Overview

Dataset statistics

Number of variables9
Number of observations4318
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory324.8 KiB
Average record size in memory77.0 B

Variable types

Categorical4
Numeric5

Dataset

Description경기도 광주시 관내 포장 현황에 대한 데이터로 지형지물부호, 관리번호, 법정구역, 관리기관, 도로구간번호, 연장(미터), 면적(제곱미터), 폭원(미터) 등을 제공합니다.
Author경기도 광주시
URLhttps://www.data.go.kr/data/15042245/fileData.do

Alerts

관리기관 has constant value ""Constant
데이터기준일자 has constant value ""Constant
관리번호 is highly overall correlated with 법정구역High 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 관리번호High correlation
지형지물부호 is highly imbalanced (51.2%)Imbalance

Reproduction

Analysis started2023-12-12 11:23:41.756545
Analysis finished2023-12-12 11:23:47.307637
Duration5.55 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지형지물부호
Categorical

IMBALANCE 

Distinct4
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size33.9 KiB
보도포장
2614 
차도포장
1701 
차도면
 
2
보도면
 
1

Length

Max length4
Median length4
Mean length3.9993052
Min length3

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row차도면
2nd row차도면
3rd row보도면
4th row차도포장
5th row차도포장

Common Values

ValueCountFrequency (%)
보도포장 2614
60.5%
차도포장 1701
39.4%
차도면 2
 
< 0.1%
보도면 1
 
< 0.1%

Length

2023-12-12T20:23:47.449401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:23:47.644918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
보도포장 2614
60.5%
차도포장 1701
39.4%
차도면 2
 
< 0.1%
보도면 1
 
< 0.1%

관리번호
Real number (ℝ)

HIGH CORRELATION 

Distinct4304
Distinct (%)99.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12636.152
Minimum1
Maximum221206
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size38.1 KiB
2023-12-12T20:23:47.858131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile213.85
Q11077.25
median2374.5
Q33453.75
95-th percentile4517.15
Maximum221206
Range221205
Interquartile range (IQR)2376.5

Descriptive statistics

Standard deviation46682.775
Coefficient of variation (CV)3.6943822
Kurtosis16.003191
Mean12636.152
Median Absolute Deviation (MAD)1188.5
Skewness4.2402187
Sum54562904
Variance2.1792815 × 109
MonotonicityNot monotonic
2023-12-12T20:23:48.070897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
15 2
 
< 0.1%
1305 2
 
< 0.1%
1307 2
 
< 0.1%
1304 2
 
< 0.1%
1303 2
 
< 0.1%
1201 2
 
< 0.1%
1202 2
 
< 0.1%
1203 2
 
< 0.1%
1204 2
 
< 0.1%
1601 2
 
< 0.1%
Other values (4294) 4298
99.5%
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 (%)
221206 1
< 0.1%
221205 1
< 0.1%
221204 1
< 0.1%
221203 1
< 0.1%
221202 1
< 0.1%
221201 1
< 0.1%
221200 1
< 0.1%
221199 1
< 0.1%
221198 1
< 0.1%
221197 1
< 0.1%

법정구역
Categorical

HIGH CORRELATION 

Distinct27
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size33.9 KiB
태전동
857 
송정동
548 
역동
491 
경안동
406 
곤지암읍
394 
Other values (22)
1622 

Length

Max length5
Median length3
Mean length2.9761464
Min length2

Unique

Unique2 ?
Unique (%)< 0.1%

Sample

1st row회덕동
2nd row태전동
3rd row태전동
4th row곤지암읍
5th row곤지암읍

Common Values

ValueCountFrequency (%)
태전동 857
19.8%
송정동 548
12.7%
역동 491
11.4%
경안동 406
9.4%
곤지암읍 394
9.1%
신현동 298
 
6.9%
고산동 272
 
6.3%
양벌동 255
 
5.9%
초월읍 201
 
4.7%
장지동 181
 
