Overview

Dataset statistics

Number of variables8
Number of observations294
Missing cells0
Missing cells (%)0.0%
Duplicate rows8
Duplicate rows (%)2.7%
Total size in memory19.9 KiB
Average record size in memory69.4 B

Variable types

Categorical5
Numeric3

Dataset

Description제주특별자치도개발공사가 준공, 관리하는 행복주택 마음에온 현황으로 주소, 준공일, 전용면적, 세대수, 공급유형, 공급형태, 공급연도 등을 포함하는 데이터 입니다.
URLhttps://www.data.go.kr/data/15038957/fileData.do

Alerts

공급유형 has constant value ""Constant
Dataset has 8 (2.7%) duplicate rowsDuplicates
구분 is highly overall correlated with 전용면적(제곱미터) and 4 other fieldsHigh correlation
주소 is highly overall correlated with 전용면적(제곱미터) and 4 other fieldsHigh correlation
준공 is highly overall correlated with 전용면적(제곱미터) and 4 other fieldsHigh correlation
공급연도 is highly overall correlated with 전용면적(제곱미터) and 4 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 세대수High correlation

Reproduction

Analysis started2023-12-12 12:52:30.201595
Analysis finished2023-12-12 12:52:31.360733
Duration1.16 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
마음에온 건입
144 
마음에온 아라
39 
마음에온 함덕 101동
32 
마음에온 삼도일동
26 
마음에온 삼도이동
21 
Other values (2)
32 

Length

Max length12
Median length7
Mean length8.1360544
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row마음에온 아라
2nd row마음에온 아라
3rd row마음에온 아라
4th row마음에온 아라
5th row마음에온 아라

Common Values

ValueCountFrequency (%)
마음에온 건입 144
49.0%
마음에온 아라 39
 
13.3%
마음에온 함덕 101동 32
 
10.9%
마음에온 삼도일동 26
 
8.8%
마음에온 삼도이동 21
 
7.1%
마음에온 함덕 102동 16
 
5.4%
마음에온 한림 16
 
5.4%

Length

2023-12-12T21:52:31.423872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:52:31.542683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
마음에온 294
46.2%
건입 144
22.6%
함덕 48
 
7.5%
아라 39
 
6.1%
101동 32
 
5.0%
삼도일동 26
 
4.1%
삼도이동 21
 
3.3%
102동 16
 
2.5%
한림 16
 
2.5%

주소
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
제주특별자치도 제주시 임항로77
144 
제주특별자치도 제주시 조천읍 조함해안로 642
48 
제주특별자치도 제주시 연북로628
39 
제주특별자치도 제주시 충효4길 9
26 
제주특별자치도 제주시 남중서1길 24
21 

Length

Max length25
Median length22
Mean length19.013605
Min length17

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제주특별자치도 제주시 연북로628
2nd row제주특별자치도 제주시 연북로628
3rd row제주특별자치도 제주시 연북로628
4th row제주특별자치도 제주시 연북로628
5th row제주특별자치도 제주시 연북로628

Common Values

ValueCountFrequency (%)
제주특별자치도 제주시 임항로77 144
49.0%
제주특별자치도 제주시 조천읍 조함해안로 642 48
 
16.3%
제주특별자치도 제주시 연북로628 39
 
13.3%
제주특별자치도 제주시 충효4길 9 26
 
8.8%
제주특별자치도 제주시 남중서1길 24 21
 
7.1%
제주특별자치도 제주시 한림상로 142-5 16
 
5.4%

Length

2023-12-12T21:52:31.683295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:52:31.858847image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제주특별자치도 294
28.2%
제주시 294
28.2%
임항로77 144
13.8%
조천읍 48
 
4.6%
조함해안로 48
 
4.6%
642 48
 
4.6%
연북로628 39
 
3.7%
충효4길 26
 
2.5%
9 26
 
2.5%
남중서1길 21
 
2.0%
Other values (3) 53
 
5.1%

준공
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
2022
144 
2018
113 
2021
21 
2019
16 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2022 144
49.0%
2018 113
38.4%
2021 21
 
7.1%
2019 16
 
5.4%

Length

2023-12-12T21:52:32.025430image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:52:32.145957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022 144
49.0%
2018 113
38.4%
2021 21
 
7.1%
2019 16
 
5.4%

전용면적(제곱미터)
Real number (ℝ)

HIGH CORRELATION 

Distinct16
Distinct (%)5.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28.996599
Minimum18
Maximum42
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.7 KiB
2023-12-12T21:52:32.256541image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum18
5-th percentile18
Q121
median30
Q337
95-th percentile40
Maximum42
Range24
Interquartile range (IQR)16

Descriptive statistics

