Overview

Dataset statistics

Number of variables15
Number of observations3994
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory491.6 KiB
Average record size in memory126.0 B

Variable types

Text3
Categorical8
Numeric4

Dataset

Description부산광역시 수영구 가로등 현황 데이터로 등기구종류, 램프종류, 램프용량, 등주형태, 위치정보 등을 제공하고 있다.
Author부산광역시 수영구
URLhttps://www.data.go.kr/data/3046172/fileData.do

Alerts

등주종류 has constant value ""Constant
분기번호 has constant value ""Constant
램프용량(W) is highly overall correlated with 등기구종류 and 1 other fieldsHigh correlation
위도 is highly overall correlated with 행정동High correlation
행정동 is highly overall correlated with 위도High correlation
등기구ID is highly overall correlated with 등기구종류High correlation
등기구종류 is highly overall correlated with 램프용량(W) and 2 other fieldsHigh correlation
램프종류 is highly overall correlated with 램프용량(W) and 1 other fieldsHigh correlation
등주형태 is highly overall correlated with 점멸기종류High correlation
점멸기종류 is highly overall correlated with 등주형태High correlation
등기구ID is highly imbalanced (66.3%)Imbalance
램프종류 is highly imbalanced (97.0%)Imbalance
점멸기종류 is highly imbalanced (76.8%)Imbalance

Reproduction

Analysis started2024-03-14 13:25:52.314034
Analysis finished2024-03-14 13:25:58.712316
Duration6.4 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리번호
Text

Distinct3523
Distinct (%)88.2%
Missing0
Missing (%)0.0%
Memory size31.3 KiB
2024-03-14T22:25:59.454636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length9.39334
Min length5

Characters and Unicode

Total characters37517
Distinct characters91
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

Unique3057 ?
Unique (%)76.5%

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%
정과정공원-12 3
 
0.1%
정과정공원-9 3
 
0.1%
정과정공원-10 3
 
0.1%
정과정공원-13 3
 
0.1%
광안해변로-14-9 2
 
< 0.1%
광안해변로-14-4 2
 
< 0.1%
광안해변로-14-5 2
 
< 0.1%
좌수영로-2-24 2
 
< 0.1%
Other values (3514) 3971
99.1%
2024-03-14T22:26:00.634589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 7599
20.3%
1 4223
 
11.3%
로 3425
 
9.1%
2 1877
 
5.0%
수 1583
 
4.2%
0 1537
 
4.1%
영 1387
 
3.7%
3 1276
 
3.4%
5 998
 
2.7%
4 987
 
2.6%
Other values (81) 12625
33.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 16100
42.9%
Decimal Number 13794
36.8%
Dash Punctuation 7599
20.3%
Space Separator 15
 
< 0.1%
Connector Punctuation 6
 
< 0.1%
Uppercase Letter 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 3425
21.3%
수 1583
 
9.8%
영 1387
 
8.6%
광 876
 
5.4%
변 828
 
5.1%
안 556
 
3.5%
미 503
 
3.1%
해 498
 
3.1%
망 469
 
2.9%
락 449
 
2.8%
Other values (65) 5526
34.3%
Decimal Number
ValueCountFrequency (%)
1 4223
30.6%
2 1877
13.6%
0 1537
 
11.1%
3 1276
 
9.3%
5 998
 
7.2%
4 987
 
7.2%
6 801
 
5.8%
8 761
 
5.5%
7 678
 
4.9%
9 656
 
4.8%
Uppercase Letter
ValueCountFrequency (%)
K 1
33.3%
B 1
33.3%
S 1
33.3%
Dash Punctuation
ValueCountFrequency (%)
- 7599
100.0%
Space Separator
ValueCountFrequency (%)
15
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 21414
57.1%
Hangul 16100
42.9%
Latin 3
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 3425
21.3%
수 1583
 
9.8%
영 1387
 
8.6%
광 876
 
5.4%
변 828
 
5.1%
안 556
 
