Overview

Dataset statistics

Number of variables16
Number of observations3880
Missing cells413
Missing cells (%)0.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory507.9 KiB
Average record size in memory134.0 B

Variable types

Text3
Categorical9
Numeric4

Dataset

Description부산광역시_수영구_가로등현황_20221208
Author부산광역시 수영구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=3046172

Alerts

등주종류 has constant value ""Constant
분기번호 has constant value ""Constant
등 수 is highly overall correlated with 등기구회사High correlation
램프용량(W) is highly overall correlated with 등기구종류 and 3 other fieldsHigh correlation
위도 is highly overall correlated with 행정동High correlation
행정동 is highly overall correlated with 위도High correlation
등기구아이디 is highly overall correlated with 등기구종류 and 1 other fieldsHigh correlation
등기구종류 is highly overall correlated with 램프용량(W) and 3 other fieldsHigh correlation
등기구회사 is highly overall correlated with 등 수 and 5 other fieldsHigh correlation
램프종류 is highly overall correlated with 램프용량(W) and 2 other fieldsHigh correlation
등주형태 is highly overall correlated with 램프용량(W)High correlation
점멸기종류 is highly overall correlated with 등기구회사High correlation
등기구아이디 is highly imbalanced (67.8%)Imbalance
등기구회사 is highly imbalanced (57.6%)Imbalance
램프종류 is highly imbalanced (83.5%)Imbalance
점멸기종류 is highly imbalanced (80.9%)Imbalance
노선명 has 362 (9.3%) missing valuesMissing
램프용량(W) has 51 (1.3%) missing valuesMissing

Reproduction

Analysis started2023-12-10 16:35:35.647732
Analysis finished2023-12-10 16:35:39.576080
Duration3.93 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리번호
Text

Distinct3452
Distinct (%)89.0%
Missing0
Missing (%)0.0%
Memory size30.4 KiB
2023-12-11T01:35:39.786600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length9.2110825
Min length5

Characters and Unicode

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

Unique

Unique3029 ?
Unique (%)78.1%

Sample

1st rowKBS조명탑-1
2nd row감포로-1-1
3rd row감포로-1-10
4th row감포로-1-11
5th row감포로-1-12
ValueCountFrequency (%)
셈텀비스타 15
 
0.4%
정과정공원-8 3
 
0.1%
정과정공원-13 3
 
0.1%
정과정공원-9 3
 
0.1%
정과정공원-12 3
 
0.1%
정과정공원-10 3
 
0.1%
좌수영로-1-31 2
 
0.1%
좌수영로-1-28 2
 
0.1%
좌수영로-1-27 2
 
0.1%
좌수영로-1-26 2
 
0.1%
Other values (3443) 3857
99.0%
2023-12-11T01:35:40.309263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 7383
20.7%
1 4161
 
11.6%
로 3323
 
9.3%
2 1773
 
5.0%
수 1511
 
4.2%
영 1328
 
3.7%
3 1182
 
3.3%
4 973
 
2.7%
5 973
 
2.7%
0 880
 
2.5%
Other values (80) 12252
34.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 15680
43.9%
Decimal Number 12652
35.4%
Dash Punctuation 7383
20.7%
Space Separator 15
 
< 0.1%
Connector Punctuation 6
 
< 0.1%
Uppercase Letter 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 3323
21.2%
수 1511
 
9.6%
영 1328
 
8.5%
광 870
 
5.5%
변 818
 
5.2%
안 554
 
3.5%
미 503
 
3.2%
해 497
 
3.2%
망 469
 
3.0%
락 438
 
2.8%
Other values (64) 5369
34.2%
Decimal Number
ValueCountFrequency (%)
1 4161
32.9%
2 1773
14.0%
3 1182
 
9.3%
4 973
 
7.7%
5 973
 
7.7%
0 880
 
7.0%
6 786
 
6.2%
8 680
 
5.4%
7 666
 
5.3%
9 578
 
4.6%
Uppercase Letter
ValueCountFrequency (%)
K 1
33.3%
B 1
33.3%
S 1
33.3%
Dash Punctuation
ValueCountFrequency (%)
- 7383
100.0%
Space Separator
ValueCountFrequency (%)
15
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 20056
56.1%
Hangul 15680
43.9%
Latin 3
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 3323
21.2%
수 1511
 
