Overview

Dataset statistics

Number of variables9
Number of observations61
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.7 KiB
Average record size in memory78.1 B

Variable types

Categorical4
Numeric4
DateTime1

Dataset

Description전라남도 광양시 가로수현황에 대한 정보로 가로수 위치, 종류, 가로수 직경, 가로수분, 하층식재 등의 정보를 제공합니다.(현재 업데이트중)
Author전라남도 광양시
URLhttps://www.data.go.kr/data/15077714/fileData.do

Alerts

데이터기준일 has constant value ""Constant
하층식재 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 가로수길명High correlation
가로수명 is highly overall correlated with 가로수직경 and 4 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 3 other fieldsHigh correlation
위도 is highly overall correlated with 기로수번호 and 4 other fieldsHigh correlation
가로수명 is highly imbalanced (60.8%)Imbalance
경도 has unique valuesUnique

Reproduction

Analysis started2024-03-14 17:53:15.316586
Analysis finished2024-03-14 17:53:20.792389
Duration5.48 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

가로수길명
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)4.9%
Missing0
Missing (%)0.0%
Memory size616.0 B
구마2길
26 
구마4길
23 
옥진로
12 

Length

Max length4
Median length4
Mean length3.8032787
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row구마2길
2nd row구마2길
3rd row구마2길
4th row구마2길
5th row구마2길

Common Values

ValueCountFrequency (%)
구마2길 26
42.6%
구마4길 23
37.7%
옥진로 12
19.7%

Length

2024-03-15T02:53:21.033063image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T02:53:21.486911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
구마2길 26
42.6%
구마4길 23
37.7%
옥진로 12
19.7%

기로수번호
Real number (ℝ)

HIGH CORRELATION 

Distinct26
Distinct (%)42.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11.557377
Minimum1
Maximum26
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size677.0 B
2024-03-15T02:53:21.792672image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q16
median11
Q317
95-th percentile23
Maximum26
Range25
Interquartile range (IQR)11

Descriptive statistics

Standard deviation7.102874
Coefficient of variation (CV)0.61457492
Kurtosis-1.0193957
Mean11.557377
Median Absolute Deviation (MAD)6
Skewness0.30476404
Sum705
Variance50.45082
MonotonicityNot monotonic
2024-03-15T02:53:22.175189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%)
1 3
 
4.9%
8 3
 
4.9%
2 3
 
4.9%
12 3
 
4.9%
11 3
 
4.9%
10 3
 
4.9%
9 3
 
4.9%
7 3
 
4.9%
6 3
 
4.9%
5 3
 
4.9%
Other values (16) 31
50.8%
ValueCountFrequency (%)
1 3
4.9%
2 3
4.9%
3 3
4.9%
4 3
4.9%
5 3
4.9%
6 3
4.9%
7 3
4.9%
8 3
4.9%
9 3
4.9%
10 3
4.9%
ValueCountFrequency (%)
26 1
1.6%
25 1
1.6%
24 1
1.6%
23 2
3.3%
22 2
3.3%
21 2
3.3%
20 2
3.3%
19 2
3.3%
18 2
3.3%
17 2
3.3%

가로수명
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct5
Distinct (%)8.2%
Missing0
Missing (%)0.0%
Memory size616.0 B
느티나무
50 
왕벚나무
8 
왕버들
 
1
프라타나스
 
1
무궁화
 
1

Length

Max length5
Median length4
Mean length3.9836066
Min length3

Unique

Unique3 ?
Unique (%)4.9%

Sample

1st row느티나무
2nd row느티나무
3rd row느티나무
4th row느티나무
5th row느티나무

Common Values

ValueCountFrequency (%)
느티나무 50
82.0%
왕벚나무 8
 
13.1%
왕버들 1
 
1.6%
프라타나스 1
 
1.6%
무궁화 1
 
1.6%

Length

2024-03-15T02:53:22.616980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T02:53:23.051110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
느티나무 50
82.0%
왕벚나무 8
 
13.1%
왕버들 1
 
1.6%
프라타나스 1
 
1.6%
무궁화 1
 
1.6%

가로수직경
Real number (ℝ)

HIGH CORRELATION 

Distinct25
Distinct (%)41.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.22672131
Minimum0.06
Maximum0.45
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size677.0 B
2024-03-15T02:53:23.404465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.06
5-th percentile0.13
Q10.18
median0.22
Q30.27
95-th percentile0.35
Maximum0.45
Range0.39
Interquartile range (IQR)0.09

Descriptive statistics

Standard deviation0.071033356
Coefficient of variation (CV)0.31330692
Kurtosis0.79554696
Mean0.22672131
Median Absolute Deviation (MAD)0.05
Skewness0.44980889
Sum13.83
Variance0.0050457377
MonotonicityNot monotonic
2024-03-15T02:53:23.808943image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)
ValueCountFrequency (%)
0.22 7
 
11.5%
0.19 5
 
