pandas修改表格数据（整合两张表格）

import pandas as pd

#读取表格数据
df_sheet = pd.read_excel("表1.xlsx", sheet_name="Sheet1")
df_base = pd.read_excel("表2.xlsx", sheet_name="Sheet1")

cve_col = 1

# 遍历表一数据
for row_sheet in range(0, len(df_sheet)):
    # 遍历表二数据
    for row_base in range(len(df_base)):
        # 当表一与表二的cve_col相等时
        if df_sheet.iloc[row_sheet][cve_col] == df_base.iloc[row_base][cve_col]:
            # 表1中的4、5、6列数据替换为表二的数据
            df_sheet.loc[row_sheet] = [df_sheet.loc[row_sheet][0], df_sheet.loc[row_sheet][1], df_sheet.loc[row_sheet][2],
                                       df_sheet.loc[row_sheet][3], df_base.iloc[row_base][4], df_base.iloc[row_base][5],
                                       df_base.iloc[row_base][6], df_sheet.loc[row_sheet][7]]
            break

# 将数据存档到本地文件
writer = pd.ExcelWriter("result.xlsx")
df_sheet.to_excel(writer, index=False, encoding='utf-8', sheet_name='Sheet1')
writer.save()