gimi9 Pandas Profiling

Dataset statistics

Number of variables	17
Number of observations	1000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	23
Duplicate rows (%)	2.3%
Total size in memory	148.6 KiB
Average record size in memory	152.1 B

Variable types

Categorical	4
Numeric	13

Dataset

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

Alerts

`BASIS_MM` has constant value ""	Constant
`OPER_DY` has constant value ""	Constant
Dataset has 23 (2.3%) duplicate rows	Duplicates
`T07` is highly overall correlated with `T08` and 1 other fields	High correlation
`T08` is highly overall correlated with `T07` and 1 other fields	High correlation
`T09` is highly overall correlated with `T07` and 1 other fields	High correlation
`T10` is highly overall correlated with `T11`	High correlation
`T11` is highly overall correlated with `T10`	High correlation
`T14` is highly overall correlated with `T15` and 1 other fields	High correlation
`T15` is highly overall correlated with `T14` and 1 other fields	High correlation
`T16` is highly overall correlated with `T14` and 1 other fields	High correlation
`T12` is highly imbalanced (98.3%)	Imbalance
`T05` is highly skewed (γ1 = 29.91068345)	Skewed
`T07` is highly skewed (γ1 = 24.02790843)	Skewed
`T08` is highly skewed (γ1 = 25.61828575)	Skewed
`T09` is highly skewed (γ1 = 21.9651479)	Skewed
`T14` is highly skewed (γ1 = 30.50916908)	Skewed
`T15` is highly skewed (γ1 = 30.82602665)	Skewed
`T16` is highly skewed (γ1 = 30.22875795)	Skewed
`T03` has 225 (22.5%) zeros	Zeros
`T04` has 32 (3.2%) zeros	Zeros
`T05` has 985 (98.5%) zeros	Zeros
`T06` has 951 (95.1%) zeros	Zeros
`T07` has 968 (96.8%) zeros	Zeros
`T08` has 971 (97.1%) zeros	Zeros
`T09` has 970 (97.0%) zeros	Zeros
`T10` has 907 (90.7%) zeros	Zeros
`T11` has 876 (87.6%) zeros	Zeros
`T13` has 993 (99.3%) zeros	Zeros
`T14` has 994 (99.4%) zeros	Zeros
`T15` has 995 (99.5%) zeros	Zeros
`T16` has 994 (99.4%) zeros	Zeros

Reproduction

Analysis started	2023-12-11 23:44:37.273090
Analysis finished	2023-12-11 23:44:57.227130
Duration	19.95 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

LIQD_PLAN_CD
Categorical

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

KHFCMB2018S-20	804
KHFCMB2018S-19	196

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	KHFCMB2018S-20
2nd row	KHFCMB2018S-20
3rd row	KHFCMB2018S-20
4th row	KHFCMB2018S-20
5th row	KHFCMB2018S-20

Common Values

Value	Count	Frequency (%)
KHFCMB2018S-20	804	80.4%
KHFCMB2018S-19	196	19.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
khfcmb2018s-20	804	80.4%
khfcmb2018s-19	196	19.6%

BASIS_MM
Categorical

CONSTANT

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

201806	1000

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
201806	1000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
201806	1000	100.0%

T03
Real number (ℝ)

ZEROS

Distinct	657
Distinct (%)	65.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	264842.97

Minimum	0
Maximum	10500000
Zeros	225
Zeros (%)	22.5%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	30123
median	198587
Q3	365902.5
95-th percentile	780583.3
Maximum	10500000
Range	10500000
Interquartile range (IQR)	335779.5

Descriptive statistics

Standard deviation	419214
Coefficient of variation (CV)	1.5828776
Kurtosis	355.93236
Mean	264842.97
Median Absolute Deviation (MAD)	168427.5
Skewness	14.995603
Sum	2.6484297 × 10⁸
Variance	1.7574038 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	225	22.5%
555555	8	0.8%
833333	6	0.6%
150615	6	0.6%
500000	6	0.6%
458333	5	0.5%
305555	4	0.4%
75307	4	0.4%
135554	4	0.4%
105430	4	0.4%
Other values (647)	728	72.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	225	22.5%
1897	1	0.1%
1954	1	0.1%
2060	1	0.1%
6492	1	0.1%
11210	1	0.1%
13592	1	0.1%
13981	1	0.1%
14988	1	0.1%
15036	1	0.1%

