Python Pandas求和

Question

import pandas as pd
count=0
df=pd.read_csv('E:\Transactions.csv')
print(df.sum())#这里要怎么写啊

            #求每列大于0的行求和

Answer 1

import pandas as pd

df = pd.read_excel('E:\Transactions.csv')
d = {}
for i in df:
    d[i] = sum(df[i][df[i] > 0])
    
print(d)

或者

import pandas as pd

df = pd.read_excel('E:\Transactions.csv')

df.apply(lambda row: sum(row[row > 0]))  # 更帅气

Answer 2

import pandas as pd

data = [
    [1, 2],
    [-1, 2],
    [2, -1],
    [0, 0]
]

df = pd.DataFrame(data, columns=['a', 'b'])
print df[df>0].sum()