Efootball-pes-2019-all-players
efootball pes 2019 Complete players dataset
@kaggle.homerkommrad_efootball_pes_2019_all_players
efootball pes 2019 Complete players dataset
@kaggle.homerkommrad_efootball_pes_2019_all_players
With this player data of almost all players that matter , one can find interesting outcasts or the changing trends , compared to other years' data
I wouldn't be doing this If I were handed the data helpfully by some gate keepers
CREATE TABLE pes_2019_all_players (
"name" VARCHAR,
"shirt_number" VARCHAR,
"team_name" VARCHAR,
"league" VARCHAR,
"nationality" VARCHAR,
"region" VARCHAR,
"height" BIGINT,
"weight" BIGINT,
"age" BIGINT,
"foot" VARCHAR,
"condition" VARCHAR,
"registered_position" VARCHAR,
"lwf" DOUBLE,
"ss" DOUBLE,
"cf" DOUBLE,
"rwf" DOUBLE,
"lmf" BIGINT,
"dmf" BIGINT,
"cmf" BIGINT,
"amf" BIGINT,
"rmf" BIGINT,
"lb" BIGINT,
"cb" BIGINT,
"rb" BIGINT,
"attacking_prowess" BIGINT,
"ball_control" BIGINT,
"dribbling" BIGINT,
"low_pass" BIGINT,
"lofted_pass" BIGINT,
"finishing" BIGINT,
"place_kicking" BIGINT,
"swerve" BIGINT,
"header" BIGINT,
"defensive_prowess" BIGINT,
"ball_winning" BIGINT,
"kicking_power" BIGINT,
"speed" BIGINT,
"explosive_power" BIGINT,
"unwavering_balance" BIGINT,
"physical_contact" BIGINT,
"jump" BIGINT,
"goalkeeping" BIGINT,
"gk_catch" BIGINT,
"clearing" BIGINT,
"reflexes" BIGINT,
"coverage" BIGINT,
"stamina" BIGINT,
"weak_foot_usage" BIGINT,
"weak_foot_accuracy" BIGINT,
"form" BIGINT,
"injury_resistance" BIGINT,
"overall_rating" BIGINT,
"rating_as_gk" BIGINT,
"rating_as_cb" BIGINT,
"rating_as_lb" BIGINT,
"rating_as_rb" BIGINT,
"rating_as_dmf" BIGINT,
"rating_as_cmf" BIGINT,
"rating_as_lmf" BIGINT,
"rating_as_rmf" BIGINT,
"rating_as_amf" BIGINT,
"rating_as_lwf" BIGINT,
"rating_as_rwf" BIGINT,
"rating_as_ss" BIGINT,
"rating_as_cf" BIGINT,
"playing_style" VARCHAR,
"skill_malicia" BIGINT,
"skill_cross_over_turn" BIGINT,
"skill_early_cross" BIGINT,
"skill_first_time_shot" BIGINT,
"skill_incisive_run" BIGINT,
"skill_one_touch_pass" BIGINT,
"skill_chip_shot_control" BIGINT,
"skill_heel_trick" BIGINT,
"skill_man_marking" BIGINT,
"skill_interception" BIGINT,
"skill_gk_penalty_saver" BIGINT,
"skill_penalty_specialist" BIGINT,
"skill_step_on_skill_control" BIGINT,
"skill_rising_shots" BIGINT,
"skill_marseille_turn" BIGINT,
"skill_gk_high_punt" BIGINT,
"skill_heading" BIGINT,
"skill_dipping_shot" BIGINT,
"skill_outside_curler" BIGINT,
"skill_captaincy" BIGINT,
"skill_gamesmanship" BIGINT,
"skill_gk_low_punt" BIGINT,
"skill_low_lofted_pass" BIGINT,
"skill_through_passing" BIGINT,
"skill_fighting_spirit" BIGINT,
"skill_flip_flap" BIGINT,
"skill_weighted_pass" BIGINT,
"skill_pinpoint_crossing" BIGINT,
"skill_sombrero" BIGINT,
"skill_acrobatic_clear" BIGINT,
"skill_cut_behind_turn" BIGINT,
"skill_long_range_drive" BIGINT,
"skill_scotch_move" BIGINT,
"skill_acrobatic_finishing" BIGINT
);CREATE TABLE pes2019_all_players_v2 (
"name" VARCHAR,
"overall_rating" BIGINT,
"ball_color" VARCHAR,
"rating_stars" BIGINT,
"shirt_number" VARCHAR,
"team_name" VARCHAR,
"league" VARCHAR,
"nationality" VARCHAR,
"region" VARCHAR,
"height" BIGINT,
"weight" BIGINT,
"age" BIGINT,
"foot" VARCHAR,
"condition" VARCHAR,
"registered_position" VARCHAR,
"lwf" DOUBLE,
"ss" DOUBLE,
"cf" DOUBLE,
"rwf" DOUBLE,
"lmf" BIGINT,
"dmf" BIGINT,
"cmf" BIGINT,
"amf" BIGINT,
"rmf" BIGINT,
"lb" BIGINT,
"cb" BIGINT,
"rb" BIGINT,
"attacking_prowess" BIGINT,
"ball_control" BIGINT,
"dribbling" BIGINT,
"low_pass" BIGINT,
"lofted_pass" BIGINT,
"finishing" BIGINT,
"place_kicking" BIGINT,
"swerve" BIGINT,
"header" BIGINT,
"defensive_prowess" BIGINT,
"ball_winning" BIGINT,
"kicking_power" BIGINT,
"speed" BIGINT,
"explosive_power" BIGINT,
"unwavering_balance" BIGINT,
"physical_contact" BIGINT,
"jump" BIGINT,
"goalkeeping" BIGINT,
"gk_catch" BIGINT,
"clearing" BIGINT,
"reflexes" BIGINT,
"coverage" BIGINT,
"stamina" BIGINT,
"weak_foot_usage" BIGINT,
"weak_foot_accuracy" BIGINT,
"form" BIGINT,
"injury_resistance" BIGINT,
"rating_as_gk" BIGINT,
"rating_as_cb" BIGINT,
"rating_as_lb" BIGINT,
"rating_as_rb" BIGINT,
"rating_as_dmf" BIGINT,
"rating_as_cmf" BIGINT,
"rating_as_lmf" BIGINT,
"rating_as_rmf" BIGINT,
"rating_as_amf" BIGINT,
"rating_as_lwf" BIGINT,
"rating_as_rwf" BIGINT,
"rating_as_ss" BIGINT,
"rating_as_cf" BIGINT,
"playing_style" VARCHAR,
"skill_malicia" BIGINT,
"skill_cross_over_turn" BIGINT,
"skill_early_cross" BIGINT,
"skill_first_time_shot" BIGINT,
"skill_incisive_run" BIGINT,
"skill_one_touch_pass" BIGINT,
"skill_chip_shot_control" BIGINT,
"skill_heel_trick" BIGINT,
"skill_man_marking" BIGINT,
"skill_interception" BIGINT,
"skill_gk_penalty_saver" BIGINT,
"skill_penalty_specialist" BIGINT,
"skill_step_on_skill_control" BIGINT,
"skill_rising_shots" BIGINT,
"skill_marseille_turn" BIGINT,
"skill_gk_high_punt" BIGINT,
"skill_heading" BIGINT,
"skill_dipping_shot" BIGINT,
"skill_outside_curler" BIGINT,
"skill_captaincy" BIGINT,
"skill_gamesmanship" BIGINT,
"skill_gk_low_punt" BIGINT,
"skill_low_lofted_pass" BIGINT,
"skill_through_passing" BIGINT,
"skill_fighting_spirit" BIGINT,
"skill_flip_flap" BIGINT,
"skill_weighted_pass" BIGINT,
"skill_pinpoint_crossing" BIGINT,
"skill_sombrero" BIGINT,
"skill_acrobatic_clear" BIGINT,
"skill_cut_behind_turn" BIGINT,
"skill_long_range_drive" BIGINT
);Anyone who has the link will be able to view this.