Chapter 2 Data sources
2.1 Source
We scraped the data from https://www.zillow.com/research/data/, which is a big player in NY rental market. Zillow Observed Rent Index (ZORI): A smoothed measure of the typical observed market rate rent across a given region. ZORI is a repeat-rent index that is weighted to the rental housing stock to ensure representativeness across the entire market, not just those homes currently listed for-rent. The index is dollar-denominated by computing the mean of listed rents that fall into the 40th to 60th percentile range for all homes and apartments in a given region, which is once again weighted to reflect the rental housing stock.
2.2 Information about the data
- Number of rows - 105
- Number of columns - 97
The data contains the rental prices (in USD) of 104 different cities in US from Jan 2014 to Oct 2021.
2.3 Format of the data
| Variables | Description |
|---|---|
| RegionID | ID mentioned for that particular region of US (Integer) |
| RegionName | A city in the US (String) |
| SizeRank | The rank assigned to that particular region (Integer) |
| 2014-01 to 2021-10 | Rental price for that particular month, in USD (Integer) |
2.4 A quick sample of the data
## RegionID RegionName SizeRank X2014.01 X2014.02
## 1 102001 United States 0 1347 1352
## 2 394913 New York, NY 1 2356 2366
## 3 753899 Los Angeles-Long Beach-Anaheim, CA 2 1719 1730
## 4 394463 Chicago, IL 3 1374 1378
## 5 394514 Dallas-Fort Worth, TX 4 1125 1129
## 6 394974 Philadelphia, PA 5 1335 1338
## 7 394692 Houston, TX 6 1171 1178
## 8 395209 Washington, DC 7 1846 1849
## 9 394856 Miami-Fort Lauderdale, FL 8 1548 1556
## 10 394347 Atlanta, GA 9 1078 1081
## X2014.03 X2014.04 X2014.05 X2014.06 X2014.07 X2014.08 X2014.09 X2014.10
## 1 1358 1364 1369 1375 1380 1386 1391 1397
## 2 2376 2387 2397 2408 2418 2429 2439 2449
## 3 1740 1750 1761 1771 1782 1792 1802 1813
## 4 1381 1385 1388 1392 1395 1399 1402 1405
## 5 1132 1136 1139 1143 1147 1150 1154 1158
## 6 1341 1343 1346 1349 1351 1354 1357 1360
## 7 1185 1192 1198 1205 1211 1218 1224 1231
## 8 1852 1855 1858 1861 1864 1866 1869 1872
## 9 1563 1571 1579 1586 1594 1602 1609 1617
## 10 1085 1089 1093 1097 1101 1105 1109 1113
## X2014.11 X2014.12 X2015.01 X2015.02 X2015.03 X2015.04 X2015.05 X2015.06
## 1 1403 1408 1414 1419 1425 1430 1435 1441
## 2 2459 2470 2480 2489 2498 2508 2517 2526
## 3 1823 1833 1844 1854 1864 1874 1884 1894
## 4 1409 1412 1416 1419 1423 1426 1430 1434
## 5 1162 1166 1170 1174 1179 1184 1188 1193
## 6 1363 1366 1369 1372 1375 1378 1381 1384
## 7 1236 1241 1247 1250 1254 1257 1260 1263
## 8 1874 1877 1879 1881 1883 1885 1887 1890
## 9 1625 1633 1640 1648 1656 1664 1672 1680
## 10 1117 1122 1127 1132 1137 1142 1146 1151
## X2015.07 X2015.08 X2015.09 X2015.10 X2015.11 X2015.12 X2016.01 X2016.02
## 1 1446 1451 1457 1462 1467 1472 1477 1482
## 2 2535 2542 2550 2557 2563 2569 2574 2579
## 3 1904 1915 1926 1936 1947 1957 1968 1978
## 4 1437 1442 1446 1451 1455 1460 1465 1468
## 5 1197 1202 1206 1211 1216 1221 1226 1231
## 6 1388 1391 1395 1399 1402 1406 1409 1413
## 7 1266 1269 1271 1274 1275 1276 1278 1278
## 8 1893 1896 1899 1902 1905 1908 1911 1914
## 9 1687 1695 1703 1710 1717 1723 1730 1734
## 10 1156 1162 1167 1172 1178 1183 1189 1195
## X2016.03 X2016.04 X2016.05 X2016.06 X2016.07 X2016.08 X2016.09 X2016.10
## 1 1486 1491 1495 1499 1503 1507 1511 1515
## 2 2583 2588 2592 2596 2599 2603 2607 2610
## 3 1988 1998 2007 2016 2026 2035 2044 2053
## 4 1472 1475 1478 1481 1484 1486 1489 1492
## 5 1236 1241 1246 1251 1257 1262 1267 1271
## 6 1416 1419 1422 1425 1428 1431 1434 1437
## 7 1278 1278 1278 1278 1277 1276 1276 1275
## 8 1916 1919 1921 1923 1926 1928 1931 1933
## 9 1739 1744 1747 1750 1754 1756 1759 1762
## 10 1201 1207 1213 1219 1225 1231 1236 1242
## X2016.11 X2016.12 X2017.01 X2017.02 X2017.03 X2017.04 X2017.05 X2017.06
## 1 1519 1523 1527 1531 1535 1539 1543 1548
## 2 2614 2618 2622 2626 2629 2633 2637 2640
## 3 2062 2071 2080 2089 2098 2106 2115 2123
## 4 1494 1497 1499 1502 1504 1506 1509 1512
## 5 1276 1281 1285 1289 1294 1298 1302 1306
## 6 1439 1442 1444 1447 1449 1452 1455 1458
## 7 1275 1275 1275 1276 1277 1278 1281 1284
## 8 1936 1939 1942 1945 1948 1952 1954 1956
## 9 1764 1767 1770 1773 1777 1780 1784 1787
## 10 1248 1253 1259 1265 1270 1276 1282 1287
## X2017.07 X2017.08 X2017.09 X2017.10 X2017.11 X2017.12 X2018.01 X2018.02
## 1 1552 1556 1560 1565 1569 1573 1578 1582
## 2 2643 2646 2648 2651 2653 2656 2659 2662
## 3 2131 2139 2147 2155 2162 2169 2177 2184
## 4 1514 1517 1520 1522 1524 1527 1529 1532
## 5 1311 1315 1319 1323 1326 1330 1334 1337
## 6 1461 1464 1467 1470 1473 1477 1480 1484
## 7 1287 1291 1295 1299 1303 1307 1311 1315
## 8 1959 1961 1963 1965 1968 1970 1973 1976
## 9 1791 1795 1799 1803 1807 1811 1815 1819
## 10 1293 1299 1305 1311 1317 1324 1330 1336
## X2018.03 X2018.04 X2018.05 X2018.06 X2018.07 X2018.08 X2018.09 X2018.10
## 1 1587 1591 1596 1601 1606 1611 1616 1621
## 2 2665 2668 2673 2677 2681 2686 2691 2697
## 3 2192 2199 2207 2215 2223 2230 2238 2246
## 4 1534 1536 1539 1542 1544 1547 1550 1553
## 5 1341 1344 1348 1351 1355 1359 1363 1368
## 6 1487 1491 1495 1499 1503 1507 1511 1515
## 7 1319 1322 1324 1327 1329 1331 1332 1334
## 8 1980 1983 1988 1992 1996 2002 2007 2012
## 9 1823 1827 1832 1836 1841 1845 1850 1854
## 10 1342 1348 1355 1362 1369 1376 1383 1390
## X2018.11 X2018.12 X2019.01 X2019.02 X2019.03 X2019.04 X2019.05 X2019.06
## 1 1626 1631 1636 1641 1646 1650 1655 1660
## 2 2702 2708 2714 2720 2725 2731 2736 2741
## 3 2253 2260 2268 2275 2281 2288 2295 2301
## 4 1556 1560 1563 1566 1570 1574 1577 1581
## 5 1372 1376 1381 1385 1389 1393 1397 1401
## 6 1519 1524 1528 1532 1536 1540 1544 1548
## 7 1336 1338 1340 1342 1343 1345 1347 1349
## 8 2017 2022 2027 2032 2037 2042 2046 2051
## 9 1858 1863 1867 1871 1874 1878 1882 1887
## 10 1397 1404 1411 1417 1424 1430 1436 1441
## X2019.07 X2019.08 X2019.09 X2019.10 X2019.11 X2019.12 X2020.01 X2020.02
## 1 1665 1669 1673 1677 1679 1681 1684 1684
## 2 2746 2749 2753 2756 2753 2751 2748 2734
## 3 2308 2313 2318 2323 2324 2326 2327 2326
## 4 1584 1587 1591 1594 1594 1595 1596 1595
## 5 1405 1408 1411 1415 1416 1418 1420 1422
## 6 1552 1556 1560 1563 1566 1568 1571 1572
## 7 1351 1353 1355 1356 1357 1357 1357 1357
## 8 2055 2059 2062 2065 2066 2066 2066 2063
## 9 1891 1895 1899 1904 1907 1910 1913 1916
## 10 1447 1452 1456 1461 1465 1469 1472 1476
## X2020.03 X2020.04 X2020.05 X2020.06 X2020.07 X2020.08 X2020.09 X2020.10
## 1 1685 1686 1686 1687 1688 1691 1693 1696
## 2 2721 2707 2688 2669 2649 2632 2614 2596
## 3 2325 2323 2322 2320 2318 2318 2318 2318
## 4 1593 1591 1588 1585 1581 1579 1576 1574
## 5 1423 1424 1427 1429 1431 1436 1440 1445
## 6 1574 1576 1578 1580 1582 1585 1588 1591
## 7 1356 1356 1356 1356 1356 1357 1359 1360
## 8 2060 2057 2051 2045 2040 2035 2030 2025
## 9 1918 1921 1924 1928 1932 1940 1949 1957
## 10 1481 1485 1491 1497 1504 1514 1524 1534
## X2020.11 X2020.12 X2021.01 X2021.02 X2021.03 X2021.04 X2021.05 X2021.06
## 1 1706 1717 1727 1744 1761 1777 1795 1813
## 2 2595 2594 2592 2608 2624 2640 2658 2676
## 3 2328 2338 2347 2366 2384 2402 2421 2440
## 4 1577 1580 1583 1591 1599 1607 1615 1624
## 5 1457 1468 1480 1498 1516 1534 1552 1571
## 6 1598 1605 1612 1623 1634 1645 1656 1667
## 7 1367 1374 1381 1393 1404 1416 1428 1440
## 8 2029 2032 2036 2047 2059 2071 2084 2096
## 9 1980 2002 2024 2058 2093 2127 2162 2198
## 10 1553 1572 1591 1617 1643 1668 1695 1721
## X2021.07 X2021.08 X2021.09 X2021.10
## 1 1830 1849 1867 1886
## 2 2694 2715 2736 2757
## 3 2459 2480 2500 2521
## 4 1633 1642 1652 1661
## 5 1589 1608 1628 1647
## 6 1678 1690 1701 1713
## 7 1452 1465 1477 1490
## 8 2109 2123 2137 2152
## 9 2233 2271 2308 2346
## 10 1747 1775 1802 1830