Chat with us, powered by LiveChat Codelist Codelist Var. # Variable Name Description Variable Type Code Description 1.   OBS# - STUDENT SOLUTION USA

Codelist

Codelist
Var. # Variable Name Description Variable Type Code Description
1.   OBS# Observation No. Categorical
2.   CHK_ACCT Checking account status Categorical 0 : < 0 DM
1: 0 < …< 200 DM
2 : => 200 DM
3: no checking account
3.   DURATION Duration of credit in months Numerical
4.   HISTORY Credit history Categorical 0: no credits taken
1: all credits at this bank paid back duly
2: existing credits paid back duly till now
3: delay in paying off in the past
4: critical account
5.   NEW_CAR Purpose of credit Binary car (new) 0: No, 1: Yes
6. USED_CAR Purpose of credit Binary car (used) 0: No, 1: Yes
7. FURNITURE Purpose of credit Binary furniture/equipment 0: No, 1: Yes
8. RADIO/TV Purpose of credit Binary radio/television 0: No, 1: Yes
9. EDUCATION Purpose of credit Binary education 0: No, 1: Yes
10. RETRAINING Purpose of credit Binary retraining 0: No, 1: Yes
11. AMOUNT Credit amount Numerical
12. SAV_ACCT Average balance in savings account Categorical 0 : < 100 DM
1 : 100<= … < 500 DM
2 : 500<= … < 1000 DM
3 : =>1000 DM
4 : unknown/ no savings account
13. EMPLOYMENT Present employment since Categorical 0 : unemployed
1: < 1 year
2 : 1 <= … < 4 years
3 : 4 <=… < 7 years
4 : >= 7 years
14. INSTALL_RATE Installment rate as % of disposable income Numerical
15. MALE_DIV Applicant is male and divorced Binary 0: No, 1: Yes
16. MALE_SINGLE Applicant is male and single Binary 0: No, 1: Yes
17. MALE_MAR_WID Applicant is male and married or a widower Binary 0: No, 1: Yes
18. CO-APPLICANT Application has a co-applicant Binary 0: No, 1: Yes
19. GUARANTOR Applicant has a guarantor Binary 0: No, 1: Yes
20. PRESENT_RESIDENT Present resident since – years Categorical 0: <= 1 year
1<…<=2 years
2<…<=3 years
3:>4years
21. REAL_ESTATE Applicant owns real estate Binary 0: No, 1: Yes
22. PROP_UNKN_NONE Applicant owns no property (or unknown) Binary 0: No, 1: Yes
23. AGE Age in years Numerical
24. OTHER_INSTALL Applicant has other installment plan credit Binary 0: No, 1: Yes
25. RENT Applicant rents Binary 0: No, 1: Yes
26. OWN_RES Applicant owns residence Binary 0: No, 1: Yes
27. NUM_CREDITS Number of existing credits at this bank Numerical
28. JOB Nature of job Categorical 0 : unemployed/ unskilled – non-resident
1 : unskilled – resident
2 : skilled employee / official
3 : management/ self-employed/highly qualified employee/ officer
29. NUM_DEPENDENTS Number of people for whom liable to provide maintenance Numerical
30. TELEPHONE Applicant has phone in his or her name Binary 0: No, 1: Yes
31. FOREIGN Foreign worker Binary 0: No, 1: Yes
32 RESPONSE Credit rating is good Binary 0: No, 1: Yes

Data

