Icon

01 Data Access

Data Access - Exercise

This workflow shows 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 data folder2. Read the data locally La tabla que tiene más columnas es la delarchivo .csv con 13. Node 1Node 2Node 3Node 4Node 5Node 7Node 8CSV Reader Table Reader Excel Reader File Reader SQLite Connector DB Reader DB Table Selector 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 data folder2. Read the data locally La tabla que tiene más columnas es la delarchivo .csv con 13. Node 1Node 2Node 3Node 4Node 5Node 7Node 8CSV Reader Table Reader Excel Reader File Reader SQLite Connector DB Reader DB Table Selector

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-07
Last update: 2024-05-01
Created with KNIME version: v4.7.1
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!