Overview

Dataset statistics

Number of variables12
Number of observations6892
Missing cells328
Missing cells (%)0.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory700.1 KiB
Average record size in memory104.0 B

Variable types

Numeric4
Text2
Categorical5
DateTime1

Dataset

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

Alerts

종류 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 2 other fieldsHigh correlation
위도 is highly overall correlated with 나트륨램프High correlation
경도 is highly overall correlated with 순번 and 1 other fieldsHigh correlation
설치년도 is highly overall correlated with 나트륨램프High correlation
씨디엠램프 is highly overall correlated with 순번 and 1 other fieldsHigh correlation
합계 is highly imbalanced (82.7%)Imbalance
순번 has 322 (4.7%) missing valuesMissing
표찰번호 has unique valuesUnique

Reproduction

Analysis started2023-12-10 23:20:25.509246
Analysis finished2023-12-10 23:20:29.470428
Duration3.96 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct6570
Distinct (%)100.0%
Missing322
Missing (%)4.7%
Infinite0
Infinite (%)0.0%
Mean3565.482
Minimum1
Maximum7146
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size60.7 KiB
2023-12-11T08:20:29.556402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile338.45
Q11821.25
median3568.5
Q35290.75
95-th percentile6796.55
Maximum7146
Range7145
Interquartile range (IQR)3469.5

Descriptive statistics

Standard deviation2039.0997
Coefficient of variation (CV)0.57190014
Kurtosis-1.1593325
Mean3565.482
Median Absolute Deviation (MAD)1736.5
Skewness-0.00053793987
Sum23425217
Variance4157927.5
MonotonicityStrictly increasing
2023-12-11T08:20:29.764487image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4713 1
 
< 0.1%
4723 1
 
< 0.1%
4722 1
 
< 0.1%
4721 1
 
< 0.1%
4720 1
 
< 0.1%
4719 1
 
< 0.1%
4718 1
 
< 0.1%
4717 1
 
< 0.1%
4716 1
 
< 0.1%
4715 1
 
< 0.1%
Other values (6560) 6560
95.2%
(Missing) 322
 
4.7%
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 (%)
7146 1
< 0.1%
7145 1
< 0.1%
7144 1
< 0.1%
7143 1
< 0.1%
7142 1
< 0.1%
7141 1
< 0.1%
7140 1
< 0.1%
7139 1
< 0.1%
7138 1
< 0.1%
7137 1
< 0.1%

표찰번호
Text

UNIQUE 

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

Length

Max length8
Median length7
Mean length7.1349391
Min length7

Characters and Unicode

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

Unique6892 ?
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동0202 1
 
< 0.1%
옥포2동0200 1
 
< 0.1%
옥포2동0199 1
 
< 0.1%
옥포2동0198 1
 
< 0.1%
옥포2동0197 1
 
< 0.1%
옥포2동0196 1
 
< 0.1%
옥포2동0195 1
 
< 0.1%
옥포2동0189 1
 
< 0.1%
옥포2동0188 1
 
< 0.1%
Other values (6882) 6882
99.9%
2023-12-11T08:20:30.531979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 7709
15.7%
1 4097
 
8.3%
동 3634
 
7.4%
면 3435
 
7.0%
2 2682
 
5.5%
3 2239
 
4.6%
4 2152
 
4.4%
5 2089
 
4.2%
6 2009
 
4.1%
7 1897
 
3.9%
Other values (31) 17231
35.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 28224
57.4%
Other Letter 20950
42.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 3634
17.3%
면 3435
16.4%
장 1174
 
5.6%
포 1077
 
5.1%
현 769
 
3.7%
고 769
 
3.7%
등 712
 
3.4%
사 712
 
3.4%
옥 656
 
3.1%
연 544
 
2.6%
Other values (21) 7468
35.6%
Decimal Number
ValueCountFrequency (%)
0 7709
27.3%
1 4097
14.5%
2 2682
 
9.5%
3 2239
 
7.9%
4 2152
 
7.6%
5 2089
 
7.4%
6 2009
 
7.1%
7 1897
 
6.7%
8 1717
 