9.6%
영 1328
 
8.5%
광 870
 
5.5%
변 818
 
5.2%
안 554
 
3.5%
미 503
 
3.2%
해 497
 
3.2%
망 469
 
3.0%
락 438
 
2.8%
Other values (64) 5369
34.2%
Common
ValueCountFrequency (%)
- 7383
36.8%
1 4161
20.7%
2 1773
 
8.8%
3 1182
 
5.9%
4 973
 
4.9%
5 973
 
4.9%
0 880
 
4.4%
6 786
 
3.9%
8 680
 
3.4%
7 666
 
3.3%
Other values (3) 599
 
3.0%
Latin
ValueCountFrequency (%)
K 1
33.3%
B 1
33.3%
S 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 20059
56.1%
Hangul 15680
43.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 7383
36.8%
1 4161
20.7%
2 1773
 
8.8%
3 1182
 
5.9%
4 973
 
4.9%
5 973
 
4.9%
0 880
 
4.4%
6 786
 
3.9%
8 680
 
3.4%
7 666
 
3.3%
Other values (6) 602
 
3.0%
Hangul
ValueCountFrequency (%)
로 3323
21.2%
수 1511
 
9.6%
영 1328
 
8.5%
광 870
 
5.5%
변 818
 
5.2%
안 554
 
3.5%
미 503
 
3.2%
해 497
 
3.2%
망 469
 
3.0%
락 438
 
2.8%
Other values (64) 5369
34.2%

소속분전함
Text

Distinct201
Distinct (%)5.2%
Missing0
Missing (%)0.0%
Memory size30.4 KiB
2023-12-11T01:35:40.677557image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length14
Mean length8.3015464
Min length3

Characters and Unicode

Total characters32210
Distinct characters106
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

Unique5 ?
Unique (%)0.1%

Sample

1st rowKBS조명탑
2nd row감포로-1
3rd row감포로-1
4th row감포로-1
5th row감포로-1
ValueCountFrequency (%)
20 94
 
2.0%
13 94
 
2.0%
좌수영교 85
 
1.8%
15 71
 
1.5%
17 70
 
1.5%
수영강변경관조명 67
 
1.4%
좌수영로-1 62
 
1.3%
좌수영로-2 62
 
1.3%
좌수영로-8 60
 
1.2%
38 59
 
1.2%
Other values (215) 4094
85.0%
2023-12-11T01:35:41.194999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 3503
 
10.9%
로 3323
 
10.3%
1 2758
 
8.6%
1842
 
5.7%
수 1511
 
4.7%
영 1328
 
4.1%
2 1262
 
3.9%
( 1071
 
3.3%
) 1071
 
3.3%
광 889
 
2.8%
Other values (96) 13652
42.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 16409
50.9%
Decimal Number 8208
25.5%
Dash Punctuation 3503
 
10.9%
Space Separator 1842
 
5.7%
Open Punctuation 1071
 
3.3%
Close Punctuation 1071
 
3.3%
Connector Punctuation 101
 
0.3%
Uppercase Letter 5
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 3323
20.3%
수 1511
 
9.2%
영 1328
 
8.1%
광 889
 
5.4%
변 818
 
5.0%
안 554
 
3.4%
미 503
 
3.1%
해 497
 
3.0%
망 469
 
2.9%
락 438
 
2.7%
Other values (76) 6079
37.0%
Decimal Number
ValueCountFrequency (%)
1 2758
33.6%
2 1262
15.4%
3 858
 
10.5%
4 658
 
8.0%
5 658
 
8.0%
6 467
 
5.7%
8 452
 
5.5%
7 410
 
5.0%
0 369
 
4.5%
9 316
 
3.8%
Uppercase Letter
ValueCountFrequency (%)
C 1
20.0%
T 1
20.0%
K 1
20.0%
B 1
20.0%
S 1
20.0%
Dash Punctuation
ValueCountFrequency (%)
- 3503
100.0%
Space Separator
ValueCountFrequency (%)
1842
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1071
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1071
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 101
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 16409
50.9%
Common 15796
49.0%
Latin 5
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 3323
20.3%
수 1511
 