3.5%
미 503
 
3.1%
해 498
 
3.1%
망 469
 
2.9%
락 449
 
2.8%
Other values (65) 5526
34.3%
Common
ValueCountFrequency (%)
- 7599
35.5%
1 4223
19.7%
2 1877
 
8.8%
0 1537
 
7.2%
3 1276
 
6.0%
5 998
 
4.7%
4 987
 
4.6%
6 801
 
3.7%
8 761
 
3.6%
7 678
 
3.2%
Other values (3) 677
 
3.2%
Latin
ValueCountFrequency (%)
K 1
33.3%
B 1
33.3%
S 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 21417
57.1%
Hangul 16100
42.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 7599
35.5%
1 4223
19.7%
2 1877
 
8.8%
0 1537
 
7.2%
3 1276
 
6.0%
5 998
 
4.7%
4 987
 
4.6%
6 801
 
3.7%
8 761
 
3.6%
7 678
 
3.2%
Other values (6) 680
 
3.2%
Hangul
ValueCountFrequency (%)
로 3425
21.3%
수 1583
 
9.8%
영 1387
 
8.6%
광 876
 
5.4%
변 828
 
5.1%
안 556
 
3.5%
미 503
 
3.1%
해 498
 
3.1%
망 469
 
2.9%
락 449
 
2.8%
Other values (65) 5526
34.3%

소속분전함
Text

Distinct204
Distinct (%)5.1%
Missing0
Missing (%)0.0%
Memory size31.3 KiB
2024-03-14T22:26:01.592544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length18
Mean length12.161492
Min length8

Characters and Unicode

Total characters48573
Distinct characters99
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조명탑 (1)
2nd row감포로-1 (29)
3rd row감포로-1 (29)
4th row감포로-1 (29)
5th row감포로-1 (29)
ValueCountFrequency (%)
13 285
 
3.6%
23 242
 
3.0%
17 229
 
2.9%
18 226
 
2.8%
22 221
 
2.8%
15 208
 
2.6%
21 191
 
2.4%
11 186
 
2.3%
20 184
 
2.3%
19 181
 
2.3%
Other values (237) 5856
73.1%
2024-03-14T22:26:02.872323image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4762
 
9.8%
1 4551
 
9.4%
( 4059
 
8.4%
) 4059
 
8.4%
- 3618
 
7.4%
로 3425
 
7.1%
2 2581
 
5.3%
3 1870
 
3.8%
수 1583
 
3.3%
영 1387
 
2.9%
Other values (89) 16678
34.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 17434
35.9%
Decimal Number 14453
29.8%
Space Separator 4762
 
9.8%
Open Punctuation 4059
 
8.4%
Close Punctuation 4059
 
8.4%
Dash Punctuation 3618
 
7.4%
Connector Punctuation 185
 
0.4%
Uppercase Letter 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 3425
19.6%
수 1583
 
9.1%
영 1387
 
8.0%
광 876
 
5.0%
변 828
 
4.7%
안 556
 
3.2%
미 503
 
2.9%
해 498
 
2.9%
망 469
 
2.7%
락 449
 
2.6%
Other values (71) 6860
39.3%
Decimal Number
ValueCountFrequency (%)
1 4551
31.5%
2 2581
17.9%
3 1870
12.9%
5 1113
 
7.7%
8 859
 
5.9%
4 817
 
5.7%
6 792
 
5.5%
7 689
 
4.8%
9 652
 
4.5%
0 529
 
3.7%
Uppercase Letter
ValueCountFrequency (%)
K 1
33.3%
B 1
33.3%
S 1
33.3%
Space Separator
ValueCountFrequency (%)
4762
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4059
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4059
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3618
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 185
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 31136
64.1%
Hangul 17434
35.9%
Latin 3
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 3425
19.6%
수 1583
 
9.1%
영 1387
 
8.0%
광 876
 
5.0%
변 828
 
4.7%
안 556
 
3.2%
미 503
 
