title: Why can't Pandas Remove Unknown Characters from Row Data?
body: <p>Hi everyone so i was scraping a footwear website and  have got all the links and images with their respective names and Brands.</p>
  <p>I have saved them in an Excel file and i have also removed the unknown characters with the help of excel, but when i load it into pandas with jupyter Notebooks, The download stops at Number 83 as their is a \ in the name.</p>
  <p>I tried using str.replace method but it gives me an EOL parsing Error</p>
  <p>Here is my code and Also the respective Excel File For reference :)</p>
  <pre><code>import pandas as pd
  import requests
  
  Final1 = pd.read_excel(&quot;VNV.xlsx&quot;)
  Final1.index+=1
  
  a = Final1.index.tolist()
  
  Brand = Final1[&quot;Brand&quot;].tolist()
  
  Title = Final1[&quot;Title&quot;].str.split().str.join(&quot; &quot;).tolist()
  
  Images = Final1[&quot;Images&quot;].tolist()
  
  s = requests.Session()
  
  for i,b,n,l in zip(a,Brand,Title,Images):
      r = s.get(l).content
      with open(&quot;Images//&quot; + f&quot;{i}-{b}-{n}.jpg&quot;,&quot;wb&quot;) as f:
                f.write(r)
  
  ---------------------------------------------------------------------------
  OSError                                   Traceback (most recent call last)
  &lt;ipython-input-3-13d7c7daa564&gt; in &lt;module&gt;
        3 for i,b,n,l in zip(a,Brand,Title,Images):
        4     r = s.get(l).content
  ----&gt; 5     with open(&quot;Images//&quot; + f&quot;{i}-{b}-{n}.jpg&quot;,&quot;wb&quot;) as f:
        6               f.write(r)
  
  OSError: [Errno 22] Invalid argument: 'Images//83-ASICS-GEL-LYTE III OG &quot;30TH ANNIVERSARY&quot; \'WHITEFLASH CORAL\'.jpg'
  </code></pre>
  <p>EXCEL FILE ( Google Drive Link) :</p>
  <p><a href="https://drive.google.com/file/d/1iP07CFX7R6_o3M_W8CPN-sNPN2gFKKfu/view?usp=sharing" rel="nofollow noreferrer">Excel File</a></p>