4.2%
Other values (17) 415
9.6%

Length

2023-12-12T20:23:48.305739image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
태전동 857
19.8%
송정동 548
12.7%
역동 491
11.4%
경안동 406
9.4%
곤지암읍 394
9.1%
신현동 298
 
6.9%
고산동 272
 
6.3%
양벌동 255
 
5.9%
초월읍 201
 
4.7%
장지동 181
 
4.2%
Other values (17) 415
9.6%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size33.9 KiB
광주시
4318 

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 (%)
광주시 4318
100.0%

Length

2023-12-12T20:23:48.509853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:23:49.133613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광주시 4318
100.0%

도로구간번호
Real number (ℝ)

Distinct1415
Distinct (%)32.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23312.859
Minimum1
Maximum900424
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size38.1 KiB
2023-12-12T20:23:49.298161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile694.4
Q15360.25
median7070
Q38608
95-th percentile160231.75
Maximum900424
Range900423
Interquartile range (IQR)3247.75

Descriptive statistics

Standard deviation60025.33
Coefficient of variation (CV)2.5747734
Kurtosis89.61034
Mean23312.859
Median Absolute Deviation (MAD)1600
Skewness7.4312424
Sum1.0066492 × 108
Variance3.6030403 × 109
MonotonicityNot monotonic
2023-12-12T20:23:49.498072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
8924 27
 
0.6%
8910 22
 
0.5%
9134 22
 
0.5%
9065 22
 
0.5%
9042 22
 
0.5%
122005 21
 
0.5%
100224 19
 
0.4%
7 19
 
0.4%
9020 18
 
0.4%
5016 17
 
0.4%
Other values (1405) 4109
95.2%
ValueCountFrequency (%)
1 17
0.4%
2 8
0.2%
3 2
 
< 0.1%
4 6
 
0.1%
5 10
0.2%
6 5
 
0.1%
7 19
0.4%
8 5
 
0.1%
9 12
0.3%
10 5
 
0.1%
ValueCountFrequency (%)
900424 2
< 0.1%
900301 1
 
< 0.1%
900295 1
 
< 0.1%
900040 1
 
< 0.1%
900013 3
0.1%
700001 1
 
< 0.1%
360678 1
 
< 0.1%
360578 1
 
< 0.1%
360538 1
 
< 0.1%
360310 1
 
< 0.1%

연장
Real number (ℝ)

HIGH CORRELATION 

Distinct3206
Distinct (%)74.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean56.078059
Minimum0
Maximum2472
Zeros8
Zeros (%)0.2%
Negative0
Negative (%)0.0%
Memory size38.1 KiB
2023-12-12T20:23:49.704408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2.66
Q19.705
median27.06
Q360.0225
95-th percentile196.943
Maximum2472
Range2472
Interquartile range (IQR)50.3175

Descriptive statistics

Standard deviation107.96597
Coefficient of variation (CV)1.9252801
Kurtosis113.64959
Mean56.078059
Median Absolute Deviation (MAD)20.93
Skewness8.2024873
Sum242145.06
Variance11656.65
MonotonicityNot monotonic
2023-12-12T20:23:49.934159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2.0 39
 
0.9%
3.0 26
 
0.6%
4.0 22
 
0.5%
6.0 22
 
0.5%
5.0 22
 
0.5%
7.0 16
 
0.4%
8.0 15
 
0.3%
9.0 14
 
0.3%
10.0 11
 
0.3%
4.03 11
 
0.3%
Other values (3196) 4120
95.4%
ValueCountFrequency (%)
0.0 8
0.2%
0.03 1
 
< 0.1%
0.1 2
 
< 0.1%
0.2 1
 
< 0.1%
0.25 1
 
< 0.1%
0.29 1
 
< 0.1%
0.3 5
0.1%
0.35 1
 
< 0.1%
0.4 1
 
< 0.1%
0.43 1
 
