python常用工具库
一、构造数据:faker
import faker fake = faker.Faker(locale='zh-CN') user_mobile = fake.phone_numble() cnid = fake.ssn(21, 39) name = fake.name() female_name = fake.neme_female() company_name = fake.company()
二、随机取数:random
import random #随机数字段 mobile = '13' + str(random.randint(100000000, 999999999)) #列表中随机抽3个 list = ['黄鹏', '朱朗', '林灿', '薛演', '黄刚'] name = random.choice(list) #列表中随机抽3个 list = ['黄鹏', '朱朗', '林灿', '薛演', '黄刚'] numbers = random.sample(list,3)
三、表格读写:xlrd、xlutils
import xlrd from xlutils.copy import copy # 1、读取 excel 表格需要使用的 tab 页,并copy副本备用 excelDir = r'..\static\data\测试数据.xls' workbook = xlrd.open_workbook(excelDir,formatting_info=True) worksheet = workbook.sheet_by_name('构建贷款数据') workbook_copy = copy(workbook) worksheet_copy = workbook_copy.get_sheet(0) i = worksheet.nrows print('\n总的行数',i) print('总的列数',worksheet.ncols) print('第一行数据',worksheet.row_values(0)) print('第一列数据',worksheet.col_values(0)) # 读第2行,第1列的值: mobile = int(worksheet.cell(1, 0).value) # 写入第2行,第1列值 13766668888 worksheet_copy.write(1,0,‘13766668888’) # 保存: workbook_copy.save(r'..\static\data\测试数据结果.xls')
四、表格创建:openpyxl
import openpyxl
wk = openpyxl.Workbook()
sheet = wk.create_sheet()
list = [("LoanExpireSendSmsJob",'0 0 10 * * ?'),("LoanOverSendSmsJob","0 0 8,18 * * ?")]
for i in list:
sheet.append([i[0],i[1]])
wk.save(r'..\static\data\cheney-2021082701.xlsx')
五、正则匹配
import re
email = 'cheney@163.com'
match = re.search('(\w+)@163.com', email)
match0 = match.group(0)
match1 = match.group(1)
print(match) # 打印: <re.Match object; span=(0, 14), match='cheney@163.com'>
print(match0) # 打印: cheney@163.com
print(match1) # 打印: cheney
mobile = ['13760388717','13477778888','13900003334']
for i in mobile:
if re.search('\d*[^47]$',i): # 匹配不以4、7结尾
print(i) # 打印:13477778888