HMMUnsupervisedLearner Example Output Message
message |
HMM models will be saved to the tables pi_loan, A_loan, and B_loan once the training process is successfully completed. |
The query below returns the output shown in the following table:
SELECT * FROM pi_loan ORDER BY 1, 2, 3;
HMMUnsupervisedLearner Example Output Message pi_loan
model_id |
state |
probability |
1 |
0 |
3.27859360752863e-09 |
1 |
1 |
6.31101164254861e-11 |
1 |
2 |
0.999999996658296 |
2 |
0 |
0.0281195637034241 |
2 |
1 |
0.0342773193334441 |
2 |
2 |
0.937603116963132 |
The following query returns the output shown in the following table:
SELECT * FROM A_loan ORDER BY 1, 2, 3;
HMMUnsupervisedLearner Example Output Table A_loan
model_id |
from_state |
to_state |
probability |
1 |
0 |
0 |
0.0640625915875049 |
1 |
0 |
1 |
0.935924962187232 |
1 |
0 |
2 |
1.24462252627054e-05 |
1 |
1 |
0 |
0.965881665949451 |
1 |
1 |
1 |
0.034116494612011 |
1 |
1 |
2 |
1.83943853841951e-06 |
1 |
2 |
0 |
0.0200526405800346 |
1 |
2 |
1 |
0.117982394786916 |
1 |
2 |
2 |
0.86196496463305 |
2 |
0 |
0 |
0.0135275442521027 |
2 |
0 |
1 |
0.831238578948845 |
2 |
0 |
2 |
0.155233876799053 |
2 |
1 |
0 |
0.650183335972221 |
2 |
1 |
1 |
0.176213616071229 |
2 |
1 |
2 |
0.17360304795655 |
2 |
2 |
0 |
0.143610221301369 |
2 |
2 |
1 |
0.259795319424887 |
2 |
2 |
2 |
0.596594459273744 |
The following query returns the output shown in the following table:
SELECT * FROM B_loan ORDER BY 1, 2, 3;
HMMUnsupervisedLearner Example Output Table B_loan
model_id |
state |
observed |
probability |
1 |
0 |
1 |
0.0278489806401534 |
1 |
0 |
2 |
2.13490305615227e-08 |
1 |
0 |
3 |
2.16452516177902e-08 |
1 |
0 |
4 |
0.303429629806469 |
1 |
0 |
5 |
4.02001410009148e-08 |
1 |
0 |
6 |
0.668721306358954 |
1 |
0 |
7 |
9.38935391851262e-218 |
1 |
0 |
8 |
1.07065392354079e-218 |
1 |
1 |
1 |
8.06980973060956e-05 |
1 |
1 |
2 |
0.0692752214932328 |
1 |
1 |
3 |
0.156873643540954 |
1 |
1 |
4 |
0.0227441708323421 |
1 |
1 |
5 |
0.213428380115597 |
1 |
1 |
6 |
0.537597885920567 |
1 |
1 |
7 |
1.71260624384861e-218 |
1 |
1 |
8 |
1.08244279935844e-217 |
1 |
2 |
1 |
0.993584745503789 |
1 |
2 |
2 |
0.0010870231448872 |
1 |
2 |
3 |
0.00531194778573366 |
1 |
2 |
4 |
1.62821429202875e-05 |
1 |
2 |
5 |
6.37778366603837e-11 |
1 |
2 |
6 |
1.35889208728403e-09 |
1 |
2 |
7 |
5.52574644335947e-220 |
1 |
2 |
8 |
5.07942195209965e-220 |
2 |
0 |
1 |
0.742492680184544 |
2 |
0 |
2 |
2.65054280803536e-06 |
2 |
0 |
3 |
3.46492926202034e-05 |
2 |
0 |
4 |
0.196209179240367 |
2 |
0 |
5 |
1.73539886740778e-10 |
2 |
0 |
6 |
0.0612608405661211 |
2 |
0 |
7 |
9.55020607438646e-216 |
2 |
0 |
8 |
1.0889956532584e-216 |
2 |
1 |
1 |
0.686900699423504 |
2 |
1 |
2 |
0.066121858529193 |
2 |
1 |
3 |
0.155155089264256 |
2 |
1 |
4 |
9.67394943767393e-06 |
2 |
1 |
5 |
0.0668633786585835 |
2 |
1 |
6 |
0.0249493001750253 |
2 |
1 |
7 |
1.5969261489751e-218 |
2 |
1 |
8 |
1.00932786930684e-217 |
2 |
2 |
1 |
0.998254250327946 |
2 |
2 |
2 |
0.000671519946212711 |
2 |
2 |
3 |
0.000761504268610617 |
2 |
2 |
4 |
0.00012244326239558 |
2 |
2 |
5 |
2.2387837278705e-06 |
2 |
2 |
6 |
0.000188043411107735 |
2 |
2 |
7 |
3.45823602960767e-219 |
2 |
2 |
8 |
3.17890807773867e-219 |