Write pandas DataFrame to CSV File without Index in Python (Example)


In this Python tutorial you’ll learn how to export a pandas DataFrame to a CSV file without index.

Table of contents:

So now the part you have been waiting for – the exemplifying Python code!


Example Data & Libraries

First, we have to import the pandas library:

import pandas as pd                                          # Load pandas library

As a next step, we’ll also have to create some example data:

data = pd.DataFrame({'x1':range(10, 16),                     # Create pandas DataFrame
                     'x2':[3, 9, 2, 3, 7, 8],
                     'x3':['a', 'b', 'c', 'd', 'e', 'f'],
                     'x4':range(16, 10, - 1)})
print(data)                                                  # Print pandas DataFrame


table 1 DataFrame write pandas dataframe csv file without index python


Table 1 illustrates that our example pandas DataFrame consists of six rows and four columns.

Let’s print these data to a CSV file!


Example: Write pandas DataFrame as CSV File without Index

In this example, I’ll demonstrate how to save a pandas DataFrame to a CSV file without showing the index numbers of this data set in the final output.

For this task, we can apply the to_csv function as shown below.

In the first line of the following code, we have to specify the working directory and the file name. Note that you would have to replace the working directory path to your own working directory.

The second line of the following syntax is responsible for ignoring the indices. As you can see, we are setting the index argument to be equal to the logical indicator False.

data.to_csv('C:/Users/Joach/Desktop/my directory/data.csv',  # Specify path & file name
            index = False)                                   # Export to CSV without indices

After executing the previous Python code, a new CSV file called data without index values will appear in your working directory.


Video & Further Resources

I have recently published a video on my YouTube channel, which illustrates the examples of this article. You can find the video below:


The YouTube video will be added soon.


Furthermore, you could read some of the other tutorials on this website. You can find some posts below.


This article has shown how to save a pandas DataFrame to a CSV file without index numbers in Python. If you have further questions, let me know in the comments section.


Subscribe to the Statistics Globe Newsletter

Get regular updates on the latest tutorials, offers & news at Statistics Globe.
I hate spam & you may opt out anytime: Privacy Policy.

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.