{"title":"Missing Value Column Filter","nodeType":"Manipulator","id":"*xTIHpIYhQRCNETkp","factoryName":"org.knime.base.node.preproc.filter.missingvaluecolfilter.MissingValueColumnFilterNodeFactory","factoryId":"org.knime.base.node.preproc.filter.missingvaluecolfilter.MissingValueColumnFilterNodeFactory","path":["Manipulation","Column","Filter"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>The node tests each selected column for missing values and removes the column if it meets the specified condition about the number of missing values. Each column that is not selected for the test is passed on to the output unconditionally.</p>\n        ","shortDescription":"The node removes selected columns from the input if they meet the specified threshold of missing values.","keywords":[],"deprecated":false,"streamable":true,"tags":["Manipulation","Column","Filter","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6REFGNjAwRUY4OUU2MTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6REFGNjAwRUU4OUU2MTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDo2NEU5Qzk2RjFGNjExMUU1ODc4OUIxQTlEODQwRDkyQiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo2NEU5Qzk3MDFGNjExMUU1ODc4OUIxQTlEODQwRDkyQiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PobBeGoAAACsSURBVHjaYpQSl/7PAAXPXj6FMRn+///PCAQgOUaYkIqSKpDDCFfz7ds3BhYQ4+mLJwz4ANAwBqBhDId0tFDE7a9cZ2BioBBQbAADKAzQAcjVxGIWfH5GAowQ4f8o6qQlZPB6gRGNxgpYuLi4GIgwBCsARTsj1C9kA0ZVJbX/B3U0UQN200aGZ37+GGLoYQAKJ8rTAVpok+4FisMAlJDQ8wLIVXQLA4q9ABBgAJ4ZUm9P+4uLAAAAAElFTkSuQmCC","sinceVersion":"2.6.0","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Table to be filtered","description":"Table from which columns are filtered."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Filtered table","description":"Table without selected columns matching the criterion regarding missing values."}],"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":"Input columns","description":"Select the columns to test for missing values.","optional":false},{"name":"Remove columns","description":"Specify the threshold for the removal of selected columns.\n<ul><li><b>With at least one missing value</b> : Remove the column if it contains at least one missing value.</li><li><b>With only missing values</b> : Remove the column if it contains only missing values.</li><li><b>By percentage of missing values</b> : Remove the column if it contains at least the configured percentage of missing values.</li><li><b>By number of missing values</b> : Remove the column if it contains at least the configured number of missing values.</li></ul>","optional":false},{"name":"Threshold percentage (equal or more than %)","description":"Selected columns with at least this percentage of missing values are filtered out.","optional":false},{"name":"Threshold number (equal or more than)","description":"Selected columns with at least this number of missing values are filtered out.","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":[{"id":"*uVmaGQkzUOFCTqUe","factoryName":"org.knime.base.node.preproc.pmml.missingval.compute.MissingValueHandlerNodeFactory","probability":0.13975155279503104},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.06956521739130435},{"id":"*7isNz6mji9l5c7Iv","factoryName":"org.knime.base.node.preproc.normalize3.Normalizer3NodeFactory","probability":0.0453416149068323},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.03664596273291926},{"id":"*T0AhxSe0Yi42rQK8","factoryName":"org.knime.base.node.preproc.partition.PartitionNodeFactory","probability":0.03540372670807453},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.031677018633540374},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.02670807453416149},{"id":"*Oy714gpoifm4PiOZ","factoryName":"org.knime.base.node.io.csvwriter.CSVWriterNodeFactory","probability":0.016770186335403725},{"id":"*UyCz5Rn6epS9CN4Q","factoryName":"org.knime.base.node.preproc.colconvert.numbertostring.NumberToStringNodeFactory","probability":0.016149068322981366},{"id":"*7N4LxTHoPJrHN5lT","factoryName":"org.knime.base.node.stats.viz.extended.ExtendedStatisticsNodeFactory","probability":0.014906832298136646}]}