Loan as unit of observation file with loan term, dates, categorization, summarized from tstm_loans_panel
. This files contains both hh_loan_id
, which is the household-specific loan id for each loan, and hh_loan_id_nd
, which is the non-duplicate loan ID.
Format
Loan dataframe with various loan attributes
- hhid_Num
Household ID
- hh_loan_id
Loan id, individual-hh-specific loan id
- hh_loan_id_nd
Non-duplicate loan id, sequential for all loans
- loan_start
Loan start month
- loan_end
Loan end month
- number_indi_loan
Number of individual loans combined to generate a non-duplicate loan
- forinfm4
Name of categorical variable defining loan group types
- loan_principal_interest
Loan principal and interests aggregating over individual loans with the same dates and lender type
- loan_principal
loan_principal_interest
but without interests
Examples
data(tstm_loans_pn)
summary(tstm_loans_pn)
#> hhid_Num hh_loan_id hh_loan_id_nd loan_start
#> Min. : 70203 Min. : 1.00 Min. : 1 Min. : 0.00
#> 1st Qu.:271029 1st Qu.: 9.00 1st Qu.: 4994 1st Qu.: 46.00
#> Median :490306 Median : 19.00 Median : 9913 Median : 78.00
#> Mean :378178 Mean : 23.28 Mean : 9883 Mean : 78.73
#> 3rd Qu.:530101 3rd Qu.: 33.00 3rd Qu.:14810 3rd Qu.:113.00
#> Max. :531026 Max. :131.00 Max. :19587 Max. :160.00
#>
#> loan_end number_indi_loan forinfm4 loan_principal_interest
#> Min. : 0.00 Min. : 1.000 Length:20943 Min. : 0
#> 1st Qu.: 59.00 1st Qu.: 1.000 Class :character 1st Qu.: 3200
#> Median : 90.00 Median : 1.000 Mode :character Median : 11004
#> Mean : 91.79 Mean : 1.148 Mean : 22849
#> 3rd Qu.:128.00 3rd Qu.: 1.000 3rd Qu.: 21200
#> Max. :160.00 Max. :11.000 Max. :2200000
#> NA's :1781
#> loan_principal
#> Min. : 0
#> 1st Qu.: 3000
#> Median : 10000
#> Mean : 21555
#> 3rd Qu.: 20000
#> Max. :2000000
#> NA's :1948
print(tstm_loans_pn)
#> # A tibble: 20,943 × 9
#> hhid_Num hh_loan_id hh_loan_id_nd loan_start loan_end number_indi_loan
#> <dbl> <int> <int> <dbl> <dbl> <int>
#> 1 70203 1 1 12 14 1
#> 2 70203 2 2 15 15 1
#> 3 70203 3 3 39 51 1
#> 4 70203 4 4 51 65 1
#> 5 70203 5 6 64 67 1
#> 6 70203 6 5 64 65 1
#> 7 70203 7 7 65 74 1
#> 8 70203 8 9 74 86 1
#> 9 70203 9 8 74 78 1
#> 10 70203 10 10 77 125 1
#> # ℹ 20,933 more rows
#> # ℹ 3 more variables: forinfm4 <chr>, loan_principal_interest <dbl>,
#> # loan_principal <dbl>