Value	Count	Frequency (%)
10500000	1	0.1%
1888888	1	0.1%
1658333	1	0.1%
1468212	1	0.1%
1454768	1	0.1%
1450000	1	0.1%
1376224	1	0.1%
1322621	1	0.1%
1250000	1	0.1%
1216666	1	0.1%

T04
Real number (ℝ)

ZEROS

Distinct	879
Distinct (%)	87.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	297189.9

Minimum	0
Maximum	1369526
Zeros	32
Zeros (%)	3.2%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	19926.65
Q1	144245.25
median	278119.5
Q3	411613.75
95-th percentile	652213.95
Maximum	1369526
Range	1369526
Interquartile range (IQR)	267368.5

Descriptive statistics

Standard deviation	204938.19
Coefficient of variation (CV)	0.68958667
Kurtosis	3.632059
Mean	297189.9
Median Absolute Deviation (MAD)	133800.5
Skewness	1.3227131
Sum	2.971899 × 10⁸
Variance	4.1999662 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	32	3.2%
467123	10	1.0%
433150	7	0.7%
373698	6	0.6%
416164	6	0.6%
192500	4	0.4%
450136	4	0.4%
129452	3	0.3%
249698	3	0.3%
64166	3	0.3%
Other values (869)	922	92.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	32	3.2%
4054	1	0.1%
5725	1	0.1%
6164	1	0.1%
9870	1	0.1%
10144	1	0.1%
11866	1	0.1%
12194	1	0.1%
14219	1	0.1%
14230	1	0.1%

Value	Count	Frequency (%)
1369526	1	0.1%
1328116	1	0.1%
1281434	1	0.1%
1259977	1	0.1%
1239480	1	0.1%
1209849	1	0.1%
1181824	1	0.1%
1144452	1	0.1%
1122916	1	0.1%
1068438	1	0.1%

T05
Real number (ℝ)

SKEWED ZEROS

Distinct	15
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.829

Minimum	0
Maximum	1775
Zeros	985
Zeros (%)	98.5%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1775
Range	1775
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	57.21228
Coefficient of variation (CV)	20.2235
Kurtosis	924.38353
Mean	2.829
Median Absolute Deviation (MAD)	0
Skewness	29.910683
Sum	2829
Variance	3273.245
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
0	985	98.5%
64	2	0.2%
37	1	0.1%
20	1	0.1%
120	1	0.1%
76	1	0.1%
113	1	0.1%
75	1	0.1%
108	1	0.1%
2	1	0.1%
Other values (5)	5	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	985	98.5%
2	1	0.1%
15	1	0.1%
17	1	0.1%
20	1	0.1%
37	1	0.1%
64	2	0.2%
75	1	0.1%
76	1	0.1%
108	1	0.1%

Value	Count	Frequency (%)
1775	1	0.1%
234	1	0.1%
120	1	0.1%
113	1	0.1%
109	1	0.1%
108	1	0.1%
76	1	0.1%
75	1	0.1%
64	2	0.2%
37	1	0.1%

T06
Real number (ℝ)

ZEROS

Distinct	46
Distinct (%)	4.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.453

Minimum	0
Maximum	1107
Zeros	951
Zeros (%)	95.1%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1107
Range	1107
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	50.836543
Coefficient of variation (CV)	6.8209504
Kurtosis	244.16934
Mean	7.453
Median Absolute Deviation (MAD)	0
Skewness	13.453674
Sum	7453
Variance	2584.3541
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=46)

Value	Count	Frequency (%)
0	951	95.1%
115	2	0.2%
62	2	0.2%
131	2	0.2%
53	2	0.2%
16	1	0.1%
96	1	0.1%
92	1	0.1%
85	1	0.1%
225	1	0.1%
Other values (36)	36	3.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	951	95.1%
16	1	0.1%
27	1	0.1%
29	1	0.1%
35	1	0.1%
38	1	0.1%
42	1	0.1%
51	1	0.1%
52	1	0.1%
53	2	0.2%

Value	Count	Frequency (%)
1107	1	0.1%
563	1	0.1%
418	1	0.1%
391	1	0.1%
358	1	0.1%
271	1	0.1%
235	1	0.1%
225	1	0.1%
197	1	0.1%
187	1	0.1%

T07
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	24
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	184356.03

