Icon

01 Data Access

Data Access - Exercise (Solution)

This workflow shows a solution to a hands-on exercise in the L1-DS Introduction to KNIME Analytics Platform for Data Scientists - Basics course

Task 1: Read Data from a File1. Read the following files in the data folder using the appropriate reader nodes:- adult.csv- adult_education.table- adult_income.xlsxHint! You can drag and drop the files from KNIME Explorer to the workflow editor2. Change the file paths to workflow relative paths Task 2: Accessing Databases1. Read the web_activity table on the WebActivity.sqlite database available in the datafolder2. Read the data locally adult_income.xlsxadult.csvadult_education.tableadult.csvWebActivity.sqliteweb_activity Excel Reader CSV Reader Table Reader File Reader SQLite Connector DB Table Selector DB Reader Task 1: Read Data from a File1. Read the following files in the data folder using the appropriate reader nodes:- adult.csv- adult_education.table- adult_income.xlsxHint! You can drag and drop the files from KNIME Explorer to the workflow editor2. Change the file paths to workflow relative paths Task 2: Accessing Databases1. Read the web_activity table on the WebActivity.sqlite database available in the datafolder2. Read the data locally adult_income.xlsxadult.csvadult_education.tableadult.csvWebActivity.sqliteweb_activityExcel Reader CSV Reader Table Reader File Reader SQLite Connector DB Table Selector DB Reader

Nodes

Extensions

Links