Icon

JKISeason3-3_​tomljh

Real Estate Analytics

Level: Easy

Description: You are a real estate agent working in a new city, and to perform well your first task involves understanding the houses in the region better. A colleague shares a dataset with you and now it’s time for you to explore it. What has been the average housing price, lot size (in acres), and living space (in sqft) in this city, according to his dataset? How are prices distributed and correlated with housing features? What other insights can you gather from this dataset?

Authors: Thor Landstrom

Dataset: Real Estate Data in the KNIME Community Hub

kaggle:data:https://www.kaggle.com/datasets/harlfoxem/housesalesprediction Overall The distribution of prices The correlation between housing prices and other features Read dataHousing.csvgroup by : The city（all）agg: meanNote: Temporarily ignore the impact of time, as prices change within two years.Mean(sqft_lot) -> Mean(acres_lot)$Mean(sqft_lot)$ / 43560Keep two decimal placesDisplay format of numbers in table viewThe overall situation of housing prices in this city“First column name”= “price”The correlation between housing prices and other featuresIn reverse order by ”Correlation value“ columnPrices distributedstr ->datetimeyear and month CSV Reader GroupBy Math Formula Number FormatManager Table View Linear Correlation Row Filter Bar Chart Sorter Histogram String to Date&Time Extract Date&TimeFields Box Plot kaggle:data:https://www.kaggle.com/datasets/harlfoxem/housesalesprediction Overall The distribution of prices The correlation between housing prices and other features Read dataHousing.csvgroup by : The city（all）agg: meanNote: Temporarily ignore the impact of time, as prices change within two years.Mean(sqft_lot) -> Mean(acres_lot)$Mean(sqft_lot)$ / 43560Keep two decimal placesDisplay format of numbers in table viewThe overall situation of housing prices in this city“First column name”= “price”The correlation between housing prices and other featuresIn reverse order by ”Correlation value“ columnPrices distributedstr ->datetimeyear and monthCSV Reader GroupBy Math Formula Number FormatManager Table View Linear Correlation Row Filter Bar Chart Sorter Histogram String to Date&Time Extract Date&TimeFields Box Plot

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: Admin
Created at: 2024-05-29
On NodePit since: 2024-05-31
Last update: 2024-11-21
Created with KNIME version: v5.2.4
Tags: JKISeason3-3

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

Try NodePit Runner!