NBA Players & Team Data
Multiple Player & Team stats
@kaggle.loganlauton_nba_players_and_team_data
Multiple Player & Team stats
@kaggle.loganlauton_nba_players_and_team_data
I scraped player stats for all NBA seasons, ranging from 1949-50 to 2021-22, from Basketball Reference.
The team Payroll and player salary data was scraped from Hoops Hype.
I utilized the nba_api python package to scrape all of the box score data.
To see the code for scraping both sites see my Github repo.
This data set is an update to datasets such as NBA Player Stats & NBA Data from Basketball Reference.
CREATE TABLE nba_payroll_1990_2023 (
"unnamed_0" BIGINT -- Unnamed: 0,
"team" VARCHAR,
"seasonstartyear" BIGINT,
"payroll" VARCHAR,
"inflationadjpayroll" VARCHAR
);CREATE TABLE nba_player_box_score_stats_1950_2022 (
"unnamed_0" BIGINT -- Unnamed: 0,
"season" BIGINT,
"game_id" BIGINT,
"player_name" VARCHAR,
"team" VARCHAR,
"game_date" TIMESTAMP,
"matchup" VARCHAR,
"wl" VARCHAR,
"min" BIGINT,
"fgm" BIGINT,
"fga" DOUBLE,
"fg_pct" DOUBLE,
"fg3m" DOUBLE,
"fg3a" DOUBLE,
"fg3_pct" DOUBLE,
"ftm" BIGINT,
"fta" DOUBLE,
"ft_pct" DOUBLE,
"oreb" DOUBLE,
"dreb" DOUBLE,
"reb" DOUBLE,
"ast" DOUBLE,
"stl" DOUBLE,
"blk" DOUBLE,
"tov" DOUBLE,
"pf" DOUBLE,
"pts" BIGINT,
"plus_minus" DOUBLE,
"video_available" BIGINT
);CREATE TABLE nba_player_stats_1950_2022 (
"unnamed_0_1" BIGINT -- Unnamed: 0.1,
"unnamed_0" BIGINT -- Unnamed: 0,
"season" BIGINT,
"player" VARCHAR,
"pos" VARCHAR,
"age" DOUBLE,
"tm" VARCHAR,
"g" DOUBLE,
"gs" DOUBLE,
"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%,
"efg" DOUBLE -- EFG%,
"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
);CREATE TABLE nba_salaries_1990_2023 (
"unnamed_0" BIGINT -- Unnamed: 0,
"playername" VARCHAR,
"seasonstartyear" BIGINT,
"salary" VARCHAR,
"inflationadjsalary" VARCHAR
);Anyone who has the link will be able to view this.