2.9%
해 498
 
2.9%
망 469
 
2.7%
락 449
 
2.6%
Other values (71) 6860
39.3%
Common
ValueCountFrequency (%)
4762
15.3%
1 4551
14.6%
( 4059
13.0%
) 4059
13.0%
- 3618
11.6%
2 2581
8.3%
3 1870
 
6.0%
5 1113
 
3.6%
8 859
 
2.8%
4 817
 
2.6%
Other values (5) 2847
9.1%
Latin
ValueCountFrequency (%)
K 1
33.3%
B 1
33.3%
S 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 31139
64.1%
Hangul 17434
35.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4762
15.3%
1 4551
14.6%
( 4059
13.0%
) 4059
13.0%
- 3618
11.6%
2 2581
8.3%
3 1870
 
6.0%
5 1113
 
3.6%
8 859
 
2.8%
4 817
 
2.6%
Other values (8) 2850
9.2%
Hangul
ValueCountFrequency (%)
로 3425
19.6%
수 1583
 
9.1%
영 1387
 
8.0%
광 876
 
5.0%
변 828
 
4.7%
안 556
 
3.2%
미 503
 
2.9%
해 498
 
2.9%
망 469
 
2.7%
락 449
 
2.6%
Other values (71) 6860
39.3%

행정동
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size31.3 KiB
민락동
915 
남천1동
549 
망미2동
521 
수영동
426 
망미1동
382 
Other values (5)
1201 

Length

Max length4
Median length4
Mean length3.6642464
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
민락동 915
22.9%
남천1동 549
13.7%
망미2동 521
13.0%
수영동 426
10.7%
망미1동 382
9.6%
광안2동 314
 
7.9%
광안1동 268
 
6.7%
남천2동 240
 
6.0%
광안4동 190
 
4.8%
광안3동 189
 
4.7%

Length

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

Common Values (Plot)

2024-03-14T22:26:03.395547image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
민락동 915
22.9%
남천1동 549
13.7%
망미2동 521
13.0%
수영동 426
10.7%
망미1동 382
9.6%
광안2동 314
 
7.9%
광안1동 268
 
6.7%
남천2동 240
 
6.0%
광안4동 190
 
4.8%
광안3동 189
 
4.7%

노선명
Text

Distinct168
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size31.3 KiB
2024-03-14T22:26:04.359756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length8
Mean length5.4228843
Min length3

Characters and Unicode

Total characters21659
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

Unique17 ?
Unique (%)0.4%

Sample

1st row수영로
2nd row감포로
3rd row감포로
4th row감포로
5th row감포로
ValueCountFrequency (%)
광안해변로 399
 
9.8%
좌수영로 382
 
9.4%
수영로 362
 
8.9%
민락수변로 239
 
5.9%
광남로 236
 
5.8%
연수로 122
 
3.0%
망미번영로 112
 
2.8%
남천동로 106
 
2.6%
황령산로 89
 
2.2%
센텀북대로 69
 
1.7%
Other values (158) 1943
47.9%
2024-03-14T22:26:05.574528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
로 3971
18.3%
수 1652
 
7.6%
번 1579
 
7.3%
길 1410
 
6.5%
영 1337
 
6.2%
광 950
 
4.4%
변 819
 
3.8%
안 597
 
2.8%
해 505
 
2.3%
남 489
 
2.3%
Other values (55) 8350
38.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 18400
85.0%
Decimal Number 3142
 
14.5%
Space Separator 65
 
0.3%
Dash Punctuation 52
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 3971
21.6%
수 1652
 
9.0%
번 1579
 
8.6%
길 1410
 
7.7%
영 1337
 
7.3%
광 950
 
5.2%
변 819
 
4.5%
안 597
 
3.2%
해 505
 
2.7%
남 489
 
2.7%
Other values (43) 5091
27.7%
Decimal Number
ValueCountFrequency (%)
5 476
15.1%
1 440
14.0%
4 368
11.7%
8 314
10.0%
3 311
9.9%
2 304
9.7%
6 293
9.3%
7 253
8.1%
0 219
7.0%
9 164
 
