将json转换为panda dataframe的更有效的方法

import pandas as pd
import json

# 假设json_data是包含JSON数据的变量
json_data = '''
{
  "employees": [
    {
      "id": 1,
      "name": "John",
      "department": "HR"
    },
    {
      "id": 2,
      "name": "Jane",
      "department": "IT"
    },
    {
      "id": 3,
      "name": "Mike",
      "department": "Finance"
    }
  ]
}
'''

# 将JSON数据转换为Python对象
data = json.loads(json_data)

# 使用json_normalize()函数将数据转换为DataFrame
df = pd.json_normalize(data, 'employees')

# 打印DataFrame
print(df)

   id  name department
0   1  John         HR
1   2  Jane         IT
2   3  Mike    Finance