A French user you know very well bought supporter for me without saying anything, so I might try to complete my code before it expires and we can have a look at some stuff. He's also interested in the same table I posted but for specific tactics.
My file currently has 2 problems:
1) I can easily extract the games list and all the other info from the BBApi and I extract all the boxscores like that to double check that my number from the pbp are correct. However, downloading the pbp for, say, 176 games (1 season for 1 league, but could be easily more) is another thing altogether, because the website logs me out at regular intervals and I'm not skilled enough in dealing with internet explorer through VBA to understand how to fix it, so I worked around it but I need to clean it up.
2) All the output part is not done. I was going to make tables like advanced stats, regular stats, stats /36, defensive stats and shooting stats by league/team/player. I couldn't be bothered to spend the time to build that up, but maybe I will do the advanced stats, shooting and defense now. I'm open to suggestions about what to implement.
So that we're clear what I have after I import the data is something like this for every event in the pbp and every game (s39 in the EBBL had 87,152 lines):
http://tinypic.com/r/2pq7rth/9plus the lineups
http://tinypic.com/r/n689ra/9plus all the information on the games from the BBApi (which include tactics and GDP)
Note that I also have information on the lineups on the floor for any given event in the game and the time on the shot clock. Both are useful to check different things. The lineups will be useful if we decide for example to look for some evidence for or against the theory that C shoot better from 3 when they are guarded.
I will do the Princeton analysis on 6 seasons: 2 of yours, 2 of Nachtmahr and 2 of the other guy who volunteered in the thread and we can compare league-wide (or league ex Princeton playing teams) stats and distributions and Princeton only stats and distributions.
Last edited by Lemonshine at 4/9/2018 8:09:45 PM