Publications by DR VY
Document
rm(list=ls()) library(data.table) library(RSQLite) library(DBI) Documentation Home Page User Guide Connecting to Database dbdir = "/data/freddie/freddie.db" con <- dbConnect(RSQLite::SQLite(),dbdir) List tables dbListTables(con) ## [1] "acq" First 10 rows of acq Remove LIMIT 10 from the query to retrieve all the records from 1999. df <- dat...
224 sym R (2888 sym/7 pcs)
Document
rm(list=ls()) library(data.table) library(RSQLite) library(DBI) library(dplyr) library(stargazer) library(lfe) library(ggplot2) library(tidyverse) library(stringr) 1 Documentation Data Fields with Values and Definitions Web page tract_zip <- fread("/data/crosswalks/TRACT_ZIP.csv") tract_zip[,TRACT:=as.character(TRACT)] tract_zip[,TRACT:= str_...
572 sym R (31960 sym/25 pcs) 2 img
Document
rm(list=ls()) library(data.table) library(RSQLite) library(DBI) library(dplyr) library(stargazer) library(lfe) library(ggplot2) library(tidyverse) library(stringr) library(fst) zhvi <- readRDS("/data/atr/County_Zhvi_SingleFamilyResidence.rds") zhvi <- as.data.table(zhvi) zhvi[,year:=year(month)] zhvi <- zhvi[,.(zhvi=mean(zhvi,na.rm=T)),by=.(fips,...
22 sym R (8032 sym/9 pcs) 2 img
Document
1 List of Mergers # files = paste0("C:/Users/dratnadiwakara2/Documents/OneDrive - Louisiana State University/Raw Data/HMDA/Ultimate Panel Data/",as.character(2000:2016),".fst") # # panel = lapply(files, read_fst, as.data.table = TRUE,columns=c("respondentid","agencycode","reportername","asofdate","parentname","parentidentifier","reporterhomeci...
123 sym R (36770 sym/20 pcs)
Document
1 List of Mergers # # files = paste0("C:/Users/dratnadiwakara2/Documents/OneDrive - Louisiana State University/Raw Data/HMDA/Ultimate Panel Data/",as.character(2000:2016),".fst") # # panel = lapply(files, read_fst, as.data.table = TRUE,columns=c("respondentid","agencycode","reportername","asofdate","parentname","parentidentifier","reporterho...
931 sym R (84267 sym/53 pcs) 2 img
MS-FIN-21-00651 - Results
rm(list=ls()) library(stargazer) library(plyr) library(lfe) library(zoo) library(scales) library(rdrobust) library(data.table) library(ggplot2) library(dplyr) library(fst) library(fixest) Main Sample See “Merging ZTRAX Data” for sample construction code. The following sample is the subset of homes that were purchased in or before ...
971 sym R (29794 sym/20 pcs) 2 img
MS-FIN-21-00651 - Merging ZTRAX Data
rm(list=ls()) library(stargazer) library(plyr) library(lfe) library(zoo) library(data.table) library(ggplot2) library(dplyr) library(fst) library(RSQLite) library(DBI) dbdir = "/data/ztrax.db" con <- dbConnect(RSQLite::SQLite(),dbdir) Step 1:Extracting data from Zillow listings The following image shows a sample listing from Zillow. We have mark...
2826 sym R (4050 sym/12 pcs) 1 img
Document
All homes where buyernonindividual <> ’’ rm(list=ls()) library(data.table) library(RSQLite) library(DBI) library(dplyr) library(stargazer) library(lfe) library(ggplot2) library(tidyverse) library(zoo) library(stringr) library(fst) dbdir = "/data/ztrax.db" con <- dbConnect(RSQLite::SQLite(),dbdir) # identify_sfr_buyers_all_inst.R sfr <- read_f...
845 sym R (28472 sym/23 pcs) 3 img
Document
Write R code to generate the expected output shown below each question. The Big Mac index “The big mac index was invented by The Economist in 1986 as a lighthearted guide to whether currencies are at their “correct” level. It is based on the theory of purchasing-power parity (PPP), the notion that in the long run exchange rates should mov...
1843 sym R (3144 sym/17 pcs) 1 img
Document
The Big Mac index “The big mac index was invented by The Economist in 1986 as a lighthearted guide to whether currencies are at their “correct” level. It is based on the theory of purchasing-power parity (PPP), the notion that in the long run exchange rates should move towards the rate that would equalise the prices of an identical basket ...
548 sym R (4947 sym/12 pcs) 1 img