Name: UCL | Players Data (2022/2023)
Creator: Kaggle
License: https://www.gnu.org/licenses/gpl.html

About this Dataset

UCL | Players Data (2022/2023)

Context
This dataset contains all the player stats of UEFA Champions League season 2021-22 . There were 868 unique players who participated in UCL 2022/2023. Most of the spreadsheets contain the same 719 participants who actually played in most matches.
**

Challenges:

Discover the weak points of any team.

Suggest players need to be sold, based on performance analysis.

Nominate Player of the season

About UEFA Champions League:
The UEFA Champions League is an annual club football competition organised by the UEFA and contested by top-division European clubs, deciding the competition winners through a round robin group stage to qualify for a double-legged knockout format, and a single leg final.

Spreadsheets:
ucl goalkeeper.csv
ucl advanced goalkeeping.csv
ucl defensive actions.csv
ucl goal and shot creation.csv
ucl miscellanous.csv
ucl pass types.csv
ucl passing.csv
ucl player playing time.csv
ucl possession.csv
ucl shooting.csv
ucl standard stats.csv

Disclaimer
The data collected are all publicly available and it's intended for educational purposes only.

**
Acknowledgement**
Cover image taken from internet.
Appreciate, Support, Share

Tables

Ucl Advanced Goalkeeping

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_advanced_goalkeeping

24.82 kB
50 rows
32 columns

CREATE TABLE ucl_advanced_goalkeeping (
  "player" VARCHAR,
  "nationality" VARCHAR,
  "position" VARCHAR,
  "club" VARCHAR,
  "age" VARCHAR,
  "born" VARCHAR,
  "n_90s" VARCHAR  -- 90s,
  "ga" VARCHAR,
  "pka" VARCHAR,
  "fk" VARCHAR,
  "ck" VARCHAR,
  "og" VARCHAR,
  "psxg" VARCHAR,
  "psxg_sot" VARCHAR,
  "psxg_3588aa" VARCHAR  -- PSxG+/-,
  "n__90" VARCHAR  -- /90,
  "cmp" VARCHAR,
  "att" VARCHAR,
  "cmp_fbd6fd" VARCHAR  -- Cmp%,
  "att_1" VARCHAR,
  "thr" VARCHAR,
  "launch" VARCHAR  -- Launch%,
  "avglen" VARCHAR,
  "att_2" VARCHAR,
  "launch_1" VARCHAR  -- Launch%.1,
  "avglen_1" VARCHAR,
  "opp" VARCHAR,
  "stp" VARCHAR,
  "stp_379866" VARCHAR  -- Stp%,
  "n__opa" VARCHAR  -- #OPA,
  "n__opa_90" VARCHAR  -- #OPA/90,
  "avgdist" VARCHAR
);

Ucl Defensive Actions

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_defensive_actions

41.09 kB
727 rows
23 columns

CREATE TABLE ucl_defensive_actions (
  "player" VARCHAR,
  "nationality" VARCHAR,
  "position" VARCHAR,
  "club" VARCHAR,
  "age" BIGINT,
  "born" BIGINT,
  "n_90s" DOUBLE  -- 90s,
  "no_of_players_tackled" BIGINT  -- No. Of Players Tackled,
  "tackles_won" BIGINT,
  "tackles_def_3rd" BIGINT  -- Tackles (Def 3rd),
  "tackles_mid_3rd" BIGINT  -- Tackles (Mid 3rd),
  "tackles_att_3rd" BIGINT  -- Tackles (Att 3rd),
  "no_of_dribblers_tackled" BIGINT  -- No. Of Dribblers Tackled,
  "dribbles_challenged_total" BIGINT  -- Dribbles Challenged (total),
  "n__of_dribblers_successfully_tackled" DOUBLE  -- % Of Dribblers Successfully Tackled,
  "challenges_lost" BIGINT,
  "blocks" BIGINT,
  "shots_blocked" BIGINT,
  "passes_blocked" BIGINT,
  "interceptions" BIGINT,
  "tackles_internceptions" BIGINT  -- Tackles + Internceptions,
  "clearances" BIGINT,
  "errors" BIGINT
);

