Overview

Dataset statistics

Number of variables12
Number of observations7150
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory726.3 KiB
Average record size in memory104.0 B

Variable types

Numeric4
Text2
Categorical6

Dataset

Description경상남도 거제시 가로등(표찰번호, 종류, 지번주소, 위도, 경도, CDM램프, 나트륨램프, LED램프, 합계, 설치년도) 내역 제공
Author경상남도 거제시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15020452

Alerts

종류 has constant value ""Constant
데이터기준일자 has constant value ""Constant
엘이디램프 is highly overall correlated with 합계High correlation
합계 is highly overall correlated with 씨디엠램프 and 2 other fieldsHigh correlation
나트륨램프 is highly overall correlated with 순번 and 4 other fieldsHigh correlation
씨디엠램프 is highly overall correlated with 순번 and 4 other fieldsHigh correlation
순번 is highly overall correlated with 경도 and 2 other fieldsHigh correlation
위도 is highly overall correlated with 씨디엠램프 and 1 other fieldsHigh correlation
경도 is highly overall correlated with 순번 and 2 other fieldsHigh correlation
설치년도 is highly overall correlated with 씨디엠램프 and 1 other fieldsHigh correlation
합계 is highly imbalanced (91.4%)Imbalance
순번 has unique valuesUnique
표찰번호 has unique valuesUnique

Reproduction

Analysis started2023-12-10 23:20:38.389276
Analysis finished2023-12-10 23:20:41.129713
Duration2.74 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct7150
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3575.5
Minimum1
Maximum7150
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size63.0 KiB
2023-12-11T08:20:41.209268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile358.45
Q11788.25
median3575.5
Q35362.75
95-th percentile6792.55
Maximum7150
Range7149
Interquartile range (IQR)3574.5

Descriptive statistics

Standard deviation2064.1715
Coefficient of variation (CV)0.5773099
Kurtosis-1.2
Mean3575.5
Median Absolute Deviation (MAD)1787.5
Skewness0
Sum25564825
Variance4260804.2
MonotonicityStrictly increasing
2023-12-11T08:20:41.344239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
4764 1
 
< 0.1%
4775 1
 
< 0.1%
4774 1
 
< 0.1%
4773 1
 
< 0.1%
4772 1
 
< 0.1%
4771 1
 
< 0.1%
4770 1
 
< 0.1%
4769 1
 
< 0.1%
4768 1
 
< 0.1%
Other values (7140) 7140
99.9%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
7150 1
< 0.1%
7149 1
< 0.1%
7148 1
< 0.1%
7147 1
< 0.1%
7146 1
< 0.1%
7145 1
< 0.1%
7144 1
< 0.1%
7143 1
< 0.1%
7142 1
< 0.1%
7141 1
< 0.1%

표찰번호
Text

UNIQUE 

Distinct7150
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size56.0 KiB
2023-12-11T08:20:41.607885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length7
Mean length7.1416783
Min length7

Characters and Unicode

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

Unique

Unique7150 ?
Unique (%)100.0%

Sample

1st row거제면0027
2nd row거제면0028
3rd row거제면0029
4th row거제면0030
5th row거제면0031
ValueCountFrequency (%)
거제면0027 1
 
< 0.1%
옥포2동0251 1
 
< 0.1%
옥포2동0262 1
 
< 0.1%
옥포2동0261 1
 
< 0.1%
옥포2동0260 1
 
< 0.1%
옥포2동0259 1
 
< 0.1%
옥포2동0258 1
 
< 0.1%
옥포2동0257 1
 
< 0.1%
옥포2동0256 1
 
< 0.1%
옥포2동0255 1
 
< 0.1%
Other values (7140) 7140
99.9%
2023-12-11T08:20:41.994511image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 8262
16.2%
1 3976
 
7.8%
3759
 
7.4%
3577
 
7.0%
2 2800
 
5.5%
3 2330
 
4.6%
4 2261
 
4.4%
5 2162
 
4.2%
6 2134
 
4.2%
7 1973
 
3.9%
Other values (31) 17829
34.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 29288
57.4%
Other Letter 21775
42.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
3759
17.3%
3577
16.4%
1291
 
5.9%
1174
 
5.4%
755
 
3.5%
755
 
3.5%
726
 
3.3%
726
 
3.3%
688
 
3.2%
551
 
