Home >Backend Development >Python Tutorial >How to Properly Write a Pandas DataFrame to a CSV File with Unicode Characters?
How to Properly Write a Pandas DataFrame to a CSV File with Unicode Characters?
- Linda HamiltonOriginal
- 2024-11-26 08:58:11839browse
Writing a pandas DataFrame to CSV file
When attempting to write a pandas DataFrame with unicode characters to a CSV file using the to_csv method, the following error may arise:
UnicodeEncodeError: 'ascii' codec can't encode character u'u03b1' in position 20: ordinal not in range(128)
To resolve this issue, specify the encoding when calling the to_csv method using the encoding argument. For example, to use UTF-8 encoding:
df.to_csv('out.csv', encoding='utf-8')
Additionally, to write to a tab-delimited file, use the sep argument:
df.to_csv('out.csv', sep='\t')
For further customization, you can also remove the index and add a header:
df.to_csv('out.csv', sep='\t', encoding='utf-8', index=False, header=True)The above is the detailed content of How to Properly Write a Pandas DataFrame to a CSV File with Unicode Characters?. For more information, please follow other related articles on the PHP Chinese website!