Overview

Dataset statistics

Number of variables9
Number of observations320
Missing cells321
Missing cells (%)11.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory23.9 KiB
Average record size in memory76.4 B

Variable types

Numeric3
Categorical2
Text2
DateTime1
Unsupported1

Dataset

Description경상남도 거제시 경로당 정보에 대한 현황을 제공합니다(면동, 경로당명칭, 소재지, 위도, 경도, 등록일자, 기준일자)에 대한 정보를 제공합니다.
Author경상남도 거제시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15037762

Alerts

기준일자 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 연번 and 2 other fieldsHigh correlation
Unnamed: 8 has 320 (100.0%) missing valuesMissing
연번 has unique valuesUnique
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-11 00:36:34.865245
Analysis finished2023-12-11 00:36:36.096797
Duration1.23 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct320
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean160.5
Minimum1
Maximum320
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.9 KiB
2023-12-11T09:36:36.160355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile16.95
Q180.75
median160.5
Q3240.25
95-th percentile304.05
Maximum320
Range319
Interquartile range (IQR)159.5

Descriptive statistics

Standard deviation92.520268
Coefficient of variation (CV)0.57645027
Kurtosis-1.2
Mean160.5
Median Absolute Deviation (MAD)80
Skewness0
Sum51360
Variance8560
MonotonicityStrictly increasing
2023-12-11T09:36:36.289529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
162 1
 
0.3%
220 1
 
0.3%
219 1
 
0.3%
218 1
 
0.3%
217 1
 
0.3%
216 1
 
0.3%
215 1
 
0.3%
214 1
 
0.3%
213 1
 
0.3%
Other values (310) 310
96.9%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
320 1
0.3%
319 1
0.3%
318 1
0.3%
317 1
0.3%
316 1
0.3%
315 1
0.3%
314 1
0.3%
313 1
0.3%
312 1
0.3%
311 1
0.3%

면동
Categorical

HIGH CORRELATION 

Distinct18
Distinct (%)5.6%
Missing0
Missing (%)0.0%
Memory size2.6 KiB
사등면
31 
장목면
29 
연초면
28 
거제면
27 
하청면
27 
Other values (13)
178 

Length

Max length4
Median length3
Mean length3.090625
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일운면
2nd row일운면
3rd row일운면
4th row일운면
5th row일운면

Common Values

ValueCountFrequency (%)
사등면 31
 
9.7%
장목면 29
 
9.1%
연초면 28
 
8.8%
거제면 27
 
8.4%
하청면 27
 
8.4%
둔덕면 21
 
6.6%
일운면 20
 
6.2%
동부면 20
 
6.2%
고현동 19
 
5.9%
옥포2동 16
 
5.0%
Other values (8) 82
25.6%

Length

2023-12-11T09:36:36.406615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
사등면 31
 
9.7%
장목면 29
 
9.1%
연초면 28
 
8.8%
거제면 27
 
8.4%
하청면 27
 
8.4%
둔덕면 21
 
6.6%
일운면 20
 
6.2%
동부면 20
 
6.2%
고현동 19
 
5.9%
상문동 16
 
5.0%
Other values (8) 82
25.6%
Distinct313
Distinct (%)97.8%
Missing0
Missing (%)0.0%
Memory size2.6 KiB
2023-12-11T09:36:36.611024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length5
Mean length6.03125
Min length4

Characters and Unicode

Total characters1930
Distinct characters236
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique306 ?
Unique (%)95.6%

Sample

1st row대신경로당
2nd row구조라수정경로당
3rd row대동경로당
4th row망치경로당
5th row하촌경로당
ValueCountFrequency (%)
두모경로당 2
 
0.6%
롯데인벤스경로당 2
 
0.6%
덕산3차경로당 2
 
0.6%
서상경로당 2
 
0.6%
신촌경로당 2
 
0.6%
죽전경로당 2
 
0.6%
실전경로당 2
 
0.6%
율북경로당 1
 
0.3%
능포11통경로당 1
 
0.3%
중앙경로당 1
 
0.3%
Other values (303) 303
94.7%
2023-12-11T09:36:36.915093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
317
 
16.4%
317
 
16.4%
317
 
16.4%
31
 
1.6%
30
 
1.6%
30
 
1.6%
26
 
1.3%
23
 
1.2%
21
 
1.1%
21
 
1.1%
Other values (226) 797
41.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1880
97.4%
Decimal Number 37
 
1.9%
Uppercase Letter 5
 
0.3%
Close Punctuation 2
 
0.1%
Open Punctuation 2
 
