How to write Pandas DataFrame to CSV File

Pandas is a great tool for working with CSV files. I’ll show you how to write a Pandas DataFrame to a.csv file in Python in this post.

To write a Pandas DataFrame to a .csv file, you need to use the to_csv() method.

Writing a DataFrame to a .csv file

Below is an example on how to write Pandas Dataframe to CSV file.

Copied!import pandas as pd
df = pd.DataFrame({'col1': [1, 2, 3, 4, 5], 'col2': [6, 7, 8, 9, 10]})
print(df)
# Output
# col1  col2
# 0     1     6
# 1     2     7
# 2     3     8
# 3     4     9
# 4     5    10
df.to_csv('example.csv', index=False)
import pandas as pd
df = pd.DataFrame({'col1': [1, 2, 3, 4, 5], 'col2': [6, 7, 8, 9, 10]})
print(df)
# Output
# col1  col2
# 0     1     6
# 1     2     7
# 2     3     8
# 3     4     9
# 4     5    10
df.to_csv('example.csv', index=False)

The index column will not be written to the.csv file if index=False is used. True is the default value. The following will be written to the file example.csv by the code above:

Copied!col1,col2
1,6
2,7
3,8
4,9
5,10
col1,col2
1,6
2,7
3,8
4,9
5,10

Change the delimiter

If you want to change the delimiter, you can use the sep parameter.

Copied!df.to_csv('example.csv', index=False, sep=';')
df.to_csv('example.csv', index=False, sep=';')

The above code will output the following to the file example.csv:

Copied!col1;col2
1;6
2;7
3;8
4;9
5;10
col1;col2
1;6
2;7
3;8
4;9
5;10

Change the datetime format

If your data has a datetime format, you can use the date_format parameter.

Let check an example.

Copied!import pandas as pd
from datetime import datetime

df = pd.DataFrame({
    'Datetime': [datetime(2021, 10, 26),
                 datetime(2021, 10, 27)],
    'Todo': ['Write Python Tutorial', 'Read Javascript documentaion']
})

df.to_csv('example.csv', index=False)
import pandas as pd
from datetime import datetime

df = pd.DataFrame({
    'Datetime': [datetime(2021, 10, 26),
                 datetime(2021, 10, 27)],
    'Todo': ['Write Python Tutorial', 'Read Javascript documentaion']
})

df.to_csv('example.csv', index=False)

The above code will output the following to the file example.csv:

Copied!Datetime,Todo
2021-10-26,Write Python Tutorial
2021-10-27,Read Javascript documentaion
Datetime,Todo
2021-10-26,Write Python Tutorial
2021-10-27,Read Javascript documentaion

Let change the datetime format to %B %d %y.

Copied!df.to_csv('example.csv', index=False, date_format='%B %d %y')
df.to_csv('example.csv', index=False, date_format='%B %d %y')

The new output will be:

Copied!Datetime,Todo
October 26 21,Write Python Tutorial
October 27 21,Read Javascript documentaion
Datetime,Todo
October 26 21,Write Python Tutorial
October 27 21,Read Javascript documentaion

Further reading: Read more about Pandas’s DataFrame.to_csv() method in the Pandas documentation.