Some players games stats

No Flag deleted_user
Ninja
Posts: 14364
Joined: Mar 26, 2015

Re: Some players games stats

Post by deleted_user »

flontier wrote:
deleted_user wrote:
Show hidden quotes
Could you share this?
Do you mean the code or "the whole set of games for each players" ?
somppukunkku wrote:can you show mine? :O
i can do it tomorrow if you ready to offer me some of yours sepoys slaves.
The code, I guess. I'd like to be able to access this data myself. I think it's super interesting and the presentation is great.
User avatar
France flontier
Lancer
Intermediate Division Winner
Posts: 630
Joined: Aug 13, 2015
ESO: Flontier
Clan: PLOP

Re: Some players games stats

Post by flontier »

deleted_user wrote:
flontier wrote:
Show hidden quotes
Do you mean the code or "the whole set of games for each players" ?
somppukunkku wrote:can you show mine? :O
i can do it tomorrow if you ready to offer me some of yours sepoys slaves.
The code, I guess. I'd like to be able to access this data myself. I think it's super interesting and the presentation is great.
Ok, need to wait until friday i think, gonna be pretty busy tomorrow, but if you're interested, im sure guys from esoc dev teams knows waaay better than me this kinds of stuff cause they probably do things like extracting data from agecommunity website to build and print the esoc ladder and all the games and they may have nice codes to parse this kind of things (i remember the winrate by civ).
User avatar
France chronique
Advanced Player
Posts: 2060
Joined: Jul 4, 2015
ESO: poissondu44
Location: France

Re: Some players games stats

  • Quote

Post by chronique »

So, i have scraped the whole EP active play elo. I have a data table with 60 000 row where each row a game result. If peaple are interested about that kind of data (i will probably doing some data viz pretty soon myself) I can give it to the community.
No Flag deleted_user
Ninja
Posts: 14364
Joined: Mar 26, 2015

Re: Some players games stats

Post by deleted_user »

chronique wrote:So, i have scraped the whole EP active play elo. I have a data table with 60 000 row where each row a game result. If peaple are interested about that kind of data (i will probably doing some data viz pretty soon myself) I can give it to the community.
The more data the better.
User avatar
France chronique
Advanced Player
Posts: 2060
Joined: Jul 4, 2015
ESO: poissondu44
Location: France

Re: Some players games stats

  • Quote

Post by chronique »

Attachments
Rplot.png
User avatar
France flontier
Lancer
Intermediate Division Winner
Posts: 630
Joined: Aug 13, 2015
ESO: Flontier
Clan: PLOP

Re: Some players games stats

Post by flontier »

Nice, how did you find all of this inspiration and creativity :O ? Thats genius !


(Btw if you want to play who has the biggest i will win)
User avatar
Germany japanesegeneral
Lancer
Posts: 644
Joined: Mar 4, 2015
ESO: JapaneseGeneral
Location: Germany

Re: Some players games stats

Post by japanesegeneral »

Which software are you guys using? R or python?
6 petards a day keep the doctor away.
User avatar
France chronique
Advanced Player
Posts: 2060
Joined: Jul 4, 2015
ESO: poissondu44
Location: France

Re: Some players games stats

  • Quote

Post by chronique »

japanesegeneral wrote:Which software are you guys using? R or python?
#teamR
User avatar
France chronique
Advanced Player
Posts: 2060
Joined: Jul 4, 2015
ESO: poissondu44
Location: France

Re: Some players games stats

Post by chronique »

flontier wrote:Nice, how did you find all of this inspiration and creativity :O ? Thats genius !


(Btw if you want to play who has the biggest i will win)
Sorry! i have thinking than you have not the time so i have try to do the exact same stuff as you have done. All credit are for flontier ofc!!
User avatar
France flontier
Lancer
Intermediate Division Winner
Posts: 630
Joined: Aug 13, 2015
ESO: Flontier
Clan: PLOP

Re: Some players games stats

Post by flontier »

Yes dw im joking lol
User avatar
France chronique
Advanced Player
Posts: 2060
Joined: Jul 4, 2015
ESO: poissondu44
Location: France

Re: Some players games stats

  • Quote

Post by chronique »

What civ some player use, what winrate and what is opponenent PR.

Skirmisher is a chinese beast, second best civ in term of winrate, and vs opponenents who have +3.5 more PR than usual for him.

Please kaiser/hazza, stop bashing peaple with spain.

Tell me what you want me to do, i have a 100 000 rows data who ask to be analysed.
Attachments
Rplot03.png
Rplot02.png
Rplot01.png
Rplot.png
France iNcog
Ninja
Posts: 13236
Joined: Mar 7, 2015

Re: Some players games stats

Post by iNcog »

This thread is fucking awesome lol
YouTube: https://www.youtube.com/incog_aoe
Garja wrote: ↑
20 Mar 2020, 21:46
I just hope DE is not going to implement all of the EP changes. Right now it is a big clusterfuck.
User avatar
Germany japanesegeneral
Lancer
Posts: 644
Joined: Mar 4, 2015
ESO: JapaneseGeneral
Location: Germany

