CODEWITHSUNDEEP
pythonpandasencodingspecial-characters
Rajesh Mhatre
Rajesh Mhatre

Reputation: 147

pandas read_excel converting special charactor

I am reading data from excel and writing it to CSV file.

osht = pd.read_excel(ip_path,header=None,sheet_name=j,encoding='utf-8-sig')
osht.to_csv(file_name,sep=',',index=False,encoding='utf-8-sig')

Excel file has some lines which has special characters like :

'SOCIÉTÉ' , 'HERMÈS'

Pandas changes such words to :

'SOCIéTé' , 'HERMÊS'

I tried changing encoding method to 'utf-8', 'utf_16_le' but issue still persisted.

Please suggest whats needs to be done in such case.

Upvotes: 0

Views: 1245

Answers (1)

Azmi Kamis
Azmi Kamis

Reputation: 26

'SOCIéTé' , 'HERMÊS'

This suggests the resulting file is not UTF-8 encoded.

Upvotes: 1

Related Questions