更正格式错误的CSV并将更正后的数据拉回到数据帧中

import pandas as pd
import csv

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

with open('data.csv', 'r') as file:
    csv_data = csv.reader(file)
    headers = next(csv_data)  # 获取表头
    fixed_data = []  # 存储修复后的数据

    for row in csv_data:
        # 检测并修复格式错误
        if len(row) != len(headers):
            row.extend([''] * (len(headers) - len(row)))  # 补充缺失的字段
        fixed_data.append(row)

with open('fixed_data.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerow(headers)  # 写入表头
    writer.writerows(fixed_data)  # 写入修复后的数据

df_fixed = pd.read_csv('fixed_data.csv')