upartner的博客

原创 xlsx读取并循环对比并保存结果

"""Created on Fri Apr 8 10:28:04 2022@author: koer"""import pandas as pdimport numpy as npfrom openpyxl import load_workbookdf = pd.read_excel(r'matplotlib.xlsx', sheet_name='Sheet2', header=None, names = ['省份','城市', '经度', '纬度'])df_li = df.value.