6.1%
9 1633
 
5.8%

Most occurring scripts

ValueCountFrequency (%)
Common 28224
57.4%
Hangul 20950
42.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 3634
17.3%
면 3435
16.4%
장 1174
 
5.6%
포 1077
 
5.1%
현 769
 
3.7%
고 769
 
3.7%
등 712
 
3.4%
사 712
 
3.4%
옥 656
 
3.1%
연 544
 
2.6%
Other values (21) 7468
35.6%
Common
ValueCountFrequency (%)
0 7709
27.3%
1 4097
14.5%
2 2682
 
9.5%
3 2239
 
7.9%
4 2152
 
7.6%
5 2089
 
7.4%
6 2009
 
7.1%
7 1897
 
6.7%
8 1717
 
6.1%
9 1633
 
5.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 28224
57.4%
Hangul 20950
42.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 7709
27.3%
1 4097
14.5%
2 2682
 
9.5%
3 2239
 
7.9%
4 2152
 
7.6%
5 2089
 
7.4%
6 2009
 
7.1%
7 1897
 
6.7%
8 1717
 
6.1%
9 1633
 
5.8%
Hangul
ValueCountFrequency (%)
동 3634
17.3%
면 3435
16.4%
장 1174
 
5.6%
포 1077
 
5.1%
현 769
 
3.7%
고 769
 
3.7%
등 712
 
3.4%
사 712
 
3.4%
옥 656
 
3.1%
연 544
 
2.6%
Other values (21) 7468
35.6%

종류
Categorical

CONSTANT 

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

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

Length

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

Common Values (Plot)

2023-12-11T08:20:30.804370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가로등 6892
100.0%

지번주소
Text

Distinct5873
Distinct (%)85.2%
Missing0
Missing (%)0.0%
Memory size54.0 KiB
2023-12-11T08:20:31.132401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length24
Mean length20.205891
Min length14

Characters and Unicode

Total characters139259
Distinct characters109
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

Unique5283 ?
Unique (%)76.7%

Sample

1st row경상남도 거제시 거제면 동상리 613-10
2nd row경상남도 거제시 거제면 동상리 616-3
3rd row경상남도 거제시 거제면 동상리 618-8
4th row경상남도 거제시 거제면 동상리 620-1
5th row경상남도 거제시 거제면 동상리 671-2
ValueCountFrequency (%)
거제시 6888
22.2%
경상남도 6879
22.2%
사등면 734
 
2.4%
고현동 716
 
2.3%
연초면 547
 
1.8%
일운면 535
 
1.7%
장목면 533
 
1.7%
옥포동 430
 
1.4%
아주동 418
 
1.3%
장평동 362
 
1.2%
Other values (5296) 12986
41.9%
2023-12-11T08:20:31.670260image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
24136
17.3%
상 7291
 
5.2%
거 7243
 
5.2%
제 7242
 
5.2%
남 7153
 
5.1%
시 6893
 
4.9%
경 6879
 
4.9%
도 6879
 
4.9%
1 6054
 
4.3%
- 5891
 
4.2%
Other values (99) 53598
38.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 80928
58.1%
Decimal Number 28304
 
20.3%
Space Separator 24136
 
17.3%
Dash Punctuation 5891
 
4.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
상 7291
 
9.0%
거 7243
 
8.9%
제 7242
 
8.9%
남 7153
 
8.8%
시 6893
 
8.5%
경 6879
 
8.5%
도 6879
 
8.5%
동 4362
 
5.4%
면 3444
 
4.3%
리 3441
 
4.3%
Other values (87) 20101
24.8%
Decimal Number
ValueCountFrequency (%)
1 6054
21.4%
2 3792
13.4%
3 2869
10.1%
4 2559
9.0%
5 2427
8.6%
8 2324
 
8.2%
6 2130
 
7.5%
7 2129
 
7.5%
9 2068
 
7.3%
0 1952
 
6.9%
Space Separator
ValueCountFrequency (%)
24136
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5891
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 80928
58.1%
Common 58331
41.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
상 7291
 
9.0%
거 7243
 
8.9%
제 7242
 
8.9%
남 7153
 
