Overview

Dataset statistics

Number of variables22
Number of observations4465
Missing cells4109
Missing cells (%)4.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory819.9 KiB
Average record size in memory188.0 B

Variable types

Categorical11
Numeric10
Text1

Dataset

Description지형지물부호, 관리번호, 행정읍면동, 도엽번호, 관리기관, 도로구간번호, 공사번호, 등기구모형, 등주높이 등을 기준으로 경상남도 사천시 공간정보시스템 상의 가로등 데이터 현황정보를 제공합니다.
Author경상남도 사천시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15063660

Alerts

지형지물부호 has constant value ""Constant
관리기관 has constant value ""Constant
가로등제어기관리번호 has constant value ""Constant
공사번호 is highly imbalanced (79.7%)Imbalance
등주형식 is highly imbalanced (71.5%)Imbalance
광원종류 is highly imbalanced (54.0%)Imbalance
배전함관리번호 has 4109 (92.0%) missing valuesMissing
등주높이 has 902 (20.2%) zerosZeros
암길이 has 872 (19.5%) zerosZeros

Reproduction

Analysis started2023-12-10 22:54:32.214478
Analysis finished2023-12-10 22:54:32.579791
Duration0.37 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지형지물부호
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size35.0 KiB
가로등
4465 

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 (%)
가로등 4465
100.0%

Length

2023-12-11T07:54:32.631666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:54:32.714293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가로등 4465
100.0%

관리번호
Real number (ℝ)

Distinct4401
Distinct (%)98.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean476123.97
Minimum1
Maximum999128
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size39.4 KiB
2023-12-11T07:54:32.840091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile160.2
Q1177111
median383009
Q3746063
95-th percentile990207.8
Maximum999128
Range999127
Interquartile range (IQR)568952

Descriptive statistics

Standard deviation334875.94
Coefficient of variation (CV)0.70333771
Kurtosis-1.5352214
Mean476123.97
Median Absolute Deviation (MAD)333998
Skewness0.068039634
Sum2.1258935 × 109
Variance1.121419 × 1011
MonotonicityNot monotonic
2023-12-11T07:54:33.206583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
8 2
 
< 0.1%
42 2
 
< 0.1%
34 2
 
< 0.1%
33 2
 
< 0.1%
35 2
 
< 0.1%
38 2
 
< 0.1%
37 2
 
< 0.1%
36 2
 
< 0.1%
39 2
 
< 0.1%
41 2
 
< 0.1%
Other values (4391) 4445
99.6%
ValueCountFrequency (%)
1 2
< 0.1%
2 2
< 0.1%
3 2
< 0.1%
4 2
< 0.1%
5 2
< 0.1%
6 2
< 0.1%
7 2
< 0.1%
8 2
< 0.1%
9 2
< 0.1%
10 2
< 0.1%
ValueCountFrequency (%)
999128 1
< 0.1%
999127 1
< 0.1%
999126 1
< 0.1%
999125 1
< 0.1%
999124 1
< 0.1%
999123 1
< 0.1%
999122 1
< 0.1%
999121 1
< 0.1%
999120 1
< 0.1%
999119 1
< 0.1%

행정읍면동코드
Real number (ℝ)

Distinct19
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean48240385
Minimum48240109
Maximum48240595
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size39.4 KiB
2023-12-11T07:54:33.339655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum48240109
5-th percentile48240250
Q148240320
median48240330
Q348240510
95-th percentile48240570
Maximum48240595
Range486
Interquartile range (IQR)190

Descriptive statistics

Standard deviation108.92716
Coefficient of variation (CV)2.2580078 × 10-6
Kurtosis-0.74956097
Mean48240385
Median Absolute Deviation (MAD)20
Skewness0.47628069
Sum2.1539332 × 1011
Variance11865.127
MonotonicityNot monotonic
2023-12-11T07:54:33.465713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
48240320 1041
23.3%
48240330 928
20.8%
48240510 430
9.6%
48240250 353
 
7.9%
48240550 250
 
5.6%
48240360 229
 
5.1%
48240530 210
 
4.7%
48240520 193
 
4.3%
48240310 157
 
3.5%
48240570 150
 
3.4%
Other values (9) 524
11.7%
ValueCountFrequency (%)
48240109 5
 
