ML之FE:基于自定义数据集(银行客户信息贷款和赔偿)对比实现特征衍生(手动设计新特征、利用featuretools工具实现自动特征生成)

ML之FE:基于自定义数据集(银行客户信息贷款和赔偿)对比实现特征衍生(手动设计新特征、利用featuretools工具实现自动特征生成)

 

 

 

目录

基于自定义数据集(银行客户信息贷款和赔偿)对比实现特征衍生(T1手动设计新特征、T2利用featuretools工具实现自动特征生成)

设计思路

输出结果

T1、手动设计新特征

T2、利用featuretools工具实现自动特征生成

T2.1、79个Feature Primitives

T2.2、深度特征合成:指通过叠加多个基元来得到特征

1)、完整的数据框包含了254-5个新特征,特征工具通过结合与叠加基元特征构造了许多新特征

2)、完整的数据框包含了113-5个新特征


 

相关文章
ML之FE:基于自定义数据集(银行客户信息贷款和赔偿)对比实现特征衍生(手动设计新特征、利用featuretools工具实现自动特征生成)
ML之FE:基于自定义数据集(银行客户信息贷款和赔偿)对比实现特征衍生(手动设计新特征、利用featuretools工具实现自动特征生成)实现

基于自定义数据集(银行客户信息贷款和赔偿)对比实现特征衍生(T1手动设计新特征、T2利用featuretools工具实现自动特征生成)

设计思路

 

 

输出结果

clients 
    client_id  age       education  income  credit_score loan_type     joined
0      44966   31  BachelorDegree   58530           822    credit 2019-05-13
1      46602   24    DoctorDegree  176949           583      cash 2020-03-14
2      38435   43    DoctorDegree  183813           596      home 2019-06-26
3      47641   48    DoctorDegree  149357           532    credit 2020-06-25
4      25942   18    DoctorDegree  227219           839      cash 2019-06-09
loans 
    client_id loan_type  loan_amount  repaid  loan_id loan_start   loan_end  \
0      44966    credit         7733       0    11246 2020-09-15 2023-02-22   
1      46602      cash         9547       1    10612 2019-01-25 2021-09-22   
2      38435      home         6615       0    10339 2019-05-13 2020-12-25   
3      47641    credit         5050       1    10442 2020-02-22 2022-10-26   
4      25942      cash        14059       0    11871 2019-04-10 2021-03-29   

   rate  
0  0.42  
1  4.03  
2  5.65  
3  7.51  
4  3.58  
payments 
    loan_id  payment_amount payment_date  missed
0    11246            1136   2020-11-19       0
1    11246             858   2020-11-29       0
2    11246            1245   2020-12-31       0
3    11246            1153   2021-01-17       1
4    11246             838   2021-02-10       1
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

 

 

T1、手动设计新特征

loan_typemean_loan_amountmax_loan_amountmin_loan_amount
cash12014.5148848458
credit7329.857143134573795
home5456.5101301430
other9025.833333141082466

 

 

T2、利用featuretools工具实现自动特征生成

将payments数据框全部加入实体集后,输出信息,
 Entity: payments
  Variables:
    payment_id (dtype: index)
    loan_id (dtype: numeric)
    payment_amount (dtype: numeric)
    payment_date (dtype: datetime_time_index)
    missed (dtype: categorical)
  Shape:
    (Rows: 179, Columns: 5)
该实体集现在包括三个实体以及连接这些实体之间的关系,这时候已经做好了构造新特征的准备。 
 Entityset: clients
  Entities:
    clients [Rows: 25, Columns: 7]
    payments [Rows: 179, Columns: 5]
    loans [Rows: 25, Columns: 8]
  Relationships:
    loans.client_id -> clients.client_id
    payments.loan_id -> loans.loan_id
primitives:  <class 'pandas.core.frame.DataFrame'> 79 

 

 

T2.1、79个Feature Primitives

[79 rows x 5 columns]

 nametypedask_compatiblekoalas_compatibledescription描述
0allaggregationTRUEFALSECalculates if all values are 'True' in a list.计算列表中所有值是否均为“ True”。
1num_uniqueaggregationTRUETRUEDetermines the number of distinct values, ignoring `NaN` values.确定不同值的数量,忽略“ NaN”值。
2anyaggregationTRUEFALSEDetermines if any value is 'True' in a list.确定列表中是否有任何值为“ True”。
3time_since_lastaggregationFALSEFALSECalculates the time elapsed since the last datetime (default in seconds).计算自上一个日期时间以来经过的时间(默认值以秒为单位)。
4n_most_commonaggregationFALSEFALSEDetermines the `n` most common elements.确定n个最常见的元素。
5lastaggregationFALSEFALSEDetermines the last value in a list.确定列表中的最后一个值。
6entropyaggregationFALSEFALSECalculates the entropy for a categorical variable计算分类变量的熵
7num_trueaggregationTRUEFALSECounts the number of `True` values.计算“True”值的数量。
8medianaggregationFALSEFALSEDetermines the middlemost number in a list of values.确定值列表中的最中间数字。
9skewaggregationFALSEFALSEComputes the extent to which a distribution differs from a normal distribution.计算分布与正态分布的差异程度。
10maxaggregationTRUETRUECalculates the highest value, ignoring `NaN` values.计算最高值,而忽略“ NaN”值。
11avg_time_betweenaggregationFALSEFALSEComputes the average number of seconds between consecutive events.计算连续事件之间的平均秒数。
12firstaggregationFALSEFALSEDetermines the first value in a list.确定列表中的第一个值。
13sumaggregationTRUETRUECalculates the total addition, ignoring `NaN`.计算总的加法,忽略“ NaN”。
14minaggregationTRUETRUECalculates the smallest value, ignoring `NaN` values.计算最小值,忽略“ NaN”值。
15meanaggregationTRUETRUEComputes the average for a list of values.计算值列表的平均值。
16stdaggregationTRUETRUEComputes the dispersion relative to the mean value, ignoring `NaN`.忽略“ NaN”,计算相对于平均值的离散度。
17time_since_firstaggregationFALSEFALSECalculates the time elapsed since the first datetime (in seconds).计算自第一个日期时间以来经过的时间(以秒为单位)。
18modeaggregationFALSEFALSEDetermines the most commonly repeated value.确定最常见的重复值。
19percent_trueaggregationTRUEFALSEDetermines the percent of `True` values.确定“True”值的百分比。
20countaggregationTRUETRUEDetermines the total number of values, excluding `NaN`.确定值的总数,不包括“ NaN”。
21trendaggregationFALSEFALSECalculates the trend of a variable over time.计算变量随时间的趋势。
22multiply_booleantransformTRUEFALSEElement-wise multiplication of two lists of boolean values.两个布尔值列表的逐元素相乘。
23less_than_equal_totransformTRUETRUEDetermines if values in one list are less than or equal to another list.确定一个列表中的值是否小于或等于另一个列表。
24percentiletransformFALSEFALSEDetermines the percentile rank for each value in a list.确定列表中每个值的百分等级。
25num_characterstransformTRUETRUECalculates the number of characters in a string.计算字符串中的字符数。
26daytransformTRUETRUEDetermines the day of the month from a datetime.从日期时间确定一个月中的哪一天。
27cum_counttransformFALSEFALSECalculates the cumulative count.计算累积计数。
28scalar_subtract_numeric_featuretransformTRUETRUESubtract each value in the list from a given scalar.从给定的标量中减去列表中的每个值。
29time_since_previoustransformFALSEFALSECompute the time since the previous entry in a list.计算自列表中上一个条目以来的时间。
30is_weekendtransformTRUETRUEDetermines if a date falls on a weekend.确定日期是否在周末。
31yeartransformTRUETRUEDetermines the year value of a datetime.确定日期时间的年份值。
32ortransformTRUETRUEElement-wise logical OR of two lists.两个列表的元素级逻辑或。
33not_equaltransformTRUEFALSEDetermines if values in one list are not equal to another list.确定一个列表中的值是否不等于另一个列表。
34monthtransformTRUETRUEDetermines the month value of a datetime.确定日期时间的月份值。
35latitudetransformFALSEFALSEReturns the first tuple value in a list of LatLong tuples.返回LatLong元组列表中的第一个元组值。
36modulo_by_featuretransformTRUETRUEReturn the modulo of a scalar by each element in the list.返回列表中每个元素的标量的模。
37less_than_scalartransformTRUETRUEDetermines if values are less than a given scalar.确定值是否小于给定的标量。
38less_than_equal_to_scalartransformTRUETRUEDetermines if values are less than or equal to a given scalar.确定值是否小于或等于给定的标量。
39is_nulltransformTRUETRUEDetermines if a value is null.确定值是否为空。
40modulo_numeric_scalartransformTRUETRUEReturn the modulo of each element in the list by a scalar.以标量返回列表中每个元素的模。
41greater_than_equal_totransformTRUETRUEDetermines if values in one list are greater than or equal to another list.确定一个列表中的值是否大于或等于另一个列表。
42difftransformFALSEFALSECompute the difference between the value in a list and the计算列表中的值与
43divide_numeric_scalartransformTRUETRUEDivide each element in the list by a scalar.用标量除以列表中的每个元素。
44modulo_numerictransformTRUETRUEElement-wise modulo of two lists.两个列表的按元素取模。
45multiply_numeric_scalartransformTRUETRUEMultiply each element in the list by a scalar.将列表中的每个元素乘以标量。
46divide_numerictransformTRUETRUEElement-wise division of two lists.两个列表的按元素划分。
47equal_scalartransformTRUETRUEDetermines if values in a list are equal to a given scalar.确定列表中的值是否等于给定的标量。
48agetransformTRUEFALSECalculates the age in years as a floating point number given a给定a,以浮点数形式计算年龄(以年为单位)。
49secondtransformTRUETRUEDetermines the seconds value of a datetime.确定日期时间的秒值。
50cum_meantransformFALSEFALSECalculates the cumulative mean.计算累积平均值。
51multiply_numerictransformTRUETRUEElement-wise multiplication of two lists.两个列表的按元素乘法。
52less_thantransformTRUETRUEDetermines if values in one list are less than another list.确定一个列表中的值是否小于另一个列表。
53time_sincetransformTRUEFALSECalculates time from a value to a specified cutoff datetime.计算从值到指定的截止日期时间的时间。
54weekdaytransformTRUETRUEDetermines the day of the week from a datetime.从日期时间确定星期几。
55haversinetransformFALSEFALSECalculates the approximate haversine distance between two LatLong计算两个LatLong之间的大致Haversine距离
56cum_sumtransformFALSEFALSECalculates the cumulative sum.计算累计和。
57add_numeric_scalartransformTRUETRUEAdd a scalar to each value in the list.向列表中的每个值添加一个标量。
58greater_than_scalartransformTRUETRUEDetermines if values are greater than a given scalar.确定值是否大于给定的标量。
59num_wordstransformTRUETRUEDetermines the number of words in a string by counting the spaces.通过计算空格来确定字符串中的单词数。
60minutetransformTRUETRUEDetermines the minutes value of a datetime.确定日期时间的分钟值。
61absolutetransformTRUETRUEComputes the absolute value of a number.计算数字的绝对值。
62andtransformTRUETRUEElement-wise logical AND of two lists.两个列表的按元素逻辑与。
63equaltransformTRUETRUEDetermines if values in one list are equal to another list.确定一个列表中的值是否等于另一列表。
64hourtransformTRUETRUEDetermines the hour value of a datetime.确定日期时间的小时值。
65isintransformTRUETRUEDetermines whether a value is present in a provided list.确定提供的列表中是否存在值。
66subtract_numeric_scalartransformTRUETRUESubtract a scalar from each element in the list.从列表中的每个元素中减去一个标量。
67greater_than_equal_to_scalartransformTRUETRUEDetermines if values are greater than or equal to a given scalar.确定值是否大于或等于给定的标量。
68nottransformTRUETRUENegates a boolean value.取反布尔值。
69cum_maxtransformFALSEFALSECalculates the cumulative maximum.计算累计最大值。
70subtract_numerictransformTRUEFALSEElement-wise subtraction of two lists.两个列表的逐元素减法。
71greater_thantransformTRUEFALSEDetermines if values in one list are greater than another list.确定一个列表中的值是否大于另一个列表。
72weektransformTRUETRUEDetermines the week of the year from a datetime.从日期时间确定一年中的星期。
73add_numerictransformTRUETRUEElement-wise addition of two lists.按元素添加两个列表。
74divide_by_featuretransformTRUETRUEDivide a scalar by each value in the list.将标量除以列表中的每个值。
75not_equal_scalartransformTRUETRUEDetermines if values in a list are not equal to a given scalar.确定列表中的值是否不等于给定的标量。
76longitudetransformFALSEFALSEReturns the second tuple value in a list of LatLong tuples.返回LatLong元组列表中的第二个元组值。
77negatetransformTRUETRUENegates a numeric value.取反数值。
78cum_mintransformFALSEFALSECalculates the cumulative minimum.计算累计最小值。

 

 

T2.2、深度特征合成:指通过叠加多个基元来得到特征

1)、完整的数据框包含了254-5个新特征,特征工具通过结合与叠加基元特征构造了许多新特征

