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

"""
Created on Fri Apr  8 10:28:04 2022

@author: koer
"""
import pandas as pd
import numpy as np
from openpyxl import load_workbook

df = pd.read_excel(r'matplotlib.xlsx', sheet_name='Sheet2', header=None, names = ['省份','城市', '经度', '纬度'])
df_li = df.values.tolist()
df1 = pd.read_excel(r'matplotlib.xlsx', sheet_name='Sheet4', header=None,)
df1_li = df1.values.tolist()
result = []
result1 = []
result2= []
result3= []
for s_li in df_li:
 result.append( s_li[1]+' '+str(s_li[2])+' '+str(s_li[3]))
for s1_li in df1_li:
 result1.append( s1_li[0]) 

print(len(result))
print(len(result1))
log='j'
tx=''
for count1 in range(0,len(result1)):
     tx=result1[count1]
     for count in range(0,len(result)):
         if result1[count1] in result[count] :
            result2.append( result[count])
            
            log='z'
            break
     if log=='z':
      log='j'
     else:
      result3.append(tx)
print(result3)
#数组保存到电子表格
# transform a to pandas DataFrame
a=result2
#利用pandas保存数组到电子表格
dataframe = pd.DataFrame(a)
dataframe.to_excel('list.xlsx')