install.packages("tidyr", repos="https://github.com/tidyverse/tidyr")## Installing package into 'C:/Users/bkl2001/Documents/R/win-library/3.4'
## (as 'lib' is unspecified)## Warning: unable to access index for repository https://github.com/tidyverse/tidyr/src/contrib:
## cannot open URL 'https://github.com/tidyverse/tidyr/src/contrib/PACKAGES'## Warning: package 'tidyr' is not available (for R version 3.4.1)## Warning: unable to access index for repository https://github.com/tidyverse/tidyr/bin/windows/contrib/3.4:
## cannot open URL 'https://github.com/tidyverse/tidyr/bin/windows/contrib/3.4/PACKAGES'library(tidyr)## Warning: package 'tidyr' was built under R version 3.4.2install.packages("dplyr", repos="https://github.com/tidyverse/dplyr")## Installing package into 'C:/Users/bkl2001/Documents/R/win-library/3.4'
## (as 'lib' is unspecified)## Warning: unable to access index for repository https://github.com/tidyverse/dplyr/src/contrib:
## cannot open URL 'https://github.com/tidyverse/dplyr/src/contrib/PACKAGES'## Warning: package 'dplyr' is not available (for R version 3.4.1)## Warning: unable to access index for repository https://github.com/tidyverse/dplyr/bin/windows/contrib/3.4:
## cannot open URL 'https://github.com/tidyverse/dplyr/bin/windows/contrib/3.4/PACKAGES'library(dplyr)## Warning: package 'dplyr' was built under R version 3.4.2##
## Attaching package: 'dplyr'## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, unionData based on information retrieved from www.imdb.com
#Import tv data
tv <- read.csv("C:\\Users\\bkl2001\\Documents\\Personal\\CUNY\\Classes\\DATA 607 Data Acquisition and Management\\Week 5\\TVShows.csv")TV dataset has 640 observations and 6 variables
#View data set dimensions
dim(tv)## [1] 640 6#View the first 10 rows of tv dataset
head(tv, n=10)## Show Season EpisodeNumber Episode
## 1 The Sopranos 1 1 The Sopranos
## 2 The Sopranos 1 2 46 Long
## 3 The Sopranos 1 3 Denail, Anger, Acceptance
## 4 The Sopranos 1 4 Meadowlands
## 5 The Sopranos 1 5 College
## 6 The Sopranos 1 6 Pax Soprana
## 7 The Sopranos 1 7 Down Neck
## 8 The Sopranos 1 8 The Legend of Tennessee Moltisanti
## 9 The Sopranos 1 9 Boca
## 10 The Sopranos 1 10 A Hit is a Hit
## Date IMDB
## 1 1/10/1999 8.7
## 2 1/17/1999 8.7
## 3 1/24/1999 8.9
## 4 1/31/1999 8.8
## 5 2/7/1999 8.9
## 6 2/14/1999 8.7
## 7 2/21/1999 8.6
## 8 2/28/1999 8.8
## 9 3/7/1999 8.7
## 10 3/14/1999 8.4#View the last 10 rows of tv dataset
tail(tv, n=10)## Show Season EpisodeNumber Episode Date IMDB
## 631 The Shield 7 5 Game Face 9/30/2008 7.3
## 632 The Shield 7 6 Animal Control 10/7/2008 8.5
## 633 The Shield 7 7 Bitches Brew 10/14/2008 7.2
## 634 The Shield 7 8 Parricide 10/21/2008 8.1
## 635 The Shield 7 9 Moving Day 10/28/2008 7.5
## 636 The Shield 7 10 Party Line 11/4/2008 7.6
## 637 The Shield 7 11 Petty Cash 11/11/2008 7.5
## 638 The Shield 7 12 Possible Kill Screen 11/18/2008 8.7
## 639 The Shield 7 13 Family Meeting 11/25/2008 9.1
## 640 The Shield 7 14 Family Meeting, Pt. 2 11/25/2008 9.1#Only select the Show and IMDB variable
tv %>% select(Show, IMDB)## Show IMDB
## 1 The Sopranos 8.7
## 2 The Sopranos 8.7
## 3 The Sopranos 8.9
## 4 The Sopranos 8.8
## 5 The Sopranos 8.9
## 6 The Sopranos 8.7
## 7 The Sopranos 8.6
## 8 The Sopranos 8.8
## 9 The Sopranos 8.7
## 10 The Sopranos 8.4
## 11 The Sopranos 8.8
## 12 The Sopranos 9.0
## 13 The Sopranos 9.1
## 14 The Sopranos 8.5
## 15 The Sopranos 8.4
## 16 The Sopranos 8.6
## 17 The Sopranos 8.7
## 18 The Sopranos 8.7
## 19 The Sopranos 8.7
## 20 The Sopranos 8.7
## 21 The Sopranos 8.9
## 22 The Sopranos 8.8
## 23 The Sopranos 8.7
## 24 The Sopranos 8.5
## 25 The Sopranos 9.1
## 26 The Sopranos 9.2
## 27 The Sopranos 8.7
## 28 The Sopranos 8.7
## 29 The Sopranos 8.6
## 30 The Sopranos 9.0
## 31 The Sopranos 8.7
## 32 The Sopranos 8.7
## 33 The Sopranos 8.6
## 34 The Sopranos 8.5
## 35 The Sopranos 8.4
## 36 The Sopranos 8.6
## 37 The Sopranos 9.6
## 38 The Sopranos 9.1
## 39 The Sopranos 9.0
## 40 The Sopranos 8.2
## 41 The Sopranos 8.2
## 42 The Sopranos 8.0
## 43 The Sopranos 8.3
## 44 The Sopranos 8.2
## 45 The Sopranos 8.3
## 46 The Sopranos 8.2
## 47 The Sopranos 8.2
## 48 The Sopranos 8.9
## 49 The Sopranos 8.6
## 50 The Sopranos 8.1
## 51 The Sopranos 8.2
## 52 The Sopranos 8.7
## 53 The Sopranos 8.7
## 54 The Sopranos 8.6
## 55 The Sopranos 8.7
## 56 The Sopranos 8.5
## 57 The Sopranos 9.1
## 58 The Sopranos 8.4
## 59 The Sopranos 8.3
## 60 The Sopranos 8.7
## 61 The Sopranos 8.8
## 62 The Sopranos 8.7
## 63 The Sopranos 8.6
## 64 The Sopranos 9.4
## 65 The Sopranos 9.0
## 66 The Sopranos 9.0
## 67 The Sopranos 8.6
## 68 The Sopranos 8.6
## 69 The Sopranos 8.5
## 70 The Sopranos 8.7
## 71 The Sopranos 8.6
## 72 The Sopranos 8.4
## 73 The Sopranos 8.4
## 74 The Sopranos 8.4
## 75 The Sopranos 8.4
## 76 The Sopranos 8.7
## 77 The Sopranos 8.4
## 78 The Sopranos 8.9
## 79 The Sopranos 8.8
## 80 The Sopranos 8.5
## 81 The Sopranos 8.3
## 82 The Sopranos 8.7
## 83 The Sopranos 9.0
## 84 The Sopranos 9.1
## 85 The Sopranos 9.4
## 86 The Sopranos 9.0
## 87 Boardwalk Empire 8.6
## 88 Boardwalk Empire 7.9
## 89 Boardwalk Empire 8.2
## 90 Boardwalk Empire 8.3
## 91 Boardwalk Empire 8.4
## 92 Boardwalk Empire 8.3
## 93 Boardwalk Empire 8.6
## 94 Boardwalk Empire 8.2
## 95 Boardwalk Empire 8.6
## 96 Boardwalk Empire 8.6
## 97 Boardwalk Empire 8.4
## 98 Boardwalk Empire 8.8
## 99 Boardwalk Empire 8.3
## 100 Boardwalk Empire 8.5
## 101 Boardwalk Empire 8.4
## 102 Boardwalk Empire 8.3
## 103 Boardwalk Empire 8.8
## 104 Boardwalk Empire 8.1
## 105 Boardwalk Empire 8.4
## 106 Boardwalk Empire 8.7
## 107 Boardwalk Empire 8.6
## 108 Boardwalk Empire 8.7
## 109 Boardwalk Empire 8.9
## 110 Boardwalk Empire 9.2
## 111 Boardwalk Empire 8.5
## 112 Boardwalk Empire 8.1
## 113 Boardwalk Empire 8.3
## 114 Boardwalk Empire 8.7
## 115 Boardwalk Empire 8.4
## 116 Boardwalk Empire 7.7
## 117 Boardwalk Empire 8.1
## 118 Boardwalk Empire 8.7
## 119 Boardwalk Empire 8.6
## 120 Boardwalk Empire 9.0
## 121 Boardwalk Empire 9.5
## 122 Boardwalk Empire 9.4
## 123 Boardwalk Empire 8.3
## 124 Boardwalk Empire 8.3
## 125 Boardwalk Empire 8.1
## 126 Boardwalk Empire 8.6
## 127 Boardwalk Empire 9.0
## 128 Boardwalk Empire 7.9
## 129 Boardwalk Empire 8.0
## 130 Boardwalk Empire 8.8
## 131 Boardwalk Empire 8.7
## 132 Boardwalk Empire 8.9
## 133 Boardwalk Empire 8.4
## 134 Boardwalk Empire 9.4
## 135 Boardwalk Empire 8.5
## 136 Boardwalk Empire 8.3
## 137 Boardwalk Empire 8.1
## 138 Boardwalk Empire 8.7
## 139 Boardwalk Empire 8.5
## 140 Boardwalk Empire 9.0
## 141 Boardwalk Empire 9.2
## 142 Boardwalk Empire 9.3
## 143 The Wire 8.1
## 144 The Wire 8.5
## 145 The Wire 8.4
## 146 The Wire 8.5
## 147 The Wire 8.5
## 148 The Wire 8.8
## 149 The Wire 8.7
## 150 The Wire 8.7
## 151 The Wire 8.9
## 152 The Wire 9.3
## 153 The Wire 9.0
## 154 The Wire 9.2
## 155 The Wire 9.1
## 156 The Wire 8.1
## 157 The Wire 8.4
## 158 The Wire 8.4
## 159 The Wire 8.3
## 160 The Wire 8.5
## 161 The Wire 9.0
## 162 The Wire 8.5
## 163 The Wire 8.7
## 164 The Wire 8.8
## 165 The Wire 9.1
## 166 The Wire 9.3
## 167 The Wire 9.2
## 168 The Wire 8.4
## 169 The Wire 8.7
## 170 The Wire 8.7
## 171 The Wire 8.7
## 172 The Wire 8.8
## 173 The Wire 8.9
## 174 The Wire 8.8
## 175 The Wire 9.0
## 176 The Wire 8.9
## 177 The Wire 8.9
## 178 The Wire 9.6
## 179 The Wire 9.4
## 180 The Wire 8.7
## 181 The Wire 8.7
## 182 The Wire 8.9
## 183 The Wire 8.7
## 184 The Wire 8.8
## 185 The Wire 8.9
## 186 The Wire 8.8
## 187 The Wire 8.8
## 188 The Wire 8.7
## 189 The Wire 9.0
## 190 The Wire 9.2
## 191 The Wire 9.4
## 192 The Wire 9.6
## 193 The Wire 8.5
## 194 The Wire 8.6
## 195 The Wire 8.8
## 196 The Wire 9.1
## 197 The Wire 8.9
## 198 The Wire 8.8
## 199 The Wire 8.8
## 200 The Wire 9.1
## 201 The Wire 9.4
## 202 The Wire 9.6
## 203 Breaking Bad 9.0
## 204 Breaking Bad 8.7
## 205 Breaking Bad 8.8
## 206 Breaking Bad 8.4
## 207 Breaking Bad 8.4
## 208 Breaking Bad 9.3
## 209 Breaking Bad 8.9
## 210 Breaking Bad 8.7
## 211 Breaking Bad 9.3
## 212 Breaking Bad 8.4
## 213 Breaking Bad 8.3
## 214 Breaking Bad 8.4
## 215 Breaking Bad 8.9
## 216 Breaking Bad 8.8
## 217 Breaking Bad 9.1
## 218 Breaking Bad 9.1
## 219 Breaking Bad 8.6
## 220 Breaking Bad 8.9
## 221 Breaking Bad 9.2
## 222 Breaking Bad 9.2
## 223 Breaking Bad 8.6
## 224 Breaking Bad 8.7
## 225 Breaking Bad 8.5
## 226 Breaking Bad 8.3
## 227 Breaking Bad 8.7
## 228 Breaking Bad 9.3
## 229 Breaking Bad 9.6
## 230 Breaking Bad 8.8
## 231 Breaking Bad 8.5
## 232 Breaking Bad 7.9
## 233 Breaking Bad 8.5
## 234 Breaking Bad 9.5
## 235 Breaking Bad 9.6
## 236 Breaking Bad 9.2
## 237 Breaking Bad 8.4
## 238 Breaking Bad 8.2
## 239 Breaking Bad 8.7
## 240 Breaking Bad 8.7
## 241 Breaking Bad 8.5
## 242 Breaking Bad 8.9
## 243 Breaking Bad 9.3
## 244 Breaking Bad 8.9
## 245 Breaking Bad 9.6
## 246 Breaking Bad 9.7
## 247 Breaking Bad 9.4
## 248 Breaking Bad 9.9
## 249 Breaking Bad 9.3
## 250 Breaking Bad 9.0
## 251 Breaking Bad 9.0
## 252 Breaking Bad 8.9
## 253 Breaking Bad 9.7
## 254 Breaking Bad 9.1
## 255 Breaking Bad 9.5
## 256 Breaking Bad 9.6
## 257 Breaking Bad 9.4
## 258 Breaking Bad 9.2
## 259 Breaking Bad 9.6
## 260 Breaking Bad 9.2
## 261 Breaking Bad 9.8
## 262 Breaking Bad 10.0
## 263 Breaking Bad 9.7
## 264 Breaking Bad 9.9
## 265 Deadwood 8.4
## 266 Deadwood 8.4
## 267 Deadwood 8.4
## 268 Deadwood 8.9
## 269 Deadwood 8.3
## 270 Deadwood 8.4
## 271 Deadwood 7.8
## 272 Deadwood 8.0
## 273 Deadwood 8.3
## 274 Deadwood 8.7
## 275 Deadwood 8.6
## 276 Deadwood 9.2
## 277 Deadwood 8.8
## 278 Deadwood 8.4
## 279 Deadwood 8.3
## 280 Deadwood 8.4
## 281 Deadwood 8.4
## 282 Deadwood 8.6
## 283 Deadwood 8.6
## 284 Deadwood 8.4
## 285 Deadwood 8.8
## 286 Deadwood 8.6
## 287 Deadwood 8.6
## 288 Deadwood 9.1
## 289 Deadwood 8.6
## 290 Deadwood 8.6
## 291 Deadwood 8.4
## 292 Deadwood 8.4
## 293 Deadwood 9.1
## 294 Deadwood 8.5
## 295 Deadwood 8.4
## 296 Deadwood 8.3
## 297 Deadwood 8.5
## 298 Deadwood 8.8
## 299 Deadwood 8.9
## 300 Deadwood 8.7
## 301 Mad Men 8.2
## 302 Mad Men 7.6
## 303 Mad Men 7.7
## 304 Mad Men 8.0
## 305 Mad Men 8.2
## 306 Mad Men 8.0
## 307 Mad Men 8.1
## 308 Mad Men 8.4
## 309 Mad Men 8.3
## 310 Mad Men 8.3
## 311 Mad Men 8.2
## 312 Mad Men 9.0
## 313 Mad Men 9.0
## 314 Mad Men 7.8
## 315 Mad Men 8.0
## 316 Mad Men 8.0
## 317 Mad Men 8.2
## 318 Mad Men 8.4
## 319 Mad Men 8.1
## 320 Mad Men 8.5
## 321 Mad Men 8.4
## 322 Mad Men 8.5
## 323 Mad Men 8.1
## 324 Mad Men 8.4
## 325 Mad Men 8.6
## 326 Mad Men 9.0
## 327 Mad Men 8.3
## 328 Mad Men 8.0
## 329 Mad Men 8.2
## 330 Mad Men 8.2
## 331 Mad Men 8.1
## 332 Mad Men 9.1
## 333 Mad Men 8.5
## 334 Mad Men 8.1
## 335 Mad Men 8.3
## 336 Mad Men 8.4
## 337 Mad Men 9.2
## 338 Mad Men 8.9
## 339 Mad Men 9.6
## 340 Mad Men 8.7
## 341 Mad Men 8.3
## 342 Mad Men 8.7
## 343 Mad Men 8.4
## 344 Mad Men 8.7
## 345 Mad Men 8.6
## 346 Mad Men 9.7
## 347 Mad Men 8.7
## 348 Mad Men 8.8
## 349 Mad Men 8.8
## 350 Mad Men 8.5
## 351 Mad Men 8.9
## 352 Mad Men 9.0
## 353 Mad Men 8.6
## 354 Mad Men 8.6
## 355 Mad Men 8.0
## 356 Mad Men 8.7
## 357 Mad Men 9.0
## 358 Mad Men 9.1
## 359 Mad Men 8.7
## 360 Mad Men 8.4
## 361 Mad Men 8.2
## 362 Mad Men 8.3
## 363 Mad Men 9.4
## 364 Mad Men 9.3
## 365 Mad Men 8.6
## 366 Mad Men 7.8
## 367 Mad Men 7.9
## 368 Mad Men 8.1
## 369 Mad Men 8.3
## 370 Mad Men 8.3
## 371 Mad Men 8.9
## 372 Mad Men 8.2
## 373 Mad Men 8.7
## 374 Mad Men 8.5
## 375 Mad Men 8.2
## 376 Mad Men 8.8
## 377 Mad Men 8.6
## 378 Mad Men 9.2
## 379 Mad Men 8.1
## 380 Mad Men 8.5
## 381 Mad Men 8.7
## 382 Mad Men 8.6
## 383 Mad Men 8.7
## 384 Mad Men 9.0
## 385 Mad Men 9.5
## 386 Mad Men 8.4
## 387 Mad Men 8.1
## 388 Mad Men 8.5
## 389 Mad Men 9.1
## 390 Mad Men 9.1
## 391 Mad Men 9.2
## 392 Mad Men 9.3
## 393 Treme 8.1
## 394 Treme 8.3
## 395 Treme 8.2
## 396 Treme 8.1
## 397 Treme 8.4
## 398 Treme 8.0
## 399 Treme 8.6
## 400 Treme 8.6
## 401 Treme 8.5
## 402 Treme 8.7
## 403 Treme 8.0
## 404 Treme 7.9
## 405 Treme 8.5
## 406 Treme 8.1
## 407 Treme 8.1
## 408 Treme 8.1
## 409 Treme 8.4
## 410 Treme 8.2
## 411 Treme 8.6
## 412 Treme 8.3
## 413 Treme 8.9
## 414 Treme 8.0
## 415 Treme 7.9
## 416 Treme 7.9
## 417 Treme 8.0
## 418 Treme 8.1
## 419 Treme 7.9
## 420 Treme 8.2
## 421 Treme 8.0
## 422 Treme 8.0
## 423 Treme 8.3
## 424 Treme 8.2
## 425 Treme 7.8
## 426 Treme 8.0
## 427 Treme 8.2
## 428 Treme 8.5
## 429 Six Feet Under 9.0
## 430 Six Feet Under 8.3
## 431 Six Feet Under 8.6
## 432 Six Feet Under 8.6
## 433 Six Feet Under 8.6
## 434 Six Feet Under 8.8
## 435 Six Feet Under 8.3
## 436 Six Feet Under 8.5
## 437 Six Feet Under 8.8
## 438 Six Feet Under 8.7
## 439 Six Feet Under 8.6
## 440 Six Feet Under 9.0
## 441 Six Feet Under 8.9
## 442 Six Feet Under 8.7
## 443 Six Feet Under 8.5
## 444 Six Feet Under 8.4
## 445 Six Feet Under 8.7
## 446 Six Feet Under 8.7
## 447 Six Feet Under 8.5
## 448 Six Feet Under 8.4
## 449 Six Feet Under 9.2
## 450 Six Feet Under 8.3
## 451 Six Feet Under 8.5
## 452 Six Feet Under 8.7
## 453 Six Feet Under 9.1
## 454 Six Feet Under 9.3
## 455 Six Feet Under 8.5
## 456 Six Feet Under 8.3
## 457 Six Feet Under 8.3
## 458 Six Feet Under 8.9
## 459 Six Feet Under 8.3
## 460 Six Feet Under 8.3
## 461 Six Feet Under 8.4
## 462 Six Feet Under 8.4
## 463 Six Feet Under 8.3
## 464 Six Feet Under 8.6
## 465 Six Feet Under 9.0
## 466 Six Feet Under 8.7
## 467 Six Feet Under 9.3
## 468 Six Feet Under 9.0
## 469 Six Feet Under 8.1
## 470 Six Feet Under 8.3
## 471 Six Feet Under 8.2
## 472 Six Feet Under 9.2
## 473 Six Feet Under 8.6
## 474 Six Feet Under 8.2
## 475 Six Feet Under 8.3
## 476 Six Feet Under 8.1
## 477 Six Feet Under 8.1
## 478 Six Feet Under 8.4
## 479 Six Feet Under 9.2
## 480 Six Feet Under 8.6
## 481 Six Feet Under 8.3
## 482 Six Feet Under 8.6
## 483 Six Feet Under 8.9
## 484 Six Feet Under 8.5
## 485 Six Feet Under 8.8
## 486 Six Feet Under 8.4
## 487 Six Feet Under 9.0
## 488 Six Feet Under 9.5
## 489 Six Feet Under 9.7
## 490 Six Feet Under 9.3
## 491 Six Feet Under 9.9
## 492 Game of Thrones 8.9
## 493 Game of Thrones 8.7
## 494 Game of Thrones 8.6
## 495 Game of Thrones 8.7
## 496 Game of Thrones 9.0
## 497 Game of Thrones 9.1
## 498 Game of Thrones 9.2
## 499 Game of Thrones 9.0
## 500 Game of Thrones 9.5
## 501 Game of Thrones 9.4
## 502 Game of Thrones 8.8
## 503 Game of Thrones 8.5
## 504 Game of Thrones 8.8
## 505 Game of Thrones 8.7
## 506 Game of Thrones 8.8
## 507 Game of Thrones 9.0
## 508 Game of Thrones 8.9
## 509 Game of Thrones 8.7
## 510 Game of Thrones 9.7
## 511 Game of Thrones 9.4
## 512 Game of Thrones 8.7
## 513 Game of Thrones 8.6
## 514 Game of Thrones 8.8
## 515 Game of Thrones 9.5
## 516 Game of Thrones 8.9
## 517 Game of Thrones 8.7
## 518 Game of Thrones 8.6
## 519 Game of Thrones 8.9
## 520 Game of Thrones 9.9
## 521 Game of Thrones 9.0
## 522 Game of Thrones 9.1
## 523 Game of Thrones 9.7
## 524 Game of Thrones 8.8
## 525 Game of Thrones 8.8
## 526 Game of Thrones 8.7
## 527 Game of Thrones 9.7
## 528 Game of Thrones 9.1
## 529 Game of Thrones 9.7
## 530 Game of Thrones 9.5
## 531 Game of Thrones 9.6
## 532 Game of Thrones 8.4
## 533 Game of Thrones 8.5
## 534 Game of Thrones 8.5
## 535 Game of Thrones 8.7
## 536 Game of Thrones 8.6
## 537 Game of Thrones 7.9
## 538 Game of Thrones 9.0
## 539 Game of Thrones 9.9
## 540 Game of Thrones 9.4
## 541 Game of Thrones 8.8
## 542 Game of Thrones 8.4
## 543 Game of Thrones 9.5
## 544 Game of Thrones 8.7
## 545 Game of Thrones 9.2
## 546 Game of Thrones 9.7
## 547 Game of Thrones 8.3
## 548 Game of Thrones 8.6
## 549 Game of Thrones 8.2
## 550 Game of Thrones 9.9
## 551 Game of Thrones 9.9
## 552 The Shield 8.1
## 553 The Shield 7.5
## 554 The Shield 7.3
## 555 The Shield 7.6
## 556 The Shield 8.2
## 557 The Shield 8.0
## 558 The Shield 7.6
## 559 The Shield 7.5
## 560 The Shield 7.6
## 561 The Shield 8.1
## 562 The Shield 7.7
## 563 The Shield 7.4
## 564 The Shield 8.1
## 565 The Shield 7.4
## 566 The Shield 8.1
## 567 The Shield 7.4
## 568 The Shield 7.8
## 569 The Shield 7.5
## 570 The Shield 7.5
## 571 The Shield 7.4
## 572 The Shield 7.7
## 573 The Shield 7.1
## 574 The Shield 7.6
## 575 The Shield 7.7
## 576 The Shield 7.4
## 577 The Shield 8.0
## 578 The Shield 7.9
## 579 The Shield 7.5
## 580 The Shield 7.3
## 581 The Shield 7.8
## 582 The Shield 7.9
## 583 The Shield 7.3
## 584 The Shield 7.5
## 585 The Shield 7.4
## 586 The Shield 7.6
## 587 The Shield 7.7
## 588 The Shield 8.1
## 589 The Shield 7.7
## 590 The Shield 8.2
## 591 The Shield 8.4
## 592 The Shield 8.5
## 593 The Shield 6.8
## 594 The Shield 6.5
## 595 The Shield 6.4
## 596 The Shield 6.7
## 597 The Shield 7.0
## 598 The Shield 6.8
## 599 The Shield 6.7
## 600 The Shield 6.9
## 601 The Shield 6.7
## 602 The Shield 6.8
## 603 The Shield 6.7
## 604 The Shield 7.0
## 605 The Shield 6.3
## 606 The Shield 7.2
## 607 The Shield 7.2
## 608 The Shield 7.1
## 609 The Shield 7.2
## 610 The Shield 7.3
## 611 The Shield 7.2
## 612 The Shield 7.2
## 613 The Shield 7.3
## 614 The Shield 7.2
## 615 The Shield 7.3
## 616 The Shield 8.1
## 617 The Shield 7.1
## 618 The Shield 7.6
## 619 The Shield 7.7
## 620 The Shield 7.6
## 621 The Shield 7.3
## 622 The Shield 8.1
## 623 The Shield 7.6
## 624 The Shield 7.4
## 625 The Shield 7.6
## 626 The Shield 8.3
## 627 The Shield 8.5
## 628 The Shield 7.3
## 629 The Shield 7.4
## 630 The Shield 7.4
## 631 The Shield 7.3
## 632 The Shield 8.5
## 633 The Shield 7.2
## 634 The Shield 8.1
## 635 The Shield 7.5
## 636 The Shield 7.6
## 637 The Shield 7.5
## 638 The Shield 8.7
## 639 The Shield 9.1
## 640 The Shield 9.1#Summarise top tv show
tv %>% summarise(mean=mean(IMDB))## mean
## 1 8.530781#Use the separate function
separate(tv, Date, c("month","day","year"), sep="/")## Show Season EpisodeNumber
## 1 The Sopranos 1 1
## 2 The Sopranos 1 2
## 3 The Sopranos 1 3
## 4 The Sopranos 1 4
## 5 The Sopranos 1 5
## 6 The Sopranos 1 6
## 7 The Sopranos 1 7
## 8 The Sopranos 1 8
## 9 The Sopranos 1 9
## 10 The Sopranos 1 10
## 11 The Sopranos 1 11
## 12 The Sopranos 1 12
## 13 The Sopranos 1 13
## 14 The Sopranos 2 1
## 15 The Sopranos 2 2
## 16 The Sopranos 2 3
## 17 The Sopranos 2 4
## 18 The Sopranos 2 5
## 19 The Sopranos 2 6
## 20 The Sopranos 2 7
## 21 The Sopranos 2 8
## 22 The Sopranos 2 9
## 23 The Sopranos 2 10
## 24 The Sopranos 2 11
## 25 The Sopranos 2 12
## 26 The Sopranos 2 13
## 27 The Sopranos 3 1
## 28 The Sopranos 3 2
## 29 The Sopranos 3 3
## 30 The Sopranos 3 4
## 31 The Sopranos 3 5
## 32 The Sopranos 3 6
## 33 The Sopranos 3 7
## 34 The Sopranos 3 8
## 35 The Sopranos 3 9
## 36 The Sopranos 3 10
## 37 The Sopranos 3 11
## 38 The Sopranos 3 12
## 39 The Sopranos 3 13
## 40 The Sopranos 4 1
## 41 The Sopranos 4 2
## 42 The Sopranos 4 3
## 43 The Sopranos 4 4
## 44 The Sopranos 4 5
## 45 The Sopranos 4 6
## 46 The Sopranos 4 7
## 47 The Sopranos 4 8
## 48 The Sopranos 4 9
## 49 The Sopranos 4 10
## 50 The Sopranos 4 11
## 51 The Sopranos 4 12
## 52 The Sopranos 4 13
## 53 The Sopranos 5 1
## 54 The Sopranos 5 2
## 55 The Sopranos 5 3
## 56 The Sopranos 5 4
## 57 The Sopranos 5 5
## 58 The Sopranos 5 6
## 59 The Sopranos 5 7
## 60 The Sopranos 5 8
## 61 The Sopranos 5 9
## 62 The Sopranos 5 10
## 63 The Sopranos 5 11
## 64 The Sopranos 5 12
## 65 The Sopranos 5 13
## 66 The Sopranos 6 1
## 67 The Sopranos 6 2
## 68 The Sopranos 6 3
## 69 The Sopranos 6 4
## 70 The Sopranos 6 5
## 71 The Sopranos 6 6
## 72 The Sopranos 6 7
## 73 The Sopranos 6 8
## 74 The Sopranos 6 9
## 75 The Sopranos 6 10
## 76 The Sopranos 6 11
## 77 The Sopranos 6 12
## 78 The Sopranos 6 13
## 79 The Sopranos 6 14
## 80 The Sopranos 6 15
## 81 The Sopranos 6 16
## 82 The Sopranos 6 17
## 83 The Sopranos 6 18
## 84 The Sopranos 6 19
## 85 The Sopranos 6 20
## 86 The Sopranos 6 21
## 87 Boardwalk Empire 1 1
## 88 Boardwalk Empire 1 2
## 89 Boardwalk Empire 1 3
## 90 Boardwalk Empire 1 4
## 91 Boardwalk Empire 1 5
## 92 Boardwalk Empire 1 6
## 93 Boardwalk Empire 1 7
## 94 Boardwalk Empire 1 8
## 95 Boardwalk Empire 1 9
## 96 Boardwalk Empire 1 10
## 97 Boardwalk Empire 1 11
## 98 Boardwalk Empire 1 12
## 99 Boardwalk Empire 2 1
## 100 Boardwalk Empire 2 2
## 101 Boardwalk Empire 2 3
## 102 Boardwalk Empire 2 4
## 103 Boardwalk Empire 2 5
## 104 Boardwalk Empire 2 6
## 105 Boardwalk Empire 2 7
## 106 Boardwalk Empire 2 8
## 107 Boardwalk Empire 2 9
## 108 Boardwalk Empire 2 10
## 109 Boardwalk Empire 2 11
## 110 Boardwalk Empire 2 12
## 111 Boardwalk Empire 3 1
## 112 Boardwalk Empire 3 2
## 113 Boardwalk Empire 3 3
## 114 Boardwalk Empire 3 4
## 115 Boardwalk Empire 3 5
## 116 Boardwalk Empire 3 6
## 117 Boardwalk Empire 3 7
## 118 Boardwalk Empire 3 8
## 119 Boardwalk Empire 3 9
## 120 Boardwalk Empire 3 10
## 121 Boardwalk Empire 3 11
## 122 Boardwalk Empire 3 12
## 123 Boardwalk Empire 4 1
## 124 Boardwalk Empire 4 2
## 125 Boardwalk Empire 4 3
## 126 Boardwalk Empire 4 4
## 127 Boardwalk Empire 4 5
## 128 Boardwalk Empire 4 6
## 129 Boardwalk Empire 4 7
## 130 Boardwalk Empire 4 8
## 131 Boardwalk Empire 4 9
## 132 Boardwalk Empire 4 10
## 133 Boardwalk Empire 4 11
## 134 Boardwalk Empire 4 12
## 135 Boardwalk Empire 5 1
## 136 Boardwalk Empire 5 2
## 137 Boardwalk Empire 5 3
## 138 Boardwalk Empire 5 4
## 139 Boardwalk Empire 5 5
## 140 Boardwalk Empire 5 6
## 141 Boardwalk Empire 5 7
## 142 Boardwalk Empire 5 8
## 143 The Wire 1 1
## 144 The Wire 1 2
## 145 The Wire 1 3
## 146 The Wire 1 4
## 147 The Wire 1 5
## 148 The Wire 1 6
## 149 The Wire 1 7
## 150 The Wire 1 8
## 151 The Wire 1 9
## 152 The Wire 1 10
## 153 The Wire 1 11
## 154 The Wire 1 12
## 155 The Wire 1 13
## 156 The Wire 2 1
## 157 The Wire 2 2
## 158 The Wire 2 3
## 159 The Wire 2 4
## 160 The Wire 2 5
## 161 The Wire 2 6
## 162 The Wire 2 7
## 163 The Wire 2 8
## 164 The Wire 2 9
## 165 The Wire 2 10
## 166 The Wire 2 11
## 167 The Wire 2 12
## 168 The Wire 3 1
## 169 The Wire 3 2
## 170 The Wire 3 3
## 171 The Wire 3 4
## 172 The Wire 3 5
## 173 The Wire 3 6
## 174 The Wire 3 7
## 175 The Wire 3 8
## 176 The Wire 3 9
## 177 The Wire 3 10
## 178 The Wire 3 11
## 179 The Wire 3 12
## 180 The Wire 4 1
## 181 The Wire 4 2
## 182 The Wire 4 3
## 183 The Wire 4 4
## 184 The Wire 4 5
## 185 The Wire 4 6
## 186 The Wire 4 7
## 187 The Wire 4 8
## 188 The Wire 4 9
## 189 The Wire 4 10
## 190 The Wire 4 11
## 191 The Wire 4 12
## 192 The Wire 4 13
## 193 The Wire 5 1
## 194 The Wire 5 2
## 195 The Wire 5 3
## 196 The Wire 5 4
## 197 The Wire 5 5
## 198 The Wire 5 6
## 199 The Wire 5 7
## 200 The Wire 5 8
## 201 The Wire 5 9
## 202 The Wire 5 10
## 203 Breaking Bad 1 1
## 204 Breaking Bad 1 2
## 205 Breaking Bad 1 3
## 206 Breaking Bad 1 4
## 207 Breaking Bad 1 5
## 208 Breaking Bad 1 6
## 209 Breaking Bad 1 7
## 210 Breaking Bad 2 1
## 211 Breaking Bad 2 2
## 212 Breaking Bad 2 3
## 213 Breaking Bad 2 4
## 214 Breaking Bad 2 5
## 215 Breaking Bad 2 6
## 216 Breaking Bad 2 7
## 217 Breaking Bad 2 8
## 218 Breaking Bad 2 9
## 219 Breaking Bad 2 10
## 220 Breaking Bad 2 11
## 221 Breaking Bad 2 12
## 222 Breaking Bad 2 13
## 223 Breaking Bad 3 1
## 224 Breaking Bad 3 2
## 225 Breaking Bad 3 3
## 226 Breaking Bad 3 4
## 227 Breaking Bad 3 5
## 228 Breaking Bad 3 6
## 229 Breaking Bad 3 7
## 230 Breaking Bad 3 8
## 231 Breaking Bad 3 9
## 232 Breaking Bad 3 10
## 233 Breaking Bad 3 11
## 234 Breaking Bad 3 12
## 235 Breaking Bad 3 13
## 236 Breaking Bad 4 1
## 237 Breaking Bad 4 2
## 238 Breaking Bad 4 3
## 239 Breaking Bad 4 4
## 240 Breaking Bad 4 5
## 241 Breaking Bad 4 6
## 242 Breaking Bad 4 7
## 243 Breaking Bad 4 8
## 244 Breaking Bad 4 9
## 245 Breaking Bad 4 10
## 246 Breaking Bad 4 11
## 247 Breaking Bad 4 12
## 248 Breaking Bad 4 13
## 249 Breaking Bad 5 1
## 250 Breaking Bad 5 2
## 251 Breaking Bad 5 3
## 252 Breaking Bad 5 4
## 253 Breaking Bad 5 5
## 254 Breaking Bad 5 6
## 255 Breaking Bad 5 7
## 256 Breaking Bad 5 8
## 257 Breaking Bad 5 9
## 258 Breaking Bad 5 10
## 259 Breaking Bad 5 11
## 260 Breaking Bad 5 12
## 261 Breaking Bad 5 13
## 262 Breaking Bad 5 14
## 263 Breaking Bad 5 15
## 264 Breaking Bad 5 16
## 265 Deadwood 1 1
## 266 Deadwood 1 2
## 267 Deadwood 1 3
## 268 Deadwood 1 4
## 269 Deadwood 1 5
## 270 Deadwood 1 6
## 271 Deadwood 1 7
## 272 Deadwood 1 8
## 273 Deadwood 1 9
## 274 Deadwood 1 10
## 275 Deadwood 1 11
## 276 Deadwood 1 12
## 277 Deadwood 2 1
## 278 Deadwood 2 2
## 279 Deadwood 2 3
## 280 Deadwood 2 4
## 281 Deadwood 2 5
## 282 Deadwood 2 6
## 283 Deadwood 2 7
## 284 Deadwood 2 8
## 285 Deadwood 2 9
## 286 Deadwood 2 10
## 287 Deadwood 2 11
## 288 Deadwood 2 12
## 289 Deadwood 3 1
## 290 Deadwood 3 2
## 291 Deadwood 3 3
## 292 Deadwood 3 4
## 293 Deadwood 3 5
## 294 Deadwood 3 6
## 295 Deadwood 3 7
## 296 Deadwood 3 8
## 297 Deadwood 3 9
## 298 Deadwood 3 10
## 299 Deadwood 3 11
## 300 Deadwood 3 12
## 301 Mad Men 1 1
## 302 Mad Men 1 2
## 303 Mad Men 1 3
## 304 Mad Men 1 4
## 305 Mad Men 1 5
## 306 Mad Men 1 6
## 307 Mad Men 1 7
## 308 Mad Men 1 8
## 309 Mad Men 1 9
## 310 Mad Men 1 10
## 311 Mad Men 1 11
## 312 Mad Men 1 12
## 313 Mad Men 1 13
## 314 Mad Men 2 1
## 315 Mad Men 2 2
## 316 Mad Men 2 3
## 317 Mad Men 2 4
## 318 Mad Men 2 5
## 319 Mad Men 2 6
## 320 Mad Men 2 7
## 321 Mad Men 2 8
## 322 Mad Men 2 9
## 323 Mad Men 2 10
## 324 Mad Men 2 11
## 325 Mad Men 2 12
## 326 Mad Men 2 13
## 327 Mad Men 3 1
## 328 Mad Men 3 2
## 329 Mad Men 3 3
## 330 Mad Men 3 4
## 331 Mad Men 3 5
## 332 Mad Men 3 6
## 333 Mad Men 3 7
## 334 Mad Men 3 8
## 335 Mad Men 3 9
## 336 Mad Men 3 10
## 337 Mad Men 3 11
## 338 Mad Men 3 12
## 339 Mad Men 3 13
## 340 Mad Men 4 1
## 341 Mad Men 4 2
## 342 Mad Men 4 3
## 343 Mad Men 4 4
## 344 Mad Men 4 5
## 345 Mad Men 4 6
## 346 Mad Men 4 7
## 347 Mad Men 4 8
## 348 Mad Men 4 9
## 349 Mad Men 4 10
## 350 Mad Men 4 11
## 351 Mad Men 4 12
## 352 Mad Men 4 13
## 353 Mad Men 5 1
## 354 Mad Men 5 2
## 355 Mad Men 5 3
## 356 Mad Men 5 4
## 357 Mad Men 5 5
## 358 Mad Men 5 6
## 359 Mad Men 5 7
## 360 Mad Men 5 8
## 361 Mad Men 5 9
## 362 Mad Men 5 10
## 363 Mad Men 5 11
## 364 Mad Men 5 12
## 365 Mad Men 5 13
## 366 Mad Men 6 1
## 367 Mad Men 6 2
## 368 Mad Men 6 3
## 369 Mad Men 6 4
## 370 Mad Men 6 5
## 371 Mad Men 6 6
## 372 Mad Men 6 7
## 373 Mad Men 6 8
## 374 Mad Men 6 9
## 375 Mad Men 6 10
## 376 Mad Men 6 11
## 377 Mad Men 6 12
## 378 Mad Men 6 13
## 379 Mad Men 7 1
## 380 Mad Men 7 2
## 381 Mad Men 7 3
## 382 Mad Men 7 4
## 383 Mad Men 7 5
## 384 Mad Men 7 6
## 385 Mad Men 7 7
## 386 Mad Men 7 8
## 387 Mad Men 7 9
## 388 Mad Men 7 10
## 389 Mad Men 7 11
## 390 Mad Men 7 12
## 391 Mad Men 7 13
## 392 Mad Men 7 14
## 393 Treme 1 1
## 394 Treme 1 2
## 395 Treme 1 3
## 396 Treme 1 4
## 397 Treme 1 5
## 398 Treme 1 6
## 399 Treme 1 7
## 400 Treme 1 8
## 401 Treme 1 9
## 402 Treme 1 10
## 403 Treme 2 1
## 404 Treme 2 2
## 405 Treme 2 3
## 406 Treme 2 4
## 407 Treme 2 5
## 408 Treme 2 6
## 409 Treme 2 7
## 410 Treme 2 8
## 411 Treme 2 9
## 412 Treme 2 10
## 413 Treme 2 11
## 414 Treme 3 1
## 415 Treme 3 2
## 416 Treme 3 3
## 417 Treme 3 4
## 418 Treme 3 5
## 419 Treme 3 6
## 420 Treme 3 7
## 421 Treme 3 8
## 422 Treme 3 9
## 423 Treme 3 10
## 424 Treme 4 1
## 425 Treme 4 2
## 426 Treme 4 3
## 427 Treme 4 4
## 428 Treme 4 5
## 429 Six Feet Under 1 1
## 430 Six Feet Under 1 2
## 431 Six Feet Under 1 3
## 432 Six Feet Under 1 4
## 433 Six Feet Under 1 5
## 434 Six Feet Under 1 6
## 435 Six Feet Under 1 7
## 436 Six Feet Under 1 8
## 437 Six Feet Under 1 9
## 438 Six Feet Under 1 10
## 439 Six Feet Under 1 11
## 440 Six Feet Under 1 12
## 441 Six Feet Under 1 13
## 442 Six Feet Under 2 1
## 443 Six Feet Under 2 2
## 444 Six Feet Under 2 3
## 445 Six Feet Under 2 4
## 446 Six Feet Under 2 5
## 447 Six Feet Under 2 6
## 448 Six Feet Under 2 7
## 449 Six Feet Under 2 8
## 450 Six Feet Under 2 9
## 451 Six Feet Under 2 10
## 452 Six Feet Under 2 11
## 453 Six Feet Under 2 12
## 454 Six Feet Under 2 13
## 455 Six Feet Under 3 1
## 456 Six Feet Under 3 2
## 457 Six Feet Under 3 3
## 458 Six Feet Under 3 4
## 459 Six Feet Under 3 5
## 460 Six Feet Under 3 6
## 461 Six Feet Under 3 7
## 462 Six Feet Under 3 8
## 463 Six Feet Under 3 9
## 464 Six Feet Under 3 10
## 465 Six Feet Under 3 11
## 466 Six Feet Under 3 12
## 467 Six Feet Under 3 13
## 468 Six Feet Under 4 1
## 469 Six Feet Under 4 2
## 470 Six Feet Under 4 3
## 471 Six Feet Under 4 4
## 472 Six Feet Under 4 5
## 473 Six Feet Under 4 6
## 474 Six Feet Under 4 7
## 475 Six Feet Under 4 8
## 476 Six Feet Under 4 9
## 477 Six Feet Under 4 10
## 478 Six Feet Under 4 11
## 479 Six Feet Under 4 12
## 480 Six Feet Under 5 1
## 481 Six Feet Under 5 2
## 482 Six Feet Under 5 3
## 483 Six Feet Under 5 4
## 484 Six Feet Under 5 5
## 485 Six Feet Under 5 6
## 486 Six Feet Under 5 7
## 487 Six Feet Under 5 8
## 488 Six Feet Under 5 9
## 489 Six Feet Under 5 10
## 490 Six Feet Under 5 11
## 491 Six Feet Under 5 12
## 492 Game of Thrones 1 1
## 493 Game of Thrones 1 2
## 494 Game of Thrones 1 3
## 495 Game of Thrones 1 4
## 496 Game of Thrones 1 5
## 497 Game of Thrones 1 6
## 498 Game of Thrones 1 7
## 499 Game of Thrones 1 8
## 500 Game of Thrones 1 9
## 501 Game of Thrones 1 10
## 502 Game of Thrones 2 1
## 503 Game of Thrones 2 2
## 504 Game of Thrones 2 3
## 505 Game of Thrones 2 4
## 506 Game of Thrones 2 5
## 507 Game of Thrones 2 6
## 508 Game of Thrones 2 7
## 509 Game of Thrones 2 8
## 510 Game of Thrones 2 9
## 511 Game of Thrones 2 10
## 512 Game of Thrones 3 1
## 513 Game of Thrones 3 2
## 514 Game of Thrones 3 3
## 515 Game of Thrones 3 4
## 516 Game of Thrones 3 5
## 517 Game of Thrones 3 6
## 518 Game of Thrones 3 7
## 519 Game of Thrones 3 8
## 520 Game of Thrones 3 9
## 521 Game of Thrones 3 10
## 522 Game of Thrones 4 1
## 523 Game of Thrones 4 2
## 524 Game of Thrones 4 3
## 525 Game of Thrones 4 4
## 526 Game of Thrones 4 5
## 527 Game of Thrones 4 6
## 528 Game of Thrones 4 7
## 529 Game of Thrones 4 8
## 530 Game of Thrones 4 9
## 531 Game of Thrones 4 10
## 532 Game of Thrones 5 1
## 533 Game of Thrones 5 2
## 534 Game of Thrones 5 3
## 535 Game of Thrones 5 4
## 536 Game of Thrones 5 5
## 537 Game of Thrones 5 6
## 538 Game of Thrones 5 7
## 539 Game of Thrones 5 8
## 540 Game of Thrones 5 9
## 541 Game of Thrones 5 10
## 542 Game of Thrones 6 1
## 543 Game of Thrones 6 2
## 544 Game of Thrones 6 3
## 545 Game of Thrones 6 4
## 546 Game of Thrones 6 5
## 547 Game of Thrones 6 6
## 548 Game of Thrones 6 7
## 549 Game of Thrones 6 8
## 550 Game of Thrones 6 9
## 551 Game of Thrones 6 10
## 552 The Shield 1 1
## 553 The Shield 1 2
## 554 The Shield 1 3
## 555 The Shield 1 4
## 556 The Shield 1 5
## 557 The Shield 1 6
## 558 The Shield 1 7
## 559 The Shield 1 8
## 560 The Shield 1 9
## 561 The Shield 1 10
## 562 The Shield 1 11
## 563 The Shield 1 12
## 564 The Shield 1 13
## 565 The Shield 2 1
## 566 The Shield 2 2
## 567 The Shield 2 3
## 568 The Shield 2 4
## 569 The Shield 2 5
## 570 The Shield 2 6
## 571 The Shield 2 7
## 572 The Shield 2 8
## 573 The Shield 2 9
## 574 The Shield 2 10
## 575 The Shield 2 11
## 576 The Shield 2 12
## 577 The Shield 2 13
## 578 The Shield 3 1
## 579 The Shield 3 2
## 580 The Shield 3 3
## 581 The Shield 3 4
## 582 The Shield 3 5
## 583 The Shield 3 6
## 584 The Shield 3 7
## 585 The Shield 3 8
## 586 The Shield 3 9
## 587 The Shield 3 10
## 588 The Shield 3 11
## 589 The Shield 3 12
## 590 The Shield 3 13
## 591 The Shield 3 14
## 592 The Shield 3 15
## 593 The Shield 4 1
## 594 The Shield 4 2
## 595 The Shield 4 3
## 596 The Shield 4 4
## 597 The Shield 4 5
## 598 The Shield 4 6
## 599 The Shield 4 7
## 600 The Shield 4 8
## 601 The Shield 4 9
## 602 The Shield 4 10
## 603 The Shield 4 11
## 604 The Shield 4 12
## 605 The Shield 4 13
## 606 The Shield 5 1
## 607 The Shield 5 2
## 608 The Shield 5 3
## 609 The Shield 5 4
## 610 The Shield 5 5
## 611 The Shield 5 6
## 612 The Shield 5 7
## 613 The Shield 5 8
## 614 The Shield 5 9
## 615 The Shield 5 10
## 616 The Shield 5 11
## 617 The Shield 6 1
## 618 The Shield 6 2
## 619 The Shield 6 3
## 620 The Shield 6 4
## 621 The Shield 6 5
## 622 The Shield 6 6
## 623 The Shield 6 7
## 624 The Shield 6 8
## 625 The Shield 6 9
## 626 The Shield 6 10
## 627 The Shield 7 1
## 628 The Shield 7 2
## 629 The Shield 7 3
## 630 The Shield 7 4
## 631 The Shield 7 5
## 632 The Shield 7 6
## 633 The Shield 7 7
## 634 The Shield 7 8
## 635 The Shield 7 9
## 636 The Shield 7 10
## 637 The Shield 7 11
## 638 The Shield 7 12
## 639 The Shield 7 13
## 640 The Shield 7 14
## Episode month day year IMDB
## 1 The Sopranos 1 10 1999 8.7
## 2 46 Long 1 17 1999 8.7
## 3 Denail, Anger, Acceptance 1 24 1999 8.9
## 4 Meadowlands 1 31 1999 8.8
## 5 College 2 7 1999 8.9
## 6 Pax Soprana 2 14 1999 8.7
## 7 Down Neck 2 21 1999 8.6
## 8 The Legend of Tennessee Moltisanti 2 28 1999 8.8
## 9 Boca 3 7 1999 8.7
## 10 A Hit is a Hit 3 14 1999 8.4
## 11 Nobody Knows Anything 3 21 1999 8.8
## 12 Isabella 3 28 1999 9.0
## 13 I Dream of Jeannie Cusamano 4 4 1999 9.1
## 14 Guy Walks Into a Psychiatrist's Office 1 16 2000 8.5
## 15 Do Not Resuscitate 1 23 2000 8.4
## 16 Toodle-Fucking-Oo 1 30 2000 8.6
## 17 Commendatori 2 6 2000 8.7
## 18 Big Girls Don't Cry 2 13 2000 8.7
## 19 The Happy Wanderer 2 20 2000 8.7
## 20 D-Girl 2 27 2000 8.7
## 21 Full Leather Jacket 3 5 2000 8.9
## 22 From Where to Eternity 3 12 2000 8.8
## 23 Bust Out 3 19 2000 8.7
## 24 House Arrest 3 26 2000 8.5
## 25 The Knight in White Sating Armor 4 2 2000 9.1
## 26 Funhouse 4 9 2000 9.2
## 27 Mr. Ruggerio's Neighborhood 3 4 2001 8.7
## 28 Proshai, Livushka 3 4 2001 8.7
## 29 Fortunate Son 3 11 2001 8.6
## 30 Employee of the Month 3 18 2001 9.0
## 31 Another Toothpick 3 25 2001 8.7
## 32 University 4 1 2001 8.7
## 33 Second Opinion 4 8 2001 8.6
## 34 He Is Risen 4 15 2001 8.5
## 35 The Telltale Moozadell 4 22 2001 8.4
## 36 To Save Us All from Satan's Power 4 29 2001 8.6
## 37 Pine Barrens 5 6 2001 9.6
## 38 Amour Fou 5 13 2001 9.1
## 39 Army of One 5 20 2001 9.0
## 40 For All Debts Public and Private 9 15 2002 8.2
## 41 No Show 9 22 2002 8.2
## 42 Christopher 9 29 2002 8.0
## 43 The Weight 10 6 2002 8.3
## 44 Pie-O-My 10 13 2002 8.2
## 45 Everybody Hurts 10 20 2002 8.3
## 46 Watching Too Much Television 10 27 2002 8.2
## 47 Mergers & Acquisitions 11 3 2002 8.2
## 48 Whoever Did This 11 10 2002 8.9
## 49 The Strong, Silent Type 11 17 2002 8.6
## 50 Calling All Cars 11 24 2002 8.1
## 51 Eloise 12 1 2002 8.2
## 52 Whitecaps 12 8 2002 8.7
## 53 Two Tonys 3 7 2004 8.7
## 54 Rat Pack 3 14 2004 8.6
## 55 Where's Johnny? 3 21 2004 8.7
## 56 All Happy Families<U+0085> 3 28 2004 8.5
## 57 Irregular Around the Margins 4 4 2004 9.1
## 58 Sentimental Education 4 11 2004 8.4
## 59 In Camelot 4 18 2004 8.3
## 60 Marco Polo 4 25 2004 8.7
## 61 Unidentified Black Males 5 2 2004 8.8
## 62 Cold Cuts 5 9 2004 8.7
## 63 The Test Dream 5 16 2004 8.6
## 64 Long Term Parking 5 23 2004 9.4
## 65 All Due Respect 6 6 2004 9.0
## 66 Members Only 3 12 2006 9.0
## 67 Join the Club 3 19 2006 8.6
## 68 Mayham 3 26 2006 8.6
## 69 The Fleshy Part of the Thigh 4 2 2006 8.5
## 70 Mr. and Mrs. John Sacrimoni Request 4 9 2006 8.7
## 71 Live Free or Die 4 16 2006 8.6
## 72 Luxury Lounge 4 23 2006 8.4
## 73 Johnny Cakes 4 30 2006 8.4
## 74 The Ride 5 7 2006 8.4
## 75 Moe n' Joe 5 14 2006 8.4
## 76 Cold Stones 5 21 2006 8.7
## 77 Kaisha 6 4 2006 8.4
## 78 Soprano Home Movies 4 8 2007 8.9
## 79 Stage 5 4 15 2007 8.8
## 80 Remember When 4 22 2007 8.5
## 81 Chasing It 4 29 2007 8.3
## 82 Walk Like a Man 5 6 2007 8.7
## 83 Kennedy and Heidi 5 13 2007 9.0
## 84 The Second Coming 5 20 2007 9.1
## 85 The Blue Comet 6 3 2007 9.4
## 86 Made in America 6 10 2007 9.0
## 87 Boardwalk Empire 9 9 2010 8.6
## 88 The Ivory Tower 9 26 2010 7.9
## 89 Broadway Limited 10 3 2010 8.2
## 90 Anastasia 10 10 2010 8.3
## 91 Nights in Ballygran 10 17 2010 8.4
## 92 Family Limitation 10 24 2010 8.3
## 93 Home 10 31 2010 8.6
## 94 Hold Me in Paradise 11 7 2010 8.2
## 95 Belle Femme 11 14 2010 8.6
## 96 The Emerald City 11 21 2010 8.6
## 97 Paris Green 11 28 2010 8.4
## 98 A Return to Normalcy 12 5 2010 8.8
## 99 21 9 25 2011 8.3
## 100 Ourselves Alone 10 2 2011 8.5
## 101 A Dangerous Maid 10 9 2011 8.4
## 102 What Does the Bee Do? 10 16 2011 8.3
## 103 Gimcrack and Bunkum 10 23 2011 8.8
## 104 The Age of Reason 10 30 2011 8.1
## 105 Peg of Old 11 6 2011 8.4
## 106 Two Boats and a Lifeguard 11 13 2011 8.7
## 107 Battle of the Century 11 20 2011 8.6
## 108 Georgia Peaches 11 27 2011 8.7
## 109 Under God's Power She Flourishes 12 4 2011 8.9
## 110 To the Lost 12 11 2011 9.2
## 111 Resolution 9 16 2012 8.5
## 112 Spaghetti and Coffee 9 23 2012 8.1
## 113 Bone for Tuna 9 30 2012 8.3
## 114 Blue Bell Boy 10 7 2012 8.7
## 115 You'd Be Surprised 10 14 2012 8.4
## 116 Ging Gang Goolie 10 21 2012 7.7
## 117 Sunday Best 10 28 2012 8.1
## 118 The Pony 11 4 2012 8.7
## 119 The Milkmaid's Lot 11 11 2012 8.6
## 120 A Man, A Plan 11 18 2012 9.0
## 121 Two Imposters 11 25 2012 9.5
## 122 Margate Sands 12 2 2012 9.4
## 123 New York Sour 9 8 2013 8.3
## 124 Resignation 9 15 2013 8.3
## 125 Arces of Diamonds 9 22 2013 8.1
## 126 All In 9 29 2013 8.6
## 127 Erlkonig 10 6 2013 9.0
## 128 The North Star 10 13 2013 7.9
## 129 William Wilson 10 20 2013 8.0
## 130 The Old Ship of Zion 10 27 2013 8.8
## 131 Marriage and Hunting 11 3 2013 8.7
## 132 White Horse Pike 11 10 2013 8.9
## 133 Havre De Grace 11 17 2013 8.4
## 134 Farewell Daddy Blues 11 24 2013 9.4
## 135 Golden Days for Boys and Girls 9 7 2014 8.5
## 136 The Good Listener 9 14 2014 8.3
## 137 What Jesus Said 9 21 2014 8.1
## 138 Cuanto 9 28 2014 8.7
## 139 King of Norway 10 5 2014 8.5
## 140 Devil You Know 10 12 2014 9.0
## 141 Friendless Child 10 19 2014 9.2
## 142 Eldorado 10 26 2014 9.3
## 143 The Target 6 2 2002 8.1
## 144 The Detail 6 9 2002 8.5
## 145 The Buys 6 16 2002 8.4
## 146 Old Cases 6 23 2002 8.5
## 147 The Pager 6 30 2002 8.5
## 148 The Wire 7 7 2002 8.8
## 149 One Arrest 7 21 2002 8.7
## 150 Lessons 7 28 2002 8.7
## 151 Game Day 8 4 2002 8.9
## 152 The Cost 8 11 2002 9.3
## 153 The Hunt 8 18 2002 9.0
## 154 Cleaning Up 9 1 2002 9.2
## 155 Sentencing 9 8 2002 9.1
## 156 Ebb Tide 6 1 2003 8.1
## 157 Collateral Damage 6 8 2003 8.4
## 158 Hot Shots 6 15 2003 8.4
## 159 Hard Cases 6 22 2003 8.3
## 160 Undertow 6 29 2003 8.5
## 161 All Prologue 7 6 2003 9.0
## 162 Backwash 7 13 2003 8.5
## 163 Duck and Cover 7 27 2003 8.7
## 164 Stray Rounds 8 3 2003 8.8
## 165 Storm Warnings 8 10 2003 9.1
## 166 Bad Dreams 8 17 2003 9.3
## 167 Port in a Storm 8 24 2003 9.2
## 168 Time After Time 9 19 2004 8.4
## 169 All Due Respect 9 26 2004 8.7
## 170 Dead Soldiers 10 3 2004 8.7
## 171 Hamsterdam 10 10 2004 8.7
## 172 Straight and True 10 17 2004 8.8
## 173 Homecoming 10 31 2004 8.9
## 174 Back Burners 11 7 2004 8.8
## 175 Moral Midgetry 11 14 2004 9.0
## 176 Slapstick 11 21 2004 8.9
## 177 Reformation 11 28 2004 8.9
## 178 Middle Ground 12 12 2004 9.6
## 179 Mission Accomplished 12 19 2004 9.4
## 180 Boys of Summer 9 10 2006 8.7
## 181 Soft Eyes 9 17 2006 8.7
## 182 Home Rooms 9 24 2006 8.9
## 183 Refugees 10 1 2006 8.7
## 184 Alliances 10 8 2006 8.8
## 185 Margin of Error 10 15 2005 8.9
## 186 Unto Others 10 29 2006 8.8
## 187 Corner Boys 11 5 2006 8.8
## 188 Know Your Place 11 12 2006 8.7
## 189 Misgivings 11 19 2006 9.0
## 190 A New Day 11 26 2006 9.2
## 191 That's Got His Own 12 3 2006 9.4
## 192 Final Grades 12 10 2006 9.6
## 193 More with Less 1 6 2008 8.5
## 194 Uncomfirmed Reports 1 13 2008 8.6
## 195 Not for Attribution 1 20 2008 8.8
## 196 Transitions 1 27 2008 9.1
## 197 React Quotes 2 3 2008 8.9
## 198 The Dickensian Aspect 2 10 2008 8.8
## 199 Took 2 17 2008 8.8
## 200 Clarifications 2 24 2008 9.1
## 201 Late Editions 3 2 2008 9.4
## 202 30 3 9 2008 9.6
## 203 Pilot 1 20 2008 9.0
## 204 Cat's in the Bag<U+0085> 1 27 2008 8.7
## 205 <U+0085>and the Bag's in the River 2 10 2008 8.8
## 206 Cancer Man 2 17 2008 8.4
## 207 Gray Matter 2 24 2008 8.4
## 208 Crazy Handful of Nothin' 3 2 2008 9.3
## 209 A No-Rough-Stuff Type Deal 3 9 2008 8.9
## 210 Seven Thirty-Seven 3 8 2009 8.7
## 211 Grilled 3 15 2009 9.3
## 212 Bit by a Dead Bee 3 22 2009 8.4
## 213 Down 3 29 2009 8.3
## 214 Breakage 4 5 2009 8.4
## 215 Peekaboo 4 12 2009 8.9
## 216 Negro Y Azul 4 19 2009 8.8
## 217 Better Call Saul 4 26 2009 9.1
## 218 4 Days Out 5 3 2009 9.1
## 219 Over 5 10 2009 8.6
## 220 Mandala 5 17 2009 8.9
## 221 Phoenix 5 24 2009 9.2
## 222 ABQ 5 31 2009 9.2
## 223 No Mas 3 21 2010 8.6
## 224 Caballo Sin Nombre 3 28 2010 8.7
## 225 I.F.T. 4 4 2010 8.5
## 226 Green Light 4 11 2010 8.3
## 227 Mas 4 18 2010 8.7
## 228 Sunset 4 25 2010 9.3
## 229 One Minute 5 2 2010 9.6
## 230 I See You 5 9 2010 8.8
## 231 Kafkaesque 5 16 2010 8.5
## 232 Fly 5 23 2010 7.9
## 233 Abiquiu 5 30 2010 8.5
## 234 Half Measures 6 6 2010 9.5
## 235 Full Measure 6 13 2010 9.6
## 236 Box Cutter 7 17 2011 9.2
## 237 Thirty-Eight Snub 7 24 2011 8.4
## 238 Open House 7 31 2011 8.2
## 239 Bullet Points 8 7 2011 8.7
## 240 Shotgun 8 14 2011 8.7
## 241 Cornered 8 21 2011 8.5
## 242 Problem Dog 8 28 2011 8.9
## 243 Hermanos 9 4 2011 9.3
## 244 Bug 9 11 2011 8.9
## 245 Salud 9 18 2011 9.6
## 246 Crawl Space 9 25 2011 9.7
## 247 End Times 10 2 2011 9.4
## 248 Face Off 10 9 2011 9.9
## 249 Live Free or Die 7 15 2012 9.3
## 250 Madrigal 7 22 2012 9.0
## 251 Hazard Pay 7 29 2012 9.0
## 252 Fifty-One 8 5 2012 8.9
## 253 Dead Freight 8 12 2012 9.7
## 254 Buyout 8 19 2012 9.1
## 255 Say My Name 8 26 2012 9.5
## 256 Gliding Over All 9 2 2012 9.6
## 257 Blood Money 8 11 2013 9.4
## 258 Buried 8 18 2013 9.2
## 259 Confessions 8 25 2013 9.6
## 260 Rabid Dog 9 1 2013 9.2
## 261 To'hajiilee 9 8 2013 9.8
## 262 Ozymandias 9 15 2013 10.0
## 263 Granite State 9 22 2013 9.7
## 264 Felina 9 29 2013 9.9
## 265 Pilot - Deadwood 3 21 2004 8.4
## 266 Deep Water 3 28 2004 8.4
## 267 Reconnoitering the Rim 4 4 2004 8.4
## 268 Here Was a Man 4 11 2004 8.9
## 269 The Trial of Jack McCall 4 18 2004 8.3
## 270 Plague 4 25 2004 8.4
## 271 Bullock Returns to the Camp 5 2 2004 7.8
## 272 Suffer the Little Children 5 9 2004 8.0
## 273 No Other Sons Or Daughters 5 16 2004 8.3
## 274 Mister Wu 5 23 2004 8.7
## 275 Jewel's Boot Is Made For Walking 6 6 2004 8.6
## 276 Sold Under Sin 6 13 2004 9.2
## 277 A Lie Agreed Upon (1) 3 6 2005 8.8
## 278 A Lie Agreed Upon (2) 3 13 2005 8.4
## 279 New Money 3 20 2005 8.3
## 280 Requiem for a Gleet 3 27 2005 8.4
## 281 Complications 4 3 2005 8.4
## 282 Something Very Expensive 4 10 2005 8.6
## 283 E.B. Was Left Out 4 17 2005 8.6
## 284 Childish Things 4 24 2005 8.4
## 285 Amalgamation and Capital 5 1 2005 8.8
## 286 Advances, None Miraculous 5 8 2005 8.6
## 287 The Whores Can Come 5 15 2005 8.6
## 288 Boy the Earth Talks To 5 22 2005 9.1
## 289 Tell Your God to Ready for Blood 6 11 2006 8.6
## 290 I Am Not the Fine Man You Take Me For 6 18 2006 8.6
## 291 True Colors 6 25 2006 8.4
## 292 Full Faith and Credit 7 2 2006 8.4
## 293 A Two-Headed Beast 7 9 2006 9.1
## 294 A Rich Find 7 16 2006 8.5
## 295 Unauthorized Cinnamon 7 23 2006 8.4
## 296 Leviathan Smiles 7 30 2006 8.3
## 297 Amateur Night 8 6 2006 8.5
## 298 A Constant Throb 8 13 2006 8.8
## 299 The Catbird Seat 8 20 2006 8.9
## 300 Tell Him Something Pretty 8 27 2006 8.7
## 301 Smoke Gets in Your Eyes 7 19 2007 8.2
## 302 Ladies Room 7 26 2007 7.6
## 303 Marriage of Figaro 8 2 2007 7.7
## 304 New Amsterdam 8 9 2007 8.0
## 305 5G 8 16 2007 8.2
## 306 Babylon 8 23 2007 8.0
## 307 Red in the Face 8 30 2007 8.1
## 308 The Hobo Code 9 6 2007 8.4
## 309 Shoot 9 13 2007 8.3
## 310 Long Weekend 9 27 2007 8.3
## 311 Indian Summer 10 4 2007 8.2
## 312 Nixon vs. Kennedy 10 11 2007 9.0
## 313 The Wheel 10 18 2007 9.0
## 314 For Those Who Think Young 7 27 2008 7.8
## 315 Flight 1 8 3 2008 8.0
## 316 The Benefactor 8 10 2008 8.0
## 317 Three Sundays 8 17 2008 8.2
## 318 The New Girl 8 24 2008 8.4
## 319 Maidenform 8 31 2008 8.1
## 320 The Gold Violin 9 7 2008 8.5
## 321 A Night to Remember 9 14 2008 8.4
## 322 Six Month Leave 9 28 2008 8.5
## 323 The Inheritance 10 5 2008 8.1
## 324 The Jet Set 10 12 2008 8.4
## 325 The Mountain King 10 19 2008 8.6
## 326 Meditations in an Emergency 10 26 2008 9.0
## 327 Out of Town 8 16 2009 8.3
## 328 Love Among the Ruins 8 23 2009 8.0
## 329 My Old Kentucky Home 8 30 2009 8.2
## 330 The Arrangements 9 6 2009 8.2
## 331 The Fog 9 13 2009 8.1
## 332 Guy Walks Into an Advertising Agency 9 20 2009 9.1
## 333 Seven Twenty Three 9 27 2009 8.5
## 334 Souvenir 10 4 2009 8.1
## 335 Wee Small Hours 10 11 2009 8.3
## 336 The Color Blue 10 18 2009 8.4
## 337 The Gypsy and the Hobo 10 25 2009 9.2
## 338 The Grown Ups 11 1 2009 8.9
## 339 Shut the Door, Have a Seat 11 8 2009 9.6
## 340 Public Relations 7 25 2010 8.7
## 341 Christmas Comes But Once a Year 8 1 2010 8.3
## 342 The Good News 8 8 2010 8.7
## 343 The Rejected 8 15 2010 8.4
## 344 The Chrysanthemum and the Sword 8 22 2010 8.7
## 345 Waldorf Stories 8 29 2010 8.6
## 346 The Suitcase 9 5 2010 9.7
## 347 The Summer Man 9 12 2010 8.7
## 348 The Beautiful Girls 9 19 2010 8.8
## 349 Hands and Knees 9 26 2010 8.8
## 350 Chinese Wall 10 3 2010 8.5
## 351 Blowing Smoke 10 10 2010 8.9
## 352 Tomorrowland 10 17 2010 9.0
## 353 A Little Kiss 3 25 2012 8.6
## 354 A Little Kiss Part 2 3 25 2012 8.6
## 355 Tea Leaves 4 1 2012 8.0
## 356 Mystery Date 4 8 2012 8.7
## 357 Signal 30 4 15 2012 9.0
## 358 Far Away Places 4 22 2012 9.1
## 359 At the Codfish Ball 4 29 2012 8.7
## 360 Lazy Lazarus 5 6 2012 8.4
## 361 Dark Shadows 5 13 2012 8.2
## 362 Christmas Waltz 5 20 2012 8.3
## 363 The Other Woman 5 27 2012 9.4
## 364 Commissions and Fees 6 3 2012 9.3
## 365 The Phantom 6 10 2012 8.6
## 366 The Doorway 4 7 2013 7.8
## 367 The Doorway Part 2 4 7 2013 7.9
## 368 Collaborators 4 14 2013 8.1
## 369 To Have and to Hold 4 21 2013 8.3
## 370 The Flood 4 28 2013 8.3
## 371 For Immediate Release 5 5 2013 8.9
## 372 Man With a Plan 5 12 2013 8.2
## 373 The Crash 5 19 2013 8.7
## 374 The Better Half 5 26 2013 8.5
## 375 A Tale of Two Cities 6 2 2013 8.2
## 376 Favors 6 9 2013 8.8
## 377 The Quality of Mercy 6 16 2013 8.6
## 378 In Care Of 6 23 2013 9.2
## 379 Time Zones 4 3 2014 8.1
## 380 A Day's Work 4 20 2014 8.5
## 381 Field Trip 4 27 2014 8.7
## 382 The Monolith 5 4 2014 8.6
## 383 The Runaways 5 11 2014 8.7
## 384 The Strategy 5 18 2014 9.0
## 385 Waterloo 5 25 2014 9.5
## 386 Severance 4 5 2015 8.4
## 387 New Business 4 12 2015 8.1
## 388 The Forecast 4 19 2015 8.5
## 389 Time & Life 4 26 2015 9.1
## 390 Lost Horizon 5 3 2015 9.1
## 391 The Milk and Honey Route 5 10 2015 9.2
## 392 Person to Person 5 17 2015 9.3
## 393 Do You Know What It Means 4 11 2010 8.1
## 394 Meet De Boys on the Battlefront 4 18 2010 8.3
## 395 Right Place, Wrong Time 4 25 2010 8.2
## 396 At the Foot of Canal Street 5 2 2010 8.1
## 397 Shame, Shame, Shame 5 9 2010 8.4
## 398 Shallow Water, Oh Mama 5 16 2010 8.0
## 399 Smoke My Peace Pipe 5 23 2010 8.6
## 400 All on a Mardi Gras Day 6 6 2010 8.6
## 401 Wish Someone Would Care 6 13 2010 8.5
## 402 I'll Fly Away 6 20 2010 8.7
## 403 Accentuate the Positive 4 24 2011 8.0
## 404 Everything I Do Gonh Be Funky 5 1 2011 7.9
## 405 On Your Way Down 5 8 2011 8.5
## 406 Santa Claus, Do You Ever Get the Blues? 5 15 2011 8.1
## 407 Slip Away 5 22 2011 8.1
## 408 Feels Like Rain 5 29 2011 8.1
## 409 Carnival Time 6 5 2011 8.4
## 410 Can I Change My Mind 6 12 2011 8.2
## 411 What Is New Orleans? 6 19 2011 8.6
## 412 That's What Lovers Do 6 26 2011 8.3
## 413 Do Whatcha Wanna 7 3 2011 8.9
## 414 Knock with Me - Rock with Me 9 23 2012 8.0
## 415 Saints 9 30 2012 7.9
## 416 Me Donkey Want Water 10 7 2012 7.9
## 417 The Greatest Love 10 14 2012 8.0
## 418 I Thought I Heard Buddy Bolden Say 10 21 2012 8.1
## 419 Careless Love 10 28 2012 7.9
## 420 Promised Land 11 4 2012 8.2
## 421 Don't You Leave Me Here 11 11 2012 8.0
## 422 Poor Man's Paradise 11 18 2012 8.0
## 423 Tipitina 11 25 2012 8.3
## 424 Yes We Can 12 1 2013 8.2
## 425 This City 12 8 2013 7.8
## 426 Dippermouth Blues 12 15 2013 8.0
## 427 Sunset on Louisianne 12 22 2013 8.2
## 428 <U+0085>To Miss New Orleans 12 29 2013 8.5
## 429 Pilot 6 3 2001 9.0
## 430 The Will 6 10 2001 8.3
## 431 The Foot 6 17 2001 8.6
## 432 Familia 6 24 2001 8.6
## 433 An Open Book 7 1 2001 8.6
## 434 The Room 7 8 2001 8.8
## 435 Brotherhood 7 15 2001 8.3
## 436 Crossroads 7 22 2001 8.5
## 437 Life's Too Short 7 29 2001 8.8
## 438 The New Person 8 5 2001 8.7
## 439 The Trip 8 12 2001 8.6
## 440 A Private Life 8 19 2001 9.0
## 441 Knock, Knock 8 19 2001 8.9
## 442 In the Game 3 3 2002 8.7
## 443 Out, Out, Brief Candle 3 10 2002 8.5
## 444 The Plan 3 17 2002 8.4
## 445 Driving Mr. Mossback 3 24 2002 8.7
## 446 The Invisible Woman 3 31 2002 8.7
## 447 In Place of Anger 4 7 2002 8.5
## 448 Back to the Garden 4 14 2002 8.4
## 449 It's the Most Wonderful Time of the Year 4 21 2002 9.2
## 450 Someone Else's Eyes 4 28 2002 8.3
## 451 The Secret 5 5 2002 8.5
## 452 The Liar and the Whore 5 12 2002 8.7
## 453 I'll Take You 5 19 2002 9.1
## 454 The Last Time 6 2 2002 9.3
## 455 Perfect Circles 3 2 2003 8.5
## 456 You Never Know 3 9 2003 8.3
## 457 The Eye Inside 3 16 2003 8.3
## 458 Nobody Sleeps 3 23 2003 8.9
## 459 The Trap 3 30 2003 8.3
## 460 Making Love Work 4 6 2003 8.3
## 461 Timing & Space 4 13 2003 8.4
## 462 Tears, Bones and Desire 4 20 2003 8.4
## 463 The Opening 4 27 2003 8.3
## 464 Everyone Leaves 5 4 2003 8.6
## 465 Death Works Overtime 5 11 2003 9.0
## 466 Twilight 5 18 2003 8.7
## 467 I'm Sorry, I'm Lost 6 1 2003 9.3
## 468 Falling Into Place 6 13 2004 9.0
## 469 In Case of Rapture 6 20 2004 8.1
## 470 Parallel Play 6 27 2004 8.3
## 471 Can I Come Up Now? 7 11 2004 8.2
## 472 That's My Dog 7 18 2004 9.2
## 473 Terror Starts at Home 7 25 2004 8.6
## 474 The Dare 8 1 2004 8.2
## 475 Coming and Going 8 8 2004 8.3
## 476 Grinding the Corn 8 15 2004 8.1
## 477 The Black Forest 8 22 2004 8.1
## 478 Bomb Shelter 8 29 2004 8.4
## 479 Untitled 9 12 2004 9.2
## 480 A Coat of White Primer 6 6 2005 8.6
## 481 Dancing for Me 6 13 2005 8.3
## 482 Hold My Hand 6 20 2005 8.6
## 483 Time Flies 6 27 2005 8.9
## 484 Eat a Peach 7 4 2005 8.5
## 485 Rainbow of Her Reasons 7 10 2005 8.8
## 486 The Silence 7 17 2005 8.4
## 487 Singing For Our Lives 7 24 2005 9.0
## 488 Ecotone 7 31 2005 9.5
## 489 All Alone 8 7 2005 9.7
## 490 Static 8 14 2005 9.3
## 491 Everyone's Waiting 8 21 2005 9.9
## 492 Winter Is Coming 4 17 2011 8.9
## 493 The Kingsroad 4 24 2011 8.7
## 494 Lord Snow 5 1 2011 8.6
## 495 Cripples, Bastards, and Broken Things 5 8 2011 8.7
## 496 The Wolf and the Lion 5 15 2011 9.0
## 497 A Golden Crown 5 22 2011 9.1
## 498 You Win or You Die 5 29 2011 9.2
## 499 The Pointy End 6 5 2011 9.0
## 500 Baelor 6 12 2011 9.5
## 501 Fire and Blood 6 19 2011 9.4
## 502 The North Remembers 4 1 2012 8.8
## 503 The Night Lands 4 8 2012 8.5
## 504 What is Dead May Never Die 4 15 2012 8.8
## 505 Garden of Bones 4 22 2012 8.7
## 506 The Ghost of Harrenhal 4 29 2012 8.8
## 507 The Old Gods and the New 5 6 2012 9.0
## 508 A Man Without Honor 5 13 2012 8.9
## 509 The Prince of Winterfell 5 20 2012 8.7
## 510 Blackwater 5 27 2012 9.7
## 511 Valar Morghulis 6 3 2012 9.4
## 512 Valar Dohaeris 3 31 2013 8.7
## 513 Dark Wings, Dark Words 4 7 2013 8.6
## 514 Walk of Punishment 4 14 2013 8.8
## 515 And Now His Watch Is Ended 4 21 2013 9.5
## 516 Kissed by Fire 4 28 2013 8.9
## 517 The Climb 5 5 2013 8.7
## 518 The Bears and the Maiden Fair 5 12 2013 8.6
## 519 Second Sons 5 19 2013 8.9
## 520 The Rains of Castamere 6 2 2013 9.9
## 521 Mhysa 6 9 2013 9.0
## 522 Two Swords 4 6 2014 9.1
## 523 The Lion and the Rose 4 13 2014 9.7
## 524 Breaker of Chains 4 20 2014 8.8
## 525 Oathkeeper 4 27 2014 8.8
## 526 First of His Name 5 4 2014 8.7
## 527 The Laws of Gods and Men 5 11 2014 9.7
## 528 Mockingbird 5 18 2014 9.1
## 529 The Mountain and the Viper 6 1 2014 9.7
## 530 The Watchers on the Wall 6 8 2014 9.5
## 531 The Children 6 15 2014 9.6
## 532 The Wars to Come 4 12 2015 8.4
## 533 The House of Black and White 4 19 2015 8.5
## 534 High Sparrow 4 26 2015 8.5
## 535 Sons of the Harpy 5 3 2015 8.7
## 536 Kill the Boy 5 10 2015 8.6
## 537 Unbowed, Unbent, Unbroken 5 17 2015 7.9
## 538 The Gift 5 24 2015 9.0
## 539 Hardhome 5 31 2015 9.9
## 540 The Dance of Dragons 6 7 2015 9.4
## 541 Mother's Mercy 6 14 2015 8.8
## 542 The Red Woman 4 24 2016 8.4
## 543 Home 5 1 2016 9.5
## 544 Oathbreaker 5 8 2016 8.7
## 545 Book of the Stranger 5 15 2016 9.2
## 546 The Door 5 22 2016 9.7
## 547 Blood of My Blood 5 29 2016 8.3
## 548 The Broken Man 6 5 2016 8.6
## 549 No One 6 12 2016 8.2
## 550 Battle of the Bastards 6 19 2016 9.9
## 551 The Winds of Winter 6 26 2016 9.9
## 552 Pilot 3 12 2002 8.1
## 553 Our Gang 3 19 2002 7.5
## 554 The Spread 3 26 2002 7.3
## 555 Dawg Days 4 2 2002 7.6
## 556 Blowback 4 9 2002 8.2
## 557 Cherrypoppers 4 16 2002 8.0
## 558 Pay in Pain 4 23 2002 7.6
## 559 Cupid & Psycho 4 30 2002 7.5
## 560 Throwaway 5 7 2002 7.6
## 561 Dragonchasers 5 14 2002 8.1
## 562 Carnivores 5 21 2002 7.7
## 563 Two Days of Blood (Part 1) 5 28 2002 7.4
## 564 Circles (Part 2) 6 4 2002 8.1
## 565 The Quick Fix 1 7 2003 7.4
## 566 Dead Soldiers 1 14 2003 8.1
## 567 Partners 1 21 2003 7.4
## 568 Carte Blanche 1 28 2003 7.8
## 569 Greenlit 2 4 2003 7.5
## 570 Homewrecker 2 11 2003 7.5
## 571 Barnstormers 2 18 2003 7.4
## 572 Scar Tissue 2 25 2003 7.7
## 573 Co-Pilot 3 4 2003 7.1
## 574 Coyotes 3 11 2003 7.6
## 575 Inferno 3 18 2003 7.7
## 576 Breakpoint 3 25 2003 7.4
## 577 Dominoes Falling 4 1 2003 8.0
## 578 Playing Tight 3 9 2004 7.9
## 579 Blood and Water 3 16 2004 7.5
## 580 Bottom Bitch 3 23 2004 7.3
## 581 Streaks and Tips 3 30 2004 7.8
## 582 Mum 4 6 2004 7.9
## 583 Posse 4 13 2004 7.3
## 584 Safe 4 20 2004 7.5
## 585 Cracking Ice 4 27 2004 7.4
## 586 Slipknot 5 4 2004 7.6
## 587 What Power Is<U+0085> 5 11 2004 7.7
## 588 Strays 5 18 2004 8.1
## 589 Riceburner 5 25 2004 7.7
## 590 Fire in the Hole 6 1 2004 8.2
## 591 All In 6 8 2004 8.4
## 592 On Tilt 6 15 2004 8.5
## 593 The Cure 3 15 2005 6.8
## 594 Grave 3 22 2005 6.5
## 595 Bang 3 29 2005 6.4
## 596 Doghouse 4 5 2005 6.7
## 597 Tar Baby 4 12 2005 7.0
## 598 Insurgents 4 19 2005 6.8
## 599 Hurt 4 26 2005 6.7
## 600 Cut Throat 5 3 2005 6.9
## 601 String Theory 5 17 2005 6.7
## 602 Back in the Hole 5 24 2005 6.8
## 603 A Thousand Deaths 5 31 2005 6.7
## 604 Judas Priest 6 7 2005 7.0
## 605 Ain't That a Shame 6 14 2005 6.3
## 606 Extraction 1 10 2006 7.2
## 607 Enemy of Good 1 17 2006 7.2
## 608 Jailbait 1 24 2006 7.1
## 609 Tapa Boca 1 31 2006 7.2
## 610 Trophy 2 7 2006 7.3
## 611 Rap Payback 2 14 2006 7.2
## 612 Man Inside 2 21 2006 7.2
## 613 Kavanaugh 2 28 2006 7.3
## 614 Smoked 3 7 2006 7.2
## 615 Of Mice and Lem 3 14 2006 7.3
## 616 Postpartum 3 21 2006 8.1
## 617 On the Jones 4 3 2007 7.1
## 618 Baptism by Fire 4 10 2007 7.6
## 619 Back to One 4 17 2007 7.7
## 620 The New Guy 4 24 2007 7.6
## 621 Haunts 5 1 2007 7.3
## 622 Chasing Ghosts 5 8 2007 8.1
## 623 Exiled 5 15 2007 7.6
## 624 The Math of the Wrath 5 22 2007 7.4
## 625 Recoil 5 29 2007 7.6
## 626 Spanish Practices 6 5 2007 8.3
## 627 Coefficient of Drag 9 2 2008 8.5
## 628 Snitch 9 9 2008 7.3
## 629 Money Shot 9 16 2008 7.4
## 630 Genocidee 9 23 2008 7.4
## 631 Game Face 9 30 2008 7.3
## 632 Animal Control 10 7 2008 8.5
## 633 Bitches Brew 10 14 2008 7.2
## 634 Parricide 10 21 2008 8.1
## 635 Moving Day 10 28 2008 7.5
## 636 Party Line 11 4 2008 7.6
## 637 Petty Cash 11 11 2008 7.5
## 638 Possible Kill Screen 11 18 2008 8.7
## 639 Family Meeting 11 25 2008 9.1
## 640 Family Meeting, Pt. 2 11 25 2008 9.1tv %>% filter(IMDB >=9.0) %>% select(Show, Episode, IMDB)## Warning: package 'bindrcpp' was built under R version 3.4.2## Show Episode IMDB
## 1 The Sopranos Isabella 9.0
## 2 The Sopranos I Dream of Jeannie Cusamano 9.1
## 3 The Sopranos The Knight in White Sating Armor 9.1
## 4 The Sopranos Funhouse 9.2
## 5 The Sopranos Employee of the Month 9.0
## 6 The Sopranos Pine Barrens 9.6
## 7 The Sopranos Amour Fou 9.1
## 8 The Sopranos Army of One 9.0
## 9 The Sopranos Irregular Around the Margins 9.1
## 10 The Sopranos Long Term Parking 9.4
## 11 The Sopranos All Due Respect 9.0
## 12 The Sopranos Members Only 9.0
## 13 The Sopranos Kennedy and Heidi 9.0
## 14 The Sopranos The Second Coming 9.1
## 15 The Sopranos The Blue Comet 9.4
## 16 The Sopranos Made in America 9.0
## 17 Boardwalk Empire To the Lost 9.2
## 18 Boardwalk Empire A Man, A Plan 9.0
## 19 Boardwalk Empire Two Imposters 9.5
## 20 Boardwalk Empire Margate Sands 9.4
## 21 Boardwalk Empire Erlkonig 9.0
## 22 Boardwalk Empire Farewell Daddy Blues 9.4
## 23 Boardwalk Empire Devil You Know 9.0
## 24 Boardwalk Empire Friendless Child 9.2
## 25 Boardwalk Empire Eldorado 9.3
## 26 The Wire The Cost 9.3
## 27 The Wire The Hunt 9.0
## 28 The Wire Cleaning Up 9.2
## 29 The Wire Sentencing 9.1
## 30 The Wire All Prologue 9.0
## 31 The Wire Storm Warnings 9.1
## 32 The Wire Bad Dreams 9.3
## 33 The Wire Port in a Storm 9.2
## 34 The Wire Moral Midgetry 9.0
## 35 The Wire Middle Ground 9.6
## 36 The Wire Mission Accomplished 9.4
## 37 The Wire Misgivings 9.0
## 38 The Wire A New Day 9.2
## 39 The Wire That's Got His Own 9.4
## 40 The Wire Final Grades 9.6
## 41 The Wire Transitions 9.1
## 42 The Wire Clarifications 9.1
## 43 The Wire Late Editions 9.4
## 44 The Wire 30 9.6
## 45 Breaking Bad Pilot 9.0
## 46 Breaking Bad Crazy Handful of Nothin' 9.3
## 47 Breaking Bad Grilled 9.3
## 48 Breaking Bad Better Call Saul 9.1
## 49 Breaking Bad 4 Days Out 9.1
## 50 Breaking Bad Phoenix 9.2
## 51 Breaking Bad ABQ 9.2
## 52 Breaking Bad Sunset 9.3
## 53 Breaking Bad One Minute 9.6
## 54 Breaking Bad Half Measures 9.5
## 55 Breaking Bad Full Measure 9.6
## 56 Breaking Bad Box Cutter 9.2
## 57 Breaking Bad Hermanos 9.3
## 58 Breaking Bad Salud 9.6
## 59 Breaking Bad Crawl Space 9.7
## 60 Breaking Bad End Times 9.4
## 61 Breaking Bad Face Off 9.9
## 62 Breaking Bad Live Free or Die 9.3
## 63 Breaking Bad Madrigal 9.0
## 64 Breaking Bad Hazard Pay 9.0
## 65 Breaking Bad Dead Freight 9.7
## 66 Breaking Bad Buyout 9.1
## 67 Breaking Bad Say My Name 9.5
## 68 Breaking Bad Gliding Over All 9.6
## 69 Breaking Bad Blood Money 9.4
## 70 Breaking Bad Buried 9.2
## 71 Breaking Bad Confessions 9.6
## 72 Breaking Bad Rabid Dog 9.2
## 73 Breaking Bad To'hajiilee 9.8
## 74 Breaking Bad Ozymandias 10.0
## 75 Breaking Bad Granite State 9.7
## 76 Breaking Bad Felina 9.9
## 77 Deadwood Sold Under Sin 9.2
## 78 Deadwood Boy the Earth Talks To 9.1
## 79 Deadwood A Two-Headed Beast 9.1
## 80 Mad Men Nixon vs. Kennedy 9.0
## 81 Mad Men The Wheel 9.0
## 82 Mad Men Meditations in an Emergency 9.0
## 83 Mad Men Guy Walks Into an Advertising Agency 9.1
## 84 Mad Men The Gypsy and the Hobo 9.2
## 85 Mad Men Shut the Door, Have a Seat 9.6
## 86 Mad Men The Suitcase 9.7
## 87 Mad Men Tomorrowland 9.0
## 88 Mad Men Signal 30 9.0
## 89 Mad Men Far Away Places 9.1
## 90 Mad Men The Other Woman 9.4
## 91 Mad Men Commissions and Fees 9.3
## 92 Mad Men In Care Of 9.2
## 93 Mad Men The Strategy 9.0
## 94 Mad Men Waterloo 9.5
## 95 Mad Men Time & Life 9.1
## 96 Mad Men Lost Horizon 9.1
## 97 Mad Men The Milk and Honey Route 9.2
## 98 Mad Men Person to Person 9.3
## 99 Six Feet Under Pilot 9.0
## 100 Six Feet Under A Private Life 9.0
## 101 Six Feet Under It's the Most Wonderful Time of the Year 9.2
## 102 Six Feet Under I'll Take You 9.1
## 103 Six Feet Under The Last Time 9.3
## 104 Six Feet Under Death Works Overtime 9.0
## 105 Six Feet Under I'm Sorry, I'm Lost 9.3
## 106 Six Feet Under Falling Into Place 9.0
## 107 Six Feet Under That's My Dog 9.2
## 108 Six Feet Under Untitled 9.2
## 109 Six Feet Under Singing For Our Lives 9.0
## 110 Six Feet Under Ecotone 9.5
## 111 Six Feet Under All Alone 9.7
## 112 Six Feet Under Static 9.3
## 113 Six Feet Under Everyone's Waiting 9.9
## 114 Game of Thrones The Wolf and the Lion 9.0
## 115 Game of Thrones A Golden Crown 9.1
## 116 Game of Thrones You Win or You Die 9.2
## 117 Game of Thrones The Pointy End 9.0
## 118 Game of Thrones Baelor 9.5
## 119 Game of Thrones Fire and Blood 9.4
## 120 Game of Thrones The Old Gods and the New 9.0
## 121 Game of Thrones Blackwater 9.7
## 122 Game of Thrones Valar Morghulis 9.4
## 123 Game of Thrones And Now His Watch Is Ended 9.5
## 124 Game of Thrones The Rains of Castamere 9.9
## 125 Game of Thrones Mhysa 9.0
## 126 Game of Thrones Two Swords 9.1
## 127 Game of Thrones The Lion and the Rose 9.7
## 128 Game of Thrones The Laws of Gods and Men 9.7
## 129 Game of Thrones Mockingbird 9.1
## 130 Game of Thrones The Mountain and the Viper 9.7
## 131 Game of Thrones The Watchers on the Wall 9.5
## 132 Game of Thrones The Children 9.6
## 133 Game of Thrones The Gift 9.0
## 134 Game of Thrones Hardhome 9.9
## 135 Game of Thrones The Dance of Dragons 9.4
## 136 Game of Thrones Home 9.5
## 137 Game of Thrones Book of the Stranger 9.2
## 138 Game of Thrones The Door 9.7
## 139 Game of Thrones Battle of the Bastards 9.9
## 140 Game of Thrones The Winds of Winter 9.9
## 141 The Shield Family Meeting 9.1
## 142 The Shield Family Meeting, Pt. 2 9.1Data based on information retrieved from www.nyknicks.com
#Import tv data
knicks <- read.csv("C:\\Users\\bkl2001\\Documents\\Personal\\CUNY\\Classes\\DATA 607 Data Acquisition and Management\\Week 5\\knicks.csv")Knicks dataset has 49 observations and 14 variables
#View data set dimensions
dim(knicks)## [1] 19 7#View the head of the knicks data set
head(knicks)## first last pos num ht wt dob
## 1 ron baker g 31 76 220 3/30/1993
## 2 michael beasley f 8 81 235 1/9/1989
## 3 damyean dotson g 21 77 210 5/6/1994
## 4 tim hardaway jr g 3 78 205 3/16/1992
## 5 nigel hayes f 18 79 254 12/16/1994
## 6 willy hernangomez c 14 83 240 5/27/1994#View the tail of the knicks data set
tail(knicks)## first last pos num ht wt dob
## 14 frank ntilikina g 11 77 190 7/28/1998
## 15 kyle o'quinn f-c 9 82 250 3/26/1990
## 16 kristaps prozingis f-c 6 87 240 8/2/1995
## 17 xavier rathan-mayes g 17 76 208 4/29/1994
## 18 ramon sessions g 1 75 190 4/11/1986
## 19 lance thomas f 42 80 235 4/24/1988#Average height of Knicks players
summarise(knicks, avg_ht = mean(ht))## avg_ht
## 1 79.73684#Average weight of Knicks players
summarise(knicks, avg_wt = mean(wt))## avg_wt
## 1 222.9474#Number of players on the roster
count(knicks,pos)## # A tibble: 4 x 2
## pos n
## <fctr> <int>
## 1 c 3
## 2 f 5
## 3 f-c 3
## 4 g 8#Standard deviation of height
summarise(knicks, sd_ht = sd(ht))## sd_ht
## 1 3.493519#Standard deviation of weight
summarise(knicks, sd_wt = sd(wt))## sd_wt
## 1 20.89783#Median height
summarise(knicks, med_t = median(ht))## med_t
## 1 80#Median weight
summarise(knicks, med_t= median(wt))## med_t
## 1 220#Use unite function to merge first and last
unite(knicks, "full",first,last, sep=" ")## full pos num ht wt dob
## 1 ron baker g 31 76 220 3/30/1993
## 2 michael beasley f 8 81 235 1/9/1989
## 3 damyean dotson g 21 77 210 5/6/1994
## 4 tim hardaway jr g 3 78 205 3/16/1992
## 5 nigel hayes f 18 79 254 12/16/1994
## 6 willy hernangomez c 14 83 240 5/27/1994
## 7 jarret jack g 55 75 200 10/28/1983
## 8 enes kanter c 0 83 245 5/20/1992
## 9 luke kornet f-c 2 85 250 7/15/1995
## 10 mindaugas kuzminskas f 91 81 215 10/19/1989
## 11 courtney lee g 5 77 200 10/3/1985
## 12 doug mcdermott f 20 80 219 1/3/1992
## 13 joakim noah c 13 83 230 2/25/1985
## 14 frank ntilikina g 11 77 190 7/28/1998
## 15 kyle o'quinn f-c 9 82 250 3/26/1990
## 16 kristaps prozingis f-c 6 87 240 8/2/1995
## 17 xavier rathan-mayes g 17 76 208 4/29/1994
## 18 ramon sessions g 1 75 190 4/11/1986
## 19 lance thomas f 42 80 235 4/24/1988#Select players and their respective dob
select(knicks, first, last, dob)## first last dob
## 1 ron baker 3/30/1993
## 2 michael beasley 1/9/1989
## 3 damyean dotson 5/6/1994
## 4 tim hardaway jr 3/16/1992
## 5 nigel hayes 12/16/1994
## 6 willy hernangomez 5/27/1994
## 7 jarret jack 10/28/1983
## 8 enes kanter 5/20/1992
## 9 luke kornet 7/15/1995
## 10 mindaugas kuzminskas 10/19/1989
## 11 courtney lee 10/3/1985
## 12 doug mcdermott 1/3/1992
## 13 joakim noah 2/25/1985
## 14 frank ntilikina 7/28/1998
## 15 kyle o'quinn 3/26/1990
## 16 kristaps prozingis 8/2/1995
## 17 xavier rathan-mayes 4/29/1994
## 18 ramon sessions 4/11/1986
## 19 lance thomas 4/24/1988#Select all players minus their dob
select(knicks, -dob)## first last pos num ht wt
## 1 ron baker g 31 76 220
## 2 michael beasley f 8 81 235
## 3 damyean dotson g 21 77 210
## 4 tim hardaway jr g 3 78 205
## 5 nigel hayes f 18 79 254
## 6 willy hernangomez c 14 83 240
## 7 jarret jack g 55 75 200
## 8 enes kanter c 0 83 245
## 9 luke kornet f-c 2 85 250
## 10 mindaugas kuzminskas f 91 81 215
## 11 courtney lee g 5 77 200
## 12 doug mcdermott f 20 80 219
## 13 joakim noah c 13 83 230
## 14 frank ntilikina g 11 77 190
## 15 kyle o'quinn f-c 9 82 250
## 16 kristaps prozingis f-c 6 87 240
## 17 xavier rathan-mayes g 17 76 208
## 18 ramon sessions g 1 75 190
## 19 lance thomas f 42 80 235#Select all players with a jersey number over 20
filter(knicks, num > 20)## first last pos num ht wt dob
## 1 ron baker g 31 76 220 3/30/1993
## 2 damyean dotson g 21 77 210 5/6/1994
## 3 jarret jack g 55 75 200 10/28/1983
## 4 mindaugas kuzminskas f 91 81 215 10/19/1989
## 5 lance thomas f 42 80 235 4/24/1988#Select all players over 6 feet 8 inches tall
filter(knicks, ht >= 80)## first last pos num ht wt dob
## 1 michael beasley f 8 81 235 1/9/1989
## 2 willy hernangomez c 14 83 240 5/27/1994
## 3 enes kanter c 0 83 245 5/20/1992
## 4 luke kornet f-c 2 85 250 7/15/1995
## 5 mindaugas kuzminskas f 91 81 215 10/19/1989
## 6 doug mcdermott f 20 80 219 1/3/1992
## 7 joakim noah c 13 83 230 2/25/1985
## 8 kyle o'quinn f-c 9 82 250 3/26/1990
## 9 kristaps prozingis f-c 6 87 240 8/2/1995
## 10 lance thomas f 42 80 235 4/24/1988#Sort players by num lowest to highest
arrange(knicks, num)## first last pos num ht wt dob
## 1 enes kanter c 0 83 245 5/20/1992
## 2 ramon sessions g 1 75 190 4/11/1986
## 3 luke kornet f-c 2 85 250 7/15/1995
## 4 tim hardaway jr g 3 78 205 3/16/1992
## 5 courtney lee g 5 77 200 10/3/1985
## 6 kristaps prozingis f-c 6 87 240 8/2/1995
## 7 michael beasley f 8 81 235 1/9/1989
## 8 kyle o'quinn f-c 9 82 250 3/26/1990
## 9 frank ntilikina g 11 77 190 7/28/1998
## 10 joakim noah c 13 83 230 2/25/1985
## 11 willy hernangomez c 14 83 240 5/27/1994
## 12 xavier rathan-mayes g 17 76 208 4/29/1994
## 13 nigel hayes f 18 79 254 12/16/1994
## 14 doug mcdermott f 20 80 219 1/3/1992
## 15 damyean dotson g 21 77 210 5/6/1994
## 16 ron baker g 31 76 220 3/30/1993
## 17 lance thomas f 42 80 235 4/24/1988
## 18 jarret jack g 55 75 200 10/28/1983
## 19 mindaugas kuzminskas f 91 81 215 10/19/1989#Sort players by wt highest to lowest
arrange(knicks, desc(wt))## first last pos num ht wt dob
## 1 nigel hayes f 18 79 254 12/16/1994
## 2 luke kornet f-c 2 85 250 7/15/1995
## 3 kyle o'quinn f-c 9 82 250 3/26/1990
## 4 enes kanter c 0 83 245 5/20/1992
## 5 willy hernangomez c 14 83 240 5/27/1994
## 6 kristaps prozingis f-c 6 87 240 8/2/1995
## 7 michael beasley f 8 81 235 1/9/1989
## 8 lance thomas f 42 80 235 4/24/1988
## 9 joakim noah c 13 83 230 2/25/1985
## 10 ron baker g 31 76 220 3/30/1993
## 11 doug mcdermott f 20 80 219 1/3/1992
## 12 mindaugas kuzminskas f 91 81 215 10/19/1989
## 13 damyean dotson g 21 77 210 5/6/1994
## 14 xavier rathan-mayes g 17 76 208 4/29/1994
## 15 tim hardaway jr g 3 78 205 3/16/1992
## 16 jarret jack g 55 75 200 10/28/1983
## 17 courtney lee g 5 77 200 10/3/1985
## 18 frank ntilikina g 11 77 190 7/28/1998
## 19 ramon sessions g 1 75 190 4/11/1986#Select all players shorter than 6 feet 8 inches
knicks %>% filter(ht <80) %>% select(first, last, ht)## first last ht
## 1 ron baker 76
## 2 damyean dotson 77
## 3 tim hardaway jr 78
## 4 nigel hayes 79
## 5 jarret jack 75
## 6 courtney lee 77
## 7 frank ntilikina 77
## 8 xavier rathan-mayes 76
## 9 ramon sessions 75Data based on information retrieved from https://support.spatialkey.com/spatialkey-sample-csv-data
#Import tv data
sac <- read.csv("C:\\Users\\bkl2001\\Documents\\Personal\\CUNY\\Classes\\DATA 607 Data Acquisition and Management\\Week 5\\Sacramentorealestatetransactions.csv")SAC dataset has 985 observations and 12 variables
#View data set dimensions
dim(sac)## [1] 985 12#View the head of the sac data set
head(sac)## street city zip state beds baths sq__ft type
## 1 3526 HIGH ST SACRAMENTO 95838 CA 2 1 836 Residential
## 2 51 OMAHA CT SACRAMENTO 95823 CA 3 1 1167 Residential
## 3 2796 BRANCH ST SACRAMENTO 95815 CA 2 1 796 Residential
## 4 2805 JANETTE WAY SACRAMENTO 95815 CA 2 1 852 Residential
## 5 6001 MCMAHON DR SACRAMENTO 95824 CA 2 1 797 Residential
## 6 5828 PEPPERMILL CT SACRAMENTO 95841 CA 3 1 1122 Condo
## sale_date price latitude longitude
## 1 Wed May 21 00:00:00 EDT 2008 59222 38.63191 -121.4349
## 2 Wed May 21 00:00:00 EDT 2008 68212 38.47890 -121.4310
## 3 Wed May 21 00:00:00 EDT 2008 68880 38.61830 -121.4438
## 4 Wed May 21 00:00:00 EDT 2008 69307 38.61684 -121.4391
## 5 Wed May 21 00:00:00 EDT 2008 81900 38.51947 -121.4358
## 6 Wed May 21 00:00:00 EDT 2008 89921 38.66260 -121.3278#View the tail of the sac data set
tail(sac)## street city zip state beds baths sq__ft
## 980 1909 YARNELL WAY ELK GROVE 95758 CA 3 2 1262
## 981 9169 GARLINGTON CT SACRAMENTO 95829 CA 4 3 2280
## 982 6932 RUSKUT WAY SACRAMENTO 95823 CA 3 2 1477
## 983 7933 DAFFODIL WAY CITRUS HEIGHTS 95610 CA 3 2 1216
## 984 8304 RED FOX WAY ELK GROVE 95758 CA 4 2 1685
## 985 3882 YELLOWSTONE LN EL DORADO HILLS 95762 CA 3 2 1362
## type sale_date price latitude longitude
## 980 Residential Thu May 15 00:00:00 EDT 2008 230000 38.41738 -121.4843
## 981 Residential Thu May 15 00:00:00 EDT 2008 232425 38.45768 -121.3596
## 982 Residential Thu May 15 00:00:00 EDT 2008 234000 38.49989 -121.4589
## 983 Residential Thu May 15 00:00:00 EDT 2008 235000 38.70882 -121.2568
## 984 Residential Thu May 15 00:00:00 EDT 2008 235301 38.41700 -121.3974
## 985 Residential Thu May 15 00:00:00 EDT 2008 235738 38.65525 -121.0759sac_new <- subset(sac, select=c(type, beds, baths, price))
sac_new## type beds baths price
## 1 Residential 2 1 59222
## 2 Residential 3 1 68212
## 3 Residential 2 1 68880
## 4 Residential 2 1 69307
## 5 Residential 2 1 81900
## 6 Condo 3 1 89921
## 7 Residential 3 2 90895
## 8 Residential 3 1 91002
## 9 Condo 2 2 94905
## 10 Residential 3 2 98937
## 11 Residential 3 2 100309
## 12 Residential 3 2 106250
## 13 Residential 1 1 106852
## 14 Residential 3 1 107502
## 15 Residential 2 2 108750
## 16 Condo 2 2 110700
## 17 Residential 2 1 113263
## 18 Condo 2 1 116250
## 19 Residential 2 1 120000
## 20 Residential 3 2 121630
## 21 Residential 3 2 122000
## 22 Residential 4 2 122682
## 23 Residential 4 2 123000
## 24 Residential 3 2 124100
## 25 Residential 3 2 125000
## 26 Residential 3 2 126640
## 27 Residential 3 1 127281
## 28 Residential 3 2 129000
## 29 Residential 4 2 131200
## 30 Residential 3 2 132000
## 31 Condo 2 2 133000
## 32 Residential 3 2 134555
## 33 Residential 3 2 136500
## 34 Residential 3 2 138750
## 35 Condo 2 2 141000
## 36 Residential 3 2 146250
## 37 Residential 3 2 147308
## 38 Residential 4 2 148750
## 39 Residential 4 2 149593
## 40 Condo 1 1 150000
## 41 Condo 2 2 152000
## 42 Residential 3 2 154000
## 43 Residential 3 2 156896
## 44 Residential 2 2 161250
## 45 Residential 4 2 161500
## 46 Residential 4 1 164000
## 47 Residential 4 2 165000
## 48 Residential 4 1 166357
## 49 Residential 4 2 166357
## 50 Residential 3 2 168000
## 51 Residential 3 2 170000
## 52 Residential 4 2 173000
## 53 Residential 3 2 174250
## 54 Residential 4 2 174313
## 55 Residential 3 2 178480
## 56 Residential 3 2 178760
## 57 Multi-Family 4 2 179580
## 58 Residential 3 2 181000
## 59 Residential 3 1 181872
## 60 Residential 4 3 182587
## 61 Residential 3 2 182716
## 62 Residential 3 2 182750
## 63 Residential 4 2 183200
## 64 Residential 3 1 188741
## 65 Residential 3 2 189000
## 66 Residential 3 2 192067
## 67 Residential 3 2 194000
## 68 Residential 3 2 194818
## 69 Multi-Family 4 4 195000
## 70 Residential 3 2 198000
## 71 Residential 4 2 199500
## 72 Residential 3 2 200000
## 73 Residential 3 1 200000
## 74 Residential 0 0 206000
## 75 Residential 3 2 208000
## 76 Residential 4 2 212864
## 77 Residential 4 2 221000
## 78 Residential 2 2 221000
## 79 Residential 5 3 223058
## 80 Residential 4 2 227887
## 81 Residential 3 2 231477
## 82 Residential 3 2 234697
## 83 Residential 4 2 235000
## 84 Residential 4 2 236000
## 85 Residential 4 3 236685
## 86 Residential 3 2 237800
## 87 Residential 3 2 240122
## 88 Residential 3 2 242638
## 89 Residential 3 2 244000
## 90 Residential 0 0 244500
## 91 Residential 3 1 244960
## 92 Residential 5 3 245918
## 93 Residential 3 2 250000
## 94 Residential 4 2 250000
## 95 Condo 2 2 250134
## 96 Residential 3 2 254200
## 97 Residential 4 2 254200
## 98 Residential 5 3 258000
## 99 Residential 3 2 260000
## 100 Residential 3 1 260014
## 101 Residential 0 0 263500
## 102 Condo 3 2 265000
## 103 Residential 3 2 265000
## 104 Residential 3 1 271742
## 105 Residential 4 3 273750
## 106 Residential 3 2 275086
## 107 Residential 2 2 280908
## 108 Residential 4 3 280987
## 109 Multi-Family 8 4 282400
## 110 Residential 4 2 285000
## 111 Residential 4 2 287417
## 112 Residential 3 2 291000
## 113 Residential 2 1 292024
## 114 Multi-Family 4 4 297000
## 115 Residential 5 3 297000
## 116 Residential 3 2 298000
## 117 Residential 2 2 299000
## 118 Residential 5 3 304037
## 119 Residential 4 2 311000
## 120 Residential 5 3 315537
## 121 Residential 5 4 320000
## 122 Residential 0 0 320000
## 123 Residential 4 3 328360
## 124 Residential 2 1 334150
## 125 Residential 3 3 335750
## 126 Residential 4 3 335750
## 127 Residential 0 0 339500
## 128 Residential 3 2 344250
## 129 Residential 4 2 346210
## 130 Residential 3 3 347029
## 131 Residential 4 2 347650
## 132 Residential 4 3 351300
## 133 Residential 3 2 352000
## 134 Residential 0 0 370000
## 135 Residential 4 3 370500
## 136 Residential 3 2 372000
## 137 Residential 5 3 375000
## 138 Residential 5 3 381300
## 139 Residential 4 2 381942
## 140 Residential 4 2 387731
## 141 Residential 3 3 391000
## 142 Residential 4 3 394470
## 143 Residential 3 2 395000
## 144 Residential 4 3 400186
## 145 Residential 3 3 415000
## 146 Residential 5 3 425000
## 147 Residential 5 3 430000
## 148 Residential 0 0 445000
## 149 Residential 5 3 460000
## 150 Residential 4 3 461000
## 151 Residential 4 3 489332
## 152 Residential 5 4 510000
## 153 Residential 4 2 539000
## 154 Residential 0 0 585000
## 155 Residential 4 3 600000
## 156 Residential 4 3 606238
## 157 Residential 3 3 660000
## 158 Residential 6 5 830000
## 159 Condo 2 1 69000
## 160 Residential 4 2 70000
## 161 Condo 2 1 71000
## 162 Residential 2 1 78000
## 163 Residential 2 1 78400
## 164 Residential 3 1 80000
## 165 Residential 4 2 89000
## 166 Residential 3 1 90000
## 167 Residential 2 1 90000
## 168 Residential 3 1 92000
## 169 Residential 2 1 93675
## 170 Residential 0 0 97750
## 171 Residential 2 1 98000
## 172 Condo 1 1 98000
## 173 Residential 3 1 99000
## 174 Condo 1 1 100000
## 175 Residential 3 1 106716
## 176 Residential 3 1 111000
## 177 Residential 3 1 111000
## 178 Residential 2 2 114800
## 179 Residential 3 1 120108
## 180 Residential 3 1 123225
## 181 Residential 3 2 123750
## 182 Residential 3 1 125000
## 183 Residential 3 2 125000
## 184 Residential 3 2 126000
## 185 Residential 3 1 129000
## 186 Residential 2 1 134000
## 187 Residential 3 2 135000
## 188 Residential 3 2 135500
## 189 Residential 3 1 140000
## 190 Residential 3 2 140000
## 191 Condo 2 2 142500
## 192 Residential 3 2 143500
## 193 Condo 0 0 145000
## 194 Residential 2 1 145000
## 195 Residential 4 2 145000
## 196 Residential 3 2 145000
## 197 Residential 4 2 146000
## 198 Residential 3 1 148500
## 199 Residential 3 2 149000
## 200 Residential 3 2 150000
## 201 Residential 4 2 150000
## 202 Residential 2 2 152000
## 203 Residential 3 2 156000
## 204 Residential 2 1 156000
## 205 Residential 2 2 156000
## 206 Residential 2 1 157788
## 207 Residential 3 2 161653
## 208 Residential 2 1 161829
## 209 Residential 3 2 165000
## 210 Residential 3 2 168000
## 211 Residential 3 2 169000
## 212 Residential 3 2 175000
## 213 Residential 3 2 176250
## 214 Residential 3 2 179000
## 215 Residential 2 2 180000
## 216 Residential 3 2 180400
## 217 Residential 4 2 182000
## 218 Residential 4 2 184500
## 219 Residential 3 2 185000
## 220 Residential 4 2 189000
## 221 Residential 3 2 194000
## 222 Residential 3 1 195000
## 223 Residential 3 2 200000
## 224 Residential 3 1 201000
## 225 Residential 4 2 202500
## 226 Residential 3 2 205000
## 227 Residential 4 2 205000
## 228 Residential 3 2 205000
## 229 Residential 4 3 205000
## 230 Residential 2 1 207000
## 231 Residential 2 2 210000
## 232 Residential 2 1 211500
## 233 Residential 4 2 215000
## 234 Residential 3 2 215000
## 235 Residential 0 0 215500
## 236 Residential 3 1 222381
## 237 Condo 0 0 225000
## 238 Residential 3 2 225000
## 239 Residential 4 2 225000
## 240 Residential 3 2 225000
## 241 Residential 4 2 228000
## 242 Residential 4 2 229665
## 243 Residential 3 1 230000
## 244 Residential 2 2 230000
## 245 Residential 3 2 230000
## 246 Residential 3 2 234000
## 247 Residential 3 2 235000
## 248 Residential 3 1 236250
## 249 Condo 0 0 240000
## 250 Residential 0 0 242000
## 251 Residential 3 2 245000
## 252 Residential 4 3 245000
## 253 Residential 2 1 245000
## 254 Residential 0 0 250000
## 255 Residential 3 2 250000
## 256 Residential 4 2 250000
## 257 Residential 3 2 250000
## 258 Residential 3 2 255000
## 259 Multi-Family 5 4 256054
## 260 Residential 3 2 257729
## 261 Residential 4 2 260000
## 262 Residential 3 2 261000
## 263 Residential 4 2 261800
## 264 Residential 4 2 264469
## 265 Residential 4 3 265000
## 266 Residential 0 0 270000
## 267 Residential 4 3 270000
## 268 Residential 3 2 270000
## 269 Residential 0 0 270000
## 270 Residential 4 3 275000
## 271 Residential 4 2 275000
## 272 Residential 4 3 280000
## 273 Residential 3 2 286013
## 274 Residential 4 2 292000
## 275 Residential 3 2 292000
## 276 Residential 3 2 293993
## 277 Residential 3 2 294000
## 278 Residential 3 2 296769
## 279 Residential 4 4 297500
## 280 Condo 0 0 300000
## 281 Residential 3 1 300000
## 282 Residential 4 3 300000
## 283 Residential 3 2 300000
## 284 Residential 4 2 300500
## 285 Residential 3 2 305000
## 286 Residential 0 0 306500
## 287 Residential 0 0 312500
## 288 Residential 5 3 315000
## 289 Residential 4 2 319789
## 290 Residential 2 2 330000
## 291 Residential 3 2 330000
## 292 Residential 3 2 331000
## 293 Residential 2 1 334000
## 294 Residential 4 3 336000
## 295 Residential 3 1 339000
## 296 Residential 4 2 339000
## 297 Residential 4 2 345000
## 298 Residential 4 3 350000
## 299 Residential 3 2 356000
## 300 Residential 4 2 361745
## 301 Residential 4 2 361948
## 302 Residential 5 3 370000
## 303 Residential 4 2 380000
## 304 Residential 5 4 385000
## 305 Residential 3 2 399000
## 306 Residential 4 2 402000
## 307 Residential 4 3 406026
## 308 Residential 5 4 420000
## 309 Residential 0 0 425000
## 310 Residential 4 2 425000
## 311 Residential 0 0 433500
## 312 Residential 4 3 436746
## 313 Residential 5 3 438700
## 314 Residential 2 1 445000
## 315 Residential 4 2 450000
## 316 Residential 3 1 460000
## 317 Residential 3 2 460000
## 318 Residential 4 3 460000
## 319 Residential 4 4 465000
## 320 Residential 5 3 471750
## 321 Residential 5 3 480000
## 322 Residential 2 2 484000
## 323 Residential 4 3 485000
## 324 Residential 4 3 495000
## 325 Residential 0 0 500500
## 326 Residential 3 3 504000
## 327 Residential 0 0 541000
## 328 Residential 0 0 560000
## 329 Residential 5 3 572500
## 330 Residential 4 2 582000
## 331 Residential 4 3 613401
## 332 Residential 4 2 614000
## 333 Residential 5 5 680000
## 334 Residential 5 2 699000
## 335 Residential 4 4 839000
## 336 Condo 2 1 40000
## 337 Condo 1 1 48000
## 338 Residential 3 1 61500
## 339 Residential 2 1 62050
## 340 Residential 2 1 65000
## 341 Residential 2 1 65000
## 342 Residential 2 1 68000
## 343 Residential 2 1 68000
## 344 Condo 2 1 77000
## 345 Condo 2 1 82732
## 346 Residential 3 1 84000
## 347 Residential 2 1 84675
## 348 Residential 3 1 85000
## 349 Residential 3 1 90000
## 350 Condo 2 1 90000
## 351 Residential 2 2 91000
## 352 Residential 3 1 95000
## 353 Residential 2 1 97500
## 354 Multi-Family 4 2 100000
## 355 Condo 1 1 100000
## 356 Residential 2 1 101000
## 357 Residential 4 2 102750
## 358 Residential 3 1 112500
## 359 Residential 3 1 113000
## 360 Residential 4 2 114000
## 361 Residential 3 1 114000
## 362 Residential 2 1 114750
## 363 Condo 2 2 115000
## 364 Condo 2 2 115000
## 365 Residential 3 1 116100
## 366 Residential 3 2 119250
## 367 Multi-Family 4 4 120000
## 368 Residential 2 1 120000
## 369 Condo 2 2 120000
## 370 Residential 3 2 120108
## 371 Residential 2 2 121500
## 372 Residential 3 1 121725
## 373 Residential 3 2 122000
## 374 Residential 3 2 123000
## 375 Residential 2 1 125000
## 376 Residential 4 2 125573
## 377 Residential 4 2 126714
## 378 Condo 2 1 126960
## 379 Condo 2 1 127000
## 380 Residential 4 2 127500
## 381 Residential 3 2 130000
## 382 Residential 2 1 133105
## 383 Residential 2 2 136500
## 384 Condo 3 2 139500
## 385 Residential 3 2 140000
## 386 Residential 3 2 140800
## 387 Residential 3 2 145000
## 388 Residential 4 2 147000
## 389 Residential 3 2 149600
## 390 Residential 5 2 150000
## 391 Condo 2 2 150000
## 392 Residential 3 2 150000
## 393 Residential 3 2 155000
## 394 Residential 3 2 155435
## 395 Residential 3 2 155500
## 396 Residential 4 2 158000
## 397 Residential 3 2 158000
## 398 Residential 3 2 160000
## 399 Residential 2 1 160000
## 400 Residential 2 2 164000
## 401 Residential 3 2 164000
## 402 Residential 2 2 165000
## 403 Residential 3 2 167000
## 404 Residential 4 2 167293
## 405 Residential 4 2 167293
## 406 Residential 3 1 168000
## 407 Residential 3 2 170000
## 408 Residential 4 2 170000
## 409 Residential 3 2 170000
## 410 Residential 3 2 174000
## 411 Residential 3 2 178000
## 412 Residential 3 2 180000
## 413 Residential 3 2 180000
## 414 Residential 4 2 180000
## 415 Condo 2 2 182000
## 416 Residential 3 1 188325
## 417 Residential 3 2 191500
## 418 Residential 3 2 192000
## 419 Residential 3 2 192700
## 420 Residential 3 1 195000
## 421 Residential 3 2 197654
## 422 Residential 3 1 198000
## 423 Residential 3 2 200345
## 424 Residential 2 1 203000
## 425 Residential 4 2 207000
## 426 Residential 4 3 208000
## 427 Residential 4 2 210000
## 428 Residential 3 1 212000
## 429 Residential 4 2 213675
## 430 Residential 2 2 213697
## 431 Residential 4 2 215000
## 432 Residential 4 3 215000
## 433 Residential 3 1 215100
## 434 Residential 3 2 217500
## 435 Residential 3 2 218000
## 436 Residential 2 1 220000
## 437 Residential 4 3 221000
## 438 Residential 3 2 222900
## 439 Residential 3 1 223139
## 440 Residential 4 2 225500
## 441 Residential 3 2 228327
## 442 Residential 4 2 230000
## 443 Residential 3 2 230000
## 444 Condo 2 1 230522
## 445 Residential 4 3 231200
## 446 Residential 3 2 232000
## 447 Condo 2 2 232500
## 448 Residential 3 1 233641
## 449 Residential 3 2 234000
## 450 Residential 2 2 234500
## 451 Residential 4 3 235000
## 452 Multi-Family 5 4 236000
## 453 Residential 3 2 236073
## 454 Condo 3 2 238000
## 455 Residential 4 2 238861
## 456 Residential 4 3 239700
## 457 Residential 4 2 240000
## 458 Residential 5 3 240000
## 459 Residential 4 2 241000
## 460 Residential 3 2 245000
## 461 Residential 4 3 246000
## 462 Residential 4 2 247234
## 463 Residential 4 2 247480
## 464 Residential 3 1 249862
## 465 Residential 3 2 251000
## 466 Residential 4 2 252155
## 467 Residential 3 2 254172
## 468 Residential 4 2 258000
## 469 Condo 2 2 260000
## 470 Residential 0 0 261000
## 471 Residential 4 3 261000
## 472 Residential 4 2 261000
## 473 Residential 4 2 262500
## 474 Residential 4 2 266000
## 475 Residential 3 1 266000
## 476 Residential 3 2 270000
## 477 Residential 4 3 274425
## 478 Residential 0 0 274500
## 479 Residential 3 2 275336
## 480 Residential 4 3 277980
## 481 Residential 4 2 280000
## 482 Residential 3 3 284686
## 483 Residential 3 2 284893
## 484 Residential 3 2 285000
## 485 Multi-Family 2 2 285000
## 486 Residential 4 2 285000
## 487 Residential 3 2 289000
## 488 Residential 5 3 295000
## 489 Residential 4 2 296000
## 490 Residential 4 2 296056
## 491 Residential 3 2 297359
## 492 Residential 4 2 299940
## 493 Residential 5 3 304000
## 494 Residential 4 3 305000
## 495 Residential 0 0 307000
## 496 Residential 4 2 311328
## 497 Residential 3 2 313138
## 498 Residential 3 2 316630
## 499 Residential 5 3 320000
## 500 Residential 5 3 320000
## 501 Residential 5 3 325000
## 502 Residential 4 2 328578
## 503 Residential 3 3 331000
## 504 Residential 0 0 331500
## 505 Residential 4 2 340000
## 506 Residential 0 0 344755
## 507 Residential 3 2 345746
## 508 Residential 4 2 351000
## 509 Residential 4 2 353767
## 510 Residential 0 0 355000
## 511 Residential 4 2 356035
## 512 Condo 0 0 360000
## 513 Residential 4 2 360552
## 514 Residential 3 2 362305
## 515 Residential 3 1 365000
## 516 Residential 3 2 367554
## 517 Residential 0 0 368500
## 518 Residential 2 2 370000
## 519 Residential 4 2 371086
## 520 Residential 3 2 378000
## 521 Residential 0 0 383000
## 522 Residential 3 1 388000
## 523 Residential 5 3 395100
## 524 Residential 3 2 400000
## 525 Residential 3 2 400000
## 526 Residential 4 3 408431
## 527 Residential 0 0 413000
## 528 Multi-Family 4 2 416767
## 529 Residential 4 3 420000
## 530 Residential 4 3 423000
## 531 Residential 4 2 423000
## 532 Residential 2 3 427500
## 533 Residential 3 2 430922
## 534 Residential 4 2 445000
## 535 Residential 4 4 450000
## 536 Residential 5 3 452000
## 537 Residential 3 2 470000
## 538 Residential 4 3 471000
## 539 Residential 4 4 475000
## 540 Residential 3 3 484500
## 541 Residential 5 3 487500
## 542 Residential 3 3 488750
## 543 Residential 3 2 500000
## 544 Residential 3 2 506688
## 545 Residential 2 2 512000
## 546 Residential 5 3 520000
## 547 Residential 4 2 528000
## 548 Residential 5 2 579093
## 549 Residential 4 3 636000
## 550 Residential 4 3 668365
## 551 Residential 5 3 676200
## 552 Residential 3 2 677048
## 553 Residential 5 3 691659
## 554 Residential 5 3 760000
## 555 Residential 0 0 4897
## 556 Residential 0 0 4897
## 557 Residential 0 0 4897
## 558 Residential 0 0 4897
## 559 Residential 0 0 4897
## 560 Residential 0 0 4897
## 561 Residential 0 0 4897
## 562 Residential 0 0 4897
## 563 Residential 0 0 4897
## 564 Residential 0 0 4897
## 565 Residential 0 0 4897
## 566 Residential 0 0 4897
## 567 Residential 0 0 4897
## 568 Residential 0 0 4897
## 569 Residential 0 0 4897
## 570 Residential 0 0 4897
## 571 Residential 0 0 4897
## 572 Residential 0 0 4897
## 573 Residential 0 0 4897
## 574 Residential 0 0 4897
## 575 Residential 0 0 4897
## 576 Residential 0 0 4897
## 577 Residential 0 0 4897
## 578 Residential 0 0 4897
## 579 Residential 0 0 4897
## 580 Residential 4 2 4897
## 581 Residential 3 2 4897
## 582 Residential 3 2 4897
## 583 Residential 0 0 4897
## 584 Residential 0 0 4897
## 585 Residential 0 0 4897
## 586 Residential 0 0 4897
## 587 Residential 0 0 4897
## 588 Residential 0 0 4897
## 589 Residential 0 0 4897
## 590 Residential 0 0 4897
## 591 Residential 0 0 4897
## 592 Residential 0 0 4897
## 593 Residential 0 0 4897
## 594 Residential 0 0 4897
## 595 Residential 0 0 4897
## 596 Residential 0 0 4897
## 597 Residential 0 0 4897
## 598 Residential 0 0 4897
## 599 Residential 0 0 4897
## 600 Residential 0 0 4897
## 601 Residential 0 0 4897
## 602 Residential 0 0 4897
## 603 Residential 0 0 4897
## 604 Residential 3 2 30000
## 605 Residential 0 0 30000
## 606 Residential 2 1 55422
## 607 Residential 2 1 63000
## 608 Residential 2 1 65000
## 609 Residential 2 1 65000
## 610 Residential 2 1 65000
## 611 Residential 2 2 66500
## 612 Residential 2 1 71000
## 613 Residential 2 1 75000
## 614 Condo 2 1 77000
## 615 Residential 2 1 85000
## 616 Residential 3 2 95625
## 617 Residential 2 1 96140
## 618 Condo 2 1 104250
## 619 Residential 4 2 105000
## 620 Residential 2 1 108000
## 621 Residential 4 2 109000
## 622 Residential 2 1 115000
## 623 Condo 1 1 115000
## 624 Residential 3 2 115500
## 625 Residential 3 2 115620
## 626 Residential 3 2 116000
## 627 Residential 3 2 122000
## 628 Residential 3 2 122500
## 629 Residential 4 2 123000
## 630 Residential 3 2 124000
## 631 Residential 4 2 124000
## 632 Residential 3 2 124413
## 633 Residential 4 2 125000
## 634 Residential 3 2 130000
## 635 Residential 2 2 131750
## 636 Residential 4 3 137721
## 637 Residential 3 2 137760
## 638 Residential 3 2 138000
## 639 Residential 3 1 140000
## 640 Residential 3 1 145000
## 641 Residential 2 2 145000
## 642 Residential 3 2 150000
## 643 Residential 3 2 150000
## 644 Residential 4 2 151000
## 645 Residential 3 2 155000
## 646 Residential 3 2 155800
## 647 Residential 3 2 156142
## 648 Residential 4 2 158000
## 649 Multi-Family 6 4 159900
## 650 Residential 3 2 160000
## 651 Residential 3 2 161500
## 652 Residential 4 2 161600
## 653 Residential 3 2 162000
## 654 Residential 4 2 165000
## 655 Residential 3 2 165000
## 656 Residential 3 2 167293
## 657 Residential 5 2 168000
## 658 Residential 4 2 168000
## 659 Residential 3 2 168750
## 660 Residential 3 1 168750
## 661 Residential 3 1 170000
## 662 Residential 3 2 170250
## 663 Residential 3 2 173000
## 664 Residential 3 1 175000
## 665 Residential 3 2 176095
## 666 Residential 3 2 176250
## 667 Residential 3 2 178000
## 668 Residential 4 2 179000
## 669 Residential 3 2 180000
## 670 Residential 3 2 180000
## 671 Residential 3 2 180000
## 672 Residential 3 2 181000
## 673 Residential 3 2 182000
## 674 Residential 3 2 182587
## 675 Residential 4 2 185074
## 676 Residential 3 2 185833
## 677 Residential 4 2 186785
## 678 Residential 3 2 187000
## 679 Residential 3 2 188335
## 680 Residential 3 2 190000
## 681 Residential 3 1 190000
## 682 Residential 4 2 190000
## 683 Residential 2 1 190000
## 684 Residential 3 2 191250
## 685 Residential 3 2 193000
## 686 Residential 3 2 193500
## 687 Residential 0 0 194818
## 688 Residential 4 2 195000
## 689 Residential 4 3 195000
## 690 Residential 2 2 195000
## 691 Residential 3 1 195000
## 692 Residential 3 1 198000
## 693 Residential 3 2 199900
## 694 Residential 3 1 200000
## 695 Residential 3 1 201000
## 696 Residential 4 2 204918
## 697 Residential 3 2 205000
## 698 Residential 2 1 205000
## 699 Residential 3 2 205878
## 700 Residential 4 2 207000
## 701 Residential 4 2 207744
## 702 Residential 3 2 209000
## 703 Residential 3 2 210000
## 704 Condo 1 1 210944
## 705 Condo 3 2 212500
## 706 Residential 4 2 213750
## 707 Residential 3 2 215000
## 708 Residential 2 2 215000
## 709 Residential 4 1 215000
## 710 Residential 3 2 216033
## 711 Residential 4 2 220000
## 712 Residential 2 1 220000
## 713 Residential 2 1 220000
## 714 Residential 4 2 220000
## 715 Residential 3 2 220000
## 716 Residential 2 2 220702
## 717 Multi-Family 4 2 221250
## 718 Residential 3 2 222000
## 719 Residential 0 0 222500
## 720 Residential 5 2 222750
## 721 Residential 3 2 225000
## 722 Residential 4 2 225000
## 723 Residential 4 3 228750
## 724 Residential 3 2 229000
## 725 Residential 3 2 230095
## 726 Residential 5 3 232500
## 727 Residential 3 2 233000
## 728 Residential 4 2 233500
## 729 Residential 3 2 239000
## 730 Residential 4 3 240000
## 731 Residential 4 2 240000
## 732 Residential 3 2 240971
## 733 Residential 2 2 242000
## 734 Residential 3 2 243450
## 735 Residential 4 2 243500
## 736 Residential 3 2 246544
## 737 Residential 4 2 246750
## 738 Residential 0 0 247000
## 739 Residential 3 2 247000
## 740 Residential 3 2 249000
## 741 Residential 4 3 249000
## 742 Residential 3 2 250000
## 743 Residential 3 2 250000
## 744 Residential 0 0 250000
## 745 Residential 4 2 252000
## 746 Residential 3 2 255000
## 747 Residential 3 1 255000
## 748 Residential 3 2 255000
## 749 Residential 4 2 257200
## 750 Residential 3 2 260000
## 751 Residential 3 2 260000
## 752 Residential 3 2 263500
## 753 Residential 3 2 266510
## 754 Residential 4 2 267750
## 755 Residential 0 0 270000
## 756 Residential 0 0 271000
## 757 Residential 4 2 272700
## 758 Unkown 0 0 275000
## 759 Residential 3 2 275000
## 760 Residential 5 3 276000
## 761 Residential 3 2 276500
## 762 Residential 4 3 278000
## 763 Residential 5 3 279000
## 764 Residential 3 2 280000
## 765 Residential 4 2 280000
## 766 Residential 3 2 285000
## 767 Residential 3 2 288000
## 768 Residential 4 3 289000
## 769 Residential 3 2 290000
## 770 Residential 4 2 290000
## 771 Residential 4 2 293996
## 772 Residential 3 2 294000
## 773 Residential 4 2 294173
## 774 Residential 4 2 295000
## 775 Residential 0 0 298000
## 776 Residential 4 2 298000
## 777 Residential 2 1 299000
## 778 Residential 2 2 300000
## 779 Residential 3 2 300000
## 780 Residential 6 3 300000
## 781 Residential 3 2 300567
## 782 Residential 5 3 303000
## 783 Residential 3 2 305000
## 784 Residential 4 2 306000
## 785 Residential 3 2 310000
## 786 Residential 3 2 310000
## 787 Residential 4 3 310000
## 788 Residential 4 2 311518
## 789 Residential 5 3 312000
## 790 Residential 0 0 313000
## 791 Residential 4 2 315000
## 792 Residential 4 3 315000
## 793 Residential 5 3 315000
## 794 Residential 3 2 315000
## 795 Residential 4 2 315000
## 796 Residential 3 2 320000
## 797 Residential 4 3 322000
## 798 Residential 4 2 325000
## 799 Residential 0 0 325500
## 800 Residential 3 2 326951
## 801 Residential 3 2 328370
## 802 Residential 2 2 330000
## 803 Residential 4 3 330000
## 804 Residential 4 2 331200
## 805 Residential 4 3 332000
## 806 Residential 3 3 334000
## 807 Residential 3 2 335000
## 808 Residential 4 2 341000
## 809 Residential 5 3 346375
## 810 Residential 5 3 347225
## 811 Residential 5 3 349000
## 812 Residential 3 2 350000
## 813 Residential 2 2 350000
## 814 Residential 3 2 350000
## 815 Condo 3 2 350000
## 816 Residential 3 2 351000
## 817 Residential 3 2 356200
## 818 Residential 4 2 360000
## 819 Residential 4 3 367463
## 820 Residential 0 0 375000
## 821 Residential 3 1 380000
## 822 Residential 3 2 380578
## 823 Residential 3 2 386222
## 824 Residential 0 0 389000
## 825 Residential 0 0 390000
## 826 Residential 3 2 395500
## 827 Residential 0 0 396000
## 828 Residential 5 3 397000
## 829 Residential 0 0 400000
## 830 Residential 4 2 400000
## 831 Residential 4 3 412500
## 832 Residential 2 1 413500
## 833 Residential 3 2 415000
## 834 Residential 4 3 420454
## 835 Residential 3 1 425000
## 836 Residential 3 2 425000
## 837 Residential 0 0 433500
## 838 Residential 5 3 438000
## 839 Residential 5 3 441000
## 840 Residential 5 3 445000
## 841 Residential 4 3 446000
## 842 Residential 4 2 450000
## 843 Residential 4 3 455000
## 844 Residential 3 2 460000
## 845 Residential 3 2 475000
## 846 Residential 3 2 490000
## 847 Residential 4 2 493000
## 848 Residential 5 4 508000
## 849 Residential 0 0 511000
## 850 Residential 3 2 525000
## 851 Residential 4 3 533000
## 852 Residential 3 1 545000
## 853 Residential 4 3 560000
## 854 Residential 2 1 575000
## 855 Residential 4 3 575000
## 856 Residential 5 4 598695
## 857 Residential 5 3 600000
## 858 Residential 4 3 600000
## 859 Residential 4 3 600000
## 860 Residential 0 0 600000
## 861 Residential 5 3 610000
## 862 Residential 0 0 622500
## 863 Residential 0 0 680000
## 864 Residential 4 3 879000
## 865 Residential 4 3 884790
## 866 Residential 3 3 1551
## 867 Residential 3 4 2000
## 868 Residential 4 2 56950
## 869 Condo 1 1 60000
## 870 Residential 2 1 61000
## 871 Condo 2 1 62000
## 872 Residential 2 1 68566
## 873 Residential 2 1 70000
## 874 Residential 4 2 80000
## 875 Residential 3 2 85500
## 876 Condo 2 1 92000
## 877 Residential 2 2 93600
## 878 Residential 3 1 95000
## 879 Residential 3 2 97750
## 880 Residential 3 2 104000
## 881 Residential 3 1 105000
## 882 Condo 1 1 107666
## 883 Residential 3 1 109000
## 884 Residential 3 1 110000
## 885 Residential 3 1 110000
## 886 Residential 3 2 112500
## 887 Residential 3 2 114800
## 888 Residential 3 1 116000
## 889 Condo 0 0 119000
## 890 Residential 4 2 121500
## 891 Residential 3 2 122000
## 892 Residential 2 2 123675
## 893 Residential 4 2 126854
## 894 Residential 3 2 127059
## 895 Residential 3 1 128687
## 896 Residential 3 2 129500
## 897 Residential 3 2 130000
## 898 Residential 4 2 131750
## 899 Residential 2 1 132000
## 900 Residential 3 2 134000
## 901 Residential 3 1 134000
## 902 Condo 0 0 138000
## 903 Residential 3 2 142000
## 904 Residential 3 1 143012
## 905 Residential 3 2 145846
## 906 Residential 2 1 147000
## 907 Residential 3 1 148750
## 908 Residential 4 2 150000
## 909 Condo 2 1 150454
## 910 Residential 3 2 151087
## 911 Residential 3 2 157296
## 912 Residential 3 2 157500
## 913 Residential 3 2 160000
## 914 Residential 3 2 160000
## 915 Residential 4 2 161250
## 916 Residential 3 2 164000
## 917 Residential 2 1 165000
## 918 Residential 0 0 165000
## 919 Residential 4 2 165750
## 920 Residential 3 1 166000
## 921 Residential 3 2 169000
## 922 Residential 3 2 170000
## 923 Condo 2 2 170000
## 924 Multi-Family 4 2 170000
## 925 Residential 3 2 170000
## 926 Residential 3 1 170725
## 927 Residential 2 2 171750
## 928 Residential 3 2 172000
## 929 Residential 2 2 173056
## 930 Residential 3 2 174000
## 931 Residential 3 2 174250
## 932 Residential 4 2 176850
## 933 Residential 4 2 179500
## 934 Residential 3 1 185000
## 935 Condo 0 0 188000
## 936 Residential 3 2 188700
## 937 Residential 3 1 189000
## 938 Residential 3 1 189000
## 939 Residential 4 3 189836
## 940 Residential 4 2 190000
## 941 Residential 3 2 191250
## 942 Residential 3 2 191675
## 943 Residential 3 2 195500
## 944 Residential 3 1 198000
## 945 Residential 3 2 200000
## 946 Residential 3 2 200000
## 947 Residential 3 2 200000
## 948 Residential 0 0 200100
## 949 Residential 3 2 201528
## 950 Residential 4 2 204750
## 951 Residential 4 3 205000
## 952 Residential 2 2 205000
## 953 Residential 3 2 205900
## 954 Residential 2 2 207000
## 955 Residential 2 1 207973
## 956 Residential 3 2 208250
## 957 Residential 3 1 208318
## 958 Residential 3 2 209347
## 959 Residential 4 2 211500
## 960 Residential 3 2 212000
## 961 Residential 3 2 213000
## 962 Residential 3 2 216000
## 963 Residential 3 1 216021
## 964 Residential 3 2 219000
## 965 Residential 3 2 219794
## 966 Residential 3 2 220000
## 967 Condo 3 2 220000
## 968 Residential 4 2 220000
## 969 Residential 4 2 220000
## 970 Residential 4 2 223000
## 971 Residential 0 0 224000
## 972 Residential 3 1 224000
## 973 Residential 3 1 224252
## 974 Residential 3 2 224500
## 975 Residential 3 1 225000
## 976 Residential 3 2 228000
## 977 Residential 3 2 229027
## 978 Residential 4 2 229500
## 979 Residential 4 2 230000
## 980 Residential 3 2 230000
## 981 Residential 4 3 232425
## 982 Residential 3 2 234000
## 983 Residential 3 2 235000
## 984 Residential 4 2 235301
## 985 Residential 3 2 235738#Select 4 bedroom houses
sac_new %>% filter(beds==4) %>% select(type,price)## type price
## 1 Residential 122682
## 2 Residential 123000
## 3 Residential 131200
## 4 Residential 148750
## 5 Residential 149593
## 6 Residential 161500
## 7 Residential 164000
## 8 Residential 165000
## 9 Residential 166357
## 10 Residential 166357
## 11 Residential 173000
## 12 Residential 174313
## 13 Multi-Family 179580
## 14 Residential 182587
## 15 Residential 183200
## 16 Multi-Family 195000
## 17 Residential 199500
## 18 Residential 212864
## 19 Residential 221000
## 20 Residential 227887
## 21 Residential 235000
## 22 Residential 236000
## 23 Residential 236685
## 24 Residential 250000
## 25 Residential 254200
## 26 Residential 273750
## 27 Residential 280987
## 28 Residential 285000
## 29 Residential 287417
## 30 Multi-Family 297000
## 31 Residential 311000
## 32 Residential 328360
## 33 Residential 335750
## 34 Residential 346210
## 35 Residential 347650
## 36 Residential 351300
## 37 Residential 370500
## 38 Residential 381942
## 39 Residential 387731
## 40 Residential 394470
## 41 Residential 400186
## 42 Residential 461000
## 43 Residential 489332
## 44 Residential 539000
## 45 Residential 600000
## 46 Residential 606238
## 47 Residential 70000
## 48 Residential 89000
## 49 Residential 145000
## 50 Residential 146000
## 51 Residential 150000
## 52 Residential 182000
## 53 Residential 184500
## 54 Residential 189000
## 55 Residential 202500
## 56 Residential 205000
## 57 Residential 205000
## 58 Residential 215000
## 59 Residential 225000
## 60 Residential 228000
## 61 Residential 229665
## 62 Residential 245000
## 63 Residential 250000
## 64 Residential 260000
## 65 Residential 261800
## 66 Residential 264469
## 67 Residential 265000
## 68 Residential 270000
## 69 Residential 275000
## 70 Residential 275000
## 71 Residential 280000
## 72 Residential 292000
## 73 Residential 297500
## 74 Residential 300000
## 75 Residential 300500
## 76 Residential 319789
## 77 Residential 336000
## 78 Residential 339000
## 79 Residential 345000
## 80 Residential 350000
## 81 Residential 361745
## 82 Residential 361948
## 83 Residential 380000
## 84 Residential 402000
## 85 Residential 406026
## 86 Residential 425000
## 87 Residential 436746
## 88 Residential 450000
## 89 Residential 460000
## 90 Residential 465000
## 91 Residential 485000
## 92 Residential 495000
## 93 Residential 582000
## 94 Residential 613401
## 95 Residential 614000
## 96 Residential 839000
## 97 Multi-Family 100000
## 98 Residential 102750
## 99 Residential 114000
## 100 Multi-Family 120000
## 101 Residential 125573
## 102 Residential 126714
## 103 Residential 127500
## 104 Residential 147000
## 105 Residential 158000
## 106 Residential 167293
## 107 Residential 167293
## 108 Residential 170000
## 109 Residential 180000
## 110 Residential 207000
## 111 Residential 208000
## 112 Residential 210000
## 113 Residential 213675
## 114 Residential 215000
## 115 Residential 215000
## 116 Residential 221000
## 117 Residential 225500
## 118 Residential 230000
## 119 Residential 231200
## 120 Residential 235000
## 121 Residential 238861
## 122 Residential 239700
## 123 Residential 240000
## 124 Residential 241000
## 125 Residential 246000
## 126 Residential 247234
## 127 Residential 247480
## 128 Residential 252155
## 129 Residential 258000
## 130 Residential 261000
## 131 Residential 261000
## 132 Residential 262500
## 133 Residential 266000
## 134 Residential 274425
## 135 Residential 277980
## 136 Residential 280000
## 137 Residential 285000
## 138 Residential 296000
## 139 Residential 296056
## 140 Residential 299940
## 141 Residential 305000
## 142 Residential 311328
## 143 Residential 328578
## 144 Residential 340000
## 145 Residential 351000
## 146 Residential 353767
## 147 Residential 356035
## 148 Residential 360552
## 149 Residential 371086
## 150 Residential 408431
## 151 Multi-Family 416767
## 152 Residential 420000
## 153 Residential 423000
## 154 Residential 423000
## 155 Residential 445000
## 156 Residential 450000
## 157 Residential 471000
## 158 Residential 475000
## 159 Residential 528000
## 160 Residential 636000
## 161 Residential 668365
## 162 Residential 4897
## 163 Residential 105000
## 164 Residential 109000
## 165 Residential 123000
## 166 Residential 124000
## 167 Residential 125000
## 168 Residential 137721
## 169 Residential 151000
## 170 Residential 158000
## 171 Residential 161600
## 172 Residential 165000
## 173 Residential 168000
## 174 Residential 179000
## 175 Residential 185074
## 176 Residential 186785
## 177 Residential 190000
## 178 Residential 195000
## 179 Residential 195000
## 180 Residential 204918
## 181 Residential 207000
## 182 Residential 207744
## 183 Residential 213750
## 184 Residential 215000
## 185 Residential 220000
## 186 Residential 220000
## 187 Multi-Family 221250
## 188 Residential 225000
## 189 Residential 228750
## 190 Residential 233500
## 191 Residential 240000
## 192 Residential 240000
## 193 Residential 243500
## 194 Residential 246750
## 195 Residential 249000
## 196 Residential 252000
## 197 Residential 257200
## 198 Residential 267750
## 199 Residential 272700
## 200 Residential 278000
## 201 Residential 280000
## 202 Residential 289000
## 203 Residential 290000
## 204 Residential 293996
## 205 Residential 294173
## 206 Residential 295000
## 207 Residential 298000
## 208 Residential 306000
## 209 Residential 310000
## 210 Residential 311518
## 211 Residential 315000
## 212 Residential 315000
## 213 Residential 315000
## 214 Residential 322000
## 215 Residential 325000
## 216 Residential 330000
## 217 Residential 331200
## 218 Residential 332000
## 219 Residential 341000
## 220 Residential 360000
## 221 Residential 367463
## 222 Residential 400000
## 223 Residential 412500
## 224 Residential 420454
## 225 Residential 446000
## 226 Residential 450000
## 227 Residential 455000
## 228 Residential 493000
## 229 Residential 533000
## 230 Residential 560000
## 231 Residential 575000
## 232 Residential 600000
## 233 Residential 600000
## 234 Residential 879000
## 235 Residential 884790
## 236 Residential 56950
## 237 Residential 80000
## 238 Residential 121500
## 239 Residential 126854
## 240 Residential 131750
## 241 Residential 150000
## 242 Residential 161250
## 243 Residential 165750
## 244 Multi-Family 170000
## 245 Residential 176850
## 246 Residential 179500
## 247 Residential 189836
## 248 Residential 190000
## 249 Residential 204750
## 250 Residential 205000
## 251 Residential 211500
## 252 Residential 220000
## 253 Residential 220000
## 254 Residential 223000
## 255 Residential 229500
## 256 Residential 230000
## 257 Residential 232425
## 258 Residential 235301#Count Residential type
count(sac_new,type=="Residential")## # A tibble: 2 x 2
## `type == "Residential"` n
## <lgl> <int>
## 1 FALSE 68
## 2 TRUE 917#Count Condo type
count(sac_new,type=="Condo")## # A tibble: 2 x 2
## `type == "Condo"` n
## <lgl> <int>
## 1 FALSE 931
## 2 TRUE 54#Count Multi-Family type
count(sac_new,type=="Multi-Family")## # A tibble: 2 x 2
## `type == "Multi-Family"` n
## <lgl> <int>
## 1 FALSE 972
## 2 TRUE 13#Find the average cost condo along with the sum and number
sac_new %>% group_by(type=="Condo") %>% summarise(avg_cost=mean(price), sum(price),n=n())## # A tibble: 2 x 4
## `type == "Condo"` avg_cost `sum(price)` n
## <lgl> <dbl> <int> <int>
## 1 FALSE 239020.0 222527662 931
## 2 TRUE 150082.2 8104438 54#Find homes over $500,000
sac_new %>% filter(price > 500000) %>% select(type, beds, price)## type beds price
## 1 Residential 5 510000
## 2 Residential 4 539000
## 3 Residential 0 585000
## 4 Residential 4 600000
## 5 Residential 4 606238
## 6 Residential 3 660000
## 7 Residential 6 830000
## 8 Residential 0 500500
## 9 Residential 3 504000
## 10 Residential 0 541000
## 11 Residential 0 560000
## 12 Residential 5 572500
## 13 Residential 4 582000
## 14 Residential 4 613401
## 15 Residential 4 614000
## 16 Residential 5 680000
## 17 Residential 5 699000
## 18 Residential 4 839000
## 19 Residential 3 506688
## 20 Residential 2 512000
## 21 Residential 5 520000
## 22 Residential 4 528000
## 23 Residential 5 579093
## 24 Residential 4 636000
## 25 Residential 4 668365
## 26 Residential 5 676200
## 27 Residential 3 677048
## 28 Residential 5 691659
## 29 Residential 5 760000
## 30 Residential 5 508000
## 31 Residential 0 511000
## 32 Residential 3 525000
## 33 Residential 4 533000
## 34 Residential 3 545000
## 35 Residential 4 560000
## 36 Residential 2 575000
## 37 Residential 4 575000
## 38 Residential 5 598695
## 39 Residential 5 600000
## 40 Residential 4 600000
## 41 Residential 4 600000
## 42 Residential 0 600000
## 43 Residential 5 610000
## 44 Residential 0 622500
## 45 Residential 0 680000
## 46 Residential 4 879000
## 47 Residential 4 884790#Select every variable with the exception of beds
select(sac_new,-beds)## type baths price
## 1 Residential 1 59222
## 2 Residential 1 68212
## 3 Residential 1 68880
## 4 Residential 1 69307
## 5 Residential 1 81900
## 6 Condo 1 89921
## 7 Residential 2 90895
## 8 Residential 1 91002
## 9 Condo 2 94905
## 10 Residential 2 98937
## 11 Residential 2 100309
## 12 Residential 2 106250
## 13 Residential 1 106852
## 14 Residential 1 107502
## 15 Residential 2 108750
## 16 Condo 2 110700
## 17 Residential 1 113263
## 18 Condo 1 116250
## 19 Residential 1 120000
## 20 Residential 2 121630
## 21 Residential 2 122000
## 22 Residential 2 122682
## 23 Residential 2 123000
## 24 Residential 2 124100
## 25 Residential 2 125000
## 26 Residential 2 126640
## 27 Residential 1 127281
## 28 Residential 2 129000
## 29 Residential 2 131200
## 30 Residential 2 132000
## 31 Condo 2 133000
## 32 Residential 2 134555
## 33 Residential 2 136500
## 34 Residential 2 138750
## 35 Condo 2 141000
## 36 Residential 2 146250
## 37 Residential 2 147308
## 38 Residential 2 148750
## 39 Residential 2 149593
## 40 Condo 1 150000
## 41 Condo 2 152000
## 42 Residential 2 154000
## 43 Residential 2 156896
## 44 Residential 2 161250
## 45 Residential 2 161500
## 46 Residential 1 164000
## 47 Residential 2 165000
## 48 Residential 1 166357
## 49 Residential 2 166357
## 50 Residential 2 168000
## 51 Residential 2 170000
## 52 Residential 2 173000
## 53 Residential 2 174250
## 54 Residential 2 174313
## 55 Residential 2 178480
## 56 Residential 2 178760
## 57 Multi-Family 2 179580
## 58 Residential 2 181000
## 59 Residential 1 181872
## 60 Residential 3 182587
## 61 Residential 2 182716
## 62 Residential 2 182750
## 63 Residential 2 183200
## 64 Residential 1 188741
## 65 Residential 2 189000
## 66 Residential 2 192067
## 67 Residential 2 194000
## 68 Residential 2 194818
## 69 Multi-Family 4 195000
## 70 Residential 2 198000
## 71 Residential 2 199500
## 72 Residential 2 200000
## 73 Residential 1 200000
## 74 Residential 0 206000
## 75 Residential 2 208000
## 76 Residential 2 212864
## 77 Residential 2 221000
## 78 Residential 2 221000
## 79 Residential 3 223058
## 80 Residential 2 227887
## 81 Residential 2 231477
## 82 Residential 2 234697
## 83 Residential 2 235000
## 84 Residential 2 236000
## 85 Residential 3 236685
## 86 Residential 2 237800
## 87 Residential 2 240122
## 88 Residential 2 242638
## 89 Residential 2 244000
## 90 Residential 0 244500
## 91 Residential 1 244960
## 92 Residential 3 245918
## 93 Residential 2 250000
## 94 Residential 2 250000
## 95 Condo 2 250134
## 96 Residential 2 254200
## 97 Residential 2 254200
## 98 Residential 3 258000
## 99 Residential 2 260000
## 100 Residential 1 260014
## 101 Residential 0 263500
## 102 Condo 2 265000
## 103 Residential 2 265000
## 104 Residential 1 271742
## 105 Residential 3 273750
## 106 Residential 2 275086
## 107 Residential 2 280908
## 108 Residential 3 280987
## 109 Multi-Family 4 282400
## 110 Residential 2 285000
## 111 Residential 2 287417
## 112 Residential 2 291000
## 113 Residential 1 292024
## 114 Multi-Family 4 297000
## 115 Residential 3 297000
## 116 Residential 2 298000
## 117 Residential 2 299000
## 118 Residential 3 304037
## 119 Residential 2 311000
## 120 Residential 3 315537
## 121 Residential 4 320000
## 122 Residential 0 320000
## 123 Residential 3 328360
## 124 Residential 1 334150
## 125 Residential 3 335750
## 126 Residential 3 335750
## 127 Residential 0 339500
## 128 Residential 2 344250
## 129 Residential 2 346210
## 130 Residential 3 347029
## 131 Residential 2 347650
## 132 Residential 3 351300
## 133 Residential 2 352000
## 134 Residential 0 370000
## 135 Residential 3 370500
## 136 Residential 2 372000
## 137 Residential 3 375000
## 138 Residential 3 381300
## 139 Residential 2 381942
## 140 Residential 2 387731
## 141 Residential 3 391000
## 142 Residential 3 394470
## 143 Residential 2 395000
## 144 Residential 3 400186
## 145 Residential 3 415000
## 146 Residential 3 425000
## 147 Residential 3 430000
## 148 Residential 0 445000
## 149 Residential 3 460000
## 150 Residential 3 461000
## 151 Residential 3 489332
## 152 Residential 4 510000
## 153 Residential 2 539000
## 154 Residential 0 585000
## 155 Residential 3 600000
## 156 Residential 3 606238
## 157 Residential 3 660000
## 158 Residential 5 830000
## 159 Condo 1 69000
## 160 Residential 2 70000
## 161 Condo 1 71000
## 162 Residential 1 78000
## 163 Residential 1 78400
## 164 Residential 1 80000
## 165 Residential 2 89000
## 166 Residential 1 90000
## 167 Residential 1 90000
## 168 Residential 1 92000
## 169 Residential 1 93675
## 170 Residential 0 97750
## 171 Residential 1 98000
## 172 Condo 1 98000
## 173 Residential 1 99000
## 174 Condo 1 100000
## 175 Residential 1 106716
## 176 Residential 1 111000
## 177 Residential 1 111000
## 178 Residential 2 114800
## 179 Residential 1 120108
## 180 Residential 1 123225
## 181 Residential 2 123750
## 182 Residential 1 125000
## 183 Residential 2 125000
## 184 Residential 2 126000
## 185 Residential 1 129000
## 186 Residential 1 134000
## 187 Residential 2 135000
## 188 Residential 2 135500
## 189 Residential 1 140000
## 190 Residential 2 140000
## 191 Condo 2 142500
## 192 Residential 2 143500
## 193 Condo 0 145000
## 194 Residential 1 145000
## 195 Residential 2 145000
## 196 Residential 2 145000
## 197 Residential 2 146000
## 198 Residential 1 148500
## 199 Residential 2 149000
## 200 Residential 2 150000
## 201 Residential 2 150000
## 202 Residential 2 152000
## 203 Residential 2 156000
## 204 Residential 1 156000
## 205 Residential 2 156000
## 206 Residential 1 157788
## 207 Residential 2 161653
## 208 Residential 1 161829
## 209 Residential 2 165000
## 210 Residential 2 168000
## 211 Residential 2 169000
## 212 Residential 2 175000
## 213 Residential 2 176250
## 214 Residential 2 179000
## 215 Residential 2 180000
## 216 Residential 2 180400
## 217 Residential 2 182000
## 218 Residential 2 184500
## 219 Residential 2 185000
## 220 Residential 2 189000
## 221 Residential 2 194000
## 222 Residential 1 195000
## 223 Residential 2 200000
## 224 Residential 1 201000
## 225 Residential 2 202500
## 226 Residential 2 205000
## 227 Residential 2 205000
## 228 Residential 2 205000
## 229 Residential 3 205000
## 230 Residential 1 207000
## 231 Residential 2 210000
## 232 Residential 1 211500
## 233 Residential 2 215000
## 234 Residential 2 215000
## 235 Residential 0 215500
## 236 Residential 1 222381
## 237 Condo 0 225000
## 238 Residential 2 225000
## 239 Residential 2 225000
## 240 Residential 2 225000
## 241 Residential 2 228000
## 242 Residential 2 229665
## 243 Residential 1 230000
## 244 Residential 2 230000
## 245 Residential 2 230000
## 246 Residential 2 234000
## 247 Residential 2 235000
## 248 Residential 1 236250
## 249 Condo 0 240000
## 250 Residential 0 242000
## 251 Residential 2 245000
## 252 Residential 3 245000
## 253 Residential 1 245000
## 254 Residential 0 250000
## 255 Residential 2 250000
## 256 Residential 2 250000
## 257 Residential 2 250000
## 258 Residential 2 255000
## 259 Multi-Family 4 256054
## 260 Residential 2 257729
## 261 Residential 2 260000
## 262 Residential 2 261000
## 263 Residential 2 261800
## 264 Residential 2 264469
## 265 Residential 3 265000
## 266 Residential 0 270000
## 267 Residential 3 270000
## 268 Residential 2 270000
## 269 Residential 0 270000
## 270 Residential 3 275000
## 271 Residential 2 275000
## 272 Residential 3 280000
## 273 Residential 2 286013
## 274 Residential 2 292000
## 275 Residential 2 292000
## 276 Residential 2 293993
## 277 Residential 2 294000
## 278 Residential 2 296769
## 279 Residential 4 297500
## 280 Condo 0 300000
## 281 Residential 1 300000
## 282 Residential 3 300000
## 283 Residential 2 300000
## 284 Residential 2 300500
## 285 Residential 2 305000
## 286 Residential 0 306500
## 287 Residential 0 312500
## 288 Residential 3 315000
## 289 Residential 2 319789
## 290 Residential 2 330000
## 291 Residential 2 330000
## 292 Residential 2 331000
## 293 Residential 1 334000
## 294 Residential 3 336000
## 295 Residential 1 339000
## 296 Residential 2 339000
## 297 Residential 2 345000
## 298 Residential 3 350000
## 299 Residential 2 356000
## 300 Residential 2 361745
## 301 Residential 2 361948
## 302 Residential 3 370000
## 303 Residential 2 380000
## 304 Residential 4 385000
## 305 Residential 2 399000
## 306 Residential 2 402000
## 307 Residential 3 406026
## 308 Residential 4 420000
## 309 Residential 0 425000
## 310 Residential 2 425000
## 311 Residential 0 433500
## 312 Residential 3 436746
## 313 Residential 3 438700
## 314 Residential 1 445000
## 315 Residential 2 450000
## 316 Residential 1 460000
## 317 Residential 2 460000
## 318 Residential 3 460000
## 319 Residential 4 465000
## 320 Residential 3 471750
## 321 Residential 3 480000
## 322 Residential 2 484000
## 323 Residential 3 485000
## 324 Residential 3 495000
## 325 Residential 0 500500
## 326 Residential 3 504000
## 327 Residential 0 541000
## 328 Residential 0 560000
## 329 Residential 3 572500
## 330 Residential 2 582000
## 331 Residential 3 613401
## 332 Residential 2 614000
## 333 Residential 5 680000
## 334 Residential 2 699000
## 335 Residential 4 839000
## 336 Condo 1 40000
## 337 Condo 1 48000
## 338 Residential 1 61500
## 339 Residential 1 62050
## 340 Residential 1 65000
## 341 Residential 1 65000
## 342 Residential 1 68000
## 343 Residential 1 68000
## 344 Condo 1 77000
## 345 Condo 1 82732
## 346 Residential 1 84000
## 347 Residential 1 84675
## 348 Residential 1 85000
## 349 Residential 1 90000
## 350 Condo 1 90000
## 351 Residential 2 91000
## 352 Residential 1 95000
## 353 Residential 1 97500
## 354 Multi-Family 2 100000
## 355 Condo 1 100000
## 356 Residential 1 101000
## 357 Residential 2 102750
## 358 Residential 1 112500
## 359 Residential 1 113000
## 360 Residential 2 114000
## 361 Residential 1 114000
## 362 Residential 1 114750
## 363 Condo 2 115000
## 364 Condo 2 115000
## 365 Residential 1 116100
## 366 Residential 2 119250
## 367 Multi-Family 4 120000
## 368 Residential 1 120000
## 369 Condo 2 120000
## 370 Residential 2 120108
## 371 Residential 2 121500
## 372 Residential 1 121725
## 373 Residential 2 122000
## 374 Residential 2 123000
## 375 Residential 1 125000
## 376 Residential 2 125573
## 377 Residential 2 126714
## 378 Condo 1 126960
## 379 Condo 1 127000
## 380 Residential 2 127500
## 381 Residential 2 130000
## 382 Residential 1 133105
## 383 Residential 2 136500
## 384 Condo 2 139500
## 385 Residential 2 140000
## 386 Residential 2 140800
## 387 Residential 2 145000
## 388 Residential 2 147000
## 389 Residential 2 149600
## 390 Residential 2 150000
## 391 Condo 2 150000
## 392 Residential 2 150000
## 393 Residential 2 155000
## 394 Residential 2 155435
## 395 Residential 2 155500
## 396 Residential 2 158000
## 397 Residential 2 158000
## 398 Residential 2 160000
## 399 Residential 1 160000
## 400 Residential 2 164000
## 401 Residential 2 164000
## 402 Residential 2 165000
## 403 Residential 2 167000
## 404 Residential 2 167293
## 405 Residential 2 167293
## 406 Residential 1 168000
## 407 Residential 2 170000
## 408 Residential 2 170000
## 409 Residential 2 170000
## 410 Residential 2 174000
## 411 Residential 2 178000
## 412 Residential 2 180000
## 413 Residential 2 180000
## 414 Residential 2 180000
## 415 Condo 2 182000
## 416 Residential 1 188325
## 417 Residential 2 191500
## 418 Residential 2 192000
## 419 Residential 2 192700
## 420 Residential 1 195000
## 421 Residential 2 197654
## 422 Residential 1 198000
## 423 Residential 2 200345
## 424 Residential 1 203000
## 425 Residential 2 207000
## 426 Residential 3 208000
## 427 Residential 2 210000
## 428 Residential 1 212000
## 429 Residential 2 213675
## 430 Residential 2 213697
## 431 Residential 2 215000
## 432 Residential 3 215000
## 433 Residential 1 215100
## 434 Residential 2 217500
## 435 Residential 2 218000
## 436 Residential 1 220000
## 437 Residential 3 221000
## 438 Residential 2 222900
## 439 Residential 1 223139
## 440 Residential 2 225500
## 441 Residential 2 228327
## 442 Residential 2 230000
## 443 Residential 2 230000
## 444 Condo 1 230522
## 445 Residential 3 231200
## 446 Residential 2 232000
## 447 Condo 2 232500
## 448 Residential 1 233641
## 449 Residential 2 234000
## 450 Residential 2 234500
## 451 Residential 3 235000
## 452 Multi-Family 4 236000
## 453 Residential 2 236073
## 454 Condo 2 238000
## 455 Residential 2 238861
## 456 Residential 3 239700
## 457 Residential 2 240000
## 458 Residential 3 240000
## 459 Residential 2 241000
## 460 Residential 2 245000
## 461 Residential 3 246000
## 462 Residential 2 247234
## 463 Residential 2 247480
## 464 Residential 1 249862
## 465 Residential 2 251000
## 466 Residential 2 252155
## 467 Residential 2 254172
## 468 Residential 2 258000
## 469 Condo 2 260000
## 470 Residential 0 261000
## 471 Residential 3 261000
## 472 Residential 2 261000
## 473 Residential 2 262500
## 474 Residential 2 266000
## 475 Residential 1 266000
## 476 Residential 2 270000
## 477 Residential 3 274425
## 478 Residential 0 274500
## 479 Residential 2 275336
## 480 Residential 3 277980
## 481 Residential 2 280000
## 482 Residential 3 284686
## 483 Residential 2 284893
## 484 Residential 2 285000
## 485 Multi-Family 2 285000
## 486 Residential 2 285000
## 487 Residential 2 289000
## 488 Residential 3 295000
## 489 Residential 2 296000
## 490 Residential 2 296056
## 491 Residential 2 297359
## 492 Residential 2 299940
## 493 Residential 3 304000
## 494 Residential 3 305000
## 495 Residential 0 307000
## 496 Residential 2 311328
## 497 Residential 2 313138
## 498 Residential 2 316630
## 499 Residential 3 320000
## 500 Residential 3 320000
## 501 Residential 3 325000
## 502 Residential 2 328578
## 503 Residential 3 331000
## 504 Residential 0 331500
## 505 Residential 2 340000
## 506 Residential 0 344755
## 507 Residential 2 345746
## 508 Residential 2 351000
## 509 Residential 2 353767
## 510 Residential 0 355000
## 511 Residential 2 356035
## 512 Condo 0 360000
## 513 Residential 2 360552
## 514 Residential 2 362305
## 515 Residential 1 365000
## 516 Residential 2 367554
## 517 Residential 0 368500
## 518 Residential 2 370000
## 519 Residential 2 371086
## 520 Residential 2 378000
## 521 Residential 0 383000
## 522 Residential 1 388000
## 523 Residential 3 395100
## 524 Residential 2 400000
## 525 Residential 2 400000
## 526 Residential 3 408431
## 527 Residential 0 413000
## 528 Multi-Family 2 416767
## 529 Residential 3 420000
## 530 Residential 3 423000
## 531 Residential 2 423000
## 532 Residential 3 427500
## 533 Residential 2 430922
## 534 Residential 2 445000
## 535 Residential 4 450000
## 536 Residential 3 452000
## 537 Residential 2 470000
## 538 Residential 3 471000
## 539 Residential 4 475000
## 540 Residential 3 484500
## 541 Residential 3 487500
## 542 Residential 3 488750
## 543 Residential 2 500000
## 544 Residential 2 506688
## 545 Residential 2 512000
## 546 Residential 3 520000
## 547 Residential 2 528000
## 548 Residential 2 579093
## 549 Residential 3 636000
## 550 Residential 3 668365
## 551 Residential 3 676200
## 552 Residential 2 677048
## 553 Residential 3 691659
## 554 Residential 3 760000
## 555 Residential 0 4897
## 556 Residential 0 4897
## 557 Residential 0 4897
## 558 Residential 0 4897
## 559 Residential 0 4897
## 560 Residential 0 4897
## 561 Residential 0 4897
## 562 Residential 0 4897
## 563 Residential 0 4897
## 564 Residential 0 4897
## 565 Residential 0 4897
## 566 Residential 0 4897
## 567 Residential 0 4897
## 568 Residential 0 4897
## 569 Residential 0 4897
## 570 Residential 0 4897
## 571 Residential 0 4897
## 572 Residential 0 4897
## 573 Residential 0 4897
## 574 Residential 0 4897
## 575 Residential 0 4897
## 576 Residential 0 4897
## 577 Residential 0 4897
## 578 Residential 0 4897
## 579 Residential 0 4897
## 580 Residential 2 4897
## 581 Residential 2 4897
## 582 Residential 2 4897
## 583 Residential 0 4897
## 584 Residential 0 4897
## 585 Residential 0 4897
## 586 Residential 0 4897
## 587 Residential 0 4897
## 588 Residential 0 4897
## 589 Residential 0 4897
## 590 Residential 0 4897
## 591 Residential 0 4897
## 592 Residential 0 4897
## 593 Residential 0 4897
## 594 Residential 0 4897
## 595 Residential 0 4897
## 596 Residential 0 4897
## 597 Residential 0 4897
## 598 Residential 0 4897
## 599 Residential 0 4897
## 600 Residential 0 4897
## 601 Residential 0 4897
## 602 Residential 0 4897
## 603 Residential 0 4897
## 604 Residential 2 30000
## 605 Residential 0 30000
## 606 Residential 1 55422
## 607 Residential 1 63000
## 608 Residential 1 65000
## 609 Residential 1 65000
## 610 Residential 1 65000
## 611 Residential 2 66500
## 612 Residential 1 71000
## 613 Residential 1 75000
## 614 Condo 1 77000
## 615 Residential 1 85000
## 616 Residential 2 95625
## 617 Residential 1 96140
## 618 Condo 1 104250
## 619 Residential 2 105000
## 620 Residential 1 108000
## 621 Residential 2 109000
## 622 Residential 1 115000
## 623 Condo 1 115000
## 624 Residential 2 115500
## 625 Residential 2 115620
## 626 Residential 2 116000
## 627 Residential 2 122000
## 628 Residential 2 122500
## 629 Residential 2 123000
## 630 Residential 2 124000
## 631 Residential 2 124000
## 632 Residential 2 124413
## 633 Residential 2 125000
## 634 Residential 2 130000
## 635 Residential 2 131750
## 636 Residential 3 137721
## 637 Residential 2 137760
## 638 Residential 2 138000
## 639 Residential 1 140000
## 640 Residential 1 145000
## 641 Residential 2 145000
## 642 Residential 2 150000
## 643 Residential 2 150000
## 644 Residential 2 151000
## 645 Residential 2 155000
## 646 Residential 2 155800
## 647 Residential 2 156142
## 648 Residential 2 158000
## 649 Multi-Family 4 159900
## 650 Residential 2 160000
## 651 Residential 2 161500
## 652 Residential 2 161600
## 653 Residential 2 162000
## 654 Residential 2 165000
## 655 Residential 2 165000
## 656 Residential 2 167293
## 657 Residential 2 168000
## 658 Residential 2 168000
## 659 Residential 2 168750
## 660 Residential 1 168750
## 661 Residential 1 170000
## 662 Residential 2 170250
## 663 Residential 2 173000
## 664 Residential 1 175000
## 665 Residential 2 176095
## 666 Residential 2 176250
## 667 Residential 2 178000
## 668 Residential 2 179000
## 669 Residential 2 180000
## 670 Residential 2 180000
## 671 Residential 2 180000
## 672 Residential 2 181000
## 673 Residential 2 182000
## 674 Residential 2 182587
## 675 Residential 2 185074
## 676 Residential 2 185833
## 677 Residential 2 186785
## 678 Residential 2 187000
## 679 Residential 2 188335
## 680 Residential 2 190000
## 681 Residential 1 190000
## 682 Residential 2 190000
## 683 Residential 1 190000
## 684 Residential 2 191250
## 685 Residential 2 193000
## 686 Residential 2 193500
## 687 Residential 0 194818
## 688 Residential 2 195000
## 689 Residential 3 195000
## 690 Residential 2 195000
## 691 Residential 1 195000
## 692 Residential 1 198000
## 693 Residential 2 199900
## 694 Residential 1 200000
## 695 Residential 1 201000
## 696 Residential 2 204918
## 697 Residential 2 205000
## 698 Residential 1 205000
## 699 Residential 2 205878
## 700 Residential 2 207000
## 701 Residential 2 207744
## 702 Residential 2 209000
## 703 Residential 2 210000
## 704 Condo 1 210944
## 705 Condo 2 212500
## 706 Residential 2 213750
## 707 Residential 2 215000
## 708 Residential 2 215000
## 709 Residential 1 215000
## 710 Residential 2 216033
## 711 Residential 2 220000
## 712 Residential 1 220000
## 713 Residential 1 220000
## 714 Residential 2 220000
## 715 Residential 2 220000
## 716 Residential 2 220702
## 717 Multi-Family 2 221250
## 718 Residential 2 222000
## 719 Residential 0 222500
## 720 Residential 2 222750
## 721 Residential 2 225000
## 722 Residential 2 225000
## 723 Residential 3 228750
## 724 Residential 2 229000
## 725 Residential 2 230095
## 726 Residential 3 232500
## 727 Residential 2 233000
## 728 Residential 2 233500
## 729 Residential 2 239000
## 730 Residential 3 240000
## 731 Residential 2 240000
## 732 Residential 2 240971
## 733 Residential 2 242000
## 734 Residential 2 243450
## 735 Residential 2 243500
## 736 Residential 2 246544
## 737 Residential 2 246750
## 738 Residential 0 247000
## 739 Residential 2 247000
## 740 Residential 2 249000
## 741 Residential 3 249000
## 742 Residential 2 250000
## 743 Residential 2 250000
## 744 Residential 0 250000
## 745 Residential 2 252000
## 746 Residential 2 255000
## 747 Residential 1 255000
## 748 Residential 2 255000
## 749 Residential 2 257200
## 750 Residential 2 260000
## 751 Residential 2 260000
## 752 Residential 2 263500
## 753 Residential 2 266510
## 754 Residential 2 267750
## 755 Residential 0 270000
## 756 Residential 0 271000
## 757 Residential 2 272700
## 758 Unkown 0 275000
## 759 Residential 2 275000
## 760 Residential 3 276000
## 761 Residential 2 276500
## 762 Residential 3 278000
## 763 Residential 3 279000
## 764 Residential 2 280000
## 765 Residential 2 280000
## 766 Residential 2 285000
## 767 Residential 2 288000
## 768 Residential 3 289000
## 769 Residential 2 290000
## 770 Residential 2 290000
## 771 Residential 2 293996
## 772 Residential 2 294000
## 773 Residential 2 294173
## 774 Residential 2 295000
## 775 Residential 0 298000
## 776 Residential 2 298000
## 777 Residential 1 299000
## 778 Residential 2 300000
## 779 Residential 2 300000
## 780 Residential 3 300000
## 781 Residential 2 300567
## 782 Residential 3 303000
## 783 Residential 2 305000
## 784 Residential 2 306000
## 785 Residential 2 310000
## 786 Residential 2 310000
## 787 Residential 3 310000
## 788 Residential 2 311518
## 789 Residential 3 312000
## 790 Residential 0 313000
## 791 Residential 2 315000
## 792 Residential 3 315000
## 793 Residential 3 315000
## 794 Residential 2 315000
## 795 Residential 2 315000
## 796 Residential 2 320000
## 797 Residential 3 322000
## 798 Residential 2 325000
## 799 Residential 0 325500
## 800 Residential 2 326951
## 801 Residential 2 328370
## 802 Residential 2 330000
## 803 Residential 3 330000
## 804 Residential 2 331200
## 805 Residential 3 332000
## 806 Residential 3 334000
## 807 Residential 2 335000
## 808 Residential 2 341000
## 809 Residential 3 346375
## 810 Residential 3 347225
## 811 Residential 3 349000
## 812 Residential 2 350000
## 813 Residential 2 350000
## 814 Residential 2 350000
## 815 Condo 2 350000
## 816 Residential 2 351000
## 817 Residential 2 356200
## 818 Residential 2 360000
## 819 Residential 3 367463
## 820 Residential 0 375000
## 821 Residential 1 380000
## 822 Residential 2 380578
## 823 Residential 2 386222
## 824 Residential 0 389000
## 825 Residential 0 390000
## 826 Residential 2 395500
## 827 Residential 0 396000
## 828 Residential 3 397000
## 829 Residential 0 400000
## 830 Residential 2 400000
## 831 Residential 3 412500
## 832 Residential 1 413500
## 833 Residential 2 415000
## 834 Residential 3 420454
## 835 Residential 1 425000
## 836 Residential 2 425000
## 837 Residential 0 433500
## 838 Residential 3 438000
## 839 Residential 3 441000
## 840 Residential 3 445000
## 841 Residential 3 446000
## 842 Residential 2 450000
## 843 Residential 3 455000
## 844 Residential 2 460000
## 845 Residential 2 475000
## 846 Residential 2 490000
## 847 Residential 2 493000
## 848 Residential 4 508000
## 849 Residential 0 511000
## 850 Residential 2 525000
## 851 Residential 3 533000
## 852 Residential 1 545000
## 853 Residential 3 560000
## 854 Residential 1 575000
## 855 Residential 3 575000
## 856 Residential 4 598695
## 857 Residential 3 600000
## 858 Residential 3 600000
## 859 Residential 3 600000
## 860 Residential 0 600000
## 861 Residential 3 610000
## 862 Residential 0 622500
## 863 Residential 0 680000
## 864 Residential 3 879000
## 865 Residential 3 884790
## 866 Residential 3 1551
## 867 Residential 4 2000
## 868 Residential 2 56950
## 869 Condo 1 60000
## 870 Residential 1 61000
## 871 Condo 1 62000
## 872 Residential 1 68566
## 873 Residential 1 70000
## 874 Residential 2 80000
## 875 Residential 2 85500
## 876 Condo 1 92000
## 877 Residential 2 93600
## 878 Residential 1 95000
## 879 Residential 2 97750
## 880 Residential 2 104000
## 881 Residential 1 105000
## 882 Condo 1 107666
## 883 Residential 1 109000
## 884 Residential 1 110000
## 885 Residential 1 110000
## 886 Residential 2 112500
## 887 Residential 2 114800
## 888 Residential 1 116000
## 889 Condo 0 119000
## 890 Residential 2 121500
## 891 Residential 2 122000
## 892 Residential 2 123675
## 893 Residential 2 126854
## 894 Residential 2 127059
## 895 Residential 1 128687
## 896 Residential 2 129500
## 897 Residential 2 130000
## 898 Residential 2 131750
## 899 Residential 1 132000
## 900 Residential 2 134000
## 901 Residential 1 134000
## 902 Condo 0 138000
## 903 Residential 2 142000
## 904 Residential 1 143012
## 905 Residential 2 145846
## 906 Residential 1 147000
## 907 Residential 1 148750
## 908 Residential 2 150000
## 909 Condo 1 150454
## 910 Residential 2 151087
## 911 Residential 2 157296
## 912 Residential 2 157500
## 913 Residential 2 160000
## 914 Residential 2 160000
## 915 Residential 2 161250
## 916 Residential 2 164000
## 917 Residential 1 165000
## 918 Residential 0 165000
## 919 Residential 2 165750
## 920 Residential 1 166000
## 921 Residential 2 169000
## 922 Residential 2 170000
## 923 Condo 2 170000
## 924 Multi-Family 2 170000
## 925 Residential 2 170000
## 926 Residential 1 170725
## 927 Residential 2 171750
## 928 Residential 2 172000
## 929 Residential 2 173056
## 930 Residential 2 174000
## 931 Residential 2 174250
## 932 Residential 2 176850
## 933 Residential 2 179500
## 934 Residential 1 185000
## 935 Condo 0 188000
## 936 Residential 2 188700
## 937 Residential 1 189000
## 938 Residential 1 189000
## 939 Residential 3 189836
## 940 Residential 2 190000
## 941 Residential 2 191250
## 942 Residential 2 191675
## 943 Residential 2 195500
## 944 Residential 1 198000
## 945 Residential 2 200000
## 946 Residential 2 200000
## 947 Residential 2 200000
## 948 Residential 0 200100
## 949 Residential 2 201528
## 950 Residential 2 204750
## 951 Residential 3 205000
## 952 Residential 2 205000
## 953 Residential 2 205900
## 954 Residential 2 207000
## 955 Residential 1 207973
## 956 Residential 2 208250
## 957 Residential 1 208318
## 958 Residential 2 209347
## 959 Residential 2 211500
## 960 Residential 2 212000
## 961 Residential 2 213000
## 962 Residential 2 216000
## 963 Residential 1 216021
## 964 Residential 2 219000
## 965 Residential 2 219794
## 966 Residential 2 220000
## 967 Condo 2 220000
## 968 Residential 2 220000
## 969 Residential 2 220000
## 970 Residential 2 223000
## 971 Residential 0 224000
## 972 Residential 1 224000
## 973 Residential 1 224252
## 974 Residential 2 224500
## 975 Residential 1 225000
## 976 Residential 2 228000
## 977 Residential 2 229027
## 978 Residential 2 229500
## 979 Residential 2 230000
## 980 Residential 2 230000
## 981 Residential 3 232425
## 982 Residential 2 234000
## 983 Residential 2 235000
## 984 Residential 2 235301
## 985 Residential 2 235738