如图,替换不了:
- # encoding=utf-8
- import pandas as pd
- df=pd.read_excel('tihuan.xls',sheet_name='rule')
- df1=pd.read_excel('tihuan.xls',sheet_name='test')
- rule = df.set_index("old").to_dict()['new']
- data1=df1.loc[:,['test']]
- print(rule)
- print(data1)
- for key,value in rule.items():
- for i in range(0,len(data1)):
- data1.iloc[i] = data1.iloc[i].replace(key,value)
- print(data1)