Overview

Dataset statistics

Number of variables9
Number of observations47
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.5 KiB
Average record size in memory76.8 B

Variable types

Categorical6
Text1
Numeric2

Dataset

Description경기도 광주시 관내 전광표지 현황에 대한 데이터로 지형지물부호, 관리기관, 설치형식, 표출형식, 위치방향, 위치지점, 설치일자 등을 제공합니다.
Author경기도 광주시
URLhttps://www.data.go.kr/data/15042238/fileData.do

Alerts

표출형식 has constant value ""Constant
표시면기술형식 has constant value ""Constant
지형지물부호 is highly imbalanced (85.1%)Imbalance
위치지점 has unique valuesUnique
경도 has unique valuesUnique
위도 has unique valuesUnique

Reproduction

Analysis started2023-12-16 15:23:49.901583
Analysis finished2023-12-16 15:23:56.666528
Duration6.76 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지형지물부호
Categorical

IMBALANCE 

Distinct2
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size508.0 B
전광표지
46 
신호등
 
1

Length

Max length4
Median length4
Mean length3.9787234
Min length3

Unique

Unique1 ?
Unique (%)2.1%

Sample

1st row전광표지
2nd row전광표지
3rd row전광표지
4th row전광표지
5th row전광표지

Common Values

ValueCountFrequency (%)
전광표지 46
97.9%
신호등 1
 
2.1%

Length

2023-12-16T15:23:56.905727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:23:57.721058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전광표지 46
97.9%
신호등 1
 
2.1%

설치형식
Categorical

Distinct6
Distinct (%)12.8%
Missing0
Missing (%)0.0%
Memory size508.0 B
편지식
25 
부착식
13 
현수식
4 
측주식
3 
복주식
 
1

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique2 ?
Unique (%)4.3%

Sample

1st row편지식
2nd row편지식
3rd row편지식
4th row현수식
5th row현수식

Common Values

ValueCountFrequency (%)
편지식 25
53.2%
부착식 13
27.7%
현수식 4
 
8.5%
측주식 3
 
6.4%
복주식 1
 
2.1%
단주식 1
 
2.1%

Length

2023-12-16T15:23:58.444120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:23:58.835476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
편지식 25
53.2%
부착식 13
27.7%
현수식 4
 
8.5%
측주식 3
 
6.4%
복주식 1
 
2.1%
단주식 1
 
2.1%

표출형식
Categorical

CONSTANT 

Distinct1
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size508.0 B
문자식
47 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row문자식
2nd row문자식
3rd row문자식
4th row문자식
5th row문자식

Common Values

ValueCountFrequency (%)
문자식 47
100.0%

Length

2023-12-16T15:23:59.366781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:23:59.882713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
문자식 47
100.0%

표시면기술형식
Categorical

CONSTANT 

Distinct1
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size508.0 B
발광형(LED)
47 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row발광형(LED)
2nd row발광형(LED)
3rd row발광형(LED)
4th row발광형(LED)
5th row발광형(LED)

Common Values

ValueCountFrequency (%)
발광형(LED) 47
100.0%

Length

