NAF Data for Number-Crunchers

News and announcements from the worldwide Blood Bowl players' association

Moderator: TFF Mods

Post Reply
plasmoid
Legend
Legend
Posts: 5334
Joined: Sun May 05, 2002 8:55 am
Location: Copenhagen
Contact:

Re: NAF Data for Number-Crunchers

Post by plasmoid »

So, Mr. CakeBowl-man - any chance for this week?
It would be a great way to celebrate your 1000th sub :orc:

Reason: ''
Narrow Tier BB? http://www.plasmoids.dk/bbowl/NTBB.htm
Or just visit http://www.plasmoids.dk instead
plasmoid
Legend
Legend
Posts: 5334
Joined: Sun May 05, 2002 8:55 am
Location: Copenhagen
Contact:

Re: NAF Data for Number-Crunchers

Post by plasmoid »

Or maybe next week? Or just an ETA?
I really need the stats for some EuroBowl related stuff.
Cheers
Martin :)

Reason: ''
Narrow Tier BB? http://www.plasmoids.dk/bbowl/NTBB.htm
Or just visit http://www.plasmoids.dk instead
User avatar
sann0638
Kommissar Enthusiasmoff
Posts: 6610
Joined: Mon May 08, 2006 10:24 am
Location: Swindon, England

Re: NAF Data for Number-Crunchers

Post by sann0638 »

Oh right, thought it was just interest. Monday lunchtime

Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
User avatar
sann0638
Kommissar Enthusiasmoff
Posts: 6610
Joined: Mon May 08, 2006 10:24 am
Location: Swindon, England

Re: NAF Data for Number-Crunchers

Post 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

Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
User avatar
lunchmoney
Legend
Legend
Posts: 8879
Joined: Wed Dec 10, 2008 2:59 pm
Location: The Dark Future

Re: NAF Data for Number-Crunchers

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

Reason: ''
Hired Goon for the NAF (rep for South West England)
Image
lunchmoneybb@gmail.com

TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
User avatar
rolo
Super Star
Super Star
Posts: 1188
Joined: Wed May 27, 2015 9:38 am
Location: Paradise Stadium, where the pitch is green and the cheerleaders are pretty.

Re: NAF Data for Number-Crunchers

Post by rolo »

I'm more impressed by whoever won the Stunty Cup with Chaos Dwarves!

Reason: ''
"It's 2+ and I have a reroll. Chill out. I've got this!"
Image
User avatar
sann0638
Kommissar Enthusiasmoff
Posts: 6610
Joined: Mon May 08, 2006 10:24 am
Location: Swindon, England

Re: NAF Data for Number-Crunchers

Post 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 :)

Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
plasmoid
Legend
Legend
Posts: 5334
Joined: Sun May 05, 2002 8:55 am
Location: Copenhagen
Contact:

Re: NAF Data for Number-Crunchers

Post 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

Reason: ''
Narrow Tier BB? http://www.plasmoids.dk/bbowl/NTBB.htm
Or just visit http://www.plasmoids.dk instead
kyrre
Experienced
Experienced
Posts: 156
Joined: Sun Aug 28, 2016 7:44 am

Re: NAF Data for Number-Crunchers

Post by kyrre »

Do you know SQL, Martin?

Reason: ''
plasmoid
Legend
Legend
Posts: 5334
Joined: Sun May 05, 2002 8:55 am
Location: Copenhagen
Contact:

Re: NAF Data for Number-Crunchers

Post by plasmoid »

Unfortunately no.
No programming experience of any kind.

Reason: ''
Narrow Tier BB? http://www.plasmoids.dk/bbowl/NTBB.htm
Or just visit http://www.plasmoids.dk instead
kyrre
Experienced
Experienced
Posts: 156
Joined: Sun Aug 28, 2016 7:44 am

Re: NAF Data for Number-Crunchers

Post by kyrre »

Are you interested in all matches ever played or do you need specific dates?

edit: http://ghoulhq.com/nafdata/race.csv

Reason: ''
plasmoid
Legend
Legend
Posts: 5334
Joined: Sun May 05, 2002 8:55 am
Location: Copenhagen
Contact:

Re: NAF Data for Number-Crunchers

Post 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

Reason: ''
Narrow Tier BB? http://www.plasmoids.dk/bbowl/NTBB.htm
Or just visit http://www.plasmoids.dk instead
kyrre
Experienced
Experienced
Posts: 156
Joined: Sun Aug 28, 2016 7:44 am

Re: NAF Data for Number-Crunchers

Post by kyrre »

2011 and beyond variant = "Blood Bowl": http://ghoulhq.com/nafdata/race-2011.csv

Reason: ''
User avatar
sann0638
Kommissar Enthusiasmoff
Posts: 6610
Joined: Mon May 08, 2006 10:24 am
Location: Swindon, England

Re: NAF Data for Number-Crunchers

Post by sann0638 »


Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
plasmoid
Legend
Legend
Posts: 5334
Joined: Sun May 05, 2002 8:55 am
Location: Copenhagen
Contact:

Re: NAF Data for Number-Crunchers

Post by plasmoid »

Thanks yet Again Sann,
that's a very handy table :orc:
Cheers
Martin

Reason: ''
Narrow Tier BB? http://www.plasmoids.dk/bbowl/NTBB.htm
Or just visit http://www.plasmoids.dk instead
Post Reply