OBS# CHK_ACCT DURATION HISTORY NEW_CAR USED_CAR FURNITURE RADIO/TV EDUCATION RETRAINING AMOUNT SAV_ACCT EMPLOYMENT INSTALL_RATE MALE_DIV MALE_SINGLE MALE_MAR_or_WID CO-APPLICANT GUARANTOR PRESENT_RESIDENT REAL_ESTATE PROP_UNKN_NONE AGE OTHER_INSTALL RENT OWN_RES NUM_CREDITS JOB NUM_DEPENDENTS TELEPHONE FOREIGN RESPONSE
1 0 6 4 0 0 0 1 0 0 1169 4 4 4 0 1 0 0 0 4 1 0 67 0 0 1 2 2 1 1 0 1
2 1 48 2 0 0 0 1 0 0 5951 0 2 2 0 0 0 0 0 2 1 0 22 0 0 1 1 2 1 0 0 0
3 3 12 4 0 0 0 0 1 0 2096 0 3 2 0 1 0 0 0 3 1 0 49 0 0 1 1 1 2 0 0 1
4 0 42 2 0 0 1 0 0 0 7882 0 3 2 0 1 0 0 1 4 0 0 45 0 0 0 1 2 2 0 0 1
5 0 24 3 1 0 0 0 0 0 4870 0 2 3 0 1 0 0 0 4 0 1 53 0 0 0 2 2 2 0 0 0
6 3 36 2 0 0 0 0 1 0 9055 4 2 2 0 1 0 0 0 4 0 1 35 0 0 0 1 1 2 1 0 1
7 3 24 2 0 0 1 0 0 0 2835 2 4 3 0 1 0 0 0 4 0 0 53 0 0 1 1 2 1 0 0 1
8 1 36 2 0 1 0 0 0 0 6948 0 2 2 0 1 0 0 0 2 0 0 35 0 1 0 1 3 1 1 0 1
9 3 12 2 0 0 0 1 0 0 3059 3 3 2 1 0 0 0 0 4 1 0 61 0 0 1 1 1 1 0 0 1
10 1 30 4 1 0 0 0 0 0 5234 0 0 4 0 0 1 0 0 2 0 0 28 0 0 1 2 3 1 0 0 0
11 1 12 2 1 0 0 0 0 0 1295 0 1 3 0 0 0 0 0 1 0 0 25 0 1 0 1 2 1 0 0 0
12 0 48 2 0 0 0 0 0 1 4308 0 1 3 0 0 0 0 0 4 0 0 24 0 1 0 1 2 1 0 0 0
13 1 12 2 0 0 0 1 0 0 1567 0 2 1 0 0 0 0 0 1 0 0 22 0 0 1 1 2 1 1 0 1
14 0 24 4 1 0 0 0 0 0 1199 0 4 4 0 1 0 0 0 4 0 0 60 0 0 1 2 1 1 0 0 0
15 0 15 2 1 0 0 0 0 0 1403 0 2 2 0 0 0 0 0 4 0 0 28 0 1 0 1 2 1 0 0 1
16 0 24 2 0 0 0 1 0 0 1282 1 2 4 0 0 0 0 0 2 0 0 32 0 0 1 1 1 1 0 0 0
17 3 24 4 0 0 0 1 0 0 2424 4 4 4 0 1 0 0 0 4 0 0 53 0 0 1 2 2 1 0 0 1
18 0 30 0 0 0 0 0 0 1 8072 4 1 2 0 1 0 0 0 3 0 0 25 1 0 1 3 2 1 0 0 1
19 1 24 2 0 1 0 0 0 0 12579 0 4 4 0 0 0 0 0 2 0 1 44 0 0 0 1 3 1 1 0 0
20 3 24 2 0 0 0 1 0 0 3430 2 4 3 0 1 0 0 0 2 0 0 31 0 0 1 1 2 2 1 0 1
21 3 9 4 1 0 0 0 0 0 2134 0 2 4 0 1 0 0 0 4 0 0 48 0 0 1 3 2 1 1 0 1
22 0 6 2 0 0 0 1 0 0 2647 2 2 2 0 1 0 0 0 3 1 0 44 0 1 0 1 2 2 0 0 1
23 0 10 4 1 0 0 0 0 0 2241 0 1 1 0 1 0 0 0 3 1 0 48 0 1 0 2 1 2 0 1 1
24 1 12 4 0 1 0 0 0 0 1804 1 1 3 0 1 0 0 0 4 0 0 44 0 0 1 1 2 1 0 0 1
25 3 10 4 0 0 1 0 0 0 2069 4 2 2 0 0 1 0 0 1 0 0 26 0 0 1 2 2 1 0 1 1
26 0 6 2 0 0 1 0 0 0 1374 0 2 1 0 1 0 0 0 2 1 0 36 1 0 1 1 1 1 1 0 1
27 3 6 0 0 0 0 1 0 0 426 0 4 4 0 0 1 0 0 4 0 0 39 0 0 1 1 1 1 0 0 1
28 2 12 1 0 0 0 1 0 0 409 3 2 3 0 0 0 0 0 3 1 0 42 0 1 0 2 2 1 0 0 1
29 1 7 2 0 0 0 1 0 0 2415 0 2 3 0 1 0 0 1 2 1 0 34 0 0 1 1 2 1 0 0 1
30 0 60 3 0 0 0 0 0 1 6836 0 4 3 0 1 0 0 0 4 0 1 63 0 0 1 2 2 1 1 0 0
31 1 18 2 0 0 0 0 0 1 1913 3 1 3 0 0 1 0 0 3 1 0 36 1 0 1 1 2 1 1 0 1
32 0 24 2 0 0 1 0 0 0 4020 0 2 2 0 1 0 0 0 2 0 0 27 1 0 1 1 2 1 0 0 1
33 1 18 2 1 0 0 0 0 0 5866 1 2 2 0 1 0 0 0 2 0 0 30 0 0 1 2 2 1 1 0 1
34 3 12 4 0 0 0 0 0 1 1264 4 4 4 0 1 0 0 0 4 0 1 57 0 1 0 1 1 1 0 0 1
35 2 12 2 0 0 1 0 0 0 1474 0 1 4 0 0 0 0 0 1 0 0 33 1 0 1 1 3 1 1 0 1
36 1 45 4 0 0 0 1 0 0 4746 0 1 4 0 1 0 0 0 2 0 0 25 0 0 1 2 1 1 0 0 0
37 3 48 4 0 0 0 0 1 0 6110 0 2 1 0 1 0 0 0 3 0 1 31 1 0 0 1 2 1 1 0 1
38 2 18 2 0 0 0 1 0 0 2100 0 2 4 0 1 0 1 0 2 1 0 37 1 0 1 1 2 1 0 0 0
39 2 10 2 0 0 0 0 0 0 1225 0 2 2 0 1 0 0 0 2 0 0 37 0 0 1 1 2 1 1 0 1
40 1 9 2 0 0 0 1 0 0 458 0 2 4 0 1 0 0 0 3 1 0 24 0 0 1 1 2 1 0 0 1
41 3 30 2 0 0 0 1 0 0 2333 2 4 4 0 1 0 0 0 2 0 0 30 1 0 1 1 3 1 0 0 1
42 1 12 2 0 0 0 1 0 0 1158 2 2 3 1 0 0 0 0 1 0 0 26 0 0 1 1 2 1 1 0 1
43 1 18 3 0 0 0 0 0 0 6204 0 2 2 0 1 0 0 0 4 1 0 44 0 0 1 1 1 2 1 0 1
44 0 30 4 0 1 0 0 0 0 6187 1 3 1 0 0 1 0 0 4 0 0 24 0 1 0 2 2 1 0 0 1
45 0 48 4 0 1 0 0 0 0 6143 0 4 4 0 0 0 0 0 4 0 1 58 1 0 0 2 1 1 0 0 0
46 3 11 4 1 0 0 0 0 0 1393 0 1 4 0 0 0 0 0 4 0 0 35 0 0 1 2 3 1 0 0 1
47 3 36 2 0 0 0 1 0 0 2299 2 4 4 0 1 0 0 0 4 0 0 39 0 0 1 1 2 1 0 0 1
48 0 6 2 0 1 0 0 0 0 1352 2 0 1 0 0 0 0 0 2 0 0 23 0 1 0 1 0 1 1 0 1
49 3 11 4 1 0 0 0 0 0 7228 0 2 1 0 1 0 0 0 4 0 0 39 0 0 1 2 1 1 0 0 1
50 3 12 2 0 0 0 1 0 0 2073 1 2 4 0 0 0 1 0 2 1 0 28 0 0 1 1 2 1 0 0 1
51 1 24 3 0 0 1 0 0 0 2333 4 1 4 0 1 0 0 0 2 0 0 29 1 0 1 1 1 1 0 0 1
52 1 27 3 0 1 0 0 0 0 5965 0 4 1 0 1 0 0 0 2 0 0 30 0 0 1 2 3 1 1 0 1
53 3 12 2 0 0 0 1 0 0 1262 0 2 3 0 1 0 0 0 2 0 0 25 0 0 1 1 2 1 0 0 1
54 3 18 2 0 1 0 0 0 0 3378 4 2 2 0 1 0 0 0 1 0 0 31 0 0 1 1 2 1 1 0 1
55 1 36 3 1 0 0 0 0 0 2225 0 4 4 0 1 0 0 0 4 0 1 57 1 0 0 2 2 1 1 0 0
56 3 6 1 1 0 0 0 0 0 783 4 2 1 0 1 0 0 1 2 1 0 26 1 0 1 1 1 2 0 0 1
57 1 12 2 0 0 0 1 0 0 6468 4 0 2 0 1 0 0 0 1 0 1 52 0 0 1 1 3 1 1 0 0
58 3 36 4 0 0 0 1 0 0 9566 0 2 2 0 0 0 0 0 2 0 0 31 1 0 1 2 2 1 0 0 1
59 2 18 2 1 0 0 0 0 0 1961 0 4 3 0 0 0 0 0 2 0 0 23 0 0 1 1 3 1 0 0 1
60 0 36 4 0 0 1 0 0 0 6229 0 1 4 0 0 0 1 0 4 0 1 23 0 1 0 2 1 1 1 0 0
61 1 9 2 0 0 0 0 0 1 1391 0 2 2 0 0 1 0 0 1 1 0 27 1 0 1 1 2 1 1 0 1
62 1 15 4 0 0 0 1 0 0 1537 4 4 4 0 1 0 0 1 4 1 0 50 0 0 1 2 2 1 1 0 1
63 1 36 0 0 0 0 0 0 1 1953 0 4 4 0 1 0 0 0 4 0 1 61 0 0 0 1 3 1 1 0 0
64 1 48 0 0 0 0 0 0 1 14421 0 2 2 0 1 0 0 0 2 0 0 25 0 0 1 1 2 1 1 0 0
65 3 24 2 0 0 0 1 0 0 3181 0 1 4 0 0 0 0 0 4 0 0 26 0 0 1 1 2 1 1 0 1
66 3 27 2 0 0 0 0 0 0 5190 4 4 4 0 1 0 0 0 4 0 0 48 0 0 1 4 2 2 1 0 1
67 3 12 2 0 0 0 1 0 0 2171 0 1 2 0 0 0 0 0 2 0 0 29 1 0 1 1 2 1 0 0 1
68 1 12 2 1 0 0 0 0 0 1007 3 2 4 0 0 1 0 0 1 1 0 22 0 0 1 1 2 1 0 0 1
69 3 36 2 0 0 0 0 1 0 1819 0 2 4 0 1 0 0 0 4 0 1 37 1 0 0 1 2 1 1 0 0
70 3 36 2 0 0 0 1 0 0 2394 4 2 4 0 0 0 0 0 4 0 0 25 0 0 1 1 2 1 0 0 1
71 3 36 2 0 1 0 0 0 0 8133 0 2 1 0 0 0 0 0 2 0 0 30 1 0 1 1 2 1 0 0 1
72 3 7 4 0 0 0 1 0 0 730 4 4 4 0 1 0 0 0 2 0 0 46 0 1 0 2 1 1 1 0 1
73 0 8 4 0 0 0 0 0 0 1164 0 4 3 0 1 0 0 0 4 0 1 51 1 0 0 2 3 2 1 0 1
74 1 42 4 0 0 0 0 0 1 5954 0 3 2 0 0 0 0 0 1 1 0 41 1 0 1 2 1 1 0 0 1
75 0 36 2 0 0 0 0 1 0 1977 4 4 4 0 1 0 0 0 4 0 1 40 0 0 1 1 3 1 1 0 0
76 0 12 4 0 1 0 0 0 0 1526 0 4 4 0 1 0 0 0 4 0 1 66 0 0 0 2 3 1 0 0 1
77 0 42 2 0 0 0 1 0 0 3965 0 1 4 0 1 0 0 0 3 0 0 34 0 0 1 1 2 1 0 0 0
78 1 11 3 0 0 0 1 0 0 4771 0 3 2 0 1 0 0 0 4 0 0 51 0 0 1 1 2 1 0 0 1
79 3 54 0 0 1 0 0 0 0 9436 4 2 2 0 1 0 0 0 2 0 0 39 0 0 1 1 1 2 0 0 1
80 1 30 2 0 0 1 0 0 0 3832 0 1 2 0 0 1 0 0 1 0 0 22 0 0 1 1 2 1 0 0 1
81 3 24 2 0 0 0 1 0 0 5943 4 1 1 0 0 0 0 0 1 0 0 44 0 0 1 2 2 1 1 0 0
82 3 15 2 0 0 0 1 0 0 1213 2 4 4 0 1 0 0 0 3 0 0 47 1 0 1 1 2 1 1 0 1
83 3 18 2 0 0 0 0 0 1 1568 1 2 3 0 0 0 0 0 4 0 0 24 0 1 0 1 1 1 0 0 1
84 0 24 2 0 0 0 0 0 0 1755 0 4 4 0 0 0 0 1 4 1 0 58 0 0 1 1 1 1 1 0 1
85 0 10 2 0 0 0 1 0 0 2315 0 4 3 0 1 0 0 0 4 1 0 52 0 0 1 1 1 1 0 0 1
86 3 12 4 0 0 0 0 0 1 1412 0 2 4 0 0 0 0 1 2 1 0 29 0 0 1 2 3 1 1 0 1
87 1 18 4 0 0 1 0 0 0 1295 0 1 4 0 0 0 0 0 1 0 0 27 0 0 1 2 2 1 0 0 1
88 1 36 2 0 0 0 0 1 0 12612 1 2 1 0 1 0 0 0 4 0 1 47 0 0 0 1 2 2 1 0 0
89 0 18 2 1 0 0 0 0 0 2249 1 3 4 0 1 0 0 0 3 0 0 30 0 0 1 1 3 2 1 0 1
90 0 12 0 0 0 0 0 0 0 1108 0 3 4 0 1 0 0 0 3 1 0 28 0 0 1 2 2 1 0 0 0
91 3 12 4 0 0 0 1 0 0 618 0 4 4 0 1 0 0 0 4 1 0 56 0 0 1 1 2 1 0 0 1
92 0 12 4 0 1 0 0 0 0 1409 0 4 4 0 1 0 0 0 3 1 0 54 0 0 1 1 2 1 0 0 1
93 3 12 4 0 0 0 1 0 0 797 4 4 4 0 0 0 0 0 3 0 0 33 1 0 1 1 1 2 0 0 0
94 2 24 4 0 0 1 0 0 0 3617 4 4 4 0 1 0 1 0 4 0 1 20 0 1 0 2 2 1 0 0 1
95 1 12 2 1 0 0 0 0 0 1318 3 4 4 0 1 0 0 0 4 1 0 54 0 0 1 1 2 1 1 0 1
96 1 54 0 0 0 0 0 0 1 15945 0 1 3 0 1 0 0 0 4 0 1 58 0 1 0 1 2 1 1 0 0
97 3 12 4 0 0 0 0 1 0 2012 4 3 4 0 0 0 0 0 2 0 0 61 0 0 1 1 2 1 0 0 1
98 1 18 2 0 0 0 0 0 1 2622 1 2 4 0 1 0 0 0 4 0 0 34 0 0 1 1 2 1 0 0 1
99 1 36 4 0 0 0 1 0 0 2337 0 4 4 0 1 0 0 0 4 1 0 36 0 0 1 1 2 1 0 0 1
100 1 20 3 0 1 0 0 0 0 7057 4 3 3 0 1 0 0 0 4 0 0 36 1 1 0 2 3 2 1 0 1
101 3 24 2 1 0 0 0 0 0 1469 1 4 4 0 0 1 0 0 4 1 0 41 0 1 0 1 1 1 0 0 1
102 1 36 2 0 0 0 1 0 0 2323 0 3 4 0 1 0 0 0 4 0 0 24 0 1 0 1 2 1 0 0 1
103 3 6 3 0 0 0 1 0 0 932 0 2 3 0 0 0 0 0 2 1 0 24 0 0 1 1 2 1 0 0 1
104 1 9 4 0 0 1 0 0 0 1919 0 3 4 0 1 0 0 0 3 0 0 35 0 1 0 1 2 1 1 0 1
105 3 12 2 0 1 0 0 0 0 2445 4 1 2 0 0 1 0 0 4 0 0 26 0 1 0 1 2 1 1 0 1
106 1 24 4 0 0 0 0 0 0 11938 0 2 2 0 1 0 1 0 3 0 0 39 0 0 1 2 3 2 1 0 0
107 3 18 1 1 0 0 0 0 0 6458 0 4 2 0 1 0 0 0 4 0 1 39 1 0 1 2 3 2 1 0 0
108 1 12 2 1 0 0 0 0 0 6078 0 3 2 0 1 0 0 0 2 0 0 32 0 0 1 1 2 1 0 0 1
109 0 24 2 0 0 1 0 0 0 7721 4 1 1 0 0 0 0 0 2 0 0 30 0 0 1 1 2 1 1 1 1
110 1 14 2 0 0 0 0 0 1 1410 2 4 1 0 0 1 0 0 2 1 0 35 0 0 1 1 2 1 1 0 1
111 1 6 3 0 0 0 0 0 1 1449 1 4 1 1 0 0 0 0 2 0 0 31 1 0 1 2 2 2 0 0 1
112 2 15 2 0 0 0 0 1 0 392 0 1 4 0 0 0 0 0 4 0 0 23 0 1 0 1 2 1 1 0 1
113 1 18 2 1 0 0 0 0 0 6260 0 3 3 0 1 0 0 0 3 1 0 28 0 1 0 1 1 1 0 0 1
114 3 36 4 1 0 0 0 0 0 7855 0 2 4 0 0 0 0 0 2 1 0 25 1 0 1 2 2 1 1 0 0
115 0 12 2 0 0 0 1 0 0 1680 2 4 3 0 0 1 0 0 1 1 0 35 0 0 1 1 2 1 0 0 1
116 3 48 4 0 0 0 1 0 0 3578 4 4 4 0 1 0 0 0 1 1 0 47 0 0 1 1 2 1 1 0 1
117 0 42 2 0 0 0 1 0 0 7174 4 3 4 0 0 0 0 0 3 0 0 30 0 0 1 1 3 1 1 0 0
118 0 10 4 0 0 1 0 0 0 2132 4 1 2 0 0 0 1 0 3 1 0 27 0 1 0 2 2 1 0 1 1
119 0 33 4 0 0 1 0 0 0 4281 2 2 1 0 0 0 0 0 4 0 0 23 0 0 1 2 2 1 0 0 0
120 1 12 4 1 0 0 0 0 0 2366 2 3 3 1 0 0 0 0 3 0 0 36 0 0 1 1 3 1 1 0 1
121 0 21 2 0 0 0 1 0 0 1835 0 2 3 0 0 0 0 0 2 1 0 25 0 0 1 2 2 1 1 0 0
122 3 24 4 0 1 0 0 0 0 3868 0 4 4 0 0 0 0 0 2 0 0 41 0 1 0 2 3 1 1 0 1
123 3 12 2 0 0 1 0 0 0 1768 0 2 3 0 1 0 0 0 2 1 0 24 0 1 0 1 1 1 0 0 1
124 2 10 4 1 0 0 0 0 0 781 0 4 4 0 1 0 0 0 4 0 1 63 0 0 0 2 2 1 1 0 1
125 1 18 2 0 0 1 0 0 0 1924 4 1 4 0 0 0 0 0 3 1 0 27 0 1 0 1 2 1 0 0 0
126 0 12 4 1 0 0 0 0 0 2121 0 2 4 0 1 0 0 0 2 0 0 30 0 0 1 2 2 1 0 0 1
127 0 12 2 0 0 0 1 0 0 701 0 2 4 0 0 1 0 0 2 1 0 40 0 0 1 1 1 1 0 0 1
128 1 12 2 0 0 0 0 0 0 639 0 2 4 0 1 0 0 0 2 0 0 30 0 0 1 1 2 1 0 0 0
129 1 12 4 0 1 0 0 0 0 1860 0 0 4 0 1 0 0 0 2 0 0 34 0 0 1 2 3 1 1 0 1
130 0 12 4 1 0 0 0 0 0 3499 0 2 3 0 0 0 1 0 2 1 0 29 0 0 1 2 2 1 0 0 0
131 1 48 2 1 0 0 0 0 0 8487 4 3 1 0 0 0 0 0 2 0 0 24 0 0 1 1 2 1 0 0 1
132 0 36 3 0 0 0 0 1 0 6887 0 2 4 0 1 0 0 0 3 0 0 29 1 0 1 1 2 1 1 0 0
133 3 15 2 0 0 1 0 0 0 2708 0 1 2 0 1 0 0 0 3 0 0 27 1 0 1 2 1 1 0 0 1
134 3 18 2 0 0 1 0 0 0 1984 0 2 4 0 1 0 0 0 4 0 1 47 1 0 0 2 2 1 0 0 1
135 3 60 2 0 0 0 1 0 0 10144 1 3 2 0 0 0 0 0 4 1 0 21 0 0 1 1 2 1 1 0 1
136 3 12 4 0 0 0 1 0 0 1240 4 4 4 0 0 0 0 0 2 1 0 38 0 0 1 2 2 1 1 0 1
137 3 27 3 0 1 0 0 0 0 8613 3 2 2 0 1 0 0 0 2 0 0 27 0 0 1 2 2 1 0 0 1
138 1 12 2 0 0 0 1 0 0 766 2 2 4 0 1 0 0 0 3 1 0 66 0 0 1 1 1 1 0 0 0
139 1 15 4 0 0 0 1 0 0 2728 4 3 4 0 1 0 0 1 2 1 0 35 1 0 1 3 2 1 1 0 1
140 2 12 2 0 0 0 1 0 0 1881 0 2 2 0 0 0 0 0 2 0 0 44 0 1 0 1 1 1 1 0 1
141 2 6 2 1 0 0 0 0 0 709 3 1 2 0 0 1 0 0 2 1 0 27 0 0 1 1 0 1 0 1 1
142 1 36 2 0 0 0 1 0 0 4795 0 1 4 0 0 0 0 0 1 0 1 30 0 0 1 1 3 1 1 0 1
143 0 27 2 0 0 0 1 0 0 3416 0 2 3 0 1 0 0 0 2 0 0 27 0 0 1 1 3 1 0 0 1
144 0 18 2 0 0 1 0 0 0 2462 0 2 2 0 1 0 0 0 2 0 0 22 0 0 1 1 2 1 0 0 0
145 3 21 4 0 0 1 0 0 0 2288 0 1 4 0 0 0 0 0 4 0 0 23 0 0 1 1 2 1 1 0 1
146 1 48 1 0 0 0 0 0 1 3566 1 3 4 0 1 0 0 0 2 0 0 30 0 0 1 1 2 1 0 0 1
147 0 6 4 1 0 0 0 0 0 860 0 4 1 0 0 0 0 0 4 0 1 39 0 0 1 2 2 1 1 0 1
148 3 12 4 1 0 0 0 0 0 682 1 3 4 0 0 0 0 0 3 0 0 51 0 0 1 2 2 1 1 0 1
149 0 36 4 0 0 1 0 0 0 5371 0 2 3 0 1 0 0 1 2 0 0 28 0 0 1 2 2 1 0 0 1
150 3 18 4 0 0 0 1 0 0 1582 3 4 4 0 1 0 0 0 4 0 0 46 0 0 1 2 2 1 0 0 1
151 3 6 2 0 0 0 1 0 0 1346 1 4 2 0 1 0 0 0 4 0 1 42 1 0 0 1 2 2 1 0 1
152 3 10 2 0 0 0 1 0 0 1924 0 2 1 0 1 0 0 0 4 0 0 38 0 0 1 1 2 1 1 1 1
153 2 36 2 0 0 0 1 0 0 5848 0 2 4 0 1 0 0 0 1 0 0 24 0 0 1 1 2 1 0 0 1
154 1 24 4 0 1 0 0 0 0 7758 3 4 2 0 0 0 0 0 4 0 1 29 0 1 0 1 2 1 0 0 1
155 1 24 3 0 0 0 0 0 1 6967 1 3 4 0 1 0 0 0 4 0 0 36 0 1 0 1 3 1 1 0 1
156 0 12 2 0 0 1 0 0 0 1282 0 2 2 0 0 0 0 0 4 0 0 20 0 1 0 1 2 1 0 0 0
157 0 9 4 0 0 0 0 0 0 1288 1 4 3 0 1 0 0 1 4 1 0 48 0 0 1 2 2 2 0 1 1
158 0 12 1 0 0 0 0 0 0 339 0 4 4 0 0 1 0 0 1 0 0 45 1 0 1 1 1 1 0 0 1
159 1 24 2 1 0 0 0 0 0 3512 1 3 2 0 1 0 0 0 3 0 0 38 1 0 1 2 2 1 1 0 1
160 3 6 4 0 0 0 1 0 0 1898 4 2 1 0 1 0 0 0 2 1 0 34 0 0 1 2 1 2 0 0 1
161 3 24 4 0 0 0 1 0 0 2872 1 4 3 0 1 0 0 0 4 1 0 36 0 0 1 1 2 2 1 0 1
162 3 18 4 1 0 0 0 0 0 1055 0 1 4 0 0 0 0 0 1 0 0 30 0 0 1 2 2 1 0 0 1
163 3 15 2 0 0 0 0 0 0 1262 2 3 4 0 1 0 0 0 3 0 0 36 0 0 1 2 2 1 1 0 1
164 1 10 2 1 0 0 0 0 0 7308 0 0 2 0 1 0 0 0 4 0 1 70 1 0 0 1 3 1 1 0 1
165 3 36 2 1 0 0 0 0 0 909 2 4 4 0 1 0 0 0 4 0 0 36 0 0 1 1 2 1 0 0 1
166 3 6 2 0 0 1 0 0 0 2978 2 2 1 0 1 0 0 0 2 0 0 32 0 0 1 1 2 1 1 0 1
167 0 18 2 0 0 1 0 0 0 1131 0 0 4 0 0 0 0 0 2 0 0 33 0 0 1 1 2 1 0 0 0
168 1 11 2 0 0 1 0 0 0 1577 3 1 4 0 0 0 0 0 1 1 0 20 0 0 1 1 2 1 0 0 1
169 3 24 2 0 0 1 0 0 0 3972 0 3 2 0 0 0 0 0 4 0 0 25 0 1 0 1 2 1 1 0 1
170 1 24 4 0 0 0 0 0 1 1935 0 4 4 1 0 0 0 0 4 1 0 31 0 0 1 2 2 1 1 0 0
171 0 15 0 1 0 0 0 0 0 950 0 4 4 0 1 0 0 0 3 0 0 33 0 1 0 2 2 2 0 0 0
172 3 12 2 0 0 1 0 0 0 763 0 2 4 0 0 0 0 0 1 1 0 26 0 0 1 1 2 1 1 0 1
173 1 24 3 0 0 1 0 0 0 2064 0 0 3 0 0 0 0 0 2 0 0 34 0 0 1 1 3 1 1 0 0
174 1 8 2 0 0 0 1 0 0 1414 0 2 4 0 1 0 0 1 2 1 0 33 0 0 1 1 2 1 0 1 1
175 0 21 3 0 0 0 0 1 0 3414 0 1 2 0 1 0 0 0 1 0 0 26 0 0 1 2 2 1 0 0 0
176 3 30 1 0 1 0 0 0 0 7485 4 0 4 0 0 0 0 0 1 1 0 53 1 0 1 1 3 1 1 0 0
177 0 12 2 0 0 1 0 0 0 2577 0 2 2 1 0 0 0 0 1 0 0 42 0 0 1 1 2 1 0 0 1
178 0 6 4 0 0 0 1 0 0 338 2 4 4 0 1 0 0 0 4 0 0 52 0 0 1 2 2 1 0 0 1
179 3 12 2 0 0 0 1 0 0 1963 0 3 4 0 1 0 0 0 2 0 0 31 0 1 0 2 3 2 1 0 1
180 0 21 4 1 0 0 0 0 0 571 0 4 4 0 1 0 0 0 4 1 0 65 0 0 1 2 2 1 0 0 1
181 3 36 3 0 0 0 0 0 1 9572 0 1 1 1 0 0 0 0 1 0 0 28 0 0 1 2 2 1 0 0 0
182 1 36 3 0 0 0 0 0 1 4455 0 2 2 1 0 0 0 0 2 1 0 30 1 0 1 2 3 1 1 0 0
183 0 21 1 1 0 0 0 0 0 1647 4 2 4 0 1 0 0 0 2 0 0 40 0 0 1 2 1 2 0 0 0
184 3 24 4 0 0 1 0 0 0 3777 3 2 4 0 1 0 0 0 4 1 0 50 0 0 1 1 2 1 1 0 1
185 1 18 4 1 0 0 0 0 0 884 0 4 4 0 1 0 0 0 4 0 0 36 1 0 1 1 2 2 1 0 0
186 3 15 4 0 0 0 1 0 0 1360 0 2 4 0 1 0 0 0 2 0 0 31 0 0 1 2 2 1 0 0 1
187 1 9 1 0 1 0 0 0 0 5129 0 4 2 0 0 0 0 0 4 0 1 74 1 0 0 1 3 2 1 0 0
188 1 16 4 1 0 0 0 0 0 1175 0 0 2 0 1 0 0 0 3 0 0 68 0 0 0 3 0 1 1 0 1
189 0 12 2 0 0 0 1 0 0 674 1 3 4 0 0 1 0 0 1 0 0 20 0 0 1 1 2 1 0 0 0
190 1 18 0 0 0 1 0 0 0 3244 0 2 1 0 0 0 0 0 4 0 0 33 1 0 1 2 2 1 1 0 1
191 3 24 2 0 0 0 0 0 1 4591 3 2 2 0 1 0 0 0 3 0 0 54 0 0 1 3 3 1 1 0 0
192 1 48 0 0 0 0 0 0 1 3844 1 3 4 0 1 0 0 0 4 0 1 34 0 0 0 1 1 2 0 0 0
193 1 27 2 0 0 0 0 0 1 3915 0 2 4 0 1 0 0 0 2 0 0 36 0 0 1 1 2 2 1 0 0
194 3 6 2 0 0 0 1 0 0 2108 0 3 2 0 0 1 0 0 2 1 0 29 0 1 0 1 2 1 0 0 1
195 1 45 2 0 0 0 1 0 0 3031 1 2 4 0 1 0 0 1 4 0 0 21 0 1 0 1 2 1 0 0 0
196 1 9 4 0 0 0 0 1 0 1501 0 4 2 0 0 0 0 0 3 0 0 34 0 0 1 2 3 1 1 0 0
197 3 6 4 0 0 0 1 0 0 1382 0 2 1 0 0 0 0 0 1 0 0 28 0 0 1 2 2 1 1 0 1
198 1 12 2 0 0 1 0 0 0 951 1 1 4 0 0 0 0 0 4 0 0 27 1 1 0 4 2 1 0 0 0
199 1 24 2 0 1 0 0 0 0 2760 4 4 4 0 1 0 0 0 4 0 1 36 1 0 0 1 2 1 1 0 1
200 1 18 3 0 0 1 0 0 0 4297 0 4 4 1 0 0 0 0 3 0 1 40 0 0 1 1 3 1 1 0 0
201 3 9 4 0 0 0 0 1 0 936 2 4 4 0 1 0 0 0 2 0 0 52 0 0 1 2 2 1 1 0 1
202 0 12 2 1 0 0 0 0 0 1168 0 2 4 0 0 1 0 0 3 1 0 27 0 0 1 1 1 1 0 0 1
203 3 27 3 0 0 0 0 0 1 5117 0 3 3 0 1 0 0 0 4 0 0 26 0 0 1 2 2 1 0 0 1
204 0 12 2 0 0 0 0 0 0 902 0 3 4 0 0 1 0 0 4 0 0 21 0 1 0 1 2 1 0 0 0
205 3 12 4 1 0 0 0 0 0 1495 0 4 4 0 1 0 0 0 1 1 0 38 0 0 1 2 1 2 0 0 1
206 0 30 4 0 1 0 0 0 0 10623 0 4 3 0 1 0 0 0 4 0 1 38 0 0 0 3 3 2 1 0 1
207 3 12 4 0 0 1 0 0 0 1935 0 4 4 0 1 0 0 0 4 1 0 43 0 0 1 3 2 1 1 0 1
208 1 12 4 0 0 0 0 0 0 1424 0 3 4 0 1 0 0 0 3 0 0 26 0 0 1 1 2 1 0 0 1
209 0 24 2 0 0 0 0 0 1 6568 0 2 2 0 0 1 0 0 2 0 0 21 1 0 1 1 1 1 0 0 1
210 3 12 2 0 1 0 0 0 0 1413 3 3 3 0 1 0 0 0 2 0 0 55 0 0 1 1 2 1 0 1 1
211 3 9 4 0 0 0 1 0 0 3074 4 2 1 0 1 0 0 0 2 1 0 33 0 0 1 2 2 2 0 0 1
212 3 36 2 0 0 0 1 0 0 3835 4 4 2 0 0 0 0 0 4 1 0 45 0 0 1 1 1 1 1 0 1
213 0 27 0 0 0 0 0 0 1 5293 0 0 2 0 1 0 0 0 4 0 0 50 1 0 1 2 2 1 1 0 0
214 2 30 3 0 0 0 0 0 1 1908 0 4 4 0 1 0 0 0 4 1 0 66 0 0 1 1 3 1 1 0 0
215 3 36 4 0 0 0 1 0 0 3342 4 4 4 0 1 0 0 0 2 0 0 51 0 0 1 1 2 1 1 0 1
216 1 6 4 0 0 0 0 0 0 932 4 3 1 0 0 0 0 0 3 0 0 39 0 0 1 2 1 1 0 0 1
217 0 18 0 0 0 0 0 0 1 3104 0 3 3 0 1 0 0 0 1 0 0 31 1 0 1 1 2 1 1 0 1
218 2 36 2 0 0 0 1 0 0 3913 0 2 2 0 1 0 0 0 2 1 0 23 0 0 1 1 2 1 1 0 1
219 0 24 2 0 0 1 0 0 0 3021 0 2 2 1 0 0 0 0 2 1 0 24 0 1 0 1 1 1 0 0 1
220 3 10 2 1 0 0 0 0 0 1364 0 2 2 0 0 0 0 0 4 0 0 64 0 0 1 1 2 1 1 0 1
221 1 12 2 0 0 0 1 0 0 625 0 1 4 0 0 1 0 1 1 1 0 26 1 0 1 1 1 1 0 0 1
222 0 12 2 0 0 0 0 1 0 1200 4 2 4 0 0 0 0 0 4 0 0 23 1 1 0 1 2 1 1 0 1
223 3 12 2 0 0 0 1 0 0 707 0 2 4 0 1 0 0 0 2 1 0 30 1 0 1 2 2 1 0 0 1
224 3 24 3 0 0 0 0 0 1 2978 4 2 4 0 1 0 0 0 4 1 0 32 0 0 1 2 2 2 1 0 1
225 3 15 2 0 1 0 0 0 0 4657 0 2 3 0 1 0 0 0 2 0 0 30 0 0 1 1 2 1 1 0 1
226 3 36 0 0 0 0 0 0 0 2613 0 2 4 0 1 0 0 0 2 0 0 27 0 0 1 2 2 1 0 0 1
227 1 48 2 0 0 0 1 0 0 10961 3 3 1 0 1 0 1 0 2 0 1 27 1 0 1 2 2 1 1 0 0
228 0 12 2 0 0 1 0 0 0 7865 0 4 4 0 1 0 0 0 4 0 1 53 0 0 0 1 3 1 1 0 0
229 3 9 2 0 0 0 1 0 0 1478 0 3 4 0 1 0 0 0 2 0 0 22 0 0 1 1 2 1 0 0 0
230 0 24 2 0 0 1 0 0 0 3149 0 1 4 0 1 0 0 0 1 0 1 22 1 0 0 1 2 1 0 0 1
231 2 36 2 0 0 0 1 0 0 4210 0 2 4 0 1 0 0 0 2 0 0 26 0 0 1 1 2 1 0 0 0
232 3 9 2 1 0 0 0 0 0 2507 2 4 2 0 1 0 0 0 4 0 1 51 0 0 0 1 1 1 0 0 1
233 3 12 2 0 0 0 1 0 0 2141 1 3 3 0 1 0 0 0 1 0 1 35 0 0 1 1 2 1 0 0 1
234 1 18 2 0 0 0 1 0 0 866 0 2 4 0 0 1 0 1 2 1 0 25 0 0 1 1 1 1 0 0 1
235 3 4 4 0 0 0 1 0 0 1544 0 3 2 0 1 0 0 0 1 1 0 42 0 0 1 3 1 2 0 0 1
236 0 24 2 0 0 0 1 0 0 1823 0 0 4 0 1 0 0 0 2 0 0 30 1 0 1 1 3 2 0 0 0
237 1 6 2 1 0 0 0 0 0 14555 4 0 1 0 1 0 0 0 2 0 0 23 0 0 1 1 0 1 1 0 0
238 1 21 2 0 0 0 0 0 1 2767 1 4 4 1 0 0 0 0 2 0 0 61 1 1 0 2 1 1 0 0 0
239 3 12 4 0 0 0 1 0 0 1291 0 2 4 0 0 0 0 0 2 0 0 35 0 0 1 2 2 1 0 0 1
240 0 30 2 0 0 0 1 0 0 2522 0 4 1 0 1 0 0 1 3 0 0 39 0 0 1 1 2 2 0 0 1
241 0 24 2 1 0 0 0 0 0 915 4 4 4 0 0 0 0 0 2 0 0 29 1 0 1 1 2 1 0 0 0
242 3 6 2 0 0 0 1 0 0 1595 0 3 3 0 1 0 0 0 2 0 0 51 0 0 1 1 2 2 0 0 1
243 0 48 0 0 1 0 0 0 0 4605 0 4 3 0 1 0 0 0 4 0 1 24 0 0 0 2 2 2 0 0 0
244 3 12 4 0 0 0 0 0 1 1185 0 2 3 0 0 0 0 0 2 1 0 27 0 0 1 2 2 1 0 0 1
245 3 12 1 0 0 0 0 0 0 3447 2 2 4 0 0 0 0 0 3 1 0 35 0 0 1 1 1 2 0 0 1
246 3 24 2 0 0 0 0 0 1 1258 0 3 4 0 1 0 0 0 1 1 0 25 0 0 1 1 2 1 1 0 1
247 3 12 4 0 0 0 1 0 0 717 0 4 4 0 1 0 0 0 4 1 0 52 0 0 1 3 2 1 0 0 1
248 3 6 0 1 0 0 0 0 0 1204 1 2 4 0 1 0 0 0 1 0 1 35 1 1 0 1 2 1 0 1 1
249 2 24 2 0 0 1 0 0 0 1925 0 2 2 0 1 0 0 0 2 1 0 26 0 0 1 1 2 1 0 0 1
250 3 18 2 0 0 0 1 0 0 433 0 0 3 0 0 0 1 0 4 1 0 22 0 1 0 1 2 1 0 0 0
251 0 6 4 1 0 0 0 0 0 666 3 3 3 0 0 0 0 0 4 1 0 39 0 0 1 2 1 1 1 0 1
252 2 12 2 0 0 1 0 0 0 2251 0 2 1 0 0 0 0 0 2 0 0 46 0 0 1 1 1 1 0 0 1
253 1 30 2 1 0 0 0 0 0 2150 0 2 4 0 0 0 0 1 2 0 1 24 1 0 1 1 2 1 0 0 0
254 3 24 3 0 0 1 0 0 0 4151 1 2 2 0 1 0 0 0 3 0 0 35 0 0 1 2 2 1 0 0 1
255 1 9 2 0 0 1 0 0 0 2030 4 3 2 0 1 0 0 0 1 0 0 24 0 0 1 1 2 1 1 0 1
256 1 60 3 0 0 0 1 0 0 7418 4 2 1 0 1 0 0 0 1 1 0 27 0 0 1 1 1 1 0 0 1
257 3 24 4 0 0 0 1 0 0 2684 0 2 4 0 1 0 0 0 2 1 0 35 0 0 1 2 1 1 0 0 1
258 0 12 1 0 0 0 1 0 0 2149 0 2 4 1 0 0 0 0 1 0 1 29 0 0 0 1 2 1 0 0 0
259 3 15 2 0 1 0 0 0 0 3812 1 1 1 0 0 0 0 0 4 0 0 23 0 0 1 1 2 1 1 0 1
260 3 11 4 0 0 0 1 0 0 1154 1 0 4 0 0 0 0 0 4 1 0 57 0 0 1 3 1 1 0 0 1
261 0 12 2 0 0 1 0 0 0 1657 0 2 2 0 1 0 0 0 2 1 0 27 0 0 1 1 2 1 0 0 1
262 0 24 2 0 0 0 1 0 0 1603 0 4 4 0 0 0 0 0 4 0 0 55 0 0 1 1 2 1 0 0 1
263 0 18 4 1 0 0 0 0 0 5302 0 4 2 0 1 0 0 0 4 0 1 36 0 0 0 3 3 1 1 0 1
264 3 12 4 0 0 0 0 1 0 2748 0 4 2 0 0 0 0 0 4 0 1 57 1 0 0 3 1 1 0 0 1
265 3 10 4 1 0 0 0 0 0 1231 0 4 3 0 1 0 0 0 4 1 0 32 0 0 1 2 1 2 0 1 1
266 1 15 2 0 0 0 1 0 0 802 0 4 4 0 1 0 0 0 3 0 0 37 0 0 1 1 2 2 0 0 0
267 3 36 4 0 0 0 0 0 1 6304 4 4 4 0 1 0 0 0 4 1 0 36 0 0 1 2 2 1 0 0 1
268 3 24 2 0 0 0 1 0 0 1533 0 1 4 0 0 0 0 0 3 0 0 38 1 0 1 1 2 1 1 0 1
269 0 14 2 1 0 0 0 0 0 8978 0 4 1 1 0 0 0 0 4 0 0 45 0 0 1 1 3 1 1 1 0
270 3 24 2 0 0 0 1 0 0 999 4 4 4 0 1 0 0 0 2 0 0 25 0 0 1 2 2 1 0 0 1
271 3 18 2 1 0 0 0 0 0 2662 4 3 4 0 1 0 0 0 3 0 0 32 0 0 1 1 2 1 0 1 1
272 3 12 4 0 0 1 0 0 0 1402 2 3 3 0 0 0 0 0 4 0 0 37 0 1 0 1 2 1 1 0 1
273 1 48 1 1 0 0 0 0 0 12169 4 0 4 0 1 0 1 0 4 0 1 36 0 0 0 1 3 1 1 0 1
274 1 48 2 0 0 0 1 0 0 3060 0 3 4 0 1 0 0 0 4 1 0 28 0 0 1 2 2 1 0 0 0
275 0 30 2 0 0 0 0 0 0 11998 0 1 1 1 0 0 0 0 1 0 1 34 0 0 1 1 1 1 1 0 0
276 3 9 2 0 0 0 1 0 0 2697 0 2 1 0 1 0 0 0 2 1 0 32 0 0 1 1 2 2 0 0 1
277 3 18 4 0 0 0 1 0 0 2404 0 2 2 0 0 0 0 0 2 0 0 26 0 0 1 2 2 1 0 0 1
278 0 12 2 0 0 1 0 0 0 1262 4 4 2 1 0 0 0 0 4 0 0 49 0 0 1 1 1 1 1 0 1
279 3 6 2 0 0 1 0 0 0 4611 0 1 1 0 0 0 0 0 4 0 0 32 0 0 1 1 2 1 0 0 0
280 3 24 2 0 0 0 1 0 0 1901 1 2 4 0 1 0 0 0 4 0 0 29 0 1 0 1 3 1 1 0 1
281 3 15 4 0 1 0 0 0 0 3368 3 4 3 0 1 0 0 0 4 0 1 23 0 1 0 2 2 1 1 0 1
282 3 12 2 0 0 1 0 0 0 1574 0 2 4 0 1 0 0 0 2 1 0 50 0 0 1 1 2 1 0 0 1
283 2 18 1 0 0 0 1 0 0 1445 4 3 4 0 1 0 0 0 4 0 0 49 1 0 1 1 1 1 0 0 1
284 3 15 4 0 0 1 0 0 0 1520 4 4 4 0 1 0 0 0 4 0 0 63 0 0 1 1 2 1 0 0 1
285 1 24 4 1 0 0 0 0 0 3878 1 1 4 1 0 0 0 0 2 0 0 37 0 0 1 1 2 1 1 0 1
286 0 47 2 1 0 0 0 0 0 10722 0 1 1 0 0 0 0 0 1 1 0 35 0 0 1 1 1 1 1 0 1
287 0 48 2 0 1 0 0 0 0 4788 0 3 4 0 1 0 0 0 3 0 0 26 0 0 1 1 2 2 0 0 1
288 1 48 3 0 0 0 0 0 0 7582 1 0 2 0 1 0 0 0 4 0 1 31 0 0 0 1 3 1 1 0 1
289 1 12 2 0 0 0 1 0 0 1092 0 2 4 0 0 0 0 1 4 1 0 49 0 0 1 2 2 1 1 0 1
290 0 24 3 0 0 0 1 0 0 1024 0 1 4 0 0 1 0 0 4 1 0 48 1 0 1 1 2 1 0 0 0
291 3 12 2 0 0 0 0 0 1 1076 0 2 2 0 0 1 0 0 2 1 0 26 0 0 1 1 2 1 1 1 1
292 1 36 2 0 1 0 0 0 0 9398 0 1 1 0 0 1 0 0 4 0 0 28 0 1 0 1 3 1 1 0 0
293 0 24 4 0 1 0 0 0 0 6419 0 4 2 0 0 0 0 0 4 0 1 44 0 0 0 2 3 2 1 0 1
294 2 42 4 0 1 0 0 0 0 4796 0 4 4 0 1 0 0 0 4 0 1 56 0 0 0 1 2 1 0 0 1
295 3 48 4 0 0 0 0 0 1 7629 4 4 4 1 0 0 0 0 2 0 0 46 1 0 1 2 3 2 0 0 1
296 1 48 2 0 0 1 0 0 0 9960 0 1 1 0 0 0 0 0 2 0 0 26 0 0 1 1 2 1 1 0 0
297 3 12 2 0 1 0 0 0 0 4675 4 1 1 0 0 0 0 0 4 0 0 20 0 1 0 1 2 1 0 0 1
298 3 10 2 1 0 0 0 0 0 1287 4 4 4 0 1 0 1 0 2 0 0 45 0 0 1 1 1 1 0 1 1
299 3 18 2 0 0 1 0 0 0 2515 0 2 3 0 1 0 0 0 4 1 0 43 0 0 1 1 2 1 1 0 1
300 1 21 4 0 0 1 0 0 0 2745 3 3 3 0 1 0 0 0 2 0 0 32 0 0 1 2 2 1 1 0 1
301 3 6 2 1 0 0 0 0 0 672 0 0 1 0 0 0 0 0 4 1 0 54 0 0 1 1 0 1 1 0 1
302 1 36 0 0 0 0 1 0 0 3804 0 2 4 0 0 0 0 0 1 0 0 42 0 0 1 1 2 1 1 0 0
303 2 24 4 1 0 0 0 0 0 1344 4 3 4 0 1 0 0 0 2 1 0 37 1 0 1 2 1 2 0 0 0
304 0 10 4 1 0 0 0 0 0 1038 0 3 4 0 1 0 1 0 3 0 0 49 0 0 1 2 2 1 1 0 1
305 3 48 4 1 0 0 0 0 0 10127 2 2 2 0 1 0 0 0 2 0 1 44 1 0 0 1 2 1 0 0 0
306 3 6 2 0 0 1 0 0 0 1543 3 2 4 1 0 0 0 0 2 1 0 33 0 0 1 1 2 1 0 0 1
307 3 30 2 0 1 0 0 0 0 4811 4 3 2 0 0 0 0 0 4 0 0 24 1 1 0 1 1 1 0 0 1
308 0 12 2 0 0 0 1 0 0 727 1 1 4 0 0 1 0 0 3 0 1 33 0 0 1 1 1 1 1 0 0
309 1 8 2 0 0 1 0 0 0 1237 0 2 3 0 0 0 0 0 4 1 0 24 0 0 1 1 2 1 0 0 0
310 1 9 2 1 0 0 0 0 0 276 0 2 4 0 0 1 0 0 4 1 0 22 0 1 0 1 1 1 0 0 1
311 1 48 2 0 0 0 0 0 0 5381 4 0 3 0 1 0 0 0 4 0 1 40 1 0 0 1 0 1 1 0 1
312 3 24 2 0 0 1 0 0 0 5511 1 2 4 0 1 0 0 0 1 0 0 25 1 0 1 1 2 1 0 0 1
313 2 24 2 0 0 1 0 0 0 3749 0 1 2 0 0 0 0 0 4 0 0 26 0 0 1 1 2 1 0 0 1
314 1 12 2 1 0 0 0 0 0 685 0 3 2 0 0 1 0 0 3 0 0 25 1 0 1 1 1 1 0 0 0
315 2 4 2 1 0 0 0 0 0 1494 4 1 1 0 1 0 0 0 2 1 0 29 0 0 1 1 1 2 0 1 1
316 0 36 1 0 0 1 0 0 0 2746 0 4 4 0 1 0 0 0 4 0 0 31 1 0 1 1 2 1 0 0 0
317 0 12 2 0 0 1 0 0 0 708 0 2 2 0 1 0 0 1 3 0 0 38 0 0 1 1 1 2 0 0 1
318 1 24 2 0 0 1 0 0 0 4351 4 2 1 0 0 0 0 0 4 0 0 48 0 0 1 1 1 1 1 0 1
319 3 12 4 0 0 0 0 1 0 701 0 2 4 0 1 0 0 0 2 0 0 32 0 0 1 2 2 1 0 0 1
320 0 15 3 0 0 1 0 0 0 3643 0 4 1 0 0 0 0 0 4 0 0 27 0 0 1 2 1 1 0 0 1
321 1 30 4 1 0 0 0 0 0 4249 0 0 4 0 0 1 0 0 2 0 0 28 0 0 1 2 3 1 0 0 0
322 0 24 2 0 0 0 1 0 0 1938 0 1 4 1 0 0 0 0 3 0 0 32 0 0 1 1 2 1 0 0 0
323 0 24 2 0 1 0 0 0 0 2910 0 3 2 0 1 0 0 0 1 0 1 34 0 0 0 1 3 1 1 0 1
324 0 18 2 0 0 1 0 0 0 2659 3 2 4 0 1 0 0 0 2 0 0 28 0 0 1 1 2 1 0 0 1
325 3 18 4 1 0 0 0 0 0 1028 0 2 4 0 0 0 0 0 3 1 0 36 0 0 1 2 2 1 0 0 1
326 0 8 4 1 0 0 0 0 0 3398 0 3 1 0 1 0 0 0 4 1 0 39 0 0 1 2 1 1 0 1 1
327 3 12 4 0 0 1 0 0 0 5801 4 4 2 0 1 0 0 0 4 0 0 49 0 1 0 1 2 1 1 0 1
328 3 24 2 1 0 0 0 0 0 1525 3 3 4 0 0 0 0 0 3 0 0 34 0 0 1 1 2 2 1 0 1
329 2 36 2 0 0 0 1 0 0 4473 0 4 4 0 1 0 0 0 2 0 0 31 0 0 1 1 2 1 0 0 1
330 1 6 2 0 0 0 1 0 0 1068 0 4 4 0 1 0 0 0 4 0 0 28 0 0 1 1 2 2 0 0 1
331 0 24 4 0 1 0 0 0 0 6615 0 0 2 0 1 0 0 0 4 0 1 75 0 0 0 2 3 1 1 0 1
332 3 18 4 0 0 0 0 1 0 1864 1 2 4 0 0 0 0 0 2 1 0 30 0 0 1 2 2 1 0 0 0
333 1 60 2 1 0 0 0 0 0 7408 1 1 4 0 0 0 0 0 2 0 0 24 0 0 1 1 3 1 0 0 0
334 3 48 4 0 1 0 0 0 0 11590 1 2 2 0 0 0 0 0 4 0 0 24 1 1 0 2 1 1 0 0 0
335 0 24 0 0 0 1 0 0 0 4110 0 4 3 0 1 0 0 0 4 0 1 23 1 1 0 2 2 2 0 0 0
336 0 6 4 0 0 1 0 0 0 3384 0 2 1 1 0 0 0 0 4 1 0 44 0 1 0 1 3 1 1 0 0
337 1 13 2 0 0 0 1 0 0 2101 0 1 2 0 0 0 0 1 4 0 0 23 0 0 1 1 1 1 0 0 1
338 0 15 2 0 0 0 0 0 0 1275 4 2 4 0 0 0 0 0 2 0 0 24 0 1 0 1 2 1 0 0 0
339 0 24 2 0 0 1 0 0 0 4169 0 2 4 0 1 0 0 0 4 0 0 28 0 0 1 1 2 1 0 0 1
340 1 10 2 0 0 1 0 0 0 1521 0 2 4 1 0 0 0 0 2 0 0 31 0 0 1 1 1 1 0 0 1
341 1 24 4 0 0 0 0 1 0 5743 0 1 2 0 0 0 0 0 4 0 1 24 0 0 0 2 2 1 1 0 1
342 0 21 2 0 0 1 0 0 0 3599 0 3 1 0 0 0 0 0 4 0 0 26 0 1 0 1 1 1 0 0 1
343 1 18 2 0 0 0 1 0 0 3213 2 1 1 0 0 1 0 0 3 1 0 25 0 1 0 1 2 1 0 0 1
344 1 18 2 0 0 0 0 0 1 4439 0 4 1 0 1 0 1 0 1 1 0 33 1 0 1 1 3 1 1 0 1
345 2 10 2 1 0 0 0 0 0 3949 0 1 1 0 1 0 0 1 1 0 0 37 0 0 1 1 1 2 0 0 1
346 3 15 4 0 0 0 1 0 0 1459 0 2 4 0 0 0 0 0 2 0 0 43 0 0 1 1 1 1 0 0 1
347 1 13 4 0 0 0 1 0 0 882 0 1 4 0 1 0 0 1 4 1 0 23 0 0 1 2 2 1 0 0 1
348 1 24 2 0 0 0 1 0 0 3758 2 0 1 0 0 0 0 0 4 0 1 23 0 1 0 1 0 1 0 0 1
349 3 6 3 0 0 0 0 0 1 1743 1 2 1 0 1 0 0 0 2 1 0 34 0 0 1 2 1 1 0 0 1
350 1 9 4 0 0 0 0 1 0 1136 3 4 4 0 1 0 0 0 3 0 1 32 0 0 0 2 2 2 0 0 0
351 3 9 2 0 0 0 0 0 0 1236 0 1 1 0 0 0 0 0 4 1 0 23 0 1 0 1 2 1 1 0 1
352 1 9 2 0 0 1 0 0 0 959 0 2 1 0 0 0 0 0 2 0 0 29 0 0 1 1 2 1 0 1 0
353 3 18 4 0 1 0 0 0 0 3229 4 0 2 0 1 0 0 0 4 0 1 38 0 0 1 1 3 1 1 0 1
354 0 12 0 0 0 0 1 0 0 6199 0 2 4 0 1 0 0 0 2 0 0 28 0 1 0 2 2 1 1 0 0
355 3 10 2 0 0 0 0 1 0 727 2 4 4 0 1 0 0 0 4 0 1 46 0 0 0 1 2 1 1 0 1
356 1 24 2 1 0 0 0 0 0 1246 0 1 4 0 1 0 0 0 2 1 0 23 1 0 1 1 1 1 0 0 0
357 3 12 4 0 0 0 1 0 0 2331 4 4 1 0 1 0 1 0 4 1 0 49 0 0 1 1 2 1 1 0 1
358 3 36 3 0 0 0 1 0 0 4463 0 2 4 0 1 0 0 0 2 0 0 26 0 0 1 2 3 1 1 0 0
359 3 12 2 0 0 0 1 0 0 776 0 2 4 0 0 1 0 0 2 1 0 28 0 0 1 1 2 1 0 0 1
360 0 30 2 0 0 1 0 0 0 2406 0 3 4 0 0 0 0 0 4 1 0 23 0 1 0 1 2 1 0 0 0
361 1 18 2 0 0 0 0 1 0 1239 4 2 4 0 1 0 0 0 4 0 1 61 0 0 0 1 2 1 0 0 1
362 2 12 2 0 0 0 1 0 0 3399 4 4 2 0 1 0 0 0 3 0 0 37 0 0 1 1 3 1 0 0 1
363 2 12 3 1 0 0 0 0 0 2247 0 2 2 0 0 0 0 0 2 0 0 36 1 0 1 2 2 1 1 0 1
364 3 6 2 0 0 1 0 0 0 1766 0 2 1 0 0 1 0 0 2 0 0 21 0 1 0 1 2 1 0 0 1
365 0 18 2 0 0 1 0 0 0 2473 0 0 4 0 1 0 0 0 1 0 0 25 0 0 1 1 0 1 0 0 0
366 3 12 2 0 0 0 0 0 1 1542 0 3 2 0 1 0 0 0 4 0 0 36 0 0 1 1 2 1 1 0 1
367 3 18 4 0 1 0 0 0 0 3850 0 3 3 0 1 0 0 0 1 0 0 27 0 0 1 2 2 1 0 0 1
368 0 18 2 0 0 1 0 0 0 3650 0 1 1 0 0 0 0 0 4 0 0 22 0 1 0 1 2 1 0 0 1
369 0 36 2 0 0 1 0 0 0 3446 0 4

