Pandas导出和导入不同的字典

import pandas as pd

data = {'Name': ['Alice', 'Bob', 'Charlie'],
        'Age': [25, 30, 35],
        'City': ['New York', 'London', 'Paris']}

df = pd.DataFrame(data)
df.to_csv('data.csv', index=False)

import pandas as pd

data = {'Name': ['Alice', 'Bob', 'Charlie'],
        'Age': [25, 30, 35],
        'City': [{'Name': 'New York', 'Country': 'USA'},
                 {'Name': 'London', 'Country': 'UK'},
                 {'Name': 'Paris', 'Country': 'France'}]}

df = pd.json_normalize(data, 'City', ['Name', 'Age'])
df.to_json('data.json', orient='records')

import pandas as pd

df = pd.read_csv('data.csv')
data = df.to_dict()

import pandas as pd

df = pd.read_json('data.json', orient='records')
data = df.to_dict(orient='records')