Dataset: UCL | Players Data (2022/2023)

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.24 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,
  "ga" VARCHAR,
  "pka" VARCHAR,
  "fk" VARCHAR,
  "ck" VARCHAR,
  "og" VARCHAR,
  "psxg" VARCHAR,
  "psxg_sot" VARCHAR,
  "psxg_3588aa" VARCHAR,
  "n__90" VARCHAR,
  "cmp" VARCHAR,
  "att" VARCHAR,
  "cmp_fbd6fd" VARCHAR,
  "att_1" VARCHAR,
  "thr" VARCHAR,
  "launch" VARCHAR,
  "avglen" VARCHAR,
  "att_2" VARCHAR,
  "launch_1" VARCHAR,
  "avglen_1" VARCHAR,
  "opp" VARCHAR,
  "stp" VARCHAR,
  "stp_379866" VARCHAR,
  "n__opa" VARCHAR,
  "n__opa_90" VARCHAR,
  "avgdist" VARCHAR
);

Ucl Defensive Actions

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_defensive_actions

40.13 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,
  "no_of_players_tackled" BIGINT,
  "tackles_won" BIGINT,
  "tackles_def_3rd" BIGINT,
  "tackles_mid_3rd" BIGINT,
  "tackles_att_3rd" BIGINT,
  "no_of_dribblers_tackled" BIGINT,
  "dribbles_challenged_total" BIGINT,
  "n__of_dribblers_successfully_tackled" DOUBLE,
  "challenges_lost" BIGINT,
  "blocks" BIGINT,
  "shots_blocked" BIGINT,
  "passes_blocked" BIGINT,
  "interceptions" BIGINT,
  "tackles_internceptions" BIGINT,
  "clearances" BIGINT,
  "errors" BIGINT
);

Ucl Goal And Shot Creation

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_goal_and_shot_creation

37.76 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,
  "sca" BIGINT,
  "sca_90" DOUBLE,
  "sca_passlive" BIGINT,
  "sca_passdead" BIGINT,
  "sca_to" BIGINT,
  "sca_sh" BIGINT,
  "sca_fld" BIGINT,
  "sca_def" BIGINT,
  "gca" BIGINT,
  "gca_90" DOUBLE,
  "gca_passlive" BIGINT,
  "gca_passdead" BIGINT,
  "gca_to" BIGINT,
  "gca_sh" BIGINT,
  "gca_fld" BIGINT,
  "gca_def" DOUBLE
);

Ucl Goalkeeper

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_goalkeeper

19.04 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,
  "ga" BIGINT,
  "ga90" DOUBLE,
  "sota" BIGINT,
  "saves" BIGINT,
  "save" DOUBLE,
  "w" BIGINT,
  "d" BIGINT,
  "l" BIGINT,
  "cs" BIGINT,
  "cs_2b84ea" DOUBLE,
  "pkatt" BIGINT,
  "pka" BIGINT,
  "pksv" BIGINT,
  "pkm" BIGINT,
  "save_1" DOUBLE
);

Ucl Miscellanous

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_miscellanous

37.78 KB
727 rows
23 columns


CREATE TABLE ucl_miscellanous (
  "player" VARCHAR,
  "nationality" VARCHAR,
  "position" VARCHAR,
  "club" VARCHAR,
  "age" BIGINT,
  "born" BIGINT,
  "n_90s" DOUBLE,
  "yellow_cards" BIGINT,
  "red_cards" BIGINT,
  "n_2nd_yellows" BIGINT,
  "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_20" BIGINT,
  "unnamed_21" BIGINT,
  "unnamed_22" DOUBLE
);

Ucl Pass Types

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_pass_types

43.28 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,
  "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 Passing

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_passing

69.25 KB
727 rows
30 columns


CREATE TABLE ucl_passing (
  "player" VARCHAR,
  "nationality" VARCHAR,
  "position" VARCHAR,
  "club" VARCHAR,
  "age" BIGINT,
  "born" BIGINT,
  "n_90s" DOUBLE,
  "total_passes_completed" BIGINT,
  "total_passes_attempted" BIGINT,
  "total_passes_completion" DOUBLE,
  "total_passing_distance" BIGINT,
  "progressive_passing_distance" BIGINT,
  "passes_attempted_short" BIGINT,
  "passes_completed_short" BIGINT,
  "passes_completed_short_a5ac60" DOUBLE,
  "passes_attempted_medium" BIGINT,
  "passes_completed_medium" BIGINT,
  "passes_completed_medium_d6701c" DOUBLE,
  "passes_attempted_long" BIGINT,
  "passes_completed_long" BIGINT,
  "passes_completed_long_4c86b9" DOUBLE,
  "assists" BIGINT,
  "expected_assist_goals_xag" DOUBLE,
  "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 Player Playing Time

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_player_playing_time

64.22 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,
  "n_90s" DOUBLE,
  "starts" BIGINT,
  "mn_start" DOUBLE,
  "compl" BIGINT,
  "subs" BIGINT,
  "mn_sub" DOUBLE,
  "unsub" BIGINT,
  "ppm" DOUBLE,
  "ong" DOUBLE,
  "onga" DOUBLE,
  "n__error" DOUBLE,
  "n__error_1" DOUBLE,
  "on_off" DOUBLE,
  "onxg" DOUBLE,
  "onxga" DOUBLE,
  "xg" DOUBLE,
  "xg_90" DOUBLE,
  "on_off_1" DOUBLE
);

Ucl Possession

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_possession

65.48 KB
727 rows
29 columns


CREATE TABLE ucl_possession (
  "player" VARCHAR,
  "nationality" VARCHAR,
  "position" VARCHAR,
  "club" VARCHAR,
  "age" BIGINT,
  "born" BIGINT,
  "n_90s" DOUBLE,
  "touches" BIGINT,
  "touches_def_pen" BIGINT,
  "touches_def_3rd" BIGINT,
  "touches_mid_3rd" BIGINT,
  "touches_att_3rd" BIGINT,
  "touches_att_pen" BIGINT,
  "touches_liveball" BIGINT,
  "take_ons_attempted" BIGINT,
  "take_ons_completed" BIGINT,
  "successful_takeon" DOUBLE,
  "times_tackled_during_takeon" BIGINT,
  "times_tackled_during_takeon_ea7c3d" DOUBLE,
  "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

45.57 KB
726 rows
25 columns


CREATE TABLE ucl_shooting (
  "player" VARCHAR,
  "nationality" VARCHAR,
  "position" VARCHAR,
  "club" VARCHAR,
  "age" BIGINT,
  "born" BIGINT,
  "n_90s" DOUBLE,
  "goals" BIGINT,
  "shot_total" BIGINT,
  "shots_on_target" BIGINT,
  "shots_on_target_05c0e9" DOUBLE,
  "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
);

Ucl Standard Stats

@kaggle.hammadjavaid_ucl_matches_and_players_data_20222023.ucl_standard_stats

57.78 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,
  "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
);