Python:实现excel的vlookup功能
import pandas as pdimport openpyxl
from openpyxl.styles import PatternFill
df1=pd.read_excel(r"D:\工作file\0922\5G全量工参v28-广东-20220919-02_1-修正(1).xlsx",sheet_name="清远至末")
df2=pd.read_excel(r"D:\工作file\0922\清远至末(站点信息小区信息匹配).xlsx",sheet_name="Sheet1")
df3=pd.merge(df1,df2,how="left",left_on="CGI",right_on="CGI")
# df3.to_excel(r"D:\工作file\0922\merge2.xlsx")
# print(df3)
# sheet_a=df3["Sheet1"]
# maxrow=sheet_a.max_row
# maxcolumn=sheet_a.max_column
# for i in range(1,maxrow):
# cell_a=sheet_a.cell(i,8)
# cell_b=sheet_a.cell(i,54)
# cell_c=sheet_a.cell(i,9)
# cell_d=sheet_a.cell(i,85)
# if cell_a.value!=cell_b.value:
# cell_a.fill=PatternFill("solid", fgColor="FFFF00")
# if cell_c.value!=cell_d.value:
# cell_c.fill=PatternFill("solid", fgColor="FFFF00")
# df3.save(r"D:\工作file\0922\清远至末工参与规划信息不符部分.xlsx")
页:
[1]