gimi9 Pandas Profiling

Dataset statistics

Number of variables	18
Number of observations	1000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	151.5 KiB
Average record size in memory	155.1 B

Variable types

Categorical	8
Numeric	7
Boolean	2
DateTime	1

Dataset

Description	한국주택금융공사 신탁자산부 업무 관련 공개 공공데이터 (해당 부서의 업무와 관련된 데이터베이스에서 공개 가능한 원천 데이터)
Author	한국주택금융공사
URL	https://www.data.go.kr/data/15073172/fileData.do

Alerts

`LIQD_PLAN_CD` has constant value ""	Constant
`FEE_CD` has constant value ""	Constant
`EXPECT_DY` has constant value ""	Constant
`MNG_FEE_CD` has constant value ""	Constant
`TRNSFER_DY` has constant value ""	Constant
`PAY_AMT` has constant value ""	Constant
`MLTM_TRN_YN` has constant value ""	Constant
`BANK_TRN_YN` has constant value ""	Constant
`REG_ENO` has constant value ""	Constant
`REG_DT` has constant value ""	Constant
`APPRV_DY` is highly overall correlated with `LOAN_EXEC_DY`	High correlation
`LOAN_EXEC_DY` is highly overall correlated with `APPRV_DY`	High correlation
`LOAN_AMT` is highly overall correlated with `LOAN_RAMT`	High correlation
`INT_RAT` is highly overall correlated with `HOLD_CD`	High correlation
`LOAN_RAMT` is highly overall correlated with `LOAN_AMT`	High correlation
`HOLD_CD` is highly overall correlated with `INT_RAT`	High correlation
`LOAN_ACC_NO` has unique values	Unique

Reproduction

Analysis started	2023-12-12 03:09:22.173759
Analysis finished	2023-12-12 03:09:31.127410
Duration	8.95 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

LIQD_PLAN_CD
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

KHFCMB2020S-34	1000

Length

Max length	14
Median length	14
Mean length	14
Min length	14

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	KHFCMB2020S-34
2nd row	KHFCMB2020S-34
3rd row	KHFCMB2020S-34
4th row	KHFCMB2020S-34
5th row	KHFCMB2020S-34

Common Values

Value	Count	Frequency (%)
KHFCMB2020S-34	1000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
khfcmb2020s-34	1000	100.0%

FEE_CD
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

B00417	1000

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	B00417
2nd row	B00417
3rd row	B00417
4th row	B00417
5th row	B00417

Common Values

Value	Count	Frequency (%)
B00417	1000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
b00417	1000	100.0%

EXPECT_DY
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

20201120	1000

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	20201120
2nd row	20201120
3rd row	20201120
4th row	20201120
5th row	20201120

Common Values

Value	Count	Frequency (%)
20201120	1000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
20201120	1000	100.0%

MNG_FEE_CD
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

6A	1000

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	6A
2nd row	6A
3rd row	6A
4th row	6A
5th row	6A

Common Values

Value	Count	Frequency (%)
6A	1000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
6a	1000	100.0%

LOAN_ACC_NO
Real number (ℝ)

UNIQUE

Distinct	1000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.1215102 × 10¹³

Minimum	1.5090405 × 10¹¹
Maximum	9.9310901 × 10¹³
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	1.5090405 × 10¹¹
5-th percentile	2.0550904 × 10¹³
Q1	4.3340901 × 10¹³
median	6.6240904 × 10¹³
Q3	8.1070901 × 10¹³
95-th percentile	8.96724 × 10¹³
Maximum	9.9310901 × 10¹³
Range	9.9159997 × 10¹³
Interquartile range (IQR)	3.773 × 10¹³

Descriptive statistics

