Icon

justKnimeit-17

justKnimeit-17
Challenge 17: Housing Market MadnessDescription: Housing prices in America are a bit out of control. In this challenge, you will see how housing prices have changedthrough 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 CSVReader node. 2.Using monthly data, calculate the yearly data and visualize the 3 RegionNames with the most drastic changes. Note: Considerthe 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 subprimemortgage crisis.". What visualizations can show the effect this had on the housing market? We used our answer to question 2 tokeep our visualizations clutter-free. For testing purposesTranspose fortime seriesGet TimeSeries ColumnsCalculate YeartymeansFor Data typecorrectionMerge data withmean and variancesCreate Groups formean calc.Groupby StateNameLowest Price State2022Calculateoverall varianceFor headeroperationsGet top 3variance3 Top ChangedRegionsFilter irrevelantFor visual.Read CSVNode 86 CSV Reader Transpose Row Splitter Transpose GroupBy Transpose RowID Concatenate Transpose String Manipulation GroupBy Top k Selector GroupBy RowID ConstantValue Column Top k Selector Line Plot Column Filter RowID Transpose Read Data From Urland Create a Table Create Date&TimeRange Challenge 17: Housing Market MadnessDescription: Housing prices in America are a bit out of control. In this challenge, you will see how housing prices have changedthrough 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 CSVReader node. 2.Using monthly data, calculate the yearly data and visualize the 3 RegionNames with the most drastic changes. Note: Considerthe 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 subprimemortgage crisis.". What visualizations can show the effect this had on the housing market? We used our answer to question 2 tokeep our visualizations clutter-free. For testing purposesTranspose fortime seriesGet TimeSeries ColumnsCalculate YeartymeansFor Data typecorrectionMerge data withmean and variancesCreate Groups formean calc.Groupby StateNameLowest Price State2022Calculateoverall varianceFor headeroperationsGet top 3variance3 Top ChangedRegionsFilter irrevelantFor visual.Read CSVNode 86 CSV Reader Transpose Row Splitter Transpose GroupBy Transpose RowID Concatenate Transpose String Manipulation GroupBy Top k Selector GroupBy RowID ConstantValue Column Top k Selector Line Plot Column Filter RowID Transpose Read Data From Urland Create a Table Create Date&TimeRange

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: Lenovo
Created at: 2022-05-19
On NodePit since: 2022-05-21
Last update: 2024-04-28
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!