StatenIslandAnalysis
Olufemi Adesanya
Monday, May 30, 2016
Import csv file
bk <- read.csv("C:/Users/OLUFEMI/Desktop/Analysis/StatenIslandAnalysis.csv",skip=4,header=TRUE)
head(bk)## BOROUGH NEIGHBORHOOD
## 1 5 ANNADALE
## 2 5 ANNADALE
## 3 5 ANNADALE
## 4 5 ANNADALE
## 5 5 ANNADALE
## 6 5 ANNADALE
## BUILDING.CLASS.CATEGORY TAX.CLASS.AT.PRESENT BLOCK
## 1 01 ONE FAMILY HOMES 1 5391
## 2 01 ONE FAMILY HOMES 1 5397
## 3 01 ONE FAMILY HOMES 1 5403
## 4 01 ONE FAMILY HOMES 1 5403
## 5 01 ONE FAMILY HOMES 1 5404
## 6 01 ONE FAMILY HOMES 1 6205
## LOT EASE.MENT BUILDING.CLASS.AT.PRESENT
## 1 8 A5
## 2 51 A1
## 3 23 A3
## 4 23 A3
## 5 18 A2
## 6 13 A5
## ADDRESS APARTMENT.NUMBER ZIP.CODE
## 1 4730 AMBOY ROAD 10312
## 2 23 EYLANDT STREET 10312
## 3 75 NOEL STREET 10312
## 4 75 NOEL STREET 10312
## 5 1610 ARDEN AVENUE 10312
## 6 99 EAGAN AVENUE 10312
## RESIDENTIAL.UNITS COMMERCIAL.UNITS TOTAL.UNITS LAND.SQUARE.FEET
## 1 1 0 1 3,149
## 2 1 0 1 10,120
## 3 1 0 1 10,000
## 4 1 0 1 10,000
## 5 1 0 1 7,500
## 6 1 0 1 1,845
## GROSS.SQUARE.FEET YEAR.BUILT TAX.CLASS.AT.TIME.OF.SALE
## 1 1,110 2002 1
## 2 3,000 1985 1
## 3 4,095 1991 1
## 4 4,095 1991 1
## 5 2,128 1970 1
## 6 1,854 1986 1
## BUILDING.CLASS.AT.TIME.OF.SALE SALE.PRICE SALE.DATE
## 1 A5 $450,000 2/4/2011
## 2 A1 $0 10/7/2011
## 3 A3 $0 6/3/2011
## 4 A3 $0 6/3/2011
## 5 A2 $0 2/28/2011
## 6 A5 $338,000 12/19/2011summary(bk)## BOROUGH NEIGHBORHOOD
## Min. :5 GREAT KILLS : 408
## 1st Qu.:5 NEW SPRINGVILLE : 240
## Median :5 ARDEN HEIGHTS : 236
## Mean :5 ELTINGVILLE : 215
## 3rd Qu.:5 BULLS HEAD : 189
## Max. :5 TOTTENVILLE : 181
## (Other) :3287
## BUILDING.CLASS.CATEGORY
## 01 ONE FAMILY HOMES :2630
## 02 TWO FAMILY HOMES :1075
## 05 TAX CLASS 1 VACANT LAND : 283
## 04 TAX CLASS 1 CONDOS : 238
## 13 CONDOS - ELEVATOR APARTMENTS : 85
## 22 STORE BUILDINGS : 77
## (Other) : 368
## TAX.CLASS.AT.PRESENT BLOCK LOT EASE.MENT
## 1 :3802 Min. : 1 Min. : 1.0 :4753
## 4 : 238 1st Qu.:1073 1st Qu.: 24.0 E: 3
## 1B : 236 Median :3268 Median : 54.0
## 1A : 228 Mean :3391 Mean : 179.0
## 2 : 202 3rd Qu.:5488 3rd Qu.: 125.2
## 2A : 24 Max. :8050 Max. :5352.0
## (Other): 26
## BUILDING.CLASS.AT.PRESENT
## A5 : 968
## A1 : 868
## B2 : 727
## A2 : 498
## V0 : 235
## R3 : 228
## (Other):1232
## ADDRESS APARTMENT.NUMBER
## ROSWELL AVENUE : 20 :4516
## WOODROW ROAD : 18 A : 8
## 2 ELMWOOD PARK DRIVE : 9 2A : 6
## CROCHERON AVENUE : 8 B : 6
## RICHMOND TERRACE : 8 1A : 5
## 5 WINDHAM LOOP : 7 1B : 5
## (Other) :4686 (Other) : 210
## ZIP.CODE RESIDENTIAL.UNITS COMMERCIAL.UNITS TOTAL.UNITS
## Min. : 0 Min. : 0.000 Min. : 0.00000 Min. : 0.000
## 1st Qu.:10305 1st Qu.: 1.000 1st Qu.: 0.00000 1st Qu.: 1.000
## Median :10308 Median : 1.000 Median : 0.00000 Median : 1.000
## Mean :10284 Mean : 1.341 Mean : 0.08326 Mean : 1.424
## 3rd Qu.:10312 3rd Qu.: 2.000 3rd Qu.: 0.00000 3rd Qu.: 2.000
## Max. :10314 Max. :273.000 Max. :12.00000 Max. :273.000
##
## LAND.SQUARE.FEET GROSS.SQUARE.FEET YEAR.BUILT
## 0 : 445 0 : 751 Min. : 0
## 4,000 : 340 1,991 : 86 1st Qu.:1935
## 2,500 : 161 1,800 : 67 Median :1970
## 5,000 : 154 1,600 : 45 Mean :1846
## 6,000 : 87 1,200 : 33 3rd Qu.:1990
## 2,000 : 60 1,440 : 32 Max. :2012
## (Other):3509 (Other):3742
## TAX.CLASS.AT.TIME.OF.SALE BUILDING.CLASS.AT.TIME.OF.SALE SALE.PRICE
## Min. :1.000 A5 : 938 $0 :1996
## 1st Qu.:1.000 A1 : 865 $350,000: 40
## Median :1.000 B2 : 699 $300,000: 34
## Mean :1.201 A2 : 513 $10 : 32
## 3rd Qu.:1.000 V0 : 281 $375,000: 30
## Max. :4.000 R3 : 228 $325,000: 29
## (Other):1232 (Other) :2595
## SALE.DATE
## 8/23/2011: 96
## 1/11/2011: 40
## 9/20/2011: 39
## 1/5/2011 : 36
## 4/28/2011: 34
## 2/28/2011: 33
## (Other) :4478str(bk)## 'data.frame': 4756 obs. of 21 variables:
## $ BOROUGH : int 5 5 5 5 5 5 5 5 5 5 ...
## $ NEIGHBORHOOD : Factor w/ 59 levels "ANNADALE ",..: 1 1 1 1 1 1 1 1 1 1 ...
## $ BUILDING.CLASS.CATEGORY : Factor w/ 29 levels "01 ONE FAMILY HOMES ",..: 1 1 1 1 1 1 1 1 1 1 ...
## $ TAX.CLASS.AT.PRESENT : Factor w/ 10 levels " ","1","1A",..: 2 2 2 2 2 2 2 2 2 2 ...
## $ BLOCK : int 5391 5397 5403 5403 5404 6205 6205 6205 6211 6212 ...
## $ LOT : int 8 51 23 23 18 13 22 32 22 89 ...
## $ EASE.MENT : Factor w/ 2 levels " ","E": 1 1 1 1 1 1 1 1 1 1 ...
## $ BUILDING.CLASS.AT.PRESENT : Factor w/ 78 levels " ","A0","A1",..: 6 3 5 5 4 6 6 6 6 3 ...
## $ ADDRESS : Factor w/ 4317 levels " 1 ARMOUR PLACE ",..: 2915 1532 3697 3697 867 4150 3852 3406 2992 180 ...
## $ APARTMENT.NUMBER : Factor w/ 162 levels " ",..: 1 1 1 1 1 1 1 1 1 1 ...
## $ ZIP.CODE : int 10312 10312 10312 10312 10312 10312 10312 10312 10312 10312 ...
## $ RESIDENTIAL.UNITS : int 1 1 1 1 1 1 1 1 1 1 ...
## $ COMMERCIAL.UNITS : int 0 0 0 0 0 0 0 0 0 0 ...
## $ TOTAL.UNITS : int 1 1 1 1 1 1 1 1 1 1 ...
## $ LAND.SQUARE.FEET : Factor w/ 1718 levels "0","1,000","1,004",..: 796 219 211 211 1551 172 120 492 112 1072 ...
## $ GROSS.SQUARE.FEET : Factor w/ 1406 levels "0","1,000","1,001",..: 49 960 1162 1162 607 432 291 432 258 267 ...
## $ YEAR.BUILT : int 2002 1985 1991 1991 1970 1986 1986 1986 1986 1970 ...
## $ TAX.CLASS.AT.TIME.OF.SALE : num 1 1 1 1 1 1 1 1 1 1 ...
## $ BUILDING.CLASS.AT.TIME.OF.SALE: Factor w/ 79 levels " A0 "," A1 ",..: 5 2 4 4 3 5 5 5 5 2 ...
## $ SALE.PRICE : Factor w/ 1021 levels "$0","$1","$1,000",..: 643 1 1 1 1 428 1 148 441 577 ...
## $ SALE.DATE : Factor w/ 309 levels "1/10/2011","1/11/2011",..: 124 53 232 232 122 89 302 69 195 257 ...bk$SALE.PRICE.N<- as.numeric(gsub("[^[:digit:]]","",bk$SALE.PRICE))
bk$SALE.PRICE.N## [1] 450000 0 0 0 0 338000 0
## [8] 180455 345000 410000 414000 410000 415000 426000
## [15] 380000 0 517000 0 0 470000 352500
## [22] 473000 440000 340000 0 425000 775000 0
## [29] 340000 725000 1100000 745000 768778 457000 0
## [36] 590000 0 300000 0 549000 0 0
## [43] 550000 0 295000 760000 526500 0 490000
## [50] 630000 0 0 630000 875000 0 775000
## [57] 0 0 740000 930000 0 1500000 0
## [64] 0 456500 999999 835239 0 0 0
## [71] 0 481000 0 462500 530000 695000 0
## [78] 548000 0 538000 580000 0 141666 0
## [85] 800000 800000 575000 1050000 0 0 220000
## [92] 0 0 0 0 0 0 0
## [99] 0 0 645640 462000 329000 645000 455000
## [106] 350000 370000 350000 370000 350000 435000 0
## [113] 0 0 0 0 0 0 0
## [120] 0 436020 0 0 0 0 0
## [127] 0 491790 0 0 0 0 0
## [134] 0 0 0 0 0 0 0
## [141] 0 0 0 0 0 0 0
## [148] 0 0 0 0 0 425880 0
## [155] 0 0 0 0 0 0 0
## [162] 0 0 0 0 0 0 0
## [169] 446160 0 446160 0 446160 0 0
## [176] 0 495025 0 476574 0 461370 0
## [183] 466440 0 0 496860 0 220000 283500
## [190] 167310 259700 256500 265000 205000 238500 245000
## [197] 270000 268000 250000 255000 240000 0 235000
## [204] 0 257500 288400 269000 205000 297000 245000
## [211] 225000 260580 242000 288000 237000 0 212000
## [218] 210000 288000 0 255000 272500 276000 232500
## [225] 285000 214000 0 330750 335000 350000 279864
## [232] 346500 857000 325000 310000 0 330000 290000
## [239] 344750 247484 324000 0 0 310000 0
## [246] 310000 0 324450 393000 290000 240000 225000
## [253] 290000 0 265000 267000 258000 285000 270000
## [260] 240000 290000 0 0 337500 0 0
## [267] 102500 0 425000 442500 336500 310000 325000
## [274] 0 0 450000 0 0 0 0
## [281] 0 650000 422300 0 390000 10 0
## [288] 465500 258570 273000 314000 0 250000 0
## [295] 328000 293000 0 328000 325000 165810 0
## [302] 0 0 0 0 0 0 0
## [309] 0 0 0 0 0 0 0
## [316] 0 0 0 0 0 0 0
## [323] 420000 420000 451230 456300 425880 488338 439094
## [330] 436020 436020 451230 496440 455000 459730 0
## [337] 0 0 0 570000 0 0 0
## [344] 368500 1 390390 385320 390390 0 454000
## [351] 0 425000 375000 0 27500 0 4562
## [358] 370000 0 370000 0 0 0 0
## [365] 736175 0 0 490000 0 370000 0
## [372] 0 309000 265000 165000 184000 0 232500
## [379] 207000 205000 0 200000 260000 0 0
## [386] 374000 345000 365000 517500 412000 0 465000
## [393] 303000 265000 322452 525000 355000 319000 405000
## [400] 495000 0 360000 345000 0 335000 305000
## [407] 0 270000 0 75000 0 265000 0
## [414] 290000 275000 0 350000 0 215000 299000
## [421] 225000 245000 323500 215000 231000 340000 368000
## [428] 190000 290000 0 168000 307750 355000 800000
## [435] 0 435000 0 365000 650000 500000 0
## [442] 380000 395000 357000 0 0 16500 0
## [449] 0 450000 0 370800 0 499000 0
## [456] 300000 0 0 0 0 0 300000
## [463] 0 360000 360000 329000 390000 0 0
## [470] 285948 0 455000 0 375000 0 407000
## [477] 455000 0 1000 0 461100 0 380000
## [484] 0 440000 0 0 0 0 135000
## [491] 0 568333 10 0 0 590000 582000
## [498] 475000 520000 456300 555000 0 0 0
## [505] 0 247500 234000 250000 0 0 218000
## [512] 160000 200000 0 305000 280000 255000 0
## [519] 0 200000 285000 0 224000 0 230000
## [526] 0 200000 205000 170000 0 220000 0
## [533] 290000 0 0 0 0 0 0
## [540] 0 0 0 0 0 0 0
## [547] 0 0 0 0 880863 100000 0
## [554] 0 0 0 2287000 926250 0 0
## [561] 0 0 0 0 0 0 0
## [568] 9510000 0 0 1189619 0 0 355000
## [575] 0 0 265000 417600 405000 420000 0
## [582] 0 925000 410000 0 0 0 260000
## [589] 0 1 655000 420000 22532 375000 350000
## [596] 0 0 350000 0 785000 386250 0
## [603] 0 290000 0 415000 0 0 515000
## [610] 448000 453000 562500 370000 0 398000 0
## [617] 400000 670000 325000 0 499950 290000 0
## [624] 325000 313500 239000 565000 0 473800 0
## [631] 375000 0 0 270000 410000 497000 0
## [638] 0 651680 484000 530500 0 0 375000
## [645] 295000 0 0 0 3100000 2400000 1631650
## [652] 0 0 460000 315000 0 0 0
## [659] 375950 202000 450000 0 745000 0 825000
## [666] 367500 520000 350000 380000 0 0 559900
## [673] 498000 0 412000 0 362000 550000 0
## [680] 335000 0 0 540000 340000 385000 500000
## [687] 320000 466000 0 0 0 0 275000
## [694] 470000 550000 0 436000 0 300000 0
## [701] 450000 720000 705000 380000 419500 0 460000
## [708] 450000 0 129000 160000 220000 145000 77000
## [715] 215000 110000 144000 120000 125000 950000 0
## [722] 0 0 138500 0 155000 0 0
## [729] 0 0 0 0 0 310000 0
## [736] 0 349000 0 0 321180 285000 175000
## [743] 154128 114000 360000 0 300000 105000 325000
## [750] 265000 0 151642 0 0 0 0
## [757] 213000 260000 324480 285000 288000 180000 0
## [764] 185000 150000 0 0 95000 500000 0
## [771] 0 0 0 182000 0 0 160650
## [778] 224394 293550 265000 0 0 15000000 0
## [785] 0 0 0 390000 450000 0 0
## [792] 340000 0 0 462000 510000 407500 748413
## [799] 0 0 0 0 528000 372000 0
## [806] 0 440000 0 450000 515000 455000 305000
## [813] 370000 385000 0 0 365000 480000 369000
## [820] 672000 380000 462000 0 0 712773 467500
## [827] 0 585000 0 361000 650000 500000 0
## [834] 470000 0 750000 677136 691391 385000 415000
## [841] 1000 0 0 285000 285000 0 0
## [848] 0 0 550000 0 55000 170000 190000
## [855] 160000 750000 0 300000 715000 0 875000
## [862] 590000 635000 949183 465000 465000 449000 0
## [869] 0 0 890000 0 0 825000 0
## [876] 600000 0 224000 512500 1190000 490000 0
## [883] 0 525000 219000 0 0 610000 296595
## [890] 330000 0 380000 495000 0 0 0
## [897] 0 410000 224500 0 465000 0 0
## [904] 375000 400000 0 0 0 475000 499500
## [911] 415000 770000 440000 0 0 410670 977520
## [918] 719000 425000 0 0 0 0 0
## [925] 525000 382000 0 0 495000 540000 0
## [932] 0 0 0 0 0 0 0
## [939] 485000 345000 0 0 283000 0 385000
## [946] 345000 351750 465000 630000 336000 350000 0
## [953] 0 497000 0 0 383282 399000 0
## [960] 459000 435000 485000 245000 263000 360800 0
## [967] 293550 470000 225000 205000 483000 335000 425000
## [974] 565000 375000 0 0 0 0 350000
## [981] 200000 400000 266268 415000 417500 335000 365000
## [988] 376200 0 382500 0 430000 475000 565000
## [995] 0 610000 0 380000 299500 295000 0
## [1002] 406500 0 345000 227500 0 0 235000
## [1009] 420000 380000 10 0 422500 0 410000
## [1016] 0 0 0 125000 360000 595000 0
## [1023] 0 0 413000 421500 0 375000 434000
## [1030] 430000 300000 0 424750 450000 0 0
## [1037] 430000 327500 0 440000 681000 0 687318
## [1044] 890000 0 503000 860421 0 0 366000
## [1051] 0 385000 275000 0 650000 800000 0
## [1058] 0 580000 0 0 550000 0 555000
## [1065] 0 0 0 0 0 0 0
## [1072] 0 0 0 0 0 244868 0
## [1079] 464000 510000 510000 467000 0 0 0
## [1086] 0 0 499900 0 490000 0 530000
## [1093] 485000 505000 0 318360 540000 712775 0
## [1100] 442000 45000 287500 0 182000 0 0
## [1107] 2150000 841000 0 0 995000 0 0
## [1114] 465000 600000 838000 2350000 0 300000 585000
## [1121] 0 600000 1250000 0 848900 1600000 475000
## [1128] 0 482500 0 345000 360000 335000 355000
## [1135] 0 212981 350000 0 0 0 371000
## [1142] 375000 0 0 380000 0 0 0
## [1149] 360000 346750 425000 0 485000 0 0
## [1156] 330000 0 285000 350000 330000 0 0
## [1163] 0 330000 440000 512000 0 0 592000
## [1170] 650000 635000 150000 522500 840000 0 0
## [1177] 810000 107836 0 0 0 465000 0
## [1184] 742304 0 0 0 0 150000 485000
## [1191] 0 180000 535000 70000 66000 152000 0
## [1198] 127000 163000 73000 152000 109432 218000 98000
## [1205] 162000 162000 190000 208000 180000 165000 227000
## [1212] 0 4595752 0 45000 350000 0 0
## [1219] 0 0 275000 375000 390000 0 0
## [1226] 0 310275 450000 0 0 355000 0
## [1233] 430000 259700 499395 380000 465000 425000 0
## [1240] 0 0 510000 620000 0 620000 0
## [1247] 989000 0 575000 0 750000 565000 470000
## [1254] 0 615000 0 385000 425000 380000 400000
## [1261] 350000 0 0 370000 100000 365000 0
## [1268] 100000 270000 235000 412500 478000 420000 450000
## [1275] 470000 418000 475000 445000 399900 280000 412900
## [1282] 214286 300000 328500 365547 0 0 295000
## [1289] 0 350000 360000 0 309000 0 0
## [1296] 339778 390000 425000 0 450000 330000 0
## [1303] 475000 329000 485000 544000 366000 370000 365000
## [1310] 0 0 355000 0 0 97253 0
## [1317] 0 0 505000 875000 410000 0 415000
## [1324] 457500 407000 742000 0 0 380000 379225
## [1331] 0 0 0 0 340000 410000 0
## [1338] 360000 0 0 595000 530000 773870 794235
## [1345] 0 360000 475000 0 0 0 550000
## [1352] 575000 0 0 445000 650000 0 0
## [1359] 542218 529490 330000 514216 514216 0 446000
## [1366] 300000 390000 0 228150 270000 339000 515000
## [1373] 200000 0 545000 0 0 0 385000
## [1380] 504500 385000 370000 525000 295000 585000 0
## [1387] 108367 700000 10 515000 415000 250000 419000
## [1394] 0 440000 10 0 0 0 207500
## [1401] 405000 440000 200000 355000 0 0 0
## [1408] 425000 340000 0 290000 281000 296800 430000
## [1415] 265000 330000 10 0 50000 160000 0
## [1422] 260000 290000 0 385000 410000 400000 340000
## [1429] 300000 0 0 468000 0 554946 466440
## [1436] 475000 0 0 265000 35000 355100 0
## [1443] 333000 340000 465000 0 0 0 300000
## [1450] 625000 294060 0 375000 0 0 0
## [1457] 0 375000 505000 0 350000 369200 405000
## [1464] 0 440000 0 0 0 402250 318000
## [1471] 350000 329000 341500 379000 340000 365000 469482
## [1478] 425000 0 0 385000 375000 0 350000
## [1485] 137500 0 0 440000 569000 0 185000
## [1492] 0 0 375000 330000 0 385000 0
## [1499] 610000 0 380000 0 0 0 400000
## [1506] 430000 425000 0 0 0 410000 365277
## [1513] 436000 375000 0 0 485000 400000 388000
## [1520] 0 0 0 318000 0 590000 0
## [1527] 200000 0 441000 459000 420000 430000 0
## [1534] 0 285000 390000 400000 390000 430000 0
## [1541] 590000 595000 435000 435000 0 0 0
## [1548] 0 415000 0 0 0 600000 0
## [1555] 0 0 375000 0 60000 0 0
## [1562] 450000 525000 0 635000 0 0 0
## [1569] 0 0 0 0 530000 565000 0
## [1576] 380000 450000 0 415000 0 685000 661862
## [1583] 0 0 0 0 0 450000 473000
## [1590] 0 720000 0 0 10 0 0
## [1597] 0 493500 0 360000 360000 0 0
## [1604] 415000 160000 0 0 0 465000 695000
## [1611] 563500 0 0 0 440000 0 0
## [1618] 229000 225000 265000 0 233000 0 0
## [1625] 335000 600000 443000 455000 0 235000 230000
## [1632] 203803 0 0 197730 354900 250000 218000
## [1639] 0 0 0 0 390000 0 0
## [1646] 1870000 623750 0 85000 100000 102000 0
## [1653] 150000 96000 86190 158000 137800 225000 0
## [1660] 0 173000 186000 275000 295000 325000 349830
## [1667] 339690 362505 370110 359970 0 0 600000
## [1674] 2287000 0 0 395000 380000 0 0
## [1681] 390000 329600 0 360000 0 350000 370000
## [1688] 0 285000 380000 415000 395000 0 395000
## [1695] 300000 405000 0 0 0 0 415000
## [1702] 0 0 10 0 0 0 0
## [1709] 257500 0 10 0 283882 0 625000
## [1716] 0 0 0 122500 94500 175000 115000
## [1723] 0 900000 0 900000 555000 525000 0
## [1730] 625000 200000 376000 400000 0 0 975000
## [1737] 0 197000 0 92000 105000 115000 125000
## [1744] 155000 155000 116000 101000 135900 115000 121000
## [1751] 125000 300000 0 0 195000 400000 775000
## [1758] 515000 763687 335000 540000 0 965000 645000
## [1765] 811000 750000 0 450000 0 400000 0
## [1772] 0 0 300000 481500 250000 0 712775
## [1779] 712755 700000 575000 0 0 0 530000
## [1786] 0 0 460000 480000 475000 360000 0
## [1793] 372500 370000 0 0 330000 0 0
## [1800] 0 0 568500 0 680000 0 500000
## [1807] 537500 0 0 730000 0 580000 327500
## [1814] 0 0 0 0 625000 763687 0
## [1821] 600000 758596 775000 645000 0 10 235000
## [1828] 0 275000 275000 275000 0 0 975000
## [1835] 733140 710000 0 275000 500000 0 463000
## [1842] 312000 0 0 330000 412000 348000 231000
## [1849] 415740 0 88000 225000 161000 625000 0
## [1856] 0 0 0 0 530000 0 0
## [1863] 210199 106000 799000 0 0 510000 350000
## [1870] 360000 0 363000 357000 0 0 240500
## [1877] 0 500000 0 0 314340 377000 490000
## [1884] 473500 325000 0 0 0 420000 0
## [1891] 0 0 0 390000 355000 420000 289091
## [1898] 375000 300000 0 510000 800000 600000 0
## [1905] 575000 135000 527000 0 0 0 330000
## [1912] 0 0 0 10 500000 587000 0
## [1919] 0 0 455000 0 0 0 480000
## [1926] 200000 170000 330000 0 0 315000 280000
## [1933] 370110 0 319410 236262 307400 0 343000
## [1940] 405600 360000 375180 365040 365040 136350 289000
## [1947] 225000 0 0 330000 0 0 138000
## [1954] 329000 410000 0 220000 172000 355517 0
## [1961] 90500 275000 0 0 0 223500 0
## [1968] 235000 110000 236000 95000 120000 0 533480
## [1975] 0 170000 156000 0 321501 215000 234000
## [1982] 0 190632 188000 380000 320000 0 130000
## [1989] 202800 265000 142000 65000 345000 185000 0
## [1996] 0 10000 100000 180000 0 0 0
## [2003] 210000 335000 0 250000 1 340000 152100
## [2010] 21252 410670 404586 425880 0 170000 132834
## [2017] 0 273780 0 280000 189000 0 203307
## [2024] 268710 0 0 0 359970 0 0
## [2031] 0 0 300000 0 203000 330000 233220
## [2038] 0 525000 225000 75000 210000 0 254562
## [2045] 104000 0 300000 198000 39233 92000 447000
## [2052] 0 326000 0 395000 365000 0 0
## [2059] 400000 0 373500 3650000 330000 450000 0
## [2066] 0 0 300000 0 375000 251000 412274
## [2073] 0 270000 0 395460 395460 0 0
## [2080] 351500 0 280000 0 0 355000 480000
## [2087] 345000 191000 0 418782 418782 415000 0
## [2094] 330000 0 117500 346788 351752 266682 0
## [2101] 505000 0 0 270000 10 0 0
## [2108] 0 410000 390390 157000 0 140000 0
## [2115] 0 0 150000 316000 282500 157000 0
## [2122] 0 295000 293000 319300 0 0 505000
## [2129] 390000 534581 550000 0 230000 530000 0
## [2136] 0 0 0 485000 760000 0 0
## [2143] 585000 420000 570220 20000 642515 0 145000
## [2150] 0 515000 0 0 0 180000 10
## [2157] 425880 425880 420810 415000 466440 0 150000
## [2164] 71786 0 50000 234000 42500 0 0
## [2171] 0 0 0 0 450000 0 0
## [2178] 850000 0 105000 398000 0 174821 725000
## [2185] 0 335000 0 135000 315000 64000 0
## [2192] 655000 270300 385320 0 355000 0 344000
## [2199] 175000 161226 358000 115000 85000 369900 370000
## [2206] 525000 0 265000 405000 340000 0 80000
## [2213] 0 0 0 0 0 105560 0
## [2220] 135000 160000 83000 0 165282 0 227000
## [2227] 240000 0 0 0 325000 0 0
## [2234] 280000 745000 330000 0 197730 290000 495886
## [2241] 170000 249000 0 0 515000 230000 0
## [2248] 0 435000 275000 0 288660 330000 0
## [2255] 155000 120000 160000 0 310000 205000 101400
## [2262] 0 100000 212000 210000 171556 0 0
## [2269] 0 315000 155000 161070 108199 0 165000
## [2276] 350000 120000 308000 145103 10 225000 172390
## [2283] 307500 0 217900 0 0 0 0
## [2290] 280000 116610 245000 205000 0 0 414100
## [2297] 0 162240 0 0 500 0 242547
## [2304] 0 160000 38000 120000 0 0 0
## [2311] 351000 0 0 0 0 2500 14000000
## [2318] 0 0 263500 0 0 0 100000
## [2325] 0 89000 130000 105000 215000 105000 78000
## [2332] 115000 143000 0 458212 0 183000 420000
## [2339] 117000 0 0 50000 8000 0 100000
## [2346] 0 0 0 7000000 228500 323000 10
## [2353] 225000 205000 800000 232500 155000 75400 99000
## [2360] 0 0 0 675000 0 0 0
## [2367] 600000 0 400000 412500 0 0 410000
## [2374] 380000 412000 0 0 285000 475475 475000
## [2381] 0 0 462500 290000 485000 368000 0
## [2388] 377500 345000 455500 0 0 0 0
## [2395] 0 111500 350000 365000 465000 473000 0
## [2402] 0 0 660000 0 287000 540000 250000
## [2409] 372000 413333 425000 514000 10 0 0
## [2416] 0 10 334000 0 340000 0 0
## [2423] 0 0 385000 399800 572000 475000 420000
## [2430] 432802 390000 455000 157000 390000 0 600000
## [2437] 378900 404586 309270 356928 356928 356928 333000
## [2444] 354900 365040 309270 304200 283920 304200 294060
## [2451] 0 314340 485000 0 0 0 0
## [2458] 0 0 580000 522000 375000 385000 475000
## [2465] 826473 719000 270000 0 645000 0 0
## [2472] 0 145000 285000 0 590000 750000 0
## [2479] 0 0 0 3175000 700000 700000 0
## [2486] 0 0 0 0 0 0 0
## [2493] 1292610 327000 135000 0 0 0 335000
## [2500] 0 0 0 0 131000 0 130000
## [2507] 100000 100000 121000 212000 210000 0 0
## [2514] 340000 250000 360000 0 106000 250000 125400
## [2521] 309690 400000 0 0 450000 0 132500
## [2528] 132500 427000 300000 405600 420810 0 0
## [2535] 0 0 0 0 0 275000 0
## [2542] 720000 0 0 535000 559000 0 545000
## [2549] 340000 350000 0 865513 730000 0 485000
## [2556] 550000 425000 330000 80000 630000 0 0
## [2563] 514000 345000 445000 360000 0 60000 300000
## [2570] 350000 0 165500 0 0 338500 0
## [2577] 280000 407000 390000 405000 0 0 0
## [2584] 237500 108333 108333 108333 0 0 430000
## [2591] 575000 0 0 600000 0 1500000 0
## [2598] 0 0 0 260000 0 0 380000
## [2605] 0 0 0 262500 340000 0 300000
## [2612] 385000 499000 480000 320000 337155 325000 0
## [2619] 0 0 0 0 0 0 0
## [2626] 0 412000 0 418000 0 323000 0
## [2633] 0 375950 319500 460000 360000 335000 0
## [2640] 0 320000 395000 0 480000 0 0
## [2647] 460000 0 455000 452170 405000 440000 470000
## [2654] 400000 325000 275000 452000 345000 375000 0
## [2661] 350000 350000 0 450000 0 215000 200000
## [2668] 335000 325000 0 280000 0 438000 0
## [2675] 0 510000 142230 490000 555000 0 0
## [2682] 0 472500 0 557500 461000 375000 415000
## [2689] 418000 500000 0 794235 0 0 495000
## [2696] 540000 517500 0 390000 365000 0 0
## [2703] 0 0 538000 0 590000 376530 370000
## [2710] 363500 435000 538650 560000 0 0 525000
## [2717] 0 0 0 10 0 545000 0
## [2724] 500000 0 560000 40000 545000 0 0
## [2731] 300000 0 215000 200000 310000 310000 340000
## [2738] 299000 255000 185400 150000 0 0 0
## [2745] 0 165000 0 248000 264000 240000 0
## [2752] 230685 200000 280000 244341 0 0 260000
## [2759] 150000 225000 212500 205000 0 230000 268000
## [2766] 88000 110000 0 275000 0 235000 232000
## [2773] 234000 158000 185000 0 0 150000 0
## [2780] 275000 256500 0 0 270000 254000 286000
## [2787] 0 282000 0 270000 0 280000 0
## [2794] 245661 0 0 192660 327000 0 10
## [2801] 180000 202800 177000 21665 190000 205000 137000
## [2808] 0 17491 113000 140000 220000 159000 76000
## [2815] 220000 0 200000 205000 0 0 187000
## [2822] 230000 75000 230000 0 120000 165000 0
## [2829] 0 0 0 205000 275000 240000 305000
## [2836] 305000 315000 250000 315000 228000 235000 225000
## [2843] 225000 0 435000 415000 470000 330000 495000
## [2850] 495000 0 0 0 0 0 834965
## [2857] 560200 452000 470000 315000 530000 0 0
## [2864] 636406 610950 358800 390000 0 375000 351381
## [2871] 420000 0 560000 0 460000 0 325000
## [2878] 340000 350000 0 10000 0 0 360500
## [2885] 410000 385000 450000 590585 0 415000 420000
## [2892] 37500 0 390000 0 345000 210000 0
## [2899] 370000 230000 0 490000 0 509024 740000
## [2906] 117500 117500 2000 1298269 835000 740000 430000
## [2913] 435000 0 0 400000 455000 415000 615000
## [2920] 425000 825000 0 772597 600000 589500 0
## [2927] 0 400000 438000 324500 975100 0 0
## [2934] 0 667000 0 999000 0 0 0
## [2941] 0 0 0 0 894000 0 763687
## [2948] 711756 350000 0 0 0 0 0
## [2955] 0 0 0 0 230000 0 325000
## [2962] 0 0 282500 65926 125000 0 241043
## [2969] 0 459500 0 0 0 250000 0
## [2976] 263640 0 0 0 145000 141900 0
## [2983] 144160 93000 143000 0 120000 0 0
## [2990] 10000 0 0 0 0 0 573559
## [2997] 0 0 200000 142500 175000 0 100000
## [3004] 500 285000 270000 0 418275 355000 0
## [3011] 266250 260000 365000 0 0 0 0
## [3018] 377000 405000 445000 0 333000 185000 0
## [3025] 0 270000 315000 330000 305000 290000 92000
## [3032] 130000 265056 253500 0 151000 285000 0
## [3039] 225000 0 0 0 254244 229000 0
## [3046] 75000 230000 0 255000 0 172000 0
## [3053] 345000 328000 85000 85000 155000 288320 330000
## [3060] 150000 420000 473000 275000 0 0 0
## [3067] 549000 0 0 0 0 238000 380000
## [3074] 431720 0 152100 92274 55000 0 245000
## [3081] 0 0 190632 189351 363500 10 0
## [3088] 120000 0 0 350000 172380 0 0
## [3095] 0 168600 10 0 225000 0 0
## [3102] 0 414726 0 142700 0 422300 500
## [3109] 1260652 0 495000 0 150000 406000 1245000
## [3116] 0 0 1325000 950000 850000 0 0
## [3123] 0 0 0 0 499000 950000 0
## [3130] 0 0 0 0 390000 370000 692410
## [3137] 0 0 0 499999 515000 0 0
## [3144] 813582 778961 325000 0 1875000 0 559750
## [3151] 0 0 325000 0 385000 0 375000
## [3158] 524000 380000 480000 90000 0 475000 525000
## [3165] 730000 911333 750000 0 1215000 1150000 244000
## [3172] 725000 400000 375000 635000 0 0 0
## [3179] 0 0 966319 504183 415000 315000 275000
## [3186] 569000 0 325000 0 0 462500 622000
## [3193] 0 608550 735000 250000 499900 425880 350000
## [3200] 873000 775000 577000 595660 0 755541 660000
## [3207] 750000 0 233000 720000 0 740000 735685
## [3214] 625000 525000 499902 0 0 0 490000
## [3221] 312000 0 0 774000 742304 729000 400000
## [3228] 310000 425000 750000 391000 800344 813581 0
## [3235] 0 0 250000 997000 966319 775000 0
## [3242] 0 300000 592000 475000 998000 385000 0
## [3249] 480000 405000 0 10 0 405000 450000
## [3256] 0 10 134680 0 0 641497 641497
## [3263] 0 438600 0 615000 372000 690000 0
## [3270] 500000 0 0 480000 600000 765000 838000
## [3277] 0 0 910000 0 845000 0 0
## [3284] 551500 490000 0 565000 150000 370000 0
## [3291] 450000 0 0 0 530000 0 0
## [3298] 830000 0 0 0 330000 650000 320000
## [3305] 0 190000 0 390000 155000 300000 290000
## [3312] 0 278100 10 0 365000 327500 0
## [3319] 260000 286000 395000 395000 0 425000 365000
## [3326] 420000 0 278500 230000 0 0 380000
## [3333] 322000 350000 0 0 205000 245000 282500
## [3340] 0 0 385000 0 0 0 0
## [3347] 348888 235000 0 345000 0 345000 0
## [3354] 389100 240000 320000 320000 420000 0 0
## [3361] 380000 186929 312000 550000 0 530000 590000
## [3368] 274000 325000 0 251725 340000 369250 0
## [3375] 397000 350000 0 0 10 0 395000
## [3382] 420000 390000 210000 0 200000 0 0
## [3389] 0 0 185000 90000 102000 145000 155000
## [3396] 185000 135000 0 0 153000 159000 0
## [3403] 190000 220000 210000 318000 0 0 0
## [3410] 0 0 0 0 235000 0 399000
## [3417] 150000 800000 740000 0 0 0 745000
## [3424] 730000 0 0 660000 320000 330000 285000
## [3431] 0 325000 340000 0 304000 41000 322092
## [3438] 305000 216900 0 1195000 350000 0 0
## [3445] 347000 367000 0 0 400000 470000 0
## [3452] 0 280000 285000 0 307374 0 998550
## [3459] 763687 0 662880 899000 425000 430000 460000
## [3466] 302696 390000 669499 0 484100 0 535000
## [3473] 479500 0 0 0 385000 0 0
## [3480] 935000 388000 295000 0 0 285000 250000
## [3487] 295000 0 0 200000 275000 290000 263500
## [3494] 260000 0 0 0 270000 335000 273000
## [3501] 300000 315000 335000 287500 270000 310000 240000
## [3508] 0 325000 0 270000 265000 335000 0
## [3515] 0 0 0 0 260000 275000 467500
## [3522] 370000 513500 460000 0 390000 325000 360000
## [3529] 525000 0 687828 621285 621132 649134 630296
## [3536] 589566 495846 500916 0 0 580000 0
## [3543] 480000 465000 621132 750000 0 575000 4600000
## [3550] 420000 150000 720000 750000 0 165734 0
## [3557] 0 1108640 780000 215000 354900 0 438000
## [3564] 436020 740000 1200000 0 0 0 720000
## [3571] 0 265000 600000 480000 320000 255000 895000
## [3578] 555000 665000 0 0 0 0 348625
## [3585] 0 700000 865000 0 0 729000 100000
## [3592] 0 427000 0 460000 370000 0 0
## [3599] 0 500000 0 175000 249000 0 350000
## [3606] 447500 499999 275000 380000 410000 486950 503701
## [3613] 507000 0 280000 0 0 0 0
## [3620] 405000 379000 0 383000 303000 330000 0
## [3627] 0 439000 0 365000 0 368339 0
## [3634] 320000 220000 322000 242346 0 357500 269091
## [3641] 379000 386944 375000 0 325000 400000 375000
## [3648] 0 0 0 120666 0 0 385000
## [3655] 0 287500 410000 500 0 666953 0
## [3662] 310000 405000 317000 385000 250000 0 0
## [3669] 0 372000 445000 0 0 0 340000
## [3676] 0 420000 505000 0 200050 196100 0
## [3683] 0 0 370000 0 225000 360000 260000
## [3690] 355000 300000 0 380000 118000 0 225000
## [3697] 450000 0 0 315000 425880 416000 145000
## [3704] 651680 0 0 0 516000 0 185000
## [3711] 612477 0 0 0 440000 810000 367555
## [3718] 352450 0 0 0 0 0 300000
## [3725] 649643 182520 0 534581 0 475000 405000
## [3732] 460000 0 0 0 672045 0 0
## [3739] 350000 0 0 0 0 0 220000
## [3746] 644552 649643 210000 0 10 0 473000
## [3753] 0 365000 345000 0 256000 0 534581
## [3760] 0 0 0 760000 0 0 0
## [3767] 0 170000 0 0 0 30000000 990000
## [3774] 0 2984 0 0 0 0 102500
## [3781] 0 0 0 0 0 0 0
## [3788] 330000 0 0 327500 177000 425000 320000
## [3795] 395000 381600 0 375407 0 283128 303710
## [3802] 72000 286140 275100 0 87900 0 0
## [3809] 0 100000 65000 225000 335000 365000 150000
## [3816] 0 430950 405600 445000 165180 0 500
## [3823] 135000 257000 169680 172000 0 148000 310930
## [3830] 230000 307000 0 0 0 325000 0
## [3837] 140000 0 0 300000 0 0 0
## [3844] 0 0 90000 0 0 0 0
## [3851] 0 897000 2821000 100000 0 300000 0
## [3858] 355000 827000 600000 0 0 365000 0
## [3865] 325000 0 0 0 364000 295000 0
## [3872] 205000 0 360000 501930 465426 0 0
## [3879] 783034 787106 850000 783034 783034 783034 777943
## [3886] 7410000 7410000 0 398000 0 0 0
## [3893] 0 310000 0 470000 0 450000 0
## [3900] 400530 370000 0 431000 515000 396550 487750
## [3907] 0 392000 0 0 570000 0 459000
## [3914] 0 457500 0 575000 0 0 6000000
## [3921] 280000 0 66000 225000 203000 184041 0
## [3928] 233999 0 0 10 0 1999000 730000
## [3935] 3700000 0 0 999000 253500 0 868000
## [3942] 1800500 0 1100000 10 0 0 0
## [3949] 0 0 0 0 2600000 0 975000
## [3956] 0 0 0 0 0 0 0
## [3963] 0 0 0 362500 318000 0 232000
## [3970] 0 0 0 170000 740000 620000 570000
## [3977] 0 260000 239000 15255 0 382660 170000
## [3984] 115000 10000 177099 0 380500 120548 0
## [3991] 0 0 0 296800 183855 182500 120000
## [3998] 73000 0 0 0 0 0 0
## [4005] 0 1200000 772342 661862 934549 677136 407300
## [4012] 550000 690000 743332 10 0 0 0
## [4019] 0 875695 0 0 0 0 477500
## [4026] 260000 815000 450000 0 0 735000 0
## [4033] 265000 200000 0 315000 325000 298000 145000
## [4040] 0 0 806000 460000 770000 199000 0
## [4047] 0 840056 0 688000 0 370000 0
## [4054] 605000 430000 0 408000 0 415000 500000
## [4061] 680000 0 0 706387 0 342534 790000
## [4068] 683000 672045 0 220100 0 0 735000
## [4075] 0 0 565000 489000 0 0 490000
## [4082] 0 297500 0 322000 125000 440000 419175
## [4089] 0 15000 370000 0 0 440000 0
## [4096] 416500 0 365000 0 0 549900 827500
## [4103] 730912 0 0 710000 360000 680000 0
## [4110] 0 809508 0 26000 695000 0 0
## [4117] 700000 920000 0 0 0 0 0
## [4124] 815000 0 850000 0 0 916423 926607
## [4131] 682227 0 0 0 0 0 0
## [4138] 0 1500000 1800000 312500 560000 0 250000
## [4145] 250000 220000 200000 599000 495000 560000 450000
## [4152] 0 0 458350 290000 472500 900000 205000
## [4159] 265000 0 128000 0 0 0 0
## [4166] 0 0 26898 0 37500 0 10
## [4173] 0 0 0 0 200000 548000 0
## [4180] 275000 0 0 0 0 0 2137
## [4187] 390000 500 330000 268000 0 260000 0
## [4194] 290000 307500 334000 0 300000 0 342500
## [4201] 461370 443118 325000 460000 0 398000 390000
## [4208] 340000 375000 355000 365150 380000 345000 301750
## [4215] 339000 440000 390000 0 326250 375000 304200
## [4222] 0 350000 315000 0 0 1120000 0
## [4229] 0 0 0 0 0 0 0
## [4236] 0 1260000 0 0 0 0 0
## [4243] 0 0 0 190000 140000 0 400000
## [4250] 0 395000 125000 0 0 0 0
## [4257] 540000 515000 0 0 595000 590000 0
## [4264] 385000 0 370000 0 0 395000 615000
## [4271] 525000 460000 0 0 530000 315000 410000
## [4278] 0 0 0 200000 0 185000 0
## [4285] 120000 484500 54000 0 385000 360000 200000
## [4292] 257250 0 0 0 2600000 76557 0
## [4299] 108000 98000 519753 255000 125000 226497 249000
## [4306] 155000 220000 0 0 150000 325000 333606
## [4313] 333606 155000 346205 120000 0 0 290000
## [4320] 170000 0 250000 0 247200 145000 0
## [4327] 0 435000 135000 0 364000 0 255000
## [4334] 175422 372000 235000 210000 238290 0 0
## [4341] 211926 0 0 510000 0 425000 0
## [4348] 10 300000 163254 0 0 432000 0
## [4355] 445560 445560 445560 445560 445560 445560 300000
## [4362] 238290 0 0 316308 0 55000 222000
## [4369] 430000 0 0 300000 230000 187590 387755
## [4376] 265000 157170 0 399000 473500 0 372650
## [4383] 0 240000 235000 153114 0 275000 448000
## [4390] 170000 201400 0 0 172250 37000 0
## [4397] 0 0 0 0 0 0 0
## [4404] 165000 10 0 0 90000 155000 100000
## [4411] 158000 0 550000 3535000 400000 408961 0
## [4418] 1800000 0 200000 0 800000 0 0
## [4425] 200000 375000 0 0 0 0 382500
## [4432] 350000 252350 199000 357500 327500 0 340000
## [4439] 440000 487500 373000 460000 389000 0 216000
## [4446] 195000 370500 0 0 0 510000 0
## [4453] 370000 415000 0 0 0 0 365000
## [4460] 0 0 395000 487500 487500 298000 295000
## [4467] 0 355000 390000 409500 485000 0 315000
## [4474] 422000 0 400000 382500 370000 795000 460000
## [4481] 0 450000 0 0 0 0 0
## [4488] 510000 470000 640000 0 0 357500 0
## [4495] 433700 475000 460000 570000 505000 425000 345000
## [4502] 0 0 0 315000 0 368740 400500
## [4509] 505986 505986 498000 285000 0 0 250000
## [4516] 0 325000 470000 0 400000 410000 431000
## [4523] 0 0 465000 0 0 0 450000
## [4530] 0 0 539500 0 332000 624000 0
## [4537] 0 550000 0 180000 419000 123000 0
## [4544] 440000 0 0 350000 200000 763687 7450
## [4551] 758596 0 0 0 420000 358000 440000
## [4558] 0 0 512000 256269 0 0 0
## [4565] 0 0 0 0 0 510000 0
## [4572] 0 0 0 275000 42500 0 235000
## [4579] 0 728048 235000 0 712775 0 0
## [4586] 5250000 0 650000 0 0 1173957 0
## [4593] 363000 0 0 0 0 0 353500
## [4600] 370000 325000 590000 375000 283334 0 0
## [4607] 360000 0 470000 0 0 245000 172500
## [4614] 560000 307242 360000 0 370000 550000 477500
## [4621] 0 600000 610000 475000 365000 0 247500
## [4628] 0 460000 339625 331500 0 360000 360000
## [4635] 372500 465000 454700 750000 350000 499999 390000
## [4642] 333019 0 380000 0 0 0 0
## [4649] 647000 0 0 489850 0 0 0
## [4656] 0 0 0 0 0 0 0
## [4663] 60000 0 0 0 650000 0 514000
## [4670] 550000 400000 390000 0 224405 0 0
## [4677] 305000 0 0 0 750000 0 489000
## [4684] 0 0 763687 0 425000 270000 412191
## [4691] 455000 0 0 370000 0 0 0
## [4698] 700000 0 0 0 495000 487500 495000
## [4705] 565000 416000 0 415000 475566 465426 465426
## [4712] 465426 465426 1300000 350000 273000 295000 0
## [4719] 0 0 316000 410000 317600 0 362000
## [4726] 385000 235000 0 532500 4500000 560500 705000
## [4733] 760000 0 0 763687 755000 288250 855328
## [4740] 520000 0 0 685000 379500 471000 460000
## [4747] 486500 445000 495846 0 535000 379000 575000
## [4754] 0 650000 9000000library(plyr)
count(is.na(bk$SALE.PRICE.N))## x freq
## 1 FALSE 4756names(bk) <- tolower(names(bk))
names(bk)## [1] "borough" "neighborhood"
## [3] "building.class.category" "tax.class.at.present"
## [5] "block" "lot"
## [7] "ease.ment" "building.class.at.present"
## [9] "address" "apartment.number"
## [11] "zip.code" "residential.units"
## [13] "commercial.units" "total.units"
## [15] "land.square.feet" "gross.square.feet"
## [17] "year.built" "tax.class.at.time.of.sale"
## [19] "building.class.at.time.of.sale" "sale.price"
## [21] "sale.date" "sale.price.n"Clean/format the data with regular expressions
bk$gross.sqft <- as.numeric(gsub("[^[:digit:]]","",bk$gross.square.feet))
head(bk$gross.sqft, 20) ## [1] 1110 3000 4095 4095 2128 1854 1579 1854 1521 1536 1661 1661 1661 1816
## [15] 1816 1816 2250 2100 2100 2100bk$land.sqft <- as.numeric(gsub("[^[:digit:]]","",bk$land.square.feet))
head(bk$land.sqft, 20) ## [1] 3149 10120 10000 10000 7500 1845 1546 2358 1508 4200 1585
## [12] 1585 1585 1648 1648 1648 2490 2400 2400 2400bk$sale.date <- as.Date(bk$sale.date)
head(bk$sale.date, 20)## [1] "0002-04-20" "0010-07-20" "0006-03-20" "0006-03-20" NA
## [6] NA NA NA NA NA
## [11] "0004-05-20" "0006-10-20" NA "0002-10-20" "0011-10-20"
## [16] "0002-04-20" NA NA "0005-11-20" NAbk$year.built <- as.numeric(as.character(bk$year.built))
head(bk$year.built, 20)## [1] 2002 1985 1991 1991 1970 1986 1986 1986 1986 1970 2004 2004 2004 2003
## [15] 2003 2003 2004 2004 2004 2004Do a bit of exploration to make sure there’s not anything weird going on with sale prices
attach(bk)
hist(sale.price.n)
hist(sale.price.n[sale.price.n>0])
hist(gross.sqft[sale.price.n==0])
detach(bk)Keep only the actual sales
bk.sale <- bk[bk$sale.price.n!=0,]
head(bk.sale, 20)## borough neighborhood
## 1 5 ANNADALE
## 6 5 ANNADALE
## 8 5 ANNADALE
## 9 5 ANNADALE
## 10 5 ANNADALE
## 11 5 ANNADALE
## 12 5 ANNADALE
## 13 5 ANNADALE
## 14 5 ANNADALE
## 15 5 ANNADALE
## 17 5 ANNADALE
## 20 5 ANNADALE
## 21 5 ANNADALE
## 22 5 ANNADALE
## 23 5 ANNADALE
## 24 5 ANNADALE
## 26 5 ANNADALE
## 27 5 ANNADALE
## 29 5 ANNADALE
## 30 5 ANNADALE
## building.class.category tax.class.at.present block
## 1 01 ONE FAMILY HOMES 1 5391
## 6 01 ONE FAMILY HOMES 1 6205
## 8 01 ONE FAMILY HOMES 1 6205
## 9 01 ONE FAMILY HOMES 1 6211
## 10 01 ONE FAMILY HOMES 1 6212
## 11 01 ONE FAMILY HOMES 1 6220
## 12 01 ONE FAMILY HOMES 1 6220
## 13 01 ONE FAMILY HOMES 1 6220
## 14 01 ONE FAMILY HOMES 1 6220
## 15 01 ONE FAMILY HOMES 1 6220
## 17 01 ONE FAMILY HOMES 1 6222
## 20 01 ONE FAMILY HOMES 1 6222
## 21 01 ONE FAMILY HOMES 1 6226
## 22 01 ONE FAMILY HOMES 1 6227
## 23 01 ONE FAMILY HOMES 1 6232
## 24 01 ONE FAMILY HOMES 1 6232
## 26 01 ONE FAMILY HOMES 1 6234
## 27 01 ONE FAMILY HOMES 1 6237
## 29 01 ONE FAMILY HOMES 1 6247
## 30 01 ONE FAMILY HOMES 1 6249
## lot ease.ment building.class.at.present
## 1 8 A5
## 6 13 A5
## 8 32 A5
## 9 22 A5
## 10 89 A1
## 11 10 A5
## 12 11 A5
## 13 14 A5
## 14 63 A5
## 15 68 A5
## 17 33 A5
## 20 48 A5
## 21 1 A1
## 22 71 A1
## 23 11 A1
## 24 50 A1
## 26 7 A1
## 27 22 A5
## 29 34 A1
## 30 200 A1
## address apartment.number zip.code
## 1 4730 AMBOY ROAD 10312
## 6 99 EAGAN AVENUE 10312
## 8 63 EAGAN AVENUE 10312
## 9 5 EAGAN AVENUE 10312
## 10 1094 ARDEN AVENUE 10312
## 11 53 BARB STREET 10312
## 12 51 BARB STREET 10312
## 13 45 BARB STREET 10312
## 14 40 ENDVIEW STREET 10312
## 15 52 ENDVIEW STREET 10312
## 17 58 JEANNETTE AVENUE 10312
## 20 27 LORRAINE AVENUE 10312
## 21 808 ARDEN AVENUE 10312
## 22 944 CARLTON BOULEVARD 10312
## 23 182 RATHBUN AVENUE 10312
## 24 630 ARDEN AVENUE 10312
## 26 329 JEFFERSON BOULEVARD 10312
## 27 214 VINELAND AVENUE 10312
## 29 1037 ANNADALE ROAD 10312
## 30 1026 ANNADALE ROAD 10312
## residential.units commercial.units total.units land.square.feet
## 1 1 0 1 3,149
## 6 1 0 1 1,845
## 8 1 0 1 2,358
## 9 1 0 1 1,508
## 10 1 0 1 4,200
## 11 1 0 1 1,585
## 12 1 0 1 1,585
## 13 1 0 1 1,585
## 14 1 0 1 1,648
## 15 1 0 1 1,648
## 17 1 0 1 2,490
## 20 1 0 1 2,400
## 21 1 0 1 6,450
## 22 1 0 1 4,125
## 23 1 0 1 4,000
## 24 1 0 1 3,480
## 26 1 0 1 4,000
## 27 1 0 1 4,000
## 29 1 0 1 5,000
## 30 1 0 1 30,912
## gross.square.feet year.built tax.class.at.time.of.sale
## 1 1,110 2002 1
## 6 1,854 1986 1
## 8 1,854 1986 1
## 9 1,521 1986 1
## 10 1,536 1970 1
## 11 1,661 2004 1
## 12 1,661 2004 1
## 13 1,661 2004 1
## 14 1,816 2003 1
## 15 1,816 2003 1
## 17 2,250 2004 1
## 20 2,100 2004 1
## 21 1,648 1925 1
## 22 1,408 1935 1
## 23 1,630 1960 1
## 24 1,664 1980 1
## 26 2,178 1965 1
## 27 2,350 2005 1
## 29 1,693 1910 1
## 30 1,598 1945 1
## building.class.at.time.of.sale sale.price sale.date sale.price.n
## 1 A5 $450,000 0002-04-20 450000
## 6 A5 $338,000 <NA> 338000
## 8 A5 $180,455 <NA> 180455
## 9 A5 $345,000 <NA> 345000
## 10 A1 $410,000 <NA> 410000
## 11 A5 $414,000 0004-05-20 414000
## 12 A5 $410,000 0006-10-20 410000
## 13 A5 $415,000 <NA> 415000
## 14 A5 $426,000 0002-10-20 426000
## 15 A5 $380,000 0011-10-20 380000
## 17 A5 $517,000 <NA> 517000
## 20 A5 $470,000 <NA> 470000
## 21 A1 $352,500 <NA> 352500
## 22 A1 $473,000 <NA> 473000
## 23 A1 $440,000 0001-03-20 440000
## 24 A1 $340,000 <NA> 340000
## 26 A1 $425,000 <NA> 425000
## 27 A5 $775,000 0012-06-20 775000
## 29 A1 $340,000 <NA> 340000
## 30 A1 $725,000 0007-07-20 725000
## gross.sqft land.sqft
## 1 1110 3149
## 6 1854 1845
## 8 1854 2358
## 9 1521 1508
## 10 1536 4200
## 11 1661 1585
## 12 1661 1585
## 13 1661 1585
## 14 1816 1648
## 15 1816 1648
## 17 2250 2490
## 20 2100 2400
## 21 1648 6450
## 22 1408 4125
## 23 1630 4000
## 24 1664 3480
## 26 2178 4000
## 27 2350 4000
## 29 1693 5000
## 30 1598 30912plot(bk.sale$gross.sqft,bk.sale$sale.price.n)
plot(log(bk.sale$gross.sqft),log(bk.sale$sale.price.n))
#For now, let’s look at 1-, 2-, and 3-family homes
bk.homes <- bk.sale[which(grepl("FAMILY",bk.sale$building.class.category)),]
head(bk.homes, 20)## borough neighborhood
## 1 5 ANNADALE
## 6 5 ANNADALE
## 8 5 ANNADALE
## 9 5 ANNADALE
## 10 5 ANNADALE
## 11 5 ANNADALE
## 12 5 ANNADALE
## 13 5 ANNADALE
## 14 5 ANNADALE
## 15 5 ANNADALE
## 17 5 ANNADALE
## 20 5 ANNADALE
## 21 5 ANNADALE
## 22 5 ANNADALE
## 23 5 ANNADALE
## 24 5 ANNADALE
## 26 5 ANNADALE
## 27 5 ANNADALE
## 29 5 ANNADALE
## 30 5 ANNADALE
## building.class.category tax.class.at.present block
## 1 01 ONE FAMILY HOMES 1 5391
## 6 01 ONE FAMILY HOMES 1 6205
## 8 01 ONE FAMILY HOMES 1 6205
## 9 01 ONE FAMILY HOMES 1 6211
## 10 01 ONE FAMILY HOMES 1 6212
## 11 01 ONE FAMILY HOMES 1 6220
## 12 01 ONE FAMILY HOMES 1 6220
## 13 01 ONE FAMILY HOMES 1 6220
## 14 01 ONE FAMILY HOMES 1 6220
## 15 01 ONE FAMILY HOMES 1 6220
## 17 01 ONE FAMILY HOMES 1 6222
## 20 01 ONE FAMILY HOMES 1 6222
## 21 01 ONE FAMILY HOMES 1 6226
## 22 01 ONE FAMILY HOMES 1 6227
## 23 01 ONE FAMILY HOMES 1 6232
## 24 01 ONE FAMILY HOMES 1 6232
## 26 01 ONE FAMILY HOMES 1 6234
## 27 01 ONE FAMILY HOMES 1 6237
## 29 01 ONE FAMILY HOMES 1 6247
## 30 01 ONE FAMILY HOMES 1 6249
## lot ease.ment building.class.at.present
## 1 8 A5
## 6 13 A5
## 8 32 A5
## 9 22 A5
## 10 89 A1
## 11 10 A5
## 12 11 A5
## 13 14 A5
## 14 63 A5
## 15 68 A5
## 17 33 A5
## 20 48 A5
## 21 1 A1
## 22 71 A1
## 23 11 A1
## 24 50 A1
## 26 7 A1
## 27 22 A5
## 29 34 A1
## 30 200 A1
## address apartment.number zip.code
## 1 4730 AMBOY ROAD 10312
## 6 99 EAGAN AVENUE 10312
## 8 63 EAGAN AVENUE 10312
## 9 5 EAGAN AVENUE 10312
## 10 1094 ARDEN AVENUE 10312
## 11 53 BARB STREET 10312
## 12 51 BARB STREET 10312
## 13 45 BARB STREET 10312
## 14 40 ENDVIEW STREET 10312
## 15 52 ENDVIEW STREET 10312
## 17 58 JEANNETTE AVENUE 10312
## 20 27 LORRAINE AVENUE 10312
## 21 808 ARDEN AVENUE 10312
## 22 944 CARLTON BOULEVARD 10312
## 23 182 RATHBUN AVENUE 10312
## 24 630 ARDEN AVENUE 10312
## 26 329 JEFFERSON BOULEVARD 10312
## 27 214 VINELAND AVENUE 10312
## 29 1037 ANNADALE ROAD 10312
## 30 1026 ANNADALE ROAD 10312
## residential.units commercial.units total.units land.square.feet
## 1 1 0 1 3,149
## 6 1 0 1 1,845
## 8 1 0 1 2,358
## 9 1 0 1 1,508
## 10 1 0 1 4,200
## 11 1 0 1 1,585
## 12 1 0 1 1,585
## 13 1 0 1 1,585
## 14 1 0 1 1,648
## 15 1 0 1 1,648
## 17 1 0 1 2,490
## 20 1 0 1 2,400
## 21 1 0 1 6,450
## 22 1 0 1 4,125
## 23 1 0 1 4,000
## 24 1 0 1 3,480
## 26 1 0 1 4,000
## 27 1 0 1 4,000
## 29 1 0 1 5,000
## 30 1 0 1 30,912
## gross.square.feet year.built tax.class.at.time.of.sale
## 1 1,110 2002 1
## 6 1,854 1986 1
## 8 1,854 1986 1
## 9 1,521 1986 1
## 10 1,536 1970 1
## 11 1,661 2004 1
## 12 1,661 2004 1
## 13 1,661 2004 1
## 14 1,816 2003 1
## 15 1,816 2003 1
## 17 2,250 2004 1
## 20 2,100 2004 1
## 21 1,648 1925 1
## 22 1,408 1935 1
## 23 1,630 1960 1
## 24 1,664 1980 1
## 26 2,178 1965 1
## 27 2,350 2005 1
## 29 1,693 1910 1
## 30 1,598 1945 1
## building.class.at.time.of.sale sale.price sale.date sale.price.n
## 1 A5 $450,000 0002-04-20 450000
## 6 A5 $338,000 <NA> 338000
## 8 A5 $180,455 <NA> 180455
## 9 A5 $345,000 <NA> 345000
## 10 A1 $410,000 <NA> 410000
## 11 A5 $414,000 0004-05-20 414000
## 12 A5 $410,000 0006-10-20 410000
## 13 A5 $415,000 <NA> 415000
## 14 A5 $426,000 0002-10-20 426000
## 15 A5 $380,000 0011-10-20 380000
## 17 A5 $517,000 <NA> 517000
## 20 A5 $470,000 <NA> 470000
## 21 A1 $352,500 <NA> 352500
## 22 A1 $473,000 <NA> 473000
## 23 A1 $440,000 0001-03-20 440000
## 24 A1 $340,000 <NA> 340000
## 26 A1 $425,000 <NA> 425000
## 27 A5 $775,000 0012-06-20 775000
## 29 A1 $340,000 <NA> 340000
## 30 A1 $725,000 0007-07-20 725000
## gross.sqft land.sqft
## 1 1110 3149
## 6 1854 1845
## 8 1854 2358
## 9 1521 1508
## 10 1536 4200
## 11 1661 1585
## 12 1661 1585
## 13 1661 1585
## 14 1816 1648
## 15 1816 1648
## 17 2250 2490
## 20 2100 2400
## 21 1648 6450
## 22 1408 4125
## 23 1630 4000
## 24 1664 3480
## 26 2178 4000
## 27 2350 4000
## 29 1693 5000
## 30 1598 30912dim(bk.homes)## [1] 2231 24plot(log(bk.homes$gross.sqft),log(bk.homes$sale.price.n))
summary(bk.homes[which(bk.homes$sale.price.n<100000),])## borough neighborhood
## Min. :5 PORT RICHMOND : 9
## 1st Qu.:5 GREAT KILLS : 8
## Median :5 MARINERS HARBOR : 6
## Mean :5 NEW BRIGHTON : 6
## 3rd Qu.:5 WEST NEW BRIGHTON : 5
## Max. :5 BULLS HEAD : 4
## (Other) :46
## building.class.category
## 01 ONE FAMILY HOMES :49
## 02 TWO FAMILY HOMES :33
## 03 THREE FAMILY HOMES : 2
## 04 TAX CLASS 1 CONDOS : 0
## 05 TAX CLASS 1 VACANT LAND : 0
## 06 TAX CLASS 1 - OTHER : 0
## (Other) : 0
## tax.class.at.present block lot ease.ment
## 1 :84 Min. : 22.0 Min. : 1.00 :84
## : 0 1st Qu.: 668.5 1st Qu.: 22.75 E: 0
## 1A : 0 Median :1657.0 Median : 46.00
## 1B : 0 Mean :2580.6 Mean : 69.63
## 1C : 0 3rd Qu.:4332.5 3rd Qu.: 82.75
## 2 : 0 Max. :8025.0 Max. :433.00
## (Other): 0
## building.class.at.present
## A1 :21
## B2 :20
## A2 :14
## A5 : 9
## B9 : 7
## A9 : 4
## (Other): 9
## address apartment.number
## 11 ANN STREET : 2 :84
## 100 DRIGGS STREET : 1 02C : 0
## 100 GROVE AVENUE : 1 02G : 0
## 102 FIELDWAY AVENUE : 1 1 : 0
## 1024 ARTHUR KILL ROAD : 1 10 : 0
## 107 BARBARA STREET : 1 103 : 0
## (Other) :77 (Other) : 0
## zip.code residential.units commercial.units total.units
## Min. :10301 Min. :1.000 Min. :0 Min. :1.000
## 1st Qu.:10303 1st Qu.:1.000 1st Qu.:0 1st Qu.:1.000
## Median :10306 Median :1.000 Median :0 Median :1.000
## Mean :10306 Mean :1.405 Mean :0 Mean :1.405
## 3rd Qu.:10308 3rd Qu.:2.000 3rd Qu.:0 3rd Qu.:2.000
## Max. :10314 Max. :3.000 Max. :0 Max. :3.000
##
## land.square.feet gross.square.feet year.built
## 2,500 : 9 1,296 : 3 Min. :1899
## 4,000 : 3 1,024 : 2 1st Qu.:1920
## 5,000 : 3 1,200 : 2 Median :1950
## 6,000 : 3 1,565 : 2 Mean :1952
## 2,000 : 2 1,800 : 2 3rd Qu.:1985
## 2,610 : 2 1,890 : 2 Max. :2010
## (Other):62 (Other):71
## tax.class.at.time.of.sale building.class.at.time.of.sale sale.price
## Min. :1 B2 :21 $10 :25
## 1st Qu.:1 A1 :19 $500 : 5
## Median :1 A2 :13 $1 : 3
## Mean :1 A5 : 9 $10,000: 3
## 3rd Qu.:1 B9 : 9 $60,000: 3
## Max. :1 A9 : 4 $85,000: 3
## (Other): 9 (Other):42
## sale.date sale.price.n gross.sqft land.sqft
## Min. :0001-03-20 Min. : 1 Min. : 432 Min. : 700
## 1st Qu.:0002-03-13 1st Qu.: 10 1st Qu.:1222 1st Qu.: 2500
## Median :0005-03-21 Median :18250 Median :1636 Median : 3432
## Mean :0005-07-24 Mean :33796 Mean :1749 Mean : 3983
## 3rd Qu.:0007-08-19 3rd Qu.:65232 3rd Qu.:2204 3rd Qu.: 4597
## Max. :0012-12-20 Max. :98000 Max. :4160 Max. :15605
## NA's :48Remove outliers that seem like they weren’t actual sales
bk.homes$outliers <- (log(bk.homes$sale.price.n) <=5) + 0
head(bk.homes$outliers, 20)## [1] 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0bk.homes <- bk.homes[which(bk.homes$outliers==0),]
head(bk.homes, 100)## borough neighborhood
## 1 5 ANNADALE
## 6 5 ANNADALE
## 8 5 ANNADALE
## 9 5 ANNADALE
## 10 5 ANNADALE
## 11 5 ANNADALE
## 12 5 ANNADALE
## 13 5 ANNADALE
## 14 5 ANNADALE
## 15 5 ANNADALE
## 17 5 ANNADALE
## 20 5 ANNADALE
## 21 5 ANNADALE
## 22 5 ANNADALE
## 23 5 ANNADALE
## 24 5 ANNADALE
## 26 5 ANNADALE
## 27 5 ANNADALE
## 29 5 ANNADALE
## 30 5 ANNADALE
## 31 5 ANNADALE
## 32 5 ANNADALE
## 33 5 ANNADALE
## 34 5 ANNADALE
## 36 5 ANNADALE
## 38 5 ANNADALE
## 40 5 ANNADALE
## 43 5 ANNADALE
## 45 5 ANNADALE
## 46 5 ANNADALE
## 47 5 ANNADALE
## 49 5 ANNADALE
## 50 5 ANNADALE
## 53 5 ANNADALE
## 54 5 ANNADALE
## 56 5 ANNADALE
## 59 5 ANNADALE
## 60 5 ANNADALE
## 62 5 ANNADALE
## 65 5 ANNADALE
## 66 5 ANNADALE
## 67 5 ANNADALE
## 72 5 ANNADALE
## 74 5 ANNADALE
## 75 5 ANNADALE
## 76 5 ANNADALE
## 78 5 ANNADALE
## 80 5 ANNADALE
## 81 5 ANNADALE
## 83 5 ANNADALE
## 85 5 ANNADALE
## 86 5 ANNADALE
## 87 5 ANNADALE
## 88 5 ANNADALE
## 102 5 ARDEN HEIGHTS
## 103 5 ARDEN HEIGHTS
## 104 5 ARDEN HEIGHTS
## 105 5 ARDEN HEIGHTS
## 106 5 ARDEN HEIGHTS
## 107 5 ARDEN HEIGHTS
## 108 5 ARDEN HEIGHTS
## 109 5 ARDEN HEIGHTS
## 110 5 ARDEN HEIGHTS
## 111 5 ARDEN HEIGHTS
## 121 5 ARDEN HEIGHTS
## 128 5 ARDEN HEIGHTS
## 153 5 ARDEN HEIGHTS
## 169 5 ARDEN HEIGHTS
## 171 5 ARDEN HEIGHTS
## 173 5 ARDEN HEIGHTS
## 177 5 ARDEN HEIGHTS
## 179 5 ARDEN HEIGHTS
## 181 5 ARDEN HEIGHTS
## 183 5 ARDEN HEIGHTS
## 186 5 ARDEN HEIGHTS
## 188 5 ARDEN HEIGHTS
## 189 5 ARDEN HEIGHTS
## 190 5 ARDEN HEIGHTS
## 191 5 ARDEN HEIGHTS
## 192 5 ARDEN HEIGHTS
## 193 5 ARDEN HEIGHTS
## 194 5 ARDEN HEIGHTS
## 195 5 ARDEN HEIGHTS
## 196 5 ARDEN HEIGHTS
## 197 5 ARDEN HEIGHTS
## 198 5 ARDEN HEIGHTS
## 199 5 ARDEN HEIGHTS
## 200 5 ARDEN HEIGHTS
## 201 5 ARDEN HEIGHTS
## 203 5 ARDEN HEIGHTS
## 205 5 ARDEN HEIGHTS
## 206 5 ARDEN HEIGHTS
## 207 5 ARDEN HEIGHTS
## 208 5 ARDEN HEIGHTS
## 209 5 ARDEN HEIGHTS
## 210 5 ARDEN HEIGHTS
## 211 5 ARDEN HEIGHTS
## 212 5 ARDEN HEIGHTS
## 213 5 ARDEN HEIGHTS
## 214 5 ARDEN HEIGHTS
## building.class.category tax.class.at.present
## 1 01 ONE FAMILY HOMES 1
## 6 01 ONE FAMILY HOMES 1
## 8 01 ONE FAMILY HOMES 1
## 9 01 ONE FAMILY HOMES 1
## 10 01 ONE FAMILY HOMES 1
## 11 01 ONE FAMILY HOMES 1
## 12 01 ONE FAMILY HOMES 1
## 13 01 ONE FAMILY HOMES 1
## 14 01 ONE FAMILY HOMES 1
## 15 01 ONE FAMILY HOMES 1
## 17 01 ONE FAMILY HOMES 1
## 20 01 ONE FAMILY HOMES 1
## 21 01 ONE FAMILY HOMES 1
## 22 01 ONE FAMILY HOMES 1
## 23 01 ONE FAMILY HOMES 1
## 24 01 ONE FAMILY HOMES 1
## 26 01 ONE FAMILY HOMES 1
## 27 01 ONE FAMILY HOMES 1
## 29 01 ONE FAMILY HOMES 1
## 30 01 ONE FAMILY HOMES 1
## 31 01 ONE FAMILY HOMES 1B
## 32 01 ONE FAMILY HOMES 1
## 33 01 ONE FAMILY HOMES 1
## 34 01 ONE FAMILY HOMES 1
## 36 01 ONE FAMILY HOMES 1
## 38 01 ONE FAMILY HOMES 1
## 40 01 ONE FAMILY HOMES 1
## 43 01 ONE FAMILY HOMES 1
## 45 01 ONE FAMILY HOMES 1
## 46 01 ONE FAMILY HOMES 1
## 47 01 ONE FAMILY HOMES 1
## 49 01 ONE FAMILY HOMES 1
## 50 01 ONE FAMILY HOMES 1
## 53 01 ONE FAMILY HOMES 1
## 54 01 ONE FAMILY HOMES 1
## 56 01 ONE FAMILY HOMES 1
## 59 01 ONE FAMILY HOMES 1
## 60 01 ONE FAMILY HOMES 1
## 62 01 ONE FAMILY HOMES 1
## 65 01 ONE FAMILY HOMES 1
## 66 01 ONE FAMILY HOMES 1
## 67 01 ONE FAMILY HOMES 1
## 72 02 TWO FAMILY HOMES 1
## 74 02 TWO FAMILY HOMES 1
## 75 02 TWO FAMILY HOMES 1
## 76 02 TWO FAMILY HOMES 1
## 78 02 TWO FAMILY HOMES 1
## 80 02 TWO FAMILY HOMES 1
## 81 02 TWO FAMILY HOMES 1
## 83 02 TWO FAMILY HOMES 1
## 85 02 TWO FAMILY HOMES 1
## 86 02 TWO FAMILY HOMES 1
## 87 02 TWO FAMILY HOMES 1
## 88 02 TWO FAMILY HOMES 1
## 102 01 ONE FAMILY HOMES 1
## 103 01 ONE FAMILY HOMES 1
## 104 01 ONE FAMILY HOMES 1
## 105 01 ONE FAMILY HOMES 1
## 106 01 ONE FAMILY HOMES 1
## 107 01 ONE FAMILY HOMES 1
## 108 01 ONE FAMILY HOMES 1
## 109 01 ONE FAMILY HOMES 1
## 110 01 ONE FAMILY HOMES 1
## 111 01 ONE FAMILY HOMES 1
## 121 01 ONE FAMILY HOMES 1
## 128 01 ONE FAMILY HOMES 1
## 153 01 ONE FAMILY HOMES 1
## 169 01 ONE FAMILY HOMES 1
## 171 01 ONE FAMILY HOMES 1
## 173 01 ONE FAMILY HOMES 1
## 177 01 ONE FAMILY HOMES 1
## 179 01 ONE FAMILY HOMES 1
## 181 01 ONE FAMILY HOMES 1
## 183 01 ONE FAMILY HOMES 1
## 186 01 ONE FAMILY HOMES 1
## 188 01 ONE FAMILY HOMES 1
## 189 01 ONE FAMILY HOMES 1
## 190 01 ONE FAMILY HOMES 1
## 191 01 ONE FAMILY HOMES 1
## 192 01 ONE FAMILY HOMES 1
## 193 01 ONE FAMILY HOMES 1
## 194 01 ONE FAMILY HOMES 1
## 195 01 ONE FAMILY HOMES 1
## 196 01 ONE FAMILY HOMES 1
## 197 01 ONE FAMILY HOMES 1
## 198 01 ONE FAMILY HOMES 1
## 199 01 ONE FAMILY HOMES 1
## 200 01 ONE FAMILY HOMES 1
## 201 01 ONE FAMILY HOMES 1
## 203 01 ONE FAMILY HOMES 1
## 205 01 ONE FAMILY HOMES 1
## 206 01 ONE FAMILY HOMES 1
## 207 01 ONE FAMILY HOMES 1
## 208 01 ONE FAMILY HOMES 1
## 209 01 ONE FAMILY HOMES 1
## 210 01 ONE FAMILY HOMES 1
## 211 01 ONE FAMILY HOMES 1
## 212 01 ONE FAMILY HOMES 1
## 213 01 ONE FAMILY HOMES 1
## 214 01 ONE FAMILY HOMES 1
## block lot ease.ment building.class.at.present
## 1 5391 8 A5
## 6 6205 13 A5
## 8 6205 32 A5
## 9 6211 22 A5
## 10 6212 89 A1
## 11 6220 10 A5
## 12 6220 11 A5
## 13 6220 14 A5
## 14 6220 63 A5
## 15 6220 68 A5
## 17 6222 33 A5
## 20 6222 48 A5
## 21 6226 1 A1
## 22 6227 71 A1
## 23 6232 11 A1
## 24 6232 50 A1
## 26 6234 7 A1
## 27 6237 22 A5
## 29 6247 34 A1
## 30 6249 200 A1
## 31 6249 214 V0
## 32 6249 604 B2
## 33 6249 606 B2
## 34 6251 12 A1
## 36 6252 30 A1
## 38 6257 90 A2
## 40 6259 10 A1
## 43 6277 21 A1
## 45 6278 1 A2
## 46 6281 10 A1
## 47 6281 40 A2
## 49 6298 21 A2
## 50 6300 63 A1
## 53 6364 1 A1
## 54 6367 44 A1
## 56 6401 18 A1
## 59 6417 33 A1
## 60 6421 78 A1
## 62 6475 265 A3
## 65 6511 22 A1
## 66 6517 225 A1
## 67 6523 76 B2
## 72 6233 47 B2
## 74 6249 245 B2
## 75 6249 247 B2
## 76 6252 27 B2
## 78 6265 39 B2
## 80 6302 1 B2
## 81 6304 31 B1
## 83 6305 114 B1
## 85 6360 57 B9
## 86 6407 42 B9
## 87 6455 3 B2
## 88 6475 515 B2
## 102 5724 83 A5
## 103 5725 42 A5
## 104 5725 48 A1
## 105 5725 184 A5
## 106 5726 48 A9
## 107 5726 82 A5
## 108 5727 39 A5
## 109 5727 98 A5
## 110 5727 99 A5
## 111 5727 117 A5
## 121 5735 338 A5
## 128 5735 351 A5
## 153 5735 406 A5
## 169 5735 425 A5
## 171 5735 426 A5
## 173 5735 427 A5
## 177 5735 432 A5
## 179 5735 433 A5
## 181 5735 434 A5
## 183 5735 435 A5
## 186 5735 440 A5
## 188 5740 7 A5
## 189 5740 17 A5
## 190 5740 49 A5
## 191 5740 97 A5
## 192 5740 102 A5
## 193 5740 104 A5
## 194 5740 143 A5
## 195 5740 152 A5
## 196 5740 169 A5
## 197 5740 171 A5
## 198 5740 186 A5
## 199 5740 187 A5
## 200 5740 188 A5
## 201 5741 9 A5
## 203 5741 96 A5
## 205 5741 253 A5
## 206 5742 17 A5
## 207 5742 20 A5
## 208 5742 41 A5
## 209 5742 71 A5
## 210 5742 78 A5
## 211 5742 79 A5
## 212 5742 103 A5
## 213 5743 14 A5
## 214 5743 123 A5
## address apartment.number zip.code
## 1 4730 AMBOY ROAD 10312
## 6 99 EAGAN AVENUE 10312
## 8 63 EAGAN AVENUE 10312
## 9 5 EAGAN AVENUE 10312
## 10 1094 ARDEN AVENUE 10312
## 11 53 BARB STREET 10312
## 12 51 BARB STREET 10312
## 13 45 BARB STREET 10312
## 14 40 ENDVIEW STREET 10312
## 15 52 ENDVIEW STREET 10312
## 17 58 JEANNETTE AVENUE 10312
## 20 27 LORRAINE AVENUE 10312
## 21 808 ARDEN AVENUE 10312
## 22 944 CARLTON BOULEVARD 10312
## 23 182 RATHBUN AVENUE 10312
## 24 630 ARDEN AVENUE 10312
## 26 329 JEFFERSON BOULEVARD 10312
## 27 214 VINELAND AVENUE 10312
## 29 1037 ANNADALE ROAD 10312
## 30 1026 ANNADALE ROAD 10312
## 31 1002 ANNADALE ROAD 10312
## 32 86 BENNETT AVENUE 10312
## 33 82 BENNETT AVENUE 10312
## 34 80 DOWNES AVENUE 10312
## 36 6 BUFFINGTON AVENUE 10312
## 38 10 BURCHARD COURT 10312
## 40 250 DETROIT AVENUE 10312
## 43 315 DETROIT AVENUE 10312
## 45 275 EDGEGROVE AVENUE 10312
## 46 876 DRUMGOOLE ROAD EAST 10312
## 47 387 EDGEGROVE AVENUE 10312
## 49 78 RAMONA AVENUE 10312
## 50 441 RATHBUN AVENUE 10312
## 53 573 BARCLAY AVENUE 10312
## 54 301 SHIRLEY AVENUE 10312
## 56 39 ALLEN PLACE 10312
## 59 145 LIPSETT AVENUE 10312
## 60 232 TALLMAN STREET 10312
## 62 6 NICOLOSI LOOP 10312
## 65 16 RUGGLES STREET 10312
## 66 30 GENTILE COURT 10312
## 67 ARBUTUS AVENUE 10312
## 72 600 ARDEN AVENUE 10312
## 74 128 NORTH PINE TERRACE 10312
## 75 132 NORTH PINE TERRACE 10312
## 76 10 BUFFINGTON AVENUE 10312
## 78 286 JEFFERSON BOULEVARD 10312
## 80 460 SINCLAIR AVENUE 10312
## 81 370 VINELAND AVENUE 10312
## 83 375 VINELAND AVENUE 10312
## 85 56 RYAN PLACE 10312
## 86 438 SHIRLEY AVENUE 10312
## 87 12 LYNCH STREET 10312
## 88 361 ARBUTUS AVENUE 10312
## 102 32 BILLINGS STREET 10312
## 103 32 WINSTON STREET 10312
## 104 18 WINSTON STREET 10312
## 105 36 HINTON STREET 10312
## 106 18 BENSON STREET 10312
## 107 1274 ARTHUR KILL ROAD 10312
## 108 106 KENILWORTH AVENUE 10312
## 109 208 KENILWORTH AVENUE 10312
## 110 210 KENILWORTH AVENUE 10312
## 111 52 KENILWORTH AVENUE 10312
## 121 168 PRESENTATION CIRCLE 10312
## 128 200 PRESENTATION CIRCLE 10312
## 153 100 PRESENTATION CIRCLE 10312
## 169 101 PRESENTATION CIRCLE 10312
## 171 103 PRESENTATION CIRCLE 10312
## 173 105 PRESENTATION CIRCLE 10312
## 177 115 PRESENTATION CIRCLE 10312
## 179 117 PRESENTATION CIRCLE 10312
## 181 119 PRESENTATION CIRCLE 10312
## 183 121 PRESENTATION CIRCLE 10312
## 186 125 PRESENTATION CIRCLE 10312
## 188 61 ILYSSA WAY 10312
## 189 85 ILYSSA WAY 10312
## 190 365 ASPEN KNOLLS WAY 10312
## 191 285 ASPEN KNOLLS WAY 10312
## 192 235 ASPEN KNOLLS WAY 10312
## 193 231 ASPEN KNOLLS WAY 10312
## 194 97 ASPEN KNOLLS WAY 10312
## 195 79 ASPEN KNOLLS WAY 10312
## 196 38 BIANCA COURT 10312
## 197 44 BIANCA COURT 10312
## 198 1290 ARTHUR KILL ROAD 10312
## 199 1292 ARTHUR KILL ROAD 10312
## 200 51 BIANCA COURT 10312
## 201 56 ILYSSA WAY 10312
## 203 274 ILYSSA WAY 10312
## 205 708 ILYSSA WAY 10312
## 206 284 ASPEN KNOLLS WAY 10312
## 207 290 ASPEN KNOLLS WAY 10312
## 208 384 ASPEN KNOLLS WAY 10312
## 209 190 JAMIE LANE 10312
## 210 170 JAMIE LANE 10312
## 211 168 JAMIE LANE 10312
## 212 226 ASPEN KNOLLS WAY 10312
## 213 707 ILYSSA WAY 10312
## 214 83 EMILY LANE 10312
## residential.units commercial.units total.units land.square.feet
## 1 1 0 1 3,149
## 6 1 0 1 1,845
## 8 1 0 1 2,358
## 9 1 0 1 1,508
## 10 1 0 1 4,200
## 11 1 0 1 1,585
## 12 1 0 1 1,585
## 13 1 0 1 1,585
## 14 1 0 1 1,648
## 15 1 0 1 1,648
## 17 1 0 1 2,490
## 20 1 0 1 2,400
## 21 1 0 1 6,450
## 22 1 0 1 4,125
## 23 1 0 1 4,000
## 24 1 0 1 3,480
## 26 1 0 1 4,000
## 27 1 0 1 4,000
## 29 1 0 1 5,000
## 30 1 0 1 30,912
## 31 1 0 1 40,000
## 32 2 0 2 3,912
## 33 2 0 2 3,911
## 34 1 0 1 4,000
## 36 1 0 1 4,000
## 38 1 0 1 6,138
## 40 1 0 1 8,000
## 43 1 0 1 6,000
## 45 1 0 1 4,900
## 46 1 0 1 4,212
## 47 1 0 1 6,000
## 49 1 0 1 4,000
## 50 1 0 1 4,000
## 53 1 0 1 7,000
## 54 1 0 1 8,000
## 56 1 0 1 6,000
## 59 1 0 1 4,400
## 60 1 0 1 8,000
## 62 1 0 1 11,100
## 65 1 0 1 7,500
## 66 1 0 1 13,950
## 67 2 0 2 5,811
## 72 2 0 2 6,000
## 74 2 0 2 4,000
## 75 2 0 2 4,000
## 76 2 0 2 6,000
## 78 2 0 2 6,000
## 80 2 0 2 4,800
## 81 2 0 2 5,900
## 83 2 0 2 10,000
## 85 2 0 2 6,000
## 86 2 0 2 8,534
## 87 2 0 2 4,780
## 88 2 0 2 13,650
## 102 1 0 1 2,600
## 103 1 0 1 2,900
## 104 1 0 1 4,000
## 105 1 0 1 2,658
## 106 1 0 1 2,000
## 107 1 0 1 3,350
## 108 1 0 1 1,275
## 109 1 0 1 1,366
## 110 1 0 1 1,366
## 111 1 0 1 2,426
## 121 1 0 1 1,975
## 128 1 0 1 3,716
## 153 1 0 1 1,972
## 169 1 0 1 1,972
## 171 1 0 1 1,972
## 173 1 0 1 1,972
## 177 1 0 1 3,439
## 179 1 0 1 1,972
## 181 1 0 1 1,972
## 183 1 0 1 1,972
## 186 1 0 1 4,240
## 188 1 0 1 500
## 189 1 0 1 560
## 190 1 0 1 353
## 191 1 0 1 500
## 192 1 0 1 500
## 193 1 0 1 500
## 194 1 0 1 353
## 195 1 0 1 500
## 196 1 0 1 500
## 197 1 0 1 560
## 198 1 0 1 500
## 199 1 0 1 500
## 200 1 0 1 500
## 201 1 0 1 500
## 203 1 0 1 560
## 205 1 0 1 500
## 206 1 0 1 560
## 207 1 0 1 560
## 208 1 0 1 353
## 209 1 0 1 560
## 210 1 0 1 500
## 211 1 0 1 500
## 212 1 0 1 560
## 213 1 0 1 500
## 214 1 0 1 500
## gross.square.feet year.built tax.class.at.time.of.sale
## 1 1,110 2002 1
## 6 1,854 1986 1
## 8 1,854 1986 1
## 9 1,521 1986 1
## 10 1,536 1970 1
## 11 1,661 2004 1
## 12 1,661 2004 1
## 13 1,661 2004 1
## 14 1,816 2003 1
## 15 1,816 2003 1
## 17 2,250 2004 1
## 20 2,100 2004 1
## 21 1,648 1925 1
## 22 1,408 1935 1
## 23 1,630 1960 1
## 24 1,664 1980 1
## 26 2,178 1965 1
## 27 2,350 2005 1
## 29 1,693 1910 1
## 30 1,598 1945 1
## 31 0 1955 1
## 32 2,170 2010 1
## 33 2,292 2011 1
## 34 2,166 1974 1
## 36 2,550 1992 1
## 38 1,086 1955 1
## 40 2,250 1980 1
## 43 1,912 1975 1
## 45 1,084 1955 1
## 46 3,480 1974 1
## 47 1,596 1975 1
## 49 1,932 1975 1
## 50 2,083 1970 1
## 53 2,173 1975 1
## 54 2,512 1970 1
## 56 1,480 1955 1
## 59 3,436 2001 1
## 60 3,085 1980 1
## 62 7,296 1990 1
## 65 1,254 1945 1
## 66 5,900 1999 1
## 67 4,713 2010 1
## 72 2,488 1975 1
## 74 2,008 1965 1
## 75 2,008 1965 1
## 76 2,440 1985 1
## 78 2,758 1975 1
## 80 2,440 1984 1
## 81 3,136 1980 1
## 83 3,976 1986 1
## 85 3,165 1991 1
## 86 4,000 1987 1
## 87 2,840 1986 1
## 88 4,576 1997 1
## 102 2,304 2000 1
## 103 1,420 1997 1
## 104 2,630 2004 1
## 105 2,284 2003 1
## 106 1,275 1986 1
## 107 2,142 2005 1
## 108 1,220 1996 1
## 109 1,360 1998 1
## 110 1,360 1998 1
## 111 1,890 2002 1
## 121 1,991 2011 1
## 128 1,991 2011 1
## 153 1,991 2011 1
## 169 1,991 2011 1
## 171 1,991 2011 1
## 173 1,991 2011 1
## 177 1,991 2011 1
## 179 1,991 2011 1
## 181 1,991 2011 1
## 183 1,991 2011 1
## 186 1,991 2011 1
## 188 1,354 1996 1
## 189 1,553 1996 1
## 190 929 1996 1
## 191 1,354 2000 1
## 192 1,354 2000 1
## 193 1,354 2000 1
## 194 929 2001 1
## 195 1,354 2001 1
## 196 1,354 2004 1
## 197 1,510 2004 1
## 198 1,354 2004 1
## 199 1,354 2004 1
## 200 1,354 2004 1
## 201 1,354 1996 1
## 203 1,510 1996 1
## 205 1,354 1996 1
## 206 1,553 2000 1
## 207 1,553 2000 1
## 208 929 1999 1
## 209 1,510 1999 1
## 210 1,354 1999 1
## 211 1,354 1999 1
## 212 1,553 2000 1
## 213 1,354 1996 1
## 214 1,354 1996 1
## building.class.at.time.of.sale sale.price sale.date sale.price.n
## 1 A5 $450,000 0002-04-20 450000
## 6 A5 $338,000 <NA> 338000
## 8 A5 $180,455 <NA> 180455
## 9 A5 $345,000 <NA> 345000
## 10 A1 $410,000 <NA> 410000
## 11 A5 $414,000 0004-05-20 414000
## 12 A5 $410,000 0006-10-20 410000
## 13 A5 $415,000 <NA> 415000
## 14 A5 $426,000 0002-10-20 426000
## 15 A5 $380,000 0011-10-20 380000
## 17 A5 $517,000 <NA> 517000
## 20 A5 $470,000 <NA> 470000
## 21 A1 $352,500 <NA> 352500
## 22 A1 $473,000 <NA> 473000
## 23 A1 $440,000 0001-03-20 440000
## 24 A1 $340,000 <NA> 340000
## 26 A1 $425,000 <NA> 425000
## 27 A5 $775,000 0012-06-20 775000
## 29 A1 $340,000 <NA> 340000
## 30 A1 $725,000 0007-07-20 725000
## 31 A2 $1,100,000 <NA> 1100000
## 32 A1 $745,000 0003-07-20 745000
## 33 A1 $768,778 <NA> 768778
## 34 A1 $457,000 <NA> 457000
## 36 A1 $590,000 <NA> 590000
## 38 A2 $300,000 <NA> 300000
## 40 A1 $549,000 <NA> 549000
## 43 A1 $550,000 <NA> 550000
## 45 A2 $295,000 <NA> 295000
## 46 A1 $760,000 <NA> 760000
## 47 A2 $526,500 0004-08-20 526500
## 49 A2 $490,000 0005-09-20 490000
## 50 A1 $630,000 0001-11-20 630000
## 53 A1 $630,000 <NA> 630000
## 54 A1 $875,000 0010-07-20 875000
## 56 A1 $775,000 0001-10-20 775000
## 59 A1 $740,000 <NA> 740000
## 60 A1 $930,000 0007-01-20 930000
## 62 A3 $1,500,000 <NA> 1500000
## 65 A1 $456,500 0007-08-20 456500
## 66 A1 $999,999 0002-07-20 999999
## 67 A1 $835,239 <NA> 835239
## 72 B2 $481,000 <NA> 481000
## 74 B2 $462,500 <NA> 462500
## 75 B2 $530,000 <NA> 530000
## 76 B2 $695,000 0004-11-20 695000
## 78 B2 $548,000 <NA> 548000
## 80 B2 $538,000 <NA> 538000
## 81 B1 $580,000 <NA> 580000
## 83 B1 $141,666 0001-12-20 141666
## 85 B9 $800,000 0003-02-20 800000
## 86 B9 $800,000 0011-01-20 800000
## 87 B2 $575,000 0002-10-20 575000
## 88 B2 $1,050,000 0002-04-20 1050000
## 102 A5 $462,000 0012-07-20 462000
## 103 A5 $329,000 <NA> 329000
## 104 A1 $645,000 <NA> 645000
## 105 A5 $455,000 <NA> 455000
## 106 A9 $350,000 <NA> 350000
## 107 A5 $370,000 0004-02-20 370000
## 108 A5 $350,000 <NA> 350000
## 109 A5 $370,000 0003-09-20 370000
## 110 A5 $350,000 0011-01-20 350000
## 111 A5 $435,000 <NA> 435000
## 121 A5 $436,020 <NA> 436020
## 128 A5 $491,790 <NA> 491790
## 153 A5 $425,880 <NA> 425880
## 169 A5 $446,160 <NA> 446160
## 171 A5 $446,160 <NA> 446160
## 173 A5 $446,160 <NA> 446160
## 177 A5 $495,025 0011-04-20 495025
## 179 A5 $476,574 0011-10-20 476574
## 181 A5 $461,370 0011-10-20 461370
## 183 A5 $466,440 0012-01-20 466440
## 186 A5 $496,860 <NA> 496860
## 188 A5 $220,000 <NA> 220000
## 189 A5 $283,500 <NA> 283500
## 190 A5 $167,310 <NA> 167310
## 191 A5 $259,700 0003-01-20 259700
## 192 A5 $256,500 <NA> 256500
## 193 A5 $265,000 0001-05-20 265000
## 194 A5 $205,000 <NA> 205000
## 195 A5 $238,500 0003-07-20 238500
## 196 A5 $245,000 0004-11-20 245000
## 197 A5 $270,000 0005-06-20 270000
## 198 A5 $268,000 0011-03-20 268000
## 199 A5 $250,000 <NA> 250000
## 200 A5 $255,000 0002-04-20 255000
## 201 A5 $240,000 <NA> 240000
## 203 A5 $235,000 <NA> 235000
## 205 A5 $257,500 <NA> 257500
## 206 A5 $288,400 0004-07-20 288400
## 207 A5 $269,000 <NA> 269000
## 208 A5 $205,000 0001-11-20 205000
## 209 A5 $297,000 <NA> 297000
## 210 A5 $245,000 0001-11-20 245000
## 211 A5 $225,000 <NA> 225000
## 212 A5 $260,580 <NA> 260580
## 213 A5 $242,000 <NA> 242000
## 214 A5 $288,000 <NA> 288000
## gross.sqft land.sqft outliers
## 1 1110 3149 0
## 6 1854 1845 0
## 8 1854 2358 0
## 9 1521 1508 0
## 10 1536 4200 0
## 11 1661 1585 0
## 12 1661 1585 0
## 13 1661 1585 0
## 14 1816 1648 0
## 15 1816 1648 0
## 17 2250 2490 0
## 20 2100 2400 0
## 21 1648 6450 0
## 22 1408 4125 0
## 23 1630 4000 0
## 24 1664 3480 0
## 26 2178 4000 0
## 27 2350 4000 0
## 29 1693 5000 0
## 30 1598 30912 0
## 31 0 40000 0
## 32 2170 3912 0
## 33 2292 3911 0
## 34 2166 4000 0
## 36 2550 4000 0
## 38 1086 6138 0
## 40 2250 8000 0
## 43 1912 6000 0
## 45 1084 4900 0
## 46 3480 4212 0
## 47 1596 6000 0
## 49 1932 4000 0
## 50 2083 4000 0
## 53 2173 7000 0
## 54 2512 8000 0
## 56 1480 6000 0
## 59 3436 4400 0
## 60 3085 8000 0
## 62 7296 11100 0
## 65 1254 7500 0
## 66 5900 13950 0
## 67 4713 5811 0
## 72 2488 6000 0
## 74 2008 4000 0
## 75 2008 4000 0
## 76 2440 6000 0
## 78 2758 6000 0
## 80 2440 4800 0
## 81 3136 5900 0
## 83 3976 10000 0
## 85 3165 6000 0
## 86 4000 8534 0
## 87 2840 4780 0
## 88 4576 13650 0
## 102 2304 2600 0
## 103 1420 2900 0
## 104 2630 4000 0
## 105 2284 2658 0
## 106 1275 2000 0
## 107 2142 3350 0
## 108 1220 1275 0
## 109 1360 1366 0
## 110 1360 1366 0
## 111 1890 2426 0
## 121 1991 1975 0
## 128 1991 3716 0
## 153 1991 1972 0
## 169 1991 1972 0
## 171 1991 1972 0
## 173 1991 1972 0
## 177 1991 3439 0
## 179 1991 1972 0
## 181 1991 1972 0
## 183 1991 1972 0
## 186 1991 4240 0
## 188 1354 500 0
## 189 1553 560 0
## 190 929 353 0
## 191 1354 500 0
## 192 1354 500 0
## 193 1354 500 0
## 194 929 353 0
## 195 1354 500 0
## 196 1354 500 0
## 197 1510 560 0
## 198 1354 500 0
## 199 1354 500 0
## 200 1354 500 0
## 201 1354 500 0
## 203 1510 560 0
## 205 1354 500 0
## 206 1553 560 0
## 207 1553 560 0
## 208 929 353 0
## 209 1510 560 0
## 210 1354 500 0
## 211 1354 500 0
## 212 1553 560 0
## 213 1354 500 0
## 214 1354 500 0plot(log(bk.homes$gross.sqft),log(bk.homes$sale.price.n))