data %>%
select(Opponent) %>%
# Extract home (vs) away game (@)
mutate(home_away = if_else(str_detect(Opponent, "@"), "Away", "Home")) %>%
# Extract team PSU played againt
mutate(Opponent_clean = Opponent %>% str_remove("(@|vs) "))
## # A tibble: 77 × 3
## Opponent home_away Opponent_clean
## <chr> <chr> <chr>
## 1 vs Plymouth State - Black Home Plymouth Stat…
## 2 @ Salem State Univ. Away Salem State U…
## 3 vs Framingham State Rams Home Framingham St…
## 4 @ Rivier University Raiders Away Rivier Univer…
## 5 vs Massachusetts College of Liberal Arts Trailblaze… Home Massachusetts…
## 6 @ Hamilton Continentals Away Hamilton Cont…
## 7 vs Fitchburg State Falcons Home Fitchburg Sta…
## 8 @ University of New England Nor'easters Away University of…
## 9 @ Worcester State Lancers Away Worcester Sta…
## 10 vs Fitchburg State Falcons Home Fitchburg Sta…
## # ℹ 67 more rows