print_hi('PyCharm')
df1 = pd.read_excel("填报人信息.xlsx", sheet_name="子公司", skiprows=0, index_col=0)
dict1 = df1.to_dict('dict').get("填报人单位")
print(dict1)
df2 = pd.read_excel("填报人信息.xlsx", sheet_name="分公司", skiprows=0, index_col=0, usecols=[0, 1])
dict2 = df2.to_dict('dict').get("填报人单位")
print(dict2)
https://www.jb51.net/article/156411.htm
# 破坏格式 # data = pd.read_excel("wyy_联通公司调研问题汇总.xlsx", sheet_name="原始标注备份", header=1, nrows=54, usecols=[5, 6]) # data = pd.read_excel("wyy_联通公司调研问题汇总.xlsx", keep_default_na=True, sheet_name="原始标注备份", header=1) # print(data) # for k in dict1.keys(): # data['填报人单位'][data['填报人'] == k] = dict1[k] # for k in dict2.keys(): # data['填报人单位'][data['填报人'] == k] = dict2[k] # print(data) # DataFrame(data).to_excel('wyy_联通公司调研问题汇总.xlsx', sheet_name='原始标注备份', index=False, header=True) # 只有结果,然后拷贝 data = pd.read_excel("wyy_联通公司调研问题汇总.xlsx", sheet_name="原始标注备份", header=1, nrows=54, usecols=[5, 6]) for k in dict1.keys(): data['填报人单位'][data['填报人'] == k] = dict1[k] for k in dict2.keys(): data['填报人单位'][data['填报人'] == k] = dict2[k] DataFrame(data).to_excel('result.xlsx', sheet_name='Sheet1', index=False, header=True)