我有一个供应商和产品的excel,其中supplier B和supplier D是特殊供应商:
供应商 | 产品 |
---|---|
Supplier A | Product A |
Supplier B | Product A |
Supplier C | Product A |
…… | …… |
Supplier A | Product B |
Supplier C | Product C |
Supplier D | Product C |
我想用Python输出如下信息:
产品 | 供应商 | 供应商数量 | 特殊供应商数量 |
---|---|---|---|
Product A | Supplier A, Supplier B, Supplier C | 3 | 1 |
Product B | Supplier A | 1 | 0 |
Product C | Supplier C, Supplier D | 2 | 1 |