In [ ]:

    

import dir_constants as dc


    

In [ ]:

    

platform = 'lendingclub'

store = pd.HDFStore(
    dc.home_path+'/justin_tinkering/data_science/lendingclub/{0}_store.h5'.
    format(platform),
    append=True)
loan_info = store['loan_info_clean']
store.close()


    

In [ ]:

    

done_loans = loan_info[loan_info['loan_status'].isin(['paid', 'charged_off', 'defaulted', 'late_120', 'late_30', 'grace_15'])]


    

In [ ]:

    

done_loans['loan_status'].value_counts(dropna=False)/len(done_loans)


    

In [ ]:

    

done_loans[done_loans['application_type'] == 'joint']['loan_status'].value_counts(dropna=False)/len(done_loans[done_loans['application_type'] == 'joint'])


    

In [ ]:

    

len(done_loans)


    

In [ ]:

    

len(done_loans[done_loans['application_type'] == 'joint'])


    

In [ ]: