Si considerino i dati \(kc_house_data\) relativi a vendite di abitazioni e si analizzi la relazione tra price e sqft_living tenendo conto, ove ritenuto necessario delle altre caratteristiche delle case. L’obiettivo della seguente analisi è quindi quello di evidenziare delle possibili relazioni tra grandezze mediante la costruzione di un modello di regressione.
Importazione e rappresentazione dati:
# dati presi da moodle
load("dati.Rdata")
df<-kc_house_data
attach(df)
tail(df)
## id date price bedrooms bathrooms sqft_living sqft_lot
## 21592 2997800021 2/19/2015 475000 3 2.50 1310 1294
## 21593 263000018 5/21/2014 360000 3 2.50 1530 1131
## 21594 6600060120 2/23/2015 400000 4 2.50 2310 5813
## 21595 1523300141 6/23/2014 402101 2 0.75 1020 1350
## 21596 291310100 1/16/2015 400000 3 2.50 1600 2388
## 21597 1523300157 10/15/2014 325000 2 0.75 1020 1076
## floors waterfront view condition grade sqft_above sqft_basement yr_built
## 21592 2 0 0 3 8 1180 130 2008
## 21593 3 0 0 3 8 1530 0 2009
## 21594 2 0 0 3 8 2310 0 2014
## 21595 2 0 0 3 7 1020 0 2009
## 21596 2 0 0 3 8 1600 0 2004
## 21597 2 0 0 3 7 1020 0 2008
## yr_renovated zipcode lat long sqft_living15 sqft_lot15
## 21592 0 98116 47.5773 -122.409 1330 1265
## 21593 0 98103 47.6993 -122.346 1530 1509
## 21594 0 98146 47.5107 -122.362 1830 7200
## 21595 0 98144 47.5944 -122.299 1020 2007
## 21596 0 98027 47.5345 -122.069 1410 1287
## 21597 0 98144 47.5941 -122.299 1020 1357
summary(df)
## id date price bedrooms
## Min. :1.000e+06 Length:21597 Min. : 78000 Min. : 1.000
## 1st Qu.:2.123e+09 Class :character 1st Qu.: 322000 1st Qu.: 3.000
## Median :3.905e+09 Mode :character Median : 450000 Median : 3.000
## Mean :4.580e+09 Mean : 540297 Mean : 3.373
## 3rd Qu.:7.309e+09 3rd Qu.: 645000 3rd Qu.: 4.000
## Max. :9.900e+09 Max. :7700000 Max. :33.000
## bathrooms sqft_living sqft_lot floors
## Min. :0.500 Min. : 370 Min. : 520 Min. :1.000
## 1st Qu.:1.750 1st Qu.: 1430 1st Qu.: 5040 1st Qu.:1.000
## Median :2.250 Median : 1910 Median : 7618 Median :1.500
## Mean :2.116 Mean : 2080 Mean : 15099 Mean :1.494
## 3rd Qu.:2.500 3rd Qu.: 2550 3rd Qu.: 10685 3rd Qu.:2.000
## Max. :8.000 Max. :13540 Max. :1651359 Max. :3.500
## waterfront view condition grade
## Min. :0.000000 Min. :0.0000 Min. :1.00 Min. : 3.000
## 1st Qu.:0.000000 1st Qu.:0.0000 1st Qu.:3.00 1st Qu.: 7.000
## Median :0.000000 Median :0.0000 Median :3.00 Median : 7.000
## Mean :0.007547 Mean :0.2343 Mean :3.41 Mean : 7.658
## 3rd Qu.:0.000000 3rd Qu.:0.0000 3rd Qu.:4.00 3rd Qu.: 8.000
## Max. :1.000000 Max. :4.0000 Max. :5.00 Max. :13.000
## sqft_above sqft_basement yr_built yr_renovated
## Min. : 370 Min. : 0.0 Min. :1900 Min. : 0.00
## 1st Qu.:1190 1st Qu.: 0.0 1st Qu.:1951 1st Qu.: 0.00
## Median :1560 Median : 0.0 Median :1975 Median : 0.00
## Mean :1789 Mean : 291.7 Mean :1971 Mean : 84.46
## 3rd Qu.:2210 3rd Qu.: 560.0 3rd Qu.:1997 3rd Qu.: 0.00
## Max. :9410 Max. :4820.0 Max. :2015 Max. :2015.00
## zipcode lat long sqft_living15
## Min. :98001 Min. :47.16 Min. :-122.5 Min. : 399
## 1st Qu.:98033 1st Qu.:47.47 1st Qu.:-122.3 1st Qu.:1490
## Median :98065 Median :47.57 Median :-122.2 Median :1840
## Mean :98078 Mean :47.56 Mean :-122.2 Mean :1987
## 3rd Qu.:98118 3rd Qu.:47.68 3rd Qu.:-122.1 3rd Qu.:2360
## Max. :98199 Max. :47.78 Max. :-121.3 Max. :6210
## sqft_lot15
## Min. : 651
## 1st Qu.: 5100
## Median : 7620
## Mean : 12758
## 3rd Qu.: 10083
## Max. :871200
library(leaflet)
library(dplyr)
##
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
##
## filter, lag
## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union
colors<-c("yellow","red")
pal<-colorFactor(colors,price)
dfPopup<-df%>%mutate(popup_info=paste("Prezzo della casa: ",price," $","</br>", "Piedratura del soggiorno: ",sqft_living,"</br>","Piedratura del seminterrato: ",sqft_basement,"</br>","Piedratura del lotto: ",sqft_lot,"</br>","Numero di piani : ",floors,"</br>","Numero di bagni per camera: ",bathrooms,"</br>","Numero di camere: ",bedrooms,"</br>","Vista sull'acqua: ",waterfront,"</br>","Data di vendita dell'immobile: ",date,"</br>","Numero di visite: ",view,"</br>","Valutazione: ",grade," ",condition,"</br>","Coordinate: ",lat," ",long,"</br>","Anno di costruzione: ",yr_built,"</br>","Anno del restauro: ",yr_renovated,"</br>"))
leaflet()%>%addTiles()%>%addCircleMarkers(data=dfPopup,lat= ~lat,lng= ~long, radius=~1,color=~pal(price),popup=~popup_info)