Standard deviation	2.3727808 × 10¹³
Coefficient of variation (CV)	0.38761363
Kurtosis	-0.55337402
Mean	6.1215102 × 10¹³
Median Absolute Deviation (MAD)	1.6105001 × 10¹³
Skewness	-0.6774793
Sum	6.1215102 × 10¹⁶
Variance	5.6300887 × 10²⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22640904049185	1	0.1%
76320901064512	1	0.1%
25630904028402	1	0.1%
79750901037849	1	0.1%
81070901038192	1	0.1%
86020901057745	1	0.1%
81100901053831	1	0.1%
63090904023045	1	0.1%
76290901075014	1	0.1%
67520900028519	1	0.1%
Other values (990)	990	99.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
150904048743	1	0.1%
860904011621	1	0.1%
990904013277	1	0.1%
1090904012201	1	0.1%
1120904023134	1	0.1%
1140900000788	1	0.1%
1980900006601	1	0.1%
2220904016402	1	0.1%
2350904034337	1	0.1%
2480904036079	1	0.1%

Value	Count	Frequency (%)
99310901021705	1	0.1%
99280901078131	1	0.1%
99280901077978	1	0.1%
98720900004061	1	0.1%
98690900011619	1	0.1%
98560900007149	1	0.1%
97590900008428	1	0.1%
96980901088914	1	0.1%
96980901088899	1	0.1%
96980901088860	1	0.1%

APPRV_DY
Real number (ℝ)

HIGH CORRELATION

Distinct	127
Distinct (%)	12.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20199532

Minimum	20191208
Maximum	20200513
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	20191208
5-th percentile	20191230
Q1	20200220
median	20200313
Q3	20200329
95-th percentile	20200413
Maximum	20200513
Range	9305
Interquartile range (IQR)	109.25

Descriptive statistics

Standard deviation	2533.7984
Coefficient of variation (CV)	0.00012543847
Kurtosis	6.8778885
Mean	20199532
Median Absolute Deviation (MAD)	86
Skewness	-2.9750234
Sum	2.0199532 × 10¹⁰
Variance	6420134.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20191231	28	2.8%
20200317	27	2.7%
20200331	26	2.6%
20200323	23	2.3%
20200330	23	2.3%
20200327	22	2.2%
20200401	22	2.2%
20200316	22	2.2%
20200303	22	2.2%
20200402	22	2.2%
Other values (117)	763	76.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20191208	1	0.1%
20191210	1	0.1%
20191216	1	0.1%
20191218	4	0.4%
20191219	2	0.2%
20191220	3	0.3%
20191222	1	0.1%
20191223	2	0.2%
20191224	1	0.1%
20191225	1	0.1%

Value	Count	Frequency (%)
20200513	1	0.1%
20200509	1	0.1%
20200508	2	0.2%
20200507	5	0.5%
20200506	1	0.1%
20200505	2	0.2%
20200504	3	0.3%
20200501	1	0.1%
20200430	1	0.1%
20200429	4	0.4%

TRNSFER_DY
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

20201027	1000

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	20201027
2nd row	20201027
3rd row	20201027
4th row	20201027
5th row	20201027

Common Values

Value	Count	Frequency (%)
20201027	1000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
20201027	1000	100.0%

LOAN_EXEC_DY
Real number (ℝ)

HIGH CORRELATION

Distinct	69
Distinct (%)	6.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20200464

Minimum	20200122
Maximum	20200522
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	20200122
5-th percentile	20200227
Q1	20200504
median	20200508
Q3	20200515
95-th percentile	20200520
Maximum	20200522
Range	400
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	94.097578
Coefficient of variation (CV)	4.6581888 × 10^-6
Kurtosis	1.7092956
Mean	20200464
Median Absolute Deviation (MAD)	7
Skewness	-1.738161
Sum	2.0200464 × 10¹⁰
Variance	8854.3543
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20200515	116	11.6%
20200508	105	10.5%
20200520	92	9.2%
20200511	78	7.8%
20200506	63	6.3%
20200512	57	5.7%
20200507	54	5.4%
20200504	54	5.4%
20200513	45	4.5%
20200518	40	4.0%
Other values (59)	296	29.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20200122	1	0.1%
20200130	1	0.1%
20200131	7	0.7%
20200203	1	0.1%
20200205	1	0.1%
20200207	5	0.5%
20200210	2	0.2%
20200211	2	0.2%
20200213	1	0.1%
20200214	2	0.2%

