借助faker+pandas向excel表格里制造测试数据

预期结果如下：

第一种方式：

import pandas as pd
from faker import Faker
import random
f = Faker(locale='zh_CN')
meniu = []
n = 10000
for i in range(1, 11):
    # for j in range(1, 3):
    for j in range(1,random.randint(4,20)):
        b = {
            "姓名(*)": "{}".format(f.unique.name()),
            "手机号(*)": "{}".format(f.unique.phone_number()),
            "证件号码(*)": "{}".format(j),
            "开盘批次": "{}".format(i),
            "置业顾问团队(*)": "海洋团队",
            "置业顾问姓名(*)": "陌上玉置业顾问",
            "置业顾问手机号(*)": "18811111117",
            "备注": "",
            "认筹金额": f.random_int(min=1000, max=9999),
            "认筹单号(*)": "{}".format(n)
        }
        meniu.append(b)
        n += 1
# pprint(meniu)
df = pd.DataFrame(meniu)
df.to_excel(r"C:\Users\28071\Desktop\在线开盘\认筹名单.xlsx", index=None)

第二种方式：借助列表生成式

b=[{"姓名(*)": "{}".format(f.unique.name()),"手机号(*)": "{}".format(f.unique.phone_number()),"证件号码(*)": "{}".format(f.unique.ssn()),"开盘批次": "{}".format(i),"置业顾问团队(*)": "海洋团队","置业顾问姓名(*)": "陌上玉置业顾问","置业顾问手机号(*)": "18811111117","备注": "","认筹金额": f.random_int(min=1000, max=9999),"认筹单号(*)": "{}".format(10000+j)}for i in range(1, 5) for j in range(1, 11)]
df = pd.DataFrame(b)
df.to_excel(r"C:\Users\28071\Desktop\在线开盘\认筹名单.xlsx",index=None)