如何为系列中的单元格编制索引？

Question

我用了这个密码

nonzero = ucla_all[ucla_all['ADJUSTMENTS']!= 0]
cond = (nonzero.groupby(['SERV_CODE', 'CPT_CODE']).mean())['ADJUSTMENTS']
cond

显示此表的步骤

SERV_CODE  CPT_CODE
2110       90834      -600.000000
           90837      -421.000000
2111       90849      -110.000000
           90853      -130.000000
2220       90834      -800.000000
           90837      -416.534804
           90849      -110.000000

如何为第三列编制索引

Answer 1

nonzero = ucla_all[ucla_all['ADJUSTMENTS']!= 0]
cond = (nonzero.groupby(['SERV_CODE', 'CPT_CODE']).mean())['ADJUSTMENTS']

cond.columns = ['SERV_CODE', 'CPT_CODE', 'NEW_COLUMN_NAME']

SERV_CODE  CPT_CODE   NEW_COLUMN_NAME
2110       90834      -600.000000
           90837      -421.000000
2111       90849      -110.000000
           90853      -130.000000
2220       90834      -800.000000
           90837      -416.534804
           90849      -110.000000