Name: NCAA To NBA Transition For 2019 Draft
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

NCAA To NBA Transition For 2019 Draft

This project is targeted towards visualizing the transition of college basketball players into the NBA to understand the reasons behind their success rates in the pro league. A holistic review of the performance of players drafted over the past 40 years shall be compared to understand what went wrong with some of the picks. Several players of the recent 2019 draft class will be analyzed and matched to a team they would fit best with and why. Moreover, changes in trends of the drafts since 1974 to 2021 will be visualized on various levels. Overall, we hope that this project will reveal underlying patterns and trends to help teams understand which player would be a good fit on their roster to make better business decisions using different types of data visualizations to explore an extensive array of datasets.

Tables

All Seasons

@kaggle.saisaathvik_ncaa_to_nba_transition_for_2019_draft.all_seasons

283.56 kB
11,700 rows
21 columns

CREATE TABLE all_seasons (
  "player_name" VARCHAR,
  "team_abbreviation" VARCHAR,
  "age" BIGINT,
  "player_height" DOUBLE,
  "player_weight" DOUBLE,
  "college" VARCHAR,
  "country" VARCHAR,
  "draft_year" VARCHAR,
  "draft_round" VARCHAR,
  "draft_number" VARCHAR,
  "gp" BIGINT,
  "pts" DOUBLE,
  "reb" DOUBLE,
  "ast" DOUBLE,
  "net_rating" DOUBLE,
  "oreb_pct" DOUBLE,
  "dreb_pct" DOUBLE,
  "usg_pct" DOUBLE,
  "ts_pct" DOUBLE,
  "ast_pct" DOUBLE,
  "season" VARCHAR
);

Data1

@kaggle.saisaathvik_ncaa_to_nba_transition_for_2019_draft.data1

4.36 kB
20 rows
5 columns

CREATE TABLE data1 (
  "player" VARCHAR,
  "league" VARCHAR,
  "ppg" DOUBLE,
  "rpg" DOUBLE,
  "apg" DOUBLE
);

First Picks Nba

@kaggle.saisaathvik_ncaa_to_nba_transition_for_2019_draft.first_picks_nba

9.59 kB
69 rows
8 columns

CREATE TABLE first_picks_nba (
  "draft" BIGINT,
  "selected_by" VARCHAR,
  "player" VARCHAR,
  "position" VARCHAR,
  "college" VARCHAR,
  "ppg" DOUBLE,
  "rpg" DOUBLE,
  "apg" DOUBLE
);

N 2019 Ncaa

@kaggle.saisaathvik_ncaa_to_nba_transition_for_2019_draft.n_2019_ncaa

9.41 kB
46 rows
10 columns

CREATE TABLE n_2019_ncaa (
  "player" VARCHAR,
  "age" DOUBLE,
  "ppg_ncaa" DOUBLE,
  "rpg_ncaa" DOUBLE,
  "apg_ncaa" DOUBLE,
  "spg" DOUBLE,
  "bpg" DOUBLE,
  "topg" DOUBLE,
  "n_3pt" DOUBLE  -- 3PT,
  "ts" DOUBLE  -- TS%
);

Nba Players By State

@kaggle.saisaathvik_ncaa_to_nba_transition_for_2019_draft.nba_players_by_state

307.86 kB
3,407 rows
28 columns

CREATE TABLE nba_players_by_state (
  "player" VARCHAR,
  "yrs" VARCHAR,
  "g" VARCHAR,
  "mp" VARCHAR,
  "fg" VARCHAR,
  "fga" VARCHAR,
  "n_3p" VARCHAR  -- 3P,
  "n_3pa" VARCHAR  -- 3PA,
  "ft" VARCHAR,
  "fta" VARCHAR,
  "orb" VARCHAR,
  "trb" VARCHAR,
  "ast" VARCHAR,
  "stl" VARCHAR,
  "blk" VARCHAR,
  "tov" VARCHAR,
  "pf" VARCHAR,
  "pts" VARCHAR,
  "fg_51ab2d" VARCHAR  -- FG%,
  "n_3p_d87a85" VARCHAR  -- 3P%,
  "ft_ba25d5" VARCHAR  -- FT%,
  "mp_1" VARCHAR,
  "pts_1" VARCHAR,
  "trb_1" VARCHAR,
  "ast_1" VARCHAR,
  "date" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR
);

Ncaa 2019

@kaggle.saisaathvik_ncaa_to_nba_transition_for_2019_draft.ncaa_2019

9.42 kB
46 rows
10 columns

CREATE TABLE ncaa_2019 (
  "player" VARCHAR,
  "age" DOUBLE,
  "ppg_ncaa" DOUBLE,
  "rpg_ncaa" DOUBLE,
  "apg_ncaa" DOUBLE,
  "spg" DOUBLE,
  "bpg" DOUBLE,
  "topg" DOUBLE,
  "n_3pt" DOUBLE  -- 3PT,
  "ts" DOUBLE  -- TS%
);

Rookie

@kaggle.saisaathvik_ncaa_to_nba_transition_for_2019_draft.rookie

19.8 kB
43 rows
16 columns

CREATE TABLE rookie (
  "r" BIGINT  -- R#,
  "player" VARCHAR,
  "pos" VARCHAR,
  "team" VARCHAR,
  "gp" BIGINT,
  "mpg" DOUBLE,
  "fg" VARCHAR  -- FG%,
  "ft" VARCHAR  -- FT%,
  "n_3pm" VARCHAR  -- 3PM,
  "pts" VARCHAR,
  "treb" VARCHAR,
  "ast" VARCHAR,
  "stl" VARCHAR,
  "blk" VARCHAR,
  "to" VARCHAR,
  "total" DOUBLE
);

Teams Stat 18–19

@kaggle.saisaathvik_ncaa_to_nba_transition_for_2019_draft.teams_stat_18_19

18 kB
32 rows
25 columns

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

Team Stats 19–20

@kaggle.saisaathvik_ncaa_to_nba_transition_for_2019_draft.team_stats_19_20

18.12 kB
32 rows
25 columns

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