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

Roman P. · Revisado há about 2 years

Task 2 for FORM_3 is incorect: it is propose use logical and linear in different part of task. My answer was: CREATE or REPLACE MODEL bqml_dataset.predicts_visitor_model OPTIONS (model_type='logistic_reg') AS SELECT device.operatingSystem, device.isMobile, totals.pageviews, geoNetwork.country, 0 as label FROM `bigquery-public-data.google_analytics_sample.ga_sessions_20170801` WHERE totals.transactions is null UNION ALL SELECT device.operatingSystem, device.isMobile, totals.pageviews, geoNetwork.country, 1 as label FROM `bigquery-public-data.google_analytics_sample.ga_sessions_20170801` WHERE totals.transactions is not null and it is not correct.

Ihor H. · Revisado há about 2 years

lalit s. · Revisado há about 2 years

Miguel V. · Revisado há about 2 years

Werner v. · Revisado há about 2 years

Task 2 is incorect: it is propose use logical and linear in different part of task. My answer was: CREATE or REPLACE MODEL bqml_dataset.predicts_visitor_model OPTIONS (model_type='logistic_reg') AS SELECT device.operatingSystem, device.isMobile, totals.pageviews, geoNetwork.country, 0 as label FROM `bigquery-public-data.google_analytics_sample.ga_sessions_20170801` WHERE totals.transactions is null UNION ALL SELECT device.operatingSystem, device.isMobile, totals.pageviews, geoNetwork.country, 1 as label FROM `bigquery-public-data.google_analytics_sample.ga_sessions_20170801` WHERE totals.transactions is not null and it is not correct.

Ihor H. · Revisado há about 2 years

Bohdan B. · Revisado há about 2 years

Elisdênia S. · Revisado há about 2 years

Volodymyr P. · Revisado há about 2 years

Юлія К. · Revisado há about 2 years

Juandre L. · Revisado há about 2 years

Sachin K. · Revisado há about 2 years

Vladyslav C. · Revisado há about 2 years

juan carlos H. · Revisado há about 2 years

Anton B. · Revisado há about 2 years

Miguel V. · Revisado há about 2 years

Serhii V. · Revisado há about 2 years

Sergey V. · Revisado há about 2 years

Janice V. · Revisado há about 2 years

Suchita B. · Revisado há about 2 years

Maksym K. · Revisado há about 2 years

Максим К. · Revisado há about 2 years

Yuriy K. · Revisado há about 2 years