excel转换为字典

代码如下：

import pandas as pd
import numpy as np  # 虽然在这个脚本中numpy没有被直接使用，但保留以防万一
 
# 指定Excel文件的路径
masterdata_excel_file = r'C:\Users\yuanzhilong\Desktop\龙圆芝\202411\ERP数据源_云同步用\apjr110.xlsx'
cimq004_excel_file = r'C:\Users\yuanzhilong\Desktop\龙圆芝\202411\ERP数据源_云同步用\cimq004.xlsx'
 
# 利用Pandas读取Excel文件
masterdata_df = pd.read_excel(masterdata_excel_file)
cimq004_df = pd.read_excel(cimq004_excel_file)
 
# 初始化列表来存储字典
masterdata_list_of_dicts = []
cimq004_list_of_dicts = []

# 处理masterdata_df并转换为字典列表
for index, row in masterdata_df.iterrows():
    row_dict = {}
    for col_name in masterdata_df.columns:
        row_dict[col_name] = row[col_name] if pd.notna(row[col_name]) else None
    masterdata_list_of_dicts.append(row_dict)
 
# 处理cimq004_df并转换为字典列表
for index, row in cimq004_df.iterrows():
    row_dict = {}
    for col_name in cimq004_df.columns:
        row_dict[col_name] = row[col_name] if pd.notna(row[col_name]) else None
    cimq004_list_of_dicts.append(row_dict)  # 这里修正了错误，现在添加到正确的列表中
 
# 如果需要，可以打印或进一步处理这些字典列表
print(masterdata_list_of_dicts)
print(cimq004_list_of_dicts)

需求：