Dataset: EPL 23/24 Schedule With 22/23 Team Stats

About this Dataset

EPL 23/24 Schedule With 22/23 Team Stats

Combines data on team matchups for the 23/24 season with the previous season statistics for each team (including promoted clubs) for more comprehensive analysis opportunities.

Team - primary team
GW1/38 - game week opponent (week 1 through 38 in 23/24 season)
GP - games played 22/23
W - wins 22/23
D - draws 22/23
L - losses 22/23
F - goals for 22/23
A - goals against 22/23
GD - goal difference 22/23 (F - A)
P - season points 22/23
Rank - season end rank 22/23
HW/AW - home/away wins 22/23
HD/AD - home/away draws 22/23
HL/AL - home/away losses 22/23

** data for home/away wins/draws/losses not available for promoted championship clubs

Tables

Epl 24 Standings And 23 Stats

@kaggle.duncankmckinnon_epl_24_schedule_and_23_stats.epl_24_standings_and_23_stats

41.82 KB
20 rows
54 columns


CREATE TABLE epl_24_standings_and_23_stats (
  "team" VARCHAR,
  "gw1" VARCHAR,
  "gw2" VARCHAR,
  "gw3" VARCHAR,
  "gw4" VARCHAR,
  "gw5" VARCHAR,
  "gw6" VARCHAR,
  "gw7" VARCHAR,
  "gw8" VARCHAR,
  "gw9" VARCHAR,
  "gw10" VARCHAR,
  "gw11" VARCHAR,
  "gw12" VARCHAR,
  "gw13" VARCHAR,
  "gw14" VARCHAR,
  "gw15" VARCHAR,
  "gw16" VARCHAR,
  "gw17" VARCHAR,
  "gw18" VARCHAR,
  "gw19" VARCHAR,
  "gw20" VARCHAR,
  "gw21" VARCHAR,
  "gw22" VARCHAR,
  "gw23" VARCHAR,
  "gw24" VARCHAR,
  "gw25" VARCHAR,
  "gw26" VARCHAR,
  "gw27" VARCHAR,
  "gw28" VARCHAR,
  "gw29" VARCHAR,
  "gw30" VARCHAR,
  "gw31" VARCHAR,
  "gw32" VARCHAR,
  "gw33" VARCHAR,
  "gw34" VARCHAR,
  "gw35" VARCHAR,
  "gw36" VARCHAR,
  "gw37" VARCHAR,
  "gw38" VARCHAR,
  "gp" BIGINT,
  "w" BIGINT,
  "d" BIGINT,
  "l" BIGINT,
  "f" BIGINT,
  "a" BIGINT,
  "gd" BIGINT,
  "p" BIGINT,
  "rank" BIGINT,
  "hw" DOUBLE,
  "hl" DOUBLE,
  "hd" DOUBLE,
  "aw" DOUBLE,
  "al" DOUBLE,
  "ad" DOUBLE
);