UCL | Matches & Players Data

Goals, Assists, Attack, Defence, Passing, Field Control, GK Data of UCL 2021-22

@kaggle.azminetoushikwasi_ucl_202122_uefa_champions_league

Table List

8 tables(128.22 KB)

Goals

Distributon

@kaggle.azminetoushikwasi_ucl_202122_uefa_champions_league.distributon

26.04 KB
608 rows
12 columns

serial Serial	player_name Player Name	club Club	position Position	pass_accuracy Pass Accuracy	pass_attempted Pass Attempted	pass_completed Pass Completed	cross_attempted Cross Attempted	freekicks_taken Freekicks Taken	match_played Match Played
1	Erokhin	Zenit	Midfielder	98	27	26	2		6
2	Eric García	Barcelona	Defender	97.5	203	197		1	4
3	Ulreich	Bayern	Goalkeeper	97	32	31		1	1
4	Rugani	Juventus	Defender	96.8	130	122			4
5	J. Timber	Ajax	Midfielder	95.8	497	474	1	14	8
6	Egan-Riley	Man. City	Defender	95	61	58	1		1
6	Mario Gaspar	Villarreal	Defender	95	32	29	1	1	2
8	Marlon	Shakhtar Donetsk	Defender	94.8	424	402		8	5
9	Süle	Bayern	Defender	94.7	429	413	2	9	7
9	Laporte	Man. City	Defender	94.7	707	672		10	9


CREATE TABLE distributon (
  "serial" BIGINT,
  "player_name" VARCHAR,
  "club" VARCHAR,
  "position" VARCHAR,
  "pass_accuracy" DOUBLE,
  "pass_attempted" BIGINT,
  "pass_completed" BIGINT,
  "cross_accuracy" BIGINT,
  "cross_attempted" BIGINT,
  "cross_complted" BIGINT,
  "freekicks_taken" BIGINT,
  "match_played" BIGINT
);