Publications by DR VY

Document

30.05.2023

density_plot_options <- list( theme_minimal(), theme(axis.text.y = element_blank()) ) la_banks <- fread("la_banks.csv") la_banks <- paste(unique(la_banks$rssd),collapse = ",") con_call <- dbConnect(RSQLite::SQLite(), "C:/Users/dratnadiwakara2/Documents/OneDrive - Louisiana State University/Raw Data/Call Reports/call_reports.db") con_ubp...

473 sym Python (11881 sym/10 pcs) 6 img

Document

30.05.2023

# # 2000 data: NAICS Based Measure # # # NAICS is available in CBP data post 1997. # # # # cbp employment raw data # cbp <- fread(paste0("C:/Users/dratnadiwakara2/Documents/OneDrive - Louisiana State University/Raw Data/CBP/county/cbp",substr(st_yr,3,4),"co.txt")) # cbp[,naics:=as.numeric(naics)] # cbp <- cbp[!is.na(naics)] # # cbp[,i...

2953 sym 13 img

Document

17.05.2023

# # 2000 data: NAICS Based Measure # # # NAICS is available in CBP data post 1997. # # # # cbp employment raw data # cbp <- fread(paste0("C:/Users/dratnadiwakara2/Documents/OneDrive - Louisiana State University/Raw Data/CBP/county/cbp",substr(st_yr,3,4),"co.txt")) # cbp[,naics:=as.numeric(naics)] # cbp <- cbp[!is.na(naics)] # # cbp[,i...

511 sym R (19252 sym/22 pcs) 12 img

Document

10.05.2023

# created by bb_bank_data_prelim_03.RMD parent_sub <- fread("ticker_parentRSSD_subRSSD_2.csv") bhc_ids <- parent_sub[!duplicated(parent_sub[,c("ID_RSSD_PARENT","ticker")])] file_path <-"bb_bank_with_BAC.xlsx" sheets <- excel_sheets(file_path) sheets <- sheets[sheets !="tickers"] sheet_list <- list() sheet_list <- lapply(sheets, function(x) ...

47 sym Python (42744 sym/28 pcs) 9 img

Document

29.04.2023

1 Growth of US imports from China 2 Change in number of branches and deposits Import sensitivity for each county was calculated by following Autor,Dorn, and Hanson (2013). Data period 2000 to 2007. Counties are categorized in to three groups: 1 - lowest third sensitivity, 2 - middle third senstivitiy, 3 - top third sensitivity County-level...

1700 sym 7 img

Document

05.04.2023

adh <- fread("autordornhanson.csv") Table 2 of Autor, David H., David Dorn, and Gordon H. Hanson. “The China syndrome: Local labor market effects of import competition in the United States.” American economic review 103.6 (2013): 2121-2168. r <- list() r[[1]] <- felm( d_sh_empl_mfg~1|0|(d_tradeusch_pw~d_tradeotch_pw_lag)|statefip,data=adh[...

320 sym

Louisiana Banking Statistics

23.03.2023

1 Asset Growth and Composition 1.1 All Banks 1.2 Small Banks 1.3 Medium Banks 1.4 Large Banks 2 Deposit Growth and Composition 2.1 All Banks 2.2 Small Banks 2.3 Medium Banks 2.4 Large Banks 3 Loans 3.1 Allowance for loan and lease losses 3.2 Loan Composition - All Banks 3.3 Loan Composition - Small Banks 3.4 Loan Composition - ...

485 sym 13 img 1 tbl

Document

27.09.2022

1 Reading data 1.1 NFIP 1.2 Election data 1.3 Yale perception data 1.4 Disaster declaration data 1.5 ACS Data 1.6 Merge Data 2 Regression Setup 2.1 Variables 2.2 Non-SFHA Sample 2.3 SFHA Sample 3 Table 1 3.1 Panel A Descriptive Stats Non-SFHA ## ## ===============================================================================...

1791 sym

Document

20.10.2022

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...

391 sym

Document

24.10.2022

1 HMDA Sample cbsa_bnk <- read_fst("C:/Users/dratnadiwakara2/Documents/OneDrive - Louisiana State University/Projects/Bank Mergers/data/cbsa_bnk_2.fst",as.data.table = T) cbsa_bnk[,msinc13Q:=ifelse(msinc13<=0.0001,"Q0", ifelse(msinc13<0.0027235,"Q1", ifelse(msinc13<0.0112596,"Q2", ...

38 sym