0

When I try to load my excel file with:

pd.read_excel(filename)

It does not make a a Dataframe unless I delete the column with the french (i.e Vérité, café). I tried switching the encoding='utf-8' but it didn't work.

Please help.

AddWeb Solution Pvt Ltd
  • 21,025
  • 5
  • 26
  • 57
Andy Do
  • 99
  • 1
  • 2
  • 14
  • 1
    I very much doubt the Excel file is actually saved as `utf-8`. Check the encoding of the file, or open it in Excel and save it with the correct encoding. – Burhan Khalid Aug 12 '15 at 05:54
  • What do you mean with *'it does not make a dataframe'*? Do you get an error message? If so, please show that. – joris Aug 12 '15 at 08:58
  • You probably want to find out how to save csv data from excel in a certain encoding, check this other stackoverflow answer for help: http://stackoverflow.com/a/4221256/3730397 – firelynx Aug 12 '15 at 09:05
  • @joris the error is [Decode error - output not utf-8][Finished] – Andy Do Aug 13 '15 at 00:26
  • firelynx, i'll check it out thanks. – Andy Do Aug 13 '15 at 00:26
  • @AndyDo I meant the original call without specifying the encoding. – joris Aug 13 '15 at 08:03

0 Answers0