Dataset: Football Match Winners

About this Dataset

Football Match Winners

The dataset contains the Barclays Premier League data for the 2020–21 and 2021–22 seasons.The 2021-2022 season of the Barclays Premier League would have featured 20 teams competing in a round-robin format, with each team playing 38 matches over the course of the season. The season typically started in August and ended in May.

The previous season's top teams like Manchester City, Liverpool, Manchester United, and Chelsea were expected to be strong contenders for the title once again. However, surprises and upsets are common in football, so there could have been unexpected performances from other clubs as well. The fight to avoid relegation would have been fierce among the teams in the lower half of the table.

Tables

Clean Model Ready

@kaggle.omikumarmakadia2121_football_match_winners.clean_model_ready

48.31 KB
1389 rows
33 columns


CREATE TABLE clean_model_ready (
  "unnamed_0" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "comp" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" DOUBLE,
  "ga" DOUBLE,
  "opponent" VARCHAR,
  "xg" DOUBLE,
  "xga" DOUBLE,
  "poss" DOUBLE,
  "attendance" DOUBLE,
  "captain" VARCHAR,
  "formation" VARCHAR,
  "referee" VARCHAR,
  "match_report" VARCHAR,
  "notes" VARCHAR,
  "sh" DOUBLE,
  "sot" DOUBLE,
  "dist" DOUBLE,
  "fk" DOUBLE,
  "pk" DOUBLE,
  "pkatt" DOUBLE,
  "season" BIGINT,
  "team" VARCHAR,
  "venue_code" BIGINT,
  "opp_code" BIGINT,
  "hour" BIGINT,
  "day_code" BIGINT,
  "target" BIGINT
);

Matches

@kaggle.omikumarmakadia2121_football_match_winners.matches

42.52 KB
1389 rows
28 columns


CREATE TABLE matches (
  "unnamed_0" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "comp" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" DOUBLE,
  "ga" DOUBLE,
  "opponent" VARCHAR,
  "xg" DOUBLE,
  "xga" DOUBLE,
  "poss" DOUBLE,
  "attendance" DOUBLE,
  "captain" VARCHAR,
  "formation" VARCHAR,
  "referee" VARCHAR,
  "match_report" VARCHAR,
  "notes" VARCHAR,
  "sh" DOUBLE,
  "sot" DOUBLE,
  "dist" DOUBLE,
  "fk" DOUBLE,
  "pk" DOUBLE,
  "pkatt" DOUBLE,
  "season" BIGINT,
  "team" VARCHAR
);