SQL Database Tables
Below are the different data sets that you will find in the Loans_R database after deployment.
| Table | Description |
|---|---|
| Loan | Raw data about each loan |
| Borrower | Raw data about each borrower |
| Merged | The merged result of Loan and Borrower |
| Stats | Modes or Means of variables of Merged for missing values replacement |
| Merged_Cleaned | Merged table with missing values replaced |
| Bins | Serialized list of cutoffs used to bin numeric variables |
| Merged_Features | Analytical data set: cleaned merged table with new features |
| Column_Info | Serialized list of variable information including factors and their levels |
| Hash_Id | Loan Ids and Mapping through hash function for splitting |
| Model | Serialized version of the trained logistic regression |
| Logistic_Coeff | Coefficients of the logistic regression formula in decreasing order of magnitude |
| Predictions_Logistic | Predictions made on the testing set |
| Metrics | Performance metrics of the evaluated model |
| Operational_Metrics | Percentiles of the scores, corresponding score thresholds and bad rates among scores higher than thresholds |
| Scores_Average | Average of the predicted scores used in scores transformation |
| Scores | Scores computed on the testing set, transformed with Operational_Metrics |