使用python读取excel

import pandas

path = r"2020SCI影响因子数据库_2021.6.30.xls"

data = pandas.read_excel(path)

all_data = []
for i in range(0, len(data)):
    simgle_data = '"{}":"{}",'.format(data.iloc[i]['Full Journal Title'], data.iloc[i]['Journal Impact Factor'])
    all_data.append(simgle_data)

# all_data = set(all_data)
txt = open("a.txt", "w")
for i in all_data:
    txt.write(i)
    txt.write("\n")