BigQuery ML を使用した ML モデルの作成: チャレンジラボ のレビュー

Talreja Tarun · 12ヶ月前にレビュー済み

Talreja Tarun · 12ヶ月前にレビュー済み

task are non consistent between them

Torrecillas Sanchez Roberto · 12ヶ月前にレビュー済み

Meyer Sascha · 12ヶ月前にレビュー済み

Bustos Azócar Alfredo · 12ヶ月前にレビュー済み

Walz Joachim · 12ヶ月前にレビュー済み

task are non consistent between them

Torrecillas Sanchez Roberto · 12ヶ月前にレビュー済み

Gual de Torrella Gerardo · 12ヶ月前にレビュー済み

Malakar Sujal · 12ヶ月前にレビュー済み

addepalli kashyap · 12ヶ月前にレビュー済み

Estrada Miguel · 12ヶ月前にレビュー済み

Mazzon Guilherme · 12ヶ月前にレビュー済み

Cabreira Fernandes Junior Luiz Antonio · 12ヶ月前にレビュー済み

Feitosa Mônica · 12ヶ月前にレビュー済み

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) ))

Merino Miguel · 12ヶ月前にレビュー済み

Pandey Arvind · 12ヶ月前にレビュー済み

Alves Molina Rosana · 12ヶ月前にレビュー済み

Shavel Natalia · 12ヶ月前にレビュー済み

kaur kirandeep · 12ヶ月前にレビュー済み

Kang Heejung · 12ヶ月前にレビュー済み

Afsha Noor · 12ヶ月前にレビュー済み

Debnath Kaushik · 12ヶ月前にレビュー済み

No way to check as done task 4.

Merino Miguel · 12ヶ月前にレビュー済み

Simion Lavinia · 12ヶ月前にレビュー済み

GOOGLEUSER Bhavi · 12ヶ月前にレビュー済み