Minimum	0
Maximum	68000000
Zeros	968
Zeros (%)	96.8%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	68000000
Range	68000000
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2386555.5
Coefficient of variation (CV)	12.945362
Kurtosis	660.10528
Mean	184356.03
Median Absolute Deviation (MAD)	0
Skewness	24.027908
Sum	1.8435603 × 10⁸
Variance	5.695647 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
0	968	96.8%
10000000	6	0.6%
3000000	4	0.4%
1000000	2	0.2%
5000000	1	0.1%
1480000	1	0.1%
170392	1	0.1%
500000	1	0.1%
920000	1	0.1%
600000	1	0.1%
Other values (14)	14	1.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	968	96.8%
6400	1	0.1%
100000	1	0.1%
170392	1	0.1%
200000	1	0.1%
399238	1	0.1%
440000	1	0.1%
500000	1	0.1%
600000	1	0.1%
700000	1	0.1%

Value	Count	Frequency (%)
68000000	1	0.1%
20000000	1	0.1%
10000000	6	0.6%
5000000	1	0.1%
4500000	1	0.1%
3000000	4	0.4%
2140000	1	0.1%
2000000	1	0.1%
1480000	1	0.1%
1300000	1	0.1%

T08
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	30
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	185.156

Minimum	0
Maximum	81972
Zeros	971
Zeros (%)	97.1%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	81972
Range	81972
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2817.2726
Coefficient of variation (CV)	15.21567
Kurtosis	721.61976
Mean	185.156
Median Absolute Deviation (MAD)	0
Skewness	25.618286
Sum	185156
Variance	7937025.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
0	971	97.1%
19	1	0.1%
4430	1	0.1%
27424	1	0.1%
2653	1	0.1%
7134	1	0.1%
12216	1	0.1%
43	1	0.1%
128	1	0.1%
5657	1	0.1%
Other values (20)	20	2.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	971	97.1%
5	1	0.1%
19	1	0.1%
43	1	0.1%
128	1	0.1%
196	1	0.1%
203	1	0.1%
316	1	0.1%
492	1	0.1%
522	1	0.1%

Value	Count	Frequency (%)
81972	1	0.1%
27424	1	0.1%
12216	1	0.1%
8321	1	0.1%
8219	1	0.1%
7191	1	0.1%
7134	1	0.1%
5657	1	0.1%
4430	1	0.1%
4109	1	0.1%

T09
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	30
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2202.32

Minimum	0
Maximum	714744
Zeros	970
Zeros (%)	97.0%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	714744
Range	714744
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	26034.672
Coefficient of variation (CV)	11.821475
Kurtosis	571.5115
Mean	2202.32
Median Absolute Deviation (MAD)	0
Skewness	21.965148
Sum	2202320
Variance	6.7780414 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
0	970	97.0%
119124	2	0.2%
2189	1	0.1%
35540	1	0.1%
117153	1	0.1%
16982	1	0.1%
108503	1	0.1%
1923	1	0.1%
5644	1	0.1%
115839	1	0.1%
Other values (20)	20	2.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	970	97.0%
75	1	0.1%
1167	1	0.1%
1923	1	0.1%
2189	1	0.1%
5246	1	0.1%
5644	1	0.1%
6917	1	0.1%
9477	1	0.1%
10526	1	0.1%

Value	Count	Frequency (%)
714744	1	0.1%
234963	1	0.1%
136488	1	0.1%
119890	1	0.1%
119124	2	0.2%
117153	1	0.1%
115839	1	0.1%
108503	1	0.1%
59507	1	0.1%
59287	1	0.1%

T10
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	93
Distinct (%)	9.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31624.387

Minimum	0
Maximum	1658333
Zeros	907
Zeros (%)	90.7%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	261527.65
Maximum	1658333
Range	1658333
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	130739.07
Coefficient of variation (CV)	4.134122
Kurtosis	49.077395
Mean	31624.387
Median Absolute Deviation (MAD)	0
Skewness	6.0541045
Sum	31624387
Variance	1.7092706 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	907	90.7%
416666	2	0.2%
848455	1	0.1%
295050	1	0.1%
293061	1	0.1%
555555	1	0.1%
490008	1	0.1%
1658333	1	0.1%
383266	1	0.1%
13981	1	0.1%
Other values (83)	83	8.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	907	90.7%
13981	1	0.1%
14988	1	0.1%
17716	1	0.1%
22196	1	0.1%
22948	1	0.1%
44678	1	0.1%
47639	1	0.1%
52715	1	0.1%
59190	1	0.1%

Value	Count	Frequency (%)
1658333	1	0.1%
1468212	1	0.1%
900000	1	0.1%
848455	1	0.1%
791666	1	0.1%
777777	1	0.1%
750000	1	0.1%
716666	1	0.1%
703941	1	0.1%
666666	1	0.1%

