Create ML Models with BigQuery ML: Challenge Lab Reviews

Peter K. · Reviewed yaklaşık 1 yıl ago

Felipe M. · Reviewed yaklaşık 1 yıl ago

Yisan L. · Reviewed yaklaşık 1 yıl ago

Anshika R. · Reviewed yaklaşık 1 yıl ago

Ronny d. · Reviewed yaklaşık 1 yıl ago

Arbaz K. · Reviewed yaklaşık 1 yıl ago

Fahad G. · Reviewed yaklaşık 1 yıl ago

Tarun T. · Reviewed yaklaşık 1 yıl ago

Tarun T. · Reviewed yaklaşık 1 yıl ago

task are non consistent between them

Roberto T. · Reviewed yaklaşık 1 yıl ago

Sascha M. · Reviewed yaklaşık 1 yıl ago

Alfredo B. · Reviewed yaklaşık 1 yıl ago

Joachim W. · Reviewed yaklaşık 1 yıl ago

task are non consistent between them

Roberto T. · Reviewed yaklaşık 1 yıl ago

Gerardo G. · Reviewed yaklaşık 1 yıl ago

Sujal M. · Reviewed yaklaşık 1 yıl ago

kashyap a. · Reviewed yaklaşık 1 yıl ago

Miguel E. · Reviewed yaklaşık 1 yıl ago

Guilherme M. · Reviewed yaklaşık 1 yıl ago

Luiz Antonio C. · Reviewed yaklaşık 1 yıl ago

Mônica F. · Reviewed yaklaşık 1 yıl ago

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. · Reviewed yaklaşık 1 yıl ago

Arvind P. · Reviewed yaklaşık 1 yıl ago

Rosana A. · Reviewed 1 yıldan fazla ago

Natalia S. · Reviewed 1 yıldan fazla ago