9.2%
영 1328
 
8.1%
광 889
 
5.4%
변 818
 
5.0%
안 554
 
3.4%
미 503
 
3.1%
해 497
 
3.0%
망 469
 
2.9%
락 438
 
2.7%
Other values (76) 6079
37.0%
Common
ValueCountFrequency (%)
- 3503
22.2%
1 2758
17.5%
1842
11.7%
2 1262
 
8.0%
( 1071
 
6.8%
) 1071
 
6.8%
3 858
 
5.4%
4 658
 
4.2%
5 658
 
4.2%
6 467
 
3.0%
Other values (5) 1648
10.4%
Latin
ValueCountFrequency (%)
C 1
20.0%
T 1
20.0%
K 1
20.0%
B 1
20.0%
S 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 16409
50.9%
ASCII 15801
49.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 3503
22.2%
1 2758
17.5%
1842
11.7%
2 1262
 
8.0%
( 1071
 
6.8%
) 1071
 
6.8%
3 858
 
5.4%
4 658
 
4.2%
5 658
 
4.2%
6 467
 
3.0%
Other values (10) 1653
10.5%
Hangul
ValueCountFrequency (%)
로 3323
20.3%
수 1511
 
9.2%
영 1328
 
8.1%
광 889
 
5.4%
변 818
 
5.0%
안 554
 
3.4%
미 503
 
3.1%
해 497
 
3.0%
망 469
 
2.9%
락 438
 
2.7%
Other values (76) 6079
37.0%

행정동
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size30.4 KiB
민락동
903 
망미2동
521 
남천1동
480 
수영동
426 
망미1동
380 
Other values (5)
1170 

Length

Max length4
Median length4
Mean length3.6574742
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row남천1동
2nd row민락동
3rd row민락동
4th row민락동
5th row민락동

Common Values

ValueCountFrequency (%)
민락동 903
23.3%
망미2동 521
13.4%
남천1동 480
12.4%
수영동 426
11.0%
망미1동 380
9.8%
광안2동 314
 
8.1%
광안1동 255
 
6.6%
남천2동 217
 
5.6%
광안4동 195
 
5.0%
광안3동 189
 
4.9%

Length

2023-12-11T01:35:41.391516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:35:41.578406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
민락동 903
23.3%
망미2동 521
13.4%
남천1동 480
12.4%
수영동 426
11.0%
망미1동 380
9.8%
광안2동 314
 
8.1%
광안1동 255
 
6.6%
남천2동 217
 
5.6%
광안4동 195
 
5.0%
광안3동 189
 
4.9%

노선명
Text

MISSING 

Distinct167
Distinct (%)4.7%
Missing362
Missing (%)9.3%
Memory size30.4 KiB
2023-12-11T01:35:41.814134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length8
Mean length5.3544628
Min length3

Characters and Unicode

Total characters18837
Distinct characters65
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

Unique18 ?
Unique (%)0.5%

Sample

1st row수영로
2nd row감포로
3rd row감포로
4th row감포로
5th row감포로
ValueCountFrequency (%)
광안해변로 380
 
10.6%
좌수영로 337
 
9.4%
수영로 277
 
7.7%
광남로 231
 
6.4%
민락수변로 230
 
6.4%
연수로 122
 
3.4%
망미번영로 112
 
3.1%
황령산로 89
 
2.5%
센텀북대로 69
 
1.9%
남천동로 69
 
1.9%
Other values (157) 1669
46.6%
2023-12-11T01:35:42.215206image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
로 3496
18.6%
수 1374
 
7.3%
번 1355
 
7.2%
길 1199
 
6.4%
영 1102
 
5.9%
광 900
 
4.8%
변 742
 
3.9%
안 560
 
3.0%
해 480
 
2.5%
남 420
 
2.2%
Other values (55) 7209
38.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 16109
85.5%
Decimal Number 2654
 
14.1%
Space Separator 67
 
0.4%
Dash Punctuation 7
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 3496
21.7%
수 1374
 
8.5%
번 1355
 
8.4%
길 1199
 
7.4%
영 1102
 
