Overview

Dataset statistics

Number of variables13
Number of observations1000
Missing cells1000
Missing cells (%)7.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory106.6 KiB
Average record size in memory109.1 B

Variable types

Categorical3
DateTime5
Numeric3
Unsupported1
Boolean1

Dataset

Description유동화변동금리이력에 대한 데이터로, 트렌치코드, 유동화계획코드, 시작일자, 종료일자 등과 같은 항목을 제공합니다. 트랜치코드,유동화계획코드,시작일자,종료일자,지급일자,금리시작일자,금리종료일자,기준금리,표면금리,발행적용스프레드율,금융채시가평가기준수익율,확정여부,등록사번,비고와 같은 칼럼이 있으며 관련값이존재합니다.
Author한국주택금융공사
URLhttps://www.data.go.kr/data/15049744/fileData.do

Alerts

확정여부 has constant value ""Constant
유동화계획코드 is highly overall correlated with 기준금리 and 3 other fieldsHigh correlation
트랜치코드 is highly overall correlated with 기준금리 and 3 other fieldsHigh correlation
기준금리 is highly overall correlated with 표면금리 and 2 other fieldsHigh correlation
표면금리 is highly overall correlated with 기준금리 and 2 other fieldsHigh correlation
발행적용스프레드율 is highly overall correlated with 트랜치코드 and 1 other fieldsHigh correlation
금융채시가평가기준수익율 has 1000 (100.0%) missing valuesMissing
금융채시가평가기준수익율 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 14:11:57.361213
Analysis finished2023-12-12 14:11:59.504067
Duration2.14 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

트랜치코드
Categorical

HIGH CORRELATION 

Distinct41
Distinct (%)4.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
KHFCMB2010S-06-A420-1
 
25
KHFCMB2013S-13-A420-1
 
25
KHFCMB2017S-06-A420-1
 
25
KHFCMB2013S-11-A420-1
 
25
KHFCMB2014S-04-A420-1
 
25
Other values (36)
875 

Length

Max length21
Median length21
Mean length21
Min length21

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowKHFCMB2019S-01-A420-1
2nd rowKHFCMB2017S-24-A421-1
3rd rowKHFCMB2013S-33-A420-1
4th rowKHFCMB2013S-11-A420-1
5th rowKHFCMB2014S-04-A420-1

Common Values

ValueCountFrequency (%)
KHFCMB2010S-06-A420-1 25
 
2.5%
KHFCMB2013S-13-A420-1 25
 
2.5%
KHFCMB2017S-06-A420-1 25
 
2.5%
KHFCMB2013S-11-A420-1 25
 
2.5%
KHFCMB2014S-04-A420-1 25
 
2.5%
KHFCMB2012S-36-A421-1 25
 
2.5%
KHFCMB2012S-12-A420-1 25
 
2.5%
KHFCMB2010S-08-A420-1 25
 
2.5%
KHFCMB2009S-07-A360-1 25
 
2.5%
KHFCMB2011S-20-A421-1 25
 
2.5%
Other values (31) 750
75.0%

Length

2023-12-12T23:11:59.567682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
khfcmb2010s-06-a420-1 25
 
2.5%
khfcmb2013s-33-a420-1 25
 
2.5%
khfcmb2013s-13-a420-1 25
 
2.5%
khfcmb2013s-24-a420-1 25
 
2.5%
khfcmb2009s-13-a420-1 25
 
2.5%
khfcmb2012s-26-a420-1 25
 
2.5%
khfcmb2012s-38-a421-1 25
 
2.5%
khfcmb2010s-18-a420-1 25
 
2.5%
khfcmb2017s-21-a421-1 25
 
2.5%
khfcmb2018s-07-a420-1 25
 
2.5%
Other values (31) 750
75.0%

유동화계획코드
Categorical

HIGH CORRELATION 

Distinct41
Distinct (%)4.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
KHFCMB2010S-06
 
25
KHFCMB2013S-13
 
25
KHFCMB2017S-06
 
25
KHFCMB2013S-11
 
25
KHFCMB2014S-04
 
25
Other values (36)
875 

Length

Max length14
Median length14
Mean length14
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowKHFCMB2019S-01
2nd rowKHFCMB2017S-24
3rd rowKHFCMB2013S-33
4th rowKHFCMB2013S-11
5th rowKHFCMB2014S-04

Common Values

ValueCountFrequency (%)
KHFCMB2010S-06 25
 
2.5%
KHFCMB2013S-13 25
 
2.5%
KHFCMB2017S-06 25
 
2.5%
KHFCMB2013S-11 25
 
2.5%
KHFCMB2014S-04 25
 
2.5%
KHFCMB2012S-36 25
 
2.5%
KHFCMB2012S-12 25
 
2.5%
KHFCMB2010S-08 25
 
2.5%
KHFCMB2009S-07 25
 
2.5%
KHFCMB2011S-20 25
 
2.5%
Other values (31) 750
75.0%

Length

2023-12-12T23:11:59.678325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
khfcmb2010s-06 25
 
2.5%
khfcmb2013s-33 25
 
2.5%
khfcmb2013s-13 25
 
2.5%
khfcmb2013s-24 25
 
2.5%
khfcmb2009s-13 25
 
2.5%
khfcmb2012s-26 25
 
2.5%
khfcmb2012s-38 25
 
2.5%
khfcmb2010s-18 25
 
2.5%
khfcmb2017s-21 25
 
2.5%
khfcmb2018s-07 25
 
2.5%
Other values (31) 750
75.0%

시작일자
Date

Distinct261
Distinct (%)26.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
Minimum2018-08-15 00:00:00
Maximum2020-09-30 00:00:00
2023-12-12T23:11:59.805203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:11:59.949515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

종료일자
Date

Distinct254
Distinct (%)25.4%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
Minimum2018-09-15 00:00:00
Maximum2020-10-29 00:00:00
2023-12-12T23:12:00.108647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:12:00.260123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

지급일자
Date

Distinct90
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
Minimum2018-10-25 00:00:00
Maximum2020-10-30 00:00:00
2023-12-12T23:12:00.386638image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:12:00.511010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

금리시작일자
Date

Distinct266
Distinct (%)26.6%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
Minimum2018-06-25 00:00:00
Maximum2020-08-25 00:00:00
2023-12-12T23:12:00.668661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:12:00.823619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

금리종료일자
Date

Distinct254
Distinct (%)25.4%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
Minimum2018-08-15 00:00:00
Maximum2020-09-29 00:00:00
2023-12-12T23:12:01.007924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:12:01.140783image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

기준금리
Real number (ℝ)

HIGH CORRELATION 

Distinct219
Distinct (%)21.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.26341
Minimum0.66
Maximum4.65
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-12T23:12:01.302327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.66
5-th percentile1.5
Q13.1175
median3.48
Q33.78
95-th percentile4.18
Maximum4.65
Range3.99
Interquartile range (IQR)0.6625

Descriptive statistics

Standard deviation0.78492941
Coefficient of variation (CV)0.2405243
Kurtosis1.5111993
Mean3.26341
Median Absolute Deviation (MAD)0.33
Skewness-1.365736
Sum3263.41
Variance0.61611419
MonotonicityNot monotonic
2023-12-12T23:12:01.454506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3.52 31
 
3.1%
3.49 28
 
2.8%
3.57 26
 
2.6%
3.56 25
 
2.5%
3.4 24
 
2.4%
3.51 22
 
2.2%
3.87 21
 
2.1%
3.36 21
 
2.1%
3.53 21
 
2.1%
3.48 20
 
2.0%
Other values (209) 761
76.1%
ValueCountFrequency (%)
0.66 1
0.1%
0.68 1
0.1%
0.7 2
0.2%
0.71 2
0.2%
0.75 1
0.1%
0.77 2
0.2%
0.78 1
0.1%
0.79 1
0.1%
0.82 1
0.1%
0.86 1
0.1%
ValueCountFrequency (%)
4.65 5
0.5%
4.64 1
 
0.1%
4.63 2
 
0.2%
4.62 2
 
0.2%
4.61 1
 
0.1%
4.59 1
 
0.1%
4.56 1
 
0.1%
4.53 1
 
0.1%
4.48 1
 
0.1%
4.44 2
 
0.2%

표면금리
Real number (ℝ)

HIGH CORRELATION 

Distinct195
Distinct (%)19.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.02194
Minimum0.99
Maximum4.2
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-12T23:12:01.604290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.99
5-th percentile2.0795
Q12.79
median3.04
Q33.37
95-th percentile3.74
Maximum4.2
Range3.21
Interquartile range (IQR)0.58

Descriptive statistics

Standard deviation0.47413314
Coefficient of variation (CV)0.15689694
Kurtosis1.1657565
Mean3.02194
Median Absolute Deviation (MAD)0.29
Skewness-0.57376106
Sum3021.94
Variance0.22480224
MonotonicityNot monotonic
2023-12-12T23:12:02.036027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3.07 32
 
3.2%
3.11 30
 
3.0%
3.04 29
 
2.9%
2.95 26
 
2.6%
3.12 25
 
2.5%
3.08 22
 
2.2%
2.91 21
 
2.1%
3.06 21
 
2.1%
3.03 21
 
2.1%
3.42 20
 
2.0%
Other values (185) 753
75.3%
ValueCountFrequency (%)
0.99 1
 
0.1%
1.04 1
 
0.1%
1.15 1
 
0.1%
1.27 1
 
0.1%
1.45 1
 
0.1%
1.58 1
 
0.1%
1.7 1
 
0.1%
1.79 1
 
0.1%
1.8 2
0.2%
1.81 3
0.3%
ValueCountFrequency (%)
4.2 5
0.5%
4.19 1
 
0.1%
4.18 2
 
0.2%
4.17 2
 
0.2%
4.16 1
 
0.1%
4.14 1
 
0.1%
4.11 1
 
0.1%
4.08 1
 
0.1%
4.03 1
 
0.1%
3.99 2
 
0.2%

발행적용스프레드율
Real number (ℝ)

HIGH CORRELATION 

Distinct7
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-0.24147
Minimum-0.45
Maximum1.96
Zeros0
Zeros (%)0.0%
Negative877
Negative (%)87.7%
Memory size8.9 KiB
2023-12-12T23:12:02.158335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-0.45
5-th percentile-0.45
Q1-0.45
median-0.45
Q3-0.45
95-th percentile1.23
Maximum1.96
Range2.41
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.58048057
Coefficient of variation (CV)-2.4039449
Kurtosis5.8855934
Mean-0.24147
Median Absolute Deviation (MAD)0
Skewness2.7011794
Sum-241.47
Variance0.3369577
MonotonicityNot monotonic
2023-12-12T23:12:02.256409image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
-0.45 827
82.7%
-0.4 50
 
5.0%
1.96 25
 
2.5%
1.23 25
 
2.5%
1.09 25
 
2.5%
1.49 24
 
2.4%
0.33 24
 
2.4%
ValueCountFrequency (%)
-0.45 827
82.7%
-0.4 50
 
5.0%
0.33 24
 
2.4%
1.09 25
 
2.5%
1.23 25
 
2.5%
1.49 24
 
2.4%
1.96 25
 
2.5%
ValueCountFrequency (%)
1.96 25
 
2.5%
1.49 24
 
2.4%
1.23 25
 
2.5%
1.09 25
 
2.5%
0.33 24
 
2.4%
-0.4 50
 
5.0%
-0.45 827
82.7%

금융채시가평가기준수익율
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1000
Missing (%)100.0%
Memory size8.9 KiB

확정여부
Boolean

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
True
1000 
ValueCountFrequency (%)
True 1000
100.0%
2023-12-12T23:12:02.343206image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

등록사번
Categorical

Distinct4
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
1769
289 
1841
279 
1438
264 
1628
168 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1769
2nd row1769
3rd row1769
4th row1769
5th row1769

Common Values

ValueCountFrequency (%)
1769 289
28.9%
1841 279
27.9%
1438 264
26.4%
1628 168
16.8%

Length

2023-12-12T23:12:02.432034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:12:02.523503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1769 289
28.9%
1841 279
27.9%
1438 264
26.4%
1628 168
16.8%

Interactions

2023-12-12T23:11:58.800157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:11:57.959210image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:11:58.402213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:11:58.934347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:11:58.119242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:11:58.548887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:11:59.057752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:11:58.262312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:11:58.669787image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:12:02.607199image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
트랜치코드유동화계획코드지급일자기준금리표면금리발행적용스프레드율등록사번
트랜치코드1.0001.0000.0000.9370.9321.0000.000
유동화계획코드1.0001.0000.0000.9370.9321.0000.000
지급일자0.0000.0001.0000.8110.8780.9290.996
기준금리0.9370.9370.8111.0000.9510.8350.388
표면금리0.9320.9320.8780.9511.0000.6950.243
발행적용스프레드율1.0001.0000.9290.8350.6951.0000.000
등록사번0.0000.0000.9960.3880.2430.0001.000
2023-12-12T23:12:02.767072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
등록사번유동화계획코드트랜치코드
등록사번1.0000.0000.000
유동화계획코드0.0001.0001.000
트랜치코드0.0001.0001.000
2023-12-12T23:12:02.868525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준금리표면금리발행적용스프레드율트랜치코드유동화계획코드등록사번
기준금리1.0000.855-0.4370.6710.6710.241
표면금리0.8551.000-0.0620.6560.6560.147
발행적용스프레드율-0.437-0.0621.0000.9820.9820.000
트랜치코드0.6710.6560.9821.0001.0000.000
유동화계획코드0.6710.6560.9821.0001.0000.000
등록사번0.2410.1470.0000.0000.0001.000

Missing values

2023-12-12T23:11:59.232270image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:11:59.430083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

트랜치코드유동화계획코드시작일자종료일자지급일자금리시작일자금리종료일자기준금리표면금리발행적용스프레드율금융채시가평가기준수익율확정여부등록사번
0KHFCMB2019S-01-A420-1KHFCMB2019S-012020-08-042020-09-022020-10-262020-07-042020-08-023.863.41-0.45<NA>Y1769
1KHFCMB2017S-24-A421-1KHFCMB2017S-242020-08-262020-10-242020-10-262020-07-262020-09-243.783.33-0.45<NA>Y1769
2KHFCMB2013S-33-A420-1KHFCMB2013S-332020-09-252020-10-242020-10-262020-08-252020-09-243.513.06-0.45<NA>Y1769
3KHFCMB2013S-11-A420-1KHFCMB2013S-112020-09-252020-10-242020-10-262020-08-252020-09-243.092.64-0.45<NA>Y1769
4KHFCMB2014S-04-A420-1KHFCMB2014S-042020-09-252020-10-242020-10-262020-08-252020-09-242.992.54-0.45<NA>Y1769
5KHFCMB2012S-36-A421-1KHFCMB2012S-362020-09-252020-10-242020-10-262020-08-252020-09-242.752.3-0.45<NA>Y1769
6KHFCMB2012S-12-A420-1KHFCMB2012S-122020-09-252020-10-242020-10-262020-08-252020-09-243.092.64-0.45<NA>Y1769
7KHFCMB2010S-08-A420-1KHFCMB2010S-082020-09-262020-10-252020-10-262020-06-262020-09-250.72.661.96<NA>Y1769
8KHFCMB2009S-02-A420-1KHFCMB2009S-022020-09-302020-10-292020-10-302020-06-302020-09-290.71.931.23<NA>Y1769
9KHFCMB2009S-03-A366-1KHFCMB2009S-032020-09-012020-09-302020-10-262020-08-012020-08-310.682.171.49<NA>Y1769
트랜치코드유동화계획코드시작일자종료일자지급일자금리시작일자금리종료일자기준금리표면금리발행적용스프레드율금융채시가평가기준수익율확정여부등록사번
990KHFCMB2012S-04-A421-1KHFCMB2012S-042018-09-252018-10-242018-10-252018-08-252018-09-243.543.09-0.45<NA>Y1438
991KHFCMB2011S-20-A421-1KHFCMB2011S-202018-09-252018-10-242018-10-252018-08-252018-09-243.352.9-0.45<NA>Y1438
992KHFCMB2011S-15-A421-1KHFCMB2011S-152018-09-252018-10-242018-10-252018-08-252018-09-243.412.96-0.45<NA>Y1438
993KHFCMB2011S-06-A421-1KHFCMB2011S-062018-09-252018-10-242018-10-252018-08-252018-09-243.583.13-0.45<NA>Y1438
994KHFCMB2010S-18-A420-1KHFCMB2010S-182018-09-252018-10-242018-10-252018-08-252018-09-243.192.74-0.45<NA>Y1438
995KHFCMB2010S-06-A420-1KHFCMB2010S-062018-09-252018-10-242018-10-252018-08-252018-09-243.843.44-0.4<NA>Y1438
996KHFCMB2009S-13-A420-1KHFCMB2009S-132018-09-252018-10-242018-10-252018-08-252018-09-243.73.3-0.4<NA>Y1438
997KHFCMB2010S-08-A420-1KHFCMB2010S-082018-09-262018-10-252018-10-262018-06-262018-09-251.653.611.96<NA>Y1438
998KHFCMB2009S-07-A360-1KHFCMB2009S-072018-09-252018-10-242018-10-252018-06-252018-09-241.652.741.09<NA>Y1438
999KHFCMB2009S-02-A420-1KHFCMB2009S-022018-09-302018-10-292018-10-302018-06-302018-09-291.652.881.23<NA>Y1438