python - 如何将 json 解析为 Pandas 数据框

Question

我尝试解析以下 json 结构:

[
 {
"id": 0,
"cuisine": "greek",
"ingredients": [
  "romaine lettuce",
  "black olives",
  "feta cheese crumbles"
]
},
{
"id": 1,
"cuisine": "southern_us",
"ingredients": [
  "plain flour",
  "ground pepper",
  "milk",
  "vegetable oil"
]
}....]

此 JSON 文件中有数千个值，我想将其解析为 Pandas 数据框。考虑到 ingredients 键下有一个嵌套列表，我将如何去做。

干杯 :)

Answer 1

或者:

pd.concat(map(pd.DataFrame,json))

例子:

>>> import pandas as pd
>>> json=[
 {
"id": 0,
"cuisine": "greek",
"ingredients": [
  "romaine lettuce",
  "black olives",
  "feta cheese crumbles"
]
},
{
"id": 1,
"cuisine": "southern_us",
"ingredients": [
  "plain flour",
  "ground pepper",
  "milk",
  "vegetable oil"
]
}]
>>> pd.concat(map(pd.DataFrame,json))
       cuisine  id           ingredients
0        greek   0       romaine lettuce
1        greek   0          black olives
2        greek   0  feta cheese crumbles
0  southern_us   1           plain flour
1  southern_us   1         ground pepper
2  southern_us   1                  milk
3  southern_us   1         vegetable oil
>>>