5.2%
Space Separator
ValueCountFrequency (%)
65
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 52
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 18400
85.0%
Common 3259
 
15.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 3971
21.6%
수 1652
 
9.0%
번 1579
 
8.6%
길 1410
 
7.7%
영 1337
 
7.3%
광 950
 
5.2%
변 819
 
4.5%
안 597
 
3.2%
해 505
 
2.7%
남 489
 
2.7%
Other values (43) 5091
27.7%
Common
ValueCountFrequency (%)
5 476
14.6%
1 440
13.5%
4 368
11.3%
8 314
9.6%
3 311
9.5%
2 304
9.3%
6 293
9.0%
7 253
7.8%
0 219
6.7%
9 164
 
5.0%
Other values (2) 117
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 18400
85.0%
ASCII 3259
 
15.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
로 3971
21.6%
수 1652
 
9.0%
번 1579
 
8.6%
길 1410
 
7.7%
영 1337
 
7.3%
광 950
 
5.2%
변 819
 
4.5%
안 597
 
3.2%
해 505
 
2.7%
남 489
 
2.7%
Other values (43) 5091
27.7%
ASCII
ValueCountFrequency (%)
5 476
14.6%
1 440
13.5%
4 368
11.3%
8 314
9.6%
3 311
9.5%
2 304
9.3%
6 293
9.0%
7 253
7.8%
0 219
6.7%
9 164
 
5.0%
Other values (2) 117
 
3.6%

등기구ID
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size31.3 KiB
1
3523 
2
466 
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 3523
88.2%
2 466
 
11.7%
3 5
 
0.1%

Length

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

Common Values (Plot)

2024-03-14T22:26:05.970169image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 3523
88.2%
2 466
 
11.7%
3 5
 
0.1%

등기구종류
Categorical

HIGH CORRELATION 

Distinct48
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size31.3 KiB
컷오프
917 
세종로대형
620 
기타
491 
27번
327 
4번
169 
Other values (43)
1470 

Length

Max length6
Median length3
Mean length3.0881322
Min length2

Unique

Unique3 ?
Unique (%)0.1%

Sample

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

Common Values

ValueCountFrequency (%)
컷오프 917
23.0%
세종로대형 620
15.5%
기타 491
12.3%
27번 327
 
8.2%
4번 169
 
4.2%
21번 137
 
3.4%
11번 132
 
3.3%
13번 119
 
3.0%
1번 112
 
2.8%
가오스 109
 
2.7%
Other values (38) 861
21.6%

Length

2024-03-14T22:26:06.179471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
컷오프 917
23.0%
세종로대형 620
15.5%
기타 491
12.3%
27번 327
 
8.2%
4번 169
 
4.2%
21번 137
 
3.4%
11번 132
 
3.3%
13번 119
 
3.0%
1번 112
 
2.8%
가오스 109
 
2.7%
Other values (38) 861
21.6%

등 수
Real number (ℝ)

Distinct7
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.0322984
Minimum1
Maximum13
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size35.2 KiB
2024-03-14T22:26:06.370434image/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.35556944
Coefficient of variation (CV)0.34444442
Kurtosis500.81578
Mean1.0322984
Median Absolute Deviation (MAD)0
Skewness19.909036
Sum4123
Variance0.12642963
MonotonicityNot monotonic
2024-03-14T22:26:06.627822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
1 3921
98.2%
2 57
 
1.4%
3 7
 
0.2%
8 4
 
0.1%
5 3
 
0.1%
13 1
 
< 0.1%
7 1
 
< 0.1%
ValueCountFrequency (%)
1 3921
98.2%
2 57
 
1.4%
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.4%
1 3921
98.2%

램프종류
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size31.3 KiB
LED
3975 
CDM
 
15
MH
 
4

Length

