生成sales_data.xlsx文件代码:
import pandas as pd
# 定义销售数据
data = {
"产品名称": ["产品A", "产品B", "产品C", "产品A", "产品B", "产品C", "产品A", "产品B", "产品C"],
"销售日期": ["2025-01-01", "2025-01-02", "2025-01-03", "2025-01-04", "2025-01-05",
"2025-01-06", "2025-01-07", "2025-01-08", "2025-01-09"],
"销售量": [10, 5, 8, 12, 6, 7, 15, 4, 9],
"单价": [100, 150, 200, 100, 150, 200, 100, 150, 200],
"销售额": [1000, 750, 1600, 1200, 900, 1400, 1500, 600, 1800],
"销售区域": ["华东", "华北", "华南", "华东", "华北", "华南", "华东", "华北", "华南"],
"销售人员": ["张三", "李四", "王五", "张三", "李四", "王五", "张三", "李四", "王五"]
}
# 创建DataFrame
df = pd.DataFrame(data)
# 保存为Excel文件
df.to_excel("sales_data.xlsx", index=False, engine="openpyxl")
print("sales_data.xlsx 文件已生成!")