Method for constructing retail credit risk prediction model, credit card and special staged business Scorealpha 2d model
By building a credit risk prediction model based on massive data in financial institutions, the problem of insufficient data diversity and coverage faced by financial institutions in the credit risk scoring system is solved, and more accurate and stable credit risk management is achieved.
Patent Information
- Application Number
- CN202311346706.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2023-10-17
- Publication Date
- 2025-04-25
AI Technical Summary
When building a credit risk scoring system, financial institutions face problems such as insufficient data diversity and coverage, modeling skills and methodology that directly affect the stability and sorting of the system, especially small and medium-sized financial institutions have weak risk control capabilities during the digital transformation process.
By screening credit card and special installment business customer data based on massive data from large banks, a model is built to predict credit risks in credit business, and data samples with high stability, high coverage and high scarcity are used, combined with decision tree method and logistic regression model to calculate the probability of credit default and calibration of credit scores.
It improves the accuracy and efficiency of financial institutions in the full-process risk management of credit, enhances the stability and coverage of the retail business credit risk assessment system, especially in the prediction of medium- and long-term overdue risk.
Smart Images

Figure BDA0004499030640000061 
Figure BDA0004499030640000071 
Figure BDA0004499030640000072
Abstract
Description
Technical Field
[0001] This application relates to a credit risk management system and method. The method and system of this application can assist financial institutions in making more accurate risk decisions and accelerate their digital transformation process. In detail, this application relates to a method for building a retail credit risk prediction model for credit cards and special installment businesses and a Scorealpha2d model for credit cards and special installment businesses. Background Art
[0002] In the current environment of booming consumer credit, the manual approval mechanism of some financial institutions can no longer cope with the increasing demand for credit, so there is an urgent need to improve the intelligent risk control capabilities of financial institutions. Financial institutions hope to build a risk mitigation mechanism for the entire credit process, from customer pre-screening, pre-loan review, loan approval, post-loan management to early collection stages.
[0003] If a scoring system can be developed based on the principles of early identification, early warning, early detection and early disposal, and credit business can be monitored and managed quickly and conveniently, the financial institutions' own business volume, competitive advantage and asset quality can be improved while risks are controllable.
[0004] However, the construction of a scoring system is highly dependent on data and technology. The diversity and coverage of data dimensions, modeling techniques and methodology directly affect the final stability and ranking of the scoring system. Some financial institutions have little experience in intelligent risk control of retail business and have weak risk control capabilities. In the actual application process, factors such as lack of data mining and analysis capabilities and weak risk modeling technology have led to financial institutions being unable to fully utilize the value of internal data and effectively improve the accuracy and stability of models, and other control and management technical difficulties. This is also one of the main obstacles faced by small and medium-sized financial institutions in the direction of digital transformation. Summary of the invention
[0005] Credit cards are special cards issued by commercial banks to organizations or individuals based on applications from borrowers. Credit cards can be used to shop at designated merchants, make purchases, and deposit and withdraw money from banks. Credit card installment services include renovation installments, merchant installments, consumer installments, bill installments, and cash installments. These are consumer lines provided in addition to the credit line of credit cards to meet the large-amount consumption needs of credit card holders. These installment services require users to repay on schedule.
[0006] Credit cards have become an important part of the modern financial industry. They can significantly reduce social transaction costs and have a positive role in promoting my country's economic development. However, my country's credit card market is now in a period of fierce competition. Internet companies have seized the opportunity in the post-epidemic era, so it is necessary to continue to develop in a variety of scenarios. At the same time, it is also necessary to pay attention to risk control. Credit cards are credit certificates given by banks to borrowers, and special installment business is more convenient and faster than personal loan business. It is also more prone to risks, so it is necessary to avoid risks as much as possible while the business is developing rapidly. This requires the use of tools that can predict customer credit card and special installment business risks to assist business development. Comprehensive intelligent risk management tools need to be introduced not only before the loan, but also during and after the loan.
[0007] In this context, the credit risk prediction method and system of this application are based on massive data from large banks. It specifically screens customer data with credit cards and special installment businesses from the massive data, and uses customers with credit cards and special installment businesses in the retail credit customer base as samples to construct a model for predicting the credit risk of credit business.
[0008] The construction process of other popular scoring models in the market is often limited by unfavorable factors such as small number of modeling samples, relatively single data sources, and high homogeneity of data dimensions. At the same time, since most of the risk assessment models on the market currently use single-dimensional data, that is, modeling based on data from a single financial institution, a single social platform, or a single online shopping mall, the data coverage is limited, and it is difficult to conduct a comprehensive and true risk assessment of borrowers.
[0009] The method and system of the present application are developed based on data samples with high stability, high coverage and high scarcity, and have made systematic innovations to the relatively mature credit risk control system. At the same time, when selecting samples, customers with credit cards and special installment businesses in retail credit are used as modeling samples, which can effectively supplement the credit risk assessment system of retail business of financial institutions.
[0010] Specifically, the present application can further predict the probability of credit default in the future based on (1) the customer group that has not applied for credit business registration; (2) the new customer group that has applied for credit business registration within 3 months predicts the probability of credit default; (3) the existing customer group that has applied for credit business registration for more than 3 months and has overdue credit business in the past 6 months predicts the probability of credit default; (4) the existing customer group that has applied for credit business registration for more than 3 months, has not overdue credit business in the past 6 months, and has an average credit card repayment rate of more than 90% in the past 3 months predicts the probability of credit default; (5) the existing customer group that has applied for credit business registration for more than 3 months, has not overdue credit business in the past 6 months, and has an average credit card repayment rate of less than 90% in the past 3 months predicts the probability of credit default. These five credit default probabilities are used as prediction targets (i.e., target variables) for research and development.
[0011] Compared with existing models on the market, the method and system of the present application have great advantages in terms of coverage, stability and information value in predicting credit customers who are overdue for 90 days or more, and have good application prospects in predicting overdue risks of Internet credit customers, especially medium- and long-term overdue risks.
[0012] This application involves the following technical solutions:
[0013] 1. A method for calculating retail credit risk, comprising:
[0014] A data collection step, which obtains retail credit prediction data of the sample to be predicted;
[0015] A step of classifying samples to be predicted, which classifies the samples to be predicted based on a decision tree method to determine a sub-model for calculating the probability of credit default;
[0016] The credit default probability calculation step is to substitute the retail credit prediction data into the credit default probability sub-model to calculate the credit default probability of the sample to be predicted.
[0017] 2. The method according to claim 1, further comprising:
[0018] After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is used to calibrate the calculated credit default probability to a standardized score of 0-1000 points.
[0019] 3. The method according to item 1 or 2, wherein:
[0020] The retail credit prediction data includes original retail credit prediction data of the sample to be predicted and derived retail credit prediction data processed based on the original retail credit prediction data;
[0021] Preferably, the original retail credit prediction data includes:
[0022] Credit card basic data, which is based on all available data during the sample user's credit card creation and usage process.
[0023] Basic data on personal loans, which is all available data based on the loan application and usage behavior of sample users.
[0024] Basic customer information data, which is based on the attributes of the sample users themselves but is not directly related to their behavior in financial institutions.
[0025] Basic data on personal financial assets, which includes all other financial assets and financial transaction data of sample users in financial institutions that are not related to credit cards and loans.
[0026] 4. The method according to any one of items 1 to 3, wherein
[0027] The derived retail credit prediction data processed based on the original retail credit prediction data refers to the data obtained by processing the collected original retail credit prediction data based on the time dimension, space dimension, frequency dimension and statistical information dimension;
[0028] Preferably, the derived retail credit forecast data includes but is not limited to:
[0029] Derived retail credit forecast data obtained by processing based on sample relationship length,
[0030] Derivative retail credit forecast data obtained by processing time interval variables,
[0031] Derivative retail credit forecast data obtained by processing based on the frequency of sample behavior,
[0032] Derivative retail credit forecast data obtained by processing the current time point of the sample,
[0033] Derivative retail credit forecast data obtained by processing based on sample continuous behavior,
[0034] Derived retail credit forecast data obtained by processing sample data based on statistical information dimensions.
[0035] 5. The method according to any one of items 1 to 4, wherein the retail credit prediction data is selected from one, two, three, four, five, six, seven or eight of the following:
[0036] Average utilization rate of revolving loan in the past 3 months, average number of credit card cash withdrawals, number of months with credit card utilization rate > 90% in the past 3 months, number of months with credit card interest > 0 in the past 3 months, minimum balance of deposit account in the past 6 months, average monthly AUM (personal financial assets) in the past 6 months, remaining available credit limit of credit card in the current month, installment balance of credit card in the current month, number of months from the minimum balance of deposit account in the past 3 months, number of overdue payments > 0 by credit customers in the past 3 months, number of overdue payments > 1 by credit customers in the past 3 months, number of overdue payments > 2 by credit customers in the past 3 months, number of overdue payments > 3 by credit customers in the past 3 months, most Number of months since the last overdue payment > 0, current account age of the credit customer, number of months in the past 6 months with a revolving loan limit utilization rate greater than 70%, percentage of total credit card interest / consumption and cash withdrawals in the past 12 months, number of overdue payments by credit customers > 0 in the past 12 months, average credit card installment limit utilization rate in the past 6 months, number of months with a credit card limit utilization rate > 70% in the past 12 months, minimum revolving loan limit utilization rate in the past 6 months, number of months with a credit card repayment rate > 90% in the past 12 months, number of months since the maximum balance of the deposit account in the past 12 months, current deposit account balance, average balance of investment and wealth management accounts in the past 6 months, maximum wage payment value in the past 12 months.
[0037] 6. The method according to any one of items 1 to 5, wherein
[0038] The step of classifying the sample to be predicted includes the following sub-steps:
[0039] Whether the sample to be tested is a customer who has applied for registration of credit business;
[0040] Whether the sample to be tested is a customer who has applied for registration within M months;
[0041] Whether the sample to be tested is a customer with zero overdue credit business in the past 6 months;
[0042] Whether the sample to be tested is a customer whose average credit card repayment rate in the past three months is less than N;
[0043] Based on the above sub-steps, the samples to be predicted are classified to determine the sub-model for calculating the probability of credit default. Under the premise of ensuring the rationality of business logic, the order of the above sub-steps can be set arbitrarily;
[0044] It is preferred to classify the predicted samples in the following order:
[0045] Whether the sample to be tested is a customer who has applied for registration of credit business;
[0046] Whether the sample to be tested is a customer who has applied for registration within M months;
[0047] Whether the sample to be tested is a customer with zero overdue credit business in the past 6 months;
[0048] Whether the sample to be tested is a customer whose average credit card repayment rate in the past three months is less than N.
[0049] 7. The method according to any one of items 1 to 6, wherein
[0050] After performing feature conversion on the retail credit prediction data, the data is substituted into the credit default probability sub-model to calculate the credit default probability of the sample to be predicted. The feature conversion step includes:
[0051] Based on the feature type of the retail credit prediction data that needs to be substituted into the credit default probability sub-model, select the WOE method or the continuous method for feature conversion.
[0052] 8. The method according to claim 7, wherein:
[0053] The continuous method for feature conversion includes the following methods: directly selecting the original value, calculating the square of the original data, calculating the square root of the original data, calculating the cube root of the original data, or calculating the natural logarithm of the original data to perform continuous feature conversion.
[0054] 9. The method according to any one of items 1 to 8, wherein
[0055] The credit default probability sub-model is a model constructed based on sample retail credit prediction data and credit default probability using logistic regression based on the existing user population.
[0056] 10. The method according to any one of items 1 to 9, wherein
[0057] The retail credit prediction data is selected from: one, two, three, four, five or six of the following: the average utilization rate of revolving loans in the past three months, the average number of cash withdrawals from credit cards, the number of months with a credit card utilization rate > 90% in the past three months, the number of months with a credit card interest rate > 0 in the past three months, the minimum balance of deposit accounts at a certain point in time in the past six months, and the average monthly AUM (personal financial assets) in the past six months.
[0058] 11. The method according to item 10, wherein the step of calculating the probability of credit default comprises:
[0059] The feature conversion is performed on the average utilization rate of revolving loans in the past three months, the average number of credit card cash withdrawals, the number of months with a credit card utilization rate > 90% in the past three months, the number of months with a credit card interest rate > 0 in the past three months, the minimum balance of deposit accounts in the past six months, and the average monthly AUM (personal financial assets) in the past six months.
[0060] It is preferred to use a continuous conversion method for the average utilization rate of revolving loans in the past three months; use the WOE conversion method for the average number of credit card withdrawals; use a continuous conversion method for the number of months in which the credit card utilization rate in the past three months is >90%; use the WOE conversion method for the number of months in which the credit card interest is >0 in the past three months; use a continuous conversion method for the minimum balance of the deposit account at a certain point in time in the past six months; and use a continuous conversion method for the average monthly AUM (personal financial assets) in the past six months.
[0061] Further preferred is to use the square method to calculate the average utilization rate of the revolving loan limit in the past three months; to use the original value method to calculate the number of months in which the credit card limit utilization rate was >90% in the past three months; to use the logarithm method to calculate the minimum balance of the deposit account at a certain point in time in the past six months; and to use the square root method to calculate the average monthly AUM (personal financial assets) in the past six months.
[0062] 12. The method according to claim 11, wherein:
[0063] The converted values of the six features, namely, the average utilization rate of the revolving loan in the past three months, the average number of credit card cash withdrawals, the number of months with a credit card utilization rate > 90% in the past three months, the number of months with a credit card interest rate > 0 in the past three months, the minimum balance of the deposit account at a certain point in time in the past six months, and the average monthly AUM (personal financial assets) in the past six months, are substituted into the sub-model constructed by logistic regression based on the sample retail credit prediction data and credit default probability to calculate the default probability of the sample to be predicted.
[0064] 13. The method according to claim 12, wherein:
[0065] The sub-model is shown in the following formula 1:
[0066]
[0067] Where k is the number of features entering the model, preferably k is 6,
[0068] α is the intercept, the value range is (-2.861, -2.5016), and the optimal value is -2.681;
[0069] β1 is the average utilization rate of the revolving loan in the past three months, with a value range of (-0.6556, -0.5652), and the optimal value is -0.61;
[0070] β2 is the average number of cash withdrawals from credit cards, with a value range of (-0.637, -0.528) and an optimal value of -0.582;
[0071] β3 is the number of months in which the credit card limit utilization rate is greater than 90% in the past three months, with a value range of (-0.4641, -0.3704) and an optimal value of -0.417;
[0072] β4 is the number of months in which the credit card interest is > 0 in the past three months, with a value range of (-0.2974, -0.1924) and an optimal value of -0.245;
[0073] β5 is the minimum balance of the deposit account in the past 6 months, with a value range of (-0.1345, -0.0686) and an optimal value of -0.102;
[0074] β6 is the average monthly AUM (personal financial assets) in the past 6 months, with a value range of (-0.1243, -0.0547) and an optimal value of -0.09;
[0075] x1 is the WOE conversion value of the average utilization rate of the revolving loan in the past three months generated in the feature conversion step;
[0076] x2 is the square transformation value of the average number of credit card cash withdrawals generated in the feature transformation step;
[0077] x3 is the original value of the number of months in which the credit card limit utilization rate was > 90% in the past three months, generated by the feature conversion step;
[0078] x4 is the WOE conversion value of the number of months with credit card interest > 0 in the past three months generated in the feature conversion step;
[0079] x5 is the logarithmic transformation value of the minimum balance of the deposit account at a certain point in time in the past 6 months generated by the feature conversion step;
[0080] x6 is the square root transformed value of the average monthly AUM (personal financial assets) for the past 6 months generated in the feature transformation step.
[0081] 14. The method according to claim 13, wherein:
[0082] After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower:
[0083]
[0084]
[0085] Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
[0086] 15. The method according to any one of items 1 to 9, wherein
[0087] The retail credit prediction data is selected from: one, two, three, four, five, six or seven of the remaining available credit limit of the credit card in the current month, the installment balance of the credit card in the current month, the number of months from the minimum balance of the deposit account in the past three months, the number of overdue payments of the credit customer > 0 in the past three months, the number of overdue payments of the credit customer > 1 in the past three months, the number of overdue payments of the credit customer > 2 in the past three months, and the number of overdue payments of the credit customer > 3 in the past three months.
[0088] 16. The method according to item 15, wherein the step of calculating the probability of credit default comprises:
[0089] The remaining available credit limit of the credit card in the current month, the installment balance of the credit card in the current month, the number of months from the minimum balance of the deposit account in the past three months, the number of overdue payments of credit customers > 0 in the past three months, the number of overdue payments of credit customers > 1 in the past three months, the number of overdue payments of credit customers > 2 in the past three months, and the number of overdue payments of credit customers > 3 in the past three months are converted into features.
[0090] It is preferred to use the continuous conversion method for the remaining available credit limit of the current month of the credit card; the continuous conversion method is used for the installment balance of the current month of the credit card; the WOE conversion method is used for the number of months from the minimum balance of the deposit account in the past three months; the WOE conversion method is used for the number of overdue payments of the credit customer in the past three months > 0; the continuous conversion method is used for the number of overdue payments of the credit customer in the past three months > 1; the continuous conversion method is used for the number of overdue payments of the credit customer in the past three months > 2; the continuous conversion method is used for the number of overdue payments of the credit customer in the past three months > 3;
[0091] Further preferably, the logarithm of the remaining available credit limit of the credit card in the current month is used for calculation; the logarithm of the installment balance of the credit card in the current month is used for calculation; the square of the number of overdue payments of the credit customer in the past three months > 1 is used for calculation; the square root of the number of overdue payments of the credit customer in the past three months > 2 is used for calculation; the square root of the number of overdue payments of the credit customer in the past three months > 3 is used for calculation.
[0092] 17. The method according to claim 15, wherein:
[0093] The converted values of the seven features, including the remaining available credit limit of the credit card in the current month, the installment balance of the credit card in the current month, the number of months from the minimum balance of the deposit account in the past three months, the number of overdue payments of credit customers > 0 in the past three months, the number of overdue payments of credit customers > 1 in the past three months, the number of overdue payments of credit customers > 2 in the past three months, and the number of overdue payments of credit customers > 3 in the past three months, are substituted into the sub-model constructed by logistic regression based on the sample retail credit prediction data to calculate the default probability of the sample to be predicted.
[0094] 18. The method according to claim 17, wherein:
[0095] The sub-model is shown in the following formula 2:
[0096]
[0097] Where k is the number of features entering the model, and k is preferably 7;
[0098] α is the intercept, the value range is (2.61, 2.6512), and the optimal value is 2.631;
[0099] β1 is the remaining available credit limit of the credit card in the current month, with a value range of (-0.2514, -0.2464) and an optimal value of -0.249;
[0100] β2 is the current monthly installment balance of the credit card, with a value range of (-0.9655, -0.9299) and an optimal value of -0.948;
[0101] β3 is the number of months from the current month when the deposit account has the minimum balance in the past three months. The value range is (-0.3237, -0.3099), and the optimal value is -0.317;
[0102] β4 is the number of times the credit customer has overdue payments > 0 in the past three months, with a value range of (-0.252, -0.2402) and an optimal value of -0.246;
[0103] β5 is the number of months in which the credit limit utilization rate of the credit card in the past 12 months is greater than 90%, with a value range of (-0.5863, -0.5587) and an optimal value of -0.573;
[0104] β6 is the average repayment rate of credit customers in the past 6 months, with a value range of (-0.1131, -0.1075) and an optimal value of -0.11;
[0105] β7 is the maximum percentage of (interest / limit) of the credit card in the past three months, with a value range of (-0.3407, -0.3209) and an optimal value of -0.331;
[0106] x1 is the logarithmic transformation value of the remaining available credit limit of the credit card in the current month generated in the feature transformation step;
[0107] x2 is the logarithmic transformation value of the current monthly installment balance of the credit card generated in the feature transformation step;
[0108] x3 is the WOE conversion value of the minimum balance of the deposit account in the past three months generated by the feature conversion step, which is the number of months from now;
[0109] x4 is the WOE conversion value of the number of credit customers with overdue payments > 0 in the past three months generated in the feature conversion step;
[0110] x5 is the square transformation value of the number of months with a credit card limit utilization rate > 90% in the past 12 months generated by the feature conversion step;
[0111] x6 is the square root transformed value of the average repayment rate of credit customers in the past 6 months generated in the feature conversion step;
[0112] x7 is the cube root conversion value of the maximum percentage of credit card (interest / limit) in the past three months generated by the feature conversion step.
[0113] 19. The method according to claim 18, wherein:
[0114] After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower:
[0115]
[0116]
[0117] Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
[0118] 20. The method according to any one of items 1 to 9, wherein
[0119] The retail credit prediction data is selected from: the remaining available credit limit of the credit card in the current month, the number of months since the last overdue payment of the credit customer in the past 12 months>0, the current account age of the credit customer, the number of months in the past 6 months when the utilization rate of the revolving loan limit was greater than 70%, and one, two, three, four or five of the percentages of the total amount of interest / consumption and cash withdrawals of the credit card in the past 12 months.
[0120] 21. The method according to claim 20, wherein the step of calculating the probability of credit default comprises:
[0121] The remaining available credit limit of the credit card in the current month, the number of months since the last overdue payment of the credit customer in the past 12 months>0, the current account age of the credit customer, the number of months in the past 6 months when the utilization rate of the revolving loan limit was greater than 70%, and the percentage of the total amount of interest / consumption and cash withdrawal of the credit card in the past 12 months are converted into features.
[0122] It is preferred to use the continuous conversion method for the remaining available credit limit of the current month of the credit card; the WOE conversion method is used for the number of months from the last overdue payment of the credit customer in the past 12 months > 0; the continuous conversion method is used for the current account age of the credit customer; the continuous conversion method is used for the number of months in which the credit limit utilization rate of the revolving loan is greater than 70% in the past 6 months; the continuous conversion method is used for the percentage of interest / total amount of consumption and cash withdrawal of the credit card in the past 12 months;
[0123] Further preferred is to use the logarithm of the remaining available credit limit of the credit card in the current month; to use the cube root of the number of months when the credit customer's current account utilization rate is >90%; to use the square root of the number of months when the utilization rate of the revolving loan limit in the past 6 months was greater than 70%; and to use the square of the percentage of the total amount of interest / consumption and cash withdrawals of the credit card in the past 12 months.
[0124] 22. The method according to claim 20, wherein:
[0125] The converted values of the five features, namely, the remaining available credit limit of the credit card in the current month, the number of months since the last overdue payment of the credit customer in the past 12 months>0, the current account age of the credit customer, the number of months in the past 6 months when the utilization rate of the revolving loan limit was greater than 70%, and the percentage of the total amount of interest / consumption and cash withdrawals of the credit card in the past 12 months, are substituted into the sub-model constructed by logistic regression based on the sample retail credit prediction data and credit default probability to calculate the default probability of the sample to be predicted.
[0126] 23. The method according to claim 22, wherein:
[0127] The sub-model is shown in Formula 3 below:
[0128]
[0129] Where k is the number of features entering the model, and k is preferably 5;
[0130] α is the intercept, with a range of values of (2.2139, 2.3355) and an optimal value of 2.275; β1 is the remaining available credit limit of the credit card in the current month, with a range of values of (-0.3212, -0.3148) and an optimal value of -0.318; β2 is the number of months from the last overdue payment of the credit customer in the past 12 months > 0, with a range of values of (0.6342, 0.6486) and an optimal value of 0.641; β3 is the current account age of the credit customer , the value range is (-0.6442, -0.6232), and the optimal value is -0.634; β4 is the number of months in which the utilization rate of the revolving loan limit is greater than 70% in the past 6 months, the value range is (-0.2966, -0.2786), and the optimal value is -0.288; β5 is the percentage of interest / consumption and cash withdrawal of credit cards in the past 12 months, the value range is (-0.2645, -0.2461), and the optimal value is -0.255;
[0131] x1 is the logarithmic transformation value of the remaining available credit limit of the credit card in the current month generated in the feature transformation step;
[0132] x2 is the WOE conversion value of the credit customer whose most recent overdue payment in the past 12 months is greater than 0 months ago, generated by the feature conversion step;
[0133] x3 is the square transformation value of the current age of the credit customer generated in the feature transformation step;
[0134] x4 is the cube root conversion value of the number of months in the past 6 months when the utilization rate of the revolving loan was greater than 70% generated in the feature conversion step;
[0135] x5 is the square root conversion value of the total amount of interest / consumption and cash withdrawal of the credit card in the past 12 months generated in the feature conversion step.
[0136] 24. The method according to claim 23, wherein:
[0137] After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower:
[0138]
[0139]
[0140] Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
[0141] 25. The method according to any one of items 1 to 9, wherein
[0142] The retail credit prediction data is selected from: the remaining available credit limit of the credit card in the current month, the number of overdue payments of the credit customer in the past 12 months > 0, the current account age of the credit customer, the average utilization rate of the installment limit of the credit card in the past 6 months, the number of months with the credit card limit utilization rate > 70% in the past 12 months, the percentage of interest / consumption and total cash withdrawal amount of the credit card in the past 12 months, the minimum utilization rate of the revolving loan limit in the past 6 months, and the number of months with the credit card repayment rate > 90% in the past 12 months.
[0143] 26. The method according to item 25, wherein the step of calculating the probability of credit default comprises:
[0144] The remaining available credit limit of the credit card in the current month, the number of overdue payments of credit customers in the past 12 months > 0, the current account age of credit customers, the average utilization rate of the credit card installment limit in the past 6 months, the number of months with a credit card limit utilization rate > 70% in the past 12 months, the percentage of interest / consumption and total cash withdrawals of credit cards in the past 12 months, the minimum utilization rate of revolving loans in the past 6 months, and the number of months with a credit card repayment rate > 90% in the past 12 months are converted into features.
[0145] It is preferred to use a continuous conversion method for the remaining available credit limit of the current month of the credit card; use the WOE method to convert the number of overdue payments of credit customers in the past 12 months > 0; use a continuous conversion method for the current account age of credit customers; use a continuous conversion method for the average utilization rate of the installment credit limit of the credit card in the past 6 months; use a continuous conversion method for the number of months with a credit limit utilization rate > 70% in the past 12 months; use a continuous conversion method for the percentage of the total amount of interest / consumption and cash withdrawals of the credit card in the past 12 months; use a continuous conversion method for the minimum utilization rate of the revolving loan limit in the past 6 months; use a continuous conversion method for the number of months with a credit card repayment rate > 90% in the past 12 months;
[0146] Further preferably, the remaining available credit limit of the credit card in the current month is calculated by taking the logarithm; the current account age of the credit customer is calculated by taking the original value; the average utilization rate of the installment credit limit of the credit card in the past 6 months is calculated by taking the square; the number of months in the past 12 months when the credit limit utilization rate is greater than 70% is calculated by taking the square root; the percentage of the total amount of interest / consumption and cash withdrawals of the credit card in the past 12 months is calculated by taking the square; the minimum value of the credit limit utilization rate of the revolving loan in the past 6 months is calculated by taking the logarithm; and the number of months in the past 12 months when the repayment rate of the credit card is greater than 90% is calculated by taking the original value.
[0147] 27. The method according to claim 25, wherein:
[0148] The converted values of eight features, including the remaining available credit limit of the credit card in the current month, the number of overdue payments of the credit customer > 0 in the past 12 months, the current account age of the credit customer, the average utilization rate of the credit card installment limit in the past 6 months, the number of months with the credit card limit utilization rate > 70% in the past 12 months, the percentage of interest / consumption and total cash withdrawal amount of the credit card in the past 12 months, the minimum utilization rate of the revolving loan limit in the past 6 months, and the number of months with the credit card repayment rate > 90% in the past 12 months, are substituted into the sub-model constructed by logistic regression based on the sample retail credit prediction data to calculate the default probability of the sample to be predicted.
[0149] 28. The method according to claim 27, wherein:
[0150] The sub-model is shown in Formula 4 below:
[0151]
[0152] Where k is the number of features entering the model, preferably k is 8;
[0153] α is the intercept, the value range is (1.8206, 1.9124), and the optimal value is 1.867;
[0154] β1 is the remaining available credit limit of the credit card in the current month, with a value range of (-0.3997, -0.3923), and the optimal value is -0.396;
[0155] β2 is the number of times the credit customer has overdue payments > 0 in the past 12 months, with a value range of (-0.5279, -0.5179) and an optimal value of -0.523;
[0156] β3 is the current age of the credit customer, with a value range of (-0.6273, -0.6111), and the optimal value is -0.619;
[0157] β4 is the average utilization rate of the credit card installment limit in the past 6 months, with a value range of (-0.3218, -0.3132) and an optimal value of -0.318;
[0158] β5 is the number of months in the past 12 months when the credit limit utilization rate is greater than 70%, with a value range of (-0.2822, -0.2714), and the optimal value is -0.277;
[0159] β6 is the percentage of interest / total amount of consumption and cash withdrawal of credit card in the past 12 months, with a value range of (-0.2588, -0.2486) and an optimal value of -0.254;
[0160] β7 is the minimum utilization rate of the revolving loan in the past 6 months, with a value range of (-0.2388, -0.2292) and an optimal value of -0.234;
[0161] β8 is the number of months in which the credit card repayment rate was > 90% in the past 12 months, with a value range of (-0.2318, -0.2204) and an optimal value of -0.226;
[0162] x1 is the logarithmic transformation value of the remaining available credit limit of the credit card in the current month generated in the feature transformation step;
[0163] x2 is the original value of the number of times a credit customer has overdue payments > 0 in the past 12 months generated in the feature conversion step;
[0164] x3 is the square transformation value of the current age of the credit customer generated in the feature transformation step;
[0165] x4 is the WOE conversion value of the average credit card installment limit utilization rate in the past 6 months generated in the feature conversion step;
[0166] x5 is the logarithmic transformation value of the number of months with a credit card limit utilization rate > 70% in the past 12 months generated in the feature transformation step;
[0167] x6 is the square root conversion value of the percentage of interest / consumption and total cash withdrawal amount of the credit card in the past 12 months generated in the feature conversion step;
[0168] x7 is the square conversion value of the minimum utilization rate of the revolving loan in the past 6 months generated by the feature conversion step;
[0169] x8 is the original value of the number of months with a credit card repayment rate > 90% in the past 12 months generated by the feature conversion step.
[0170] 29. The method according to claim 28, wherein:
[0171] After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower:
[0172]
[0173] Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
[0174] 30. The method according to any one of items 1 to 9, wherein
[0175] The retail credit forecast data is selected from: the number of months from the maximum balance of the deposit account in the past 12 months, the minimum balance of the deposit account in the past 6 months, the current balance of the deposit account, the average monthly AUM (personal financial assets) in the past 6 months, the average balance of the investment and financial management account in the past 6 months, and one, two, three, four, five or six of the maximum values of wage payments in the past 12 months.
[0176] 31. The method according to item 30, wherein the step of calculating the probability of credit default comprises:
[0177] The feature conversion is performed on the number of months from the maximum balance of the deposit account in the past 12 months, the minimum balance of the deposit account in the past 6 months, the current balance of the deposit account, the average monthly AUM (personal financial assets) in the past 6 months, the average balance of the investment and financial management account in the past 6 months, and the maximum value of the salary payment in the past 12 months.
[0178] It is preferred to use the WOE method to convert the maximum balance of the deposit account in the past 12 months from the present; the continuous conversion method is used for the current account age of the credit customer; the continuous conversion method is used for the current deposit account balance; the continuous conversion method is used for the monthly average AUM (personal financial assets) of the past 6 months; the continuous conversion method is used for the average balance of the investment and financial management account in the past 6 months; the continuous conversion method is used for the maximum value of the salary paid on behalf of the customer in the past 12 months;
[0179] Further preferred is to use the logarithm of the minimum balance of the deposit account at a certain point in time in the past 6 months; to use the logarithm of the balance of the deposit account at the current point in time; to use the original value of the average monthly AUM (personal financial assets) of the past 6 months; to use the square of the average balance of the investment and financial management account in the past 6 months; and to use the cube root of the maximum value of salary payments on behalf of others in the past 12 months.
[0180] 32. The method according to claim 30, wherein:
[0181] The converted values of the six features, namely, the number of months from the maximum balance of the deposit account in the past 12 months, the minimum balance of the deposit account in the past 6 months, the current balance of the deposit account, the average monthly AUM (personal financial assets) in the past 6 months, the average balance of the investment and financial management account in the past 6 months, and the maximum value of the wage payment in the past 12 months, are substituted into the sub-model constructed by logistic regression based on the sample retail credit prediction data to calculate the default probability of the sample to be predicted.
[0182] 33. A method according to claim 32, wherein:
[0183] The sub-model is shown in Formula 5 below:
[0184]
[0185] Where k is the number of features entering the model, and k is preferably 6;
[0186] α is the intercept, the value range is (-2.6066, -2.2583), and the optimal value is -2.432;
[0187] β1 is the number of months from the current point in time when the deposit account has the largest balance in the past 12 months, with a value range of (-3.0504, -2.2763), and the optimal value is -2.663;
[0188] β2 is the minimum balance of the deposit account in the past 6 months, with a value range of (-0.1819, -0.1163) and an optimal value of -0.149;
[0189] β3 is the current deposit account balance, with a value range of (-0.1197, -0.0721), and the optimal value is -0.096;
[0190] β4 is the average monthly AUM (personal financial assets) in the past 6 months, with a value range of (-0.119, -0.0513) and an optimal value of -0.085;
[0191] β5 is the average balance of investment and financial management accounts in the past 6 months, with a value range of (-0.5767, -0.2145) and an optimal value of -0.396;
[0192] β6 is the maximum value of the wage payment in the past 12 months, with a value range of (-0.6459, -0.1799) and an optimal value of -0.413;
[0193] x1 is the logarithmic transformation value of the maximum balance of the deposit account in the past 12 months generated in the feature conversion step;
[0194] x2 is the logarithmic transformation value of the minimum balance of the deposit account at a certain point in time in the past 6 months generated by the feature conversion step;
[0195] x3 is the WOE conversion value of the deposit account balance at the current time point generated by the feature conversion step;
[0196] x4 is the original value of the average monthly AUM (personal financial assets) for the past 6 months generated in the feature conversion step;
[0197] x5 is the square transformation value of the average balance of the investment and financial management account in the past 6 months generated by the feature transformation step;
[0198] x6 is the cube root conversion value of the maximum wage paid on behalf of others in the past 12 months generated in the feature conversion step.
[0199] 34. A method according to claim 33, wherein:
[0200] After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower:
[0201]
[0202]
[0203] Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
[0204] 35. A device for calculating retail credit risk, comprising:
[0205] A data collection module, which is used to obtain retail credit prediction data of samples to be predicted;
[0206] A module for classifying samples to be predicted, which is used to classify the samples to be predicted based on a decision tree method to determine a sub-model for calculating the probability of credit default;
[0207] A credit default probability calculation module is used to substitute the retail credit prediction data into the credit default probability sub-model to calculate the credit default probability of the sample to be predicted, and preferably the credit default probability is the credit default probability for credit cards and special installment business.
[0208] 36. An apparatus according to item 35, wherein the apparatus executes the steps of the method for calculating retail credit risk described in any one of items 1 to 34.
[0209] 37. A system for calculating retail credit risk, characterized in that the system for calculating retail credit risk comprises: a memory, a processor, and a program for the method for calculating retail credit risk stored in the memory and executable on the processor, wherein the program for calculating retail credit risk implements the steps of the method for calculating retail credit risk as described in any one of items 1 to 34 when executed by the processor.
[0210] 38. A computer storage medium, characterized in that a program for calculating retail credit risk is stored on the computer storage medium, and when the program for calculating retail credit risk is executed by a processor, the steps of the method for calculating retail credit risk as described in any one of items 1 to 34 are implemented.
[0211] 39. A method for constructing a retail credit risk prediction model for credit card and special installment business, comprising:
[0212] A data collection step, which obtains the original retail credit prediction data of the sample used to build the model;
[0213] A data derivation step, which processes derived retail credit forecast data based on the original retail credit forecast data;
[0214] The feature initial screening step is to perform initial screening on all categories, that is, all features, including the original retail credit forecast data and the derived retail credit forecast data, to obtain features after initial screening;
[0215] The initial screening data conversion step is to judge the conversion method of the features after the initial screening to confirm whether to use one of the WOE conversion method, the dummy feature conversion method and the continuous conversion method for feature conversion, and use the best method to convert each feature after the initial screening;
[0216] The feature fine screening step is to perform in-depth screening on the initially screened features after feature conversion to obtain finely screened features;
[0217] The credit default probability modeling step is to select the logistic regression method to build the model based on the relationship between the carefully screened features and the probability of credit default, and confirm the method used to calculate the credit default probability;
[0218] The data samples obtained in the data collection step are samples of customers who have used credit cards and special installment services.
[0219] 40. The method according to claim 39, wherein:
[0220] In the data collection step, the original retail credit prediction data of the samples obtained for building the model include:
[0221] Credit card basic data, which is based on all available data during the sample user's credit card creation and usage process.
[0222] Basic data on personal loans, which is all available data based on the loan application and usage behavior of sample users.
[0223] Basic customer information data, which is based on the attributes of the sample users themselves but is not directly related to their behavior in financial institutions.
[0224] Basic data on personal financial assets, which includes all other financial assets and financial transaction data of sample users in financial institutions that are not related to credit cards and loans.
[0225] 41. The method according to claim 39, wherein:
[0226] In the data derivation step, the derived retail credit prediction data processed based on the original retail credit prediction data refers to data obtained by processing the collected original retail credit prediction data based on the time dimension, space dimension, frequency dimension, and statistical information dimension;
[0227] Preferably, the derived retail credit forecast data includes but is not limited to:
[0228] Derived retail credit forecast data obtained by processing based on sample relationship length,
[0229] Derivative retail credit forecast data obtained by processing time interval variables,
[0230] Derivative retail credit forecast data obtained by processing based on the frequency of sample behavior,
[0231] Derivative retail credit forecast data obtained by processing the current time point of the sample,
[0232] Derivative retail credit forecast data obtained by processing based on sample continuous behavior,
[0233] Derived retail credit forecast data obtained by processing sample data based on statistical information dimensions.
[0234] 42. The method according to any one of items 39 to 41, wherein
[0235] The feature initial screening step includes the following steps:
[0236] The first preliminary screening step is to screen the features based on the missing data of each feature of the sample used to build the model.
[0237] The second initial screening step is to screen the features based on the fact that a single value of a feature sample is too high.
[0238] The third preliminary screening step is to calculate the information IV value of each feature to perform preliminary screening of the features;
[0239] The order of the first preliminary screening step, the second preliminary screening step and the third preliminary screening step can be any order.
[0240] The fourth preliminary screening step uses a stepwise discrimination algorithm to perform preliminary screening of features after the first to third preliminary screenings;
[0241] The fifth preliminary screening step is to conduct preliminary screening of the features after the fourth preliminary screening step based on the consistency between the risk characteristics of each feature itself and the actual real results of the samples used for model construction.
[0242] 43. The method according to any one of items 39 to 42, further comprising:
[0243] The sample selection step is used to screen all users and obtain samples of credit cards and special installment services for model construction before the data collection step.
[0244] Preferably, the sample selection step includes classifying all sample users based on a decision tree, and the classification basis includes but is not limited to:
[0245] Whether a user is a customer of a customer who has applied to register for credit business;
[0246] Whether a user is a customer who has applied for registration within M months;
[0247] Whether a user is a customer with zero overdue credit business in the past six months;
[0248] Whether a user is a customer whose average credit card repayment rate in the past three months is less than N.
[0249] 44. A method according to any one of items 39 to 43, wherein, in the initial screening data conversion step, the conversion method of the features after the initial screening is determined based on the concentration and data type of the features after the initial screening.
[0250] 45. A method according to claim 44, wherein:
[0251] The initial screening data conversion step includes the following steps based on the judgment of concentration and data type:
[0252] Classify the data type of each feature into character variables and numeric variables.
[0253] For character variables, dummy feature conversion is used to perform initial screening data conversion.
[0254] The process of further classifying numerical variables includes the following sub-steps:
[0255] If the value of the numeric variable is less than n, the WOE conversion method is used to convert the initial screening data.
[0256] If the value of the numerical variable is more than n, further judge if the value of the continuous variable is large and the concentration of a single value is greater than m%, then the WOE conversion method is used; if the concentration of a single value is less than or equal to m%, then the continuous conversion method is used.
[0257] Preferably, n and m are both positive integers, wherein n=5-10, and m=90-99.
[0258] 46. The method according to item 45, further comprising:
[0259] For the features that are confirmed to adopt the continuous conversion method, the optimal conversion method is selected based on the correlation between the feature and credit default under different continuous conversion methods to perform the continuous feature conversion of the feature.
[0260] Preferably, the continuous feature conversion is performed by directly selecting the original value, calculating the square of the original data, calculating the square root of the original data, calculating the cube root of the original data, or calculating the natural logarithm of the original data.
[0261] 47. The method according to any one of items 39 to 46, wherein the feature fine screening step comprises:
[0262] The first fine screening step is to screen the features based on the stepwise regression algorithm, the F test and the T test to determine the significance of the features.
[0263] The second fine screening step is to calculate the variance inflation factor based on each feature and eliminate the features with higher variance inflation factors to screen the features.
[0264] The third fine screening step is to analyze the characteristics after the first fine screening step and the second fine screening step based on logistic regression to see whether the characteristic coefficients are consistent with the trend of the prediction results for credit default so as to further perform feature screening.
[0265] 48. A method according to any one of items 39 to 47, wherein the credit default probability modeling step substitutes the features screened in the feature fine screening step into the Sigmoid function to perform logistic regression to calculate the credit default probability model.
[0266] 49. A device for constructing a retail credit risk prediction model for credit card and special installment business, characterized in that the device comprises:
[0267] A data collection module, which is used to obtain raw retail credit prediction data of samples used to build a model;
[0268] A data derivation module, which is used to process derived retail credit forecast data based on the original retail credit forecast data;
[0269] A feature initial screening module, which is used to perform initial screening on all categories, that is, all features, including the original retail credit forecast data and the derived retail credit forecast data, to obtain features after initial screening;
[0270] The initial screening data conversion module is used to determine the conversion method of the features after the initial screening to confirm whether to use one of the WOE conversion method, the dummy feature conversion method and the continuous conversion method for feature conversion, and to use the best method for feature conversion for each feature after the initial screening;
[0271] A feature fine screening module is used to perform in-depth screening on the initially screened features after feature conversion to obtain finely screened features;
[0272] The credit default probability modeling module is used to select the logistic regression method to build a model based on the probability relationship between the finely screened features and credit default, and confirm the method used to calculate the credit default probability.
[0273] The data samples obtained by the data collection module are customer samples who have used credit cards and special installment services.
[0274] 50. An apparatus according to item 49, wherein the apparatus executes the steps of the method for constructing a retail credit risk prediction model described in any one of items 29 to 38.
[0275] 51. A system for constructing a retail credit risk prediction model for credit cards and special installment services, characterized in that the system comprises: a memory, a processor, and a program for constructing a retail credit risk prediction model method stored in the memory and executable on the processor, wherein the program for constructing a retail credit risk prediction model method, when executed by the processor, implements the steps of constructing a retail credit risk prediction model method as described in any one of items 39 to 48.
[0276] Effects of the Invention
[0277] The method and system for constructing a retail credit risk prediction model in this application combines a large number of samples from a large financial institution when constructing the model, and screens customer data with credit cards and special installment businesses from them, and deeply processes and derives the original data obtained from the samples. It uses advanced statistical analysis methods and explainable machine learning technology to construct a general scoring model for retail credit based on the characteristics of the original data and derived data and the strong financial attribute information contained in the data that is difficult to obtain on the market.
[0278] In addition, this application uses the decision tree method to classify samples in the most reasonable way at the beginning of model construction and builds a sub-classification model based on the classified samples. Combining decision trees to build financial models can effectively classify samples according to executable categories, thereby better covering the credit risk characteristics of different customer groups and avoiding the problem of using all samples to build models, resulting in the model lacking sub-group representativeness.
[0279] Furthermore, when constructing the risk prediction model in this application, the overall efficiency of model development is fully improved by using the stepwise discriminant analysis method for the preliminary screening of model features. The stepwise discriminant method can better select more important feature variables under the same dimension, greatly reducing the workload of developers in the next step who need to judge and screen one by one according to the trend of the variables, and fully improving the efficiency of model development without affecting the overall model effect, making the initial screening of variables more efficient and accurate.
[0280] This application innovatively combines continuous conversion, WOE conversion, and dummy feature conversion when building a model, reprocesses some features that have passed the initial screening, combines the advantages and disadvantages of the three conversion methods, and creatively designs a conversion judgment method. According to parameters such as feature data attributes, missing rate, concentration, etc., supplemented by business logic judgment, the optimal feature conversion method is selected. Through such a model building method, it is possible to avoid the technical shortcomings of overfitting when building a model with complete WOE variables and the inability to adapt to categorical variables when building a model with complete continuous variables.
[0281] In addition, the method and system for calculating credit risk probability or scoring credit risk constructed by the present application, namely the Scorealpha2d model (Scorealpha2d series scoring cards) (including Scorealpha2d-1 to Scorealpha2d-5 sub-models or sub-scoring cards), because its model is first split based on the decision tree when it is constructed, so when the credit risk is calculated, the customer sample is initially effectively classified and the most suitable sub-model or sub-scoring card is selected for processing. At the same time, because the model construction method used in the sub-model or sub-scoring card is the method described in the present application, the construction process also avoids the technical shortcomings of overfitting when constructing a model with complete WOE variables and the inability to adapt to categorical variables when constructing a model with complete continuous variables. Therefore, it has a significantly better effect than existing models in predicting credit risk. In addition, since this application is aimed at credit cards and special installment businesses, the sample data is customer data of online credit businesses screened out from massive bank data. It not only covers the predictive variables of credit cards and special installment businesses, but also includes the overdue performance data of credit cards and special businesses. Therefore, the risk rules extracted from specific business scenario data using statistical principles have very significant adaptability and distinctiveness in terms of credit risks of credit cards and special installment businesses. BRIEF DESCRIPTION OF THE DRAWINGS
[0282] The accompanying drawings are used to better understand the present application and do not constitute an improper limitation on the present application.
[0283] Figure 1 This is a schematic diagram of the KS curve with a KS value of 58.
[0284] Figure 2 A typical flow chart for classifying all users in a sample based on a decision tree is shown.
[0285] Figure 3 An example of binning to confirm whether the data conforms to business trends is shown. DETAILED DESCRIPTION
[0286] The following is a description of the exemplary embodiments of the present application, including various details of the embodiments of the present application to facilitate understanding, which should be considered as merely exemplary. Therefore, it should be recognized by those of ordinary skill in the art that various changes and modifications can be made to the embodiments described herein without departing from the scope and spirit of the present application. Similarly, for clarity and conciseness, the description of well-known functions and structures is omitted in the following description.
[0287] Credit risk is the risk caused by the borrower's reduced willingness to repay or inability to perform the loan contract due to changes in economic ability, rather than the risk of default caused by the borrower's deliberate fraud. Credit default occurs in all kinds of retail credit business scenarios, and is particularly related to the borrower's personal economic situation. The reasons for borrowers' credit defaults can be divided into four categories: 1. Short credit history, such borrowers have little experience in financial management; 2. Borrowers temporarily forget to repay; 3. Over-borrowing, such borrowers have relatively low repayment ability due to a large amount of debt; 4. Affected by major negative factors, such borrowers have long-term impacts on their repayment ability due to major factors such as reduced income, unemployment or divorce. The above different reasons will more or less cause borrowers to default, which may lead to more serious defaults. The purpose of credit risk scoring is to dig out the inherent mathematical relationship between various historical information of customers and the probability of future default, and convert it into a scoring method to quantify the probability of default.
[0288] At present, the credit risk scoring in the existing technology is mainly developed using credit history data and multiple data (multiple data refers to the statistical data of borrowers' behavior of applying for loans from multiple financial institutions. It is generally believed that the greater the number of multiple times in a short period of time, the greater the probability of future overdue payments), which reflects their payment behavior and willingness to pay. The sample data used to build the model in this application includes the borrower's credit card application and behavior-related data, which can be used in combination with traditional credit risk scoring to conduct a more comprehensive measurement of the borrower's debt repayment ability, personal qualifications, etc., thereby providing more accurate prediction results.
[0289] <Overall description of model building method>
[0290] Specifically, the present application relates to a method for constructing a retail credit risk prediction model for credit cards and special installment businesses, which includes: a data collection step, which obtains the original retail credit prediction data of the sample used to build the model; a data derivation step, which processes the derived retail credit prediction data based on the original retail credit prediction data; a feature initial screening step, which performs preliminary screening on all categories including the original retail credit prediction data and the derived retail credit prediction data, that is, all features, to obtain the features after the preliminary screening; a preliminary screening data conversion step, which determines the conversion method of the features after the preliminary screening to confirm that one of the WOE conversion method, the dummy feature conversion method and the continuous conversion method is used for feature conversion, and the best method is used for feature conversion for each feature after the preliminary screening; a feature fine screening step, which performs in-depth screening on the features after the preliminary screening after feature conversion to obtain the finely screened features; a credit default probability modeling step, which selects the logistic regression method for model construction based on the finely screened features combined with the probability relationship between the features and the credit default, and confirms the method for calculating the credit default probability.
[0291] In a specific manner, the method for constructing a retail credit risk prediction model for credit cards and special installment businesses involved in this application may also include a sample selection step before the data collection step, which is used to screen all users before the data collection step to obtain samples for model construction. Those skilled in the art understand that based on the total number and data of users who can build the model, those skilled in the art can choose whether to eliminate user data that does not meet the requirements for building the model. In addition, those skilled in the art can also first select some users as samples, and then continuously increase the samples for modeling according to the corresponding rules.
[0292] In a specific implementation, the selected samples are samples of customers who apply for credit card and special installment business among the customer samples who apply for credit business registration within a certain period of time.
[0293] <Sample selection steps>
[0294] In a specific implementation, the sample selection step is to screen all users before the data collection step to obtain samples for model construction. Specifically, the sample selection step includes classifying all sample users based on a decision tree, and the classification basis includes but is not limited to: whether a certain user is a customer who has applied for a credit business; a certain user has applied for registration within M months; whether a certain user's credit business has been overdue in the past 6 months; whether a certain user's average credit card repayment rate in the past 3 months is less than N.
[0295] Furthermore, all sample users are classified based on the decision tree to better construct the sub-model.
[0296] Since performance variables are required for modeling, the analysis samples are further divided into whether or not the users have applied for registration for credit business at the relevant bank. That is, users can be divided into those who have applied for registration and those who have not.
[0297] Credit business is a basic and important asset business of banks. It recovers the principal and interest by issuing bank loans and obtains profits after deducting costs. Generally speaking, bank credit business is an important means for banks to make profits. From the classification of bank credit business, it can be divided into corporate credit business and personal credit business. Among them, corporate credit business includes project loans, working capital loans, small business loans, real estate enterprise loans, etc.; personal credit business includes personal housing loans, personal consumption loans, personal business loans, etc.
[0298] Credit card business is the most important credit business of commercial banks. It can create huge profits and revenues for banks. It is also the most convenient and frequently used credit product by retail customers.
[0299] A decision tree is a decision analysis method that uses a decision tree to obtain the probability that the expected value of the net present value is greater than or equal to zero, evaluate project risks, and judge its feasibility based on the known probabilities of various situations. It is a graphical method that intuitively uses probability analysis. When constructing a model, this application uses a decision tree to classify samples used for modeling based on the characteristics of data from large financial institutions. After distinguishing between samples that have applied for credit business and samples that have not applied for credit business, it can further classify whether the samples that have applied for credit business are new customers, and classify the samples that have applied for credit business into two categories: new customers and existing customers. The decision on whether a customer is a new customer can be determined based on the needs of technical personnel in this field. For example, users who have applied for credit business within M months are decided to be new customers, and customers who have applied for credit business for more than M months are existing customers or non-new customers.
[0300] In a specific implementation, M may be set to, for example, 3, 6, 9 or 12. In the present application, M may also be referred to as account age.
[0301] It is also possible to further classify customers based on their overdue situation, and classify existing customers who have applied for credit services into two categories: customers whose credit business overdue number in the past 6 months is 0 (i.e., currently non-overdue customers) and customers whose overdue number in the past 6 months is not 0 (i.e., currently overdue customers).
[0302] The current non-overdue customers can also be further classified based on their repayment status. For example, customers whose average credit card repayment rate in the past three months is less than N are under-repayment customers, while customers whose average credit card repayment rate in the past three months is greater than or equal to N are full-repayment customers.
[0303] In a specific embodiment, N may be set to, for example, 90%, for example, 85%, for example, 80%.
[0304] Those skilled in the art can fully understand that other splitting methods can also be selected when performing sample splitting, and the customer sample splitting method when building a model can be considered and performed entirely according to the needs of modeling.
[0305] In the process of building the model for this application, since it is necessary to build models for credit cards and special installment businesses, the selected samples are customer samples who have credit cards and special installment businesses within a certain period of time.
[0306] In a specific implementation, 110 million customers with credit cards and special installment businesses are selected from 130 million customers with a certain credit business as the modeling sample. Such samples are more targeted and representative when predicting the credit risk of credit cards and special installment businesses.
[0307] <Original Retail Credit Forecast Data>
[0308] When constructing the model for this application, firstly, based on the basic data of financial institutions, about 120 types of original retail credit prediction data (i.e. more than 120 basic features) can be obtained, and the retail credit risk points are split or processed as much as possible according to different dimensions under the premise of optimal effect, generating more than 3,000 derivative features in total.
[0309] When constructing the model, first of all, based on all historical data of financial institutions, the credit card application and behavior data, personal loan application and behavior data, personal financial asset transaction data and personal customer information data of all retail customers in the past four years were initially collected when constructing the model of this application, totaling 730 million people, of which each person has corresponding data to be processed every month. It can be seen that the data system used to construct the model of this application is comprehensive and the data volume is very large. When constructing a model based on such a data system, it is necessary to consider the modeling methodology, otherwise it will be trapped in the huge data, resulting in the special sample groups that need to be paid attention to being covered in the huge data volume and unable to be effectively identified, causing the computer program to run slowly or even unable to run, so that the most suitable prediction model cannot be accurately constructed.
[0310] In the data collection step, the original retail credit prediction data of the sample obtained for building the model include: basic data of credit cards, which are all available data based on the sample's credit card creation process and use process (i.e., retail customers' credit card application and behavior data); basic data of personal loans, which are all available data based on the sample's loan application and usage behavior (i.e., personal loan application and behavior data); basic data of basic customer information, which are data based on the attributes of the sample itself but not directly related to the behavior in the financial institution (i.e., personal customer information data); or basic data of personal financial assets, which are all other financial assets and financial transaction data of the sample in the financial institution that are not related to credit cards and loans (personal financial asset transaction data).
[0311] In a specific implementation, the basic data of credit cards include, but are not limited to: credit card bills, credit card cash withdrawals, credit card installments, interest generated by credit cards, and other information such as accounts, overdue, balances, credit limits, due payments, and actual payments under different dimensions (e.g., time dimension, space dimension, and frequency dimension). The above basic data is not limited to the specific categories listed. With the changes in the credit card business, those skilled in the art can further cover new data types in implementation, that is, all types of data that can be obtained during the user's credit card creation and use process can be used as basic data of credit cards.
[0312] In a specific implementation, basic data of personal loans include but are not limited to: personal loan accounts, overdue personal loans, balances of personal loans, total amount of personal loans, repayments due and actual repayments of personal loans, etc. The above basic data are not limited to the specific categories listed. With the changes in personal loan business, those skilled in the art can further cover new data types in implementation, that is, all types of data that can be obtained based on the user's loan application and behavior can be used as basic data of personal loans.
[0313] In a specific implementation, according to the requirements of the Personal Privacy Protection Act, the basic data of the basic information category of customers only includes: basic information of customers, including gender, age and administrative region information of the business. The above basic data is not limited to the specific categories listed. With the development of customer conditions and social relations, technical personnel in this field can also further cover other or emerging data types in the implementation within the scope of the business application scenario, that is, all types of data based on the attributes of the user sample itself but not directly related to the behavior in the financial institution can be used as basic data of the basic information category of customers.
[0314] In a specific implementation, basic data of personal financial assets include but are not limited to: AUM (i.e., asset management scale), deposits, financial management, and payroll information. The above basic data are not limited to the specific categories listed. With the changes in financial assets, those skilled in the art can also further cover new data types in implementation, that is, all other financial assets and financial transaction data that are not related to credit cards and loans in financial institutions based on samples can be used as basic data of personal financial assets.
[0315] In a specific embodiment, the original retail credit prediction data of the samples obtained for building the model are based on more than 120 data types (i.e., basic variables or basic features) obtained from 730 million people, including but not limited to: credit card bills, credit card withdrawals, credit card installments, interest generated by credit cards, and other accounts, overdue, balances, amounts, due and actual repayments under different dimensions (e.g., time dimension, space dimension, frequency dimension); personal loan accounts, overdue personal loan status, personal loan balances, total amount of personal loans, due and actual repayments of personal loans; basic customer information including gender, age and administrative region to which the business belongs; basic information such as AUM (i.e., asset management scale), deposits, wealth management and payroll payment.
[0316] <Derived Retail Credit Forecast Data>
[0317] In the present application, in the data derivation step, the derived retail credit prediction data processed based on the original retail credit prediction data refers to the data obtained by processing the collected original retail credit prediction data based on the time dimension, space dimension, frequency dimension, and statistical information dimension.
[0318] In a specific embodiment, the derived retail credit prediction data includes, but is not limited to: derived retail credit prediction data obtained by processing based on the sample relationship length, derived retail credit prediction data obtained by processing based on time interval variables, derived retail credit prediction data obtained by processing based on the frequency of sample behavior, derived retail credit prediction data obtained by processing based on the current time point of the sample, derived retail credit prediction data obtained by processing based on the continuous behavior of the sample, or derived retail credit prediction data obtained by processing sample data based on statistical information dimensions. For example, the monthly data of the customer can be obtained and processed based on the monthly data. In this application, processing based on statistical information dimensions includes obtaining the maximum value, minimum value, average value, etc. of the data to describe the data situation.
[0319] In a specific implementation, for example, starting from the time dimension, such as customer relationship length variables: such as the customer account opening time, customer maximum account age, etc. are used as types of derived retail credit prediction data, that is, as derived features or derived variables.
[0320] In a specific implementation, for example, starting from the time dimension, time intervals are considered, such as the number of months from the customer's most recent repayment to the current time point, the number of months from the customer's most recent overdue payment to the current time point, etc. as derived features or derived variables.
[0321] In a specific implementation, for example, starting from the frequency level, the behavior frequency level variable is considered: such as the number of times the customer has repaid > N in the last X months, the number of times the customer's credit limit utilization rate > N in the last X months, etc. as derived features or derived variables. There is no limit on X and N, and they can be any positive integer greater than 0 as long as the business logic is reasonable.
[0322] In a specific implementation, for example, starting from the time dimension, the current point in time variables are considered: the customer's current monthly credit limit, the customer's current monthly balance, etc. as derived features or derived variables.
[0323] In a specific approach, starting from the time dimension, continuous behavior variables are considered as derived features or derived variables, such as the maximum number of consecutive overdue payments of a customer > N in the last X months, the number of consecutive repayment rates of a customer > N in the last X months, etc.
[0324] In a specific method, starting from the dimension of statistical information, statistical variables are considered, such as the maximum number of overdue payments of a customer in the last X months, the average credit limit utilization rate of a customer in the last X months, etc. as derived features or derived variables.
[0325] It is clear to those skilled in the art that the above methods for processing derived variables are merely enumerated and can be selected arbitrarily. For example, 120 types of basic data can be processed into more than 3,000 derived data. In this application, data, data types, data types, variables or features are sometimes mixed, and those skilled in the art can understand them based on common sense in statistics.
[0326] In this application, the derivative data can be derived data obtained by simple processing of the original retail credit forecast data, or it can be derived data obtained by complex processing. The simply processed derivative data, such as the current variables such as the salary of the current month and the balance of the current month, can be used directly after the data is aggregated. The complex processed derivative data needs to be based on the variables of the current class based on time slicing and logical processing, and can generate derivative variables such as the maximum salary in the past 3 months and the minimum balance in the past 12 months.
[0327] <Preliminary feature screening>
[0328] In the initial screening data conversion step of the present application, the judgment of the conversion method of the features after the initial screening is based on the concentration and data type of the features after the initial screening. The initial screening data conversion step includes the following steps based on the judgment of the concentration and data type: classify each feature into character variables and numerical variables according to the data type of each feature, use the dummy feature conversion method to perform initial screening data conversion on the character variables, and further classify the numerical variables. The process includes the following sub-steps: if the value of the numerical variable is less than n, use the WOE conversion method to perform initial screening data conversion, if the value of the numerical variable is more than n, further judge if the value of the continuous variable is more and the concentration of the single value is greater than m%, then use the WOE conversion method, if the concentration of the single value is less than or equal to m%, then use the continuous conversion method, preferably, n and m are both positive integers, where n = 5 to 10, m = 90 to 99.
[0329] For example, n is 5, 6, 7, 8, 9 or 10, and m is 90, 91, 92, 93, 94, 95, 96, 97, 98 or 99.
[0330] Specifically, in this application, a variety of different feature initial screening methods are used to screen a large number of features, so that the screening can be effectively performed from the largest dimension of features. Existing credit risk scoring often uses missing rate, concentration and information value IV for feature initial screening.
[0331] In a specific method, features are screened based on the data missingness of each feature of the sample used to build the model. When screening the missing rate, it is generally considered to delete variables with a missing rate greater than 90%, 91%, 92%, 93%, 94%, or 95%. For example, features with a data missing rate exceeding 95% can be eliminated, and features with a data missing rate exceeding 90% can also be eliminated.
[0332] In a specific method, features are screened based on the fact that a single value of a feature sample is too high. When screening by concentration, it is generally considered to delete variables whose single values account for more than 99%, 98%, 97%, 96%, or 95%. For example, features whose single values exceed 99% can be eliminated, and features whose single values exceed 95% can also be eliminated.
[0333] In a specific method, the information IV value of each feature is calculated to perform preliminary screening of the features. During IV screening, the IV value can be used to measure the predictive power of the feature. The larger the IV value, the stronger the predictive power of the feature. The calculation method of the IV value of a single feature is as follows:
[0334]
[0335] Where k is the number of groups after this feature is discretized; y i is the number of non-defaulting customers in group i; s is the total number of customers who have not defaulted; n i is the total number of defaulting customers in group i; n s The quantitative index of IV has the following meanings: when the calculated value of IV is less than 0.02, it means that the predictive power of this feature is very weak; when the calculated value of IV is above 0.02 and below 0.1, it means that the predictive power of this feature is weak; when the calculated value of IV is above 0.1 and below 0.3, it means that the predictive power of this feature is good; when the calculated value of IV is above 0.3, it means that the predictive power of this feature is strong.
[0336] Of course, the IV calculated value deletion threshold may also be set to 0.03, 0.04, 0.05, etc.
[0337] In the model building method of the present application, the step of using missing rate, concentration and information value IV for feature initial screening can be performed in any order, for example, the screening can be performed based on the missing rate first, then based on the concentration, and finally based on the information value IV for feature initial screening. It is also possible to first screen based on the concentration, then screen based on the missing rate, and finally based on the information value IV for feature initial screening. It is also possible to first screen based on the missing rate, then screen based on the information value IV, and finally based on the concentration for feature initial screening. It is also possible to first screen based on the information value IV, then screen based on the missing rate, and finally based on the concentration for feature initial screening. It is also possible to first screen based on the information value IV, then screen based on the missing rate, and finally based on the concentration for feature initial screening. It is also possible to first screen based on the information value IV, then screen based on the concentration, and finally based on the missing rate for feature initial screening. It is also possible to first screen based on the concentration, then screen based on the information value IV, and finally based on the missing rate for feature initial screening. Those skilled in the art can make a choice based on the data situation of the sample, so based on these three methods, features with obvious defects in one aspect can be effectively removed, which can effectively reduce the data dimension and improve the effect of model building.
[0338] In one specific method, after the features have been screened using missing rate, concentration and information value IV respectively, a stepwise discriminant algorithm is used to perform preliminary screening of the features, and then preliminary screening of the features is performed based on the consistency between the risk characteristics of each feature itself and the actual real results of the samples used to build the model.
[0339] On this basis, the technical solution of the present application introduces a stepwise discriminant method to make the initial screening of variables more efficient and accurate in order to improve the overall efficiency of model development. In actual data, there may be a close distribution of good and bad samples on a certain variable, and the ability to distinguish between good and bad is weak. There may also be a class of variables, each of which can distinguish good and bad samples well, but if all are included in the model, they will be redundant due to the duplication of data dimensions covered by the variables. In this regard, a stepwise discriminant analysis method is used in this application, and WILKS'S LAMBDA value is used as the statistical criterion for entry and removal, and variables with weak or redundant discriminant effects in the data are deleted.
[0340] The stepwise discrimination method uses the WILKS'S LAMBDA criterion to measure the strength of feature capabilities and eliminates features that do not meet the set threshold among the remaining features after three rounds of screening. In the stepwise discrimination process, the variable with the strongest discriminant ability is added first. As the variables in the model gradually increase, the discriminant ability of the variables introduced earlier may also change. If the discriminant ability of a variable in the model is less than the threshold, the variable is removed, and then the process is repeated until the variables contained in the model meet the WILKS'S LAMBDA similarity ratio criterion and other variables do not meet the criteria for entering the model.
[0341] In this application, the step of screening using the stepwise discriminant method is a more critical step. For the purpose of capturing as many credit risk points as possible, the model involved in this application uses a huge amount of data and many data dimensions, so variable screening must be performed to further reduce the time cost of model development. In the existing financial risk model evaluation, the variable importance method is generally used to reduce variables, such as calculating the importance of variables through algorithms such as the Gini index and information entropy, and selecting variables with high importance. The modeling method of screening using the stepwise discriminant method is rarely used. Compared with the variable importance screening scheme commonly used in the industry, the methodology used in this application can retain a large number of variables with relatively weak importance but relatively independent information dimensions.
[0342] In a specific way, more than 3,000 derivative data can be processed based on, for example, 120 types of basic data. After three rounds of screening of missing rate, concentration and information value IV, about 20-30% of the features with poor data can be deleted, but more than 2,000 features will still be retained. If subsequent variable fine screening is performed based on all the above features, it will seriously affect the development efficiency. Therefore, after comparing and testing a variety of different variable deletion schemes, it was finally determined that stepwise discrimination was the best choice.
[0343] For the important features selected by the stepwise discrimination algorithm, further feature selection is performed based on the risk characteristics of each risk point itself (system preset) and the actual bad debt rate of the sample. Determine whether the actual bad debt rate distribution of the remaining features is consistent with the business trend, and eliminate the features whose actual bad debt rate distribution does not conform to the business trend. Specifically, (1) Divide the remaining target features into 10-20 boxes according to the quantile points, and calculate the median value of each box and the corresponding bad debt rate. (2) Use the median value of each box and the previous box and the corresponding bad debt rate to calculate the rate of change (slope). (3) Count the number of boxes greater than 0 and non-0 boxes (non-greater than 0 boxes) in the rate of change between two adjacent boxes, and calculate the percentage of the number of boxes greater than 0 in the rate of change to the number of non-0 boxes in the rate of change. (4) Obtain the risk characteristics preset for this feature, and based on the percentage of the number of boxes greater than 0 in the rate of change to the number of non-0 boxes in the rate of change, check whether the actual bad debt rate change trend is approximately consistent with the business logic bad debt rate change trend. The criteria for whether they are approximately consistent are as follows: First, if the business logic trend of this feature should be: as the value of this feature increases, the bad debt rate increases (such as the credit line utilization rate, etc.). In this module, the features whose number of boxes greater than 0 in the above calculated slope accounts for less than 70% of the number of boxes with a slope other than 0 are eliminated, that is, the features whose feature performance does not conform to the business trend are eliminated. Second, if the business logic trend of this feature should be: as the value of this feature increases, the bad debt rate decreases (such as the deposit amount, etc.). In this module, the features whose number of boxes greater than 0 in the above calculated slope accounts for more than 30% of the number of boxes with a slope other than 0 are eliminated, that is, the features whose feature performance does not conform to the business trend are eliminated.
[0344] For example, the following table gives an example of binning. In this example, the feature values are divided into 10 bins. The value ranges of the bins are also summarized in the following table. At the same time, based on the data in the following table, a graph of the bad debt rate of the feature bins versus the median of the feature bins is drawn, as shown in the following figure: Figure 3 As shown. Figure 3 In the example, there are 7 with slopes greater than 0 and 2 with slopes less than 0. Through the above method, the features can be further screened based on the risk characteristics of each risk point itself (system preset) and the actual bad debt rate of the sample. By further screening features using such a binning method, the features that best match the business development trend can be effectively screened out, thereby further obtaining features suitable for modeling.
[0345]
[0346] <Conversion of eigenvalues>
[0347] The initial feature processing of existing credit risk scoring methods mainly uses WOE conversion (multi-classification) and dummy feature conversion (binary classification) to discretize continuous features (such as age, account age, etc.). The WOE conversion method is an optimal binning scheme based on modeling samples. It discretizes continuous features according to the optimal cutting point and embeds the data of good and bad samples into the WOE value. Therefore, it performs better in model construction, but the binning results may overfit the modeling samples, resulting in a serious decline in model effect when applied to the whole (poor generalization ability). At the same time, due to the normalization operation used in binning, the original features falling into different bins are converted into a single value corresponding to each bin, thus losing the ability to distinguish the risks of people falling into the same interval. The dummy feature conversion method is mainly applied to grouping features. Its advantage is that it can eliminate the difference between good and bad values of different feature values, but it will become extremely complex and redundant when processing continuous variables.
[0348] In the model building method of the present application, the conversion method of the features after preliminary screening is judged to confirm whether to use one of the WOE conversion method, the dummy feature conversion method and the continuous conversion method for feature conversion, and the optimal method is used to perform feature conversion for each feature after preliminary screening.
[0349] The initial screening data conversion step includes the following steps based on the judgment of concentration and data type: classifying each feature into character variables and numeric variables according to the data type of each feature, using dummy feature conversion method to perform initial screening data conversion on character variables, and further classifying the numeric variables includes the following sub-steps: if the value of the numeric variable is less than n, the WOE conversion method is used for initial screening data conversion; if the value of the numeric variable is more than n, further judging that if the value converted to a continuous variable is large and the concentration of a single value is greater than m%, the WOE conversion method is used; if the concentration of a single value is less than or equal to m%, a continuous conversion method is used; preferably, n and m are both positive integers, wherein n=5-10, m=90-99.
[0350] Specifically, taking the character variable as education level, the value of this feature variable can be primary school, middle school, university, graduate school, etc. For numeric variables, if the numeric variable is the number of overdue months in the past three months, the value is 0, 1, 2, 3.
[0351] In the present application, the above n can be 5, 6, 7, 8, 9 or 10, and m can be 90, 91, 92, 93, 94, 95, 96, 97, 98 or 99.
[0352] In a specific implementation, m is selected as 5 and n is selected as 95.
[0353] Specifically, the WOE conversion method is: find the optimal cutting point of the feature, divide the value range of the original feature into multiple bins, calculate the WOE conversion value corresponding to each bin after segmentation according to the good or bad situation in each bin and output it, divide the original feature according to the binning result and output the WOE conversion value. For each bin, the WOE value is calculated as follows:
[0354]
[0355] where y i is the number of non-defaulting customers in group i; s is the total number of customers who have not defaulted; n i is the total number of defaulting customers in group i; n s is the total number of defaulting customers.
[0356] Let's take age as an example to introduce the WOE binning process. The original feature age includes values from 18 to 50 years old. After binning, 5 bins are obtained, namely 18 to 24 years old, 25 to 30 years old, 31 to 35 years old, 36 to 42 years old, and 43 to 50 years old. Then, the WOE conversion value of each bin is calculated according to the number of good and bad customers in each bin. Finally, each user data in each bin is output according to the corresponding conversion value of each bin. For example, 23 years old outputs the WOE conversion value corresponding to the 18 to 24 bins, and 46 years old outputs the WOE conversion value corresponding to the 43 to 50 bins.
[0357] The conversion method of dummy features is: if the original feature has m mutually exclusive attribute types, it is converted into (m-1) dummy features. If a customer belongs to the corresponding value of the generated dummy feature, the corresponding dummy feature value is 1, and the remaining dummy feature values are 0.
[0358] Taking gender as an example, we will introduce the method of dummy feature conversion. The original features include: male, female. After dummy feature conversion, a dummy feature "gender-male" is generated. If the customer's gender is male, it is recorded as 1 in "gender-male"; if the customer's gender is female, it is recorded as 0 in "gender-male". If we take education as an example, the original features include: college degree or below, bachelor's degree, master's degree or above. After dummy feature conversion, two dummy features "education-bachelor's degree" and "education-master's degree or above" are generated. If the customer's education level is bachelor's degree, it is recorded as 1 in "education-bachelor's degree" and 0 in "education-master's degree or above"; if the customer's education level is master's degree or above, it is recorded as 0 in "education-bachelor's degree" and 1 in "education-master's degree or above"; if the customer's education level is junior college or below, it is recorded as 0 in "education-bachelor's degree" and 0 in "education-master's degree or above".
[0359] The continuous conversion method is: perform a variety of continuous conversions on the original features (continuous conversion methods include but are not limited to: directly selecting the original value, calculating the square of the original data, calculating the square root of the original data, calculating the cube root of the original data, and calculating the natural logarithm of the original data). Calculate the correlation coefficient r (Correlation Coefficient) between the feature value and the overdue label after continuous conversion, select the conversion method with the largest absolute value of the correlation coefficient, and output the conversion method corresponding to the original feature. The calculation formula of the correlation coefficient is as follows:
[0360]
[0361] Where Σ is the summation symbol in mathematics; n is the total number of observations; x i is the conversion value of the original feature of the i-th observation after continuous conversion; This is the average of the transformed values; where y i is a binary feature indicating whether the i-th observation is in default; It is the average value of this binary feature. The closer the absolute value of the correlation coefficient is to 1, the more relevant the converted value is to the default situation, and the better the effect of this conversion method. The quantitative index of the correlation coefficient r has the following meanings: when the absolute value of the correlation coefficient is above 0 and less than 0.3, it indicates a low correlation; when the absolute value of the correlation coefficient is above 0.3 and less than 0.8, it indicates a moderate correlation; when the absolute value of the correlation coefficient is above 0.8 and less than 1, it indicates a high correlation.
[0362] In the model construction of the present application, for the features that are confirmed to adopt a continuous conversion method, the optimal conversion method is selected to perform continuous feature conversion of the feature based on the correlation of the feature with credit default under different continuous conversion methods. Preferably, the continuous feature conversion is performed by directly selecting the original value, calculating the square of the original data, calculating the square root of the original data, calculating the cube root of the original data, or calculating the natural logarithm of the original data.
[0363] Take age as an example to introduce the continuous conversion method. The original feature age contains values from 18 to 50 years old. The continuous conversion obtains the original value, square, square root, cube root, natural logarithm, etc. of age, and then calculates the WOE value and the absolute value of the correlation coefficient between each conversion value and the good or bad label (prediction result). The conversion method with the largest absolute value of the correlation coefficient is selected for conversion and output. If the cube root of the age feature has the largest absolute value of the correlation coefficient with the good or bad label compared with other conversion methods, the cube root of age is output as the conversion value.
[0364] In the prior art solutions, one of the feature conversion methods, WOE and dummy features, is mainly selected for model construction. For example, in the Chinese patent CN112686749B, the WOE method is used to convert the feature values. The WOE conversion method is an optimal binning scheme based on the modeling sample. It discretizes the continuous features according to the optimal cutting point, so it performs better in model construction, but the binning results may overfit the modeling samples, resulting in a serious decrease in the model effect when applied to the whole (poor generalization ability). At the same time, due to the normalization operation used in the binning, the original features falling into different bins are converted into a single value corresponding to each bin, so the risk differentiation ability of people falling into the same interval is lost.
[0365] The conversion method of dummy features is mainly used for grouping features. Its advantage is that it can eliminate the difference between good and bad values of different feature values. For example, for the industry in which the customer is located, because there is no obvious advantage or disadvantage between the retail industry and the wholesale industry, it is more suitable to use the dummy feature processing method; there is a hierarchical difference between junior colleges and undergraduates, so although dummy features can be used, it is actually more appropriate to use the WOE processing method.
[0366] On the other hand, the continuous conversion method can avoid the overfitting of the modeling samples in the WOE conversion method, has a strong generalization ability for the overall sample, and because no interval mapping is performed, most customer groups rarely fall into a single value. However, it cannot be applied to some features with poor monotonicity or discrete characteristics (such as occupation, position, etc.).
[0367] As described above, the technical solution of the present application takes a different approach and creatively combines three methods: continuous conversion, WOE conversion, and dumb feature conversion. It reprocesses some carefully screened features, combines the advantages and disadvantages of the three conversion methods, and creatively designs a conversion judgment method. It selects the optimal feature conversion method based on parameters such as feature data attributes, missing rate, concentration, and business logic judgment.
[0368] <Logistic regression and deep feature screening based on logistic regression>
[0369] In existing credit risk scoring, due to the requirement of model interpretability, logistic regression model is mainly used for model development, and the software that can be used are generally: SAS, R, Python, etc.
[0370] In a specific embodiment, the present application develops models based on SAS software.
[0371] Specifically, the Sigmoid function is used in logistic regression to fit the probability of predicted default. The Sigmoid function is:
[0372]
[0373] Where Z is a linear combination of the model coefficients and the feature transformation values, and Z is defined as follows:
[0374] Z=α+β1x1+β2x2+...+β k-1 x k-1 +β k x k
[0375] The predicted probability of default is:
[0376] P=P(Y=1|x1,x2,x3,...,x k-1 ,x k )
[0377] The fitted prediction for the probability of default is:
[0378]
[0379] From the above formula we can further deduce:
[0380] Substituting the Z value into the above formula can calculate the probability P of predicted default.
[0381] The core of logistic regression model construction is feature screening. The steps of feature screening are as follows: First, batch screen the features according to missing rate, concentration and information value IV. Second, screen all remaining features one by one according to whether the features are in line with business trends, and retain the features with correct business trends. For example: if it is found that the bad debt rate of the customer group decreases with the increase of the characteristic loan balance, it is considered that this feature does not conform to the business trend. In the understanding of credit business, the higher the loan balance, the higher the customer's default risk exposure (EAD) level, and the greater the risk. At this time, this feature will be removed from the feature list. Third, use the stepwise regression function of logistic regression to eliminate the less important features that are highly correlated with other features. Fourth, filter the coefficients according to the positive and negative signs of the training coefficients and the business trend of the feature conversion value, and retain the features whose feature coefficient signs conform to the business logic. In the case where 0 is defined as a good customer and 1 is defined as a bad customer in the Y label, for a feature whose bad debt rate increases monotonically with the increase of the feature value (such as loan balance), the sign of its training coefficient should be positive; conversely, for a feature whose bad debt rate decreases monotonically with the increase of the feature value (such as deposit balance), the sign of its training coefficient should be negative. If it does not meet the above standards, it should be eliminated. Fifth, use variance inflation factor (VIF), correlation coefficient, etc. to further eliminate features with high correlation: for variance inflation factor, eliminate features with the highest VIF and greater than 4 one by one; for features with high correlation, eliminate features with low IV values in the feature group with the highest correlation coefficient and greater than 0.80 one by one. Sixth, use the population stability index (PSI) to eliminate features with large distribution differences at different time points, which lead to instability. For features with PSI>0.25, directly eliminate them, and for features with 0.25>PSI>0.1, carefully eliminate them according to the impact of eliminating this feature on the model's distinguishing ability.
[0382] This application strictly adheres to the above rules to screen features, ensuring the model's interpretability, stability, and ability to distinguish between good and bad customers.
[0383] The feature fine-screening steps of the present application include: a first fine-screening step, based on a stepwise regression algorithm, to screen features based on the F test and the T test for the significance of features; a second fine-screening step, to screen features based on calculating the variance inflation factor for each feature and eliminating features with higher variance inflation factors; a third fine-screening step, based on logistic regression, to analyze whether the feature coefficients of the features after the first fine-screening step and the second fine-screening step are in line with the trend of the prediction results for credit default so as to further perform feature screening.
[0384] Feature fine screening step 1, based on the stepwise regression algorithm, based on the F test and T test method, introduces features in order from high to low significance. Each time a feature is introduced, the selected features are tested one by one. When the originally introduced feature becomes no longer significant due to the introduction of the subsequent features, it is eliminated. This process is repeated until no features above the significance threshold are selected into the equation, and no features below the significance threshold are eliminated from the regression equation.
[0385] Feature fine-screening step 2 is based on the method of eliminating features with high variance inflation factors to further reduce multicollinearity in the model.
[0386] Feature fine screening step 3, based on the risk characteristics of each risk point itself (system preset) and the positive and negative signs of the model training coefficient, determines whether the feature coefficients of the remaining features in the model in the feature fine screening step 3 are consistent with the business trend, removes the features whose model coefficients do not meet the business trend, and iterates again. The specific implementation plan of feature fine screening module 3 is as follows: 1. For features whose feature conversion method is WOE type, the corresponding model training coefficient should be a negative value, and the WOE conversion type features with positive training coefficients should be eliminated. 2. For continuous conversion methods, if the value of this feature increases in business logic, the bad debt rate should increase (such as the credit line utilization rate, etc.), then the corresponding model training coefficient should be a positive value, and such continuous conversion type features with negative training coefficients should be eliminated; if the value of this feature increases in business logic, the bad debt rate should decrease (such as the deposit amount, etc.), then the corresponding model training coefficient should be a negative value, and such continuous conversion type features with positive training coefficients should be eliminated. 3. For the dummy feature conversion method, it is necessary to determine the bad debt rate when the value is 1 and the value is 0. If the bad debt rate when the value is 1 is greater than the bad debt rate when the value is 0, the coefficient should be positive, otherwise it should be negative.
[0387] Feature fine screening step 4, data stability monitoring step, is used to evaluate whether the distribution of individual features and overall scores at different time points has obvious deviations. In this embodiment, features with PSI>0.25 are directly eliminated, and features with 0.25>PSI>0.1 are carefully eliminated based on the impact of eliminating this feature on the model's distinguishing ability.
[0388] Based on the above steps 3 and 4, the feature list is iterated multiple times until no new features are added or removed from the model, and the iteration is stopped to obtain the final feature list and its conversion value. After the above steps, the input variables for constructing the model of this application can be finally obtained.
[0389] The credit default probability modeling step of the present application substitutes the features screened in the feature fine screening step into the Sigmoid function to perform logistic regression to calculate the credit default probability model.
[0390] In the prior art, the core of all scoring models built is whether the data they use is representative. For the existing scoring models in the prior art, due to information security and cost reasons, the sample size and bad labels of most models are small, and the stability of the model cannot be guaranteed, let alone independent modeling of a certain type of customer. At the same time, because the scoring models on the market can obtain information dimensions in the modeling process, mostly multi-loan data and weak financial attribute data (such as smart terminal device data, social platform data, online shopping mall data and other non-credit transaction data), it is impossible to accurately reflect the customer's asset status and repayment ability. The data source used in this application is the full business data of large banks, and the data volume of modeling samples and bad labels is very large. This application designs modeling samples based on different sample groups, which can more finely distinguish the risk differences between such customers, and at the same time ensure the stability of data and models based on cross-time verification and PSI verification. This application uses personal credit history data and asset data for model development, so it has a good reflection of the borrower's repayment willingness and repayment ability.
[0391] For some small and medium-sized financial institutions, the internally built scoring models are relatively small or started late in their retail credit business, and the accumulated historical data is insufficient to develop a credit risk model with stable data and strong differentiation ability. Therefore, they are highly dependent on manual approval when used for credit review business. The efficiency limitations of manual approval have restricted the development of their retail credit business. At the same time, the subjectivity of manual approval has increased the operational risks in the credit review process. The model constructed in this application can assist such financial institutions in making digital decisions, enhance their approval accuracy and speed, and reduce the above-mentioned adverse effects.
[0392] In terms of feature conversion, compared with the traditional WOE conversion method, it is necessary to roughly bin and discretize continuous features according to data performance and the experience of modelers. The results of rough binning are greatly affected by the subjective factors of modelers; and the process of discretizing continuous features may result in too many customers falling into the same interval, which leads to more single values of the calculated scores. This application combines the continuous conversion method, the WOE conversion method and the dummy feature conversion method to encode the original features, which reduces the impact of human factors and single values while enhancing the ability to distinguish scores.
[0393] <Methodology for calculating retail credit risk>
[0394] The present application further relates to a method for calculating the retail credit risk of a sample to be tested using the retail credit risk model constructed in the present application.
[0395] In this application, retail credit risk refers to the probability of credit default in the sample to be tested. In a specific way, the probability of credit default refers to the probability of credit default, specifically, for example, the probability of whether a credit default will occur for 90 days or more, for example, the discrimination and stability of credit default for 90 days or more in a certain customer group.
[0396] The present application relates to a method for calculating retail credit risk, which comprises: a data collection step, which obtains retail credit prediction data of samples to be predicted; a step of classifying the samples to be predicted, which classifies the samples to be predicted based on a decision tree method to determine a sub-model for calculating the probability of credit default; a step of calculating the probability of credit default, which substitutes the retail credit prediction data into the credit default probability sub-model to calculate the probability of credit default of the samples to be predicted.
[0397] In this application, the credit default probability covers the credit default probability of various types of credit services. In a specific implementation, the credit default probability is the credit default probability for credit cards and special installment services.
[0398] In the present application, the sample to be predicted may be a sample used to build a model, that is, when the model is built, the sample is already a customer of a certain financial institution holding a credit business (including but not limited to a credit card or personal loan business), and the method for calculating retail credit risk of the present application can be used to calculate its potential retail credit risk in the future. In the present application, the sample to be predicted may be a sample that is not used to build a model, that is, when the model is built, it is not a customer of a certain financial institution holding a credit business, but now it is a customer of a certain financial institution holding a credit business, and the method for calculating retail credit risk of the present application can be used to calculate its potential retail credit risk in the future. In the present application, the sample may also be a customer who was not and is not a customer of the financial institution holding a credit business when the model was built in the past, but is a customer of the financial institution that already holds other financial asset businesses, and the method for calculating retail credit risk of the present application can be used to calculate its potential retail credit risk in the future.
[0399] The present application relates to a method for calculating retail credit risk, which comprises: a data collection step, which obtains retail credit prediction data of samples to be predicted; a step of classifying the samples to be predicted, which classifies the samples to be predicted based on a decision tree method to determine a sub-model for calculating the credit default probability; a credit default probability calculation step, which substitutes the retail credit prediction data into the credit default probability sub-model to calculate the credit default probability of the samples to be predicted; and after calculating the credit default probability, a step of calculating the credit score of the samples to be predicted.
[0400] The step of calculating the credit score of the sample to be predicted is used to calibrate the calculated credit default probability to a standardized score of 0-1000 points.
[0401] In the method of the present application, the retail credit prediction data includes the original retail credit prediction data of the sample to be predicted and the derived retail credit prediction data processed based on the original retail credit prediction data, wherein the description of the original retail credit prediction data and the derived retail credit prediction data is consistent with the description of the model building part.
[0402] In this application, the step of classifying the sample to be predicted includes the following sub-steps:
[0403] Whether the sample to be tested is a customer who has applied for registration of credit business;
[0404] Whether the sample to be tested is a customer who has applied for registration within M months, where M is, for example, 3, 6, 9, or 12;
[0405] Whether the sample to be tested is a customer with zero overdue credit business in the past 6 months;
[0406] Whether the sample to be tested is a customer whose average credit card repayment rate in the past three months is less than N.
[0407] Based on the above sub-steps, the samples to be predicted are classified to determine the sub-model for calculating the probability of credit default, and the order of performing the above sub-steps can be set arbitrarily.
[0408] In this application, Figure 2 The flowchart for classifying the samples to be predicted is shown in Figure 1. Based on the classification in this step, the sub-model for calculating the probability of credit default can be selected. Figure 2 As shown, the samples to be predicted are classified in the following order: first, determine whether the sample to be tested is a customer who has applied for credit business registration; then determine whether the sample to be tested is a customer who has applied for registration within M months; then determine whether the sample to be tested is a customer whose credit business overdue number in the past 6 months is 0; finally, determine whether the sample to be tested is a customer whose average credit card repayment rate in the past 3 months is less than N. Using such step classification, the most suitable sub-model for predicting the sample to be tested can be confirmed.
[0409] In the present application, the retail credit prediction data is subjected to feature conversion and then substituted into the credit default probability sub-model to calculate the credit default probability of the sample to be predicted. The feature conversion step includes selecting the WOE method or the continuous method for feature conversion based on the feature type of the retail credit prediction data that needs to be substituted into the credit default probability sub-model.
[0410] The method of converting features in WOE mode or continuous mode is well known to those skilled in the art, and the specific conversion method can be referred to the description in the model construction section of this application. However, the existing models in the art only use WOE mode to convert parameters.
[0411] The WOE conversion method is an optimal binning scheme based on the modeling sample. It discretizes the continuous features according to the optimal cutting point. Therefore, it performs better in model construction, but the binning results may overfit the modeling sample, resulting in a serious decline in the model effect when applied to the overall population (poor generalization ability). At the same time, due to the normalization operation used in binning, the original features falling into different bins are converted into a single value corresponding to each bin, thus losing the ability to distinguish the risks of people falling into the same interval. The conversion method of dummy features is mainly applied to grouping features. Its advantage is that it can eliminate the difference between good and bad values of features. For example: for the industry in which the customer is located, because there is no obvious advantage or disadvantage between the retail industry and the wholesale industry, it is more suitable for the dummy feature processing method; there is a hierarchical difference between junior colleges and undergraduates, so although dummy features can be used, it is actually more appropriate to use the WOE processing method. The continuous conversion method can avoid the overfitting of the modeling sample in the WOE conversion method, and has a strong generalization ability for the overall sample. Since no interval mapping is performed, most customer groups rarely fall into a single value. However, it cannot be applied to some features with poor monotonicity or discreteness (such as occupations, positions, etc.). The present application uses a combination of continuous conversion and WOE conversion to process the initial features, combines the advantages and disadvantages of the two conversion methods, designs a conversion judgment module, and selects the optimal feature conversion method based on the parameters such as feature data attributes, missing rate, and concentration, supplemented by business logic judgment. The technical solution of the present application takes a different approach, creatively combining the three methods of continuous conversion, WOE conversion, and dummy feature conversion, reprocesses some carefully screened features, combines the advantages and disadvantages of the three conversion methods, and creatively designs a conversion judgment method, and selects the optimal feature conversion method based on the parameters such as feature data attributes, missing rate, and concentration, supplemented by business logic judgment. The feature conversion method determined in this way is then substituted into the model for calculating retail credit risk, which can more accurately predict the retail credit risk of the sample.
[0412] The sub-model used in the present application to calculate the probability of credit default is a model constructed based on sample retail credit prediction data and the probability of credit default using logistic regression based on an existing user population, that is, a model constructed using the method described in the present application.
[0413] <Device, system and computer storage medium for calculating retail credit risk>
[0414] The present application relates to a device for calculating retail credit risk, which includes: a data acquisition module, which is used to obtain retail credit prediction data of samples to be predicted; a module for classifying samples to be predicted, which is used to classify samples to be predicted based on a decision tree method to determine a sub-model for calculating credit default probability; a credit default probability calculation module, which is used to substitute the retail credit prediction data into the credit default probability sub-model to calculate the credit default probability of the samples to be predicted.
[0415] The device for calculating retail credit risk of the present application can execute the steps of the method for calculating retail credit risk of the present application.
[0416] The present application also relates to a system for calculating retail credit risk, characterized in that the system for calculating retail credit risk comprises: a memory, a processor, and a program for calculating retail credit risk stored in the memory and executable on the processor, wherein the program for calculating retail credit risk implements the steps of the method for calculating retail credit risk as described in the present application when executed by the processor.
[0417] The present application relates to a computer storage medium, characterized in that a program for a method for calculating retail credit risk is stored on the computer storage medium, and when the program for the method for calculating retail credit risk is executed by a processor, the steps of the method for calculating retail credit risk as described in the present application are implemented.
[0418] All the contents described above for the method for calculating retail credit risk can be fully applied to the device, system and computer storage medium for calculating retail credit risk.
[0419] The method for calculating retail credit risk in the present application can avoid the technical shortcomings of overfitting when building a model with complete WOE variables and the inability to adapt well to categorical variables when building a model with complete continuous variables. Therefore, when the model is used for retail credit risk calculation, it can better cover the retail credit risk prediction needs of various types of customer groups and meet the demand for obtaining more accurate prediction results when predicting credit risk as a general score.
[0420] Example
[0421] Example 1 Collection of modeling samples
[0422] In the process of constructing this embodiment, credit card application and behavior data, personal loan application and behavior data, personal financial asset transaction data, and personal customer information data of all retail customers of China Construction Bank between 2017 and 2021 were collected, totaling 730 million people. The modeling sample was confirmed through a professional model design scheme, and 620 million data in 2018 and 650 million data in 2019 were selected as analysis samples. Since performance variables are required for modeling and the performance period of credit cards and special installment businesses is relatively short, 2019 was selected as the observation period, and the 650 million analysis samples were divided into two parts: registered credit business and unregistered credit business, with sample sizes of 130 million and 520 million people respectively.
[0423] The specific Alpha2d model is a scenario scoring model for credit cards and special installment services. When designing the model, 110 million customers who have applied for credit cards and special installment services are analyzed and designed among the 130 million customers who have applied. After the model is developed and put online, the results will be applied to the total number of 730 million people who have applied and those who have not applied, or all other potential customer groups.
[0424] The model design includes 1) exclusion rules: such as excluding customer data that has been settled, closed, has no performance, or has special circumstances. After exclusion, the modeling population is 58.59 million customers; 2) time window setting: determine the sample to use 2019 data as the modeling sample, and use the next 15 months as the performance period of Y; 3) sample sampling: use a sample number of 10:1 for good / bad sampling modeling. Different segmentation schemes are designed through the decision tree method, and the parent-child model comparison method is used to confirm the final model segmentation plan, and then each segmentation model is modeled separately. The model segmentation scheme of this application is designed by dividing the customer into whether the customer has applied, whether the customer is a new customer, whether the credit business has been overdue in the past 6 months, and the average credit card repayment rate of the customer in the past 3 months. It fully reflects the control variables that are closely related to risk characteristics in the business process, and can more comprehensively match various customer groups in the market.
[0425] In this embodiment, the modeling samples are first divided into the following sub-samples based on the decision tree for the subsequent construction of sub-models. When determining the modeling samples, the first level of the decision tree makes a judgment based on whether the customer's account age is less than 3 (the customer has applied for a registered credit business but the application has not exceeded 3 months). If the account age is less than 3, the customer is classified as a new customer and is classified into the Alpha2d seg1 model. If the account age is greater than or equal to 3, it is further subdivided. In this embodiment, customers with an account age greater than or equal to 3 will be divided according to whether the customer's credit business has been overdue in the past 6 months. The customer group with overdue credit business in the past 6 months will be classified into the Alpha2dseg2 model, and the customer group with no overdue credit business in the past 6 months will be further subdivided.
[0426] For existing customers with an account age greater than or equal to 3 years and no overdue credit business in the past 6 months, they will be divided according to the average repayment rate of their credit cards in the past 3 months. If the average repayment rate of their credit cards in the past 3 months is <90%, this customer group will be classified as Alpha2d seg3, otherwise this customer group will be classified as Alpha2d seg4.
[0427] In addition, in this embodiment, in order to build a model for the sample group that has not applied for credit business registration, new customers with an account age of less than 3 months are selected from the overall sample as the approximate customer group and enter the Alpha2d seg5 segment for model training.
[0428] Specifically, the sample size of the sub-customer group used to build the Alpha2d seg1 segmentation model is about 430,000. The customer group is mainly new customers who have applied for credit business but the application has not exceeded 3 months. The model is used to predict the probability of credit arrears of more than 90 days in this group of people.
[0429] Specifically, the sample size of the sub-customer group used to build the Alpha2d seg2 segmentation model is about 450,000. The customer group mainly consists of existing customers who have applied for registered credit business for more than 3 months and have overdue credit business in the past 6 months. The model is used to predict the probability of their credit overdue for more than 90 days.
[0430] Specifically, the sample size of the sub-customer group used to build the Alpha2d seg3 segmentation model is about 4.46 million. Its customer base mainly consists of existing customers who have applied for registered credit business for more than 3 months, have no credit business overdue in the past 6 months, and have an average credit card repayment rate of less than 90% in the past 3 months. The model is built to predict the probability of credit overdue for more than 90 days in this group of people.
[0431] Specifically, the sample size of the sub-customer group used to build the Alpha2d seg4 segmentation model is about 53.25 million. Its customer base mainly consists of existing customers who have applied for registered credit business for more than 3 months, have no credit business overdue in the past 6 months, and have an average credit card repayment rate of more than 90% in the past 3 months. The model is built to predict the probability of credit overdue for more than 90 days in this group of people.
[0432] Specifically, the sample size of the sub-customer group used to build the Alpha2d seg5 segmentation model is about 430,000. The customer group is mainly new customers with an account age of less than 3 months who have applied for credit business. The model is used to predict the probability of credit overdue for more than 90 days in the future for the sample group that has not applied for registered credit business.
[0433] Based on the different customer samples of each sub-model confirmed above, historical data information of borrowers is obtained: 1) Credit card category, basic fields include account, overdue, balance, quota, repayment, actual repayment and other information under different dimensions such as bills, cash withdrawals, installments, interest, etc.; 2) Personal loan category, including account, overdue, balance, quota, repayment, actual repayment and other information; 3) Customer basic information, including gender, age and administrative region information of the business; 4) Personal financial assets, including AUM, deposits, wealth management and payroll information.
[0434] According to various risk points in the credit business, macro credit risk is split according to information dimensions, time slices, etc. Variables are derived through professional characteristic variable construction methods. The basic methods are: 1) Customer relationship length variables: such as customer account opening time, customer maximum account age, etc. 2) Time interval variables: such as the number of months from the customer's last repayment to the observation point, the number of months from the customer's last overdue payment, etc.; 3) Behavior frequency degree variables: such as the number of times the customer's repayments are > N in the last X months, the number of times the customer's credit utilization rate is > N in the last X months, etc.; 4) Current time point variables: customer's current monthly credit limit, customer's current monthly balance, etc.; 5) Statistical value variables: such as the customer's maximum number of overdue periods in the last X months, the customer's average credit utilization rate in the last X months; 6) Continuous behavior variables: such as the maximum number of consecutive overdue periods > N in the last X months, the number of consecutive repayment rates > N in the last X months, and other characteristic variables. Finally, 3067 features with potential predictive power for customer overdue payment were derived, such as 'current repayment amount', 'average number of overdue periods in the past 6 months', and 'number of credit card installments in the past 12 months'. In this article, observation point refers to the time point when samples are collected until modeling, and current also refers to the sampling cutoff time. Observation point and current have the same meaning.
[0435] Table 1 Summary of basic variables and derived variables used in the examples
[0436]
[0437] Example 2 Feature Screening
[0438] A preliminary screening was performed on the 3067 features (variables) collected in Example 1 that have potential predictive power for customer overdue payments.
[0439] The preliminary screening of the features of the four sub-models Alpha2d seg1 to Alpha2d seg4 divided in Example 1 is performed according to the following method:
[0440] In the first round of preliminary screening, the features with a missing rate of more than 95% in the data collected in Example 1 were first eliminated, and a total of 230 variables were deleted, leaving 2837 variables.
[0441] In the second round of preliminary screening, for the 2837 features that passed the first round of preliminary screening, the features with single values exceeding 99% among the remaining features were eliminated, a total of 307 variables were eliminated, and 2530 variables remained.
[0442] In the third round of preliminary screening, the 2530 features after the second round of preliminary screening are sorted according to the feature values (the sorting method is specifically that if the feature is a character variable, each value is a separate box, and if the feature is a numeric variable, it is sorted from small to large according to the value size), and then divided into 10-20 boxes according to the quantile point, and the feature IV value is calculated. If the feature IV value is lower than 0.02, it is eliminated. In this embodiment, since the variable attributes are strong financial and asset variables, the prediction effect is strong. Here, variables with IV values lower than 0.05 are eliminated. A total of 1049 features are eliminated, and 1481 feature variables remain.
[0443] In the fourth round of preliminary screening, for the 1481 features after the third round of screening, the features are further screened based on the stepwise discrimination algorithm. After this round of screening, 296 important feature variables can be quickly screened out. The following is an introduction to the stepwise discrimination method. In actual data, there may be little difference in the mean values of different categories on a certain variable. In this case, the effect of using this variable for classification will not be very good; there is also a type of variable that can indeed distinguish different categories in the data well when considered independently, but after including these variables in the model variables, they may appear redundant. Therefore, the embodiment pioneered the use of the stepwise discrimination method to better select more important feature variables under the same dimension, greatly reducing the workload of judging and screening one by one according to the trend of the variables in the fifth round of screening, and fully improving the efficiency of model development without affecting the overall model effect.
[0444] The stepwise discrimination method uses the WILKS'S LAMBDA criterion to measure the strength of feature capabilities and eliminates features that do not meet the set threshold among the remaining features after three rounds of screening. In the stepwise discrimination process, the variable with the strongest discriminant ability is added first. As the variables in the model gradually increase, the discriminant ability of the variables introduced earlier may also change. If the discriminant ability of a variable in the model is less than the threshold, the variable is removed, and then the process is repeated until the variables contained in the model meet the WILKS'S LAMBDA similarity ratio criterion and other variables do not meet the criteria for entering the model.
[0445] The fifth round of preliminary screening is to further screen the 296 important features after the fourth round of screening based on the risk characteristics of each risk point itself (system preset) and the actual bad debt rate of the sample.
[0446] Determine whether the actual bad debt rate distribution of the remaining features is consistent with the business trend, and remove the features whose actual bad debt rate distribution of the samples does not conform to the business trend. Specifically,
[0447] (1) Divide the remaining target features into 10-20 boxes according to the quantiles, and calculate the median of each box and the corresponding bad debt rate.
[0448] (2) Calculate the rate of change (slope) using the median of the values of each box compared to the previous box and the corresponding bad debt rate.
[0449] (3) Count the number of boxes with a change rate greater than 0 and the number of boxes with a change rate greater than 0 between two adjacent boxes, and calculate the percentage of boxes with a change rate greater than 0 to the number of boxes with a change rate greater than 0.
[0450] (4) Obtain the risk characteristics preset for this feature, and based on the percentage of the number of boxes greater than 0 in the above-calculated change rate to the number of non-zero boxes in the change rate, determine whether the actual bad debt rate change trend is approximately consistent with the business logic bad debt rate change trend.
[0451] The criteria for approximate consistency are as follows:
[0452] First, if the business logic trend of this feature is: as the value of this feature increases, the bad debt rate increases (such as the credit line utilization rate, etc.), in this module, the features whose number of boxes with slope greater than 0 in the above calculation accounts for less than 70% of the number of boxes with slope non-0 are eliminated, that is, the features that do not conform to the business trend are eliminated.
[0453] Second, if the business logic trend of this feature is: as the value of this feature increases, the bad debt rate decreases (for example, the amount of deposits, etc.), in this module, the features whose number of boxes with slope greater than 0 in the above calculation accounts for more than 30% of the number of boxes with slope not 0 are eliminated, that is, the features that do not conform to the business trend are eliminated.
[0454] After the fifth round of screening, 175 features were eliminated and 121 features remained.
[0455] For the Alpha2d seg5 sub-model divided in Example 1, the selected variables are customer basic information and personal financial asset variables (a total of 316 feature variables) used to approximately predict the probability of credit defaults in the future for customers who have not registered for credit applications. The feature initial screening step and subsequent steps are the same as other sub-models.
[0456] Example 3 Conversion of features after initial screening
[0457] In the feature judgment step, the optimal conversion method is selected according to the concentration of features after the initial feature screening step, data type, etc. When judging the conversion method, data types are generally divided into two categories, one is character variables, and the other is numeric variables. For character variables, the dummy variable conversion method is generally used for variable conversion; for numeric variables, if the variable value is less than 5 or so, the WOE conversion method will be used. If the variable value is more, the WOE or continuous conversion method will be used (the optimal conversion form is selected by the correlation with the target variable). In this process, it is necessary to comprehensively consider the situation of variable concentration. For example, if the continuous variable has many values, but the concentration of a single value exceeds 95%, the continuous processing will not be performed, and the WOE conversion method can be used directly. Features using different conversion methods are grouped and divided into different data sets. Specifically,
[0458] First, the remaining 121 features in Example 2 are used to determine the conversion methods of these features, and the following three methods are selected according to the concentration of the features, data types, etc.
[0459] Feature conversion method 1 is used to perform WOE conversion on the features obtained in the data acquisition module and judged in the feature judgment module that the optimal conversion method is WOE conversion.
[0460] Feature conversion method 2 is used to perform dummy feature conversion on the features obtained in the data acquisition module and judged in the feature judgment module that the optimal conversion method is dummy feature conversion.
[0461] Feature conversion method 3 is used to obtain the features in the data acquisition module that are determined to be optimal for continuous conversion in the feature judgment module, select the optimal continuous conversion method, and perform continuous conversion.
[0462] The feature merging module is used to horizontally splice the data of feature conversion mode 1, feature conversion mode 2 and feature conversion mode 3.
[0463] Through this embodiment, 121 features were converted, of which 34 features were converted to WOE, 11 features were converted to dummy features (expanded to 28 variables), and 76 features were converted to continuous types, totaling 138 features. The conversion of the post-primary screening features of the Alpha2d seg5 sub-model is also basically similar.
[0464] Example 4 Feature Depth Screening (Feature Fine Screening Step)
[0465] The feature fine screening step mainly includes the following four steps in this embodiment. Steps 1 and 2 are based on stepwise regression and calculation of variance inflation factor to eliminate features with large multicollinearity in the feature merging module to enhance the robustness of the model. Step 3 eliminates features whose positive and negative signs of the training coefficients in the model do not conform to the business trend. Step 4 uses the population stability coefficient (PSI) to eliminate unstable features. This embodiment uses the LOGISTIC process in SAS for deep screening.
[0466] Feature fine screening step 1, based on the stepwise regression algorithm, based on the F test and T test method, introduces features in order from high to low significance. Each time a feature is introduced, the selected features are tested one by one. When the originally introduced feature becomes no longer significant due to the introduction of the subsequent features, it is eliminated. This process is repeated until no features above the significance threshold are selected into the equation, and no features below the significance threshold are eliminated from the regression equation. After this step, 138 features are eliminated to 62 features.
[0467] Feature fine-screening step 2, which is based on the method of removing features with high variance inflation factors, further reduces multicollinearity in the model. After this step, 62 features are eliminated to 46 features.
[0468] Feature fine screening step 3 compares the risk characteristics of each risk point itself (system preset) with the positive and negative signs of the model training coefficients to determine whether the feature coefficients of the remaining features in the model in step 3 are consistent with the business trend, eliminates the features whose model coefficients do not conform to the business trend, and iterates again.
[0469] The specific implementation scheme of the feature fine screening module 3 is as follows:
[0470] 1. For features whose feature conversion method is WOE type, the corresponding model training coefficient should be a negative value, and the WOE conversion type features with positive training coefficients should be eliminated.
[0471] 2. For continuous conversion methods, if the value of this feature increases in business logic, the bad debt rate should increase (such as the credit limit utilization rate, etc.), then the corresponding model training coefficient should be positive, and such continuous conversion features with negative training coefficients should be eliminated; if the value of this feature increases in business logic, the bad debt rate should decrease (such as the deposit amount, etc.), then the corresponding model training coefficient should be negative, and such continuous conversion features with positive training coefficients should be eliminated.
[0472] 3. For the dummy feature conversion method, it is necessary to determine the bad debt rate when the value is 1 and the value is 0. If the bad debt rate when the value is 1 is greater than the bad debt rate when the value is 0, the coefficient should be positive, otherwise it should be negative.
[0473] Feature fine screening step 4, data stability monitoring step, is used to evaluate whether the distribution of individual features and overall scores at different time points has obvious deviations. In this embodiment, features with PSI>0.25 are directly eliminated, and features with 0.25>PSI>0.1 are carefully eliminated based on the impact of eliminating this feature on the model's distinguishing ability.
[0474] Based on the above steps 3 and 4, the feature list is iterated multiple times until no new features are added or removed from the model, and the iteration is stopped to obtain the final feature list and its conversion value. After the above steps, 46 features are eliminated as the feature variables finally entered into the model, for example, 5 features, 6 features, 7 features, and 8 features.
[0475] Example 5 Construction of Alpha2d seg1 model
[0476] Construction of the Alpha2d seg1 model
[0477] Generally speaking, the stronger the correlation between the feature variable and the target variable, the more accurate the final model will be. In this embodiment, Alpha2d seg1 is used as a sub-model of the segmentation model. The above-mentioned decision tree method is adopted to obtain a sample size of about 430,000. Its customer base is mainly new customers who have applied for credit business but have not applied for more than 3 months. The model is constructed to predict the probability of credit overdue for more than 90 days (target variable).
[0478] In this embodiment 5, it is finally confirmed that the six features of the average utilization rate of the revolving loan in the past 3 months, the average number of cash withdrawals from credit cards, the number of months with a credit card utilization rate of >90% in the past 3 months, the number of months with interest >0 in the past 3 months, the minimum balance of the deposit account at a certain point in time in the past 6 months, and the average monthly AUM (personal financial assets) in the past 6 months are used as examples to describe the final modeling results. In the feature conversion step, the conversion method selection has been carried out on the 6 modeling variables according to the correlation between the feature and the target variable. In the credit default probability modeling step, the 6 features screened by the feature fine screening step are substituted into the Sigmoid function (using the LOGISTIC process of SAS software) to perform logistic regression to calculate the model of credit default probability.
[0479] The average utilization rate of the revolving loan in the past three months reflects the borrower's credit demand. For new customers who have applied for credit business but have not applied for more than three months, a large amount of credit demand in the short term may lead to excessive debt. The manifestation of revolving loans is that the utilization rate of the credit line is often too high in the short term, and the possibility of overdue payment in the future will be very high. The relationship between this variable and customer risk is that the smaller the average utilization rate of the revolving loan in the past three months, the lower the borrower's credit demand, and the lower the possibility of serious default in the future; conversely, the larger the average utilization rate of the revolving loan in the past three months, the higher the borrower's credit demand, and the possibility of serious default will also increase. The conversion method is square conversion.
[0480] The average number of cash withdrawals from credit cards reflects the borrower's credit demand. For new customers who have applied for credit business but have not applied for more than 3 months, a large amount of credit demand over a period of time may lead to excessive debt, which is reflected in the use of credit cards for cash withdrawals and consumption, eventually leading to overdue payments. The relationship between this variable and customer risk is that the lower the average number of cash withdrawals from credit cards, the lower the borrower's short-term credit demand, and the lower the possibility of serious default; conversely, the higher the average number of cash withdrawals from credit cards, the higher the borrower's short-term credit demand, and the higher the possibility of serious default. The conversion method is WOE conversion.
[0481] The number of months in which the credit card credit limit utilization rate is > 90% in the past three months reflects the borrower's recent credit demand. For new customers who have applied for credit business but have not applied for more than three months, in short-term credit behavior, if a large amount of credit demand frequently leads to excessive credit limit utilization, the possibility of overdue payment in the future will be greater. The relationship between this variable and customer risk is that the more months in which the credit card credit limit utilization rate is > 90% in the past three months, the greater the repayment pressure of the customer, and the higher the possibility of serious default; conversely, the fewer months in which the credit card credit limit utilization rate is > 90% in the past three months, the lower the possibility of serious default. The conversion method is to convert the original value.
[0482] The number of months with a credit card interest rate > 0 in the past three months reflects the borrower's credit demand. For new customers who have applied for credit business but have not applied for more than three months, a large amount of interest on the credit card means that the customer has used the credit card for non-interest-free business more frequently recently, and the credit demand is large, which may lead to overdue payments in the future. The fewer the number of months with a credit card interest rate > 0 in the past three months, the smaller the borrower's credit demand and repayment pressure, and the lower the possibility of a serious default; conversely, the more the number of months with a credit card interest rate > 0 in the past three months, the greater the borrower's credit demand and repayment pressure, and the higher the possibility of a serious default. The conversion method is WOE conversion.
[0483] The minimum balance of the deposit account at a certain point in time in the past six months reflects the borrower's deposit level and repayment ability. For new customers who have applied for credit business but have not applied for more than three months, the smaller the deposit balance in the past period of time, the more pressure the borrower will have to repay the debt, resulting in a higher possibility of overdue payment. The relationship between this variable and customer risk is that the larger the minimum balance of the deposit account at a certain point in time in the past six months, the better the borrower's deposit level and the stronger the repayment ability, and the lower the possibility of serious default; conversely, the smaller the minimum balance of the deposit account at a certain point in time in the past six months, the worse the borrower's deposit level and the weaker the repayment ability, and the higher the possibility of serious default. The conversion method is logarithmic conversion.
[0484] The average monthly AUM (personal financial assets) in the past 6 months reflects the borrower's repayment ability. For new customers who have applied for credit business but have not applied for more than 3 months, the average monthly AUM in the short term reflects the borrower's recent economic ability. The larger the average monthly AUM, the more sufficient the economic ability is, and the lower the possibility of future overdue payments. The relationship between this variable and customer risk is that the higher the average monthly AUM (personal financial assets) in the past 6 months, the higher the borrower's repayment ability and the lower the possibility of serious default; conversely, the lower the average monthly AUM (personal financial assets) in the past 6 months, the weaker the borrower's repayment ability and the higher the possibility of serious default. The conversion method is square root conversion.
[0485] In the step of calculating the probability of credit default, based on the data and coefficients obtained in the feature conversion step, the following model formula is used to predict the probability (P) that the borrower is in default:
[0486]
[0487] Where k is the number of features entering the model, and in Formula 1, k is 6.
[0488] α is the intercept, with a range of values from (-2.861, -2.5016) and an optimal value of -2.681; β1 is the average utilization rate of the revolving loan in the past three months, with a range of values from (-0.6556, -0.5652) and an optimal value of -0.61; β2 is the average number of credit card withdrawals, with a range of values from (-0.637, -0.528) and an optimal value of -0.582; β3 is the number of months in which the credit card utilization rate was > 90% in the past three months, with a range of values from (-0.4641, -0. 3704), the optimal value is -0.417; β4 is the number of months with credit card interest > 0 in the past 3 months, the value range is (-0.2974, -0.1924), the optimal value is -0.245; β5 is the minimum balance of the deposit account in the past 6 months, the value range is (-0.1345, -0.0686), the optimal value is -0.102; β6 is the average monthly AUM (personal financial assets) in the past 6 months, the value range is (-0.1243, -0.0547), the optimal value is -0.09. (Note: The value range comes from the 95% confidence interval, that is, the 95% CI in the table below)
[0489] x1 is the WOE conversion value of the average utilization rate of the revolving loan in the past three months generated by the feature conversion step; x2 is the square conversion value of the average number of credit card withdrawals generated by the feature conversion step; x3 is the original value of the number of months with a credit card utilization rate > 90% in the past three months generated by the feature conversion step; x4 is the WOE conversion value of the number of months with interest > 0 in the past three months generated by the feature conversion step; x5 is the logarithmic conversion value of the minimum balance of the deposit account at a certain point in time in the past six months generated by the feature conversion step; x6 is the square root conversion value of the average monthly AUM (personal financial assets) in the past six months generated by the feature conversion step. The model performance of some features is shown in Table 2 below.
[0490] Table 2
[0491]
[0492] The P values of all model characteristics are less than 0.05, indicating that the above characteristics are significantly correlated with default performance.
[0493] Example 6 Construction of Alpha2d seg2 model
[0494] For Alpha2d seg2 as a sub-model of the segmentation model, the above-mentioned decision tree method is adopted, and the sample size obtained for classification is about 450,000. Its customer base is mainly existing customers who have applied for registered credit business for more than 3 months and have overdue credit business in the past 6 months. The model is built to predict the probability of credit overdue for more than 90 days in this group (target variable).
[0495] In this embodiment 6, the final modeling result is described by taking seven features as examples: the remaining available credit limit of the current month of the credit card, the installment balance of the current month of the credit card, the number of months from the minimum balance of the deposit account in the past three months, the number of overdue payments of credit customers in the past three months>0, the number of months with credit card credit limit utilization rate>90% in the past 12 months, the average repayment rate of credit customers in the past six months, and the maximum percentage of (interest / limit) of the credit card in the past three months. In the selection of the conversion method in the feature conversion step, the 7 modeling variables have been converted in a corresponding form according to the correlation between the feature and the target variable. In the credit default probability modeling step, the 7 features screened by the feature fine screening step are substituted into the Sigmoid function (using the LOGISTIC process of SAS software) to perform logistic regression to calculate the credit default probability model.
[0496] The remaining available credit limit of the credit card in the current month reflects the borrower's credit demand. For existing customers who have applied for credit business for more than 3 months and have overdue credit business in the past 6 months, a large amount of credit demand in the near future may lead to excessive debt, which is directly reflected in the credit card as the continuous reduction of the remaining available credit limit, which eventually leads to overdue. The relationship between this variable and customer risk is that the lower the remaining available credit limit of the credit card in the current month, the stronger the borrower's credit demand, the greater the repayment pressure, and the higher the possibility of serious default; conversely, the higher the remaining available credit limit of the credit card in the current month, the weaker the borrower's credit demand, the smaller the repayment pressure, and the lower the possibility of serious default. The conversion method is logarithmic conversion.
[0497] The current monthly installment balance of a credit card reflects the borrower's credit demand and repayment pressure. For existing customers who have applied for credit business for more than 3 months and have overdue credit business in the past 6 months, using credit card installment business means that the customer has recently used the credit card for non-interest-free business more frequently. The larger the installment balance, the greater the credit demand, which may lead to overdue payments in the future. The relationship between this variable and customer risk is that the higher the current monthly installment balance of the credit card, the stronger the borrower's credit demand and repayment pressure, and the higher the possibility of serious default; conversely, the lower the current monthly installment balance of the credit card, the weaker the borrower's credit demand and repayment pressure, and the lower the possibility of serious default. The conversion method is logarithmic conversion.
[0498] The number of months from the minimum balance of the deposit account in the past three months reflects the change in the borrower's capital level. For existing customers who have applied for registered credit business for more than three months and have overdue credit business in the past six months, the longer the minimum balance of the deposit occurred in the past period of time, the more sufficient the borrower's current funds are than before, and the lower the possibility of future loan overdue. The relationship between this variable and customer risk is that the greater the number of months from the minimum balance of the deposit account in the past three months, the better the borrower's capital level is, and the lower the possibility of serious default; conversely, the greater the number of months from the minimum balance of the deposit account in the past three months, the worse the borrower's capital level is, and the possibility of serious default will also increase. The conversion method is WOE conversion.
[0499] The number of times a credit customer has overdue payments > 0 in the past three months reflects the borrower's repayment habits and credit performance. For existing customers who have applied for registered credit business for more than three months and have overdue credit business in the past six months, if any credit business has been overdue in the past period of time, it means that the borrower can no longer balance income and debt, and the possibility of overdue payments in the future will be very high. The relationship between this variable and customer risk is that the smaller the number of times a credit customer has overdue payments > 0 in the past three months, the better the historical credit performance of the borrower, and the lower the possibility of serious default in the future; conversely, the greater the number of times a credit customer has overdue payments > 0 in the past three months, the worse the historical credit performance of the borrower, and the higher the possibility of serious default. The conversion method is WOE conversion.
[0500] The number of months in which the credit limit utilization rate of the credit card in the past 12 months is > 90% reflects the borrower's medium- and long-term credit demand. For existing customers who have applied for registered credit business for more than 3 months and have overdue credit business in the past 6 months, the borrower's large credit demand in the medium and long term may lead to excessive debt, which is directly reflected in the credit card as the continuous increase in the credit limit utilization rate, and ultimately leads to overdue. The lower the number of months in which the credit limit utilization rate of the credit card in the past 12 months is > 90%, the lower the borrower's demand for funds and the lower the possibility of serious default; conversely, the greater the number of months in which the credit limit utilization rate of the credit card in the past 12 months is > 90%, the higher the borrower's demand for funds and the higher the possibility of serious default. The conversion method is square conversion.
[0501] The average repayment rate of credit customers in the past 6 months reflects the repayment habits and credit performance of borrowers. For existing customers who have applied for credit business registration for more than 3 months and have overdue credit business in the past 6 months, the good repayment habits of borrowers in the short and medium term represent the good credit performance of borrowers with balanced income and expenditure, and the possibility of overdue in the future is very low. The relationship between this variable and customer risk is that the lower the average repayment rate of credit customers in the past 6 months, the worse the repayment habits and credit performance of borrowers, and the higher the possibility of serious default; conversely, the higher the average repayment rate of credit customers in the past 6 months, the stronger the repayment habits and credit performance of borrowers, and the lower the possibility of serious default. The conversion method is square root conversion.
[0502] The maximum percentage of the credit card (interest / credit limit) in the past three months reflects the borrower's credit demand. For existing customers who have applied for credit business for more than three months and have overdue credit business in the past six months, the large amount of interest generated by the credit card means that the customer has recently used the credit card for non-interest-free business more frequently, and the credit demand is large, which may lead to overdue payments in the future. The smaller the maximum percentage of the credit card (interest / credit limit) in the past three months, the smaller the borrower's credit demand and repayment pressure, and the lower the possibility of serious default; conversely, the larger the maximum percentage of the credit card (interest / credit limit) in the past three months, the greater the borrower's credit demand and repayment pressure, and the higher the possibility of serious default. The conversion method is cube root conversion.
[0503] In the step of calculating the probability of credit default, based on the data and coefficients obtained in the feature conversion step, the following model formula is used to predict the probability (P) that the borrower is in default:
[0504]
[0505] Where k is the number of features entering the model, and in Formula 2, k is 7.
[0506] α is the intercept, with a range of values from (2.61, 2.6512) and an optimal value of 2.631; β1 is the remaining available credit limit of the credit card in the current month, with a range of values from (-0.2514, -0.2464) and an optimal value of -0.249; β2 is the installment balance of the credit card in the current month, with a range of values from (-0.9655, -0.9299) and an optimal value of -0.948; β3 is the number of months from the minimum balance of the deposit account in the past three months, with a range of values from (-0.3237, -0.3099) and an optimal value of -0.317; β4 is the number of months overdue for credit customers in the past three months > 0 The number of times, the value range is (-0.252, -0.2402), the optimal is -0.246; β5 is the number of months with a credit card limit utilization rate of > 90% in the past 12 months, the value range is (-0.5863, -0.5587), the optimal is -0.573; β6 is the average repayment rate of credit customers in the past 6 months, the value range is (-0.1131, -0.1075), the optimal is -0.11; β7 is the maximum percentage of credit card (interest / limit) in the past 3 months, the value range is (-0.3407, -0.3209), the optimal is -0.331. (Note: The value range comes from the 95% confidence interval, that is, the 95% CI in the table below)
[0507] x1 is the logarithmic conversion value of the remaining available credit limit of the credit card in the current month generated by the feature conversion step; x2 is the logarithmic conversion value of the installment balance of the credit card in the current month generated by the feature conversion step; x3 is the WOE conversion value of the minimum balance of the deposit account in the past three months generated by the feature conversion step; x4 is the WOE conversion value of the number of overdue payments of the credit customer in the past three months>0 generated by the feature conversion step; x5 is the square conversion value of the number of months with a credit limit utilization rate>90% in the past 12 months generated by the feature conversion step; x6 is the square root conversion value of the average repayment rate of the credit customer in the past six months generated by the feature conversion step; x7 is the cube root conversion value of the maximum percentage of the credit card (interest / limit) in the past three months generated by the feature conversion step. The model performance of some features is shown in Table 3 below:
[0508] Table 3
[0509]
[0510] The P values of all model characteristics are less than 0.05, indicating that the above characteristics are significantly correlated with default performance.
[0511] The P values of all model characteristics are less than 0.05, indicating that the above characteristics are significantly correlated with default performance.
[0512] Example 7 Construction of Alpha2d seg3 model
[0513] For Alpha2d seg3 as a sub-model of the segmentation model, the above-mentioned decision tree method is adopted, and the sample size obtained for classification is about 4.46 million. Its customer base is mainly existing customers who have applied for registered credit business for more than 3 months, have no overdue credit business in the past 6 months, and have an average credit card repayment rate of less than 90% in the past 3 months. The model is built to predict the probability of credit overdue for more than 90 days in this group (target variable).
[0514] In this embodiment 7, the final modeling result is described by taking five features as examples: the remaining available credit limit of the credit card in the current month, the number of months from the last overdue payment of the credit customer in the past 12 months>0, the current account age of the credit customer, the number of months with a credit limit utilization rate greater than 70% in the past 6 months of the revolving loan, and the percentage of interest / consumption and total cash withdrawal amount of the credit card in the past 12 months. In the selection of the conversion method in the feature conversion step, the 5 modeling variables have been converted in a corresponding form according to the correlation between the feature and the target variable. In the credit default probability modeling step, the 5 features screened by the feature fine screening step are substituted into the Sigmoid function (using the LOGISTIC process of SAS software) for logistic regression to calculate the credit default probability model.
[0515] The remaining available credit limit of the credit card in the current month reflects the borrower's credit demand. For existing customers who have applied for credit business for more than 3 months, have not been overdue in the past 6 months, and have an average credit card repayment rate of less than 90% in the past 3 months, a large amount of credit demand in the near future may lead to excessive debt, which is directly reflected in the credit card as the continuous reduction of the remaining available credit limit, which eventually leads to overdue payments. The relationship between this variable and customer risk is that the lower the remaining available credit limit of the credit card in the current month, the stronger the borrower's credit demand, the greater the repayment pressure, and the higher the possibility of serious default; conversely, the higher the remaining available credit limit of the credit card in the current month, the weaker the borrower's credit demand, the smaller the repayment pressure, and the lower the possibility of serious default. The conversion method is logarithmic conversion.
[0516] The number of months from the last overdue payment of a credit customer in the past 12 months > 0 reflects the repayment habits and credit performance of the borrower. For existing customers who have applied for registered credit business for more than 3 months, have no overdue credit business in the past 6 months, and have an average credit card repayment rate of less than 90% in the past 3 months, if any credit business has been overdue in the past period of time, it means that the borrower can no longer balance income and debt, and the possibility of overdue payment in the future will be very high. The performance relationship between this variable and customer risk is that the smaller the number of months from the last overdue payment of a credit customer in the past 12 months > 0, the better the historical credit performance of the borrower, and the lower the possibility of serious default in the future; conversely, the larger the number of months from the last overdue payment of a credit customer in the past 12 months > 0, the worse the historical credit performance of the borrower, and the higher the possibility of serious default. The conversion method is WOE conversion.
[0517] The current account age of a credit customer reflects the borrower's stickiness and recognition with the bank. For existing customers who have applied for credit business registration for more than 3 months, have not had any overdue credit business in the past 6 months, and have an average credit card repayment rate of less than 90% in the past 3 months, the longer the borrower's account age, the better the credit business usage and repayment habits, and the lower the possibility of overdue payment. The lower the current account age of the credit customer, the better the borrower's money usage habits, and the lower the possibility of serious default; conversely, the older the current account age of the credit customer, the borrower's good money usage habits have not yet been formed, and the possibility of serious default increases accordingly. The conversion method is cube root conversion.
[0518] The number of months in which the credit utilization rate of the revolving loan in the past 6 months was greater than 70% reflects the borrower's medium-term credit demand. For existing customers who have applied for registered credit business for more than 3 months, have not been overdue in credit business in the past 6 months, and have an average credit card repayment rate of less than 90% in the past 3 months, the borrower's large credit demand in the medium term may lead to excessive debt, which is directly reflected in the credit card as the continuous increase in credit utilization rate, and ultimately leads to overdue. The lower the number of months in which the credit utilization rate of the revolving loan in the past 6 months is greater than 70%, the lower the borrower's demand for funds and the lower the possibility of serious default; conversely, the greater the number of months in which the credit utilization rate of the revolving loan in the past 6 months is greater than 70%, the higher the borrower's demand for funds and the higher the possibility of serious default. The conversion method is square root conversion.
[0519] The percentage of interest / total amount of consumption and cash withdrawal of credit cards in the past 12 months reflects the credit demand of borrowers. For existing customers who have applied for credit business for more than 3 months, have no overdue credit business in the past 6 months, and have an average credit card repayment rate of less than 90% in the past 3 months, the large amount of interest generated by credit cards means that customers have recently used credit cards for non-interest-free business more frequently, have a large credit demand, and may cause overdue payments in the future. The smaller the percentage of interest / total amount of consumption and cash withdrawal of credit cards in the past 12 months, the smaller the credit demand and repayment pressure of the borrower, and the lower the possibility of serious default; conversely, the larger the percentage of interest / total amount of consumption and cash withdrawal of credit cards in the past 12 months, the greater the credit demand and repayment pressure of the borrower, and the higher the possibility of serious default. The conversion method is square conversion.
[0520] In the step of calculating the probability of credit default, based on the data and coefficients obtained in the feature conversion step, the following model formula is used to predict the probability (P) that the borrower is in default:
[0521]
[0522] Where k is the number of features entering the model, and k is 5 in Formula 3.
[0523] α is the intercept, with a range of values of (2.2139, 2.3355) and an optimal value of 2.275; β1 is the remaining available credit limit of the credit card in the current month, with a range of values of (-0.3212, -0.3148) and an optimal value of -0.318; β2 is the number of months from the last overdue payment of the credit customer in the past 12 months > 0, with a range of values of (0.6342, 0.6486) and an optimal value of 0.641; β3 is the current account age of the credit customer , the value range is (-0.6442, -0.6232), the optimal value is -0.634; β4 is the number of months in which the utilization rate of the revolving loan limit is greater than 70% in the past 6 months, the value range is (-0.2966, -0.2786), the optimal value is -0.288; β5 is the percentage of interest / consumption and cash withdrawal of credit cards in the past 12 months, the value range is (-0.2645, -0.2461), the optimal value is -0.255. (Note: The value range comes from the 95% confidence interval, that is, the 95% CI in the table below)
[0524] x1 is the logarithmic conversion value of the remaining available credit limit of the credit card in the current month generated in the feature conversion step; x2 is the WOE conversion value of the number of months from the last overdue payment of the credit customer in the past 12 months > 0 generated in the feature conversion step; x3 is the square conversion value of the credit customer's current account age generated in the feature conversion step; x4 is the cube root conversion value of the number of months in the past 6 months when the revolving loan credit limit utilization rate was greater than 70% generated in the feature conversion step; x5 is the square root conversion value of the percentage of interest / consumption and total cash withdrawal amount of the credit card in the past 12 months generated in the feature conversion step.
[0525] The model performance of some features is shown in Table 4 below:
[0526] Table 4
[0527]
[0528] The P values of all model characteristics are less than 0.05, indicating that the above characteristics are significantly correlated with default performance.
[0529] Example 8 Alpha2d seg4 model construction
[0530] For Alpha2d seg4 as a sub-model of the segmentation model, the above-mentioned decision tree method is adopted, and the sample size obtained by classification is about 53.25 million. Its customer base is mainly existing customers who have applied for registered credit business for more than 3 months, have no overdue credit business in the past 6 months, and have an average credit card repayment rate of more than 90% in the past 3 months. The model is built to predict the probability of credit overdue for more than 90 days in this group (target variable).
[0531] In Example 8, it is finally confirmed that the final modeling result is described by eight features, including the remaining available credit limit of the current month of the credit card, the number of overdue payments of the credit customer in the past 12 months>0, the current account age of the credit customer, the average utilization rate of the installment limit of the credit card in the past 6 months, the number of months with a credit card limit utilization rate>70% in the past 12 months, the percentage of interest / consumption and total withdrawal amount of the credit card in the past 12 months, the minimum utilization rate of the revolving loan limit in the past 6 months, and the number of months with a credit card repayment rate>90% in the past 12 months. In the feature conversion step, the conversion method selection has been carried out on the 8 modeling variables according to the correlation between the feature and the target variable. In the credit default probability modeling step, the 8 features screened by the feature fine screening step are substituted into the Sigmoid function (using the LOGISTIC process of SAS software) to perform logistic regression to calculate the model of the credit default probability.
[0532] The remaining available credit limit of the credit card in the current month reflects the borrower's credit demand. For existing customers who have applied for credit business for more than 3 months, have not been overdue in the past 6 months, and have an average credit card repayment rate of more than 90% in the past 3 months, a large amount of credit demand in the near future may lead to excessive debt, which is directly reflected in the credit card as the continuous reduction of the remaining available credit limit, which eventually leads to overdue. The relationship between this variable and customer risk is that the lower the remaining available credit limit of the credit card in the current month, the stronger the borrower's credit demand, the greater the repayment pressure, and the higher the possibility of serious default; conversely, the higher the remaining available credit limit of the credit card in the current month, the weaker the borrower's credit demand, the smaller the repayment pressure, and the lower the possibility of serious default. The conversion method is logarithmic conversion. The conversion method is natural logarithm conversion.
[0533] The number of times a credit customer has overdue payments > 0 in the past 12 months reflects the borrower's repayment habits and credit performance. For existing customers who have applied for registered credit business for more than 3 months, have no overdue credit business in the past 6 months, and have an average credit card repayment rate of more than 90% in the past 3 months, if any credit business has been overdue in the past period of time, it means that the borrower has been unable to balance income and debt, and the possibility of overdue payments in the future will be very high. The relationship between this variable and customer risk is that the smaller the number of overdue payments > 0 in the past 12 months, the better the historical credit performance of the borrower, and the lower the possibility of serious default in the future; conversely, the greater the number of overdue payments > 0 in the past 12 months, the worse the historical credit performance of the borrower, and the higher the possibility of serious default. The conversion method is WOE conversion.
[0534] The current account age of a credit customer reflects the borrower's stickiness and recognition with the bank. For existing customers who have applied for credit business registration for more than 3 months, have not had overdue credit business in the past 6 months, and have an average credit card repayment rate of more than 90% in the past 3 months, the longer the borrower's account age, the better the credit business usage and repayment habits, and the lower the possibility of overdue payment. The lower the current account age of the credit customer, the better the borrower's money usage habits, and the lower the possibility of serious default; conversely, the older the current account age of the credit customer, the borrower's good money usage habits have not yet been formed, and the possibility of serious default increases accordingly. The conversion method is raw value conversion.
[0535] The average utilization rate of the installment limit of the credit card in the past 6 months reflects the credit demand and repayment pressure of the borrower. For existing customers who have applied for registered credit business for more than 3 months, have not been overdue in the credit business in the past 6 months, and have an average credit card repayment rate of more than 90% in the past 3 months, the use of credit card installment business means that the customer has used the credit card for non-interest-free business more frequently recently. The larger the installment balance, the greater the credit demand, which may lead to overdue in the future. The relationship between this variable and customer risk is that the higher the average utilization rate of the installment limit of the credit card in the past 6 months, the stronger the credit demand and repayment pressure of the borrower, and the higher the possibility of serious default; conversely, the lower the average utilization rate of the installment limit of the credit card in the past 6 months, the weaker the credit demand and repayment pressure of the borrower, and the lower the possibility of serious default. The conversion method is square conversion.
[0536] The number of months in which the credit card credit limit utilization rate is > 70% in the past 12 months reflects the borrower's credit demand and repayment pressure. For existing customers who have applied for registered credit business for more than 3 months, have not been overdue in credit business in the past 6 months, and have an average credit card repayment rate of more than 90% in the past 3 months, the borrower's large credit demand in the medium and long term may lead to excessive debt, which is directly reflected in the credit card as the continuous increase in credit limit utilization rate, and ultimately leads to overdue. The lower the number of months in which the credit card credit limit utilization rate is > 70% in the past 12 months, the lower the borrower's demand for funds and the lower the possibility of serious default; conversely, the greater the number of months in which the credit card credit limit utilization rate is > 70% in the past 12 months, the higher the borrower's demand for funds and the higher the possibility of serious default. The conversion method is square root conversion.
[0537] The percentage of interest / total amount of consumption and cash withdrawal of credit cards in the past 12 months reflects the credit demand of borrowers. For existing customers who have applied for credit business for more than 3 months, have no overdue credit business in the past 6 months, and have an average credit card repayment rate of more than 90% in the past 3 months, the large amount of interest generated by credit cards means that customers have recently used credit cards for non-interest-free business more frequently, have a large credit demand, and may cause overdue payments in the future. The smaller the percentage of interest / total amount of consumption and cash withdrawal of credit cards in the past 12 months, the smaller the credit demand and repayment pressure of the borrower, and the lower the possibility of serious default; conversely, the larger the percentage of interest / total amount of consumption and cash withdrawal of credit cards in the past 12 months, the greater the credit demand and repayment pressure of the borrower, and the higher the possibility of serious default. The conversion method is square conversion.
[0538] The minimum utilization rate of the revolving loan in the past 6 months reflects the borrower's medium-term credit demand. For existing customers who have applied for registered credit business for more than 3 months, have not been overdue in the past 6 months, and have an average credit card repayment rate of more than 90% in the past 3 months, the borrower's large credit demand in the medium term may lead to excessive debt, which is directly reflected in the credit card as the continuous increase in the utilization rate of the credit line, and ultimately leads to overdue. The lower the minimum utilization rate of the revolving loan in the past 6 months, the lower the borrower's demand for funds and the lower the possibility of serious default; conversely, the more months the utilization rate of the revolving loan in the past 6 months is greater than 70%, the higher the borrower's demand for funds and the higher the possibility of serious default. The conversion method is logarithmic conversion.
[0539] The number of months in which the credit card repayment rate in the past 12 months is > 90% reflects the borrower's repayment habits and credit performance. For existing customers who have applied for registered credit business for more than 3 months, have not been overdue in credit business in the past 6 months, and have an average credit card repayment rate of more than 90% in the past 3 months, the good repayment habits of medium- and long-term borrowers represent the borrower's balanced income and expenditure and good credit performance, and the possibility of future overdue payments is very low. The relationship between this variable and customer risk is that the lower the number of months in which the credit card repayment rate in the past 12 months is > 90%, the worse the borrower's repayment habits and credit performance are, and the higher the possibility of serious default; conversely, the higher the number of months in which the credit card repayment rate in the past 12 months is > 90%, the stronger the borrower's repayment habits and credit performance are, and the lower the possibility of serious default. The conversion method is raw value conversion.
[0540] In the step of calculating the probability of credit default, based on the data and coefficients obtained in the feature conversion step, the following model formula is used to predict the probability (P) that the borrower is in default:
[0541]
[0542] Where k is the number of features entering the model. In Formula 4, k is 8.
[0543] α is the intercept, with a range of values from (1.8206, 1.9124) and an optimal value of 1.867; β1 is the remaining available credit limit of the credit card in the current month, with a range of values from (-0.3997, -0.3923) and an optimal value of -0.396; β2 is the number of times the credit customer has overdue payments > 0 in the past 12 months, with a range of values from (-0.5279, -0.5179) and an optimal value of -0.523; β3 is the current account age of the credit customer, with a range of values from (-0.6273, -0.6111) and an optimal value of -0.619; β4 is the average utilization rate of the installment limit of the credit card in the past 6 months, with a range of values from (-0.3218, -0.3132) and an optimal value of - 0.318; β5 is the number of months in which the credit card limit utilization rate in the past 12 months is >70%, the value range is (-0.2822, -0.2714), and the optimal value is -0.277; β6 is the percentage of interest / consumption and cash withdrawal of credit cards in the past 12 months, the value range is (-0.2588, -0.2486), and the optimal value is -0.254; β7 is the minimum value of the credit limit utilization rate of revolving loans in the past 6 months, the value range is (-0.2388, -0.2292), and the optimal value is -0.234; β8 is the number of months in which the credit card repayment rate in the past 12 months is >90%, the value range is (-0.2318, -0.2204), and the optimal value is -0.226. (Note: The value range comes from the 95% confidence interval, that is, the 95% CI in the table below)
[0544] x1 is the logarithmic transformation value of the remaining available credit limit of the credit card in the current month generated in the feature conversion step; x2 is the original value of the number of overdue payments of the credit customer in the past 12 months > 0 generated in the feature conversion step; x3 is the square transformation value of the current account age of the credit customer generated in the feature conversion step; x4 is the WOE transformation value of the average installment credit limit utilization rate of the credit card in the past 6 months generated in the feature conversion step; x5 is the logarithmic transformation value of the number of months with a credit limit utilization rate > 70% in the past 12 months generated in the feature conversion step; x6 is the square root transformation value of the percentage of interest / consumption and total cash withdrawal amount of the credit card in the past 12 months generated in the feature conversion step; x7 is the square transformation value of the minimum credit limit utilization rate of the revolving loan in the past 6 months generated in the feature conversion step; x8 is the original value of the number of months with a repayment rate > 90% in the past 12 months generated in the feature conversion step.
[0545] The model performance of some features is shown in Table 5 below:
[0546] Table 5
[0547]
[0548] The P values of all model characteristics are less than 0.05, indicating that the above characteristics are significantly correlated with default performance.
[0549] Example 9 Alpha2d seg5 model construction
[0550] For Alpha2d seg5 as a sub-model of the segmentation model, the above-mentioned decision tree method is adopted, and the sample size obtained by classification is about 430,000. Its customer base is mainly new customers who have applied for credit business and have an account age of less than 3 months. The model is built to predict the probability (target variable) of the sample group that has not applied for registered credit business to be overdue for more than 90 days in the future.
[0551] In Example 10, it is finally confirmed that the final modeling result is described by taking the six features of the maximum balance of the deposit account in the past 12 months from now, the minimum balance of the deposit account in the past 6 months, the current balance of the deposit account, the average monthly AUM (personal financial assets) in the past 6 months, the average balance of the investment and financial management account in the past 6 months, and the maximum value of the salary paid on behalf of the past 12 months as examples. In the selection of the conversion method in the feature conversion step, the 6 modeling variables have been converted in a corresponding form according to the correlation between the feature and the target variable. In the credit default probability modeling step, the 6 features screened by the feature fine screening step are substituted into the Sigmoid function (using the LOGISTIC process of SAS software) to perform logistic regression to calculate the model of credit default probability.
[0552] The number of months from the maximum balance of the deposit account in the past 12 months to the present reflects the changes in the borrower's capital level. For new users who have not applied for credit business registration, if the maximum balance of the deposit in the past period of time is smaller than the present month, the borrower's current capital level is more sufficient than before, and the possibility of future loan default is lower. The relationship between this variable and customer risk is that the further the maximum balance of the deposit account in the past 12 months is from the present month, the lower the borrower's recent income level and repayment ability, and the higher the possibility of serious default; conversely, the closer the maximum balance of the deposit account in the past 12 months is to the present month, the higher the borrower's recent income level and repayment ability, and the lower the possibility of serious default. The conversion method is WOE conversion.
[0553] The minimum balance of the deposit account at a certain point in time in the past six months reflects the borrower's capital level and repayment ability. For new users who have not applied for credit business registration, the larger the minimum balance of the deposit in the past period of time, the more sufficient the borrower's capital level is, and the lower the possibility of future loan defaults. . The relationship between this variable and customer risk is that the larger the minimum balance of the deposit account at a certain point in time in the past six months, the more sufficient the borrower's capital level is, and the lower the possibility of serious default; conversely, the larger the minimum balance of the deposit account at a certain point in time in the past six months, the weaker the borrower's capital level and repayment ability are, and the possibility of serious default will also increase. The conversion method is the logarithmic conversion in the continuous conversion.
[0554] The current deposit account balance reflects the borrower's deposit level and repayment ability. For new users who have not applied for credit business, the more pressure the borrower has to repay the debt, the higher the possibility of overdue payment. The relationship between this variable and customer risk is that the larger the current deposit account balance, the better the borrower's deposit level and repayment ability, and the lower the possibility of serious default; conversely, the smaller the current deposit account balance, the worse the borrower's deposit level and repayment ability, and the higher the possibility of serious default. The conversion method is logarithmic conversion.
[0555] The average monthly AUM (personal financial assets) in the past six months reflects the borrower's repayment ability. For new users who have not applied for credit business registration, the average monthly AUM in the short term reflects the borrower's recent economic ability. The larger the average monthly AUM, the more sufficient the economic ability is, and the lower the possibility of future overdue payments. The relationship between this variable and customer risk is that the higher the average monthly AUM (personal financial assets) in the past six months, the higher the borrower's repayment ability and the lower the possibility of serious default; conversely, the lower the average monthly AUM (personal financial assets) in the past six months, the weaker the borrower's repayment ability and the higher the possibility of serious default. The conversion method is raw value conversion.
[0556] The average balance of investment and financial management accounts in the past six months reflects the borrower's investment level and repayment ability. For new users who have not applied for credit business registration, the average balance of investment and financial management accounts in the past six months reflects the adequacy of the borrower's second repayment source. The larger the balance, the stronger the repayment ability, and the lower the possibility of future overdue payments. The relationship between this variable and customer risk is that the smaller the average balance of investment and financial management accounts in the past six months, the lower the borrower's investment level and repayment ability, and the higher the possibility of serious default; conversely, the larger the average balance of investment and financial management accounts in the past six months, the higher the borrower's investment level and repayment ability, and the lower the possibility of serious default. The conversion method is square conversion.
[0557] The maximum amount of wage payments in the past 12 months reflects the borrower's income level and repayment ability. For new users who have not applied for credit business registration, the amount of wage payments reflects the borrower's income and repayment ability. In the case of insufficient financial ability, the possibility of future overdue payments is very high. The relationship between this variable and customer risk is that the larger the maximum amount of wage payments in the past 12 months, the stronger the borrower's income level and repayment ability, and the lower the possibility of serious default; conversely, the smaller the maximum amount of wage payments in the past 12 months, the weaker the borrower's income level and repayment ability, and the higher the possibility of serious default. The conversion method is cube root conversion.
[0558] In the step of calculating the probability of credit default, based on the data and coefficients obtained in the feature conversion step, the following model formula is used to predict the probability (P) that the borrower is in default:
[0559]
[0560] Where k is the number of features entering the model. In Formula 5, k is 6.
[0561] α is the intercept, with a range of values from (-2.6066, -2.2583), and the optimal value is -2.432; β1 is the number of months from the maximum balance of the deposit account in the past 12 months, with a range of values from (-3.0504, -2.2763), and the optimal value is -2.663; β2 is the minimum balance of the deposit account in the past 6 months, with a range of values from (-0.1819, -0.1163), and the optimal value is -0.149; β3 is the balance of the deposit account at the current time, with a range of values from (-0.1197, -0.0721), the optimal value is -0.096; β4 is the average monthly AUM (personal financial assets) in the past 6 months, the value range is (-0.119, -0.0513), the optimal value is -0.085; β5 is the average balance of investment and financial management accounts in the past 6 months, the value range is (-0.5767, -0.2145), the optimal value is -0.396; β6 is the maximum value of salary payment in the past 12 months, the value range is (-0.6459, -0.1799), the optimal value is -0.413. (Note: The value range comes from the 95% confidence interval, that is, the 95% CI in the table below)
[0562] x1 is the logarithmic transformation value of the maximum balance of the deposit account in the past 12 months, generated by the feature conversion step; x2 is the logarithmic transformation value of the minimum balance of the deposit account in the past 6 months, generated by the feature conversion step; x3 is the WOE transformation value of the deposit account balance at the current time, generated by the feature conversion step; x4 is the original value of the average monthly AUM (personal financial assets) in the past 6 months, generated by the feature conversion step; x5 is the square transformation value of the average balance of the investment and financial management account in the past 6 months, generated by the feature conversion step; x6 is the cube root transformation value of the maximum value of wage payment on behalf of others in the past 12 months, generated by the feature conversion step.
[0563] The model performance of some features is shown in Table 6 below:
[0564] Table 6
[0565]
[0566] The P values of all model characteristics are less than 0.05, indicating that the above characteristics are significantly correlated with default performance.
[0567] Example 10
[0568] The P values calculated by the above formulas can be further used to calculate the score of any customer.
[0569] The scoring calculation step is used to convert the calculated credit default probability into a score of 0-1000 using a pre-stored default score conversion code.
[0570] In the scoring calculation module, the following formula is used to calculate and generate the credit score used to characterize the borrower:
[0571]
[0572]
[0573] Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
[0574] In this embodiment, the P value calculated in the above embodiments can be substituted to calculate the score.
[0575] The KS (Kolmogorov-Smirnov) statistic was proposed by two Soviet mathematicians, ANKolmogorov and NVSmirnov. In risk control, KS is often used to evaluate the discrimination of models. The greater the discrimination, the stronger the risk ranking ability of the model.
[0576] The KS statistic is based on the empirical cumulative distribution function (ECDF), which is generally defined as:
[0577] KS=max(|cum(bad_rate)-cum(good_rate)|)
[0578] According to the prediction model, a KS curve is drawn. The KS of this embodiment is 80.64. It can be seen that the model constructed in this embodiment performs well in assessing customer credit risk. Figure 1 An example of a KS graph is shown with a KS value of 58.
[0579] The following shows the results of the KS values of the model applied to the development sample and the reserved validation sample in the development sample and the validation sample. From Table 7, it can be seen that the model has a good discrimination effect in the training set and the validation set (where the sample size ratio of the training set and the validation set is 6:4) and the overall sample, that is, the discrimination effect is very good in all sub-models.
[0580] Table 7
[0581]
[0582] Although the embodiments of the present application are described above, the present application is not limited to the above specific embodiments and application fields, and the above specific embodiments are merely illustrative and instructive, rather than restrictive. A person of ordinary skill in the art can make many forms under the guidance of this specification and without departing from the scope of protection of the claims of the present application, all of which belong to the protection of the present application.
Claims
1. A method for calculating retail credit risk, comprising: A data collection step, which obtains retail credit prediction data of the sample to be predicted; A step of classifying samples to be predicted, which classifies the samples to be predicted based on a decision tree method to determine a sub-model for calculating the probability of credit default; The credit default probability calculation step is to substitute the retail credit prediction data into the credit default probability sub-model to calculate the credit default probability of the sample to be predicted.
2. The method according to claim 1, further comprising: After calculating the credit default probability, a step of calculating the credit score of the sample to be predicted is used to calibrate the calculated credit default probability to a standardized score of 0-1000 points.
3. The method according to claim 1 or 2, wherein: The retail credit prediction data includes original retail credit prediction data of the sample to be predicted and derived retail credit prediction data processed based on the original retail credit prediction data; Preferably, the original retail credit prediction data includes: Credit card basic data, which is based on all available data during the sample user's credit card creation and usage process. Basic data on personal loans, which is all available data based on the loan application and usage behavior of sample users. Basic customer information data, which is based on the attributes of the sample users themselves but is not directly related to their behavior in financial institutions. Basic data on personal financial assets, which includes all other financial assets and financial transaction data of sample users in financial institutions that are not related to credit cards and loans.
4. The method according to any one of claims 1 to 3, wherein: The derived retail credit prediction data processed based on the original retail credit prediction data refers to the data obtained by processing the collected original retail credit prediction data based on the time dimension, space dimension, frequency dimension and statistical information dimension; Preferably, the derived retail credit forecast data includes but is not limited to: Derived retail credit forecast data obtained by processing based on sample relationship length, Derivative retail credit forecast data obtained by processing time interval variables, Derivative retail credit forecast data obtained by processing based on the frequency of sample behavior, Derivative retail credit forecast data obtained by processing the current time point of the sample, Derivative retail credit forecast data obtained by processing based on sample continuous behavior, Derived retail credit forecast data obtained by processing sample data based on statistical information dimensions.
5. The method according to any one of claims 1 to 4, wherein: The retail credit prediction data is selected from one, two, three, four, five, six, seven or eight of the following: Average utilization rate of revolving loan in the past 3 months, average number of credit card cash withdrawals, number of months with credit card utilization rate > 90% in the past 3 months, number of months with credit card interest > 0 in the past 3 months, minimum balance of deposit account in the past 6 months, average monthly AUM (personal financial assets) in the past 6 months, remaining available credit limit of credit card in the current month, installment balance of credit card in the current month, number of months from the minimum balance of deposit account in the past 3 months, number of overdue payments > 0 by credit customers in the past 3 months, number of overdue payments > 1 by credit customers in the past 3 months, number of overdue payments > 2 by credit customers in the past 3 months, number of overdue payments > 3 by credit customers in the past 3 months, most Number of months since the last overdue payment > 0, current account age of the credit customer, number of months in the past 6 months with a revolving loan limit utilization rate greater than 70%, percentage of total credit card interest / consumption and cash withdrawals in the past 12 months, number of overdue payments by credit customers > 0 in the past 12 months, average credit card installment limit utilization rate in the past 6 months, number of months with a credit card limit utilization rate > 70% in the past 12 months, minimum revolving loan limit utilization rate in the past 6 months, number of months with a credit card repayment rate > 90% in the past 12 months, number of months since the maximum balance of the deposit account in the past 12 months, current deposit account balance, average balance of investment and wealth management accounts in the past 6 months, maximum wage payment value in the past 12 months.
6. The method according to any one of claims 1 to 5, wherein: The step of classifying the sample to be predicted includes the following sub-steps: Whether the sample to be tested is a customer who has applied for registration of credit business; Whether the sample to be tested is a customer who has applied for registration within M months; Whether the sample to be tested is a customer with zero overdue credit business in the past 6 months; Whether the sample to be tested is a customer whose average credit card repayment rate in the past three months is less than N; Based on the above sub-steps, the samples to be predicted are classified to determine the sub-model for calculating the probability of credit default. Under the premise of ensuring the rationality of business logic, the order of the above sub-steps can be set arbitrarily; It is preferred to classify the predicted samples in the following order: Whether the sample to be tested is a customer who has applied for registration of credit business; Whether the sample to be tested is a customer who has applied for registration within M months; Whether the sample to be tested is a customer with zero overdue credit business in the past 6 months; Whether the sample to be tested is a customer whose average credit card repayment rate in the past three months is less than N.
7. The method according to any one of claims 1 to 6, wherein: After performing feature conversion on the retail credit prediction data, the data is substituted into the credit default probability sub-model to calculate the credit default probability of the sample to be predicted. The feature conversion step includes: Based on the feature type of the retail credit prediction data that needs to be substituted into the credit default probability sub-model, select the WOE method or the continuous method for feature conversion.
8. The method according to claim 7, wherein: The continuous method for feature conversion includes the following methods: directly selecting the original value, calculating the square of the original data, calculating the square root of the original data, calculating the cube root of the original data, or calculating the natural logarithm of the original data to perform continuous feature conversion.
9. The method according to any one of claims 1 to 8, wherein: The credit default probability sub-model is a model constructed based on sample retail credit prediction data and credit default probability using logistic regression based on the existing user population.
10. The method according to any one of claims 1 to 9, wherein: The retail credit prediction data is selected from: one, two, three, four, five or six of the following: the average utilization rate of revolving loans in the past three months, the average number of cash withdrawals from credit cards, the number of months with a credit card utilization rate > 90% in the past three months, the number of months with a credit card interest rate > 0 in the past three months, the minimum balance of deposit accounts at a certain point in time in the past six months, and the average monthly AUM (personal financial assets) in the past six months.
11. The method according to claim 10, wherein: The steps to calculate the probability of credit default include: The feature conversion is performed on the average utilization rate of revolving loans in the past three months, the average number of credit card cash withdrawals, the number of months with a credit card utilization rate > 90% in the past three months, the number of months with a credit card interest rate > 0 in the past three months, the minimum balance of deposit accounts in the past six months, and the average monthly AUM (personal financial assets) in the past six months. It is preferred to use a continuous conversion method for the average utilization rate of revolving loans in the past three months; use the WOE conversion method for the average number of credit card withdrawals; use a continuous conversion method for the number of months in which the credit card utilization rate in the past three months is >90%; use the WOE conversion method for the number of months in which the credit card interest is >0 in the past three months; use a continuous conversion method for the minimum balance of the deposit account at a certain point in time in the past six months; and use a continuous conversion method for the average monthly AUM (personal financial assets) in the past six months. Further preferred is to use the square method to calculate the average utilization rate of the revolving loan limit in the past three months; to use the original value method to calculate the number of months in which the credit card limit utilization rate was >90% in the past three months; to use the logarithm method to calculate the minimum balance of the deposit account at a certain point in time in the past six months; and to use the square root method to calculate the average monthly AUM (personal financial assets) in the past six months.
12. The method according to claim 11, wherein: The converted values of the six features, namely, the average utilization rate of the revolving loan in the past three months, the average number of credit card cash withdrawals, the number of months with a credit card utilization rate > 90% in the past three months, the number of months with a credit card interest rate > 0 in the past three months, the minimum balance of the deposit account at a certain point in time in the past six months, and the average monthly AUM (personal financial assets) in the past six months, are substituted into the sub-model constructed by logistic regression based on the sample retail credit prediction data and credit default probability to calculate the default probability of the sample to be predicted.
13. The method according to claim 12, wherein: The sub-model is shown in the following formula 1: Where k is the number of features entering the model, preferably k is 6, α is the intercept, the value range is (-2.861, -2.5016), and the optimal value is -2.681; β1 is the average utilization rate of the revolving loan in the past three months, with a value range of (-0.6556, -0.5652), and the optimal value is -0.61; β2 is the average number of cash withdrawals from credit cards, with a value range of (-0.637, -0.528) and an optimal value of -0.582; β3 is the number of months in which the credit card limit utilization rate is greater than 90% in the past three months, with a value range of (-0.4641, -0.3704) and an optimal value of -0.417; β4 is the number of months in which the credit card interest was > 0 in the past three months, with a value range of (-0.2974, -0.1924) and an optimal value of -0.245; β5 is the minimum balance of the deposit account in the past 6 months, with a value range of (-0.1345, -0.0686) and an optimal value of -0.102; β6 is the average monthly AUM (personal financial assets) in the past 6 months, with a value range of (-0.1243, -0.0547) and an optimal value of -0.09; x1 is the WOE conversion value of the average utilization rate of the revolving loan in the past three months generated in the feature conversion step; x2 is the square transformation value of the average number of credit card cash withdrawals generated in the feature transformation step; x3 is the original value of the number of months in which the credit card limit utilization rate was > 90% in the past three months, generated by the feature conversion step; x4 is the WOE conversion value of the number of months with credit card interest > 0 in the past three months generated in the feature conversion step; x5 is the logarithmic transformation value of the minimum balance of the deposit account at a certain point in time in the past 6 months generated by the feature conversion step; x6 is the square root transformed value of the average monthly AUM (personal financial assets) for the past 6 months generated in the feature transformation step.
14. The method according to claim 13, wherein: After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower: Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
15. The method according to any one of claims 1 to 9, wherein: The retail credit prediction data is selected from: one, two, three, four, five, six or seven of the remaining available credit limit of the credit card in the current month, the installment balance of the credit card in the current month, the number of months from the minimum balance of the deposit account in the past three months, the number of overdue payments of the credit customer > 0 in the past three months, the number of overdue payments of the credit customer > 1 in the past three months, the number of overdue payments of the credit customer > 2 in the past three months, and the number of overdue payments of the credit customer > 3 in the past three months.
16. The method according to claim 15, wherein: The steps to calculate the probability of credit default include: The remaining available credit limit of the credit card in the current month, the installment balance of the credit card in the current month, the number of months from the minimum balance of the deposit account in the past three months, the number of overdue payments of credit customers > 0 in the past three months, the number of overdue payments of credit customers > 1 in the past three months, the number of overdue payments of credit customers > 2 in the past three months, and the number of overdue payments of credit customers > 3 in the past three months are converted into features. It is preferred to use the continuous conversion method for the remaining available credit limit of the current month of the credit card; the continuous conversion method is used for the installment balance of the current month of the credit card; the WOE conversion method is used for the number of months from the minimum balance of the deposit account in the past three months; the WOE conversion method is used for the number of overdue payments of the credit customer in the past three months > 0; the continuous conversion method is used for the number of overdue payments of the credit customer in the past three months > 1; the continuous conversion method is used for the number of overdue payments of the credit customer in the past three months > 2; the continuous conversion method is used for the number of overdue payments of the credit customer in the past three months > 3; Further preferably, the logarithm of the remaining available credit limit of the credit card in the current month is used for calculation; the logarithm of the installment balance of the credit card in the current month is used for calculation; the square of the number of overdue payments of the credit customer in the past three months > 1 is used for calculation; the square root of the number of overdue payments of the credit customer in the past three months > 2 is used for calculation; the square root of the number of overdue payments of the credit customer in the past three months > 3 is used for calculation.
17. The method according to claim 15, wherein: The converted values of the seven features, including the remaining available credit limit of the credit card in the current month, the installment balance of the credit card in the current month, the number of months from the minimum balance of the deposit account in the past three months, the number of overdue payments of credit customers > 0 in the past three months, the number of overdue payments of credit customers > 1 in the past three months, the number of overdue payments of credit customers > 2 in the past three months, and the number of overdue payments of credit customers > 3 in the past three months, are substituted into the sub-model constructed by logistic regression based on the sample retail credit prediction data to calculate the default probability of the sample to be predicted.
18. The method according to claim 17, wherein: The sub-model is shown in the following formula 2: Where k is the number of features entering the model, and k is preferably 7; α is the intercept, the value range is (2.61, 2.6512), and the optimal value is 2.631; β1 is the remaining available credit limit of the credit card in the current month, with a value range of (-0.2514, -0.2464) and an optimal value of -0.249; β2 is the current monthly installment balance of the credit card, with a value range of (-0.9655, -0.9299) and an optimal value of -0.948; β3 is the number of months from the current month when the deposit account has the minimum balance in the past three months. The value range is (-0.3237, -0.3099), and the optimal value is -0.317; β4 is the number of times the credit customer has overdue payments > 0 in the past three months, with a value range of (-0.252, -0.2402) and an optimal value of -0.246; β5 is the number of months in which the credit limit utilization rate of the credit card in the past 12 months is greater than 90%, with a value range of (-0.5863, -0.5587) and an optimal value of -0.573; β6 is the average repayment rate of credit customers in the past 6 months, with a value range of (-0.1131, -0.1075) and an optimal value of -0.11; β7 is the maximum percentage of (interest / limit) of the credit card in the past three months, with a value range of (-0.3407, -0.3209) and an optimal value of -0.331; x1 is the logarithmic transformation value of the remaining available credit limit of the credit card in the current month generated in the feature transformation step; x2 is the logarithmic transformation value of the current monthly installment balance of the credit card generated in the feature transformation step; x3 is the WOE conversion value of the minimum balance of the deposit account in the past three months generated by the feature conversion step, which is the number of months from now; x4 is the WOE conversion value of the number of credit customers with overdue payments > 0 in the past three months generated in the feature conversion step; x5 is the square transformation value of the number of months with a credit card limit utilization rate > 90% in the past 12 months generated by the feature conversion step; x6 is the square root transformed value of the average repayment rate of credit customers in the past 6 months generated in the feature conversion step; x7 is the cube root conversion value of the maximum percentage of credit card (interest / limit) in the past three months generated by the feature conversion step.
19. The method according to claim 18, wherein: After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower: Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
20. The method according to any one of claims 1 to 9, wherein: The retail credit prediction data is selected from: the remaining available credit limit of the credit card in the current month, the number of months since the last overdue payment of the credit customer in the past 12 months>0, the current account age of the credit customer, the number of months in the past 6 months when the utilization rate of the revolving loan limit was greater than 70%, and one, two, three, four or five of the percentages of the total amount of interest / consumption and cash withdrawals of the credit card in the past 12 months.
21. The method according to claim 20, wherein: The steps to calculate the probability of credit default include: The remaining available credit limit of the credit card in the current month, the number of months since the last overdue payment of the credit customer in the past 12 months>0, the current account age of the credit customer, the number of months in the past 6 months when the utilization rate of the revolving loan limit was greater than 70%, and the percentage of the total amount of interest / consumption and cash withdrawal of the credit card in the past 12 months are converted into features. It is preferred to use the continuous conversion method for the remaining available credit limit of the current month of the credit card; the WOE conversion method is used for the number of months from the last overdue payment of the credit customer in the past 12 months > 0; the continuous conversion method is used for the current account age of the credit customer; the continuous conversion method is used for the number of months in which the credit limit utilization rate of the revolving loan is greater than 70% in the past 6 months; the continuous conversion method is used for the percentage of interest / total amount of consumption and cash withdrawal of the credit card in the past 12 months; Further preferred is to use the logarithm of the remaining available credit limit of the credit card in the current month; to use the cube root of the number of months when the credit customer's current account utilization rate is >90%; to use the square root of the number of months when the utilization rate of the revolving loan limit in the past 6 months was greater than 70%; and to use the square of the percentage of the total amount of interest / consumption and cash withdrawals of the credit card in the past 12 months.
22. The method according to claim 20, wherein: The converted values of the five features, namely, the remaining available credit limit of the credit card in the current month, the number of months since the last overdue payment of the credit customer in the past 12 months>0, the current account age of the credit customer, the number of months in the past 6 months when the utilization rate of the revolving loan limit was greater than 70%, and the percentage of the total amount of interest / consumption and cash withdrawals of the credit card in the past 12 months, are substituted into the sub-model constructed by logistic regression based on the sample retail credit prediction data and credit default probability to calculate the default probability of the sample to be predicted.
23. The method according to claim 22, wherein: The sub-model is shown in Formula 3 below: Where k is the number of features entering the model, and k is preferably 5; α is the intercept, with a range of values of (2.2139, 2.3355) and an optimal value of 2.275; β1 is the remaining available credit limit of the credit card in the current month, with a range of values of (-0.3212, -0.3148) and an optimal value of -0.318; β2 is the number of months from the last overdue payment of the credit customer in the past 12 months > 0, with a range of values of (0.6342, 0.6486) and an optimal value of 0.641; β3 is the current account age of the credit customer , the value range is (-0.6442, -0.6232), and the optimal value is -0.634; β4 is the number of months in which the utilization rate of the revolving loan limit is greater than 70% in the past 6 months, the value range is (-0.2966, -0.2786), and the optimal value is -0.288; β5 is the percentage of interest / consumption and cash withdrawal of credit cards in the past 12 months, the value range is (-0.2645, -0.2461), and the optimal value is -0.255; x1 is the logarithmic transformation value of the remaining available credit limit of the credit card in the current month generated in the feature transformation step; x2 is the WOE conversion value of the credit customer whose most recent overdue payment in the past 12 months is greater than 0 months ago, generated by the feature conversion step; x3 is the square transformation value of the current age of the credit customer generated in the feature transformation step; x4 is the cube root conversion value of the number of months in the past 6 months when the utilization rate of the revolving loan was greater than 70% generated in the feature conversion step; x5 is the square root conversion value of the total amount of interest / consumption and cash withdrawal of the credit card in the past 12 months generated in the feature conversion step.
24. The method according to claim 23, wherein: After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower: Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
25. The method according to any one of claims 1 to 9, wherein: The retail credit prediction data is selected from: the remaining available credit limit of the credit card in the current month, the number of overdue payments of the credit customer in the past 12 months > 0, the current account age of the credit customer, the average utilization rate of the installment limit of the credit card in the past 6 months, the number of months with the credit card limit utilization rate > 70% in the past 12 months, the percentage of interest / consumption and total cash withdrawal amount of the credit card in the past 12 months, the minimum utilization rate of the revolving loan limit in the past 6 months, and the number of months with the credit card repayment rate > 90% in the past 12 months.
26. The method according to claim 25, wherein: The steps to calculate the probability of credit default include: The remaining available credit limit of the credit card in the current month, the number of overdue payments of credit customers in the past 12 months > 0, the current account age of credit customers, the average utilization rate of the credit card installment limit in the past 6 months, the number of months with a credit card limit utilization rate > 70% in the past 12 months, the percentage of interest / consumption and total cash withdrawals of credit cards in the past 12 months, the minimum utilization rate of revolving loans in the past 6 months, and the number of months with a credit card repayment rate > 90% in the past 12 months are converted into features. It is preferred to use a continuous conversion method for the remaining available credit limit of the current month of the credit card; use the WOE method to convert the number of overdue payments of credit customers in the past 12 months > 0; use a continuous conversion method for the current account age of credit customers; use a continuous conversion method for the average utilization rate of the installment credit limit of the credit card in the past 6 months; use a continuous conversion method for the number of months with a credit limit utilization rate > 70% in the past 12 months; use a continuous conversion method for the percentage of the total amount of interest / consumption and cash withdrawals of the credit card in the past 12 months; use a continuous conversion method for the minimum utilization rate of the revolving loan limit in the past 6 months; use a continuous conversion method for the number of months with a credit card repayment rate > 90% in the past 12 months; Further preferably, the remaining available credit limit of the credit card in the current month is calculated by taking the logarithm; the current account age of the credit customer is calculated by taking the original value; the average utilization rate of the installment credit limit of the credit card in the past 6 months is calculated by taking the square; the number of months in the past 12 months when the credit limit utilization rate is greater than 70% is calculated by taking the square root; the percentage of the total amount of interest / consumption and cash withdrawals of the credit card in the past 12 months is calculated by taking the square; the minimum value of the credit limit utilization rate of the revolving loan in the past 6 months is calculated by taking the logarithm; and the number of months in the past 12 months when the repayment rate of the credit card is greater than 90% is calculated by taking the original value.
27. The method according to claim 25, wherein: The converted values of eight features, including the remaining available credit limit of the credit card in the current month, the number of overdue payments of the credit customer > 0 in the past 12 months, the current account age of the credit customer, the average utilization rate of the credit card installment limit in the past 6 months, the number of months with the credit card limit utilization rate > 70% in the past 12 months, the percentage of interest / consumption and total cash withdrawal amount of the credit card in the past 12 months, the minimum utilization rate of the revolving loan limit in the past 6 months, and the number of months with the credit card repayment rate > 90% in the past 12 months, are substituted into the sub-model constructed by logistic regression based on the sample retail credit prediction data to calculate the default probability of the sample to be predicted.
28. The method according to claim 27, wherein: The sub-model is shown in Formula 4 below: Where k is the number of features entering the model, preferably k is 8; α is the intercept, the value range is (1.8206, 1.9124), and the optimal value is 1.867; β1 is the remaining available credit limit of the credit card in the current month, with a value range of (-0.3997, -0.3923), and the optimal value is -0.396; β2 is the number of times the credit customer has overdue payments > 0 in the past 12 months, with a value range of (-0.5279, -0.5179) and an optimal value of -0.523; β3 is the current age of credit customers, with a value range of (-0.6273, -0.6111), and the optimal value is -0.619; β4 is the average utilization rate of the credit card installment limit in the past 6 months, with a value range of (-0.3218, -0.3132) and an optimal value of -0.318; β5 is the number of months in the past 12 months when the credit limit utilization rate is greater than 70%, with a value range of (-0.2822, -0.2714), and the optimal value is -0.277; β6 is the percentage of interest / total amount of consumption and cash withdrawal of credit card in the past 12 months, with a value range of (-0.2588, -0.2486) and an optimal value of -0.254; β7 is the minimum utilization rate of the revolving loan in the past 6 months, with a value range of (-0.2388, -0.2292) and an optimal value of -0.234; β8 is the number of months in which the credit card repayment rate was > 90% in the past 12 months, with a value range of (-0.2318, -0.2204) and an optimal value of -0.226; x1 is the logarithmic transformation value of the remaining available credit limit of the credit card in the current month generated in the feature transformation step; x2 is the original value of the number of times a credit customer has overdue payments > 0 in the past 12 months generated in the feature conversion step; x3 is the square transformation value of the current age of the credit customer generated in the feature transformation step; x4 is the WOE conversion value of the average credit card installment limit utilization rate in the past 6 months generated in the feature conversion step; x5 is the logarithmic transformation value of the number of months with a credit card limit utilization rate > 70% in the past 12 months generated in the feature transformation step; x6 is the square root conversion value of the percentage of interest / consumption and total cash withdrawal amount of the credit card in the past 12 months generated in the feature conversion step; x7 is the square conversion value of the minimum utilization rate of the revolving loan in the past 6 months generated by the feature conversion step; x8 is the original value of the number of months with a credit card repayment rate > 90% in the past 12 months generated by the feature conversion step.
29. The method according to claim 28, wherein: After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower: Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
30. The method according to any one of claims 1 to 9, wherein: The retail credit forecast data is selected from: the number of months from the maximum balance of the deposit account in the past 12 months, the minimum balance of the deposit account in the past 6 months, the current balance of the deposit account, the average monthly AUM (personal financial assets) in the past 6 months, the average balance of the investment and financial management account in the past 6 months, and one, two, three, four, five or six of the maximum values of wage payments in the past 12 months.
31. The method according to claim 30, wherein: The steps to calculate the probability of credit default include: The feature conversion is performed on the number of months from the maximum balance of the deposit account in the past 12 months, the minimum balance of the deposit account in the past 6 months, the current balance of the deposit account, the average monthly AUM (personal financial assets) in the past 6 months, the average balance of the investment and financial management account in the past 6 months, and the maximum value of the salary payment in the past 12 months. It is preferred to use the WOE method to convert the maximum balance of the deposit account in the past 12 months from the present; the continuous conversion method is used for the current account age of the credit customer; the continuous conversion method is used for the current deposit account balance; the continuous conversion method is used for the monthly average AUM (personal financial assets) of the past 6 months; the continuous conversion method is used for the average balance of the investment and financial management account in the past 6 months; the continuous conversion method is used for the maximum value of the salary paid on behalf of the customer in the past 12 months; Further preferred is to use the logarithm of the minimum balance of the deposit account at a certain point in time in the past 6 months; to use the logarithm of the balance of the deposit account at the current point in time; to use the original value of the average monthly AUM (personal financial assets) of the past 6 months; to use the square of the average balance of the investment and financial management account in the past 6 months; and to use the cube root of the maximum value of salary payments on behalf of others in the past 12 months.
32. The method of claim 30, wherein: The converted values of the six features, namely, the number of months from the maximum balance of the deposit account in the past 12 months, the minimum balance of the deposit account in the past 6 months, the current balance of the deposit account, the average monthly AUM (personal financial assets) in the past 6 months, the average balance of the investment and financial management account in the past 6 months, and the maximum value of the wage payment in the past 12 months, are substituted into the sub-model constructed by logistic regression based on the sample retail credit prediction data to calculate the default probability of the sample to be predicted.
33. The method of claim 32, wherein: The sub-model is shown in Formula 5 below: Where k is the number of features entering the model, and k is preferably 6; α is the intercept, the value range is (-2.6066, -2.2583), and the optimal value is -2.432; β1 is the number of months from the current point in time when the deposit account has the largest balance in the past 12 months, with a value range of (-3.0504, -2.2763), and the optimal value is -2.663; β2 is the minimum balance of the deposit account in the past 6 months, with a value range of (-0.1819, -0.1163) and an optimal value of -0.149; β3 is the current deposit account balance, with a value range of (-0.1197, -0.0721), and the optimal value is -0.096; β4 is the average monthly AUM (personal financial assets) in the past 6 months, with a value range of (-0.119, -0.0513) and an optimal value of -0.085; β5 is the average balance of investment and financial management accounts in the past 6 months, with a value range of (-0.5767, -0.2145) and an optimal value of -0.396; β6 is the maximum value of the wage payment in the past 12 months, with a value range of (-0.6459, -0.1799) and an optimal value of -0.413; x1 is the logarithmic transformation value of the maximum balance of the deposit account in the past 12 months generated in the feature conversion step; x2 is the logarithmic transformation value of the minimum balance of the deposit account at a certain point in time in the past 6 months generated by the feature conversion step; x3 is the WOE conversion value of the deposit account balance at the current time point generated by the feature conversion step; x4 is the original value of the average monthly AUM (personal financial assets) for the past 6 months generated in the feature conversion step; x5 is the square transformation value of the average balance of the investment and financial management account in the past 6 months generated by the feature transformation step; x6 is the cube root conversion value of the maximum wage paid on behalf of others in the past 12 months generated in the feature conversion step.
34. The method of claim 33, wherein: After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower: Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
35. A device for calculating retail credit risk, comprising: A data collection module, which is used to obtain retail credit prediction data of samples to be predicted; A module for classifying samples to be predicted, which is used to classify the samples to be predicted based on a decision tree method to determine a sub-model for calculating the probability of credit default; A credit default probability calculation module is used to substitute the retail credit prediction data into the credit default probability sub-model to calculate the credit default probability of the sample to be predicted, and preferably the credit default probability is the credit default probability for credit cards and special installment business.
36. The device according to claim 35, wherein The device executes the steps of the method for calculating retail credit risk according to any one of claims 1 to 34.
37. A system for calculating retail credit risk, characterized in that: The system for calculating retail credit risk comprises: a memory, a processor, and a program for the method for calculating retail credit risk stored in the memory and executable on the processor. When the program for calculating retail credit risk is executed by the processor, the steps of the method for calculating retail credit risk as described in any one of claims 1 to 34 are implemented.
38. A computer storage medium, characterized in that The computer storage medium stores a program for calculating the retail credit risk method, and when the program for calculating the retail credit risk method is executed by the processor, the steps of the method for calculating the retail credit risk according to any one of claims 1 to 34 are implemented.
39. A method for constructing a retail credit risk prediction model for credit card and special installment business, comprising: A data collection step, which obtains the original retail credit prediction data of the sample used to build the model; A data derivation step, which processes derived retail credit forecast data based on the original retail credit forecast data; The feature initial screening step is to perform initial screening on all categories, that is, all features, including the original retail credit forecast data and the derived retail credit forecast data, to obtain features after initial screening; The initial screening data conversion step is to judge the conversion method of the features after the initial screening to confirm whether to use one of the WOE conversion method, the dummy feature conversion method and the continuous conversion method for feature conversion, and use the best method to convert each feature after the initial screening; The feature fine screening step is to perform in-depth screening on the initially screened features after feature conversion to obtain finely screened features; The credit default probability modeling step is to select the logistic regression method to build the model based on the relationship between the carefully screened features and the probability of credit default, and confirm the method used to calculate the credit default probability; The data samples obtained in the data collection step are samples of customers who have used credit cards and special installment services.
40. The method of claim 39, wherein: In the data collection step, the original retail credit prediction data of the samples obtained for building the model include: Credit card basic data, which is based on all available data during the sample user's credit card creation and usage process. Basic data on personal loans, which is all available data based on the loan application and usage behavior of sample users. Basic customer information data, which is based on the attributes of the sample users themselves but is not directly related to their behavior in financial institutions. Basic data on personal financial assets, which includes all other financial assets and financial transaction data of sample users in financial institutions that are not related to credit cards and loans.
41. The method of claim 39, wherein: In the data derivation step, the derived retail credit prediction data processed based on the original retail credit prediction data refers to data obtained by processing the collected original retail credit prediction data based on the time dimension, space dimension, frequency dimension, and statistical information dimension; Preferably, the derived retail credit forecast data includes but is not limited to: Derived retail credit forecast data obtained by processing based on sample relationship length, Derivative retail credit forecast data obtained by processing time interval variables, Derivative retail credit forecast data obtained by processing based on the frequency of sample behavior, Derivative retail credit forecast data obtained by processing the current time point of the sample, Derivative retail credit forecast data obtained by processing based on sample continuous behavior, Derived retail credit forecast data obtained by processing sample data based on statistical information dimensions.
42. The method according to any one of claims 39 to 41, wherein: The feature initial screening step includes the following steps: The first preliminary screening step is to screen the features based on the missing data of each feature of the sample used to build the model. The second initial screening step is to screen the features based on the fact that a single value of a feature sample is too high. The third preliminary screening step is to calculate the information IV value of each feature to perform preliminary screening of the features; The order of the first preliminary screening step, the second preliminary screening step and the third preliminary screening step can be any order. The fourth preliminary screening step uses a stepwise discrimination algorithm to perform preliminary screening of features after the first to third preliminary screenings; The fifth preliminary screening step is to conduct preliminary screening of the features after the fourth preliminary screening step based on the consistency between the risk characteristics of each feature itself and the actual real results of the samples used for model construction.
43. The method according to any one of claims 39 to 42, wherein: Also includes: The sample selection step is used to screen all users and obtain samples of credit cards and special installment services for model construction before the data collection step. Preferably, the sample selection step includes classifying all sample users based on a decision tree, and the classification basis includes but is not limited to: Whether a user is a customer of a customer who has applied to register for credit business; Whether a user is a customer who has applied for registration within M months; Whether a user is a customer with zero overdue credit business in the past six months; Whether a user is a customer whose average credit card repayment rate in the past three months is less than N.
44. The method according to any one of claims 39 to 43, wherein: In the initial screening data conversion step, the conversion method of the features after the initial screening is determined based on the concentration and data type of the features after the initial screening.
45. The method of claim 44, wherein: The initial screening data conversion step includes the following steps based on the judgment of concentration and data type: Classify the data type of each feature into character variables and numeric variables. For character variables, dummy feature conversion is used to perform initial screening data conversion. The process of further classifying numerical variables includes the following sub-steps: If the value of the numeric variable is less than n, the WOE conversion method is used to convert the initial screening data. If the value of the numerical variable is more than n, further judge if the value of the continuous variable is large and the concentration of a single value is greater than m%, then the WOE conversion method is used; if the concentration of a single value is less than or equal to m%, then the continuous conversion method is used. Preferably, n and m are both positive integers, wherein n=5-10, and m=90-99.
46. The method of claim 45, wherein: Also includes: For the features that are confirmed to adopt the continuous conversion method, the optimal conversion method is selected based on the correlation between the feature and credit default under different continuous conversion methods to perform the continuous feature conversion of the feature. Preferably, the continuous feature conversion is performed by directly selecting the original value, calculating the square of the original data, calculating the square root of the original data, calculating the cube root of the original data, or calculating the natural logarithm of the original data.
47. The method according to any one of claims 39 to 46, wherein: The feature fine screening steps include: The first fine screening step is to screen the features based on the stepwise regression algorithm, the F test and the T test to determine the significance of the features. The second fine screening step is to calculate the variance inflation factor based on each feature and eliminate the features with higher variance inflation factors to screen the features. The third fine screening step is to analyze the characteristics after the first fine screening step and the second fine screening step based on logistic regression to see whether the characteristic coefficients are consistent with the trend of the prediction results for credit default so as to further perform feature screening.
48. The method according to any one of claims 39 to 47, wherein: The credit default probability modeling step substitutes the features selected in the feature fine screening step into the Sigmoid function to perform logistic regression to calculate the credit default probability model.
49. A device for constructing a retail credit risk prediction model for credit card and special installment business, characterized in that: The device comprises: A data collection module, which is used to obtain raw retail credit prediction data of samples used to build a model; A data derivation module, which is used to process derived retail credit forecast data based on the original retail credit forecast data; A feature initial screening module, which is used to perform initial screening on all categories, that is, all features, including the original retail credit forecast data and the derived retail credit forecast data, to obtain features after initial screening; The initial screening data conversion module is used to determine the conversion method of the features after the initial screening to confirm whether to use one of the WOE conversion method, the dummy feature conversion method and the continuous conversion method for feature conversion, and to use the best method for feature conversion for each feature after the initial screening; A feature fine screening module is used to perform in-depth screening on the initially screened features after feature conversion to obtain finely screened features; The credit default probability modeling module is used to select the logistic regression method to build a model based on the probability relationship between the finely screened features and credit default, and confirm the method used to calculate the credit default probability. The data samples obtained by the data collection module are customer samples who have used credit cards and special installment services.
50. The apparatus of claim 49, wherein: The device executes the steps of the method for constructing a retail credit risk prediction model as described in any one of claims 29 to 38.
51. A system for building a retail credit risk prediction model for credit card and special installment business, characterized in that: The system includes: a memory, a processor, and a program for constructing a retail credit risk prediction model stored in the memory and executable on the processor. When the program for constructing a retail credit risk prediction model is executed by the processor, the steps of constructing a retail credit risk prediction model as described in any one of claims 39 to 48 are implemented.
Citation Information
Patent Citations
A credit risk assessment method and apparatus based on logistic regression technology
CN112686749B