title: Reading large excel files in Python and UnicodeDecodeError:
body: <p>I am new to Python and I'm trying to read a large excel file in python. I converted my xlsx file to csv to work with pandas. I wrote the code below:</p>
  
  <pre><code>import pandas as pd
  pd.read_csv('filepath.csv')
  df = csv.parse("Sheet")
  df.head()
  </code></pre>
  
  <p>But it gives this error:
  <code>UnicodeDecodeError: 'charmap' codec can't decode byte 0x81 in position 28: character maps to &lt;undefined&gt;</code></p>
  
  <p>Can you please tell me why it gives this error? Or do you have any advice to read large excel files? I also tried to work with <code>openpyxl</code> module, but I couldn't use <code>read_only</code> because of version of my Python.(I am using Python 2.7.8)</p>