
import csvorders = []fields = {"订单号": "id","客户": "customer","金额": "amount",}def read_row(reader, source):raw = next(reader)return {"source": source,**{key: raw[col]for col, key in fields.items()}}with open("门店订单.csv", encoding="utf-8-sig") as file:reader = csv.DictReader(file)orders.append(read_row(reader, "门店"))orders.append(read_row(reader, "门店"))with open("商城订单.csv", encoding="utf-8-sig") as file:reader = csv.DictReader(file)orders.append(read_row(reader, "商城"))orders.append(read_row(reader, "商城"))with open("渠道订单.csv", encoding="utf-8-sig") as file:reader = csv.DictReader(file)orders.append(read_row(reader, "渠道"))orders.append(read_row(reader, "渠道"))
| 来源 | 订单号 | 客户 | 金额/元 |
|---|---|---|---|
| 门店 | A-101 | 云舟 | 360 |
| 门店 | A-102 | 青禾 | 240 |
| 商城 | B-201 | — | 180 |
| 商城 | B-202 | 青禾 | 150 |
| 渠道 | A-102 | 青禾 | 240 |
| 渠道 | C-301 | 远山 | 待确认 |
01 多源数据采集
让分散的数据,成为统一的信息。连接不同业务来源,自动读取、整理并统一数据格式。保留原始来源与处理记录,让每一份数据都清晰可查、持续可用。













