Icon

Challenge 17 - Housing Market Madness

Challenge 17 - Housing Market Madness
READ DATA & PREPROCESSING Description: Housing 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 thischallenge:Read the dataset for this challenge directly from its link, without downloading any files to your local machine with the CSV Reader node.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 recentyear to calculate change; feel free to ignore missing values.Find the state (regardless of region) with the lowest prices for homes on average currently.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 effectthis had on the housing market? We used our answer to question 2 to keep our visualizations clutter-free. Challenge 17 - Housing Market Madness CALCULATE AVG. CHANGE OF PRICING FINAL DASHBOARD Read Housing Prices DatasetDates toRowsCalculateYearly Avg.ExcludeMissing PricesAverage between regions CSV Reader Unpivoting Column Rename GroupBy Row Filter Create Date & Year Calculate YoYVariance Visualizations READ DATA & PREPROCESSING Description: Housing 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 thischallenge:Read the dataset for this challenge directly from its link, without downloading any files to your local machine with the CSV Reader node.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 recentyear to calculate change; feel free to ignore missing values.Find the state (regardless of region) with the lowest prices for homes on average currently.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 effectthis had on the housing market? We used our answer to question 2 to keep our visualizations clutter-free. Challenge 17 - Housing Market Madness CALCULATE AVG. CHANGE OF PRICING FINAL DASHBOARD Read Housing Prices DatasetDates toRowsCalculateYearly Avg.ExcludeMissing PricesAverage between regions CSV Reader Unpivoting Column Rename GroupBy Row Filter Create Date & Year Calculate YoYVariance Visualizations

Nodes

Extensions

Links

Download

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

Download Workflow
Created by: USER
Created at: 2022-05-24
On NodePit since: 2022-05-25
Last update: 2024-04-27
Created with KNIME version: v4.5.0
Tags: #justknimeit#justknimeit-17

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

Try NodePit Runner!