Overview

Dataset statistics

Number of variables11
Number of observations2900
Missing cells311
Missing cells (%)1.0%
Duplicate rows3
Duplicate rows (%)0.1%
Total size in memory252.2 KiB
Average record size in memory89.0 B

Variable types

Categorical7
Text3
Numeric1

Dataset

Description2022년도 기준 부산광역시 동구 가로등 설치장소, 관리번호, 설치높이 및 가로등주 색상, 재질 등에 관한 자료를 현황하하여 정보제공합니다.
Author부산광역시 동구
URLhttps://www.data.go.kr/data/15038701/fileData.do

Alerts

등록구 has constant value ""Constant
Dataset has 3 (0.1%) duplicate rowsDuplicates
등주형상 is highly overall correlated with 등주재질High correlation
등주재질 is highly overall correlated with 등주형상High correlation
관리기관 is highly imbalanced (67.7%)Imbalance
설치구분 is highly imbalanced (75.6%)Imbalance
설치일자 has 58 (2.0%) missing valuesMissing
설치장소 has 249 (8.6%) missing valuesMissing
등주높이 has 304 (10.5%) zerosZeros

Reproduction

Analysis started2023-12-12 12:38:04.233736
Analysis finished2023-12-12 12:38:05.775105
Duration1.54 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

등록구
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size22.8 KiB
동구
2900 

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 (%)
동구 2900
100.0%

Length

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

Common Values (Plot)

2023-12-12T21:38:05.932656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동구 2900
100.0%

관리기관
Categorical

IMBALANCE 

Distinct9
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size22.8 KiB
동구 도시국 도시안전과
2266 
동구
391 
동구 도시국 건설과
 
215
<NA>
 
21
동구 안전도시국 건설과
 
3
Other values (4)
 
4

Length

Max length12
Median length12
Mean length10.443448
Min length2

Unique

Unique4 ?
Unique (%)0.1%

Sample

1st row동구
2nd row동구
3rd row동구
4th row동구
5th row동구

Common Values

ValueCountFrequency (%)
동구 도시국 도시안전과 2266
78.1%
동구 391
 
13.5%
동구 도시국 건설과 215
 
7.4%
<NA> 21
 
0.7%
동구 안전도시국 건설과 3
 
0.1%
남구 도시국 건설과 1
 
< 0.1%
금정구 도시국 건설과 1
 
< 0.1%
동래구 도시국 건설과 1
 
< 0.1%
도시개발실푸른도시과 1
 
< 0.1%

Length

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

Common Values (Plot)

2023-12-12T21:38:06.152822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동구 2875
36.5%
도시국 2484
31.5%
도시안전과 2266
28.8%
건설과 221
 
2.8%
na 21
 
0.3%
안전도시국 3
 
< 0.1%
남구 1
 
< 0.1%
금정구 1
 
< 0.1%
동래구 1
 
< 0.1%
도시개발실푸른도시과 1
 
< 0.1%

관리번호
Text

Distinct2836
Distinct (%)97.9%
Missing4
Missing (%)0.1%
Memory size22.8 KiB
2023-12-12T21:38:06.788849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length5.9526934
Min length1

Characters and Unicode

Total characters17239
Distinct characters59
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

Unique2795 ?
Unique (%)96.5%

Sample

1st row79-17
2nd row79-16
3rd row79-15
4th row79-14
5th row79-13
ValueCountFrequency (%)
12월 55
 
1.7%
04월 33
 
1.0%
09월 31
 
1.0%
03월 31
 
1.0%
08월 29
 
0.9%
07월 28
 
0.9%
10월 27
 
0.8%
01월 27
 
0.8%
02월 24
 
0.7%
05월 24
 
0.7%
Other values (2554) 2933
90.5%
2023-12-12T21:38:07.390989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 2956
17.1%
- 2527
14.7%
2 1123
 
6.5%
0 1004
 
5.8%
3 996
 
5.8%
4 938
 
5.4%
5 797
 
4.6%
7 793
 
4.6%
6 738
 
4.3%
8 648
 
3.8%
Other values (49) 4719
27.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 10624
61.6%
Dash Punctuation 2527
 
14.7%
Lowercase Letter 1418
 
8.2%
Other Letter 1053
 
6.1%
Uppercase Letter 863
 
