I would like to find the average age of people who have a dog using a lambda function,
and so far I have made this code
pets['age'].mean(lambda x: x in pets['pets'] == 'dog')
... but it keeps giving me a value error..... help would be very appriciated!
If need age with dog and possible another values filter by boolean indexing with DataFrame.loc:
out = df.loc[df['pets'].apply(lambda x: 'dog' in x), 'age'].mean()
print (out)
46.75
If need age with only dog :
out = df.loc[df['pets'].apply(lambda x: x[0] == 'dog'), 'age'].mean()
out = df.loc[df['pets'].str[0] == 'dog', 'age'].mean()
print (out)
55.333333333333336
You can do the job also without any lambda function. One of possible solutions is:
df.explode('pets').query('pets == "dog"').age.mean()
