WR of Notable Players vs Others Using Web Scraping

Discussion in 'General Discussion' started by MikeLin, Mar 11, 2019.

  1. MikeLin

    MikeLin I need me some PIE!

    Let me know what player's WR would you like me to scrape. Or find out tiny's WR vs players not on this list currently.

    @TinyDragon %Win Vs:
    THIS ONLY INCLUDES RANKED 1v1 GAMES
    NUMBERS GO IN THIS ORDER SEPARATED BY SPACE: Tiny's wins, opponent wins, total games played, and Tiny's WR(%) vs that player(highlighted in yellow)

    THIS SCRIPT WAS RAN LIKE 7PM EST 03/11/19
    Following spreadsheet was made from:

    https://drive.google.com/file/d/1cIA6m5KtsJ9eYM--DUvKzFTdmy3rpHQ8/view?usp=sharing
    which contains the entire Match Making history from the player at the time after I finish running the script

    Tiny is only negative vs Kithros, Guitarape, and iPox so far
    Players:
    ballballer @Ballballer : 85 35 120 70.83333333333334
    DevilsRath @devilsrath : 279 194 473 58.985200845665965
    Ryvirath @Ryvirath : 156 156 312 50
    hashinshin: 83 50 133 62.40601503759399
    Kithros: 18 21 39 46.15384615384615
    theRed: 56 18 74 75.67567567567568
    sinwind: 48 46 94 51.06382978723404
    Soremist: 14 10 24 58.333333333333336
    DragonSlayer1 @nepyonisdead : 96 67 163 58.895705521472394
    TheNidhogg: 48 27 75 64
    kthx @kthx : 62 26 88 70.45454545454545
    Hermaios @Chris : 167 78 245 68.16326530612244
    BurnPyro @BurnPyro : 97 25 122 79.50819672131148
    Dagdapede @Dagda : 56 15 71 78.87323943661971
    calisk @calisk : 75 26 101 74.25742574257426
    Taylor: 137 54 191 71.72774869109948
    MogaBait: 15 10 25 60
    xaznsoulx @xaznsoulx : 198 78 276 71.73913043478261
    Gainer900: 53 22 75 70.66666666666667
    MW24: 87 57 144 60.416666666666664
    Zorbot @zorbot : 70 32 102 68.62745098039215
    Sheepy23: 83 33 116 71.55172413793103
    Nihilarian: 88 21 109 80.73394495412845
    Luvadata: 42 15 57 73.68421052631578
    Indijanac: 23 4 27 85.18518518518519
    DMrBadguy: 14 8 22 63.63636363636363
    Markoth: 40 19 59 67.79661016949152
    Halfgodx: 157 61 218 72.01834862385321
    Revenancer: 6 1 7 85.71428571428571
    guitarape: 26 27 53 49.056603773584904
    Axeraiser @Axeraiser : 70 30 100 70
    movntarget @MovnTarget : 32 9 41 78.04878048780488
    RasielCZ @RasielCZ : 110 30 140 78.57142857142857
    iPox @iPox : 6 10 16 37.5
    MarkXXIV: 150 80 230 65.21739130434783
    ShrineMaster: 99 21 120 82.5
    sokolov22 @Sokolov: 1 0 1 100
    XIThorXI @Chris : 12 12 24 50
    Nepallyon @nepyonisdead : 72 42 114 63.1578947368421
    TheProdigy1 @nepyonisdead : 4 2 6 66.66666666666666


    It goes by Oppenent, Player Wins, Player Losses, Total games played vs that opponent, and Win Rate(%) vs that player highlighted in yellow
    @Ballballer vs:

    THIS SCRIPT WAS RAN LIKE 3PM EST 03/12/19

    which contains the entire Match Making history from the player at the time after I finish running the script
    View attachment 7571

    @devilsrath vs:
    THIS SCRIPT WAS RAN LIKE 3PM EST 03/12/19

    Following spreadsheet was made from: https://drive.google.com/file/d/1R7FhraA8a_uhsmRue2bgVZ-OSVkn_M4f/view?usp=sharing
    which contains the entire Match Making history from the player at the time after I finish running the script
    View attachment 7573

    @Ryvirath vs:
    THIS SCRIPT WAS RAN LIKE 8:30PM EST 03/12/19

    Following spreadsheet was made from: https://drive.google.com/file/d/1aS6D2jcniGFEwEHcmQ2ebHD4HmXKBKCb/view?usp=sharing
    View attachment 7574

    @DMrBadguy vs:

    THIS SCRIPT WAS RAN LIKE 3:00PM EST 03/14/19
    @PoxBot
    This chart doesn't mean $h@t tbh because a lot of his games are played in unranked. Don't know if you want his unranked as well.

    Following spreadsheet was made from: https://drive.google.com/file/d/1-TU-UVqxNNiKTANAjpzhf8YCwfMnU5CB/view?usp=sharing
    which contains the entire Match Making history from the player at the time after I finish running the script

    View attachment 7575

    sinwind vs:
    THIS SCRIPT WAS RAN LIKE 3:00PM EST 03/14/19

    Following spreadsheet was made from: https://drive.google.com/file/d/1_a1CpNSdFLtUUxyRIWIEghh3ZWTdZ0Gh/view?usp=sharing
    which contains the entire Match Making history from the player at the time after I finish running the script

    View attachment 7578




    [​IMG]
     
    Last edited: Mar 14, 2019
  2. Sokolov

    Sokolov The One True Cactuar Octopi

  3. MikeLin

    MikeLin I need me some PIE!

    @Sokolov Thanks man your the best. Now tell me how to do it lol
     
  4. Sokolov

    Sokolov The One True Cactuar Octopi

    I copied and pasted your table into Notepad.

    Then I imported it into Excel as a space delimited file.

    Cleaned up the data (since your columns weren't strictly formatted).

    Then I converted the WR field to read as a %.

    Then I added header fields, and filtered on the Win Rate column and sorted from highest to lowest.

    Then I selected that column and applied a conditional formatting rule.
     
    devilsrath likes this.
  5. MikeLin

    MikeLin I need me some PIE!

    @Sokolov hmm i should probably stop being lazy and write my results into a csv file oh well
     
  6. xaznsoulx

    xaznsoulx Supreme Dream Team 夢想 隊

    78 times with mostly UD? I'll take it.
     
  7. JazzMan1221

    JazzMan1221 Better-Known Member

  8. Markoth

    Markoth Lord Inquisitor

    IS>SL
     
  9. Sokolov

    Sokolov The One True Cactuar Octopi

    I mean, it took me all of 3 minutes to do, so it's no big deal in this case.
     
  10. nepyonisdead

    nepyonisdead I need me some PIE!

    Id include the nepallyon account games vs him since the vast majority are there and on TheProdigy1

    % wise i think i am around 40 - 45% tho so wouldnt matter that much


    Also nicely done and great effort into piling that data together, not sure how u did it but good job
     
  11. MikeLin

    MikeLin I need me some PIE!

    @Ballballer vs:
    THIS SCRIPT WAS RAN LIKE 3PM EST 03/12/19
    Again it goes by Oppenent, ballballer wins, ballballer losses, total games played vs that opponent, and win rate vs that player highlighted in yellow
    Following spreadsheet was made from:
    which contains the entire Match Making history from the player at the time after I finish running the script

    upload_2019-3-12_18-21-34.png
     
    Last edited: Mar 12, 2019
  12. Chris

    Chris I need me some PIE!

    xithorxi, played tiny a fair few times on that
     
  13. MikeLin

    MikeLin I need me some PIE!

    Nepallyon: 72 42 114 63.1578947368421
    TheProdigy1: 4 2 6 66.66666666666666
     
  14. MikeLin

    MikeLin I need me some PIE!

    @devilsrath vs:
    THIS SCRIPT WAS RAN LIKE 3PM EST 03/12/19
    Again it goes by Oppenent, Player Wins, Player Losses, Total games played vs that opponent, and Win Rate(%) vs that player highlighted in yellow
    Following spreadsheet was made from: https://drive.google.com/file/d/1R7FhraA8a_uhsmRue2bgVZ-OSVkn_M4f/view?usp=sharing
    which contains the entire Match Making history from the player at the time after I finish running the script
    upload_2019-3-12_20-14-27.png
    @MentalMoles @devilsrath updated here for you guys too
    MentalMoles: 26 6 32 81.25
    Filthrog (Kithros' alt or main don't know): 0 3 3 0
     
    Last edited: Mar 13, 2019
    devilsrath likes this.
  15. JazzMan1221

    JazzMan1221 Better-Known Member

    Was there ever any question?

    On-topic, MY winrate vs. Tiny is exactly 1%. I beat him in a draft game once.......I guess he got really unlucky with his packs.
     
  16. MikeLin

    MikeLin I need me some PIE!

  17. PoxBot

    PoxBot I need me some PIE!

    newsbuff likes this.
  18. devilsrath

    devilsrath I need me some PIE!

    This is pretty awesome. Tiny's negative against iPox and i'm 7-1 - i win???? :D

    Kithros's orignal account was called Filthrog (I think) if you want to check that.

    It's good to see the stats vs. my nemesis. At least I can say i've beaten tiny more than anyone else in the game i guess.

    Cool post though, brought back some good memories - cheers
     
    Last edited: Mar 13, 2019
  19. MentalMoles

    MentalMoles I need me some PIE!

    whats devils win rate against me? is this all game types or just ranked?
     
  20. MikeLin

    MikeLin I need me some PIE!

    Wins, Losses, Total Games Played, and WR vs that player
    Filthrog: 0 3 3 0

    Um. you can use this file and control f through it https://drive.google.com/file/d/1R7FhraA8a_uhsmRue2bgVZ-OSVkn_M4f/view?usp=sharing
    to find games you played vs him as well. I believe you played 3 games vs Kith's alt that are unranked.
     
    Last edited: Mar 13, 2019

Share This Page