目的:将excel中的所有电话信息批量查询到归属地信息并对应记录到新的表格中
代码分享:
import phone
import pandas as pd
import os
p = phone.Phone()
PATH = os.path.expanduser(‘C:\Users\Administrator\Desktop\local\local1\local.csv’)
def data_prepare():
# f = open(PATH, ‘rb’)
df = pd.read_csv(“local.1.csv”, encoding=“gbk”)
# print(df)
# f.close()
return df
def play():
df = data_prepare()
results = list()
for index, series in df.iterrows():
# print(series)
try:
phone_num = series[‘phone’]
name = series[“name”]
# phone_num = phone_num.replace(" ", “”)
# phone_num = int(phone_num)
dt = p.find(phone_num)
dt[‘name’] = name
results.append(dt)
except Exception as e:
print(“failed to parse the raw=%d, exception=%s.” % (index, e))
new_df = pd.DataFrame(results)
# print(new_df)
new_df.to_csv(‘local-new.csv’,encoding=“gbk”)
play()