La Liga Match Data

La Liga Match Data from 2014-2020

@kaggle.sanjeetsinghnaik_la_liga_match_data

Table List

1 table(111.39 KB)

Combined Data Laliga

@kaggle.sanjeetsinghnaik_la_liga_match_data.combined_data_laliga

111.39 KB
2660 rows
41 columns

unnamed_0 Unnamed: 0	home_team Home Team	away_team Away Team	score Score	half_time_score Half Time Score	match_excitement Match Excitement	home_team_rating Home Team Rating	away_team_rating Away Team Rating	home_team_possession Home Team Possession %	away_team_possession Away Team Possession %	home_team_off_target_shots Home Team Off Target Shots	home_team_on_target_shots Home Team On Target Shots	home_team_total_shots Home Team Total Shots	home_team_blocked_shots Home Team Blocked Shots	home_team_corners Home Team Corners	home_team_throw_ins Home Team Throw Ins	home_team_pass_success Home Team Pass Success %	home_team_aerials_won Home Team Aerials Won	home_team_clearances Home Team Clearances	home_team_fouls Home Team Fouls	home_team_yellow_cards Home Team Yellow Cards	home_team_red_cards Home Team Red Cards	away_team_off_target_shots Away Team Off Target Shots	away_team_on_target_shots Away Team On Target Shots	away_team_total_shots Away Team Total Shots	away_team_blocked_shots Away Team Blocked Shots	away_team_corners Away Team Corners	away_team_throw_ins Away Team Throw Ins	away_team_pass_success Away Team Pass Success %	away_team_aerials_won Away Team Aerials Won	away_team_clearances Away Team Clearances	away_team_fouls Away Team Fouls	away_team_yellow_cards Away Team Yellow Cards	away_team_second_yellow_cards Away Team Second Yellow Cards	away_team_red_cards Away Team Red Cards	home_team_goals_scored Home Team Goals Scored	away_team_goals_scored Away Team Goals Scored	home_team_goals_conceeded Home Team Goals Conceeded	away_team_goals_conceeded Away Team Goals Conceeded	year Year
	MÁLAGA	ATHLETIC	1-0	1-0	4.4	6	5.7	40	60	5	3	12	4	5	13	69	11	16	13	3	2	5	5	12	2	4	22	84	17	14	9	3			1			1	2014
1	SEVILLA FC	VALENCIA	1-1	1-0	4.7	6.5	6.8	47	53	4	3	12	5	3	20	76	13	16	23	4		5	1	11	5	3	27	79	14	16	8	2		1	1	1	1	1	2014
2	GRANADA	DEPORTIVO	2-1	0-1	4.6	7.2	5.9	53	47	6	3	10	1	5	25	79	20	21	13	1		1	1	8	6	3	30	76	10	14	26	3			2	1	1	2	2014
3	ALMERÍA	ESPANYOL	1-1	0-0	5.6	6.9	5.5	56	44	7	6	19	6	11	26	81	19	25	8	3		6	2	12	4	7	19	70	11	20	9	3	1		1	1	1	1	2014
4	EIBAR	REAL SOCIEDAD	1-0	1-0	3.7	6.5	5.9	41	59	5	5	12	2	5	28	60	29	17	13	4		7	4	19	8	6	36	75	25	20	14	1			1			1	2014
5	BARCELONA	ELCHE	3-0	1-0	5.1	8	5.3	72	28	5	6	12	1	3	23	93	2	2	11		1	3		3		1	19	81	4	17	13	1			3			3	2014
6	CELTA	GETAFE	3-1	1-0	7	7.3	5.5	59	41	4	9	20	7	4	21	82	27	15	19	4		8	3	12	1	4	19	74	22	7	15	1			3	1	1	3	2014
7	LEVANTE	VILLARREAL	0-2	0-0	4.7	5.6	7.3	53	47	4	2	9	3	3	16	80	19	12	11	1		5	6	12	1	4	14	78	21	18	14	3				2	2		2014
8	REAL MADRID	CÓRDOBA	2-0	1-0	4.7	6.9	5.5	63	37	3	8	14	3	8	25	88	23	13	9	1		6	2	8		5	18	79	15	27	13	2			2			2	2014
9	RAYO VALLECANO	ATLETICO MADRID	0-0	0-0	2.1	6.9	5.9	59	41	5	2	8	1	2	23	79	21	20	13	2		3	2	9	4	4	34	68	26	15	17	2							2014


CREATE TABLE combined_data_laliga (
  "unnamed_0" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "score" VARCHAR,
  "half_time_score" VARCHAR,
  "match_excitement" DOUBLE,
  "home_team_rating" DOUBLE,
  "away_team_rating" DOUBLE,
  "home_team_possession" BIGINT,
  "away_team_possession" BIGINT,
  "home_team_off_target_shots" DOUBLE,
  "home_team_on_target_shots" DOUBLE,
  "home_team_total_shots" DOUBLE,
  "home_team_blocked_shots" DOUBLE,
  "home_team_corners" DOUBLE,
  "home_team_throw_ins" DOUBLE,
  "home_team_pass_success" DOUBLE,
  "home_team_aerials_won" DOUBLE,
  "home_team_clearances" DOUBLE,
  "home_team_fouls" DOUBLE,
  "home_team_yellow_cards" DOUBLE,
  "home_team_second_yellow_cards" DOUBLE,
  "home_team_red_cards" DOUBLE,
  "away_team_off_target_shots" DOUBLE,
  "away_team_on_target_shots" DOUBLE,
  "away_team_total_shots" DOUBLE,
  "away_team_blocked_shots" DOUBLE,
  "away_team_corners" DOUBLE,
  "away_team_throw_ins" DOUBLE,
  "away_team_pass_success" DOUBLE,
  "away_team_aerials_won" DOUBLE,
  "away_team_clearances" DOUBLE,
  "away_team_fouls" DOUBLE,
  "away_team_yellow_cards" DOUBLE,
  "away_team_second_yellow_cards" DOUBLE,
  "away_team_red_cards" DOUBLE,
  "home_team_goals_scored" BIGINT,
  "away_team_goals_scored" BIGINT,
  "home_team_goals_conceeded" BIGINT,
  "away_team_goals_conceeded" BIGINT,
  "year" BIGINT
);