Overview

Dataset statistics

Number of variables4
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory419.9 KiB
Average record size in memory43.0 B

Variable types

Numeric3
Categorical1

Dataset

Description대구시 시내의 가로등에 대한 위치 및 가로등 현황 공개
Author대구시설공단
URLhttps://www.data.go.kr/data/3055368/fileData.do

Alerts

가로등번호 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 가로등번호 and 1 other fieldsHigh correlation

Reproduction

Analysis started2023-12-12 07:03:46.381687
Analysis finished2023-12-12 07:03:48.147174
Duration1.77 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

가로등번호
Real number (ℝ)

HIGH CORRELATION 

Distinct9000
Distinct (%)90.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5418311.8
Minimum1001001
Maximum8613001
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T16:03:48.249591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1001001
5-th percentile2064011.8
Q13129001
median5429011
Q37247009.2
95-th percentile8379008.3
Maximum8613001
Range7612000
Interquartile range (IQR)4118008.2

Descriptive statistics

Standard deviation2222216.6
Coefficient of variation (CV)0.41013081
Kurtosis-1.1186004
Mean5418311.8
Median Absolute Deviation (MAD)1874500
Skewness-0.36401875
Sum5.4183118 × 1010
Variance4.9382467 × 1012
MonotonicityNot monotonic
2023-12-12T16:03:48.399671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
6261001 66
 
0.7%
6382001 64
 
0.6%
6248010 49
 
0.5%
5303017 46
 
0.5%
6382002 40
 
0.4%
2228001 38
 
0.4%
2350029 36
 
0.4%
5406001 34
 
0.3%
3166001 28
 
0.3%
8452001 28
 
0.3%
Other values (8990) 9571
95.7%
ValueCountFrequency (%)
1001001 1
< 0.1%
1001002 1
< 0.1%
1001012 1
< 0.1%
1001013 1
< 0.1%
1002002 1
< 0.1%
1002005 1
< 0.1%
1002009 1
< 0.1%
1002012 1
< 0.1%
1002014 1
< 0.1%
1003006 1
< 0.1%
ValueCountFrequency (%)
8613001 1
< 0.1%
8501014 1
< 0.1%
8501013 1
< 0.1%
8501010 1
< 0.1%
8501007 1
< 0.1%
8501006 1
< 0.1%
8501005 1
< 0.1%
8500062 1
< 0.1%
8500043 1
< 0.1%
8500017 1
< 0.1%

관할구청
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
북구
1856 
달서구
1832 
달성군
1708 
동구
1702 
수성구
1436 
Other values (3)
1466 

Length

Max length3
Median length2
Mean length2.4976
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row북구
2nd row북구
3rd row달성군
4th row북구
5th row달서구

Common Values

ValueCountFrequency (%)
북구 1856
18.6%
달서구 1832
18.3%
달성군 1708
17.1%
동구 1702
17.0%
수성구 1436
14.4%
서구 649
 
6.5%
남구 451
 
4.5%
중구 366
 
3.7%

Length

2023-12-12T16:03:48.538042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:03:48.658848image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
북구 1856
18.6%
달서구 1832
18.3%
달성군 1708
17.1%
동구 1702
17.0%
수성구 1436
14.4%
서구 649
 
6.5%
남구 451
 
4.5%
중구 366
 
3.7%

위도
Real number (ℝ)

HIGH CORRELATION 

Distinct9996
Distinct (%)> 99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35.850866
Minimum35.629171
Maximum35.996598
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T16:03:49.115166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum35.629171
5-th percentile35.689352
Q135.832926
median35.86234
Q335.884972
95-th percentile35.942263
Maximum35.996598
Range0.36742716
Interquartile range (IQR)0.052045855

Descriptive statistics

Standard deviation0.06699399
Coefficient of variation (CV)0.0018686854
Kurtosis2.1195793
Mean35.850866
Median Absolute Deviation (MAD)0.02679063
Skewness-1.3491686
Sum358508.66
Variance0.0044881947
MonotonicityNot monotonic
2023-12-12T16:03:49.292021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
35.87537336 2
 
< 0.1%
35.87867499 2
 
< 0.1%
35.84090979 2
 
< 0.1%
35.85865563 2
 
< 0.1%
35.83851825 1
 
< 0.1%
35.88235394 1
 
< 0.1%
35.86146068 1
 
< 0.1%
35.88106255 1
 
< 0.1%
35.87218698 1
 
< 0.1%
35.78218182 1
 
