title: Read csv with foreign language using pandas
body: <p>I am reading a csv  which has the following format
  ID,Name,Description</p>
  
  <p>Now some of my description contain foriegn langage characters like
  <img src="https://i.stack.imgur.com/Iqemx.png" alt="enter image description here">,<img src="https://i.stack.imgur.com/K3bF3.png" alt="enter image description here"></p>
  
  <p>I would like to read this file into dataframe if possible. When I am using read_csv etcI am getting encoding errors. I tried</p>
  
  <pre><code>csv = pd.read_csv('foo.csv',encoding='utf-8')
  </code></pre>
  
  <p>but it throws encoding error </p>
  
  <pre><code>'charmap' codec can't decode byte 0x9d
  </code></pre>
  
  <p>Is there any way to read the file keeping character set and keep analysing.
  If not what would be the way to get such file into a dataframe or array like structure?</p>
  
  <p>If keeping characters is not possible, then can such lines/words be ignored and read rest of the data? Help appreciated.</p>