Name: NBA Team Per Game Stats
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

NBA Team Per Game Stats

Context

The NBA play style is always changing, and collecting the "Team Per Game" stats can be an insight into increasing team efficiency, pace of games, etc.

Content

The dataset contains the "Team Per Game" stats of NBA teams from 1980-2019 season.

The data recorded is that of a box score, containing: Points (PTS), Assists (AST), Steals (STL), etc.

There are 2 data sets:

main_df -> data is formatted as found, is not "clean" - still has asterisks in TEAM
playoff_labelled -> adds a "Playoff" column - indicating if the team made the playoffs for that year, and removes the asterisks in TEAM

Acknowledgements

Data source: Basketball Reference

Inspiration

Questions to explore:
-> has the pace of the game changed? Has it increased/decreased over time?
-> cluster the teams based on efficiency
-> how do the teams from different eras compare?

Tables

Main Df

@kaggle.jpsdev_19802019_nba_team_stats.main_df

57.54 kB
1,104 rows
26 columns

CREATE TABLE main_df (
  "rk" BIGINT,
  "team" VARCHAR,
  "g" BIGINT,
  "mp" DOUBLE,
  "fg" DOUBLE,
  "fga" DOUBLE,
  "fg_51ab2d" DOUBLE  -- FG%,
  "n_3p" DOUBLE  -- 3P,
  "n_3pa" DOUBLE  -- 3PA,
  "n_3p_d87a85" DOUBLE  -- 3P%,
  "n_2p" DOUBLE  -- 2P,
  "n_2pa" DOUBLE  -- 2PA,
  "n_2p_c8658d" DOUBLE  -- 2P%,
  "ft" DOUBLE,
  "fta" DOUBLE,
  "ft_ba25d5" DOUBLE  -- FT%,
  "orb" DOUBLE,
  "drb" DOUBLE,
  "trb" DOUBLE,
  "ast" DOUBLE,
  "stl" DOUBLE,
  "blk" DOUBLE,
  "tov" DOUBLE,
  "pf" DOUBLE,
  "pts" DOUBLE,
  "year" BIGINT
);

Playoff Labelled

@kaggle.jpsdev_19802019_nba_team_stats.playoff_labelled

57.93 kB
1,104 rows
27 columns

CREATE TABLE playoff_labelled (
  "rk" BIGINT,
  "team" VARCHAR,
  "g" BIGINT,
  "mp" DOUBLE,
  "fg" DOUBLE,
  "fga" DOUBLE,
  "fg_51ab2d" DOUBLE  -- FG%,
  "n_3p" DOUBLE  -- 3P,
  "n_3pa" DOUBLE  -- 3PA,
  "n_3p_d87a85" DOUBLE  -- 3P%,
  "n_2p" DOUBLE  -- 2P,
  "n_2pa" DOUBLE  -- 2PA,
  "n_2p_c8658d" DOUBLE  -- 2P%,
  "ft" DOUBLE,
  "fta" DOUBLE,
  "ft_ba25d5" DOUBLE  -- FT%,
  "orb" DOUBLE,
  "drb" DOUBLE,
  "trb" DOUBLE,
  "ast" DOUBLE,
  "stl" DOUBLE,
  "blk" DOUBLE,
  "tov" DOUBLE,
  "pf" DOUBLE,
  "pts" DOUBLE,
  "year" BIGINT,
  "playoff" BIGINT
);

Renamed Teams

@kaggle.jpsdev_19802019_nba_team_stats.renamed_teams

57.66 kB
1,104 rows
27 columns

CREATE TABLE renamed_teams (
  "rk" BIGINT,
  "team" VARCHAR,
  "g" BIGINT,
  "mp" DOUBLE,
  "fg" DOUBLE,
  "fga" DOUBLE,
  "fg_51ab2d" DOUBLE  -- FG%,
  "n_3p" DOUBLE  -- 3P,
  "n_3pa" DOUBLE  -- 3PA,
  "n_3p_d87a85" DOUBLE  -- 3P%,
  "n_2p" DOUBLE  -- 2P,
  "n_2pa" DOUBLE  -- 2PA,
  "n_2p_c8658d" DOUBLE  -- 2P%,
  "ft" DOUBLE,
  "fta" DOUBLE,
  "ft_ba25d5" DOUBLE  -- FT%,
  "orb" DOUBLE,
  "drb" DOUBLE,
  "trb" DOUBLE,
  "ast" DOUBLE,
  "stl" DOUBLE,
  "blk" DOUBLE,
  "tov" DOUBLE,
  "pf" DOUBLE,
  "pts" DOUBLE,
  "year" BIGINT,
  "playoff" BIGINT
);