6.8%
광 900
 
5.6%
변 742
 
4.6%
안 560
 
3.5%
해 480
 
3.0%
남 420
 
2.6%
Other values (43) 4481
27.8%
Decimal Number
ValueCountFrequency (%)
5 363
13.7%
4 348
13.1%
1 344
13.0%
2 282
10.6%
3 260
9.8%
8 249
9.4%
6 238
9.0%
0 209
7.9%
7 209
7.9%
9 152
5.7%
Space Separator
ValueCountFrequency (%)
67
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 16109
85.5%
Common 2728
 
14.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 3496
21.7%
수 1374
 
8.5%
번 1355
 
8.4%
길 1199
 
7.4%
영 1102
 
6.8%
광 900
 
5.6%
변 742
 
4.6%
안 560
 
3.5%
해 480
 
3.0%
남 420
 
2.6%
Other values (43) 4481
27.8%
Common
ValueCountFrequency (%)
5 363
13.3%
4 348
12.8%
1 344
12.6%
2 282
10.3%
3 260
9.5%
8 249
9.1%
6 238
8.7%
0 209
7.7%
7 209
7.7%
9 152
5.6%
Other values (2) 74
 
2.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 16109
85.5%
ASCII 2728
 
14.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
로 3496
21.7%
수 1374
 
8.5%
번 1355
 
8.4%
길 1199
 
7.4%
영 1102
 
6.8%
광 900
 
5.6%
변 742
 
4.6%
안 560
 
3.5%
해 480
 
3.0%
남 420
 
2.6%
Other values (43) 4481
27.8%
ASCII
ValueCountFrequency (%)
5 363
13.3%
4 348
12.8%
1 344
12.6%
2 282
10.3%
3 260
9.5%
8 249
9.1%
6 238
8.7%
0 209
7.7%
7 209
7.7%
9 152
5.6%
Other values (2) 74
 
2.7%

등기구아이디
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size30.4 KiB
1
3452 
2
423 
3
 
5

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 3452
89.0%
2 423
 
10.9%
3 5
 
0.1%

Length

2023-12-11T01:35:42.358554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:35:42.522606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 3452
89.0%
2 423
 
10.9%
3 5
 
0.1%

등기구종류
Categorical

HIGH CORRELATION 

Distinct50
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size30.4 KiB
컷오프
730 
세종로대형
603 
기타
474 
27번
309 
<NA>
214 
Other values (45)
1550 

Length

Max length6
Median length3
Mean length3.1546392
Min length2

Unique

Unique4 ?
Unique (%)0.1%

Sample

1st row머스코
2nd row컷오프
3rd row세종로대형
4th row컷오프
5th row컷오프

Common Values

ValueCountFrequency (%)
컷오프 730
18.8%
세종로대형 603
15.5%
기타 474
12.2%
27번 309
 
8.0%
<NA> 214
 
5.5%
21번 138
 
3.6%
11번 132
 
3.4%
4번 117
 
3.0%
1번 111
 
2.9%
가오스 107
 
2.8%
Other values (40) 945
24.4%

Length

2023-12-11T01:35:42.704607image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
컷오프 730
18.8%
세종로대형 603
15.5%
기타 474
12.2%
27번 309
 
8.0%
na 214
 
5.5%
21번 138
 
3.6%
11번 132
 
3.4%
4번 117
 
3.0%
1번 111
 
2.9%
가오스 107
 
2.8%
Other values (40) 945
24.4%

등기구회사
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct13
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size30.4 KiB
<NA>
2785 
-
361 
한라IMS
315 
MK
 
106
올스타
 
97
Other values (8)
 
216

Length

Max length5
Median length4
Mean length3.6268041
Min length1

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 2785
71.8%
- 361
 
9.3%
한라IMS 315
 
8.1%
MK 106
 
2.7%
올스타 97
 
2.5%
한라 96
 
2.5%
금경 77
 
2.0%
다노테크 22
 
0.6%
유양 10
 
0.3%
금경라이팅 4
 
0.1%
Other values (3) 7
 
0.2%

Length

2023-12-11T01:35:42.841244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 2785
71.8%
361
 
9.3%
한라ims 315
 
8.1%
mk 108
 
2.8%
올스타 97
 
2.5%
한라 96
 
2.5%
금경 77
 
2.0%
다노테크 22
 
0.6%
유양 10
 
0.3%
금경라이팅 4
 
0.1%
Other values (2) 5
 
0.1%

등 수
Real number (ℝ)

HIGH CORRELATION 

Distinct7
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.0332474
Minimum1
Maximum13
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size34.2 KiB
2023-12-11T01:35:42.951653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q31
95-th percentile1
Maximum13
Range12
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.36071278
Coefficient of variation (CV)0.34910591
Kurtosis486.48406
Mean1.0332474
Median Absolute Deviation (MAD)0
Skewness19.62233
Sum4009
Variance0.13011371
MonotonicityNot monotonic
2023-12-11T01:35:43.060851image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
1 3807
98.1%
2 57
 
1.5%
3 7
 
0.2%
8 4
 
0.1%
5 3
 
0.1%
13 1
 
< 0.1%
7 1
 
< 0.1%
ValueCountFrequency (%)
1 3807
98.1%
2 57
 
1.5%
3 7
 
0.2%
5 3
 
0.1%
7 1
 
< 0.1%
8 4
 
0.1%
13 1
 
< 0.1%
ValueCountFrequency (%)
13 1
 
< 0.1%
8 4
 
0.1%
7 1
 
< 0.1%
5 3
 
0.1%
3 7
 
0.2%
2 57
 
1.5%
1 3807
98.1%

램프종류
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct4
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size30.4 KiB
LED
3668 
CDM
 
197
NH
 
11
MH
 
4

Length

Max length3
Median length3
Mean length2.996134
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowMH
2nd rowLED
3rd rowLED
4th rowLED
5th rowLED

Common Values

ValueCountFrequency (%)
LED 3668
94.5%
CDM 197
 
5.1%
NH 11
 
0.3%
MH 4
 
0.1%

Length

2023-12-11T01:35:43.197828image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:35:43.307394image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
led 3668
94.5%
cdm 197
 
5.1%
nh 11
 
0.3%
mh 4
 
0.1%

램프용량(W)
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct22
Distinct (%)0.6%
Missing51
Missing (%)1.3%
Infinite0
Infinite (%)0.0%
Mean118.92426
Minimum6
Maximum1000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size34.2 KiB
2023-12-11T01:35:43.415886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum6
5-th percentile50
Q1100
median125
Q3150
95-th percentile200
Maximum1000
Range994
Interquartile range (IQR)50

Descriptive statistics

Standard deviation55.43541
Coefficient of variation (CV)0.46614046
Kurtosis74.207765
Mean118.92426
Median Absolute Deviation (MAD)25
Skewness5.180656
Sum455361
Variance3073.0846
MonotonicityNot monotonic
2023-12-11T01:35:43.538260image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%)
150 1111
28.6%
100 646
16.6%
50 536
13.8%
135 383
 
9.9%
120 350
 
9.0%
200 199
 
5.1%
125 176
 
4.5%
60 150
 
3.9%
110 66
 
1.7%
35 54
 
1.4%
Other values (12) 158
 
4.1%
(Missing) 51
 
1.3%
ValueCountFrequency (%)
6 8
 
0.2%
12 4
 
0.1%
30 15
 
0.4%
35 54
 
1.4%
45 26
 
0.7%
50 536
13.8%
60 150
 
3.9%
70 17
 
0.4%
80 17
 
0.4%
100 646
16.6%
ValueCountFrequency (%)
1000 4
 
0.1%
600 6
 
0.2%
400 3
 
0.1%
250 21
 
0.5%
200 199
 
5.1%
160 8
 
0.2%
150 1111
28.6%
140 29
 
0.7%
135 383
 
9.9%
125 176
 
4.5%

등주종류
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size30.4 KiB
기타
3880 

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 (%)
기타 3880
100.0%

Length

2023-12-11T01:35:43.654121image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:35:43.760595image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기타 3880
100.0%

등주형태
Categorical

HIGH CORRELATION 

Distinct18
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size30.4 KiB
스텐주
1764 
한전취부등
780 
철팔각
564 
원형철주
333 
교각하부취부등
 
