For companies that make money off of interest on loans held by their customer, it’s always about increasing the bottom line. Being able to assess the risk of loan applications can save a lender the cost of holding too many risky assets. It is the data scientist’s job to run analysis on your customer data and make business rules that will directly impact loan approval.
- Although they work with data day in and out, they are dependent on the data engineers to obtain up-to-date tables.
- With data growing at an exponential rate, they are dependent on the infrastructure team to provision compute resources.
- Once the model building process is done, they must trust software developers to correctly translate their model code to production ready code.
This is where the Databricks Unified Analytics Platform can help bridge those gaps between different parts of that workflow chain and reduce friction between the data scientists, data engineers, and software engineers.
In addition to reducing operational friction, Databricks is a central location to run the latest Machine Learning models. Users can leverage the native Spark MLLib package or download any open source Python or R ML package. With Databricks Runtime for Machine Learning, Databricks clusters are preconfigured with XGBoost, scikit-learn, and numpy as well as popular Deep Learning frameworks such as TensorFlow, Keras, Horovod, and their dependencies.
In this blog, we will explore how to:
- Import our sample data source to create a Databricks table
- Explore your data using Databricks Visualizations
- Execute ETL code against your data
- Execute ML Pipeline including model tuning XGBoost Logistic Regression
For our experiment, we will be using the public Lending Club Loan Data. It includes all funded loans from 2012 to 2017. Each loan includes applicant information provided by the applicant as well as the current loan status (Current, Late, Fully Paid, etc.) and latest payment information. For more information, refer to the Lending Club Data schema.
Once you have downloaded the data locally, you can create a database and table within the Databricks workspace to load this dataset. For more information, refer to Databricks Documentation > User Guide > Databases and Tables > Create a Table.
In this case, we have created the Databricks Database
amy and table
loanstats_2012_2017. The following code snippet allows you to access this table within a Databricks notebook via PySpark.
# Import loan statistics table loan_stats = spark.table("amy.loanstats_2012_2017")
Explore your Data
With the Databricks
displaycommand, you can make use of the Databricks native visualizations.# View bar graph of our data display(loan_stats)
In this case, we can view the asset allocations by reviewing the loan grade and the loan amount.
Munging your data with the PySpark DataFrame API
As noted in Cleaning Big Data (Forbes), 80% of a Data Scientist’s work is data preparation and is often the least enjoyable aspect of the job. But with PySpark, you can write Spark SQL statements or use the PySpark DataFrame API to streamline your data preparation tasks. Below is a code snippet to simplify the filtering of your data.# Import loan statistics table loan_stats = loan_stats.filter( loan_stats.loan_status.isin( ["Default", "Charged Off", "Fully Paid"] ) ).withColumn( "bad_loan", (~(loan_stats.loan_status == "Fully Paid") ).cast("string"))
After this ETL process is completed, you can use the
displaycommand again to review the cleansed data in a scatterplot.# View bar graph of our data display(loan_stats)
To view this same asset data broken out by state on a map visualization, you can use the
displaycommand combined the the PySpark DataFrame API using
group bystatements with
agg(aggregations) such as the following code snippet.# View map of our asset data display(loan_stats.groupBy("addr_state").agg((count(col("annual_inc"))).alias("ratio")))
Training our ML model using XGBoost
While we can quickly visualize our asset data, we would like to see if we can create a machine learning model that will allow us to predict if a loan is good or bad based on the available parameters. As noted in the following code snippet, we will predict
label) by building our ML pipeline as follows:
- Executes an
imputerto fill in missing values within the
attributes (output is
indexersto handle the categorical values and then converting them to vectors using OneHotEncoder via
featuresfor our ML pipeline are defined by combining the
- Next, we will assemble the features together by executing the
- As noted previously, we will establish our
label(i.e. what we are going to try to predict) as the
- Prior to establishing which algorithm to apply, apply the standard scaler to build our pipeline array (
// Imputation estimator for completing missing values val numerics_out = numerics.map(_ + "_out") val imputers = new Imputer() .setInputCols(numerics) .setOutputCols(numerics_out) // Apply StringIndexer for our categorical data val categoricals_idx = categoricals.map(_ + "_idx") val indexers = categoricals.map( x => new StringIndexer().setInputCol(x).setOutputCol(x + "_idx").setHandleInvalid("keep") ) // Apply OHE for our StringIndexed categorical data val categoricals_class = categoricals.map(_ + "_class") val oneHotEncoders = new OneHotEncoderEstimator() .setInputCols(categoricals_idx) .setOutputCols(categoricals_class) // Set feature columns val featureCols = categoricals_class ++ numerics_out // Create assembler for our numeric columns (including label) val assembler = new VectorAssembler() .setInputCols(featureCols) .setOutputCol("features") // Establish label val labelIndexer = new StringIndexer() .setInputCol("bad_loan") .setOutputCol("label") // Apply StandardScaler val scaler = new StandardScaler() .setInputCol("features") .setOutputCol("scaledFeatures") .setWithMean(true) .setWithStd(true) // Build pipeline array val pipelineAry = indexers ++ Array(oneHotEncoders, imputers, assembler, labelIndexer, scaler)
Now that we have established out pipeline, let’s create our XGBoost pipeline and apply it to our training dataset.// Create XGBoostEstimator val xgBoostEstimator = new XGBoostEstimator( Map[String, Any]( "num_round" -> 5, "objective" -> "binary:logistic", "nworkers" -> 16, "nthreads" -> 4 ) ) // Create XGBoost Pipeline val xgBoostPipeline = new Pipeline().setStages(pipelineAry ++ Array(xgBoostEstimator)) // Create XGBoost Model based on the training dataset val xgBoostModel = xgBoostPipeline.fit(dataset_train) // Test our model against the validation dataset val predictions = xgBoostModel.transform(dataset_valid) display(predictions.select("probabilities", "label"))
"nworkers" -> 16, "nthreads" -> 4is configured as the instances used were 16 i3.xlarges.
Now that we have our model, we can test our model against the validation dataset with
predictionscontaining the result.
Reviewing Model Efficacy
Now that we have built and trained our XGBoost model, let’s determine its efficacy by using the
BinaryClassficationEvaluator.// Include BinaryClassificationEvaluator import org.apache.spark.ml.evaluation.BinaryClassificationEvaluator // Evaluate val evaluator = new BinaryClassificationEvaluator() .setRawPredictionCol("probabilities") // Calculate Validation AUC val accuracy = evaluator.evaluate(predictions)
Upon calculation, the XGBoost validation data area-under-curve (AUC) is: ~0.6520.
Tune Model using MLlib Cross Validation
We can try to tune our model using MLlib cross validation via
CrossValidatoras noted in the following code snippet. We first establish our parameter grid so we can execute multiple runs with our grid of different parameter values. Using the same
BinaryClassificationEvaluatorthat we had used to test the model efficacy, we apply this at a larger scale with a different combination of parameters by combining the
ParamGridBuilderand apply it to our
CrossValidator().// Build parameter grid val paramGrid = new ParamGridBuilder() .addGrid(xgBoostEstimator.maxDepth, Array(4, 7)) .addGrid(xgBoostEstimator.eta, Array(0.1, 0.6)) .addGrid(xgBoostEstimator.num_round, Array(5, 10)) .build() // Set evaluator as a BinaryClassificationEvaluator val evaluator = new BinaryClassificationEvaluator() .setRawPredictionCol("probabilities") // Establish CrossValidator() val cv = new CrossValidator() .setEstimator(xgBoostPipeline) .setEvaluator(evaluator) .setEstimatorParamMaps(paramGrid) .setNumFolds(4) // Run cross-validation, and choose the best set of parameters. val cvModel = cv.fit(dataset_train)
This code snippet will run our cross-validation and choose the best set of parameters. We can then re-run our predictions and re-calculate the accuracy.// Test our model against the cvModel and validation dataset val predictions_cv = cvModel.transform(dataset_valid) display(predictions_cv.select("probabilities", "label")) // Calculate cvModel Validation AUC val accuracy = evaluator.evaluate(predictions_cv)
Our accuracy increased slightly with a value ~0.6734.
You can also review the bestModel parameters by running the following snippet.// Review bestModel parameters cvModel.bestModel.asInstanceOf[PipelineModel].stages(11).extractParamMap
Quantify the Business Value
A great way to quickly understand the business value of this model is to create a confusion matrix. The definition of our matrix is as follows:
- Label=1, Prediction=1 : Correctly found bad loans. sum_net = loss avoided.
- Label=0, Prediction=1 : Incorrectly labeled bad loans. sum_net = profit forfeited.
- Label=1, Prediction=0 : Incorrectly labeled good loans. sum_net = loss still incurred.
- Label=0, Prediction=0 : Correctly found good loans. sum_net = profit retained.
The following code snippet calculates the following confusion matrix.
To determine the value gained from implementing the model, we can calculate this as
value = -(loss avoided - profit forfeited)
If we were to compare the confusion matrix from a previously executed GLM model with AUC = ~0.6520 compared to our current XGBoost model with AUC = ~0.6734, the values note the significant value gain from implementing our XGBoost model.
- value (glm): 6.235
- value (XGBoost): 22.076
We demonstrated how you can quickly perform loan risk analysis using the Databricks Unified Analytics Platform (UAP) which includes the Databricks Runtime for Machine Learning. With Databricks Runtime for Machine Learning, Databricks clusters are preconfigured with XGBoost, scikit-learn, and numpy as well as popular Deep Learning frameworks such as TensorFlow, Keras, Horovod, and their dependencies.
By removing the data engineering complexities commonly associated with such data pipelines, we could quickly import our data source into a Databricks table, explore your data using Databricks Visualizations, execute ETL code against your data, and build, train, and tune your ML pipeline using XGBoost logistic regression. Try out this notebook series in Databricks today!
Try Databricks for free. Get started today.
The post Loan Risk Analysis with XGBoost and Databricks Runtime for Machine Learning appeared first on Databricks.