Input
The input table is admissions_factor_table, output by GLML1L2 Example: Ridge Regression, Family ('BINOMIAL'). In admissions_factor_table, categorical predictors were converted to integers.
SQL Call
Because the admissions_factor_table has only integers, this call does not specify CategoricalColumns.
DROP TABLE admissions_model_2; CREATE MULTISET TABLE admissions_model_2 AS ( SELECT * FROM GLML1L2 ( ON admissions_factor_table AS InputTable USING TargetColumns ('[0:5]') ResponseColumn ('admitted') Family ('BINOMIAL') Alpha (0) RegularizationLambda (0.02) ) AS dt ) WITH DATA;
Output
SELECT * FROM admissions_model_2;
attribute estimate information -------------------- --------------------- ----------- AIC 15.21927981934978 NULL Iterations # 28.0 NULL Features # 6.0 NULL Alpha 0.0 NULL Lambda 0.02 NULL stats_novice -0.026716553307241597 p programming_novice -0.0820786516340258 p Regularization NULL Ridge Family NULL Binomial Converged NULL true gpa 0.38346423433872745 p Rows # 40.0 NULL BIC 27.041435998147332 NULL (Intercept) 0.3838162407664626 p programming_beginner -1.0259430213730834 p stats_beginner 0.08063465501463249 p masters_yes -1.2652530272653697 p
Download a zip file of all examples and a SQL script file that creates their input tables.