Pandas>>按照行、列进行求和

Pandas>>按照行、列进行求和

基础数据：

data_test= pd.DataFrame([
                    ['张三',1,1],
                    ['李四',2,2],
                    ['张三',3,3],
                    ['张三',4,4],
                    ['王五',5,5],
                    ['王五',6,6,],
                    ['赵六',7,7]
                    ],
                    columns =['name','number_1','number_2']
                    )
data_test

image.png

先看下图：

image.png

• 1.使用1值表示沿着每一行或者列标签模向0.行对应的方法

data_test['axis_1']=data_test.loc[:,['number_1','number_2']].apply(lambda x:x.sum(),axis=1)
data_test

image.png

• 2.使用0值表示沿着每一列或行标签\索引值向下执行方法

data_test.loc['axis_0']=data_test.loc[:,['number_1','number_2','axis_1']].apply(lambda x:x.sum())
data_test

image.png
注：参考https://mbd.baidu.com/newspage/data/landingshare?pageType=1&isBdboxFrom=1&context=%7B%22nid%22%3A%22news_10587707568739755641%22%2C%22sourceFrom%22%3A%22bjh%22%7D