Create ML Models with BigQuery ML: Challenge Lab avis

Peter K. · Examiné il y a environ un an

Felipe M. · Examiné il y a environ un an

Yisan L. · Examiné il y a environ un an

Anshika R. · Examiné il y a environ un an

Ronny d. · Examiné il y a environ un an

Arbaz K. · Examiné il y a environ un an

Fahad G. · Examiné il y a environ un an

Tarun T. · Examiné il y a environ un an

Tarun T. · Examiné il y a environ un an

task are non consistent between them

Roberto T. · Examiné il y a environ un an

Sascha M. · Examiné il y a environ un an

Alfredo B. · Examiné il y a environ un an

Joachim W. · Examiné il y a environ un an

task are non consistent between them

Roberto T. · Examiné il y a environ un an

Gerardo G. · Examiné il y a environ un an

Sujal M. · Examiné il y a environ un an

kashyap a. · Examiné il y a environ un an

Miguel E. · Examiné il y a environ un an

Guilherme M. · Examiné il y a environ un an

Luiz Antonio C. · Examiné il y a environ un an

Mônica F. · Examiné il y a environ un an

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. · Examiné il y a environ un an

Arvind P. · Examiné il y a environ un an

Rosana A. · Examiné il y a environ un an

Natalia S. · Examiné il y a environ un an