Using the multiclass logistic regression model
In this section, we'll test our ML model and analyze the results.
To use our BigQuery ML model, we'll use the ML.PREDICT
function and the classification_table
table, which hosts the records, to test our model, as seen in the following code block:
SELECT Â Â tree_id, Â Â actual_label, Â Â predicted_label_probs, Â Â predicted_label FROM Â Â ML.PREDICT (MODEL `06_nyc_trees.classification_model_version_3`, Â Â Â Â ( Â Â Â Â SELECT Â Â Â Â Â Â Â tree_id, Â Â Â Â Â Â Â zip_city, Â Â Â Â Â Â Â tree_dbh, Â Â Â Â Â Â Â boroname, Â Â Â Â Â Â Â nta_name, Â Â Â Â Â Â Â health, Â Â Â Â Â Â Â sidewalk, Â Â Â Â Â Â Â spc_latin as actual_label ...