Pandas dataframe .to_csv

Question

I'm trying to use pandas.DataFrame.to_csv to export a DataFrame to a .csv file, however after running the following code there's no output:

collist = sve2_all.columns
path_d = 'C:\\Users\\Desktop\\From EPD'
sve2_all.to_csv('sve2_all', path = path_d, columns = collist)

Docs

What if you leave out the columns=collist argument? (not necessary as you are writing all columns). Furthermore, the path kwarg is not in the docs you linked to. — joris
– joris, Commented Apr 11, 2014 at 10:03
What happens when you do the following: sve2_all.to_csv(path_d + '\\sve2_all.csv') — EdChum
– EdChum, Commented Apr 11, 2014 at 10:05

Cai · Accepted Answer · 2017-10-02 15:36:25Z

4

I think what you are doing won't work as the path is not being used to set the destination path and resulting csv

This should work:

import os
path_d = 'C:\\Users\\Desktop\\From EPD'
sve2_all.to_csv(os.path.join(path_d, 'sve2_all.csv'))

Also, you are passing a string as the first parameter to to_csv which is probably confusing it also as it should be a fully qualified path or buffer for path_or_buf parameter.

edited Oct 2, 2017 at 15:36

Cai

2,1882 gold badges17 silver badges26 bronze badges

answered Apr 11, 2014 at 10:11

EdChum

397k204 gold badges836 silver badges583 bronze badges

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

2 Comments

joris Over a year ago

Indeed, path is not a kwarg of to_csv (but it apparantly does not give an error on this, but is just ignored)

EdChum Over a year ago

@joris yes that is worrying, it would be nice that this raised an error but not sure how given python's flexibility

Collectives™ on Stack Overflow

Pandas dataframe .to_csv

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related