Re: Some players games stats

Post by japanesegeneral »

Can you make plot over all your data? Where you display the average pr difference instead of the average pr. And you don't choose a specific player but display the whole playerbase?
6 petards a day keep the doctor away.
User avatar
France chronique
Advanced Player
Posts: 2060
Joined: Jul 4, 2015
ESO: poissondu44
Location: France

Re: Some players games stats

Post by chronique »

japanesegeneral wrote:Can you make plot over all your data? Where you display the average pr difference instead of the average pr. And you don't choose a specific player but display the whole playerbase?
Yes i can, maybe i can select some pr limit, becouse iam not sure it make sens to take pr 5 vs pr 15 games ^^
France Von_peter
Crossbow
Posts: 14
Joined: Feb 2, 2019
ESO: Von_peter

Re: Some players games stats

Post by Von_peter »

Such a cool idea ! Can see the truth now !
User avatar
Greece BrookG
Retired Contributor
Posts: 2009
Joined: Feb 21, 2016
ESO: BrookG
Location: Thessaloniki

Re: Some players games stats

Post by BrookG »

OMG I'M IN LOVE WITH THAT THREAD
Correlation doesn't mean causation.
http://www.tylervigen.com/spurious-correlations

"mr.brookg go buy jeans and goto the club with somppuli" - Princeofkabul, July 2018
No Flag deleted_user
Ninja
Posts: 14364
Joined: Mar 26, 2015

Re: Some players games stats

Post by deleted_user »

Hmm, my roommate is adept in R. How can I get this data so I can have him analyze me?
Australia Hazza54321
Pro Player
Winter Champion 2020 x2Donator 01
Posts: 8049
Joined: May 4, 2015
ESO: PrinceofBabu

Re: Some players games stats

Post by Hazza54321 »

hehe kaiserklein noobbashing pr30s
User avatar
France chronique
Advanced Player
Posts: 2060
Joined: Jul 4, 2015
ESO: poissondu44
Location: France

Re: Some players games stats

Post by chronique »

deleted_user wrote:Hmm, my roommate is adept in R. How can I get this data so I can have him analyze me?
Idk if its a true request or some sexual joke (maybe both!), anyway i can give the data set to the community, i just need to know ... how!
No Flag deleted_user
Ninja
Posts: 14364
Joined: Mar 26, 2015

Re: Some players games stats

Post by deleted_user »

Google drive or dropbox?
User avatar
France chronique
Advanced Player
Posts: 2060
Joined: Jul 4, 2015
ESO: poissondu44
Location: France

Re: Some players games stats

Post by chronique »

I think i can with gg drive.
User avatar
France chronique
Advanced Player
Posts: 2060
Joined: Jul 4, 2015
ESO: poissondu44
Location: France

Re: Some players games stats

  • Quote

Post by chronique »

@japanesegeneral
You wanted something like that?

It's look pretty insane how spain differe just by changing the filtering criterium. On the second graph, i have selected game only when the loser have a PR sup than 30, spain is the worth in term of winrate and still have overall +0.5 PR comparatively to is opponenet.

But when i select when the winner have a PR > 30, spanish become the best in term of winrate but with an huge PR adventage.
(i dont care about other civ, i play only spain, just why brit are always picked by the lowest player)

Why the top level bash so many peaple with my main civ :(
Attachments
Rplot02.png
Rplot01.png
Rplot.png
User avatar
Germany japanesegeneral
Lancer
Posts: 644
Joined: Mar 4, 2015
ESO: JapaneseGeneral
Location: Germany

Re: Some players games stats

Post by japanesegeneral »

The first graph is what i was thinking of. However the secound and third graph add so much depth to it. The case of spain is indeed quite funny.

Thank you for making these.
6 petards a day keep the doctor away.
User avatar
India Challenger_Marco
ESOC Media Team
Posts: 2689
Joined: Nov 23, 2015
ESO: challenger_marco

Re: Some players games stats

Post by Challenger_Marco »

i dont understand the graph
:nwc:
User avatar
France chronique
Advanced Player
Posts: 2060
Joined: Jul 4, 2015
ESO: poissondu44
Location: France

Re: Some players games stats

Post by chronique »

Challenger_Marco wrote:i dont understand the graph
Barplot give the winrate of each civ, "n" give the number of game played by this civ, "pr diff" is the pr difference between the player of the civ and the other player (for exemple in the first graph, spain have a PR diff equal to 1, mean overall spain players have 1 more PR than his opponenet).

Who is online

Users browsing this forum: No registered users and 11 guests

Which top 10 players do you wish to see listed?

All-time

Active last two weeks

Active last month

Supremacy

Treaty

Official

ESOC Patch

Treaty Patch

1v1 Elo

2v2 Elo

3v3 Elo

Power Rating

Which streams do you wish to see listed?

Twitch

Age of Empires III

Age of Empires IV