Overview

Dataset statistics

Number of variables8
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows2
Duplicate rows (%)2.0%
Total size in memory6.9 KiB
Average record size in memory70.3 B

Variable types

Categorical7
Numeric1

Dataset

Description정책모기지 상품 중 한국주택금융공사에서 운영하는 보금자리론 이용 고객들의 주택연금 대출기관 현황 관련된 데이터를 제공하고 있습니다.
URLhttps://www.data.go.kr/data/15090223/fileData.do

Alerts

최초등록부점 has constant value ""Constant
Dataset has 2 (2.0%) duplicate rowsDuplicates
상품 is highly overall correlated with 상품대분류 and 2 other fieldsHigh correlation
상품대분류 is highly overall correlated with 상품중분류 and 2 other fieldsHigh correlation
상품중분류 is highly overall correlated with 상품대분류 and 3 other fieldsHigh correlation
대출기관 is highly overall correlated with 상품대분류 and 4 other fieldsHigh correlation
부점 is highly overall correlated with 상품중분류 and 1 other fieldsHigh correlation
최초등록일시 is highly overall correlated with 대출기관High correlation

Reproduction

Analysis started2023-12-12 20:03:46.832156
Analysis finished2023-12-12 20:03:47.596056
Duration0.76 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
2
57 
1
43 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2 57
57.0%
1 43
43.0%

Length

2023-12-13T05:03:47.690215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:03:47.785833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 57
57.0%
1 43
43.0%

상품중분류
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
3
53 
1
43 
2
 
4

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3 53
53.0%
1 43
43.0%
2 4
 
4.0%

Length

2023-12-13T05:03:47.882472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:03:47.971540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 53
53.0%
1 43
43.0%
2 4
 
4.0%

상품
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)5.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
120301
33 
110108
24 
120305
20 
110101
19 
120201
4 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
120301 33
33.0%
110108 24
24.0%
120305 20
20.0%
110101 19
19.0%
120201 4
 
4.0%

Length

2023-12-13T05:03:48.082653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:03:48.214219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
120301 33
33.0%
110108 24
24.0%
120305 20
20.0%
110101 19
19.0%
120201 4
 
4.0%

금액
Real number (ℝ)

Distinct66
Distinct (%)66.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.62106 × 108
Minimum20000000
Maximum4.35 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-13T05:03:48.348212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20000000
5-th percentile35700000
Q180000000
median1.46 × 108
Q32.38 × 108
95-th percentile3.181 × 108
Maximum4.35 × 108
Range4.15 × 108
Interquartile range (IQR)1.58 × 108

Descriptive statistics

Standard deviation1.0073767 × 108
Coefficient of variation (CV)0.62143083
Kurtosis-0.61748243
Mean1.62106 × 108
Median Absolute Deviation (MAD)75000000
Skewness0.55546501
Sum1.62106 × 1010
Variance1.0148078 × 1016
MonotonicityNot monotonic
2023-12-13T05:03:48.501749image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
300000000 9
 
9.0%
100000000 6
 
6.0%
200000000 4
 
4.0%
156000000 4
 
4.0%
50000000 3
 
3.0%
140000000 3
 
3.0%
80000000 3
 
3.0%
270000000 3
 
3.0%
30000000 2
 
2.0%
90000000 2
 
2.0%
Other values (56) 61
61.0%
ValueCountFrequency (%)
20000000 2
2.0%
23000000 1
 
1.0%
30000000 2
2.0%
36000000 1
 
1.0%
40000000 2
2.0%
41400000 1
 
1.0%
42000000 1
 
1.0%
45700000 1
 
1.0%
50000000 3
3.0%
52000000 1
 
1.0%
ValueCountFrequency (%)
435000000 1
 
1.0%
412000000 1
 
1.0%
382000000 1
 
1.0%
332000000 1
 
1.0%
320000000 1
 
1.0%
318000000 1
 
1.0%
300000000 9
9.0%
294000000 1
 
1.0%
292000000 1
 
1.0%
281000000 1
 
1.0%

부점
Categorical

HIGH CORRELATION 

Distinct22
Distinct (%)22.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
THO
13 
THA
12 
TLA
9 
TPB
8 
QAD
7 
Other values (17)
51 

Length

Max length3
Median length3
Mean length2.98
Min length1

Unique

Unique5 ?
Unique (%)5.0%

Sample

1st rowQAD
2nd rowTAA
3rd rowTBA
4th rowTBA
5th rowQAD

Common Values

ValueCountFrequency (%)
THO 13
13.0%
THA 12
12.0%
TLA 9
9.0%
TPB 8
 
8.0%
QAD 7
 
7.0%
TAC 7
 
7.0%
THB 7
 
7.0%
TBA 6
 
6.0%
TAB 5
 
5.0%
TLB 4
 
4.0%
Other values (12) 22
22.0%

Length

2023-12-13T05:03:48.665810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
tho 13
13.0%
tha 12
12.0%
tla 9
9.0%
tpb 8
 
