install.packages("tidyverse")
install.packages("readr")
install.packages("formattable")
install.packages("gridExtra")
install.packages("ggpubr")
install.packages("Hmisc")
install.packages("corrplot")
install.packages("PerformanceAnalytics")
library(PerformanceAnalytics)
library(Hmisc)
library(corrplot)
library(ggpubr)
library(tidyverse)
library(dplyr)
library(readr)
library(ggplot2)
library(tidyr)
library(janitor)
library(rmarkdown)
library(lubridate)
library(scales)
library(formattable)
library(gridExtra)
# upload edited and cleaned csv files from excel
pga_data<-read_csv("espn_pga_data_csv.csv")
t10_pga_data<-read_csv("espn_pga_data_t10_csv.csv")
# all player average drive distance df
distance_df<- pga_data %>%
select(avg_drive, date) %>%
group_by(Year = date) %>%
summarise (Average_Drive_Yards = mean (avg_drive,2))
# top 10 average drive distance df
t10_distance_df<- t10_pga_data %>%
select(avg_drive, date) %>%
group_by(Year = date) %>%
summarise (Average_Drive_Yards_t10 = mean (avg_drive,2))
distance_df$Year <- paste0(" ", distance_df$Year)
t10_distance_df$Year <- paste0(" ", t10_distance_df$Year)
merged_distance<-merge(distance_df, t10_distance_df)
## plot of average distance of top 10 drivers and all player average drive
ggplot(data = merged_distance)+
geom_point(mapping = aes(x = Year, y = Average_Drive_Yards), color = 'blue')+
geom_text(size = 2.5, mapping =aes(x = Year, y = Average_Drive_Yards,label = paste0(" ",Average_Drive_Yards," ")),nudge_y = +3.0)+
geom_point(mapping = aes(x = Year, y = Average_Drive_Yards_t10), color = 'red')+
geom_text(size = 2.5, mapping =aes(x = Year, y = Average_Drive_Yards_t10,label = paste0("T10 ", Average_Drive_Yards_t10," ")),nudge_y = +3.0)+
ylim(280,325)+
labs(title ="Average Drive Distance by Year (Yards)", subtitle ="PGA Players Avg VS PGA top 10 Drivers Avg", caption = "Data courtesy PGA Tour.com and espn.com")+
scale_x_discrete(guide = guide_axis(n.dodge = 2))+
theme_light()
remove(distance_df, t10_distance_df)
# all player average greens in regulation df
gir_df<- pga_data %>%
select(gir, date) %>%
group_by(Year = date) %>%
summarise (gir = mean (gir,2))
# top 10 greens in regulation df
t10_gir_df<- t10_pga_data %>%
select(gir, date) %>%
group_by(Year = date) %>%
summarise (t10_gir = mean (gir,2))
gir_df$Year <- paste0(" ", gir_df$Year)
t10_gir_df$Year <- paste0(" ", t10_gir_df$Year)
merged_gir<-merge(gir_df, t10_gir_df)
merged_gir$gir<-formattable(merged_gir$gir,format="f",digits=1)
merged_gir$t10_gir<- formattable(merged_gir$t10_gir, format = "f", digits =1)
# plot of average greens in regulation of top 10 drivers and all player average greens in regulation
ggplot(data = merged_gir)+
geom_point(mapping = aes(x = Year, y = gir), color = 'blue')+
geom_text(size = 2.5, mapping =aes(x = Year, y = gir,label = paste0(" ", gir," ")),nudge_y = -2.0)+ geom_point(mapping = aes(x = Year, y = t10_gir), color = 'red')+
geom_text(size = 2.5, mapping =aes(x = Year, y = t10_gir,label = paste0("T10 ", t10_gir," ")),nudge_y = +2.0)+
ylim(50,75)+
labs(title ="Greens in Regulation by Year (%)",subtitle ="PGA Players Avg VS PGA top 10 GIR Avg", caption ="Data courtesy PGA Tour.com and espn.com")+
scale_x_discrete(guide = guide_axis(n.dodge = 2))+
theme_light()
remove(t10_gir_df, gir_df)
# all player average putts df
putts<- pga_data %>%
select(avg_putts, date) %>%
group_by(Year = date) %>%
reframe(putts = mean(avg_putts))
# top 10 average putts df
t10_putts<- t10_pga_data %>%
select(avg_putts, date) %>%
group_by(Year = date) %>%
summarise (t10_putts = mean (avg_putts))
putts$Year <- paste0(" ", putts$Year)
t10_putts$Year <- paste0(" ", t10_putts$Year)
merged_putts<-merge(putts, t10_putts)
merged_putts$putts<-formattable(merged_putts$putts,format="f",digits=2)
merged_putts$t10_putts<- formattable(merged_putts$t10_putts, format = "f", digits =2)
# plot of average putts per hole of top 10 drivers and all player average player
ggplot(data = merged_putts)+
geom_point(mapping = aes(x = Year, y = putts), color = 'blue')+
geom_text(size = 2.5, mapping =aes(x = Year, y = putts,label = paste0(" ", putts," ")),nudge_y = -0.03)+ geom_point(mapping = aes(x = Year, y = t10_putts), color = 'red')+
geom_text(size = 2.5, mapping =aes(x = Year, y = t10_putts,label = paste0("T10 ", t10_putts," ")),nudge_y =+0.03)+
ylim(1.7,1.85)+
labs(title ="Average Number of Putts by Year (%)",subtitle ="PGA Players Avg VS PGA top 10 Number of Putts", caption = "Data courtesy PGA Tour.com and espn.com")+ scale_x_discrete(guide = guide_axis(n.dodge = 2))+
theme_light()
remove(putts, t10_putts)
# all player average score df
allscore<- pga_data %>%
select(avg_score, date) %>%
group_by(Year = date) %>%
summarise (score = mean (avg_score,2))
# top 10 score df
t10_score<- t10_pga_data %>%
select(avg_score, date) %>%
group_by(Year = date) %>%
summarise (t10_score = mean (avg_score,2))
allscore$Year <- paste0(" ", allscore$Year)
t10_score$Year <- paste0(" ", t10_score$Year)
merged_score<-merge(allscore, t10_score)
merged_score$score<-formattable(merged_score$score,format="f",digits=1)
merged_score$t10_score<- formattable(merged_score$t10_score, format = "f", digits =1)
# plot of average score of top 10 drivers and all player average score
ggplot(data = merged_score)+
geom_point(mapping = aes(x = Year, y = score), color = 'blue')+
geom_text(size = 2.5, mapping =aes(x = Year, y = score,label = paste0(" ", score," ")),nudge_y = -0.7)+ geom_point(mapping = aes(x = Year, y = t10_score), color = 'red')+
geom_text(size = 2.5, mapping =aes(x = Year, y = t10_score,label = paste0("T10 ", t10_score," ")),nudge_y = 0.7)+
ylim(69,72)+
labs(title ="Average Score by Year",subtitle = "PGA Players Avg VS PGA top 10 Score", caption = "Data courtesy PGA Tour.com and espn.com")+
scale_x_discrete(guide = guide_axis(n.dodge = 2))+
theme_light()
remove(allscore, t10_score)
# pga official winnings data edit
pga_data<- pga_data %>%
mutate_if(~any(str_detect(., '^\\$'), na.rm = FALSE), ~as.numeric(str_replace_all(., '[$,]', '')))
# pga official winnings df
money<- pga_data %>%
select(official_winnings, date) %>%
group_by(Year = date) %>%
summarise (official_winnings = round(mean(official_winnings/1000000),5))
# t10 data edit
t10_pga_data<-t10_pga_data %>%
mutate_if(~any(str_detect(., '^\\$'), na.rm = FALSE), ~as.numeric(str_replace_all(., '[$,]', '')))
# top 10 official winnings df
t10_money<- t10_pga_data %>%
select(official_winnings, date) %>%
group_by(Year = date) %>%
summarise (official_winnings_t10 = round(mean(official_winnings/1000000),5))
money$Year <- paste0(" ", money$Year)
t10_money$Year <- paste0(" ", t10_money$Year)
merged_money<-merge(money, t10_money)
merged_money$official_winnings<-formattable(merged_money$official_winnings,format="f",digits=2)
merged_money$official_winnings_t10<-formattable(merged_money$official_winnings_t10,format="f",digits=2)
# plot of average earnings of top 10 drivers and all player average drive
ggplot(data = merged_money)+
geom_point(mapping = aes(x = Year, y = official_winnings), color = 'blue')+
geom_text(size = 2.5, check_overlap = TRUE, mapping = aes(x = Year, y = official_winnings,label = paste0(" ",
official_winnings," ")), nudge_y = -.4)+
geom_point(mapping = aes(x = Year, y = official_winnings_t10), color = 'red')+
geom_text(size = 2.5, check_overlap = TRUE, mapping = aes(x = Year, y = official_winnings_t10,label =
paste0("T10 $ ", official_winnings_t10,"")),nudge_y = .4)+
labs(title ="Average Winnings by Year", subtitle = "PGA Players Avg VS PGA top 10 Avg Winnings (Millions $)",
caption = "Data courtesy PGA Tour.com and espn.com")+
ylab("Average Total Winnings")+
ylim(0,4.5)+
scale_x_discrete(guide = guide_axis(n.dodge = 2))+
theme_light()
remove(money, t10_money)
# df for average Greens in Regulation vs average distance
dvsg<- cbind(merged_distance,merged_gir)
dvsg_df<- right_join(merged_distance, merged_gir, by = join_by(Year))
dvsg_df$Year <- ymd(dvsg_df$Year)
remove(dvsg)
| | ##### Set plots for Drive/ Greens in Regulation comparison and plot
together.
# upper plot for average distance
p1<-ggplot(dvsg_df) +
geom_point(aes(x = Year, y = Average_Drive_Yards, color = "Average_Drive_Yards")) +
geom_point(aes(x = Year, y = Average_Drive_Yards_t10, color = "Average_Drive_Yards_t10"))+ scale_color_manual(name = 'Avg Drive', breaks = c('Average_Drive_Yards', 'Average_Drive_Yards_t10'), values = c('blue', 'red'))+
labs(title = "Average Drive Distance (Yards)", subtitle = "PGA Players Avg VS PGA top 10 Avg Drive")+ ylab("Yards")+
ylim(285,325)+
theme(plot.background = element_rect(fill = 'lightgreen'))
# lower plot for average Greens in Regulation
p2<-ggplot(dvsg_df)+
geom_point(aes(x = Year, y = gir, color = "gir"))+
geom_point(aes(x = Year, y = t10_gir, color = "t10_gir"))+ scale_color_manual(name='GIR', breaks=c('gir', 't10_gir'), values=c('blue', 'red'))+
labs(title = "Average Greens in Regulation by Year", subtitle = "PGA Players Avg VS PGA top 10 Avg GIR ( % )", caption = "Data courtesy PGA Tour.com and espn.com")+
ylab("GIR %")+ ylim(55,70)+
theme(plot.background = element_rect(fill = 'lightgreen'))
grid.arrange(p1,p2, nrow = 2)
remove(p1,p2,dvsg_df)
# df for average putts vs average drive
dvsp<- cbind(merged_distance,merged_putts)
dvsp_df<- right_join(merged_distance, merged_putts, by = join_by(Year))
dvsp_df$Year <- ymd(dvsp_df$Year)
remove(dvsp)
# upper plot of average distance
p3<-ggplot(dvsp_df) +
geom_point(aes(x = Year, y = Average_Drive_Yards, color = "Average_Drive_Yards")) +
geom_point(aes(x = Year, y = Average_Drive_Yards_t10, color = "Average_Drive_Yards_t10"))+
scale_color_manual(name = 'Avg Drive', breaks = c('Average_Drive_Yards', 'Average_Drive_Yards_t10'),
values= c('blue', 'red'))+
labs(title = "Average Drive Distance (Yards)", subtitle = "PGA Players Avg VS PGA top 10 Avg Drive")+
ylab("Yards")+
ylim(285,325)+
theme(plot.background = element_rect(fill = 'lightgreen'))
# lower plot of average putts
p4<-ggplot(dvsp_df)+
geom_point(aes(x = Year, y = putts, color = "putts"))+
geom_point(aes(x = Year, y = t10_putts, color = "t10_putts"))+
scale_color_manual(name='Putts', breaks=c('putts', 't10_putts'), values=c('blue', 'red'))+
labs(title = "Average putts by Year", subtitle = "PGA Players Avg VS PGA top 10 Avg putts ( # )", caption = "Data courtesy PGA Tour.com and espn.com")+
ylab("Putts #")+
ylim(1.75,1.85)+
theme(plot.background = element_rect(fill = 'lightgreen'))
grid.arrange(p3,p4, nrow = 2)
remove(p3,p4,dvsp_df)
# df for average drive and score plot
dvss<- cbind(merged_distance,merged_score)
dvss_df<- right_join(merged_distance, merged_score, by = join_by(Year))
dvss_df$Year <- ymd(dvss_df$Year)
class(dvss_df$Year)
## [1] "Date"
remove(dvss)
# upper plot of Average distance
p5<-ggplot(dvss_df) +
geom_point(aes(x = Year, y = Average_Drive_Yards, color = "Average_Drive_Yards")) +
geom_point(aes(x = Year, y = Average_Drive_Yards_t10, color = "Average_Drive_Yards_t10"))+ scale_color_manual(name = 'Avg Drive', breaks = c('Average_Drive_Yards', 'Average_Drive_Yards_t10'), values = c('blue', 'red'))+
labs(title = "Average Drive Distance (Yards)", subtitle = "PGA Players Avg VS PGA top 10 Avg Drive")+ ylab("Yards")+
ylim(285,325)+
theme(plot.background = element_rect(fill = 'lightgreen'))
# Lower plot of average score
p6<-ggplot(dvss_df)+
geom_point(aes(x = Year, y = score, color = "score"))+
geom_point(aes(x = Year, y = t10_score, color = "t10_score"))+
scale_color_manual(name = 'score', breaks = c('score', 't10_score'), values=c('blue', 'red'))+
labs(title = "Average score by Year", subtitle = "PGA Players Avg VS PGA top 10 Avg score", caption = "Data courtesy PGA Tour.com and espn.com")+
ylab("Score")+
ylim(69,72)+
theme(plot.background = element_rect(fill = 'lightgreen'))
grid.arrange(p5,p6, nrow = 2)
remove(p5,p6,dvss_df)
# df for Official winnings or Money and Drive Distance
dvsm<- cbind(merged_distance,merged_money)
dvsm_df<- right_join(merged_distance, merged_money, by = join_by(Year))
dvsm_df$Year <- ymd(dvsm_df$Year)
remove(dvsm)
# Upper plot of Average Drives
p7<-ggplot(dvsm_df) +
geom_point(aes(x = Year, y = Average_Drive_Yards), color = "blue") +
geom_point(aes(x = Year, y = Average_Drive_Yards_t10), color = "red")+ labs(title = "Average Drive distance (Yards)", subtitle = "PGA Players Avg VS PGA top 10 Avg Drive")+
ylab("Yards")+
ylim(285,325)+
theme(plot.background = element_rect(fill = 'lightgreen'))
# Lower plot of Official winnings
p8<-ggplot(dvsm_df)+
geom_point(aes(x = Year, y = official_winnings), color = "blue")+
geom_point(aes(x = Year, y = official_winnings_t10), color = "red")+
labs(title = "Average Winnings by Year", subtitle = "PGA Players Avg VS PGA top 10 Avg Winnings (Millions $)", caption = "Data courtesy PGA Tour.com and espn.com")+
ylab("Millions $")+
ylim(.8,4.3)+
theme(plot.background = element_rect(fill = 'lightgreen'))
grid.arrange(p7,p8, nrow = 2)
remove(p7,p8,dvsm_df)
# Distance vs Greens in Regulation df
dvgir<- merge(merged_distance, merged_gir)
dvgir$gir<- formattable(dvgir$gir, format = "f", digits = 1)
dvgir$t10_gir<- formattable(dvgir$t10_gir, format = "f", digits = 1)
dvgir$Year <- ymd(dvgir$Year)
dvgir$Year <- as.Date(dvgir$Year)
dvgir <- as.xts(dvgir [, -1], order.by = dvgir$Year)
# Distance vs Greens in Regulation Plot
gircor <- cor(dvgir, method = "spearman") # pearson was also run with virtually the same results
corrplot(gircor, type = "lower", tl.srt = 5, addCoef.col = "white", cex.main = .8)
dvgir<- title("Drive Distance vs GIR", cex.main = 1)
remove(dvgir, gircor)
# Distance vs Putts df
dvsp<- merge(merged_distance, merged_putts)
dvsp$putts<- formattable(dvsp$putts, format = "f", digits = 1)
dvsp$t10_putts<- formattable(dvsp$t10_putts, format = "f", digits = 1)
dvsp$Year <- ymd(dvsp$Year)
dvsp$Year <- as.Date(dvsp$Year)
dvsp <- as.xts(dvsp [, -1], order.by = dvsp$Year)
# Distance vs Putts plot
puttcor <- cor(dvsp, method = "spearman") # pearson was also run with virtually the same results
corrplot(puttcor, type = "lower", tl.srt = 5, addCoef.col = "white", cex.main = .8)
dvsp<-title("Drive distance vs Putts", cex.main = 1)
remove(dvsp, puttcor)
# Distance vs Score df
dvss<- merge(merged_distance, merged_score)
dvss$score<- formattable(dvss$score, format = "f", digits = 1)
dvss$t10_score<- formattable(dvss$t10_score, format = "f", digits = 1)
dvss$Year <- ymd(dvss$Year)
dvss$Year <- as.Date(dvss$Year)
dvss <- as.xts(dvss [, -1], order.by = dvss$Year)
# Distance vs Score plot
scorcor <- cor(dvss, method = "spearman") # pearson was also run with virtually the same results
corrplot(scorcor, type = "lower", tl.srt = 5, addCoef.col = "white", cex.main = .8)
dvss<-title (" Drive Distance vs Score", cex.main = 1)
######Clean environment
remove(dvss, scorcor)
# Distance vs Earnings df
dvsmo<- merge(merged_distance, merged_money)
dvsmo$official_winnings<- formattable(dvsmo$official_winnings, format = "f", digits = 1)
dvsmo$official_winnings_t10<- formattable(dvsmo$official_winnings_t10, format = "f", digits = 1)
dvsmo$Year <- ymd(dvsmo$Year)
dvsmo$Year <- as.Date(dvsmo$Year)
dvsmo <- as.xts(dvsmo [, -1], order.by = dvsmo$Year)
# Distance vs Earnings data plot
moncor <- cor(dvsmo, method = "spearman") # pearson was also run with virtually the same results
corrplot(moncor, type = "lower", tl.srt = 5, addCoef.col = "white", cex.main = .8)
dvsmo<-title("Drive Distance vs Earnings", cex.main = 1)
# All PGA correlation plot and df
allpga<- pga_data %>%
select(avg_drive, gir, avg_putts, avg_score, official_winnings,date) %>%
group_by(Year = date)
allpga<-allpga[,-6]
allpga$gir<- formattable(allpga$gir, format = "f", digits = 1)
allpga$avg_putts<- formattable(allpga$avg_putts, format = "f", digits = 1)
allpga$avg_score<- formattable(allpga$avg_score, format = "f", digits = 1)
allpga$official_winnings<- formattable(allpga$official_winnings, format = "f", digits = 2)
allpga$avg_drive<- formattable(allpga$avg_drive, format = "f", digits = 1)
allpga$Year <- ymd(allpga$Year)
allpga$Year <- as.Date(allpga$Year)
allpga <- as.xts(allpga [, -6], order.by = allpga$Year)
allcor <- cor(allpga, method = "spearman") # pearson was also run with virtually the same results
corrplot(allcor, type = "lower", tl.srt = 5, addCoef.col = "black")
allpga<- title (
"Correlations,
All Player Averages from 2010 to 2022", cex.main = 1)
# Top 10 correlation plot and df
t10pga<- t10_pga_data %>%
select(avg_drive, gir, avg_putts, avg_score, official_winnings,date) %>%
group_by(Year = date)
t10pga<-t10pga[,-6]
t10pga$gir<- formattable(t10pga$gir, format = "f", digits = 1)
t10pga$avg_putts<- formattable(t10pga$avg_putts, format = "f", digits = 1)
t10pga$avg_score<- formattable(t10pga$avg_score, format = "f", digits = 1)
t10pga$official_winnings<- formattable(t10pga$official_winnings, format = "f", digits = 2)
t10pga$avg_drive<- formattable(t10pga$avg_drive, format = "f", digits = 1)
t10pga$Year <- ymd(t10pga$Year)
t10pga$Year <- as.Date(t10pga$Year)
t10pga <- as.xts(t10pga [, -6], order.by = t10pga$Year)
t10cor <- cor(t10pga, method = "spearman") # pearson was also run with virtually the same results
corrplot(t10cor, type = "lower", tl.srt = 5, addCoef.col = "black")
t10pga<- title(
"Correlations,
Top 10 Player Averages from 2010 to 2022", cex.main = 1)
# Final data frames for plotting
t10pga<- t10_pga_data %>%
select(t10drive = avg_drive, t10gir = gir, t10putts = avg_putts, t10score = avg_score, t10money = official_winnings,date) %>%
group_by(Year = date)
t10pga<- t10pga[, -6]
t10pga$Year <- ymd(t10pga$Year)
allpga<- pga_data %>%
select(avg_drive, gir, avg_putts, avg_score, official_winnings,date) %>%
group_by(Year = date)
allpga<- allpga[,-6]
allpga$Year <- ymd(allpga$Year)
# Final plot to discuss an solidify findings with correlations
t10pga$t10gir<- formattable(t10pga$t10gir, format = "f", digits = 1)
t10pga$t10putts<- formattable(t10pga$t10putts, format = "f", digits = 1)
t10pga$t10score<- formattable(t10pga$t10score, format = "f", digits = 1)
t10pga$t10money<- formattable(t10pga$t10money, format = "f", digits = 2)
t10pga$t10drive<- formattable(t10pga$t10drive, format = "f", digits = 1)
allpga$gir<- formattable(allpga$gir, format = "f", digits = 1)
allpga$avg_putts<- formattable(allpga$avg_putts, format = "f", digits = 1)
allpga$avg_score<- formattable(allpga$avg_score, format = "f", digits = 1)
allpga$official_winnings<- formattable(allpga$official_winnings, format = "f", digits = 2)
allpga$avg_drive<- formattable(allpga$avg_drive, format = "f", digits = 1)
final1<- merge(allpga, t10pga)
final1$official_winnings<- formattable(final1$official_winnings, format = "f", digits = 1)
final1$t10money<- formattable(final1$t10money, format = "f", digits = 1)
final1$Year <- ymd(final1$Year)
final1$Year <- as.Date(final1$Year)
final1 <- as.xts(final1 [, -1], order.by = final1$Year)
final1 <- cor(final1, method = "spearman") # pearson was also run with virtually the same results
corrplot(final1, type = "lower", cl.ratio = .1, tl.srt = 5, addCoef.col = "black", number.cex = 0.8)
final1<- title(
" Final Correlations. ,
Top 10 and all Player Averages from 2010 to 2022", cex.main = 1, outer = FALSE)
# Final clean of environment
remove(pga_data, t10_pga_data, merged_distance, merged_gir, merged_putts, merged_score, merged_money, allcor, allpga, t10cor, t10pga, final1)