T11
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	118
Distinct (%)	11.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38684.336

Minimum	0
Maximum	1239480
Zeros	876
Zeros (%)	87.6%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	341745
Maximum	1239480
Range	1239480
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	123278.66
Coefficient of variation (CV)	3.1867849
Kurtosis	19.868632
Mean	38684.336
Median Absolute Deviation (MAD)	0
Skewness	3.9961908
Sum	38684336
Variance	1.5197628 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	876	87.6%
249698	3	0.3%
467123	3	0.3%
238232	2	0.2%
50342	2	0.2%
450136	2	0.2%
501435	1	0.1%
413123	1	0.1%
582689	1	0.1%
677574	1	0.1%
Other values (108)	108	10.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	876	87.6%
31372	1	0.1%
31892	1	0.1%
33226	1	0.1%
41205	1	0.1%
46519	1	0.1%
48125	1	0.1%
49315	1	0.1%
50342	2	0.2%
76438	1	0.1%

Value	Count	Frequency (%)
1239480	1	0.1%
909095	1	0.1%
861814	1	0.1%
735342	1	0.1%
732534	1	0.1%
677574	1	0.1%
653581	1	0.1%
633610	1	0.1%
582689	1	0.1%
563315	1	0.1%

T12
Categorical

IMBALANCE

Distinct	4
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

0	997
20	1
120	1
109	1

Length

Max length	3
Median length	1
Mean length	1.005
Min length	1

Unique

Unique	3 ?
Unique (%)	0.3%

Sample

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

Common Values

Value	Count	Frequency (%)
0	997	99.7%
20	1	0.1%
120	1	0.1%
109	1	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	997	99.7%
20	1	0.1%
120	1	0.1%
109	1	0.1%

T13
Real number (ℝ)

ZEROS

Distinct	8
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.647

Minimum	0
Maximum	187
Zeros	993
Zeros (%)	99.3%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	187
Range	187
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	8.6457585
Coefficient of variation (CV)	13.362842
Kurtosis	279.7853
Mean	0.647
Median Absolute Deviation (MAD)	0
Skewness	15.785321
Sum	647
Variance	74.74914
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	993	99.3%
115	1	0.1%
63	1	0.1%
62	1	0.1%
187	1	0.1%
97	1	0.1%
29	1	0.1%
94	1	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	993	99.3%
29	1	0.1%
62	1	0.1%
63	1	0.1%
94	1	0.1%
97	1	0.1%
115	1	0.1%
187	1	0.1%

Value	Count	Frequency (%)
187	1	0.1%
115	1	0.1%
97	1	0.1%
94	1	0.1%
63	1	0.1%
62	1	0.1%
29	1	0.1%
0	993	99.3%

T14
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	7
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	85040

Minimum	0
Maximum	68000000
Zeros	994
Zeros (%)	99.4%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	68000000
Range	68000000
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2178110.6
Coefficient of variation (CV)	25.612778
Kurtosis	949.32645
Mean	85040
Median Absolute Deviation (MAD)	0
Skewness	30.509169
Sum	85040000
Variance	4.744166 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	994	99.4%
4500000	1	0.1%
10000000	1	0.1%
440000	1	0.1%
68000000	1	0.1%
1100000	1	0.1%
1000000	1	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	994	99.4%
440000	1	0.1%
1000000	1	0.1%
1100000	1	0.1%
4500000	1	0.1%
10000000	1	0.1%
68000000	1	0.1%

Value	Count	Frequency (%)
68000000	1	0.1%
10000000	1	0.1%
4500000	1	0.1%
1100000	1	0.1%
1000000	1	0.1%
440000	1	0.1%
0	994	99.4%

T15
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	6
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	99.104

Minimum	0
Maximum	81972
Zeros	995
Zeros (%)	99.5%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	81972
Range	81972
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2615.2295
Coefficient of variation (CV)	26.388738
Kurtosis	964.45078
Mean	99.104
Median Absolute Deviation (MAD)	0
Skewness	30.826027
Sum	99104
Variance	6839425.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	995	99.5%
8321	1	0.1%
7191	1	0.1%
81972	1	0.1%
203	1	0.1%
1417	1	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	995	99.5%
203	1	0.1%
1417	1	0.1%
7191	1	0.1%
8321	1	0.1%
81972	1	0.1%

