Overview

Dataset statistics

Number of variables9
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.5 KiB
Average record size in memory76.3 B

Variable types

Categorical6
Numeric2
Boolean1

Dataset

Description한국주택금융공사 유동화자산부 업무 관련 공개 공공데이터 (해당 부서의 업무와 관련된 데이터베이스에서 공개 가능한 원천 데이터) 유동화계획코드,인수코드,작성기준일자,순번,반복제공회차,온라인여부,전문순번,자료제공일자,등기구분코드 관련 정보가 포함되어있습니다.
Author한국주택금융공사
URLhttps://www.data.go.kr/data/15073166/fileData.do

Alerts

반복제공회차 has constant value ""Constant
온라인여부 has constant value ""Constant
자료제공일자 is highly overall correlated with 작성기준일자High correlation
작성기준일자 is highly overall correlated with 자료제공일자High correlation
인수코드 is highly overall correlated with 유동화계획코드High correlation
유동화계획코드 is highly overall correlated with 인수코드High correlation
등기구분코드 is highly imbalanced (85.9%)Imbalance
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-13 00:05:40.540842
Analysis finished2023-12-13 00:05:41.391732
Duration0.85 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

유동화계획코드
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)8.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
KHFCMB2010S_03
28 
KHFCMB2010S_16
18 
KHFCMB2012S_05
15 
KHFCMB2011S_11
12 
KHFCMB2013S_40
11 
Other values (3)
16 

Length

Max length14
Median length14
Mean length14
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowKHFCMB2013S_40
2nd rowKHFCMB2010S_03
3rd rowKHFCMB2010S_03
4th rowKHFCMB2012S_05
5th rowKHFCMB2010S_16

Common Values

ValueCountFrequency (%)
KHFCMB2010S_03 28
28.0%
KHFCMB2010S_16 18
18.0%
KHFCMB2012S_05 15
15.0%
KHFCMB2011S_11 12
12.0%
KHFCMB2013S_40 11
 
11.0%
KHFCMB2008S_05 9
 
9.0%
KHFCMB2008S_01 5
 
5.0%
KHFCMB2009S_08 2
 
2.0%

Length

2023-12-13T09:05:41.462166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T09:05:41.556360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
khfcmb2010s_03 28
28.0%
khfcmb2010s_16 18
18.0%
khfcmb2012s_05 15
15.0%
khfcmb2011s_11 12
12.0%
khfcmb2013s_40 11
 
11.0%
khfcmb2008s_05 9
 
9.0%
khfcmb2008s_01 5
 
5.0%
khfcmb2009s_08 2
 
2.0%

인수코드
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
B034_2010_0001
28 
B034_2010_0003
18 
B034_2012_0008
15 
B034_2011_0001
12 
B034_2008_0001
9 
Other values (4)
18 

Length

Max length14
Median length14
Mean length14
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowB034_2013_0010
2nd rowB034_2010_0001
3rd rowB034_2010_0001
4th rowB034_2012_0008
5th rowB034_2010_0003

Common Values

ValueCountFrequency (%)
B034_2010_0001 28
28.0%
B034_2010_0003 18
18.0%
B034_2012_0008 15
15.0%
B034_2011_0001 12
12.0%
B034_2008_0001 9
 
9.0%
B034_2012_0017 6
 
6.0%
B034_2013_0010 5
 
5.0%
B034_2007_0003 5
 
5.0%
B034_2008_0002 2
 
2.0%

Length

2023-12-13T09:05:41.672996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T09:05:41.764814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
b034_2010_0001 28
28.0%
b034_2010_0003 18
18.0%
b034_2012_0008 15
15.0%
b034_2011_0001 12
12.0%
b034_2008_0001 9
 
9.0%
b034_2012_0017 6
 
6.0%
b034_2013_0010 5
 
5.0%
b034_2007_0003 5
 
5.0%
b034_2008_0002 2
 
2.0%

작성기준일자
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2015-10-31
44 
2016-09-30
31 
2016-10-31
25 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2015-10-31
2nd row2015-10-31
3rd row2016-09-30
4th row2016-10-31
5th row2016-09-30

Common Values

ValueCountFrequency (%)
2015-10-31 44
44.0%
2016-09-30 31
31.0%
2016-10-31 25
25.0%

Length

2023-12-13T09:05:41.869958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T09:05:42.219595image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2015-10-31 44
44.0%
2016-09-30 31
31.0%
2016-10-31 25
25.0%

