读取excel 并修改

import xlrd
wb = xlrd.open_workbook(filename='查院士.xlsx')
table = wb.sheets()[0]
row = table.nrows
data_list = []
for i in range(1,row):
    col = table.row_values(i)
    data_list.append(col[0])
print(data_list)

# 两院院士
wb1 = xlrd.open_workbook(filename='两院院士学科分类结果汇总表2021-2-2（修改)(1).xlsx')
table1 = wb1.sheets()[0]
row1 = table1.nrows
yuanshi_list = []
for i in range(1,row1):
    col1 = table1.row_values(i)
    yuanshi_list.append(col1[0])


#
# print(yuanshi_list)
import pandas as pd
book = pd.read_excel('查院士 - 副本.xlsx',engine='openpyxl') # 读取excel
for idx, row in book.iterrows():
    book.loc[idx, "姓名"]
    for i in data_list:
        if i == book.loc[idx,"姓名"]:
            book.loc[idx, '院士是否'] = 1
            break
book.to_excel('5.xlsx', sheet_name='Sheet1', index=False, header=True)