Overview

Dataset statistics

Number of variables9
Number of observations130
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.8 KiB
Average record size in memory77.0 B

Variable types

Categorical5
Numeric2
Text2

Dataset

Description양주시 관내 마을회관 현황입니다. 이와 관련된 데이터로서 주소, 마을회관명,연면적(제곱미터),동 수 등을 포함하고 있습니다.
Author경기도 양주시
URLhttps://www.data.go.kr/data/3077276/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 (76.5%)Imbalance
연번 has unique valuesUnique

Reproduction

Analysis started2024-04-17 15:56:22.108272
Analysis finished2024-04-17 15:56:23.008869
Duration0.9 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)8.5%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
남면
22 
백석읍
20 
광적면
17 
은현면
15 
장흥면
13 
Other values (6)
43 

Length

Max length4
Median length3.5
Mean length3.1615385
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row백석읍
2nd row백석읍
3rd row백석읍
4th row백석읍
5th row백석읍

Common Values

ValueCountFrequency (%)
남면 22
16.9%
백석읍 20
15.4%
광적면 17
13.1%
은현면 15
11.5%
장흥면 13
10.0%
양주1동 12
9.2%
회천1동 9
6.9%
양주2동 8
 
6.2%
회천2동 8
 
6.2%
회천4동 4
 
3.1%

Length

2024-04-18T00:56:23.066113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
남면 22
16.9%
백석읍 20
15.4%
광적면 17
13.1%
은현면 15
11.5%
장흥면 13
10.0%
양주1동 12
9.2%
회천1동 9
6.9%
양주2동 8
 
6.2%
회천2동 8
 
6.2%
회천4동 4
 
3.1%

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct130
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean65.5
Minimum1
Maximum130
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2024-04-18T00:56:23.169082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile7.45
Q133.25
median65.5
Q397.75
95-th percentile123.55
Maximum130
Range129
Interquartile range (IQR)64.5

Descriptive statistics

Standard deviation37.671829
Coefficient of variation (CV)0.57514242
Kurtosis-1.2
Mean65.5
Median Absolute Deviation (MAD)32.5
Skewness0
Sum8515
Variance1419.1667
MonotonicityStrictly increasing
2024-04-18T00:56:23.280480image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.8%
99 1
 
0.8%
97 1
 
0.8%
96 1
 
0.8%
95 1
 
0.8%
94 1
 
0.8%
93 1
 
0.8%
92 1
 
0.8%
91 1
 
0.8%
90 1
 
0.8%
Other values (120) 120
92.3%
ValueCountFrequency (%)
1 1
0.8%
2 1
0.8%
3 1
0.8%
4 1
0.8%
5 1
0.8%
6 1
0.8%
7 1
0.8%
8 1
0.8%
9 1
0.8%
10 1
0.8%
ValueCountFrequency (%)
130 1
0.8%
129 1
0.8%
128 1
0.8%
127 1
0.8%
126 1
0.8%
125 1
0.8%
124 1
0.8%
123 1
0.8%
122 1
0.8%
121 1
0.8%

주소
Text

Distinct129
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2024-04-18T00:56:23.515543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length23
Mean length17.376923
Min length13

Characters and Unicode

Total characters2259
Distinct characters90
Distinct categories6 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique128 ?
Unique (%)98.5%

Sample

1st row경기도양주시백석읍 방성리 238
2nd row경기도양주시백석읍 방성리 85-10
3rd row경기도양주시백석읍 방성리 345-3
4th row경기도양주시백석읍 방성리 692-8
5th row경기도양주시백석읍 방성리 5-20
ValueCountFrequency (%)
경기도양주시남면 22
 
6.2%
경기도양주시백석읍 20
 
5.7%
경기도양주시광적면 17
 
4.8%
경기도양주시은현면 14
 
4.0%
경기도양주시장흥면 13
 
3.7%
방성리 5
 
1.4%
경기도양주시덕정동 5
 
1.4%
상수리 5
 
1.4%
신산리 4
 
1.1%
경기도양주시봉양동 4
 
1.1%
Other values (182) 244
69.1%
2024-04-18T00:56:23.844958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
223
 
9.9%
136
 
6.0%
135
 
6.0%
131
 
5.8%
131
 
5.8%
130
 
5.8%
130
 
5.8%
- 108
 
4.8%
1 101
 
4.5%
87
 
3.9%
Other values (80) 947
41.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1414
62.6%
Decimal Number 512
 
22.7%
Space Separator 223
 
9.9%
Dash Punctuation 108
 
4.8%
Close Punctuation 1
 
< 0.1%
Open Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
136
 
9.6%
135
 
9.5%
131
 
9.3%
131
 
9.3%
130
 
9.2%
130
 
9.2%
87
 
6.2%
67
 
4.7%
43
 
3.0%
26
 
1.8%
Other values (66) 398
28.1%
Decimal Number
ValueCountFrequency (%)
1 101
19.7%
3 73
14.3%
2 67
13.1%
4 53
10.4%
5 45
8.8%
7 41
8.0%
6 39
 
7.6%
0 38
 
7.4%
8 32
 
6.2%
9 23
 
4.5%
Space Separator
ValueCountFrequency (%)
223
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 108
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1414
62.6%
Common 845
37.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
136
 
9.6%
135
 
9.5%
131
 
9.3%
131
 
9.3%
130
 
9.2%
130
 
9.2%
87
 
6.2%
67
 
4.7%
43
 
3.0%
26
 
1.8%
Other values (66) 398
28.1%
Common
ValueCountFrequency (%)
223
26.4%
- 108
12.8%
1 101
12.0%
3 73
 
8.6%
2 67
 
7.9%
4 53
 
6.3%
5 45
 
5.3%
7 41
 
4.9%
6 39
 
4.6%
0 38
 
4.5%
Other values (4) 57
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1414
62.6%
ASCII 845
37.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
223
26.4%
- 108
12.8%
1 101
12.0%
3 73
 
8.6%
2 67
 
7.9%
4 53
 
6.3%
5 45
 
5.3%
7 41
 
4.9%
6 39
 
4.6%
0 38
 
4.5%
Other values (4) 57
 
6.7%
Hangul
ValueCountFrequency (%)
136
 
9.6%
135
 
9.5%
131
 
9.3%
131
 
9.3%
130
 
9.2%
130
 
9.2%
87
 
6.2%
67
 
4.7%
43
 
3.0%
26
 
1.8%
Other values (66) 398
28.1%
Distinct129
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2024-04-18T00:56:24.023348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length8
Mean length8.2461538
Min length4

Characters and Unicode

Total characters1072
Distinct characters104
Distinct categories6 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique128 ?
Unique (%)98.5%

Sample

1st row방성1리마을회관
2nd row방성2리마을회관
3rd row방성3리마을회관
4th row방성4리마을회관
5th row방성5리마을회관
ValueCountFrequency (%)
마을회관 9
 
6.3%
상수2리마을회관 2
 
1.4%
어둔동 2
 
1.4%
연곡1리마을회관 2
 
1.4%
덕도2리마을회관 1
 
0.7%
덕도3리마을회관 1
 
0.7%
산북1통마을회관 1
 
0.7%
마전1통마을회관 1
 
0.7%
남방4통마을회관 1
 
0.7%
남방3통마을회관 1
 
0.7%
Other values (122) 122
85.3%
2024-04-18T00:56:24.299223image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
137
12.8%
129
12.0%
128
11.9%
126
11.8%
90
 
8.4%
2 43
 
4.0%
1 39
 
3.6%
32
 
3.0%
21
 
2.0%
3 14
 
1.3%
Other values (94) 313
29.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 938
87.5%
Decimal Number 106
 
9.9%
Space Separator 13
 
1.2%
Open Punctuation 7
 
0.7%
Close Punctuation 7
 
0.7%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
137
14.6%
129
13.8%
128
13.6%
126
13.4%
90
 
9.6%
32
 
3.4%
21
 
2.2%
14
 
1.5%
11
 
1.2%
11
 
