Python(phone)模块获取手机号归属地、区号、运营商等

Python(phone)模块获取手机号归属地、区号、运营商等

一、我使用的是python3,可以自行搜索下载

二、安装phone模块， pip install phone 

三、测试代码如下：

1from phone import Phone
2
3if __name__ == "__main__":
4    phoneNum = '17613394466'
5    info = Phone().find(phoneNum)
6    print(info)
7    try:
8        phone = info['phone']
9        province = info['province']
10        city = info['city']
11        zip_code = info['zip_code']
12        area_code = info['area_code']
13        phone_type = info['phone_type']
14    except:
15        print('none')

四、批量查询excle中已有的电话号

1from phone import Phone
2import xlrd
3import xlwt
4
5
6def Get_Excel_data():
7    file = './Tel.xlsx'   #电话号码存储的excle表
8    re1 = xlrd.open_workbook(file)
9
10    outwb = xlwt.Workbook() #创建工作簿
11    # print(type(outwb))
12    outws = outwb.add_sheet("new")  #在工作簿中新建一个工作表new
13    # print(type(outws))
14
15    # 读取第一个sheet
16    ws = re1.sheet_by_index(0)
17    rows = ws.nrows
18    # print(rows)
19    outws.write(0, 0, u'电话号')  #给新表的第一行添加对应的标签
20    outws.write(0, 1, u'省份')
21    outws.write(0, 2, u'城市')
22    outws.write(0, 3, u'区号')
23    outws.write(0, 4, u'运营商')
24
25    for i in range(0, rows):
26        Telvalue = int(ws.cell_value(i, 0))
27        # print(Telvalue)
28        data = Phone().find(Telvalue)
29        print(data)
30        outws.write(i + 1, 0, Telvalue)  #给新表的个列添加对应的数据
31        try:
32            outws.write(i + 1, 1, data['province'])
33            outws.write(i + 1, 2, data['city'])
34            outws.write(i + 1, 3, data['area_code'])
35            outws.write(i + 1, 4, data['phone_type'])
36
37            outwb.save(r'New_Tel.xls')
38        except:
39            print("none")
40
41Get_Excel_data()