Write pandas dataframe to csv file line by line

Question

I'm trying to write a pandas dataframe to a CSV file with the associated headers in tact row by row. I've accomplished this using

    new_df = pd.DataFrame(old_df).T

Which appears to produce a format (I think a dict?) where I can then write to a csv file line by line using the following

    with open('new.csv', 'a') as f:
        new_df.to_csv(f)

However in the CSV file I have two new columns both with incremental numbers (1,2,3..) for each row. The second column has the key 'Unnamed: 0' while the first column has no key (i.e. key = '').

I would prefer to not have these headers, I can delete the second on using

del new_df['Unnamed: 0']

but I can't do this for the second as it has no key (del new_df[''] does not work).

Would anyone know either how to delete the first column or a better way to write a dataframe to a csv file row by row..

To be sure, please provide some actual data. What is it you're getting. How do you want it written. Words don't help much. — cs95
– cs95, Commented Sep 7, 2017 at 7:45

jezrael · Accepted Answer · 2017-09-07 07:51:35Z

2

It seems you need parameter index=False for not write first column called index (0,1,2...) and header=False for no columns names:

df.to_csv('file', index=False, header=False)

edited Sep 7, 2017 at 7:51

answered Sep 7, 2017 at 7:46

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Write pandas dataframe to csv file line by line

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related