5.0%
Space Separator 386
 
2.2%
Open Punctuation 133
 
0.8%
Close Punctuation 133
 
0.8%
Math Symbol 90
 
0.5%
Other Punctuation 12
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
일 354
33.6%
월 353
33.5%
씽 295
28.0%
관 11
 
1.0%
경 11
 
1.0%
범 5
 
0.5%
지 4
 
0.4%
잔 3
 
0.3%
디 3
 
0.3%
등 3
 
0.3%
Other values (9) 11
 
1.0%
Lowercase Letter
ValueCountFrequency (%)
a 190
13.4%
u 182
12.8%
e 172
12.1%
n 128
9.0%
r 126
8.9%
p 122
8.6%
c 101
7.1%
b 66
 
4.7%
y 62
 
4.4%
l 61
 
4.3%
Other values (4) 208
14.7%
Decimal Number
ValueCountFrequency (%)
1 2956
27.8%
2 1123
 
10.6%
0 1004
 
9.5%
3 996
 
9.4%
4 938
 
8.8%
5 797
 
7.5%
7 793
 
7.5%
6 738
 
6.9%
8 648
 
6.1%
9 631
 
5.9%
Uppercase Letter
ValueCountFrequency (%)
J 189
21.9%
M 125
14.5%
A 121
14.0%
P 77
8.9%
L 77
8.9%
F 66
 
7.6%
S 59
 
6.8%
O 54
 
6.3%
N 48
 
5.6%
D 47
 
5.4%
Dash Punctuation
ValueCountFrequency (%)
- 2527
100.0%
Space Separator
ValueCountFrequency (%)
386
100.0%
Open Punctuation
ValueCountFrequency (%)
( 133
100.0%
Close Punctuation
ValueCountFrequency (%)
) 133
100.0%
Math Symbol
ValueCountFrequency (%)
~ 90
100.0%
Other Punctuation
ValueCountFrequency (%)
, 12
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 13905
80.7%
Latin 2281
 
13.2%
Hangul 1053
 
6.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
a 190
 
8.3%
J 189
 
8.3%
u 182
 
8.0%
e 172
 
7.5%
n 128
 
5.6%
r 126
 
5.5%
M 125
 
5.5%
p 122
 
5.3%
A 121
 
5.3%
c 101
 
4.4%
Other values (14) 825
36.2%
Hangul
ValueCountFrequency (%)
일 354
33.6%
월 353
33.5%
씽 295
28.0%
관 11
 
1.0%
경 11
 
1.0%
범 5
 
0.5%
지 4
 
0.4%
잔 3
 
0.3%
디 3
 
0.3%
등 3
 
0.3%
Other values (9) 11
 
1.0%
Common
ValueCountFrequency (%)
1 2956
21.3%
- 2527
18.2%
2 1123
 
8.1%
0 1004
 
7.2%
3 996
 
7.2%
4 938
 
6.7%
5 797
 
5.7%
7 793
 
5.7%
6 738
 
5.3%
8 648
 
4.7%
Other values (6) 1385
10.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 16186
93.9%
Hangul 1053
 
6.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 2956
18.3%
- 2527
15.6%
2 1123
 
6.9%
0 1004
 
6.2%
3 996
 
6.2%
4 938
 
5.8%
5 797
 
4.9%
7 793
 
4.9%
6 738
 
4.6%
8 648
 
4.0%
Other values (30) 3666
22.6%
Hangul
ValueCountFrequency (%)
일 354
33.6%
월 353
33.5%
씽 295
28.0%
관 11
 
1.0%
경 11
 
1.0%
범 5
 
0.5%
지 4
 
0.4%
잔 3
 
0.3%
디 3
 
0.3%
등 3
 
0.3%
Other values (9) 11
 
1.0%

설치일자
Text

MISSING 

Distinct197
Distinct (%)6.9%
Missing58
Missing (%)2.0%
Memory size22.8 KiB
2023-12-12T21:38:07.744707image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length9.7114708
Min length1

Characters and Unicode

Total characters27600
Distinct characters12
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique32 ?
Unique (%)1.1%

Sample

1st row
2nd row
3rd row
4th row
5th row
ValueCountFrequency (%)
1984-07-27 108
 
3.9%
2020-10-09 83
 
3.0%
1986-11-18 82
 
3.0%
2010-10-29 71
 
2.6%
2001-11-30 59
 
2.2%
2012-01-03 58
 
2.1%
2004-09-22 53
 
1.9%
2001-11-28 51
 
1.9%
2001-01-10 47
 
1.7%
1996-03-29 46
 
1.7%
Other values (185) 2084
76.0%
2023-12-12T21:38:08.338486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 5710
20.7%
- 5484
19.9%
1 5023
18.2%
2 3370
12.2%
9 2743
9.9%
8 1248
 
4.5%
3 891
 
3.2%
5 852
 
3.1%
7 801
 
2.9%
4 707
 
2.6%
Other values (2) 771
 
2.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 21936
79.5%
Dash Punctuation 5484
 
19.9%
Space Separator 180
 
0.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 5710
26.0%
1 5023
22.9%
2 3370
15.4%
9 2743
12.5%
8 1248
 
5.7%
3 891
 
4.1%
5 852
 
3.9%
7 801
 
3.7%
4 707
 
3.2%
6 591
 
2.7%
Dash Punctuation
ValueCountFrequency (%)
- 5484
100.0%
Space Separator
ValueCountFrequency (%)
180
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 27600
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 5710
20.7%
- 5484
19.9%
1 5023
18.2%
2 3370
12.2%
9 2743
9.9%
8 1248
 
4.5%
3 891
 
3.2%
5 852
 
3.1%
7 801
 
2.9%
4 707
 
2.6%
Other values (2) 771
 
2.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 27600
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 5710
20.7%
- 5484
19.9%
1 5023
18.2%
2 3370
12.2%
9 2743
9.9%
8 1248
 
4.5%
3 891
 
3.2%
5 852
 
3.1%
7 801
 
2.9%
4 707
 
2.6%
Other values (2) 771
 
2.8%

설치장소
Text

MISSING 

Distinct788
Distinct (%)29.7%
Missing249
Missing (%)8.6%
Memory size22.8 KiB
2023-12-12T21:38:08.654946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length38
Median length30
Mean length11.044512
Min length1

Characters and Unicode

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

Unique

Unique382 ?
Unique (%)14.4%

Sample

1st row동구 초량동 653-3번지 일원
2nd row동구 초량동 653-3번지 일원
3rd row동구 초량동 653-3번지 일원
4th row동구 초량동 653-3번지 일원
5th row동구 초량동 653-3번지 일원
ValueCountFrequency (%)
주변 541
 
8.5%
앞 303
 
4.8%
위 159
 
2.5%
충장로 130
 
2.0%
동구 125
 
2.0%
고가교 119
 
1.9%
뒤 119
 
1.9%
옆 98
 
1.5%
중앙로 78
 
1.2%
건너편 75
 
1.2%
Other values (743) 4601
72.5%
2023-12-12T21:38:09.126361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3992
 
13.6%
동 1076
 
3.7%
로 861
 
2.9%
주 741
 
2.5%
변 647
 
2.2%
앞 590
 
2.0%
도 584
 
2.0%
부 523
 
1.8%
고 471
 
1.6%
정 470
 
1.6%
Other values (328) 19324
66.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 22405
76.5%
Space Separator 3992
 
13.6%
Decimal Number 1592
 
5.4%
Uppercase Letter 513
 
1.8%
Close Punctuation 232
 
0.8%
Open Punctuation 232
 
0.8%
Math Symbol 152
 
0.5%
Dash Punctuation 82
 
0.3%
Other Punctuation 79
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 1076
 
4.8%
로 861
 
3.8%
주 741
 
3.3%
변 647
 
2.9%
앞 590
 
2.6%
도 584
 
2.6%
부 523
 
2.3%
고 471
 
2.1%
정 470
 
2.1%
교 468
 
2.1%
Other values (292) 15974
71.3%
Uppercase Letter
ValueCountFrequency (%)
B 104
20.3%
D 73
14.2%
A 49
9.6%
S 42
8.2%
M 42
8.2%
T 35
 
6.8%
C 30
 
5.8%
P 29
 
5.7%
Y 20
 
3.9%
E 20
 
3.9%
Other values (7) 69
13.5%
Decimal Number
ValueCountFrequency (%)
1 322
20.2%
5 296
18.6%
2 295
18.5%
4 235
14.8%
3 202
12.7%
6 93
 
