Remove index column from DataFrame Pandas

Question

I have searched a lot about this topic of how to remove the index column of the datframe when exporting the dataframe to csv file. I found many solutions and tricks but none of them worked with me. In the csv output I got 0 (the column index) at the first row of the CSV output. Can you guide me of fixing such a problem?!!

are you using df.reset_index(inplace=True) before doing df.to_csv(index=False)? — A l w a y s S u n n y
– A l w a y s S u n n y, Commented Nov 5, 2020 at 16:32

Prakriti Shaurya · Accepted Answer · 2020-11-05 16:55:32Z

1

   df.to_csv('output.csv', index=False, header=False)

answered Nov 5, 2020 at 16:55

Prakriti Shaurya

1951 gold badge3 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Flavio Moraes · Accepted Answer · 2020-11-05 17:19:12Z

1

Are you using pandas? If so, you can use the .to_csv method with the argument index=False to remove index:

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

or header=False to remove column names:

df.to_csv('output.csv', header=False)

edited Nov 5, 2020 at 17:19

answered Nov 5, 2020 at 16:27

Flavio Moraes

1,3511 gold badge7 silver badges17 bronze badges

5 Comments

YasserKhalil Over a year ago

Thanks a lot. This was my first try and this removes the row's index not the column index.

YasserKhalil Over a year ago

Thanks a lot for your support.

alper Over a year ago

Does this print the results into terminal?

Flavio Moraes Over a year ago

@alper it doesn't. It only creates a csv file. If you want to print something you have to say it to print whatever you want to print.

alper Over a year ago

Can I redirect it to the terminal in paralel ? or should I do cat output.csv' inside the python script?

Collectives™ on Stack Overflow

Remove index column from DataFrame Pandas

2 Answers 2

Comments

5 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Related