Overview

Dataset statistics

Number of variables12
Number of observations10000
Missing cells745
Missing cells (%)0.6%
Duplicate rows1
Duplicate rows (%)< 0.1%
Total size in memory1.0 MiB
Average record size in memory108.0 B

Variable types

Text4
Categorical4
Numeric4

Dataset

Description울산광역시 남구의 가로보안등 정보로 관리번호, 시설종류, 지번주소, 도로명주소, 등기구종류, 램프종류, 램프용량(W), 램프수량, 등주종류, 위도, 경도, 데이터기준일자로 구성되어있습니다.
Author울산광역시 남구
URLhttps://www.data.go.kr/data/15127415/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
Dataset has 1 (< 0.1%) duplicate rowsDuplicates
램프용량(W) is highly overall correlated with 시설종류 and 2 other fieldsHigh correlation
시설종류 is highly overall correlated with 램프용량(W) and 2 other fieldsHigh correlation
등기구종류 is highly overall correlated with 램프용량(W) and 2 other fieldsHigh correlation
램프종류 is highly overall correlated with 램프용량(W) and 2 other fieldsHigh correlation
등기구종류 is highly imbalanced (55.8%)Imbalance
등주종류 has 745 (7.4%) missing valuesMissing

Reproduction

Analysis started2024-04-06 08:26:33.714827
Analysis finished2024-04-06 08:26:41.779946
Duration8.07 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리번호
Text

Distinct9927
Distinct (%)99.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-04-06T17:26:42.449591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length21
Mean length6.9193
Min length1

Characters and Unicode

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

Unique

Unique9888 ?
Unique (%)98.9%

Sample

1st row무거동432
2nd row중앙로10-2
3rd row신정2동261
4th row삼산로11-13
5th row문수로2-9
ValueCountFrequency (%)
법대로3 10
 
0.1%
삼산동x 8
 
0.1%
문수산 7
 
0.1%
야음장생포동x 6
 
0.1%
무거동x 5
 