GERMAN CREDIT

GermanCredit.xls is the dataset for this case study.

Background

Money-lending has been around since the advent of money; it is perhaps the world’s second-oldest profession. The systematic evaluation of credit risk, though, is a relatively recent arrival, and lending was largely based on reputation and very incomplete data. Thomas Jefferson, the third President of the United States, was in debt throughout his life and unreliable in his debt payments, yet people continued to lend him money. It wasn’t until the beginning of the 20th century that the Retail Credit Company was founded to share information about credit. That company is now Equifax, one of the big three credit-scoring agencies (the other two are Transunion and Experian).

Individual and local human judgment are now largely irrelevant to the credit-reporting process. Credit agencies and other big financial institutions extending credit at the retail level collect huge amounts of data to predict whether defaults or other adverse events will occur, based on numerous customer and transaction information.

Data

This case deals with an early stage of the historical transition to predictive modeling, in which humans were employed to label records as either good or poor credit. The German Credit dataset has 30 variables and 1000 records, each record being a prior applicant for credit. Each applicant was rated as “good credit” (700 cases) or “bad credit” (300 cases). Figure 21.1 shows the values of these variables for the first four records. All the variables are explained in 
Table

21.6. New applicants for credit can also be evaluated on these 30 predictor variables and classified as a good or a bad credit risk based on the predictor variables.