< 0.1%
ValueCountFrequency (%)
2472.0 1
< 0.1%
1940.0 1
< 0.1%
1362.79 1
< 0.1%
1347.93 1
< 0.1%
1256.79 1
< 0.1%
1235.48 1
< 0.1%
1209.0 1
< 0.1%
1168.0 1
< 0.1%
1123.29 1
< 0.1%
1069.1 1
< 0.1%

면적
Real number (ℝ)

HIGH CORRELATION 

Distinct3864
Distinct (%)89.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean387.56174
Minimum0.1
Maximum32948.28
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size38.1 KiB
2023-12-12T20:23:50.188998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.1
5-th percentile4.6755
Q127.435
median104.195
Q3300.3125
95-th percentile1480.205
Maximum32948.28
Range32948.18
Interquartile range (IQR)272.8775

Descriptive statistics

Standard deviation1179.9295
Coefficient of variation (CV)3.0444944
Kurtosis189.2739
Mean387.56174
Median Absolute Deviation (MAD)91.28
Skewness10.770693
Sum1673491.6
Variance1392233.7
MonotonicityNot monotonic
2023-12-12T20:23:50.444159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1.4 28
 
0.6%
2.8 19
 
0.4%
5.6 17
 
0.4%
4.2 16
 
0.4%
2.1 15
 
0.3%
7.0 14
 
0.3%
3.5 11
 
0.3%
11.2 10
 
0.2%
4.9 10
 
0.2%
6.3 10
 
0.2%
Other values (3854) 4168
96.5%
ValueCountFrequency (%)
0.1 1
 
< 0.1%
0.13 1
 
< 0.1%
0.3 2
< 0.1%
0.63 1
 
< 0.1%
0.7 4
0.1%
0.75 1
 
< 0.1%
0.97 2
< 0.1%
1.0 1
 
< 0.1%
1.01 1
 
< 0.1%
1.05 1
 
< 0.1%
ValueCountFrequency (%)
32948.28 1
< 0.1%
16776.3 1
< 0.1%
15698.13 1
< 0.1%
15058.16 1
< 0.1%
14644.92 1
< 0.1%
13641.0 1
< 0.1%
13370.71 1
< 0.1%
13074.05 1
< 0.1%
13060.0 1
< 0.1%
12461.49 1
< 0.1%

폭원
Real number (ℝ)

HIGH CORRELATION 

Distinct1113
Distinct (%)25.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.2001274
Minimum0.05
Maximum70
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size38.1 KiB
2023-12-12T20:23:50.673760image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.05
5-th percentile0.7
Q12
median3.025
Q36.6075
95-th percentile16.963
Maximum70
Range69.95
Interquartile range (IQR)4.6075

Descriptive statistics

Standard deviation5.4059555
Coefficient of variation (CV)1.0395814
Kurtosis10.006731
Mean5.2001274
Median Absolute Deviation (MAD)1.485
Skewness2.5008059
Sum22454.15
Variance29.224355
MonotonicityNot monotonic
2023-12-12T20:23:50.923685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.7 393
 
9.1%
3.0 62
 
1.4%
2.0 55
 
1.3%
2.5 46
 
1.1%
1.5 39
 
0.9%
4.5 32
 
0.7%
3.01 31
 
0.7%
2.02 31
 
0.7%
4.01 27
 
0.6%
1.99 27
 
0.6%
Other values (1103) 3575
82.8%
ValueCountFrequency (%)
0.05 3
 
0.1%
0.08 2
 
< 0.1%
0.3 1
 
< 0.1%
0.43 1
 
< 0.1%
0.57 1
 
< 0.1%
0.67 1
 
< 0.1%
0.7 393
9.1%
0.74 1
 
< 0.1%
0.75 1
 
< 0.1%
0.8 4
 
