How do I close a csv file created with pandas (pd.to_csv)?

Question

I first create the file (appending mode)

db.to_csv(DB, mode='a', header=False, sep='\t')

then I try to open it:

rdb=pd.read_table(DB,sep="\t",header=True,parse_dates=True)

And next, Python crashes,probably because the file is open, is not it?

I have tried: db.close() but does not work

It would help if you would post a short, complete, stand-alone program that demonstrates your error. From your description, I should think a 10-line program would suffice. See http://SSCCE.org and http://stackoverflow.com/help/mcve — Robᵩ, Mar 21 '14 at 14:58

score 2 · Answer 1 · edited May 23 '17 at 10:34

2

I'm late to answer here, but for anyone else having this problem, I found the answer here:

You can pass to_csv a file object instead of just a path, and then close it yourself, like this:

outfile = open(path+'filename.csv', 'wb')
df.to_csv(outfile)
outfile.close()

edited May 23 '17 at 10:34

Community

answered Oct 29 '16 at 19:57

rossdavidh

1 Answers1