使用字典来记录表格中的每个数据,并以行名和列名作为键,并将最终结果保存在txt里面
import csv
# 创建空字典用于存储数据
data_dict = {}
# 打开CSV文件
with open('hmhan_report.csv', 'r') as file:
# 创建CSV reader对象
reader = csv.reader(file)
# 获取表头(列名)
header = next(reader)
print(header)
# 逐行读取并处理数据
for row in reader:
# 获取行名(索引)
row_name = row[0]
# 处理每一行数据
for i in range(1, len(row)):
# 获取列名
column_name = header[i]
# 构建字典键
key = row_name + '_' + column_name
# 获取数据值
value = row[i]
# 将数据值添加到字典
data_dict[key] = value
# 打印记录的字典数据
for key, value in data_dict.items():
with open("data.txt","a")as f:
f.write(f'"{key}": {value},\n')
print(key, value)