Python gives UnicodeEncodeError reading xlsx

Question

When running this Python code:

import pandas as pd
from pandas import ExcelWriter
from pandas import ExcelFile
import unicodedata
import codecs

DataFile=pd.read_excel('indata.xlsx')#,dtype={'text': unicode})

for Rownumber in range (0,7):# 2? til 23761?
 print('rownumber: ', Rownumber)
 ColumnF=str((DataFile.iloc[Rownumber,5]))
 print('ColumnF: ', ColumnF)        
print('EOF')

I get the following error:

('rownumber: ', 0)
Traceback (most recent call last):
  File "example.py", line 13, in <module>
    ColumnF=str((DataFile.iloc[Rownumber,5]))
UnicodeEncodeError: 'ascii' codec can't encode character u'\xe6' in position 11: ordinal not in range(128)

any idea how to make Python read xlsx containing non-ascii utf8 caharacters in xlsx?

this helps https://stackoverflow.com/questions/10406135/unicodedecodeerror-ascii-codec-cant-decode-byte-0xd1-in-position-2-ordinal/40346898#40346898 — khelili miliana, Feb 05 '18 at 13:42
Thanks, I tried that too, still getting the same error message. — Uffe A. Fredens, Feb 05 '18 at 14:18

score 0 · Answer 1 · answered Feb 05 '18 at 13:41

0

Try opening the excel with an encoding:

EX:

DataFile=pd.read_excel('indata.xlsx', encoding = 'utf8')

answered Feb 05 '18 at 13:41

Rakesh

81,458
17
76
113

Thanks, I tried that, but I got the same error as above. – Uffe A. Fredens Feb 05 '18 at 13:59

Python gives UnicodeEncodeError reading xlsx

1 Answers1