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)):
if df_sheet.iloc[row_sheet][cve_col] == df_base.iloc[row_base][cve_col]:
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()