Value	Count	Frequency (%)
20200522	1	0.1%
20200520	92	9.2%
20200519	29	2.9%
20200518	40	4.0%
20200515	116	11.6%
20200514	39	3.9%
20200513	45	4.5%
20200512	57	5.7%
20200511	78	7.8%
20200508	105	10.5%

LOAN_EXPIRE_DY
Real number (ℝ)

Distinct	155
Distinct (%)	15.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20451164

Minimum	20300220
Maximum	20500520
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	20300220
5-th percentile	20300511
Q1	20400508
median	20500466
Q3	20500512
95-th percentile	20500520
Maximum	20500520
Range	200300
Interquartile range (IQR)	100004

Descriptive statistics

Standard deviation	72312.833
Coefficient of variation (CV)	0.0035358785
Kurtosis	-0.58410615
Mean	20451164
Median Absolute Deviation (MAD)	54
Skewness	-1.0070464
Sum	2.0451164 × 10¹⁰
Variance	5.2291458 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20500515	82	8.2%
20500508	64	6.4%
20500511	57	5.7%
20500520	56	5.6%
20500507	40	4.0%
20500506	39	3.9%
20500512	37	3.7%
20500504	37	3.7%
20500514	27	2.7%
20500518	23	2.3%
Other values (145)	538	53.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20300220	2	0.2%
20300227	2	0.2%
20300302	1	0.1%
20300306	1	0.1%
20300312	1	0.1%
20300313	1	0.1%
20300316	1	0.1%
20300317	1	0.1%
20300320	2	0.2%
20300327	1	0.1%

Value	Count	Frequency (%)
20500520	56	5.6%
20500519	15	1.5%
20500518	23	2.3%
20500515	82	8.2%
20500514	27	2.7%
20500513	23	2.3%
20500512	37	3.7%
20500511	57	5.7%
20500508	64	6.4%
20500507	40	4.0%

LOAN_AMT
Real number (ℝ)

HIGH CORRELATION

Distinct	240
Distinct (%)	24.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.51428 × 10⁸

Minimum	4000000
Maximum	3.13 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	4000000
5-th percentile	45000000
Q1	95000000
median	1.47 × 10⁸
Q3	2 × 10⁸
95-th percentile	2.861 × 10⁸
Maximum	3.13 × 10⁸
Range	3.09 × 10⁸
Interquartile range (IQR)	1.05 × 10⁸

Descriptive statistics

Standard deviation	71200634
Coefficient of variation (CV)	0.47019464
Kurtosis	-0.68915126
Mean	1.51428 × 10⁸
Median Absolute Deviation (MAD)	53000000
Skewness	0.26009934
Sum	1.51428 × 10¹¹
Variance	5.0695303 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200000000	43	4.3%
300000000	38	3.8%
100000000	33	3.3%
150000000	30	3.0%
140000000	25	2.5%
130000000	21	2.1%
70000000	20	2.0%
110000000	19	1.9%
80000000	19	1.9%
170000000	17	1.7%
Other values (230)	735	73.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4000000	1	0.1%
10000000	1	0.1%
15000000	1	0.1%
16000000	1	0.1%
17000000	1	0.1%
18000000	1	0.1%
19000000	1	0.1%
20000000	8	0.8%
25000000	2	0.2%
26000000	1	0.1%

Value	Count	Frequency (%)
313000000	1	0.1%
308000000	1	0.1%
300000000	38	3.8%
299000000	1	0.1%
298000000	2	0.2%
297000000	1	0.1%
292000000	2	0.2%
290000000	1	0.1%
289000000	1	0.1%
288000000	2	0.2%

INT_RAT
Real number (ℝ)

HIGH CORRELATION

Distinct	31
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.32244

Minimum	1.58
Maximum	2.63
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	1.58
5-th percentile	1.98
Q1	2.23
median	2.38
Q3	2.43
95-th percentile	2.53
Maximum	2.63
Range	1.05
Interquartile range (IQR)	0.2