1.2%
Other values (84) 239
25.5%
Decimal Number
ValueCountFrequency (%)
2 43
40.6%
1 39
36.8%
3 14
 
13.2%
4 6
 
5.7%
5 3
 
2.8%
6 1
 
0.9%
Space Separator
ValueCountFrequency (%)
13
100.0%
Open Punctuation
ValueCountFrequency (%)
( 7
100.0%
Close Punctuation
ValueCountFrequency (%)
) 7
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 938
87.5%
Common 134
 
12.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
137
14.6%
129
13.8%
128
13.6%
126
13.4%
90
 
9.6%
32
 
3.4%
21
 
2.2%
14
 
1.5%
11
 
1.2%
11
 
1.2%
Other values (84) 239
25.5%
Common
ValueCountFrequency (%)
2 43
32.1%
1 39
29.1%
3 14
 
10.4%
13
 
9.7%
( 7
 
5.2%
) 7
 
5.2%
4 6
 
4.5%
5 3
 
2.2%
6 1
 
0.7%
, 1
 
0.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 938
87.5%
ASCII 134
 
12.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
137
14.6%
129
13.8%
128
13.6%
126
13.4%
90
 
9.6%
32
 
3.4%
21
 
2.2%
14
 
1.5%
11
 
1.2%
11
 
1.2%
Other values (84) 239
25.5%
ASCII
ValueCountFrequency (%)
2 43
32.1%
1 39
29.1%
3 14
 
10.4%
13
 
9.7%
( 7
 
5.2%
) 7
 
5.2%
4 6
 
4.5%
5 3
 
2.2%
6 1
 
0.7%
, 1
 
0.7%

연면적(제곱미터)
Real number (ℝ)

HIGH CORRELATION 

Distinct111
Distinct (%)85.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean224.87392
Minimum40
Maximum837
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2024-04-18T00:56:24.410980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum40
5-th percentile81.45
Q1149.25
median199
Q3265
95-th percentile432.4
Maximum837
Range797
Interquartile range (IQR)115.75

Descriptive statistics

Standard deviation130.49419
Coefficient of variation (CV)0.58029933
Kurtosis8.7310085
Mean224.87392
Median Absolute Deviation (MAD)59.5
Skewness2.4428015
Sum29233.61
Variance17028.733
MonotonicityNot monotonic
2024-04-18T00:56:24.519019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
198.0 8
 
6.2%
199.0 6
 
4.6%
265.0 2
 
1.5%
157.0 2
 
1.5%
98.0 2
 
1.5%
269.0 2
 
1.5%
165.0 2
 
1.5%
253.0 2
 
1.5%
129.0 2
 
1.5%
67.68 1
 
0.8%
Other values (101) 101
77.7%
ValueCountFrequency (%)
40.0 1
0.8%
62.0 1
0.8%
67.68 1
0.8%
73.0 1
0.8%
79.0 1
0.8%
80.0 1
0.8%
81.0 1
0.8%
82.0 1
0.8%
83.76 1
0.8%
94.0 1
0.8%
ValueCountFrequency (%)
837.0 1
0.8%
836.0 1
0.8%
792.0 1
0.8%
559.0 1
0.8%
509.8 1
0.8%
447.0 1
0.8%
445.0 1
0.8%
417.0 1
0.8%
396.0 1
0.8%
389.5 1
0.8%

동 수
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
1
125 
2
 
5

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 125
96.2%
2 5
 
3.8%

Length

2024-04-18T00:56:24.620310image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T00:56:24.690602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 125
96.2%
2 5
 
3.8%

층 수
Categorical

Distinct3
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2
91 
1
30 
3
 
9

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2 91
70.0%
1 30
 
23.1%
3 9
 
6.9%

Length

2024-04-18T00:56:24.771346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T00:56:24.845495image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 91
70.0%
1 30
 
23.1%
3 9
 
6.9%

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
양주시 주택과
130 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row양주시 주택과
2nd row양주시 주택과
3rd row양주시 주택과
4th row양주시 주택과
5th row양주시 주택과

Common Values