The consequences of misclassification have been assessed as follows: The costs of a false positive (incorrectly saying that an applicant is a good credit risk) outweigh the benefits of a true positive (correctly saying that an applicant is a good credit risk) by a factor of 5. This is summarized in Table 21.4. The opportunity cost table was derived from the average net profit per loan as shown in Table 21.5.

Because decision makers are used to thinking of their decision in terms of net profits, we use these tables in assessing the performance of the various models.

Assignment

1. Review the predictor variables and guess what their role in a credit decision might be. Are there any surprises in the data?

2. Divide the data into training and validation partitions, and develop classification models using the following data mining techniques in XLMiner: logistic regression and classification trees. Use variants of these techniques as you see fit (e.g. best subset, best pruned tree, etc.). (Note: Depending on the capacity of your computer, Best Subsets may not run quickly, and possibly not at all; if this is the case, choose another selection technique.)

3. Choose one model from each technique and report the confusion matrix and the cost/gain matrix for the validation data. Which technique has the most net profit?

4. Let us try and improve our performance. Rather than accept XLMiner’s initial classification of all applicants’ credit status, use the “predicted probability of success” in logistic regression (where success means 1) as a basis for selecting the best credit risks first, followed by poorer risk applicants.

· Sort the validation on “predicted probability of success.”

· For each case, calculate the net profit of extending credit.

· Add another column for cumulative net profit.

a. How far into the validation data do you go to get maximum net profit? (Often, this is specified as a percentile or rounded to deciles.)

b. If this logistic regression model is scored to future applicants, what “probability of success” cutoff should be used in extending credit?

error: Content is protected !!