Week 1 statistics

[mojo371]

Originally Posted by Spoam

Thanks for the stat dump. Did you compile these manually or via script?

I manually entered in all the data for stuff like breaching success rates and climbing success rates but then used functions in excel to calculate the percentages and averages.

It wasn't that bad since www.thebluealliance.com centralized all that data for each regional under the insights tab. I just tried to centralize it more.

[Taylor]

At Lake Superior, there were 202 matches played, but Class A defenses were out for 200 of the matches. (60 portcullis, 140 cdf). Was this a miscount in data, or was there a more interesting explanation at the event?

[vhcook]

Originally Posted by Taylor

At Lake Superior, there were 202 matches played, but Class A defenses were out for 200 of the matches. (60 portcullis, 140 cdf). Was this a miscount in data, or was there a more interesting explanation at the event?

I've found that the TBA data has a tendency to not record defense type for position 3 in the first match. They have a few other data glitches, but that's the most common one.

[Gugund]

Could you share the editable spreadsheet or upload a downloadable version? I would like to make some graphs with all this info, using Tableau

[plnyyanks]

Originally Posted by vhcook

I've found that the TBA data has a tendency to not record defense type for position 3 in the first match. They have a few other data glitches, but that's the most common one.

Can you give an example of a match that shows this bug so we can investigate?

[Conor Ryan]

Can anybody dump this data into a tableau server? (Bonus points for integrating with The Blue Alliance API)

It would be a wicked awesome way to work with all this data. A Scala/R GUI interface works too. We can get some real data science action going on over here.

[mojo371]

I have attached the excel spreadsheet that I used to make all of this data for anyone that wants to add/change anything they want. If you want to add something to the master google sheets copy for everyone to see, don't hesitate to contact me.

[Gugund]

Originally Posted by mojo371

I have attached the excel spreadsheet that I used to make all of this data for anyone that wants to add/change anything they want. If you want to add something to the master google sheets copy for everyone to see, don't hesitate to contact me.

Thank You!! I'm a new Tableau user, but i'll see what i'm able to do with this info

[engunneer]

Originally Posted by Conor Ryan

Can anybody dump this data into a tableau server? (Bonus points for integrating with The Blue Alliance API)

It would be a wicked awesome way to work with all this data. A Scala/R GUI interface works too. We can get some real data science action going on over here.

One of the av guys in the pnw districts works at Tableau. I don't think he reads cd though. I'll see if they have anything set up.

[Conor Ryan]

Originally Posted by engunneer

One of the av guys in the pnw districts works at Tableau. I don't think he reads cd though. I'll see if they have anything set up.

Awesome! Tableau's web interface would be a wicked awesome application of this, on the fly visualizations and easy ways to slice the data and all that fun jazz. I bet you we could get a lot of users via CD.

Actually now that I did a little more research, Tableau Public might actually be the correct solution. Lets see if i can do some quick hacking.