124
Other values (13)
315 

Length

Max length7
Median length3
Mean length3.6365979
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row조명탑
2nd row철팔각
3rd row한전취부등
4th row철팔각
5th row철팔각

Common Values

ValueCountFrequency (%)
스텐주 1764
45.5%
한전취부등 780
20.1%
철팔각 564
 
14.5%
원형철주 333
 
8.6%
교각하부취부등 124
 
3.2%
열주등 101
 
2.6%
원형스텐주 41
 
1.1%
기타 35
 
0.9%
경관조명 25
 
0.6%
취부등 24
 
0.6%
Other values (8) 89
 
2.3%

Length

2023-12-11T01:35:43.876558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
스텐주 1764
45.5%
한전취부등 780
20.1%
철팔각 564
 
14.5%
원형철주 333
 
8.6%
교각하부취부등 124
 
3.2%
열주등 101
 
2.6%
원형스텐주 41
 
1.1%
기타 35
 
0.9%
경관조명 25
 
0.6%
취부등 24
 
0.6%
Other values (8) 89
 
2.3%

점멸기종류
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size30.4 KiB
기타
3704 
<NA>
 
134
양방향식
 
42

Length

Max length4
Median length2
Mean length2.0907216
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row기타
2nd row기타
3rd row기타
4th row기타
5th row기타

Common Values

ValueCountFrequency (%)
기타 3704
95.5%
<NA> 134
 
3.5%
양방향식 42
 
1.1%

Length

2023-12-11T01:35:44.007240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:35:44.125032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기타 3704
95.5%
na 134
 
3.5%
양방향식 42
 
1.1%

분기번호
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size30.4 KiB
0
3880 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 3880
100.0%

Length

2023-12-11T01:35:44.271369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:35:44.398799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 3880
100.0%

위도
Real number (ℝ)

HIGH CORRELATION 

Distinct3450
Distinct (%)88.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35.161446
Minimum35.135538
Maximum35.185571
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size34.2 KiB
2023-12-11T01:35:44.558048image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum35.135538
5-th percentile35.140454
Q135.154437
median35.160948
Q335.171159
95-th percentile35.178809
Maximum35.185571
Range0.05003216
Interquartile range (IQR)0.016721717

Descriptive statistics

Standard deviation0.011561228
Coefficient of variation (CV)0.00032880411
Kurtosis-0.77503299
Mean35.161446
Median Absolute Deviation (MAD)0.00876503
Skewness-0.23081678
Sum136426.41
Variance0.00013366199
MonotonicityNot monotonic
2023-12-11T01:35:45.111115image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
35.15670627 4
 
0.1%
35.18171978 3
 
0.1%
35.18181288 3
 
0.1%
35.1817619 3
 
0.1%
35.1816952 3
 
0.1%
35.18163469 3
 
0.1%
35.171026 2
 
0.1%
35.1665172 2
 
0.1%
35.17164753 2
 
0.1%
35.17143364 2
 
0.1%
Other values (3440) 3853
99.3%
ValueCountFrequency (%)
35.13553836 1
< 0.1%
35.13567721 1
< 0.1%
35.13571714 1
< 0.1%
35.13572774 1
< 0.1%
35.13576584 1
< 0.1%
35.13580173 1
< 0.1%
35.13582021 1
< 0.1%
35.13584874 1
< 0.1%
35.1358797 1
< 0.1%
35.13591766 1
< 0.1%
ValueCountFrequency (%)
35.18557052 1
< 0.1%
35.18526946 1
< 0.1%
35.18510041 1
< 0.1%
35.18491886 1
< 0.1%
35.18474655 1
< 0.1%
35.18457223 1
< 0.1%
35.18439109 2
0.1%
35.1842675 2
0.1%
35.18420654 1
< 0.1%
35.1840204 1
< 0.1%

경도
Real number (ℝ)

Distinct3432
Distinct (%)88.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean129.11611
Minimum129.09597
Maximum129.13506
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size34.2 KiB
2023-12-11T01:35:45.281606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum129.09597
5-th percentile129.10244
Q1129.11029
median129.11511
Q3129.12165
95-th percentile129.13163
Maximum129.13506
Range0.0390886
Interquartile range (IQR)0.011361775

