Converting list of dict to rows in pandas [duplicate]

Question

I have a data frame looks as follows

df1 = df = pd.DataFrame({"a":[[{"x":0,"y":4}], None, [{"x":10,"y":5}], None], 
                     "b":[5, 6, 7, 8]})

How can create a seperate column of x and y from it ?

YOLO · Accepted Answer · 2020-08-18 13:42:50Z

2

You can do:

df[['x', 'y']] = df['a'].str[0].apply(pd.Series)

print(df)

                     a  b     x    y
0   [{'x': 0, 'y': 4}]  5   0.0  4.0
1                 None  6   NaN  NaN
2  [{'x': 10, 'y': 5}]  7  10.0  5.0
3                 None  8   NaN  NaN

answered Aug 18, 2020 at 13:42

YOLO

22k5 gold badges25 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

Converting list of dict to rows in pandas [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related