with open('配件.txt') as f:
datas = f.readlines()
for data in datas:
data = data.strip()
PeijianList.append(data)
datas = pd.read_csv('2018年11月到2020年4月全国数据.csv')
datas['折后拆装费'] = datas['折后拆装费'].fillna(0)
datas['折后维修费'] = datas['折后维修费'].fillna(0)
xiangmu = datas['定损项目名称']
chaizhuangfei = datas['折后拆装费']
weixiufei = datas['折后维修费']
import gc
del datas
gc.collect()
datas = pd.read_excel('要替换的配件名称3.31.xlsx')
fit_name = datas['fit_name']
fit_name0 = datas['新的转换项目(人为修改)']
DIc = {}
L = []
for i in range(len(fit_name0)):
try:
DIc[qx(fit_name[i])] = fit_name0[i]
except:
pass
import multiprocessing
def do_something(x):
x = x.upper()
try:
return DIc[qx(x)]
except:
return '不合理'
if __name__ == '__main__':
# revise to parallel
items = list(xiangmu)
p = multiprocessing.Pool(3)
Dingsunxiangmu = p.map(do_something, items)
p.close()
p.join()