点击此处---> 群内免费提供SAP练习系统(在群公告中)
加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)
1使用随机森林算法我想在公用事业使用水平高,信用风险数高,已支付的滞纳金数量更多的情况下,识别高风险客户示例,我想将客户标记为高风险客户。
SET SCHEMA DM_PAL; 删除类型PAL_RF_SCORING_DATA_T; 创建类型PAL_RF_SCORING_DATA_T AS TABLE(" CONTRACT_ID" INTEGER," TEMPDIFF" VARCHAR(20)," CREDITRISK_RANK" INTEGER," LATEFEE_PAID" DOUBLE," IS_RISK" VARCHAR(10)); 删除类型PAL_RF_SCORING_MODEL_T; 创建类型为PAL_RF_SCORING_MODEL_T的表(" ID" INTEGER," TREEINDEX" INTEGER," MODEL" VARCHAR(5000)); 删除类型PAL_RF_SCORING_RESULT_T; 创建类型为PAL_RF_SCORING_RESULT_T TABLE(" ID" INTEGER," SCORING" VARCHAR(50)," PROB" DOUBLE); DROP TYPE PAL_CONTROL_T; 创建类型PAL_CONTROL_T AS TABLE(" NAME" VARCHAR(100)," INTARGS" INTEGER," DOUBLEARGS" DOUBLE," STRINGARGS" VARCHAR(100)); 删除表PAL_RF_SCORING_PDATA_TBL; 创建列表PAL_RF_SCORING_PDATA_TBL(" POSITION" INT," SCHEMA_NAME" NVARCHAR(256)," TYPE_NAME" NVARCHAR(256)," PARAMETER_TYPE" VARCHAR(7)); INSERT INTO PAL_RF_SCORING_PDATA_TBL VALUES(1,'DM_PAL','PAL_RF_SCORING_DATA_T','IN'); INSERT INTO PAL_RF_SCORING_PDATA_TBL VALUES(2,'DM_PAL','PAL_CONTROL_T','IN'); INSERT INTO PAL_RF_SCORING_PDATA_TBL VALUES(3,'DM_PAL','PAL_RF_SCORING_MODEL_T','IN'); INSERT INTO PAL_RF_SCORING_PDATA_TBL VALUES(4,'DM_PAL','PAL_RF_SCORING_RESULT_TBL','OUT'); 呼叫" SYS"。AFLLANG_WRAPPER_PROCEDURE_DROP('DM_PAL','PAL_RF_SCORING_PROC'); 调用" SYS" .AFLLANG_WRAPPER_PROCEDURE_CREATE('AFLPAL','RANDOMFORESTSCORING','DM_PAL','PAL_RF_SCORING_PROC',PAL_RF_SCORING_PDATA_TBL); DROP TABLE #PAL_CONTROL_TBL; 创建本地临时列表#PAL_CONTROL_TBL(" NAME" VARCHAR(100)," INTARGS" INTEGER," DOUBLEARGS" DOUBLE," STRINGARGS" VARCHAR(100)); INSERT INTO #PAL_CONTROL_TBL VALUES('THREAD_NUMBER',20,null,null); INSERT INTO #PAL_CONTROL_TBL VALUES('VERBOSE',0,null,null); 删除表PAL_RF_SCORING_DATA_TBL; 创建列表PAL_RF_SCORING_DATA_TBL喜欢PAL_RF_SCORING_DATA_T; INSERT INTO PAL_RF_SCORING_DATA_TBL VALUES(0,'LT',10,12,'Yes'); INSERT INTO PAL_RF_SCORING_DATA_TBL VALUES(1,'LT',10,11,'Yes'); 插入到PAL_RF_SCORING_DATA_TBL VALUES(2,'HT',1,1,'No'); 插入到PAL_RF_SCORING_DATA_TBL VALUES(3,'HT',1,1,'No'); INSERT INTO PAL_RF_SCORING_DATA_TBL VALUES(4,'LT',10,11,'Yes'); 插入PAL_RF_SCORING_DATA_TBL值(5,'LT',10,11,'是'); INSERT INTO PAL_RF_SCORING_DATA_TBL VALUES(6,'HT',1,1,'No'); 删除表PAL_RF_SCORING_RESULT_TBL; 创建列表PAL_RF_SCORING_RESULT_TBL喜欢PAL_RF_SCORING_RESULT_T; 呼叫" DM_PAL"。PAL_RF_SCORING_PROC(PAL_RF_SCORING_DATA_TBL,#PAL_CONTROL_TBL,PAL_RF_MODEL_TBL,PAL_RF_SCORING_RESULT_TBL); SELECT * FROM PAL_RF_SCORING_RESULT_TBL;
但是输出结果为空。 请告知
已修复。
嗨! 太好了,您自己修复。 您能否分享解决方案,以便我们所有人都能从中受益? 谢谢!
一周热门 更多>