将包含列表和dics的JSON转换为dataframe

import pandas as pd

{
  "name": "John",
  "age": 30,
  "address": {
    "street": "123 Main St",
    "city": "New York",
    "state": "NY"
  },
  "hobbies": ["reading", "painting", "swimming"],
  "scores": {
    "math": 90,
    "science": 85,
    "english": 95
  }
}

data = {
  "name": ["John"],
  "age": [30],
  "address": [{"street": "123 Main St", "city": "New York", "state": "NY"}],
  "hobbies": [["reading", "painting", "swimming"]],
  "scores": [{"math": 90, "science": 85, "english": 95}]
}

df = pd.json_normalize(data)

   name  age address.street address.city address.state  \
0  John   30    123 Main St     New York            NY   

                      hobbies                     scores  
0  [reading, painting, swimming]  {'math': 90, 'science': 85, 'english': 95}