Descriptive statistics

Standard deviation	0.17270632
Coefficient of variation (CV)	0.07436417
Kurtosis	2.2433029
Mean	2.32244
Median Absolute Deviation (MAD)	0.1
Skewness	-1.3377023
Sum	2322.44
Variance	0.029827474
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
2.43	323	32.3%
2.23	137	13.7%
2.38	104	10.4%
2.53	91	9.1%
2.28	74	7.4%
2.18	74	7.4%
2.03	31	3.1%
2.33	30	3.0%
2.48	22	2.2%
2.08	18	1.8%
Other values (21)	96	9.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.58	1	0.1%
1.63	5	0.5%
1.68	4	0.4%
1.78	10	1.0%
1.83	7	0.7%
1.88	5	0.5%
1.9	1	0.1%
1.93	4	0.4%
1.98	18	1.8%
2.03	31	3.1%

Value	Count	Frequency (%)
2.63	7	0.7%
2.58	3	0.3%
2.55	2	0.2%
2.53	91	9.1%
2.48	22	2.2%
2.45	10	1.0%
2.43	323	32.3%
2.4	3	0.3%
2.38	104	10.4%
2.33	30	3.0%

LOAN_RAMT
Real number (ℝ)

HIGH CORRELATION

Distinct	888
Distinct (%)	88.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.4835226 × 10⁸

Minimum	3933336
Maximum	3.104839 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	3933336
5-th percentile	41680480
Q1	92033337
median	1.423262 × 10⁸
Q3	1.9819411 × 10⁸
95-th percentile	2.8296706 × 10⁸
Maximum	3.104839 × 10⁸
Range	3.0655057 × 10⁸
Interquartile range (IQR)	1.0616077 × 10⁸

Descriptive statistics

Standard deviation	71190176
Coefficient of variation (CV)	0.47987253
Kurtosis	-0.68386
Mean	1.4835226 × 10⁸
Median Absolute Deviation (MAD)	54923894
Skewness	0.28469368
Sum	1.4835226 × 10¹¹
Variance	5.0680411 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
297746793	8	0.8%
138948503	5	0.5%
197345830	4	0.4%
96666668	4	0.4%
79399146	4	0.4%
119098717	4	0.4%
98135461	4	0.4%
98888892	4	0.4%
148873398	4	0.4%
198497862	3	0.3%
Other values (878)	956	95.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3933336	1	0.1%
9922285	1	0.1%
13340663	1	0.1%
14750000	1	0.1%
15466668	1	0.1%
16807472	1	0.1%
17462165	1	0.1%
18288861	1	0.1%
19256399	1	0.1%
19624125	1	0.1%

Value	Count	Frequency (%)
310483903	1	0.1%
307949048	1	0.1%
299953769	2	0.2%
299952924	2	0.2%
299952292	1	0.1%
299952076	2	0.2%
299951857	1	0.1%
299919327	1	0.1%
299917970	1	0.1%
299916299	1	0.1%

PAY_AMT
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

15000	1000

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	15000
2nd row	15000
3rd row	15000
4th row	15000
5th row	15000

Common Values

Value	Count	Frequency (%)
15000	1000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
15000	1000	100.0%

HOLD_CD
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

B004-2020-0099	839
B004-2020-0098	161

Length

Max length	14
Median length	14
Mean length	14
Min length	14

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	B004-2020-0099
2nd row	B004-2020-0099
3rd row	B004-2020-0099
4th row	B004-2020-0099
5th row	B004-2020-0099

Common Values

Value	Count	Frequency (%)
B004-2020-0099	839	83.9%
B004-2020-0098	161	16.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
b004-2020-0099	839	83.9%
b004-2020-0098	161	16.1%

MLTM_TRN_YN
Boolean

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 KiB

False	1000

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1000	100.0%

BANK_TRN_YN
Boolean

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 KiB

False	1000

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1000	100.0%

REG_ENO
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

1769	1000

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1769
2nd row	1769
3rd row	1769
4th row	1769
5th row	1769