feature_names: 
 <class 'list'> 254 [<Feature: age>, <Feature: education>, <Feature: income>, <Feature: credit_score>, <Feature: loan_type>, <Feature: LAST(loans.loan_amount)>, <Feature: LAST(loans.loan_id)>, <Feature: LAST(loans.loan_type)>, <Feature: LAST(loans.rate)>, <Feature: LAST(loans.repaid)>, <Feature: MAX(loans.loan_amount)>, <Feature: MAX(loans.rate)>, <Feature: MEAN(loans.loan_amount)>, <Feature: MEAN(loans.rate)>, <Feature: LAST(payments.missed)>, <Feature: LAST(payments.payment_amount)>, <Feature: LAST(payments.payment_id)>, <Feature: MAX(payments.payment_amount)>, <Feature: MEAN(payments.payment_amount)>, <Feature: age / credit_score>, <Feature: age / income>, <Feature: credit_score / age>, <Feature: credit_score / income>, <Feature: income / age>, <Feature: income / credit_score>, <Feature: MONTH(joined)>, <Feature: age - credit_score>, <Feature: age - income>, <Feature: credit_score - income>, <Feature: YEAR(joined)>, <Feature: LAST(loans.MAX(payments.payment_amount))>, <Feature: LAST(loans.MEAN(payments.payment_amount))>, <Feature: LAST(loans.MONTH(loan_end))>, <Feature: LAST(loans.MONTH(loan_start))>, <Feature: LAST(loans.YEAR(loan_end))>, <Feature: LAST(loans.YEAR(loan_start))>, <Feature: LAST(loans.loan_amount - rate)>, <Feature: LAST(loans.loan_amount / rate)>, <Feature: LAST(loans.rate / loan_amount)>, <Feature: MAX(loans.LAST(payments.payment_amount))>, <Feature: MAX(loans.MEAN(payments.payment_amount))>, <Feature: MAX(loans.loan_amount - rate)>, <Feature: MAX(loans.loan_amount / rate)>, <Feature: MAX(loans.rate / loan_amount)>, <Feature: MEAN(loans.LAST(payments.payment_amount))>, <Feature: MEAN(loans.MAX(payments.payment_amount))>, <Feature: MEAN(loans.MEAN(payments.payment_amount))>, <Feature: MEAN(loans.loan_amount - rate)>, <Feature: MEAN(loans.loan_amount / rate)>, <Feature: MEAN(loans.rate / loan_amount)>, <Feature: LAST(payments.loans.client_id)>, <Feature: LAST(payments.loans.loan_amount)>, <Feature: LAST(payments.loans.loan_type)>, <Feature: LAST(payments.loans.rate)>, <Feature: LAST(payments.loans.repaid)>, <Feature: MAX(payments.loans.loan_amount)>, <Feature: MAX(payments.loans.rate)>, <Feature: MEAN(payments.loans.loan_amount)>, <Feature: MEAN(payments.loans.rate)>, <Feature: LAST(loans.loan_amount) / LAST(loans.rate)>, <Feature: LAST(loans.loan_amount) / LAST(payments.payment_amount)>, <Feature: LAST(loans.loan_amount) / MAX(loans.loan_amount)>, <Feature: LAST(loans.loan_amount) / MAX(loans.rate)>, <Feature: LAST(loans.loan_amount) / MAX(payments.payment_amount)>, <Feature: LAST(loans.loan_amount) / MEAN(loans.loan_amount)>, <Feature: LAST(loans.loan_amount) / MEAN(loans.rate)>, <Feature: LAST(loans.loan_amount) / MEAN(payments.payment_amount)>, <Feature: LAST(loans.loan_amount) / age>, <Feature: LAST(loans.loan_amount) / credit_score>, <Feature: LAST(loans.loan_amount) / income>, <Feature: LAST(loans.rate) / LAST(loans.loan_amount)>, <Feature: LAST(loans.rate) / LAST(payments.payment_amount)>, <Feature: LAST(loans.rate) / MAX(loans.loan_amount)>, <Feature: LAST(loans.rate) / MAX(loans.rate)>, <Feature: LAST(loans.rate) / MAX(payments.payment_amount)>, <Feature: LAST(loans.rate) / MEAN(loans.loan_amount)>, <Feature: LAST(loans.rate) / MEAN(loans.rate)>, <Feature: LAST(loans.rate) / MEAN(payments.payment_amount)>, <Feature: LAST(loans.rate) / age>, <Feature: LAST(loans.rate) / credit_score>, <Feature: LAST(loans.rate) / income>, <Feature: LAST(payments.payment_amount) / LAST(loans.loan_amount)>, <Feature: LAST(payments.payment_amount) / LAST(loans.rate)>, <Feature: LAST(payments.payment_amount) / MAX(loans.loan_amount)>, <Feature: LAST(payments.payment_amount) / MAX(loans.rate)>, <Feature: LAST(payments.payment_amount) / MAX(payments.payment_amount)>, <Feature: LAST(payments.payment_amount) / MEAN(loans.loan_amount)>, <Feature: LAST(payments.payment_amount) / MEAN(loans.rate)>, <Feature: LAST(payments.payment_amount) / MEAN(payments.payment_amount)>, <Feature: LAST(payments.payment_amount) / age>, <Feature: LAST(payments.payment_amount) / credit_score>, <Feature: LAST(payments.payment_amount) / income>, <Feature: MAX(loans.loan_amount) / LAST(loans.loan_amount)>, <Feature: MAX(loans.loan_amount) / LAST(loans.rate)>, <Feature: MAX(loans.loan_amount) / LAST(payments.payment_amount)>, <Feature: MAX(loans.loan_amount) / MAX(loans.rate)>, <Feature: MAX(loans.loan_amount) / MAX(payments.payment_amount)>, <Feature: MAX(loans.loan_amount) / MEAN(loans.loan_amount)>, <Feature: MAX(loans.loan_amount) / MEAN(loans.rate)>, <Feature: MAX(loans.loan_amount) / MEAN(payments.payment_amount)>, <Feature: MAX(loans.loan_amount) / age>, <Feature: MAX(loans.loan_amount) / credit_score>, <Feature: MAX(loans.loan_amount) / income>, <Feature: MAX(loans.rate) / LAST(loans.loan_amount)>, <Feature: MAX(loans.rate) / LAST(loans.rate)>, <Feature: MAX(loans.rate) / LAST(payments.payment_amount)>, <Feature: MAX(loans.rate) / MAX(loans.loan_amount)>, <Feature: MAX(loans.rate) / MAX(payments.payment_amount)>, <Feature: MAX(loans.rate) / MEAN(loans.loan_amount)>, <Feature: MAX(loans.rate) / MEAN(loans.rate)>, <Feature: MAX(loans.rate) / MEAN(payments.payment_amount)>, <Feature: MAX(loans.rate) / age>, <Feature: MAX(loans.rate) / credit_score>, <Feature: MAX(loans.rate) / income>, <Feature: MAX(payments.payment_amount) / LAST(loans.loan_amount)>, <Feature: MAX(payments.payment_amount) / LAST(loans.rate)>, <Feature: MAX(payments.payment_amount) / LAST(payments.payment_amount)>, <Feature: MAX(payments.payment_amount) / MAX(loans.loan_amount)>, <Feature: MAX(payments.payment_amount) / MAX(loans.rate)>, <Feature: MAX(payments.payment_amount) / MEAN(loans.loan_amount)>, <Feature: MAX(payments.payment_amount) / MEAN(loans.rate)>, <Feature: MAX(payments.payment_amount) / MEAN(payments.payment_amount)>, <Feature: MAX(payments.payment_amount) / age>, <Feature: MAX(payments.payment_amount) / credit_score>, <Feature: MAX(payments.payment_amount) / income>, <Feature: MEAN(loans.loan_amount) / LAST(loans.loan_amount)>, <Feature: MEAN(loans.loan_amount) / LAST(loans.rate)>, <Feature: MEAN(loans.loan_amount) / LAST(payments.payment_amount)>, <Feature: MEAN(loans.loan_amount) / MAX(loans.loan_amount)>, <Feature: MEAN(loans.loan_amount) / MAX(loans.rate)>, <Feature: MEAN(loans.loan_amount) / MAX(payments.payment_amount)>, <Feature: MEAN(loans.loan_amount) / MEAN(loans.rate)>, <Feature: MEAN(loans.loan_amount) / MEAN(payments.payment_amount)>, <Feature: MEAN(loans.loan_amount) / age>, <Feature: MEAN(loans.loan_amount) / credit_score>, <Feature: MEAN(loans.loan_amount) / income>, <Feature: MEAN(loans.rate) / LAST(loans.loan_amount)>, <Feature: MEAN(loans.rate) / LAST(loans.rate)>, <Feature: MEAN(loans.rate) / LAST(payments.payment_amount)>, <Feature: MEAN(loans.rate) / MAX(loans.loan_amount)>, <Feature: MEAN(loans.rate) / MAX(loans.rate)>, <Feature: MEAN(loans.rate) / MAX(payments.payment_amount)>, <Feature: MEAN(loans.rate) / MEAN(loans.loan_amount)>, <Feature: MEAN(loans.rate) / MEAN(payments.payment_amount)>, <Feature: MEAN(loans.rate) / age>, <Feature: MEAN(loans.rate) / credit_score>, <Feature: MEAN(loans.rate) / income>, <Feature: MEAN(payments.payment_amount) / LAST(loans.loan_amount)>, <Feature: MEAN(payments.payment_amount) / LAST(loans.rate)>, <Feature: MEAN(payments.payment_amount) / LAST(payments.payment_amount)>, <Feature: MEAN(payments.payment_amount) / MAX(loans.loan_amount)>, <Feature: MEAN(payments.payment_amount) / MAX(loans.rate)>, <Feature: MEAN(payments.payment_amount) / MAX(payments.payment_amount)>, <Feature: MEAN(payments.payment_amount) / MEAN(loans.loan_amount)>, <Feature: MEAN(payments.payment_amount) / MEAN(loans.rate)>, <Feature: MEAN(payments.payment_amount) / age>, <Feature: MEAN(payments.payment_amount) / credit_score>, <Feature: MEAN(payments.payment_amount) / income>, <Feature: age / LAST(loans.loan_amount)>, <Feature: age / LAST(loans.rate)>, <Feature: age / LAST(payments.payment_amount)>, <Feature: age / MAX(loans.loan_amount)>, <Feature: age / MAX(loans.rate)>, <Feature: age / MAX(payments.payment_amount)>, <Feature: age / MEAN(loans.loan_amount)>, <Feature: age / MEAN(loans.rate)>, <Feature: age / MEAN(payments.payment_amount)>, <Feature: credit_score / LAST(loans.loan_amount)>, <Feature: credit_score / LAST(loans.rate)>, <Feature: credit_score / LAST(payments.payment_amount)>, <Feature: credit_score / MAX(loans.loan_amount)>, <Feature: credit_score / MAX(loans.rate)>, <Feature: credit_score / MAX(payments.payment_amount)>, <Feature: credit_score / MEAN(loans.loan_amount)>, <Feature: credit_score / MEAN(loans.rate)>, <Feature: credit_score / MEAN(payments.payment_amount)>, <Feature: income / LAST(loans.loan_amount)>, <Feature: income / LAST(loans.rate)>, <Feature: income / LAST(payments.payment_amount)>, <Feature: income / MAX(loans.loan_amount)>, <Feature: income / MAX(loans.rate)>, <Feature: income / MAX(payments.payment_amount)>, <Feature: income / MEAN(loans.loan_amount)>, <Feature: income / MEAN(loans.rate)>, <Feature: income / MEAN(payments.payment_amount)>, <Feature: MONTH(LAST(loans.loan_end))>, <Feature: MONTH(LAST(loans.loan_start))>, <Feature: MONTH(LAST(payments.payment_date))>, <Feature: LAST(loans.loan_amount) - LAST(loans.rate)>, <Feature: LAST(loans.loan_amount) - LAST(payments.payment_amount)>, <Feature: LAST(loans.loan_amount) - MAX(loans.loan_amount)>, <Feature: LAST(loans.loan_amount) - MAX(loans.rate)>, <Feature: LAST(loans.loan_amount) - MAX(payments.payment_amount)>, <Feature: LAST(loans.loan_amount) - MEAN(loans.loan_amount)>, <Feature: LAST(loans.loan_amount) - MEAN(loans.rate)>, <Feature: LAST(loans.loan_amount) - MEAN(payments.payment_amount)>, <Feature: LAST(loans.rate) - LAST(payments.payment_amount)>, <Feature: LAST(loans.rate) - MAX(loans.loan_amount)>, <Feature: LAST(loans.rate) - MAX(loans.rate)>, <Feature: LAST(loans.rate) - MAX(payments.payment_amount)>, <Feature: LAST(loans.rate) - MEAN(loans.loan_amount)>, <Feature: LAST(loans.rate) - MEAN(loans.rate)>, <Feature: LAST(loans.rate) - MEAN(payments.payment_amount)>, <Feature: LAST(payments.payment_amount) - MAX(loans.loan_amount)>, <Feature: LAST(payments.payment_amount) - MAX(loans.rate)>, <Feature: LAST(payments.payment_amount) - MAX(payments.payment_amount)>, <Feature: LAST(payments.payment_amount) - MEAN(loans.loan_amount)>, <Feature: LAST(payments.payment_amount) - MEAN(loans.rate)>, <Feature: LAST(payments.payment_amount) - MEAN(payments.payment_amount)>, <Feature: MAX(loans.loan_amount) - MAX(loans.rate)>, <Feature: MAX(loans.loan_amount) - MAX(payments.payment_amount)>, <Feature: MAX(loans.loan_amount) - MEAN(loans.loan_amount)>, <Feature: MAX(loans.loan_amount) - MEAN(loans.rate)>, <Feature: MAX(loans.loan_amount) - MEAN(payments.payment_amount)>, <Feature: MAX(loans.rate) - MAX(payments.payment_amount)>, <Feature: MAX(loans.rate) - MEAN(loans.loan_amount)>, <Feature: MAX(loans.rate) - MEAN(loans.rate)>, <Feature: MAX(loans.rate) - MEAN(payments.payment_amount)>, <Feature: MAX(payments.payment_amount) - MEAN(loans.loan_amount)>, <Feature: MAX(payments.payment_amount) - MEAN(loans.rate)>, <Feature: MAX(payments.payment_amount) - MEAN(payments.payment_amount)>, <Feature: MEAN(loans.loan_amount) - MEAN(loans.rate)>, <Feature: MEAN(loans.loan_amount) - MEAN(payments.payment_amount)>, <Feature: MEAN(loans.rate) - MEAN(payments.payment_amount)>, <Feature: age - LAST(loans.loan_amount)>, <Feature: age - LAST(loans.rate)>, <Feature: age - LAST(payments.payment_amount)>, <Feature: age - MAX(loans.loan_amount)>, <Feature: age - MAX(loans.rate)>, <Feature: age - MAX(payments.payment_amount)>, <Feature: age - MEAN(loans.loan_amount)>, <Feature: age - MEAN(loans.rate)>, <Feature: age - MEAN(payments.payment_amount)>, <Feature: credit_score - LAST(loans.loan_amount)>, <Feature: credit_score - LAST(loans.rate)>, <Feature: credit_score - LAST(payments.payment_amount)>, <Feature: credit_score - MAX(loans.loan_amount)>, <Feature: credit_score - MAX(loans.rate)>, <Feature: credit_score - MAX(payments.payment_amount)>, <Feature: credit_score - MEAN(loans.loan_amount)>, <Feature: credit_score - MEAN(loans.rate)>, <Feature: credit_score - MEAN(payments.payment_amount)>, <Feature: income - LAST(loans.loan_amount)>, <Feature: income - LAST(loans.rate)>, <Feature: income - LAST(payments.payment_amount)>, <Feature: income - MAX(loans.loan_amount)>, <Feature: income - MAX(loans.rate)>, <Feature: income - MAX(payments.payment_amount)>, <Feature: income - MEAN(loans.loan_amount)>, <Feature: income - MEAN(loans.rate)>, <Feature: income - MEAN(payments.payment_amount)>, <Feature: YEAR(LAST(loans.loan_end))>, <Feature: YEAR(LAST(loans.loan_start))>, <Feature: YEAR(LAST(payments.payment_date))>]

