Icon

04 Geospatial data - Solution

Geospatial Visualization


Learning objective: In this exercise, you'll practice the creation of a choropleth map with the nodes of the Geospatial Analytics Extension for KNIME.


Workflow description: This workflow expands the analysis started in the previous workflow. It adds a geospatial view to the interactive dashboard.


You'll find the instructions to the exercises in the yellow annotations.

Handle missing values, rename and sort

The products with missing price are removed. If the brand is missing, it is replaced with the value N/A. These nodes also rename the columns and sort the rows by rating and price.

Extract values from the Product table

The nodes in this section process the product table to to extract some values from the strings, such as the product number, price, rating, etc..

Review Date and Country

The Expression node parses the Review Date and Loc column to extract the date and location of each review and store them in single columns. The Review Date is then processed to obtain a string with the yyyy-mm format.

Review Score and Review Length

The Expression node contains the expression to extract the Review Score from the string. Additionally, it creates a new column containing the review length.

Outliers handling

These nodes removes the rows with outlier values in the Price and Review Length columns respectively,

Step 1. Enrich dashboard

Open the component and complete the steps to add a choropleth map to the dashboard.



Data Quality

Calculate data quality measures and visualize heatmaps.

Sort by ratingand price
Sorter
Extract ASINfrom Link
String Replacer
Product reviews
Excel Reader
Column Renamer
Parse Price
Expression
Extractyear and month
Date&Time Part Extractor
Regex extract:Review CountryReview Date
Expression
Price by category
Box Plot
Regex replace: Category,Rating, Global_Ratings
Expression
Remove outliersin Review Length
Numeric Outliers
Data visualization
Product details
Excel Reader
Concatenateyear and month
Column Aggregator
Data Quality Profile
Remove rows with missing priceFill missing Brand with N/A
Missing Value
Domain Calculator
Data Quality + Heatmaps
Review ScoreReview Length
Expression
Remove outliersin Price
Numeric Outliers
String to Date&Time

Nodes

Extensions

Links