slides-code.R

# Code demonstrated throughout the slides

# Select helper functions and select_ -------------------------------
# Make a students data.frame



# Select students + math grades


# Better yet, using "contains"


# See also: starts_with, ends_with, matches


# Use select_ to select using strings


# Subject of interest (why this matters):


# Summarise -------------------------------

# Compute values of interest


# Reshaping (we won't focus too much on this today) -------------------------------



# Groupby and summarise ------------------------------- 

# Which student has the highest average?


# Which exam was most difficult?


# Student with highest math grade 

                  
# Worst spanish score


# Left joins -------------------------------

# Student majors


# Student contact info


# Join data.frames



# Order matters!