将json列映射到pandas dataframe列

[
    {
        "name": "Alice",
        "age": 25,
        "address": {
            "city": "New York",
            "state": "NY"
        }
    },
    {
        "name": "Bob",
        "age": 30,
        "address": {
            "city": "San Francisco",
            "state": "CA"
        }
    }
]

import pandas as pd
import json

data = [
    {
        "name": "Alice",
        "age": 25,
        "address": {
            "city": "New York",
            "state": "NY"
        }
    },
    {
        "name": "Bob",
        "age": 30,
        "address": {
            "city": "San Francisco",
            "state": "CA"
        }
    }
]

df = pd.json_normalize(data)

   name  age address.city address.state
0  Alice   25     New York            NY
1    Bob   30     San Francisco      CA