5.8%
9 49
 
3.1%
7 36
 
2.3%
8 35
 
2.2%
0 29
 
1.8%
Other Punctuation
ValueCountFrequency (%)
/ 73
92.4%
' 3
 
3.8%
. 3
 
3.8%
Math Symbol
ValueCountFrequency (%)
~ 83
54.6%
→ 69
45.4%
Space Separator
ValueCountFrequency (%)
3992
100.0%
Close Punctuation
ValueCountFrequency (%)
) 232
100.0%
Open Punctuation
ValueCountFrequency (%)
( 232
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 82
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 22405
76.5%
Common 6361
 
21.7%
Latin 513
 
1.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 1076
 
4.8%
로 861
 
3.8%
주 741
 
3.3%
변 647
 
2.9%
앞 590
 
2.6%
도 584
 
2.6%
부 523
 
2.3%
고 471
 
2.1%
정 470
 
2.1%
교 468
 
2.1%
Other values (292) 15974
71.3%
Common
ValueCountFrequency (%)
3992
62.8%
1 322
 
5.1%
5 296
 
4.7%
2 295
 
4.6%
4 235
 
3.7%
) 232
 
3.6%
( 232
 
3.6%
3 202
 
3.2%
6 93
 
1.5%
~ 83
 
1.3%
Other values (9) 379
 
6.0%
Latin
ValueCountFrequency (%)
B 104
20.3%
D 73
14.2%
A 49
9.6%
S 42
8.2%
M 42
8.2%
T 35
 
6.8%
C 30
 
5.8%
P 29
 
5.7%
Y 20
 
3.9%
E 20
 
3.9%
Other values (7) 69
13.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 22405
76.5%
ASCII 6805
 
23.2%
Arrows 69
 
0.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3992
58.7%
1 322
 
4.7%
5 296
 
4.3%
2 295
 
4.3%
4 235
 
3.5%
) 232
 
