Apply the following dplyr verbs to your data
Filter rows
## # A tibble: 0 × 37
## # ℹ 37 variables: YEAR <dbl>, TEAM NO <dbl>, TEAM ID <dbl>, TEAM <chr>,
## # CONF <chr>, DUNKS FG% <dbl>, DUNKS SHARE <dbl>, DUNKS FG%D <dbl>,
## # DUNKS D SHARE <dbl>, CLOSE TWOS FG% <dbl>, CLOSE TWOS SHARE <dbl>,
## # CLOSE TWOS FG%D <dbl>, CLOSE TWOS D SHARE <dbl>, FARTHER TWOS FG% <dbl>,
## # FARTHER TWOS SHARE <dbl>, FARTHER TWOS FG%D <dbl>,
## # FARTHER TWOS D SHARE <dbl>, THREES FG% <dbl>, THREES SHARE <dbl>,
## # THREES FG%D <dbl>, THREES D SHARE <dbl>, DUNKS FG% RANK <dbl>, …
Arrange rows
## # A tibble: 949 × 37
## YEAR `TEAM NO` `TEAM ID` TEAM CONF `DUNKS FG%` `DUNKS SHARE` `DUNKS FG%D`
## <dbl> <dbl> <dbl> <chr> <chr> <dbl> <dbl> <dbl>
## 1 2024 1079 2 Akron MAC 97.2 6.8 90.6
## 2 2024 1078 3 Alaba… SEC 81.9 9.5 89.2
## 3 2024 1077 8 Arizo… P12 91.2 11.9 89.3
## 4 2024 1076 12 Auburn SEC 87.7 13.2 87.1
## 5 2024 1075 14 Baylor B12 89.2 11.6 91.8
## 6 2024 1074 17 Boise… MWC 90.2 4.9 87.5
## 7 2024 1073 25 BYU B12 88.9 6.1 92.1
## 8 2024 1072 33 Clems… ACC 97.2 6.4 81
## 9 2024 1071 36 Colga… Pat 100 1.8 97.2
## 10 2024 1070 37 Colle… CAA 92.9 7.6 86
## # ℹ 939 more rows
## # ℹ 29 more variables: `DUNKS D SHARE` <dbl>, `CLOSE TWOS FG%` <dbl>,
## # `CLOSE TWOS SHARE` <dbl>, `CLOSE TWOS FG%D` <dbl>,
## # `CLOSE TWOS D SHARE` <dbl>, `FARTHER TWOS FG%` <dbl>,
## # `FARTHER TWOS SHARE` <dbl>, `FARTHER TWOS FG%D` <dbl>,
## # `FARTHER TWOS D SHARE` <dbl>, `THREES FG%` <dbl>, `THREES SHARE` <dbl>,
## # `THREES FG%D` <dbl>, `THREES D SHARE` <dbl>, `DUNKS FG% RANK` <dbl>, …
Select columns
## # A tibble: 949 × 16
## TEAM CONF `DUNKS FG%` `DUNKS SHARE` `DUNKS FG%D` `DUNKS D SHARE`
## <chr> <chr> <dbl> <dbl> <dbl> <dbl>
## 1 Akron MAC 97.2 6.8 90.6 5.6
## 2 Alabama SEC 81.9 9.5 89.2 7.3
## 3 Arizona P12 91.2 11.9 89.3 5.9
## 4 Auburn SEC 87.7 13.2 87.1 4.7
## 5 Baylor B12 89.2 11.6 91.8 7.2
## 6 Boise St. MWC 90.2 4.9 87.5 6.2
## 7 BYU B12 88.9 6.1 92.1 5.9
## 8 Clemson ACC 97.2 6.4 81 5.2
## 9 Colgate Pat 100 1.8 97.2 3.1
## 10 College of Char… CAA 92.9 7.6 86 3.4
## # ℹ 939 more rows
## # ℹ 10 more variables: `CLOSE TWOS FG%` <dbl>, `CLOSE TWOS SHARE` <dbl>,
## # `CLOSE TWOS FG%D` <dbl>, `CLOSE TWOS D SHARE` <dbl>,
## # `FARTHER TWOS FG%` <dbl>, `FARTHER TWOS SHARE` <dbl>,
## # `FARTHER TWOS FG%D` <dbl>, `FARTHER TWOS D SHARE` <dbl>,
## # `THREES FG%` <dbl>, `THREES SHARE` <dbl>
Add columns
## # A tibble: 949 × 38
## YEAR `TEAM NO` `TEAM ID` TEAM CONF `DUNKS FG%` `DUNKS SHARE` `DUNKS FG%D`
## <dbl> <dbl> <dbl> <chr> <chr> <dbl> <dbl> <dbl>
## 1 2024 1079 2 Akron MAC 97.2 6.8 90.6
## 2 2024 1078 3 Alaba… SEC 81.9 9.5 89.2
## 3 2024 1077 8 Arizo… P12 91.2 11.9 89.3
## 4 2024 1076 12 Auburn SEC 87.7 13.2 87.1
## 5 2024 1075 14 Baylor B12 89.2 11.6 91.8
## 6 2024 1074 17 Boise… MWC 90.2 4.9 87.5
## 7 2024 1073 25 BYU B12 88.9 6.1 92.1
## 8 2024 1072 33 Clems… ACC 97.2 6.4 81
## 9 2024 1071 36 Colga… Pat 100 1.8 97.2
## 10 2024 1070 37 Colle… CAA 92.9 7.6 86
## # ℹ 939 more rows
## # ℹ 30 more variables: `DUNKS D SHARE` <dbl>, `CLOSE TWOS FG%` <dbl>,
## # `CLOSE TWOS SHARE` <dbl>, `CLOSE TWOS FG%D` <dbl>,
## # `CLOSE TWOS D SHARE` <dbl>, `FARTHER TWOS FG%` <dbl>,
## # `FARTHER TWOS SHARE` <dbl>, `FARTHER TWOS FG%D` <dbl>,
## # `FARTHER TWOS D SHARE` <dbl>, `THREES FG%` <dbl>, `THREES SHARE` <dbl>,
## # `THREES FG%D` <dbl>, `THREES D SHARE` <dbl>, `DUNKS FG% RANK` <dbl>, …
Summarize by groups
## # A tibble: 1 × 9
## Total_Teams Average_Dunks_FG_Percentage Average_Close_Twos_FG_Percentage
## <int> <dbl> <dbl>
## 1 949 89.6 62.4
## # ℹ 6 more variables: Average_Farther_Twos_FG_Percentage <dbl>,
## # Average_Threes_FG_Percentage <dbl>, Average_Dunks_Share <dbl>,
## # Average_Close_Twos_Share <dbl>, Average_Farther_Twos_Share <dbl>,
## # Average_Threes_Share <dbl>