Common Values

Value	Count	Frequency (%)
1769	1000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1769	1000	100.0%

REG_DT
Date

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

Minimum	2020-10-28 11:22:37
Maximum	2020-10-28 11:22:37

Histogram

Histogram with fixed size bins (bins=1)

Phik (φk)
Auto

Heatmap
Table

	LOAN_ACC_NO	APPRV_DY	LOAN_EXEC_DY	LOAN_EXPIRE_DY	LOAN_AMT	INT_RAT	LOAN_RAMT	HOLD_CD
LOAN_ACC_NO	1.000	0.377	0.343	0.117	0.263	0.340	0.263	0.646
APPRV_DY	0.377	1.000	0.701	0.203	0.297	0.123	0.292	0.147
LOAN_EXEC_DY	0.343	0.701	1.000	0.267	0.252	0.141	0.237	0.280
LOAN_EXPIRE_DY	0.117	0.203	0.267	1.000	0.482	0.848	0.498	0.068
LOAN_AMT	0.263	0.297	0.252	0.482	1.000	0.316	0.999	0.122
INT_RAT	0.340	0.123	0.141	0.848	0.316	1.000	0.315	0.835
LOAN_RAMT	0.263	0.292	0.237	0.498	0.999	0.315	1.000	0.101
HOLD_CD	0.646	0.147	0.280	0.068	0.122	0.835	0.101	1.000

Heatmap
Table

	LOAN_ACC_NO	APPRV_DY	LOAN_EXEC_DY	LOAN_EXPIRE_DY	LOAN_AMT	INT_RAT	LOAN_RAMT	HOLD_CD
LOAN_ACC_NO	1.000	0.000	-0.071	-0.033	-0.022	0.137	-0.026	0.499
APPRV_DY	0.000	1.000	0.640	0.249	-0.264	0.002	-0.255	0.101
LOAN_EXEC_DY	-0.071	0.640	1.000	0.426	-0.212	-0.066	-0.195	0.302
LOAN_EXPIRE_DY	-0.033	0.249	0.426	1.000	0.239	0.364	0.256	0.081
LOAN_AMT	-0.022	-0.264	-0.212	0.239	1.000	0.217	0.991	0.093
INT_RAT	0.137	0.002	-0.066	0.364	0.217	1.000	0.221	0.665
LOAN_RAMT	-0.026	-0.255	-0.195	0.256	0.991	0.221	1.000	0.078
HOLD_CD	0.499	0.101	0.302	0.081	0.093	0.665	0.078	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	LIQD_PLAN_CD	FEE_CD	EXPECT_DY	MNG_FEE_CD	LOAN_ACC_NO	APPRV_DY	TRNSFER_DY	LOAN_EXEC_DY	LOAN_EXPIRE_DY	LOAN_AMT	INT_RAT	LOAN_RAMT	PAY_AMT	HOLD_CD	MLTM_TRN_YN	BANK_TRN_YN	REG_ENO	REG_DT
0	KHFCMB2020S-34	B00417	20201120	6A	22640904049185	20200129	20201027	20200320	20500320	250000000	2.43	245833336	15000	B004-2020-0099	N	N	1769	2020/10/28 11:22:37
1	KHFCMB2020S-34	B00417	20201120	6A	67850901154669	20200318	20201027	20200515	20500515	165000000	2.43	163166668	15000	B004-2020-0099	N	N	1769	2020/10/28 11:22:37
2	KHFCMB2020S-34	B00417	20201120	6A	63650904033088	20200225	20201027	20200508	20500508	140000000	2.43	138948503	15000	B004-2020-0099	N	N	1769	2020/10/28 11:22:37
3	KHFCMB2020S-34	B00417	20201120	6A	21650904019004	20200208	20201027	20200325	20500325	145000000	2.43	142583338	15000	B004-2020-0099	N	N	1769	2020/10/28 11:22:37
4	KHFCMB2020S-34	B00417	20201120	6A	50100904027071	20200312	20201027	20200504	20300504	38000000	2.18	36416670	15000	B004-2020-0099	N	N	1769	2020/10/28 11:22:37
5	KHFCMB2020S-34	B00417	20201120	6A	53820904018891	20200329	20201027	20200511	20400511	162000000	2.38	159300000	15000	B004-2020-0099	N	N	1769	2020/10/28 11:22:37
6	KHFCMB2020S-34	B00417	20201120	6A	55860904031247	20200227	20201027	20200504	20350504	126000000	2.08	123008497	15000	B004-2020-0099	N	N	1769	2020/10/28 11:22:37
7	KHFCMB2020S-34	B00417	20201120	6A	1090904012201	20200319	20201027	20200508	20500508	300000000	2.43	299952076	15000	B004-2020-0099	N	N	1769	2020/10/28 11:22:37
8	KHFCMB2020S-34	B00417	20201120	6A	86190904030843	20200327	20201027	20200514	20500514	70000000	2.33	69465176	15000	B004-2020-0099	N	N	1769	2020/10/28 11:22:37
9	KHFCMB2020S-34	B00417	20201120	6A	81010904021456	20200312	20201027	20200515	20500515	163000000	2.43	161775758	15000	B004-2020-0099	N	N	1769	2020/10/28 11:22:37

	LIQD_PLAN_CD	FEE_CD	EXPECT_DY	MNG_FEE_CD	LOAN_ACC_NO	APPRV_DY	TRNSFER_DY	LOAN_EXEC_DY	LOAN_EXPIRE_DY	LOAN_AMT	INT_RAT	LOAN_RAMT	PAY_AMT	HOLD_CD	MLTM_TRN_YN	BANK_TRN_YN	REG_ENO	REG_DT
