Icon

DATA201_​week_​41

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?

Special Task plot both NZ and chch city only prices on same plot

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
Expression
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
Color Palette Designer
Filter neighbour_group to CHCH city ony
Row Filter
Bar Chart
Pie Chart
Row Sampler
Histogram days since last review
Histogram
Filter out columns that are not required
Column Filter

Nodes

Extensions

Links