Overview

Dataset statistics

Number of variables5
Number of observations91
Missing cells26
Missing cells (%)5.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.8 KiB
Average record size in memory42.5 B

Variable types

DateTime2
Categorical2
Numeric1

Dataset

Description(부보금융회사 종합정보)(채권) 지원자금 마련과 관련하여 부족재원을 조달하기 위하여 발행하거나, 채권 만기도래 금액 중 단기 상환이 불가능한 자금의 조달을 위해 차환발행한 채권 현황 정보(차입금) 자금수지불일치를 해소하기 위해 발행한 차입금 현황 정보
Author예금보험공사
URLhttps://www.data.go.kr/data/15028031/fileData.do

Alerts

회계계정코드 is highly overall correlated with 당일잔액 and 1 other fieldsHigh correlation
기금코드 is highly overall correlated with 당일잔액 and 1 other fieldsHigh correlation
당일잔액 is highly overall correlated with 기금코드 and 1 other fieldsHigh correlation
당일잔액 has 26 (28.6%) missing valuesMissing

Reproduction

Analysis started2024-04-06 08:08:21.814512
Analysis finished2024-04-06 08:08:22.869183
Duration1.05 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기준시점
Date

Distinct23
Distinct (%)25.3%
Missing0
Missing (%)0.0%
Memory size860.0 B
Minimum2013-12-31 00:00:00
Maximum2023-12-31 00:00:00
2024-04-06T17:08:22.985594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:08:23.284536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)

기금코드
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size860.0 B
예보기금
69 
상환기금
22 

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 (%)
예보기금 69
75.8%
상환기금 22
 
24.2%

Length

2024-04-06T17:08:23.607456image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:08:23.807962image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
예보기금 69
75.8%
상환기금 22
 
24.2%

회계계정코드
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)4.4%
Missing0
Missing (%)0.0%
Memory size860.0 B
특별계정채권
23 
단기사채
23 
차입금
23 
상환기금채권
22 

Length

Max length6
Median length4
Mean length4.7362637
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row상환기금채권
2nd row특별계정채권
3rd row단기사채
4th row차입금
5th row상환기금채권

Common Values

ValueCountFrequency (%)
특별계정채권 23
25.3%
단기사채 23
25.3%
차입금 23
25.3%
상환기금채권 22
24.2%

Length

2024-04-06T17:08:24.061223image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:08:24.318492image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
특별계정채권 23
25.3%
단기사채 23
25.3%
차입금 23
25.3%
상환기금채권 22
24.2%

당일잔액
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct50
Distinct (%)76.9%
Missing26
Missing (%)28.6%
Infinite0
Infinite (%)0.0%
Mean53437
Minimum15
Maximum233300
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size951.0 B
2024-04-06T17:08:24.569644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum15
5-th percentile140.4
Q12549
median38800
Q385200
95-th percentile214080
Maximum233300
Range233285
Interquartile range (IQR)82651

Descriptive statistics

Standard deviation65143.205
Coefficient of variation (CV)1.2190655
Kurtosis1.1787045
Mean53437
Median Absolute Deviation (MAD)36300
Skewness1.3853877
Sum3473405
Variance4.2436372 × 109
MonotonicityNot monotonic
2024-04-06T17:08:25.002553image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2500 6
 
6.6%
38800 4
 
4.4%
50900 2
 
2.2%
62300 2
 
2.2%
75400 2
 
2.2%
88400 2
 
2.2%
8000 2
 
2.2%
185200 2
 
2.2%
221300 2
 
2.2%
48500 1
 
1.1%
Other values (40) 40
44.0%
(Missing) 26
28.6%
ValueCountFrequency (%)
15 1
 
1.1%
30 1
 
1.1%
93 1
 
1.1%
139 1
 
1.1%
146 1
 
1.1%
1549 1
 
1.1%
1772 1
 
1.1%
2000 1
 
1.1%
2300 1
 
1.1%
2500 6
6.6%
ValueCountFrequency (%)
233300 1
1.1%
225200 1
1.1%
221300 2
2.2%
185200 2
2.2%
163000 1
1.1%
127400 1
1.1%
125500 1
1.1%
115400 1
1.1%
100500 1
1.1%
96800 1
1.1%

등록일자
Date

Distinct23
Distinct (%)25.3%
Missing0
Missing (%)0.0%
Memory size860.0 B
Minimum2013-12-31 00:00:00
Maximum2023-12-31 00:00:00
2024-04-06T17:08:25.260515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:08:25.633669image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)

Interactions

2024-04-06T17:08:22.378853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-06T17:08:25.881145image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준시점기금코드회계계정코드당일잔액등록일자
기준시점1.0000.0000.0000.0001.000
기금코드0.0001.0001.0000.6230.000
회계계정코드0.0001.0001.0000.7650.000
당일잔액0.0000.6230.7651.0000.000
등록일자1.0000.0000.0000.0001.000
2024-04-06T17:08:26.138857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회계계정코드기금코드
회계계정코드1.0000.989
기금코드0.9891.000
2024-04-06T17:08:26.303140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
당일잔액기금코드회계계정코드
당일잔액1.0000.5920.587
기금코드0.5921.0000.989
회계계정코드0.5870.9891.000

Missing values

2024-04-06T17:08:22.606535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T17:08:22.802100image/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

기준시점기금코드회계계정코드당일잔액등록일자
02013-12-31상환기금상환기금채권2252002013-12-31
12013-12-31예보기금특별계정채권2333002013-12-31
22013-12-31예보기금단기사채<NA>2013-12-31
32013-12-31예보기금차입금20002013-12-31
42014-12-31상환기금상환기금채권1852002014-12-31
52014-12-31예보기금특별계정채권2213002014-12-31
62014-12-31예보기금단기사채<NA>2014-12-31
72014-12-31예보기금차입금25002014-12-31
82015-12-31상환기금상환기금채권1852002015-12-31
92015-12-31예보기금특별계정채권2213002015-12-31
기준시점기금코드회계계정코드당일잔액등록일자
812023-06-30예보기금단기사채105002023-06-30
822023-06-30예보기금차입금<NA>2023-06-30
832023-09-30상환기금상환기금채권<NA>2023-09-30
842023-09-30예보기금특별계정채권509002023-09-30
852023-09-30예보기금단기사채<NA>2023-09-30
862023-09-30예보기금차입금1392023-09-30
872023-12-31상환기금상환기금채권<NA>2023-12-31
882023-12-31예보기금특별계정채권485002023-12-31
892023-12-31예보기금단기사채<NA>2023-12-31
902023-12-31예보기금차입금<NA>2023-12-31