Descriptive statistics

Standard deviation0.0085017828
Coefficient of variation (CV)6.5846024 × 10-5
Kurtosis-0.45935115
Mean129.11611
Median Absolute Deviation (MAD)0.00554265
Skewness0.21708004
Sum500970.52
Variance7.228031 × 10-5
MonotonicityNot monotonic
2023-12-11T01:35:45.523583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
129.1151488 4
 
0.1%
129.102169 3
 
0.1%
129.1151785 3
 
0.1%
129.1149089 3
 
0.1%
129.115008 3
 
0.1%
129.1149601 3
 
0.1%
129.1200825 3
 
0.1%
129.1207219 3
 
0.1%
129.1171624 3
 
0.1%
129.121941 2
 
0.1%
Other values (3422) 3850
99.2%
ValueCountFrequency (%)
129.0959748 1
< 0.1%
129.0963799 1
< 0.1%
129.0965168 1
< 0.1%
129.0965262 1
< 0.1%
129.0966131 1
< 0.1%
129.0966669 1
< 0.1%
129.0967059 1
< 0.1%
129.0967574 1
< 0.1%
129.0967848 1
< 0.1%
129.0968027 1
< 0.1%
ValueCountFrequency (%)
129.1350634 2
0.1%
129.135037 1
< 0.1%
129.1350362 2
0.1%
129.1350016 1
< 0.1%
129.1349764 1
< 0.1%
129.1349699 2
0.1%
129.1349599 2
0.1%
129.1348929 1
< 0.1%
129.1348752 2
0.1%
129.134784 1
< 0.1%

Interactions

2023-12-11T01:35:38.328835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:35:37.040186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:35:37.437151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:35:37.866363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:35:38.484431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:35:37.121254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:35:37.528311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:35:37.973676image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:35:38.613355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:35:37.199334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:35:37.619110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:35:38.107018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:35:38.745671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:35:37.280505image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:35:37.735256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:35:38.219420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T01:35:45.664925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동등기구아이디등기구종류등기구회사등 수램프종류램프용량(W)등주형태점멸기종류위도경도
행정동1.0000.2410.8070.7650.0420.2030.1740.5670.2800.9270.873
등기구아이디0.2411.0000.9160.8910.0000.0000.4670.3110.0180.2820.185
등기구종류0.8070.9161.0000.9420.6660.8730.9310.9090.0000.7710.729
등기구회사0.7650.8910.9421.0000.9320.9870.9280.8100.7250.5840.629
등 수0.0420.0000.6660.9321.0000.2000.5500.7220.0000.1150.181
램프종류0.2030.0000.8730.9870.2001.0000.8560.6670.0000.1670.183
램프용량(W)0.1740.4670.9310.9280.5500.8561.0000.8980.0690.1830.165
등주형태0.5670.3110.9090.8100.7220.6670.8981.0000.5220.5320.562
점멸기종류0.2800.0180.0000.7250.0000.0000.0690.5221.0000.2200.156
위도0.9270.2820.7710.5840.1150.1670.1830.5320.2201.0000.696
경도0.8730.1850.7290.6290.1810.1830.1650.5620.1560.6961.000
2023-12-11T01:35:45.850528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
등기구종류행정동등기구회사점멸기종류등기구아이디등주형태램프종류
등기구종류1.0000.4260.6860.0000.7500.4950.642
행정동0.4261.0000.4540.2140.1480.2560.122
등기구회사0.6860.4541.0000.5730.6360.4950.896
점멸기종류0.0000.2140.5731.0000.0300.4130.000
등기구아이디0.7500.1480.6360.0301.0000.1500.000
등주형태0.4950.2560.4950.4130.1501.0000.431
램프종류0.6420.1220.8960.0000.0000.4311.000
2023-12-11T01:35:45.985911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
등 수램프용량(W)위도경도행정동등기구아이디등기구종류등기구회사램프종류등주형태점멸기종류
등 수1.0000.0310.0290.0390.0200.0000.3500.7840.1680.4220.000
램프용량(W)0.0311.000-0.145-0.0120.0920.2180.7150.6680.7210.5960.050
위도0.029-0.1451.000-0.0570.5570.1760.3840.2910.1010.2350.169
경도0.039-0.012-0.0571.0000.4530.1120.3430.3240.1100.2540.120
행정동0.0200.0920.5570.4531.0000.1480.4260.4540.1220.2560.214
등기구아이디0.0000.2180.1760.1120.1481.0000.7500.6360.0000.1500.030
등기구종류0.3500.7150.3840.3430.4260.7501.0000.6860.6420.4950.000
등기구회사0.7840.6680.2910.3240.4540.6360.6861.0000.8960.4950.573
램프종류0.1680.7210.1010.1100.1220.0000.6420.8961.0000.4310.000
등주형태0.4220.5960.2350.2540.2560.1500.4950.4950.4311.0000.413
점멸기종류0.0000.0500.1690.1200.2140.0300.0000.5730.0000.4131.000

