Overview

Dataset statistics

Number of variables17
Number of observations4536
Missing cells0
Missing cells (%)0.0%
Duplicate rows332
Duplicate rows (%)7.3%
Total size in memory620.3 KiB
Average record size in memory140.0 B

Variable types

Categorical16
Text1

Dataset

Description부산광역시 동래구 가로등 현황에 대한 데이터로 관리기관, 설치장소, 설치개수, 설치구분, ARM길이, ARM형태, ARM재질, 등주형상, 등주형식, 등주높이, 등주재질, 등기구(규격), 등기구(개수), 램프(규격), 램프(개수), 안정기(규격), 안정기(개수) 등의 항목을 제공합니다.
Author부산광역시 동래구
URLhttps://www.data.go.kr/data/15020532/fileData.do

Alerts

관리기관 has constant value ""Constant
개수 has constant value ""Constant
암형태 has constant value ""Constant
등기구(개수) has constant value ""Constant
램프(개수) has constant value ""Constant
안정기(개수) has constant value ""Constant
Dataset has 332 (7.3%) duplicate rowsDuplicates
등주재질 is highly overall correlated with 암재질 and 2 other fieldsHigh correlation
암재질 is highly overall correlated with 등주형상 and 2 other fieldsHigh correlation
등기구(규격) is highly overall correlated with 램프(규격) and 1 other fieldsHigh correlation
램프(규격) is highly overall correlated with 등기구(규격) and 1 other fieldsHigh correlation
안정기(규격) is highly overall correlated with 암재질 and 3 other fieldsHigh correlation
등주형상 is highly overall correlated with 암재질 and 1 other fieldsHigh correlation
설치구분 is highly imbalanced (98.3%)Imbalance
암길이 is highly imbalanced (51.6%)Imbalance
암재질 is highly imbalanced (97.1%)Imbalance
등주형상 is highly imbalanced (90.8%)Imbalance
등주형식 is highly imbalanced (78.2%)Imbalance
등주재질 is highly imbalanced (97.1%)Imbalance
등기구(규격) is highly imbalanced (99.4%)Imbalance
램프(규격) is highly imbalanced (99.5%)Imbalance
안정기(규격) is highly imbalanced (98.9%)Imbalance

Reproduction

Analysis started2024-03-14 10:03:06.108193
Analysis finished2024-03-14 10:03:08.610808
Duration2.5 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size35.6 KiB
부산광역시 동래구 안전도시국 도시재생과
4536 

Length

Max length21
Median length21
Mean length21
Min length21

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row부산광역시 동래구 안전도시국 도시재생과
2nd row부산광역시 동래구 안전도시국 도시재생과
3rd row부산광역시 동래구 안전도시국 도시재생과
4th row부산광역시 동래구 안전도시국 도시재생과
5th row부산광역시 동래구 안전도시국 도시재생과

Common Values

ValueCountFrequency (%)
부산광역시 동래구 안전도시국 도시재생과 4536
100.0%

Length

2024-03-14T19:03:08.716188image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T19:03:08.867777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
부산광역시 4536
25.0%
동래구 4536
25.0%
안전도시국 4536
25.0%
도시재생과 4536
25.0%

소재지
Text

Distinct1931
Distinct (%)42.6%
Missing0
Missing (%)0.0%
Memory size35.6 KiB
2024-03-14T19:03:09.816778image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length103
Median length37
Mean length18.325176
Min length10

Characters and Unicode

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

Unique

Unique1638 ?
Unique (%)36.1%

Sample

1st row부산광역시 동래구 온천동 473-10
2nd row부산광역시 동래구 온천동 473-8
3rd row부산광역시 동래구 온천동 450-8
4th row부산광역시 동래구 온천동 183-3
5th row부산광역시 동래구 온천동 452-16
ValueCountFrequency (%)
동래구 4787
28.4%
부산광역시 4695
27.8%
온천동 661
 
3.9%
안락동 403
 
2.4%
사직동 280
 
1.7%
명장동 255
 
1.5%
앞 221
 
1.3%
주변 218
 
1.3%
수안동 175
 
1.0%
명륜동 156
 
0.9%
Other values (2177) 5010
29.7%
2024-03-14T19:03:11.102198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
15296
18.4%
동 7749
 
9.3%
래 5207
 
6.3%
시 4901
 
5.9%
산 4901
 
5.9%
구 4868
 
5.9%
역 4779
 
5.7%
부 4736
 
5.7%
광 4709
 
5.7%
1 2464
 
3.0%
Other values (352) 23513
28.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 55417
66.7%
Space Separator 15296
 
18.4%
Decimal Number 10047
 
12.1%
Dash Punctuation 2077
 
2.5%
Uppercase Letter 127
 
0.2%
Math Symbol 43
 
0.1%
Close Punctuation 41
 
< 0.1%
Open Punctuation 41
 
< 0.1%
Other Punctuation 21
 
< 0.1%
Lowercase Letter 13
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 7749
14.0%
래 5207
9.4%
시 4901
8.8%
산 4901
8.8%
구 4868
8.8%
역 4779
8.6%
부 4736
8.5%
광 4709
 
8.5%
천 892
 
1.6%
안 878
 
1.6%
Other values (313) 11797
21.3%
Uppercase Letter
ValueCountFrequency (%)
S 26
20.5%
K 26
20.5%
L 16
12.6%
D 16
12.6%
R 15
11.8%
E 14
11.0%
W 4
 
3.1%
A 3
 
2.4%
G 3
 
2.4%
C 1
 
0.8%
Other values (3) 3
 
2.4%
Decimal Number
ValueCountFrequency (%)
1 2464
24.5%
2 1286
12.8%
3 1132
11.3%
4 1077
10.7%
5 857
 
8.5%
6 784
 
7.8%
7 667
 
6.6%
0 632
 
6.3%
9 601
 
6.0%
8 547
 
5.4%
Lowercase Letter
ValueCountFrequency (%)
g 2
15.4%
s 2
15.4%
k 2
15.4%
l 2
15.4%
y 1
7.7%
a 1
7.7%
i 1
7.7%
f 1
7.7%
t 1
7.7%
Other Punctuation
ValueCountFrequency (%)
. 18
85.7%
/ 3
 
