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

Ashutosh k. · Revisado há over 5 years

Siddhi W. · Revisado há over 5 years

Atharva M. · Revisado há over 5 years

Awesome

Aakash kumar M. · Revisado há over 5 years

edgttrj t. · Revisado há over 5 years

Aman S. · Revisado há over 5 years

Omkar P. · Revisado há over 5 years

Prajwal P. · Revisado há over 5 years

Rupali S. · Revisado há over 5 years

Sreebrata D. · Revisado há over 5 years

Sneha P. · Revisado há over 5 years

Divyesh K. · Revisado há over 5 years

Joshua J. · Revisado há over 5 years

Sanjay A. · Revisado há over 5 years

Srisha Reddy T. · Revisado há over 5 years

Suman P. · Revisado há over 5 years

Rahul K. · Revisado há over 5 years

Ashutosh S. · Revisado há over 5 years

good

Priyadarshan g. · Revisado há over 5 years

ANKIT B. · Revisado há over 5 years

Vinita S. · Revisado há over 5 years

Souvik R. · Revisado há over 5 years

Sahil K. · Revisado há over 5 years

Anjali K. · Revisado há over 5 years

export PROJECT_ID=DEVSHELL_PROJECT_ID bq query --use_legacy_sql=false "CREATE OR REPLACE MODEL austin.austin_1 OPTIONS(input_label_cols=['duration_minutes'], model_type='linear_reg') AS SELECT duration_minutes, location, start_station_name, CAST(EXTRACT(dayofweek FROM start_time) AS STRING) as dayofweek, CAST(EXTRACT(hour FROM start_time) AS STRING) AS hourofday, FROM \`bigquery-public-data.austin_bikeshare.bikeshare_trips\` AS trips JOIN \`bigquery-public-data.austin_bikeshare.bikeshare_stations\` AS stations ON trips.start_station_id = stations.station_id WHERE EXTRACT(year from start_time) = 2018"

Pratik J. · Revisado há over 5 years