Exercise

Filtering the dataset

Employees at senior levels such as Vice President, Director, Senior Manager etc. have very different labor market conditions and are few in numbers too, hence, including them in your analysis can disproportionately affect your findings.

In this exercise, you will count the number of employees only at the Analyst and Specialist levels using the filter() function.

The following example filters df such that only the observations for which x is a or b or c are selected:

df %>% 
       filter(x %in% c("a", "b", "c"))

Instructions

100 XP
  • First, count the number of employees across levels.
  • Subset the data to retain employees only at the Analyst and Specialist levels.
  • Review the number of employees across all levels, again.