http://git-wip-us.apache.org/repos/asf/incubator-madlib-site/blob/b5b51c69/docs/v1.11/decision__tree_8sql__in.html ---------------------------------------------------------------------- diff --git a/docs/v1.11/decision__tree_8sql__in.html b/docs/v1.11/decision__tree_8sql__in.html new file mode 100644 index 0000000..9f23900 --- /dev/null +++ b/docs/v1.11/decision__tree_8sql__in.html @@ -0,0 +1,2697 @@ +<!-- 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: decision_tree.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> +<!-- 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.incubator.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.incubator.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.11</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.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('decision__tree_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">decision_tree.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:ad5e9443cce27ebc70d7b2c2381d17e06"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#ad5e9443cce27ebc70d7b2c2381d17e06">tree_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 split_criterion, text grouping_cols, text weights, integer max_depth, integer min_split, integer min_bucket, integer n_bins, text pruning_params, text surrogate_params, boolean verbose_mode)</td></tr> +<tr class="memdesc:ad5e9443cce27ebc70d7b2c2381d17e06"><td class="mdescLeft"> </td><td class="mdescRight">Training of decision tree. <a href="#ad5e9443cce27ebc70d7b2c2381d17e06">More...</a><br /></td></tr> +<tr class="separator:ad5e9443cce27ebc70d7b2c2381d17e06"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a9a7ef7f9b8ded8ae08ec69dd3d634539"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a9a7ef7f9b8ded8ae08ec69dd3d634539">__build_tree</a> (boolean is_classification, text split_criterion, text training_table_name, text output_table_name, text id_col_name, text dependent_variable, boolean dep_is_bool, varchar[] cat_features, varchar[] ordered_cat_features, varchar[] boolean_cats, varchar[] con_features, text grouping_cols, text weights, integer max_depth, integer min_split, integer min_bucket, integer n_bins, text cp_table, smallint max_n_surr, text msg_level, integer k)</td></tr> +<tr class="separator:a9a7ef7f9b8ded8ae08ec69dd3d634539"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a73a43da31b61ee81d5208860af2d3ab1"><td class="memItemLeft" align="right" valign="top">text </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a73a43da31b61ee81d5208860af2d3ab1">tree_train</a> (text message)</td></tr> +<tr class="separator:a73a43da31b61ee81d5208860af2d3ab1"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a530812f8c3662705e24f8bf24d4eb3a5"><td class="memItemLeft" align="right" valign="top">text </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a530812f8c3662705e24f8bf24d4eb3a5">tree_train</a> ()</td></tr> +<tr class="separator:a530812f8c3662705e24f8bf24d4eb3a5"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:ac6533f633d95f6c41a628a751b356ce1"><td class="memItemLeft" align="right" valign="top">bytea8 </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#ac6533f633d95f6c41a628a751b356ce1">_dst_compute_con_splits_transition</a> (bytea8 state, float8[] con_features, integer n_per_seg, smallint num_splits)</td></tr> +<tr class="separator:ac6533f633d95f6c41a628a751b356ce1"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a1ce0c3bc05f5f6657ce61f2890b27a33"><td class="memItemLeft" align="right" valign="top">bytea8 </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a1ce0c3bc05f5f6657ce61f2890b27a33">_dst_compute_con_splits_final</a> (bytea8 state)</td></tr> +<tr class="separator:a1ce0c3bc05f5f6657ce61f2890b27a33"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:aaabc1efd8cc211886572692062f74732"><td class="memItemLeft" align="right" valign="top">aggregate bytea8 </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#aaabc1efd8cc211886572692062f74732">_dst_compute_con_splits</a> (float8[], integer, smallint)</td></tr> +<tr class="separator:aaabc1efd8cc211886572692062f74732"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a88589c4a865221cd97af52284e222195"><td class="memItemLeft" align="right" valign="top">integer [] </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a88589c4a865221cd97af52284e222195">_dst_compute_entropy_transition</a> (integer[] state, integer encoded_dep_var, integer num_dep_var)</td></tr> +<tr class="separator:a88589c4a865221cd97af52284e222195"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a992c692244ec9f1dd38557bc8cf5c2ef"><td class="memItemLeft" align="right" valign="top">integer [] </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a992c692244ec9f1dd38557bc8cf5c2ef">_dst_compute_entropy_merge</a> (integer[] state1, integer[] state2)</td></tr> +<tr class="separator:a992c692244ec9f1dd38557bc8cf5c2ef"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:ac81d2cf47356702c5bc30790f505c05f"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#ac81d2cf47356702c5bc30790f505c05f">_dst_compute_entropy_final</a> (integer[] state)</td></tr> +<tr class="separator:ac81d2cf47356702c5bc30790f505c05f"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a71e8f6ae4227a3cd3734d8c8f7ef54fe"><td class="memItemLeft" align="right" valign="top">aggregate float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a71e8f6ae4227a3cd3734d8c8f7ef54fe">_dst_compute_entropy</a> (integer, integer)</td></tr> +<tr class="separator:a71e8f6ae4227a3cd3734d8c8f7ef54fe"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a247bb7f7065a506279627028b49af5e9"><td class="memItemLeft" align="right" valign="top">integer [] </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a247bb7f7065a506279627028b49af5e9">_map_catlevel_to_int</a> (text[] cat_values_in_text, text[] cat_levels_in_text, integer[] cat_n_levels)</td></tr> +<tr class="separator:a247bb7f7065a506279627028b49af5e9"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:ad63f7b9a78190275509744f9517dd370"><td class="memItemLeft" align="right" valign="top">bytea8 </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#ad63f7b9a78190275509744f9517dd370">_initialize_decision_tree</a> (boolean is_regression_tree, text impurity_function, smallint num_response_labels, smallint max_n_surr)</td></tr> +<tr class="separator:ad63f7b9a78190275509744f9517dd370"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:aadad9dcc5dd62e335305e99dc1a1b68e"><td class="memItemLeft" align="right" valign="top">bytea8 </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#aadad9dcc5dd62e335305e99dc1a1b68e">_compute_leaf_stats_transition</a> (bytea8 state, bytea8 tree_state, integer[] cat_features, float8[] con_features, float8 response, float8 weight, integer[] cat_levels, bytea8 con_splits, smallint n_response_labels, boolean weights_as_rows)</td></tr> +<tr class="separator:aadad9dcc5dd62e335305e99dc1a1b68e"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:aec006330e98f6c322f30c05cb07518c0"><td class="memItemLeft" align="right" valign="top">bytea8 </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#aec006330e98f6c322f30c05cb07518c0">_compute_leaf_stats_merge</a> (bytea8 state1, bytea8 state2)</td></tr> +<tr class="separator:aec006330e98f6c322f30c05cb07518c0"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a93896cc01cd324ff6dec20d3791b8500"><td class="memItemLeft" align="right" valign="top">aggregate bytea8 </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a93896cc01cd324ff6dec20d3791b8500">_compute_leaf_stats</a> (bytea8, integer[], float8[], float8, float8, integer[], bytea8, smallint, boolean)</td></tr> +<tr class="separator:a93896cc01cd324ff6dec20d3791b8500"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a164580846362686fe4ab55db7c4fa52a"><td class="memItemLeft" align="right" valign="top">_tree_result_type </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a164580846362686fe4ab55db7c4fa52a">_dt_apply</a> (bytea8 tree, bytea8 state, bytea8 con_splits, smallint min_split, smallint min_bucket, smallint max_depth, boolean subsample, integer num_random_features)</td></tr> +<tr class="separator:a164580846362686fe4ab55db7c4fa52a"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:af17fb0c819380de1c090731dba54ec40"><td class="memItemLeft" align="right" valign="top">bytea8 </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#af17fb0c819380de1c090731dba54ec40">_compute_surr_stats_transition</a> (bytea8 state, bytea8 tree_state, integer[] cat_features, float8[] con_features, integer[] cat_levels, bytea8 con_splits, integer dup_count)</td></tr> +<tr class="separator:af17fb0c819380de1c090731dba54ec40"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a52020e1216a5ca6b255aa9fefa5ed0f1"><td class="memItemLeft" align="right" valign="top">aggregate bytea8 </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a52020e1216a5ca6b255aa9fefa5ed0f1">_compute_surr_stats</a> (bytea8, integer[], float8[], integer[], bytea8, integer)</td></tr> +<tr class="separator:a52020e1216a5ca6b255aa9fefa5ed0f1"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a05665f86bc28346cdf12e4b4d05aa3d9"><td class="memItemLeft" align="right" valign="top">bytea8 </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a05665f86bc28346cdf12e4b4d05aa3d9">_dt_surr_apply</a> (bytea8 tree, bytea8 state, bytea8 con_splits)</td></tr> +<tr class="separator:a05665f86bc28346cdf12e4b4d05aa3d9"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a32e1056ceed38cc5da2e022e455b7de6"><td class="memItemLeft" align="right" valign="top">_flattened_tree </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a32e1056ceed38cc5da2e022e455b7de6">_print_decision_tree</a> (bytea8 tree)</td></tr> +<tr class="separator:a32e1056ceed38cc5da2e022e455b7de6"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a59b5f555e1f8d7c57830c9cfe3401615"><td class="memItemLeft" align="right" valign="top">float8 </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a59b5f555e1f8d7c57830c9cfe3401615">_predict_dt_response</a> (bytea8 tree, integer[] cat_features, float8[] con_features)</td></tr> +<tr class="separator:a59b5f555e1f8d7c57830c9cfe3401615"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a25ef01785744c7cf005e6b517602b497"><td class="memItemLeft" align="right" valign="top">float8 [] </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a25ef01785744c7cf005e6b517602b497">_predict_dt_prob</a> (bytea8 tree, integer[] cat_features, float8[] con_features)</td></tr> +<tr class="separator:a25ef01785744c7cf005e6b517602b497"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:ae371963e135c40d8be5b2e342ab3c252"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#ae371963e135c40d8be5b2e342ab3c252">tree_predict</a> (text model, text source, text output, text pred_type)</td></tr> +<tr class="memdesc:ae371963e135c40d8be5b2e342ab3c252"><td class="mdescLeft"> </td><td class="mdescRight">Use decision tree model to make predictions. <a href="#ae371963e135c40d8be5b2e342ab3c252">More...</a><br /></td></tr> +<tr class="separator:ae371963e135c40d8be5b2e342ab3c252"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a71a536f94609625aabceaaa8a9030ac6"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a71a536f94609625aabceaaa8a9030ac6">__tree_predict</a> (text model, text source, text output, text pred_type, boolean use_existing_tables, integer k)</td></tr> +<tr class="separator:a71a536f94609625aabceaaa8a9030ac6"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:ad8afbe21c3b73daff7322c3fe906a804"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#ad8afbe21c3b73daff7322c3fe906a804">tree_predict</a> (text model, text source, text output)</td></tr> +<tr class="separator:ad8afbe21c3b73daff7322c3fe906a804"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:abb6f3ecdd2fdcb7661ee10a65419066e"><td class="memItemLeft" align="right" valign="top">text </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#abb6f3ecdd2fdcb7661ee10a65419066e">tree_predict</a> (text message)</td></tr> +<tr class="separator:abb6f3ecdd2fdcb7661ee10a65419066e"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a744d4c5564a3ba18c9774fa040f32d18"><td class="memItemLeft" align="right" valign="top">text </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a744d4c5564a3ba18c9774fa040f32d18">tree_predict</a> ()</td></tr> +<tr class="separator:a744d4c5564a3ba18c9774fa040f32d18"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a6ba706727adf88f8c07cfe09f71732bb"><td class="memItemLeft" align="right" valign="top">varchar </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a6ba706727adf88f8c07cfe09f71732bb">tree_surr_display</a> (text model_table)</td></tr> +<tr class="memdesc:a6ba706727adf88f8c07cfe09f71732bb"><td class="mdescLeft"> </td><td class="mdescRight">Display decision tree in dot or text format. <a href="#a6ba706727adf88f8c07cfe09f71732bb">More...</a><br /></td></tr> +<tr class="separator:a6ba706727adf88f8c07cfe09f71732bb"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a97c730e746e1a8ea658efe433c9d1be5"><td class="memItemLeft" align="right" valign="top">varchar </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a97c730e746e1a8ea658efe433c9d1be5">tree_surr_display</a> ()</td></tr> +<tr class="separator:a97c730e746e1a8ea658efe433c9d1be5"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:ae3e4875107103a092d3ef560b1812ee5"><td class="memItemLeft" align="right" valign="top">varchar </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#ae3e4875107103a092d3ef560b1812ee5">tree_display</a> (text model_table, boolean dot_format, boolean verbose)</td></tr> +<tr class="memdesc:ae3e4875107103a092d3ef560b1812ee5"><td class="mdescLeft"> </td><td class="mdescRight">Display decision tree in dot or text format. <a href="#ae3e4875107103a092d3ef560b1812ee5">More...</a><br /></td></tr> +<tr class="separator:ae3e4875107103a092d3ef560b1812ee5"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a3c51edcc0fe3de029dc39a3f0306155d"><td class="memItemLeft" align="right" valign="top">varchar </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a3c51edcc0fe3de029dc39a3f0306155d">tree_display</a> (text model_table, boolean dot_format)</td></tr> +<tr class="separator:a3c51edcc0fe3de029dc39a3f0306155d"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a5168f7f604b0ad1c9e581f0e3f52698e"><td class="memItemLeft" align="right" valign="top">varchar </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a5168f7f604b0ad1c9e581f0e3f52698e">tree_display</a> (text model_table)</td></tr> +<tr class="separator:a5168f7f604b0ad1c9e581f0e3f52698e"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:adc9d02213b4d906976805a9681ea13fb"><td class="memItemLeft" align="right" valign="top">varchar </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#adc9d02213b4d906976805a9681ea13fb">tree_display</a> ()</td></tr> +<tr class="separator:adc9d02213b4d906976805a9681ea13fb"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a77f0212dd3776488cf73080eeb4e851c"><td class="memItemLeft" align="right" valign="top">text </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a77f0212dd3776488cf73080eeb4e851c">_display_decision_tree</a> (bytea8 tree, text[] cat_features, text[] con_features, text[] cat_levels_in_text, integer[] cat_n_levels, text[] dependent_levels, text id_prefix, boolean verbose)</td></tr> +<tr class="separator:a77f0212dd3776488cf73080eeb4e851c"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a0dd7cec9ec3db8482ae60a3f274c3488"><td class="memItemLeft" align="right" valign="top">text </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a0dd7cec9ec3db8482ae60a3f274c3488">_display_decision_tree</a> (bytea8 tree, text[] cat_features, text[] con_features, text[] cat_levels_in_text, integer[] cat_n_levels, text[] dependent_levels, text id_prefix)</td></tr> +<tr class="separator:a0dd7cec9ec3db8482ae60a3f274c3488"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a071ad5dd0cf985d9e5258968fa8c214d"><td class="memItemLeft" align="right" valign="top">text </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a071ad5dd0cf985d9e5258968fa8c214d">_display_decision_tree_surrogate</a> (bytea8 tree, text[] cat_features, text[] con_features, text[] cat_levels_in_text, integer[] cat_n_levels)</td></tr> +<tr class="separator:a071ad5dd0cf985d9e5258968fa8c214d"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:af030ab954fd282bb08e13134e087fafb"><td class="memItemLeft" align="right" valign="top">text </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#af030ab954fd282bb08e13134e087fafb">_display_text_decision_tree</a> (bytea8 tree, text[] cat_features, text[] con_features, text[] cat_levels_in_text, integer[] cat_n_levels, text[] dependent_levels)</td></tr> +<tr class="separator:af030ab954fd282bb08e13134e087fafb"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a658412807f7b28e9e367a1421cb8ad96"><td class="memItemLeft" align="right" valign="top">set< _cat_levels_type > </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a658412807f7b28e9e367a1421cb8ad96">_gen_cat_levels_set</a> (text[] grp_keys, integer[] cat_n_levels, integer n_cat, text[] cat_sorted_origin)</td></tr> +<tr class="separator:a658412807f7b28e9e367a1421cb8ad96"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a29db1b54ffa60f40bb533c1229332789"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a29db1b54ffa60f40bb533c1229332789">tree_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 split_criterion, text grouping_cols, text weights, integer max_depth, integer min_split, integer min_bucket, integer n_bins, text pruning_params, text surrogate_params)</td></tr> +<tr class="separator:a29db1b54ffa60f40bb533c1229332789"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:ab561b3e2a8a66b6ec763d44ea042aeca"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#ab561b3e2a8a66b6ec763d44ea042aeca">tree_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 split_criterion, text grouping_cols, text weights, integer max_depth, integer min_split, integer min_bucket, integer n_bins, text pruning_params)</td></tr> +<tr class="separator:ab561b3e2a8a66b6ec763d44ea042aeca"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:add62455af9b9f9a075df8221269a4872"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#add62455af9b9f9a075df8221269a4872">tree_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 split_criterion, text grouping_cols, text weights, integer max_depth, integer min_split, integer min_bucket, integer n_bins)</td></tr> +<tr class="separator:add62455af9b9f9a075df8221269a4872"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a635b82bc9c1fcd63e5a46546d3e2ba70"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a635b82bc9c1fcd63e5a46546d3e2ba70">tree_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 split_criterion, text grouping_cols, text weights, integer max_depth, integer min_split, integer min_bucket)</td></tr> +<tr class="separator:a635b82bc9c1fcd63e5a46546d3e2ba70"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a93591ca5193e5ac9f8c3ac52e1dfb1ba"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a93591ca5193e5ac9f8c3ac52e1dfb1ba">tree_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 split_criterion, text grouping_cols, text weights, integer max_depth, integer min_split)</td></tr> +<tr class="separator:a93591ca5193e5ac9f8c3ac52e1dfb1ba"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a558361a337c93731b856523e20f20e72"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a558361a337c93731b856523e20f20e72">tree_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 split_criterion, text grouping_cols, text weights, integer max_depth)</td></tr> +<tr class="separator:a558361a337c93731b856523e20f20e72"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a10b882e4d6417023ae6b92f79e88ac29"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a10b882e4d6417023ae6b92f79e88ac29">tree_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 split_criterion, text grouping_cols, text weights)</td></tr> +<tr class="separator:a10b882e4d6417023ae6b92f79e88ac29"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:ac49c038b5668aeb901d22a5a81c8f338"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#ac49c038b5668aeb901d22a5a81c8f338">tree_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 split_criterion, text grouping_cols)</td></tr> +<tr class="separator:ac49c038b5668aeb901d22a5a81c8f338"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a9cfac8d89b1a13d22a20eb79d4d7e7ce"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a9cfac8d89b1a13d22a20eb79d4d7e7ce">tree_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 split_criterion)</td></tr> +<tr class="separator:a9cfac8d89b1a13d22a20eb79d4d7e7ce"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:af70d0b6bba29f94ebd49acc48b4f9bb1"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#af70d0b6bba29f94ebd49acc48b4f9bb1">tree_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:af70d0b6bba29f94ebd49acc48b4f9bb1"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a639431da2553fb86673e82d62cde4458"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="decision__tree_8sql__in.html#a639431da2553fb86673e82d62cde4458">tree_train</a> (text training_table_name, text output_table_name, text id_col_name, text dependent_variable, text list_of_features)</td></tr> +<tr class="separator:a639431da2553fb86673e82d62cde4458"><td class="memSeparator" colspan="2"> </td></tr> +</table> +<h2 class="groupheader">Function Documentation</h2> +<a id="a9a7ef7f9b8ded8ae08ec69dd3d634539"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a9a7ef7f9b8ded8ae08ec69dd3d634539">◆ </a></span>__build_tree()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">void __build_tree </td> + <td>(</td> + <td class="paramtype">boolean </td> + <td class="paramname"><em>is_classification</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>split_criterion</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>training_table_name</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>output_table_name</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>id_col_name</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>dependent_variable</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">boolean </td> + <td class="paramname"><em>dep_is_bool</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">varchar [] </td> + <td class="paramname"><em>cat_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">varchar [] </td> + <td class="paramname"><em>ordered_cat_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">varchar [] </td> + <td class="paramname"><em>boolean_cats</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">varchar [] </td> + <td class="paramname"><em>con_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>grouping_cols</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>weights</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname"><em>max_depth</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname"><em>min_split</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname"><em>min_bucket</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname"><em>n_bins</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>cp_table</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">smallint </td> + <td class="paramname"><em>max_n_surr</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>msg_level</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname"><em>k</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a71a536f94609625aabceaaa8a9030ac6"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a71a536f94609625aabceaaa8a9030ac6">◆ </a></span>__tree_predict()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">void __tree_predict </td> + <td>(</td> + <td class="paramtype">text </td> + <td class="paramname"><em>model</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>source</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>output</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>pred_type</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">boolean </td> + <td class="paramname"><em>use_existing_tables</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname"><em>k</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a93896cc01cd324ff6dec20d3791b8500"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a93896cc01cd324ff6dec20d3791b8500">◆ </a></span>_compute_leaf_stats()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">aggregate bytea8 _compute_leaf_stats </td> + <td>(</td> + <td class="paramtype">bytea8 </td> + <td class="paramname">, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname">[], </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">float8 </td> + <td class="paramname">[], </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">float8 </td> + <td class="paramname">, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">float8 </td> + <td class="paramname">, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname">[], </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">bytea8 </td> + <td class="paramname">, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">smallint </td> + <td class="paramname">, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">boolean </td> + <td class="paramname"> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="aec006330e98f6c322f30c05cb07518c0"></a> +<h2 class="memtitle"><span class="permalink"><a href="#aec006330e98f6c322f30c05cb07518c0">◆ </a></span>_compute_leaf_stats_merge()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">bytea8 _compute_leaf_stats_merge </td> + <td>(</td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>state1</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>state2</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="aadad9dcc5dd62e335305e99dc1a1b68e"></a> +<h2 class="memtitle"><span class="permalink"><a href="#aadad9dcc5dd62e335305e99dc1a1b68e">◆ </a></span>_compute_leaf_stats_transition()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">bytea8 _compute_leaf_stats_transition </td> + <td>(</td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>state</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>tree_state</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer [] </td> + <td class="paramname"><em>cat_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">float8 [] </td> + <td class="paramname"><em>con_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">float8 </td> + <td class="paramname"><em>response</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">float8 </td> + <td class="paramname"><em>weight</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer [] </td> + <td class="paramname"><em>cat_levels</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>con_splits</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">smallint </td> + <td class="paramname"><em>n_response_labels</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">boolean </td> + <td class="paramname"><em>weights_as_rows</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a52020e1216a5ca6b255aa9fefa5ed0f1"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a52020e1216a5ca6b255aa9fefa5ed0f1">◆ </a></span>_compute_surr_stats()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">aggregate bytea8 _compute_surr_stats </td> + <td>(</td> + <td class="paramtype">bytea8 </td> + <td class="paramname">, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname">[], </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">float8 </td> + <td class="paramname">[], </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname">[], </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">bytea8 </td> + <td class="paramname">, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname"> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="af17fb0c819380de1c090731dba54ec40"></a> +<h2 class="memtitle"><span class="permalink"><a href="#af17fb0c819380de1c090731dba54ec40">◆ </a></span>_compute_surr_stats_transition()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">bytea8 _compute_surr_stats_transition </td> + <td>(</td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>state</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>tree_state</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer [] </td> + <td class="paramname"><em>cat_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">float8 [] </td> + <td class="paramname"><em>con_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer [] </td> + <td class="paramname"><em>cat_levels</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>con_splits</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname"><em>dup_count</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a77f0212dd3776488cf73080eeb4e851c"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a77f0212dd3776488cf73080eeb4e851c">◆ </a></span>_display_decision_tree() <span class="overload">[1/2]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">text _display_decision_tree </td> + <td>(</td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>tree</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text [] </td> + <td class="paramname"><em>cat_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text [] </td> + <td class="paramname"><em>con_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text [] </td> + <td class="paramname"><em>cat_levels_in_text</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer [] </td> + <td class="paramname"><em>cat_n_levels</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text [] </td> + <td class="paramname"><em>dependent_levels</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>id_prefix</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">boolean </td> + <td class="paramname"><em>verbose</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a0dd7cec9ec3db8482ae60a3f274c3488"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a0dd7cec9ec3db8482ae60a3f274c3488">◆ </a></span>_display_decision_tree() <span class="overload">[2/2]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">text _display_decision_tree </td> + <td>(</td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>tree</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text [] </td> + <td class="paramname"><em>cat_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text [] </td> + <td class="paramname"><em>con_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text [] </td> + <td class="paramname"><em>cat_levels_in_text</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer [] </td> + <td class="paramname"><em>cat_n_levels</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text [] </td> + <td class="paramname"><em>dependent_levels</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>id_prefix</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a071ad5dd0cf985d9e5258968fa8c214d"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a071ad5dd0cf985d9e5258968fa8c214d">◆ </a></span>_display_decision_tree_surrogate()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">text _display_decision_tree_surrogate </td> + <td>(</td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>tree</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text [] </td> + <td class="paramname"><em>cat_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text [] </td> + <td class="paramname"><em>con_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text [] </td> + <td class="paramname"><em>cat_levels_in_text</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer [] </td> + <td class="paramname"><em>cat_n_levels</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="af030ab954fd282bb08e13134e087fafb"></a> +<h2 class="memtitle"><span class="permalink"><a href="#af030ab954fd282bb08e13134e087fafb">◆ </a></span>_display_text_decision_tree()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">text _display_text_decision_tree </td> + <td>(</td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>tree</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text [] </td> + <td class="paramname"><em>cat_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text [] </td> + <td class="paramname"><em>con_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text [] </td> + <td class="paramname"><em>cat_levels_in_text</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer [] </td> + <td class="paramname"><em>cat_n_levels</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text [] </td> + <td class="paramname"><em>dependent_levels</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="aaabc1efd8cc211886572692062f74732"></a> +<h2 class="memtitle"><span class="permalink"><a href="#aaabc1efd8cc211886572692062f74732">◆ </a></span>_dst_compute_con_splits()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">aggregate bytea8 _dst_compute_con_splits </td> + <td>(</td> + <td class="paramtype">float8 </td> + <td class="paramname">[], </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname">, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">smallint </td> + <td class="paramname"> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a1ce0c3bc05f5f6657ce61f2890b27a33"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a1ce0c3bc05f5f6657ce61f2890b27a33">◆ </a></span>_dst_compute_con_splits_final()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">bytea8 _dst_compute_con_splits_final </td> + <td>(</td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>state</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="ac6533f633d95f6c41a628a751b356ce1"></a> +<h2 class="memtitle"><span class="permalink"><a href="#ac6533f633d95f6c41a628a751b356ce1">◆ </a></span>_dst_compute_con_splits_transition()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">bytea8 _dst_compute_con_splits_transition </td> + <td>(</td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>state</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">float8 [] </td> + <td class="paramname"><em>con_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname"><em>n_per_seg</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">smallint </td> + <td class="paramname"><em>num_splits</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a71e8f6ae4227a3cd3734d8c8f7ef54fe"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a71e8f6ae4227a3cd3734d8c8f7ef54fe">◆ </a></span>_dst_compute_entropy()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">aggregate float8 _dst_compute_entropy </td> + <td>(</td> + <td class="paramtype">integer </td> + <td class="paramname">, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname"> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="ac81d2cf47356702c5bc30790f505c05f"></a> +<h2 class="memtitle"><span class="permalink"><a href="#ac81d2cf47356702c5bc30790f505c05f">◆ </a></span>_dst_compute_entropy_final()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">float8 _dst_compute_entropy_final </td> + <td>(</td> + <td class="paramtype">integer [] </td> + <td class="paramname"><em>state</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a992c692244ec9f1dd38557bc8cf5c2ef"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a992c692244ec9f1dd38557bc8cf5c2ef">◆ </a></span>_dst_compute_entropy_merge()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">integer [] _dst_compute_entropy_merge </td> + <td>(</td> + <td class="paramtype">integer [] </td> + <td class="paramname"><em>state1</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer [] </td> + <td class="paramname"><em>state2</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a88589c4a865221cd97af52284e222195"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a88589c4a865221cd97af52284e222195">◆ </a></span>_dst_compute_entropy_transition()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">integer [] _dst_compute_entropy_transition </td> + <td>(</td> + <td class="paramtype">integer [] </td> + <td class="paramname"><em>state</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname"><em>encoded_dep_var</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname"><em>num_dep_var</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a164580846362686fe4ab55db7c4fa52a"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a164580846362686fe4ab55db7c4fa52a">◆ </a></span>_dt_apply()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">_tree_result_type _dt_apply </td> + <td>(</td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>tree</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>state</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>con_splits</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">smallint </td> + <td class="paramname"><em>min_split</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">smallint </td> + <td class="paramname"><em>min_bucket</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">smallint </td> + <td class="paramname"><em>max_depth</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">boolean </td> + <td class="paramname"><em>subsample</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname"><em>num_random_features</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a05665f86bc28346cdf12e4b4d05aa3d9"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a05665f86bc28346cdf12e4b4d05aa3d9">◆ </a></span>_dt_surr_apply()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">bytea8 _dt_surr_apply </td> + <td>(</td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>tree</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>state</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>con_splits</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a658412807f7b28e9e367a1421cb8ad96"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a658412807f7b28e9e367a1421cb8ad96">◆ </a></span>_gen_cat_levels_set()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">set<_cat_levels_type> _gen_cat_levels_set </td> + <td>(</td> + <td class="paramtype">text [] </td> + <td class="paramname"><em>grp_keys</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer [] </td> + <td class="paramname"><em>cat_n_levels</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname"><em>n_cat</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text [] </td> + <td class="paramname"><em>cat_sorted_origin</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="ad63f7b9a78190275509744f9517dd370"></a> +<h2 class="memtitle"><span class="permalink"><a href="#ad63f7b9a78190275509744f9517dd370">◆ </a></span>_initialize_decision_tree()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">bytea8 _initialize_decision_tree </td> + <td>(</td> + <td class="paramtype">boolean </td> + <td class="paramname"><em>is_regression_tree</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>impurity_function</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">smallint </td> + <td class="paramname"><em>num_response_labels</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">smallint </td> + <td class="paramname"><em>max_n_surr</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a247bb7f7065a506279627028b49af5e9"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a247bb7f7065a506279627028b49af5e9">◆ </a></span>_map_catlevel_to_int()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">integer [] _map_catlevel_to_int </td> + <td>(</td> + <td class="paramtype">text [] </td> + <td class="paramname"><em>cat_values_in_text</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text [] </td> + <td class="paramname"><em>cat_levels_in_text</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer [] </td> + <td class="paramname"><em>cat_n_levels</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a25ef01785744c7cf005e6b517602b497"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a25ef01785744c7cf005e6b517602b497">◆ </a></span>_predict_dt_prob()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">float8 [] _predict_dt_prob </td> + <td>(</td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>tree</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer [] </td> + <td class="paramname"><em>cat_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">float8 [] </td> + <td class="paramname"><em>con_features</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a59b5f555e1f8d7c57830c9cfe3401615"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a59b5f555e1f8d7c57830c9cfe3401615">◆ </a></span>_predict_dt_response()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">float8 _predict_dt_response </td> + <td>(</td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>tree</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer [] </td> + <td class="paramname"><em>cat_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">float8 [] </td> + <td class="paramname"><em>con_features</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a32e1056ceed38cc5da2e022e455b7de6"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a32e1056ceed38cc5da2e022e455b7de6">◆ </a></span>_print_decision_tree()</h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">_flattened_tree _print_decision_tree </td> + <td>(</td> + <td class="paramtype">bytea8 </td> + <td class="paramname"><em>tree</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="ae3e4875107103a092d3ef560b1812ee5"></a> +<h2 class="memtitle"><span class="permalink"><a href="#ae3e4875107103a092d3ef560b1812ee5">◆ </a></span>tree_display() <span class="overload">[1/4]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">varchar tree_display </td> + <td>(</td> + <td class="paramtype">text </td> + <td class="paramname"><em>model_table</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">boolean </td> + <td class="paramname"><em>dot_format</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">boolean </td> + <td class="paramname"><em>verbose</em> </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">tree_model</td><td>Name of the table containing the decision tree model </td></tr> + </table> + </dd> +</dl> + +</div> +</div> +<a id="a3c51edcc0fe3de029dc39a3f0306155d"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a3c51edcc0fe3de029dc39a3f0306155d">◆ </a></span>tree_display() <span class="overload">[2/4]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">varchar tree_display </td> + <td>(</td> + <td class="paramtype">text </td> + <td class="paramname"><em>model_table</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">boolean </td> + <td class="paramname"><em>dot_format</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a5168f7f604b0ad1c9e581f0e3f52698e"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a5168f7f604b0ad1c9e581f0e3f52698e">◆ </a></span>tree_display() <span class="overload">[3/4]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">varchar tree_display </td> + <td>(</td> + <td class="paramtype">text </td> + <td class="paramname"><em>model_table</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="adc9d02213b4d906976805a9681ea13fb"></a> +<h2 class="memtitle"><span class="permalink"><a href="#adc9d02213b4d906976805a9681ea13fb">◆ </a></span>tree_display() <span class="overload">[4/4]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">varchar tree_display </td> + <td>(</td> + <td class="paramname"></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="ae371963e135c40d8be5b2e342ab3c252"></a> +<h2 class="memtitle"><span class="permalink"><a href="#ae371963e135c40d8be5b2e342ab3c252">◆ </a></span>tree_predict() <span class="overload">[1/4]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">void tree_predict </td> + <td>(</td> + <td class="paramtype">text </td> + <td class="paramname"><em>model</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>source</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>output</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>pred_type</em> </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 decision tree 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 trees, 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__decision__tree.html">Decision Tree</a> for more details. </p> + +</div> +</div> +<a id="ad8afbe21c3b73daff7322c3fe906a804"></a> +<h2 class="memtitle"><span class="permalink"><a href="#ad8afbe21c3b73daff7322c3fe906a804">◆ </a></span>tree_predict() <span class="overload">[2/4]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">void tree_predict </td> + <td>(</td> + <td class="paramtype">text </td> + <td class="paramname"><em>model</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>source</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>output</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="abb6f3ecdd2fdcb7661ee10a65419066e"></a> +<h2 class="memtitle"><span class="permalink"><a href="#abb6f3ecdd2fdcb7661ee10a65419066e">◆ </a></span>tree_predict() <span class="overload">[3/4]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">text tree_predict </td> + <td>(</td> + <td class="paramtype">text </td> + <td class="paramname"><em>message</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a744d4c5564a3ba18c9774fa040f32d18"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a744d4c5564a3ba18c9774fa040f32d18">◆ </a></span>tree_predict() <span class="overload">[4/4]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">text tree_predict </td> + <td>(</td> + <td class="paramname"></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a6ba706727adf88f8c07cfe09f71732bb"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a6ba706727adf88f8c07cfe09f71732bb">◆ </a></span>tree_surr_display() <span class="overload">[1/2]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">varchar tree_surr_display </td> + <td>(</td> + <td class="paramtype">text </td> + <td class="paramname"><em>model_table</em></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">tree_model</td><td>Name of the table containing the decision tree model </td></tr> + </table> + </dd> +</dl> + +</div> +</div> +<a id="a97c730e746e1a8ea658efe433c9d1be5"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a97c730e746e1a8ea658efe433c9d1be5">◆ </a></span>tree_surr_display() <span class="overload">[2/2]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">varchar tree_surr_display </td> + <td>(</td> + <td class="paramname"></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="ad5e9443cce27ebc70d7b2c2381d17e06"></a> +<h2 class="memtitle"><span class="permalink"><a href="#ad5e9443cce27ebc70d7b2c2381d17e06">◆ </a></span>tree_train() <span class="overload">[1/14]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">void tree_train </td> + <td>(</td> + <td class="paramtype">text </td> + <td class="paramname"><em>training_table_name</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>output_table_name</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>id_col_name</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>dependent_variable</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>list_of_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>list_of_features_to_exclude</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>split_criterion</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>grouping_cols</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>weights</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname"><em>max_depth</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname"><em>min_split</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname"><em>min_bucket</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">integer </td> + <td class="paramname"><em>n_bins</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>pruning_params</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>surrogate_params</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">boolean </td> + <td class="paramname"><em>verbose_mode</em> </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">split_criterion</td><td>Various options to compute the feature to split a node. Available options are 'gini', 'cross-entropy', and 'misclassification'. The "cart" algorithm provides an additional option of 'mse'. </td></tr> + <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 decision trees, one for each group. </td></tr> + <tr><td class="paramname">weights</td><td>OPTIONAL. Column name containing weights for each observation. </td></tr> + <tr><td class="paramname">max_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. A deeper tree can lead to better prediction but will also result in longer processing time and higher memory usage. </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">n_bins</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 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">pruning_params</td><td>(default: cp=0) pruning parameter string containing key-value pairs. the keys can be: cp (default = 0.01) a complexity parameter that determines that a split is attempted only if it decreases the overall lack of fit by a factor of âcpâ. n_folds (default = 0) number of cross-validation folds </td></tr> + <tr><td class="paramname">verbose_mode</td><td>optional (default = false) prints status information on the splits performed and any other information useful for debugging.</td></tr> + </table> + </dd> +</dl> +<p>see <a class="el" href="group__grp__decision__tree.html">Decision Tree</a> for more details. </p> + +</div> +</div> +<a id="a73a43da31b61ee81d5208860af2d3ab1"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a73a43da31b61ee81d5208860af2d3ab1">◆ </a></span>tree_train() <span class="overload">[2/14]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">text tree_train </td> + <td>(</td> + <td class="paramtype">text </td> + <td class="paramname"><em>message</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a530812f8c3662705e24f8bf24d4eb3a5"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a530812f8c3662705e24f8bf24d4eb3a5">◆ </a></span>tree_train() <span class="overload">[3/14]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">text tree_train </td> + <td>(</td> + <td class="paramname"></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> + +</div> +</div> +<a id="a29db1b54ffa60f40bb533c1229332789"></a> +<h2 class="memtitle"><span class="permalink"><a href="#a29db1b54ffa60f40bb533c1229332789">◆ </a></span>tree_train() <span class="overload">[4/14]</span></h2> + +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">void tree_train </td> + <td>(</td> + <td class="paramtype">text </td> + <td class="paramname"><em>training_table_name</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>output_table_name</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>id_col_name</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>dependent_variable</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>list_of_features</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>list_of_features_to_exclude</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramname"><em>split_criterion</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">text </td> + <td class="paramnam
<TRUNCATED>
