Dataset statistics
Number of variables | 6 |
---|---|
Number of observations | 499 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 25.0 KiB |
Average record size in memory | 51.3 B |
Variable types
Categorical | 2 |
---|---|
Numeric | 3 |
DateTime | 1 |
Dataset
Description | 한국주택금융공사 주택연금부 업무 보증번호 관련 공개 공공데이터 (해당 부서의 업무와 관련된 데이터베이스에서 공개 가능한 원천 데이터) |
---|---|
Author | 한국주택금융공사 |
URL | https://www.data.go.kr/data/15072883/fileData.do |
Reproduction
Analysis started | 2023-12-12 04:07:27.386303 |
---|---|
Analysis finished | 2023-12-12 04:07:29.318548 |
Duration | 1.93 second |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
SYS_DVCD
Categorical
Distinct | 2 |
---|---|
Distinct (%) | 0.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 4.0 KiB |
R | |
---|---|
K |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | K |
---|---|
2nd row | K |
3rd row | R |
4th row | K |
5th row | R |
Common Values
Value | Count | Frequency (%) |
R | 258 | |
K | 241 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
r | 258 | |
k | 241 |
BRCD
Categorical
HIGH CORRELATION
 
Distinct | 28 |
---|---|
Distinct (%) | 5.6% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 4.0 KiB |
TAA | 28 |
---|---|
TBA | 28 |
TNA | 28 |
TJA | 28 |
TMA | 28 |
Other values (23) |
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 3 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | TMB |
---|---|
2nd row | TQC |
3rd row | TQC |
4th row | TOB |
5th row | ABN |
Common Values
Value | Count | Frequency (%) |
TAA | 28 | 5.6% |
TBA | 28 | 5.6% |
TNA | 28 | 5.6% |
TJA | 28 | 5.6% |
TMA | 28 | 5.6% |
THA | 28 | 5.6% |
QAD | 28 | 5.6% |
TPA | 28 | 5.6% |
THO | 27 | 5.4% |
TRA | 26 | 5.2% |
Other values (18) | 222 |
Length
Value | Count | Frequency (%) |
taa | 28 | 5.6% |
tba | 28 | 5.6% |
tna | 28 | 5.6% |
tja | 28 | 5.6% |
tma | 28 | 5.6% |
tha | 28 | 5.6% |
qad | 28 | 5.6% |
tpa | 28 | 5.6% |
tho | 27 | 5.4% |
tra | 26 | 5.2% |
Other values (18) | 222 |
ACPT_YR
Real number (ℝ)
Distinct | 14 |
---|---|
Distinct (%) | 2.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2014.5411 |
Minimum | 2007 |
---|---|
Maximum | 2020 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.5 KiB |
Quantile statistics
Minimum | 2007 |
---|---|
5-th percentile | 2008 |
Q1 | 2011 |
median | 2015 |
Q3 | 2018 |
95-th percentile | 2020 |
Maximum | 2020 |
Range | 13 |
Interquartile range (IQR) | 7 |
Descriptive statistics
Standard deviation | 3.8843491 |
---|---|
Coefficient of variation (CV) | 0.0019281558 |
Kurtosis | -1.0330498 |
Mean | 2014.5411 |
Median Absolute Deviation (MAD) | 3 |
Skewness | -0.30155056 |
Sum | 1005256 |
Variance | 15.088168 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
2020 | 51 | |
2019 | 50 | |
2016 | 43 | |
2018 | 42 | |
2017 | 41 | |
2015 | 41 | |
2013 | 38 | 7.6% |
2014 | 37 | 7.4% |
2012 | 30 | 6.0% |
2010 | 30 | 6.0% |
Other values (4) | 96 |
Value | Count | Frequency (%) |
2007 | 21 | |
2008 | 22 | |
2009 | 24 | |
2010 | 30 | |
2011 | 29 | |
2012 | 30 | |
2013 | 38 | |
2014 | 37 | |
2015 | 41 | |
2016 | 43 |
Value | Count | Frequency (%) |
2020 | 51 | |
2019 | 50 | |
2018 | 42 | |
2017 | 41 | |
2016 | 43 | |
2015 | 41 | |
2014 | 37 | |
2013 | 38 | |
2012 | 30 | |
2011 | 29 |
SEQ
Real number (ℝ)
Distinct | 317 |
---|---|
Distinct (%) | 63.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 252.05611 |
Minimum | 1 |
---|---|
Maximum | 1249 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.5 KiB |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 6 |
Q1 | 40 |
median | 128 |
Q3 | 351.5 |
95-th percentile | 931.6 |
Maximum | 1249 |
Range | 1248 |
Interquartile range (IQR) | 311.5 |
Descriptive statistics
Standard deviation | 291.09767 |
---|---|
Coefficient of variation (CV) | 1.1548923 |
Kurtosis | 1.2770843 |
Mean | 252.05611 |
Median Absolute Deviation (MAD) | 104 |
Skewness | 1.4678679 |
Sum | 125776 |
Variance | 84737.852 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1 | 9 | 1.8% |
6 | 7 | 1.4% |
27 | 7 | 1.4% |
33 | 7 | 1.4% |
2 | 6 | 1.2% |
3 | 5 | 1.0% |
9 | 5 | 1.0% |
21 | 5 | 1.0% |
45 | 5 | 1.0% |
60 | 5 | 1.0% |
Other values (307) | 438 |
Value | Count | Frequency (%) |
1 | 9 | |
2 | 6 | |
3 | 5 | |
4 | 4 | |
6 | 7 | |
7 | 2 | 0.4% |
8 | 2 | 0.4% |
9 | 5 | |
10 | 3 | 0.6% |
12 | 1 | 0.2% |
Value | Count | Frequency (%) |
1249 | 1 | |
1215 | 1 | |
1214 | 1 | |
1189 | 1 | |
1121 | 1 | |
1113 | 1 | |
1107 | 1 | |
1101 | 1 | |
1088 | 1 | |
1055 | 1 |
REG_ENO
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 179 |
---|---|
Distinct (%) | 35.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 5689.3988 |
Minimum | 1003 |
---|---|
Maximum | 52046 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.5 KiB |
Quantile statistics
Minimum | 1003 |
---|---|
5-th percentile | 1151.6 |
Q1 | 1660 |
median | 7311 |
Q3 | 7510 |
95-th percentile | 7567 |
Maximum | 52046 |
Range | 51043 |
Interquartile range (IQR) | 5850 |
Descriptive statistics
Standard deviation | 3964.1186 |
---|---|
Coefficient of variation (CV) | 0.69675527 |
Kurtosis | 73.004707 |
Mean | 5689.3988 |
Median Absolute Deviation (MAD) | 256 |
Skewness | 6.0975173 |
Sum | 2839010 |
Variance | 15714236 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
7510 | 16 | 3.2% |
7462 | 11 | 2.2% |
7457 | 10 | 2.0% |
7564 | 10 | 2.0% |
7486 | 10 | 2.0% |
7313 | 9 | 1.8% |
7311 | 9 | 1.8% |
7538 | 9 | 1.8% |
7375 | 8 | 1.6% |
7536 | 8 | 1.6% |
Other values (169) | 399 |
Value | Count | Frequency (%) |
1003 | 1 | |
1009 | 1 | |
1053 | 1 | |
1071 | 1 | |
1088 | 2 | |
1095 | 1 | |
1096 | 2 | |
1104 | 1 | |
1115 | 1 | |
1119 | 1 |
Value | Count | Frequency (%) |
52046 | 1 | 0.2% |
51915 | 1 | 0.2% |
7645 | 1 | 0.2% |
7621 | 2 | 0.4% |
7620 | 1 | 0.2% |
7592 | 2 | 0.4% |
7589 | 5 | |
7588 | 2 | 0.4% |
7586 | 1 | 0.2% |
7583 | 2 | 0.4% |
REG_TS
Date
UNIQUE
 
