Convert a string into a dataframe in Python

Question

I have a string which looks like this.

x = 24.55 26.22, 69.22 78.25, 66.25 45.98

I want to convert into a dataframe which looks like this:

  A       B      A     B      A      B
24.55   26.22  69.22  78.25  66.25  45.98

This is what I have tried, but I am getting an error.

import io
import pandas as pd
df1 = pd.read_csv(io.StringIO(x), sep=",")
df1 =  df1.groupby(level=[0,1]).cumcount().map({0 : 'x', 1 : 'y'})

What error do you get? What is the exact error message? Can you add it to your question? (But ******** without ******** "Edit:", "Update:", or similar - the question should appear as if it was written today) — Peter Mortensen
– Peter Mortensen, Commented Oct 21, 2022 at 14:35

mozway · Accepted Answer · 2022-08-12 14:54:15Z

2

You could use a double split, stack and reshape to DataFrame:

x = '24.55 26.22, 69.22 78.25, 66.25 45.98'

out = (pd
       .DataFrame([map(float, s.split()) for s in x.split(',')],
                  columns=['A', 'B'])
       .stack().droplevel(0)
       .to_frame().T
      )

output:

       A      B      A      B      A      B
0  24.55  26.22  69.22  78.25  66.25  45.98

If you already know the number of items:

pd.DataFrame([[float(e) for s in x.split(',') for e in s.split()]],
             columns=['A', 'B']*3)

answered Aug 12, 2022 at 14:54

mozway

267k13 gold badges56 silver badges106 bronze badges

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

Collectives™ on Stack Overflow

Convert a string into a dataframe in Python

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