FDMA - Final exam
Shyh-Weir Tzang
2023/1/11
- Test Summary
- Data
- Questions
- 2 Data wrangling
- 2.1 Delete ‘No’ column. Rename column names of ‘Investment Sector’, ‘Property Sector’ and ‘Property Subsector’ to ‘Investment_Sector’, ‘Property_Sector’ and ‘Property_Subsector’. Also rename the column ‘MKV(millions)’ to ‘MKV_mio’. (Hint: use
rename()) - 2.2 Convert the following columns into categorical data: ‘Investment_Sector’, ‘Property_Sector’ and ‘Property_Subsector’. (Hint: use
mutate())
- 2.1 Delete ‘No’ column. Rename column names of ‘Investment Sector’, ‘Property Sector’ and ‘Property Subsector’ to ‘Investment_Sector’, ‘Property_Sector’ and ‘Property_Subsector’. Also rename the column ‘MKV(millions)’ to ‘MKV_mio’. (Hint: use
- 3 Group analysis and plotting
- 4 Download price from yahoo finance
Test Summary
This is a short summary of what you have learned after midterm.
Data
Data are the constituent companies of the FTSE Nareit All REITs Index. See https://www.reit.com/data-research/reit-indexes/monthly-index-constituents.
To read the data, you have to download the data file in excel: Constituent Companies of the FTSE Nareit All REITs Index_modified_2022.xlsx. Make sure that the paths point to the appropriate data sets.
# load libraries
if (!require("pacman")) install.packages("pacman")
pacman::p_load(tidyverse, lubridate, tidyquant, readxl, writexl)
# Work horse packages
library(tidyverse)
library(lubridate)
library(purrr)
# theme_tq()
library(tidyquant)
# Excel Files
library(readxl)
library(writexl)# Read the data from appropriate paths which you have to modify according to your file location.
reits_ticker <- read_excel("Constituent Companies of the FTSE Nareit All REITs Index_modified_2022.xlsx")
glimpse(reits_ticker)## Rows: 206
## Columns: 7
## $ No <dbl> 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15…
## $ Company <chr> "Alexandria Real Estate Equities, Inc.", "Boston …
## $ Symbols <chr> "ARE", "BXP", "KRC", "VNO", "CUZ", "HIW", "OFC", …
## $ `Investment Sector` <chr> "Equity", "Equity", "Equity", "Equity", "Equity",…
## $ `Property Sector` <chr> "Office", "Office", "Office", "Office", "Office",…
## $ `Property Subsector` <chr> "Office", "Office", "Office", "Office", "Office",…
## $ `MKV(millions)` <dbl> 23776.0, 10590.6, 4513.4, 3990.2, 3829.8, 2942.2,…Questions
1. Unique categories
1.1 What are the unique categories of property sectors?
## # A tibble: 13 × 1
## `Property Sector`
## <chr>
## 1 Office
## 2 Industrial
## 3 Retail
## 4 Residential
## 5 Diversified
## 6 Lodging/Resorts
## 7 Self Storage
## 8 Health Care
## 9 Timber
## 10 Infrastructure
## 11 Data Centers
## 12 Specialty
## 13 Mortgage1.2 What are the unique categories of property subsectors? (Hint: use distinct())
## # A tibble: 18 × 1
## `Property Subsector`
## <chr>
## 1 Office
## 2 Industrial
## 3 Shopping Centers
## 4 Regional Malls
## 5 Free Standing
## 6 Apartments
## 7 Manufactured Homes
## 8 Single Family Homes
## 9 Diversified
## 10 Lodging/Resorts
## 11 Self Storage
## 12 Health Care
## 13 Timber
## 14 Infrastructure
## 15 Data Centers
## 16 Specialty
## 17 Home Financing
## 18 Commercial Financing1.3 Compute the number of firms in each property subsector and average MKV. (Hint: use group_by(), summarize())
## `summarise()` has grouped output by 'Property Sector'. You can override using
## the `.groups` argument.## # A tibble: 18 × 4
## `Property Sector` `Property Subsector` no_firms avg_MKV
## <chr> <chr> <int> <dbl>
## 1 Data Centers Data Centers 2 44723.
## 2 Diversified Diversified 15 1949.
## 3 Health Care Health Care 15 6474.
## 4 Industrial Industrial 12 12655.
## 5 Infrastructure Infrastructure 6 31458.
## 6 Lodging/Resorts Lodging/Resorts 16 2076.
## 7 Mortgage Commercial Financing 19 1245.
## 8 Mortgage Home Financing 25 1288.
## 9 Office Office 22 3152.
## 10 Residential Apartments 16 7301.
## 11 Residential Manufactured Homes 3 10183.
## 12 Residential Single Family Homes 2 14362.
## 13 Retail Free Standing 12 6515.
## 14 Retail Regional Malls 3 13908.
## 15 Retail Shopping Centers 20 3160.
## 16 Self Storage Self Storage 6 14941.
## 17 Specialty Specialty 9 8427.
## 18 Timber Timber 3 10395.2 Data wrangling
2.1 Delete ‘No’ column. Rename column names of ‘Investment Sector’, ‘Property Sector’ and ‘Property Subsector’ to ‘Investment_Sector’, ‘Property_Sector’ and ‘Property_Subsector’. Also rename the column ‘MKV(millions)’ to ‘MKV_mio’. (Hint: use rename())
2.2 Convert the following columns into categorical data: ‘Investment_Sector’, ‘Property_Sector’ and ‘Property_Subsector’. (Hint: use mutate())
## # A tibble: 6 × 5
## Symbols Investment_Sector Property_Sector Property_Subsector MKV_mio
## <chr> <fct> <fct> <fct> <dbl>
## 1 ARE Equity Office Office 23776
## 2 BXP Equity Office Office 10591.
## 3 KRC Equity Office Office 4513.
## 4 VNO Equity Office Office 3990.
## 5 CUZ Equity Office Office 3830.
## 6 HIW Equity Office Office 2942.3 Group analysis and plotting
3.1 Select firms with ‘Investment_Sector’ being equal to ‘Equity’.
3.2 Compute the sum of MKV by Property Sector.
## # A tibble: 6 × 3
## Property_Sector MKV MKV_text
## <fct> <dbl> <chr>
## 1 Infrastructure 188749. $188,749
## 2 Retail 183105. $183,105
## 3 Residential 176082. $176,082
## 4 Industrial 151856. $151,856
## 5 Health Care 97112. $97,112
## 6 Self Storage 89648. $89,6483.3 Plot the MKV by Property Sector. (Hint: use coord_flip(), theme_tq()…)
Note: You can select any colors you like. Use colors() to call up the color names.
4 Download price from yahoo finance
4.1 Download each Symbol’s daily adjusted closing price from 2010/01/01 to 2022/12/31.
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols
## pausing 1 second between requests for more than 5 symbols## [1] "ARE" "BXP" "KRC" "VNO" "CUZ" "HIW" "OFC" "DEI" "EQC" "SLG"
## [11] "HPP" "PGRE" "DEA" "PDM" "ESRT" "BDN" "OPI" "ONL" "CIO" "FSP"
## [21] "CMCT" "NYC" "PLD" "REXR" "COLD" "EGP" "FR" "STAG" "TRNO" "IIPR"
## [31] "LXP" "PLYM" "INDT" "ILPT" "KIM" "REG" "FRT" "BRX" "KRG" "PECO"
## [41] "SITC" "SKT" "ROIC" "UE" "IVT" "AKR" "ALEX" "BFS" "RPT" "UBA"
## [51] "WSR" "CTO" "UBP" "WHLR" "SPG" "MAC" "CBL" "O" "STOR" "NNN"
## [61] "ADC" "SRC" "EPRT" "FCPT" "GTY" "NTST" "RTL" "PSTL" "PINE" "AVB"
## [71] "EQR" "MAA" "ESS" "UDR" "CPT" "AIRC" "IRT" "ELME" "VRE" "NXRT"
## [81] "AIV" "CSR" "BRT" "CLPR" "BHM" "SUI" "ELS" "UMH" "INVH" "AMH"
## [91] "WPC" "BNL" "JBGS" "AAT" "GNL" "SVC" "ALX" "AHH" "GOOD" "STAR"
## [101] "OLP" "MDV" "MDRR" "SQFT" "GIPR" "HST" "RHP" "APLE" "PK" "SHO"
## [111] "PEB" "DRH" "RLJ" "XHR" "INN" "CLDT" "HT" "BHR" "AHT" "SOHO"
## [121] "IHT" "PSA" "EXR" "CUBE" "LSI" "NSA" "SELF" "WELL" "VTR" "PEAK"
## [131] "HR" "MPW" "OHI" "DOC" "SBRA" "NHI" "CTRE" "LTC" "CHCT" "UHT"
## [141] "GMRE" "DHC" "WY" "RYN" "PCH" "AMT" "CCI" "SBAC" "UNIT" "CORR"
## [151] "PW" "EQIX" "DLR" "VICI" "IRM" "GLPI" "LAMR" "EPR" "OUT" "SAFE"
## [161] "FPI" "LAND"## ARE.Adjusted BXP.Adjusted KRC.Adjusted VNO.Adjusted CUZ.Adjusted
## 2010-01-04 43.12880 43.64643 20.14190 29.86840 14.78186
## 2010-01-05 42.67409 44.30991 20.21481 29.64230 15.52096
## 2010-01-06 42.45013 44.51808 20.17504 29.52287 15.83215
## 2010-01-07 42.84376 44.71322 20.75165 29.97930 16.16280
## 2010-01-08 42.70123 44.13430 20.71189 29.64658 15.85160
## 2010-01-11 42.92520 44.34244 21.14270 29.74042 16.04609
## HIW.Adjusted OFC.Adjusted DEI.Adjusted EQC.Adjusted SLG.Adjusted
## 2010-01-04 17.59737 20.52097 9.527958 13.40136 32.54274
## 2010-01-05 17.12442 20.82769 9.642672 13.54771 31.93750
## 2010-01-06 17.05375 20.95832 9.615681 13.79860 31.72468
## 2010-01-07 17.36905 20.86176 9.777630 13.81951 32.52943
## 2010-01-08 17.24946 20.76521 9.662913 13.56862 32.29664
## 2010-01-11 17.34731 20.87880 9.791122 13.65225 32.87526
## HPP.Adjusted PGRE.Adjusted DEA.Adjusted PDM.Adjusted ESRT.Adjusted
## 2010-01-04 NA NA NA NA NA
## 2010-01-05 NA NA NA NA NA
## 2010-01-06 NA NA NA NA NA
## 2010-01-07 NA NA NA NA NA
## 2010-01-08 NA NA NA NA NA
## 2010-01-11 NA NA NA NA NA
## BDN.Adjusted OPI.Adjusted ONL.Adjusted CIO.Adjusted FSP.Adjusted
## 2010-01-04 5.666382 31.71932 NA NA 6.465184
## 2010-01-05 5.721837 31.33266 NA NA 6.329947
## 2010-01-06 5.792413 31.52599 NA NA 6.242697
## 2010-01-07 5.847866 31.59504 NA NA 6.203438
## 2010-01-08 5.822660 31.73313 NA NA 6.155447
## 2010-01-11 5.822660 31.70551 NA NA 6.103099
## CMCT.Adjusted NYC.Adjusted PLD.Adjusted REXR.Adjusted COLD.Adjusted
## 2010-01-04 17.09539 NA 16.94888 NA NA
## 2010-01-05 16.89267 NA 17.19607 NA NA
## 2010-01-06 16.78006 NA 17.04240 NA NA
## 2010-01-07 16.75753 NA 17.18270 NA NA
## 2010-01-08 16.89267 NA 17.13594 NA NA
## 2010-01-11 17.88371 NA 17.15598 NA NA
## EGP.Adjusted FR.Adjusted STAG.Adjusted TRNO.Adjusted IIPR.Adjusted
## 2010-01-04 24.22865 4.254948 NA NA NA
## 2010-01-05 23.70250 4.340669 NA NA NA
## 2010-01-06 23.66446 4.231568 NA NA NA
## 2010-01-07 23.74052 4.325084 NA NA NA
## 2010-01-08 23.68981 4.231568 NA NA NA
## 2010-01-11 23.74052 4.348462 NA NA NA
## LXP.Adjusted PLYM.Adjusted INDT.Adjusted ILPT.Adjusted KIM.Adjusted
## 2010-01-04 2.945247 NA 24.95744 NA 7.612265
## 2010-01-05 2.954568 NA 24.48541 NA 7.573257
## 2010-01-06 2.912627 NA 23.98763 NA 7.606692
## 2010-01-07 2.940588 NA 24.07346 NA 7.863036
## 2010-01-08 2.977870 NA 24.33951 NA 7.762729
## 2010-01-11 2.991850 NA 24.54549 NA 7.874182
## REG.Adjusted FRT.Adjusted BRX.Adjusted KRG.Adjusted PECO.Adjusted
## 2010-01-04 21.17593 43.90084 NA 8.264449 NA
## 2010-01-05 21.32819 43.84846 NA 8.063855 NA
## 2010-01-06 21.35865 43.73057 NA 8.264449 NA
## 2010-01-07 21.52308 43.71746 NA 8.645575 NA
## 2010-01-08 21.48653 43.44239 NA 8.665634 NA
## 2010-01-11 21.80933 43.98598 NA 8.625515 NA
## SITC.Adjusted SKT.Adjusted ROIC.Adjusted UE.Adjusted IVT.Adjusted
## 2010-01-04 8.401088 11.04945 6.406983 NA NA
## 2010-01-05 8.328426 11.23726 6.444743 NA NA
## 2010-01-06 8.174030 11.45352 6.451039 NA NA
## 2010-01-07 8.537326 11.32547 6.469917 NA NA
## 2010-01-08 8.455581 11.16612 6.476211 NA NA
## 2010-01-11 8.510075 11.21734 6.457334 NA NA
## AKR.Adjusted ALEX.Adjusted BFS.Adjusted RPT.Adjusted UBA.Adjusted
## 2010-01-04 10.57935 NA 19.85815 5.038890 7.861887
## 2010-01-05 10.51697 NA 19.52818 4.846450 7.745225
## 2010-01-06 10.47954 NA 19.34820 4.750231 7.700382
## 2010-01-07 10.61678 NA 19.89415 4.760361 7.705537
## 2010-01-08 10.41717 NA 20.69207 4.704654 7.607607
## 2010-01-11 10.49202 NA 20.81206 4.699588 7.695234
## WSR.Adjusted CTO.Adjusted UBP.Adjusted WHLR.Adjusted SPG.Adjusted
## 2010-01-04 NA 7.698836 7.444952 NA 43.83769
## 2010-01-05 NA 7.598238 7.479976 NA 43.53773
## 2010-01-06 NA 7.491224 7.398727 NA 43.04891
## 2010-01-07 NA 7.611083 7.271773 NA 43.60994
## 2010-01-08 NA 7.634627 7.124509 NA 42.56567
## 2010-01-11 NA 7.692417 7.205761 NA 42.60454
## MAC.Adjusted CBL.Adjusted O.Adjusted STOR.Adjusted NNN.Adjusted
## 2010-01-04 17.52952 NA 13.90159 NA 11.36129
## 2010-01-05 17.32324 NA 14.13595 NA 11.32939
## 2010-01-06 16.77481 NA 14.12529 NA 11.43572
## 2010-01-07 16.84022 NA 14.42356 NA 11.48357
## 2010-01-08 16.52324 NA 14.62063 NA 11.31876
## 2010-01-11 16.56852 NA 14.50878 NA 11.38255
## ADC.Adjusted SRC.Adjusted EPRT.Adjusted FCPT.Adjusted GTY.Adjusted
## 2010-01-04 12.18415 NA NA NA 12.00436
## 2010-01-05 12.10201 NA NA NA 11.79668
## 2010-01-06 11.94283 NA NA NA 11.77136
## 2010-01-07 11.99418 NA NA NA 11.82201
## 2010-01-08 11.87608 NA NA NA 11.80682
## 2010-01-11 11.88122 NA NA NA 11.79162
## NTST.Adjusted RTL.Adjusted PSTL.Adjusted PINE.Adjusted AVB.Adjusted
## 2010-01-04 NA NA NA NA 53.51212
## 2010-01-05 NA NA NA NA 53.11010
## 2010-01-06 NA NA NA NA 52.60926
## 2010-01-07 NA NA NA NA 52.71472
## 2010-01-08 NA NA NA NA 52.31929
## 2010-01-11 NA NA NA NA 53.03763
## EQR.Adjusted MAA.Adjusted ESS.Adjusted UDR.Adjusted CPT.Adjusted
## 2010-01-04 18.74070 29.83469 55.39895 10.28221 25.23881
## 2010-01-05 18.66775 29.80993 55.73420 10.26952 25.18406
## 2010-01-06 18.77436 29.90899 56.12312 10.19975 24.87991
## 2010-01-07 18.95391 30.05139 56.70649 10.27587 24.83123
## 2010-01-08 18.71264 29.85327 56.12312 10.07289 24.45409
## 2010-01-11 18.65653 30.00804 56.16333 10.14266 24.52709
## AIRC.Adjusted IRT.Adjusted ELME.Adjusted VRE.Adjusted NXRT.Adjusted
## 2010-01-04 NA NA 15.03764 21.16620 NA
## 2010-01-05 NA NA 14.92768 21.75066 NA
## 2010-01-06 NA NA 14.91668 21.99576 NA
## 2010-01-07 NA NA 15.03215 22.36026 NA
## 2010-01-08 NA NA 15.02664 22.28486 NA
## 2010-01-11 NA NA 15.05964 22.58022 NA
## AIV.Adjusted CSR.Adjusted BRT.Adjusted CLPR.Adjusted BHM.Adjusted
## 2010-01-04 1.145268 42.51284 3.557934 NA NA
## 2010-01-05 1.173972 40.85772 3.536372 NA NA
## 2010-01-06 1.194782 40.00652 3.514807 NA NA
## 2010-01-07 1.238555 40.43212 3.521996 NA NA
## 2010-01-08 1.209851 40.57400 3.529184 NA NA
## 2010-01-11 1.219180 40.52671 3.543560 NA NA
## SUI.Adjusted ELS.Adjusted UMH.Adjusted INVH.Adjusted AMH.Adjusted
## 2010-01-04 11.28528 9.186097 3.902714 NA NA
## 2010-01-05 11.22327 9.226366 3.856798 NA NA
## 2010-01-06 11.56149 9.193421 3.810884 NA NA
## 2010-01-07 11.56713 9.105565 3.806293 NA NA
## 2010-01-08 11.57276 9.068956 3.810884 NA NA
## 2010-01-11 11.57276 9.065303 3.865982 NA NA
## WPC.Adjusted BNL.Adjusted JBGS.Adjusted AAT.Adjusted GNL.Adjusted
## 2010-01-04 12.99000 NA NA NA NA
## 2010-01-05 12.92436 NA NA NA NA
## 2010-01-06 12.76022 NA NA NA NA
## 2010-01-07 12.96187 NA NA NA NA
## 2010-01-08 12.98532 NA NA NA NA
## 2010-01-11 13.06504 NA NA NA NA
## SVC.Adjusted ALX.Adjusted AHH.Adjusted GOOD.Adjusted STAR.Adjusted
## 2010-01-04 10.68936 123.8200 NA 4.637640 1.876681
## 2010-01-05 10.86646 123.0840 NA 4.489703 1.985870
## 2010-01-06 10.93911 123.7543 NA 4.548189 2.122356
## 2010-01-07 11.05717 125.9707 NA 4.555070 2.320261
## 2010-01-08 11.19794 125.6993 NA 4.637640 2.313436
## 2010-01-11 11.37050 119.9547 NA 4.579153 2.361206
## OLP.Adjusted MDV.Adjusted MDRR.Adjusted SQFT.Adjusted GIPR.Adjusted
## 2010-01-04 3.461106 NA NA NA NA
## 2010-01-05 3.590165 NA NA NA NA
## 2010-01-06 3.828727 NA NA NA NA
## 2010-01-07 3.926498 NA NA NA NA
## 2010-01-08 3.887388 NA NA NA NA
## 2010-01-11 4.079021 NA NA NA NA
## HST.Adjusted RHP.Adjusted APLE.Adjusted PK.Adjusted SHO.Adjusted
## 2010-01-04 8.109559 11.65321 NA NA 6.320421
## 2010-01-05 8.294803 11.57444 NA NA 6.376478
## 2010-01-06 8.342827 11.91205 NA NA 6.355456
## 2010-01-07 8.651566 11.90080 NA NA 6.551656
## 2010-01-08 8.569238 12.16526 NA NA 6.600706
## 2010-01-11 8.493766 12.41847 NA NA 6.838948
## PEB.Adjusted DRH.Adjusted RLJ.Adjusted XHR.Adjusted INN.Adjusted
## 2010-01-04 15.18675 5.927488 NA NA NA
## 2010-01-05 15.46417 6.201276 NA NA NA
## 2010-01-06 15.47128 6.187587 NA NA NA
## 2010-01-07 15.15830 6.303946 NA NA NA
## 2010-01-08 15.02315 6.139672 NA NA NA
## 2010-01-11 14.95913 6.365551 NA NA NA
## CLDT.Adjusted HT.Adjusted BHR.Adjusted AHT.Adjusted SOHO.Adjusted
## 2010-01-04 NA 7.147985 NA 171.1182 1.246318
## 2010-01-05 NA 7.456850 NA 175.3521 1.252428
## 2010-01-06 NA 7.743653 NA 184.1726 1.246318
## 2010-01-07 NA 7.831897 NA 190.5234 1.289084
## 2010-01-08 NA 7.765715 NA 198.2855 1.374616
## 2010-01-11 NA 8.162823 NA 206.4004 1.545679
## IHT.Adjusted PSA.Adjusted EXR.Adjusted CUBE.Adjusted LSI.Adjusted
## 2010-01-04 0.989080 50.30447 7.784088 4.678254 14.30294
## 2010-01-05 0.989080 50.71881 7.731715 4.772665 14.12295
## 2010-01-06 1.061673 50.41118 7.757906 4.720575 14.09495
## 2010-01-07 1.143340 50.34213 7.698981 4.733598 14.13896
## 2010-01-08 1.170563 49.42556 7.528768 4.661974 14.00296
## 2010-01-11 1.225008 49.76458 7.587687 4.753133 14.53492
## NSA.Adjusted SELF.Adjusted WELL.Adjusted VTR.Adjusted PEAK.Adjusted
## 2010-01-04 NA 1.579438 23.64323 27.23341 14.20855
## 2010-01-05 NA 1.579438 23.97607 27.36535 14.17075
## 2010-01-06 NA 1.579438 23.85796 27.05752 14.08570
## 2010-01-07 NA 1.549230 23.90628 27.35907 14.27943
## 2010-01-08 NA 1.536284 23.65933 27.05752 14.37393
## 2010-01-11 NA 1.575123 23.71301 27.60406 14.53459
## HR.Adjusted MPW.Adjusted OHI.Adjusted DOC.Adjusted SBRA.Adjusted
## 2010-01-04 NA 4.199804 7.588738 NA 9.662726
## 2010-01-05 NA 4.320750 7.716378 NA 9.798089
## 2010-01-06 NA 4.333264 7.700904 NA 9.558608
## 2010-01-07 NA 4.304071 7.708642 NA 9.798089
## 2010-01-08 NA 4.220656 7.673830 NA 10.100052
## 2010-01-11 NA 4.287386 7.693171 NA 9.860566
## NHI.Adjusted CTRE.Adjusted LTC.Adjusted CHCT.Adjusted UHT.Adjusted
## 2010-01-04 17.45256 NA 13.60855 NA 16.86645
## 2010-01-05 17.30286 NA 13.39607 NA 16.86119
## 2010-01-06 16.81511 NA 13.59372 NA 16.79280
## 2010-01-07 16.72819 NA 13.82103 NA 16.95588
## 2010-01-08 16.78614 NA 13.67279 NA 16.98746
## 2010-01-11 16.81511 NA 13.32690 NA 16.92959
## GMRE.Adjusted DHC.Adjusted WY.Adjusted RYN.Adjusted PCH.Adjusted
## 2010-01-04 NA 9.680449 10.53014 12.89141 16.03655
## 2010-01-05 NA 9.738522 10.75369 13.23563 16.10142
## 2010-01-06 NA 9.850201 10.63478 13.25086 16.30599
## 2010-01-07 NA 9.814462 10.58722 13.52197 16.35090
## 2010-01-08 NA 9.707249 10.48972 13.68951 16.30599
## 2010-01-11 NA 9.783192 10.55868 13.82049 16.19123
## AMT.Adjusted CCI.Adjusted SBAC.Adjusted UNIT.Adjusted CORR.Adjusted
## 2010-01-04 35.16530 28.89672 34.27257 NA 13.35731
## 2010-01-05 35.74789 29.17394 35.09113 NA 13.77722
## 2010-01-06 35.93398 28.75811 35.02292 NA 14.03717
## 2010-01-07 35.83689 28.28391 35.51991 NA 14.31711
## 2010-01-08 35.90972 28.42253 35.55889 NA 14.89700
## 2010-01-11 35.58606 28.42982 35.80251 NA 14.99698
## PW.Adjusted EQIX.Adjusted DLR.Adjusted VICI.Adjusted IRM.Adjusted
## 2010-01-04 9.308210 86.67095 29.50228 NA 9.347872
## 2010-01-05 9.370088 85.86408 29.69641 NA 9.376461
## 2010-01-06 9.325888 86.64722 29.29638 NA 9.678664
## 2010-01-07 9.370088 84.87522 29.55523 NA 9.833849
## 2010-01-08 9.591081 84.46384 29.88467 NA 9.862433
## 2010-01-11 9.440805 85.15999 29.73759 NA 9.935944
## GLPI.Adjusted LAMR.Adjusted EPR.Adjusted OUT.Adjusted SAFE.Adjusted
## 2010-01-04 NA 21.30770 16.41336 NA NA
## 2010-01-05 NA 21.82836 16.39939 NA NA
## 2010-01-06 NA 22.26994 16.26894 NA NA
## 2010-01-07 NA 21.85472 16.27826 NA NA
## 2010-01-08 NA 21.83495 16.23633 NA NA
## 2010-01-11 NA 21.78881 16.64165 NA NA
## FPI.Adjusted LAND.Adjusted
## 2010-01-04 NA NA
## 2010-01-05 NA NA
## 2010-01-06 NA NA
## 2010-01-07 NA NA
## 2010-01-08 NA NA
## 2010-01-11 NA NA4.2 Replace “.Adjusted” with "". Show the first six rows of data using head(). (Hint: use str_replace())
## ARE BXP KRC VNO CUZ HIW OFC
## 2010-01-04 43.12880 43.64643 20.14190 29.86840 14.78186 17.59737 20.52097
## 2010-01-05 42.67409 44.30991 20.21481 29.64230 15.52096 17.12442 20.82769
## 2010-01-06 42.45013 44.51808 20.17504 29.52287 15.83215 17.05375 20.95832
## 2010-01-07 42.84376 44.71322 20.75165 29.97930 16.16280 17.36905 20.86176
## 2010-01-08 42.70123 44.13430 20.71189 29.64658 15.85160 17.24946 20.76521
## 2010-01-11 42.92520 44.34244 21.14270 29.74042 16.04609 17.34731 20.87880
## DEI EQC SLG HPP PGRE DEA PDM ESRT BDN OPI
## 2010-01-04 9.527958 13.40136 32.54274 NA NA NA NA NA 5.666382 31.71932
## 2010-01-05 9.642672 13.54771 31.93750 NA NA NA NA NA 5.721837 31.33266
## 2010-01-06 9.615681 13.79860 31.72468 NA NA NA NA NA 5.792413 31.52599
## 2010-01-07 9.777630 13.81951 32.52943 NA NA NA NA NA 5.847866 31.59504
## 2010-01-08 9.662913 13.56862 32.29664 NA NA NA NA NA 5.822660 31.73313
## 2010-01-11 9.791122 13.65225 32.87526 NA NA NA NA NA 5.822660 31.70551
## ONL CIO FSP CMCT NYC PLD REXR COLD EGP FR
## 2010-01-04 NA NA 6.465184 17.09539 NA 16.94888 NA NA 24.22865 4.254948
## 2010-01-05 NA NA 6.329947 16.89267 NA 17.19607 NA NA 23.70250 4.340669
## 2010-01-06 NA NA 6.242697 16.78006 NA 17.04240 NA NA 23.66446 4.231568
## 2010-01-07 NA NA 6.203438 16.75753 NA 17.18270 NA NA 23.74052 4.325084
## 2010-01-08 NA NA 6.155447 16.89267 NA 17.13594 NA NA 23.68981 4.231568
## 2010-01-11 NA NA 6.103099 17.88371 NA 17.15598 NA NA 23.74052 4.348462
## STAG TRNO IIPR LXP PLYM INDT ILPT KIM REG
## 2010-01-04 NA NA NA 2.945247 NA 24.95744 NA 7.612265 21.17593
## 2010-01-05 NA NA NA 2.954568 NA 24.48541 NA 7.573257 21.32819
## 2010-01-06 NA NA NA 2.912627 NA 23.98763 NA 7.606692 21.35865
## 2010-01-07 NA NA NA 2.940588 NA 24.07346 NA 7.863036 21.52308
## 2010-01-08 NA NA NA 2.977870 NA 24.33951 NA 7.762729 21.48653
## 2010-01-11 NA NA NA 2.991850 NA 24.54549 NA 7.874182 21.80933
## FRT BRX KRG PECO SITC SKT ROIC UE IVT
## 2010-01-04 43.90084 NA 8.264449 NA 8.401088 11.04945 6.406983 NA NA
## 2010-01-05 43.84846 NA 8.063855 NA 8.328426 11.23726 6.444743 NA NA
## 2010-01-06 43.73057 NA 8.264449 NA 8.174030 11.45352 6.451039 NA NA
## 2010-01-07 43.71746 NA 8.645575 NA 8.537326 11.32547 6.469917 NA NA
## 2010-01-08 43.44239 NA 8.665634 NA 8.455581 11.16612 6.476211 NA NA
## 2010-01-11 43.98598 NA 8.625515 NA 8.510075 11.21734 6.457334 NA NA
## AKR ALEX BFS RPT UBA WSR CTO UBP WHLR
## 2010-01-04 10.57935 NA 19.85815 5.038890 7.861887 NA 7.698836 7.444952 NA
## 2010-01-05 10.51697 NA 19.52818 4.846450 7.745225 NA 7.598238 7.479976 NA
## 2010-01-06 10.47954 NA 19.34820 4.750231 7.700382 NA 7.491224 7.398727 NA
## 2010-01-07 10.61678 NA 19.89415 4.760361 7.705537 NA 7.611083 7.271773 NA
## 2010-01-08 10.41717 NA 20.69207 4.704654 7.607607 NA 7.634627 7.124509 NA
## 2010-01-11 10.49202 NA 20.81206 4.699588 7.695234 NA 7.692417 7.205761 NA
## SPG MAC CBL O STOR NNN ADC SRC EPRT FCPT
## 2010-01-04 43.83769 17.52952 NA 13.90159 NA 11.36129 12.18415 NA NA NA
## 2010-01-05 43.53773 17.32324 NA 14.13595 NA 11.32939 12.10201 NA NA NA
## 2010-01-06 43.04891 16.77481 NA 14.12529 NA 11.43572 11.94283 NA NA NA
## 2010-01-07 43.60994 16.84022 NA 14.42356 NA 11.48357 11.99418 NA NA NA
## 2010-01-08 42.56567 16.52324 NA 14.62063 NA 11.31876 11.87608 NA NA NA
## 2010-01-11 42.60454 16.56852 NA 14.50878 NA 11.38255 11.88122 NA NA NA
## GTY NTST RTL PSTL PINE AVB EQR MAA ESS
## 2010-01-04 12.00436 NA NA NA NA 53.51212 18.74070 29.83469 55.39895
## 2010-01-05 11.79668 NA NA NA NA 53.11010 18.66775 29.80993 55.73420
## 2010-01-06 11.77136 NA NA NA NA 52.60926 18.77436 29.90899 56.12312
## 2010-01-07 11.82201 NA NA NA NA 52.71472 18.95391 30.05139 56.70649
## 2010-01-08 11.80682 NA NA NA NA 52.31929 18.71264 29.85327 56.12312
## 2010-01-11 11.79162 NA NA NA NA 53.03763 18.65653 30.00804 56.16333
## UDR CPT AIRC IRT ELME VRE NXRT AIV CSR
## 2010-01-04 10.28221 25.23881 NA NA 15.03764 21.16620 NA 1.145268 42.51284
## 2010-01-05 10.26952 25.18406 NA NA 14.92768 21.75066 NA 1.173972 40.85772
## 2010-01-06 10.19975 24.87991 NA NA 14.91668 21.99576 NA 1.194782 40.00652
## 2010-01-07 10.27587 24.83123 NA NA 15.03215 22.36026 NA 1.238555 40.43212
## 2010-01-08 10.07289 24.45409 NA NA 15.02664 22.28486 NA 1.209851 40.57400
## 2010-01-11 10.14266 24.52709 NA NA 15.05964 22.58022 NA 1.219180 40.52671
## BRT CLPR BHM SUI ELS UMH INVH AMH WPC BNL
## 2010-01-04 3.557934 NA NA 11.28528 9.186097 3.902714 NA NA 12.99000 NA
## 2010-01-05 3.536372 NA NA 11.22327 9.226366 3.856798 NA NA 12.92436 NA
## 2010-01-06 3.514807 NA NA 11.56149 9.193421 3.810884 NA NA 12.76022 NA
## 2010-01-07 3.521996 NA NA 11.56713 9.105565 3.806293 NA NA 12.96187 NA
## 2010-01-08 3.529184 NA NA 11.57276 9.068956 3.810884 NA NA 12.98532 NA
## 2010-01-11 3.543560 NA NA 11.57276 9.065303 3.865982 NA NA 13.06504 NA
## JBGS AAT GNL SVC ALX AHH GOOD STAR OLP MDV
## 2010-01-04 NA NA NA 10.68936 123.8200 NA 4.637640 1.876681 3.461106 NA
## 2010-01-05 NA NA NA 10.86646 123.0840 NA 4.489703 1.985870 3.590165 NA
## 2010-01-06 NA NA NA 10.93911 123.7543 NA 4.548189 2.122356 3.828727 NA
## 2010-01-07 NA NA NA 11.05717 125.9707 NA 4.555070 2.320261 3.926498 NA
## 2010-01-08 NA NA NA 11.19794 125.6993 NA 4.637640 2.313436 3.887388 NA
## 2010-01-11 NA NA NA 11.37050 119.9547 NA 4.579153 2.361206 4.079021 NA
## MDRR SQFT GIPR HST RHP APLE PK SHO PEB DRH
## 2010-01-04 NA NA NA 8.109559 11.65321 NA NA 6.320421 15.18675 5.927488
## 2010-01-05 NA NA NA 8.294803 11.57444 NA NA 6.376478 15.46417 6.201276
## 2010-01-06 NA NA NA 8.342827 11.91205 NA NA 6.355456 15.47128 6.187587
## 2010-01-07 NA NA NA 8.651566 11.90080 NA NA 6.551656 15.15830 6.303946
## 2010-01-08 NA NA NA 8.569238 12.16526 NA NA 6.600706 15.02315 6.139672
## 2010-01-11 NA NA NA 8.493766 12.41847 NA NA 6.838948 14.95913 6.365551
## RLJ XHR INN CLDT HT BHR AHT SOHO IHT PSA
## 2010-01-04 NA NA NA NA 7.147985 NA 171.1182 1.246318 0.989080 50.30447
## 2010-01-05 NA NA NA NA 7.456850 NA 175.3521 1.252428 0.989080 50.71881
## 2010-01-06 NA NA NA NA 7.743653 NA 184.1726 1.246318 1.061673 50.41118
## 2010-01-07 NA NA NA NA 7.831897 NA 190.5234 1.289084 1.143340 50.34213
## 2010-01-08 NA NA NA NA 7.765715 NA 198.2855 1.374616 1.170563 49.42556
## 2010-01-11 NA NA NA NA 8.162823 NA 206.4004 1.545679 1.225008 49.76458
## EXR CUBE LSI NSA SELF WELL VTR PEAK
## 2010-01-04 7.784088 4.678254 14.30294 NA 1.579438 23.64323 27.23341 14.20855
## 2010-01-05 7.731715 4.772665 14.12295 NA 1.579438 23.97607 27.36535 14.17075
## 2010-01-06 7.757906 4.720575 14.09495 NA 1.579438 23.85796 27.05752 14.08570
## 2010-01-07 7.698981 4.733598 14.13896 NA 1.549230 23.90628 27.35907 14.27943
## 2010-01-08 7.528768 4.661974 14.00296 NA 1.536284 23.65933 27.05752 14.37393
## 2010-01-11 7.587687 4.753133 14.53492 NA 1.575123 23.71301 27.60406 14.53459
## HR MPW OHI DOC SBRA NHI CTRE LTC CHCT
## 2010-01-04 NA 4.199804 7.588738 NA 9.662726 17.45256 NA 13.60855 NA
## 2010-01-05 NA 4.320750 7.716378 NA 9.798089 17.30286 NA 13.39607 NA
## 2010-01-06 NA 4.333264 7.700904 NA 9.558608 16.81511 NA 13.59372 NA
## 2010-01-07 NA 4.304071 7.708642 NA 9.798089 16.72819 NA 13.82103 NA
## 2010-01-08 NA 4.220656 7.673830 NA 10.100052 16.78614 NA 13.67279 NA
## 2010-01-11 NA 4.287386 7.693171 NA 9.860566 16.81511 NA 13.32690 NA
## UHT GMRE DHC WY RYN PCH AMT CCI
## 2010-01-04 16.86645 NA 9.680449 10.53014 12.89141 16.03655 35.16530 28.89672
## 2010-01-05 16.86119 NA 9.738522 10.75369 13.23563 16.10142 35.74789 29.17394
## 2010-01-06 16.79280 NA 9.850201 10.63478 13.25086 16.30599 35.93398 28.75811
## 2010-01-07 16.95588 NA 9.814462 10.58722 13.52197 16.35090 35.83689 28.28391
## 2010-01-08 16.98746 NA 9.707249 10.48972 13.68951 16.30599 35.90972 28.42253
## 2010-01-11 16.92959 NA 9.783192 10.55868 13.82049 16.19123 35.58606 28.42982
## SBAC UNIT CORR PW EQIX DLR VICI IRM GLPI
## 2010-01-04 34.27257 NA 13.35731 9.308210 86.67095 29.50228 NA 9.347872 NA
## 2010-01-05 35.09113 NA 13.77722 9.370088 85.86408 29.69641 NA 9.376461 NA
## 2010-01-06 35.02292 NA 14.03717 9.325888 86.64722 29.29638 NA 9.678664 NA
## 2010-01-07 35.51991 NA 14.31711 9.370088 84.87522 29.55523 NA 9.833849 NA
## 2010-01-08 35.55889 NA 14.89700 9.591081 84.46384 29.88467 NA 9.862433 NA
## 2010-01-11 35.80251 NA 14.99698 9.440805 85.15999 29.73759 NA 9.935944 NA
## LAMR EPR OUT SAFE FPI LAND
## 2010-01-04 21.30770 16.41336 NA NA NA NA
## 2010-01-05 21.82836 16.39939 NA NA NA NA
## 2010-01-06 22.26994 16.26894 NA NA NA NA
## 2010-01-07 21.85472 16.27826 NA NA NA NA
## 2010-01-08 21.83495 16.23633 NA NA NA NA
## 2010-01-11 21.78881 16.64165 NA NA NA NA