Convert Pandas dataframe to csv string

Question

Here is an example of what I am trying to get:

I have:

import pandas as pd 
df = pd.DataFrame({'A' : [0, 1], 'B' : [1, 6]})

My goal is:

',A,B\n0,0,1\n1,1,6\n'

I can achieve this with lazy and horrible:

df.to_csv('temp.csv') # create unnecessary file
body = open('temp.csv').read()

Also to_string() methods looks very promising; however, the best I can come up with is this:

body = df.to_string()[1:].replace('  ', ',') + '\n'

This does not create an unnecessary file, but seems sloppy and perhaps not very reliable.

Am I missing a simpler solution?

elyase · Accepted Answer · 2015-01-04 17:20:00Z

200

The simplest way is just to not input any filename, in this case a string is returned:

>>> df = pd.DataFrame({'A' : [0, 1], 'B' : [1, 6]})
>>> df.to_csv()
',A,B\n0,0,1\n1,1,6\n'

answered Jan 4, 2015 at 17:20

elyase

41.2k12 gold badges121 silver badges123 bronze badges

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

1 Comment

The Unfun Cat Over a year ago

If you are using a series, you need to wrap it in a dataframe constructor: pandas.DataFrame(series).to_csv().

Sayan Sil · Accepted Answer · 2019-08-15 22:51:05Z

54

In [10]: df = pd.DataFrame({'A' : [0, 1], 'B' : [1, 6]})

In [11]: import io

In [12]: s = io.StringIO()

In [13]: df.to_csv(s)

In [14]: s.getvalue()
Out[14]: ',A,B\n0,0,1\n1,1,6\n'

edited Aug 15, 2019 at 22:51

Sayan Sil

6,1153 gold badges20 silver badges32 bronze badges

answered Apr 22, 2014 at 22:53

Jeff

130k21 gold badges223 silver badges189 bronze badges

1 Comment

John Smith Over a year ago

-1 as it is an overkill (maybe it was from a previous version of pandas). But in latest if no path_or_buf is provided the result is returned as a string. See answer below.

Collectives™ on Stack Overflow

Convert Pandas dataframe to csv string

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related