Dataset statistics
Number of variables | 3 |
---|---|
Number of observations | 144 |
Missing cells | 121 |
Missing cells (%) | 28.0% |
Duplicate rows | 4 |
Duplicate rows (%) | 2.8% |
Total size in memory | 3.6 KiB |
Average record size in memory | 25.9 B |
Variable types
Categorical | 2 |
---|---|
Numeric | 1 |
Dataset
Description | 공단이 보유한 퇴직연금기록괸라시스템DB자료(퇴직연금사업장운용현황)2019.08.입니다._통화코드국가코드은행코드공식익률 등 |
---|---|
Author | 근로복지공단 |
URL | https://www.data.go.kr/data/15051514/fileData.do |
Dataset has 4 (2.8%) duplicate rows | Duplicates |
공시수익률_기준일자 is highly overall correlated with 장기수수료할인기본_적용시작일자 | High correlation |
장기수수료할인기본_적용시작일자 is highly overall correlated with 공시수익률_기준일자 | High correlation |
공시수익률_기준일자 is highly imbalanced (52.4%) | Imbalance |
장기수수료할인기본_적용시작일자 is highly imbalanced (59.6%) | Imbalance |
공시수익률_공시수익률 has 121 (84.0%) missing values | Missing |
공시수익률_공시수익률 has 8 (5.6%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-12 23:15:12.862532 |
---|---|
Analysis finished | 2023-12-12 23:15:13.199899 |
Duration | 0.34 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
공시수익률_기준일자
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 3 |
---|---|
Distinct (%) | 2.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.3 KiB |
<NA> | |
---|---|
2016-12-31 | |
2017-03-31 | 5 |
Length
Max length | 10 |
---|---|
Median length | 4 |
Mean length | 4.9583333 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2016-12-31 |
---|---|
2nd row | 2016-12-31 |
3rd row | 2016-12-31 |
4th row | 2016-12-31 |
5th row | 2016-12-31 |
Common Values
Value | Count | Frequency (%) |
<NA> | 121 | |
2016-12-31 | 18 | 12.5% |
2017-03-31 | 5 | 3.5% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
na | 121 | |
2016-12-31 | 18 | 12.5% |
2017-03-31 | 5 | 3.5% |
공시수익률_공시수익률
Real number (ℝ)
MISSING
  ZEROS
 
Distinct | 12 |
---|---|
Distinct (%) | 52.2% |
Missing | 121 |
Missing (%) | 84.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 0.18695652 |
Minimum | -2.62 |
---|---|
Maximum | 2.53 |
Zeros | 8 |
Zeros (%) | 5.6% |
Negative | 6 |
Negative (%) | 4.2% |
Memory size | 1.4 KiB |
Quantile statistics
Minimum | -2.62 |
---|---|
5-th percentile | -1.8 |
Q1 | -0.155 |
median | 0 |
Q3 | 0.41 |
95-th percentile | 2.324 |
Maximum | 2.53 |
Range | 5.15 |
Interquartile range (IQR) | 0.565 |
Descriptive statistics
Standard deviation | 1.2338684 |
---|---|
Coefficient of variation (CV) | 6.5997612 |
Kurtosis | 0.53771919 |
Mean | 0.18695652 |
Median Absolute Deviation (MAD) | 0.39 |
Skewness | -0.036254429 |
Sum | 4.3 |
Variance | 1.5224312 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0.0 | 8 | 5.6% |
-1.08 | 2 | 1.4% |
0.41 | 2 | 1.4% |
-0.31 | 2 | 1.4% |
1.73 | 2 | 1.4% |
0.39 | 1 | 0.7% |
-1.88 | 1 | 0.7% |
1.63 | 1 | 0.7% |
-2.62 | 1 | 0.7% |
0.36 | 1 | 0.7% |
Other values (2) | 2 | 1.4% |
(Missing) | 121 |
Value | Count | Frequency (%) |
-2.62 | 1 | 0.7% |
-1.88 | 1 | 0.7% |
-1.08 | 2 | 1.4% |
-0.31 | 2 | 1.4% |
0.0 | 8 | |
0.36 | 1 | 0.7% |
0.39 | 1 | 0.7% |
0.41 | 2 | 1.4% |
1.63 | 1 | 0.7% |
1.73 | 2 | 1.4% |
Value | Count | Frequency (%) |
2.53 | 1 | 0.7% |
2.39 | 1 | 0.7% |
1.73 | 2 | 1.4% |
1.63 | 1 | 0.7% |
0.41 | 2 | 1.4% |
0.39 | 1 | 0.7% |
0.36 | 1 | 0.7% |
0.0 | 8 | |
-0.31 | 2 | 1.4% |
-1.08 | 2 | 1.4% |
장기수수료할인기본_적용시작일자
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 5 |
---|---|
Distinct (%) | 3.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.3 KiB |
<NA> | |
---|---|
2015-09-15 | 9 |
2015-09-01 | 6 |
2018-07-01 | 4 |
2018-07-02 | 4 |
Length
Max length | 10 |
---|---|
Median length | 4 |
Mean length | 4.9583333 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2015-09-15 |
---|---|
2nd row | 2015-09-01 |
3rd row | 2015-09-01 |
4th row | 2015-09-15 |
5th row | 2015-09-01 |
Common Values
Value | Count | Frequency (%) |
<NA> | 121 | |
2015-09-15 | 9 | 6.2% |
2015-09-01 | 6 | 4.2% |
2018-07-01 | 4 | 2.8% |
2018-07-02 | 4 | 2.8% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
na | 121 | |
2015-09-15 | 9 | 6.2% |
2015-09-01 | 6 | 4.2% |
2018-07-01 | 4 | 2.8% |
2018-07-02 | 4 | 2.8% |
공시수익률_기준일자 | 공시수익률_공시수익률 | 장기수수료할인기본_적용시작일자 | |
---|---|---|---|
공시수익률_기준일자 | 1.000 | 0.440 | 0.983 |
공시수익률_공시수익률 | 0.440 | 1.000 | 0.000 |
장기수수료할인기본_적용시작일자 | 0.983 | 0.000 | 1.000 |
공시수익률_기준일자 | 장기수수료할인기본_적용시작일자 | |
---|---|---|
공시수익률_기준일자 | 1.000 | 0.839 |
장기수수료할인기본_적용시작일자 | 0.839 | 1.000 |
공시수익률_공시수익률 | 공시수익률_기준일자 | 장기수수료할인기본_적용시작일자 | |
---|---|---|---|
공시수익률_공시수익률 | 1.000 | 0.399 | 0.000 |
공시수익률_기준일자 | 0.399 | 1.000 | 0.839 |
장기수수료할인기본_적용시작일자 | 0.000 | 0.839 | 1.000 |
공시수익률_기준일자 | 공시수익률_공시수익률 | 장기수수료할인기본_적용시작일자 | |
---|---|---|---|
0 | 2016-12-31 | 0.39 | 2015-09-15 |
1 | 2016-12-31 | 0.0 | 2015-09-01 |
2 | 2016-12-31 | -1.08 | 2015-09-01 |
3 | 2016-12-31 | 0.0 | 2015-09-15 |
4 | 2016-12-31 | -1.88 | 2015-09-01 |
5 | 2016-12-31 | 0.41 | 2015-09-15 |
6 | 2016-12-31 | 0.41 | 2015-09-15 |
7 | 2016-12-31 | 0.0 | 2015-09-15 |
8 | 2016-12-31 | -1.08 | 2015-09-15 |
9 | 2016-12-31 | 1.63 | 2015-09-01 |
공시수익률_기준일자 | 공시수익률_공시수익률 | 장기수수료할인기본_적용시작일자 | |
---|---|---|---|
134 | <NA> | <NA> | <NA> |
135 | <NA> | <NA> | <NA> |
136 | <NA> | <NA> | <NA> |
137 | <NA> | <NA> | <NA> |
138 | <NA> | <NA> | <NA> |
139 | <NA> | <NA> | <NA> |
140 | <NA> | <NA> | <NA> |
141 | <NA> | <NA> | <NA> |
142 | <NA> | <NA> | <NA> |
143 | <NA> | <NA> | <NA> |
Most frequently occurring
공시수익률_기준일자 | 공시수익률_공시수익률 | 장기수수료할인기본_적용시작일자 | # duplicates | |
---|---|---|---|---|
3 | <NA> | <NA> | <NA> | 121 |
0 | 2016-12-31 | 0.0 | 2015-09-15 | 4 |
1 | 2016-12-31 | 0.41 | 2015-09-15 | 2 |
2 | 2017-03-31 | 0.0 | 2018-07-02 | 2 |