Icon

Challenge 17 Housing Market Madness

Question 2 Calculate the average price for each year Question 3:Lowest prices for homes on average currently: WV (West Virginia) Question 4:Visualize the US average price Node 1separate date columnsNode 17Node 21Node 22extract yearby yearNode 25Node 26Node 28Node 29Node 30Node 40Node 41Node 42check std deviationnote the max values'RegionNameTop3 drastic changes:San Jose, CA,San Francisco, CA,Summit Park, UTNode 49only RegionsNode 51split regions and countryNode 59Node 60Node 61 CSV Reader Column Splitter Transpose RowID String to Date&Time Extract Date&TimeFields Group Loop Start Transpose Column Filter Column Aggregator Loop End (ColumnAppend) Joiner Line Plot Column Filter Transpose RowID RowID Statistics Column Filter GroupBy Row Filter Sorter Row Splitter Column Filter Line Plot RowID RowID Transpose Question 2 Calculate the average price for each year Question 3:Lowest prices for homes on average currently: WV (West Virginia) Question 4:Visualize the US average price Node 1separate date columnsNode 17Node 21Node 22extract yearby yearNode 25Node 26Node 28Node 29Node 30Node 40Node 41Node 42check std deviationnote the max values'RegionNameTop3 drastic changes:San Jose, CA,San Francisco, CA,Summit Park, UTNode 49only RegionsNode 51split regions and countryNode 59Node 60Node 61 CSV Reader Column Splitter Transpose RowID String to Date&Time Extract Date&TimeFields Group Loop Start Transpose Column Filter Column Aggregator Loop End (ColumnAppend) Joiner Line Plot Column Filter Transpose RowID RowID Statistics Column Filter GroupBy Row Filter Sorter Row Splitter Column Filter Line Plot RowID RowID Transpose

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: xiao.mengyuan
Created at: 2022-05-18
On NodePit since: 2022-05-24
Last update: 2024-04-27
Created with KNIME version: v4.5.2

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

Try NodePit Runner!