我有一个CSV文件，我读到一个Pandas 文件使用多索引头. 下面是一个例子:
df = pd.DataFrame([[1,5,5,2,3], [2,10,4,20,3]])
df.columns = pd.MultiIndex.from_tuples((("1/1/2024","Store"), ("product code 1", "quantity onhand"), ("product code 1",'quantity sold'), ("product code 2", "quantity onhand"), ("product code 2",'quantity sold')))
df
| 1/1/2024 Store |
product code 1 quantity onhand |
product code 1 quantity sold |
product code 2 quantity onhand |
product code 2 quantity sold |
|---|---|---|---|---|
| 1 | 5 | 5 | 2 | 3 |
| 2 | 10 | 4 | 20 | 3 |
第一栏中的日期不需要. 我试过堆，但我需要保留store 的原样. 这可以使用pivot来完成吗？
data = [[1,'product code 1',5,5],[1,'product code 2',3,2],[2,'product code 1',4,10],[2,'product code 2',3,20]]
columns = ['Store','Code','quantity sold','quantity onhand']
df2 = pd.DataFrame(data, columns=columns)
df2
| Store | Code | quantity sold | quantity onhand |
|---|---|---|---|
| 1 | product code 1 | 5 | 5 |
| 1 | product code 2 | 3 | 2 |
| 2 | product code 1 | 4 | 10 |
| 2 | product code 2 | 3 | 20 |