Icon

jKi-17

jKi-17
Challenge 17: Housing Market MadnessLevel: MediumDescription: Housing prices in America are a bit out of control. In thischallenge, you will see how housing prices have changed throughtime. Here are the tasks for this challenge:1. Read the dataset for this challenge directly from its link, withoutdownloading any files to your local machine with the CSV Readernode.2. Using monthly data, calculate the yearly data and visualize the 3RegionNames with the most drastic changes. Note: Consider theyear the data was collected until the most recent year to calculatechange; feel free to ignore missing values.3. Find the state (regardless of region) with the lowest prices forhomes on average currently.4.. According to Wikipedia, "The bankruptcy of Lehman Brothers onSeptember 15, 2008 was the climax of the subprime mortgagecrisis.". What visualizations can show the effect this had on thehousing market? We used our answer to question 2 to keep ourvisualizations clutter-free. Node 1Node 3Node 4yearNode 6Node 82. regions withmost drastic changesNode 10Node 12Node 132. regions withmost drastic changes CSV Reader Unpivoting String to Date&Time Extract Date&TimeFields GroupBy GroupBy Top k Selector GroupBy String Manipulation Row Filter Top k Selector Challenge 17: Housing Market MadnessLevel: MediumDescription: Housing prices in America are a bit out of control. In thischallenge, you will see how housing prices have changed throughtime. Here are the tasks for this challenge:1. Read the dataset for this challenge directly from its link, withoutdownloading any files to your local machine with the CSV Readernode.2. Using monthly data, calculate the yearly data and visualize the 3RegionNames with the most drastic changes. Note: Consider theyear the data was collected until the most recent year to calculatechange; feel free to ignore missing values.3. Find the state (regardless of region) with the lowest prices forhomes on average currently.4.. According to Wikipedia, "The bankruptcy of Lehman Brothers onSeptember 15, 2008 was the climax of the subprime mortgagecrisis.". What visualizations can show the effect this had on thehousing market? We used our answer to question 2 to keep ourvisualizations clutter-free. Node 1Node 3Node 4yearNode 6Node 82. regions withmost drastic changesNode 10Node 12Node 132. regions withmost drastic changes CSV Reader Unpivoting String to Date&Time Extract Date&TimeFields GroupBy GroupBy Top k Selector GroupBy String Manipulation Row Filter Top k Selector

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: franz
Created at: 2022-05-19
On NodePit since: 2022-05-19
Last update: 2024-11-21
Created with KNIME version: v4.5.2
Tags: 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!