[ https://issues.apache.org/jira/browse/MADLIB-925?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16565896#comment-16565896 ]
ASF GitHub Bot commented on MADLIB-925: --------------------------------------- Github user asfgit closed the pull request at: https://github.com/apache/madlib/pull/295 > Improve RF output format for variable importance (and new DT/RF impurity > importance) > ------------------------------------------------------------------------------------- > > Key: MADLIB-925 > URL: https://issues.apache.org/jira/browse/MADLIB-925 > Project: Apache MADlib > Issue Type: Improvement > Components: Module: Random Forest > Reporter: Frank McQuillan > Assignee: Nandish Jayaram > Priority: Major > Labels: starter > Fix For: v1.15 > > > As a user, > I want to have an easier way of accessing the variable importance output from > random forest so that I can understand which are the most important variables. > Current method of getting variable importance for each variable (in a tabular > format - assuming output table name is `rf_output`): > ``` > SELECT unnest(regexp_split_to_array(cat_features, ',')) as variable, > unnest(cat_var_importance) as importance > FROM rf_output_group, rf_output_summary; > ``` > This is a cumbersome query to write and has to be written twice - for > categorical and for continuous features. -- This message was sent by Atlassian JIRA (v7.6.3#76005)