ValueCountFrequency (%)
양주시 주택과 130
100.0%

Length

2024-04-18T00:56:24.925389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T00:56:24.994010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
양주시 130
50.0%
주택과 130
50.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2022-07-19
130 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-07-19
2nd row2022-07-19
3rd row2022-07-19
4th row2022-07-19
5th row2022-07-19

Common Values

ValueCountFrequency (%)
2022-07-19 130
100.0%

Length

2024-04-18T00:56:25.066225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T00:56:25.136141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-07-19 130
100.0%

Interactions

2024-04-18T00:56:22.715344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-18T00:56:22.572399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-18T00:56:22.784045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-18T00:56:22.638823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-18T00:56:25.179979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분연번연면적(제곱미터)동 수층 수
구분1.0000.9150.1250.0000.145
연번0.9151.0000.1940.0710.300
연면적(제곱미터)0.1250.1941.0000.7720.619
동 수0.0000.0710.7721.0000.040
층 수0.1450.3000.6190.0401.000
2024-04-18T00:56:25.253821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
층 수동 수구분
층 수1.0000.0650.078
동 수0.0651.0000.000
구분0.0780.0001.000
2024-04-18T00:56:25.319504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번연면적(제곱미터)구분동 수층 수
연번1.000-0.1300.7070.0470.182
연면적(제곱미터)-0.1301.0000.0530.5820.480
구분0.7070.0531.0000.0000.078
동 수0.0470.5820.0001.0000.065
층 수0.1820.4800.0780.0651.000

Missing values

2024-04-18T00:56:22.873989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-18T00:56:22.970564image/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백석읍1경기도양주시백석읍 방성리 238방성1리마을회관836.022양주시 주택과2022-07-19
1백석읍2경기도양주시백석읍 방성리 85-10방성2리마을회관253.013양주시 주택과2022-07-19
2백석읍3경기도양주시백석읍 방성리 345-3방성3리마을회관129.011양주시 주택과2022-07-19
3백석읍4경기도양주시백석읍 방성리 692-8방성4리마을회관184.012양주시 주택과2022-07-19
4백석읍5경기도양주시백석읍 방성리 5-20방성5리마을회관80.012양주시 주택과2022-07-19
5백석읍6경기도양주시백석읍 오산리 73-2오산1리마을회관73.011양주시 주택과2022-07-19
6백석읍7경기도양주시백석읍 오산리 535-5오산2리마을회관140.011양주시 주택과2022-07-19
7백석읍8경기도양주시백석읍 오산리 424-3오산3리마을회관198.011양주시 주택과2022-07-19
8백석읍9경기도양주시백석읍 오산리 190-5오산4리마을회관169.011양주시 주택과2022-07-19
9백석읍10경기도양주시백석읍 복지리 106-3복지1리마을회관396.012양주시 주택과2022-07-19
구분연번주소마을회관명연면적(제곱미터)동 수층 수관리기관명데이터기준일자
120회천2동121경기도양주시회정동 421-28회정1통마을회관209.012양주시 주택과2022-07-19
121회천2동122경기도양주시덕계동 417-11덕계12통마을회관208.012양주시 주택과2022-07-19
122회천2동123경기도양주시회정동 325-5회정3통마을회관157.012양주시 주택과2022-07-19
123회천2동124경기도양주시덕계동 477-4덕계1통249.213양주시 주택과2022-07-19
124회천3동125경기도양주시고암동 386-5고암2통마을회관274.012양주시 주택과2022-07-19
125회천3동126경기도양주시고암동 140-8엄상1,2통 마을회관105.2811양주시 주택과2022-07-19
126회천4동127경기도양주시회암동 161-16회암1통마을회관377.012양주시 주택과2022-07-19
127회천4동128경기도양주시회암동 553-8회암2통마을회관261.012양주시 주택과2022-07-19
128회천4동129경기도양주시회암동 447-5회암리회관(연동)40.011양주시 주택과2022-07-19
129회천4동130경기도양주시율정동 260-1율정2통마을회관143.012양주시 주택과2022-07-19