表单引擎-engine2x-快速做业务系统-不用写代码-会xls即可

模拟生成一个采购客户的xls表格之python代码：


import pandas as pd
import random
from faker import Faker
from datetime import datetime, timedelta

fake = Faker('zh_CN')

# 生成100条数据
data = []
for _ in range(100):
    company = f"{fake.city()}·{fake.company_prefix()}{random.choice(['科技', '贸易', '实业', '电子', '材料'])}有限公司"
    contact = fake.name()
    phone = fake.phone_number()
    email = contact.lower() + f"{random.randint(1000, 9999)}@" + fake.free_email_domain()

    record = {
        "客户ID": _ + 1,
        "公司名称": company.replace("集团", ""),
        "联系人": contact,
        "联系电话": phone,
        "邮箱": email,
        "所在地区": random.choice(["华东", "华南", "华北", "西南", "西北"]),
        "所属行业": random.choice(["电子制造", "机械设备", "食品饮料", "医疗器械", "建筑材料"]),
        "最近采购日期": (datetime.now() - timedelta(days=random.randint(1, 365))).strftime("%Y-%m-%d"),
        "年度采购次数": random.randint(1, 20),
        "年度采购金额(元)": round(random.randint(5000, 500000), -2),
        "采购产品类别": random.choice(["电子元件", "机械设备", "包装材料", "化工产品", "办公用品"]),
        "支付方式": random.choice(["电汇", "信用证", "承兑汇票", "现金支付", "在线支付"])
    }
    record["平均单次金额(元)"] = round(record["年度采购金额(元)"] / record["年度采购次数"])
    record["客户等级"] = "VIP客户" if record["年度采购金额(元)"] > 300000 else "优质客户" if record["年度采购金额(元)"] > 100000 else "普通客户"
    data.append(record)

df = pd.DataFrame(data)
df.to_excel("采购客户管理表.xlsx", index=False)

print("done")