外卖门店经营数据看板（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', index=False) print("模拟订单数据已生成：mock_orders.csv")

结果输出