Conditional statement and calculating mean

[phharsh]

Hello,

How do I calculate mean from a given column using a conditional statement ie if a certain variable has a true value only then it should be considered.

For instance= I would only like to calculate the mean age from the above table of all males who have jobs "e"

[FJCC]

Let's assume yo data are in a data frame named df. You can get the average Age of Gender == "M" and Job == "E" with

library(dplyr)
df %>% filter(Gender == "M", Job == "E") %>% summarize(Avg = mean(Age))

You can get the average of all combinations of Gender and Job with

library(dplyr)
df %>% group_by(Gender, Job) %>% summarize(Avg = mean(Age))

[stkrog]

Or if you for some odd reason don't want to use dplyr, you can use vanilla R:

mean(df$Age[df$Gender == "M" & df$Job == "E"])