features: <class 'pandas.core.frame.DataFrame'> 
            age       education  income  credit_score loan_type
client_id                                                     
33747       44    MasterDegree  138377           683     other
31578       38    DoctorDegree  104028           805     other
27894       47  BachelorDegree  176516           708    credit
44966       31  BachelorDegree   58530           822    credit
29195       46  BachelorDegree   38528           680     other
Show a feature with a depth of 1 
            MEAN(loans.loan_amount)
client_id                         
33747                         7855
31578                         7953
27894                        13457
44966                         7733
29195                         2466
25942                        14059
38435                         6615
41646                        14884
31484                         8458
49966                        14108
Show a feature with a depth of 2 
            LAST(loans.MEAN(payments.payment_amount))
client_id                                           
33747                                    1314.000000
31578                                    1180.714286
27894                                    2118.428571
44966                                    1079.666667
29195                                     368.500000
25942                                    1920.000000
38435                                     960.111111
41646                                    2239.500000
31484                                    1232.750000
49966                                    1671.000000
client_idageeducationincomecredit_scoreloan_typeLAST(loans.loan_amount)LAST(loans.loan_id)LAST(loans.loan_type)LAST(loans.rate)LAST(loans.repaid)MAX(loans.loan_amount)MAX(loans.rate)MEAN(loans.loan_amount)MEAN(loans.rate)LAST(payments.missed)LAST(payments.payment_amount)LAST(payments.payment_id)MAX(payments.payment_amount)MEAN(payments.payment_amount)age / credit_scoreage / incomecredit_score / agecredit_score / incomeincome / ageincome / credit_scoreMONTH(joined)age - credit_scoreage - incomecredit_score - incomeYEAR(joined)LAST(loans.MAX(payments.payment_amount))LAST(loans.MEAN(payments.payment_amount))LAST(loans.MONTH(loan_end))LAST(loans.MONTH(loan_start))LAST(loans.YEAR(loan_end))LAST(loans.YEAR(loan_start))LAST(loans.loan_amount - rate)LAST(loans.loan_amount / rate)LAST(loans.rate / loan_amount)MAX(loans.LAST(payments.payment_amount))MAX(loans.MEAN(payments.payment_amount))MAX(loans.loan_amount - rate)MAX(loans.loan_amount / rate)MAX(loans.rate / loan_amount)MEAN(loans.LAST(payments.payment_amount))MEAN(loans.MAX(payments.payment_amount))MEAN(loans.MEAN(payments.payment_amount))MEAN(loans.loan_amount - rate)MEAN(loans.loan_amount / rate)MEAN(loans.rate / loan_amount)LAST(payments.loans.client_id)LAST(payments.loans.loan_amount)LAST(payments.loans.loan_type)LAST(payments.loans.rate)LAST(payments.loans.repaid)MAX(payments.loans.loan_amount)MAX(payments.loans.rate)MEAN(payments.loans.loan_amount)MEAN(payments.loans.rate)LAST(loans.loan_amount) / LAST(loans.rate)LAST(loans.loan_amount) / LAST(payments.payment_amount)LAST(loans.loan_amount) / MAX(loans.loan_amount)LAST(loans.loan_amount) / MAX(loans.rate)LAST(loans.loan_amount) / MAX(payments.payment_amount)LAST(loans.loan_amount) / MEAN(loans.loan_amount)LAST(loans.loan_amount) / MEAN(loans.rate)LAST(loans.loan_amount) / MEAN(payments.payment_amount)LAST(loans.loan_amount) / ageLAST(loans.loan_amount) / credit_scoreLAST(loans.loan_amount) / incomeLAST(loans.rate) / LAST(loans.loan_amount)LAST(loans.rate) / LAST(payments.payment_amount)LAST(loans.rate) / MAX(loans.loan_amount)LAST(loans.rate) / MAX(loans.rate)LAST(loans.rate) / MAX(payments.payment_amount)LAST(loans.rate) / MEAN(loans.loan_amount)LAST(loans.rate) / MEAN(loans.rate)LAST(loans.rate) / MEAN(payments.payment_amount)LAST(loans.rate) / ageLAST(loans.rate) / credit_scoreLAST(loans.rate) / incomeLAST(payments.payment_amount) / LAST(loans.loan_amount)LAST(payments.payment_amount) / LAST(loans.rate)LAST(payments.payment_amount) / MAX(loans.loan_amount)LAST(payments.payment_amount) / MAX(loans.rate)LAST(payments.payment_amount) / MAX(payments.payment_amount)LAST(payments.payment_amount) / MEAN(loans.loan_amount)LAST(payments.payment_amount) / MEAN(loans.rate)LAST(payments.payment_amount) / MEAN(payments.payment_amount)LAST(payments.payment_amount) / ageLAST(payments.payment_amount) / credit_scoreLAST(payments.payment_amount) / incomeMAX(loans.loan_amount) / LAST(loans.loan_amount)MAX(loans.loan_amount) / LAST(loans.rate)MAX(loans.loan_amount) / LAST(payments.payment_amount)MAX(loans.loan_amount) / MAX(loans.rate)MAX(loans.loan_amount) / MAX(payments.payment_amount)MAX(loans.loan_amount) / MEAN(loans.loan_amount)MAX(loans.loan_amount) / MEAN(loans.rate)MAX(loans.loan_amount) / MEAN(payments.payment_amount)MAX(loans.loan_amount) / ageMAX(loans.loan_amount) / credit_scoreMAX(loans.loan_amount) / incomeMAX(loans.rate) / LAST(loans.loan_amount)MAX(loans.rate) / LAST(loans.rate)MAX(loans.rate) / LAST(payments.payment_amount)MAX(loans.rate) / MAX(loans.loan_amount)MAX(loans.rate) / MAX(payments.payment_amount)MAX(loans.rate) / MEAN(loans.loan_amount)MAX(loans.rate) / MEAN(loans.rate)MAX(loans.rate) / MEAN(payments.payment_amount)MAX(loans.rate) / ageMAX(loans.rate) / credit_scoreMAX(loans.rate) / incomeMAX(payments.payment_amount) / LAST(loans.loan_amount)MAX(payments.payment_amount) / LAST(loans.rate)MAX(payments.payment_amount) / LAST(payments.payment_amount)MAX(payments.payment_amount) / MAX(loans.loan_amount)MAX(payments.payment_amount) / MAX(loans.rate)MAX(payments.payment_amount) / MEAN(loans.loan_amount)MAX(payments.payment_amount) / MEAN(loans.rate)MAX(payments.payment_amount) / MEAN(payments.payment_amount)MAX(payments.payment_amount) / ageMAX(payments.payment_amount) / credit_scoreMAX(payments.payment_amount) / incomeMEAN(loans.loan_amount) / LAST(loans.loan_amount)MEAN(loans.loan_amount) / LAST(loans.rate)MEAN(loans.loan_amount) / LAST(payments.payment_amount)MEAN(loans.loan_amount) / MAX(loans.loan_amount)MEAN(loans.loan_amount) / MAX(loans.rate)MEAN(loans.loan_amount) / MAX(payments.payment_amount)MEAN(loans.loan_amount) / MEAN(loans.rate)MEAN(loans.loan_amount) / MEAN(payments.payment_amount)MEAN(loans.loan_amount) / ageMEAN(loans.loan_amount) / credit_scoreMEAN(loans.loan_amount) / incomeMEAN(loans.rate) / LAST(loans.loan_amount)MEAN(loans.rate) / LAST(loans.rate)MEAN(loans.rate) / LAST(payments.payment_amount)MEAN(loans.rate) / MAX(loans.loan_amount)MEAN(loans.rate) / MAX(loans.rate)MEAN(loans.rate) / MAX(payments.payment_amount)MEAN(loans.rate) / MEAN(loans.loan_amount)MEAN(loans.rate) / MEAN(payments.payment_amount)MEAN(loans.rate) / ageMEAN(loans.rate) / credit_scoreMEAN(loans.rate) / incomeMEAN(payments.payment_amount) / LAST(loans.loan_amount)MEAN(payments.payment_amount) / LAST(loans.rate)MEAN(payments.payment_amount) / LAST(payments.payment_amount)MEAN(payments.payment_amount) / MAX(loans.loan_amount)MEAN(payments.payment_amount) / MAX(loans.rate)MEAN(payments.payment_amount) / MAX(payments.payment_amount)MEAN(payments.payment_amount) / MEAN(loans.loan_amount)MEAN(payments.payment_amount) / MEAN(loans.rate)MEAN(payments.payment_amount) / ageMEAN(payments.payment_amount) / credit_scoreMEAN(payments.payment_amount) / incomeage / LAST(loans.loan_amount)age / LAST(loans.rate)age / LAST(payments.payment_amount)age / MAX(loans.loan_amount)age / MAX(loans.rate)age / MAX(payments.payment_amount)age / MEAN(loans.loan_amount)age / MEAN(loans.rate)age / MEAN(payments.payment_amount)credit_score / LAST(loans.loan_amount)credit_score / LAST(loans.rate)credit_score / LAST(payments.payment_amount)credit_score / MAX(loans.loan_amount)credit_score / MAX(loans.rate)credit_score / MAX(payments.payment_amount)credit_score / MEAN(loans.loan_amount)credit_score / MEAN(loans.rate)credit_score / MEAN(payments.payment_amount)income / LAST(loans.loan_amount)income / LAST(loans.rate)income / LAST(payments.payment_amount)income / MAX(loans.loan_amount)income / MAX(loans.rate)income / MAX(payments.payment_amount)income / MEAN(loans.loan_amount)income / MEAN(loans.rate)income / MEAN(payments.payment_amount)MONTH(LAST(loans.loan_end))MONTH(LAST(loans.loan_start))MONTH(LAST(payments.payment_date))LAST(loans.loan_amount) - LAST(loans.rate)LAST(loans.loan_amount) - LAST(payments.payment_amount)LAST(loans.loan_amount) - MAX(loans.loan_amount)LAST(loans.loan_amount) - MAX(loans.rate)LAST(loans.loan_amount) - MAX(payments.payment_amount)LAST(loans.loan_amount) - MEAN(loans.loan_amount)LAST(loans.loan_amount) - MEAN(loans.rate)LAST(loans.loan_amount) - MEAN(payments.payment_amount)LAST(loans.rate) - LAST(payments.payment_amount)LAST(loans.rate) - MAX(loans.loan_amount)LAST(loans.rate) - MAX(loans.rate)LAST(loans.rate) - MAX(payments.payment_amount)LAST(loans.rate) - MEAN(loans.loan_amount)LAST(loans.rate) - MEAN(loans.rate)LAST(loans.rate) - MEAN(payments.payment_amount)LAST(payments.payment_amount) - MAX(loans.loan_amount)LAST(payments.payment_amount) - MAX(loans.rate)LAST(payments.payment_amount) - MAX(payments.payment_amount)LAST(payments.payment_amount) - MEAN(loans.loan_amount)LAST(payments.payment_amount) - MEAN(loans.rate)LAST(payments.payment_amount) - MEAN(payments.payment_amount)MAX(loans.loan_amount) - MAX(loans.rate)MAX(loans.loan_amount) - MAX(payments.payment_amount)MAX(loans.loan_amount) - MEAN(loans.loan_amount)MAX(loans.loan_amount) - MEAN(loans.rate)MAX(loans.loan_amount) - MEAN(payments.payment_amount)MAX(loans.rate) - MAX(payments.payment_amount)MAX(loans.rate) - MEAN(loans.loan_amount)MAX(loans.rate) - MEAN(loans.rate)MAX(loans.rate) - MEAN(payments.payment_amount)MAX(payments.payment_amount) - MEAN(loans.loan_amount)MAX(payments.payment_amount) - MEAN(loans.rate)MAX(payments.payment_amount) - MEAN(payments.payment_amount)MEAN(loans.loan_amount) - MEAN(loans.rate)MEAN(loans.loan_amount) - MEAN(payments.payment_amount)MEAN(loans.rate) - MEAN(payments.payment_amount)age - LAST(loans.loan_amount)age - LAST(loans.rate)age - LAST(payments.payment_amount)age - MAX(loans.loan_amount)age - MAX(loans.rate)age - MAX(payments.payment_amount)age - MEAN(loans.loan_amount)age - MEAN(loans.rate)age - MEAN(payments.payment_amount)credit_score - LAST(loans.loan_amount)credit_score - LAST(loans.rate)credit_score - LAST(payments.payment_amount)credit_score - MAX(loans.loan_amount)credit_score - MAX(loans.rate)credit_score - MAX(payments.payment_amount)credit_score - MEAN(loans.loan_amount)credit_score - MEAN(loans.rate)credit_score - MEAN(payments.payment_amount)income - LAST(loans.loan_amount)income - LAST(loans.rate)income - LAST(payments.payment_amount)income - MAX(loans.loan_amount)income - MAX(loans.rate)income - MAX(payments.payment_amount)income - MEAN(loans.loan_amount)income - MEAN(loans.rate)income - MEAN(payments.payment_amount)YEAR(LAST(loans.loan_end))YEAR(LAST(loans.loan_start))YEAR(LAST(payments.payment_date))
3374744MasterDegree138377683other785511031other4.89178554.8978554.8911372129137213140.0644216690.00031797215.522727270.0049357913144.931818202.6017573-639-138333-13769420191372131439202220207850.111606.3394680.000622533137213147850.111606.3394680.0006225331372137213147850.111606.3394680.000622533337477855other4.89178554.8978554.891606.3394685.72521865911606.3394685.72521865911606.3394685.977929985178.522727311.500732060.0567652140.0006225330.003564140.00062253310.003564140.00062253310.0037214610.1111363640.007159593.53E-050.174665818280.57259710.174665818280.572597110.174665818280.57259711.0441400331.181818182.0087847730.00991494311606.3394685.7252186591606.3394685.72521865911606.3394685.977929985178.522727311.500732060.0567652140.00062253310.003564140.0006225330.003564140.00062253310.0037214610.1111363640.007159593.53E-050.174665818280.572597110.174665818280.57259710.174665818280.57259711.0441400331.181818182.0087847730.00991494311606.3394685.72521865911606.3394685.7252186591606.3394685.977929985178.522727311.500732060.0567652140.00062253310.003564140.00062253310.003564140.0006225330.0037214610.1111363640.007159593.53E-050.167281986268.71165640.9577259480.167281986268.71165640.9577259480.167281986268.711656429.863636361.92386530.0094957980.0056015288.997955010.0320699710.0056015288.997955010.0320699710.0056015288.997955010.033485540.086950987139.67280160.4978134110.086950987139.67280160.4978134110.086950987139.67280160.5197869117.6164226628297.95501100.857871717.6164226628297.95501100.857871717.6164226628297.95501105.309741239127850.11648307850.11648307850.116541-1367.11-7850.110-1367.11-7850.110-1309.11-64831367.110-64831367.11587850.11648307850.116541-1367.11-7850.110-1309.11-64831367.11587850.116541-1309.11-781139.11-1328-781139.11-1328-781139.11-1270-7172678.11-689-7172678.11-689-7172678.11-631130522138372.11137005130522138372.11137005130522138372.11137063202220202020
3157838DoctorDegree104028805other795311439other0.13179530.1379530.131155714315571180.7142860.0472049690.00036528621.184210530.0077383012737.578947129.22732924-767-103990-103223201915571180.71428616202320207952.8761176.923081.63E-0515571180.7142867952.8761176.923081.63E-05155715571180.7142867952.8761176.923081.63E-05315787953other0.13179530.1379530.1361176.923085.107899807161176.923085.107899807161176.923086.735753176209.28947379.8795031060.0764505711.63E-058.35E-051.63E-0518.35E-051.63E-0510.0001101030.0034210530.0001614911.25E-060.19577517911976.923080.19577517911976.9230810.19577517911976.923081.31869328540.973684211.9341614910.014967124161176.923085.10789980761176.923085.107899807161176.923086.735753176209.28947379.8795031060.0764505711.63E-0518.35E-051.63E-058.35E-051.63E-0510.0001101030.0034210530.0001614911.25E-060.19577517911976.9230810.19577517911976.923080.19577517911976.923081.31869328540.973684211.9341614910.014967124161176.923085.107899807161176.923085.10789980761176.923086.735753176209.28947379.8795031060.0764505711.63E-0518.35E-051.63E-0518.35E-051.63E-050.0001101030.0034210530.0001614911.25E-060.1484614979082.4175820.7583264520.1484614979082.4175820.7583264520.1484614979082.41758231.071428571.4667258210.0113499660.004778071292.30769230.0244059090.004778071292.30769230.0244059090.004778071292.30769230.0321839080.1012196666192.3076920.517019910.1012196666192.3076920.517019910.1012196666192.3076920.68179068413.08034704800215.384666.8131021213.08034704800215.384666.8131021213.08034704800215.384688.1059891116127952.87639607952.87639607952.876772.285714-1556.87-7952.870-1556.87-7952.870-1180.584286-63961556.870-63961556.87376.28571437952.87639607952.876772.285714-1556.87-7952.870-1180.584286-63961556.87376.28571437952.876772.285714-1180.584286-791537.87-1519-791537.87-1519-791537.87-1142.714286-7148804.87-752-7148804.87-752-7148804.87-375.714285796075104027.8710247196075104027.8710247196075104027.87102847.2857202320202020
2789447BachelorDegree176516708credit1345711225credit1.481134571.48134571.48025054225052118.4285710.0663841810.00026626515.063829790.0040109683755.659574249.31638424-661-176469-175808201925052118.4285711042022202013455.529092.5675680.0001099825052118.42857113455.529092.5675680.00010998250525052118.42857113455.529092.5675680.000109982789413457credit1.481134571.48134571.489092.5675685.37205588819092.5675685.37205588819092.5675686.352350125286.319148919.007062150.0762367150.000109980.0005908180.0001099810.0005908180.0001099810.0006986310.0314893620.0020903958.38E-060.1861484731692.5675680.1861484731692.56756810.1861484731692.5675681.18248027553.297872343.5381355930.01419134819092.5675685.3720558889092.5675685.37205588819092.5675686.352350125286.319148919.007062150.0762367150.0001099810.0005908180.000109980.0005908180.0001099810.0006986310.0314893620.0020903958.38E-060.1861484731692.56756810.1861484731692.5675680.1861484731692.5675681.18248027553.297872343.5381355930.01419134819092.5675685.37205588819092.5675685.3720558889092.5675686.352350125286.319148919.007062150.0762367150.0001099810.0005908180.0001099810.0005908180.000109980.0006986310.0314893620.0020903958.38E-060.1574220531431.3706560.8456800680.1574220531431.3706560.8456800680.1574220531431.37065645.072948332.9921307510.012001340.00349260631.756756760.0187624750.00349260631.756756760.0187624750.00349260631.756756760.0221862570.052612023478.37837840.2826347310.052612023478.37837840.2826347310.052612023478.37837840.33420999413.11703946119267.567670.4654690613.11703946119267.567670.4654690613.11703946119267.567683.324027241041213455.5210952013455.5210952013455.5211338.57143-2503.52-13455.520-2503.52-13455.520-2116.948571-109522503.520-109522503.52386.571428613455.5210952013455.5211338.57143-2503.52-13455.520-2116.948571-109522503.52386.571428613455.5211338.57143-2116.948571-1341045.52-2458-1341045.52-2458-1341045.52-2071.428571-12749706.52-1797-12749706.52-1797-12749706.52-1410.428571163059176514.52174011163059176514.52174011163059176514.52174397.5714202220202020
4496631BachelorDegree58530822credit773311246credit0.42077330.4277330.4201245212451079.6666670.0377128950.00052964326.516129030.014044081888.06451671.204379565-791-58499-57708201912451079.66666729202320207732.5818411.904765.43E-0512451079.6666677732.5818411.904765.43E-05124512451079.6666677732.5818411.904765.43E-05449667733credit0.42077330.4277330.4218411.904766.21124498118411.904766.21124498118411.904767.162395801249.45161299.4075425790.132120285.43E-050.0003373495.43E-0510.0003373495.43E-0510.0003890090.0135483870.0005109497.18E-060.1609983192964.2857140.1609983192964.28571410.1609983192964.2857141.15313368340.161290321.514598540.021271143118411.904766.2112449818411.904766.21124498118411.904767.162395801249.45161299.4075425790.132120285.43E-0510.0003373495.43E-050.0003373495.43E-0510.0003890090.0135483870.0005109497.18E-060.1609983192964.28571410.1609983192964.2857140.1609983192964.2857141.15313368340.161290321.514598540.021271143118411.904766.21124498118411.904766.2112449818411.904767.162395801249.45161299.4075425790.132120285.43E-0510.0003373495.43E-0510.0003373495.43E-050.0003890090.0135483870.0005109497.18E-060.1396180872570.6349210.8672021420.1396180872570.6349210.8672021420.1396180872570.63492134.827956991.3134630980.0184463810.00400879373.809523810.0248995980.00400879373.809523810.0248995980.00400879373.809523810.0287125660.1062976851957.1428570.6602409640.1062976851957.1428570.6602409640.1062976851957.1428570.7613460947.568860727139357.142947.012048197.568860727139357.142947.012048197.568860727139357.142954.2111762929127732.58648807732.58648807732.586653.333333-1244.58-7732.580-1244.58-7732.580-1079.246667-64881244.580-64881244.58165.33333337732.58648807732.586653.333333-1244.58-7732.580-1079.246667-64881244.58165.33333337732.586653.333333-1079.246667-770230.58-1214-770230.58-1214-770230.58-1048.666667-6911821.58-423-6911821.58-423-6911821.58-257.66666675079758529.58572855079758529.58572855079758529.5857450.33333202320202020
2919546BachelorDegree38528680other246611992other0.68124660.6824660.68043173431368.50.0676470590.00119393714.78260870.017649502837.565217456.658823535-634-38482-378482019431368.543202120192465.323626.4705880.00027575431368.52465.323626.4705880.00027575431431368.52465.323626.4705880.00027575291952466other0.68124660.6824660.683626.4705885.72157772613626.4705885.72157772613626.4705886.69199457353.608695653.6264705880.0640053990.000275750.0015777260.0002757510.0015777260.0002757510.0018453190.0147826090.0011.76E-050.174776967633.82352940.174776967633.823529410.174776967633.82352941.1696065139.3695652170.6338235290.01118666913626.4705885.7215777263626.4705885.72157772613626.4705886.69199457353.608695653.6264705880.0640053990.0002757510.0015777260.000275750.0015777260.0002757510.0018453190.0147826090.0011.76E-050.174776967633.823529410.174776967633.82352940.174776967633.82352941.1696065139.3695652170.6338235290.01118666913626.4705885.72157772613626.4705885.7215777263626.4705886.69199457353.608695653.6264705880.0640053990.0002757510.0015777260.0002757510.0015777260.000275750.0018453190.0147826090.0011.76E-050.149432279541.91176470.8549883990.149432279541.91176470.8549883990.149432279541.91176478.0108695650.5419117650.0095644730.0186536967.647058820.1067285380.0186536967.647058820.1067285380.0186536967.647058820.1248303930.27575020310001.5777262180.27575020310001.5777262180.27575020310001.8453188615.6236820856658.8235389.3921113715.6236820856658.8235389.3921113715.6236820856658.82353104.553595743102465.32203502465.32203502465.322097.5-430.32-2465.320-430.32-2465.320-367.82-2035430.320-2035430.3262.52465.32203502465.322097.5-430.32-2465.320-367.82-2035430.3262.52465.322097.5-367.82-242045.32-385-242045.32-385-242045.32-322.5-1786679.32249-1786679.32249-1786679.32311.53606238527.32380973606238527.32380973606238527.3238159.5202120192019
2594218DoctorDegree227219839cash1405911871cash3.580140593.58140593.581179135240319200.0214541127.92E-0546.611111110.00369247312623.27778270.82121576-821-227201-226380201924031920342021201914055.423927.0949720.0002546411791192014055.423927.0949720.00025464117912403192014055.423927.0949720.0002546412594214059cash3.580140593.58140593.583927.0949727.84980457813927.0949725.85060341213927.0949727.322395833781.055555616.75685340.0618742270.0002546410.0019988830.00025464110.0014898040.00025464110.0018645830.1988888890.0042669851.58E-050.127391706500.27932960.127391706500.27932960.7453183520.127391706500.27932960.932812599.52.1346841480.00788226313927.0949727.8498045783927.0949725.85060341213927.0949727.322395833781.055555616.75685340.0618742270.00025464110.0019988830.0002546410.0014898040.00025464110.0018645830.1988888890.0042669851.58E-050.170922541671.22905031.3417085430.170922541671.22905030.170922541671.22905031.2515625133.52.8641239570.010575713927.0949727.84980457813927.0949725.8506034123927.0949727.322395833781.055555616.75685340.0618742270.00025464110.0019988830.00025464110.0014898040.0002546410.0018645830.1988888890.0042669851.58E-050.136567323536.31284921.0720268010.136567323536.31284920.7990012480.136567323536.3128492106.66666672.2884386170.0084499980.0012803195.0279329610.0100502510.0012803195.0279329610.0074906370.0012803195.0279329610.0093750.059677075234.35754190.4684533780.059677075234.35754190.34914690.059677075234.35754190.43697916716.1618180563468.99441126.867113316.1618180563468.9944194.5563878516.1618180563468.99441118.3432292341214055.4212268014055.4211656014055.4212139-1787.42-14055.420-2399.42-14055.420-1916.42-122681787.42-612-122681787.42-12914055.4211656014055.4212139-2399.42-14055.420-1916.42-116562399.4248314055.4212139-1916.42-1404114.42-1773-1404114.42-2385-1404114.42-1902-13220835.42-952-13220835.42-1564-13220835.42-1081213160227215.42225428213160227215.42224816213160227215.42225299202120192019
3843543DoctorDegree183813596home661510339home5.65066155.6566155.6511086211177960.11111110.0721476510.00023393313.860465120.0032424264274.72093308.41107386-553-183770-18321720191177960.1111111125202020196609.351170.796460.0008541191086960.11111116609.351170.796460.00085411910861177960.11111116609.351170.796460.000854119384356615home5.65066155.6566155.651170.796466.09116022111170.796465.62022090111170.796466.889827566153.837209311.098993290.0359876610.0008541190.0052025780.00085411910.004800340.00085411910.0058847360.1313953490.0094798663.07E-050.164172336192.21238940.164172336192.21238940.9226847920.164172336192.21238941.13111908325.255813951.8221476510.00590817811170.796466.0911602211170.796465.62022090111170.796466.889827566153.837209311.098993290.0359876610.00085411910.0052025780.0008541190.004800340.00085411910.0058847360.1313953490.0094798663.07E-050.177928949208.31858411.0837937380.177928949208.31858410.177928949208.31858411.2258997827.372093021.9748322150.00640324711170.796466.09116022111170.796465.6202209011170.796466.889827566153.837209311.098993290.0359876610.00085411910.0052025780.00085411910.004800340.0008541190.0058847360.1313953490.0094798663.07E-050.145141513169.93117010.8840802130.145141513169.93117010.8157273670.145141513169.931170122.328165371.6109246830.0052233040.0065003787.6106194690.0395948430.0065003787.6106194690.036533560.0065003787.6106194690.0447864830.090098262105.48672570.5488029470.090098262105.48672570.5063721330.090098262105.48672570.62076148627.7873015932533.27434169.256906127.7873015932533.27434156.170773227.7873015932533.27434191.449716512536609.35552906609.35543806609.355654.888889-1080.35-6609.350-1171.35-6609.350-954.4611111-55291080.35-91-55291080.35125.88888896609.35543806609.355654.888889-1171.35-6609.350-954.4611111-54381171.35216.88888896609.355654.888889-954.4611111-657237.35-1043-657237.35-1134-657237.35-917.1111111-6019590.35-490-6019590.35-581-6019590.35-364.1111111177198183807.35182727177198183807.35182636177198183807.35182852.8889202020192020
4164627AssociateDegree47995514cash1488410334cash0.040148840.04148840.040197817425012239.50.0525291830.00056255919.037037040.0107094491777.59259393.375486387-487-47968-47481201925012239.510102022202014883.963721002.69E-0619782239.514883.963721002.69E-06197825012239.514883.963721002.69E-064164614884cash0.040148840.04148840.043721007.52477249713721005.95121951213721006.646126367551.259259328.957198440.3101156372.69E-062.02E-052.69E-0611.60E-052.69E-0611.79E-050.0014814817.78E-058.33E-070.132894383494500.132894383494500.7908836470.132894383494500.88323286473.259259263.8482490270.04121262613721007.5247724973721005.95121951213721006.646126367551.259259328.957198440.3101156372.69E-0612.02E-052.69E-061.60E-052.69E-0611.79E-050.0014814817.78E-058.33E-070.168032787625251.2644084930.168032787625250.168032787625251.11676713692.629629634.8657587550.05210959513721007.52477249713721005.9512195123721006.646126367551.259259328.957198440.3101156372.69E-0612.02E-052.69E-0611.60E-052.69E-061.79E-050.0014814817.78E-058.33E-070.15046358555987.51.1322042470.15046358555987.50.8954418230.15046358555987.582.944444444.3570038910.0466611110.0018140286750.0136501520.0018140286750.0107956820.0018140286750.0120562630.034533727128500.2598584430.034533727128500.2055177930.034533727128500.2295155173.224603601119987524.264408493.224603601119987519.190323873.224603601119987521.4311230210101214883.9612906014883.9612383014883.9612644.5-1977.96-14883.960-2500.96-14883.960-2239.46-129061977.96-523-129061977.96-261.514883.9612383014883.9612644.5-2500.96-14883.960-2239.46-123832500.96261.514883.9612644.5-2239.46-1485726.96-1951-1485726.96-2474-1485726.96-2212.5-14370513.96-1464-14370513.96-1987-14370513.96-1725.53311147994.96460173311147994.96454943311147994.9645755.5202220202020
3148425AssociateDegree151928547cash845810288cash4.04084584.0484584.04014296114911232.750.0457038390.00016455221.880.003600396077.12277.74771487-522-151903-151381201914911232.7576202120198453.962093.5643560.00047765414291232.758453.962093.5643560.000477654142914911232.758453.962093.5643560.000477654314848458cash4.04084584.0484584.042093.5643565.91882435312093.5643565.67270288412093.5643566.861082945338.3215.462522850.0556711070.0004776540.0028271520.00047765410.0027095910.00047765410.0032772260.16160.007385742.66E-050.168952471353.71287130.168952471353.71287130.958417170.168952471353.71287131.15919691757.162.6124314440.00940577112093.5643565.9188243532093.5643565.67270288412093.5643566.861082945338.3215.462522850.0556711070.00047765410.0028271520.0004776540.0027095910.00047765410.0032772260.16160.007385742.66E-050.176282809369.05940591.0433869840.176282809369.05940590.176282809369.05940591.20949097559.642.7257769650.00981385912093.5643565.91882435312093.5643565.6727028842093.5643566.861082945338.3215.462522850.0556711070.00047765410.0028271520.00047765410.0027095910.0004776540.0032772260.16160.007385742.66E-050.145749586305.13613860.86266620.145749586305.13613860.8267940980.145749586305.136138649.312.2536563070.0081140410.0029557826.1881188120.0174947520.0029557826.1881188120.016767270.0029557826.1881188120.0202798620.064672499135.39603960.3827851640.064672499135.39603960.3668678740.064672499135.39603960.44372338317.9626389237605.94059106.317704717.9626389237605.94059101.896713617.9626389237605.94059123.24315557658453.96702908453.96696708453.967225.25-1424.96-8453.960-1486.96-8453.960-1228.71-70291424.96-62-70291424.96196.258453.96696708453.967225.25-1486.96-8453.960-1228.71-69671486.96258.258453.967225.25-1228.71-843320.96-1404-843320.96-1466-843320.96-1207.75-7911542.96-882-7911542.96-944-7911542.96-685.75143470151923.96150499143470151923.96150437143470151923.96150695.25202120192020
4996632AssociateDegree164888629other1410810299other4.691141084.69141084.6911671119167116710.0508744040.00019407119.656250.0038147115152.75262.143084310-597-164856-1642592019167116711292022202014103.313008.1023450.0003324351671167114103.313008.1023450.00033243516711671167114103.313008.1023450.0003324354996614108other4.691141084.69141084.693008.1023458.44284859413008.1023458.44284859413008.1023458.442848594440.87522.429252780.0855611080.0003324350.0028067030.00033243510.0028067030.00033243510.0028067030.14656250.007456282.84E-050.118443436356.28997870.118443436356.289978710.118443436356.2899787152.218752.6565977740.01013415213008.1023458.4428485943008.1023458.44284859413008.1023458.442848594440.87522.429252780.0855611080.00033243510.0028067030.0003324350.0028067030.00033243510.0028067030.14656250.007456282.84E-050.118443436356.289978710.118443436356.28997870.118443436356.2899787152.218752.6565977740.01013415213008.1023458.44284859413008.1023458.4428485943008.1023458.442848594440.87522.429252780.0855611080.00033243510.0028067030.00033243510.0028067030.0003324350.0028067030.14656250.007456282.84E-050.118443436356.289978710.118443436356.289978710.118443436356.289978752.218752.6565977740.0101341520.0022682176.8230277190.0191502090.0022682176.8230277190.0191502090.0022682176.8230277190.0191502090.044584633134.11513860.3764213050.044584633134.11513860.3764213050.044584633134.11513860.37642130511.6875531635157.3560898.6762417711.6875531635157.3560898.6762417711.6875531635157.3560898.676241771291214103.3112437014103.3112437014103.3112437-1666.31-14103.310-1666.31-14103.310-1666.31-124371666.310-124371666.31014103.3112437014103.3112437-1666.31-14103.310-1666.31-124371666.31014103.3112437-1666.31-1407627.31-1639-1407627.31-1639-1407627.31-1639-13479624.31-1042-13479624.31-1042-13479624.31-1042150780164883.31163217150780164883.31163217150780164883.31163217202220202020
3461040BachelorDegree53512771credit449711322credit2.3144972.344972.3150397679601.66666670.0518806740.00074749619.2750.0144079831337.869.4059662810-731-53472-527412019679601.666666718202220204494.71955.2173910.000511452503601.66666674494.71955.2173910.000511452503679601.66666674494.71955.2173910.000511452346104497credit2.3144972.344972.31955.2173918.94035785311955.2173916.62297496311955.2173917.474238227112.4255.8326848250.0840372250.0005114520.0045725650.00051145210.0033873340.00051145210.0038227150.05750.0029831394.30E-050.111852346218.69565220.111852346218.69565220.7407952870.111852346218.69565220.8360110812.5750.6523994810.00939976111955.2173918.9403578531955.2173916.62297496311955.2173917.474238227112.4255.8326848250.0840372250.00051145210.0045725650.0005114520.0033873340.00051145210.0038227150.05750.0029831394.30E-050.150989549295.21739131.3499005960.150989549295.21739130.150989549295.21739131.12853185616.9750.8806744490.01268874311955.2173918.94035785311955.2173916.6229749631955.2173917.474238227112.4255.8326848250.0840372250.00051145210.0045725650.00051145210.0033873340.0005114520.0038227150.05750.0029831394.30E-050.133792899261.59420291.1961563950.133792899261.59420290.886107020.133792899261.594202915.041666670.7803718120.0112435840.00889481917.391304350.0795228630.00889481917.391304350.0589101620.00889481917.391304350.0664819940.171447632335.21739131.5328031810.171447632335.21739131.1354933730.171447632335.21739131.28144044311.8994885523266.08696106.385685911.8994885523266.0869678.8100147311.8994885523266.0869688.9396121918124494.7399404494.7381804494.73895.333333-500.7-4494.70-676.7-4494.70-599.3666667-3994500.7-176-3994500.7-98.666666674494.7381804494.73895.333333-676.7-4494.70-599.3666667-3818676.777.333333334494.73895.333333-599.3666667-445737.7-463-445737.7-639-445737.7-561.6666667-3726768.7268-3726768.792-3726768.7169.33333334901553509.7530094901553509.7528334901553509.752910.33333202220202020
4913431MasterDegree74686708home210110293home0.95121010.9521010.951396114398315.50.0437853110.00041507122.838709680.0094796882409.225806105.488700611-677-74655-739782019398315.567202220202100.052211.5789470.000452166396315.52100.052211.5789470.000452166396398315.52100.052211.5789470.000452166491342101home0.95121010.9521010.952211.5789475.30555555612211.5789475.27889447212211.5789476.65927099867.774193552.9675141240.0281311090.0004521660.002398990.00045216610.0023869350.00045216610.0030110940.0306451610.0013418081.27E-050.188481675416.84210530.188481675416.84210530.9949748740.188481675416.84210531.25515055512.774193550.5593220340.00530219912211.5789475.3055555562211.5789475.27889447212211.5789476.65927099867.774193552.9675141240.0281311090.00045216610.002398990.0004521660.0023869350.00045216610.0030110940.0306451610.0013418081.27E-050.189433603418.94736841.0050505050.189433603418.94736840.189433603418.94736841.26148969912.838709680.5621468930.00532897712211.5789475.30555555612211.5789475.2788944722211.5789476.65927099867.774193552.9675141240.0281311090.00045216610.002398990.00045216610.0023869350.0004521660.0030110940.0306451610.0013418081.27E-050.150166587332.10526320.7967171720.150166587332.10526320.7927135680.150166587332.105263210.177419350.4456214690.0042243530.01475487932.631578950.0782828280.01475487932.631578950.0778894470.01475487932.631578950.0982567350.336982389745.26315791.7878787880.336982389745.26315791.7788944720.336982389745.26315792.24405705235.5478343678616.84211188.601010135.5478343678616.84211187.653266335.5478343678616.84211236.722662467122100.05170502100.05170302100.051785.5-395.05-2100.050-397.05-2100.050-314.55-1705395.05-2-1705395.0580.52100.05170302100.051785.5-397.05-2100.050-314.55-1703397.0582.52100.051785.5-314.55-207030.05-365-207030.05-367-207030.05-284.5-1393707.05312-1393707.05310-1393707.05392.57258574685.05742907258574685.05742887258574685.0574370.5202220202020
4222118AssociateDegree150127814credit379511465credit2.26137952.2637952.26138194712535.85714290.0221130220.00011989845.222222220.0054220768340.388889184.431203911-796-150109-1493132019712535.857142925202220203792.741679.203540.00059552381535.85714293792.741679.203540.00059552381712535.85714293792.741679.203540.00059552422213795credit2.26137952.2637952.261679.203549.96062992111679.203545.3300561811679.203547.082111437210.83333334.6621621620.0252785970.000595520.0059317590.0005955210.0031741570.0005955210.0042175420.1255555560.0027764131.51E-050.100395257168.58407080.100395257168.58407080.535112360.100395257168.58407080.71101039721.166666670.4680589680.00253785111679.203549.9606299211679.203545.3300561811679.203547.082111437210.83333334.6621621620.0252785970.0005955210.0059317590.000595520.0031741570.0005955210.0042175420.1255555560.0027764131.51E-050.187615283315.04424781.8687664040.187615283315.04424780.187615283315.04424781.32871234339.555555560.8746928750.00474265111679.203549.96062992111679.203545.330056181679.203547.082111437210.83333334.6621621620.0252785970.0005955210.0059317590.0005955210.0031741570.000595520.0042175420.1255555560.0027764131.51E-050.141200828237.10493051.4064491940.141200828237.10493050.7526083470.141200828237.104930529.769841270.6583011580.0035693590.0047430837.964601770.0472440940.0047430837.964601770.0252808990.0047430837.964601770.0335910420.214492754360.17699122.136482940.214492754360.17699121.1432584270.214492754360.17699121.51906158439.5591567966427.87611394.034120739.5591567966427.87611210.852528139.5591567966427.87611280.162356725113792.74341403792.74308303792.743259.142857-378.74-3792.740-709.74-3792.740-533.5971429-3414378.74-331-3414378.74-154.85714293792.74308303792.743259.142857-709.74-3792.740-533.5971429-3083709.74176.14285713792.743259.142857-533.5971429-377715.74-363-377715.74-694-377715.74-517.8571429-2981811.74433-2981811.74102-2981811.74278.1428571146332150124.74149746146332150124.74149415146332150124.74149591.1429202220202020
4853145MasterDegree106017658home143011232home6.81114306.8114306.810258110266216.33333330.0683890580.0004244614.622222220.0062065522355.933333161.120060812-613-105972-1053592019266216.3333333411202220191423.19209.98531570.004762238258216.33333331423.19209.98531570.004762238258266216.33333331423.19209.98531570.004762238485311430home6.81114306.8114306.81209.98531575.5426356591209.98531575.375939851209.98531576.61016949231.777777782.173252280.0134884030.0047622380.0263953490.00476223810.0256015040.00476223810.0314791990.1513333330.0103495446.42E-050.1804195837.885462560.1804195837.885462560.9699248120.1804195837.885462561.1926040065.7333333330.3920972640.0024335721209.98531575.542635659209.98531575.375939851209.98531576.61016949231.777777782.173252280.0134884030.00476223810.0263953490.0047622380.0256015040.00476223810.0314791990.1513333330.0103495446.42E-050.18601398639.060205581.0310077520.18601398639.060205580.18601398639.060205581.2295839755.9111111110.4042553190.0025090321209.98531575.5426356591209.98531575.37593985209.98531576.61016949231.777777782.173252280.0134884030.00476223810.0263953490.00476223810.0256015040.0047622380.0314791990.1513333330.0103495446.42E-050.15128205131.76700930.8385012920.15128205131.76700930.8132832080.15128205131.76700934.8074074070.3287740630.0020405530.0314685316.6079295150.1744186050.0314685316.6079295150.1691729320.0314685316.6079295150.2080123270.4601398696.62261382.5503875970.4601398696.62261382.4736842110.4601398696.62261383.04160246574.1377622415567.84141410.918604774.1377622415567.84141398.560150474.1377622415567.84141490.063174141191423.19117201423.19116401423.191213.666667-251.19-1423.190-259.19-1423.190-209.5233333-1172251.19-8-1172251.1941.666666671423.19116401423.191213.666667-259.19-1423.190-209.5233333-1164259.1949.666666671423.191213.666667-209.5233333-138538.19-213-138538.19-221-138538.19-171.3333333-772651.19400-772651.19392-772651.19441.6666667104587106010.19105759104587106010.19105751104587106010.19105800.6667202220192020
3003639MasterDegree217948842other1327911264other2.21132792.2132792.20245215424521814.8333330.046318290.00017894221.589743590.0038633075588.410256258.845605712-803-217909-217106201924521814.833333692022201913276.86035.9090910.00016567524521814.83333313276.86035.9090910.000165675245224521814.83333313276.86035.9090910.0001656753003613279other2.21132792.2132792.26035.9090915.41557911916035.9090915.41557911916035.9090917.316925337340.487179515.770783850.0609273770.0001656750.0008972270.00016567510.0008972270.00016567510.0012122330.0564102560.0026128271.01E-050.1846524591114.5454550.1846524591114.54545510.1846524591114.5454551.35108825462.871794872.9121140140.0112503916035.9090915.4155791196035.9090915.41557911916035.9090917.316925337340.487179515.770783850.0609273770.00016567510.0008972270.0001656750.0008972270.00016567510.0012122330.0564102560.0026128271.01E-050.1846524591114.54545510.1846524591114.5454550.1846524591114.5454551.35108825462.871794872.9121140140.0112503916035.9090915.41557911916035.9090915.4155791196035.9090917.316925337340.487179515.770783850.0609273770.00016567510.0008972270.00016567510.0008972270.0001656750.0012122330.0564102560.0026128271.01E-050.136669428824.92424240.74014410.136669428824.92424240.74014410.136669428824.924242446.534188032.1553840060.008326910.00293696817.727272730.0159053830.00293696817.727272730.0159053830.00293696817.727272730.0214895770.063408389382.72727270.3433931480.063408389382.72727270.3433931480.063408389382.72727270.46395444916.4129829199067.2727388.885807516.4129829199067.2727388.885807516.4129829199067.27273120.092570569413276.810827013276.810827013276.811464.16667-2449.8-13276.80-2449.8-13276.80-1812.633333-108272449.80-108272449.8637.166666713276.810827013276.811464.16667-2449.8-13276.80-1812.633333-108272449.8637.166666713276.811464.16667-1812.633333-1324036.8-2413-1324036.8-2413-1324036.8-1775.833333-12437839.8-1610-12437839.8-1610-12437839.8-972.8333333204669217945.8215496204669217945.8215496204669217945.8216133.1667202220192020
3985121AssociateDegree157615649credit964610759credit2.41196462.4196462.41099516217461391.6250.0323574730.00013323630.90476190.0041176287505.47619242.85824351-628-157594-156966202017461391.62551202220209643.594002.4896270.0002498449951391.6259643.594002.4896270.00024984499517461391.6259643.594002.4896270.000249844398519646credit2.41196462.4196462.414002.4896279.69447236214002.4896275.52462772114002.4896276.931465014459.333333314.862865950.0611997590.0002498440.0024221110.00024984410.0013802980.00024984410.0017317880.1147619050.0037134051.53E-050.103151565412.86307050.103151565412.86307050.5698739980.103151565412.86307050.71499146747.380952381.5331278890.00631285114002.4896279.6944723624002.4896275.52462772114002.4896276.931465014459.333333314.862865950.0611997590.00024984410.0024221110.0002498440.0013802980.00024984410.0017317880.1147619050.0037134051.53E-050.181007672724.48132781.7547738690.181007672724.48132780.181007672724.48132781.25464834383.142857142.6902927580.01107762614002.4896279.69447236214002.4896275.5246277214002.4896276.931465014459.333333314.862865950.0611997590.00024984410.0024221110.00024984410.0013802980.0002498440.0017317880.1147619050.0037134051.53E-050.144269645577.43775931.398618090.144269645577.43775930.7970360820.144269645577.437759366.267857142.1442604010.0088292680.0021770688.7136929460.0211055280.0021770688.7136929460.0120274910.0021770688.7136929460.0150902720.067281775269.29460580.6522613070.067281775269.29460580.3717067580.067281775269.29460580.46636126816.3399336565400.41494158.407035216.3399336565400.4149490.272050416.3399336565400.41494113.25967845199643.59865109643.59790009643.598254.375-992.59-9643.590-1743.59-9643.590-1389.215-8651992.59-751-8651992.59-396.6259643.59790009643.598254.375-1743.59-9643.590-1389.215-79001743.59354.3759643.598254.375-1389.215-962518.59-974-962518.59-1725-962518.59-1370.625-8997646.59-346-8997646.59-1097-8997646.59-742.625147969157612.59156620147969157612.59155869147969157612.59156223.375202220202020
2752125MasterDegree40205503other849411082other0.54184940.5484940.540106116713111110.40.0497017890.00062181320.120.0125108821608.279.93041752-478-40180-39702202013111110.449202120198493.4615729.629636.36E-0510611110.48493.4615729.629636.36E-05106113111110.48493.4615729.629636.36E-05275218494other0.54184940.5484940.5415729.629638.005655042115729.629636.479023646115729.629637.649495677339.7616.886679920.2112672556.36E-050.0005089546.36E-0510.0004118996.36E-0510.0004863110.02160.0010735591.34E-050.1249117021964.8148150.1249117021964.8148150.8093058730.1249117021964.8148150.95551152742.442.1093439360.026389753115729.629638.00565504215729.629636.479023646115729.629637.649495677339.7616.886679920.2112672556.36E-0510.0005089546.36E-050.0004118996.36E-0510.0004863110.02160.0010735591.34E-050.1543442432427.7777781.2356267670.1543442432427.7777780.1543442432427.7777781.1806556252.442.6063618290.032607885115729.629638.005655042115729.629636.47902364615729.629637.649495677339.7616.886679920.2112672556.36E-0510.0005089546.36E-0510.0004118996.36E-050.0004863110.02160.0010735591.34E-050.1307275722056.2962961.0465598490.1307275722056.2962960.8469870330.1307275722056.29629644.4162.2075546720.0276184550.00294325446.29629630.0235626770.00294325446.29629630.0190694130.00294325446.29629630.0225144090.059218272931.48148150.4740810560.059218272931.48148150.3836765830.059218272931.48148150.4529899144.73334118274453.703737.89349674.73334118274453.703730.667429444.73334118274453.703736.207672914948493.46743308493.46718308493.467383.6-1060.46-8493.460-1310.46-8493.460-1109.86-74331060.46-250-74331060.46-49.48493.46718308493.467383.6-1310.46-8493.460-1109.86-71831310.46200.68493.467383.6-1109.86-846924.46-1036-846924.46-1286-846924.46-1085.4-7991502.46-558-7991502.46-808-7991502.46-607.43171140204.46391443171140204.46388943171140204.4639094.6202120192020
4660224DoctorDegree176949583cash954710612cash4.03195474.0395474.03010781218951319.7142860.0411663810.00013563224.291666670.0032947357372.875303.51457983-559-176925-176366202018951319.71428691202120199542.972368.982630.00042212210781319.7142869542.972368.982630.000422122107818951319.7142869542.972368.982630.000422122466029547cash4.03195474.0395474.032368.982638.85621521312368.982635.03799472312368.982637.234141589397.791666716.375643220.0539533990.0004221220.0037384040.00042212210.0021266490.00042212210.0030536910.1679166670.0069125212.28E-050.112915052267.49379650.112915052267.49379650.5688654350.112915052267.49379650.81684347344.916666671.8490566040.00609215112368.982638.8562152132368.982635.03799472312368.982637.234141589397.791666716.375643220.0539533990.00042212210.0037384040.0004221220.0021266490.00042212210.0030536910.1679166670.0069125212.28E-050.198491673470.22332511.7578849720.198491673470.22332510.198491673470.22332511.43591686578.958333333.2504288160.010709312368.982638.85621521312368.982635.0379947232368.982637.234141589397.791666716.375643220.0539533990.00042212210.0037384040.00042212210.0021266490.0004221220.0030536910.1679166670.0069125212.28E-050.138233402327.47252751.2242247550.138233402327.47252750.6964191480.138233402327.472527554.988095242.2636608670.0074581620.0025138795.9553349880.0222634510.0025138795.9553349880.0126649080.0025138795.9553349880.0181857540.061066304144.66501240.5408163270.061066304144.66501240.3076517150.061066304144.66501240.44176228618.5345134643907.94045164.145640118.5345134643907.9404593.37678118.5345134643907.94045134.081294791109542.97846909542.97765209542.978227.285714-1073.97-9542.970-1890.97-9542.970-1315.684286-84691073.97-817-84691073.97-241.71428579542.97765209542.978227.285714-1890.97-9542.970-1315.684286-76521890.97575.28571439542.978227.285714-1315.684286-952319.97-1054-952319.97-1871-952319.97-1295.714286-8964578.97-495-8964578.97-1312-8964578.97-736.7142857167402176944.97175871167402176944.97175054167402176944.97175629.2857202120192019
4276619AssociateDegree173466790credit713111776credit1.17071311.1771311.17010158211991092.4444440.0240506330.00010953241.578947370.0045542079129.789474219.57721523-771-173447-172676202011991092.44444462202120197129.836094.8717950.00016407210151092.4444447129.836094.8717950.000164072101511991092.4444447129.836094.8717950.000164072427667131credit1.17071311.1771311.176094.8717957.02561576416094.8717955.94745621416094.8717956.527563059375.31578959.0265822780.041108920.0001640720.0011527090.00016407210.0009758130.00016407210.0010709930.0615789470.0014810136.74E-060.142336278867.52136750.142336278867.52136750.8465387820.142336278867.52136750.92910903253.421052631.2848101270.00585129116094.8717957.0256157646094.8717955.94745621416094.8717956.527563059375.31578959.0265822780.041108920.00016407210.0011527090.0001640720.0009758130.00016407210.0010709930.0615789470.0014810136.74E-060.1681391111024.7863251.1812807880.1681391111024.7863250.1681391111024.7863251.09753864963.105263161.5177215190.00691201716094.8717957.02561576416094.8717955.9474562146094.8717956.527563059375.31578959.0265822780.041108920.00016407210.0011527090.00016407210.0009758130.0001640720.0010709930.0615789470.0014810136.74E-060.153196528933.71320041.0762999450.153196528933.71320040.9111296450.153196528933.713200457.497076021.3828410690.0062977440.00266442316.239316240.0187192120.00266442316.239316240.0158465390.00266442316.239316240.0173921890.110783901675.21367520.7783251230.110783901675.21367520.6588824020.110783901675.21367520.72314890224.32562053148261.5385170.902463124.32562053148261.5385144.67556324.32562053148261.5385158.78702262127129.83611607129.83593207129.836038.555556-1013.83-7129.830-1197.83-7129.830-1091.274444-61161013.83-184-61161013.83-77.444444447129.83593207129.836038.555556-1197.83-7129.830-1091.274444-59321197.83106.55555567129.836038.555556-1091.274444-711217.83-996-711217.83-1180-711217.83-1073.444444-6341788.83-225-6341788.83-409-6341788.83-302.4444444166335173464.83172451166335173464.83172267166335173464.83172373.5556202120192019
3164847DoctorDegree54228635home1013011861home5.811101305.81101305.81018786418781365.6666670.0740157480.00086671113.51063830.0117098181153.78723485.39842523-588-54181-53593202018781365.666667682022202010124.191743.5456110.00057354418781365.66666710124.191743.5456110.000573544187818781365.66666710124.191743.5456110.0005735443164810130home5.811101305.81101305.811743.5456115.39403620911743.5456115.39403620911743.5456117.417622651215.531914915.952755910.1868038650.0005735440.0030937170.00057354410.0030937170.00057354410.0042543320.1236170210.0091496060.000107140.185389931323.23580030.185389931323.235800310.185389931323.23580031.37515255139.957446812.9574803150.03463155611743.5456115.3940362091743.5456115.39403620911743.5456117.417622651215.531914915.952755910.1868038650.00057354410.0030937170.0005735440.0030937170.00057354410.0042543320.1236170210.0091496060.000107140.185389931323.235800310.185389931323.23580030.185389931323.23580031.37515255139.957446812.9574803150.03463155611743.5456115.39403620911743.5456115.3940362091743.5456117.417622651215.531914915.952755910.1868038650.00057354410.0030937170.00057354410.0030937170.0005735440.0042543320.1236170210.0091496060.000107140.134814084235.05450370.7271920480.134814084235.05450370.7271920480.134814084235.054503729.056737592.1506561680.0251837920.0046396848.0895008610.0250266240.0046396848.0895008610.0250266240.0046396848.0895008610.0344154260.062685094109.29432010.3381256660.062685094109.29432010.3381256660.062685094109.29432010.4649743715.3532082929333.56282328.875399365.3532082929333.56282328.875399365.3532082929333.56282339.70807908681210124.198252010124.198252010124.198764.333333-1872.19-10124.190-1872.19-10124.190-1359.856667-82521872.190-82521872.19512.333333310124.198252010124.198764.333333-1872.19-10124.190-1359.856667-82521872.19512.333333310124.198764.333333-1359.856667-1008341.19-1831-1008341.19-1831-1008341.19-1318.666667-9495629.19-1243-9495629.19-1243-9495629.19-730.66666674409854222.19523504409854222.19523504409854222.1952862.33333202220202020
4114036BachelorDegree171301551home429710896home3.78042973.7842973.7806421457887150.0653357530.00021015615.305555560.003216564758.361111310.89110715-515-171265-1707502020788715109202220204293.221136.7724870.0008796846427154293.221136.7724870.0008796846427887154293.221136.7724870.000879684411404297home3.78042973.7842973.781136.7724876.69314641711136.7724875.45304568511136.7724876.00979021119.36111117.7985480940.02508450.0008796840.005887850.00087968410.0047969540.00087968410.0052867130.1050.0068602542.21E-050.149406563169.84126980.149406563169.84126980.8147208120.149406563169.84126980.89790209817.833333331.1651542650.00374778911136.7724876.6931464171136.7724875.45304568511136.7724876.00979021119.36111117.7985480940.02508450.00087968410.005887850.0008796840.0047969540.00087968410.0052867130.1050.0068602542.21E-050.183383756208.46560851.227414330.183383756208.46560850.183383756208.46560851.10209790221.888888891.4301270420.0046000911136.7724876.69314641711136.7724875.4530456851136.7724876.00979021119.36111117.7985480940.02508450.00087968410.005887850.00087968410.0047969540.0008796840.0052867130.1050.0068602542.21E-050.166395159189.15343921.1137071650.166395159189.15343920.9073604060.166395159189.153439219.861111111.2976406530.0041739390.0083779389.5238095240.0560747660.0083779389.5238095240.0456852790.0083779389.5238095240.050349650.128228997145.76719580.8582554520.128228997145.76719580.6992385790.128228997145.76719580.77062937139.8652548345317.72487266.823987539.8652548345317.72487217.387055839.8652548345317.72487239.5818182109124293.22365504293.22350904293.223582-638.22-4293.220-784.22-4293.220-711.22-3655638.22-146-3655638.22-734293.22350904293.223582-784.22-4293.220-711.22-3509784.22734293.223582-711.22-426132.22-606-426132.22-752-426132.22-679-3746547.22-91-3746547.22-237-3746547.22-164167004171297.22170659167004171297.22170513167004171297.22170586202220202020
4764148DoctorDegree149357532credit505010442credit7.51150507.5150507.51187427876749.16666670.0902255640.00032137811.083333330.0035619353111.604167280.74624066-484-149309-1488252020876749.1666667102202220205042.49672.4367510.001487129874749.16666675042.49672.4367510.001487129874876749.16666675042.49672.4367510.001487129476415050credit7.51150507.5150507.51672.4367515.7780320371672.4367515.7648401831672.4367516.740823137105.20833339.4924812030.0338116060.0014871290.0085926770.00148712910.0085730590.00148712910.0100244720.1564583330.0141165415.03E-050.173069307116.37816250.173069307116.37816250.9977168950.173069307116.37816251.16662958818.208333331.6428571430.0058517511672.4367515.778032037672.4367515.7648401831672.4367516.740823137105.20833339.4924812030.0338116060.00148712910.0085926770.0014871290.0085730590.00148712910.0100244720.1564583330.0141165415.03E-050.173465347116.6444741.002288330.173465347116.6444740.173465347116.6444741.16929922118.251.6466165410.0058651421672.4367515.7780320371672.4367515.764840183672.4367516.740823137105.20833339.4924812030.0338116060.00148712910.0085926770.00148712910.0085730590.0014871290.0100244720.1564583330.0141165415.03E-050.14834983599.755881050.8571700990.14834983599.755881050.855213090.14834983599.7558810515.607638891.408208020.0050159460.009504956.3914780290.0549199080.009504956.3914780290.0547945210.009504956.3914780290.064071190.10534653570.838881490.6086956520.10534653570.838881490.6073059360.10534653570.838881490.71012235829.5756435619887.74967170.88901629.5756435619887.74967170.498858429.5756435619887.74967199.3641824102105042.49417605042.49417405042.494300.833333-866.49-5042.490-868.49-5042.490-741.6566667-4176866.49-2-4176866.49124.83333335042.49417405042.494300.833333-868.49-5042.490-741.6566667-4174868.49126.83333335042.494300.833333-741.6566667-500240.49-826-500240.49-828-500240.49-701.1666667-4518524.49-342-4518524.49-344-4518524.49-217.1666667144307149349.49148483144307149349.49148481144307149349.49148607.8333202220202020
3102721AssociateDegree59927722cash1279110644cash4.071127914.07127914.071205117023052140.6666670.0290858730.00035042634.380952380.0120479922853.66666783.001385048-701-59906-59205202023052140.666667682022202012786.933142.7518430.00031819220512140.66666712786.933142.7518430.000318192205123052140.66666712786.933142.7518430.0003181923102712791cash4.071127914.07127914.073142.7518436.23647001513142.7518435.54924078113142.7518435.975241358609.095238117.716066480.2134430220.0003181920.0019843980.00031819210.0017657270.00031819210.0019012770.1938095240.0056371196.79E-050.160347119503.93120390.160347119503.93120390.8898047720.160347119503.93120390.95811273797.666666672.8407202220.03422497413142.7518436.2364700153142.7518435.54924078113142.7518435.975241358609.095238117.716066480.2134430220.00031819210.0019843980.0003181920.0017657270.00031819210.0019012770.1938095240.0056371196.79E-050.180204832566.33906631.1238420280.180204832566.33906630.180204832566.33906631.076767362109.76190483.1925207760.03846346413142.7518436.23647001513142.7518435.5492407813142.7518435.975241358609.095238117.716066480.2134430220.00031819210.0019843980.00031819210.0017657270.0003181920.0019012770.1938095240.0056371196.79E-050.167357256525.9623261.0437185110.167357256525.9623260.9287057120.167357256525.962326101.93650792.9649122810.0357212390.0016417795.159705160.0102389080.0016417795.159705160.0091106290.0016417795.159705160.0098100280.056445939177.39557740.3520234030.056445939177.39557740.3132321040.056445939177.39557740.3372781074.6850910814724.0786229.218430034.6850910814724.0786225.998698484.6850910814724.0786227.99454998681212786.9310740012786.9310486012786.9310650.33333-2046.93-12786.930-2300.93-12786.930-2136.596667-107402046.93-254-107402046.93-89.6666666712786.9310486012786.9310650.33333-2300.93-12786.930-2136.596667-104862300.93164.333333312786.9310650.33333-2136.596667-1277016.93-2030-1277016.93-2284-1277016.93-2119.666667-12069717.93-1329-12069717.93-1583-12069717.93-1418.6666674713659922.93578764713659922.93576224713659922.9357786.33333202220202020
4247635AssociateDegree76007502cash1234811024cash1.791123481.79123481.791139545139513950.0697211160.00046048414.342857140.0066046552171.628571151.40836659-467-75972-755052020139513956102022202012346.216898.3240220.0001449631395139512346.216898.3240220.00014496313951395139512346.216898.3240220.0001449634247612348cash1.791123481.79123481.796898.3240228.85161290316898.3240228.85161290316898.3240228.851612903352.824.597609560.1624587210.0001449630.0012831540.00014496310.0012831540.00014496310.0012831540.0511428570.0035657372.36E-050.112973761779.32960890.112973761779.329608910.112973761779.3296089139.857142862.7788844620.01835357316898.3240228.8516129036898.3240228.85161290316898.3240228.851612903352.824.597609560.1624587210.00014496310.0012831540.0001449630.0012831540.00014496310.0012831540.0511428570.0035657372.36E-050.112973761779.329608910.112973761779.32960890.112973761779.3296089139.857142862.7788844620.01835357316898.3240228.85161290316898.3240228.8516129036898.3240228.851612903352.824.597609560.1624587210.00014496310.0012831540.00014496310.0012831540.0001449630.0012831540.0511428570.0035657372.36E-050.112973761779.329608910.112973761779.329608910.112973761779.329608939.857142862.7788844620.0183535730.00283446719.553072630.0250896060.00283446719.553072630.0250896060.00283446719.553072630.0250896060.040654357280.44692740.3598566310.040654357280.44692740.3598566310.040654357280.44692740.3598566316.15540978342462.0111754.485304666.15540978342462.0111754.485304666.15540978342462.0111754.485304666101212346.2110953012346.2110953012346.2110953-1393.21-12346.210-1393.21-12346.210-1393.21-109531393.210-109531393.21012346.2110953012346.2110953-1393.21-12346.210-1393.21-109531393.21012346.2110953-1393.21-1231333.21-1360-1231333.21-1360-1231333.21-1360-11846500.21-893-11846500.21-893-11846500.21-8936365976005.21746126365976005.21746126365976005.2174612202220202020
4749730BachelorDegree50855606home816611735home0.98181660.9881660.98011608714681193.40.049504950.00058991220.20.0119162321695.16666783.919141919-576-50825-50249202014681193.482202220208165.028332.6530610.0001200111601193.48165.028332.6530610.00012001116014681193.48165.028332.6530610.00012001474978166home0.98181660.9881660.988332.6530617.03965517218332.6530615.562670318332.6530616.84263449272.213.475247520.1605741810.000120010.0008448280.0001200110.0006675750.0001200110.0008211830.0326666670.0016171621.93E-050.1420524121183.6734690.1420524121183.6734690.7901907360.1420524121183.6734690.97201273738.666666671.9141914190.0228099518332.6530617.0396551728332.6530615.562670318332.6530616.84263449272.213.475247520.1605741810.0001200110.0008448280.000120010.0006675750.0001200110.0008211830.0326666670.0016171621.93E-050.1797697771497.9591841.2655172410.1797697771497.9591840.1797697771497.9591841.23009887748.933333332.4224422440.02886638518332.6530617.03965517218332.6530615.56267038332.6530616.84263449272.213.475247520.1605741810.0001200110.0008448280.0001200110.0006675750.000120010.0008211830.0326666670.0016171621.93E-050.1461425421217.7551021.0287931030.1461425421217.7551020.8129427790.1461425421217.75510239.781.9693069310.0234667190.00367376930.61224490.0258620690.00367376930.61224490.0204359670.00367376930.61224490.025138260.07421014618.36734690.5224137930.07421014618.36734690.412806540.07421014618.36734690.5077928616.22765123751892.8571443.840517246.22765123751892.8571434.642370576.22765123751892.8571442.613541148288165.02700608165.02669808165.026972.6-1159.02-8165.020-1467.02-8165.020-1192.42-70061159.02-308-70061159.02-33.48165.02669808165.026972.6-1467.02-8165.020-1192.42-66981467.02274.68165.026972.6-1192.42-813629.02-1130-813629.02-1438-813629.02-1163.4-7560605.02-554-7560605.02-862-7560605.02-587.44268950854.02496954268950854.02493874268950854.0249661.6202220202020

 

 

