cocoon icon

Data Cleaning

Powered by Cocoon

german_credit_data

(First 100 rows)
Before After
savings_status property_magnitude own_telephone class checking_status duration personal_status job housing credit_history purpose credit_amount installment_commitment employment existing_credits num_dependents other_parties other_payment_plans age residence_since foreign_worker
0 no known savings real estate yes good <0 6 male single skilled own critical/other existing credit radio/tv 1169 4 >=7 2 1 none none 67 4 yes
1 <100 real estate none bad 0<=X<200 48 female div/dep/mar skilled own existing paid radio/tv 5951 2 1<=X<4 1 1 none none 22 2 yes
2 <100 real estate none good no checking 12 male single unskilled resident own critical/other existing credit education 2096 2 4<=X<7 1 2 none none 49 3 yes
3 <100 life insurance none good <0 42 male single skilled for free existing paid furniture/equipment 7882 2 4<=X<7 1 2 guarantor none 45 4 yes
4 <100 no known property none bad <0 24 male single skilled for free delayed previously new car 4870 3 1<=X<4 2 2 none none 53 4 yes
5 no known savings no known property yes good no checking 36 male single unskilled resident for free existing paid education 9055 2 1<=X<4 1 2 none none 35 4 yes
6 500<=X<1000 life insurance none good no checking 24 male single skilled own existing paid furniture/equipment 2835 3 >=7 1 1 none none 53 4 yes
7 <100 car yes good 0<=X<200 36 male single high qualif/self emp/mgmt rent existing paid used car 6948 2 1<=X<4 1 1 none none 35 2 yes
8 >=1000 real estate none good no checking 12 male div/sep unskilled resident own existing paid radio/tv 3059 2 4<=X<7 1 1 none none 61 4 yes
9 <100 car none bad 0<=X<200 30 male mar/wid high qualif/self emp/mgmt own critical/other existing credit new car 5234 4 unemployed 2 1 none none 28 2 yes
10 <100 car none bad 0<=X<200 12 female div/dep/mar skilled rent existing paid new car 1295 3 <1 1 1 none none 25 1 yes
11 <100 life insurance none bad <0 48 female div/dep/mar skilled rent existing paid business 4308 3 <1 1 1 none none 24 4 yes
12 <100 car yes good 0<=X<200 12 female div/dep/mar skilled own existing paid radio/tv 1567 1 1<=X<4 1 1 none none 22 1 yes
13 <100 car none bad <0 24 male single unskilled resident own critical/other existing credit new car 1199 4 >=7 2 1 none none 60 4 yes
14 <100 car none good <0 15 female div/dep/mar skilled rent existing paid new car 1403 2 1<=X<4 1 1 none none 28 4 yes
15 100<=X<500 car none bad <0 24 female div/dep/mar unskilled resident own existing paid radio/tv 1282 4 1<=X<4 1 1 none none 32 2 yes
16 no known savings life insurance none good no checking 24 male single skilled own critical/other existing credit radio/tv 2424 4 >=7 2 1 none none 53 4 yes
17 no known savings car none good <0 30 male single skilled own no credits/all paid business 8072 2 <1 3 1 none bank 25 3 yes
18 <100 no known property yes bad 0<=X<200 24 female div/dep/mar high qualif/self emp/mgmt for free existing paid used car 12579 4 >=7 1 1 none none 44 2 yes
19 500<=X<1000 car yes good no checking 24 male single skilled own existing paid radio/tv 3430 3 >=7 1 2 none none 31 2 yes
20 <100 car yes good no checking 9 male single skilled own critical/other existing credit new car 2134 4 1<=X<4 3 1 none none 48 4 yes
21 500<=X<1000 real estate none good <0 6 male single skilled rent existing paid radio/tv 2647 2 1<=X<4 1 2 none none 44 3 yes
22 <100 real estate none good <0 10 male single unskilled resident rent critical/other existing credit new car 2241 1 <1 2 2 none none 48 3 no
23 100<=X<500 life insurance none good 0<=X<200 12 male single skilled own critical/other existing credit used car 1804 3 <1 1 1 none none 44 4 yes
24 no known savings car none good no checking 10 male mar/wid skilled own critical/other existing credit furniture/equipment 2069 2 1<=X<4 2 1 none none 26 1 no
25 <100 real estate yes good <0 6 male single unskilled resident own existing paid furniture/equipment 1374 1 1<=X<4 1 1 none bank 36 2 yes
26 <100 car none good no checking 6 male mar/wid unskilled resident own no credits/all paid radio/tv 426 4 >=7 1 1 none none 39 4 yes
27 >=1000 real estate none good >=200 12 female div/dep/mar skilled rent all paid radio/tv 409 3 1<=X<4 2 1 none none 42 3 yes
28 <100 real estate none good 0<=X<200 7 male single skilled own existing paid radio/tv 2415 3 1<=X<4 1 1 guarantor none 34 2 yes
29 <100 no known property yes bad <0 60 male single skilled own delayed previously business 6836 3 >=7 2 1 none none 63 4 yes
30 >=1000 real estate yes good 0<=X<200 18 male mar/wid skilled own existing paid business 1913 3 <1 1 1 none bank 36 3 yes
31 <100 car none good <0 24 male single skilled own existing paid furniture/equipment 4020 2 1<=X<4 1 1 none stores 27 2 yes
32 100<=X<500 car yes good 0<=X<200 18 male single skilled own existing paid new car 5866 2 1<=X<4 2 1 none none 30 2 yes
33 no known savings no known property none good no checking 12 male single unskilled resident rent critical/other existing credit business 1264 4 >=7 1 1 none none 57 4 yes
34 <100 life insurance yes good >=200 12 female div/dep/mar high qualif/self emp/mgmt own existing paid furniture/equipment 1474 4 <1 1 1 none bank 33 1 yes
35 <100 life insurance none bad 0<=X<200 45 male single unskilled resident own critical/other existing credit radio/tv 4746 4 <1 2 1 none none 25 2 yes
36 <100 no known property yes good no checking 48 male single skilled for free critical/other existing credit education 6110 1 1<=X<4 1 1 none bank 31 3 yes
37 <100 real estate none bad >=200 18 male single skilled own existing paid radio/tv 2100 4 1<=X<4 1 1 co applicant stores 37 2 yes
38 <100 car yes good >=200 10 male single skilled own existing paid domestic appliance 1225 2 1<=X<4 1 1 none none 37 2 yes
39 <100 real estate none good 0<=X<200 9 male single skilled own existing paid radio/tv 458 4 1<=X<4 1 1 none none 24 3 yes
40 500<=X<1000 car none good no checking 30 male single high qualif/self emp/mgmt own existing paid radio/tv 2333 4 >=7 1 1 none bank 30 2 yes
41 500<=X<1000 car yes good 0<=X<200 12 male div/sep skilled own existing paid radio/tv 1158 3 1<=X<4 1 1 none none 26 1 yes
42 <100 real estate yes good 0<=X<200 18 male single unskilled resident own delayed previously repairs 6204 2 1<=X<4 1 2 none none 44 4 yes
43 100<=X<500 car none good <0 30 male mar/wid skilled rent critical/other existing credit used car 6187 1 4<=X<7 2 1 none none 24 4 yes
44 <100 no known property none bad <0 48 female div/dep/mar unskilled resident for free critical/other existing credit used car 6143 4 >=7 2 1 none stores 58 4 yes
45 <100 car none good no checking 11 female div/dep/mar high qualif/self emp/mgmt own critical/other existing credit new car 1393 4 <1 2 1 none none 35 4 yes
46 500<=X<1000 car none good no checking 36 male single skilled own existing paid radio/tv 2299 4 >=7 1 1 none none 39 4 yes
47 500<=X<1000 life insurance yes good <0 6 female div/dep/mar unemp/unskilled non res rent existing paid used car 1352 1 unemployed 1 1 none none 23 2 yes
48 <100 life insurance none good no checking 11 male single unskilled resident own critical/other existing credit new car 7228 1 1<=X<4 2 1 none none 39 4 yes
49 100<=X<500 real estate none good no checking 12 female div/dep/mar skilled own existing paid radio/tv 2073 4 1<=X<4 1 1 co applicant none 28 2 yes
50 no known savings life insurance none good 0<=X<200 24 male single unskilled resident own delayed previously furniture/equipment 2333 4 <1 1 1 none bank 29 2 yes
51 <100 car yes good 0<=X<200 27 male single high qualif/self emp/mgmt own delayed previously used car 5965 1 >=7 2 1 none none 30 2 yes
52 <100 car none good no checking 12 male single skilled own existing paid radio/tv 1262 3 1<=X<4 1 1 none none 25 2 yes
53 no known savings life insurance yes good no checking 18 male single skilled own existing paid used car 3378 2 1<=X<4 1 1 none none 31 1 yes
54 <100 no known property yes bad 0<=X<200 36 male single skilled for free delayed previously new car 2225 4 >=7 2 1 none bank 57 4 yes
55 no known savings real estate none good no checking 6 male single unskilled resident own all paid new car 783 1 1<=X<4 1 2 guarantor stores 26 2 yes
56 no known savings no known property yes bad 0<=X<200 12 male single high qualif/self emp/mgmt own existing paid radio/tv 6468 2 unemployed 1 1 none none 52 1 yes
57 <100 car none good no checking 36 female div/dep/mar skilled own critical/other existing credit radio/tv 9566 2 1<=X<4 2 1 none stores 31 2 yes
58 <100 car none good >=200 18 female div/dep/mar high qualif/self emp/mgmt own existing paid new car 1961 3 >=7 1 1 none none 23 2 yes
59 <100 no known property yes bad <0 36 female div/dep/mar unskilled resident rent critical/other existing credit furniture/equipment 6229 4 <1 2 1 co applicant none 23 4 yes
60 <100 real estate yes good 0<=X<200 9 male mar/wid skilled own existing paid business 1391 2 1<=X<4 1 1 none bank 27 1 yes
61 no known savings real estate yes good 0<=X<200 15 male single skilled own critical/other existing credit radio/tv 1537 4 >=7 2 1 guarantor none 50 4 yes
62 <100 no known property yes bad 0<=X<200 36 male single high qualif/self emp/mgmt for free no credits/all paid business 1953 4 >=7 1 1 none none 61 4 yes
63 <100 car yes bad 0<=X<200 48 male single skilled own no credits/all paid business 14421 2 1<=X<4 1 1 none none 25 2 yes
64 <100 life insurance yes good no checking 24 female div/dep/mar skilled own existing paid radio/tv 3181 4 <1 1 1 none none 26 4 yes
65 no known savings life insurance yes good no checking 27 male single skilled own existing paid repairs 5190 4 >=7 4 2 none none 48 4 yes
66 <100 car none good no checking 12 female div/dep/mar skilled own existing paid radio/tv 2171 2 <1 1 1 none bank 29 2 yes
67 >=1000 real estate none good 0<=X<200 12 male mar/wid skilled own existing paid new car 1007 4 1<=X<4 1 1 none none 22 1 yes
68 <100 no known property yes bad no checking 36 male single skilled for free existing paid education 1819 4 1<=X<4 1 1 none stores 37 4 yes
69 no known savings car none good no checking 36 female div/dep/mar skilled own existing paid radio/tv 2394 4 1<=X<4 1 1 none none 25 4 yes
70 <100 life insurance none good no checking 36 female div/dep/mar skilled own existing paid used car 8133 1 1<=X<4 1 1 none bank 30 2 yes
71 no known savings life insurance yes good no checking 7 male single unskilled resident rent critical/other existing credit radio/tv 730 4 >=7 2 1 none none 46 2 yes
72 <100 no known property yes good <0 8 male single high qualif/self emp/mgmt for free critical/other existing credit other 1164 3 >=7 2 2 none bank 51 4 yes
73 <100 real estate none good 0<=X<200 42 female div/dep/mar unskilled resident own critical/other existing credit business 5954 2 4<=X<7 2 1 none bank 41 1 yes
74 no known savings no known property yes bad <0 36 male single high qualif/self emp/mgmt own existing paid education 1977 4 >=7 1 1 none none 40 4 yes
75 <100 no known property none good <0 12 male single high qualif/self emp/mgmt for free critical/other existing credit used car 1526 4 >=7 2 1 none none 66 4 yes
76 <100 car none bad <0 42 male single skilled own existing paid radio/tv 3965 4 <1 1 1 none none 34 3 yes
77 <100 life insurance none good 0<=X<200 11 male single skilled own delayed previously radio/tv 4771 2 4<=X<7 1 1 none none 51 4 yes
78 no known savings life insurance none good no checking 54 male single unskilled resident own no credits/all paid used car 9436 2 1<=X<4 1 2 none none 39 2 yes
79 <100 life insurance none good 0<=X<200 30 male mar/wid skilled own existing paid furniture/equipment 3832 2 <1 1 1 none none 22 1 yes
80 no known savings car yes bad no checking 24 female div/dep/mar skilled own existing paid radio/tv 5943 1 <1 2 1 none none 44 1 yes
81 500<=X<1000 life insurance yes good no checking 15 male single skilled own existing paid radio/tv 1213 4 >=7 1 1 none stores 47 3 yes
82 100<=X<500 life insurance none good no checking 18 female div/dep/mar unskilled resident rent existing paid business 1568 3 1<=X<4 1 1 none none 24 4 yes
83 <100 real estate yes good <0 24 female div/dep/mar unskilled resident own existing paid other 1755 4 >=7 1 1 guarantor none 58 4 yes
84 <100 real estate none good <0 10 male single unskilled resident own existing paid radio/tv 2315 3 >=7 1 1 none none 52 4 yes
85 <100 real estate yes good no checking 12 female div/dep/mar high qualif/self emp/mgmt own critical/other existing credit business 1412 4 1<=X<4 2 1 guarantor none 29 2 yes
86 <100 life insurance none good 0<=X<200 18 female div/dep/mar skilled own critical/other existing credit furniture/equipment 1295 4 <1 2 1 none none 27 1 yes
87 100<=X<500 no known property yes bad 0<=X<200 36 male single skilled for free existing paid education 12612 1 1<=X<4 1 2 none none 47 4 yes
88 100<=X<500 car yes good <0 18 male single high qualif/self emp/mgmt own existing paid new car 2249 4 4<=X<7 1 2 none none 30 3 yes
89 <100 real estate none bad <0 12 male single skilled own no credits/all paid repairs 1108 4 4<=X<7 2 1 none none 28 3 yes
90 <100 real estate none good no checking 12 male single skilled own critical/other existing credit radio/tv 618 4 >=7 1 1 none none 56 4 yes
91 <100 real estate none good <0 12 male single skilled own critical/other existing credit used car 1409 4 >=7 1 1 none none 54 3 yes
92 no known savings life insurance none bad no checking 12 female div/dep/mar unskilled resident own critical/other existing credit radio/tv 797 4 >=7 1 2 none bank 33 3 yes
93 no known savings no known property none good >=200 24 male single skilled rent critical/other existing credit furniture/equipment 3617 4 >=7 2 1 co applicant none 20 4 yes
94 >=1000 real estate yes good 0<=X<200 12 male single skilled own existing paid new car 1318 4 >=7 1 1 none none 54 4 yes
95 <100 no known property yes bad 0<=X<200 54 male single skilled rent no credits/all paid business 15945 3 <1 1 1 none none 58 4 yes
96 no known savings car none good no checking 12 female div/dep/mar skilled own critical/other existing credit education 2012 4 4<=X<7 1 1 none none 61 2 yes
97 100<=X<500 car none good 0<=X<200 18 male single skilled own existing paid business 2622 4 1<=X<4 1 1 none none 34 4 yes
98 <100 real estate none good 0<=X<200 36 male single skilled own critical/other existing credit radio/tv 2337 4 >=7 1 1 none none 36 4 yes
99 no known savings life insurance yes good 0<=X<200 20 male single high qualif/self emp/mgmt rent delayed previously used car 7057 3 4<=X<7 2 2 none bank 36 4 yes
savings_account_status property_magnitude has_telephone credit_risk_class checking_account_status credit_duration_months personal_status_sex job_qualification housing_situation credit_history credit_purpose credit_amount installment_rate_percentage employment_length_years num_existing_credits num_dependents other_parties_involved has_other_payment_plans age residence_length_years is_foreign_worker
0 None real estate yes good <0 6 male single skilled own critical/other existing credit radio/tv 1169 4 >=7 2 1 none none 67 4 True
1 <100 real estate None bad 0<=X<200 48 female divorced/widowed/married skilled own existing paid radio/tv 5951 2 1<=X<4 1 1 none none 22 2 True
2 <100 real estate None good no checking 12 male single unskilled resident own critical/other existing credit education 2096 2 4<=X<7 1 2 none none 49 3 True
3 <100 life insurance None good <0 42 male single skilled for free existing paid furniture/equipment 7882 2 4<=X<7 1 2 guarantor none 45 4 True
4 <100 None None bad <0 24 male single skilled for free delayed previously new car 4870 3 1<=X<4 2 2 none none 53 4 True
5 None None yes good no checking 36 male single unskilled resident for free existing paid education 9055 2 1<=X<4 1 2 none none 35 4 True
6 500<=X<1000 life insurance None good no checking 24 male single skilled own existing paid furniture/equipment 2835 3 >=7 1 1 none none 53 4 True
7 <100 car yes good 0<=X<200 36 male single high qualif/self emp/mgmt rent existing paid used car 6948 2 1<=X<4 1 1 none none 35 2 True
8 >=1000 real estate None good no checking 12 male divorced/separated unskilled resident own existing paid radio/tv 3059 2 4<=X<7 1 1 none none 61 4 True
9 <100 car None bad 0<=X<200 30 male married/widowed high qualif/self emp/mgmt own critical/other existing credit new car 5234 4 unemployed 2 1 none none 28 2 True
10 <100 car None bad 0<=X<200 12 female divorced/widowed/married skilled rent existing paid new car 1295 3 <1 1 1 none none 25 1 True
11 <100 life insurance None bad <0 48 female divorced/widowed/married skilled rent existing paid business 4308 3 <1 1 1 none none 24 4 True
12 <100 car yes good 0<=X<200 12 female divorced/widowed/married skilled own existing paid radio/tv 1567 1 1<=X<4 1 1 none none 22 1 True
13 <100 car None bad <0 24 male single unskilled resident own critical/other existing credit new car 1199 4 >=7 2 1 none none 60 4 True
14 <100 car None good <0 15 female divorced/widowed/married skilled rent existing paid new car 1403 2 1<=X<4 1 1 none none 28 4 True
15 100<=X<500 car None bad <0 24 female divorced/widowed/married unskilled resident own existing paid radio/tv 1282 4 1<=X<4 1 1 none none 32 2 True
16 None life insurance None good no checking 24 male single skilled own critical/other existing credit radio/tv 2424 4 >=7 2 1 none none 53 4 True
17 None car None good <0 30 male single skilled own no credits/all paid business 8072 2 <1 3 1 none bank 25 3 True
18 <100 None yes bad 0<=X<200 24 female divorced/widowed/married high qualif/self emp/mgmt for free existing paid used car 12579 4 >=7 1 1 none none 44 2 True
19 500<=X<1000 car yes good no checking 24 male single skilled own existing paid radio/tv 3430 3 >=7 1 2 none none 31 2 True
20 <100 car yes good no checking 9 male single skilled own critical/other existing credit new car 2134 4 1<=X<4 3 1 none none 48 4 True
21 500<=X<1000 real estate None good <0 6 male single skilled rent existing paid radio/tv 2647 2 1<=X<4 1 2 none none 44 3 True
22 <100 real estate None good <0 10 male single unskilled resident rent critical/other existing credit new car 2241 1 <1 2 2 none none 48 3 False
23 100<=X<500 life insurance None good 0<=X<200 12 male single skilled own critical/other existing credit used car 1804 3 <1 1 1 none none 44 4 True
24 None car None good no checking 10 male married/widowed skilled own critical/other existing credit furniture/equipment 2069 2 1<=X<4 2 1 none none 26 1 False
25 <100 real estate yes good <0 6 male single unskilled resident own existing paid furniture/equipment 1374 1 1<=X<4 1 1 none bank 36 2 True
26 <100 car None good no checking 6 male married/widowed unskilled resident own no credits/all paid radio/tv 426 4 >=7 1 1 none none 39 4 True
27 >=1000 real estate None good >=200 12 female divorced/widowed/married skilled rent all paid radio/tv 409 3 1<=X<4 2 1 none none 42 3 True
28 <100 real estate None good 0<=X<200 7 male single skilled own existing paid radio/tv 2415 3 1<=X<4 1 1 guarantor none 34 2 True
29 <100 None yes bad <0 60 male single skilled own delayed previously business 6836 3 >=7 2 1 none none 63 4 True
30 >=1000 real estate yes good 0<=X<200 18 male married/widowed skilled own existing paid business 1913 3 <1 1 1 none bank 36 3 True
31 <100 car None good <0 24 male single skilled own existing paid furniture/equipment 4020 2 1<=X<4 1 1 none stores 27 2 True
32 100<=X<500 car yes good 0<=X<200 18 male single skilled own existing paid new car 5866 2 1<=X<4 2 1 none none 30 2 True
33 None None None good no checking 12 male single unskilled resident rent critical/other existing credit business 1264 4 >=7 1 1 none none 57 4 True
34 <100 life insurance yes good >=200 12 female divorced/widowed/married high qualif/self emp/mgmt own existing paid furniture/equipment 1474 4 <1 1 1 none bank 33 1 True
35 <100 life insurance None bad 0<=X<200 45 male single unskilled resident own critical/other existing credit radio/tv 4746 4 <1 2 1 none none 25 2 True
36 <100 None yes good no checking 48 male single skilled for free critical/other existing credit education 6110 1 1<=X<4 1 1 none bank 31 3 True
37 <100 real estate None bad >=200 18 male single skilled own existing paid radio/tv 2100 4 1<=X<4 1 1 co applicant stores 37 2 True
38 <100 car yes good >=200 10 male single skilled own existing paid domestic appliance 1225 2 1<=X<4 1 1 none none 37 2 True
39 <100 real estate None good 0<=X<200 9 male single skilled own existing paid radio/tv 458 4 1<=X<4 1 1 none none 24 3 True
40 500<=X<1000 car None good no checking 30 male single high qualif/self emp/mgmt own existing paid radio/tv 2333 4 >=7 1 1 none bank 30 2 True
41 500<=X<1000 car yes good 0<=X<200 12 male divorced/separated skilled own existing paid radio/tv 1158 3 1<=X<4 1 1 none none 26 1 True
42 <100 real estate yes good 0<=X<200 18 male single unskilled resident own delayed previously repairs 6204 2 1<=X<4 1 2 none none 44 4 True
43 100<=X<500 car None good <0 30 male married/widowed skilled rent critical/other existing credit used car 6187 1 4<=X<7 2 1 none none 24 4 True
44 <100 None None bad <0 48 female divorced/widowed/married unskilled resident for free critical/other existing credit used car 6143 4 >=7 2 1 none stores 58 4 True
45 <100 car None good no checking 11 female divorced/widowed/married high qualif/self emp/mgmt own critical/other existing credit new car 1393 4 <1 2 1 none none 35 4 True
46 500<=X<1000 car None good no checking 36 male single skilled own existing paid radio/tv 2299 4 >=7 1 1 none none 39 4 True
47 500<=X<1000 life insurance yes good <0 6 female divorced/widowed/married unemp/unskilled non res rent existing paid used car 1352 1 unemployed 1 1 none none 23 2 True
48 <100 life insurance None good no checking 11 male single unskilled resident own critical/other existing credit new car 7228 1 1<=X<4 2 1 none none 39 4 True
49 100<=X<500 real estate None good no checking 12 female divorced/widowed/married skilled own existing paid radio/tv 2073 4 1<=X<4 1 1 co applicant none 28 2 True
50 None life insurance None good 0<=X<200 24 male single unskilled resident own delayed previously furniture/equipment 2333 4 <1 1 1 none bank 29 2 True
51 <100 car yes good 0<=X<200 27 male single high qualif/self emp/mgmt own delayed previously used car 5965 1 >=7 2 1 none none 30 2 True
52 <100 car None good no checking 12 male single skilled own existing paid radio/tv 1262 3 1<=X<4 1 1 none none 25 2 True
53 None life insurance yes good no checking 18 male single skilled own existing paid used car 3378 2 1<=X<4 1 1 none none 31 1 True
54 <100 None yes bad 0<=X<200 36 male single skilled for free delayed previously new car 2225 4 >=7 2 1 none bank 57 4 True
55 None real estate None good no checking 6 male single unskilled resident own all paid new car 783 1 1<=X<4 1 2 guarantor stores 26 2 True
56 None None yes bad 0<=X<200 12 male single high qualif/self emp/mgmt own existing paid radio/tv 6468 2 unemployed 1 1 none none 52 1 True
57 <100 car None good no checking 36 female divorced/widowed/married skilled own critical/other existing credit radio/tv 9566 2 1<=X<4 2 1 none stores 31 2 True
58 <100 car None good >=200 18 female divorced/widowed/married high qualif/self emp/mgmt own existing paid new car 1961 3 >=7 1 1 none none 23 2 True
59 <100 None yes bad <0 36 female divorced/widowed/married unskilled resident rent critical/other existing credit furniture/equipment 6229 4 <1 2 1 co applicant none 23 4 True
60 <100 real estate yes good 0<=X<200 9 male married/widowed skilled own existing paid business 1391 2 1<=X<4 1 1 none bank 27 1 True
61 None real estate yes good 0<=X<200 15 male single skilled own critical/other existing credit radio/tv 1537 4 >=7 2 1 guarantor none 50 4 True
62 <100 None yes bad 0<=X<200 36 male single high qualif/self emp/mgmt for free no credits/all paid business 1953 4 >=7 1 1 none none 61 4 True
63 <100 car yes bad 0<=X<200 48 male single skilled own no credits/all paid business 14421 2 1<=X<4 1 1 none none 25 2 True
64 <100 life insurance yes good no checking 24 female divorced/widowed/married skilled own existing paid radio/tv 3181 4 <1 1 1 none none 26 4 True
65 None life insurance yes good no checking 27 male single skilled own existing paid repairs 5190 4 >=7 4 2 none none 48 4 True
66 <100 car None good no checking 12 female divorced/widowed/married skilled own existing paid radio/tv 2171 2 <1 1 1 none bank 29 2 True
67 >=1000 real estate None good 0<=X<200 12 male married/widowed skilled own existing paid new car 1007 4 1<=X<4 1 1 none none 22 1 True
68 <100 None yes bad no checking 36 male single skilled for free existing paid education 1819 4 1<=X<4 1 1 none stores 37 4 True
69 None car None good no checking 36 female divorced/widowed/married skilled own existing paid radio/tv 2394 4 1<=X<4 1 1 none none 25 4 True
70 <100 life insurance None good no checking 36 female divorced/widowed/married skilled own existing paid used car 8133 1 1<=X<4 1 1 none bank 30 2 True
71 None life insurance yes good no checking 7 male single unskilled resident rent critical/other existing credit radio/tv 730 4 >=7 2 1 none none 46 2 True
72 <100 None yes good <0 8 male single high qualif/self emp/mgmt for free critical/other existing credit other 1164 3 >=7 2 2 none bank 51 4 True
73 <100 real estate None good 0<=X<200 42 female divorced/widowed/married unskilled resident own critical/other existing credit business 5954 2 4<=X<7 2 1 none bank 41 1 True
74 None None yes bad <0 36 male single high qualif/self emp/mgmt own existing paid education 1977 4 >=7 1 1 none none 40 4 True
75 <100 None None good <0 12 male single high qualif/self emp/mgmt for free critical/other existing credit used car 1526 4 >=7 2 1 none none 66 4 True
76 <100 car None bad <0 42 male single skilled own existing paid radio/tv 3965 4 <1 1 1 none none 34 3 True
77 <100 life insurance None good 0<=X<200 11 male single skilled own delayed previously radio/tv 4771 2 4<=X<7 1 1 none none 51 4 True
78 None life insurance None good no checking 54 male single unskilled resident own no credits/all paid used car 9436 2 1<=X<4 1 2 none none 39 2 True
79 <100 life insurance None good 0<=X<200 30 male married/widowed skilled own existing paid furniture/equipment 3832 2 <1 1 1 none none 22 1 True
80 None car yes bad no checking 24 female divorced/widowed/married skilled own existing paid radio/tv 5943 1 <1 2 1 none none 44 1 True
81 500<=X<1000 life insurance yes good no checking 15 male single skilled own existing paid radio/tv 1213 4 >=7 1 1 none stores 47 3 True
82 100<=X<500 life insurance None good no checking 18 female divorced/widowed/married unskilled resident rent existing paid business 1568 3 1<=X<4 1 1 none none 24 4 True
83 <100 real estate yes good <0 24 female divorced/widowed/married unskilled resident own existing paid other 1755 4 >=7 1 1 guarantor none 58 4 True
84 <100 real estate None good <0 10 male single unskilled resident own existing paid radio/tv 2315 3 >=7 1 1 none none 52 4 True
85 <100 real estate yes good no checking 12 female divorced/widowed/married high qualif/self emp/mgmt own critical/other existing credit business 1412 4 1<=X<4 2 1 guarantor none 29 2 True
86 <100 life insurance None good 0<=X<200 18 female divorced/widowed/married skilled own critical/other existing credit furniture/equipment 1295 4 <1 2 1 none none 27 1 True
87 100<=X<500 None yes bad 0<=X<200 36 male single skilled for free existing paid education 12612 1 1<=X<4 1 2 none none 47 4 True
88 100<=X<500 car yes good <0 18 male single high qualif/self emp/mgmt own existing paid new car 2249 4 4<=X<7 1 2 none none 30 3 True
89 <100 real estate None bad <0 12 male single skilled own no credits/all paid repairs 1108 4 4<=X<7 2 1 none none 28 3 True
90 <100 real estate None good no checking 12 male single skilled own critical/other existing credit radio/tv 618 4 >=7 1 1 none none 56 4 True
91 <100 real estate None good <0 12 male single skilled own critical/other existing credit used car 1409 4 >=7 1 1 none none 54 3 True
92 None life insurance None bad no checking 12 female divorced/widowed/married unskilled resident own critical/other existing credit radio/tv 797 4 >=7 1 2 none bank 33 3 True
93 None None None good >=200 24 male single skilled rent critical/other existing credit furniture/equipment 3617 4 >=7 2 1 co applicant none 20 4 True
94 >=1000 real estate yes good 0<=X<200 12 male single skilled own existing paid new car 1318 4 >=7 1 1 none none 54 4 True
95 <100 None yes bad 0<=X<200 54 male single skilled rent no credits/all paid business 15945 3 <1 1 1 none none 58 4 True
96 None car None good no checking 12 female divorced/widowed/married skilled own critical/other existing credit education 2012 4 4<=X<7 1 1 none none 61 2 True
97 100<=X<500 car None good 0<=X<200 18 male single skilled own existing paid business 2622 4 1<=X<4 1 1 none none 34 4 True
98 <100 real estate None good 0<=X<200 36 male single skilled own critical/other existing credit radio/tv 2337 4 >=7 1 1 none none 36 4 True
99 None life insurance yes good 0<=X<200 20 male single high qualif/self emp/mgmt rent delayed previously used car 7057 3 4<=X<7 2 2 none bank 36 4 True
savings_account_status
▲
not_nullaccepted_values

