| Forum Index > BW General |
Milkis
5003 Posts
On July 16 2011 02:21 IntoTheWow wrote: Can you get a list of best streaks mlikis? Like most PvP's won in a row, etc? Hrm... I'm not 100% sure how to get that, but I'll try in the future. Does anyone know what kind of algorithm you would use to get this? | ||
|
amazingoopah
United States1925 Posts
On July 16 2011 02:21 IntoTheWow wrote: Can you get a list of best streaks mlikis? Like most PvP's won in a row, etc? It's right here already: http://www.teamliquid.net/forum/viewmessage.php?topic_id=82758 though GoRush is listed there with a 16 game winning streak but his player page says his best streak is 15: http://www.teamliquid.net/tlpd/korean/players/8_GoRush/games | ||
|
Milkis
5003 Posts
On July 16 2011 02:23 amazingoopah wrote: It's right here already: http://www.teamliquid.net/forum/viewmessage.php?topic_id=82758 though GoRush is listed there with a 16 game winning streak but his player page says his best streak is 15: http://www.teamliquid.net/tlpd/korean/players/8_GoRush/games The thing is that is outdated and I want to update it  | ||
|
VGhost
United States3617 Posts
| ||
|
Dayrlan
United States248 Posts
On July 16 2011 02:22 Milkis wrote: Hrm... I'm not 100% sure how to get that, but I'll try in the future. Does anyone know what kind of algorithm you would use to get this? Not sure if this is a joke I'm missing. Are you pulling statistics out of a database using a script and want pseudocode? | ||
|
Milkis
5003 Posts
On July 16 2011 07:27 Dayrlan wrote: Not sure if this is a joke I'm missing. Are you pulling statistics out of a database using a script and want pseudocode? Yeah, i'm pulling stats out of a db. I can't think of a decent way of doing this (ie: decent meaning i don't want to make it too painful for me to collect the stats :p) | ||
swanized
Canada2480 Posts
| ||
|
gngfn
United States1726 Posts
On July 16 2011 07:38 Milkis wrote: Yeah, i'm pulling stats out of a db. I can't think of a decent way of doing this (ie: decent meaning i don't want to make it too painful for me to collect the stats :p) It depends on how you're able to query the database--are there any constraints? The simple approach to finding win streaks would just be to sort games played by date and loop over them, tracking the current win streak for each player in a dictionary or something. When the player loses, reset the dictionary entry to 0 and add a tuple to a list somewhere like ('GoRush', 16) or whatever. There are tricks you can do to improve runtime involving sampling and such, but there really haven't been enough SC games played for this to improve much over the simple method... | ||
|
Milkis
5003 Posts
On July 16 2011 08:15 gngfn wrote: It depends on how you're able to query the database--are there any constraints? The simple approach to finding win streaks would just be to sort games played by date and loop over them, tracking the current win streak for each player in a dictionary or something. When the player loses, reset the dictionary entry to 0 and add a tuple to a list somewhere like ('GoRush', 16) or whatever. There are tricks you can do to improve runtime involving sampling and such, but there really haven't been enough SC games played for this to improve much over the simple method... Yeah, that's what I was afraid of doing since it'd be annoying with how the db is set up. If that's the easiest way though But since PoP seemed to have no problems taking them out of the TLPD i'm sure there's... something. | ||
|
gngfn
United States1726 Posts
On July 16 2011 08:19 Milkis wrote: Yeah, that's what I was afraid of doing since it'd be annoying with how the db is set up. If that's the easiest way though But since PoP seemed to have no problems taking them out of the TLPD i'm sure there's... something. Well, it's tough to say if that's the easiest way without knowing what problem with the database setup makes what I described hard. | ||
|
Milkis
5003 Posts
On July 16 2011 08:24 gngfn wrote: Well, it's tough to say if that's the easiest way without knowing what problem with the database setup makes what I described hard. At the simplest form it is listed as the following. Game ID - Winner's Player ID - Winner's Race - Loser's Player ID - Loser's Race - Map - League For every player. | ||
|
gngfn
United States1726 Posts
On July 16 2011 08:26 Milkis wrote: At the simplest form it is listed as the following. Game ID - Winner's Player ID - Winner's Race - Loser's Player ID - Loser's Race - Map - League For every player. But that's everything you need to do what I said. That the records are grouped by player doesn't matter since win streaks are a per-player stat anyway, and although you omitted date, I'm assuming you have it since you had those win rate-per-month stats earlier. Maybe I'm missing something. | ||
|
Milkis
5003 Posts
On July 16 2011 08:37 gngfn wrote: But that's everything you need to do what I said. That the records are grouped by player doesn't matter since win streaks are a per-player stat anyway, and although you omitted date, I'm assuming you have it since you had those win rate-per-month stats earlier. Maybe I'm missing something. Yeah, I know it's possible the way you said it, I'm just wondering if there's a simpler algorithm than I'm missing | ||
|
Crunchums
United States11144 Posts
Overall TvZ Win/Loss Overall TvP Win/Loss Overall Tv[not T] Win/Loss (just add previous two) TvZ Win/Loss with Flash removed TvP Win/Loss with Flash removed Tv[not T] Win/Loss with Flash removed (just add previous two) Flash's statistics over that time period are: 228 - 73 (75.75%) Overall 85 - 24 (77.98%) vT 87 - 29 (75.00%) vZ 56 - 20 (73.68%) vP Could you please find these two statistics Overall TvZ Win/Loss Overall TvP Win/Loss during that time period? Those are all I need to calculate the rest. edit: these stats are current as of 7/18/2011 | ||
|
Crunchums
United States11144 Posts
It would also be interesting to take a similar look at how zergs do if you remove Jaedong. | ||
|
Lachrymose
Australia1928 Posts
On July 17 2011 14:56 Crunchums wrote: Now that I can actually look at that post I have made, holy balls what the fuck Flash so dominant o.O It would also be interesting to take a similar look at how zergs do if you remove Jaedong. It would be interesting to see PvZ without Bisu, I think. | ||
|
moopie
12605 Posts
Since the majority of players don't mean much to anyone, here are the top 30 for each catagory: Contains every game in TLPD (minus All-Stars) up to July 18th 2011 All leagues (minus All-Stars): Top 30 win streaks: + Show Spoiler +
Top 30 losing streaks: + Show Spoiler +
All Individual Leagues: Top 30 win streaks: + Show Spoiler +
Top 30 losing streaks: + Show Spoiler +
All Team Leagues (minus All-Stars): Top 30 win streaks: + Show Spoiler +
Top 30 losing streaks: + Show Spoiler +
OSL/MSL/MST/KPGA/Prelims: Top 30 win streaks: + Show Spoiler +
Top 30 losing streaks: + Show Spoiler +
SPL/SWL/Playoffs: Top 30 win streaks: + Show Spoiler +
Top 30 losing streaks: + Show Spoiler +
This took a while to compile and format, so I hope someone else finds it interesting :3 edit: fixed bug in my script. | ||
|
moopie
12605 Posts
+ Show Spoiler + and not a single fuck was given :/ | ||
|
BYAHH
United States20 Posts
+ Show Spoiler + a fuck has indeed been given No but really, a job very well done! | ||
|
Lachrymose
Australia1928 Posts
Rock. | ||
| ||
|
|
CranKy Ducklings
Sparkling Tuna Cup
PiGosaur Cup
Replay Cast
Kung Fu Cup
Replay Cast
The PondCast
CranKy Ducklings
WardiTV Team League
Replay Cast
[ Show More ] |
|
|
EPT
