Dataset: 2021 PGA Tour Stats

About this Dataset

2021 PGA Tour Stats

Context

I have seen some other datasets for various PGA Tour Stats and I noticed there wasn't one for 2021. I built a scraper to pull the information from the PGA Tour website and then did my own manipulation on the data to get it in the right format as well as make custom column names for reference.

Content

Inside the data set you'll find the first column with the player names for 197 players on the PGA Tour. And then each column is named like the following:
"Data Title---Data Subcategory---Data Category." For example this is how the column "AVERAGE---sg: approach the green---APPROACH THE GREEN" would read, Average is the average value for SG on Approach the Green under the tab APPROACH THE GREEN on the PGA Tour Stats site. The columns are broken down like this because the Data Titles have shared names across the Data Subcategories, to avoid confusion or miss represented data I labeled them accordingly.
Original Site here: https://www.pgatour.com/stats.html

Acknowledgements

Have to acknowledge Steve Russo and his data set Here

Inspiration

The inspiration for this data set came from this webscraper created by Steve Russo. https://github.com/sjrusso8/pga-scraper
I will upload my version to my Github here shortly.

Tables

N 2021 Pga Tour Filtered Stats

@kaggle.lilcobeeee_2021_pga_tour_stats.n_2021_pga_tour_filtered_stats

330.82 KB
196 rows
191 columns