< 0.1%
Other values (9986) 9986
99.9%
ValueCountFrequency (%)
35.62917051 1
< 0.1%
35.62920301 1
< 0.1%
35.62921141 1
< 0.1%
35.62936887 1
< 0.1%
35.62938564 1
< 0.1%
35.62939174 1
< 0.1%
35.62939787 1
< 0.1%
35.62941623 1
< 0.1%
35.62942117 1
< 0.1%
35.62943458 1
< 0.1%
ValueCountFrequency (%)
35.99659767 1
< 0.1%
35.9955412 1
< 0.1%
35.99485047 1
< 0.1%
35.99447417 1
< 0.1%
35.99267326 1
< 0.1%
35.99183477 1
< 0.1%
35.99062045 1
< 0.1%
35.98906341 1
< 0.1%
35.98745395 1
< 0.1%
35.98632407 1
< 0.1%

경도
Real number (ℝ)

HIGH CORRELATION 

Distinct9968
Distinct (%)99.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean128.57489
Minimum128.40705
Maximum128.75728
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T16:03:49.444271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum128.40705
5-th percentile128.45154
Q1128.52087
median128.57286
Q3128.63276
95-th percentile128.71037
Maximum128.75728
Range0.3502354
Interquartile range (IQR)0.11188815

Descriptive statistics

Standard deviation0.078136667
Coefficient of variation (CV)0.00060771326
Kurtosis-0.67716433
Mean128.57489
Median Absolute Deviation (MAD)0.0555683
Skewness0.06222056
Sum1285748.9
Variance0.0061053387
MonotonicityNot monotonic
2023-12-12T16:03:49.593912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
128.4175151 2
 
< 0.1%
128.477916 2
 
< 0.1%
128.6169011 2
 
< 0.1%
128.5263801 2
 
< 0.1%
128.5740259 2
 
< 0.1%
128.5285227 2
 
< 0.1%
128.524234 2
 
< 0.1%
128.5990702 2
 
< 0.1%
128.509661 2
 
< 0.1%
128.4902981 2
 
< 0.1%
Other values (9958) 9980
99.8%
ValueCountFrequency (%)
128.4070494 1
< 0.1%
128.4074944 1
< 0.1%
128.4079352 1
< 0.1%
128.4081585 1
< 0.1%
128.4084118 1
< 0.1%
128.4084529 1
< 0.1%
128.4085972 1
< 0.1%
128.4087425 1
< 0.1%
128.4088776 1
< 0.1%
128.4090564 1
< 0.1%
ValueCountFrequency (%)
128.7572848 1
< 0.1%
128.7566019 1
< 0.1%
128.7562249 1
< 0.1%
128.755909 1
< 0.1%
128.7556316 1
< 0.1%
128.754 1
< 0.1%
128.7539368 1
< 0.1%
128.7537603 1
< 0.1%
128.7534196 1
< 0.1%
128.7533923 1
< 0.1%

Interactions

2023-12-12T16:03:47.631012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:03:46.868075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:03:47.249846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:03:47.762503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:03:46.984122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:03:47.399443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:03:47.862015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:03:47.112505image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:03:47.519835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T16:03:49.695056image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
가로등번호관할구청위도경도
가로등번호1.0000.9980.8570.895
관할구청0.9981.0000.7500.810
위도0.8570.7501.0000.841
경도0.8950.8100.8411.000
2023-12-12T16:03:49.789251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
가로등번호위도경도관할구청
가로등번호1.000-0.670-0.6790.986
위도-0.6701.0000.3950.485
경도-0.6790.3951.0000.564
관할구청0.9860.4850.5641.000

Missing values

2023-12-12T16:03:48.000645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:03:48.093715image/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

가로등번호관할구청위도경도
206955114021북구35.890436128.599626
217365153026북구35.92758128.552261
580608436004달성군35.683391128.450983
259385300026북구35.918876128.596505
414427149012달서구35.838827128.52329
435397217025달서구35.822081128.552974
407217119011달서구35.820492128.524465
546268309031달성군35.875205128.471731
472197366005달서구35.8139128.520446
482327424001달서구35.84932128.522158
가로등번호관할구청위도경도
256625293035북구35.923583128.599411
348576251006수성구35.847063128.674045
54672207004동구35.879424128.614867
590998476005달성군35.781144128.442624
519738177013달성군35.633474128.429729
142503114022서구35.876954128.529536
384376441010수성구35.852495128.652191
530158230002달성군35.663375128.422159
51392193005동구35.876566128.654269
531798236019달성군35.879649128.410742