[jira] [Updated] (MADLIB-925) Improve RF output format for variable importance

["Frank McQuillan (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/MADLIB-925?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Frank McQuillan updated MADLIB-925:
-----------------------------------
    Labels: starter  (was: gsoc2016 starter)

> Improve RF output format for variable 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
>              Labels: starter
>
> 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
(v6.4.14#64029)