08-22-2019, 10:39 AM | #21 |
[Nobody liked that.]
Join Date: Sep 2012
Posts: 3,358
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
|
08-22-2019, 10:49 AM | #22 |
Very Grave Indeed
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
So what would be the desired amount of granularity?
Wolf wins/losses Town wins/losses 3p wins/losses Percentages for all of those individually and combined? |
08-22-2019, 12:20 PM | #23 |
longing
Join Date: Dec 2007
Location: Ontario, Canada
Posts: 2,680
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
its not hard to make the threads not appear on the homepage sidebar of new threads, they already do that with the Ask me anything forum which makes alot less sense than them doing it for this subforum
Last edited by Dinglesberry; 08-22-2019 at 12:24 PM.. |
08-22-2019, 01:46 PM | #24 |
T-Force's Rival
Join Date: Dec 2010
Age: 27
Posts: 1,865
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
LOL SUNFAN WITH THE ROAST IN A THREAD CALLING OUT SUNFAN
|
08-22-2019, 01:51 PM | #25 | |
Snivy! Dohoho!
Join Date: Mar 2006
Age: 33
Posts: 6,161
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
Quote:
Seriously, why are you trying to start something? |
|
08-22-2019, 02:02 PM | #26 | |
Banned
Join Date: Nov 2013
Posts: 8,563
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
Quote:
you're literally saying "it popular so it bad" how about you fuck off out of twg subforum or set your password to a random string and logout so we don't need to see your posts ever again |
|
08-22-2019, 02:34 PM | #27 |
Very Grave Indeed
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
Why would I want to make TWG threads not show up in the sidebar?
I actively want to continue to advertise TWG, not hide it. |
08-23-2019, 12:30 AM | #28 |
Beach Bum Extraordinaire
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
Yesssssssssss
|
08-23-2019, 12:56 AM | #29 | |
FFR Player
Join Date: Mar 2017
Age: 29
Posts: 444
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
Quote:
games played (not counting times you subbed out) games subbed out total wins wins as each alignment something like that for the baseline EDIT: games subbed out is a really hard stat to track, so maybe not even that games finished would be more accurate at this point
__________________
TWG Stats: https://docs.google.com/spreadsheets...it?usp=sharing FFR is a pretty good place somehow. Last edited by the sun fan; 08-23-2019 at 12:59 AM.. |
|
08-23-2019, 01:27 AM | #30 |
RIP Storn D0-D0
Join Date: Jun 2012
Posts: 3,453
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
where is games mislynched D0 ?
|
08-23-2019, 01:24 PM | #31 |
Very Grave Indeed
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
So uh
https://docs.google.com/spreadsheets...it?usp=sharing (That covers all the games which are done, but not in the history for regular TWG. Now I can work backwards through the history thread. |
08-23-2019, 01:57 PM | #32 |
T-Force's Rival
Join Date: Dec 2010
Age: 27
Posts: 1,865
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
so is devonin doing the stats...........?
|
08-23-2019, 02:04 PM | #33 |
Very Grave Indeed
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
Well, I'm doing some stats. What gets done with it after is *shrug*
|
08-23-2019, 02:22 PM | #34 | |
~ お ま ん こ ~
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
Quote:
I tried in the past but parsing and cleaning the data was too strenuous to normalize, esp. when you consider oddball or bastard games. |
|
08-23-2019, 02:24 PM | #35 |
Very Grave Indeed
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
I mean...fundamentally no I can't really do much ETL stuff with this particular spreadsheet. I'm doing what it looked like was wanted which was just individual player stats for town, wolf, and 3p.
Depending on the kind of data you want access to, making another spreadsheet that was more easily used as a source for data extraction wouldn't be super hard to do. Basically it would be a spreadsheet that had everything -but- individual player stats. Total players, size of each faction, which faction won, total phases etc. That could be pretty extractable for various bits of analysis. Last edited by devonin; 08-23-2019 at 02:33 PM.. |
08-23-2019, 02:51 PM | #36 |
FFR Player
Join Date: Mar 2017
Age: 29
Posts: 444
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
Mfw
__________________
TWG Stats: https://docs.google.com/spreadsheets...it?usp=sharing FFR is a pretty good place somehow. |
08-23-2019, 02:53 PM | #37 |
Snivy! Dohoho!
Join Date: Mar 2006
Age: 33
Posts: 6,161
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
|
08-23-2019, 02:57 PM | #38 | |
~ お ま ん こ ~
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
Quote:
The harsh reality is that someone is gonna have to manually clean the dataset to have a robust, scalable stats potential. I might take a look at that this weekend to gauge how hard that would be. I might devise a simple schema that captures like, win/lose for each player, color, role, modkill, etc. EDIT: But yeah the principle is as you described. Having a spreadsheet that has raw data means that you can make as many stats as you want, just query the spreadsheet when needed DOUBLE EDIT: I might just straight-up ask the MafiaUniverse mods what schema they use for their native stats system. No need to reinvent the wheel
__________________
Last edited by DaBackpack; 08-23-2019 at 03:00 PM.. |
|
08-23-2019, 03:00 PM | #39 |
Very Grave Indeed
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
"A parse I did already"
*Is going manually game by game through the archive because that's the only way to get at ANY player stats at all* |
08-23-2019, 03:03 PM | #40 | |
~ お ま ん こ ~
|
Re: ITT We remind thesunfan that he hasn't finished the stat sheet
Quote:
thanks for this work, I'll see if I can extract the game data over the next few days and we can work together to get stats done |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|