NBA Game Stats Season 22/23 & 23/24
@kaggle.hakanormanci_nba_game_stats_season_2223_and_2334
@kaggle.hakanormanci_nba_game_stats_season_2223_and_2334
This datasets have full games which played in 22/23 season and 23/24 season games until 07.02.2024. I scrape data from web using Python with BeautifulSoup library.
CREATE TABLE data_february_2024 (
"unnamed_0" BIGINT -- Unnamed: 0,
"date" TIMESTAMP,
"id" VARCHAR,
"team" VARCHAR,
"opp" VARCHAR,
"venue" VARCHAR,
"team_fg" BIGINT,
"team_fga" BIGINT,
"team_fg3" BIGINT,
"team_fg3a" BIGINT,
"team_ft" BIGINT,
"team_fta" BIGINT,
"team_orb" BIGINT,
"team_drb" BIGINT,
"team_trb" BIGINT,
"team_ast" BIGINT,
"team_stl" BIGINT,
"team_blk" BIGINT,
"team_tov" BIGINT,
"team_pf" BIGINT,
"adv_team_mp" BIGINT,
"adv_team_ts" DOUBLE,
"adv_team_efg" DOUBLE,
"adv_team_tpar" DOUBLE,
"adv_team_ftr" DOUBLE,
"adv_team_orb" DOUBLE,
"adv_team_drb" DOUBLE,
"adv_team_trb" DOUBLE,
"adv_team_ast" DOUBLE,
"adv_team_stl" DOUBLE,
"adv_team_blk" DOUBLE,
"adv_team_tov" DOUBLE,
"adv_team_usg" BIGINT,
"adv_team_ortg" DOUBLE,
"adv_team_drtg" DOUBLE,
"adv_team_bpm" VARCHAR,
"opp_fg" BIGINT,
"opp_fga" BIGINT,
"opp_fg3" BIGINT,
"opp_fg3a" BIGINT,
"opp_ft" BIGINT,
"opp_fta" BIGINT,
"opp_orb" BIGINT,
"opp_drb" BIGINT,
"opp_trb" BIGINT,
"opp_ast" BIGINT,
"opp_stl" BIGINT,
"opp_blk" BIGINT,
"opp_tov" BIGINT,
"opp_pf" BIGINT,
"adv_opp_mp" BIGINT,
"adv_opp_ts" DOUBLE,
"adv_opp_efg" DOUBLE,
"adv_opp_tpar" DOUBLE,
"adv_opp_ftr" DOUBLE,
"adv_opp_orb" DOUBLE,
"adv_opp_drb" DOUBLE,
"adv_opp_trb" DOUBLE,
"adv_topp_ast" DOUBLE,
"adv_opp_stl" DOUBLE,
"adv_opp_blk" DOUBLE,
"adv_opp_tov" DOUBLE,
"adv_opp_usg" BIGINT,
"adv_opp_ortg" DOUBLE,
"adv_opp_drtg" DOUBLE,
"adv_opp_bpm" VARCHAR,
"season" VARCHAR,
"target" BIGINT,
"venue_code" BIGINT,
"opp_code" BIGINT,
"team_fg_rolling" DOUBLE,
"team_fga_rolling" DOUBLE,
"team_fg3_rolling" DOUBLE,
"team_fg3a_rolling" DOUBLE,
"team_ft_rolling" DOUBLE,
"team_fta_rolling" DOUBLE,
"team_orb_rolling" DOUBLE,
"team_drb_rolling" DOUBLE,
"team_trb_rolling" DOUBLE,
"team_ast_rolling" DOUBLE,
"team_stl_rolling" DOUBLE,
"team_blk_rolling" DOUBLE,
"team_tov_rolling" DOUBLE,
"team_pf_rolling" DOUBLE,
"adv_team_mp_rolling" DOUBLE,
"adv_team_ts_rolling" DOUBLE,
"adv_team_efg_rolling" DOUBLE,
"adv_team_tpar_rolling" DOUBLE,
"adv_team_ftr_rolling" DOUBLE,
"adv_team_orb_rolling" DOUBLE,
"adv_team_drb_rolling" DOUBLE,
"adv_team_trb_rolling" DOUBLE,
"adv_team_ast_rolling" DOUBLE,
"adv_team_stl_rolling" DOUBLE,
"adv_team_blk_rolling" DOUBLE,
"adv_team_tov_rolling" DOUBLE,
"adv_team_usg_rolling" DOUBLE,
"adv_team_ortg_rolling" DOUBLE,
"adv_team_drtg_rolling" DOUBLE,
"opp_fg_rolling" DOUBLE
);CREATE TABLE data_mr (
"unnamed_0" BIGINT -- Unnamed: 0,
"date" TIMESTAMP,
"id" VARCHAR,
"team" VARCHAR,
"opp" VARCHAR,
"venue" VARCHAR,
"team_fg" DOUBLE,
"team_fga" DOUBLE,
"team_fg3" DOUBLE,
"team_fg3a" DOUBLE,
"team_ft" DOUBLE,
"team_fta" DOUBLE,
"team_orb" DOUBLE,
"team_drb" DOUBLE,
"team_trb" DOUBLE,
"team_ast" DOUBLE,
"team_stl" DOUBLE,
"team_blk" DOUBLE,
"team_tov" DOUBLE,
"team_pf" DOUBLE,
"adv_team_mp" DOUBLE,
"adv_team_ts" DOUBLE,
"adv_team_efg" DOUBLE,
"adv_team_tpar" DOUBLE,
"adv_team_ftr" DOUBLE,
"adv_team_orb" DOUBLE,
"adv_team_drb" DOUBLE,
"adv_team_trb" DOUBLE,
"adv_team_ast" DOUBLE,
"adv_team_stl" DOUBLE,
"adv_team_blk" DOUBLE,
"adv_team_tov" DOUBLE,
"adv_team_usg" DOUBLE,
"adv_team_ortg" DOUBLE,
"adv_team_drtg" DOUBLE,
"adv_team_bpm" VARCHAR,
"opp_fg" DOUBLE,
"opp_fga" DOUBLE,
"opp_fg3" DOUBLE,
"opp_fg3a" DOUBLE,
"opp_ft" DOUBLE,
"opp_fta" DOUBLE,
"opp_orb" DOUBLE,
"opp_drb" DOUBLE,
"opp_trb" DOUBLE,
"opp_ast" DOUBLE,
"opp_stl" DOUBLE,
"opp_blk" DOUBLE,
"opp_tov" DOUBLE,
"opp_pf" DOUBLE,
"adv_opp_mp" DOUBLE,
"adv_opp_ts" DOUBLE,
"adv_opp_efg" DOUBLE,
"adv_opp_tpar" DOUBLE,
"adv_opp_ftr" DOUBLE,
"adv_opp_orb" DOUBLE,
"adv_opp_drb" DOUBLE,
"adv_opp_trb" DOUBLE,
"adv_topp_ast" DOUBLE,
"adv_opp_stl" DOUBLE,
"adv_opp_blk" DOUBLE,
"adv_opp_tov" DOUBLE,
"adv_opp_usg" DOUBLE,
"adv_opp_ortg" DOUBLE,
"adv_opp_drtg" DOUBLE,
"adv_opp_bpm" VARCHAR,
"target" BIGINT,
"venue_code" BIGINT,
"opp_code" BIGINT,
"team_fg_rolling" DOUBLE,
"team_fga_rolling" DOUBLE,
"team_fg3_rolling" DOUBLE,
"team_fg3a_rolling" DOUBLE,
"team_ft_rolling" DOUBLE,
"team_fta_rolling" DOUBLE,
"team_orb_rolling" DOUBLE,
"team_drb_rolling" DOUBLE,
"team_trb_rolling" DOUBLE,
"team_ast_rolling" DOUBLE,
"team_stl_rolling" DOUBLE,
"team_blk_rolling" DOUBLE,
"team_tov_rolling" DOUBLE,
"team_pf_rolling" DOUBLE,
"adv_team_mp_rolling" DOUBLE,
"adv_team_ts_rolling" DOUBLE,
"adv_team_efg_rolling" DOUBLE,
"adv_team_tpar_rolling" DOUBLE,
"adv_team_ftr_rolling" DOUBLE,
"adv_team_orb_rolling" DOUBLE,
"adv_team_drb_rolling" DOUBLE,
"adv_team_trb_rolling" DOUBLE,
"adv_team_ast_rolling" DOUBLE,
"adv_team_stl_rolling" DOUBLE,
"adv_team_blk_rolling" DOUBLE,
"adv_team_tov_rolling" DOUBLE,
"adv_team_usg_rolling" DOUBLE,
"adv_team_ortg_rolling" DOUBLE,
"adv_team_drtg_rolling" DOUBLE,
"opp_fg_rolling" DOUBLE,
"opp_fga_rolling" DOUBLE
);Anyone who has the link will be able to view this.