Ladder statistics

General feedback and discussion of the game.

Moderator: Forum Moderators

amir
Posts: 25
Joined: August 24th, 2008, 10:43 am

Re: Ladder statistics

Post by amir »

sergey wrote: July 10th, 2019, 10:58 pm
amir wrote: July 10th, 2019, 10:35 pm Are there other statistics you would like to see?
Could you compile faction vs faction per map statistics please? E.g. win ratio Drakes / Rebels on Hamlets = 60% / 40%

I have even better idea, though it is of course up to you to implement it or not. Here it is:
- remove all rows from the table that don't have associated replay file
- add new text columns "winner faction" and "looser faction"
- add new numeric column "Wesnoth version"
- add new text column "map name"
- add new text column "era name"
- fill those new columns with data from the replay files

With such modified table it would be much faster and more convenient to perform future queries. However, feel free to ignore this idea if you don't like it.
I completely forgot about your request, but I'm gonna look into it in the next days. :D

Anyway, i generated new charts from up to date data. (Thanks go to chains and cackfiend!)
First thing that interested me was how much the results changes when i filter by elo. attached you'll find the results for the years 2018/2019/2020 with elo limit and without. Turned out, there is less of a difference than i expected.
Attachments
18_19_20_1800elo.pdf
All ladder games of players with a minimum elo of 1800 in the years 2018, 2019 and 2020
(682.46 KiB) Downloaded 275 times
18_19_20_0elo.pdf
All ladder games of all players in the years 2018, 2019 and 2020
(661.87 KiB) Downloaded 280 times
amir
Posts: 25
Joined: August 24th, 2008, 10:43 am

Re: Ladder statistics

Post by amir »

Next i generated the same charts but for each year respectively. I'll leave theories on how the data should be interpreted to you :)
There is no chart for the year 2020 for players over 1800 elo, because there isn't enough data yet.
Attachments
18_1800elo.pdf
(669.86 KiB) Downloaded 238 times
19_1800elo.pdf
(675.28 KiB) Downloaded 240 times
18_0elo.pdf
(669.86 KiB) Downloaded 255 times
19_0elo.pdf
(675.3 KiB) Downloaded 228 times
20_0elo.pdf
(673.76 KiB) Downloaded 253 times
User avatar
sergey
Posts: 475
Joined: January 9th, 2015, 9:25 pm

Re: Ladder statistics

Post by sergey »

So you split data by years and this is the only difference comparing to these charts viewtopic.php?p=644414#p644414 , correct?
Author of SP scenario Dragon Fight and SP campaign Captured by a Nightmare.
Created The Rise of Wesnoth (alternative mechanics) version of the mainline campaign.
amir
Posts: 25
Joined: August 24th, 2008, 10:43 am

Re: Ladder statistics

Post by amir »

exactly
amir
Posts: 25
Joined: August 24th, 2008, 10:43 am

Re: Ladder statistics

Post by amir »

On request i generated also the charts for all games of 2018,2019 and 2020 with a minimum elo of 1600 for both players.
Comparing the files 18_19_20_0elo.pdf. 18_19_20_1600elo.pdf and 18_19_20_1800elo.pdf proved quite interesting. Some match-ups only change slightly with elo and others completely turn around.
Attachments
18_19_20_1600elo.pdf
(687.07 KiB) Downloaded 264 times
Post Reply