Overview

Dataset statistics

Number of variables7
Number of observations26
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory64.1 B

Variable types

Categorical3
Numeric2
DateTime2

Dataset

Description(부보금융회사 종합정보)IMF 금융위기 시 구조조정 자금 마련을 위해 기발행한 채권의 만기도래 금액 중 회수자금 등으로 충당하지 못하는 부족자금 조달을 위해 차환발행 한 상환채 현황 정보
Author예금보험공사
URLhttps://www.data.go.kr/data/15083232/fileData.do

Alerts

채권종류 has constant value ""Constant
기금 has constant value ""Constant
잔액 has constant value ""Constant
채권번호 is highly overall correlated with 이자율High correlation
이자율 is highly overall correlated with 채권번호High correlation
채권번호 has unique valuesUnique
발행일 has unique valuesUnique
만기일 has unique valuesUnique

Reproduction

Analysis started2024-03-23 05:38:55.647014
Analysis finished2024-03-23 05:38:57.012011
Duration1.36 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

채권종류
Categorical

CONSTANT 

Distinct1
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size340.0 B
상환기금채권
26 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row상환기금채권
2nd row상환기금채권
3rd row상환기금채권
4th row상환기금채권
5th row상환기금채권

Common Values

ValueCountFrequency (%)
상환기금채권 26
100.0%

Length

2024-03-23T14:38:57.109789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T14:38:57.267123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
상환기금채권 26
100.0%

채권번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct26
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2012771.8
Minimum2009001
Maximum2018002
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size366.0 B
2024-03-23T14:38:57.472134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2009001
5-th percentile2010001.2
Q12010254.8
median2012503
Q32013752.2
95-th percentile2017751
Maximum2018002
Range9001
Interquartile range (IQR)3497.5

Descriptive statistics

Standard deviation2581.0141
Coefficient of variation (CV)0.0012823183
Kurtosis-0.38585355
Mean2012771.8
Median Absolute Deviation (MAD)1999.5
Skewness0.63849025
Sum52332068
Variance6661633.7
MonotonicityStrictly increasing
2024-03-23T14:38:57.709562image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%)
2009001 1
 
3.8%
2013002 1
 
3.8%
2018002 1
 
3.8%
2018001 1
 
3.8%
2017001 1
 
3.8%
2016002 1
 
3.8%
2016001 1
 
3.8%
2015001 1
 
3.8%
2014001 1
 
3.8%
2013006 1
 
3.8%
Other values (16) 16
61.5%
ValueCountFrequency (%)
2009001 1
3.8%
2010001 1
3.8%
2010002 1
3.8%
2010003 1
3.8%
2010004 1
3.8%
2010005 1
3.8%
2010006 1
3.8%
2011001 1
3.8%
2012001 1
3.8%
2012002 1
3.8%
ValueCountFrequency (%)
2018002 1
3.8%
2018001 1
3.8%
2017001 1
3.8%
2016002 1
3.8%
2016001 1
3.8%
2015001 1
3.8%
2014001 1
3.8%
2013006 1
3.8%
2013005 1
3.8%
2013004 1
3.8%

기금
Categorical

CONSTANT 

Distinct1
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size340.0 B
상환기금
26 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row상환기금
2nd row상환기금
3rd row상환기금
4th row상환기금
5th row상환기금

Common Values

ValueCountFrequency (%)
상환기금 26
100.0%

Length

2024-03-23T14:38:57.952130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T14:38:58.183809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
상환기금 26
100.0%

발행일
Date

UNIQUE 

Distinct26
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size340.0 B
Minimum2009-01-12 00:00:00
Maximum2018-08-10 00:00:00
2024-03-23T14:38:58.378489image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:38:58.633184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)

만기일
Date

UNIQUE 

Distinct26
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size340.0 B
Minimum2014-01-12 00:00:00
Maximum2021-08-10 00:00:00
2024-03-23T14:38:58.852854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:38:59.047922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)

이자율
Real number (ℝ)

HIGH CORRELATION 

