KNIME Essentials电子书

KNIME Essentials

Table of Contents

KNIME Essentials

Credits

About the Author

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

1. Installing and Using KNIME

Few words about KNIME

Installing KNIME

Installation using the archive

KNIME for Windows

KNIME for Linux

KNIME for Mac OS X

Troubleshooting

KNIME terminologies

Organizing your work

Nodes

Node lifecycle

Meta nodes

Ports

Data tables

Port view

Flow variables

Node views

HiLite

Eclipse concepts

Preferences

Logging

User interface

Getting started

Setting preferences

KNIME

Other preferences

Installing extensions

Workbench

Workflow handling

Node controls

HiLite

Variable flows

Meta nodes

Workflow lifecycle

Other views

Summary

2. Data Preprocessing

Importing data

Importing data from a database

Starting Java DB

Importing data from tabular files

Importing data from web services

REST services

Importing XML files

Importing models

Other formats

Public data sources

Regular expressions

Basic syntax

Partial versus whole match

Usage from Java

References and tools

Alternative pattern description

Transforming the shape

Filtering rows

Sampling

Appending tables

Less columns

Dimension reduction

More columns

GroupBy

Pivoting and Unpivoting

One2Many and Many2One

Cosmetic transformations

Renames

Changing the column order

Reordering the rows

The row ID

Transpose

Transforming values

Generic transformations

Java snippets

The Math Formula node

Conversion between types

Binning

Normalization

Text normalization

Regular expressions

Multiple columns

XML transformation

Time transformation

Smoothing

Data generation

Generating the grid

Constraints

Loops

Workflow customization

Case study – finding min-max in the next n rows

Case study – ranks within groups

Summary

3. Data Exploration

Computing statistics

Overview of visualizations

Visual guide for the views

Distance matrix

Using visual properties

Color

Size

Shape

KNIME views

HiLite

Use cases for HiLite

Row IDs

Extreme values

Basic KNIME views

The Box plots

Hierarchical clustering

Histograms

Interactive Table

The Lift chart

Lines

Pie charts

The Scatter plots

Spark Line Appender

Radar Plot Appender

The Scorer views

JFreeChart

The Bar charts

The Bubble chart

Heatmap

The Histogram chart

The Interval chart

The Line chart

The Pie chart

The Scatter plot

Open Street Map

3D Scatterplot

Other visualization nodes

The R plot, Python plot, and Matlab plot

The official R plots

The RapidMiner view

The HiTS visualization

Tips for HiLiting

Using Interactive HiLite Collector

Finding connections

Visualizing models

Further ideas

Summary

4. Reporting

Installation of the reporting extensions

Reporting concepts

Importing data

Sending data and images to a report

Importing from other sources

Joining data sets

Preferences

Using the designer

In visible views

Report properties

Report items

Label

Text

Binding

Dynamic text

Data

Image

Grid

List

Groups

Sorting

Filters

Table

Chart

Cross Tab

Setting up

Changing

Using data cubes

Quick Tools

Aggregation

Relative time period

Generating reports

Using colors

Using HiLite

Using workflow variables

Suggested readings

Summary

Index