Icon

Housing Market Madness (Phil)

Housing Market MadnessHousing prices in America are a bit out of control. In this challenge, you will see how housing prices have changed through time. Here are the tasks for this challenge:1. Read the dataset for this challenge directly from its link, without downloading any files to your local machine with the CSV Reader node.2. Using monthly data, calculate the yearly data and visualize the 3 RegionNames with the most drastic changes. Note: Consider the year the data was collected until the most recent year to calculate change; feel free to ignore missing values.3. Find the state (regardless of region) with the lowest prices for homes on average currently.4. According to Wikipedia, "The bankruptcy of Lehman Brothers on September 15, 2008 was the climax of the subprime mortgage crisis.". What visualizations can show the effect this had on the housing market? We used our answer to question 2 to keep our visualizations clutter-free.

Task 1 - Dynamcially read the most current dataset



Task 2 - Get the 3 Regions (!) with the highest increase over time



Task 3 - Get the State (!) with the cheapest current housing price



Task 4 - Visualize housing price development over time



read housing data(source file)from online source
CSV Reader
exclude "country"focus is on"Region"
Row Filter
get smallesttime difference to today
GroupBy
make month and housing pricescolumns
Unpivot
clean uptable
Table Manipulator
make "Year / Month"a true date column
String to Date&Time
Extract Yearand month
Date&Time Part Extractor
group mean housingprice by Region andYear
GroupBy
Table Row to Variable
keep only most current date rows
Row Filter
keep only citiesfrom top 3 highest price change %
Reference Row Filter
group Yearpivot Region Nameaggregate mean price
Pivot
find state withsmallest meanhousing price
Top k Row Filter
keep onlyRegionName
Column Filter
get latest housing priceper region
GroupBy
delete missingvalue rows
Row Filter
get top 3highest price change %
Top k Row Filter
get first housing price per region
GroupBy
Bar Chart
join togetherby region
Joiner
calculate price change %
Math Formula
groupmean housing priceby state and date
GroupBy
Date&Time Difference
rename year columns
Column Renamer
rename toreadableRegionNames
Column Renamer
visulaize development
Line Plot

Nodes

Extensions

Links