Padans按行、按列汇总

Padans按行、按列汇总

1、按照行汇总

data.loc['汇总'] = data.apply(lambda x: x.sum()) #按列求和，添加汇总行

pvot_nextweek.loc['总计'] = pvot_nextweek.sum(axis=0)

df.apply(func,axis=1) #添加列，按行计算

#示例

df['C']=df.apply(lambda x:x['A']+x['B'],axis=1) #添加C列，为A列+B列

data['汇总'] = data.apply(lambda x: x.sum(), axis=1) #按行求和，添加汇总列

2、按照列汇总

p_know.loc['总计'] = p_know.sum(axis=0)
p_know.reset_index(inplace=True)