blob: 98e1015c5bb466abe3f3aa1c566f884bcba1f9c2 [file] [log] [blame]
<!-- HTML header for doxygen 1.8.4-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.10"/>
<meta name="keywords" content="madlib,postgres,greenplum,machine learning,data mining,deep learning,ensemble methods,data science,market basket analysis,affinity analysis,pca,lda,regression,elastic net,huber white,proportional hazards,k-means,latent dirichlet allocation,bayes,support vector machines,svm"/>
<title>MADlib: random_forest.sql_in File Reference</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtreedata.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<script type="text/javascript">
$(document).ready(initResizable);
$(window).load(resizeHeight);
</script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/searchdata.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
$(document).ready(function() { init_search(); });
</script>
<!-- hack in the navigation tree -->
<script type="text/javascript" src="eigen_navtree_hacks.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
<link href="madlib_extra.css" rel="stylesheet" type="text/css"/>
<!-- google analytics -->
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-45382226-1', 'madlib.net');
ga('send', 'pageview');
</script>
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
<tbody>
<tr style="height: 56px;">
<td id="projectlogo"><a href="http://madlib.net"><img alt="Logo" src="madlib.png" height="50" style="padding-left:0.5em;" border="0"/ ></a></td>
<td style="padding-left: 0.5em;">
<div id="projectname">
<span id="projectnumber">1.9.1</span>
</div>
<div id="projectbrief">User Documentation for MADlib</div>
</td>
<td> <div id="MSearchBox" class="MSearchBoxInactive">
<span class="left">
<img id="MSearchSelect" src="search/mag_sel.png"
onmouseover="return searchBox.OnSearchSelectShow()"
onmouseout="return searchBox.OnSearchSelectHide()"
alt=""/>
<input type="text" id="MSearchField" value="Search" accesskey="S"
onfocus="searchBox.OnSearchFieldFocus(true)"
onblur="searchBox.OnSearchFieldFocus(false)"
onkeyup="searchBox.OnSearchFieldChange(event)"/>
</span><span class="right">
<a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
</span>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.10 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
</div><!-- top -->
<div id="side-nav" class="ui-resizable side-nav-resizable">
<div id="nav-tree">
<div id="nav-tree-contents">
<div id="nav-sync" class="sync"></div>
</div>
</div>
<div id="splitbar" style="-moz-user-select:none;"
class="ui-resizable-handle">
</div>
</div>
<script type="text/javascript">
$(document).ready(function(){initNavTree('random__forest_8sql__in.html','');});
</script>
<div id="doc-content">
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
onmouseover="return searchBox.OnSearchSelectShow()"
onmouseout="return searchBox.OnSearchSelectHide()"
onkeydown="return searchBox.OnSearchSelectKey(event)">
</div>
<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0"
name="MSearchResults" id="MSearchResults">
</iframe>
</div>
<div class="header">
<div class="summary">
<a href="#func-members">Functions</a> </div>
<div class="headertitle">
<div class="title">random_forest.sql_in File Reference</div> </div>
</div><!--header-->
<div class="contents">
<table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="func-members"></a>
Functions</h2></td></tr>
<tr class="memitem:a5433a4e28f210a8a09fab2e918ea88c9"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a5433a4e28f210a8a09fab2e918ea88c9">forest_train</a> (text training_table_name, text output_table_name, text id_col_name, text dependent_variable, text list_of_features, text list_of_features_to_exclude, text grouping_cols, integer num_trees, integer num_random_features, boolean importance, integer num_permutations, integer max_tree_depth, integer min_split, integer min_bucket, integer num_splits, text surrogate_params, boolean verbose, float8 sample_ratio)</td></tr>
<tr class="memdesc:a5433a4e28f210a8a09fab2e918ea88c9"><td class="mdescLeft">&#160;</td><td class="mdescRight">Training of Random Forest. <a href="#a5433a4e28f210a8a09fab2e918ea88c9">More...</a><br /></td></tr>
<tr class="separator:a5433a4e28f210a8a09fab2e918ea88c9"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a807c2d0ab7a4c3b56d52aad07aedd02a"><td class="memItemLeft" align="right" valign="top">float8&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a807c2d0ab7a4c3b56d52aad07aedd02a">_get_bin_value_by_index</a> (bytea8 con_splits, integer feature_index, integer bin_index)</td></tr>
<tr class="separator:a807c2d0ab7a4c3b56d52aad07aedd02a"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a5abaf34ca61c9870463291b0851ef261"><td class="memItemLeft" align="right" valign="top">integer&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a5abaf34ca61c9870463291b0851ef261">_get_bin_index_by_value</a> (float8 bin_value, bytea8 con_splits, integer feature_index)</td></tr>
<tr class="separator:a5abaf34ca61c9870463291b0851ef261"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a022b4a4701e439538bd8aad7891ecee5"><td class="memItemLeft" align="right" valign="top">integer[]&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a022b4a4701e439538bd8aad7891ecee5">_get_bin_indices_by_values</a> (float8[] bin_values, bytea8 con_splits)</td></tr>
<tr class="separator:a022b4a4701e439538bd8aad7891ecee5"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a21d04e51fb54f374bbdc9810f3386b11"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a21d04e51fb54f374bbdc9810f3386b11">forest_predict</a> (text model, text source, text output, text pred_type)</td></tr>
<tr class="memdesc:a21d04e51fb54f374bbdc9810f3386b11"><td class="mdescLeft">&#160;</td><td class="mdescRight">Use random forest model to make predictions. <a href="#a21d04e51fb54f374bbdc9810f3386b11">More...</a><br /></td></tr>
<tr class="separator:a21d04e51fb54f374bbdc9810f3386b11"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aef268338ffa67f54ca1371326bb25fa0"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#aef268338ffa67f54ca1371326bb25fa0">forest_predict</a> (text model, text source, text output)</td></tr>
<tr class="separator:aef268338ffa67f54ca1371326bb25fa0"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a072cf9e76a6c9351a6089a3989f7e859"><td class="memItemLeft" align="right" valign="top">text&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a072cf9e76a6c9351a6089a3989f7e859">forest_predict</a> (text message)</td></tr>
<tr class="separator:a072cf9e76a6c9351a6089a3989f7e859"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a2f1d729cd2f2f3b8102a97f9063dae40"><td class="memItemLeft" align="right" valign="top">text&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a2f1d729cd2f2f3b8102a97f9063dae40">forest_predict</a> ()</td></tr>
<tr class="separator:a2f1d729cd2f2f3b8102a97f9063dae40"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af22b14c3da4f64b544b6c333a8e97070"><td class="memItemLeft" align="right" valign="top">varchar&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#af22b14c3da4f64b544b6c333a8e97070">get_tree</a> (text model_table, integer gid, integer sample_id, boolean dot_format)</td></tr>
<tr class="memdesc:af22b14c3da4f64b544b6c333a8e97070"><td class="mdescLeft">&#160;</td><td class="mdescRight">Display a single tree from random forest in dot or text format. <a href="#af22b14c3da4f64b544b6c333a8e97070">More...</a><br /></td></tr>
<tr class="separator:af22b14c3da4f64b544b6c333a8e97070"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af2abc993cde32a08278a411c28439bb6"><td class="memItemLeft" align="right" valign="top">varchar&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#af2abc993cde32a08278a411c28439bb6">get_tree</a> (text model_table, integer gid, integer sample_id)</td></tr>
<tr class="separator:af2abc993cde32a08278a411c28439bb6"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a6796f6dc96ce0f8b75c75061c348a6bb"><td class="memItemLeft" align="right" valign="top">varchar&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a6796f6dc96ce0f8b75c75061c348a6bb">get_tree</a> ()</td></tr>
<tr class="separator:a6796f6dc96ce0f8b75c75061c348a6bb"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a3ba1911b340a431982189e3e1f8c0111"><td class="memItemLeft" align="right" valign="top">varchar&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a3ba1911b340a431982189e3e1f8c0111">get_tree_surr</a> (text model_table, integer gid, integer sample_id)</td></tr>
<tr class="memdesc:a3ba1911b340a431982189e3e1f8c0111"><td class="mdescLeft">&#160;</td><td class="mdescRight">Display the surrogate splits for each internal node in a single tree from random forest. <a href="#a3ba1911b340a431982189e3e1f8c0111">More...</a><br /></td></tr>
<tr class="separator:a3ba1911b340a431982189e3e1f8c0111"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ab761f190afe9420e791ce6d1a3c3c719"><td class="memItemLeft" align="right" valign="top">varchar&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#ab761f190afe9420e791ce6d1a3c3c719">get_tree_surr</a> ()</td></tr>
<tr class="separator:ab761f190afe9420e791ce6d1a3c3c719"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a8c1ad829a371b4388703cad2f71d82f1"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a8c1ad829a371b4388703cad2f71d82f1">forest_train</a> (text training_table_name, text output_table_name, text id_col_name, text dependent_variable, text list_of_features, text list_of_features_to_exclude, text grouping_cols, integer num_trees, integer num_random_features, boolean importance, integer num_permutations, integer max_tree_depth, integer min_split, integer min_bucket, integer num_splits, text surrogate_params, boolean verbose)</td></tr>
<tr class="separator:a8c1ad829a371b4388703cad2f71d82f1"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af413c916c74c7f0d0e5ac543d931dfff"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#af413c916c74c7f0d0e5ac543d931dfff">forest_train</a> (text training_table_name, text output_table_name, text id_col_name, text dependent_variable, text list_of_features, text list_of_features_to_exclude, text grouping_cols, integer num_trees, integer num_random_features, boolean importance, integer num_permutations, integer max_tree_depth, integer min_split, integer min_bucket, integer num_splits, text surrogate_params)</td></tr>
<tr class="separator:af413c916c74c7f0d0e5ac543d931dfff"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af2e84b0cdcd87adbabbc5fa8caba9467"><td class="memItemLeft" align="right" valign="top">text&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#af2e84b0cdcd87adbabbc5fa8caba9467">forest_train</a> (text message)</td></tr>
<tr class="separator:af2e84b0cdcd87adbabbc5fa8caba9467"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aae56e36fc47ff539b9155180c8c0abb3"><td class="memItemLeft" align="right" valign="top">text&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#aae56e36fc47ff539b9155180c8c0abb3">forest_train</a> ()</td></tr>
<tr class="separator:aae56e36fc47ff539b9155180c8c0abb3"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a77c66aa21874aa49cb6a236b8c91cef4"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a77c66aa21874aa49cb6a236b8c91cef4">forest_train</a> (text training_table_name, text output_table_name, text id_col_name, text dependent_variable, text list_of_features, text list_of_features_to_exclude, text grouping_cols, integer num_trees, integer num_random_features, boolean importance, integer num_permutations, integer max_tree_depth, integer min_split, integer min_bucket, integer num_splits)</td></tr>
<tr class="separator:a77c66aa21874aa49cb6a236b8c91cef4"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a58a8ac26acb60396b15dabaaa3c4b742"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a58a8ac26acb60396b15dabaaa3c4b742">forest_train</a> (text training_table_name, text output_table_name, text id_col_name, text dependent_variable, text list_of_features, text list_of_features_to_exclude, text grouping_cols, integer num_trees, integer num_random_features, boolean importance, integer num_permutations, integer max_tree_depth, integer min_split, integer min_bucket)</td></tr>
<tr class="separator:a58a8ac26acb60396b15dabaaa3c4b742"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af7314fae3406399700ba75a6f385fda7"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#af7314fae3406399700ba75a6f385fda7">forest_train</a> (text training_table_name, text output_table_name, text id_col_name, text dependent_variable, text list_of_features, text list_of_features_to_exclude, text grouping_cols, integer num_trees, integer num_random_features, boolean importance, integer num_permutations, integer max_tree_depth, integer min_split)</td></tr>
<tr class="separator:af7314fae3406399700ba75a6f385fda7"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aa2b0e1092f8a0e789a1c8c50a88e966b"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#aa2b0e1092f8a0e789a1c8c50a88e966b">forest_train</a> (text training_table_name, text output_table_name, text id_col_name, text dependent_variable, text list_of_features, text list_of_features_to_exclude, text grouping_cols, integer num_trees, integer num_random_features, boolean importance, integer num_permutations, integer max_tree_depth)</td></tr>
<tr class="separator:aa2b0e1092f8a0e789a1c8c50a88e966b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:abdab5d1051736a984eb483a0a84d10a4"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#abdab5d1051736a984eb483a0a84d10a4">forest_train</a> (text training_table_name, text output_table_name, text id_col_name, text dependent_variable, text list_of_features, text list_of_features_to_exclude, text grouping_cols, integer num_trees, integer num_random_features, boolean importance, integer num_permutations)</td></tr>
<tr class="separator:abdab5d1051736a984eb483a0a84d10a4"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a741417bcd9541f4d12f45ee70082f4cb"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a741417bcd9541f4d12f45ee70082f4cb">forest_train</a> (text training_table_name, text output_table_name, text id_col_name, text dependent_variable, text list_of_features, text list_of_features_to_exclude, text grouping_cols, integer num_trees, integer num_random_features, boolean importance)</td></tr>
<tr class="separator:a741417bcd9541f4d12f45ee70082f4cb"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ae577213f72707260dee6f143c319090b"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#ae577213f72707260dee6f143c319090b">forest_train</a> (text training_table_name, text output_table_name, text id_col_name, text dependent_variable, text list_of_features, text list_of_features_to_exclude, text grouping_cols, integer num_trees, integer num_random_features)</td></tr>
<tr class="separator:ae577213f72707260dee6f143c319090b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a926e116171a0f794e1eff344de1f4935"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a926e116171a0f794e1eff344de1f4935">forest_train</a> (text training_table_name, text output_table_name, text id_col_name, text dependent_variable, text list_of_features, text list_of_features_to_exclude, text grouping_cols, integer num_trees)</td></tr>
<tr class="separator:a926e116171a0f794e1eff344de1f4935"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a6f1a5cae6cbb9cbc756e11bf34da5572"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a6f1a5cae6cbb9cbc756e11bf34da5572">forest_train</a> (text training_table_name, text output_table_name, text id_col_name, text dependent_variable, text list_of_features, text list_of_features_to_exclude, text grouping_cols)</td></tr>
<tr class="separator:a6f1a5cae6cbb9cbc756e11bf34da5572"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a04cbc760f3790bcf69fe48e008cfba3d"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a04cbc760f3790bcf69fe48e008cfba3d">forest_train</a> (text training_table_name, text output_table_name, text id_col_name, text dependent_variable, text list_of_features, text list_of_features_to_exclude)</td></tr>
<tr class="separator:a04cbc760f3790bcf69fe48e008cfba3d"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a5ec3574505880bc3f6e2620b6ab5cd02"><td class="memItemLeft" align="right" valign="top">float8[][]&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a5ec3574505880bc3f6e2620b6ab5cd02">_convert_to_random_forest_format</a> (bytea8 model)</td></tr>
<tr class="separator:a5ec3574505880bc3f6e2620b6ab5cd02"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a9b188037fd90e41b9590d8296351b645"><td class="memItemLeft" align="right" valign="top">float8[][]&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a9b188037fd90e41b9590d8296351b645">_rf_cat_imp_score</a> (bytea8 tree, integer[] cat_features, float8[] con_features, integer[] cat_n_levels, integer num_permutations, float8 y, boolean is_classification, float8[][] cat_feature_distributions)</td></tr>
<tr class="separator:a9b188037fd90e41b9590d8296351b645"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aa237f4a451150d5a44f7e871a62b4621"><td class="memItemLeft" align="right" valign="top">float8[]&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#aa237f4a451150d5a44f7e871a62b4621">_rf_con_imp_score</a> (bytea8 tree, integer[] cat_features, float8[] con_features, bytea8 con_splits, integer num_permutations, float8 y, boolean is_classification, float8[][] con_index_distrbutions)</td></tr>
<tr class="separator:aa237f4a451150d5a44f7e871a62b4621"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table>
<h2 class="groupheader">Function Documentation</h2>
<a class="anchor" id="a5ec3574505880bc3f6e2620b6ab5cd02"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">float8 [][] _convert_to_random_forest_format </td>
<td>(</td>
<td class="paramtype">bytea8&#160;</td>
<td class="paramname"><em>model</em></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a5abaf34ca61c9870463291b0851ef261"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">integer _get_bin_index_by_value </td>
<td>(</td>
<td class="paramtype">float8&#160;</td>
<td class="paramname"><em>bin_value</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">bytea8&#160;</td>
<td class="paramname"><em>con_splits</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>feature_index</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a022b4a4701e439538bd8aad7891ecee5"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">integer [] _get_bin_indices_by_values </td>
<td>(</td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>bin_values</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">bytea8&#160;</td>
<td class="paramname"><em>con_splits</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a807c2d0ab7a4c3b56d52aad07aedd02a"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">float8 _get_bin_value_by_index </td>
<td>(</td>
<td class="paramtype">bytea8&#160;</td>
<td class="paramname"><em>con_splits</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>feature_index</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>bin_index</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a9b188037fd90e41b9590d8296351b645"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">float8 [][] _rf_cat_imp_score </td>
<td>(</td>
<td class="paramtype">bytea8&#160;</td>
<td class="paramname"><em>tree</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer[]&#160;</td>
<td class="paramname"><em>cat_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>con_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer[]&#160;</td>
<td class="paramname"><em>cat_n_levels</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_permutations</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8&#160;</td>
<td class="paramname"><em>y</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>is_classification</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8&#160;</td>
<td class="paramname"><em>cat_feature_distributions</em>[][]&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="aa237f4a451150d5a44f7e871a62b4621"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">float8 [] _rf_con_imp_score </td>
<td>(</td>
<td class="paramtype">bytea8&#160;</td>
<td class="paramname"><em>tree</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer[]&#160;</td>
<td class="paramname"><em>cat_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8[]&#160;</td>
<td class="paramname"><em>con_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">bytea8&#160;</td>
<td class="paramname"><em>con_splits</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_permutations</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8&#160;</td>
<td class="paramname"><em>y</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>is_classification</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8&#160;</td>
<td class="paramname"><em>con_index_distrbutions</em>[][]&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a21d04e51fb54f374bbdc9810f3386b11"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void forest_predict </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>model</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>source</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>output</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>pred_type</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
<table class="params">
<tr><td class="paramname">model</td><td>Name of the table containing the random forest model </td></tr>
<tr><td class="paramname">source</td><td>Name of table containing prediction data </td></tr>
<tr><td class="paramname">output</td><td>Name of table to output prediction results </td></tr>
<tr><td class="paramname">pred_type</td><td>OPTIONAL (Default = 'response'). For regression trees, 'response', implies output is the predicted value. For classification models, this can be 'response', giving the classification prediction as output, or ‘prob’, giving the class probabilities as output (for two classes, only a single probability value is output that corresponds to the first class when the two classes are sorted by name; in case of more than two classes, an array of class probabilities (a probability of each class) is output).</td></tr>
</table>
</dd>
</dl>
<p>See <a class="el" href="group__grp__random__forest.html">Random Forest</a> for more details. </p>
</div>
</div>
<a class="anchor" id="aef268338ffa67f54ca1371326bb25fa0"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void forest_predict </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>model</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>source</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>output</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a072cf9e76a6c9351a6089a3989f7e859"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">text forest_predict </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>message</em></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a2f1d729cd2f2f3b8102a97f9063dae40"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">text forest_predict </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a5433a4e28f210a8a09fab2e918ea88c9"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void forest_train </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>training_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>output_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>id_col_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>dependent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features_to_exclude</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_trees</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_random_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>importance</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_permutations</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>max_tree_depth</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>min_split</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>min_bucket</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_splits</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>surrogate_params</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>verbose</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8&#160;</td>
<td class="paramname"><em>sample_ratio</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
<table class="params">
<tr><td class="paramname">training_table_name</td><td>Name of the table containing data. </td></tr>
<tr><td class="paramname">output_table_name</td><td>Name of the table to output the model. </td></tr>
<tr><td class="paramname">id_col_name</td><td>Name of column containing the id information in training data. </td></tr>
<tr><td class="paramname">dependent_variable</td><td>Name of the column that contains the output for training. Boolean, integer and text are considered classification outputs, while float values are considered regression outputs. </td></tr>
<tr><td class="paramname">list_of_features</td><td>List of column names (comma-separated string) to use as predictors. Can also be a ‘*’ implying all columns are to be used as predictors (except the ones included in the next argument). Boolean, integer, and text columns are considered categorical columns. </td></tr>
<tr><td class="paramname">list_of_features_to_exclude</td><td>OPTIONAL. List of column names (comma-separated string) to exlude from the predictors list. </td></tr>
<tr><td class="paramname">grouping_cols</td><td>OPTIONAL. List of column names (comma-separated string) to group the data by. This will lead to creating multiple Random Forests, one for each group. </td></tr>
<tr><td class="paramname">num_trees</td><td>OPTIONAL (Default = 100). Maximum number of trees to grow in the Random forest model. </td></tr>
<tr><td class="paramname">num_random_features</td><td>OPTIONAL (Default = sqrt(n) for classification, n/3 for regression) Number of features to randomly select at each split. </td></tr>
<tr><td class="paramname">max_tree_depth</td><td>OPTIONAL (Default = 10). Set the maximum depth of any node of the final tree, with the root node counted as depth 0. </td></tr>
<tr><td class="paramname">min_split</td><td>OPTIONAL (Default = 20). Minimum number of observations that must exist in a node for a split to be attempted. </td></tr>
<tr><td class="paramname">min_bucket</td><td>OPTIONAL (Default = minsplit/3). Minimum number of observations in any terminal node. If only one of minbucket or minsplit is specified, minsplit is set to minbucket*3 or minbucket to minsplit/3, as appropriate. </td></tr>
<tr><td class="paramname">num_splits</td><td>optional (default = 100) number of bins to use during binning. continuous-valued features are binned into discrete bins (per the quartile values) to compute split bound- aries. this global parameter is used to compute the resolution of the bins. higher number of bins will lead to higher processing time. </td></tr>
<tr><td class="paramname">verbose</td><td>optional (default = false) prints status information on the splits performed and any other information useful for debugging. </td></tr>
<tr><td class="paramname">importance</td><td>optional (default = false) calculates variable importance of all features if True </td></tr>
<tr><td class="paramname">num_permutations</td><td>optional (default = 1) number of times to permute feature values while calculating variable importance</td></tr>
</table>
</dd>
</dl>
<p>see <a class="el" href="group__grp__random__forest.html">Random Forest</a> for more details. </p>
</div>
</div>
<a class="anchor" id="a8c1ad829a371b4388703cad2f71d82f1"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void forest_train </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>training_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>output_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>id_col_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>dependent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features_to_exclude</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_trees</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_random_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>importance</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_permutations</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>max_tree_depth</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>min_split</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>min_bucket</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_splits</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>surrogate_params</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>verbose</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="af413c916c74c7f0d0e5ac543d931dfff"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void forest_train </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>training_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>output_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>id_col_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>dependent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features_to_exclude</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_trees</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_random_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>importance</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_permutations</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>max_tree_depth</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>min_split</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>min_bucket</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_splits</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>surrogate_params</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="af2e84b0cdcd87adbabbc5fa8caba9467"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">text forest_train </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>message</em></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="aae56e36fc47ff539b9155180c8c0abb3"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">text forest_train </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a77c66aa21874aa49cb6a236b8c91cef4"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void forest_train </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>training_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>output_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>id_col_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>dependent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features_to_exclude</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_trees</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_random_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>importance</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_permutations</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>max_tree_depth</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>min_split</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>min_bucket</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_splits</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a58a8ac26acb60396b15dabaaa3c4b742"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void forest_train </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>training_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>output_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>id_col_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>dependent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features_to_exclude</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_trees</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_random_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>importance</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_permutations</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>max_tree_depth</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>min_split</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>min_bucket</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="af7314fae3406399700ba75a6f385fda7"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void forest_train </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>training_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>output_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>id_col_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>dependent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features_to_exclude</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_trees</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_random_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>importance</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_permutations</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>max_tree_depth</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>min_split</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="aa2b0e1092f8a0e789a1c8c50a88e966b"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void forest_train </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>training_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>output_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>id_col_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>dependent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features_to_exclude</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_trees</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_random_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>importance</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_permutations</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>max_tree_depth</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="abdab5d1051736a984eb483a0a84d10a4"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void forest_train </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>training_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>output_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>id_col_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>dependent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features_to_exclude</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_trees</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_random_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>importance</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_permutations</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a741417bcd9541f4d12f45ee70082f4cb"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void forest_train </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>training_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>output_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>id_col_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>dependent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features_to_exclude</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_trees</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_random_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>importance</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="ae577213f72707260dee6f143c319090b"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void forest_train </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>training_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>output_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>id_col_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>dependent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features_to_exclude</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_trees</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_random_features</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a926e116171a0f794e1eff344de1f4935"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void forest_train </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>training_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>output_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>id_col_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>dependent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features_to_exclude</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>grouping_cols</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>num_trees</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a6f1a5cae6cbb9cbc756e11bf34da5572"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void forest_train </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>training_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>output_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>id_col_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>dependent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features_to_exclude</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>grouping_cols</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a04cbc760f3790bcf69fe48e008cfba3d"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void forest_train </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>training_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>output_table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>id_col_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>dependent_variable</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>list_of_features_to_exclude</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="af22b14c3da4f64b544b6c333a8e97070"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">varchar get_tree </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>model_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>gid</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>sample_id</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">boolean&#160;</td>
<td class="paramname"><em>dot_format</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
<table class="params">
<tr><td class="paramname">forest_model</td><td>Name of the table containing the random forest model </td></tr>
<tr><td class="paramname">gid</td><td>Group id of the tree to display </td></tr>
<tr><td class="paramname">sample_id</td><td>Sample id of the tree to display TRUE if dot format, FALSE for text format </td></tr>
</table>
</dd>
</dl>
</div>
</div>
<a class="anchor" id="af2abc993cde32a08278a411c28439bb6"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">varchar get_tree </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>model_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>gid</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>sample_id</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a6796f6dc96ce0f8b75c75061c348a6bb"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">varchar get_tree </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a class="anchor" id="a3ba1911b340a431982189e3e1f8c0111"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">varchar get_tree_surr </td>
<td>(</td>
<td class="paramtype">text&#160;</td>
<td class="paramname"><em>model_table</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>gid</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">integer&#160;</td>
<td class="paramname"><em>sample_id</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
<dl class="params"><dt>Parameters</dt><dd>
<table class="params">
<tr><td class="paramname">forest_model</td><td>Name of the table containing the random forest model </td></tr>
<tr><td class="paramname">gid</td><td>Group id of the tree to display </td></tr>
<tr><td class="paramname">sample_id</td><td>Sample id of the tree to display </td></tr>
</table>
</dd>
</dl>
</div>
</div>
<a class="anchor" id="ab761f190afe9420e791ce6d1a3c3c719"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">varchar get_tree_surr </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
</div><!-- contents -->
</div><!-- doc-content -->
<!-- start footer part -->
<div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
<ul>
<li class="navelem"><a class="el" href="dir_68267d1309a1af8e8297ef4c3efbcdba.html">src</a></li><li class="navelem"><a class="el" href="dir_efbcf68973d247bbf15f9eecae7f24e3.html">ports</a></li><li class="navelem"><a class="el" href="dir_a4a48839224ef8488facbffa8a397967.html">postgres</a></li><li class="navelem"><a class="el" href="dir_dc596537ad427a4d866006d1a3e1fe29.html">modules</a></li><li class="navelem"><a class="el" href="dir_5341dbb6d7f0a427749c6136276fa506.html">recursive_partitioning</a></li><li class="navelem"><a class="el" href="random__forest_8sql__in.html">random_forest.sql_in</a></li>
<li class="footer">Generated on Tue Sep 20 2016 11:27:01 for MADlib by
<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.10 </li>
</ul>
</div>
</body>
</html>