📃 Summary: Status of the individual's savings account

property_magnitude
▲
accepted_values

📃 Summary: Magnitude of the individual's property
❓ Missing: Not all loans are secured by property.

has_telephone
▲
accepted_values

📃 Summary: Indicates if the individual has a telephone
❓ Missing: Not everyone has a telephone.

credit_risk_class
▲
not_nullaccepted_values

📃 Summary: Credit risk classification: good or bad

checking_account_status
▲
not_nullaccepted_values

📃 Summary: Status of the individual's checking account

credit_duration_months
▲
not_null

📃 Summary: Duration of the credit in months

personal_status_sex
▲
not_nullaccepted_values

📃 Summary: Individual's personal status and sex

job_qualification
▲
not_nullaccepted_values

📃 Summary: Individual's job qualification

housing_situation
▲
not_nullaccepted_values

📃 Summary: Individual's housing situation

credit_history
▲
not_nullaccepted_values

📃 Summary: Individual's past credit history

credit_purpose
▲
not_nullaccepted_values

📃 Summary: Purpose of the credit

credit_amount
▲
not_null

📃 Summary: Amount of credit requested

installment_rate_percentage
▲
not_null

📃 Summary: Installment rate as a percentage of disposable income

employment_length_years
▲
not_nullaccepted_values

