Criar modelos de ML com o BigQuery ML: laboratório com desafio avaliações

impossible to finish task 2 and chat support dosn't help

Roberto T. · Revisado há over 1 year

Peter K. · Revisado há over 1 year

Felipe M. · Revisado há over 1 year

Yisan L. · Revisado há over 1 year

Anshika R. · Revisado há over 1 year

Ronny d. · Revisado há over 1 year

Arbaz K. · Revisado há over 1 year

Fahad G. · Revisado há over 1 year

Tarun T. · Revisado há over 1 year

Tarun T. · Revisado há over 1 year

task are non consistent between them

Roberto T. · Revisado há over 1 year

Sascha M. · Revisado há over 1 year

Alfredo B. · Revisado há over 1 year

Joachim W. · Revisado há over 1 year

task are non consistent between them

Roberto T. · Revisado há over 1 year

Gerardo G. · Revisado há over 1 year

Sujal M. · Revisado há over 1 year

kashyap a. · Revisado há over 1 year

Miguel E. · Revisado há over 1 year

Guilherme M. · Revisado há over 1 year

Luiz Antonio C. · Revisado há over 1 year

Mônica F. · Revisado há over 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. · Revisado há over 1 year

Arvind P. · Revisado há over 1 year

Rosana A. · Revisado há over 1 year