Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory576.2 KiB
Average record size in memory59.0 B

Variable types

Numeric3
Categorical3

Dataset

Description광명시 관내 가로수에 대해 위치, 수종 등을 제공
Author경기도 광명시
URLhttps://www.data.go.kr/data/15025510/fileData.do

Alerts

관리기관 has constant value ""Constant
관리번호 is highly overall correlated with 행정동High correlation
위도 is highly overall correlated with 행정동High correlation
경도 is highly overall correlated with 행정동High correlation
행정동 is highly overall correlated with 관리번호 and 2 other fieldsHigh correlation

Reproduction

Analysis started2023-12-12 21:21:16.844783
Analysis finished2023-12-12 21:21:18.751369
Duration1.91 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리번호
Real number (ℝ)

HIGH CORRELATION 

Distinct9947
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean78906.124
Minimum10
Maximum700173
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T06:21:18.825091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10
5-th percentile980.95
Q15105.75
median10003.5
Q320660.25
95-th percentile500610.05
Maximum700173
Range700163
Interquartile range (IQR)15554.5

Descriptive statistics

Standard deviation165759.35
Coefficient of variation (CV)2.1007159
Kurtosis5.0615931
Mean78906.124
Median Absolute Deviation (MAD)5813.5
Skewness2.5119095
Sum7.8906124 × 108
Variance2.7476162 × 1010
MonotonicityNot monotonic
2023-12-13T06:21:18.990621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
700120 3
 
< 0.1%
700118 3
 
< 0.1%
700125 3
 
< 0.1%
700119 3
 
< 0.1%
12025 2
 
< 0.1%
12042 2
 
< 0.1%
700136 2
 
< 0.1%
12037 2
 
< 0.1%
12039 2
 
< 0.1%
700159 2
 
< 0.1%
Other values (9937) 9976
99.8%
ValueCountFrequency (%)
10 1
< 0.1%
11 1
< 0.1%
12 1
< 0.1%
16 1
< 0.1%
18 1
< 0.1%
19 1
< 0.1%
20 1
< 0.1%
21 1
< 0.1%
23 1
< 0.1%
24 1
< 0.1%
ValueCountFrequency (%)
700173 1
< 0.1%
700172 1
< 0.1%
700171 1
< 0.1%
700169 1
< 0.1%
700168 1
< 0.1%
700165 1
< 0.1%
700164 1
< 0.1%
700162 1
< 0.1%
700161 2
< 0.1%
700160 1
< 0.1%

행정동
Categorical

HIGH CORRELATION 

Distinct19
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
소하2동
1684 
학온동
1338 
철산3동
1187 
소하1동
1161 
하안1동
894 
Other values (14)
3736 

Length

Max length4
Median length4
Mean length3.8662
Min length3

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row하안1동
2nd row학온동
3rd row소하2동
4th row하안4동
5th row광명6동

Common Values

ValueCountFrequency (%)
소하2동 1684
16.8%
학온동 1338
13.4%
철산3동 1187
11.9%
소하1동 1161
11.6%
하안1동 894
8.9%
하안3동 686
6.9%
광명6동 676
6.8%
하안4동 619
 
6.2%
광명7동 417
 
4.2%
철산2동 407
 
4.1%
Other values (9) 931
9.3%

Length

2023-12-13T06:21:19.150305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
소하2동 1684
16.8%
학온동 1338
13.4%
철산3동 1187
11.9%
소하1동 1161
11.6%
하안1동 894
8.9%
하안3동 686
6.9%
광명6동 676
6.8%
하안4동 619
 
6.2%
광명7동 417
 
4.2%
철산2동 407
 
4.1%
Other values (9) 931
9.3%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
광명시청
10000 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row광명시청
2nd row광명시청
3rd row광명시청
4th row광명시청
5th row광명시청

Common Values

ValueCountFrequency (%)
광명시청 10000
100.0%

Length

2023-12-13T06:21:19.279577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:21:19.385365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광명시청 10000
100.0%

가로수종류
Categorical

Distinct13
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
벗나무
3679 
은행나무
3433 
느티나무
1304 
이팝나무
710 
메타세콰이아
 
231
Other values (8)
643 

Length

Max length6
Median length4
Mean length3.6467
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row산딸기나무
2nd row벗나무
3rd row느티나무
4th row느티나무
5th row은행나무

Common Values

ValueCountFrequency (%)
벗나무 3679
36.8%
은행나무 3433
34.3%
느티나무 1304
 
13.0%
이팝나무 710
 
7.1%
메타세콰이아 231
 
2.3%
기타 228
 
2.3%
산딸기나무 165
 
1.7%
버즘나무 142
 
1.4%
<NA> 53
 
0.5%
미분류 22
 
0.2%
Other values (3) 33
 
0.3%

Length

2023-12-13T06:21:19.491424image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
벗나무 3679
36.8%
은행나무 3433
34.3%
느티나무 1304
 
13.0%
이팝나무 710
 
7.1%
메타세콰이아 231
 
2.3%
기타 228
 
2.3%
산딸기나무 165
 
1.7%
버즘나무 142
 
1.4%
na 53
 
0.5%
미분류 22
 
0.2%
Other values (3) 33
 
0.3%

위도
Real number (ℝ)

HIGH CORRELATION 

Distinct9988
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.453655
Minimum37.406089
Maximum37.493932
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T06:21:19.624788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.406089
5-th percentile37.41575
Q137.436088
median37.459997
Q337.470315
95-th percentile37.483099
Maximum37.493932
Range0.08784272
Interquartile range (IQR)0.034227935

Descriptive statistics

Standard deviation0.022187105
Coefficient of variation (CV)0.00059238824
Kurtosis-1.0000799
Mean37.453655
Median Absolute Deviation (MAD)0.01414211
Skewness-0.46606683
Sum374536.55
Variance0.00049226761
MonotonicityNot monotonic
2023-12-13T06:21:19.756090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.42944858 2
 
< 0.1%
37.42955297 2
 
< 0.1%
37.46377779 2
 
< 0.1%
37.45780832 2
 
< 0.1%
37.4735273 2
 
< 0.1%
37.41848616 2
 
< 0.1%
37.45187754 2
 
< 0.1%
37.45883439 2
 
< 0.1%
37.45824874 2
 
< 0.1%
37.42944822 2
 
< 0.1%
Other values (9978) 9980
99.8%
ValueCountFrequency (%)
37.40608883 1
< 0.1%
37.40632639 1
< 0.1%
37.40635736 1
< 0.1%
37.40640041 1
< 0.1%
37.40648002 1
< 0.1%
37.40655072 1
< 0.1%
37.40662033 1
< 0.1%
37.40670067 1
< 0.1%
37.40687908 1
< 0.1%
37.40693888 1
< 0.1%
ValueCountFrequency (%)
37.49393155 1
< 0.1%
37.49387976 1
< 0.1%
37.49381302 1
< 0.1%
37.49375484 1
< 0.1%
37.49369521 1
< 0.1%
37.49362919 1
< 0.1%
37.4935665 1
< 0.1%
37.49349832 1
< 0.1%
37.49348965 1
< 0.1%
37.49337306 1
< 0.1%

경도
Real number (ℝ)

HIGH CORRELATION 

Distinct9871
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.8703
Minimum126.83164
Maximum126.8991
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T06:21:19.897687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.83164
5-th percentile126.84284
Q1126.86045
median126.87229
Q3126.88226
95-th percentile126.88985
Maximum126.8991
Range0.0674597
Interquartile range (IQR)0.0218136

Descriptive statistics

Standard deviation0.014949904
Coefficient of variation (CV)0.00011783612
Kurtosis-0.63272228
Mean126.8703
Median Absolute Deviation (MAD)0.0103444
Skewness-0.55227282
Sum1268703
Variance0.00022349963
MonotonicityNot monotonic
2023-12-13T06:21:20.047891image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
126.8838235 3
 
< 0.1%
126.8446612 3
 
< 0.1%
126.8765511 2
 
< 0.1%
126.8837419 2
 
< 0.1%
126.8730241 2
 
< 0.1%
126.8685453 2
 
< 0.1%
126.8867614 2
 
< 0.1%
126.887209 2
 
< 0.1%
126.8462449 2
 
< 0.1%
126.8463125 2
 
< 0.1%
Other values (9861) 9978
99.8%
ValueCountFrequency (%)
126.8316359 1
< 0.1%
126.8316372 1
< 0.1%
126.8316416 1
< 0.1%
126.8316645 1
< 0.1%
126.8316864 1
< 0.1%
126.8317069 1
< 0.1%
126.8317536 1
< 0.1%
126.8317607 1
< 0.1%
126.8317952 1
< 0.1%
126.8318264 1
< 0.1%
ValueCountFrequency (%)
126.8990956 1
< 0.1%
126.8989149 1
< 0.1%
126.8988211 1
< 0.1%
126.8987568 1
< 0.1%
126.8986726 1
< 0.1%
126.8985799 1
< 0.1%
126.8983879 1
< 0.1%
126.8983477 1
< 0.1%
126.8983285 1
< 0.1%
126.898255 1
< 0.1%

Interactions

2023-12-13T06:21:18.209434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:21:17.469655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:21:17.829870image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:21:18.342805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:21:17.578493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:21:17.974035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:21:18.443653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:21:17.706799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:21:18.084543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T06:21:20.147640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호행정동가로수종류위도경도
관리번호1.0000.8380.6380.6690.562
행정동0.8381.0000.7000.8740.860
가로수종류0.6380.7001.0000.6260.534
위도0.6690.8740.6261.0000.724
경도0.5620.8600.5340.7241.000
2023-12-13T06:21:20.240189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
가로수종류행정동
가로수종류1.0000.316
행정동0.3161.000
2023-12-13T06:21:20.320237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호위도경도행정동가로수종류
관리번호1.000-0.2330.0360.5050.304
위도-0.2331.000-0.2910.5820.322
경도0.036-0.2911.0000.5550.257
행정동0.5050.5820.5551.0000.316
가로수종류0.3040.3220.2570.3161.000

Missing values

2023-12-13T06:21:18.586054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T06:21:18.696412image/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

관리번호행정동관리기관가로수종류위도경도
504312025하안1동광명시청산딸기나무37.468778126.866011
370420256학온동광명시청벗나무37.454063126.852261
97855599소하2동광명시청느티나무37.436292126.882598
102144724하안4동광명시청느티나무37.468855126.880375
557311206광명6동광명시청은행나무37.473659126.847775
2113130900소하2동광명시청벗나무37.421428126.887157
12520954하안1동광명시청은행나무37.455191126.880953
75468733철산2동광명시청은행나무37.478928126.863773
93606368학온동광명시청느티나무37.421671126.862713
66569808광명6동광명시청은행나무37.472379126.844747
관리번호행정동관리기관가로수종류위도경도
71119251학온동광명시청은행나무37.41897126.85676
405712990하안3동광명시청산수유나무37.459154126.877582
510411973학온동광명시청이팝나무37.416812126.853885
520411873학온동광명시청<NA>37.416597126.85481
616310577광명7동광명시청은행나무37.473766126.851899
797500486소하1동광명시청느티나무37.450082126.889649
71669196학온동광명시청느티나무37.412824126.850599
319600203소하1동광명시청기타37.446633126.888249
1672131341소하2동광명시청벗나무37.420678126.880933
66339857광명7동광명시청은행나무37.469116126.847059