📃 Summary: Length of employment in years

num_existing_credits
▲
not_null

📃 Summary: Number of existing credits at the bank

num_dependents
▲
not_null

📃 Summary: Number of people dependent on the individual

other_parties_involved
▲
not_nullaccepted_values

📃 Summary: Indicates if there is a co-applicant or guarantor

has_other_payment_plans
▲
not_nullaccepted_values

📃 Summary: Indicates if the individual has other payment plans

age
▲
not_null

📃 Summary: Age of the individual

residence_length_years
▲
not_null

📃 Summary: Length of residence in years

is_foreign_worker
▲
not_null

📃 Summary: Indicates if the individual is a foreign worker

Cocoon Cleaning Summary 🤗


📃 1. Table Summary


The table contains credit data for individuals in Germany. It includes details about each person's financial status, credit history, employment, personal information, and whether they are classified as a good or bad credit risk.


📊 2. Column Rename


😎 16 columns have been renamed
Column Summary New Column Name Renamed?
0 checking_status Status of the individual's checking account checking_account_status ✔️ Yes
1 duration Duration of the credit in months credit_duration_months ✔️ Yes
2 credit_history Individual's past credit history credit_history ❌ No
3 purpose Purpose of the credit credit_purpose ✔️ Yes
4 credit_amount Amount of credit requested credit_amount ❌ No
5 savings_status Status of the individual's savings account savings_account_status ✔️ Yes
6 employment Length of employment in years employment_length_years ✔️ Yes
7 installment_commitment Installment rate as a percentage of disposable income installment_rate_percentage ✔️ Yes
8 personal_status Individual's personal status and sex personal_status_sex ✔️ Yes
9 other_parties Indicates if there is a co-applicant or guarantor other_parties_involved ✔️ Yes
10 residence_since Length of residence in years residence_length_years ✔️ Yes
11 property_magnitude Magnitude of the individual's property property_magnitude ❌ No
12 age Age of the individual age ❌ No
13 other_payment_plans Indicates if the individual has other payment plans has_other_payment_plans ✔️ Yes
14 housing Individual's housing situation housing_situation ✔️ Yes
15 existing_credits Number of existing credits at the bank num_existing_credits ✔️ Yes
16 job Individual's job qualification job_qualification ✔️ Yes
17 num_dependents Number of people dependent on the individual num_dependents ❌ No
18 own_telephone Indicates if the individual has a telephone has_telephone ✔️ Yes
19 foreign_worker Indicates if the individual is a foreign worker is_foreign_worker ✔️ Yes
20 class Credit risk classification: good or bad credit_risk_class ✔️ Yes



