Icon

02c. Scatter Plot - solution

Relations in data with scatter and bubble plots
Read excel file containing pricesof houses (prices in the lastcolumn called "MEDV") Check the relationships:MEDV = median value of the occupied housed in 1.000 USD1. see and understand the relationship between the price "MEDV" andindependent feature "LSTAT" which represents percentage of poor people inthe area of certain house.2. see and understand the relationship between the price "MEDV" andindependent features "RM" representing the number of rooms, and "DIS"representing Distance of the employee centers Depict and average MEDV price for different ages. Hint: round the ages on whole numbers, group the MEDV based on the ageand create a heat map MEDVRelationshipbetween MEDV and LSTATGrouped tableaccording to age (rounded)Rounding ageAge to stringHouse pricesRelationship among MEDV, RM, DIS Heatmap Scatter Plot GroupBy Round Double Number To String Excel Reader (XLS) Bubble Chart(Plotly) Read excel file containing pricesof houses (prices in the lastcolumn called "MEDV") Check the relationships:MEDV = median value of the occupied housed in 1.000 USD1. see and understand the relationship between the price "MEDV" andindependent feature "LSTAT" which represents percentage of poor people inthe area of certain house.2. see and understand the relationship between the price "MEDV" andindependent features "RM" representing the number of rooms, and "DIS"representing Distance of the employee centers Depict and average MEDV price for different ages. Hint: round the ages on whole numbers, group the MEDV based on the ageand create a heat map MEDVRelationshipbetween MEDV and LSTATGrouped tableaccording to age (rounded)Rounding ageAge to stringHouse pricesRelationship among MEDV, RM, DIS Heatmap Scatter Plot GroupBy Round Double Number To String Excel Reader (XLS) Bubble Chart(Plotly)

Nodes

Extensions

Links