z147369521的博客

原创 数据可视化当中数据缺失

df['num'] = [re.findall(r'(\d+\.{0,1}\d*)', i)[0] for i in df['付款情况']]df['unit'] = [''.join(re.findall(r'(万)', i)) for i in df['付款情况']]df['unit'] = df['unit'].apply(lambda x:10000 if x=='万' else 1)df['省份'] = df['地址'].str.split(' ').apply(lambda x:x[0])