Skip to contents

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.

Usage

tstm_loans_pn

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>