Workflow: Creating Scorecard models with the Scorecard block

IanBD
IanBD
Altair Employee
edited October 2022 in Altair RapidMiner

The Scorecard Model block enables you to create a scorecard model consisting of a set of attributes each with an assigned weighted score (either positive or negative).

The following demonstrates how to use the Scorecard Model block to create a scorecard with a logistic regression model and a WoE Transform block. Two input datasets (loan_data.csv and loan_applications.csv) that contains observations describing a loan and the person taking the loan out, loan_data.csv contains a Default column where loan_applications.csv does not.

  1. Import the loan_data.csv and loan_applications.csv datasets onto a Workflow canvas using the Text File Import block.
  2. Expand the Model Training group in the Workflow palette, then click and drag a WoE Transform block onto the Workflow canvas.
  3. Click the Output port of the loan_applications dataset block and drag a connection towards the Input port of the WoE Transform block.
  4. Double-click the WoE Transform block to display the WoE Transform Editor view.
  5. In the WoE Transform Editor view:
    1. In the Dependent variable drop-down list, select Default.
    2. In the Target Category drop-down list, select 1 (one).
    3. In the Unselected Variables list, press and hold CTRL and select the Age, Housing_Situation, Income, Other_Debt, and Sector variables.
    4. Click Select to move the specified variables to the Selected Variables list.
    5. Click the Optimisation tab, click Apply optimal binning to all variables.
    6. Close the WoE Transform Editor view and save the configuration when prompted.
      A green execution status is displayed in the Output port of the WoE Transform Working Dataset.
  6. Click and drag a Logistic Regression block onto the Workflow canvas.
  7. Click the Output port of the WoE Transform block Working Dataset and drag a connection towards the Input port of the Logistic Regression block.
  8. Double click the Logistic Regression block to display the Configure Logistic Regression dialog box.
  9. In the Configure Logistic Regression dialog box:
    1. In the Dependent variable drop-down list, select Default.
    2. In the Event drop-down list, select 1 (one).
    3. In the Unselected Effect Variables list, select the Age_WOE, Housing_Situation_WOE, Income_WOE, Other_Debt_WOE, and Sector_WOE variables.
    4. Click Select to move the specified variables to the Selected Effect Variables list.
    5. In the Selected Effect Variables list, clear the Class checkbox for each variable.
    6. Click the Model Selection tab and in the Method drop-down list, select Forward.
    7. Click OK to close the Configure Logistic Regression dialog box.
  10. Click and drag a Scorecard Model block onto the Workflow canvas.
  11. Click the Output port of the WoE Transform blocknWoE Transform block and drag a connection towards the Input port of the Scorecard Model block. Repeat for the Logistic Regression Model.
  12. Double click the Scorecard block to display the Scorecard Model view.
  13. In the Scorecard Model view:
    1. In Points at base odds enter 500.
    2. In Points to double the odds enter 60.
  14. Close the Scorecard Model view and save the configuration when prompted.
  15. Expand the Scoring group in the Workflow palette, then click and drag a Score block onto the Workflow canvas.
  16. Click the Output port of the Scorecard Model block and drag a connection towards the Input port of the Score block. Repeat for the loan_applications dataset.

The green execution status of the Score block turns green and the output is populated with the loan applications plus the score for each customer generated by the Scorecard Model block. A score threshold value can then be used in order to accept or reject these loan applications.

Tagged:

Categories