Max length3
Median length3
Mean length2.9989985
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
LED 3975
99.5%
CDM 15
 
0.4%
MH 4
 
0.1%

Length

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

Common Values (Plot)

2024-03-14T22:26:07.127143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
led 3975
99.5%
cdm 15
 
0.4%
mh 4
 
0.1%

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

HIGH CORRELATION 

Distinct22
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean115.19104
Minimum6
Maximum1000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size35.2 KiB
2024-03-14T22:26:07.457522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation53.95815
Coefficient of variation (CV)0.46842316
Kurtosis80.81818
Mean115.19104
Median Absolute Deviation (MAD)30
Skewness5.4710831
Sum460073
Variance2911.4819
MonotonicityNot monotonic
2024-03-14T22:26:07.860909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%)
150 1008
25.2%
100 823
20.6%
50 608
15.2%
135 379
 
9.5%
120 359
 
9.0%
125 218
 
5.5%
200 185
 
4.6%
60 148
 
3.7%
110 66
 
1.7%
35 54
 
1.4%
Other values (12) 146
 
3.7%
ValueCountFrequency (%)
6 8
 
0.2%
12 5
 
0.1%
30 15
 
0.4%
35 54
 
1.4%
45 26
 
0.7%
50 608
15.2%
60 148
 
3.7%
70 17
 
0.4%
80 21
 
0.5%
100 823
20.6%
ValueCountFrequency (%)
1000 4
 
0.1%
600 6
 
0.2%
400 3
 
0.1%
250 3
 
0.1%
200 185
 
4.6%
160 9
 
0.2%
150 1008
25.2%
140 29
 
0.7%
135 379
 
9.5%
125 218
 
5.5%

등주종류
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size31.3 KiB
기타
3994 

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

Length

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

Common Values (Plot)

2024-03-14T22:26:08.238661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기타 3994
100.0%

등주형태
Categorical

HIGH CORRELATION 

Distinct18
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size31.3 KiB
스텐주
1886 
한전취부등
782 
철팔각
552 
원형철주
336 
교각하부취부등
 
124
Other values (13)
314 

Length

Max length7
Median length3
Mean length3.6204306
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
스텐주 1886
47.2%
한전취부등 782
19.6%
철팔각 552
 
13.8%
원형철주 336
 
8.4%
교각하부취부등 124
 
3.1%
열주등 99
 
2.5%
원형스텐주 41
 
1.0%
기타 35
 
0.9%
취부등 24
 
0.6%
경관조명 24
 
0.6%
Other values (8) 91
 
2.3%

Length

2024-03-14T22:26:08.419164image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
스텐주 1886
47.2%
한전취부등 782
19.6%
철팔각 552
 
13.8%
원형철주 336
 
8.4%
교각하부취부등 124
 
3.1%
열주등 99
 
2.5%
원형스텐주 41
 
1.0%
기타 35
 
0.9%
경관조명 24
 
0.6%
취부등 24
 
0.6%
Other values (8) 91
 
2.3%

점멸기종류
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size31.3 KiB
기타
3843 
양방향식
 
151

Length

Max length4
Median length2
Mean length2.0756134
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
기타 3843
96.2%
양방향식 151
 
3.8%

Length

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

Common Values (Plot)

2024-03-14T22:26:08.831850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기타 3843
96.2%
양방향식 151
 
3.8%

분기번호
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size31.3 KiB
0
3994 

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 3994
100.0%

Length

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

Common Values (Plot)

2024-03-14T22:26:09.257480image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 3994
100.0%

위도
Real number (ℝ)

HIGH CORRELATION 

Distinct3521
Distinct (%)88.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35.160953
Minimum35.135538
Maximum35.185571
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size35.2 KiB
2024-03-14T22:26:09.448767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum35.135538
5-th percentile35.140378
Q135.153873
median35.160498
Q335.170998
95-th percentile35.178594
Maximum35.185571
Range0.05003216
Interquartile range (IQR)0.01712442

Descriptive statistics

Standard deviation0.011812784
Coefficient of variation (CV)0.00033596313
Kurtosis-0.85442053
Mean35.160953
Median Absolute Deviation (MAD)0.00927072
Skewness-0.20624322
Sum140432.85
Variance0.00013954186
MonotonicityNot monotonic
2024-03-14T22:26:09.920725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
35.15670627 4
 
0.1%
35.18181288 3
 
0.1%
35.1816952 3
 
0.1%
35.18163469 3
 
0.1%
35.18171978 3
 
0.1%
35.1817619 3
 
0.1%
35.17016916 2
 
0.1%
35.17041309 2
 
0.1%
35.16831327 2
 
0.1%
35.16807193 2
 
0.1%
Other values (3511) 3967
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 (ℝ)

Distinct3502
Distinct (%)87.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean129.11596
Minimum129.09597
Maximum129.13506
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size35.2 KiB
2024-03-14T22:26:10.378214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum129.09597
5-th percentile129.10255
Q1129.11012
median129.11497
Q3129.12152
95-th percentile129.13164
Maximum129.13506
Range0.0390886
Interquartile range (IQR)0.011403875

Descriptive statistics

Standard deviation0.0085291514
Coefficient of variation (CV)6.6058072 × 10-5
Kurtosis-0.4804869
Mean129.11596
Median Absolute Deviation (MAD)0.00556875
Skewness0.24537567
Sum515689.15
Variance7.2746424 × 10-5
MonotonicityNot monotonic
2024-03-14T22:26:10.837063image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
129.1151488 4
 
0.1%
129.1149601 3
 
0.1%
129.1151785 3
 
0.1%
129.1207219 3
 
0.1%
129.1070166 3
 
0.1%
129.1149089 3
 
0.1%
129.1171624 3
 
0.1%
129.102169 3
 
0.1%
129.115008 3
 
0.1%
129.1200825 3
 
0.1%
Other values (3492) 3963
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

2024-03-14T22:25:56.605382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:25:53.913457image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:25:54.978632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:25:55.685123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:25:56.878470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:25:54.168969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:25:55.187400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:25:55.839196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:25:57.149768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:25:54.429635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:25:55.344525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:25:56.077863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:25:57.423231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:25:54.689986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:25:55.500819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:25:56.327240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T22:26:11.131001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동등기구ID등기구종류등 수램프종류램프용량(W)등주형태점멸기종류위도경도
행정동1.0000.2340.8020.0440.1280.1940.5500.2860.9250.872
등기구ID0.2341.0000.9350.0000.0000.4700.3160.0280.2720.161
등기구종류0.8020.9351.0000.6600.9740.9420.8730.4650.7620.729
등 수0.0440.0000.6601.0000.2760.5500.7210.0000.1140.179
램프종류0.1280.0000.9740.2761.0000.9450.7580.0000.1970.176
램프용량(W)0.1940.4700.9420.5500.9451.0000.8180.0690.1670.153
등주형태0.5500.3160.8730.7210.7580.8181.0000.6580.5220.557
점멸기종류0.2860.0280.4650.0000.0000.0690.6581.0000.3280.276
위도0.9250.2720.7620.1140.1970.1670.5220.3281.0000.701
경도0.8720.1610.7290.1790.1760.1530.5570.2760.7011.000
2024-03-14T22:26:11.447846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
점멸기종류등주형태등기구ID램프종류행정동등기구종류
점멸기종류1.0000.5260.0470.0000.2190.370
등주형태0.5261.0000.1520.4890.2450.422
등기구ID0.0470.1521.0000.0000.1430.748
램프종류0.0000.4890.0001.0000.0760.840
행정동0.2190.2450.1430.0761.0000.422
등기구종류0.3700.4220.7480.8400.4221.000
2024-03-14T22:26:11.735647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
등 수램프용량(W)위도경도행정동등기구ID등기구종류램프종류등주형태점멸기종류
등 수1.000-0.0300.0330.0400.0210.0000.3480.2710.4210.000
램프용량(W)-0.0301.000-0.141-0.0010.1030.2200.7050.7150.4780.050
위도0.033-0.1411.000-0.0170.5510.1690.3770.1190.2290.251
경도0.040-0.001-0.0171.0000.4510.0960.3450.1060.2500.211
행정동0.0210.1030.5510.4511.0000.1430.4220.0760.2450.219
등기구ID0.0000.2200.1690.0960.1431.0000.7480.0000.1520.047
등기구종류0.3480.7050.3770.3450.4220.7481.0000.8400.4220.370
램프종류0.2710.7150.1190.1060.0760.0000.8401.0000.4890.000
등주형태0.4210.4780.2290.2500.2450.1520.4220.4891.0000.526
점멸기종류0.0000.0500.2510.2110.2190.0470.3700.0000.5261.000

Missing values

2024-03-14T22:25:57.846207image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T22:25:58.462004image/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

관리번호소속분전함행정동노선명등기구ID등기구종류등 수램프종류램프용량(W)등주종류등주형태점멸기종류분기번호위도경도
0KBS조명탑-1KBS조명탑 (1)남천1동수영로1머스코5MH1000기타조명탑기타035.143849129.109464
1감포로-1-1감포로-1 (29)민락동감포로1컷오프1LED150기타철팔각기타035.167637129.117875
2감포로-1-10감포로-1 (29)민락동감포로1세종로대형1LED100기타한전취부등기타035.163838129.119239
3감포로-1-11감포로-1 (29)민락동감포로1컷오프1LED150기타철팔각기타035.163622129.119302
4감포로-1-12감포로-1 (29)민락동감포로1컷오프1LED150기타철팔각기타035.163146129.119465
5감포로-1-13감포로-1 (29)민락동감포로1컷오프1LED150기타철팔각기타035.162739129.119606
6감포로-1-14감포로-1 (29)민락동감포로1컷오프1LED150기타철팔각기타035.162312129.119748
7감포로-1-15감포로-1 (29)민락동감포로1컷오프1LED150기타철팔각기타035.162086129.119825
8감포로-1-16감포로-1 (29)민락동감포로1컷오프1LED150기타철팔각기타035.161299129.120128
9감포로-1-17감포로-1 (29)민락동감포로1컷오프1LED150기타철팔각기타035.160966129.120237
관리번호소속분전함행정동노선명등기구ID등기구종류등 수램프종류램프용량(W)등주종류등주형태점멸기종류분기번호위도경도
3984황령산로8-1-09황령산로8-1 (18)남천1동황령산로8번길13번1LED100기타한전취부등기타035.148541129.109645
3985황령산로8-1-10황령산로8-1 (18)남천1동황령산로8번길13번1LED100기타한전취부등기타035.148864129.10975
3986황령산로8-1-11황령산로8-1 (18)남천1동황령산로8번길13번1LED100기타한전취부등기타035.149106129.109945
3987황령산로8-1-12황령산로8-1 (18)남천1동황령산로8번길13번1LED100기타스텐주기타035.149371129.110015
3988황령산로8-1-13황령산로8-1 (18)남천1동황령산로8번길13번1LED100기타한전취부등기타035.149539129.11005
3989황령산로8-1-14황령산로8-1 (18)남천1동황령산로8번길13번1LED100기타한전취부등기타035.149572129.110125
3990황령산로8-1-15황령산로8-1 (18)남천1동황령산로8번길13번1LED100기타한전취부등기타035.149987129.110196
3991황령산로8-1-16황령산로8-1 (18)남천1동황령산로8번길13번1LED100기타한전취부등기타035.15042129.110314
3992황령산로8-1-17황령산로8-1 (18)남천1동황령산로8번길13번1LED100기타한전취부등기타035.150601129.110373
3993황령산로8-1-18황령산로8-1 (18)남천1동황령산로8번길13번1LED100기타한전취부등기타035.147792129.109456