\n", " | LoanNr_ChkDgt | \n", "Name | \n", "City | \n", "State | \n", "Zip | \n", "Bank | \n", "BankState | \n", "NAICS | \n", "ApprovalDate | \n", "ApprovalFY | \n", "Term | \n", "NoEmp | \n", "NewExist | \n", "CreateJob | \n", "RetainedJob | \n", "FranchiseCode | \n", "UrbanRural | \n", "RevLineCr | \n", "LowDoc | \n", "ChgOffDate | \n", "DisbursementDate | \n", "DisbursementGross | \n", "BalanceGross | \n", "MIS_Status | \n", "ChgOffPrinGr | \n", "GrAppv | \n", "SBA_Appv | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "1000014003 | \n", "ABC HOBBYCRAFT | \n", "EVANSVILLE | \n", "IN | \n", "47711 | \n", "FIFTH THIRD BANK | \n", "OH | \n", "451120 | \n", "28-Feb-97 | \n", "1997 | \n", "84 | \n", "4 | \n", "2.0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "N | \n", "Y | \n", "NaN | \n", "28-Feb-99 | \n", "$60,000.00 | \n", "$0.00 | \n", "P I F | \n", "$0.00 | \n", "$60,000.00 | \n", "$48,000.00 | \n", "
1 | \n", "1000024006 | \n", "LANDMARK BAR & GRILLE (THE) | \n", "NEW PARIS | \n", "IN | \n", "46526 | \n", "1ST SOURCE BANK | \n", "IN | \n", "722410 | \n", "28-Feb-97 | \n", "1997 | \n", "60 | \n", "2 | \n", "2.0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "N | \n", "Y | \n", "NaN | \n", "31-May-97 | \n", "$40,000.00 | \n", "$0.00 | \n", "P I F | \n", "$0.00 | \n", "$40,000.00 | \n", "$32,000.00 | \n", "
2 | \n", "1000034009 | \n", "WHITLOCK DDS, TODD M. | \n", "BLOOMINGTON | \n", "IN | \n", "47401 | \n", "GRANT COUNTY STATE BANK | \n", "IN | \n", "621210 | \n", "28-Feb-97 | \n", "1997 | \n", "180 | \n", "7 | \n", "1.0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "N | \n", "N | \n", "NaN | \n", "31-Dec-97 | \n", "$287,000.00 | \n", "$0.00 | \n", "P I F | \n", "$0.00 | \n", "$287,000.00 | \n", "$215,250.00 | \n", "
3 | \n", "1000044001 | \n", "BIG BUCKS PAWN & JEWELRY, LLC | \n", "BROKEN ARROW | \n", "OK | \n", "74012 | \n", "1ST NATL BK & TR CO OF BROKEN | \n", "OK | \n", "0 | \n", "28-Feb-97 | \n", "1997 | \n", "60 | \n", "2 | \n", "1.0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "N | \n", "Y | \n", "NaN | \n", "30-Jun-97 | \n", "$35,000.00 | \n", "$0.00 | \n", "P I F | \n", "$0.00 | \n", "$35,000.00 | \n", "$28,000.00 | \n", "
4 | \n", "1000054004 | \n", "ANASTASIA CONFECTIONS, INC. | \n", "ORLANDO | \n", "FL | \n", "32801 | \n", "FLORIDA BUS. DEVEL CORP | \n", "FL | \n", "0 | \n", "28-Feb-97 | \n", "1997 | \n", "240 | \n", "14 | \n", "1.0 | \n", "7 | \n", "7 | \n", "1 | \n", "0 | \n", "N | \n", "N | \n", "NaN | \n", "14-May-97 | \n", "$229,000.00 | \n", "$0.00 | \n", "P I F | \n", "$0.00 | \n", "$229,000.00 | \n", "$229,000.00 | \n", "
\n", " | State | \n", "BankState | \n", "Term | \n", "NoEmp | \n", "NewExist | \n", "CreateJob | \n", "RetainedJob | \n", "UrbanRural | \n", "RevLineCr | \n", "LowDoc | \n", "MIS_Status | \n", "GrAppv | \n", "SBA_Appv | \n", "NAICS_abbrev | \n", "Real_Estate | \n", "SBA_Appv_% | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "IN | \n", "OH | \n", "84 | \n", "4 | \n", "2.0 | \n", "0 | \n", "0 | \n", "0 | \n", "N | \n", "Y | \n", "0 | \n", "60000.0 | \n", "48000.0 | \n", "45 | \n", "0 | \n", "0.80 | \n", "
1 | \n", "IN | \n", "IN | \n", "60 | \n", "2 | \n", "2.0 | \n", "0 | \n", "0 | \n", "0 | \n", "N | \n", "Y | \n", "0 | \n", "40000.0 | \n", "32000.0 | \n", "72 | \n", "0 | \n", "0.80 | \n", "
2 | \n", "IN | \n", "IN | \n", "180 | \n", "7 | \n", "1.0 | \n", "0 | \n", "0 | \n", "0 | \n", "N | \n", "N | \n", "0 | \n", "287000.0 | \n", "215250.0 | \n", "62 | \n", "0 | \n", "0.75 | \n", "
3 | \n", "OK | \n", "OK | \n", "60 | \n", "2 | \n", "1.0 | \n", "0 | \n", "0 | \n", "0 | \n", "N | \n", "Y | \n", "0 | \n", "35000.0 | \n", "28000.0 | \n", "0 | \n", "0 | \n", "0.80 | \n", "
4 | \n", "FL | \n", "FL | \n", "240 | \n", "14 | \n", "1.0 | \n", "7 | \n", "7 | \n", "0 | \n", "N | \n", "N | \n", "0 | \n", "229000.0 | \n", "229000.0 | \n", "0 | \n", "1 | \n", "1.00 | \n", "
\n", " | accuracy | \n", "approved_interest_rate_25 | \n", "approved_interest_rate_50 | \n", "approved_interest_rate_75 | \n", "approved_interest_rate_cnt | \n", "approved_loan_25 | \n", "approved_loan_50 | \n", "approved_loan_75 | \n", "approved_loan_cnt | \n", "approved_loan_total | \n", "fn | \n", "fp | \n", "rejected_loan_25 | \n", "rejected_loan_50 | \n", "rejected_loan_75 | \n", "rejected_loan_cnt | \n", "rejected_loan_total | \n", "tn | \n", "tp | \n", "TrainingJobName | \n", "portfolio_value | \n", "threshold | \n", "portfolio_return | \n", "threshold_2_digit | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
98 | \n", "0.935932 | \n", "0.05 | \n", "0.057500 | \n", "0.076087 | \n", "73114.0 | \n", "43000.0 | \n", "100000.0 | \n", "253725.0 | \n", "73114.0 | \n", "1.570100e+10 | \n", "2899.0 | \n", "2878.0 | \n", "23000.0 | \n", "45000.0 | \n", "100000.0 | \n", "15729.0 | \n", "1.541148e+09 | \n", "70215.0 | \n", "12851.0 | \n", "hpo-threshold-190808-1957-102-2cc59551 | \n", "841421888.0 | \n", "0.359 | \n", "0.053590 | \n", "0.35 | \n", "
117 | \n", "0.935932 | \n", "0.05 | \n", "0.057500 | \n", "0.076087 | \n", "73114.0 | \n", "43000.0 | \n", "100000.0 | \n", "253725.0 | \n", "73114.0 | \n", "1.570100e+10 | \n", "2899.0 | \n", "2878.0 | \n", "23000.0 | \n", "45000.0 | \n", "100000.0 | \n", "15729.0 | \n", "1.541148e+09 | \n", "70215.0 | \n", "12851.0 | \n", "hpo-threshold-190808-1957-083-afccf0e4 | \n", "841421888.0 | \n", "0.358 | \n", "0.053590 | \n", "0.35 | \n", "
41 | \n", "0.935932 | \n", "0.05 | \n", "0.057143 | \n", "0.076087 | \n", "72889.0 | \n", "43000.0 | \n", "100000.0 | \n", "254000.0 | \n", "72889.0 | \n", "1.566342e+10 | \n", "2825.0 | \n", "3029.0 | \n", "23500.0 | \n", "48000.0 | \n", "100000.0 | \n", "15954.0 | \n", "1.578729e+09 | \n", "70064.0 | \n", "12925.0 | \n", "hpo-threshold-190808-1957-159-587c4c83 | \n", "840656704.0 | \n", "0.349 | \n", "0.053670 | \n", "0.34 | \n", "
36 | \n", "0.935932 | \n", "0.05 | \n", "0.057143 | \n", "0.076087 | \n", "72888.0 | \n", "43000.0 | \n", "100000.0 | \n", "254000.0 | \n", "72888.0 | \n", "1.566341e+10 | \n", "2825.0 | \n", "3030.0 | \n", "23500.0 | \n", "48000.0 | \n", "100000.0 | \n", "15955.0 | \n", "1.578734e+09 | \n", "70063.0 | \n", "12925.0 | \n", "hpo-threshold-190808-1957-164-3e1d3949 | \n", "840654976.0 | \n", "0.342 | \n", "0.053670 | \n", "0.34 | \n", "
31 | \n", "0.935932 | \n", "0.05 | \n", "0.057143 | \n", "0.076087 | \n", "72888.0 | \n", "43000.0 | \n", "100000.0 | \n", "254000.0 | \n", "72888.0 | \n", "1.566341e+10 | \n", "2825.0 | \n", "3030.0 | \n", "23500.0 | \n", "48000.0 | \n", "100000.0 | \n", "15955.0 | \n", "1.578734e+09 | \n", "70063.0 | \n", "12925.0 | \n", "hpo-threshold-190808-1957-169-ceecb349 | \n", "840654976.0 | \n", "0.344 | \n", "0.053670 | \n", "0.34 | \n", "
51 | \n", "0.935932 | \n", "0.05 | \n", "0.057732 | \n", "0.078571 | \n", "74145.0 | \n", "42400.0 | \n", "100000.0 | \n", "252000.0 | \n", "74145.0 | \n", "1.591500e+10 | \n", "3314.0 | \n", "2262.0 | \n", "20000.0 | \n", "40650.0 | \n", "92325.0 | \n", "14698.0 | \n", "1.327143e+09 | \n", "70831.0 | \n", "12436.0 | \n", "hpo-threshold-190808-1957-149-5a6520ed | \n", "840528832.0 | \n", "0.405 | \n", "0.052814 | \n", "0.40 | \n", "
13 | \n", "0.935932 | \n", "0.05 | \n", "0.057732 | \n", "0.078571 | \n", "74144.0 | \n", "42475.0 | \n", "100000.0 | \n", "252000.0 | \n", "74144.0 | \n", "1.591499e+10 | \n", "3314.0 | \n", "2263.0 | \n", "20000.0 | \n", "40600.0 | \n", "92250.0 | \n", "14699.0 | \n", "1.327158e+09 | \n", "70830.0 | \n", "12436.0 | \n", "hpo-threshold-190808-1957-187-4f6257db | \n", "840522496.0 | \n", "0.400 | \n", "0.052813 | \n", "0.40 | \n", "
193 | \n", "0.935932 | \n", "0.05 | \n", "0.057732 | \n", "0.078571 | \n", "74144.0 | \n", "42475.0 | \n", "100000.0 | \n", "252000.0 | \n", "74144.0 | \n", "1.591499e+10 | \n", "3314.0 | \n", "2263.0 | \n", "20000.0 | \n", "40600.0 | \n", "92250.0 | \n", "14699.0 | \n", "1.327158e+09 | \n", "70830.0 | \n", "12436.0 | \n", "hpo-threshold-190808-1957-007-680a2308 | \n", "840522496.0 | \n", "0.402 | \n", "0.052813 | \n", "0.40 | \n", "
2 | \n", "0.935932 | \n", "0.05 | \n", "0.057732 | \n", "0.077273 | \n", "73735.0 | \n", "42687.5 | \n", "100000.0 | \n", "253000.0 | \n", "73735.0 | \n", "1.583827e+10 | \n", "3138.0 | \n", "2496.0 | \n", "20300.0 | \n", "45000.0 | \n", "99127.0 | \n", "15108.0 | \n", "1.403881e+09 | \n", "70597.0 | \n", "12612.0 | \n", "hpo-threshold-190808-1957-198-6e7e67a5 | \n", "840333760.0 | \n", "0.387 | \n", "0.053057 | \n", "0.38 | \n", "
63 | \n", "0.935932 | \n", "0.05 | \n", "0.057732 | \n", "0.077273 | \n", "73734.0 | \n", "42700.0 | \n", "100000.0 | \n", "253000.0 | \n", "73734.0 | \n", "1.583824e+10 | \n", "3138.0 | \n", "2497.0 | \n", "20300.0 | \n", "45000.0 | \n", "99100.0 | \n", "15109.0 | \n", "1.403906e+09 | \n", "70596.0 | \n", "12612.0 | \n", "hpo-threshold-190808-1957-137-e30b6471 | \n", "840323904.0 | \n", "0.383 | \n", "0.053057 | \n", "0.38 | \n", "
\n", " | Accuracy | \n", "Precision_0 | \n", "Precision_1 | \n", "Recall_0 | \n", "Recall_1 | \n", "
---|---|---|---|---|---|
Naive Model | \n", "0.822721 | \n", "0.822721 | \n", "NaN | \n", "1.000000 | \n", "0.000000 | \n", "
Random Forest Model (0.5 Threshold) | \n", "0.935302 | \n", "0.944246 | \n", "0.883336 | \n", "0.979177 | \n", "0.731683 | \n", "
Random Forest Model (Optimal Threshold) | \n", "0.934975 | \n", "0.960350 | \n", "0.817026 | \n", "0.960626 | \n", "0.815937 | \n", "