#!/usr/bin/env python
# coding: utf-8
# In[1]:
def get_quxian(ca):
try:
for k,v in dict1:
if v >= int(ca):
return k
except:
return '无邮政编码'
def get_city(ca):
return get_quxian(str(ca)[0:3]+'000')
import pandas as pd
df = pd.read_excel(r"C:\Users\Administrator\Desktop\赚钱\程序员\专利数据处理\各地区邮政编码.xlsx")
dict1 = list(zip(df['城市'],df['邮政编码']))
dict1
# In[ ]:
