外卖门店经营数据看板（Excel动态仪表板）

生成一周模拟数据源码import pandas as pd import numpy as np from datetime import datetime, timedelta np.random.seed(42) stores [(A01, 人民广场店), (A02, 南京东路店), (A03, 静安寺店)] dates [datetime.now().date() - timedelta(i) for i in range(7, 0, -1)] orders [] for store_id, store_name in stores: for dt in dates: daily_orders np.random.randint(80, 200) # 每天订单量 for _ in range(daily_orders): order { order_id: np.random.randint(10000, 99999), store_id: store_id, store_name: store_name, order_amt: round(np.random.uniform(15, 80), 2), order_time: f{dt} {np.random.choice([11:30,12:00,12:30,18:00,18:30])}, rating: np.random.choice([好评,中评,差评,无评价], p[0.85,0.05,0.03,0.07]), delivery_time: np.random.randint(15, 60) } orders.append(order) df pd.DataFrame(orders) df.to_csv(mock_orders.csv, indexFalse) print(模拟订单数据已生成mock_orders.csv)结果输出