{"title":"Binner","nodeType":"Manipulator","id":"*f6JNvzVp3pcflXaI","factoryName":"org.knime.base.node.preproc.binner2.BinnerNodeFactory","factoryId":"org.knime.base.node.preproc.binner2.BinnerNodeFactory","path":["Manipulation","Column","Binning"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Groups numeric columns into discrete intervals, known as bins. This node supports both automatic and manual binning methods, including equal-width, equal-frequency, custom cutoffs, and quantile-based binning. Each bin is assigned a label based on its position, boundary values, or midpoint. The resulting binned values are output as string-type columns, either replacing the original data or appended alongside it.</p>\n        ","shortDescription":"Groups numeric values into labeled bins using automatic or custom-defined intervals.","keywords":["Auto Binner","Numeric Binner"],"deprecated":false,"streamable":true,"tags":["Manipulation","Column","Binning","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAIAAACQkWg2AAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3hpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6M0EwQTJCQTIxODM1MTFFNTgxM0FFMEQwQTc0Qzg5QTIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6MzIyRjE1MTQxODM1MTFFNTgxM0FFMEQwQTc0Qzg5QTIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpjZTBmYzg4ZC1kNjkyLTQ5NDEtOTZiOC03ODIxMjliYWZkYWIiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6MGIzNmFjOTctNWViYS00MGU3LTkxODktYmJlOGQ3ZDBmMjRlIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+laojDgAAAHdJREFUeNpilBKXZoCBZy+fwtkQcaAIsgKoxH8kABTBwwUqZmIgEZCsgeXfv3+MjIwQDsQNBGwgRhFlTmJiItkSBEDTCQ9WFEXiIhIENfDz80NERIXFSNMAApJiUsTHNFl+IEYDipPI1wD0PSQlAxnIIYEGAAIMAMgBk0hFlQMTAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input Data","description":"Data to be categorized"}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Binned Data","description":"Data with bins defined"},{"objectClass":"org.knime.core.node.port.pmml.PMMLPortObject","color":"1469af","dataType":"PMML","optional":false,"name":"PMML Processing Fragment","description":"The PMML Model fragment containing information how to bin"}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Columns to bin","description":"Select the numeric columns to apply binning to. Only the selected columns will be transformed.","optional":false},{"name":"Binning type","description":"Select the method used to define bin intervals.\n<ul><li><b>Equal width</b> : Creates bins of equal size across the value range. Requires a specified number of bins.</li><li><b>Equal frequency</b> : Creates bins with approximately the same number of values. Requires a specified number of bins.</li><li><b>Custom cutoffs</b> : Manually define bin edges using a list of cutoff values. At least two cutoffs are required.</li><li><b>Custom quantiles</b> : Define bin edges based on quantile values. At least two quantiles are required. Quantiles are converted to bin edges using the R-7 algorithm, see <a href=\"https://en.wikipedia.org/wiki/Quantile\" rel=\"ugc nofollow noopener noreferrer\">WP:Quantile</a> for more details. Note that when setting upper or lower bounds quantiles are calculated only on values within those bounds.</li></ul>","optional":false},{"name":"Number of bins","description":"Specifies the number of bins to create. Used with Equal width and Equal frequency binning.","optional":false},{"name":"Custom cutoffs","description":"Specifies the exact value at which the bin boundary should be placed.\n<ul><li><b>Cutoff</b> : Specifies the exact value at which the bin boundary should be placed.</li><li><b>Exact match</b> : Defines how to assign values that match a cutoff exactly.\n  <ul><li><b>To lower bin</b> : Assign to the bin below the cutoff.</li><li><b>To upper bin</b> : Assign to the bin above the cutoff.</li></ul></li></ul>","optional":false},{"name":"Custom quantiles","description":"The bin boundaries may be defined manually by entering the quantiles. The behaviour when a value is exactly equal to a quantile can be configured separately for each quantile.\n<ul><li><b>Quantile</b> : Specifies a quantile value (between 0 and 1) used as a bin boundary.</li><li><b>Exact match</b> : Defines how to assign values that match a cutoff exactly.\n  <ul><li><b>To lower bin</b> : Assign to the bin below the cutoff.</li><li><b>To upper bin</b> : Assign to the bin above the cutoff.</li></ul></li></ul>","optional":false},{"name":"Enforce integer cutoffs","description":"If enabled, bin boundaries will be rounded to the nearest integer. Not available when using custom cutoffs.","optional":false},{"name":"Fix lower bound","description":"If enabled, values below the specified lower bound will be assigned to a dedicated outlier bin. The bin will have the name specified by the &#39;Lower outlier name/value&#39; setting.","optional":false},{"name":"Lower bound","description":"Sets the minimum value for binning. Values below this will be assigned to the lower outlier bin.","optional":false},{"name":"Fix upper bound","description":"If enabled, values above the specified upper bound will be assigned to a dedicated outlier bin. The bin will have the name specified by the &#39;Upper outlier name/value&#39; setting.","optional":false},{"name":"Upper bound","description":"Sets the maximum value for binning. Values above this will be assigned to the upper outlier bin.","optional":false},{"name":"Bin names/values","description":"Selects how bins are labeled in the output. Use a &#39;Number Format Manager&#39; node to customize number formatting.\n<ul><li><b>Numbered (e.g., Bin 1, Bin 2)</b> : Bins are labeled by index.</li><li><b>Borders (e.g., [0.0, 1.0))</b> : Bins are labeled using interval borders.</li><li><b>Midpoints</b> : Bins are labeled using the midpoint of each interval.</li></ul>","optional":false},{"name":"Prefix","description":"Text to prepend to bin labels when using numbered naming (e.g., Bin 1, Bin 2).","optional":false},{"name":"Lower outlier name/value","description":"Label assigned to values below the first bin.","optional":false},{"name":"Upper outlier name/value","description":"Label assigned to values above the last bin.","optional":false},{"name":"Output columns","description":"Whether to replace the original columns with the binned columns, or to append the binned columns with new names created by appending the specified suffix to the original column names.\n<ul><li><b>Replace</b> : Replaces the original column with the binned result.</li><li><b>Append with suffix</b> : Adds a new column with the binned values.</li></ul>","optional":false},{"name":"Suffix","description":"Text appended to column names when new columns are created using the Append option.","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606261225","bundleName":"KNIME Base Nodes","bundleSymbolicName":"org.knime.base","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.base","featureName":"KNIME Base nodes","featureVersion":"5.12.0.v202606261225","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*bjR3r1yWOznPIEXS"},"frequentSuccessors":[]}