Ucl Goal And Shot Creation

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_goal_and_shot_creation

38.67 kB
727 rows
23 columns

CREATE TABLE ucl_goal_and_shot_creation (
  "player" VARCHAR,
  "nationality" VARCHAR,
  "position" VARCHAR,
  "club" VARCHAR,
  "age" BIGINT,
  "born" BIGINT,
  "n_90s" DOUBLE  -- 90s,
  "sca" BIGINT,
  "sca_90" DOUBLE,
  "sca_passlive" BIGINT  -- SCA (PassLive),
  "sca_passdead" BIGINT  -- SCA (PassDead),
  "sca_to" BIGINT  -- SCA (TO),
  "sca_sh" BIGINT  -- SCA(Sh),
  "sca_fld" BIGINT  -- SCA(Fld),
  "sca_def" BIGINT  -- SCA(Def),
  "gca" BIGINT,
  "gca_90" DOUBLE,
  "gca_passlive" BIGINT  -- GCA (PassLive),
  "gca_passdead" BIGINT  -- GCA (PassDead),
  "gca_to" BIGINT  -- GCA (TO),
  "gca_sh" BIGINT  -- GCA (Sh),
  "gca_fld" BIGINT  -- GCA (Fld),
  "gca_def" DOUBLE  -- GCA (Def)
);

Ucl Goalkeeper

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_goalkeeper

19.5 kB
49 rows
25 columns

CREATE TABLE ucl_goalkeeper (
  "player" VARCHAR,
  "nationality" VARCHAR,
  "position" VARCHAR,
  "club" VARCHAR,
  "age" BIGINT,
  "born" BIGINT,
  "mp" BIGINT,
  "starts" BIGINT,
  "min" BIGINT,
  "n_90s" DOUBLE  -- 90s,
  "ga" BIGINT,
  "ga90" DOUBLE,
  "sota" BIGINT,
  "saves" BIGINT,
  "save" DOUBLE  -- Save%,
  "w" BIGINT,
  "d" BIGINT,
  "l" BIGINT,
  "cs" BIGINT,
  "cs_2b84ea" DOUBLE  -- CS%,
  "pkatt" BIGINT,
  "pka" BIGINT,
  "pksv" BIGINT,
  "pkm" BIGINT,
  "save_1" DOUBLE  -- Save%.1
);

Ucl Miscellanous

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_miscellanous

38.69 kB
727 rows
23 columns

CREATE TABLE ucl_miscellanous (
  "player" VARCHAR,
  "nationality" VARCHAR,
  "position" VARCHAR,
  "club" VARCHAR,
  "age" BIGINT,
  "born" BIGINT,
  "n_90s" DOUBLE  -- 90s,
  "yellow_cards" BIGINT,
  "red_cards" BIGINT,
  "n_2nd_yellows" BIGINT  -- 2nd Yellows,
  "fouls_comitted" BIGINT,
  "fouls_drawn" BIGINT,
  "crosses" BIGINT,
  "interceptions" BIGINT,
  "tackles_won" BIGINT,
  "penalties_won" BIGINT,
  "penalties_comitted" BIGINT,
  "own_goals" BIGINT,
  "ball_recoveries" BIGINT,
  "unnamed_19" BIGINT  -- Unnamed: 19,
  "unnamed_20" BIGINT  -- Unnamed: 20,
  "unnamed_21" BIGINT  -- Unnamed: 21,
  "unnamed_22" DOUBLE  -- Unnamed: 22
);

Ucl Passing

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_passing

70.92 kB
727 rows
30 columns