8.8%
시 6893
 
8.5%
경 6879
 
8.5%
도 6879
 
8.5%
동 4362
 
5.4%
면 3444
 
4.3%
리 3441
 
4.3%
Other values (87) 20101
24.8%
Common
ValueCountFrequency (%)
24136
41.4%
1 6054
 
10.4%
- 5891
 
10.1%
2 3792
 
6.5%
3 2869
 
4.9%
4 2559
 
4.4%
5 2427
 
4.2%
8 2324
 
4.0%
6 2130
 
3.7%
7 2129
 
3.6%
Other values (2) 4020
 
6.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 80928
58.1%
ASCII 58331
41.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
24136
41.4%
1 6054
 
10.4%
- 5891
 
10.1%
2 3792
 
6.5%
3 2869
 
4.9%
4 2559
 
4.4%
5 2427
 
4.2%
8 2324
 
4.0%
6 2130
 
3.7%
7 2129
 
3.6%
Other values (2) 4020
 
6.9%
Hangul
ValueCountFrequency (%)
상 7291
 
9.0%
거 7243
 
8.9%
제 7242
 
8.9%
남 7153
 
8.8%
시 6893
 
8.5%
경 6879
 
8.5%
도 6879
 
8.5%
동 4362
 
5.4%
면 3444
 
4.3%
리 3441
 
4.3%
Other values (87) 20101
24.8%

위도
Real number (ℝ)

HIGH CORRELATION 

Distinct6816
Distinct (%)98.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean34.882605
Minimum34.709939
Maximum35.031272
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size60.7 KiB
2023-12-11T08:20:31.830959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum34.709939
5-th percentile34.790796
Q134.864861
median34.88672
Q334.902905
95-th percentile34.980817
Maximum35.031272
Range0.3213328
Interquartile range (IQR)0.038043725

Descriptive statistics

Standard deviation0.051466664
Coefficient of variation (CV)0.0014754249
Kurtosis1.9923198
Mean34.882605
Median Absolute Deviation (MAD)0.0202148
Skewness-0.37606309
Sum240410.91
Variance0.0026488175
MonotonicityNot monotonic
2023-12-11T08:20:32.016789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
34.8864695 2
 
< 0.1%
34.7299901 2
 
< 0.1%
34.8970929 2
 
< 0.1%
34.891107 2
 
< 0.1%
34.9013928 2
 
< 0.1%
34.9031445 2
 
< 0.1%
34.8673733 2
 
< 0.1%
34.8831002 2
 
< 0.1%
34.8657455 2
 
< 0.1%
34.8955734 2
 
< 0.1%
Other values (6806) 6872
99.7%
ValueCountFrequency (%)
34.7099391 1
< 0.1%
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%
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 

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

Quantile statistics

Minimum128.47041
5-th percentile128.52501
Q1128.61049
median128.64172
Q3128.69361
95-th percentile128.72209
Maximum128.74268
Range0.272267
Interquartile range (IQR)0.0831195

Descriptive statistics

Standard deviation0.058880091
Coefficient of variation (CV)0.00045770256
Kurtosis-0.17003891
Mean128.6427
Median Absolute Deviation (MAD)0.0469215
Skewness-0.60077216
Sum886605.46
Variance0.0034668651
MonotonicityNot monotonic
2023-12-11T08:20:32.361287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
128.70379 4
 
0.1%
128.701847 3
 
< 0.1%
128.634313 3
 
< 0.1%
128.578439 3
 
< 0.1%
128.619197 3
 
< 0.1%
128.63483 3
 
< 0.1%
128.616829 3
 
< 0.1%
128.690614 2
 
< 0.1%
128.6350909 2
 
< 0.1%
128.705401 2
 
< 0.1%
Other values (6717) 6864
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 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size54.0 KiB
1
3924 
<NA>
2965 
2
 
3

Length

Max length4
Median length1
Mean length2.2906268
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 3924
56.9%
<NA> 2965
43.0%
2 3
 
< 0.1%

Length

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

Common Values (Plot)

2023-12-11T08:20:32.663598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 3924
56.9%
na 2965
43.0%
2 3
 