Standard deviation8.101952
Coefficient of variation (CV)0.27941043
Kurtosis-1.495889
Mean28.996599
Median Absolute Deviation (MAD)7
Skewness0.008356262
Sum8525
Variance65.641627
MonotonicityNot monotonic
2023-12-12T21:52:32.359788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%)
37 58
19.7%
18 46
15.6%
30 40
13.6%
40 32
10.9%
25 30
10.2%
21 29
9.9%
20 10
 
3.4%
28 9
 
3.1%
27 9
 
3.1%
19 8
 
2.7%
Other values (6) 23
 
7.8%
ValueCountFrequency (%)
18 46
15.6%
19 8
 
2.7%
20 10
 
3.4%
21 29
9.9%
25 30
10.2%
27 9
 
3.1%
28 9
 
3.1%
29 3
 
1.0%
30 40
13.6%
36 5
 
1.7%
ValueCountFrequency (%)
42 3
 
1.0%
41 4
 
1.4%
40 32
10.9%
39 4
 
1.4%
38 4
 
1.4%
37 58
19.7%
36 5
 
1.7%
30 40
13.6%
29 3
 
1.0%
28 9
 
3.1%

세대수
Real number (ℝ)

HIGH CORRELATION 

Distinct14
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean31.340136
Minimum3
Maximum58
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.7 KiB
2023-12-12T21:52:32.475510image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile4
Q114
median26
Q346
95-th percentile58
Maximum58
Range55
Interquartile range (IQR)32

Descriptive statistics

Standard deviation19.25489
Coefficient of variation (CV)0.61438439
Kurtosis-1.4402997
Mean31.340136
Median Absolute Deviation (MAD)18
Skewness-0.0018188315
Sum9214
Variance370.75081
MonotonicityNot monotonic
2023-12-12T21:52:32.571174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
58 58
19.7%
46 46
15.6%
40 40
13.6%
26 26
8.8%
24 24
8.2%
4 16
 
5.4%
8 16
 
5.4%
15 15
 
5.1%
14 14
 
4.8%
10 10
 
3.4%
Other values (4) 29
9.9%
ValueCountFrequency (%)
3 9
 
3.1%
4 16
5.4%
5 5
 
1.7%
6 6
 
2.0%
8 16
5.4%
9 9
 
3.1%
10 10
3.4%
14 14
4.8%
15 15
5.1%
24 24
8.2%
ValueCountFrequency (%)
58 58
19.7%
46 46
15.6%
40 40
13.6%
26 26
8.8%
24 24
8.2%
15 15
 
5.1%
14 14
 
4.8%
10 10
 
3.4%
9 9
 
3.1%
8 16
 
5.4%

공급유형
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
건설
294 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row건설
2nd row건설
3rd row건설
4th row건설
5th row건설

Common Values

ValueCountFrequency (%)
건설 294
100.0%

Length

2023-12-12T21:52:32.680247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:52:32.762329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
건설 294
100.0%

공급형태
Real number (ℝ)

HIGH CORRELATION 

Distinct176
Distinct (%)59.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean503.22449
Minimum101
Maximum1123
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.7 KiB
2023-12-12T21:52:32.857373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum101
5-th percentile201
Q1304
median411.5
Q3706.75
95-th percentile1014.35
Maximum1123
Range1022
Interquartile range (IQR)402.75

Descriptive statistics

Standard deviation257.30972
Coefficient of variation (CV)0.51132193
Kurtosis-0.54293908
Mean503.22449
Median Absolute Deviation (MAD)196
Skewness0.60402896
Sum147948
Variance66208.291
MonotonicityNot monotonic
2023-12-12T21:52:32.975971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
404 7
 
2.4%
403 7
 
2.4%
402 7
 
2.4%
401 7
 
2.4%
201 6
 
2.0%
303 6
 
2.0%
203 6
 
2.0%
204 6
 
2.0%
405 6
 
2.0%
202 6
 
2.0%
Other values (166) 230
78.2%
ValueCountFrequency (%)
101 2
 
0.7%
102 2
 
0.7%
103 2
 
0.7%
104 2
 
0.7%
105 2
 
0.7%
201 6
2.0%
202 6
2.0%
203 6
2.0%
204 6
2.0%
205 4
1.4%
ValueCountFrequency (%)
1123 1
0.3%
1122 1
0.3%
1121 1
0.3%
1120 1
0.3%
1119 1
0.3%
1118 1
0.3%
1023 1
0.3%
1022 1
0.3%
1021 1
0.3%
1020 1
0.3%

공급연도
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
2022
144 
2019
90 
2018
39 
2021
21 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2022 144
49.0%
2019 90
30.6%
2018 39
 
13.3%
2021 21
 
7.1%

