IPL Players Statistics
The dataset contains the individual statistics of more than 600 IPL players.
@kaggle.mohammadzamakhan_ipl_players_statistics
The dataset contains the individual statistics of more than 600 IPL players.
@kaggle.mohammadzamakhan_ipl_players_statistics
The IPL player statistic dataset provides a comprehensive set of performance metrics for players participating in the Indian Premier League (IPL). The dataset contains information on various key aspects of a player's performance, including their batting, bowling, and fielding statistics.
Here is a description of the columns in the dataset:
Player: This column represents the name of the IPL player.
Runs: This column indicates the total number of runs scored by the player in IPL matches.
Boundaries: It represents the number of boundaries hit by the player, which includes fours and sixes.
Balls Faced: This column provides the count of balls faced by the player while batting.
Wickets: It denotes the total number of wickets taken by the player while bowling.
Balls Bowled: This column signifies the number of balls bowled by the player.
Runs Conceded: It represents the total number of runs conceded by the player while bowling.
Matches: This column indicates the total number of matches played by the player in the IPL.
Batting Avg: It represents the batting average of the player, calculated by dividing the total runs scored by the number of times dismissed.
Batting Strike Rate: This column represents the strike rate of the player, calculated by dividing the total runs scored by the number of balls faced and multiplying by 100.
Boundaries Percent: It represents the percentage of runs scored through boundaries, calculated by dividing the total runs from boundaries by the total runs scored and multiplying by 100.
Bowling Economy: This column indicates the average number of runs conceded by the player per over bowled.
Bowling Avg: It represents the average number of runs conceded by the player per wicket taken.
Bowling Strike Rate: This column indicates the average number of balls bowled by the player per wicket taken.
Catches: It denotes the total number of catches taken by the player in IPL matches.
Stumpings: This column represents the total number of stumpings made by the player as a wicket-keeper.
The dataset provides a comprehensive overview of the performance of IPL players, allowing for detailed analysis and comparison of their batting, bowling, and fielding capabilities.
CREATE TABLE ipl_player_stat (
"unnamed_0" BIGINT -- Unnamed: 0,
"player" VARCHAR,
"runs" BIGINT,
"boundaries" BIGINT,
"balls_faced" BIGINT,
"wickets" DOUBLE,
"balls_bowled" DOUBLE,
"runs_conceded" DOUBLE,
"matches" BIGINT,
"batting_avg" DOUBLE,
"batting_strike_rate" DOUBLE,
"boundaries_percent" DOUBLE,
"bowling_economy" DOUBLE,
"bowling_avg" DOUBLE,
"bowling_strike_rate" DOUBLE,
"catches" DOUBLE,
"stumpings" DOUBLE
);
Anyone who has the link will be able to view this.