Distinct25
Distinct (%)96.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.3161538
Minimum1.34
Maximum5
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size366.0 B
2024-03-23T14:38:59.236234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.34
5-th percentile1.7375
Q12.765
median3.095
Q34.1275
95-th percentile4.8475
Maximum5
Range3.66
Interquartile range (IQR)1.3625

Descriptive statistics

Standard deviation1.0044584
Coefficient of variation (CV)0.3028986
Kurtosis-0.71309997
Mean3.3161538
Median Absolute Deviation (MAD)0.745
Skewness-0.016784189
Sum86.22
Variance1.0089366
MonotonicityNot monotonic
2024-03-23T14:38:59.584741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)
ValueCountFrequency (%)
2.98 2
 
7.7%
4.65 1
 
3.8%
2.84 1
 
3.8%
2.15 1
 
3.8%
2.52 1
 
3.8%
2.39 1
 
3.8%
1.34 1
 
3.8%
1.61 1
 
3.8%
2.12 1
 
3.8%
2.74 1
 
3.8%
Other values (15) 15
57.7%
ValueCountFrequency (%)
1.34 1
3.8%
1.61 1
3.8%
2.12 1
3.8%
2.15 1
3.8%
2.39 1
3.8%
2.52 1
3.8%
2.74 1
3.8%
2.84 1
3.8%
2.87 1
3.8%
2.98 2
7.7%
ValueCountFrequency (%)
5.0 1
3.8%
4.9 1
3.8%
4.69 1
3.8%
4.65 1
3.8%
4.52 1
3.8%
4.2 1
3.8%
4.14 1
3.8%
4.09 1
3.8%
3.88 1
3.8%
3.67 1
3.8%

잔액
Categorical

CONSTANT 

Distinct1
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size340.0 B
0
26 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 26
100.0%

Length

2024-03-23T14:38:59.809467image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T14:38:59.948927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 26
100.0%

Interactions

2024-03-23T14:38:56.340935image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:38:55.951001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:38:56.508289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:38:56.101315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-23T14:39:00.053984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
채권번호발행일만기일이자율
채권번호1.0001.0001.0000.916
발행일1.0001.0001.0001.000
만기일1.0001.0001.0001.000
이자율0.9161.0001.0001.000
2024-03-23T14:39:00.209696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
채권번호이자율
채권번호1.000-0.922
이자율-0.9221.000

Missing values

2024-03-23T14:38:56.735199image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-23T14:38:56.931101image/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

채권종류채권번호기금발행일만기일이자율잔액
0상환기금채권2009001상환기금2009-01-122014-01-124.650
1상환기금채권2010001상환기금2010-02-182015-02-185.00
2상환기금채권2010002상환기금2010-05-142015-05-144.90
3상환기금채권2010003상환기금2010-05-252014-05-254.690
4상환기금채권2010004상환기금2010-08-192014-08-194.520
5상환기금채권2010005상환기금2010-09-292015-09-294.090
6상환기금채권2010006상환기금2010-11-192015-11-194.20
7상환기금채권2011001상환기금2011-06-232016-06-234.140
8상환기금채권2012001상환기금2012-04-052016-04-053.880
9상환기금채권2012002상환기금2012-07-052017-07-053.670
채권종류채권번호기금발행일만기일이자율잔액
16상환기금채권2013004상환기금2013-07-302018-07-303.380
17상환기금채권2013005상환기금2013-09-172016-09-173.070
18상환기금채권2013006상환기금2013-10-022018-10-023.330
19상환기금채권2014001상환기금2014-07-082017-07-082.740
20상환기금채권2015001상환기금2015-11-252020-11-252.120
21상환기금채권2016001상환기금2016-03-232019-03-231.610
22상환기금채권2016002상환기금2016-08-092019-08-091.340
23상환기금채권2017001상환기금2017-11-012020-11-012.390
24상환기금채권2018001상환기금2018-01-312021-01-312.520
25상환기금채권2018002상환기금2018-08-102021-08-102.150