Import data

# csv file
data <- read.csv("../00_data/Salaries.csv")
data

# excel file
data <- read_excel("../00_data/Salaries.xlsx")
data

Apply the following dplyr verbs to your data

Filter rows

filter(data, rank == "Prof")

Arrange rows

arrange(data, yrs.since.phd)

Select columns

Add columns

Summarize by groups