Data report overview

The dataset examined has the following dimensions:

Feature Result
Number of observations 9079
Number of variables 48

Codebook summary table

Label Variable Class # unique values Missing Description
repartition integer 4 0.00 %
tax_identification_number numeric 9079 0.00 %
ID integer 9078 0.00 %
reclassified factor 2 0.00 %
quantity_months_different_to_situation_1 integer 12 0.00 %
maximum_situation_12_months integer 4 0.00 %
average_debt_months_different_situation_1 numeric 2211 0.00 %
quantity_entities_situation_2_prior_12_months integer 12 0.00 %
months_situation_3 integer 13 0.00 %
average_debt_months_situation_3 numeric 1597 0.00 %
quantity_entities_situation_3_prior_12_months integer 11 0.00 %
ratio_situation_2_over_total_debt_prior_6_months numeric 7425 0.00 %
ratio_situation_3_over_total_debt_prior_6_months numeric 5269 0.00 %
reclassified_prior_11_months integer 2 0.00 %
amount_debt_banks integer 505 0.00 %
quantity_banks_with_debt integer 13 0.00 %
situation_debt_banks integer 6 0.00 %
amount_debt_state_bank integer 379 0.00 %
situation_debt_state_bank integer 6 0.00 %
amount_debt_financial_trust integer 59 0.00 %
quantity_debt_financial_trust integer 6 0.00 %
situation_debt_financial_trust integer 6 0.00 %
amount_debt_financial_institution_no_bank integer 144 0.00 %
quantity_debt_financial_institution_no_bank integer 3 0.00 %
situation_debt_financial_institution_no_bank integer 6 0.00 %
amount_debt_institution_out_supervision_bcra integer 223 0.00 %
quantity_debt_institution_out_supervision_bcra integer 13 0.00 %
situation_debt_institution_out_supervision_bcra integer 6 0.00 %
amount_debt_credit_card integer 112 0.00 %
quantity_debt_credit_card integer 6 0.00 %
situation_debt_credit_card integer 6 0.00 %
amount_debt_situation_1 integer 509 0.00 %
quantity_debt_situation_1 integer 15 0.00 %
amount_debt_situation_2 integer 226 0.00 %
quantity_debt_situation_2 integer 8 0.00 %
amount_debt_situation_3 integer 135 0.00 %
quantity_debt_situation_3 integer 7 0.00 %
amount_debt_situation_4 integer 133 0.00 %
quantity_debt_situation_4 integer 7 0.00 %
amount_debt_situation_5 integer 129 0.00 %
quantity_debt_situation_5 integer 7 0.00 %
amount_total_debt integer 583 0.00 %
ratio_debt_greater_situation_2_over_total_debt numeric 2810 0.00 %
ratio_debt_situation_2_over_total_debt numeric 3972 0.00 %
ratio_debt_state_banks_over_total numeric 787 0.00 %
ratio_debt_retails_banks_over_total numeric 2319 0.00 %
amount_debt_our_bank integer 144 0.00 %
situation_debt_our_bank integer 6 0.00 %

Variable list

repartition

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 4
Median 2
1st and 3rd quartiles 1; 4
Min. and max. 1; 4

tax_identification_number

Feature Result
Variable type numeric
Number of missing obs. 0 (0 %)
Number of unique values 9079
Median 27056145899
1st and 3rd quartiles 20293536205.5; 27229082806
Min. and max. 20023891736; 27442345746

ID

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 9078
Median 22510362
1st and 3rd quartiles 13383835; 29354324.5
Min. and max. 597705; 94297751

reclassified

Feature Result
Variable type factor
Number of missing obs. 0 (0 %)
Number of unique values 2
Mode “no”
Reference category no

  • Observed factor levels: "no", "yes".

quantity_months_different_to_situation_1

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 12
Median 9
1st and 3rd quartiles 4; 12
Min. and max. 1; 12

maximum_situation_12_months

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 4
Median 4
1st and 3rd quartiles 2; 5
Min. and max. 2; 5

average_debt_months_different_situation_1

Feature Result
Variable type numeric
Number of missing obs. 0 (0 %)
Number of unique values 2211
Median 16
1st and 3rd quartiles 7; 33
Min. and max. 0.29; 2141.67

quantity_entities_situation_2_prior_12_months

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 12
Median 2
1st and 3rd quartiles 1; 3
Min. and max. 1; 13

months_situation_3

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 13
Median 5
1st and 3rd quartiles 0; 12
Min. and max. 0; 12

average_debt_months_situation_3

Feature Result
Variable type numeric
Number of missing obs. 0 (0 %)
Number of unique values 1597
Median 8
1st and 3rd quartiles 0; 21.91
Min. and max. 0; 2172

quantity_entities_situation_3_prior_12_months

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 11
Median 1
1st and 3rd quartiles 0; 2
Min. and max. 0; 11

ratio_situation_2_over_total_debt_prior_6_months

Feature Result
Variable type numeric
Number of missing obs. 0 (0 %)
Number of unique values 7425
Median 0.14
1st and 3rd quartiles 0.05; 0.32
Min. and max. 0; 1

ratio_situation_3_over_total_debt_prior_6_months

Feature Result
Variable type numeric
Number of missing obs. 0 (0 %)
Number of unique values 5269
Median 0.06
1st and 3rd quartiles 0; 0.24
Min. and max. 0; 1

reclassified_prior_11_months

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 2
Median 0
1st and 3rd quartiles 0; 0
Min. and max. 0; 1

amount_debt_banks

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 505
Median 72
1st and 3rd quartiles 23; 139
Min. and max. 0; 3329

quantity_banks_with_debt

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 13
Median 2
1st and 3rd quartiles 1; 3
Min. and max. 0; 14

