Page 14 of 18
Re: NAF Data for Number-Crunchers
Posted: Sun Jun 03, 2018 12:18 pm
by plasmoid
So, Mr. CakeBowl-man - any chance for this week?
It would be a great way to celebrate your 1000th sub
Re: NAF Data for Number-Crunchers
Posted: Sat Jun 09, 2018 9:46 am
by plasmoid
Or maybe next week? Or just an ETA?
I really need the stats for some EuroBowl related stuff.
Cheers
Martin
Re: NAF Data for Number-Crunchers
Posted: Sat Jun 09, 2018 10:15 am
by sann0638
Oh right, thought it was just interest. Monday lunchtime
Re: NAF Data for Number-Crunchers
Posted: Mon Jun 11, 2018 1:43 pm
by sann0638
All updated, with an interesting tweak. If you go to the NAF Game Data workbook, you should be able to download the full list of games to a CSV to do with what you will.
Be aware that each game is listed twice, with the coaches reversed as "home" and "away", so use the data intelligently!
https://public.tableau.com/profile/mike ... .davies#!/
In an exciting development, we now have our first "big 5" stunty winner, Daht, who has won it with all 5 of the possible teams.
https://public.tableau.com/profile/mike ... yCupDetail
Re: NAF Data for Number-Crunchers
Posted: Mon Jun 11, 2018 2:35 pm
by lunchmoney
hmmm..... I smell a challenge
Shame I'm too rubbish to win it with anything other than #FlingNation
Re: NAF Data for Number-Crunchers
Posted: Mon Jun 11, 2018 2:56 pm
by rolo
I'm more impressed by whoever won the Stunty Cup with Chaos Dwarves!
Re: NAF Data for Number-Crunchers
Posted: Mon Jun 11, 2018 2:58 pm
by sann0638
That's there to illustrate the fallibility of data. It was a mixed tournament, but you enter a main team in the database
Re: NAF Data for Number-Crunchers
Posted: Thu Jun 14, 2018 8:16 am
by plasmoid
Thanks a bunch!
Very interesting Developments
Quick question - is there some way to see how many times each race has played against each other race in a dataset?
I have no problem checking each match-up one at a time.
WDL would be even nicer, but I'm mainly curious about the match-up count.
Cheers
Martin
Re: NAF Data for Number-Crunchers
Posted: Thu Jun 14, 2018 10:05 pm
by kyrre
Do you know SQL, Martin?
Re: NAF Data for Number-Crunchers
Posted: Fri Jun 15, 2018 5:57 am
by plasmoid
Unfortunately no.
No programming experience of any kind.
Re: NAF Data for Number-Crunchers
Posted: Fri Jun 15, 2018 1:08 pm
by kyrre
Are you interested in all matches ever played or do you need specific dates?
edit:
http://ghoulhq.com/nafdata/race.csv
Re: NAF Data for Number-Crunchers
Posted: Fri Jun 15, 2018 1:55 pm
by plasmoid
Wow. That was fast. Thanks!
I got everything I needed.
And since you asked: Other potential future queries would most likely be limited to 2011-amd-later data - and just Blood Bowl, not the variants.
Thanks Again
Martin
Re: NAF Data for Number-Crunchers
Posted: Fri Jun 15, 2018 2:51 pm
by kyrre
2011 and beyond variant = "Blood Bowl":
http://ghoulhq.com/nafdata/race-2011.csv
Re: NAF Data for Number-Crunchers
Posted: Fri Jun 15, 2018 7:55 pm
by sann0638
Re: NAF Data for Number-Crunchers
Posted: Sat Jun 23, 2018 10:28 pm
by plasmoid
Thanks yet Again Sann,
that's a very handy table
Cheers
Martin