Sports Data Analysis
FIFA data to see how to apply EDA and Statistics concepts
@kaggle.mukeshmanral_fifa_data_for_eda_and_stats
FIFA data to see how to apply EDA and Statistics concepts
@kaggle.mukeshmanral_fifa_data_for_eda_and_stats
You want to create your own football club named ‘ultralearnManral’.
Create some reports/kind of things which recommends data backed players for main team
NOTE:
As always assume budget for hiring players to be limited, team needs 18-22 possible players to choose from.
CREATE TABLE fifa_eda_stats (
"id" BIGINT,
"name" VARCHAR,
"age" BIGINT,
"nationality" VARCHAR,
"overall" BIGINT,
"potential" BIGINT,
"club" VARCHAR,
"value" VARCHAR,
"wage" VARCHAR,
"preferred_foot" VARCHAR,
"international_reputation" DOUBLE,
"weak_foot" DOUBLE,
"skill_moves" DOUBLE,
"work_rate" VARCHAR,
"body_type" VARCHAR,
"position" VARCHAR,
"jersey_number" DOUBLE,
"joined" TIMESTAMP,
"loaned_from" VARCHAR,
"contract_valid_until" VARCHAR,
"height" VARCHAR,
"weight" VARCHAR,
"crossing" DOUBLE,
"finishing" DOUBLE,
"headingaccuracy" DOUBLE,
"shortpassing" DOUBLE,
"volleys" DOUBLE,
"dribbling" DOUBLE,
"curve" DOUBLE,
"fkaccuracy" DOUBLE,
"longpassing" DOUBLE,
"ballcontrol" DOUBLE,
"acceleration" DOUBLE,
"sprintspeed" DOUBLE,
"agility" DOUBLE,
"reactions" DOUBLE,
"balance" DOUBLE,
"shotpower" DOUBLE,
"jumping" DOUBLE,
"stamina" DOUBLE,
"strength" DOUBLE,
"longshots" DOUBLE,
"aggression" DOUBLE,
"interceptions" DOUBLE,
"positioning" DOUBLE,
"vision" DOUBLE,
"penalties" DOUBLE,
"composure" DOUBLE,
"marking" DOUBLE,
"standingtackle" DOUBLE,
"slidingtackle" DOUBLE,
"gkdiving" DOUBLE,
"gkhandling" DOUBLE,
"gkkicking" DOUBLE,
"gkpositioning" DOUBLE,
"gkreflexes" DOUBLE,
"release_clause" VARCHAR
);Anyone who has the link will be able to view this.