8.2%
0.16 5
 
8.2%
0.15 4
 
6.6%
0.24 4
 
6.6%
0.28 4
 
6.6%
0.27 4
 
6.6%
0.21 3
 
4.9%
0.29 3
 
4.9%
0.2 3
 
4.9%
Other values (15) 19
31.1%
ValueCountFrequency (%)
0.06 1
 
1.6%
0.1 1
 
1.6%
0.12 1
 
1.6%
0.13 2
 
3.3%
0.15 4
6.6%
0.16 5
8.2%
0.17 1
 
1.6%
0.18 1
 
1.6%
0.19 5
8.2%
0.2 3
4.9%
ValueCountFrequency (%)
0.45 1
 
1.6%
0.38 1
 
1.6%
0.36 1
 
1.6%
0.35 1
 
1.6%
0.32 1
 
1.6%
0.31 1
 
1.6%
0.3 2
3.3%
0.29 3
4.9%
0.28 4
6.6%
0.27 4
6.6%

가로수분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size616.0 B
사각
38 
말굽형
23 

Length

Max length3
Median length2
Mean length2.3770492
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row사각
2nd row사각
3rd row사각
4th row사각
5th row사각

Common Values

ValueCountFrequency (%)
사각 38
62.3%
말굽형 23
37.7%

Length

2024-03-15T02:53:24.253592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T02:53:24.576621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사각 38
62.3%
말굽형 23
37.7%

하층식재
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size616.0 B
꽃잔디
49 
없음
12 

Length

Max length3
Median length3
Mean length2.8032787
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row꽃잔디
2nd row꽃잔디
3rd row꽃잔디
4th row꽃잔디
5th row꽃잔디

Common Values

ValueCountFrequency (%)
꽃잔디 49
80.3%
없음 12
 
19.7%

Length

2024-03-15T02:53:24.918377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T02:53:25.261440image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
꽃잔디 49
80.3%
없음 12
 
19.7%

경도
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct61
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.68993
Minimum127.68733
Maximum127.69766
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size677.0 B
2024-03-15T02:53:25.593096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.68733
5-th percentile127.68758
Q1127.68809
median127.68855
Q3127.68901
95-th percentile127.69654
Maximum127.69766
Range0.0103309
Interquartile range (IQR)0.0009255

Descriptive statistics

Standard deviation0.0032627255
Coefficient of variation (CV)2.5551941 × 10-5
Kurtosis0.51462594
Mean127.68993
Median Absolute Deviation (MAD)0.0004654
Skewness1.5232702
Sum7789.0858
Variance1.0645378 × 10-5
MonotonicityNot monotonic
2024-03-15T02:53:26.121690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.6873265 1
 
1.6%
127.6888985 1
 
1.6%
127.6889259 1
 
1.6%
127.689012 1
 
1.6%
127.6890986 1
 
1.6%
127.6891869 1
 
1.6%
127.6879356 1
 
1.6%
127.688021 1
 
1.6%
127.6882796 1
 
1.6%
127.688363 1
 
1.6%
Other values (51) 51
83.6%
ValueCountFrequency (%)
127.6873265 1
1.6%
127.687334 1
1.6%
127.6875787 1
1.6%
127.687583 1
1.6%
127.6876372 1
1.6%
127.6876575 1
1.6%
127.6877351 1
1.6%
127.6877452 1
1.6%
127.6878351 1
1.6%
127.6878417 1
1.6%
ValueCountFrequency (%)
127.6976574 1
1.6%
127.6974897 1
1.6%
127.6969703 1
1.6%
127.6965366 1
1.6%
127.6962576 1
1.6%
127.6961757 1
1.6%
127.6960907 1
1.6%
127.6960898 1
1.6%
127.6959957 1
1.6%
127.6959251 1
1.6%

위도
Real number (ℝ)

HIGH CORRELATION 

Distinct60
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean34.955015
Minimum34.945309
Maximum34.990228
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size677.0 B
2024-03-15T02:53:26.511486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum34.945309
5-th percentile34.945312
Q134.945388
median34.94748
Q334.947815
95-th percentile34.990195
Maximum34.990228
Range0.04491902
Interquartile range (IQR)0.00242668

Descriptive statistics

Standard deviation0.017529245
Coefficient of variation (CV)0.00050148011
Kurtosis0.44244932
Mean34.955015
Median Absolute Deviation (MAD)0.00208988
Skewness1.551138
Sum2132.2559
Variance0.00030727442
MonotonicityNot monotonic
2024-03-15T02:53:26.951693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
34.94531176 2
 
3.3%
34.94539597 1
 
1.6%
34.94744211 1
 
1.6%
34.94754909 1
 
1.6%
34.94751219 1
 
1.6%
34.94747248 1
 
1.6%
34.94784859 1
 
1.6%
34.94781304 1
 
1.6%
34.94770332 1
 
1.6%
34.94766788 1
 