순번
Real number (ℝ)

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean100.69
Minimum5
Maximum208
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-13T09:05:42.321006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum5
5-th percentile9.95
Q140.75
median89.5
Q3183.25
95-th percentile203.05
Maximum208
Range203
Interquartile range (IQR)142.5

Descriptive statistics

Standard deviation67.271303
Coefficient of variation (CV)0.66810312
Kurtosis-1.2887803
Mean100.69
Median Absolute Deviation (MAD)52
Skewness0.30540258
Sum10069
Variance4525.4282
MonotonicityNot monotonic
2023-12-13T09:05:42.444558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
5 1
 
1.0%
126 1
 
1.0%
206 1
 
1.0%
207 1
 
1.0%
208 1
 
1.0%
119 1
 
1.0%
120 1
 
1.0%
121 1
 
1.0%
122 1
 
1.0%
123 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
5 1
1.0%
6 1
1.0%
7 1
1.0%
8 1
1.0%
9 1
1.0%
10 1
1.0%
12 1
1.0%
14 1
1.0%
16 1
1.0%
17 1
1.0%
ValueCountFrequency (%)
208 1
1.0%
207 1
1.0%
206 1
1.0%
205 1
1.0%
204 1
1.0%
203 1
1.0%
202 1
1.0%
201 1
1.0%
200 1
1.0%
199 1
1.0%

반복제공회차
Categorical

CONSTANT 

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

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 100
100.0%

Length

2023-12-13T09:05:42.556697image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T09:05:42.628032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 100
100.0%

온라인여부
Boolean

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size232.0 B
True
100 
ValueCountFrequency (%)
True 100
100.0%
2023-12-13T09:05:42.687050image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

전문순번
Real number (ℝ)

Distinct84
Distinct (%)84.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean84.92
Minimum2
Maximum200
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-13T09:05:42.769107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile8.9
Q142.75
median79.5
Q3119
95-th percentile177.05
Maximum200
Range198
Interquartile range (IQR)76.25

Descriptive statistics

Standard deviation50.876694
Coefficient of variation (CV)0.59911321
Kurtosis-0.71211668
Mean84.92
Median Absolute Deviation (MAD)38
Skewness0.29767594
Sum8492
Variance2588.438
MonotonicityNot monotonic
2023-12-13T09:05:42.887861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
114 3
 
3.0%
72 2
 
2.0%
2 2
 
2.0%
41 2
 
2.0%
102 2
 
2.0%
88 2
 
2.0%
47 2
 
2.0%
37 2
 
2.0%
109 2
 
2.0%
111 2
 
2.0%
Other values (74) 79
79.0%
ValueCountFrequency (%)
2 2
2.0%
3 1
1.0%
7 2
2.0%
9 1
1.0%
10 1
1.0%
11 1
1.0%
13 1
1.0%
16 1
1.0%
18 1
1.0%
19 1
1.0%
ValueCountFrequency (%)
200 1
1.0%
191 1
1.0%
187 1
1.0%
184 1
1.0%
178 1
1.0%
177 1
1.0%
174 1
1.0%
173 1
1.0%
172 1
1.0%
158 1
1.0%

자료제공일자
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2015-11-03
44 
2016-10-05
31 
2016-11-02
25 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2015-11-03
2nd row2015-11-03
3rd row2016-10-05
4th row2016-11-02
5th row2016-10-05

Common Values

ValueCountFrequency (%)
2015-11-03 44
44.0%
2016-10-05 31
31.0%
2016-11-02 25
25.0%

Length

2023-12-13T09:05:42.987905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T09:05:43.060148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2015-11-03 44
44.0%
2016-10-05 31
31.0%
2016-11-02 25
25.0%

등기구분코드
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
건물(토지 미등기)
98 
토지와 건물
 
2

Length

Max length10
Median length10
Mean length9.92
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row건물(토지 미등기)
2nd row건물(토지 미등기)
3rd row건물(토지 미등기)
4th row건물(토지 미등기)
5th row건물(토지 미등기)

Common Values

ValueCountFrequency (%)
건물(토지 미등기) 98
98.0%
토지와 건물 2
 
2.0%

Length

