pandas and csv how to create csv as a string without saving

Question

I know how to save a DF as a csv file. I want the csv as a string and I dont want to have to save, then load.

df.to_csv('test.csv',index=True)
my_csv = open('test.csv').read()
print type(my_csv)
<type 'str'>

Rather I would rater do the below:

my_csv = df.to_csv()

roman · Accepted Answer · 2013-12-12 14:31:42Z

8

Try StringIO module:

>>> df = pd.DataFrame({'a':range(3), 'b':list('abc')})
>>> s = StringIO()
>>> df.to_csv(s)
>>> my_csv = s.getvalue()
>>> my_csv
',a,b\n0,0,a\n1,1,b\n2,2,c\n'

answered Dec 12, 2013 at 14:31

roman

118k30 gold badges205 silver badges209 bronze badges

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

Collectives™ on Stack Overflow

pandas and csv how to create csv as a string without saving

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