Length

2023-12-12T21:52:33.090556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:52:33.201526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022 144
49.0%
2019 90
30.6%
2018 39
 
13.3%
2021 21
 
7.1%

Interactions

2023-12-12T21:52:30.930794image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:52:30.489260image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:52:30.702748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:52:31.009054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:52:30.552923image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:52:30.776976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:52:31.082814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:52:30.625566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:52:30.854298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T21:52:33.281822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분주소준공전용면적(제곱미터)세대수공급형태공급연도
구분1.0001.0001.0000.8050.8320.5901.000
주소1.0001.0001.0000.8730.8580.6241.000
준공1.0001.0001.0000.7520.9470.6940.984
전용면적(제곱미터)0.8050.8730.7521.0000.9490.6110.828
세대수0.8320.8580.9470.9491.0000.6480.974
공급형태0.5900.6240.6940.6110.6481.0000.700
공급연도1.0001.0000.9840.8280.9740.7001.000
2023-12-12T21:52:33.375101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분주소준공공급연도
구분1.0000.9980.9950.995
주소0.9981.0000.9970.997
준공0.9950.9971.0000.827
공급연도0.9950.9970.8271.000
2023-12-12T21:52:33.473675image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전용면적(제곱미터)세대수공급형태구분주소준공공급연도
전용면적(제곱미터)1.000-0.0060.0920.5580.6120.5520.622
세대수-0.0061.0000.6810.6570.7190.6810.771
공급형태0.0920.6811.0000.3470.3870.4900.497
구분0.5580.6570.3471.0000.9980.9950.995
주소0.6120.7190.3870.9981.0000.9970.997
준공0.5520.6810.4900.9950.9971.0000.827
공급연도0.6220.7710.4970.9950.9970.8271.000

Missing values

2023-12-12T21:52:31.186035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:52:31.303350image/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

구분주소준공전용면적(제곱미터)세대수공급유형공급형태공급연도
0마음에온 아라제주특별자치도 제주시 연북로6282018289건설2012018
1마음에온 아라제주특별자치도 제주시 연북로6282018289건설2022018
2마음에온 아라제주특별자치도 제주시 연북로6282018273건설2032018
3마음에온 아라제주특별자치도 제주시 연북로6282018293건설2042018
4마음에온 아라제주특별자치도 제주시 연북로62820184024건설2052018
5마음에온 아라제주특별자치도 제주시 연북로62820184024건설2062018
6마음에온 아라제주특별자치도 제주시 연북로62820184024건설2072018
7마음에온 아라제주특별자치도 제주시 연북로62820184024건설2082018
8마음에온 아라제주특별자치도 제주시 연북로62820184024건설2092018
9마음에온 아라제주특별자치도 제주시 연북로62820184024건설2102018
구분주소준공전용면적(제곱미터)세대수공급유형공급형태공급연도
284마음에온 건입제주특별자치도 제주시 임항로7720223040건설10202022
285마음에온 건입제주특별자치도 제주시 임항로7720223040건설10212022
286마음에온 건입제주특별자치도 제주시 임항로7720223040건설10222022
287마음에온 건입제주특별자치도 제주시 임항로7720223040건설10232022
288마음에온 건입제주특별자치도 제주시 임항로7720223758건설11182022
289마음에온 건입제주특별자치도 제주시 임항로7720223040건설11192022
290마음에온 건입제주특별자치도 제주시 임항로7720223040건설11202022
291마음에온 건입제주특별자치도 제주시 임항로7720223040건설11212022
292마음에온 건입제주특별자치도 제주시 임항로7720223040건설11222022
293마음에온 건입제주특별자치도 제주시 임항로7720223040건설11232022

Duplicate rows

Most frequently occurring

구분주소준공전용면적(제곱미터)세대수공급유형공급형태공급연도# duplicates
0마음에온 함덕 101동제주특별자치도 제주시 조천읍 조함해안로 64220182526건설10320192
1마음에온 함덕 101동제주특별자치도 제주시 조천읍 조함해안로 64220182526건설20120192
2마음에온 함덕 101동제주특별자치도 제주시 조천읍 조함해안로 64220182526건설20420192
3마음에온 함덕 101동제주특별자치도 제주시 조천읍 조함해안로 64220182526건설20720192
4마음에온 함덕 101동제주특별자치도 제주시 조천읍 조함해안로 64220182526건설30320192
5마음에온 함덕 101동제주특별자치도 제주시 조천읍 조함해안로 64220182526건설30620192
6마음에온 함덕 101동제주특별자치도 제주시 조천읍 조함해안로 6422018384건설40520192
7마음에온 함덕 101동제주특별자치도 제주시 조천읍 조함해안로 6422018394건설40220192