业务数据脚本自动生成

import os
import pandas as pd
import random
from faker import Faker

使用 Faker 生成随机数据

fake = Faker()

生成示例业务数据

def generate_business_data(num_records=100):
data = {
‘ID’: [i+1 for i in range(num_records)],
‘Name’: [fake.name() for _ in range(num_records)],
‘Email’: [fake.email() for _ in range(num_records)],
‘Phone’: [fake.phone_number() for _ in range(num_records)],
‘Age’: [random.randint(18, 60) for _ in range(num_records)],
‘City’: [fake.city() for _ in range(num_records)],
‘Salary’: [random.randint(30000, 80000) for _ in range(num_records)],
‘Join_Date’: [fake.date_this_decade() for _ in range(num_records)]
}

df = pd.DataFrame(data)
return df

指定桌面文件夹路径

desktop_path = os.path.join(os.path.expanduser(“~”), “Desktop”)

生成业务数据并保存到桌面上的 Excel 文件

business_data = generate_business_data()
excel_file_path = os.path.join(desktop_path, ‘business_data.xlsx’)
business_data.to_excel(excel_file_path, index=False)

print(f"业务数据已保存到 {excel_file_path}")