Overview

Dataset statistics

Number of variables45
Number of observations175
Missing cells5255
Missing cells (%)66.7%
Duplicate rows28
Duplicate rows (%)16.0%
Total size in memory61.7 KiB
Average record size in memory360.8 B

Variable types

Text4
Categorical3
Unsupported38

Dataset

Description송파구 가로등의 위치 및 정보
Author서울특별시 송파구
URLhttps://www.data.go.kr/data/15062370/fileData.do

Alerts

Dataset has 28 (16.0%) duplicate rowsDuplicates
5-1. 노선별 가로등 시설현황(시도) has 168 (96.0%) missing valuesMissing
Unnamed: 1 has 172 (98.3%) missing valuesMissing
Unnamed: 3 has 7 (4.0%) missing valuesMissing
Unnamed: 4 has 18 (10.3%) missing valuesMissing
Unnamed: 5 has 155 (88.6%) missing valuesMissing
Unnamed: 6 has 140 (80.0%) missing valuesMissing
Unnamed: 7 has 13 (7.4%) missing valuesMissing
Unnamed: 8 has 8 (4.6%) missing valuesMissing
Unnamed: 9 has 14 (8.0%) missing valuesMissing
Unnamed: 10 has 58 (33.1%) missing valuesMissing
Unnamed: 12 has 10 (5.7%) missing valuesMissing
Unnamed: 13 has 9 (5.1%) missing valuesMissing
Unnamed: 14 has 21 (12.0%) missing valuesMissing
Unnamed: 15 has 14 (8.0%) missing valuesMissing
Unnamed: 16 has 14 (8.0%) missing valuesMissing
Unnamed: 17 has 166 (94.9%) missing valuesMissing
Unnamed: 19 has 104 (59.4%) missing valuesMissing
Unnamed: 20 has 170 (97.1%) missing valuesMissing
Unnamed: 21 has 171 (97.7%) missing valuesMissing
Unnamed: 22 has 171 (97.7%) missing valuesMissing
Unnamed: 23 has 171 (97.7%) missing valuesMissing
Unnamed: 24 has 169 (96.6%) missing valuesMissing
Unnamed: 25 has 169 (96.6%) missing valuesMissing
Unnamed: 26 has 169 (96.6%) missing valuesMissing
Unnamed: 27 has 170 (97.1%) missing valuesMissing
Unnamed: 28 has 171 (97.7%) missing valuesMissing
Unnamed: 29 has 171 (97.7%) missing valuesMissing
Unnamed: 30 has 170 (97.1%) missing valuesMissing
Unnamed: 31 has 171 (97.7%) missing valuesMissing
Unnamed: 32 has 168 (96.0%) missing valuesMissing
Unnamed: 33 has 168 (96.0%) missing valuesMissing
Unnamed: 34 has 169 (96.6%) missing valuesMissing
Unnamed: 35 has 171 (97.7%) missing valuesMissing
Unnamed: 36 has 172 (98.3%) missing valuesMissing
Unnamed: 37 has 168 (96.0%) missing valuesMissing
Unnamed: 38 has 166 (94.9%) missing valuesMissing
Unnamed: 39 has 166 (94.9%) missing valuesMissing
Unnamed: 40 has 170 (97.1%) missing valuesMissing
Unnamed: 41 has 170 (97.1%) missing valuesMissing
Unnamed: 42 has 170 (97.1%) missing valuesMissing
Unnamed: 43 has 130 (74.3%) missing valuesMissing
Unnamed: 44 has 133 (76.0%) missing valuesMissing
Unnamed: 4 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 6 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 13 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 14 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 15 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 16 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 17 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 19 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 20 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 21 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 22 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 23 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 24 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 25 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 26 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 27 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 29 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 30 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 31 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 32 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 33 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 34 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 35 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 36 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 37 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 38 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 39 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 40 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 41 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 42 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 43 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 44 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 12:46:14.911128
Analysis finished2023-12-12 12:46:15.327641
Duration0.42 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

5-1. 노선별 가로등 시설현황(시도)
Text

MISSING 

Distinct6
Distinct (%)85.7%
Missing168
Missing (%)96.0%
Memory size1.5 KiB
2023-12-12T21:46:15.471614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length112
Median length54
Mean length41.714286
Min length2

Characters and Unicode

Total characters292
Distinct characters121
Distinct categories12 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique5 ?
Unique (%)71.4%