1.6%
Other values (50) 50
82.0%
ValueCountFrequency (%)
34.94530924 1
1.6%
34.94530981 1
1.6%
34.94531162 1
1.6%
34.94531176 2
3.3%
34.94531529 1
1.6%
34.94531561 1
1.6%
34.94531703 1
1.6%
34.94531808 1
1.6%
34.94531825 1
1.6%
34.9453188 1
1.6%
ValueCountFrequency (%)
34.99022826 1
1.6%
34.99022095 1
1.6%
34.99020918 1
1.6%
34.99019521 1
1.6%
34.99018688 1
1.6%
34.99013451 1
1.6%
34.9900863 1
1.6%
34.99006633 1
1.6%
34.99000527 1
1.6%
34.98994618 1
1.6%

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size616.0 B
Minimum2024-03-06 00:00:00
Maximum2024-03-06 00:00:00
2024-03-15T02:53:27.297668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:53:27.587019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-03-15T02:53:18.956827image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:53:15.874630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:53:16.865542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:53:17.801948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:53:19.207067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:53:16.110156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:53:17.118796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:53:18.115572image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:53:19.490170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:53:16.375980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:53:17.392426image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:53:18.436865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:53:19.751461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:53:16.620136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:53:17.552439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:53:18.700647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T02:53:27.751269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
가로수길명기로수번호가로수명가로수직경가로수분하층식재경도위도
가로수길명1.0000.0000.6690.6561.0001.0000.7441.000
기로수번호0.0001.0000.0000.0000.0000.1020.3550.102
가로수명0.6690.0001.0000.9250.2200.8180.9640.818
가로수직경0.6560.0000.9251.0000.4950.8600.7020.860
가로수분1.0000.0000.2200.4951.0000.4820.3980.482
하층식재1.0000.1020.8180.8600.4821.0001.0000.997
경도0.7440.3550.9640.7020.3981.0001.0001.000
위도1.0000.1020.8180.8600.4820.9971.0001.000
2024-03-15T02:53:28.005589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
하층식재가로수길명가로수분가로수명
하층식재1.0000.9910.3200.920
가로수길명0.9911.0000.9910.629
가로수분0.3200.9911.0000.260
가로수명0.9200.6290.2601.000
2024-03-15T02:53:28.247594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기로수번호가로수직경경도위도가로수길명가로수명가로수분하층식재
기로수번호1.000-0.179-0.013-0.5980.0000.0000.0000.080
가로수직경-0.1791.0000.3160.2220.4710.6060.3510.643
경도-0.0130.3161.0000.5410.7290.7290.4720.974
위도-0.5980.2220.5411.0000.9910.9200.3200.947
가로수길명0.0000.4710.7290.9911.0000.6290.9910.991
가로수명0.0000.6060.7290.9200.6291.0000.2600.920
가로수분0.0000.3510.4720.3200.9910.2601.0000.320
하층식재0.0800.6430.9740.9470.9910.9200.3201.000

Missing values

2024-03-15T02:53:20.099714image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T02:53:20.622401image/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

가로수길명기로수번호가로수명가로수직경가로수분하층식재경도위도데이터기준일
0구마2길1느티나무0.2사각꽃잔디127.68732634.9453962024-03-06
1구마2길2느티나무0.27사각꽃잔디127.68758334.9453942024-03-06
2구마2길3느티나무0.22사각꽃잔디127.68763734.9453942024-03-06
3구마2길4느티나무0.2사각꽃잔디127.68773534.9453942024-03-06
4구마2길5느티나무0.19사각꽃잔디127.68783534.9453932024-03-06
5구마2길6느티나무0.24사각꽃잔디127.68793334.9453922024-03-06
6구마2길7느티나무0.28사각꽃잔디127.68818434.9453912024-03-06
7구마2길8느티나무0.06사각꽃잔디127.68828434.945392024-03-06
8구마2길9느티나무0.24사각꽃잔디127.68838534.9453882024-03-06
9구마2길10느티나무0.26사각꽃잔디127.6884834.9453882024-03-06
가로수길명기로수번호가로수명가로수직경가로수분하층식재경도위도데이터기준일
51옥진로3왕벚나무0.27사각없음127.6960934.9902092024-03-06
52옥진로4왕벚나무0.36사각없음127.69617634.9901952024-03-06
53옥진로5왕벚나무0.35사각없음127.69625834.9901872024-03-06
54옥진로6왕버들0.32사각없음127.69553334.9901352024-03-06
55옥진로7프라타나스0.45사각없음127.69592534.9900862024-03-06
56옥진로8왕벚나무0.28사각없음127.69609134.9900662024-03-06
57옥진로9왕벚나무0.3사각없음127.69653734.9900052024-03-06
58옥진로10무궁화0.1사각없음127.6969734.9899462024-03-06
59옥진로11왕벚나무0.29사각없음127.6974934.9898762024-03-06
60옥진로12느티나무0.3사각없음127.69765734.989852024-03-06