NAF Data for Number-Crunchers

News and announcements from the worldwide Blood Bowl players' association

Moderator: TFF Mods

Post Reply
User avatar
sann0638
Kommissar Enthusiasmoff
Posts: 6609
Joined: Mon May 08, 2006 10:24 am
Location: Swindon, England

Re: NAF Data for Number-Crunchers

Post by sann0638 »

Haven't done an update, will ask the question.

Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
kyrre
Experienced
Experienced
Posts: 156
Joined: Sun Aug 28, 2016 7:44 am

Re: NAF Data for Number-Crunchers

Post by kyrre »

Links to CSV/XLSX moved here: viewtopic.php?f=81&t=40863&p=792162#p792162

Reason: ''
kyrre
Experienced
Experienced
Posts: 156
Joined: Sun Aug 28, 2016 7:44 am

Re: NAF Data for Number-Crunchers

Post by kyrre »

mubo wrote:Is there a 2018 update? Thanks in advance!

Also, I noticed that the Spikey club open 2002, is dated 2003., which doesn't match the dates on the NAF site.
If you look at the matches recorded here https://member.thenaf.net/index.php?mod ... advanced=1 you will discover that they are indeed dated in 2003. Possibly a mistake when it was added to the database. Since this appears to be the very first tournament recorded it might have been added long after it was actually played. With mostly unstructured data like provided by hundreds of different people, there will be many errors like this. Now, the date thing should be quite easy to fix. A list with tournament and match date mismatches might be useful.

Reason: ''
User avatar
mubo
Star Player
Star Player
Posts: 749
Joined: Mon Dec 22, 2008 7:12 pm
Location: Oxford, UK

Re: NAF Data for Number-Crunchers

Post by mubo »

kyrre wrote: If you look at the matches recorded here https://member.thenaf.net/index.php?mod ... advanced=1 you will discover that they are indeed dated in 2003. Possibly a mistake when it was added to the database. Since this appears to be the very first tournament recorded it might have been added long after it was actually played. With mostly unstructured data like provided by hundreds of different people, there will be many errors like this. Now, the date thing should be quite easy to fix. A list with tournament and match date mismatches might be useful.
Thanks, very helpful!

Looking at: https://member.thenaf.net/index.php?mod ... view&id=25
There does seem to be a NAF record of tourney happening in 2002, so yes- should be easy to flag date of tourney and date of game mismatches.

Reason: ''
Glicko guy.
Team England committee member
User avatar
sann0638
Kommissar Enthusiasmoff
Posts: 6609
Joined: Mon May 08, 2006 10:24 am
Location: Swindon, England

Re: NAF Data for Number-Crunchers

Post by sann0638 »

I'm happy to update the database if there are mistakes.

Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
kyrre
Experienced
Experienced
Posts: 156
Joined: Sun Aug 28, 2016 7:44 am

Re: NAF Data for Number-Crunchers

Post by kyrre »

NAF data has been updated as of just now. January 15, 2018 10:11 CET.

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

Re: NAF Data for Number-Crunchers

Post by sann0638 »

Have been in discussions with kyrre about getting the data directly.

And it seems I'm a data analyst now, so am going to be doing some pretty groovy stuff with it, starting here in my lunch break:

https://www.thenaf.net/tournaments/rankings/tableau/

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 »

Link says: Forbidden!

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: 6609
Joined: Mon May 08, 2006 10:24 am
Location: Swindon, England

Re: NAF Data for Number-Crunchers

Post by sann0638 »

New link: sann0638.co.uk/nafdata.htm

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 »

Very nice.
2 suggestions:
1) In the coach view, add a "win percentage" calculation at the end of each race.
2) In the main view, add to the "years" filter the option to choose any "year and later" - so for example "2014+" gives the data for 2014, 2015, 2016, 2017, 2018.

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: 6609
Joined: Mon May 08, 2006 10:24 am
Location: Swindon, England

Re: NAF Data for Number-Crunchers

Post by sann0638 »

Will make it a "select multiple" option.

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: 6609
Joined: Mon May 08, 2006 10:24 am
Location: Swindon, England

Re: NAF Data for Number-Crunchers

Post by sann0638 »

Updated with some nice new pages.

Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
Moraiwe
Emerging Star
Emerging Star
Posts: 323
Joined: Fri Jul 25, 2003 1:22 pm
Location: Melbourne, Australia

Re: NAF Data for Number-Crunchers

Post by Moraiwe »

Sann, the data doesn't match the data on the NAF site (for me at least) - you're using numbers you pulled from the NAF a month or two ago, yes?

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

Re: NAF Data for Number-Crunchers

Post by sann0638 »

I did wonder if you would say something nice...

Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
kyrre
Experienced
Experienced
Posts: 156
Joined: Sun Aug 28, 2016 7:44 am

Re: NAF Data for Number-Crunchers

Post by kyrre »

Moraiwe wrote:Sann, the data doesn't match the data on the NAF site (for me at least) - you're using numbers you pulled from the NAF a month or two ago, yes?

This is actually good news! Searching for bugs for one coach's match record is much easier than finding errors in 200,000 matches. Mind sharing your coach name, so that I can investigate?

Reason: ''
Post Reply