我有一个带有3列的Pandas 数据帧示例.
这是示例数据集-
In [3]: df = pd.DataFrame({
...: 'mode': ['car'] * 4 + ['train'] * 3 + ['truck'] * 5,
...: 'qty1': [2,4,9,7,6,3,4,1,2,5,5,7],
...: 'qty2': [5,2,3,6,9,7,4,5,1,6,3,9]
...: })
...: df
Out[3]:
mode qty1 qty2
0 car 2 5
1 car 4 2
2 car 9 3
3 car 7 6
4 train 6 9
5 train 3 7
6 train 4 4
7 truck 1 5
8 truck 2 1
9 truck 5 6
10 truck 5 3
11 truck 7 9
现在我用pivot_table
得到以下输出-
In [4]: pivot1 = pd.pivot_table(data=df,
...: index=['mode'],
...: values=['qty1','qty2'],
...: aggfunc='sum')
In [5]: pivot1
Out[5]:
qty1 qty2
mode
car 22 16
train 13 20
truck 20 24
现在,当我应用以下代码时,
In [7]: pivot1 = pivot1.style.set_table_styles([^M
...: {^M
...: "selector":"th",^M
...: "props": [("border", "1px solid black"),^M
...: ("font-style", "italic")]^M
...: },^M
...: {^M
...: "selector":"th.row_heading",^M
...: "props": [("border", "1px solid black"),^M
...: ("font-style", "italic")]^M
...: } ^M
...: ]).set_properties(border="1px solid black").format('${:.2f}')
...: pivot1
我得到以下输出-
现在我想要one level上的所有column headers-‘mode’、‘qty1’和‘qty2’.我try 使用reset_index()
重置索引,但我不希望在重置索引后使用索引列.我希望最后一张桌子是这样的-
mode | qty1 | qty2 |
---|---|---|
car | $22.00 | $16.00 |
train | $13.00 | $20.00 |
truck | $20.00 | $24.00 |
我的最终目标是将此表保存为png/jpg,并使用python将其上载到pptx演示文稿中.
任何帮助都将不胜感激!谢谢