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 :orc:

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
sann0638 wrote: 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
hmmm..... I smell a challenge :lol:


Shame I'm too rubbish to win it with anything other than #FlingNation :lol:

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! :orc:
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 :orc:
Cheers
Martin