Value	Count	Frequency (%)
81972	1	0.1%
8321	1	0.1%
7191	1	0.1%
1417	1	0.1%
203	1	0.1%
0	995	99.5%

T16
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	7
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	916.436

Minimum	0
Maximum	714744
Zeros	994
Zeros (%)	99.4%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	714744
Range	714744
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	22975.64
Coefficient of variation (CV)	25.070643
Kurtosis	936.03208
Mean	916.436
Median Absolute Deviation (MAD)	0
Skewness	30.228758
Sum	916436
Variance	5.2788003 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	994	99.4%
53113	1	0.1%
119124	1	0.1%
5246	1	0.1%
714744	1	0.1%
12790	1	0.1%
11419	1	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	994	99.4%
5246	1	0.1%
11419	1	0.1%
12790	1	0.1%
53113	1	0.1%
119124	1	0.1%
714744	1	0.1%

Value	Count	Frequency (%)
714744	1	0.1%
119124	1	0.1%
53113	1	0.1%
12790	1	0.1%
11419	1	0.1%
5246	1	0.1%
0	994	99.4%

OPER_DY
Categorical

CONSTANT

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

20180928	1000

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
20180928	1000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
20180928	1000	100.0%

Heatmap
Table

	LIQD_PLAN_CD	T03	T04	T05	T06	T07	T08	T09	T10	T11	T12	T13	T14	T15	T16
LIQD_PLAN_CD	1.000	0.000	0.177	0.029	0.095	0.000	0.069	0.000	0.000	0.041	0.000	0.000	0.000	0.000	0.000
T03	0.000	1.000	0.272	0.000	0.000	0.000	0.000	0.000	0.358	0.000	0.000	0.000	0.000	0.000	0.000
T04	0.177	0.272	1.000	0.454	0.000	0.000	0.000	0.051	0.154	0.589	0.000	0.000	0.000	0.000	0.000
T05	0.029	0.000	0.454	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
T06	0.095	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.368	0.000	0.000	0.000
T07	0.000	0.000	0.000	0.000	0.000	1.000	0.956	1.000	0.000	0.000	0.000	0.000	0.721	0.675	0.721
T08	0.069	0.000	0.000	0.000	0.000	0.956	1.000	0.954	0.000	0.000	0.000	0.000	0.675	0.763	0.675
T09	0.000	0.000	0.051	0.000	0.000	1.000	0.954	1.000	0.000	0.000	0.000	0.000	0.715	0.675	0.715
T10	0.000	0.358	0.154	0.000	0.000	0.000	0.000	0.000	1.000	0.632	0.286	0.507	0.000	0.000	0.000
T11	0.041	0.000	0.589	0.000	0.000	0.000	0.000	0.000	0.632	1.000	0.175	0.418	0.000	0.000	0.000
T12	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.286	0.175	1.000	0.000	0.000	0.000	0.000
T13	0.000	0.000	0.000	0.000	0.368	0.000	0.000	0.000	0.507	0.418	0.000	1.000	0.000	0.000	0.000
T14	0.000	0.000	0.000	0.000	0.000	0.721	0.675	0.715	0.000	0.000	0.000	0.000	1.000	0.943	1.000
T15	0.000	0.000	0.000	0.000	0.000	0.675	0.763	0.675	0.000	0.000	0.000	0.000	0.943	1.000	0.943
T16	0.000	0.000	0.000	0.000	0.000	0.721	0.675	0.715	0.000	0.000	0.000	0.000	1.000	0.943	1.000

Heatmap
Table

	T12	LIQD_PLAN_CD
T12	1.000	0.000
LIQD_PLAN_CD	0.000	1.000

Heatmap
Table

	T03	T04	T05	T06	T07	T08	T09	T10	T11	T13	T14	T15	T16	LIQD_PLAN_CD	T12
