如何在Python中将字典列表写入csv并从CSV缓冲区创建pandas数据帧？

import csv
import pandas as pd

# 定义字典列表
data = [
    {'Name': 'Alice', 'Age': 25, 'City': 'New York'},
    {'Name': 'Bob', 'Age': 30, 'City': 'London'},
    {'Name': 'Charlie', 'Age': 35, 'City': 'Paris'}
]

# 将字典列表写入CSV文件
csv_file = 'data.csv'
csv_columns = ['Name', 'Age', 'City']

with open(csv_file, 'w', newline='') as file:
    writer = csv.DictWriter(file, fieldnames=csv_columns)
    writer.writeheader()
    writer.writerows(data)

# 从CSV缓冲区创建数据帧
with open(csv_file, 'r') as file:
    df = pd.read_csv(file)

# 打印数据帧
print(df)