리뷰 Google 머신러닝을 사용한 브라켓톨로지개

The SQL command in Task 12 is incorrect. The correct one would be: # create training dataset: # create a row for the winning team CREATE OR REPLACE TABLE `bracketology.training_new_features` AS WITH outcomes AS ( SELECT # features season, # 1994 "win" AS label, # our label win_seed AS seed, # ranking # this time without seed even win_school_ncaa AS school_ncaa, lose_seed AS opponent_seed, # ranking lose_school_ncaa AS opponent_school_ncaa FROM `bigquery-public-data.ncaa_basketball.mbb_historical_tournament_games` t WHERE season >= 2014 UNION ALL # create a separate row for the losing team SELECT # features season, # 1994 "loss" AS label, # our label lose_seed AS seed, # ranking lose_school_ncaa AS school_ncaa, win_seed AS opponent_seed, # ranking win_school_ncaa AS opponent_school_ncaa FROM `bigquery-public-data.ncaa_basketball.mbb_historical_tournament_games` t WHERE season >= 2014 UNION ALL # add in 2018 tournament game results not part of the public dataset: SELECT season, label, seed, school_ncaa, opponent_seed, opponent_school_ncaa FROM `data-to-insights.ncaa.2018_tournament_results` ) SELECT o.season, label, # our team seed, school_ncaa, # new pace metrics (basketball possession) team.pace_rank, team.poss_40min, team.pace_rating, # new efficiency metrics (scoring over time) team.efficiency_rank, team.pts_100poss, team.efficiency_rating, # opposing team opponent_seed, opponent_school_ncaa, # new pace metrics (basketball possession) opp.pace_rank AS opp_pace_rank, opp.poss_40min AS opp_poss_40min, opp.pace_rating AS opp_pace_rating, # new efficiency metrics (scoring over time) opp.efficiency_rank AS opp_efficiency_rank, opp.pts_100poss AS opp_pts_100poss, opp.efficiency_rating AS opp_efficiency_rating, # a little feature engineering (take the difference in stats) # new pace metrics (basketball possession) opp.pace_rank - team.pace_rank AS pace_rank_diff, opp.poss_40min - team.poss_40min AS pace_stat_diff, opp.pace_rating - team.pace_rating AS pace_rating_diff, # new efficiency metrics (scoring over time) opp.efficiency_rank - team.efficiency_rank AS eff_rank_diff, opp.pts_100poss - team.pts_100poss AS eff_stat_diff, opp.efficiency_rating - team.efficiency_rating AS eff_rating_diff FROM outcomes AS o LEFT JOIN `data-to-insights.ncaa.feature_engineering` AS team ON o.school_ncaa = team.team AND o.season = team.season LEFT JOIN `data-to-insights.ncaa.feature_engineering` AS opp ON o.opponent_school_ncaa = opp.team AND o.season = opp.season The SQL command in Task 15 is also incorrect. The correct one is: CREATE OR REPLACE MODEL `bracketology.ncaa_model_updated` OPTIONS ( model_type='logistic_reg') AS SELECT # this time, don't train the model on school name or seed season, label, # our pace poss_40min, pace_rank, pace_rating, # opponent pace opp_poss_40min, opp_pace_rank, opp_pace_rating, # difference in pace pace_rank_diff, pace_stat_diff, pace_rating_diff, # our efficiency pts_100poss, efficiency_rank, efficiency_rating, # opponent efficiency opp_pts_100poss, opp_efficiency_rank, opp_efficiency_rating, # difference in efficiency eff_rank_diff, eff_stat_diff, eff_rating_diff FROM `bracketology.training_new_features` # here we'll train on 2014 - 2017 and predict on 2018 WHERE season BETWEEN 2014 AND 2017 # between in SQL is inclusive of end points

Chowdhury Mohammad I. · 대략 3년 전에 리뷰됨

ARUNENDRA M. · 대략 3년 전에 리뷰됨

Dhyaneswar B. · 대략 3년 전에 리뷰됨

Kaif A. · 대략 3년 전에 리뷰됨

Abhishek G. · 대략 3년 전에 리뷰됨

difficult to understand

Juan P. · 대략 3년 전에 리뷰됨

Andrew L. · 대략 3년 전에 리뷰됨

Muhammad Talha K. · 대략 3년 전에 리뷰됨

awesome

Siddheswar S. · 대략 3년 전에 리뷰됨

ANANYA T. · 대략 3년 전에 리뷰됨

Aditi K. · 대략 3년 전에 리뷰됨

nice

GOUROB D. · 대략 3년 전에 리뷰됨

Rahul K. · 대략 3년 전에 리뷰됨

great

Raunak R. · 대략 3년 전에 리뷰됨

Sushil Kumar G. · 대략 3년 전에 리뷰됨

Soumya Sagar R. · 대략 3년 전에 리뷰됨

PRATHAM S. · 대략 3년 전에 리뷰됨

1208- B. · 대략 3년 전에 리뷰됨

nice

Hemant S. · 대략 3년 전에 리뷰됨

Undavalli J. · 대략 3년 전에 리뷰됨

Soham G. · 대략 3년 전에 리뷰됨

nice

Ritesh Kumar S. · 대략 3년 전에 리뷰됨

Sourav D. · 대략 3년 전에 리뷰됨

Parth G. · 대략 3년 전에 리뷰됨

Sonu C. · 대략 3년 전에 리뷰됨