编辑代码

# coding:utf-8
#JSRUN引擎2.0，支持多达30种语言在线运行，全仿真在线交互输入输出。 
import pandas as pd
import numpy as np
from datetime import datetime, timedelta

# 生成日期范围
date_rng = pd.date_range(start='1/1/2024', end='12/31/2024', freq='D')

# 生成随机数据
np.random.seed(0)
sales = np.random.uniform(1000, 5000, size=(len(date_rng)))
cost = sales * np.random.uniform(0.5, 0.9, size=(len(date_rng)))
profit = sales - cost
customers = np.random.randint(50, 200, size=(len(date_rng)))

# 创建DataFrame
data = pd.DataFrame({
    'Date': date_rng,
    'Sales': sales,
    'Cost': cost,
    'Profit': profit,
    'Customers': customers
})

# 导出为Excel
file_path = 'C:\Lotus\AICG\sales_data.xlsx'
data.to_excel(file_path, index=False)
file_path