Sample

1st row ○ [(형태 : 마주보기-A, 지그재그-B, 한쪽-C, 중앙-D) (등주type : 원형-R, 팔각-E, STS-S, AL-A,) (표기 예시)알미늄재질원형 10m Y주 암2.5m=AR10Y-25 ]
2nd row ○ 설치년도,광원,용량,형태,배전방식,등주타입 등이 다를때에는 다음 칸을 이용(같은 칸에서 Alt Enter 키 이용금지)
3rd row ○ 도로연장은 편측설치, 양측설치를 구분하고 실제 도로연장만 기재(가로등 설치연장 자동계산 됨)
4th row○ 교량하부등은 각종 하부통과도로 상에 있는 조명을 뜻하며 교량점검용 조명은 제외할 것
5th row도로 구분
ValueCountFrequency (%)
○ 4
 
6.9%
3
 
5.2%
시도 2
 
3.4%
도로 1
 
1.7%
것 1
 
1.7%
이용금지 1
 
1.7%
도로연장은 1
 
1.7%
편측설치 1
 
1.7%
양측설치를 1
 
1.7%
구분하고 1
 
1.7%
Other values (42) 42
72.4%
2023-12-12T21:46:15.879137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
53
 
18.2%
, 13
 
4.5%
- 9
 
3.1%
도 7
 
2.4%
등 5
 
1.7%
) 5
 
1.7%
( 5
 
1.7%
A 5
 
1.7%
로 5
 
1.7%
설 4
 
1.4%
Other values (111) 181
62.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 157
53.8%
Space Separator 53
 
18.2%
Uppercase Letter 19
 
6.5%
Other Punctuation 16
 
5.5%
Lowercase Letter 12
 
4.1%
Dash Punctuation 9
 
3.1%
Decimal Number 8
 
2.7%
Close Punctuation 6
 
2.1%
Open Punctuation 6
 
2.1%
Other Symbol 4
 
1.4%
Other values (2) 2
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
도 7
 
4.5%
등 5
 
3.2%
로 5
 
3.2%
설 4
 
2.5%
치 4
 
2.5%
용 4
 
2.5%
은 4
 
2.5%
주 4
 
2.5%
형 4
 
2.5%
하 4
 
2.5%
Other values (77) 112
71.3%
Uppercase Letter
ValueCountFrequency (%)
A 5
26.3%
S 3
15.8%
Y 2
 
10.5%
R 2
 
10.5%
E 2
 
10.5%
D 1
 
5.3%
L 1
 
5.3%
T 1
 
5.3%
C 1
 
5.3%
B 1
 
5.3%
Lowercase Letter
ValueCountFrequency (%)
t 3
25.0%
m 2
16.7%
e 2
16.7%
r 1
 
8.3%
n 1
 
8.3%
p 1
 
8.3%
y 1
 
8.3%
l 1
 
8.3%
Decimal Number
ValueCountFrequency (%)
5 2
25.0%
2 2
25.0%
0 2
25.0%
1 2
25.0%
Other Punctuation
ValueCountFrequency (%)
, 13
81.2%
: 2
 
12.5%
. 1
 
6.2%
Close Punctuation
ValueCountFrequency (%)
) 5
83.3%
] 1
 
16.7%
Open Punctuation
ValueCountFrequency (%)
( 5
83.3%
[ 1
 
16.7%
Space Separator
ValueCountFrequency (%)
53
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 9
100.0%
Other Symbol
ValueCountFrequency (%)
○ 4
100.0%
Math Symbol
ValueCountFrequency (%)
= 1
100.0%
Control
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 157
53.8%
Common 104
35.6%
Latin 31
 
10.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
도 7
 
4.5%
등 5
 
3.2%
로 5
 
3.2%
설 4
 
2.5%
치 4
 
2.5%
용 4
 
2.5%
은 4
 
2.5%
주 4
 
2.5%
형 4
 
2.5%
하 4
 
2.5%
Other values (77) 112
71.3%
Latin
ValueCountFrequency (%)
A 5
16.1%
S 3
 
9.7%
t 3
 
9.7%
Y 2
 
6.5%
m 2
 
6.5%
R 2
 
6.5%
e 2
 
6.5%
E 2
 
6.5%
D 1
 
3.2%
r 1
 
3.2%
Other values (8) 8
25.8%
Common
ValueCountFrequency (%)
53
51.0%
, 13
 
12.5%
- 9
 
8.7%
) 5
 
4.8%
( 5
 
4.8%
○ 4
 
3.8%
5 2
 
1.9%
2 2
 
1.9%
0 2
 
1.9%
1 2
 
1.9%
Other values (6) 7
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 157
53.8%
ASCII 131
44.9%
Geometric Shapes 4
 
1.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
53
40.5%
, 13
 
9.9%
- 9
 
6.9%
) 5
 
3.8%
( 5
 
3.8%
A 5
 
3.8%
S 3
 
2.3%
t 3
 
2.3%
5 2
 
1.5%
2 2
 
1.5%
Other values (23) 31
23.7%
Hangul
ValueCountFrequency (%)
도 7
 
4.5%
등 5
 
3.2%
로 5
 
3.2%
설 4
 
2.5%
치 4
 
2.5%
용 4
 
2.5%
은 4
 
2.5%
주 4
 
2.5%
형 4
 
2.5%
하 4
 
2.5%
Other values (77) 112
71.3%
Geometric Shapes
ValueCountFrequency (%)
○ 4
100.0%

Unnamed: 1
Text

MISSING 

Distinct3
Distinct (%)100.0%
Missing172
Missing (%)98.3%
Memory size1.5 KiB
2023-12-12T21:46:16.073895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length5
Median length2
Mean length2.6666667
Min length1

Characters and Unicode

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

Unique

Unique3 ?
Unique (%)100.0%

Sample

1st row노선 번호
2nd row예시
3rd row계
ValueCountFrequency (%)
노선 1
25.0%
번호 1
25.0%
예시 1
25.0%
계 1
25.0%
2023-12-12T21:46:16.412227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
노 1
12.5%
선 1
12.5%
1
12.5%
번 1
12.5%
호 1
12.5%
예 1
12.5%
시 1
12.5%
계 1
12.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7
87.5%
Control 1
 
12.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
노 1
14.3%
선 1
14.3%
번 1
14.3%
호 1
14.3%
예 1
14.3%
시 1
14.3%
계 1
14.3%
Control
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7
87.5%
Common 1
 
12.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
노 1
14.3%
선 1
14.3%
번 1
14.3%
호 1
14.3%
예 1
14.3%
시 1
14.3%
계 1
14.3%
Common
ValueCountFrequency (%)
1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7
87.5%
ASCII 1
 
12.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
노 1
14.3%
선 1
14.3%
번 1
14.3%
호 1
14.3%
예 1
14.3%
시 1
14.3%
계 1
14.3%
ASCII
ValueCountFrequency (%)
1
100.0%

Unnamed: 2
Categorical

Distinct23
Distinct (%)13.1%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
송파대로
34 
올림픽로
29 
양재대로
15 
오금로
14 
동남로
14 
Other values (18)
69 

Length

Max length11
Median length4
Mean length4.0342857
Min length1

Unique

Unique5 ?
Unique (%)2.9%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row노선명

Common Values

ValueCountFrequency (%)
송파대로 34
19.4%
올림픽로 29
16.6%
양재대로 15
8.6%
오금로 14
8.0%
동남로 14
8.0%
위례성대로 13
 
7.4%
백제고분로 13
 
7.4%
<NA> 7
 
4.0%
강동대로 6
 
3.4%
삼전로 4
 
2.3%
Other values (13) 26
14.9%

Length

2023-12-12T21:46:16.531318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
송파대로 34
19.4%
올림픽로 29
16.6%
양재대로 15
8.6%
오금로 14
8.0%
동남로 14
8.0%
위례성대로 13
 
7.4%
백제고분로 13
 
7.4%
na 7
 
4.0%
강동대로 6
 
3.4%
삼전로 4
 
2.3%
Other values (13) 26
14.9%

Unnamed: 3
Text

MISSING 

Distinct98
Distinct (%)58.3%
Missing7
Missing (%)4.0%
Memory size1.5 KiB
2023-12-12T21:46:16.793337image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length18
Mean length10.416667
Min length3

Characters and Unicode

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

Unique

Unique64 ?
Unique (%)38.1%

Sample

1st row구 간
2nd row00~00
3rd row00~00
4th row00~00
5th row00~00
ValueCountFrequency (%)
삼성교~운동장사거리 6
 
3.4%
잠실나루역입구~구청~방이고가 6
 
3.4%
평화의문~올림픽공원사거리 6
 
3.4%
아시아선수촌아파트교차로~올림픽공원남4문사거리 6
 
3.4%
앞 6
 
3.4%
올림픽대교~동남로 5
 
2.8%
00~00 4
 
2.3%
구청앞사거리~평화의문 4
 
2.3%
탄천교~송파대로 4
 
2.3%
갤러리아~탄천1교 4
 
2.3%
Other values (91) 126
71.2%
2023-12-12T21:46:17.164408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
~ 147
 
8.4%
로 89
 
5.1%
거 68
 
3.9%
리 66
 
3.8%
사 53
 
3.0%
교 48
 
2.7%
대 47
 
2.7%
역 36
 
2.1%
실 36
 
2.1%
잠 36
 
2.1%
Other values (134) 1124
64.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1512
86.4%
Math Symbol 147
 
8.4%
Decimal Number 46
 
2.6%
Open Punctuation 15
 
0.9%
Close Punctuation 15
 
0.9%
Space Separator 9
 
0.5%
Uppercase Letter 4
 
0.2%
Dash Punctuation 1
 
0.1%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 89
 
5.9%
거 68
 
4.5%
리 66
 
4.4%
사 53
 
3.5%
교 48
 
3.2%
대 47
 
3.1%
역 36
 
2.4%
실 36
 
2.4%
잠 36
 
2.4%
동 35
 
2.3%
Other values (117) 998
66.0%
Decimal Number
ValueCountFrequency (%)
0 16
34.8%
1 8
17.4%
2 7
15.2%
4 6
 
13.0%
5 4
 
8.7%
9 2
 
4.3%
7 1
 
2.2%
3 1
 
2.2%
8 1
 
2.2%
Uppercase Letter
ValueCountFrequency (%)
R 3
75.0%
A 1
 
25.0%
Math Symbol
ValueCountFrequency (%)
~ 147
100.0%
Open Punctuation
ValueCountFrequency (%)
( 15
100.0%
Close Punctuation
ValueCountFrequency (%)
) 15
100.0%
Space Separator
ValueCountFrequency (%)
9
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1512
86.4%
Common 234
 
13.4%
Latin 4
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 89
 
5.9%
거 68
 
4.5%
리 66
 
4.4%
사 53
 
3.5%
교 48
 
3.2%
대 47
 
3.1%
역 36
 
2.4%
실 36
 
2.4%
잠 36
 
2.4%
동 35
 
2.3%
Other values (117) 998
66.0%
Common
ValueCountFrequency (%)
~ 147
62.8%
0 16
 
6.8%
( 15
 
6.4%
) 15
 
6.4%
9
 
3.8%
1 8
 
3.4%
2 7
 
3.0%
4 6
 
2.6%
5 4
 
1.7%
9 2
 
0.9%
Other values (5) 5
 
2.1%
Latin
ValueCountFrequency (%)
R 3
75.0%
A 1
 
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1512
86.4%
ASCII 238
 
13.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
~ 147
61.8%
0 16
 
6.7%
( 15
 
6.3%
) 15
 
6.3%
9
 
3.8%
1 8
 
3.4%
2 7
 
2.9%
4 6
 
2.5%
5 4
 
1.7%
R 3
 
1.3%
Other values (7) 8
 
3.4%
Hangul
ValueCountFrequency (%)
로 89
 
5.9%
거 68
 
4.5%
리 66
 
4.4%
사 53
 
3.5%
교 48
 
3.2%
대 47
 
3.1%
역 36
 
2.4%
실 36
 
2.4%
잠 36
 
2.4%
동 35
 
2.3%
Other values (117) 998
66.0%

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing18
Missing (%)10.3%
Memory size1.5 KiB

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing155
Missing (%)88.6%
Memory size1.5 KiB

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing140
Missing (%)80.0%
Memory size1.5 KiB

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing13
Missing (%)7.4%
Memory size1.5 KiB

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing8
Missing (%)4.6%
Memory size1.5 KiB

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing14
Missing (%)8.0%
Memory size1.5 KiB

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing58
Missing (%)33.1%
Memory size1.5 KiB

Unnamed: 11
Categorical

Distinct8
Distinct (%)4.6%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
A
77 
<NA>
62 
B
13 
C
11 
AB
 
5
Other values (3)
 
7

Length

Max length4
Median length1
Mean length2.1142857
Min length1

Unique

Unique1 ?
Unique (%)0.6%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row형태

Common Values

ValueCountFrequency (%)
A 77
44.0%
<NA> 62
35.4%
B 13
 
7.4%
C 11
 
6.3%
AB 5
 
2.9%
D 3
 
1.7%
AD 3
 
1.7%
형태 1
 
0.6%

Length

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

Common Values (Plot)

2023-12-12T21:46:17.433404image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
a 77
44.0%
na 62
35.4%
b 13
 
7.4%
c 11
 
6.3%
ab 5
 
2.9%
d 3
 
1.7%
ad 3
 
1.7%
형태 1
 
0.6%

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing10
Missing (%)5.7%
Memory size1.5 KiB

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9
Missing (%)5.1%
Memory size1.5 KiB

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing21
Missing (%)12.0%
Memory size1.5 KiB

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing14
Missing (%)8.0%
Memory size1.5 KiB

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing14
Missing (%)8.0%
Memory size1.5 KiB

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing166
Missing (%)94.9%
Memory size1.5 KiB

Unnamed: 18
Categorical

Distinct15
Distinct (%)8.6%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
<NA>
105 
CDM70
19 
LED50
19 
LED25
13 
MH100
 
8
Other values (10)
11 

Length

Max length6
Median length4
Mean length4.3771429
Min length2

Unique

Unique9 ?
Unique (%)5.1%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 105
60.0%
CDM70 19
 
10.9%
LED50 19
 
10.9%
LED25 13
 
7.4%
MH100 8
 
4.6%
LED30 2
 
1.1%
광원 1
 
0.6%
NH70 1
 
0.6%
NA100 1
 
0.6%
LED10 1
 
0.6%
Other values (5) 5
 
2.9%

Length

2023-12-12T21:46:17.560246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 105
60.0%
cdm70 19
 
10.9%
led50 19
 
10.9%
led25 13
 
7.4%
mh100 8
 
4.6%
led30 2
 
1.1%
광원 1
 
0.6%
nh70 1
 
0.6%
na100 1
 
0.6%
led10 1
 
0.6%
Other values (5) 5
 
2.9%

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing104
Missing (%)59.4%
Memory size1.5 KiB

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing170
Missing (%)97.1%
Memory size1.5 KiB

Unnamed: 21
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing171
Missing (%)97.7%
Memory size1.5 KiB

Unnamed: 22
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing171
Missing (%)97.7%
Memory size1.5 KiB

Unnamed: 23
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing171
Missing (%)97.7%
Memory size1.5 KiB

Unnamed: 24
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing169
Missing (%)96.6%
Memory size1.5 KiB

Unnamed: 25
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing169
Missing (%)96.6%
Memory size1.5 KiB

Unnamed: 26
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing169
Missing (%)96.6%
Memory size1.5 KiB

Unnamed: 27
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing170
Missing (%)97.1%
Memory size1.5 KiB

Unnamed: 28
Text

MISSING 

Distinct4
Distinct (%)100.0%
Missing171
Missing (%)97.7%
Memory size1.5 KiB
2023-12-12T21:46:17.679246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length4
Mean length4
Min length2

Characters and Unicode

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

Unique

Unique4 ?
Unique (%)100.0%

Sample

1st row차도등
2nd row광원
3rd rowNH400
4th rowCDM250
ValueCountFrequency (%)
차도등 1
25.0%
광원 1
25.0%
nh400 1
25.0%
cdm250 1
25.0%
2023-12-12T21:46:17.915287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 3
18.8%
차 1
 
6.2%
도 1
 
6.2%
등 1
 
6.2%
광 1
 
6.2%
원 1
 
6.2%
N 1
 
6.2%
H 1
 
6.2%
4 1
 
6.2%
C 1
 
6.2%
Other values (4) 4
25.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 6
37.5%
Other Letter 5
31.2%
Uppercase Letter 5
31.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
차 1
20.0%
도 1
20.0%
등 1
20.0%
광 1
20.0%
원 1
20.0%
Uppercase Letter
ValueCountFrequency (%)
N 1
20.0%
H 1
20.0%
C 1
20.0%
D 1
20.0%
M 1
20.0%
Decimal Number
ValueCountFrequency (%)
0 3
50.0%
4 1
 
16.7%
2 1
 
16.7%
5 1
 
16.7%

Most occurring scripts

ValueCountFrequency (%)
Common 6
37.5%
Hangul 5
31.2%
Latin 5
31.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
차 1
20.0%
도 1
20.0%
등 1
20.0%
광 1
20.0%
원 1
20.0%
Latin
ValueCountFrequency (%)
N 1
20.0%
H 1
20.0%
C 1
20.0%
D 1
20.0%
M 1
20.0%
Common
ValueCountFrequency (%)
0 3
50.0%
4 1
 
16.7%
2 1
 
16.7%
5 1
 
16.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 11
68.8%
Hangul 5
31.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 3
27.3%
N 1
 
9.1%
H 1
 
9.1%
4 1
 
9.1%
C 1
 
9.1%
D 1
 
9.1%
M 1
 
9.1%
2 1
 
9.1%
5 1
 
9.1%
Hangul
ValueCountFrequency (%)
차 1
20.0%
도 1
20.0%
등 1
20.0%
광 1
20.0%
원 1
20.0%

Unnamed: 29
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing171
Missing (%)97.7%
Memory size1.5 KiB

Unnamed: 30
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing170
Missing (%)97.1%
Memory size1.5 KiB

Unnamed: 31
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing171
Missing (%)97.7%
Memory size1.5 KiB

Unnamed: 32
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing168
Missing (%)96.0%
Memory size1.5 KiB

Unnamed: 33
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing168
Missing (%)96.0%
Memory size1.5 KiB

Unnamed: 34
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing169
Missing (%)96.6%
Memory size1.5 KiB

Unnamed: 35
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing171
Missing (%)97.7%
Memory size1.5 KiB

Unnamed: 36
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing172
Missing (%)98.3%
Memory size1.5 KiB

Unnamed: 37
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing168
Missing (%)96.0%
Memory size1.5 KiB

Unnamed: 38
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing166
Missing (%)94.9%
Memory size1.5 KiB

Unnamed: 39
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing166
Missing (%)94.9%
Memory size1.5 KiB

Unnamed: 40
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing170
Missing (%)97.1%
Memory size1.5 KiB

Unnamed: 41
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing170
Missing (%)97.1%
Memory size1.5 KiB

Unnamed: 42
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing170
Missing (%)97.1%
Memory size1.5 KiB

Unnamed: 43
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing130
Missing (%)74.3%
Memory size1.5 KiB

Unnamed: 44
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing133
Missing (%)76.0%
Memory size1.5 KiB

Sample

5-1. 노선별 가로등 시설현황(시도)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22Unnamed: 23Unnamed: 24Unnamed: 25Unnamed: 26Unnamed: 27Unnamed: 28Unnamed: 29Unnamed: 30Unnamed: 31Unnamed: 32Unnamed: 33Unnamed: 34Unnamed: 35Unnamed: 36Unnamed: 37Unnamed: 38Unnamed: 39Unnamed: 40Unnamed: 41Unnamed: 42Unnamed: 43Unnamed: 44
0○ [(형태 : 마주보기-A, 지그재그-B, 한쪽-C, 중앙-D) (등주type : 원형-R, 팔각-E, STS-S, AL-A,) (표기 예시)알미늄재질원형 10m Y주 암2.5m=AR10Y-25 ]<NA><NA><NA>NaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1○ 설치년도,광원,용량,형태,배전방식,등주타입 등이 다를때에는 다음 칸을 이용(같은 칸에서 Alt Enter 키 이용금지)<NA><NA><NA>NaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2○ 도로연장은 편측설치, 양측설치를 구분하고 실제 도로연장만 기재(가로등 설치연장 자동계산 됨)<NA><NA><NA>NaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
3○ 교량하부등은 각종 하부통과도로 상에 있는 조명을 뜻하며 교량점검용 조명은 제외할 것<NA><NA><NA>NaNNaNNaNNaNNaNNaNNaN<NA>NaN675612057961NaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
4도로 구분노선 번호노선명구 간노폭\n(m)도로연장(m)NaN가로등\n설치연장설치\n년도조도\n(lx)경간\n(m)형태선로\n배전\n방식차도등NaNNaNNaN보행등<NA>NaN육교수\n(개소)\n/\n등수NaNNaNNaN교량하부등NaNNaN터널등<NA>NaNNaNNaN지하(보)차도등NaNNaNNaNNaN지하보도등NaNNaN경관조명NaNNaN분전함\n(수량)비고
5<NA><NA><NA><NA>NaN편측양측NaNNaNNaNNaN<NA>NaN등주type본수광원등수본수광원등수육교\n(개소)본수광원등수하부\n(개소)광원등수터널\n(개소)차도등NaN보행등NaN차도\n(개소)차도등NaN보도등NaN보도\n(개소)광원등수설치\n(개소)광원등수NaNNaN
6<NA><NA><NA><NA>NaNNaNNaN(편+양×2)NaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaN광원등수광원등수NaN광원등수광원등수NaNNaNNaNNaNNaNNaNNaNNaN
7시도예시00로00~0040NaN14002800992230A2SR10-25100NH3501000CDM7030110CDM7010NaNNaNNaN1NH4002000FL452001NA400100NaNNaNNaNNA25050NaNNaNNaN5NaN
8<NA><NA>〃00~0030NaN13002600992230A2SR10-2550NA400500NH7020NaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN3NaN
9<NA><NA>〃00~00405013002650042230A2SR12Y-2550CDM2501000NA10020220CDM7020NaNNaNNaNNaN<NA>NaNNaNNaN1NA400100FL321002NA250501NA250505NaN
5-1. 노선별 가로등 시설현황(시도)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22Unnamed: 23Unnamed: 24Unnamed: 25Unnamed: 26Unnamed: 27Unnamed: 28Unnamed: 29Unnamed: 30Unnamed: 31Unnamed: 32Unnamed: 33Unnamed: 34Unnamed: 35Unnamed: 36Unnamed: 37Unnamed: 38Unnamed: 39Unnamed: 40Unnamed: 41Unnamed: 42Unnamed: 43Unnamed: 44
165<NA><NA>중대로광평교~선수촌삼거리30NaN3300660020063025A2SR12-2898MH35098NaNMH100152NaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1186
166<NA><NA>천호대로천호대교남단~천호역NaN450NaN45019973025A2R10-2515MH35015NaNCDM7015NaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
167<NA><NA>올림픽로평화의광장~강동대로40NaN1000200020163030A2SR10-2564LED12568NaNLED3061NaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN413
168<NA><NA>올림픽로평화의광장~강동대로NaNNaNNaN020163030B2SR5-10NaNNaNNaN14LED3014NaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
169<NA><NA>올림픽로평화의광장~강동대로40NaNNaN020163030A2SR10-R45LED20020NaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
170<NA><NA>올림픽로평화의광장~천호대로40NaNNaN0199930NaN<NA>2SE10-교차38CDM25024NaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
171<NA><NA>헌릉로복정사거리~대곡교50NaN5101020201022NaNA2E10-2526CDM25026NaNMH1004NaNNaNNaNNaN1CDM25020NaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN312
172<NA><NA>올림픽로천호사거리~영파여고40600NaN60020152230A2SE10-2521LED10024NaNLED3521NaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN120
173<NA><NA>올림픽로강동대로~영파여고401080NaN108020152240A2SE10-2532LED12046NaNLED2532NaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN243
174<NA><NA>올림픽로구청앞 사거리40NaNNaN0200922NaN<NA>2NaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNFL32외134NaNNaNNaN133

Duplicate rows

Most frequently occurring

5-1. 노선별 가로등 시설현황(시도)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 11Unnamed: 18Unnamed: 28# duplicates
3<NA><NA>백제고분로아시아선수촌아파트교차로~올림픽공원남4문사거리ALED25<NA>5
0<NA><NA>강동대로올림픽대교~동남로B<NA><NA>3
4<NA><NA>삼전로갤러리아~탄천1교B<NA><NA>3
15<NA><NA>양재대로올림픽공원역 앞<NA>LED25<NA>3
16<NA><NA>양재대로탄천교~송파대로<NA><NA><NA>3
17<NA><NA>오금로잠실나루역입구~구청~방이고가A<NA><NA>3
22<NA><NA>올림픽로삼성교~운동장사거리<NA><NA><NA>3
25<NA><NA>위례성대로평화의문~올림픽공원사거리<NA><NA><NA>3
1<NA><NA>동남로서하남입구~장지동RB<NA><NA>2
2<NA><NA>동남로위례성길~송파대로(로데오)<NA><NA><NA>2