How to convert list of dictionaries to dataframe using pandas in python [duplicate]

Question

I have a list of dictionaries: data = [{'name': 'peter', 'id': 92, 'value': 6500},{'name': 'peter', 'id': 93, 'value': 6000},[{'name': 'jack', 'id': 93, 'value': 9500}]

and I want it to be converted to a dataframe:

peter    id   jack 
6500     92  0/NaN
6000     93   9500

How to do that in python.

I have tried this but it is not working

df1 = pd.DataFrame(data,  columns =['name', 'value']) 
print (df1)

Allen Qin · Accepted Answer · 2020-04-09 08:24:59Z

1

What about just doing this?

pd.DataFrame(data)

It gives you:

    name    id  value
0   peter   92  6500
1   jack    93  6000

answered Apr 9, 2020 at 8:24

Allen Qin

20k9 gold badges55 silver badges68 bronze badges

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

Collectives™ on Stack Overflow

How to convert list of dictionaries to dataframe using pandas in python [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related