0.1%
ValueCountFrequency (%)
70.0 1
< 0.1%
43.38 1
< 0.1%
39.27 1
< 0.1%
36.63 1
< 0.1%
35.91 1
< 0.1%
35.48 1
< 0.1%
33.47 1
< 0.1%
32.62 1
< 0.1%
32.34 1
< 0.1%
31.65 1
< 0.1%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size33.9 KiB
2023-11-21
4318 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-11-21
2nd row2023-11-21
3rd row2023-11-21
4th row2023-11-21
5th row2023-11-21

Common Values

ValueCountFrequency (%)
2023-11-21 4318
100.0%

Length

2023-12-12T20:23:51.149043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:23:51.295822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-11-21 4318
100.0%

Interactions

2023-12-12T20:23:45.929170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:42.755013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:43.471270image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:44.325876image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:45.091767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:46.106930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:42.884983image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:43.644933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:44.478133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:45.234287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:46.295202image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:43.009947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:43.838926image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:44.627056image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:45.394548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:46.483757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:43.137508image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:43.984168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:44.781982image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:45.573439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:46.674621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:43.303192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:44.157191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:44.924644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:23:45.745225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T20:23:51.416277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지형지물부호관리번호법정구역도로구간번호연장면적폭원
지형지물부호1.0000.0680.2860.1430.1610.1320.679
관리번호0.0681.0000.8430.0650.0000.0000.000
법정구역0.2860.8431.0000.7330.4170.5380.223
도로구간번호0.1430.0650.7331.0000.3660.5170.085
연장0.1610.0000.4170.3661.0000.7160.198
면적0.1320.0000.5380.5170.7161.0000.205
폭원0.6790.0000.2230.0850.1980.2051.000
2023-12-12T20:23:51.606511image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
법정구역지형지물부호
법정구역1.0000.153
지형지물부호0.1531.000
2023-12-12T20:23:51.755455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호도로구간번호연장면적폭원지형지물부호법정구역
관리번호1.0000.4990.0090.0850.2870.0450.702
도로구간번호0.4991.0000.0470.0780.1190.0980.419
연장0.0090.0471.0000.8040.2320.0730.180
면적0.0850.0780.8041.0000.6280.0910.261
폭원0.2870.1190.2320.6281.0000.3590.091
지형지물부호0.0450.0980.0730.0910.3591.0000.153
법정구역0.7020.4190.1800.2610.0910.1531.000

Missing values

2023-12-12T20:23:46.947690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T20:23:47.197391image/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차도면3940회덕동광주시891971.7303.225.22023-11-21
1차도면1980태전동광주시581756.47420.967.462023-11-21
2보도면1983태전동광주시5832138.81342.512.992023-11-21
3차도포장221206곤지암읍광주시837749.88593.6311.02023-11-21
4차도포장221205곤지암읍광주시935029.22385.5114.42023-11-21
5차도포장221204곤지암읍광주시837616.41179.9311.02023-11-21
6차도포장221203곤지암읍광주시836130.98440.1815.32023-11-21
7차도포장221202곤지암읍광주시837624.45322.3712.52023-11-21
8차도포장221201곤지암읍광주시8375117.43976.338.02023-11-21
9차도포장221200곤지암읍광주시8377107.57932.527.92023-11-21
지형지물부호관리번호법정구역관리기관도로구간번호연장면적폭원데이터기준일자
4308보도포장353곤지암읍광주시7198.15600.73.082023-11-21
4309보도포장351곤지암읍광주시771.73214.323.022023-11-21
4310보도포장348곤지암읍광주시1667.75173.132.32023-11-21
4311보도포장347추자동광주시22141.04395.632.862023-11-21
4312보도포장346곤지암읍광주시4111.57387.693.472023-11-21
4313보도포장341추자동광주시2293.33263.162.792023-11-21
4314보도포장340추자동광주시223.226.972.352023-11-21
4315보도포장339추자동광주시253.05.761.52023-11-21
4316보도포장338추자동광주시22125.67350.432.752023-11-21
4317보도포장336곤지암읍광주시29.2622.582.572023-11-21