from faker import Faker
from openpyxl import Workbook
import random
# 创建Faker对象
faker = Faker('zh_CN')
# 创建Excel工作簿
wb = Workbook()
ws = wb.active
# 设置表头
ws.append(['user_id', 'user_name', 'user_age', 'job_id', 'job_age','job_enable','city','work_date'])
# 生成30万条数据并写入Excel
for _ in range(300000):
user_id = faker.pystr(min_chars=8, max_chars=8).upper() + faker.numerify()
user_name = faker.name()
user_age = random.randint(23, 60)
job_id = random.choice(["job001","job002","job003","job004","job005"])
job_age = faker.random_int(min=1, max=10)
job_enable = random.choice(['true', 'false'])
city = faker.city()
work_date = faker.date_between(start_date="-10y", end_date="today")
ws.append([user_id, user_name, user_age, job_id, job_age,job_enable,city,work_date])
# 保存Excel文件
wb.save('data30w.xlsx')
print('数据已保存到文件中...')
python faker批量生成大量数据插入excel表
于 2024-06-15 17:23:45 首次发布