Input
The input table is admissions_test, as in GLMPredict_MLE GLMPredict_MLE Example: Logistic Distribution Prediction.
The model table is admissions_model, output of GLML1L2 Example: Ridge Regression, Family ('BINOMIAL').
SQL Call
SELECT * FROM GLML1L2Predict ( ON admissions_test PARTITION BY ANY ON admissions_model AS Model DIMENSION USING OutputProb ('true') Accumulate ('id') ) AS dt ORDER BY id;
Output
id prediction prob -- ---------- ------------------- 50 0.0 0.42261164778201094 51 0.0 0.4049408918235976 52 1.0 0.6791731064692488 53 1.0 0.6128348254047428 54 1.0 0.6321200551583135 55 1.0 0.8635298008802573 56 1.0 0.8639684744611825 57 1.0 0.8589345247253525 58 1.0 0.8297786450140937 59 1.0 0.8421968614075399 60 1.0 0.8624268462528424 61 1.0 0.6575556307139581 62 1.0 0.8584692566063056 63 1.0 0.8644185196041072 64 1.0 0.640966603964 65 1.0 0.6488695133874245 66 1.0 0.693208669498573 67 0.0 0.35267304201513183 68 1.0 0.7347418494287773 69 1.0 0.8701555291596779
Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.