2023-12-16T15:24:00.475039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:24:01.117394image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
발광형(led 47
100.0%

위치방향
Categorical

Distinct3
Distinct (%)6.4%
Missing0
Missing (%)0.0%
Memory size508.0 B
상행(우)
24 
하행(좌)
22 
미분류
 
1

Length

Max length5
Median length5
Mean length4.9574468
Min length3

Unique

Unique1 ?
Unique (%)2.1%

Sample

1st row상행(우)
2nd row상행(우)
3rd row상행(우)
4th row하행(좌)
5th row하행(좌)

Common Values

ValueCountFrequency (%)
상행(우) 24
51.1%
하행(좌) 22
46.8%
미분류 1
 
2.1%

Length

2023-12-16T15:24:01.831109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:24:02.416624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
상행(우 24
51.1%
하행(좌 22
46.8%
미분류 1
 
2.1%

위치지점
Text

UNIQUE 

Distinct47
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size508.0 B
2023-12-16T15:24:03.320175image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length24
Mean length20.829787
Min length17

Characters and Unicode

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

Unique

Unique47 ?
Unique (%)100.0%

Sample

1st row경기도 광주시 쌍령동 372번지
2nd row경기도 광주시 곤지암읍 삼리 97-42번지
3rd row경기도 광주시 초월읍 도평리 221-6번지
4th row경기도 광주시 남한산성면 광지원리 332-1번지
5th row경기도 광주시 남한산성면 광지원리 37-4번지
ValueCountFrequency (%)
경기도 47
22.6%
광주시 47
22.6%
고산동 8
 
3.8%
곤지암읍 5
 
2.4%
남한산성면 4
 
1.9%
태전동 4
 
1.9%
송정동 4
 
1.9%
초월읍 4
 
1.9%
광지원리 3
 
1.4%
퇴촌면 3
 
1.4%
Other values (72) 79
38.0%
2023-12-16T15:24:05.329033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
161
16.4%
지 58
 
5.9%
도 52
 
5.3%
광 50
 
5.1%
경 48
 
4.9%
번 48
 
4.9%
기 47
 
4.8%
주 47
 
4.8%
시 47
 
4.8%
- 43
 
4.4%
Other values (58) 378
38.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 596
60.9%
Decimal Number 179
 
18.3%
Space Separator 161
 
16.4%
Dash Punctuation 43
 
4.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
지 58
 
9.7%
도 52
 
8.7%
광 50
 
8.4%
경 48
 
8.1%
번 48
 
8.1%
기 47
 
7.9%
주 47
 
7.9%
시 47
 
7.9%
동 28
 
4.7%
리 20
 
3.4%
Other values (46) 151
25.3%
Decimal Number
ValueCountFrequency (%)
1 35
19.6%
4 25
14.0%
3 25
14.0%
2 21
11.7%
6 17
9.5%
5 14
 
7.8%
9 13
 
7.3%
8 12
 
6.7%
7 10
 
5.6%
0 7
 
3.9%
Space Separator
ValueCountFrequency (%)
161
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 43
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 596
60.9%
Common 383
39.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
지 58
 
9.7%
도 52
 
8.7%
광 50
 
8.4%
경 48
 
8.1%
번 48
 
8.1%
기 47
 
7.9%
주 47
 
7.9%
시 47
 
7.9%
동 28
 
4.7%
리 20
 
3.4%
Other values (46) 151
25.3%
Common
ValueCountFrequency (%)
161
42.0%
- 43
 
11.2%
1 35
 
9.1%
4 25
 
6.5%
3 25
 
6.5%
2 21
 
5.5%
6 17
 
4.4%
5 14
 
3.7%
9 13
 
3.4%
8 12
 
3.1%
Other values (2) 17
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 596
60.9%
ASCII 383
39.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
161
42.0%
- 43
 
11.2%
1 35
 
9.1%
4 25
 
6.5%
3 25
 
6.5%
2 21
 
5.5%
6 17
 
4.4%
5 14
 
3.7%
9 13
 
3.4%
8 12
 
3.1%
Other values (2) 17
 
4.4%
Hangul
ValueCountFrequency (%)
지 58
 
9.7%
도 52
 
8.7%
광 50
 
8.4%
경 48
 
8.1%
번 48
 
8.1%
기 47
 
7.9%
주 47
 
7.9%
시 47
 
7.9%
동 28
 
4.7%
리 20
 
3.4%
Other values (46) 151
25.3%

관리기관
Categorical

Distinct2
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size508.0 B
경기도 광주시청
30 
국토교통부
17 

Length

Max length8
Median length8
Mean length6.9148936
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row국토교통부
2nd row국토교통부
3rd row경기도 광주시청
4th row국토교통부
5th row경기도 광주시청

Common Values

ValueCountFrequency (%)
경기도 광주시청 30
63.8%
국토교통부 17
36.2%

Length

2023-12-16T15:24:06.070585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:24:06.902920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 30
39.0%
광주시청 30
39.0%
국토교통부 17
22.1%

경도
Real number (ℝ)

UNIQUE 

Distinct47
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.26286
Minimum127.16185
Maximum127.40716
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size555.0 B
2023-12-16T15:24:07.701730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.16185
5-th percentile127.20269
Q1127.23072
median127.25365
Q3127.28208
95-th percentile127.35298
Maximum127.40716
Range0.24530758
Interquartile range (IQR)0.051356504

Descriptive statistics

Standard deviation0.0503751
Coefficient of variation (CV)0.00039583503
Kurtosis1.4809632
Mean127.26286
Median Absolute Deviation (MAD)0.023907095
Skewness0.90522853
Sum5981.3546
Variance0.0025376507
MonotonicityNot monotonic
2023-12-16T15:24:08.693049image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=47)
ValueCountFrequency (%)
127.275224272 1
 
2.1%
127.33082551 1
 
2.1%
127.235970426 1
 
2.1%
127.281847533 1
 
2.1%
127.359644915 1
 
2.1%
127.282937225 1
 
2.1%
127.255421107 1
 
2.1%
127.23523288 1
 
2.1%
127.230552407 1
 
2.1%
127.334600582 1
 
2.1%
Other values (37) 37
78.7%
ValueCountFrequency (%)
127.161848621 1
2.1%
127.162904839 1
2.1%
127.193761699 1
2.1%
127.223524989 1
2.1%
127.225057118 1
2.1%
127.22598855 1
2.1%
127.226943506 1
2.1%
127.227995621 1
2.1%
127.229448838 1
2.1%
127.229741803 1
2.1%
ValueCountFrequency (%)
127.407156198 1
2.1%
127.399209181 1
2.1%
127.359644915 1
2.1%
127.337427259 1
2.1%
127.334600582 1
2.1%
127.33168562 1
2.1%
127.33082551 1
2.1%
127.306687375 1
2.1%
127.291338567 1
2.1%
127.282937225 1
2.1%

위도
Real number (ℝ)

UNIQUE 

Distinct47
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.401709
Minimum37.328035
Maximum37.490921
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size555.0 B
2023-12-16T15:24:09.373763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.328035
5-th percentile37.352124
Q137.371535
median37.392578
Q337.424397
95-th percentile37.472421
Maximum37.490921
Range0.16288524
Interquartile range (IQR)0.052861264

Descriptive statistics

Standard deviation0.041424681
Coefficient of variation (CV)0.0011075612
Kurtosis-0.60408537
Mean37.401709
Median Absolute Deviation (MAD)0.026443621
Skewness0.55858912
Sum1757.8803
Variance0.0017160042
MonotonicityNot monotonic
2023-12-16T15:24:10.303992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=47)
ValueCountFrequency (%)
37.396912448 1
 
2.1%
37.353409516 1
 
2.1%
37.392055839 1
 
2.1%
37.392758359 1
 
2.1%
37.341538685 1
 
2.1%
37.488168372 1
 
2.1%
37.425803627 1
 
2.1%
37.384732667 1
 
2.1%
37.363703957 1
 
2.1%
37.351572563 1
 
2.1%
Other values (37) 37
78.7%
ValueCountFrequency (%)
37.328035289 1
2.1%
37.341538685 1
2.1%
37.351572563 1
2.1%
37.353409516 1
2.1%
37.35608609 1
2.1%
37.357897535 1
2.1%
37.361284669 1
2.1%
37.363703957 1
2.1%
37.367535515 1
2.1%
37.367715887 1
2.1%
ValueCountFrequency (%)
37.490920529 1
2.1%
37.488168372 1
2.1%
37.473225644 1
2.1%
37.470544246 1
2.1%
37.468680493 1
2.1%
37.462382503 1
2.1%
37.460540869 1
2.1%
37.458924234 1
2.1%
37.451072963 1
2.1%
37.438814921 1
2.1%

Interactions

2023-12-16T15:23:54.647310image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:23:53.512971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:23:55.099415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:23:54.053564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-16T15:24:10.949072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지형지물부호설치형식위치방향위치지점관리기관경도위도
지형지물부호1.0000.5220.0001.0000.0000.0000.000
설치형식0.5221.0000.6831.0000.6630.3020.000
위치방향0.0000.6831.0001.0000.0630.0000.351
위치지점1.0001.0001.0001.0001.0001.0001.000
관리기관0.0000.6630.0631.0001.0000.0000.000
경도0.0000.3020.0001.0000.0001.0000.710
위도0.0000.0000.3511.0000.0000.7101.000
2023-12-16T15:24:11.590215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리기관위치방향지형지물부호설치형식
관리기관1.0000.0980.0000.461
위치방향0.0981.0000.0000.352
지형지물부호0.0000.0001.0000.357
설치형식0.4610.3520.3571.000
2023-12-16T15:24:12.025031image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
경도위도지형지물부호설치형식위치방향관리기관
경도1.0000.2120.0000.1400.0000.000
위도0.2121.0000.0000.0000.1960.000
지형지물부호0.0000.0001.0000.3570.0000.000
설치형식0.1400.0000.3571.0000.3520.461
위치방향0.0000.1960.0000.3521.0000.098
관리기관0.0000.0000.0000.4610.0981.000

Missing values

2023-12-16T15:23:55.554274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-16T15:23:56.308021image/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전광표지편지식문자식발광형(LED)상행(우)경기도 광주시 쌍령동 372번지국토교통부127.27522437.396912
1전광표지편지식문자식발광형(LED)상행(우)경기도 광주시 곤지암읍 삼리 97-42번지국토교통부127.33082637.35341
2전광표지편지식문자식발광형(LED)상행(우)경기도 광주시 초월읍 도평리 221-6번지경기도 광주시청127.29133937.395502
3전광표지현수식문자식발광형(LED)하행(좌)경기도 광주시 남한산성면 광지원리 332-1번지국토교통부127.25497237.451073
4전광표지현수식문자식발광형(LED)하행(좌)경기도 광주시 남한산성면 광지원리 37-4번지경기도 광주시청127.24226737.460541
5전광표지현수식문자식발광형(LED)상행(우)경기도 광주시 남한산성면 상번천리 619-2번지경기도 광주시청127.26295137.438815
6전광표지부착식문자식발광형(LED)하행(좌)경기도 광주시 남종면 삼성리 산25-4번지경기도 광주시청127.27549737.473226
7전광표지부착식문자식발광형(LED)하행(좌)경기도 광주시 남종면 삼성리 296-8번지경기도 광주시청127.28253337.490921
8전광표지부착식문자식발광형(LED)상행(우)경기도 광주시 고산동 183-1번지경기도 광주시청127.23344837.371126
9전광표지부착식문자식발광형(LED)하행(좌)경기도 광주시 고산동 183-14번지경기도 광주시청127.23329837.371029
지형지물부호설치형식표출형식표시면기술형식위치방향위치지점관리기관경도위도
37전광표지편지식문자식발광형(LED)하행(좌)경기도 광주시 퇴촌면 도마리 305-4번지국토교통부127.26872137.462383
38전광표지편지식문자식발광형(LED)하행(좌)경기도 광주시 추자동 324-14번지국토교통부127.22352537.356086
39전광표지편지식문자식발광형(LED)상행(우)경기도 광주시 능평동 440-4번지경기도 광주시청127.16184937.357898
40전광표지편지식문자식발광형(LED)상행(우)경기도 광주시 퇴촌면 도수리 산41-10번지경기도 광주시청127.33168637.46868
41전광표지편지식문자식발광형(LED)상행(우)경기도 광주시 도척면 진우리 128-6번지경기도 광주시청127.33742737.328035
42전광표지편지식문자식발광형(LED)상행(우)경기도 광주시 역동 216-13번지경기도 광주시청127.25294537.397208
43전광표지편지식문자식발광형(LED)하행(좌)경기도 광주시 송정동 4-9번지경기도 광주시청127.27743137.419022
44전광표지편지식문자식발광형(LED)상행(우)경기도 광주시 목현동 12-3번지경기도 광주시청127.23936637.428664
45전광표지편지식문자식발광형(LED)하행(좌)경기도 광주시 곤지암읍 연곡리 546-3번지경기도 광주시청127.39920937.367536
46전광표지측주식문자식발광형(LED)미분류경기도 광주시 남한산성면 광지원리 253-1번지국토교통부127.25364937.458924