1. please use the column filter node and the sales dataset for the following tasks: a. exclude column card, b. exclude all columns starting with c, and c. exclude all numerical columns (5 points, submit screenshots of your workflow and the results) .

2. Please use the born_outside_US dataset, row filtering node, and missing value node for the following tasks: a. filter out rows where the marital status is missing, b. extract rows where the marital status is divorced, c, extract rows where the marital status is never married and age is between 20 and 40 (both included), d, the occupation starts with s .(15 points, submit screenshots of your workflow and the results) .

3. Use the Malariahts datasets and concatenate and string manipulation nodes for the following tasks: a. concatenate malariahts_experiment hits and no-hits into one single table, b. use string manager to ensure that all entries of the Sample column are using UPPERCASE letters, (10 points, submit screenshots of your workflow and the results).

Notes: you also need csv reader, excel reader to read the datasets.

Using the app KNIME Analysis Platform