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

Mr. W. · Revisado há almost 6 years

Sue Yi L. · Revisado há almost 6 years

Faiz I. · Revisado há almost 6 years

yijie l. · Revisado há almost 6 years

Christie N. · Revisado há almost 6 years

Last Task is unclear. I just renamed the column and it work? ish

Sze Shen o. · Revisado há almost 6 years

Sawyer G. · Revisado há almost 6 years

Shong Y. · Revisado há almost 6 years

Yan Kai L. · Revisado há almost 6 years

Ambiguous

Thakorn T. · Revisado há almost 6 years

Last task has not clear description

Adam P. · Revisado há almost 6 years

Jia Wei T. · Revisado há almost 6 years

Used the required feature, but unable to pass. Hint is not helpful on error

Jia Wei T. · Revisado há almost 6 years

The definition of "busiest station" in task 5 is ambiguous.

KOJI I. · Revisado há almost 6 years

Amos Li Sheng T. · Revisado há almost 6 years

Diptaparna B. · Revisado há almost 6 years

I tried plenty combinations and even I found out there is few types of "Single Trip" values, but still cannot pass the answer, any idea on this? I will share my code here ========================== SELECT AVG(predicted_label) as Average_Predicted_Trip_Duration, avg(label) as Average_Truth_Trip_Duration FROM ML.PREDICT(MODEL `data.model_2`, ( SELECT duration_minutes as label, start_station_name, subscriber_type, start_time, FROM `data.trips` WHERE start_station_id = ( select start_station_id from data.trips where extract(year from start_time) = 2019 group by start_station_id order by count(trip_id) desc limit 1 ) and subscriber_type Like "%Single%" ))

HOU ZHI C. · Revisado há almost 6 years

Really dont know how to do for last task

HOU ZHI C. · Revisado há almost 6 years

Tan W. · Revisado há almost 6 years

Lim W. · Revisado há almost 6 years

CHIEW K. · Revisado há almost 6 years

Joey L. · Revisado há almost 6 years

vincent w. · Revisado há almost 6 years

Yan Kai L. · Revisado há almost 6 years

SUM KOK LIANG ​. · Revisado há almost 6 years