Distinct | 499 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 4.0 KiB |
Minimum | 2007-07-12 12:53:04 |
---|---|
Maximum | 2020-04-17 09:11:01 |
SYS_DVCD | BRCD | ACPT_YR | SEQ | REG_ENO | |
---|---|---|---|---|---|
SYS_DVCD | 1.000 | 0.000 | 0.000 | 0.482 | 0.000 |
BRCD | 0.000 | 1.000 | 0.000 | 0.522 | 0.921 |
ACPT_YR | 0.000 | 0.000 | 1.000 | 0.201 | 0.395 |
SEQ | 0.482 | 0.522 | 0.201 | 1.000 | 0.319 |
REG_ENO | 0.000 | 0.921 | 0.395 | 0.319 | 1.000 |
BRCD | SYS_DVCD | |
---|---|---|
BRCD | 1.000 | 0.000 |
SYS_DVCD | 0.000 | 1.000 |
ACPT_YR | SEQ | REG_ENO | SYS_DVCD | BRCD | |
---|---|---|---|---|---|
ACPT_YR | 1.000 | 0.388 | 0.358 | 0.000 | 0.000 |
SEQ | 0.388 | 1.000 | 0.396 | 0.368 | 0.211 |
REG_ENO | 0.358 | 0.396 | 1.000 | 0.000 | 0.771 |
SYS_DVCD | 0.000 | 0.368 | 0.000 | 1.000 | 0.000 |
BRCD | 0.000 | 0.211 | 0.771 | 0.000 | 1.000 |
SYS_DVCD | BRCD | ACPT_YR | SEQ | REG_ENO | REG_TS | |
---|---|---|---|---|---|---|
0 | K | TMB | 2020 | 3 | 1557 | 2020/04/17 09:11:01 |
1 | K | TQC | 2020 | 26 | 1912 | 2020/04/13 12:14:04 |
2 | R | TQC | 2020 | 38 | 1912 | 2020/04/13 12:10:04 |
3 | K | TOB | 2020 | 24 | 6145 | 2020/02/04 09:22:12 |
4 | R | ABN | 2020 | 9 | 1825 | 2020/02/03 16:51:22 |
5 | K | TLB | 2020 | 47 | 6104 | 2020/01/13 13:15:26 |
6 | K | TBB | 2020 | 58 | 6136 | 2020/01/09 15:51:00 |
7 | K | TPB | 2020 | 107 | 7510 | 2020/01/08 16:11:48 |
8 | R | TMB | 2020 | 27 | 6183 | 2020/01/08 14:30:29 |
9 | K | TRA | 2020 | 62 | 6106 | 2020/01/08 11:11:19 |
SYS_DVCD | BRCD | ACPT_YR | SEQ | REG_ENO | REG_TS | |
---|---|---|---|---|---|---|
489 | K | TNA | 2009 | 6 | 1434 | 2009/04/08 16:17:34 |
490 | K | TAB | 2011 | 117 | 7313 | 2011/01/06 11:18:39 |
491 | K | TNA | 2010 | 33 | 1329 | 2010/01/28 16:04:05 |
492 | R | QAD | 2010 | 563 | 7313 | 2010/01/04 09:56:37 |
493 | K | THA | 2009 | 35 | 1375 | 2009/02/27 14:00:13 |
494 | K | THA | 2011 | 51 | 7383 | 2011/01/06 17:49:45 |
495 | K | TJA | 2009 | 28 | 7308 | 2009/01/16 15:17:28 |
496 | K | TRA | 2010 | 3 | 1185 | 2010/04/28 15:49:57 |
497 | R | TMA | 2009 | 45 | 7344 | 2009/01/07 16:32:22 |
498 | K | QAD | 2008 | 65 | 7313 | 2008/01/14 14:45:53 |