how to create multiple rows and columns from a dictionary value in pandas

Question

I have a data frame like following

id,  values
1, {'foo':2 , 'bar':2}
2, {'baz':20}
and so on

I want to transform this dataframe into

id val1 val2
1  foo    2
1 bar     2
2 baz     20

and so on.. I dont want to like iterate each row in dataframe.. as I am pretty sure there is a way in pandas to do the above?

BENY · Accepted Answer · 2017-11-29 22:26:52Z

2

IIUC PS: you can add rename at the end

df.set_index('id')['values'].apply(pd.Series).stack().reset_index()
Out[920]: 
   id level_1     0
0   1     bar   2.0
1   1     foo   2.0
2   2     baz  20.0

answered Nov 29, 2017 at 22:26

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Collectives™ on Stack Overflow

how to create multiple rows and columns from a dictionary value in pandas

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related