关于“運用 BigQuery ML 建立機器學習模型：挑戰實驗室”的评价

Peter K. · 评论about 1 year之前

Felipe M. · 评论about 1 year之前

Yisan L. · 评论about 1 year之前

Anshika R. · 评论about 1 year之前

Ronny d. · 评论about 1 year之前

Arbaz K. · 评论about 1 year之前

Fahad G. · 评论about 1 year之前

Tarun T. · 评论about 1 year之前

Tarun T. · 评论about 1 year之前

task are non consistent between them

Roberto T. · 评论about 1 year之前

Sascha M. · 评论about 1 year之前

Alfredo B. · 评论about 1 year之前

Joachim W. · 评论about 1 year之前

task are non consistent between them

Roberto T. · 评论about 1 year之前

Gerardo G. · 评论about 1 year之前

Sujal M. · 评论about 1 year之前

kashyap a. · 评论about 1 year之前

Miguel E. · 评论about 1 year之前

Guilherme M. · 评论about 1 year之前

Luiz Antonio C. · 评论about 1 year之前

Mônica F. · 评论about 1 year之前

No way to check as done task 4. --busiest bike sharing station in 2019 (based on the number of trips per station in 2019) where the subscriber type is 'Single Trip'. WITH t1 AS ( select start_station_name, count(*) as trips FROM `bigquery-public-data.austin_bikeshare.bikeshare_trips` WHERE EXTRACT(YEAR FROM start_time) = 2019 AND subscriber_type = 'Single Trip' GROUP BY 1 ORDER BY 2 DESC LIMIT 1 ) --predict the average trip duration for all trips from the busiest bike sharing station in 2019 (based on the number of trips per station in 2019) where the subscriber type is 'Single Trip'. SELECT AVG(predicted_duration_minutes) as avg_predicted_duration_minutes, AVG(duration_minutes) as avg_duration_minutes FROM ML.PREDICT( MODEL `qwiklabs-gcp-01-fff487b8bf0c.austin.subscriber_model`, ( SELECT -- label col bkt.duration_minutes AS duration_minutes, --features bkt.start_station_name, EXTRACT(HOUR FROM bkt.start_time) AS start_hour, bkt.subscriber_type as subscriber_type, FROM `bigquery-public-data.austin_bikeshare.bikeshare_trips` bkt WHERE 1=1 AND EXTRACT(YEAR FROM bkt.start_time) = 2019 AND bkt.subscriber_type = 'Single Trip' AND bkt.start_station_name = (select t1.start_station_name from t1) ))

Miguel M. · 评论about 1 year之前

Arvind P. · 评论about 1 year之前

Rosana A. · 评论about 1 year之前

Natalia S. · 评论about 1 year之前