14.3%
Space Separator
ValueCountFrequency (%)
15296
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2077
100.0%
Math Symbol
ValueCountFrequency (%)
~ 43
100.0%
Close Punctuation
ValueCountFrequency (%)
) 41
100.0%
Open Punctuation
ValueCountFrequency (%)
( 41
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 55417
66.7%
Common 27566
33.2%
Latin 140
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 7749
14.0%
래 5207
9.4%
시 4901
8.8%
산 4901
8.8%
구 4868
8.8%
역 4779
8.6%
부 4736
8.5%
광 4709
 
8.5%
천 892
 
1.6%
안 878
 
1.6%
Other values (313) 11797
21.3%
Latin
ValueCountFrequency (%)
S 26
18.6%
K 26
18.6%
L 16
11.4%
D 16
11.4%
R 15
10.7%
E 14
10.0%
W 4
 
2.9%
A 3
 
2.1%
G 3
 
2.1%
g 2
 
1.4%
Other values (12) 15
10.7%
Common
ValueCountFrequency (%)
15296
55.5%
1 2464
 
8.9%
- 2077
 
7.5%
2 1286
 
4.7%
3 1132
 
4.1%
4 1077
 
3.9%
5 857
 
3.1%
6 784
 
2.8%
7 667
 
2.4%
0 632
 
2.3%
Other values (7) 1294
 
4.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 55417
66.7%
ASCII 27706
33.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
15296
55.2%
1 2464
 
8.9%
- 2077
 
7.5%
2 1286
 
4.6%
3 1132
 
4.1%
4 1077
 
3.9%
5 857
 
3.1%
6 784
 
2.8%
7 667
 
2.4%
0 632
 
2.3%
Other values (29) 1434
 
5.2%
Hangul
ValueCountFrequency (%)
동 7749
14.0%
래 5207
9.4%
시 4901
8.8%
산 4901
8.8%
구 4868
8.8%
역 4779
8.6%
부 4736
8.5%
광 4709
 
8.5%
천 892
 
1.6%
안 878
 
1.6%
Other values (313) 11797
21.3%

개수
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size35.6 KiB
1
4536 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 4536
100.0%

Length

2024-03-14T19:03:11.341996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T19:03:11.559328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 4536
100.0%

설치구분
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size35.6 KiB
가로등
4529 
교량상하부등
 
7

Length

Max length6
Median length3
Mean length3.0046296
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가로등
2nd row가로등
3rd row가로등
4th row가로등
5th row가로등

Common Values

ValueCountFrequency (%)
가로등 4529
99.8%
교량상하부등 7
 
0.2%

Length

2024-03-14T19:03:11.727270image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T19:03:11.896610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가로등 4529
99.8%
교량상하부등 7
 
0.2%

암길이
Categorical

IMBALANCE 

Distinct32
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size35.6 KiB
1.8~1.8
1708 
0~0
1467 
.5~.5
346 
1.5~1.5
299 
2.5~2.5
257 
Other values (27)
459 

Length

Max length7
Median length7
Mean length5.2852734
Min length3

Unique

Unique16 ?
Unique (%)0.4%

Sample

1st row1.8~1.8
2nd row1.8~1.8
3rd row1.8~1.8
4th row1.8~1.8
5th row1.8~1.8

Common Values

ValueCountFrequency (%)
1.8~1.8 1708
37.7%
0~0 1467
32.3%
.5~.5 346
 
7.6%
1.5~1.5 299
 
6.6%
2.5~2.5 257
 
5.7%
2~2 207
 
4.6%
1.6~1.6 90
 
2.0%
1~1 78
 
1.7%
1.3~1.3 27
 
0.6%
3~3 12
 
0.3%
Other values (22) 45
 
1.0%

Length

2024-03-14T19:03:12.088536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
1.8~1.8 1708
37.7%
0~0 1467
32.3%
5~.5 346
 
7.6%
1.5~1.5 299
 
6.6%
2.5~2.5 257
 
5.7%
2~2 207
 
4.6%
1.6~1.6 90
 
2.0%
1~1 78
 
1.7%
1.3~1.3 27
 
0.6%
3~3 12
 
0.3%
Other values (22) 45
 
1.0%

암형태
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size35.6 KiB
사각형
4536 

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 (%)
사각형 4536
100.0%

Length

2024-03-14T19:03:12.307231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T19:03:12.462347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사각형 4536
100.0%

암재질
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct4
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size35.6 KiB
철팔각
4510 
FRP
 
14
주철
 
11
한전주병설
 
1

Length

Max length5
Median length3
Mean length2.9980159
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row철팔각
2nd row철팔각
3rd row철팔각
4th row주철
5th row철팔각

Common Values

ValueCountFrequency (%)
철팔각 4510
99.4%
FRP 14
 
0.3%
주철 11
 
0.2%
한전주병설 1
 
< 0.1%

Length

2024-03-14T19:03:12.731846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T19:03:12.911120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
철팔각 4510
99.4%
frp 14
 
0.3%
주철 11
 
0.2%
한전주병설 1
 
< 0.1%

등주형상
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size35.6 KiB
원형
4483 
팔각
 
53

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 (%)
원형 4483
98.8%
팔각 53
 
1.2%

Length

2024-03-14T19:03:13.088832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T19:03:13.248624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
원형 4483
98.8%
팔각 53
 
1.2%

등주형식
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size35.6 KiB
1등용
4378 
2등용
 
158

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1등용
2nd row1등용
3rd row1등용
4th row1등용
5th row1등용

Common Values

ValueCountFrequency (%)
1등용 4378
96.5%
2등용 158
 
3.5%

Length

2024-03-14T19:03:13.412918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T19:03:13.571838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1등용 4378
96.5%
2등용 158
 
3.5%

등주높이
Categorical

Distinct19
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size35.6 KiB
8.5~8.5
1708 
0~0
1677 
8~8
409 
10~10
199 
9~9
 
150
Other values (14)
393 

Length

Max length7
Median length3
Mean length4.7279541
Min length3

Unique

Unique2 ?
Unique (%)< 0.1%

Sample

1st row8.5~8.5
2nd row8.5~8.5
3rd row8.5~8.5
4th row8.5~8.5
5th row8.5~8.5

Common Values

ValueCountFrequency (%)
8.5~8.5 1708
37.7%
0~0 1677
37.0%
8~8 409
 
9.0%
10~10 199
 
4.4%
9~9 150
 
3.3%
5~5 104
 
2.3%
7~7 72
 
1.6%
5.4~5.4 68
 
1.5%
4.5~4.5 34
 
0.7%
7.5~7.5 33
 
0.7%
Other values (9) 82
 
1.8%

Length

2024-03-14T19:03:13.835131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
8.5~8.5 1708
37.7%
0~0 1677
37.0%
8~8 409
 
9.0%
10~10 199
 
4.4%
9~9 150
 
3.3%
5~5 104
 
2.3%
7~7 72
 
1.6%
5.4~5.4 68
 
1.5%
4.5~4.5 34
 
0.7%
7.5~7.5 33
 
0.7%
Other values (9) 82
 
1.8%

등주재질
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct4
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size35.6 KiB
철팔각
4510 
FRP
 
14
주철
 
11
한전주병설
 
1

Length

Max length5
Median length3
Mean length2.9980159
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row철팔각
2nd row철팔각
3rd row철팔각
4th row주철
5th row철팔각

Common Values

ValueCountFrequency (%)
철팔각 4510
99.4%
FRP 14
 
0.3%
주철 11
 
0.2%
한전주병설 1
 
< 0.1%

Length

2024-03-14T19:03:14.087947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T19:03:14.267079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
철팔각 4510
99.4%
frp 14
 
0.3%
주철 11
 
0.2%
한전주병설 1
 
< 0.1%

등기구(규격)
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size35.6 KiB
사각형
4534 
원형
 
2

Length

Max length3
Median length3
Mean length2.9995591
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row사각형
2nd row사각형
3rd row사각형
4th row사각형
5th row사각형

Common Values

ValueCountFrequency (%)
사각형 4534
> 99.9%
원형 2
 
< 0.1%

Length

2024-03-14T19:03:14.450031image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T19:03:14.612883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사각형 4534
> 99.9%
원형 2
 
< 0.1%

등기구(개수)
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size35.6 KiB
1
4536 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 4536
100.0%

Length

2024-03-14T19:03:14.777044image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T19:03:14.958640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 4536
100.0%

램프(규격)
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size35.6 KiB
고압NT(NH형)220V/250W
4533 
고효율 메탈 200W
 
2
메탈(고효율200w)
 
1

Length

Max length18
Median length18
Mean length17.99537
Min length11

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row고압NT(NH형)220V/250W
2nd row고압NT(NH형)220V/250W
3rd row고압NT(NH형)220V/250W
4th row메탈(고효율200w)
5th row고압NT(NH형)220V/250W

Common Values

ValueCountFrequency (%)
고압NT(NH형)220V/250W 4533
99.9%
고효율 메탈 200W 2
 
< 0.1%
메탈(고효율200w) 1
 
< 0.1%

Length

2024-03-14T19:03:15.394687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T19:03:15.569461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
고압nt(nh형)220v/250w 4533
99.8%
고효율 2
 
< 0.1%
메탈 2
 
< 0.1%
200w 2
 
< 0.1%
메탈(고효율200w 1
 
< 0.1%

램프(개수)
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size35.6 KiB
1
4536 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 4536
100.0%

Length

2024-03-14T19:03:15.746041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T19:03:15.895544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 4536
100.0%

안정기(규격)
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct15
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size35.6 KiB
고압NT(CC형)220V/250W
4522 
메탈(고효율200w)
 
1
고효율 메탈 200W
 
1
고효율 메탈 200W
 
1
고압NT(CC형)220V/251W
 
1
Other values (10)
 
10

Length

Max length18
Median length18
Mean length17.995591
Min length11

Unique

Unique14 ?
Unique (%)0.3%

Sample

1st row고압NT(CC형)220V/250W
2nd row고압NT(CC형)220V/250W
3rd row고압NT(CC형)220V/250W
4th row메탈(고효율200w)
5th row고압NT(CC형)220V/250W

Common Values

ValueCountFrequency (%)
고압NT(CC형)220V/250W 4522
99.7%
메탈(고효율200w) 1
 
< 0.1%
고효율 메탈 200W 1
 
< 0.1%
고효율 메탈 200W 1
 
< 0.1%
고압NT(CC형)220V/251W 1
 
< 0.1%
고압NT(CC형)220V/252W 1
 
< 0.1%
고압NT(CC형)220V/253W 1
 
< 0.1%
고압NT(CC형)220V/254W 1
 
< 0.1%
고압NT(CC형)220V/255W 1
 
< 0.1%
고압NT(CC형)220V/256W 1
 
< 0.1%
Other values (5) 5
 
0.1%

Length

2024-03-14T19:03:16.072477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
고압nt(cc형)220v/250w 4522
99.6%
고효율 2
 
< 0.1%
메탈 2
 
< 0.1%
200w 2
 
< 0.1%
메탈(고효율200w 1
 
< 0.1%
고압nt(cc형)220v/251w 1
 
< 0.1%
고압nt(cc형)220v/252w 1
 
< 0.1%
고압nt(cc형)220v/253w 1
 
< 0.1%
고압nt(cc형)220v/254w 1
 
< 0.1%
고압nt(cc형)220v/255w 1
 
< 0.1%
Other values (6) 6
 
0.1%

안정기(개수)
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size35.6 KiB
1
4536 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 4536
100.0%

Length

2024-03-14T19:03:16.364154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T19:03:16.513345image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 4536
100.0%

Correlations

2024-03-14T19:03:16.623066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치구분암길이암재질등주형상등주형식등주높이등주재질등기구(규격)램프(규격)안정기(규격)
설치구분1.0000.0000.0000.5020.0000.0000.0000.0000.0000.000
암길이0.0001.0000.0000.0880.3710.8380.0000.0000.0000.000
암재질0.0000.0001.0000.7160.0000.0941.0000.6140.3780.796
등주형상0.5020.0880.7161.0000.0040.0980.7160.0000.0000.253
등주형식0.0000.3710.0000.0041.0000.2530.0000.0000.0000.000
등주높이0.0000.8380.0940.0980.2531.0000.0940.1380.1420.000
등주재질0.0000.0001.0000.7160.0000.0941.0000.6140.3780.796
등기구(규격)0.0000.0000.6140.0000.0000.1380.6141.0001.0001.000
램프(규격)0.0000.0000.3780.0000.0000.1420.3781.0001.0001.000
안정기(규격)0.0000.0000.7960.2530.0000.0000.7961.0001.0001.000
2024-03-14T19:03:16.846661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
등주재질등주형식등주형상설치구분암재질등기구(규격)등주높이램프(규격)안정기(규격)암길이
등주재질1.0000.0000.5110.0001.0000.4250.0510.3680.5950.000
등주형식0.0001.0000.0030.0000.0000.0000.2240.0000.0000.294
등주형상0.5110.0031.0000.3350.5110.0000.0870.0000.2300.069
설치구분0.0000.0000.3351.0000.0000.0000.0000.0000.0000.000
암재질1.0000.0000.5110.0001.0000.4250.0510.3680.5950.000
등기구(규격)0.4250.0000.0000.0000.4251.0000.1221.0000.9990.000
등주높이0.0510.2240.0870.0000.0510.1221.0000.0750.0000.386
램프(규격)0.3680.0000.0000.0000.3681.0000.0751.0000.9990.000
안정기(규격)0.5950.0000.2300.0000.5950.9990.0000.9991.0000.000
암길이0.0000.2940.0690.0000.0000.0000.3860.0000.0001.000
2024-03-14T19:03:17.068559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치구분암길이암재질등주형상등주형식등주높이등주재질등기구(규격)램프(규격)안정기(규격)
설치구분1.0000.0000.0000.3350.0000.0000.0000.0000.0000.000
암길이0.0001.0000.0000.0690.2940.3860.0000.0000.0000.000
암재질0.0000.0001.0000.5110.0000.0511.0000.4250.3680.595
등주형상0.3350.0690.5111.0000.0030.0870.5110.0000.0000.230
등주형식0.0000.2940.0000.0031.0000.2240.0000.0000.0000.000
등주높이0.0000.3860.0510.0870.2241.0000.0510.1220.0750.000
등주재질0.0000.0001.0000.5110.0000.0511.0000.4250.3680.595
등기구(규격)0.0000.0000.4250.0000.0000.1220.4251.0001.0000.999
램프(규격)0.0000.0000.3680.0000.0000.0750.3681.0001.0000.999
안정기(규격)0.0000.0000.5950.2300.0000.0000.5950.9990.9991.000

Missing values

2024-03-14T19:03:07.955955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T19:03:08.448839image/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부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구 온천동 473-101가로등1.8~1.8사각형철팔각팔각1등용8.5~8.5철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1
1부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구 온천동 473-81가로등1.8~1.8사각형철팔각팔각1등용8.5~8.5철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1
2부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구 온천동 450-81가로등1.8~1.8사각형철팔각팔각1등용8.5~8.5철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1
3부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구 온천동 183-31가로등1.8~1.8사각형주철원형1등용8.5~8.5주철사각형1메탈(고효율200w)1메탈(고효율200w)1
4부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구 온천동 452-161가로등1.8~1.8사각형철팔각팔각1등용8.5~8.5철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1
5부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구 온천동 185-931가로등1.8~1.8사각형철팔각팔각1등용8.5~8.5철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1
6부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구 온천동 450-61가로등1.8~1.8사각형철팔각팔각1등용8.5~8.5철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1
7부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구 온천동 475-201가로등1.8~1.8사각형철팔각팔각1등용8.5~8.5철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1
8부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구 온천동 444-631가로등1.8~1.8사각형철팔각팔각1등용8.5~8.5철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1
9부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구 온천동 444-751가로등1.8~1.8사각형철팔각팔각1등용8.5~8.5철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1
관리기관소재지개수설치구분암길이암형태암재질등주형상등주형식등주높이등주재질등기구(규격)등기구(개수)램프(규격)램프(개수)안정기(규격)안정기(개수)
4526부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구1가로등0~0사각형철팔각원형1등용9~9철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1
4527부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구1가로등0~0사각형철팔각원형1등용0~0철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1
4528부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구1가로등0~0사각형철팔각원형1등용0~0철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1
4529부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구1가로등0~0사각형철팔각원형1등용0~0철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1
4530부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구1가로등0~0사각형철팔각원형1등용0~0철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1
4531부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구1가로등0~0사각형철팔각원형1등용0~0철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1
4532부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구1가로등0~0사각형철팔각원형1등용0~0철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1
4533부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구1가로등0~0사각형철팔각원형1등용0~0철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1
4534부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구1가로등0~0사각형철팔각원형1등용0~0철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1
4535부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구1가로등0~0사각형철팔각원형1등용0~0철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1

Duplicate rows

Most frequently occurring

관리기관소재지개수설치구분암길이암형태암재질등주형상등주형식등주높이등주재질등기구(규격)등기구(개수)램프(규격)램프(개수)안정기(규격)안정기(개수)# duplicates
1부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구1가로등0~0사각형철팔각원형1등용0~0철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W11072
152부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구 부산광역시 동래구 온천동 동래래미안 아이파크 주변1가로등2.5~2.5사각형철팔각원형1등용8~8철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1146
73부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구 도시고속도로1가로등0~0사각형철팔각원형1등용0~0철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W1131
13부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구1가로등1.8~1.8사각형철팔각원형1등용8.5~8.5철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W157
5부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구1가로등0~0사각형철팔각원형2등용0~0철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W134
24부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구1가로등2~2사각형철팔각원형1등용9~9철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W134
36부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구1가로등1~1사각형철팔각원형2등용10~10철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W134
38부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구1가로등2.5~2.5사각형철팔각원형1등용7~7철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W130
158부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구 사직 아시아드 지역주택조합1가로등2~2사각형철팔각원형1등용9~9철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W126
4부산광역시 동래구 안전도시국 도시재생과부산광역시 동래구1가로등0~0사각형철팔각원형1등용9~9철팔각사각형1고압NT(NH형)220V/250W1고압NT(CC형)220V/250W125