Dataset: EgyptianLeague

About this Dataset

EgyptianLeague

Egyptian Premier League Match Data (2010-2024)
This dataset contains detailed information about matches played in the Egyptian Premier League from 2010 to 2024. The dataset includes match statistics, team performance, referee decisions, and the outcome of each match.

Features Overview:

ID: Unique identifier for each match.
Season: The season in which the match took place.
Fixture: Details about the specific fixture in the league.
MatchDay: The match day number within the season.
Date: The date on which the match was played.
Time: The time of the match.
Home Team: The team playing at home.
Away Team: The visiting team.
Referee: The referee officiating the match.
Yellow Home: Number of yellow cards issued to the home team.
Yellow Away: Number of yellow cards issued to the away team.
2nd Yellow Home: Number of second yellow cards (leading to a red card) for the home team.
2nd Yellow Away: Number of second yellow cards for the away team.
Red Home: Number of red cards issued to the home team.
Red Away: Number of red cards issued to the away team.
Half Time Result: The score at halftime.
Full Time Result: The final score at the end of the match.
Home Goals: Goals scored by the home team.
Away Goals: Goals scored by the away team.
Winner: Indicates the winner of the match (Home, Away, or Draw).
Label: Various performance labels or categorization criteria.
Count: Frequency or count associated with certain labels.

Potential Use Cases:

Match Analysis: Track performance trends for different teams, referees, and players over multiple seasons.
Predictive Modeling: Create machine learning models to predict match outcomes based on past performance.
Referee Performance: Analyze the impact of referees on match outcomes and team discipline.
Team Strategy Insights: Examine the correlation between yellow/red cards and match results.
Time Series Analysis: Perform time-based analysis of matches and outcomes across different seasons.
This dataset is ideal for soccer analysts, sports statisticians, and machine learning enthusiasts who are interested in exploring match data from the Egyptian Premier League.

Tables

Egyptianleague

@kaggle.mahmoudelshabrawy_egyptianleague.egyptianleague

72.06 KB
2031 rows
22 columns


CREATE TABLE egyptianleague (
  "unnamed_0_1" BIGINT,
  "unnamed_0" BIGINT,
  "id" BIGINT,
  "season" BIGINT,
  "fixture" VARCHAR,
  "matchday" BIGINT,
  "date" VARCHAR,
  "time" VARCHAR,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "refree" VARCHAR,
  "yellow_home" BIGINT,
  "yellow_away" BIGINT,
  "n_2nd_yellow_home" BIGINT,
  "n_2nd_yellow_away" BIGINT,
  "red_home" BIGINT,
  "red_away" BIGINT,
  "half_time_result" VARCHAR,
  "full_time_result" VARCHAR,
  "home_goals" BIGINT,
  "away_goals" BIGINT,
  "winner" VARCHAR
);