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
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