Create a DataFrame from a String

Question

How can I take a string and create a data frame.

Let's say the string I have is the following.

ss = "This is a string"

If I do the following, it produced an error.

pd.DataFrame(ss)
Traceback (most recent call last):

  File "<ipython-input-84-4694a8452254>", line 1, in <module>
    pd.DataFrame(ss)

  File "/Users/abrahammathew/anaconda3/lib/python3.6/site-packages/pandas/core/frame.py", line 404, in __init__
    raise ValueError('DataFrame constructor not properly called!')

ValueError: DataFrame constructor not properly called!

However, if I try to create a series, it works.

pd.Series(ss)
Out[85]: 
0    This is a string
dtype: object

pd.Series(ss).to_frame()

user3483203
– user3483203

2018-06-04 22:50:53 +00:00
Commented Jun 4, 2018 at 22:50 — user3483203
– user3483203, Commented Jun 4, 2018 at 22:50
or pd.DataFrame([ss])

jedwards
– jedwards

2018-06-04 22:51:54 +00:00
Commented Jun 4, 2018 at 22:51 — jedwards
– jedwards, Commented Jun 4, 2018 at 22:51
What is your expected output?

cs95
– cs95

2018-06-04 22:53:11 +00:00
Commented Jun 4, 2018 at 22:53 — cs95
– cs95, Commented Jun 4, 2018 at 22:53

Amine Kaddioui · Accepted Answer · 2018-06-04 22:53:34Z

2

Try the below:

from pandas.compat import StringIO
df_string= pd.read_csv(StringIO(ss), sep=';')

Or:

df_string=pd.DataFrame(pd.Series(ss))

answered Jun 4, 2018 at 22:53

Amine Kaddioui

13812 bronze badges

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

Comments

grovina · Accepted Answer · 2018-06-04 22:53:35Z

1

You can see a DataFrame as a 2D thing (while a Series would be 1D). In order to have a proper DataFrame, pandas needs index or columns or some dimension. Try the following:

>>> pd.DataFrame(["Hello"])
       0
0  Hello

I wonder why you'd need this.

answered Jun 4, 2018 at 22:53

grovina

3,07721 silver badges25 bronze badges

Collectives™ on Stack Overflow

Create a DataFrame from a String

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related