8.0%
qad 7
 
7.0%
tac 7
 
7.0%
thb 7
 
7.0%
tba 6
 
6.0%
tab 5
 
5.0%
tlb 4
 
4.0%
Other values (12) 22
22.0%

최초등록일시
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2021-06-08
76 
2021-06-07
24 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-06-08
2nd row2021-06-08
3rd row2021-06-08
4th row2021-06-08
5th row2021-06-08

Common Values

ValueCountFrequency (%)
2021-06-08 76
76.0%
2021-06-07 24
 
24.0%

Length

2023-12-13T05:03:48.816531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:03:48.928697image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-06-08 76
76.0%
2021-06-07 24
 
24.0%

최초등록부점
Categorical

CONSTANT 

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

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
999 100
100.0%

Length

2023-12-13T05:03:49.030464image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:03:49.120471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
999 100
100.0%

대출기관
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)8.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
우리은행
43 
SC은행
33 
수협은행
11 
경남은행
 
4
교보생명
 
4
Other values (3)
5 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique2 ?
Unique (%)2.0%

Sample

1st rowSC은행
2nd rowSC은행
3rd rowSC은행
4th rowSC은행
5th rowSC은행

Common Values

ValueCountFrequency (%)
우리은행 43
43.0%
SC은행 33
33.0%
수협은행 11
 
11.0%
경남은행 4
 
4.0%
교보생명 4
 
4.0%
하나은행 3
 
3.0%
농협은행 1
 
1.0%
제주은행 1
 
1.0%

Length

2023-12-13T05:03:49.228390image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:03:49.355071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
우리은행 43
43.0%
sc은행 33
33.0%
수협은행 11
 
11.0%
경남은행 4
 
4.0%
교보생명 4
 
4.0%
하나은행 3
 
3.0%
농협은행 1
 
1.0%
제주은행 1
 
1.0%

Interactions

2023-12-13T05:03:47.226672image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T05:03:49.456847image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상품대분류상품중분류상품금액부점최초등록일시대출기관
상품대분류1.0001.0001.0000.5530.6410.6561.000
상품중분류1.0001.0001.0000.4620.7810.2931.000
상품1.0001.0001.0000.6530.6910.3760.914
금액0.5530.4620.6531.0000.0000.5270.521
부점0.6410.7810.6910.0001.0000.1660.900
최초등록일시0.6560.2930.3760.5270.1661.0000.733
대출기관1.0001.0000.9140.5210.9000.7331.000
2023-12-13T05:03:49.607629image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상품최초등록일시상품대분류상품중분류대출기관부점
상품1.0000.4510.9850.9900.8410.387
최초등록일시0.4511.0000.4560.4710.5440.108
상품대분류0.9850.4561.0000.9950.9690.457
상품중분류0.9900.4710.9951.0000.9740.525
대출기관0.8410.5440.9690.9741.0000.603
부점0.3870.1080.4570.5250.6031.000
2023-12-13T05:03:49.737779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
금액상품대분류상품중분류상품부점최초등록일시대출기관
금액1.0000.4200.3110.3110.0000.3860.276
상품대분류0.4201.0000.9950.9850.4570.4560.969
상품중분류0.3110.9951.0000.9900.5250.4710.974
상품0.3110.9850.9901.0000.3870.4510.841
부점0.0000.4570.5250.3871.0000.1080.603
최초등록일시0.3860.4560.4710.4510.1081.0000.544
대출기관0.2760.9690.9740.8410.6030.5441.000

Missing values

2023-12-13T05:03:47.347286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T05:03:47.493893image/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

상품대분류상품중분류상품금액부점최초등록일시최초등록부점대출기관
023120301318000000QAD2021-06-08999SC은행
123120301272000000TAA2021-06-08999SC은행
22312030140000000TBA2021-06-08999SC은행
32312030180000000TBA2021-06-08999SC은행
42312030198000000QAD2021-06-08999SC은행
523120301150000000THA2021-06-08999SC은행
623120301435000000THA2021-06-08999SC은행
72312030150000000THB2021-06-08999SC은행
82312030141400000THB2021-06-08999SC은행
92312030142000000TJA2021-06-08999SC은행
상품대분류상품중분류상품금액부점최초등록일시최초등록부점대출기관
902312030165000000TAA2021-06-07999SC은행
912312030180500000TJA2021-06-07999SC은행
9223120301100000000THO2021-06-07999SC은행
9323120301300000000TLB2021-06-07999SC은행
9423120301120000000THB2021-06-07999SC은행
952312030190000000TLA2021-06-07999SC은행
962312030173500000TLA2021-06-07999SC은행
972312030160000000THO2021-06-07999SC은행
982312030145700000THO2021-06-07999SC은행
992312030123000000TPB2021-06-07999SC은행

Duplicate rows

Most frequently occurring

상품대분류상품중분류상품금액부점최초등록일시최초등록부점대출기관# duplicates
011110108300000000THB2021-06-08999우리은행2
123120305156000000QAD2021-06-08999수협은행2