Pandas subset rows column mean, pandas get column mean, pandas column mean for rows where, pandas column mean for selected rows, pandas column mean where rows, column mean for a subset of rows

import pandas as pd

csv = pd.read_csv('data.csv')

subset = csv.loc[(csv['Age'].notnull()) & (csv['Sex'] == 'female')]
mean = subset['Age'].mean()
print(mean) #will output mean value for all not-null rows where sex = female

Leave a comment