2)、完整的数据框包含了113-5个新特征

auto_feature_names: 
 113 [<Feature: age>, <Feature: education>, <Feature: income>, <Feature: credit_score>, <Feature: loan_type>, <Feature: COUNT(loans)>, <Feature: MAX(loans.loan_amount)>, <Feature: MAX(loans.rate)>, <Feature: MEAN(loans.loan_amount)>, <Feature: MEAN(loans.rate)>, <Feature: MIN(loans.loan_amount)>, <Feature: MIN(loans.rate)>, <Feature: MODE(loans.loan_type)>, <Feature: MODE(loans.repaid)>, <Feature: NUM_UNIQUE(loans.loan_type)>, <Feature: NUM_UNIQUE(loans.repaid)>, <Feature: SKEW(loans.loan_amount)>, <Feature: SKEW(loans.rate)>, <Feature: STD(loans.loan_amount)>, <Feature: STD(loans.rate)>, <Feature: SUM(loans.loan_amount)>, <Feature: SUM(loans.rate)>, <Feature: COUNT(payments)>, <Feature: MAX(payments.payment_amount)>, <Feature: MEAN(payments.payment_amount)>, <Feature: MIN(payments.payment_amount)>, <Feature: MODE(payments.missed)>, <Feature: NUM_UNIQUE(payments.missed)>, <Feature: SKEW(payments.payment_amount)>, <Feature: STD(payments.payment_amount)>, <Feature: SUM(payments.payment_amount)>, <Feature: DAY(joined)>, <Feature: MONTH(joined)>, <Feature: WEEKDAY(joined)>, <Feature: YEAR(joined)>, <Feature: MAX(loans.COUNT(payments))>, <Feature: MAX(loans.MEAN(payments.payment_amount))>, <Feature: MAX(loans.MIN(payments.payment_amount))>, <Feature: MAX(loans.NUM_UNIQUE(payments.missed))>, <Feature: MAX(loans.SKEW(payments.payment_amount))>, <Feature: MAX(loans.STD(payments.payment_amount))>, <Feature: MAX(loans.SUM(payments.payment_amount))>, <Feature: MEAN(loans.COUNT(payments))>, <Feature: MEAN(loans.MAX(payments.payment_amount))>, <Feature: MEAN(loans.MEAN(payments.payment_amount))>, <Feature: MEAN(loans.MIN(payments.payment_amount))>, <Feature: MEAN(loans.NUM_UNIQUE(payments.missed))>, <Feature: MEAN(loans.SKEW(payments.payment_amount))>, <Feature: MEAN(loans.STD(payments.payment_amount))>, <Feature: MEAN(loans.SUM(payments.payment_amount))>, <Feature: MIN(loans.COUNT(payments))>, <Feature: MIN(loans.MAX(payments.payment_amount))>, <Feature: MIN(loans.MEAN(payments.payment_amount))>, <Feature: MIN(loans.NUM_UNIQUE(payments.missed))>, <Feature: MIN(loans.SKEW(payments.payment_amount))>, <Feature: MIN(loans.STD(payments.payment_amount))>, <Feature: MIN(loans.SUM(payments.payment_amount))>, <Feature: MODE(loans.DAY(loan_end))>, <Feature: MODE(loans.DAY(loan_start))>, <Feature: MODE(loans.MODE(payments.missed))>, <Feature: MODE(loans.MONTH(loan_end))>, <Feature: MODE(loans.MONTH(loan_start))>, <Feature: MODE(loans.WEEKDAY(loan_end))>, <Feature: MODE(loans.WEEKDAY(loan_start))>, <Feature: MODE(loans.YEAR(loan_end))>, <Feature: MODE(loans.YEAR(loan_start))>, <Feature: NUM_UNIQUE(loans.DAY(loan_end))>, <Feature: NUM_UNIQUE(loans.DAY(loan_start))>, <Feature: NUM_UNIQUE(loans.MODE(payments.missed))>, <Feature: NUM_UNIQUE(loans.MONTH(loan_end))>, <Feature: NUM_UNIQUE(loans.MONTH(loan_start))>, <Feature: NUM_UNIQUE(loans.WEEKDAY(loan_end))>, <Feature: NUM_UNIQUE(loans.WEEKDAY(loan_start))>, <Feature: NUM_UNIQUE(loans.YEAR(loan_end))>, <Feature: NUM_UNIQUE(loans.YEAR(loan_start))>, <Feature: SKEW(loans.COUNT(payments))>, <Feature: SKEW(loans.MAX(payments.payment_amount))>, <Feature: SKEW(loans.MEAN(payments.payment_amount))>, <Feature: SKEW(loans.MIN(payments.payment_amount))>, <Feature: SKEW(loans.NUM_UNIQUE(payments.missed))>, <Feature: SKEW(loans.STD(payments.payment_amount))>, <Feature: SKEW(loans.SUM(payments.payment_amount))>, <Feature: STD(loans.COUNT(payments))>, <Feature: STD(loans.MAX(payments.payment_amount))>, <Feature: STD(loans.MEAN(payments.payment_amount))>, <Feature: STD(loans.MIN(payments.payment_amount))>, <Feature: STD(loans.NUM_UNIQUE(payments.missed))>, <Feature: STD(loans.SKEW(payments.payment_amount))>, <Feature: STD(loans.SUM(payments.payment_amount))>, <Feature: SUM(loans.MAX(payments.payment_amount))>, <Feature: SUM(loans.MEAN(payments.payment_amount))>, <Feature: SUM(loans.MIN(payments.payment_amount))>, <Feature: SUM(loans.NUM_UNIQUE(payments.missed))>, <Feature: SUM(loans.SKEW(payments.payment_amount))>, <Feature: SUM(loans.STD(payments.payment_amount))>, <Feature: MAX(payments.loans.loan_amount)>, <Feature: MAX(payments.loans.rate)>, <Feature: MEAN(payments.loans.loan_amount)>, <Feature: MEAN(payments.loans.rate)>, <Feature: MIN(payments.loans.loan_amount)>, <Feature: MIN(payments.loans.rate)>, <Feature: MODE(payments.loans.client_id)>, <Feature: MODE(payments.loans.loan_type)>, <Feature: MODE(payments.loans.repaid)>, <Feature: NUM_UNIQUE(payments.loans.client_id)>, <Feature: NUM_UNIQUE(payments.loans.loan_type)>, <Feature: NUM_UNIQUE(payments.loans.repaid)>, <Feature: SKEW(payments.loans.loan_amount)>, <Feature: SKEW(payments.loans.rate)>, <Feature: STD(payments.loans.loan_amount)>, <Feature: STD(payments.loans.rate)>, <Feature: SUM(payments.loans.loan_amount)>, <Feature: SUM(payments.loans.rate)>]
