Spaces:
Sleeping
Sleeping
| library(shiny) | |
| library(plotly) | |
| library(gridlayout) | |
| library(bslib) | |
| library(DT) | |
| library(rsconnect) | |
| library(baseballr) | |
| library(dplyr) | |
| library(tidyverse) | |
| library(rvest) | |
| library(ggplot2) | |
| library(janitor) | |
| library(ggthemes) | |
| library(ggpubr) | |
| library(jsonlite) | |
| library(utils) | |
| library(grid) | |
| library(gridExtra) | |
| library(png) | |
| pdf(file = NULL) | |
| Sys.setenv(TZ='EST') | |
| is_barrel <- function(df) { | |
| df$barrel <- with(df, ifelse(hit_angle <= 50 & hit_speed >= 97 & hit_speed * 1.5 - | |
| hit_angle >= 117 & hit_speed + hit_angle >= 123, 1, 0)) | |
| return(df) | |
| } | |
| VAA <- function(milbtotal){ | |
| milbtotal <- milbtotal |> | |
| mutate(VAA = -atan((vz0+(az*(-sqrt((vy0*vy0)-(2*ay*(y0-(17/12))))-vy0)/ | |
| ay))/(-sqrt((vy0*vy0)-(2*ay*(y0-(17/12))))))*(180/pi)) | |
| } | |
| pitcher_summary <- function(game_pk,date){ | |
| gdate <- as.Date.character(date) | |
| gdate <- as.Date(gdate) | |
| tmilb <- mlb_pbp(game_pk) | |
| tmilb <- tmilb |> | |
| filter(type == "pitch") | |
| tmilb <- tmilb |> | |
| select(matchup.batter.fullName,matchup.batter.id,matchup.pitcher.fullName, | |
| matchup.pitcher.id,result.event,details.description,details.type.description, | |
| result.description,pitchData.startSpeed, | |
| pitchData.plateTime,pitchData.zone,pitchData.breaks.spinRate,pitchData.extension, | |
| pitchData.coordinates.pX,pitchData.coordinates.pZ,pitchData.coordinates.x0, | |
| pitchData.coordinates.y0,pitchData.coordinates.z0,pitchData.coordinates.aX, | |
| pitchData.coordinates.aY,pitchData.coordinates.aZ,pitchData.coordinates.vX0, | |
| pitchData.coordinates.vZ0,pitchData.coordinates.vY0,pitchData.coordinates.pfxX, | |
| pitchData.coordinates.pfxZ,pitchData.breaks.breakVerticalInduced,pitchData.breaks.breakHorizontal, | |
| hitData.launchSpeed,hitData.launchAngle,hitData.totalDistance,details.isInPlay,last.pitch.of.ab) | |
| colnames(tmilb) <- c("Batter Name","Batter ID","Pitcher Name","Pitcher ID", | |
| "result","description","pitch_name", | |
| "des","start_speed","plateTime","zone","spin_rate", | |
| "extension","px","pz","x0","y0","z0","ax","ay","az", | |
| "vx0","vz0","vy0","pfxX","pfxZ","IVB","HB","hit_speed", | |
| "hit_angle","hit_distance","inPlay","lastPitch") | |
| tmilb <- is_barrel(tmilb) | |
| tmilb <- tmilb |> | |
| mutate(is_strike_swinging = ifelse(description == "Swinging Strike" | | |
| description == "Foul Tip",TRUE,FALSE)) | |
| tmilb <- tmilb |> | |
| mutate(date = gdate) | |
| return(tmilb) | |
| } | |
| break_plot <- function(game){ | |
| ggplot()+ | |
| geom_point(game,mapping = | |
| aes(x=HB, y = IVB,color = pitch_name),size = 4) + | |
| geom_vline(xintercept = 0, color = "lightblue",linewidth = 1,linetype = 4)+ | |
| geom_hline(yintercept = 0, color = "lightblue",linewidth = 1,linetype = 4)+ | |
| xlab("Horizontal Break from Pitcher's Perspective (in) ")+ | |
| ylab("Induced Verical Break (in)") + | |
| xlim(-25,25) + | |
| ylim(-25,25) + | |
| ggthemes::theme_igray()+ | |
| theme(panel.grid.minor = element_line(color = "gray", | |
| size = 0.25, | |
| linetype = 1))+ | |
| guides(color = guide_legend(title = "Pitch Type")) | |
| } | |
| pitch_plot <- function(game){ | |
| ggplot()+ | |
| geom_point(game,mapping = | |
| aes(x=px, y = pz,color = pitch_name),size = 3.5) + | |
| geom_segment(aes(x=-0.71,xend = 0.71, y = 1.5,yend = 1.5))+ | |
| geom_segment(aes(x=-0.71,xend = 0.71, y = 3.6,yend = 3.6))+ | |
| geom_segment(aes(x= 0.71,xend = 0.71, y = 1.5,yend = 3.6))+ | |
| geom_segment(aes(x=-0.71,xend = -0.71, y = 1.5,yend =3.6))+ | |
| xlab(" ")+ | |
| ylab(" ") + | |
| xlim(-3,3)+ | |
| ylim(0.2,4)+ | |
| coord_fixed(ratio = 1) + | |
| ggthemes::theme_few()+ | |
| guides(color = guide_legend(title = "Pitch Type"))+ | |
| theme(axis.text.x=element_blank(), | |
| axis.ticks.x=element_blank(), | |
| axis.text.y=element_blank(), | |
| axis.ticks.y=element_blank()) | |
| } | |
| summary_table <- function(game){ | |
| rows <- nrow(game) | |
| sumtable <- game |> | |
| mutate(VAA = -atan((vz0+(az*(-sqrt((vy0*vy0)-(2*ay*(y0-(17/12))))-vy0)/ | |
| ay))/(-sqrt((vy0*vy0)-(2*ay*(y0-(17/12))))))*(180/pi)) |> | |
| mutate(team_fielding_id = ifelse(description == "Called Strike" | | |
| description == "Swinging Strike" | | |
| description == "Swinging Strike (Blocked)",1,0))|> | |
| mutate(swing = ifelse(description == "Foul" | | |
| description == "Foul Pitchout" | | |
| description == "In play, no out" | | |
| description == "In play, out(s)" | | |
| description == "In play, run(s)" | | |
| description == "Swinging Strike" | | |
| description == "swinging Strike (Blocked)" | | |
| description == "Foul Tip",1,0)) |> | |
| mutate(is_strike_swinging = ifelse(is_strike_swinging == TRUE,1,0)) |> | |
| mutate(Pitch = pitch_name) |> | |
| group_by(Pitch)|> | |
| summarize(Pitches = n(), | |
| 'Pitch%' = round(sum(Pitches)/sum(rows) * 100,digits = 1), | |
| 'Avg. Velo' = round(sum(start_speed)/Pitches,digits = 1), | |
| 'Spin Rate' = round(sum(spin_rate)/ Pitches,digits = 1), | |
| 'Extension' = round(mean(extension,na.rm = TRUE),digits = 1), | |
| 'IVB' = round(mean(IVB,na.rm=TRUE),digits = 1), | |
| 'HB' = round(mean(HB,na.rm = TRUE),digits = 1), | |
| 'VAA' = round(mean(VAA,na.rm= TRUE),digits = 1), | |
| 'CSW%' = round(sum(team_fielding_id)/ | |
| sum(!is.na(team_fielding_id))*100,digits = 1), | |
| 'Whiff%' = round(sum(is_strike_swinging)/ | |
| sum(swing)*100,digits = 1))|> | |
| arrange(-Pitches) | |
| } | |
| mlbid <- mlb_schedule(season = 2024, level_ids = "1") | |
| mlbteamH <- mlbid |> | |
| select(teams_home_team_name) | |
| mlbteamH <- distinct(mlbteamH) | |
| mlbteamA <- mlbid |> | |
| select(teams_away_team_name) | |
| mlbteamA <- distinct(mlbteamA) | |
| aaaid <- mlb_schedule(season = 2024, level_ids = "11") | |
| aaateamH <- aaaid |> | |
| select(teams_home_team_name) | |
| aaateamH <- distinct(aaateamH) | |
| aaateamA <- aaaid |> | |
| select(teams_away_team_name) | |
| aaateamA <- distinct(aaateamA) | |
| fslid <- mlb_schedule(season = 2024, level_ids = "14") | |
| fslid <- fslid |> | |
| filter(teams_home_team_name == "Daytona Tortugas" | | |
| teams_home_team_name == "Jupiter Hammerheads" | | |
| teams_home_team_name == "Palm Beach Cardinals" | | |
| teams_home_team_name == "St. Lucie Mets" | | |
| teams_home_team_name == "Bradenton Marauders" | | |
| teams_home_team_name == "Clearwater Threshers" | | |
| teams_home_team_name == "Dunedin Blue Jays" | | |
| teams_home_team_name == "Fort Myers Mighty Mussels" | | |
| teams_home_team_name == "Lakeland Flying Tigers" | | |
| teams_home_team_name == "Tampa Tarpons") | |
| fslteamH <- fslid |> | |
| select(teams_home_team_name) | |
| fslteamH <- distinct(fslteamH) | |
| fslteamA <- fslid |> | |
| select(teams_away_team_name) | |
| fslteamA <- distinct(fslteamA) | |
| sbid <- mlb_schedule(season = 2024, level_ids = "22") | |
| sbteamH <- sbid |> | |
| select(teams_home_team_name) | |
| sbteamH <- distinct(sbteamH) | |
| sbteamA <- sbid |> | |
| select(teams_away_team_name) | |
| sbteamA <- distinct(sbteamA) | |
| ui <- fluidPage( | |
| tags$head( | |
| tags$style(HTML(" | |
| @media (max-width: 768px) { | |
| .sidebar { width: 100%; float: none; } | |
| .main-content { margin-left: 0; } | |
| .selectize-input { font-size: 14px; } | |
| .form-group { margin-bottom: 10px; } | |
| .action-button { width: 100%; } | |
| } | |
| ")) | |
| ), | |
| titlePanel("2024 MLB/AAA/FSL Summary Cards"), | |
| sidebarLayout( | |
| sidebarPanel( | |
| width = 2, | |
| dateInput("date", "Date:"), | |
| selectizeInput("level", "Level:", c("MLB", "AAA", "FSL", "College (Statcast Parks Only)")), | |
| selectizeInput("homeT", "Home Team:", mlbteamH[,1]), | |
| selectizeInput("awayT", "Away Team:", mlbteamA[,1]), | |
| selectizeInput("gamenum", "Game Number (For Doubleheaders):", c("1", "2")), | |
| actionButton("update", "Find Pitcher", icon("magnifying-glass"), | |
| style = "color: #FFFFFF; background-color: #0077B6; width: 100%;"), | |
| selectizeInput("pitcher", "Pitcher Name:", c(" ")), | |
| selectizeInput("league", "MLB or MiLB Photo", c("MLB", "MiLB")), | |
| textInput("title", "Card Title"), | |
| actionButton("update1", "Make Card", icon("plus"), | |
| style = "color: #FFFFFF; background-color: #0077B6; width: 100%;"), | |
| downloadButton("downloadPlot", "Download Card") | |
| ), | |
| mainPanel( | |
| plotOutput("combinedPlot", height = "900px",width = "1350px") | |
| ) | |
| ) | |
| ) | |
| server <- function(input, output, session) { | |
| observeEvent(input$level, { | |
| if(input$level == "AAA"){ | |
| updateSelectizeInput(session = getDefaultReactiveDomain(),"homeT","Home Team:",choices = aaateamH[,1]) | |
| updateSelectizeInput(session = getDefaultReactiveDomain(),"awayT","Away Team:",choices = aaateamA[,1]) | |
| } | |
| if(input$level == "FSL"){ | |
| updateSelectizeInput(session = getDefaultReactiveDomain(),"homeT","Home Team:",choices = fslteamH[,1]) | |
| updateSelectizeInput(session = getDefaultReactiveDomain(),"awayT","Away Team:",choices = fslteamA[,1]) | |
| } | |
| if(input$level == "MLB"){ | |
| updateSelectizeInput(session = getDefaultReactiveDomain(),"homeT","Home Team:",choices = mlbteamH[,1]) | |
| updateSelectizeInput(session = getDefaultReactiveDomain(),"awayT","Away Team:",choices = mlbteamA[,1]) | |
| } | |
| if(input$level == "College (Statcast Parks Only)"){ | |
| updateSelectizeInput(session = getDefaultReactiveDomain(),"homeT","Home Team:",choices = sbteamH[,1]) | |
| updateSelectizeInput(session = getDefaultReactiveDomain(),"awayT","Away Team:",choices = sbteamA[,1]) | |
| } | |
| }) | |
| observeEvent(input$update, { | |
| if(input$level == "AAA"){ | |
| pname <- aaaid |> | |
| filter(date == input$date) |> | |
| filter(teams_home_team_name == input$homeT) |> | |
| filter(teams_away_team_name == input$awayT) |> | |
| filter(game_number == input$gamenum) | |
| pname <- tryCatch({pitcher_summary(pname[,6],input$date)},error=function(e){cat("ERROR :",conditionMessage(e), "\n")}) | |
| updateSelectizeInput(session = getDefaultReactiveDomain(),"pitcher","Pitcher:",choices = pname[,3]) | |
| } | |
| if(input$level == "FSL"){ | |
| pname <- fslid |> | |
| filter(date == input$date) |> | |
| filter(teams_home_team_name == input$homeT) |> | |
| filter(teams_away_team_name == input$awayT) |> | |
| filter(game_number == input$gamenum) | |
| pname <- tryCatch({pitcher_summary(pname[,6],input$date)},error=function(e){cat("ERROR :",conditionMessage(e), "\n")}) | |
| updateSelectizeInput(session = getDefaultReactiveDomain(),"pitcher","Pitcher:",choices = pname[,3]) | |
| } | |
| if(input$level == "MLB"){ | |
| pname <- mlbid |> | |
| filter(date == as.character.Date(input$date)) |> | |
| filter(teams_home_team_name == input$homeT) |> | |
| filter(teams_away_team_name == input$awayT) |> | |
| filter(game_number == input$gamenum) | |
| pname <- tryCatch({pitcher_summary(pname[,6],input$date)},error=function(e){cat("ERROR :",conditionMessage(e), "\n")}) | |
| updateSelectizeInput(session = getDefaultReactiveDomain(),"pitcher","Pitcher:",choices = pname[,3]) | |
| } | |
| if(input$level == "College (Statcast Parks Only)"){ | |
| pname <- sbid |> | |
| filter(date == input$date) |> | |
| filter(teams_home_team_name == input$homeT) |> | |
| filter(teams_away_team_name == input$awayT) |> | |
| filter(game_number == input$gamenum) | |
| pname <- tryCatch({pitcher_summary(pname[,6],input$date)},error=function(e){cat("ERROR :",conditionMessage(e), "\n")}) | |
| updateSelectizeInput(session = getDefaultReactiveDomain(),"pitcher","Pitcher:",choices = pname[,3]) | |
| } | |
| }) | |
| combinedPlot <- reactiveVal() | |
| observeEvent(input$update1, { | |
| if(input$level == "MLB"){ | |
| id <- mlbid |> | |
| filter(date == as.character.Date(input$date)) |> | |
| filter(teams_home_team_name == input$homeT) |> | |
| filter(teams_away_team_name == input$awayT) |> | |
| filter(game_number == input$gamenum) | |
| game <- tryCatch({pitcher_summary(id[,6],input$date)},error=function(e){cat("ERROR :",conditionMessage(e), "\n")}) | |
| game <- game |> | |
| filter(`Pitcher Name` == input$pitcher) | |
| id <- as.character(game[1,4]) | |
| } | |
| if(input$level == "FSL"){ | |
| id <- fslid |> | |
| filter(date == as.character.Date(input$date)) |> | |
| filter(teams_home_team_name == input$homeT) |> | |
| filter(teams_away_team_name == input$awayT) |> | |
| filter(game_number == input$gamenum) | |
| game <- tryCatch({pitcher_summary(id[,6],input$date)},error=function(e){cat("ERROR :",conditionMessage(e), "\n")}) | |
| game <- game |> | |
| filter(`Pitcher Name` == input$pitcher) | |
| id <- as.character(game[1,4]) | |
| } | |
| if(input$level == "AAA"){ | |
| id <- aaaid |> | |
| filter(date == as.character.Date(input$date)) |> | |
| filter(teams_home_team_name == input$homeT) |> | |
| filter(teams_away_team_name == input$awayT) |> | |
| filter(game_number == input$gamenum) | |
| game <- tryCatch({pitcher_summary(id[,6],input$date)},error=function(e){cat("ERROR :",conditionMessage(e), "\n")}) | |
| game <- game |> | |
| filter(`Pitcher Name` == input$pitcher) | |
| id <- as.character(game[1,4]) | |
| } | |
| if(input$level == "College (Statcast Parks Only)"){ | |
| id <- sbid |> | |
| filter(date == as.character.Date(input$date)) |> | |
| filter(teams_home_team_name == input$homeT) |> | |
| filter(teams_away_team_name == input$awayT) |> | |
| filter(game_number == input$gamenum) | |
| game <- tryCatch({pitcher_summary(id[,6],input$date)},error=function(e){cat("ERROR :",conditionMessage(e), "\n")}) | |
| game <- game |> | |
| filter(`Pitcher Name` == input$pitcher) | |
| id <- as.character(game[1,4]) | |
| } | |
| break_plot <- break_plot(game) | |
| pitch_plot <- pitch_plot(game) | |
| # Create table plot | |
| table_plot <- tableGrob(summary_table(game),theme = ttheme_default( | |
| core = list(fg_params = list(cex = 1.5)), # Increase text size | |
| colhead = list(fg_params = list(cex = 1.5)), | |
| rowhead = list(fg_params = list(cex = 2.5)))) | |
| table_plot$widths[[1]] <- unit(0, "cm") | |
| # Find the text grobs in the first column | |
| text_grobs <- which(sapply(table_plot$grobs, function(g) { | |
| g$name == "core-fg-1" && inherits(g$children[[1]], "text") | |
| })) | |
| # Remove the numbers from these text grobs | |
| for (i in text_grobs) { | |
| text <- table_plot$grobs[[i]]$children[[1]]$label | |
| table_plot$grobs[[i]]$children[[1]]$label <- sub("^\\d+\\s*", "", text) | |
| } | |
| # Draw the modified table | |
| grid.newpage() | |
| grid.draw(table_plot) | |
| # Download and process image | |
| if(input$league == "MLB"){ | |
| y <- paste("https://midfield.mlbstatic.com/v1/people/","/mlb/300?circle=false",sep = id) | |
| } else { | |
| y <- paste("https://midfield.mlbstatic.com/v1/people/","/milb/300?circle=false",sep = id) | |
| } | |
| photo <- tempfile() | |
| download.file(y, photo, mode = 'wb') | |
| img <- readPNG(photo) | |
| img_grob <- rasterGrob(img, interpolate = TRUE) | |
| # Combine all elements into one plot | |
| combined <- grid.arrange( | |
| arrangeGrob(table_plot, img_grob, ncol = 2, widths = c(2/3, 1/3)), | |
| arrangeGrob(break_plot, pitch_plot, ncol = 2), | |
| nrow = 2, | |
| top = textGrob(paste(input$title, "Made by @TimStats", sep = " "), gp = gpar(fontsize = 20, font = 2)) | |
| ) | |
| combinedPlot(combined) | |
| output$combinedPlot <- renderPlot({ | |
| grid.draw(combinedPlot()) | |
| }) | |
| }) | |
| output$downloadPlot <- downloadHandler( | |
| filename = function() { | |
| paste("baseball_card_", Sys.Date(), ".png", sep = "") | |
| }, | |
| content = function(file) { | |
| ggsave(file, plot = combinedPlot(), width = 18, height = 12, dpi = 300) | |
| } | |
| ) | |
| } | |
| shinyApp(ui, server) |