0.1%
Other Punctuation 2
 
0.1%
Dash Punctuation 1
 
0.1%
Lowercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
317
16.9%
317
16.9%
317
16.9%
31
 
1.6%
30
 
1.6%
30
 
1.6%
26
 
1.4%
23
 
1.2%
21
 
1.1%
21
 
1.1%
Other values (209) 747
39.7%
Decimal Number
ValueCountFrequency (%)
1 12
32.4%
2 9
24.3%
3 7
18.9%
6 3
 
8.1%
4 3
 
8.1%
5 2
 
5.4%
7 1
 
2.7%
Uppercase Letter
ValueCountFrequency (%)
K 1
20.0%
S 1
20.0%
A 1
20.0%
H 1
20.0%
L 1
20.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Other Punctuation
ValueCountFrequency (%)
. 2
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1880
97.4%
Common 44
 
2.3%
Latin 6
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
317
16.9%
317
16.9%
317
16.9%
31
 
1.6%
30
 
1.6%
30
 
1.6%
26
 
1.4%
23
 
1.2%
21
 
1.1%
21
 
1.1%
Other values (209) 747
39.7%
Common
ValueCountFrequency (%)
1 12
27.3%
2 9
20.5%
3 7
15.9%
6 3
 
6.8%
4 3
 
6.8%
) 2
 
4.5%
( 2
 
4.5%
. 2
 
4.5%
5 2
 
4.5%
- 1
 
2.3%
Latin
ValueCountFrequency (%)
e 1
16.7%
K 1
16.7%
S 1
16.7%
A 1
16.7%
H 1
16.7%
L 1
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1880
97.4%
ASCII 50
 
2.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
317
16.9%
317
16.9%
317
16.9%
31
 
1.6%
30
 
1.6%
30
 
1.6%
26
 
1.4%
23
 
1.2%
21
 
1.1%
21
 
1.1%
Other values (209) 747
39.7%
ASCII
ValueCountFrequency (%)
1 12
24.0%
2 9
18.0%
3 7
14.0%
6 3
 
6.0%
4 3
 
6.0%
) 2
 
