import pandas as pd
dir=r"C:\福州互操作-删除.csv"
dir1=r"C:\SA参数核查统计-1106.xlsx"
dir_quhao=r"C:\区号与地市对应.xlsx"
qingdan=pd.read_csv(dir,low_memory=False)
qingdan["区号"]=qingdan["SubNetwork"].str[0:3]
quhao_list=pd.read_excel(dir_quhao,dtype={"区号":str}) #将区号那列修改为字符型
xiugai=pd.merge(qingdan,quhao_list,how="left",on="区号") #需要根据区号vlookup地市
wb=xiugai.set_index('SubNetwork')
xiugai.to_csv(r"C:\SA参数核查-修改.csv",encoding="gbk")