CREATE TABLE ucl_passing (
  "player" VARCHAR,
  "nationality" VARCHAR,
  "position" VARCHAR,
  "club" VARCHAR,
  "age" BIGINT,
  "born" BIGINT,
  "n_90s" DOUBLE  -- 90s,
  "total_passes_completed" BIGINT,
  "total_passes_attempted" BIGINT,
  "total_passes_completion" DOUBLE  -- Total Passes Completion %,
  "total_passing_distance" BIGINT,
  "progressive_passing_distance" BIGINT,
  "passes_attempted_short" BIGINT  -- Passes Attempted (short),
  "passes_completed_short" BIGINT  -- Passes Completed (short),
  "passes_completed_short_a5ac60" DOUBLE  -- Passes Completed (short) %,
  "passes_attempted_medium" BIGINT  -- Passes Attempted (medium),
  "passes_completed_medium" BIGINT  -- Passes Completed (medium),
  "passes_completed_medium_d6701c" DOUBLE  -- Passes Completed (medium) %,
  "passes_attempted_long" BIGINT  -- Passes Attempted (long),
  "passes_completed_long" BIGINT  -- Passes Completed (long),
  "passes_completed_long_4c86b9" DOUBLE  -- Passes Completed (long) %,
  "assists" BIGINT,
  "expected_assist_goals_xag" DOUBLE  -- Expected Assist Goals (xAG),
  "xa" DOUBLE,
  "a_xag" DOUBLE,
  "key_passes" BIGINT,
  "passes_into_final_third" BIGINT,
  "passes_into_penalty_area" BIGINT,
  "crosses_into_penalty_area" BIGINT,
  "progressive_passes" BIGINT
);

Ucl Pass Types

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_pass_types

44.32 kB
727 rows
22 columns

CREATE TABLE ucl_pass_types (
  "player" VARCHAR,
  "nationality" VARCHAR,
  "position" VARCHAR,
  "club" VARCHAR,
  "age" BIGINT,
  "born" BIGINT,
  "n_90s" DOUBLE  -- 90s,
  "total_passes_attempted" BIGINT,
  "live_ball_passes" BIGINT,
  "dead_ball_passes" BIGINT,
  "passes_from_free_kicks" BIGINT,
  "through_balls" BIGINT,
  "switches" BIGINT,
  "crosses" BIGINT,
  "throw_ins_taken" BIGINT,
  "corner_kicks" BIGINT,
  "inswinging_corner_kicks" BIGINT,
  "outswinging_corner_kicks" BIGINT,
  "straight_corner_kicks" BIGINT,
  "passes_completed" BIGINT,
  "passes_offside" BIGINT,
  "passes_blocked" BIGINT
);

Ucl Player Playing Time

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_player_playing_time

65.76 kB
877 rows
28 columns

CREATE TABLE ucl_player_playing_time (
  "player" VARCHAR,
  "nationality" VARCHAR,
  "position" VARCHAR,
  "club" VARCHAR,
  "age" BIGINT,
  "born" BIGINT,
  "mp" BIGINT,
  "min" DOUBLE,
  "mn_mp" DOUBLE,
  "min_59d8e8" DOUBLE  -- Min%,
  "n_90s" DOUBLE  -- 90s,
  "starts" BIGINT,
  "mn_start" DOUBLE,
  "compl" BIGINT,
  "subs" BIGINT,
  "mn_sub" DOUBLE,
  "unsub" BIGINT,
  "ppm" DOUBLE,
  "ong" DOUBLE,
  "onga" DOUBLE,
  "n__error" DOUBLE  -- #ERROR!,
  "n__error_1" DOUBLE  -- #ERROR!.1,
  "on_off" DOUBLE,
  "onxg" DOUBLE,
  "onxga" DOUBLE,
  "xg" DOUBLE  -- XG+/-,
  "xg_90" DOUBLE  -- XG+/-90,
  "on_off_1" DOUBLE
);

Ucl Possession

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_possession

67.05 kB
727 rows
29 columns

