Last Updated : 11 Jul, 2025
In this article, we will learn how we can export a Pandas DataFrame to a CSV file by using the Pandas to_csv() method. By default, the to csv() method exports DataFrame to a CSV file with row index as the first column and comma as the delimiter.
Here, we are taking sample data to convert DataFrame to CSV.
Python
# importing pandas as pd
import pandas as pd
# list of name, degree, score
nme = ["aparna", "pankaj", "sudhir", "Geeku"]
deg = ["MBA", "BCA", "M.Tech", "MBA"]
scr = [90, 40, 80, 98]
# dictionary of lists
dict = {'name': nme, 'degree': deg, 'score': scr}
df = pd.DataFrame(dict)
Export CSV to a Working Directory
Here, we simply export a Dataframe to a CSV file using df.to_csv().
Python
# saving the dataframe
df.to_csv('file1.csv')
Output:
Saving CSV Without Headers and IndexHere, we are saving the file with no header and no index number.
Python
# saving the dataframe
df.to_csv('file2.csv', header=False, index=False)
Output:
Save the CSV file to a Specified LocationWe can also, save our file at some specific location.
Python
# saving the dataframe
df.to_csv(r'C:\Users\Admin\Desktop\file3.csv')
Output:
Write a DataFrame to CSV file using Tab SeparatorWe can also save our file with some specific separate as we want. i.e, "\t" .
Python
import pandas as pd
import numpy as np
users = {'Name': ['Amit', 'Cody', 'Drew'],
'Age': [20,21,25]}
#create DataFrame
df = pd.DataFrame(users, columns=['Name','Age'])
print("Original DataFrame:")
print(df)
print('Data from Users.csv:')
df.to_csv('Users.csv', sep='\t', index=False,header=True)
new_df = pd.read_csv('Users.csv')
print(new_df)
Output:
Original DataFrame:
Name Age
0 Amit 20
1 Cody 21
2 Drew 25
Data from Users.csv:
Name\tAge
0 Amit\t20
1 Cody\t21
2 Drew\t25
Saving a Pandas Dataframe as a CSV
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4