
224
|
第
5
章
REGEXP_EXTRACT(raw_prediction, r'.*"source": "(.*?)"') AS prediction,
REGEXP_EXTRACT(raw_prediction, r'.*"confidence": (0.\d{2}).*') AS confidence,
REGEXP_EXTRACT(groundtruth, r'.*"source": "(.*?)"') AS groundtruth,
FROM
txtcls_eval.swivel
表
5
-
2
:一旦真实情况可用,就可以将其添加到原始 BigQuery 表中,并评估模型性能
行
model model_version time text prediction condence groundtruth
1 txtcls swivel 2020-06-10 A native Mac app wrapper github 0.77 github
01:38:13 UTC for WhatsApp Web
2 txtcls swivel 2020-06-10 Senate Conrms First Black nytimes 0.99 nytimes
01:37:46 UTC Air Force Chief
3 txtcls swivel 2020-06-10 Astronauts Dock With Space ...