Overview

Dataset statistics

Number of variables4
Number of observations1000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory33.3 KiB
Average record size in memory34.1 B

Variable types

Categorical3
Numeric1

Dataset

Description한국주택금융공사 주택연금부 업무 관련 공개 공공데이터 (해당 부서의 업무와 관련된 데이터베이스에서 공개 가능한 원천 데이터) 입니다. 기준연월,기관코드,회차,대출대상 칼럼과 관련값이 포함되어있습니다.
Author한국주택금융공사
URLhttps://www.data.go.kr/data/15073165/fileData.do

Alerts

회차 is highly overall correlated with 대출대상High correlation
대출대상 is highly overall correlated with 회차High correlation

Reproduction

Analysis started2023-12-12 03:42:17.336194
Analysis finished2023-12-12 03:42:17.776370
Duration0.44 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기준연월
Categorical

Distinct27
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
2021-09-19
 
45
2021-10-19
 
45
2021-02-20
 
42
2021-06-20
 
42
2021-07-20
 
42
Other values (22)
784 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-09-20
2nd row2021-09-20
3rd row2021-09-20
4th row2021-09-20
5th row2021-09-20

Common Values

ValueCountFrequency (%)
2021-09-19 45
 
4.5%
2021-10-19 45
 
4.5%
2021-02-20 42
 
4.2%
2021-06-20 42
 
4.2%
2021-07-20 42
 
4.2%
2021-05-20 42
 
4.2%
2021-04-20 42
 
4.2%
2021-03-20 42
 
4.2%
2021-12-19 42
 
4.2%
2021-06-19 42
 
4.2%
Other values (17) 574
57.4%

Length

2023-12-12T12:42:17.858232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2021-09-19 45
 
4.5%
2021-10-19 45
 
4.5%
2021-06-19 42
 
4.2%
2021-07-19 42
 
4.2%
2021-11-19 42
 
4.2%
2021-04-19 42
 
4.2%
2021-08-19 42
 
4.2%
2021-08-20 42
 
4.2%
2021-01-20 42
 
4.2%
2021-12-19 42
 
4.2%
Other values (17) 574
57.4%

기관코드
Real number (ℝ)

Distinct15
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean31.903
Minimum3
Maximum88
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-12T12:42:17.998452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile3
Q111
median32
Q337
95-th percentile88
Maximum88
Range85
Interquartile range (IQR)26

Descriptive statistics

Standard deviation25.105615
Coefficient of variation (CV)0.78693585
Kurtosis0.25316355
Mean31.903
Median Absolute Deviation (MAD)12
Skewness1.0210232
Sum31903
Variance630.29188
MonotonicityNot monotonic
2023-12-12T12:42:18.120772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
39 81
 
8.1%
35 78
 
7.8%
88 75
 
7.5%
31 73
 
7.3%
37 72
 
7.2%
11 72
 
7.2%
4 72
 
7.2%
3 72
 
7.2%
20 72
 
7.2%
32 72
 
7.2%
Other values (5) 261
26.1%
ValueCountFrequency (%)
3 72
7.2%
4 72
7.2%
7 60
6.0%
11 72
7.2%
12 54
5.4%
20 72
7.2%
31 73
7.3%
32 72
7.2%
34 72
7.2%
35 78
7.8%
ValueCountFrequency (%)
88 75
7.5%
81 69
6.9%
57 6
 
0.6%
39 81
8.1%
37 72
7.2%
35 78
7.8%
34 72
7.2%
32 72
7.2%
31 73
7.3%
20 72
7.2%

회차
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
99
334 
2
333 
1
333 

Length

Max length2
Median length1
Mean length1.334
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
99 334
33.4%
2 333
33.3%
1 333
33.3%

Length

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

Common Values (Plot)

2023-12-12T12:42:18.397609image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
99 334
33.4%
2 333
33.3%
1 333
33.3%

대출대상
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
합계
334 
주택담보노후연금대출(대출상환방식)
333 
주택담보노후연금대출(대출상환방식 제외)
333 

Length

Max length21
Median length18
Mean length13.655
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row합계
2nd row주택담보노후연금대출(대출상환방식)
3rd row주택담보노후연금대출(대출상환방식 제외)
4th row합계
5th row주택담보노후연금대출(대출상환방식)

Common Values

ValueCountFrequency (%)
합계 334
33.4%
주택담보노후연금대출(대출상환방식) 333
33.3%
주택담보노후연금대출(대출상환방식 제외) 333
33.3%

Length

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

Common Values (Plot)

2023-12-12T12:42:18.667432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
주택담보노후연금대출(대출상환방식 666
50.0%
합계 334
25.1%
제외 333
25.0%

Interactions

2023-12-12T12:42:17.500914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T12:42:18.748466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준연월기관코드회차대출대상
기준연월1.0000.0000.0000.000
기관코드0.0001.0000.0000.000
회차0.0000.0001.0001.000
대출대상0.0000.0001.0001.000
2023-12-12T12:42:18.881112image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회차대출대상기준연월
회차1.0001.0000.000
대출대상1.0001.0000.000
기준연월0.0000.0001.000
2023-12-12T12:42:19.016694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기관코드기준연월회차대출대상
기관코드1.0000.0210.0000.000
기준연월0.0211.0000.0000.000
회차0.0000.0001.0001.000
대출대상0.0000.0001.0001.000

Missing values

2023-12-12T12:42:17.643644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T12:42:17.732379image/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

기준연월기관코드회차대출대상
02021-09-208199합계
12021-09-20812주택담보노후연금대출(대출상환방식)
22021-09-20811주택담보노후연금대출(대출상환방식 제외)
32021-09-208899합계
42021-09-20882주택담보노후연금대출(대출상환방식)
52021-09-20881주택담보노후연금대출(대출상환방식 제외)
62021-09-203599합계
72021-09-20352주택담보노후연금대출(대출상환방식)
82021-09-20351주택담보노후연금대출(대출상환방식 제외)
92021-09-203199합계
기준연월기관코드회차대출대상
9902021-08-18351주택담보노후연금대출(대출상환방식 제외)
9912021-08-183599합계
9922021-09-183299합계
9932021-09-188899합계
9942021-09-18882주택담보노후연금대출(대출상환방식)
9952021-09-18881주택담보노후연금대출(대출상환방식 제외)
9962021-09-183499합계
9972021-09-18342주택담보노후연금대출(대출상환방식)
9982021-09-18341주택담보노후연금대출(대출상환방식 제외)
9992021-09-183199합계