Icon

Exercise2

<p><strong>Chapter 2/Exercise 1</strong></p><p>This exercise shows how to</p><ul><li><p>read the data file <em>data1_new.csv</em> generated in the previous exercise Chapter2/Exercise 1,</p></li><li><p>filter rows and columns, and</p></li><li><p>write the resulting data table to a new file.</p></li></ul><p>The particularity here is in the Column Filter, since we filter out all <em>Integer </em>columns using a type-based filtering and not just a manual filtering.</p>

URL: KNIME Beginner's Luck (Book Homepage) https://www.knime.com/knimepress/beginners-luck

Reading data

Cleaning data

Writing data

Workflow: Chapter 2/Exercise 2


This exercise shows how to

  • read the data file data1_new.csv generated in the previous exercise Chapter2/Exercise 1,

  • filter rows and columns, and

  • write the resulting data table to a new file.

The particularity here is in the Column Filter, since we filter out all Integer columns using a type-based filtering and not just a manual filtering.

data1_new.csv(created in Chapter2/Exercise2)
CSV Reader
Exclude rows with comments = "average"
Row Filter
Exclude integer columns
Column Filter
Append to data1_new.csvwithout column headers
CSV Writer

Nodes

Extensions

Links