2023-12-13T09:05:43.147671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T09:05:43.226797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
건물(토지 98
49.0%
미등기 98
49.0%
토지와 2
 
1.0%
건물 2
 
1.0%

Interactions

2023-12-13T09:05:41.044295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T09:05:40.848724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T09:05:41.126744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T09:05:40.932441image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T09:05:43.275465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
유동화계획코드인수코드작성기준일자순번전문순번자료제공일자등기구분코드
유동화계획코드1.0001.0000.0000.0000.7610.0000.209
인수코드1.0001.0000.0000.0000.7470.0000.119
작성기준일자0.0000.0001.0000.0000.3561.0000.000
순번0.0000.0000.0001.0000.0620.0000.275
전문순번0.7610.7470.3560.0621.0000.3560.000
자료제공일자0.0000.0001.0000.0000.3561.0000.000
등기구분코드0.2090.1190.0000.2750.0000.0001.000
2023-12-13T09:05:43.362870image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
자료제공일자작성기준일자인수코드등기구분코드유동화계획코드
자료제공일자1.0001.0000.0000.0000.000
작성기준일자1.0001.0000.0000.0000.000
인수코드0.0000.0001.0000.1110.995
등기구분코드0.0000.0000.1111.0000.150
유동화계획코드0.0000.0000.9950.1501.000
2023-12-13T09:05:43.449051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번전문순번유동화계획코드인수코드작성기준일자자료제공일자등기구분코드
순번1.0000.1320.0000.0000.0000.0000.264
전문순번0.1321.0000.4920.4590.2190.2190.000
유동화계획코드0.0000.4921.0000.9950.0000.0000.150
인수코드0.0000.4590.9951.0000.0000.0000.111
작성기준일자0.0000.2190.0000.0001.0001.0000.000
자료제공일자0.0000.2190.0000.0001.0001.0000.000
등기구분코드0.2640.0000.1500.1110.0000.0001.000

Missing values

2023-12-13T09:05:41.230042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T09:05:41.345007image/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

유동화계획코드인수코드작성기준일자순번반복제공회차온라인여부전문순번자료제공일자등기구분코드
0KHFCMB2013S_40B034_2013_00102015-10-3151Y162015-11-03건물(토지 미등기)
1KHFCMB2010S_03B034_2010_00012015-10-3161Y342015-11-03건물(토지 미등기)
2KHFCMB2010S_03B034_2010_00012016-09-3081Y642016-10-05건물(토지 미등기)
3KHFCMB2012S_05B034_2012_00082016-10-3191Y1152016-11-02건물(토지 미등기)
4KHFCMB2010S_16B034_2010_00032016-09-3071Y1072016-10-05건물(토지 미등기)
5KHFCMB2010S_16B034_2010_00032016-10-31101Y862016-11-02건물(토지 미등기)
6KHFCMB2013S_40B034_2012_00172016-09-30121Y72016-10-05건물(토지 미등기)
7KHFCMB2011S_11B034_2011_00012016-10-31141Y922016-11-02건물(토지 미등기)
8KHFCMB2013S_40B034_2012_00172016-10-31161Y1262016-11-02건물(토지 미등기)
9KHFCMB2012S_05B034_2012_00082016-09-30251Y1272016-10-05건물(토지 미등기)
유동화계획코드인수코드작성기준일자순번반복제공회차온라인여부전문순번자료제공일자등기구분코드
90KHFCMB2013S_40B034_2012_00172016-09-301901Y92016-10-05건물(토지 미등기)
91KHFCMB2010S_16B034_2010_00032016-10-311891Y802016-11-02건물(토지 미등기)
92KHFCMB2013S_40B034_2012_00172016-10-311881Y72016-11-02건물(토지 미등기)
93KHFCMB2010S_03B034_2010_00012016-09-301871Y592016-10-05건물(토지 미등기)
94KHFCMB2008S_01B034_2007_00032016-10-311861Y32016-11-02건물(토지 미등기)
95KHFCMB2010S_03B034_2010_00012016-10-311851Y422016-11-02건물(토지 미등기)
96KHFCMB2010S_03B034_2010_00012015-10-311841Y722015-11-03건물(토지 미등기)
97KHFCMB2008S_05B034_2008_00012015-10-311831Y432015-11-03건물(토지 미등기)
98KHFCMB2011S_11B034_2011_00012016-09-301821Y1192016-10-05건물(토지 미등기)
99KHFCMB2010S_03B034_2010_00012016-10-311811Y222016-11-02건물(토지 미등기)