This repository is meant as a way for organizing FDIC Call Reports and Summary of Deposits data through R and SQL. The main goal is to calculate agricultural financial statistics from this data, although the data can be used for much more than just agricultural focused issues.
For most users, the raw data are of the most importance and they are referenced above. However, this project is open-source and meant to be allow users to replicate the results to cross-check the validity of the data. If any errors are found, please submit a pull request.
- Raw data can be found in the 0-data
- Download the data:
0-FDIC-calls-data.R,0-FDIC-chicago-data.R, and0-FDIC-SOD-data.R - Insert data into SQL:
0-FDIC-calls-sql.R,0-FDIC-chicago-sql.R, and0-FDIC-SOD-sql.R
- Download the data:
- Tidy data can be found in 1-tidy
- Some generic figures can be found in 2-eda
A few packages needs to be installed to maintain this repository that are on CRAN and can be installed with the install.packages() command:
install.packages(c("DBI", "lubridate", "ggmap", "haven", "httr", "RSQLite", "rvest", "tidyverse", "zipcode"))A quick reasoning for each package:
- DBI - database interface with R
- lubridate - helpful for time series
- ggmap - mapping of locations
- haven - read in SAS
- httr - web scraping of the FDIC and Chicago Fed
- RSQLite - able to create SQLite databases
- rvest - web scraping
- tidyverse - useful for data munging
- zipcode - coordinates of zip codes