Creating Python nested dictionary lists into data frames Question

For example, the following nested dictionary lists are listed:

a = [ {'info' : {'name' : 'hahaha', 'status' : 'True'} , 'price' : 500} ]

I'd like to change it to the following data frame.

      'name'     'status'      'price'
 0    hahaha       True          500

How do I make the code?

df = pd.DataFrame(data=a, columns=['?', '?', 'price'])

Is there a way to specify the key value of the nested dictionary immediately when specifying columns

python dataframe dictionary list pandas

2022-09-20 11:27

1 Answers

>>> a
[{'info': {'name': 'hahaha', 'status': 'True'}, 'price': 500}]

>>> a_ = [ { **d["info"], "price":d["price"] } for d in a ]
>>> a_
[{'name': 'hahaha', 'status': 'True', 'price': 500}]

>>> df = pd.DataFrame(a_)
>>> df
     name status  price
0  hahaha   True    500

2022-09-20 11:27

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656