import pandas as pd
df = pd.read_csv(r'C:UsersgiserDesktopheilongjiang.csv',encoding='gbk')
df1 = pd.read_csv(r'C:UsersgiserDesktopcitylist.csv',encoding='gbk')
# df['type1'] = list(map(lambda x:x.split(';')[0],df['type']))
# df['type2'] = list(map(lambda x:x.split(';')[1],df['type']))
# df['type3'] = list(map(lambda x:x.split(';')[2],df['type']))
first = []
second = []
thirst = []
for i in df['type']:
try:
f = i.split(';')[0]
except:
f = ''
try:
r = i.split(';')[1]
except:
r = ''
try:
t = i.split(';')[2]
except:
t = ''
first.append(f)
second.append(r)
thirst.append(t)
df['type1'] = first
df['type2'] = second
df['type3'] = thirst
for s in df1['citylist']:
print(s)
res = df[df['adcode']==s]
res.to_csv(r'D:poi{}.csv'.format(s),encoding='gbk')