removing column in pandas dataframe

Question

I have the following DataFrame:

                  Date  Year  Month  Day Security Trade  Value
0  2011-01-10 00:00:00  2011      1   10     AAPL   Buy   1500
1  2011-01-13 00:00:00  2011      1   13     AAPL  Sell   1500

When I write this to csv, an extra column is created at the start of the file:

,Date,Year,Month,Day,Security,Trade,Value
0,2011-01-10 00:00:00,2011,1,10,AAPL,Buy,1500
1,2011-01-13 00:00:00,2011,1,13,AAPL,Sell,1500

How can i resolve this?

DSM · Accepted Answer · 2013-09-25 19:33:32Z

5

The "extra column" is the index. You can suppress this by passing index=None, for example:

>>> df
    A
0  10
1  20
2  30
>>> df.to_csv("out.csv")
>>> !cat out.csv
,A
0,10
1,20
2,30
>>> df.to_csv("out.csv", index=None)
>>> !cat out.csv
A
10
20
30

answered Sep 25, 2013 at 19:33

DSM

355k67 gold badges606 silver badges504 bronze badges

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

5 Comments

trinity Over a year ago

Hi Thanks for your response, I have tried that already , and i am getting the following error.... df = pd.read_csv(input_file, index=None) TypeError: parser_f() got an unexpected keyword argument 'index'

DSM Over a year ago

df.to_csv isn't the same thing as pd.read_csv. df.to_csv writes the dataframe df to a csv file, pd.read_csv is for reading a csv file in. Which are you trying to do?

trinity Over a year ago

Sorry, my bad. The index = None, is worked. Thanks for your help

EdChum Over a year ago

@DSM the docs state that index takes a boolean so shouldn't it be False rather than None even though that does work? I've always used False because of this

trinity Over a year ago

Hi, i have one more question. New to stackoverflow. and i didnt get the hang of formatting and not able to get get the question uploaded.

Collectives™ on Stack Overflow

removing column in pandas dataframe

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related