Overview

Dataset statistics

Number of variables5
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows1
Duplicate rows (%)1.0%
Total size in memory4.1 KiB
Average record size in memory42.3 B

Variable types

Categorical4
Numeric1

Dataset

Description한국주택금융공사 재무관리부 업무 관련 공개 공공데이터이며 해당결산년월,유동화계획코드,매입코드,회수이자,작업자직번,등록년월일 칼럼과 관련값이 포함되어있습니다.
Author한국주택금융공사
URLhttps://www.data.go.kr/data/15040232/fileData.do

Alerts

작업자직번 has constant value ""Constant
등록년월일 has constant value ""Constant
Dataset has 1 (1.0%) duplicate rowsDuplicates
유동화계획코드 is highly overall correlated with 매입코드High correlation
매입코드 is highly overall correlated with 유동화계획코드High correlation

Reproduction

Analysis started2023-12-12 10:29:08.591397
Analysis finished2023-12-12 10:29:08.971577
Duration0.38 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

유동화계획코드
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
KHFCMB2019L-A9
64 
KHFCMB2019L-A8
36 

Length

Max length14
Median length14
Mean length14
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowKHFCMB2019L-A8
2nd rowKHFCMB2019L-A8
3rd rowKHFCMB2019L-A8
4th rowKHFCMB2019L-A8
5th rowKHFCMB2019L-A8

Common Values

ValueCountFrequency (%)
KHFCMB2019L-A9 64
64.0%
KHFCMB2019L-A8 36
36.0%

Length

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

Common Values (Plot)

2023-12-12T19:29:09.147436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
khfcmb2019l-a9 64
64.0%
khfcmb2019l-a8 36
36.0%

매입코드
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
B004-2014-0022
47 
B020-2014-0037
36 
B004-2014-0016
9 
B004-2014-0017
8 

Length

Max length14
Median length14
Mean length14
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowB020-2014-0037
2nd rowB020-2014-0037
3rd rowB020-2014-0037
4th rowB020-2014-0037
5th rowB020-2014-0037

Common Values

ValueCountFrequency (%)
B004-2014-0022 47
47.0%
B020-2014-0037 36
36.0%
B004-2014-0016 9
 
9.0%
B004-2014-0017 8
 
8.0%

Length

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

Common Values (Plot)

2023-12-12T19:29:09.366588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
b004-2014-0022 47
47.0%
b020-2014-0037 36
36.0%
b004-2014-0016 9
 
9.0%
b004-2014-0017 8
 
8.0%

회수이자
Real number (ℝ)

Distinct99
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13234279
Minimum2142367
Maximum54170767
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-12T19:29:09.511154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2142367
5-th percentile3859326.5
Q16988666.2
median11280091
Q318693353
95-th percentile24186352
Maximum54170767
Range52028400
Interquartile range (IQR)11704686

Descriptive statistics

Standard deviation8420789.8
Coefficient of variation (CV)0.63628625
Kurtosis4.8915685
Mean13234279
Median Absolute Deviation (MAD)4940379.5
Skewness1.6376703
Sum1.3234279 × 109
Variance7.09097 × 1013
MonotonicityNot monotonic
2023-12-12T19:29:09.704648image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
9691966 2
 
2.0%
12024717 1
 
1.0%
20701358 1
 
1.0%
11550523 1
 
1.0%
6708608 1
 
1.0%
5407351 1
 
1.0%
8031980 1
 
1.0%
10794264 1
 
1.0%
14403528 1
 
1.0%
15597810 1
 
1.0%
Other values (89) 89
89.0%
ValueCountFrequency (%)
2142367 1
1.0%
2889627 1
1.0%
2946955 1
1.0%
3500470 1
1.0%
3675111 1
1.0%
3869022 1
1.0%
4310370 1
1.0%
4327966 1
1.0%
4435982 1
1.0%
4478896 1
1.0%
ValueCountFrequency (%)
54170767 1
1.0%
38767960 1
1.0%
33301146 1
1.0%
28482412 1
1.0%
24229966 1
1.0%
24184057 1
1.0%
24007442 1
1.0%
23422298 1
1.0%
23142482 1
1.0%
23083590 1
1.0%