< 0.1%
신정1동x(표찰x 4
 
< 0.1%
은월로2-x 4
 
< 0.1%
삼호동x(표찰x 4
 
< 0.1%
조명타워 4
 
< 0.1%
삼산동x(표찰x 3
 
< 0.1%
Other values (9924) 9966
99.5%
2024-04-06T17:26:43.471256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 6961
 
10.1%
- 5917
 
8.6%
로 5626
 
8.1%
2 4846
 
7.0%
동 4183
 
6.0%
3 3648
 
5.3%
4 2851
 
4.1%
5 2321
 
3.4%
6 1926
 
2.8%
산 1890
 
2.7%
Other values (144) 29024
41.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 33439
48.3%
Decimal Number 29352
42.4%
Dash Punctuation 5917
 
8.6%
Uppercase Letter 278
 
0.4%
Open Punctuation 88
 
0.1%
Close Punctuation 88
 
0.1%
Space Separator 21
 
< 0.1%
Other Punctuation 6
 
< 0.1%
Lowercase Letter 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 5626
 
16.8%
동 4183
 
12.5%
산 1890
 
5.7%
삼 1318
 
3.9%
신 1307
 
3.9%
정 1222
 
3.7%
용 791
 
2.4%
업 740
 
2.2%
남 713
 
2.1%
암 703
 
2.1%
Other values (123) 14946
44.7%
Decimal Number
ValueCountFrequency (%)
1 6961
23.7%
2 4846
16.5%
3 3648
12.4%
4 2851
9.7%
5 2321
 
7.9%
6 1926
 
6.6%
7 1836
 
6.3%
8 1773
 
6.0%
9 1629
 
5.5%
0 1561
 
5.3%
Uppercase Letter
ValueCountFrequency (%)
X 118
42.4%
A 100
36.0%
P 30
 
10.8%
L 30
 
10.8%
Other Punctuation
ValueCountFrequency (%)
? 3
50.0%
, 3
50.0%
Dash Punctuation
ValueCountFrequency (%)
- 5917
100.0%
Open Punctuation
ValueCountFrequency (%)
( 88
100.0%
Close Punctuation
ValueCountFrequency (%)
) 88
100.0%
Space Separator
ValueCountFrequency (%)
21
100.0%
Lowercase Letter
ValueCountFrequency (%)
x 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 35472
51.3%
Hangul 33439
48.3%
Latin 282
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 5626
 
16.8%
동 4183
 
12.5%
산 1890
 
5.7%
삼 1318
 
3.9%
신 1307
 
3.9%
정 1222
 
3.7%
용 791
 
2.4%
업 740
 
2.2%
남 713
 
2.1%
암 703
 
2.1%
Other values (123) 14946
44.7%
Common
ValueCountFrequency (%)
1 6961
19.6%
- 5917
16.7%
2 4846
13.7%
3 3648
10.3%
4 2851
8.0%
5 2321
 
6.5%
6 1926
 
5.4%
7 1836
 
5.2%
8 1773
 
5.0%
9 1629
 
4.6%
Other values (6) 1764
 
5.0%
Latin
ValueCountFrequency (%)
X 118
41.8%
A 100
35.5%
P 30
 
10.6%
L 30
 
10.6%
x 4
 
1.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 35754
51.7%
Hangul 33439
48.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 6961
19.5%
- 5917
16.5%
2 4846
13.6%
3 3648
10.2%
4 2851
8.0%
5 2321
 
6.5%
6 1926
 
5.4%
7 1836
 
5.1%
8 1773
 
5.0%
9 1629
 
4.6%
Other values (11) 2046
 
5.7%
Hangul
ValueCountFrequency (%)
로 5626
 
16.8%
동 4183
 
12.5%
산 1890
 
5.7%
삼 1318
 
3.9%
신 1307
 
3.9%
정 1222
 
3.7%
용 791
 
2.4%
업 740
 
2.2%
남 713
 
2.1%
암 703
 
2.1%
Other values (123) 14946
44.7%

시설종류
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
가로등
5900 
보안등
4100 

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 (%)
가로등 5900
59.0%
보안등 4100
41.0%

Length

2024-04-06T17:26:43.756610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:26:43.947680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가로등 5900
59.0%
보안등 4100
41.0%

지번주소
Text

Distinct8490
Distinct (%)84.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-04-06T17:26:44.540316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length26
Mean length20.2993
Min length1

Characters and Unicode

Total characters202993
Distinct characters69
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

Unique7419 ?
Unique (%)74.2%

Sample

1st row울산광역시 남구 무거동 857-7번지
2nd row울산광역시 남구 달동 810-2번지
3rd row울산광역시 남구 신정동 1647-107번지
4th row울산광역시 남구 달동 905-2번지
5th row울산광역시 남구 무거동 541-5번지
ValueCountFrequency (%)
울산광역시 9944
24.9%
남구 9824
24.6%
신정동 1904
 
4.8%
무거동 1446
 
3.6%
삼산동 1104
 
2.8%
야음동 1017
 
2.6%
달동 935
 
2.3%
옥동 761
 
1.9%
두왕동 516
 
1.3%
선암동 483
 
1.2%
Other values (7814) 11923
29.9%
2024-04-06T17:26:45.653907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
29969
 
14.8%
산 11726
 
5.8%
울 10025
 
4.9%
광 9944
 
4.9%
역 9944
 
4.9%
시 9944
 
4.9%
지 9944
 
4.9%
번 9944
 
4.9%
1 9928
 
4.9%
구 9873
 
4.9%
Other values (59) 81752
40.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 118758
58.5%
Decimal Number 44917
 
22.1%
Space Separator 29969
 
14.8%
Dash Punctuation 9349
 
4.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
산 11726
9.9%
울 10025
8.4%
광 9944
8.4%
역 9944
8.4%
시 9944
8.4%
지 9944
8.4%
번 9944
8.4%
구 9873
8.3%
동 9863
8.3%
남 9840
8.3%
Other values (47) 17711
14.9%
Decimal Number
ValueCountFrequency (%)
1 9928
22.1%
2 5305
11.8%
3 4707
10.5%
4 4342
9.7%
5 4144
9.2%
6 3930
 
8.7%
7 3638
 
8.1%
8 3475
 
7.7%
9 2979
 
6.6%
0 2469
 
5.5%
Space Separator
ValueCountFrequency (%)
29969
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 9349
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 118758
58.5%
Common 84235
41.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
산 11726
9.9%
울 10025
8.4%
광 9944
8.4%
역 9944
8.4%
시 9944
8.4%
지 9944
8.4%
번 9944
8.4%
구 9873
8.3%
동 9863
8.3%
남 9840
8.3%
Other values (47) 17711
14.9%
Common
ValueCountFrequency (%)
29969
35.6%
1 9928
 
11.8%
- 9349
 
11.1%
2 5305
 
6.3%
3 4707
 
5.6%
4 4342
 
5.2%
5 4144
 
4.9%
6 3930
 
4.7%
7 3638
 
4.3%
8 3475
 
4.1%
Other values (2) 5448
 
6.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 118758
58.5%
ASCII 84235
41.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
29969
35.6%
1 9928
 
11.8%
- 9349
 
11.1%
2 5305
 
6.3%
3 4707
 
5.6%
4 4342
 
5.2%
5 4144
 
4.9%
6 3930
 
4.7%
7 3638
 
4.3%
8 3475
 
4.1%
Other values (2) 5448
 
6.5%
Hangul
ValueCountFrequency (%)
산 11726
9.9%
울 10025
8.4%
광 9944
8.4%
역 9944
8.4%
시 9944
8.4%
지 9944
8.4%
번 9944
8.4%
구 9873
8.3%
동 9863
8.3%
남 9840
8.3%
Other values (47) 17711
14.9%

도로명주소
Text

Distinct3385
Distinct (%)33.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-04-06T17:26:46.238139image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length1
Mean length10.2173
Min length1

Characters and Unicode

Total characters102173
Distinct characters335
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

Unique3070 ?
Unique (%)30.7%

Sample

1st row울산광역시 남구 신복로 4 (무거동)
2nd row
3rd row
4th row
5th row
ValueCountFrequency (%)
울산광역시 3777
19.6%
남구 3767
19.5%
신정동 906
 
4.7%
무거동 870
 
4.5%
달동 624
 
3.2%
삼산동 540
 
2.8%
야음동 343
 
1.8%
옥동 201
 
1.0%
돋질로 108
 
0.6%
8 83
 
0.4%
Other values (1871) 8095
41.9%
2024-04-06T17:26:47.082123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
21760
21.3%
산 4911
 
4.8%
남 3999
 
3.9%
동 3891
 
3.8%
울 3837
 
3.8%
광 3820
 
3.7%
( 3819
 
3.7%
) 3819
 
3.7%
구 3801
 
3.7%
시 3789
 
3.7%
Other values (325) 44727
43.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 56932
55.7%
Space Separator 21760
 
21.3%
Decimal Number 14683
 
14.4%
Open Punctuation 3819
 
3.7%
Close Punctuation 3819
 
3.7%
Dash Punctuation 896
 
0.9%
Other Punctuation 209
 
0.2%
Uppercase Letter 55
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
산 4911
 
8.6%
남 3999
 
7.0%
동 3891
 
6.8%
울 3837
 
6.7%
광 3820
 
6.7%
구 3801
 
6.7%
시 3789
 
6.7%
역 3781
 
6.6%
로 3756
 
6.6%
번 2722
 
4.8%
Other values (294) 18625
32.7%
Uppercase Letter
ValueCountFrequency (%)
A 8
14.5%
S 6
10.9%
C 5
9.1%
E 5
9.1%
K 4
 
7.3%
T 4
 
7.3%
L 4
 
7.3%
I 3
 
5.5%
W 3
 
5.5%
G 2
 
3.6%
Other values (6) 11
20.0%
Decimal Number
ValueCountFrequency (%)
1 3466
23.6%
2 2263
15.4%
3 1667
11.4%
4 1372
 
9.3%
5 1163
 
7.9%
6 1096
 
7.5%
8 1043
 
7.1%
7 947
 
6.4%
0 836
 
5.7%
9 830
 
5.7%
Space Separator
ValueCountFrequency (%)
21760
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3819
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3819
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 896
100.0%
Other Punctuation
ValueCountFrequency (%)
, 209
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 56932
55.7%
Common 45186
44.2%
Latin 55
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
산 4911
 
8.6%
남 3999
 
7.0%
동 3891
 
6.8%
울 3837
 
6.7%
광 3820
 
6.7%
구 3801
 
6.7%
시 3789
 
6.7%
역 3781
 
6.6%
로 3756
 
6.6%
번 2722
 
4.8%
Other values (294) 18625
32.7%
Latin
ValueCountFrequency (%)
A 8
14.5%
S 6
10.9%
C 5
9.1%
E 5
9.1%
K 4
 
7.3%
T 4
 
7.3%
L 4
 
7.3%
I 3
 
5.5%
W 3
 
5.5%
G 2
 
3.6%
Other values (6) 11
20.0%
Common
ValueCountFrequency (%)
21760
48.2%
( 3819
 
8.5%
) 3819
 
8.5%
1 3466
 
7.7%
2 2263
 
5.0%
3 1667
 
3.7%
4 1372
 
3.0%
5 1163
 
2.6%
6 1096
 
2.4%
8 1043
 
2.3%
Other values (5) 3718
 
8.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 56932
55.7%
ASCII 45241
44.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
21760
48.1%
( 3819
 
8.4%
) 3819
 
8.4%
1 3466
 
7.7%
2 2263
 
5.0%
3 1667
 
3.7%
4 1372
 
3.0%
5 1163
 
2.6%
6 1096
 
2.4%
8 1043
 
2.3%
Other values (21) 3773
 
8.3%
Hangul
ValueCountFrequency (%)
산 4911
 
8.6%
남 3999
 
7.0%
동 3891
 
6.8%
울 3837
 
6.7%
광 3820
 
6.7%
구 3801
 
6.7%
시 3789
 
6.7%
역 3781
 
6.6%
로 3756
 
6.6%
번 2722
 
4.8%
Other values (294) 18625
32.7%

등기구종류
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct16
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
타운형
3731 
LED
3173 
<NA>
2793 
세종로대형
 
207
PC글러브
 
60
Other values (11)
 
36

Length

Max length7
Median length3
Mean length3.3363
Min length3

Unique

Unique5 ?
Unique (%)< 0.1%

Sample

1st row타운형
2nd rowLED
3rd row타운형
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
타운형 3731
37.3%
LED 3173
31.7%
<NA> 2793
27.9%
세종로대형 207
 
2.1%
PC글러브 60
 
0.6%
투광등 15
 
0.1%
무역의거리형 7
 
0.1%
터널등 3
 
< 0.1%
LED타운형 2
 
< 0.1%
가오스 2
 
< 0.1%
Other values (6) 7
 
0.1%

Length

2024-04-06T17:26:47.359422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
타운형 3731
37.3%
led 3173
31.7%
na 2793
27.9%
세종로대형 207
 
2.1%
pc글러브 60
 
0.6%
투광등 15
 
0.1%
무역의거리형 7
 
0.1%
터널등 3
 
< 0.1%
led타운형 2
 
< 0.1%
가오스 2
 
< 0.1%
Other values (6) 7
 
0.1%

램프종류
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
LED
4350 
CDM
3785 
나트륨
1080 
세라믹
684 
NH
 
79
Other values (3)
 
22

Length

Max length4
Median length3
Mean length2.9937
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
LED 4350
43.5%
CDM 3785
37.9%
나트륨 1080
 
10.8%
세라믹 684
 
6.8%
NH 79
 
0.8%
<NA> 16
 
0.2%
cdm 5
 
0.1%
삼파장 1
 
< 0.1%

Length

2024-04-06T17:26:47.630899image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:26:47.866789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
led 4350
43.5%
cdm 3790
37.9%
나트륨 1080
 
10.8%
세라믹 684
 
6.8%
nh 79
 
0.8%
na 16
 
0.2%
삼파장 1
 
< 0.1%

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

HIGH CORRELATION 

Distinct17
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean123.143
Minimum0
Maximum1000
Zeros98
Zeros (%)1.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-04-06T17:26:48.191581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile50
Q170
median150
Q3150
95-th percentile250
Maximum1000
Range1000
Interquartile range (IQR)80

Descriptive statistics

Standard deviation62.751973
Coefficient of variation (CV)0.5095862
Kurtosis8.7496826
Mean123.143
Median Absolute Deviation (MAD)80
Skewness1.3039883
Sum1231430
Variance3937.8101
MonotonicityNot monotonic
2024-04-06T17:26:48.418304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%)
150 3945
39.5%
70 3393
33.9%
250 1167
 
11.7%
50 758
 
7.6%
120 363
 
3.6%
100 147
 
1.5%
0 98
 
1.0%
75 67
 
0.7%
60 26
 
0.3%
125 22
 
0.2%
Other values (7) 14
 
0.1%
ValueCountFrequency (%)
0 98
 
1.0%
15 2
 
< 0.1%
50 758
 
7.6%
60 26
 
0.3%
70 3393
33.9%
75 67
 
0.7%
100 147
 
1.5%
120 363
 
3.6%
125 22
 
0.2%
142 1
 
< 0.1%
ValueCountFrequency (%)
1000 2
 
< 0.1%
800 1
 
< 0.1%
600 1
 
< 0.1%
250 1167
 
11.7%
200 6
 
0.1%
153 1
 
< 0.1%
150 3945
39.5%
142 1
 
< 0.1%
125 22
 
0.2%
120 363
 
3.6%

램프수량
Real number (ℝ)

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.0709
Minimum1
Maximum8
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-04-06T17:26:48.605268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q31
95-th percentile2
Maximum8
Range7
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.28754384
Coefficient of variation (CV)0.26850671
Kurtosis100.50327
Mean1.0709
Median Absolute Deviation (MAD)0
Skewness6.8984799
Sum10709
Variance0.082681458
MonotonicityNot monotonic
2024-04-06T17:26:48.816005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
1 9326
93.3%
2 659
 
6.6%
3 9
 
0.1%
6 3
 
< 0.1%
8 2
 
< 0.1%
4 1
 
< 0.1%
ValueCountFrequency (%)
1 9326
93.3%
2 659
 
6.6%
3 9
 
0.1%
4 1
 
< 0.1%
6 3
 
< 0.1%
8 2
 
< 0.1%
ValueCountFrequency (%)
8 2
 
< 0.1%
6 3
 
< 0.1%
4 1
 
< 0.1%
3 9
 
0.1%
2 659
 
6.6%
1 9326
93.3%

등주종류
Text

MISSING 

Distinct56
Distinct (%)0.6%
Missing745
Missing (%)7.4%
Memory size156.2 KiB
2024-04-06T17:26:49.228433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length3
Mean length3.5132361
Min length2

Characters and Unicode

Total characters32515
Distinct characters67
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

Unique10 ?
Unique (%)0.1%

Sample

1st row한전주
2nd row스텐등주
3rd row한전주
4th row스텐등주
5th row스텐등주
ValueCountFrequency (%)
한전주 3570
38.6%
팔각테파 1607
17.4%
스텐등주 822
 
8.9%
철재원형 753
 
8.1%
팔각형 384
 
4.1%
원형폴 286
 
3.1%
스텐형 231
 
2.5%
팔각 145
 
1.6%
통신주 139
 
1.5%
스텐원형 126
 
1.4%
Other values (45) 1192
 
12.9%
2024-04-06T17:26:49.880459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 5223
16.1%
전 3865
11.9%
한 3669
11.3%
팔 2310
 
7.1%
각 2310
 
7.1%
형 2181
 
6.7%
테 1715
 
5.3%
파 1715
 
5.3%
스 1388
 
4.3%
텐 1388
 
4.3%
Other values (57) 6751
20.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 32001
98.4%
Decimal Number 267
 
0.8%
Close Punctuation 99
 
0.3%
Open Punctuation 99
 
0.3%
Other Punctuation 31
 
0.1%
Uppercase Letter 18
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 5223
16.3%
전 3865
12.1%
한 3669
11.5%
팔 2310
 
7.2%
각 2310
 
7.2%
형 2181
 
6.8%
테 1715
 
5.4%
파 1715
 
5.4%
스 1388
 
4.3%
텐 1388
 
4.3%
Other values (45) 6237
19.5%
Decimal Number
ValueCountFrequency (%)
9 204
76.4%
2 24
 
9.0%
1 23
 
8.6%
6 14
 
5.2%
8 2
 
0.7%
Uppercase Letter
ValueCountFrequency (%)
M 14
77.8%
C 2
 
11.1%
T 1
 
5.6%
V 1
 
5.6%
Close Punctuation
ValueCountFrequency (%)
) 99
100.0%
Open Punctuation
ValueCountFrequency (%)
( 99
100.0%
Other Punctuation
ValueCountFrequency (%)
, 31
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 32001
98.4%
Common 496
 
1.5%
Latin 18
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 5223
16.3%
전 3865
12.1%
한 3669
11.5%
팔 2310
 
7.2%
각 2310
 
7.2%
형 2181
 
6.8%
테 1715
 
5.4%
파 1715
 
5.4%
스 1388
 
4.3%
텐 1388
 
4.3%
Other values (45) 6237
19.5%
Common
ValueCountFrequency (%)
9 204
41.1%
) 99
20.0%
( 99
20.0%
, 31
 
6.2%
2 24
 
4.8%
1 23
 
4.6%
6 14
 
2.8%
8 2
 
0.4%
Latin
ValueCountFrequency (%)
M 14
77.8%
C 2
 
11.1%
T 1
 
5.6%
V 1
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 32001
98.4%
ASCII 514
 
1.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 5223
16.3%
전 3865
12.1%
한 3669
11.5%
팔 2310
 
7.2%
각 2310
 
7.2%
형 2181
 
6.8%
테 1715
 
5.4%
파 1715
 
5.4%
스 1388
 
4.3%
텐 1388
 
4.3%
Other values (45) 6237
19.5%
ASCII
ValueCountFrequency (%)
9 204
39.7%
) 99
19.3%
( 99
19.3%
, 31
 
6.0%
2 24
 
4.7%
1 23
 
4.5%
6 14
 
2.7%
M 14
 
2.7%
8 2
 
0.4%
C 2
 
0.4%
Other values (2) 2
 
0.4%

위도
Real number (ℝ)

Distinct9767
Distinct (%)97.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35.528873
Minimum35.459123
Maximum35.556672
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-04-06T17:26:50.292470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum35.459123
5-th percentile35.486225
Q135.51967
median35.534366
Q335.542529
95-th percentile35.550599
Maximum35.556672
Range0.09754983
Interquartile range (IQR)0.02285965

Descriptive statistics

Standard deviation0.019510133
Coefficient of variation (CV)0.0005491346
Kurtosis1.9077872
Mean35.528873
Median Absolute Deviation (MAD)0.01048967
Skewness-1.3963823
Sum355288.73
Variance0.0003806453
MonotonicityNot monotonic
2024-04-06T17:26:50.642566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
35.53321026 5
 
0.1%
35.54265833 5
 
0.1%
35.50699722 4
 
< 0.1%
35.53738056 4
 
< 0.1%
35.53553611 4
 
< 0.1%
35.54190278 3
 
< 0.1%
35.54698056 3
 
< 0.1%
35.527425 3
 
< 0.1%
35.53517222 3
 
< 0.1%
35.503475 3
 
< 0.1%
Other values (9757) 9963
99.6%
ValueCountFrequency (%)
35.45912255 1
< 0.1%
35.45913545 1
< 0.1%
35.45914539 1
< 0.1%
35.45916667 1
< 0.1%
35.45917702 1
< 0.1%
35.45923751 1
< 0.1%
35.45929984 1
< 0.1%
35.45936059 1
< 0.1%
35.45937331 1
< 0.1%
35.45939843 1
< 0.1%
ValueCountFrequency (%)
35.55667238 1
< 0.1%
35.55658188 1
< 0.1%
35.55647559 1
< 0.1%
35.55642851 1
< 0.1%
35.55636067 1
< 0.1%
35.55635231 1
< 0.1%
35.55625618 1
< 0.1%
35.55617746 1
< 0.1%
35.55612822 1
< 0.1%
35.55611039 1
< 0.1%

경도
Real number (ℝ)

Distinct9829
Distinct (%)98.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean129.31691
Minimum129.24652
Maximum129.38687
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-04-06T17:26:50.894902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum129.24652
5-th percentile129.26108
Q1129.29872
median129.31921
Q3129.33992
95-th percentile129.36534
Maximum129.38687
Range0.1403437
Interquartile range (IQR)0.04120745

Descriptive statistics

Standard deviation0.030799757
Coefficient of variation (CV)0.0002381727
Kurtosis-0.56421508
Mean129.31691
Median Absolute Deviation (MAD)0.0206321
Skewness-0.28555148
Sum1293169.1
Variance0.000948625
MonotonicityNot monotonic
2024-04-06T17:26:51.175017image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
129.2996361 5
 
0.1%
129.3276639 3
 
< 0.1%
129.3320083 3
 
< 0.1%
129.3255159 3
 
< 0.1%
129.3091222 3
 
< 0.1%
129.3013139 3
 
< 0.1%
129.3415694 3
 
< 0.1%
129.3254056 3
 
< 0.1%
129.3691306 3
 
< 0.1%
129.3373278 3
 
< 0.1%
Other values (9819) 9968
99.7%
ValueCountFrequency (%)
129.2465222 1
< 0.1%
129.2466111 1
< 0.1%
129.2471861 1
< 0.1%
129.2474057 1
< 0.1%
129.2476 1
< 0.1%
129.2482561 1
< 0.1%
129.2483361 1
< 0.1%
129.2485986 1
< 0.1%
129.248921 1
< 0.1%
129.2493163 1
< 0.1%
ValueCountFrequency (%)
129.3868659 1
< 0.1%
129.3865834 1
< 0.1%
129.3863489 1
< 0.1%
129.38606 1
< 0.1%
129.385482 1
< 0.1%
129.3852702 1
< 0.1%
129.3847635 1
< 0.1%
129.3847267 1
< 0.1%
129.3847214 1
< 0.1%
129.384709 1
< 0.1%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-03-28
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2024-03-28
2nd row2024-03-28
3rd row2024-03-28
4th row2024-03-28
5th row2024-03-28

Common Values

ValueCountFrequency (%)
2024-03-28 10000
100.0%

Length

2024-04-06T17:26:51.497196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:26:51.658803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2024-03-28 10000
100.0%

Interactions

2024-04-06T17:26:40.317639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:37.091967image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:38.202461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:39.509307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:40.512117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:37.436385image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:38.767283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:39.747239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:40.771290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:37.705481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:39.026097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:39.940837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:40.974614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:37.932388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:39.205578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:40.123444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-06T17:26:51.789951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시설종류등기구종류램프종류램프용량(W)램프수량등주종류위도경도
시설종류1.0000.8080.6230.9850.0431.0000.3660.389
등기구종류0.8081.0000.8430.8970.7740.8460.3390.252
램프종류0.6230.8431.0000.6960.0580.8270.4230.278
램프용량(W)0.9850.8970.6961.0000.9540.9030.4230.286
램프수량0.0430.7740.0580.9541.0000.7690.1060.166
등주종류1.0000.8460.8270.9030.7691.0000.7600.677
위도0.3660.3390.4230.4230.1060.7601.0000.714
경도0.3890.2520.2780.2860.1660.6770.7141.000
2024-04-06T17:26:52.015899image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시설종류등기구종류램프종류
시설종류1.0000.7650.671
등기구종류0.7651.0000.594
램프종류0.6710.5941.000
2024-04-06T17:26:52.185934image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
램프용량(W)램프수량위도경도시설종류등기구종류램프종류
램프용량(W)1.000-0.094-0.3030.2330.8710.5990.501
램프수량-0.0941.0000.098-0.0670.0310.4980.034
위도-0.3030.0981.000-0.4460.2810.1330.230
경도0.233-0.067-0.4461.0000.2990.0970.144
시설종류0.8710.0310.2810.2991.0000.7650.671
등기구종류0.5990.4980.1330.0970.7651.0000.594
램프종류0.5010.0340.2300.1440.6710.5941.000

Missing values

2024-04-06T17:26:41.261322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T17:26:41.616579image/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

관리번호시설종류지번주소도로명주소등기구종류램프종류램프용량(W)램프수량등주종류위도경도데이터기준일자
1297무거동432보안등울산광역시 남구 무거동 857-7번지울산광역시 남구 신복로 4 (무거동)타운형CDM701한전주35.547499129.2613392024-03-28
14662중앙로10-2가로등울산광역시 남구 달동 810-2번지LEDLED1202스텐등주35.532344129.3175432024-03-28
4422신정2동261보안등울산광역시 남구 신정동 1647-107번지타운형CDM701한전주35.534192129.3028722024-03-28
11704삼산로11-13가로등울산광역시 남구 달동 905-2번지<NA>LED1501스텐등주35.535108129.3179842024-03-28
9821문수로2-9가로등울산광역시 남구 무거동 541-5번지<NA>CDM1501스텐등주35.53764129.2597982024-03-28
14333장생포로1-8가로등울산광역시 남구 여천동 895-14번지LEDLED1501팔각테파35.519249129.3451122024-03-28
15586처용로37-13가로등울산광역시 남구 여천동 831-7번지타운형세라믹1501팔각테파35.513378129.3425272024-03-28
11443산업로7-32가로등울산광역시 남구 여천동 989-5번지<NA>나트륨2501팔각35.524384129.3442442024-03-28
6918강남로3-2가로등울산광역시 남구 삼산동 1330-2번지LEDLED1501철재원형35.548085129.3364152024-03-28
12234수암로16-3가로등울산광역시 남구 야음동 866-3번지울산광역시 남구 대암로 69 신정현대프라자 (야음동)LEDLED1501팔각테파35.530557129.3235272024-03-28
관리번호시설종류지번주소도로명주소등기구종류램프종류램프용량(W)램프수량등주종류위도경도데이터기준일자
4653신정3동93보안등울산광역시 남구 신정동 490-13번지울산광역시 남구 팔등로61번길 6 (신정동)타운형CDM702한전주35.546008129.3129862024-03-28
3024삼호동470보안등울산광역시 남구 무거동 1268-20번지타운형CDM701한전주35.548827129.2712712024-03-28
14960처용로10-1가로등울산광역시 남구 황성동 787-2번지<NA>CDM1501팔각형35.470104129.3467882024-03-28
8358남창로1-31가로등울산광역시 남구 두왕동 산134-2번지<NA>나트륨2501철재원형35.502937129.2972332024-03-28
1159무거동294보안등울산광역시 남구 무거동 834번지울산광역시 남구 신복로45번길 4 (무거동, 현대문수팰리스)타운형CDM701한전주35.549183129.2567892024-03-28
15164처용로20-2가로등울산광역시 남구 황성동 581-10번지<NA>나트륨2501스텐형35.459398129.3602942024-03-28
2289삼산동867보안등울산광역시 남구 삼산동 1614-6번지울산광역시 남구 삼산로308번길 15 (삼산동)타운형CDM701한전주35.538475129.34052024-03-28
10674부두로4-15가로등울산광역시 남구 삼산동 6-2번지LEDLED1501팔각테파35.542646129.3584022024-03-28
14235장생포고래로2-26가로등울산광역시 남구 장생포동 222-6번지LEDLED1501팔각테파35.501147129.3706382024-03-28
6404옥동190보안등울산광역시 남구 옥동 1402-1번지울산광역시 남구 문수로359번길 8 (옥동)타운형CDM701한전주35.535508129.2931472024-03-28

Duplicate rows

Most frequently occurring

관리번호시설종류지번주소도로명주소등기구종류램프종류램프용량(W)램프수량등주종류위도경도데이터기준일자# duplicates
0화합로6-12가로등울산광역시 남구 달동 18-8번지LEDLED1501<NA>35.533265129.3384572024-03-282