Ladder statistics
Moderator: Forum Moderators
Re: Ladder statistics
I completely forgot about your request, but I'm gonna look into it in the next days.sergey wrote: ↑July 10th, 2019, 10:58 pmCould 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.
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 276 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
Re: Ladder statistics
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.
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 241 times
-
- 18_0elo.pdf
- (669.86 KiB) Downloaded 256 times
-
- 19_0elo.pdf
- (675.3 KiB) Downloaded 228 times
-
- 20_0elo.pdf
- (673.76 KiB) Downloaded 255 times
Re: Ladder statistics
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.
Created The Rise of Wesnoth (alternative mechanics) version of the mainline campaign.
Re: Ladder statistics
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.
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