CREATE TABLE ucl_possession (
  "player" VARCHAR,
  "nationality" VARCHAR,
  "position" VARCHAR,
  "club" VARCHAR,
  "age" BIGINT,
  "born" BIGINT,
  "n_90s" DOUBLE  -- 90s,
  "touches" BIGINT,
  "touches_def_pen" BIGINT  -- Touches (Def Pen),
  "touches_def_3rd" BIGINT  -- Touches (Def 3rd),
  "touches_mid_3rd" BIGINT  -- Touches (Mid 3rd),
  "touches_att_3rd" BIGINT  -- Touches (Att 3rd),
  "touches_att_pen" BIGINT  -- Touches (Att Pen),
  "touches_liveball" BIGINT  -- Touches (LiveBall),
  "take_ons_attempted" BIGINT,
  "take_ons_completed" BIGINT,
  "successful_takeon" DOUBLE  -- Successful Takeon (%),
  "times_tackled_during_takeon" BIGINT,
  "times_tackled_during_takeon_ea7c3d" DOUBLE  -- Times Tackled During Takeon (%),
  "carries" BIGINT,
  "total_carrying_distance" BIGINT,
  "progressive_carrying_distance" BIGINT,
  "progressive_carries" BIGINT,
  "carries_into_final_third" BIGINT,
  "carries_into_penalty_area" BIGINT,
  "miscontrols" BIGINT,
  "dispossessed" BIGINT,
  "passes_received" BIGINT,
  "progressive_passes_received" BIGINT
);

Ucl Shooting

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_shooting

46.66 kB
726 rows
25 columns

CREATE TABLE ucl_shooting (
  "player" VARCHAR,
  "nationality" VARCHAR,
  "position" VARCHAR,
  "club" VARCHAR,
  "age" BIGINT,
  "born" BIGINT,
  "n_90s" DOUBLE  -- 90s,
  "goals" BIGINT,
  "shot_total" BIGINT,
  "shots_on_target" BIGINT,
  "shots_on_target_05c0e9" DOUBLE  -- Shots On Target %,
  "shots_total_90" DOUBLE,
  "shots_on_target_90" DOUBLE,
  "goals_shot" DOUBLE,
  "goals_shot_on_target" DOUBLE,
  "avg_shot_distance" DOUBLE,
  "free_kicks" BIGINT,
  "penalty_kicks" BIGINT,
  "penalty_kicks_attempted" BIGINT,
  "expected_goal" DOUBLE,
  "non_penalty_expected_goals" DOUBLE,
  "non_penalty_expected_goals_shot" DOUBLE,
  "goals_minus_expected_goals" DOUBLE,
  "non_penalty_goals_minus_non_penalty_expected_goals" VARCHAR,
  "unnamed_24" VARCHAR  -- Unnamed: 24
);

Ucl Standard Stats

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_standard_stats

59.16 kB
727 rows
35 columns

CREATE TABLE ucl_standard_stats (
  "player" VARCHAR,
  "nationality" VARCHAR,
  "pos" VARCHAR,
  "club" VARCHAR,
  "age" BIGINT,
  "born" BIGINT,
  "mp" BIGINT,
  "starts" BIGINT,
  "min" BIGINT,
  "n_90s" DOUBLE  -- 90s,
  "goals" BIGINT,
  "assists" BIGINT,
  "g_a" BIGINT,
  "g_pk" BIGINT,
  "pk" BIGINT,
  "pkatt" BIGINT,
  "crdyellow" BIGINT,
  "crdred" BIGINT,
  "xg" DOUBLE,
  "npxg" DOUBLE,
  "xag" DOUBLE,
  "npxg_xag" DOUBLE,
  "prgc" BIGINT,
  "prgp" BIGINT,
  "prgr" BIGINT,
  "gls" DOUBLE,
  "ast" DOUBLE,
  "g_a_1" DOUBLE,
  "g_pk_1" DOUBLE,
  "g_a_pk" DOUBLE,
  "xg_1" DOUBLE,
  "xag_1" DOUBLE,
  "xg_xag" DOUBLE,
  "npxg_1" DOUBLE,
  "npxg_xag_1" DOUBLE
);