T03	1.000	0.343	0.004	-0.048	-0.245	-0.233	-0.237	0.147	-0.001	-0.046	-0.105	-0.096	-0.105	0.000	0.000
T04	0.343	1.000	-0.058	0.048	-0.305	-0.290	-0.295	0.031	0.060	0.004	-0.130	-0.119	-0.130	0.135	0.000
T05	0.004	-0.058	1.000	0.008	-0.022	-0.021	-0.022	0.043	0.027	-0.010	-0.010	-0.009	-0.010	0.048	0.000
T06	-0.048	0.048	0.008	1.000	-0.041	-0.039	-0.040	-0.010	0.012	0.366	-0.018	-0.016	-0.018	0.068	0.000
T07	-0.245	-0.305	-0.022	-0.041	1.000	0.952	0.967	-0.058	-0.068	-0.015	0.430	0.394	0.430	0.000	0.000
T08	-0.233	-0.290	-0.021	-0.039	0.952	1.000	0.914	-0.055	-0.065	-0.015	0.376	0.414	0.376	0.046	0.000
T09	-0.237	-0.295	-0.022	-0.040	0.967	0.914	1.000	-0.056	-0.066	-0.015	0.443	0.406	0.443	0.000	0.000
T10	0.147	0.031	0.043	-0.010	-0.058	-0.055	-0.056	1.000	0.848	0.135	-0.025	-0.023	-0.025	0.000	0.131
T11	-0.001	0.060	0.027	0.012	-0.068	-0.065	-0.066	0.848	1.000	0.221	-0.029	-0.027	-0.029	0.040	0.112
T13	-0.046	0.004	-0.010	0.366	-0.015	-0.015	-0.015	0.135	0.221	1.000	-0.007	-0.006	-0.007	0.000	0.000
T14	-0.105	-0.130	-0.010	-0.018	0.430	0.376	0.443	-0.025	-0.029	-0.007	1.000	0.913	1.000	0.000	0.000
T15	-0.096	-0.119	-0.009	-0.016	0.394	0.414	0.406	-0.023	-0.027	-0.006	0.913	1.000	0.913	0.000	0.000
T16	-0.105	-0.130	-0.010	-0.018	0.430	0.376	0.443	-0.025	-0.029	-0.007	1.000	0.913	1.000	0.000	0.000
LIQD_PLAN_CD	0.000	0.135	0.048	0.068	0.000	0.046	0.000	0.000	0.040	0.000	0.000	0.000	0.000	1.000	0.000
T12	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.131	0.112	0.000	0.000	0.000	0.000	0.000	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	BASIS_MM	T03	T04	T05	T10	T11	OPER_DY
0	KHFCMB2018S-20	201806	420000	163493	0	420000	163493	20180928
1	KHFCMB2018S-20	201806	980000	1144452	0	0	0	20180928
2	KHFCMB2018S-20	201806	0	96250	0	0	0	20180928
3	KHFCMB2018S-20	201806	76678	126088	0	0	0	20180928
4	KHFCMB2018S-20	201806	73691	36770	0	0	0	20180928
5	KHFCMB2018S-20	201806	275968	4054	0	0	0	20180928
6	KHFCMB2018S-20	201806	127572	219486	0	0	0	20180928
7	KHFCMB2018S-20	201806	68891	145449	0	0	0	20180928
8	KHFCMB2018S-20	201806	120492	82191	37	0	0	20180928
9	KHFCMB2018S-20	201806	196839	39747	0	0	0	20180928

	LIQD_PLAN_CD	BASIS_MM	T03	T04	OPER_DY
990	KHFCMB2018S-19	201806	305555	359684	20180928
991	KHFCMB2018S-19	201806	583333	659546	20180928
992	KHFCMB2018S-19	201806	192367	417083	20180928
993	KHFCMB2018S-19	201806	128738	279125	20180928
994	KHFCMB2018S-19	201806	517912	1122916	20180928
995	KHFCMB2018S-19	201806	305015	621216	20180928
996	KHFCMB2018S-19	201806	108280	220532	20180928
997	KHFCMB2018S-19	201806	224922	487666	20180928
998	KHFCMB2018S-19	201806	55455	64166	20180928
999	KHFCMB2018S-19	201806	504974	931878	20180928

Most frequently occurring

	LIQD_PLAN_CD	BASIS_MM	T03	T04	OPER_DY	# duplicates
10	KHFCMB2018S-20	201806	0	433150	20180928	6
12	KHFCMB2018S-20	201806	0	467123	20180928	6
9	KHFCMB2018S-20	201806	0	416164	20180928	5
6	KHFCMB2018S-20	201806	0	373698	20180928	4
16	KHFCMB2018S-20	201806	150615	102739	20180928	3
0	KHFCMB2018S-19	201806	29595	64166	20180928	2
1	KHFCMB2018S-19	201806	133177	288750	20180928	2
2	KHFCMB2018S-19	201806	342252	160416	20180928	2
3	KHFCMB2018S-20	201806	0	239506	20180928	2
4	KHFCMB2018S-20	201806	0	303205	20180928	2

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)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring