Crowdsourcing Dataset

Many analysts, one dataset: Making transparent how variations in analytical choi

@kaggle.kemalmaolana_crowdsourcing_dataset

Table List

1 table(1.89 MB)

Crowdstormingdatajuly1st

@kaggle.kemalmaolana_crowdsourcing_dataset.crowdstormingdatajuly1st

1.89 MB
146028 rows
28 columns

playershort PlayerShort	player Player	club Club	leaguecountry LeagueCountry	birthday Birthday	height Height	weight Weight	position Position	games Games	victories Victories	ties Ties	defeats Defeats	yellowcards YellowCards	photoid PhotoID	rater1 Rater1	rater2 Rater2	refnum RefNum	refcountry RefCountry	alpha_3 Alpha 3	meaniat MeanIAT	niat NIAT	seiat SeIAT	meanexp MeanExp	nexp NExp	seexp SeExp
lucas-wilchez	Lucas Wilchez	Real Zaragoza	Spain	31.08.1983	177	72	Attacking Midfielder	1			1		95212.jpg	0.25	0.5	1	1	GRC	0.326391469021736	712	0.0005641123543345	0.396	750	0.0026964901062936
john-utaka	John Utaka	Montpellier HSC	France	08.01.1982	179	82	Right Winger	1			1	1	1663.jpg	0.75	0.75	2	2	ZMB	0.203374724564378	40	0.0108748941063986	-0.204081632653061	49	0.0615044043187379
abdon-prats	Abdón Prats	RCD Mallorca	Spain	17.12.1992	181	79	nan	1		1		1	nan			3	3	ESP	0.369893594187172	1785	0.0002294896408664	0.588297311544544	1897	0.0010016473064931
pablo-mari	Pablo Marí	RCD Mallorca	Spain	31.08.1993	191	87	Center Back	1	1				nan			3	3	ESP	0.369893594187172	1785	0.0002294896408664	0.588297311544544	1897	0.0010016473064931
ruben-pena	Rubén Peña	Real Valladolid	Spain	18.07.1991	172	70	Right Midfielder	1	1				nan			3	3	ESP	0.369893594187172	1785	0.0002294896408664	0.588297311544544	1897	0.0010016473064931
aaron-hughes	Aaron Hughes	Fulham FC	England	08.11.1979	182	71	Center Back	1			1		3868.jpg	0.25		4	4	LUX	0.325185154120009	127	0.0032968095236196	0.538461538461538	130	0.013752210497518
aleksandar-kolarov	Aleksandar Kolarov	Manchester City	England	10.11.1985	187	80	Left Fullback	1	1				47704.jpg		0.25	4	4	LUX	0.325185154120009	127	0.0032968095236196	0.538461538461538	130	0.013752210497518
alexander-tettey	Alexander Tettey	Norwich City	England	04.04.1986	180	68	Defensive Midfielder	1			1		22356.jpg	1	1	4	4	LUX	0.325185154120009	127	0.0032968095236196	0.538461538461538	130	0.013752210497518
anders-lindegaard	Anders Lindegaard	Manchester United	England	13.04.1984	193	80	Goalkeeper	1		1			16528.jpg	0.25	0.25	4	4	LUX	0.325185154120009	127	0.0032968095236196	0.538461538461538	130	0.013752210497518
andreas-beck	Andreas Beck	1899 Hoffenheim	Germany	13.03.1987	180	70	Right Fullback	1	1				36499.jpg			4	4	LUX	0.325185154120009	127	0.0032968095236196	0.538461538461538	130	0.013752210497518


CREATE TABLE crowdstormingdatajuly1st (
  "playershort" VARCHAR,
  "player" VARCHAR,
  "club" VARCHAR,
  "leaguecountry" VARCHAR,
  "birthday" VARCHAR,
  "height" DOUBLE,
  "weight" DOUBLE,
  "position" VARCHAR,
  "games" BIGINT,
  "victories" BIGINT,
  "ties" BIGINT,
  "defeats" BIGINT,
  "goals" BIGINT,
  "yellowcards" BIGINT,
  "yellowreds" BIGINT,
  "redcards" BIGINT,
  "photoid" VARCHAR,
  "rater1" DOUBLE,
  "rater2" DOUBLE,
  "refnum" BIGINT,
  "refcountry" BIGINT,
  "alpha_3" VARCHAR,
  "meaniat" DOUBLE,
  "niat" DOUBLE,
  "seiat" DOUBLE,
  "meanexp" DOUBLE,
  "nexp" DOUBLE,
  "seexp" DOUBLE
);