0.1%
48240111 9
 
0.2%
48240116 32
 
0.7%
48240124 7
 
0.2%
48240126 16
 
0.4%
48240250 353
 
7.9%
48240310 157
 
3.5%
48240320 1041
23.3%
48240330 928
20.8%
48240340 85
 
1.9%
ValueCountFrequency (%)
48240595 146
 
3.3%
48240570 150
 
3.4%
48240550 250
5.6%
48240530 210
4.7%
48240520 193
4.3%
48240510 430
9.6%
48240370 97
 
2.2%
48240360 229
5.1%
48240350 127
 
2.8%
48240340 85
 
1.9%

행정읍면동
Categorical

Distinct15
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size35.0 KiB
사남면
1041 
용현면
928 
동서동
430 
사천읍
353 
벌용동
250 
Other values (10)
1463 

Length

Max length7
Median length3
Mean length3.1088466
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row사천읍
2nd row사천읍
3rd row사천읍
4th row사남면
5th row사남면

Common Values

ValueCountFrequency (%)
사남면 1041
23.3%
용현면 928
20.8%
동서동 430
9.6%
사천읍 353
 
7.9%
벌용동 250
 
5.6%
곤명면 229
 
5.1%
동서금동 210
 
4.7%
선구동 193
 
4.3%
정동면 157
 
3.5%
향촌동 150
 
3.4%
Other values (5) 524
11.7%

Length

2023-12-11T07:54:33.596226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
사남면 1041
23.0%
용현면 928
20.5%
동서동 430
9.5%
사천읍 353
 
7.8%
벌용동 250
 
5.5%
곤명면 229
 
5.1%
동서금동 210
 
4.6%
선구동 193
 
4.3%
정동면 157
 
3.5%
향촌동 150
 
3.3%
Other values (6) 593
13.1%

도엽번호
Text

Distinct594
Distinct (%)13.3%
Missing0
Missing (%)0.0%
Memory size35.0 KiB
2023-12-11T07:54:33.818577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length9.943561
Min length9

Characters and Unicode

Total characters44398
Distinct characters14
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique127 ?
Unique (%)2.8%

Sample

1st row358131750A
2nd row358131750A
3rd row358131750A
4th row358131761D
5th row358131761D
ValueCountFrequency (%)
358132293c 68
 
1.5%
358132293a 68
 
1.5%
348010731d 52
 
1.2%
358132283a 42
 
0.9%
348010212 40
 
0.9%
357161536c 39
 
0.9%
358132283b 36
 
0.8%
348010736c 34
 
0.8%
358132283d 32
 
0.7%
358131690c 28
 
0.6%
Other values (584) 4026
90.2%
2023-12-11T07:54:34.163168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 8333
18.8%
1 7312
16.5%
8 5207
11.7%
0 4072
9.2%
5 3778
8.5%
7 3252
 
7.3%
4 2569
 
5.8%
2 2539
 
5.7%
6 1923
 
4.3%
9 1200
 
2.7%
Other values (4) 4213
9.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 40185
90.5%
Uppercase Letter 4213
 
9.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 8333
20.7%
1 7312
18.2%
8 5207
13.0%
0 4072
10.1%
5 3778
9.4%
7 3252
 
8.1%
4 2569
 
6.4%
2 2539
 
6.3%
6 1923
 
4.8%
9 1200
 
3.0%
Uppercase Letter
ValueCountFrequency (%)
A 1161
27.6%
C 1090
25.9%
D 1046
24.8%
B 916
21.7%

Most occurring scripts

ValueCountFrequency (%)
Common 40185
90.5%
Latin 4213
 
9.5%

Most frequent character per script

Common
ValueCountFrequency (%)
3 8333
20.7%
1 7312
18.2%
8 5207
13.0%
0 4072
10.1%
5 3778
9.4%
7 3252
 
8.1%
4 2569
 
6.4%
2 2539
 
6.3%
6 1923
 
4.8%
9 1200
 
3.0%
Latin
ValueCountFrequency (%)
A 1161
27.6%
C 1090
25.9%
D 1046
24.8%
B 916
21.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 44398
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 8333
18.8%
1 7312
16.5%
8 5207
11.7%
0 4072
9.2%
5 3778
8.5%
7 3252
 
7.3%
4 2569
 
5.8%
2 2539
 
5.7%
6 1923
 
4.3%
9 1200
 
2.7%
Other values (4) 4213
9.5%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size35.0 KiB
사천시
4465 

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 (%)
사천시 4465
100.0%

Length

2023-12-11T07:54:34.285277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:54:34.369227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사천시 4465
100.0%

도로구간번호
Real number (ℝ)

Distinct1499
Distinct (%)33.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean400458.78
Minimum2
Maximum999028
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size39.4 KiB
2023-12-11T07:54:34.477179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile100102
Q1230011
median320602
Q3478404
95-th percentile900266
Maximum999028
Range999026
Interquartile range (IQR)248393

Descriptive statistics

Standard deviation261527.8
Coefficient of variation (CV)0.65307047
Kurtosis-0.14933842
Mean400458.78
Median Absolute Deviation (MAD)120397
Skewness0.8036924
Sum1.7880485 × 109
Variance6.8396792 × 1010
MonotonicityNot monotonic
2023-12-11T07:54:34.614863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
471813 90
 
2.0%
300209 41
 
0.9%
999002 41
 
0.9%
300139 40
 
0.9%
433902 39
 
0.9%
310102 33
 
0.7%
432207 29
 
0.6%
900295 28
 
0.6%
500704 26
 
0.6%
300151 25
 
0.6%
Other values (1489) 4073
91.2%
ValueCountFrequency (%)
2 3
 
0.1%
3 5
0.1%
5 1
 
< 0.1%
6 1
 
< 0.1%
8 3
 
0.1%
9 8
0.2%
25 11
0.2%
26 1
 
< 0.1%
1006 3
 
0.1%
1015 1
 
< 0.1%
ValueCountFrequency (%)
999028 7
0.2%
999026 4
 
0.1%
999025 4
 
0.1%
999024 10
0.2%
999023 6
 
0.1%
999021 17
0.4%
999014 8
0.2%
999013 8
0.2%
999004 17
0.4%
999003 1
 
< 0.1%

공사번호
Categorical

IMBALANCE 

Distinct16
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size35.0 KiB
<NA>
3915 
RD20110005
 
207
RD20110009
 
183
2001000006
 
95
RD20110001
 
15
Other values (11)
 
50

Length

Max length10
Median length4
Mean length4.7390817
Min length4

Unique

Unique3 ?
Unique (%)0.1%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 3915
87.7%
RD20110005 207
 
4.6%
RD20110009 183
 
4.1%
2001000006 95
 
2.1%
RD20110001 15
 
0.3%
RD20110022 12
 
0.3%
RD20110007 10
 
0.2%
2005000328 9
 
0.2%
RD20110002 6
 
0.1%
2000000102 3
 
0.1%
Other values (6) 10
 
0.2%

Length

2023-12-11T07:54:34.736904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 3915
87.7%
rd20110005 207
 
4.6%
rd20110009 183
 
4.1%
2001000006 95
 
2.1%
rd20110001 15
 
0.3%
rd20110022 12
 
0.3%
rd20110007 10
 
0.2%
2005000328 9
 
0.2%
rd20110002 6
 
0.1%
2000000102 3
 
0.1%
Other values (6) 10
 
0.2%

등기구모형
Categorical

Distinct12
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size35.0 KiB
세종형대형
2053 
가오스형(신)
1240 
기타
447 
미분류
446 
투광기
 
87
Other values (7)
 
192

Length

Max length10
Median length7
Mean length4.9740202
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가오스형(신)
2nd row가오스형(신)
3rd row가오스형(신)
4th row세종형대형
5th row세종형대형

Common Values

ValueCountFrequency (%)
세종형대형 2053
46.0%
가오스형(신) 1240
27.8%
기타 447
 
10.0%
미분류 446
 
10.0%
투광기 87
 
1.9%
원형 58
 
1.3%
수박등 34
 
0.8%
갈매기형 27
 
0.6%
STS엠보싱돌기성형 26
 
0.6%
쌍구형 17
 
0.4%
Other values (2) 30
 
0.7%

Length

2023-12-11T07:54:34.860913image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
세종형대형 2053
46.0%
가오스형(신 1240
27.8%
기타 447
 
10.0%
미분류 446
 
10.0%
투광기 87
 
1.9%
원형 58
 
1.3%
수박등 34
 
0.8%
갈매기형 27
 
0.6%
sts엠보싱돌기성형 26
 
0.6%
쌍구형 17
 
0.4%
Other values (2) 30
 
0.7%

등주높이
Real number (ℝ)

ZEROS 

Distinct11
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.256439
Minimum0
Maximum9
Zeros902
Zeros (%)20.2%
Negative0
Negative (%)0.0%
Memory size39.4 KiB
2023-12-11T07:54:34.963836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q15
median6.5
Q36.5
95-th percentile8
Maximum9
Range9
Interquartile range (IQR)1.5

Descriptive statistics

Standard deviation2.7622072
Coefficient of variation (CV)0.52549021
Kurtosis-0.17806819
Mean5.256439
Median Absolute Deviation (MAD)0.5
Skewness-1.1969235
Sum23470
Variance7.6297888
MonotonicityNot monotonic
2023-12-11T07:54:35.049652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
6.5 2137
47.9%
0.0 902
20.2%
8.0 578
 
12.9%
7.0 356
 
8.0%
5.0 333
 
7.5%
4.0 50
 
1.1%
6.0 36
 
0.8%
4.5 24
 
0.5%
3.5 22
 
0.5%
9.0 14
 
0.3%
ValueCountFrequency (%)
0.0 902
20.2%
3.5 22
 
0.5%
4.0 50
 
1.1%
4.5 24
 
0.5%
5.0 333
 
7.5%
5.5 13
 
0.3%
6.0 36
 
0.8%
6.5 2137
47.9%
7.0 356
 
8.0%
8.0 578
 
12.9%
ValueCountFrequency (%)
9.0 14
 
0.3%
8.0 578
 
12.9%
7.0 356
 
8.0%
6.5 2137
47.9%
6.0 36
 
0.8%
5.5 13
 
0.3%
5.0 333
 
7.5%
4.5 24
 
0.5%
4.0 50
 
1.1%
3.5 22
 
0.5%

등주형식
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size35.0 KiB
기본형
3882 
미분류
472 
2등형
 
101
보행등
 
9
4등형
 
1

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row기본형
2nd row기본형
3rd row기본형
4th row기본형
5th row기본형

Common Values

ValueCountFrequency (%)
기본형 3882
86.9%
미분류 472
 
10.6%
2등형 101
 
2.3%
보행등 9
 
0.2%
4등형 1
 
< 0.1%

Length

2023-12-11T07:54:35.146265image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:54:35.238531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기본형 3882
86.9%
미분류 472
 
10.6%
2등형 101
 
2.3%
보행등 9
 
0.2%
4등형 1
 
< 0.1%

등주재질
Categorical

Distinct7
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size35.0 KiB
스텐레스
1818 
주철
1690 
FRP
446 
미분류
434 
혼합주(주철+스텐레스)
 
37
Other values (2)
 
40

Length

Max length12
Median length4
Mean length3.0942889
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
스텐레스 1818
40.7%
주철 1690
37.8%
FRP 446
 
10.0%
미분류 434
 
9.7%
혼합주(주철+스텐레스) 37
 
0.8%
강관 33
 
0.7%
기타 7
 
0.2%

Length

2023-12-11T07:54:35.335768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:54:35.428209image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
스텐레스 1818
40.7%
주철 1690
37.8%
frp 446
 
10.0%
미분류 434
 
9.7%
혼합주(주철+스텐레스 37
 
0.8%
강관 33
 
0.7%
기타 7
 
0.2%

암길이
Real number (ℝ)

ZEROS 

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.3616797
Minimum0
Maximum2.8
Zeros872
Zeros (%)19.5%
Negative0
Negative (%)0.0%
Memory size39.4 KiB
2023-12-11T07:54:35.516958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11.2
median1.2
Q32
95-th percentile2.8
Maximum2.8
Range2.8
Interquartile range (IQR)0.8

Descriptive statistics

Standard deviation0.86857645
Coefficient of variation (CV)0.63787132
Kurtosis-0.8162163
Mean1.3616797
Median Absolute Deviation (MAD)0.8
Skewness-0.061888489
Sum6079.9
Variance0.75442505
MonotonicityNot monotonic
2023-12-11T07:54:35.594555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
1.2 2077
46.5%
0.0 872
19.5%
2.0 583
 
13.1%
2.5 567
 
12.7%
2.8 350
 
7.8%
1.5 16
 
0.4%
ValueCountFrequency (%)
0.0 872
19.5%
1.2 2077
46.5%
1.5 16
 
0.4%
2.0 583
 
13.1%
2.5 567
 
12.7%
2.8 350
 
7.8%
ValueCountFrequency (%)
2.8 350
 
7.8%
2.5 567
 
12.7%
2.0 583
 
13.1%
1.5 16
 
0.4%
1.2 2077
46.5%
0.0 872
19.5%

등기구수량
Categorical

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size35.0 KiB
1
3644 
0
553 
2
 
268

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 3644
81.6%
0 553
 
12.4%
2 268
 
6.0%

Length

2023-12-11T07:54:35.687021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:54:35.767740image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 3644
81.6%
0 553
 
12.4%
2 268
 
6.0%

광원종류
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size35.0 KiB
저압나트륨램프
3520 
미분류
434 
기타
 
309
수은램프
 
201
고압나트륨램프
 
1

Length

Max length7
Median length7
Mean length6.1301232
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row저압나트륨램프
2nd row저압나트륨램프
3rd row저압나트륨램프
4th row저압나트륨램프
5th row저압나트륨램프

Common Values

ValueCountFrequency (%)
저압나트륨램프 3520
78.8%
미분류 434
 
9.7%
기타 309
 
6.9%
수은램프 201
 
4.5%
고압나트륨램프 1
 
< 0.1%

Length

2023-12-11T07:54:35.862803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:54:35.956103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
저압나트륨램프 3520
78.8%
미분류 434
 
9.7%
기타 309
 
6.9%
수은램프 201
 
4.5%
고압나트륨램프 1
 
< 0.1%

점멸방식
Categorical

Distinct8
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size35.0 KiB
자동점멸기
2007 
배전함
1591 
속성나중입력
418 
기타
370 
미분류
 
60
Other values (3)
 
19

Length

Max length6
Median length5
Mean length4.0985442
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row자동점멸기
2nd row자동점멸기
3rd row배전함
4th row자동점멸기
5th row자동점멸기

Common Values

ValueCountFrequency (%)
자동점멸기 2007
44.9%
배전함 1591
35.6%
속성나중입력 418
 
9.4%
기타 370
 
8.3%
미분류 60
 
1.3%
수동 9
 
0.2%
센 스위치 6
 
0.1%
<NA> 4
 
0.1%

Length

2023-12-11T07:54:36.059860image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:54:36.161356image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
자동점멸기 2007
44.9%
배전함 1591
35.6%
속성나중입력 418
 
9.3%
기타 370
 
8.3%
미분류 60
 
1.3%
수동 9
 
0.2%
센 6
 
0.1%
스위치 6
 
0.1%
na 4
 
0.1%

배전함관리번호
Real number (ℝ)

MISSING 

Distinct17
Distinct (%)4.8%
Missing4109
Missing (%)92.0%
Infinite0
Infinite (%)0.0%
Mean279639.61
Minimum100063
Maximum293007
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size39.4 KiB
2023-12-11T07:54:36.261413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum100063
5-th percentile203001
Q1283002
median283007
Q3293005
95-th percentile293007
Maximum293007
Range192944
Interquartile range (IQR)10003

Descriptive statistics

Standard deviation31046.837
Coefficient of variation (CV)0.11102446
Kurtosis18.357472
Mean279639.61
Median Absolute Deviation (MAD)9995
Skewness-4.10438
Sum99551701
Variance9.6390611 × 108
MonotonicityNot monotonic
2023-12-11T07:54:36.358365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%)
283002 41
 
0.9%
293007 40
 
0.9%
293005 29
 
0.6%
293002 23
 
0.5%
293006 23
 
0.5%
283004 22
 
0.5%
283007 22
 
0.5%
283001 21
 
0.5%
293001 21
 
0.5%
283003 20
 
0.4%
Other values (7) 94
 
2.1%
(Missing) 4109
92.0%
ValueCountFrequency (%)
100063 6
 
0.1%
203001 20
0.4%
273001 12
 
0.3%
283001 21
0.5%
283002 41
0.9%
283003 20
0.4%
283004 22
0.5%
283005 17
0.4%
283006 13
 
0.3%
283007 22
0.5%
ValueCountFrequency (%)
293007 40
0.9%
293006 23
0.5%
293005 29
0.6%
293004 15
 
0.3%
293003 11
 
0.2%
293002 23
0.5%
293001 21
0.5%
283007 22
0.5%
283006 13
 
0.3%
283005 17
0.4%

가로등제어기관리번호
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size35.0 KiB
0
4465 

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

Length

2023-12-11T07:54:36.470084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:54:36.567474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 4465
100.0%

위도
Real number (ℝ)

Distinct4353
Distinct (%)97.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35.017248
Minimum34.920286
Maximum35.157638
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size39.4 KiB
2023-12-11T07:54:36.677918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum34.920286
5-th percentile34.92833
Q134.944813
median35.026894
Q335.066841
95-th percentile35.111067
Maximum35.157638
Range0.237352
Interquartile range (IQR)0.122028

Descriptive statistics

Standard deviation0.062259499
Coefficient of variation (CV)0.0017779666
Kurtosis-1.2660654
Mean35.017248
Median Absolute Deviation (MAD)0.045322
Skewness-0.13734303
Sum156352.01
Variance0.0038762452
MonotonicityNot monotonic
2023-12-11T07:54:36.822551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
35.061965 3
 
0.1%
35.064861 3
 
0.1%
35.061371 2
 
< 0.1%
35.057122 2
 
< 0.1%
35.057343 2
 
< 0.1%
35.057416 2
 
< 0.1%
35.057489 2
 
< 0.1%
34.934268 2
 
< 0.1%
35.11196 2
 
< 0.1%
35.054159 2
 
< 0.1%
Other values (4343) 4443
99.5%
ValueCountFrequency (%)
34.920286 1
< 0.1%
34.920396 1
< 0.1%
34.920535 1
< 0.1%
34.920644 1
< 0.1%
34.920789 1
< 0.1%
34.920898 1
< 0.1%
34.921037 1
< 0.1%
34.921146 1
< 0.1%
34.921325 1
< 0.1%
34.921435 1
< 0.1%
ValueCountFrequency (%)
35.157638 1
< 0.1%
35.157152 1
< 0.1%
35.15667 1
< 0.1%
35.153025 1
< 0.1%
35.152061 1
< 0.1%
35.151382 1
< 0.1%
35.150651 1
< 0.1%
35.149774 1
< 0.1%
35.149087 1
< 0.1%
35.148358 1
< 0.1%

경도
Real number (ℝ)

Distinct4319
Distinct (%)96.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean128.05776
Minimum127.93189
Maximum128.14619
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size39.4 KiB
2023-12-11T07:54:36.956959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.93189
5-th percentile127.9755
Q1128.04522
median128.06192
Q3128.07889
95-th percentile128.09646
Maximum128.14619
Range0.214299
Interquartile range (IQR)0.033666

Descriptive statistics

Standard deviation0.032663838
Coefficient of variation (CV)0.00025507113
Kurtosis3.1854965
Mean128.05776
Median Absolute Deviation (MAD)0.016804
Skewness-1.5760642
Sum571777.9
Variance0.0010669263
MonotonicityNot monotonic
2023-12-11T07:54:37.066172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
128.043945 3
 
0.1%
128.087258 3
 
0.1%
128.0393 3
 
0.1%
128.048017 3
 
0.1%
128.042243 2
 
< 0.1%
127.976142 2
 
< 0.1%
128.077345 2
 
< 0.1%
128.083924 2
 
< 0.1%
128.084073 2
 
< 0.1%
128.061427 2
 
< 0.1%
Other values (4309) 4441
99.5%
ValueCountFrequency (%)
127.931888 1
< 0.1%
127.932132 1
< 0.1%
127.932234 1
< 0.1%
127.932458 1
< 0.1%
127.93258 1
< 0.1%
127.932798 1
< 0.1%
127.932896 1
< 0.1%
127.933121 1
< 0.1%
127.933236 1
< 0.1%
127.933429 1
< 0.1%
ValueCountFrequency (%)
128.146187 1
< 0.1%
128.140879 1
< 0.1%
128.140734 1
< 0.1%
128.140053 1
< 0.1%
128.132245 1
< 0.1%
128.12672 1
< 0.1%
128.125198 1
< 0.1%
128.121405 1
< 0.1%
128.120597 1
< 0.1%
128.118048 1
< 0.1%

X좌표
Real number (ℝ)

Distinct4460
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean114002.19
Minimum102624.87
Maximum122096.7
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size39.4 KiB
2023-12-11T07:54:37.178054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum102624.87
5-th percentile106618.95
Q1112882.43
median114366.92
Q3115896.07
95-th percentile117524.29
Maximum122096.7
Range19471.839
Interquartile range (IQR)3013.645

Descriptive statistics

Standard deviation2958.7544
Coefficient of variation (CV)0.025953488
Kurtosis3.1402743
Mean114002.19
Median Absolute Deviation (MAD)1501.841
Skewness-1.5522349
Sum5.0901977 × 108
Variance8754227.6
MonotonicityNot monotonic
2023-12-11T07:54:37.313133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
114957.03 2
 
< 0.1%
114394.135 2
 
< 0.1%
113077.111 2
 
< 0.1%
113095.682 2
 
< 0.1%
113256.737 2
 
< 0.1%
114652.96 1
 
< 0.1%
114648.514 1
 
< 0.1%
114648.087 1
 
< 0.1%
114644.117 1
 
< 0.1%
114636.856 1
 
< 0.1%
Other values (4450) 4450
99.7%
ValueCountFrequency (%)
102624.865 1
< 0.1%
102647.338 1
< 0.1%
102656.509 1
< 0.1%
102677.118 1
< 0.1%
102688.098 1
< 0.1%
102708.137 1
< 0.1%
102716.92 1
< 0.1%
102737.67 1
< 0.1%
102747.95 1
< 0.1%
102765.81 1
< 0.1%
ValueCountFrequency (%)
122096.704 1
< 0.1%
121621.29 1
< 0.1%
121608.449 1
< 0.1%
121548.365 1
< 0.1%
120745.368 1
< 0.1%
120232.598 1
< 0.1%
120092.074 1
< 0.1%
119824.644 1
< 0.1%
119776.042 1
< 0.1%
119521.102 1
< 0.1%

Y좌표
Real number (ℝ)

Distinct4460
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean269414.72
Minimum258678.33
Maximum285080.71
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size39.4 KiB
2023-12-11T07:54:37.455298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum258678.33
5-th percentile259538.24
Q1261370.05
median270499.25
Q3274911.36
95-th percentile279930.52
Maximum285080.71
Range26402.376
Interquartile range (IQR)13541.31

Descriptive statistics

Standard deviation6917.1133
Coefficient of variation (CV)0.025674593
Kurtosis-1.2599376
Mean269414.72
Median Absolute Deviation (MAD)4988.31
Skewness-0.13520479
Sum1.2029367 × 109
Variance47846456
MonotonicityNot monotonic
2023-12-11T07:54:37.586381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
266467.102 2
 
< 0.1%
259704.683 2
 
< 0.1%
269727.805 2
 
< 0.1%
269692.445 2
 
< 0.1%
272061.156 2
 
< 0.1%
274124.868 1
 
< 0.1%
268505.608 1
 
< 0.1%
268482.021 1
 
< 0.1%
268579.092 1
 
< 0.1%
268458.607 1
 
< 0.1%
Other values (4450) 4450
99.7%
ValueCountFrequency (%)
258678.33 1
< 0.1%
258690.591 1
< 0.1%
258705.548 1
< 0.1%
258717.755 1
< 0.1%
258733.436 1
< 0.1%
258745.678 1
< 0.1%
258760.637 1
< 0.1%
258772.864 1
< 0.1%
258792.241 1
< 0.1%
258804.564 1
< 0.1%
ValueCountFrequency (%)
285080.706 1
< 0.1%
285026.548 1
< 0.1%
284972.796 1
< 0.1%
284552.62 1
< 0.1%
284446.033 1
< 0.1%
284371.569 1
< 0.1%
284291.043 1
< 0.1%
284194.089 1
< 0.1%
284118.545 1
< 0.1%
284037.984 1
< 0.1%

Sample

지형지물부호관리번호행정읍면동코드행정읍면동도엽번호관리기관도로구간번호공사번호등기구모형등주높이등주형식등주재질암길이등기구수량광원종류점멸방식배전함관리번호가로등제어기관리번호위도경도X좌표Y좌표
0가로등17502648240250사천읍358131750A사천시100259<NA>가오스형(신)5.0기본형스텐레스1.21저압나트륨램프자동점멸기<NA>035.05963128.047901113146.345274124.868
1가로등17502748240250사천읍358131750A사천시202802<NA>가오스형(신)5.0기본형스텐레스1.21저압나트륨램프자동점멸기<NA>035.068425128.046896113063.982275101.453
2가로등17502848240250사천읍358131750A사천시100262<NA>가오스형(신)5.0기본형스텐레스1.21저압나트륨램프배전함<NA>035.069345128.049002113257.1275201.792
3가로등17722748240320사남면358131761D사천시100102<NA>세종형대형6.5기본형주철1.21저압나트륨램프자동점멸기<NA>035.071501128.058358114112.711275432.886
4가로등17722848240320사남면358131761D사천시100102<NA>세종형대형6.5기본형주철1.21저압나트륨램프자동점멸기<NA>035.07095128.060487114306.361275369.881
5가로등17722948240320사남면358131761D사천시100102<NA>세종형대형6.5기본형주철1.21저압나트륨램프자동점멸기<NA>035.071381128.058821114154.88275419.169
6가로등17723048240320사남면358131761D사천시100102<NA>세종형대형6.5기본형주철1.21저압나트륨램프자동점멸기<NA>035.06327128.042958112699.26274533.029
7가로등17723148240320사남면358131771B사천시100102<NA>세종형대형6.5기본형주철1.21저압나트륨램프자동점멸기<NA>035.071363128.066378114844.137275410.695
8가로등17723248240320사남면358131772A사천시200312<NA>세종형대형6.5기본형주철1.21저압나트륨램프자동점멸기<NA>035.069395128.065734114783.324275192.887
9가로등17723348240320사남면358131772A사천시200314<NA>세종형대형6.5기본형주철1.21저압나트륨램프자동점멸기<NA>035.069745128.065136114729.153275232.241
지형지물부호관리번호행정읍면동코드행정읍면동도엽번호관리기관도로구간번호공사번호등기구모형등주높이등주형식등주재질암길이등기구수량광원종류점멸방식배전함관리번호가로등제어기관리번호위도경도X좌표Y좌표
4455가로등19402048240330용현면358132158A사천시194059<NA>기타8.0기본형강관2.01기타자동점멸기<NA>035.023397128.036563112073.17270114.809
4456가로등19402148240330용현면358132158A사천시194059<NA>기타8.0기본형강관2.01기타자동점멸기<NA>035.022981128.036718112086.876270068.53
4457가로등19402248240550벌용동348010736A사천시194002<NA>가오스형(신)8.0기본형스텐레스2.01기타자동점멸기<NA>034.93487128.076174115597.622260259.052
4458가로등19402348240550벌용동348010726C사천시194002<NA>가오스형(신)8.0기본형스텐레스2.01기타자동점멸기<NA>034.935119128.07649115626.731260286.361
4459가로등19402448240550벌용동348010726C사천시194002<NA>가오스형(신)8.0기본형스텐레스2.01기타자동점멸기<NA>034.935409128.076753115651.009260318.348
4460가로등19402548240550벌용동348010726C사천시194002<NA>가오스형(신)8.0기본형스텐레스2.01기타자동점멸기<NA>034.935742128.076934115667.863260355.103
4461가로등19402648240550벌용동348010726C사천시194002<NA>가오스형(신)8.0기본형스텐레스2.01기타자동점멸기<NA>034.936087128.077059115679.668260393.323
4462가로등19402748240550벌용동348010726C사천시194002<NA>가오스형(신)8.0기본형스텐레스2.01기타자동점멸기<NA>034.936445128.07701115675.602260433.045
4463가로등19402848240550벌용동348010726C사천시194002<NA>가오스형(신)8.0기본형스텐레스2.01기타자동점멸기<NA>034.936792128.076929115668.508260471.593
4464가로등19402948240550벌용동348010726C사천시194002<NA>기타8.0기본형스텐레스2.01기타자동점멸기<NA>034.937003128.076822115658.991260495.123