Writing a pandas DataFrame to CSV file

Question

I want to convert the panda's data frame to the CSV file. This is the code I am using:

df.to_csv('out.csv')

I am getting the error:

UnicodeEncodeError: 'ascii' codec can't encode character u'\u03b1' in position 20: ordinal not in range(128)

Is there a way to provide a tab space between the variables?

Answer 1

To give tab space you can use the command below:

df.to_csv(file_name, sep='\t')

To use a specific encoding (e.g. 'utf-8') use the command below:

df.to_csv(file_name, sep='\t', encoding='utf-8')

If you want to know more about the Data Science then do check out the following Data Science which will help you in understanding Data Science from scratch