990	KHFCMB2020S-34	B00417	20201120	6A	42750904005814	20200307	20201027	20200511	20500511	80000000	2.43	79399146	15000	B004-2020-0099	N	N	1769	2020/10/28 11:22:37
991	KHFCMB2020S-34	B00417	20201120	6A	64220904021723	20200130	20201027	20200228	20500228	265000000	2.33	261406895	15000	B004-2020-0099	N	N	1769	2020/10/28 11:22:37
992	KHFCMB2020S-34	B00417	20201120	6A	40530904025845	20200330	20201027	20200519	20500519	78000000	2.05	77133336	15000	B004-2020-0099	N	N	1769	2020/10/28 11:22:37
993	KHFCMB2020S-34	B00417	20201120	6A	66950904005568	20200330	20201027	20200519	20500519	56000000	2.23	55377780	15000	B004-2020-0099	N	N	1769	2020/10/28 11:22:37
994	KHFCMB2020S-34	B00417	20201120	6A	48040904019751	20200309	20201027	20200508	20500508	212000000	2.43	210407733	15000	B004-2020-0099	N	N	1769	2020/10/28 11:22:37
995	KHFCMB2020S-34	B00417	20201120	6A	78030900024442	20200330	20201027	20200520	20300520	79000000	2.28	76651559	15000	B004-2020-0098	N	N	1769	2020/10/28 11:22:37
996	KHFCMB2020S-34	B00417	20201120	6A	81030900029201	20200309	20201027	20200511	20500511	234000000	2.43	230052037	15000	B004-2020-0099	N	N	1769	2020/10/28 11:22:37
997	KHFCMB2020S-34	B00417	20201120	6A	53260904020944	20200226	20201027	20200504	20500504	120000000	2.43	119098717	15000	B004-2020-0099	N	N	1769	2020/10/28 11:22:37
998	KHFCMB2020S-34	B00417	20201120	6A	77390901095405	20200306	20201027	20200508	20350508	187000000	2.28	183513310	15000	B004-2020-0099	N	N	1769	2020/10/28 11:22:37
999	KHFCMB2020S-34	B00417	20201120	6A	5810904019172	20200402	20201027	20200518	20300518	50000000	1.98	48490684	15000	B004-2020-0099	N	N	1769	2020/10/28 11:22:37

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample