Publications by DR VY
Document
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) zdata[,Selling_premium:=zdata$sales_price/zdata$adj_purch_price] zdata[,Renter_fraction:=zdata$renters/zdata$totalpopulation] zdata[,Purchase_price...
251 sym R (40062 sym/31 pcs) 2 img
Publish Document
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) zdata[,Selling_premium:=zdata$sales_price/zdata$adj_purch_price] zdata[,Renter_fraction:=zdata$renters/zdata$totalpopulation] zdata[,Purchase_price...
251 sym R (40080 sym/31 pcs) 2 img
Publish Document
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) zdata[,Selling_premium:=zdata$sales_price/zdata$adj_purch_price] zdata[,Renter_fraction:=zdata$renters/zdata$totalpopulation] zdata[,Purchase_price...
251 sym R (39931 sym/31 pcs) 2 img
Document
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) zdata[,Selling_premium:=zdata$sales_price/zdata$adj_purch_price] zdata[,Renter_fraction:=zdata$renters/zdata$totalpopulation] zdata[,Purchase_price...
252 sym R (66866 sym/32 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) 1 Documentation Data Fields with Values and Definitions Web page dbdir = "/data/hmda.db" con <- dbConnect(RSQLite::SQLite(),dbdir) lar <- data.table(dbGetQuery(con," ...
101 sym R (14203 sym/14 pcs) 1 img
Document
rm(list=ls()) library(data.table) library(RSQLite) library(DBI) Documentation Layout ZAsmtMetaData ZTransMetaData Data Dictionary Connecting to Database dbdir = "/data/ztrax.db" con <- dbConnect(RSQLite::SQLite(),dbdir) List tables dbListTables(con) ## [1] "zasmt_building" "zasmt_buildingareas" ## [3] "...
888 sym R (26108 sym/23 pcs)
Document
rm(list=ls()) library(RPostgres) library(data.table) library(getPass) library(lfe) library(stargazer) library(ggplot2) library(fst) library(stringr) library(stringi) library(lubridate) files = paste0("C:/Users/dratnadiwakara2/Documents/OneDrive - Louisiana State University/Raw Data/HMDA/Ultimate Panel Data/",c("2014.fst","2015.fst","201...
110 sym R (15969 sym/15 pcs) 5 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","reporterhomecity","re...
400 sym R (35656 sym/23 pcs) 1 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","reporterhomecity","re...
1486 sym R (123518 sym/77 pcs) 2 img
Document
rm(list=ls()) library(data.table) library(RSQLite) library(DBI) Documentation Data Fields with Values and Definitions Web page Connecting to Database dbdir = "/data/hmda.db" con <- dbConnect(RSQLite::SQLite(),dbdir) List tables Table lar contains all the mortgage applications. Table ts contains information on the lender Tables lar and ts...
966 sym R (12701 sym/17 pcs)