작업자직번
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
BATCH
100 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
BATCH 100
100.0%

Length

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

Common Values (Plot)

2023-12-12T19:29:09.971507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
batch 100
100.0%

등록년월일
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2019-12-11 16:49
100 

Length

Max length16
Median length16
Mean length16
Min length16

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2019-12-11 16:49
2nd row2019-12-11 16:49
3rd row2019-12-11 16:49
4th row2019-12-11 16:49
5th row2019-12-11 16:49

Common Values

ValueCountFrequency (%)
2019-12-11 16:49 100
100.0%

Length

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

Common Values (Plot)

2023-12-12T19:29:10.198405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2019-12-11 100
50.0%
16:49 100
50.0%

Interactions

2023-12-12T19:29:08.703738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T19:29:10.259473image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
유동화계획코드매입코드회수이자
유동화계획코드1.0001.0000.613
매입코드1.0001.0000.502
회수이자0.6130.5021.000
2023-12-12T19:29:10.359548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
유동화계획코드매입코드
유동화계획코드1.0000.990
매입코드0.9901.000
2023-12-12T19:29:10.466200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회수이자유동화계획코드매입코드
회수이자1.0000.4540.223
유동화계획코드0.4541.0000.990
매입코드0.2230.9901.000

Missing values

2023-12-12T19:29:08.810092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T19:29:08.923162image/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

유동화계획코드매입코드회수이자작업자직번등록년월일
0KHFCMB2019L-A8B020-2014-003712024717BATCH2019-12-11 16:49
1KHFCMB2019L-A8B020-2014-00378602918BATCH2019-12-11 16:49
2KHFCMB2019L-A8B020-2014-003715608735BATCH2019-12-11 16:49
3KHFCMB2019L-A8B020-2014-00378399708BATCH2019-12-11 16:49
4KHFCMB2019L-A8B020-2014-003715675965BATCH2019-12-11 16:49
5KHFCMB2019L-A8B020-2014-003718151103BATCH2019-12-11 16:49
6KHFCMB2019L-A8B020-2014-003738767960BATCH2019-12-11 16:49
7KHFCMB2019L-A8B020-2014-003713657642BATCH2019-12-11 16:49
8KHFCMB2019L-A8B020-2014-00378468340BATCH2019-12-11 16:49
9KHFCMB2019L-A8B020-2014-003722058953BATCH2019-12-11 16:49
유동화계획코드매입코드회수이자작업자직번등록년월일
90KHFCMB2019L-A9B004-2014-00226385733BATCH2019-12-11 16:49
91KHFCMB2019L-A9B004-2014-00225898155BATCH2019-12-11 16:49
92KHFCMB2019L-A9B004-2014-002228482412BATCH2019-12-11 16:49
93KHFCMB2019L-A9B004-2014-00224327966BATCH2019-12-11 16:49
94KHFCMB2019L-A9B004-2014-00222946955BATCH2019-12-11 16:49
95KHFCMB2019L-A9B004-2014-002211455350BATCH2019-12-11 16:49
96KHFCMB2019L-A9B004-2014-00229603457BATCH2019-12-11 16:49
97KHFCMB2019L-A9B004-2014-00227195162BATCH2019-12-11 16:49
98KHFCMB2019L-A9B004-2014-00228595665BATCH2019-12-11 16:49
99KHFCMB2019L-A9B004-2014-002210014131BATCH2019-12-11 16:49

Duplicate rows

Most frequently occurring

유동화계획코드매입코드회수이자작업자직번등록년월일# duplicates
0KHFCMB2019L-A8B020-2014-00379691966BATCH2019-12-11 16:492