auto_features: <class 'pandas.core.frame.DataFrame'> 
client_idageeducationincomecredit_scoreloan_typeCOUNT(loans)MAX(loans.loan_amount)MAX(loans.rate)MEAN(loans.loan_amount)MEAN(loans.rate)MIN(loans.loan_amount)MIN(loans.rate)MODE(loans.loan_type)MODE(loans.repaid)NUM_UNIQUE(loans.loan_type)NUM_UNIQUE(loans.repaid)SKEW(loans.loan_amount)SKEW(loans.rate)STD(loans.loan_amount)STD(loans.rate)SUM(loans.loan_amount)SUM(loans.rate)COUNT(payments)MAX(payments.payment_amount)MEAN(payments.payment_amount)MIN(payments.payment_amount)MODE(payments.missed)NUM_UNIQUE(payments.missed)SKEW(payments.payment_amount)STD(payments.payment_amount)SUM(payments.payment_amount)DAY(joined)MONTH(joined)WEEKDAY(joined)YEAR(joined)MAX(loans.COUNT(payments))MAX(loans.MEAN(payments.payment_amount))MAX(loans.MIN(payments.payment_amount))MAX(loans.NUM_UNIQUE(payments.missed))MAX(loans.SKEW(payments.payment_amount))MAX(loans.STD(payments.payment_amount))MAX(loans.SUM(payments.payment_amount))MEAN(loans.COUNT(payments))MEAN(loans.MAX(payments.payment_amount))MEAN(loans.MEAN(payments.payment_amount))MEAN(loans.MIN(payments.payment_amount))MEAN(loans.NUM_UNIQUE(payments.missed))MEAN(loans.SKEW(payments.payment_amount))MEAN(loans.STD(payments.payment_amount))MEAN(loans.SUM(payments.payment_amount))MIN(loans.COUNT(payments))MIN(loans.MAX(payments.payment_amount))MIN(loans.MEAN(payments.payment_amount))MIN(loans.NUM_UNIQUE(payments.missed))MIN(loans.SKEW(payments.payment_amount))MIN(loans.STD(payments.payment_amount))MIN(loans.SUM(payments.payment_amount))MODE(loans.DAY(loan_end))MODE(loans.DAY(loan_start))MODE(loans.MODE(payments.missed))MODE(loans.MONTH(loan_end))MODE(loans.MONTH(loan_start))MODE(loans.WEEKDAY(loan_end))MODE(loans.WEEKDAY(loan_start))MODE(loans.YEAR(loan_end))MODE(loans.YEAR(loan_start))NUM_UNIQUE(loans.DAY(loan_end))NUM_UNIQUE(loans.DAY(loan_start))NUM_UNIQUE(loans.MODE(payments.missed))NUM_UNIQUE(loans.MONTH(loan_end))NUM_UNIQUE(loans.MONTH(loan_start))NUM_UNIQUE(loans.WEEKDAY(loan_end))NUM_UNIQUE(loans.WEEKDAY(loan_start))NUM_UNIQUE(loans.YEAR(loan_end))NUM_UNIQUE(loans.YEAR(loan_start))SKEW(loans.COUNT(payments))SKEW(loans.MAX(payments.payment_amount))SKEW(loans.MEAN(payments.payment_amount))SKEW(loans.MIN(payments.payment_amount))SKEW(loans.NUM_UNIQUE(payments.missed))SKEW(loans.STD(payments.payment_amount))SKEW(loans.SUM(payments.payment_amount))STD(loans.COUNT(payments))STD(loans.MAX(payments.payment_amount))STD(loans.MEAN(payments.payment_amount))STD(loans.MIN(payments.payment_amount))STD(loans.NUM_UNIQUE(payments.missed))STD(loans.SKEW(payments.payment_amount))STD(loans.SUM(payments.payment_amount))SUM(loans.MAX(payments.payment_amount))SUM(loans.MEAN(payments.payment_amount))SUM(loans.MIN(payments.payment_amount))SUM(loans.NUM_UNIQUE(payments.missed))SUM(loans.SKEW(payments.payment_amount))SUM(loans.STD(payments.payment_amount))MAX(payments.loans.loan_amount)MAX(payments.loans.rate)MEAN(payments.loans.loan_amount)MEAN(payments.loans.rate)MIN(payments.loans.loan_amount)MIN(payments.loans.rate)MODE(payments.loans.client_id)MODE(payments.loans.loan_type)MODE(payments.loans.repaid)NUM_UNIQUE(payments.loans.client_id)NUM_UNIQUE(payments.loans.loan_type)NUM_UNIQUE(payments.loans.repaid)SKEW(payments.loans.loan_amount)SKEW(payments.loans.rate)STD(payments.loans.loan_amount)STD(payments.loans.rate)SUM(payments.loans.loan_amount)SUM(payments.loans.rate)
3374744MasterDegree138377683other178554.8978554.8978554.89other111    78554.89213721314125611 82.024386622628273220192131412561 82.02438662262821372131412561 82.0243866226282137213141 82.0243866226281201391620222020111111111              1372131412561082.0243866278554.8978554.8978554.8933747other1111  00157109.78
3157838DoctorDegree104028805other179530.1379530.1379530.13other111    79530.13715571180.714286854120.327985609225.51179898265544201971180.71428685420.327985609225.51179898265715571180.71428685420.327985609225.51179898265715571180.71428620.327985609225.511798982654201162520232020111111111              15571180.71428685420.327985609225.511798979530.1379530.1379530.1331578other11110000556710.91
2789447BachelorDegree176516708credit1134571.48134571.48134571.48credit111    134571.48725052118.4285711692020.104454852296.482072114829746201972118.428571169220.104454852296.482072114829725052118.428571169220.104454852296.482072114829725052118.42857120.104454852296.48207211482981801045520222020111111111              25052118.428571169220.104454852296.4820721134571.48134571.48134571.4827894credit111100009419910.36
4496631BachelorDegree58530822credit177330.4277330.4277330.42credit011    77330.42312451079.66666785801-1.169092087199.55533932391350201931079.6666678581-1.169092087199.5553393239312451079.6666678581-1.169092087199.5553393239312451079.6666671-1.169092087199.555339323922150292120232020111111111              12451079.6666678581-1.169092087199.55533977330.4277330.4277330.4244966credit01110000231991.26
2919546BachelorDegree38528680other124660.6824660.6824660.68other111    24660.686431368.528902-0.35912687760.321637912211225220196368.52892-0.35912687760.3216379122116431368.52892-0.35912687760.3216379122116431368.52-0.35912687760.3216379122112760431220212019111111111              431368.52892-0.35912687760.3216379124660.6824660.6824660.6829195other11110000147964.08
2594218DoctorDegree227219839cash1140593.58140593.58140593.58cash011    140593.588240319201441020.19589847336.755528115360966201981920144120.19589847336.755528115360824031920144120.19589847336.75552811536082403192020.19589847336.75552811536029100340220212019111111111              24031920144120.19589847336.7555281140593.58140593.58140593.5825942cash0111000011247228.64
3843543DoctorDegree183813596home166155.6566155.6566155.65home011    66155.6591177960.111111173002-0.110570695156.98442958641266220199960.11111117302-0.110570695156.9844295864191177960.11111117302-0.110570695156.9844295864191177960.11111112-0.110570695156.98442958641251301254020202019111111111              1177960.11111117302-0.110570695156.984429566155.6566155.6566155.6538435home011100005953550.85
4164627AssociateDegree47995514cash1148840.04148840.04148840.04cash011    148840.04225012239.5197802 369.81684664479675201922239.519782 369.81684664479225012239.519782 369.81684664479225012239.52 369.816846644792222010105320222020111111111              25012239.5197820369.8168466148840.04148840.04148840.0441646cash0111  00297680.08
3148425AssociateDegree151928547cash184584.0484584.0484584.04cash011    84584.04814911232.7588312-0.485776673202.590191698621671201981232.758832-0.485776673202.59019169862814911232.758832-0.485776673202.59019169862814911232.752-0.485776673202.5901916986213181761120212019111111111              14911232.758832-0.485776673202.590191684584.0484584.0484584.0431484cash011100006766432.32
4996632AssociateDegree164888629other1141084.69141084.69141084.69other111    141084.69116711671167111  1671710020191167116711  167111671167116711  16711167116711  167181611293220222020111111111              167116711671100141084.69141084.69141084.6949966other1111    141084.69
3461040BachelorDegree53512771credit144972.344972.344972.3credit111    44972.33679601.666666750311-1.00753821189.918481618052410320193601.66666675031-1.00753821189.918481618053679601.66666675031-1.00753821189.918481618053679601.66666671-1.00753821189.9184816180514281184420222020111111111              679601.66666675031-1.00753821189.918481644972.344972.344972.334610credit11110000134916.9
4913431MasterDegree74686708home121010.9521010.9521010.95home111    21010.954398315.522402-0.03828580594.4651611312621911120194315.52242-0.03828580594.4651611312624398315.52242-0.03828580594.4651611312624398315.52-0.03828580594.46516113126211210675120222020111111111              398315.52242-0.03828580594.4651611321010.9521010.9521010.9549134home1111000084043.8
4222118AssociateDegree150127814credit137952.2637952.2637952.26credit111    37952.267712535.8571429381120.404340426100.378331937512111320197535.857142938120.404340426100.378331937517712535.857142938120.404340426100.378331937517712535.857142920.404340426100.378331937512891250520222020111111111              712535.857142938120.404340426100.378331937952.2637952.2637952.2642221credit111100002656515.82
4853145MasterDegree106017658home114306.8114306.8114306.81home111    14306.819266216.333333316202-0.08644264442.658527871947212020199216.33333331622-0.08644264442.6585278719479266216.33333331622-0.08644264442.6585278719479266216.33333332-0.08644264442.65852787194721904115120222019111111111              266216.33333331622-0.08644264442.6585278714306.8114306.8114306.8148531home111100001287061.29
3003639MasterDegree217948842other1132792.2132792.2132792.2other111    132792.2624521814.8333331485021.132810699365.5163015108893121201961814.833333148521.132810699365.516301510889624521814.833333148521.132810699365.516301510889624521814.83333321.132810699365.51630151088911240695120222019111111111              24521814.833333148521.132810699365.5163015132792.2132792.2132792.230036other111100007967413.2
3985121AssociateDegree157615649credit196462.4196462.4196462.41credit111    96462.41817461391.62597002-0.305586974305.6557062111331613202081391.6259702-0.305586974305.655706211133817461391.6259702-0.305586974305.655706211133817461391.6252-0.305586974305.6557062111334250512520222020111111111              17461391.6259702-0.305586974305.655706296462.4196462.4196462.4139851credit111100007716819.28
2752125MasterDegree40205503other184940.5484940.5484940.54other111    84940.54513111110.41003021.509440198121.230359255522225202051110.4100321.509440198121.23035925552513111110.4100321.509440198121.23035925552513111110.421.509440198121.2303592555223270494420212019111111111              13111110.4100321.509440198121.230359284940.5484940.5484940.5427521other11110000424702.7
4660224DoctorDegree176949583cash195474.0395474.0395474.03cash111    95474.03718951319.7142861078021.343759834314.34254992381435202071319.714286107821.343759834314.3425499238718951319.714286107821.343759834314.3425499238718951319.71428621.343759834314.342549923822250912420212019111111111              18951319.714286107821.343759834314.34254995474.0395474.0395474.0346602cash111100006682928.21
4276619AssociateDegree173466790credit171311.1771311.1771311.17credit011    71311.17911991092.44444473002-2.200999473148.268431598321536202091092.4444447302-2.200999473148.26843159832911991092.4444447302-2.200999473148.26843159832911991092.4444442-2.200999473148.268431598321360626220212019111111111              11991092.4444447302-2.200999473148.268431571311.1771311.1771311.1742766credit011100006417910.53
3164847DoctorDegree54228635home1101305.81101305.81101305.81home111    101305.81318781365.6666671081021.700079287444.608067140971731202031365.666667108121.700079287444.60806714097318781365.666667108121.700079287444.60806714097318781365.66666721.700079287444.6080671409713190680220222020111111111              18781365.666667108121.700079287444.6080671101305.81101305.81101305.8131648home111100003039017.43
4114036BachelorDegree171301551home142973.7842973.7842973.78home011    42973.78278871564202 103.237590114301453202027156422 103.2375901143027887156422 103.2375901143027887152 103.23759011430122801092020222020111111111              78871564220103.237590142973.7842973.7842973.7841140home0111  0085947.56
4764148DoctorDegree149357532credit150507.5150507.5150507.51credit111    50507.516876749.1666667623120.199406377108.74634094495256320206749.166666762320.199406377108.746340944956876749.166666762320.199406377108.746340944956876749.166666720.199406377108.74634094495262211022520222020111111111              876749.166666762320.199406377108.746340950507.5150507.5150507.5147641credit111100003030045.06
3102721AssociateDegree59927722cash1127914.07127914.07127914.07cash111    127914.07323052140.6666672051121.710489413142.514326864222581202032140.666667205121.710489413142.51432686422323052140.666667205121.710489413142.51432686422323052140.66666721.710489413142.5143268642221121681220222020111111111              23052140.666667205121.710489413142.5143268127914.07127914.07127914.0731027cash111100003837312.21
4247635AssociateDegree76007502cash1123481.79123481.79123481.79cash111    123481.79113951395139511  1395129520201139513951  139511395139513951  13951139513951  1395292416102520222020111111111              139513951395100123481.79123481.79123481.7942476cash1111    123481.79
4749730BachelorDegree50855606home181660.9881660.9881660.98home111    81660.98514681193.4956120.274517917219.31666659671995202051193.495620.274517917219.3166665967514681193.495620.274517917219.3166665967514681193.420.274517917219.31666659679141821420222020111111111              14681193.495620.274517917219.31666681660.9881660.9881660.9847497home11110000408304.9

 

 

 

 

 

 

 

 

一个处女座的程序猿 CSDN认证博客专家 华为杯研电赛一等 华为研数模一等奖 国内外AI竞十
人工智能硕博生,目前兼职国内外多家头部人工智能公司的AI技术顾问。拥有十多项发明专利(6项)和软件著作权(9项),多个国家级证书(2个国三级、3个国四级),先后获得国内外“人工智能算法”竞赛(包括国家级、省市级等,一等奖5项、二等奖4项、三等奖2项)相关证书十多个,以上均以第一作者身份,并拥有省市校级个人荣誉证书十多项。正在撰写《人工智算法最新实战》一书,目前已37万字。
已标记关键词 清除标记
©️2020 CSDN 皮肤主题: 代码科技 设计师:Amelia_0503 返回首页