2.5%
Other values (21) 7773
35.7%
Decimal Number
ValueCountFrequency (%)
0 8262
28.2%
1 3976
13.6%
2 2800
 
9.6%
3 2330
 
8.0%
4 2261
 
7.7%
5 2162
 
7.4%
6 2134
 
7.3%
7 1973
 
6.7%
8 1718
 
5.9%
9 1672
 
5.7%

Most occurring scripts

ValueCountFrequency (%)
Common 29288
57.4%
Hangul 21775
42.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
3759
17.3%
3577
16.4%
1291
 
5.9%
1174
 
5.4%
755
 
3.5%
755
 
3.5%
726
 
3.3%
726
 
3.3%
688
 
3.2%
551
 
2.5%
Other values (21) 7773
35.7%
Common
ValueCountFrequency (%)
0 8262
28.2%
1 3976
13.6%
2 2800
 
9.6%
3 2330
 
8.0%
4 2261
 
7.7%
5 2162
 
7.4%
6 2134
 
7.3%
7 1973
 
6.7%
8 1718
 
5.9%
9 1672
 
5.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 29288
57.4%
Hangul 21775
42.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 8262
28.2%
1 3976
13.6%
2 2800
 
9.6%
3 2330
 
8.0%
4 2261
 
7.7%
5 2162
 
7.4%
6 2134
 
7.3%
7 1973
 
6.7%
8 1718
 
5.9%
9 1672
 
5.7%
Hangul
ValueCountFrequency (%)
3759
17.3%
3577
16.4%
1291
 
5.9%
1174
 
5.4%
755
 
3.5%
755
 
3.5%
726
 
3.3%
726
 
3.3%
688
 
3.2%
551
 
2.5%
Other values (21) 7773
35.7%

종류
Categorical

CONSTANT 

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

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

Length

2023-12-11T08:20:42.151142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T08:20:42.294022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가로등 7150
100.0%
Distinct6262
Distinct (%)87.6%
Missing0
Missing (%)0.0%
Memory size56.0 KiB
2023-12-11T08:20:42.645514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length24
Mean length20.261399
Min length14

Characters and Unicode

Total characters144869
Distinct characters111
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

Unique5657 ?
Unique (%)79.1%

Sample

1st row경상남도 거제시 거제면 동상리 613-10
2nd row경상남도 거제시 거제면 동상리 616-3
3rd row경상남도 거제시 거제면 동상리 618-8
4th row경상남도 거제시 거제면 동상리 620-1
5th row경상남도 거제시 거제면 동상리 671-2
ValueCountFrequency (%)
경상남도 7151
22.2%
거제시 7146
22.2%
사등면 778
 
2.4%
고현동 668
 
2.1%
연초면 560
 
1.7%
장목면 546
 
1.7%
일운면 541
 
1.7%
옥포동 460
 
1.4%
아주동 443
 
1.4%
장평동 416
 
1.3%
Other values (5623) 13512
41.9%
2023-12-11T08:20:43.171264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
25071
17.3%
7562
 
5.2%
7527
 
5.2%
7519
 
5.2%
7427
 
5.1%
7152
 
4.9%
7151
 
4.9%
7151
 
4.9%
- 6269
 
4.3%
1 6078
 
4.2%
Other values (101) 55962
38.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 84071
58.0%
Decimal Number 29458
 
20.3%
Space Separator 25071
 
17.3%
Dash Punctuation 6269
 
4.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
7562
 
9.0%
7527
 
9.0%
7519
 
8.9%
7427
 
8.8%
7152
 
8.5%
7151
 
8.5%
7151
 
8.5%
4437
 
5.3%
3591
 
4.3%
3589
 
4.3%
Other values (89) 20965
24.9%
Decimal Number
ValueCountFrequency (%)
1 6078
20.6%
2 3998
13.6%
3 3043
10.3%
4 2689
9.1%
5 2534
8.6%
8 2288
 
7.8%
7 2277
 
7.7%
6 2276
 
7.7%
9 2227
 
7.6%
0 2048
 
7.0%
Space Separator
ValueCountFrequency (%)
25071
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6269
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 84071
58.0%
Common 60798
42.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
7562
 
9.0%
7527
 
9.0%
7519
 
8.9%
7427
 
8.8%
7152
 
8.5%
7151
 
8.5%
7151
 
8.5%
4437
 
5.3%
3591
 
4.3%
3589
 
4.3%
Other values (89) 20965
24.9%
Common
ValueCountFrequency (%)
25071
41.2%
- 6269
 
10.3%
1 6078
 
10.0%
2 3998
 
6.6%
3 3043
 
5.0%
4 2689
 
4.4%
5 2534
 
4.2%
8 2288
 
3.8%
7 2277
 
3.7%
6 2276
 
3.7%
Other values (2) 4275
 
7.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 84071
58.0%
ASCII 60798
42.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
25071
41.2%
- 6269
 
10.3%
1 6078
 
10.0%
2 3998
 
6.6%
3 3043
 
5.0%
4 2689
 
4.4%
5 2534
 
4.2%
8 2288
 
3.8%
7 2277
 
3.7%
6 2276
 
3.7%
Other values (2) 4275
 
7.0%
Hangul
ValueCountFrequency (%)
7562
 
9.0%
7527
 
9.0%
7519
 
8.9%
7427
 
8.8%
7152
 
8.5%
7151
 
8.5%
7151
 
8.5%
4437
 
5.3%
3591
 
4.3%
3589
 
4.3%
Other values (89) 20965
24.9%

위도
Real number (ℝ)

HIGH CORRELATION 

Distinct7120
Distinct (%)99.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean34.882558
Minimum34.713487
Maximum35.031272
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size63.0 KiB
2023-12-11T08:20:43.316079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum34.713487
5-th percentile34.793044
Q134.86508
median34.886452
Q334.903068
95-th percentile34.979639
Maximum35.031272
Range0.3177852
Interquartile range (IQR)0.037987325

Descriptive statistics

Standard deviation0.051271914
Coefficient of variation (CV)0.0014698439
Kurtosis1.9590058
Mean34.882558
Median Absolute Deviation (MAD)0.0199918
Skewness-0.36588874
Sum249410.29
Variance0.0026288092
MonotonicityNot monotonic
2023-12-11T08:20:43.678177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
34.8673733 2
 
< 0.1%
34.8820569 2
 
< 0.1%
34.8879838 2
 
< 0.1%
34.8660152 2
 
< 0.1%
34.8763593 2
 
< 0.1%
34.8296996 2
 
< 0.1%
34.867506 2
 
< 0.1%
34.8671644 2
 
< 0.1%
34.835429 2
 
< 0.1%
34.8948201 2
 
< 0.1%
Other values (7110) 7130
99.7%
ValueCountFrequency (%)
34.7134867 1
< 0.1%
34.7135841 1
< 0.1%
34.7137588 1
< 0.1%
34.713862 1
< 0.1%
34.7142369 1
< 0.1%
34.7146725 1
< 0.1%
34.715188 1
< 0.1%
34.7152206 1
< 0.1%
34.7155005 1
< 0.1%
34.7158386 1
< 0.1%
ValueCountFrequency (%)
35.0312719 1
< 0.1%
35.031066 1
< 0.1%
35.0309876 1
< 0.1%
35.0309248 1
< 0.1%
35.0309089 1
< 0.1%
35.0307578 1
< 0.1%
35.0307287 1
< 0.1%
35.0306131 1
< 0.1%
35.0305894 1
< 0.1%
35.0304926 1
< 0.1%

경도
Real number (ℝ)

HIGH CORRELATION 

Distinct6977
Distinct (%)97.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean128.64254
Minimum128.47041
Maximum128.74268
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size63.0 KiB
2023-12-11T08:20:43.831310image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum128.47041
5-th percentile128.52337
Q1128.60916
median128.6419
Q3128.69458
95-th percentile128.72329
Maximum128.74268
Range0.272267
Interquartile range (IQR)0.08542125

Descriptive statistics

Standard deviation0.060098701
Coefficient of variation (CV)0.00046717597
Kurtosis-0.23983212
Mean128.64254
Median Absolute Deviation (MAD)0.047541
Skewness-0.59237132
Sum919794.13
Variance0.0036118539
MonotonicityNot monotonic
2023-12-11T08:20:43.990911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
128.70379 4
 
0.1%
128.578439 3
 
< 0.1%
128.634313 3
 
< 0.1%
128.701847 3
 
< 0.1%
128.63483 3
 
< 0.1%
128.706081 2
 
< 0.1%
128.605065 2
 
< 0.1%
128.642872 2
 
< 0.1%
128.641831 2
 
< 0.1%
128.681795 2
 
< 0.1%
Other values (6967) 7124
99.6%
ValueCountFrequency (%)
128.470412 1
< 0.1%
128.470641 1
< 0.1%
128.471146 1
< 0.1%
128.471506 1
< 0.1%
128.471935 1
< 0.1%
128.472383 1
< 0.1%
128.472809 1
< 0.1%
128.473186 1
< 0.1%
128.473232 1
< 0.1%
128.473297 1
< 0.1%
ValueCountFrequency (%)
128.742679 1
< 0.1%
128.74265 1
< 0.1%
128.742632 1
< 0.1%
128.742592 1
< 0.1%
128.742571 1
< 0.1%
128.74241 1
< 0.1%
128.742376 1
< 0.1%
128.742259 1
< 0.1%
128.742175 1
< 0.1%
128.742041 1
< 0.1%

씨디엠램프
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size56.0 KiB
1
4344 
<NA>
2806 

Length

Max length4
Median length1
Mean length2.1773427
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 4344
60.8%
<NA> 2806
39.2%

Length

2023-12-11T08:20:44.121719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T08:20:44.237885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 4344
60.8%
na 2806
39.2%

나트륨램프
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size56.0 KiB
<NA>
6322 
1
828 

Length

Max length4
Median length4
Mean length3.6525874
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 6322
88.4%
1 828
 
11.6%

Length

2023-12-11T08:20:44.361092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T08:20:44.464908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 6322
88.4%
1 828
 
11.6%

엘이디램프
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size56.0 KiB
<NA>
5172 
1
1901 
2
 
77

Length

Max length4
Median length4
Mean length3.1700699
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 5172
72.3%
1 1901
 
26.6%
2 77
 
1.1%

Length

2023-12-11T08:20:44.590780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T08:20:44.716765image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 5172
72.3%
1 1901
 
26.6%
2 77
 
1.1%

합계
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size56.0 KiB
1
7073 
2
 
77

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 7073
98.9%
2 77
 
1.1%

Length

2023-12-11T08:20:44.838974image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T08:20:44.949013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 7073
98.9%
2 77
 
1.1%

설치년도
Real number (ℝ)

HIGH CORRELATION 

Distinct27
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1986.653
Minimum1905
Maximum2021
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size63.0 KiB
2023-12-11T08:20:45.049707image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1905
5-th percentile1905
Q11998
median2005
Q32011
95-th percentile2019
Maximum2021
Range116
Interquartile range (IQR)13

Descriptive statistics

Standard deviation41.636186
Coefficient of variation (CV)0.020957956
Kurtosis0.085061766
Mean1986.653
Median Absolute Deviation (MAD)7
Skewness-1.3984741
Sum14204569
Variance1733.572
MonotonicityNot monotonic
2023-12-11T08:20:45.218073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
1905 1450
20.3%
1998 788
 
11.0%
2009 431
 
6.0%
2008 411
 
5.7%
2006 399
 
5.6%
2004 377
 
5.3%
2014 318
 
4.4%
2005 303
 
4.2%
2015 302
 
4.2%
1997 274
 
3.8%
Other values (17) 2097
29.3%
ValueCountFrequency (%)
1905 1450
20.3%
1993 1
 
< 0.1%
1995 5
 
0.1%
1997 274
 
3.8%
1998 788
11.0%
2000 140
 
2.0%
2001 147
 
2.1%
2002 117
 
1.6%
2003 116
 
1.6%
2004 377
 
5.3%
ValueCountFrequency (%)
2021 79
 
1.1%
2020 145
2.0%
2019 236
3.3%
2018 24
 
0.3%
2017 238
3.3%
2016 39
 
0.5%
2015 302
4.2%
2014 318
4.4%
2013 145
2.0%
2012 167
2.3%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size56.0 KiB
2021-09-07
7150 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-09-07
2nd row2021-09-07
3rd row2021-09-07
4th row2021-09-07
5th row2021-09-07

Common Values

ValueCountFrequency (%)
2021-09-07 7150
100.0%

Length

2023-12-11T08:20:45.382733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T08:20:45.481229image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-09-07 7150
100.0%

Interactions

2023-12-11T08:20:40.423471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:39.176606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:39.572873image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:40.039612image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:40.518970image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:39.264433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:39.680304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:40.139884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:40.627941image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:39.360836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:39.824286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:40.232082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:40.727682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:39.473472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:39.919894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:40.324909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T08:20:45.541173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번위도경도엘이디램프합계설치년도
순번1.0000.8530.8750.6410.4050.420
위도0.8531.0000.6630.3390.1620.273
경도0.8750.6631.0000.5230.2540.470
엘이디램프0.6410.3390.5231.0001.0000.090
합계0.4050.1620.2541.0001.0000.097
설치년도0.4200.2730.4700.0900.0971.000
2023-12-11T08:20:45.639176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
엘이디램프합계나트륨램프씨디엠램프
엘이디램프1.0000.993NaNNaN
합계0.9931.0001.0001.000
나트륨램프NaN1.0001.000NaN
씨디엠램프NaN1.000NaN1.000
2023-12-11T08:20:45.748705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번위도경도설치년도씨디엠램프나트륨램프엘이디램프합계
순번1.0000.2930.529-0.1621.0001.0000.4960.311
위도0.2931.000-0.044-0.1991.0001.0000.2590.124
경도0.529-0.0441.000-0.2791.0001.0000.4030.194
설치년도-0.162-0.199-0.2791.0001.0001.0000.1790.168
씨디엠램프1.0001.0001.0001.0001.0000.0000.0001.000
나트륨램프1.0001.0001.0001.0000.0001.0000.0001.000
엘이디램프0.4960.2590.4030.1790.0000.0001.0000.993
합계0.3110.1240.1940.1681.0001.0000.9931.000

Missing values

2023-12-11T08:20:40.869039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T08:20:41.046572image/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

순번표찰번호종류지번주소위도경도씨디엠램프나트륨램프엘이디램프합계설치년도데이터기준일자
01거제면0027가로등경상남도 거제시 거제면 동상리 613-1034.849367128.592788<NA><NA>1119972021-09-07
12거제면0028가로등경상남도 거제시 거제면 동상리 616-334.848932128.593072<NA><NA>1119972021-09-07
23거제면0029가로등경상남도 거제시 거제면 동상리 618-834.848526128.593324<NA><NA>1119972021-09-07
34거제면0030가로등경상남도 거제시 거제면 동상리 620-134.848222128.593536<NA><NA>1119972021-09-07
45거제면0031가로등경상남도 거제시 거제면 동상리 671-234.847926128.593764<NA><NA>1119972021-09-07
56거제면0032가로등경상남도 거제시 거제면 동상리 717-1734.847593128.593979<NA><NA>1119972021-09-07
67거제면0091가로등경상남도 거제시 거제면 남동리 151-4934.847443128.5904171<NA><NA>119982021-09-07
78거제면0092가로등경상남도 거제시 거제면 남동리 29-40134.84748128.5918141<NA><NA>119982021-09-07
89거제면0093가로등경상남도 거제시 거제면 남동리 29-40534.847451128.5931811<NA><NA>119982021-09-07
910거제면0094가로등경상남도 거제시 거제면 남동리 29-43334.847236128.594007<NA><NA>1119982021-09-07
순번표찰번호종류지번주소위도경도씨디엠램프나트륨램프엘이디램프합계설치년도데이터기준일자
71407141하청면0947가로등경상남도 거제시 하청면 대곡리 83335.007615128.627841<NA><NA>1120172021-09-07
71417142하청면0948가로등경상남도 거제시 하청면 대곡리 산10435.007878128.627482<NA><NA>1120172021-09-07
71427143하청면0949가로등경상남도 거제시 하청면 대곡리 산104-135.008141128.62721<NA><NA>1120172021-09-07
71437144하청면0950가로등경상남도 거제시 하청면 대곡리 산104-135.008459128.626967<NA><NA>1120172021-09-07
71447145하청면0951가로등경상남도 거제시 하청면 대곡리 산105-235.008891128.626755<NA><NA>1120172021-09-07
71457146하청면0977가로등경상남도 거제시 하청면 실전리 산67-434.975412128.653838<NA><NA>1120192021-09-07
71467147하청면0984가로등경상남도 거제시 하청면 하청리 529-134.957824128.656678<NA><NA>1120192021-09-07
71477148하청면0986가로등경상남도 거제시 하청면 하청리 53934.958339128.657523<NA><NA>1120192021-09-07
71487149하청면1008가로등경상남도 거제시 연초면 한내리 산16-134.944838128.598153<NA><NA>1120202021-09-07
71497150하청면1024가로등경상남도 거제시 하청면 유계리 12-1834.959598128.646316<NA><NA>1120202021-09-07