Icon

clean_​data

Row Filtering Remove Values Row FilteringReplace Values Cleaning Data. The following set of tools (nodes) can be used to manipulate datasets that have rows containingmissing values, duplicate values or that need to be filtered based on certain row values. Remove row duplicates panda-list-sample.csv Filter out rows that match thecondition specified for a columne.g. Filter out rows with "NA"appearing in the column "Birthplace"Remove duplicate rows(exclude the column Index which has no duplicates)Replace strings having value "NA"in the column"Name in Chinese" with "Not Applicable" Using the GroupBy achieves the same result as above (exclude the column Index whichhas no duplicates)Filter out the rows that match the condition specified for a columne.g. Filter out rows with "NA"appearing in the column "Birthplace"Replace strings having value "NA" in the column"Loan_Expire_Date" with "01012030" Node 76Node 77CSV Reader Row Filter DuplicateRow Filter String Replacer GroupBy Row Filter (Labs) String Replacer File Reader CSV Reader Row Filtering Remove Values Row FilteringReplace Values Cleaning Data. The following set of tools (nodes) can be used to manipulate datasets that have rows containingmissing values, duplicate values or that need to be filtered based on certain row values. Remove row duplicates panda-list-sample.csv Filter out rows that match thecondition specified for a columne.g. Filter out rows with "NA"appearing in the column "Birthplace"Remove duplicate rows(exclude the column Index which has no duplicates)Replace strings having value "NA"in the column"Name in Chinese" with "Not Applicable" Using the GroupBy achieves the same result as above (exclude the column Index whichhas no duplicates)Filter out the rows that match the condition specified for a columne.g. Filter out rows with "NA"appearing in the column "Birthplace"Replace strings having value "NA" in the column"Loan_Expire_Date" with "01012030" Node 76Node 77CSV Reader Row Filter DuplicateRow Filter String Replacer GroupBy Row Filter (Labs) String Replacer File Reader CSV Reader

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: jbmac
Created at: 2017-08-30
On NodePit since: 2021-04-07
Last update: 2024-04-27
Created with KNIME version: v4.3.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!