将csv转换为字典

import csv

def csv_to_dict(file_path):
    with open(file_path, mode='r', encoding='utf-8') as csvfile:
        reader = csv.DictReader(csvfile)
        data = [row for row in reader]
    return data

# 示例使用
file_path = 'example.csv'
data_dict = csv_to_dict(file_path)
print(data_dict)

import csv

def csv_to_dict_with_missing(file_path):
    with open(file_path, mode='r', encoding='utf-8') as csvfile:
        reader = csv.DictReader(csvfile)
        data = []
        for row in reader:
            # 处理缺失值，例如用空字符串替换
            cleaned_row = {key: value if value else '' for key, value in row.items()}
            data.append(cleaned_row)
    return data

# 示例使用
file_path = 'example_with_missing.csv'
data_dict = csv_to_dict_with_missing(file_path)
print(data_dict)