Hello! I was wondering if anyone could suggest some simple ways to get a txt file created using bevent into a database…I used bevent to print the pitch sequence and pitcher for each at bat…I was gonna import it into excel and use the len function to count the length of each pitch sequence (which would give me a list of pitcher and number pitches for each at bat) and then load it into my database and use sqlyog to sum pitches by pitcher id…I guess I am wondering if there is a way to just import the txt as a table into sql, and sum the pitches by pitcher id? Hope I explained my question almost clearly…sorry otherwise!
Probably more than you bargained for, but I finally wrote out a Retrosheet tutorial.
oh man, I was really hoping you might write a tutorial exactly like this at! thank you so much!
could anyone help me parse the pitch sequence strings? i'd like to remove all pickoff throws from the strings, and my best effort was gonna be to use the replace function to delete them essentially, but i was wondering if someone knows a way to pull the characters that represent pitches out of the string and into a new column (is that possible?) any ideas, as always, are greatly appreciated, have an awesome day!