How to export Pandas DataFrame to a CSV file?

Let us see how to export a Pandas DataFrame to a CSV file. We will be using the to_csv() function to save a DataFrame as a CSV file.

DataFrame.to_csv()

Syntax : to_csv(parameters)
Parameters :

  • path_or_buf : File path or object, if None is provided the result is returned as a string.
  • sep : String of length 1. Field delimiter for the output file.
  • na_rep : Missing data representation.
  • float_format : Format string for floating point numbers.
  • columns : Columns to write.
  • header : If a list of strings is given it is assumed to be aliases for the column names.
  • index : Write row names (index).
  • index_label : Column label for index column(s) if desired. If None is given, and header and index are True, then the index names are used.
  • mode : Python write mode, default ‘w’.
  • encoding : A string representing the encoding to use in the output file.
  • compression : Compression mode among the following possible values: {‘infer’, ‘gzip’, ‘bz2’, ‘zip’, ‘xz’, None}.
  • quoting : Defaults to csv.QUOTE_MINIMAL.
  • quotechar : String of length 1. Character used to quote fields.
  • line_terminator : The newline character or character sequence to use in the output file.
  • chunksize : Rows to write at a time.
  • date_format : Format string for datetime objects.
  • doublequote : Control quoting of quotechar inside a field.
  • escapechar : String of length 1. Character used to escape sep and quotechar when appropriate.
  • decimal : Character recognized as decimal separator. E.g. use ‘,’ for European data.

Returns : None or str

Example 1 :

filter_none

edit
close

play_arrow

link
brightness_4
code

# importing the module
import pandas as pd
  
# creating the DataFrame
my_df = {'Name': ['Rutuja', 'Anuja'], 
         'ID': [1, 2], 
         'Age': [20, 19]}
df = pd.DataFrame(my_df)
  
# displaying the DataFrame
print('DataFrame:\n', df)
   
# saving the DataFrame as a CSV file
gfg_csv_data = df.to_csv('GfG.csv', index = True)
print('\nCSV String:\n', gfg_csv_data)

chevron_right


Output :
Before executing the code:



After executing the code:

We can clearly see the .csv file created.

Also, the output of the above code includes the index, as follows.

Example 2 : Converting to a CSV file without the index. If we wish not to include the index, then in the index parameter assign the value False.

filter_none

edit
close

play_arrow

link
brightness_4
code

# importing the module
import pandas as pd
  
# creating the DataFrame
my_df = {'Name': ['Rutuja', 'Anuja'], 
         'ID': [1, 2], 
         'Age': [20, 19]}
df = pd.DataFrame(my_df)
  
# displaying the DataFrame
print('DataFrame:\n', df)
   
# saving the DataFrame as a CSV file
gfg_csv_data = df.to_csv('GfG.csv', index = False)
print('\nCSV String:\n', gfg_csv_data)

chevron_right


Output:

Example 3 : Converting to a CSV file without the header of the rows. If we wish not to include the header, then in the headerparameter assign the value False.

filter_none

edit
close

play_arrow

link
brightness_4
code

# importing the module
import pandas as pd
  
# creating the DataFrame
my_df = {'Name': ['Rutuja', 'Anuja'], 
         'ID': [1, 2], 
         'Age': [20, 19]}
df = pd.DataFrame(my_df)
  
# displaying the DataFrame
print('DataFrame:\n', df)
   
# saving the DataFrame as a CSV file
gfg_csv_data = df.to_csv('GfG.csv', header = False)
print('\nCSV String:\n', gfg_csv_data)

chevron_right


Output:

Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course.




My Personal Notes arrow_drop_up

Enthusiast Technical Content Writer

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :

Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.