The Lending Club
The Lending Club data is a publicly available dataset which collects a relatively large numbers of features (63 columns) for a sample of individual loans across the United States Although the dataset is not terribly large (686 rows) it does provide an opportunity to test our data wrangling and analytical abilities.
The main challenge for this type of project is that we all work with the same data without the possibility of version control issues. While we could have just placed the data set and even a whole SQL database in some share folder environment like GitHub, this would still be a non-real time access solution.
We decided instead to create a MySQL Server in AWS (cloud) and create a database with the main Lending Club database plus other associated tables which could help our SQL queries. This way the whole team would access data in real-time without worries of version control issues.
Below you will find a few SQL queries that through PHP, query directly the MySQL database. We have provided a few examples of queries which respond back with an HTML Table which could easily be accessed from R using the rvest package.
The final part of our project was to perform analysis of the data. You can see a few examples below. Finally we provide links tour .RMD file used for accessing, data wrangling and visualizations and analytics.
