程序目的:
使用Python将第一列(id)中超过五位数的数字,前两位变为对应的ASCII码,后四位保留原数字,存为新的一列(id_c)
# -*- coding: utf-8 -*-
import pandas as pd
import numpy as np
data = pd.read_csv('D:/work/id.csv',encoding = 'utf-8',engine='python')
data.loc[:,'id_c']=np.where((data.loc[:,"id"]>=60000),(data["id"]).map(lambda x:(chr(eval(str(x)[:2]))+str(x)[2:])),data["id"])
#id_c=(chr(data.loc[:,"OBSERVE_ID"][:3])+str(data.loc[:,"OBSERVE_ID"][3:]))
data.to_csv('D:/work/id_c.csv',encoding='utf-8')
这五行代码也可以轻松搞定上万行表格哦~