This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
rank | Nickname | total_points | count_of_predictions | |
---|---|---|---|---|
1st | Lyonzy | 78 | 92 | |
2nd | Yanju | 76 | 92 | |
3rd | Potato XI | 75 | 92 | |
4th | rangsat | 73 | 92 | |
5th | TonyMarshalinho | 71 | 92 | |
6th | Danny New | 68 | 72 | |
6th | dnina10 | 68 | 92 | |
6th | Jake | 68 | 92 | |
9th | MikeDexter | 67 | 92 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
rank | Nickname | rps | count_of_predictions | |
---|---|---|---|---|
1st | Foxy | 0.181268125 | 80 | |
2nd | Danny New | 0.18391338028169013 | 71 | |
3rd | SK1 | 0.18915422535211268 | 71 | |
4th | Jimbles | 0.19301463414634146 | 82 | |
5th | Alain | 0.19380494505494505 | 91 | |
6th | Sal_the_Octopus? | 0.19784239130434783 | 92 | |
7th | Dr Chris Brown | 0.19815434782608696 | 92 | |
8th | PIRES | 0.19903419169148734 | 92 | |
9th | rangsat | 0.1996467391304348 | 92 |
We can make this file beautiful and searchable if this error is corrected: It looks like row 9 should actually have 14 columns, instead of 13. in line 8.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
,PERSON_ID,DISPLAY_LAST_COMMA_FIRST,DISPLAY_FIRST_LAST,ROSTERSTATUS,FROM_YEAR,TO_YEAR,PLAYERCODE,TEAM_ID,TEAM_CITY,TEAM_NAME,TEAM_ABBREVIATION,TEAM_CODE,GAMES_PLAYED_FLAG | |
0,203518,"Abrines, Alex",Alex Abrines,1,2016,2017,alex_abrines,1610612760,Oklahoma City,Thunder,OKC,thunder,Y | |
1,203112,"Acy, Quincy",Quincy Acy,1,2012,2017,quincy_acy,1610612751,Brooklyn,Nets,BKN,nets,Y | |
2,203500,"Adams, Steven",Steven Adams,1,2013,2017,steven_adams,1610612760,Oklahoma City,Thunder,OKC,thunder,Y | |
3,1628389,"Adebayo, Bam",Bam Adebayo,1,2017,2017,bam_adebayo,1610612748,Miami,Heat,MIA,heat,Y | |
4,201167,"Afflalo, Arron",Arron Afflalo,1,2007,2017,arron_afflalo,1610612753,Orlando,Magic,ORL,magic,Y | |
5,201582,"Ajinca, Alexis",Alexis Ajinca,1,2008,2017,alexis_ajinca,1610612740,New Orleans,Pelicans,NOP,pelicans,Y | |
6,202332,"Aldrich, Cole",Cole Aldrich,1,2010,2017,cole_aldrich,1610612750,Minnesota,Timberwolves,MIN,timberwolves,Y | |
7,200746,"Aldridge, LaMarcus",LaMarcus Aldridge,1,2006,2017,lamarcus_aldridge,1610612759,San Antonio,Spurs,SAS,spu |
We can make this file beautiful and searchable if this error is corrected: It looks like row 7 should actually have 31 columns, instead of 29. in line 6.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
,Game_ID,Team_ID,GAME_DATE,MATCHUP,WL,W,L,W_PCT,MIN,FGM,FGA,FG_PCT,FG3M,FG3A,FG3_PCT,FTM,FTA,FT_PCT,OREB,DREB,REB,AST,STL,BLK,TOV,PF,PTS,Opp_ID,Team,Opponent | |
0,0021700576,1610612737,"JAN 05, 2018",ATL @ POR,L,10,28,0.263,240,30,83,0.361,8,26,0.308,21,25,0.84,11,28,39,14,7,5,16,16,89,1610612757,ATL,POR | |
1,0021700533,1610612737,"DEC 30, 2017",ATL vs. POR,W,10,26,0.278,240,40,89,0.449,14,30,0.467,10,15,0.667,13,32,45,29,12,3,13,16,104,1610612757,ATL,POR | |
2,0021700549,1610612739,"JAN 02, 2018",CLE vs. POR,W,25,12,0.676,240,43,83,0.518,13,32,0.406,28,37,0.757,8,32,40,28,11,4,10,17,127,1610612757,CLE,POR | |
3,0021700333,1610612740,"DEC 02, 2017",NOP @ POR,W,12,11,0.522,240,45,86,0.523,15,31,0.484,18,25,0.72,4,44,48,22,2,3,11,16,123,1610612757,NOP,POR | |
4,0021700053,1610612740,"OCT 24, 2017",NOP @ POR,L,1,3,0.25,240,30,76,0.395,9,30,0.3,24,32,0.75,4,38,42,17,5,7,17,26,93,1610612757,NOP,POR | |
5,0021700547,1610612741,"JAN 01, 2018",CHI vs. POR,L,13,24,0.351,265,45,104,0.433,11,27,0.407,19,23,0.826,15,43,58,28,5,7,12,21,120,161 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
player_name | new_club | new_league | previous_club | previous_league | price_euros | price_pounds | timestamp | transfer_type | ||
---|---|---|---|---|---|---|---|---|---|---|
0 | Juan Cuadrado | Juventus | Serie A | Chelsea | Premier League | 20000000.0 | 17330000.0 | 2017-05-23 12:09:52 | fee | |
1 | Vinícius Júnior | Real Madrid | La Liga | Flamengo | Campeonato Brasileiro Série A | 46000000.0 | 39600000.0 | 2017-05-24 12:15:56 | fee | |
2 | Vinícius Júnior | Flamengo | Campeonato Brasileiro Série A | Real Madrid | La Liga | 0.0 | 0.0 | 2017-05-24 12:21:09 | loan | |
3 | Michael Kightly | Free agent | Free agent | Burnley | Premier League | 0.0 | 0.0 | 2017-05-24 12:26:08 | released | |
4 | Joey Barton | Free agent | Free agent | Burnley | Premier League | 0.0 | 0.0 | 2017-05-24 12:27:24 | released | |
5 | Matthias Ostrzolek | Hannover 96 | Bundesliga | Hamburg | Bundesliga | 0.0 | 0.0 | 2017-05-24 12:30:04 | fee | |
6 | Benoît Trémoulinas | Free agent | Free agent | Sevilla | La Liga | 0.0 | 0.0 | 2017-05-24 12:31:40 | released | |
7 | Youri Tielemans | Monaco | Ligue 1 | Anderlecht | Jupiler League | 25000000.0 | 21600000.0 | 2017-05-24 20:06:33 | fee | |
8 | Diego López | Espanyol | La Liga | Milan | Serie A | 0.0 | 0.0 | 2017-05-25 07:43:21 | fee |