< 0.1%

나트륨램프
Categorical

HIGH CORRELATION 

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

Length

Max length4
Median length4
Mean length3.6395821
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> 6064
88.0%
1 828
 
12.0%

Length

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

Common Values (Plot)

2023-12-11T08:20:32.923377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 6064
88.0%
1 828
 
12.0%

엘이디램프
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size54.0 KiB
<NA>
4757 
1
1827 
2
 
308

Length

Max length4
Median length4
Mean length3.0706616
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 4757
69.0%
1 1827
 
26.5%
2 308
 
4.5%

Length

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

Common Values (Plot)

2023-12-11T08:20:33.129387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 4757
69.0%
1 1827
 
26.5%
2 308
 
4.5%

합계
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size54.0 KiB
1
6575 
2
 
312
<NA>
 
5

Length

Max length4
Median length1
Mean length1.0021764
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 6575
95.4%
2 312
 
4.5%
<NA> 5
 
0.1%

Length

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

Common Values (Plot)

2023-12-11T08:20:33.426521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 6575
95.4%
2 312
 
4.5%
na 5
 
0.1%

설치년도
Real number (ℝ)

HIGH CORRELATION 

Distinct26
Distinct (%)0.4%
Missing3
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean1986.8409
Minimum1905
Maximum2022
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size60.7 KiB
2023-12-11T08:20:33.538791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1905
5-th percentile1905
Q11998
median2006
Q32012
95-th percentile2020
Maximum2022
Range117
Interquartile range (IQR)14

Descriptive statistics

Standard deviation42.338827
Coefficient of variation (CV)0.021309621
Kurtosis-0.014934258
Mean1986.8409
Median Absolute Deviation (MAD)8
Skewness-1.3626337
Sum13687347
Variance1792.5763
MonotonicityNot monotonic
2023-12-11T08:20:33.664515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%)
1905 1429
20.7%
1998 681
 
9.9%
2009 429
 
6.2%
2008 395
 
5.7%
2006 372
 
5.4%
2004 324
 
4.7%
2014 315
 
4.6%
2015 298
 
4.3%
2005 292
 
4.2%
2019 251
 
3.6%
Other values (16) 2103
30.5%
ValueCountFrequency (%)
1905 1429
20.7%
1997 217
 
3.1%
1998 681
9.9%
2000 122
 
1.8%
2001 126
 
1.8%
2002 101
 
1.5%
2003 96
 
1.4%
2004 324
 
4.7%
2005 292
 
4.2%
2006 372
 
5.4%
ValueCountFrequency (%)
2022 47
 
0.7%
2021 62
 
0.9%
2020 249
3.6%
2019 251
3.6%
2018 56
 
0.8%
2017 237
3.4%
2016 39
 
0.6%
2015 298
4.3%
2014 315
4.6%
2013 141
2.0%

데이터기준일자
Date

Distinct10
Distinct (%)0.1%
Missing3
Missing (%)< 0.1%
Memory size54.0 KiB
Minimum2021-09-07 00:00:00
Maximum2022-08-31 00:00:00
2023-12-11T08:20:33.762719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:33.851662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)

Interactions

2023-12-11T08:20:28.473603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:26.652076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:27.129769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:27.656531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:28.601897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:26.771316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:27.237231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:28.095190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:28.729803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:26.899563image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:27.365497image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:28.232044image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:28.851120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:27.010392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:27.511946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:20:28.350009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T08:20:33.925912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번위도경도씨디엠램프엘이디램프합계설치년도데이터기준일자
순번1.0000.8580.872NaN0.6450.4240.4770.716
위도0.8581.0000.6470.1730.4310.2060.3210.511
경도0.8720.6471.0000.0000.4730.2680.4510.538
씨디엠램프NaN0.1730.0001.000NaN0.9060.0000.679
엘이디램프0.6450.4310.473NaN1.0001.0000.1770.766
합계0.4240.2060.2680.9061.0001.0000.1950.941
설치년도0.4770.3210.4510.0000.1770.1951.0000.325
데이터기준일자0.7160.5110.5380.6790.7660.9410.3251.000
2023-12-11T08:20:34.042765image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
엘이디램프합계나트륨램프씨디엠램프
엘이디램프1.0000.996NaNNaN
합계0.9961.0001.0000.721
나트륨램프NaN1.0001.000NaN
씨디엠램프NaN0.721NaN1.000
2023-12-11T08:20:34.159461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번위도경도설치년도씨디엠램프나트륨램프엘이디램프합계
순번1.0000.3150.539-0.1811.0001.0000.5000.326
위도0.3151.000-0.032-0.1970.1331.0000.3310.158
경도0.539-0.0321.000-0.2850.0001.0000.3630.205
설치년도-0.181-0.197-0.2851.0000.0001.0000.3450.337
씨디엠램프1.0000.1330.0000.0001.0000.000NaN0.721
나트륨램프1.0001.0001.0001.0000.0001.0000.0001.000
엘이디램프0.5000.3310.3630.345NaN0.0001.0000.996
합계0.3260.1580.2050.3370.7211.0000.9961.000

Missing values

2023-12-11T08:20:28.999071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T08:20:29.194657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
2023-12-11T08:20:29.359917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

순번표찰번호종류지번주소위도경도씨디엠램프나트륨램프엘이디램프합계설치년도데이터기준일자
01거제면0027가로등경상남도 거제시 거제면 동상리 613-1034.849367128.592788<NA><NA>1119972022-08-31
12거제면0028가로등경상남도 거제시 거제면 동상리 616-334.848932128.593072<NA><NA>1119972022-08-31
23거제면0029가로등경상남도 거제시 거제면 동상리 618-834.848526128.593324<NA><NA>1119972022-08-31
34거제면0030가로등경상남도 거제시 거제면 동상리 620-134.848222128.593536<NA><NA>1119972022-08-31
45거제면0031가로등경상남도 거제시 거제면 동상리 671-234.847926128.593764<NA><NA>1119972022-08-31
56거제면0032가로등경상남도 거제시 거제면 동상리 717-1734.847593128.593979<NA><NA>1119972022-08-31
67거제면0091가로등경상남도 거제시 거제면 남동리 151-4934.847443128.5904171<NA><NA>119982022-08-31
78거제면0092가로등경상남도 거제시 거제면 남동리 29-40134.84748128.5918141<NA><NA>119982022-08-31
89거제면0093가로등경상남도 거제시 거제면 남동리 29-40534.847451128.5931811<NA><NA>119982022-08-31
910거제면0094가로등경상남도 거제시 거제면 남동리 29-43334.847236128.594007<NA><NA>1119982022-08-31
순번표찰번호종류지번주소위도경도씨디엠램프나트륨램프엘이디램프합계설치년도데이터기준일자
68827137하청면0943가로등경상남도 거제시 하청면 하청리 607-134.957202128.655651<NA><NA>1120172021-09-07
68837138하청면0944가로등경상남도 거제시 하청면 하청리 607-234.956969128.655528<NA><NA>1120172021-09-07
68847139하청면0945가로등경상남도 거제시 하청면 하청리 608-234.956833128.655626<NA><NA>1120172021-09-07
68857140하청면0946가로등경상남도 거제시 하청면 하청리 661-3834.956825128.655363<NA><NA>1120172021-09-07
68867141하청면0947가로등경상남도 거제시 하청면 대곡리 83335.007615128.627841<NA><NA>1120172021-09-07
68877142하청면0948가로등경상남도 거제시 하청면 대곡리 산10435.007878128.627482<NA><NA>1120172021-09-07
68887143하청면0949가로등경상남도 거제시 하청면 대곡리 산104-135.008141128.62721<NA><NA>1120172021-09-07
68897144하청면0950가로등경상남도 거제시 하청면 대곡리 산104-135.008459128.626967<NA><NA>1120172021-09-07
68907145하청면0951가로등경상남도 거제시 하청면 대곡리 산105-235.008891128.626755<NA><NA>1120172021-09-07
68917146하청면0977가로등경상남도 거제시 하청면 실전리 산67-434.975412128.653838<NA><NA>1120192021-09-07