🚧 3. Erroneous Values


🔍 1 columns have erroneous values
  1. personal_status_sex: 'div/dep/mar' and 'div/sep' are unusual abbreviations. Gender groupings are inconsistent.
    ✔️ The column has been cleaned:
    Original Value Cleaned Value
    0 female div/dep/mar female divorced/widowed/married
    1 male mar/wid male married/widowed
    2 male div/sep male divorced/separated


🕵️‍♂️ 4. Disguised Missing Values


🔍 3 columns have disguised missing values
✔️ 3 columns have been cleaned
Column Disguised Missing Values Impute to NULL? Values to NULL (Sep By ,)
0 savings_account_status [no known savings] True no known savings
1 property_magnitude [no known property] True no known property
2 has_telephone [none] True none



🔧 5. Data Type


✔️ 1 columns have been casted
Column Name Clause Reasoning
0 is_foreign_worker CAST(CASE WHEN "is_foreign_worker" = 'yes' THEN TRUE ELSE FALSE END AS BOOLEAN) To transform the 'is_foreign_worker' column from 'VARCHAR' to 'BOOLEAN' data type in Snowflake, we can use a CASE expression within the CAST function. The CASE expression will map the 'yes' value to TRUE and the 'no' value to FALSE. By casting the result of the CASE expression to BOOLEAN, we effectively convert the column to the desired data type.\n



❓ 6. Missing Values


🔍 3 columns have missing values
✔️ 2 of them are acceptable
Column NULL (%) Is NULL Acceptable? Explanation
0 has_telephone 59.6 True Not everyone has a telephone.
1 property_magnitude 15.4 True Not all loans are secured by property.
2 savings_account_status 18.3 False

🧩 These missing values are handled as follows:
Column NULL (%) Strategy
0 savings_account_status 18.3 🔄 Unchanged