Icon

DATA201_​week_​4

1. Discover

2. Structure

3. Clean

4. Enrich

Task: Calculate how long ago the last review was in days (difference between scrape/publish date and last review date). Plot the distribution of this new feature.

Last review date (most recent in the column last_review): 2026-06-22

Today's date is 2026-07-29

How long ago the last review was in days = today's date - last review date

5. Validate

6. Publish

Analysis

missing values - price has 5223 missing values,

last_Review has 5128 missing values

reviews_per_month has 5128 missing values

license has 50932 missing values

Price has minimum value of 5 and maximum of 84,438.

50% quantile is 264 but the mean is 378155.

Task: Plot the distribution of price as a histogram, both for all of New Zealand and only for Christchurch City

Task: Find out which properties in New Zealand get the highest numbers of reviews (filter top 10%). How many of them are in Christchurch?

From: https://insideairbnb.com/get-the-data/New Zealand June 2026 : listings.csv
CSV Reader
Column Filter
Sorter
filtered out price is missing rowsThere are 5233 missing price values
Row Filter
Row Sampler
task: plot the distribution of price as a histogram: All NZ price
Histogram
Added column: days_since_last review
Date&Time Difference
task: plot the distribution of price as a histogram: CHCH city
Histogram
Convert last_Review from string to Datetime variable
String to Date&Time
Get rid of price outlier,replaced the outlier values as missing values(outlier count : 3323). lower bound -211upper bound 813
Numeric Outliers
Pie Chart
Filter neighbour_group to CHCH city ony
Row Filter
Histogram days since last review
Histogram
Filter out columns that are not required
Column Filter

Nodes

Extensions

  • No modules found

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: kuoch
Created at: 2026-07-27
On NodePit since: 2026-07-30
Last update: 2026-08-02
Created with KNIME version: v5.12.0

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

Try NodePit Runner!