我有这个数据框:
Env location lob grid row server model make slot ports connected disabled
0 Prod USA Market AB3 bc2 Server123 Hitachi Stor 1 3.0 1.0 5.0
1 Prod USA Market AB3 bc2 Server123 Hitachi Stor 2 2.0 3.0 3.0
2 Prod USA Market AB3 bc2 Server123 Hitachi Stor 3 0.0 0.0 2.0
3 Prod USA Market AB3 bc2 Server123 Hitachi Stor 4 8.0 7.0 1.0
4 Total USA Market AB3 bc2 Server123 Hitachi Stor 4 13.0 11.0 11.0
6 Dev EMEA Ins. AB6 bc4 Serverabc IBM Mfa 10 6.0 5.0 0.0
7 Dev EMEA Ins. AB6 bc4 Serverabc IBM Mfa 1 8.0 4.0 0.0
8 Dev EMEA Ins. AB6 bc4 Serverabc IBM Mfa 2 12.0 4.0 0.0
9 Dev EMEA Ins. AB6 bc4 Serverabc IBM Mfa 3 10.0 2.0 0.0
8 Dev EMEA Ins. AB6 bc4 Serverabc IBM Mfa 8 12.0 4.0 0.0
9 Dev EMEA Ins. AB6 bc4 Serverabc IBM Mfa 9 10.0 2.0 0.0
10 Total EMEA Ins. AB6 bc4 Serverabc IBM Mfa 7 36.0 15.0 0.0
我需要按“模型”和“槽”对此数据框进行排序,槽需要从 1 开始并按升序排列,总计需要位于每组模型的末尾。
例如 model=IBM 从 10 开始,它需要从 1 开始,10 需要是总行之前的最后一个数字。总行始终位于每组模型的末尾。最终数据框需要如下所示:
打印(df)
Env location lob grid row server model make slot ports connected disabled
0 Prod USA Market AB3 bc2 Server123 Hitachi Stor 1 3.0 1.0 5.0
1 Prod USA Market AB3 bc2 Server123 Hitachi Stor 2 2.0 3.0 3.0
2 Prod USA Market AB3 bc2 Server123 Hitachi Stor 3 0.0 0.0 2.0
3 Prod USA Market AB3 bc2 Server123 Hitachi Stor 4 8.0 7.0 1.0
4 Total USA Market AB3 bc2 Server123 Hitachi Stor 4 13.0 11.0 11.0
7 Dev EMEA Ins. AB6 bc4 Serverabc IBM Mfa 1 8.0 4.0 0.0
8 Dev EMEA Ins. AB6 bc4 Serverabc IBM Mfa 2 12.0 4.0 0.0
9 Dev EMEA Ins. AB6 bc4 Serverabc IBM Mfa 3 10.0 2.0 0.0
8 Dev EMEA Ins. AB6 bc4 Serverabc IBM Mfa 8 12.0 4.0 0.0
9 Dev EMEA Ins. AB6 bc4 Serverabc IBM Mfa 9 10.0 2.0 0.0
Dev EMEA Ins. AB6 bc4 Serverabc IBM Mfa 10 6.0 5.0 0.0
10 Total EMEA Ins. AB6 bc4 Serverabc IBM Mfa 7 36.0 15.0 0.0
我试过这个:
df.sort(['model', 'slot'], ascending=[True, False])
我需要每个模型组末尾的总计。
您可以有一个临时列指示
Total
:输出: