How can I group a set of values by column using R programming

Question

This is my Table:

Employee Details:

EmpID | WorkingPlaces | Salary
1001  | Bangalore     | 5000
1001  | Chennai       | 6000
1002  | Bombay        | 1000
1002  | Chennai       | 500
1003  | Pune          | 2000
1003  | Mangalore     | 1000

Suppose that, the same employee works for different places in a month. 

Using this info how can I find the top 2 highly paid employees?

The output should look like this:

EmpID | WorkingPlaces | Salary
1001  | Chennai       | 6000
1001  | Bangalore     | 5000
1003  | Pune          | 2000
1003  | Mangalore     | 1000

Answer 1

Use the dplyr package that R provides:

library(dplyr)
df1 %>%
   group_by(EmpID) %>% 
   mutate(SumSalary = sum(Salary)) %>% 
   arrange(-SumSalary, EmpID) %>% 
   head(4) %>%
   select(-SumSalary)

Answer 2

Try this ,

Employee %>% group_by(EmpID) %>% mutate(SumSalary = sum(Salary)) %>% arrange(desc(SumSalary)) %>% head(2) %>% select(-SumSalary)