3.4%
( 232
 
3.4%
3 202
 
3.0%
B 104
 
1.5%
6 93
 
1.4%
Other values (25) 802
 
11.8%
Hangul
ValueCountFrequency (%)
동 1076
 
4.8%
로 861
 
3.8%
주 741
 
3.3%
변 647
 
2.9%
앞 590
 
2.6%
도 584
 
2.6%
부 523
 
2.3%
고 471
 
2.1%
정 470
 
2.1%
교 468
 
2.1%
Other values (292) 15974
71.3%
Arrows
ValueCountFrequency (%)
→ 69
100.0%

설치구분
Categorical

IMBALANCE 

Distinct7
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size22.8 KiB
가로등
2572 
보행등
 
213
교량상하부등
 
56
육교등
 
34
지하보도등
 
15
Other values (2)
 
10

Length

Max length6
Median length3
Mean length3.0737931
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
가로등 2572
88.7%
보행등 213
 
7.3%
교량상하부등 56
 
1.9%
육교등 34
 
1.2%
지하보도등 15
 
0.5%
지하차도등 6
 
0.2%
<NA> 4
 
0.1%

Length

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

Common Values (Plot)

2023-12-12T21:38:09.421449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가로등 2572
88.7%
보행등 213
 
7.3%
교량상하부등 56
 
1.9%
육교등 34
 
1.2%
지하보도등 15
 
0.5%
지하차도등 6
 
0.2%
na 4
 
0.1%

색상
Categorical

Distinct8
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size22.8 KiB
회색
1278 
명회색
1020 
기타
244 
<NA>
215 
하늘색
 
80
Other values (3)
 
63

Length

Max length4
Median length2
Mean length2.5496552
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row명회색
2nd row명회색
3rd row명회색
4th row명회색
5th row명회색

Common Values

ValueCountFrequency (%)
회색 1278
44.1%
명회색 1020
35.2%
기타 244
 
8.4%
<NA> 215
 
7.4%
하늘색 80
 
2.8%
검은색 50
 
1.7%
동분색 12
 
0.4%
연초록색 1
 
< 0.1%

Length

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

Common Values (Plot)

2023-12-12T21:38:09.760462image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
회색 1278
44.1%
명회색 1020
35.2%
기타 244
 
8.4%
na 215
 
7.4%
하늘색 80
 
2.8%
검은색 50
 
1.7%
동분색 12
 
0.4%
연초록색 1
 
< 0.1%

등주형식
Categorical

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size22.8 KiB
1등용
2299 
2등용
514 
<NA>
 
87

Length

Max length4
Median length3
Mean length3.03
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1등용 2299
79.3%
2등용 514
 
17.7%
<NA> 87
 
3.0%

Length

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

Common Values (Plot)

2023-12-12T21:38:10.050953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1등용 2299
79.3%
2등용 514
 
17.7%
na 87
 
3.0%

등주형상
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size22.8 KiB
원형
1757 
팔각
984 
<NA>
 
159

Length

Max length4
Median length2
Mean length2.1096552
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row원형
2nd row원형
3rd row원형
4th row원형
5th row원형

Common Values

ValueCountFrequency (%)
원형 1757
60.6%
팔각 984
33.9%
<NA> 159
 
5.5%

Length

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

Common Values (Plot)

2023-12-12T21:38:10.293095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
원형 1757
60.6%
팔각 984
33.9%
na 159
 
5.5%

등주재질
Categorical

HIGH CORRELATION 

Distinct13
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size22.8 KiB
철팔각
824 
원형철주
522 
SUS
466 
철주
336 
STEEL
196 
Other values (8)
556 

Length

Max length5
Median length4
Mean length3.2351724
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
철팔각 824
28.4%
원형철주 522
18.0%
SUS 466
16.1%
철주 336
11.6%
STEEL 196
 
6.8%
주철 161
 
5.6%
FRP 133
 
4.6%
<NA> 89
 
3.1%
한전주병설 87
 
3.0%
기타 56
 
1.9%
Other values (3) 30
 
1.0%

Length

2023-12-12T21:38:10.399956image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
철팔각 824
28.4%
원형철주 522
18.0%
sus 466
16.1%
철주 336
11.6%
steel 196
 
6.8%
주철 161
 
5.6%
frp 133
 
4.6%
na 89
 
3.1%
한전주병설 87
 
3.0%
기타 56
 
1.9%
Other values (3) 30
 
1.0%

등주높이
Real number (ℝ)

ZEROS 

Distinct18
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7.0755172
Minimum0
Maximum81
Zeros304
Zeros (%)10.5%
Negative0
Negative (%)0.0%
Memory size25.6 KiB
2023-12-12T21:38:10.508084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q16
median8.5
Q38.5
95-th percentile10
Maximum81
Range81
Interquartile range (IQR)2.5

Descriptive statistics

Standard deviation3.3248031
Coefficient of variation (CV)0.46990248
Kurtosis83.999927
Mean7.0755172
Median Absolute Deviation (MAD)0.5
Skewness2.7319033
Sum20519
Variance11.054316
MonotonicityNot monotonic
2023-12-12T21:38:10.619251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
8.5 1250
43.1%
10.0 328
 
11.3%
0.0 304
 
10.5%
9.0 208
 
7.2%
7.0 127
 
4.4%
5.0 123
 
4.2%
7.5 113
 
3.9%
6.0 105
 
3.6%
4.0 102
 
3.5%
1.5 69
 
2.4%
Other values (8) 171
 
5.9%
ValueCountFrequency (%)
0.0 304
10.5%
1.0 2
 
0.1%
1.5 69
 
2.4%
3.0 40
 
1.4%
3.5 16
 
0.6%
4.0 102
 
3.5%
4.5 4
 
0.1%
5.0 123
4.2%
6.0 105
 
3.6%
7.0 127
4.4%
ValueCountFrequency (%)
81.0 1
 
< 0.1%
11.0 10
 
0.3%
10.0 328
 
11.3%
9.5 52
 
1.8%
9.0 208
 
7.2%
8.5 1250
43.1%
8.0 46
 
1.6%
7.5 113
 
3.9%
7.0 127
 
4.4%
6.0 105
 
3.6%

Interactions

2023-12-12T21:38:05.140939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T21:38:10.712011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리기관설치구분색상등주형식등주형상등주재질등주높이
관리기관1.0000.3650.4080.0950.2690.5310.316
설치구분0.3651.0000.4680.1790.3210.5580.608
색상0.4080.4681.0000.1030.2730.6840.270
등주형식0.0950.1790.1031.0000.3000.4700.119
등주형상0.2690.3210.2730.3001.0000.9980.153
등주재질0.5310.5580.6840.4700.9981.0000.593
등주높이0.3160.6080.2700.1190.1530.5931.000
2023-12-12T21:38:10.817034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치구분등주형상색상관리기관등주재질등주형식
설치구분1.0000.2140.3230.2270.2520.129
등주형상0.2141.0000.2910.3280.9640.194
색상0.3230.2911.0000.3010.4200.110
관리기관0.2270.3280.3011.0000.3280.102
등주재질0.2520.9640.4200.3281.0000.365
등주형식0.1290.1940.1100.1020.3651.000
2023-12-12T21:38:10.933173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
등주높이관리기관설치구분색상등주형식등주형상등주재질
등주높이1.0000.2120.3090.1880.1960.2520.329
관리기관0.2121.0000.2270.3010.1020.3280.328
설치구분0.3090.2271.0000.3230.1290.2140.252
색상0.1880.3010.3231.0000.1100.2910.420
등주형식0.1960.1020.1290.1101.0000.1940.365
등주형상0.2520.3280.2140.2910.1941.0000.964
등주재질0.3290.3280.2520.4200.3650.9641.000

Missing values

2023-12-12T21:38:05.356093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:38:05.520432image/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.
2023-12-12T21:38:05.679285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

등록구관리기관관리번호설치일자설치장소설치구분색상등주형식등주형상등주재질등주높이
0동구동구79-17동구 초량동 653-3번지 일원가로등명회색1등용원형주철9.0
1동구동구79-16동구 초량동 653-3번지 일원가로등명회색1등용원형주철9.0
2동구동구79-15동구 초량동 653-3번지 일원가로등명회색1등용원형주철9.0
3동구동구79-14동구 초량동 653-3번지 일원가로등명회색1등용원형주철9.0
4동구동구79-13동구 초량동 653-3번지 일원가로등명회색1등용원형주철9.0
5동구동구Dec-79동구 초량동 653-3번지 일원가로등명회색1등용원형주철9.0
6동구동구Nov-79동구 초량동 653-3번지 일원가로등명회색1등용원형주철9.0
7동구동구Oct-79동구 초량동 653-3번지 일원가로등명회색1등용원형주철9.0
8동구동구Sep-79동구 초량동 653-3번지 일원가로등명회색1등용원형주철9.0
9동구동구Aug-79동구 초량동 653-3번지 일원가로등명회색1등용원형주철9.0
등록구관리기관관리번호설치일자설치장소설치구분색상등주형식등주형상등주재질등주높이
2890동구동구<NA>2018-06-29동구 좌천서린엘마르 주변가로등회색1등용원형철주8.0
2891동구동구 도시국 도시안전과01월 10일1986-11-18신한은행 주변가로등회색2등용원형원형철주9.5
2892동구동구 도시국 도시안전과01월 09일1986-11-18신한은해 주변가로등회색1등용원형원형철주9.5
2893동구동구 도시국 도시안전과01월 08일1986-11-18상해문 주변가로등회색1등용원형원형철주10.0
2894동구동구 도시국 도시안전과01월 07일1986-11-18상해문 주변가로등회색2등용원형원형철주9.5
2895동구동구 도시국 도시안전과01월 05일1986-11-18상해문 주변가로등회색1등용팔각FRP8.5
2896동구동구 도시국 도시안전과01월 04일1986-11-18상해문 주변가로등회색2등용팔각SUS9.5
2897동구동구 도시국 도시안전과01월 03일1986-11-18상해문 주변가로등회색2등용팔각FRP9.5
2898동구동구 도시국 도시안전과01월 02일1986-11-18부산역 건너편 기업은행 앞가로등회색2등용원형원형철주9.5
2899동구동구 도시국 도시안전과01월 01일2012-11-14부산역 건너편 기업은행 앞가로등회색2등용원형원형철주9.5

Duplicate rows

Most frequently occurring

등록구관리기관관리번호설치일자설치장소설치구분색상등주형식등주형상등주재질등주높이# duplicates
0동구동구가로등회색<NA>원형STEEL0.015
2동구동구 안전도시국 건설과<NA><NA><NA>가로등<NA>1등용<NA><NA>0.03
1동구동구 도시국 건설과2019-10-21동구 범일로 41가로등회색1등용원형철주10.02