Icon

Lab 3 - 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.xlsxWA_Fn-UseC_-Telco-Customer-Chur.csvadult_education.tableWA_Fn-UseC_-Telco-Customer-Chur.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.xlsxWA_Fn-UseC_-Telco-Customer-Chur.csvadult_education.tableWA_Fn-UseC_-Telco-Customer-Chur.csvWebActivity.sqliteweb_activityExcel Reader CSV Reader Table Reader File Reader SQLite Connector DB Table Selector DB 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: Maarit Laukkanen
Created at: 2020-04-20
On NodePit since: 2023-02-26
Last update: 2024-05-01
Created with KNIME version: v4.7.0
Tags: csvdata accesseducationexceltabledatabase

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

Try NodePit Runner!