situation_debt_banks

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 6
Median 1
1st and 3rd quartiles 1; 3
Min. and max. 0; 5

amount_debt_state_bank

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 379
Median 46
1st and 3rd quartiles 10; 101
Min. and max. 0; 1006

situation_debt_state_bank

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 6
Median 1
1st and 3rd quartiles 1; 1
Min. and max. 0; 5

amount_debt_financial_trust

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 59
Median 0
1st and 3rd quartiles 0; 0
Min. and max. 0; 248

quantity_debt_financial_trust

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 6
Median 0
1st and 3rd quartiles 0; 1
Min. and max. 0; 5

situation_debt_financial_trust

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 6
Median 0
1st and 3rd quartiles 0; 0
Min. and max. 0; 5

amount_debt_financial_institution_no_bank

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 144
Median 0
1st and 3rd quartiles 0; 0
Min. and max. 0; 596

quantity_debt_financial_institution_no_bank

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 3
Median 0
1st and 3rd quartiles 0; 0
Min. and max. 0; 2

situation_debt_financial_institution_no_bank

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 6
Median 0
1st and 3rd quartiles 0; 0
Min. and max. 0; 5

amount_debt_institution_out_supervision_bcra

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 223
Median 7
1st and 3rd quartiles 0; 31
Min. and max. 0; 2172

quantity_debt_institution_out_supervision_bcra

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 13
Median 1
1st and 3rd quartiles 0; 3
Min. and max. 0; 12

situation_debt_institution_out_supervision_bcra

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 6
Median 1
1st and 3rd quartiles 0; 3
Min. and max. 0; 5

amount_debt_credit_card

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 112
Median 0
1st and 3rd quartiles 0; 5
Min. and max. 0; 180

quantity_debt_credit_card

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 6
Median 0
1st and 3rd quartiles 0; 1
Min. and max. 0; 5

situation_debt_credit_card

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 6
Median 0
1st and 3rd quartiles 0; 1
Min. and max. 0; 5

amount_debt_situation_1

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 509
Median 79
1st and 3rd quartiles 22; 150
Min. and max. 0; 3329

quantity_debt_situation_1

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 15
Median 2
1st and 3rd quartiles 1; 3
Min. and max. 0; 15

amount_debt_situation_2

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 226
Median 0
1st and 3rd quartiles 0; 10
Min. and max. 0; 1173

quantity_debt_situation_2

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 8
Median 0
1st and 3rd quartiles 0; 1
Min. and max. 0; 7

amount_debt_situation_3

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 135
Median 0
1st and 3rd quartiles 0; 0
Min. and max. 0; 2172

quantity_debt_situation_3

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 7
Median 0
1st and 3rd quartiles 0; 0
Min. and max. 0; 8

amount_debt_situation_4

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 133
Median 0
1st and 3rd quartiles 0; 0
Min. and max. 0; 1561

quantity_debt_situation_4

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 7
Median 0
1st and 3rd quartiles 0; 0
Min. and max. 0; 6

amount_debt_situation_5

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 129
Median 0
1st and 3rd quartiles 0; 6
Min. and max. 0; 556

quantity_debt_situation_5

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 7
Median 0
1st and 3rd quartiles 0; 1
Min. and max. 0; 6

amount_total_debt

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 583
Median 102
1st and 3rd quartiles 42; 182
Min. and max. 1; 5501

ratio_debt_greater_situation_2_over_total_debt

Feature Result
Variable type numeric
Number of missing obs. 0 (0 %)
Number of unique values 2810
Median 0.08
1st and 3rd quartiles 0; 0.29
Min. and max. 0; 1

ratio_debt_situation_2_over_total_debt

Feature Result
Variable type numeric
Number of missing obs. 0 (0 %)
Number of unique values 3972
Median 0.19
1st and 3rd quartiles 0.07; 0.43
Min. and max. 0; 1

ratio_debt_state_banks_over_total

Feature Result
Variable type numeric
Number of missing obs. 0 (0 %)
Number of unique values 787
Median 0
1st and 3rd quartiles 0; 0
Min. and max. 0; 1

ratio_debt_retails_banks_over_total

Feature Result
Variable type numeric
Number of missing obs. 0 (0 %)
Number of unique values 2319
Median 0
1st and 3rd quartiles 0; 0.09
Min. and max. 0; 1

amount_debt_our_bank

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 144
Median 0
1st and 3rd quartiles 0; 0
Min. and max. 0; 298

situation_debt_our_bank

Feature Result
Variable type integer
Number of missing obs. 0 (0 %)
Number of unique values 6
Median 0
1st and 3rd quartiles 0; 0
Min. and max. 0; 5

Report generation information:

  • Created by mrmelchi (username: Mario).

  • Report creation time: lu. may. 13 2019 17:41:46

  • Report was run from directory: C:/Users/Mario/OneDrive/Documentos/Credit_Scoring

  • dataMaid v1.2.0 [Pkg: 2018-10-03 from CRAN (R 3.5.3)]

  • R version 3.5.3 (2019-03-11).

  • Platform: x86_64-w64-mingw32/x64 (64-bit)(Windows 10 x64 (build 17763)).

  • Function call: makeDataReport(data = data, mode = c("summarize", "visualize", "check"), smartNum = FALSE, file = "codebook_data.Rmd", checks = list( character = "showAllFactorLevels", factor = "showAllFactorLevels", labelled = "showAllFactorLevels", haven_labelled = "showAllFactorLevels", numeric = NULL, integer = NULL, logical = NULL, Date = NULL), listChecks = FALSE, maxProbVals = Inf, codebook = TRUE, reportTitle = "Codebook for data")