4.0%
( 2
 
4.0%
. 2
 
4.0%
5 2
 
4.0%
- 1
 
2.0%
Other values (7) 7
14.0%
Distinct318
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Memory size2.6 KiB
2023-12-11T09:36:37.266724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length24
Mean length19.790625
Min length14

Characters and Unicode

Total characters6333
Distinct characters156
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

Unique316 ?
Unique (%)98.8%

Sample

1st row경상남도 거제시 일운면 지세포해안로 82-5
2nd row경상남도 거제시 일운면 구조라로 49
3rd row경상남도 거제시 일운면 지세포5길 45
4th row경상남도 거제시 일운면 망치2길 2-2
5th row경상남도 거제시 일운면 옥림4길 11
ValueCountFrequency (%)
거제시 320
21.1%
경상남도 319
21.0%
사등면 31
 
2.0%
장목면 29
 
1.9%
연초면 28
 
1.8%
거제면 27
 
1.8%
하청면 27
 
1.8%
둔덕면 21
 
1.4%
일운면 20
 
1.3%
동부면 20
 
1.3%
Other values (440) 675
44.5%
2023-12-11T09:36:37.734370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1197
18.9%
385
 
6.1%
383
 
6.0%
343
 
5.4%
329
 
5.2%
324
 
5.1%
323
 
5.1%
320
 
5.1%
1 243
 
3.8%
219
 
3.5%
Other values (146) 2267
35.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4043
63.8%
Space Separator 1197
 
18.9%
Decimal Number 1011
 
16.0%
Dash Punctuation 80
 
1.3%
Open Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
385
 
9.5%
383
 
9.5%
343
 
8.5%
329
 
8.1%
324
 
8.0%
323
 
8.0%
320
 
7.9%
219
 
5.4%
214
 
5.3%
162
 
4.0%
Other values (132) 1041
25.7%
Decimal Number
ValueCountFrequency (%)
1 243
24.0%
2 166
16.4%
3 120
11.9%
5 101
10.0%
4 82
 
8.1%
6 72
 
7.1%
7 61
 
6.0%
8 57
 
5.6%
9 55
 
5.4%
0 54
 
5.3%
Space Separator
ValueCountFrequency (%)
1197
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 80
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4043
63.8%
Common 2290
36.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
385
 
9.5%
383
 
9.5%
343
 
8.5%
329
 
8.1%
324
 
8.0%
323
 
8.0%
320
 
7.9%
219
 
5.4%
214
 
5.3%
162
 
4.0%
Other values (132) 1041
25.7%
Common
ValueCountFrequency (%)
1197
52.3%
1 243
 
10.6%
2 166
 
7.2%
3 120
 
5.2%
5 101
 
4.4%
4 82
 
3.6%
- 80
 
3.5%
6 72
 
3.1%
7 61
 
2.7%
8 57
 
2.5%
Other values (4) 111
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4043
63.8%
ASCII 2290
36.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1197
52.3%
1 243
 
10.6%
2 166
 
7.2%
3 120
 
5.2%
5 101
 
4.4%
4 82
 
3.6%
- 80
 
3.5%
6 72
 
3.1%
7 61
 
2.7%
8 57
 
2.5%
Other values (4) 111
 
4.8%
Hangul
ValueCountFrequency (%)
385
 
9.5%
383
 
9.5%
343
 
8.5%
329
 
8.1%
324
 
8.0%
323
 
8.0%
320
 
7.9%
219
 
5.4%
214
 
5.3%
162
 
4.0%
Other values (132) 1041
25.7%

위도
Real number (ℝ)

HIGH CORRELATION 

Distinct318
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean34.886401
Minimum34.714531
Maximum35.029749
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.9 KiB
2023-12-11T09:36:37.853838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum34.714531
5-th percentile34.795021
Q134.850837
median34.886373
Q334.91504
95-th percentile34.991518
Maximum35.029749
Range0.31521835
Interquartile range (IQR)0.06420323

Descriptive statistics

Standard deviation0.060387793
Coefficient of variation (CV)0.0017309837
Kurtosis0.33388304
Mean34.886401
Median Absolute Deviation (MAD)0.03380244
Skewness-0.09878653
Sum11163.648
Variance0.0036466855
MonotonicityNot monotonic
2023-12-11T09:36:37.984606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
34.82553235 2
 
0.6%
34.87619263 2
 
0.6%
34.86156475 1
 
0.3%
34.86820332 1
 
0.3%
34.86925984 1
 
0.3%
34.87339222 1
 
0.3%
34.86834895 1
 
0.3%
34.86343633 1
 
0.3%
34.94263622 1
 
0.3%
34.96038377 1
 
0.3%
Other values (308) 308
96.2%
ValueCountFrequency (%)
34.71453114 1
0.3%
34.71485683 1
0.3%
34.72061138 1
0.3%
34.72521177 1
0.3%
34.72905473 1
0.3%
34.7327494 1
0.3%
34.73747983 1
0.3%
34.73798154 1
0.3%
34.74140335 1
0.3%
34.7627018 1
0.3%
ValueCountFrequency (%)
35.02974949 1
0.3%
35.02903211 1
0.3%
35.02745323 1
0.3%
35.02092532 1
0.3%
35.01433289 1
0.3%
35.00954183 1
0.3%
35.00923297 1
0.3%
35.00897925 1
0.3%
35.00661806 1
0.3%
35.00638653 1
0.3%

경도
Real number (ℝ)

HIGH CORRELATION 

Distinct318
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean128.63009
Minimum128.46506
Maximum128.73867
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.9 KiB
2023-12-11T09:36:38.131147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum128.46506
5-th percentile128.50691
Q1128.58943
median128.63603
Q3128.68677
95-th percentile128.72491
Maximum128.73867
Range0.2736005
Interquartile range (IQR)0.097344875

Descriptive statistics

Standard deviation0.06750416
Coefficient of variation (CV)0.00052479292
Kurtosis-0.5371026
Mean128.63009
Median Absolute Deviation (MAD)0.04877025
Skewness-0.52179654
Sum41161.628
Variance0.0045568116
MonotonicityNot monotonic
2023-12-11T09:36:38.275018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
128.6055739 2
 
0.6%
128.7349456 2
 
0.6%
128.7224568 1
 
0.3%
128.7248446 1
 
0.3%
128.7275555 1
 
0.3%
128.7193774 1
 
0.3%
128.7276241 1
 
0.3%
128.7305665 1
 
0.3%
128.7158228 1
 
0.3%
128.7131085 1
 
0.3%
Other values (308) 308
96.2%
ValueCountFrequency (%)
128.4650647 1
0.3%
128.4728712 1
0.3%
128.4764846 1
0.3%
128.4783807 1
0.3%
128.4797264 1
0.3%
128.479747 1
0.3%
128.4805161 1
0.3%
128.4809492 1
0.3%
128.48154 1
0.3%
128.4895103 1
0.3%
ValueCountFrequency (%)
128.7386652 1
0.3%
128.7363035 1
0.3%
128.7349456 2
0.6%
128.7342115 1
0.3%
128.7330814 1
0.3%
128.7325341 1
0.3%
128.7324568 1
0.3%
128.7311687 1
0.3%
128.7307903 1
0.3%
128.7305665 1
0.3%
Distinct284
Distinct (%)89.0%
Missing1
Missing (%)0.3%
Memory size2.6 KiB
Minimum1905-05-23 00:00:00
Maximum2022-05-24 00:00:00
2023-12-11T09:36:38.436684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:36:38.848764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.6 KiB
2022-08-29
320 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-08-29
2nd row2022-08-29
3rd row2022-08-29
4th row2022-08-29
5th row2022-08-29

Common Values

ValueCountFrequency (%)
2022-08-29 320
100.0%

Length

2023-12-11T09:36:39.019507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T09:36:39.124657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-08-29 320
100.0%

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing320
Missing (%)100.0%
Memory size2.9 KiB

Interactions

2023-12-11T09:36:35.658334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:36:35.174355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:36:35.411455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:36:35.749282image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:36:35.256113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:36:35.497713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:36:35.842932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:36:35.332376image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:36:35.582788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T09:36:39.189866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번면동위도경도
연번1.0000.9750.8960.887
면동0.9751.0000.8930.872
위도0.8960.8931.0000.534
경도0.8870.8720.5341.000
2023-12-11T09:36:39.289827image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번위도경도면동
연번1.0000.4500.3520.863
위도0.4501.0000.2350.613
경도0.3520.2351.0000.572
면동0.8630.6130.5721.000

Missing values

2023-12-11T09:36:35.942833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T09:36:36.052122image/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

연번면동경로당명칭소재지(도로명주소)위도경도등록일자기준일자Unnamed: 8
01일운면대신경로당경상남도 거제시 일운면 지세포해안로 82-534.830095128.7039462008-11-042022-08-29<NA>
12일운면구조라수정경로당경상남도 거제시 일운면 구조라로 4934.804416128.6953992013-01-112022-08-29<NA>
23일운면대동경로당경상남도 거제시 일운면 지세포5길 4534.828089128.7016222008-10-242022-08-29<NA>
34일운면망치경로당경상남도 거제시 일운면 망치2길 2-234.812702128.6662851998-02-272022-08-29<NA>
45일운면하촌경로당경상남도 거제시 일운면 옥림4길 1134.850064128.7206061974-09-032022-08-29<NA>
56일운면회진경로당경상남도 거제시 일운면 지세포로 6034.827549128.7077182012-12-042022-08-29<NA>
67일운면소동경로당경상남도 거제시 일운면 소동3길 1634.839118128.6977692013-10-312022-08-29<NA>
78일운면와현경로당경상남도 거제시 일운면 와현해변길 2034.813866128.7060262006-09-252022-08-29<NA>
89일운면공령경로당경상남도 거제시 일운면 지세포로142-134.832502128.7008512011-06-222022-08-29<NA>
910일운면양화경로당경상남도 거제시 일운면 양화1길 1534.795553128.6634692010-07-022022-08-29<NA>
연번면동경로당명칭소재지(도로명주소)위도경도등록일자기준일자Unnamed: 8
310311수양동동산내경로당경상남도 거제시 수양로 38234.888324128.6467332000-09-072022-08-29<NA>
311312수양동양정경로당경상남도 거제시 양정2길 534.871716128.6522912006-07-102022-08-29<NA>
312313수양동수월경로당경상남도 거제시 수월2길 2634.884468128.6530481993-07-222022-08-29<NA>
313314수양동제산1할머니경로당경상남도 거제시 제산로5길 1734.887492128.6454582008-03-172022-08-29<NA>
314315수양동수양경로당경상남도 거제시 수양2길 4334.889109128.6532051994-03-072022-08-29<NA>
315316수양동해명1경로당경상남도 거제시 해명로 10길 934.892801128.6456852009-11-202022-08-29<NA>
316317수양동거제자이경로당경상남도 거제시 해명로 5234.892037128.6435132010-01-252022-08-29<NA>
317318수양동더샵경로당경상남도 거제시 제산로 8634.88648128.6426162011-07-042022-08-29<NA>
318319수양동춘광한빛타운경로당경상남도 거제시 해명로6길 1134.893652128.6449372015-12-292022-08-29<NA>
319320수양동해뜰안애아파트경로당경상남도 거제시 수양로 10434.865603128.6524832020-09-152022-08-29<NA>