CREATE TABLE n_2021_pga_tour_filtered_stats (
  "player_name" VARCHAR,
  "rounds_sg_approach_the_green_approach_the_green" BIGINT,
  "average_sg_approach_the_green_approach_the_green" DOUBLE,
  "total_sg_app_sg_approach_the_green_approach_the_green" DOUBLE,
  "measured_rounds_sg_approach_the_green_approach_the_green" BIGINT,
  "n__greens_in_regulation_percentage_approach_the_green" DOUBLE,
  "greens_hit_greens_in_regulation_percentage_approach_the_green" BIGINT,
  "n__holes_greens_in_regulation_percentage_approach_the_green" BIGINT,
  "relative_par_greens_in_regulation_percentage_approach_the_green" DOUBLE,
  "avg_average_distance_of_birdie_putts_made_putting" VARCHAR,
  "tot_dist_ft_average_distance_of_birdie_putts_made_putting" DOUBLE,
  "tot_birdie_putts_made_average_distance_of_birdie_putts_9aac35d1" BIGINT,
  "longest_made_ft_average_distance_of_birdie_putts_made_putting" BIGINT,
  "shortest_made_ft_average_distance_of_birdie_putts_made_putting" VARCHAR,
  "avg_average_putting_distance_all_1_putts_putting" VARCHAR,
  "distance_feet_average_putting_distance_all_1_putts_putting" DOUBLE,
  "total_putts_average_putting_distance_all_1_putts_putting" BIGINT,
  "avg_putts_per_round_round_3_putting" DOUBLE,
  "total_putts_putts_per_round_round_3_putting" BIGINT,
  "total_rounds_putts_per_round_round_3_putting" BIGINT,
  "avg_overall_putting_average_putting" DOUBLE,
  "n__of_putts_overall_putting_average_putting" BIGINT,
  "n__of_holes_overall_putting_average_putting" BIGINT,
  "avg_putts_per_round_round_2_putting" DOUBLE,
  "total_putts_putts_per_round_round_2_putting" BIGINT,
  "total_rounds_putts_per_round_round_2_putting" BIGINT,
  "avg_putts_per_round_round_1_putting" DOUBLE,
  "total_putts_putts_per_round_round_1_putting" BIGINT,
  "total_rounds_putts_per_round_round_1_putting" BIGINT,
  "avg_putts_per_round_putting" DOUBLE,
  "total_putts_putts_per_round_putting" BIGINT,
  "total_rounds_putts_per_round_putting" BIGINT,
  "low_total_putts_putts_per_round_putting" BIGINT,
  "avg_putts_per_round_round_4_putting" DOUBLE,
  "total_putts_putts_per_round_round_4_putting" BIGINT,
  "total_rounds_putts_per_round_round_4_putting" BIGINT,
  "avg_3_putts_per_round_putting" DOUBLE,
  "total_3_putts_3_putts_per_round_putting" BIGINT,
  "total_rounds_3_putts_per_round_putting" BIGINT,
  "n__3_putt_avoidance_putting" DOUBLE,
  "total_3_putts_3_putt_avoidance_putting" BIGINT,
  "total_holes_overall_3_putt_avoidance_putting" BIGINT,
  "total_total_1_putts_inside_5_putting" BIGINT,
  "total_for_all_distances_total_1_putts_inside_5_putting" BIGINT,
  "pct_of_all_1_putts_total_1_putts_inside_5_putting" DOUBLE,
  "average_sg_putting_putting" DOUBLE,
  "total_sg_putting_sg_putting_putting" DOUBLE,
  "measured_rounds_sg_putting_putting" BIGINT,
  "avg_1_putts_per_round_putting" DOUBLE,
  "total_1_putts_1_putts_per_round_putting" BIGINT,
  "total_rounds_1_putts_per_round_putting" BIGINT,
  "n__one_putt_percentage_putting" DOUBLE,
  "n__of_1_putts_one_putt_percentage_putting" BIGINT,
  "n__of_holes_one_putt_percentage_putting" BIGINT,
  "avg_dtp_proximity_to_hole_arg_around_the_green" VARCHAR,
  "total_distance_feet_proximity_to_hole_arg_around_the_green" DOUBLE,
  "n__of_shots_proximity_to_hole_arg_around_the_green" BIGINT,
  "scrambling_rank_proximity_to_hole_arg_around_the_green" BIGINT,
  "n__scrambling_around_the_green" DOUBLE,
  "par_or_better_scrambling_around_the_green" BIGINT,
  "missed_gir_scrambling_around_the_green" BIGINT,
  "average_sg_around_the_green_around_the_green" DOUBLE,
  "total_sg_arg_sg_around_the_green_around_the_green" DOUBLE,
  "measured_rounds_sg_around_the_green_around_the_green" BIGINT,
  "n__sand_save_percentage_around_the_green" DOUBLE,
  "n__saves_sand_save_percentage_around_the_green" BIGINT,
  "n__bunkers_sand_save_percentage_around_the_green" BIGINT,
  "total_o_u_par_sand_save_percentage_around_the_green" DOUBLE,
  "avg_round_4_scoring_average_scoring" DOUBLE,
  "total_strokes_round_4_scoring_average_scoring" BIGINT,
  "total_rounds_round_4_scoring_average_scoring" BIGINT,
  "avg_round_3_scoring_average_scoring" DOUBLE,
  "total_strokes_round_3_scoring_average_scoring" BIGINT,
  "total_rounds_round_3_scoring_average_scoring" BIGINT,
  "avg_round_2_scoring_average_scoring" DOUBLE,
  "total_strokes_round_2_scoring_average_scoring" BIGINT,
  "total_rounds_round_2_scoring_average_scoring" BIGINT,
  "avg_round_1_scoring_average_scoring" DOUBLE,
  "total_strokes_round_1_scoring_average_scoring" BIGINT,
  "total_rounds_round_1_scoring_average_scoring" BIGINT,
  "avg_final_round_scoring_average_scoring" DOUBLE,
  "total_strokes_final_round_scoring_average_scoring" BIGINT,
  "total_rounds_final_round_scoring_average_scoring" BIGINT,
  "n__birdie_or_better_percentage_scoring" DOUBLE,
  "total_birdies_birdie_or_better_percentage_scoring" BIGINT,
  "total_holes_birdie_or_better_percentage_scoring" BIGINT,
  "gir_rank_birdie_or_better_percentage_scoring" BIGINT,
  "total_total_birdies_scoring" BIGINT,
  "total_total_eagles_scoring" BIGINT,
  "avg_scoring_average_actual_scoring" DOUBLE,
  "total_strokes_scoring_average_actual_scoring" BIGINT,
  "total_rounds_scoring_average_actual_scoring" BIGINT,
  "average_sg_total_scoring" DOUBLE,
  "total_sg_t_sg_total_scoring" DOUBLE,
  "total_sg_t2g_sg_total_scoring" DOUBLE,
  "total_sg_p_sg_total_scoring" DOUBLE,
  "measured_rounds_sg_total_scoring" BIGINT,
  "avg_scoring_average_scoring" DOUBLE,
  "total_strokes_scoring_average_scoring" BIGINT,
  "total_adjustment_scoring_average_scoring" VARCHAR
);