Missing values

2023-12-11T01:35:38.959361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T01:35:39.226022image/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-11T01:35:39.422901image/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

관리번호소속분전함행정동노선명등기구아이디등기구종류등기구회사등 수램프종류램프용량(W)등주종류등주형태점멸기종류분기번호위도경도
0KBS조명탑-1KBS조명탑남천1동수영로1머스코<NA>5MH1000기타조명탑기타035.143849129.109464
1감포로-1-1감포로-1민락동감포로1컷오프<NA>1LED150기타철팔각기타035.167637129.117875
2감포로-1-10감포로-1민락동감포로1세종로대형한라1LED100기타한전취부등기타035.163838129.119239
3감포로-1-11감포로-1민락동감포로1컷오프<NA>1LED150기타철팔각기타035.163622129.119302
4감포로-1-12감포로-1민락동감포로1컷오프<NA>1LED150기타철팔각기타035.163146129.119465
5감포로-1-13감포로-1민락동감포로1컷오프<NA>1LED150기타철팔각기타035.162739129.119606
6감포로-1-14감포로-1민락동감포로1컷오프<NA>1LED150기타철팔각기타035.162312129.119748
7감포로-1-15감포로-1민락동감포로1컷오프<NA>1LED150기타철팔각기타035.162086129.119825
8감포로-1-16감포로-1민락동감포로1컷오프<NA>1LED150기타철팔각기타035.161299129.120128
9감포로-1-17감포로-1민락동감포로1컷오프<NA>1LED150기타철팔각기타035.160966129.120237
관리번호소속분전함행정동노선명등기구아이디등기구종류등기구회사등 수램프종류램프용량(W)등주종류등주형태점멸기종류분기번호위도경도
3870황령산로8-1-18황령산로8-1_점검남천1동황령산로8번길13번<NA>1LED100기타한전취부등기타035.147792129.109456
3871황령산로8-1-2황령산로8-1_점검남천1동황령산로7번길13번<NA>1LED100기타한전취부등기타035.14618129.10912
3872황령산로8-1-3황령산로8-1_점검남천1동황령산로7번길13번<NA>1LED120기타한전취부등기타035.146413129.109064
3873황령산로8-1-3황령산로8-1_점검남천1동황령산로7번길23번-1LED120기타한전취부등기타035.146413129.109064
3874황령산로8-1-4황령산로8-1_점검남천1동황령산로7번길13번<NA>1LED100기타한전취부등기타035.146788129.109169
3875황령산로8-1-5황령산로8-1_점검남천1동황령산로7번길13번<NA>1LED100기타한전취부등기타035.147205129.10929
3876황령산로8-1-6황령산로8-1_점검남천1동황령산로8번길13번<NA>1LED100기타한전취부등기타035.147472129.109354
3877황령산로8-1-7황령산로8-1_점검남천1동황령산로8번길13번<NA>1LED100기타한전취부등기타035.148106129.109516
3878황령산로8-1-8황령산로8-1_점검남천1동황령산로8번길13번<NA>1LED100기타한전취부등기타035.148319129.10959
3879황령산로8-1-9황령산로8-1_점검남천1동황령산로8번길13번<NA>1LED100기타한전취부등기타035.148541129.109645