如何在Python中将JSON行数据拆分成多列

{"name": "Alice", "age": 30, "city": "New York"}
{"name": "Bob", "age": 25, "city": "Los Angeles"}
{"name": "Charlie", "age": 35, "city": "Chicago"}

import pandas as pd

# 读取JSON行数据文件
with open('data.jsonl', 'r') as file:
    data = [json.loads(line) for line in file]

# 将数据转换为DataFrame
df = pd.DataFrame(data)

# 查看结果
print(df)

      name  age         city
0    Alice   30     New York
1      Bob   25  Los Angeles
2  Charlie   35      Chicago

df = pd.read_json('data.jsonl', lines=True)

import json

data = []
with open('data.jsonl', 'r') as file:
    for line in file:
        try:
            data.append(json.loads(line))
        except json.JSONDecodeError:
            print(f"Error parsing line: {line}")

df = pd.DataFrame(data)