Google Git
Sign in
apache / madlib-site / da7bed6a2b56b966779ebd8366a01690f8b18cf3 / . / docs / v1.18.0 / random__forest_8sql__in.html
blob: 3cba2fc6a1e81f0089b8b528759c540d6c54e352 [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.13"/>
<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);
</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>
<script type="text/x-mathjax-config">
MathJax.Hub.Config({
extensions: ["tex2jax.js", "TeX/AMSmath.js", "TeX/AMSsymbols.js"],
jax: ["input/TeX","output/HTML-CSS"],
});
</script><script type="text/javascript" src="http://cdn.mathjax.org/mathjax/latest/MathJax.js"></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.apache.org');
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.apache.org"><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.18.0</span>
</div>
<div id="projectbrief">User Documentation for Apache 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.13 -->
<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> &#124;
<a href="#var-members">Variables</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:a449144c760063041399eaed682d17af4"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a449144c760063041399eaed682d17af4">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 null_handling_params, boolean verbose, float8 sample_ratio)</td></tr>
<tr class="memdesc:a449144c760063041399eaed682d17af4"><td class="mdescLeft">&#160;</td><td class="mdescRight">Training of Random Forest. <a href="#a449144c760063041399eaed682d17af4">More...</a><br /></td></tr>
<tr class="separator:a449144c760063041399eaed682d17af4"><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:aea5ca2b827a4ee552a8c0f4d4d947725"><td class="memItemLeft" align="right" valign="top">CREATE OR REPLACE FUNCTION madlib&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#aea5ca2b827a4ee552a8c0f4d4d947725">get_var_importance</a> (model_table TEXT, output_table TEXT) RETURNS VOID AS $$ PythonFunction(recursive_partitioning</td></tr>
<tr class="separator:aea5ca2b827a4ee552a8c0f4d4d947725"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a02aabd66a900f6cd233274c7d16268ac"><td class="memItemLeft" align="right" valign="top">CREATE OR REPLACE FUNCTION madlib&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a02aabd66a900f6cd233274c7d16268ac">get_var_importance</a> (message TEXT) RETURNS TEXT AS $$ PythonFunction(recursive_partitioning</td></tr>
<tr class="separator:a02aabd66a900f6cd233274c7d16268ac"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a8a375b28fa555fb9a24dd8177902a7d5"><td class="memItemLeft" align="right" valign="top">CREATE OR REPLACE FUNCTION madlib&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a8a375b28fa555fb9a24dd8177902a7d5">get_var_importance</a> () RETURNS TEXT AS $$ BEGIN RETURN madlib.get_var_importance('')</td></tr>
<tr class="separator:a8a375b28fa555fb9a24dd8177902a7d5"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a513524a87a38b2d6a50ac74c5d073a14"><td class="memItemLeft" align="right" valign="top">varchar&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a513524a87a38b2d6a50ac74c5d073a14">get_tree</a> (text model_table, integer gid, integer sample_id, boolean dot_format, boolean verbose)</td></tr>
<tr class="memdesc:a513524a87a38b2d6a50ac74c5d073a14"><td class="mdescLeft">&#160;</td><td class="mdescRight">Display a single tree from random forest in dot or text format. <a href="#a513524a87a38b2d6a50ac74c5d073a14">More...</a><br /></td></tr>
<tr class="separator:a513524a87a38b2d6a50ac74c5d073a14"><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="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:a5d5622998b4e3ab4ee0b22de9c436960"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a5d5622998b4e3ab4ee0b22de9c436960">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 null_handling_params, boolean verbose)</td></tr>
<tr class="separator:a5d5622998b4e3ab4ee0b22de9c436960"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ae0786fea458787a914e9711ee167750d"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#ae0786fea458787a914e9711ee167750d">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 null_handling_params)</td></tr>
<tr class="separator:ae0786fea458787a914e9711ee167750d"><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>
<tr class="memitem:a33a268c5561595aa0efe6508bfaf6d47"><td class="memItemLeft" align="right" valign="top">float8 []&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a33a268c5561595aa0efe6508bfaf6d47">normalize_sum_array</a> (float8[] input_array, float8 target_sum)</td></tr>
<tr class="separator:a33a268c5561595aa0efe6508bfaf6d47"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="var-members"></a>
Variables</h2></td></tr>
<tr class="memitem:a7b9a14c36355554372b1163f7b157b88"><td class="memItemLeft" align="right" valign="top">CREATE OR REPLACE FUNCTION madlib&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a7b9a14c36355554372b1163f7b157b88">random_forest</a></td></tr>
<tr class="separator:a7b9a14c36355554372b1163f7b157b88"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a9cf684a2e9bdf9ed0906e11f19b80037"><td class="memItemLeft" align="right" valign="top">CREATE OR REPLACE FUNCTION madlib <a class="el" href="random__forest_8sql__in.html#a8a375b28fa555fb9a24dd8177902a7d5">get_var_importance</a> LANGUAGE plpythonu&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a9cf684a2e9bdf9ed0906e11f19b80037">VOLATILE</a></td></tr>
<tr class="separator:a9cf684a2e9bdf9ed0906e11f19b80037"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a8ee741e3812ad259d3ca4c9fa489dc7e"><td class="memItemLeft" align="right" valign="top">CREATE OR REPLACE FUNCTION madlib _importance_help_message LANGUAGE plpythonu&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a8ee741e3812ad259d3ca4c9fa489dc7e">IMMUTABLE</a></td></tr>
<tr class="separator:a8ee741e3812ad259d3ca4c9fa489dc7e"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a1de54bd922161dd5c6a353647f448fd6"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="random__forest_8sql__in.html#a1de54bd922161dd5c6a353647f448fd6">END</a></td></tr>
<tr class="separator:a1de54bd922161dd5c6a353647f448fd6"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table>
<h2 class="groupheader">Function Documentation</h2>
<a id="a5ec3574505880bc3f6e2620b6ab5cd02"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a5ec3574505880bc3f6e2620b6ab5cd02">&#9670;&nbsp;</a></span>_convert_to_random_forest_format()</h2>
<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 id="a5abaf34ca61c9870463291b0851ef261"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a5abaf34ca61c9870463291b0851ef261">&#9670;&nbsp;</a></span>_get_bin_index_by_value()</h2>
<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 id="a022b4a4701e439538bd8aad7891ecee5"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a022b4a4701e439538bd8aad7891ecee5">&#9670;&nbsp;</a></span>_get_bin_indices_by_values()</h2>
<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 id="a807c2d0ab7a4c3b56d52aad07aedd02a"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a807c2d0ab7a4c3b56d52aad07aedd02a">&#9670;&nbsp;</a></span>_get_bin_value_by_index()</h2>
<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 id="a9b188037fd90e41b9590d8296351b645"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a9b188037fd90e41b9590d8296351b645">&#9670;&nbsp;</a></span>_rf_cat_imp_score()</h2>
<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 id="aa237f4a451150d5a44f7e871a62b4621"></a>
<h2 class="memtitle"><span class="permalink"><a href="#aa237f4a451150d5a44f7e871a62b4621">&#9670;&nbsp;</a></span>_rf_con_imp_score()</h2>
<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 id="a21d04e51fb54f374bbdc9810f3386b11"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a21d04e51fb54f374bbdc9810f3386b11">&#9670;&nbsp;</a></span>forest_predict() <span class="overload">[1/4]</span></h2>
<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 id="aef268338ffa67f54ca1371326bb25fa0"></a>
<h2 class="memtitle"><span class="permalink"><a href="#aef268338ffa67f54ca1371326bb25fa0">&#9670;&nbsp;</a></span>forest_predict() <span class="overload">[2/4]</span></h2>
<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 id="a072cf9e76a6c9351a6089a3989f7e859"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a072cf9e76a6c9351a6089a3989f7e859">&#9670;&nbsp;</a></span>forest_predict() <span class="overload">[3/4]</span></h2>
<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 id="a2f1d729cd2f2f3b8102a97f9063dae40"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a2f1d729cd2f2f3b8102a97f9063dae40">&#9670;&nbsp;</a></span>forest_predict() <span class="overload">[4/4]</span></h2>
<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 id="a449144c760063041399eaed682d17af4"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a449144c760063041399eaed682d17af4">&#9670;&nbsp;</a></span>forest_train() <span class="overload">[1/15]</span></h2>
<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>null_handling_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>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 = 7). 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 = 20) number of bins to use during binning. Continuous-valued features are binned into discrete bins (per the quartile values) to compute split boundaries. This global parameter is used to compute the resolution of the bins. Higher number of bins will lead to higher processing time and more memory usage. </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 id="a5d5622998b4e3ab4ee0b22de9c436960"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a5d5622998b4e3ab4ee0b22de9c436960">&#9670;&nbsp;</a></span>forest_train() <span class="overload">[2/15]</span></h2>
<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>null_handling_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 id="ae0786fea458787a914e9711ee167750d"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ae0786fea458787a914e9711ee167750d">&#9670;&nbsp;</a></span>forest_train() <span class="overload">[3/15]</span></h2>
<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>null_handling_params</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a id="af2e84b0cdcd87adbabbc5fa8caba9467"></a>
<h2 class="memtitle"><span class="permalink"><a href="#af2e84b0cdcd87adbabbc5fa8caba9467">&#9670;&nbsp;</a></span>forest_train() <span class="overload">[4/15]</span></h2>
<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 id="aae56e36fc47ff539b9155180c8c0abb3"></a>
<h2 class="memtitle"><span class="permalink"><a href="#aae56e36fc47ff539b9155180c8c0abb3">&#9670;&nbsp;</a></span>forest_train() <span class="overload">[5/15]</span></h2>
<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 id="a77c66aa21874aa49cb6a236b8c91cef4"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a77c66aa21874aa49cb6a236b8c91cef4">&#9670;&nbsp;</a></span>forest_train() <span class="overload">[6/15]</span></h2>
<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 id="a58a8ac26acb60396b15dabaaa3c4b742"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a58a8ac26acb60396b15dabaaa3c4b742">&#9670;&nbsp;</a></span>forest_train() <span class="overload">[7/15]</span></h2>
<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 id="af7314fae3406399700ba75a6f385fda7"></a>
<h2 class="memtitle"><span class="permalink"><a href="#af7314fae3406399700ba75a6f385fda7">&#9670;&nbsp;</a></span>forest_train() <span class="overload">[8/15]</span></h2>
<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 id="aa2b0e1092f8a0e789a1c8c50a88e966b"></a>
<h2 class="memtitle"><span class="permalink"><a href="#aa2b0e1092f8a0e789a1c8c50a88e966b">&#9670;&nbsp;</a></span>forest_train() <span class="overload">[9/15]</span></h2>
<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 id="abdab5d1051736a984eb483a0a84d10a4"></a>
<h2 class="memtitle"><span class="permalink"><a href="#abdab5d1051736a984eb483a0a84d10a4">&#9670;&nbsp;</a></span>forest_train() <span class="overload">[10/15]</span></h2>
<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 id="a741417bcd9541f4d12f45ee70082f4cb"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a741417bcd9541f4d12f45ee70082f4cb">&#9670;&nbsp;</a></span>forest_train() <span class="overload">[11/15]</span></h2>
<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 id="ae577213f72707260dee6f143c319090b"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ae577213f72707260dee6f143c319090b">&#9670;&nbsp;</a></span>forest_train() <span class="overload">[12/15]</span></h2>
<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 id="a926e116171a0f794e1eff344de1f4935"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a926e116171a0f794e1eff344de1f4935">&#9670;&nbsp;</a></span>forest_train() <span class="overload">[13/15]</span></h2>
<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 id="a6f1a5cae6cbb9cbc756e11bf34da5572"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a6f1a5cae6cbb9cbc756e11bf34da5572">&#9670;&nbsp;</a></span>forest_train() <span class="overload">[14/15]</span></h2>
<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 id="a04cbc760f3790bcf69fe48e008cfba3d"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a04cbc760f3790bcf69fe48e008cfba3d">&#9670;&nbsp;</a></span>forest_train() <span class="overload">[15/15]</span></h2>
<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 id="a513524a87a38b2d6a50ac74c5d073a14"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a513524a87a38b2d6a50ac74c5d073a14">&#9670;&nbsp;</a></span>get_tree() <span class="overload">[1/4]</span></h2>
<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>, </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">
<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 TRUE if the dot format output will contain additional information </td></tr>
</table>
</dd>
</dl>
</div>
</div>
<a id="af22b14c3da4f64b544b6c333a8e97070"></a>
<h2 class="memtitle"><span class="permalink"><a href="#af22b14c3da4f64b544b6c333a8e97070">&#9670;&nbsp;</a></span>get_tree() <span class="overload">[2/4]</span></h2>
<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">
</div>
</div>
<a id="af2abc993cde32a08278a411c28439bb6"></a>
<h2 class="memtitle"><span class="permalink"><a href="#af2abc993cde32a08278a411c28439bb6">&#9670;&nbsp;</a></span>get_tree() <span class="overload">[3/4]</span></h2>
<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 id="a6796f6dc96ce0f8b75c75061c348a6bb"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a6796f6dc96ce0f8b75c75061c348a6bb">&#9670;&nbsp;</a></span>get_tree() <span class="overload">[4/4]</span></h2>
<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 id="a3ba1911b340a431982189e3e1f8c0111"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a3ba1911b340a431982189e3e1f8c0111">&#9670;&nbsp;</a></span>get_tree_surr() <span class="overload">[1/2]</span></h2>
<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 id="ab761f190afe9420e791ce6d1a3c3c719"></a>
<h2 class="memtitle"><span class="permalink"><a href="#ab761f190afe9420e791ce6d1a3c3c719">&#9670;&nbsp;</a></span>get_tree_surr() <span class="overload">[2/2]</span></h2>
<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>
<a id="aea5ca2b827a4ee552a8c0f4d4d947725"></a>
<h2 class="memtitle"><span class="permalink"><a href="#aea5ca2b827a4ee552a8c0f4d4d947725">&#9670;&nbsp;</a></span>get_var_importance() <span class="overload">[1/3]</span></h2>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">CREATE OR REPLACE FUNCTION madlib get_var_importance </td>
<td>(</td>
<td class="paramtype">model_table&#160;</td>
<td class="paramname"><em>TEXT</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">output_table&#160;</td>
<td class="paramname"><em>TEXT</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
<p>Helper function to display variable importance scores (both oob and impurity importance scores for variables). </p>
</div>
</div>
<a id="a02aabd66a900f6cd233274c7d16268ac"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a02aabd66a900f6cd233274c7d16268ac">&#9670;&nbsp;</a></span>get_var_importance() <span class="overload">[2/3]</span></h2>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">CREATE OR REPLACE FUNCTION madlib get_var_importance </td>
<td>(</td>
<td class="paramtype">message&#160;</td>
<td class="paramname"><em>TEXT</em></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a id="a8a375b28fa555fb9a24dd8177902a7d5"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a8a375b28fa555fb9a24dd8177902a7d5">&#9670;&nbsp;</a></span>get_var_importance() <span class="overload">[3/3]</span></h2>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">CREATE OR REPLACE FUNCTION madlib get_var_importance </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a id="a33a268c5561595aa0efe6508bfaf6d47"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a33a268c5561595aa0efe6508bfaf6d47">&#9670;&nbsp;</a></span>normalize_sum_array()</h2>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">float8 [] normalize_sum_array </td>
<td>(</td>
<td class="paramtype">float8 []&#160;</td>
<td class="paramname"><em>input_array</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float8&#160;</td>
<td class="paramname"><em>target_sum</em>&#160;</td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<h2 class="groupheader">Variable Documentation</h2>
<a id="a1de54bd922161dd5c6a353647f448fd6"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a1de54bd922161dd5c6a353647f448fd6">&#9670;&nbsp;</a></span>END</h2>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">END</td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a id="a8ee741e3812ad259d3ca4c9fa489dc7e"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a8ee741e3812ad259d3ca4c9fa489dc7e">&#9670;&nbsp;</a></span>IMMUTABLE</h2>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">LANGUAGE plpgsql IMMUTABLE</td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a id="a7b9a14c36355554372b1163f7b157b88"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a7b9a14c36355554372b1163f7b157b88">&#9670;&nbsp;</a></span>random_forest</h2>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">CREATE OR REPLACE FUNCTION madlib random_forest</td>
</tr>
</table>
</div><div class="memdoc">
</div>
</div>
<a id="a9cf684a2e9bdf9ed0906e11f19b80037"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a9cf684a2e9bdf9ed0906e11f19b80037">&#9670;&nbsp;</a></span>VOLATILE</h2>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">CREATE OR REPLACE FUNCTION madlib <a class="el" href="random__forest_8sql__in.html#a8a375b28fa555fb9a24dd8177902a7d5">get_var_importance</a> LANGUAGE plpythonu VOLATILE</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 Wed Mar 31 2021 20:45:46 for MADlib by
<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.13 </li>
</ul>
</div>
</body>
</html>