关于“通过 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前审核