Overview

Dataset statistics

Number of variables9
Number of observations579
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory43.1 KiB
Average record size in memory76.2 B

Variable types

Categorical5
Numeric4

Dataset

Description경기도 광주시 관내 미끄럼방지시설 현황에 대한 데이터로 지형지물부호, 관리번호, 도로구간번호, 설치일자, 폭원,연장 등을 제공합니다.
Author경기도 광주시
URLhttps://www.data.go.kr/data/15042244/fileData.do

Alerts

지형지물부호 has constant value ""Constant
관리기관 has constant value ""Constant
법정구역 is highly overall correlated with 관리번호 and 2 other fieldsHigh correlation
행정구역 is highly overall correlated with 관리번호 and 2 other fieldsHigh correlation
관리번호 is highly overall correlated with 도로구간번호 and 2 other fieldsHigh correlation
도로구간번호 is highly overall correlated with 관리번호 and 2 other fieldsHigh correlation
포장종류 is highly imbalanced (59.8%)Imbalance
관리번호 has unique valuesUnique

Reproduction

Analysis started2023-12-16 15:58:53.054700
Analysis finished2023-12-16 15:59:02.481852
Duration9.43 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지형지물부호
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
미끄럼방지시설
579 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row미끄럼방지시설
2nd row미끄럼방지시설
3rd row미끄럼방지시설
4th row미끄럼방지시설
5th row미끄럼방지시설

Common Values

ValueCountFrequency (%)
미끄럼방지시설 579
100.0%

Length

2023-12-16T15:59:02.800351image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:59:03.256458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
미끄럼방지시설 579
100.0%

관리번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct579
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18781978
Minimum1
Maximum92021003
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.2 KiB
2023-12-16T15:59:03.768385image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile111.9
Q1232.5
median175001
Q31733503
95-th percentile91569204
Maximum92021003
Range92021002
Interquartile range (IQR)1733270.5

Descriptive statistics

Standard deviation35920498
Coefficient of variation (CV)1.9124982
Kurtosis0.2323846
Mean18781978
Median Absolute Deviation (MAD)174892
Skewness1.4775169
Sum1.0874765 × 1010
Variance1.2902822 × 1015
MonotonicityStrictly decreasing
2023-12-16T15:59:04.412383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
92021003 1
 
0.2%
303 1
 
0.2%
283 1
 
0.2%
282 1
 
0.2%
281 1
 
0.2%
280 1
 
0.2%
279 1
 
0.2%
278 1
 
0.2%
277 1
 
0.2%
276 1
 
0.2%
Other values (569) 569
98.3%
ValueCountFrequency (%)
1 1
0.2%
2 1
0.2%
4 1
0.2%
8 1
0.2%
9 1
0.2%
10 1
0.2%
11 1
0.2%
12 1
0.2%
13 1
0.2%
19 1
0.2%
ValueCountFrequency (%)
92021003 1
0.2%
92021001 1
0.2%
92013001 1
0.2%
92004002 1
0.2%
92004001 1
0.2%
92003001 1
0.2%
92001001 1
0.2%
91918002 1
0.2%
91918001 1
0.2%
91917002 1
0.2%

도로구간번호
Real number (ℝ)

HIGH CORRELATION 

Distinct272
Distinct (%)47.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean146910.96
Minimum0
Maximum900349
Zeros2
Zeros (%)0.3%
Negative0
Negative (%)0.0%
Memory size5.2 KiB
2023-12-16T15:59:05.203273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile5035
Q16155
median122757
Q3240396
95-th percentile360551.7
Maximum900349
Range900349
Interquartile range (IQR)234241

Descriptive statistics

Standard deviation178623.11
Coefficient of variation (CV)1.2158597
Kurtosis6.7716995
Mean146910.96
Median Absolute Deviation (MAD)116646
Skewness2.2074083
Sum85061446
Variance3.1906216 × 1010
MonotonicityNot monotonic
2023-12-16T15:59:06.030888image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
6152 23
 
4.0%
8185 16
 
2.8%
320351 12
 
2.1%
123272 11
 
1.9%
320011 11
 
1.9%
320264 10
 
1.7%
240452 9
 
1.6%
8910 8
 
1.4%
5601 8
 
1.4%
240396 8
 
1.4%
Other values (262) 463
80.0%
ValueCountFrequency (%)
0 2
0.3%
1 2
0.3%
13 1
 
0.2%
205 1
 
0.2%
212 1
 
0.2%
564 2
0.3%
1427 1
 
0.2%
1505 4
0.7%
1512 3
0.5%
1718 1
 
0.2%
ValueCountFrequency (%)
900349 1
 
0.2%
900342 7
1.2%
900341 4
0.7%
900116 1
 
0.2%
900050 2
 
0.3%
900028 1
 
0.2%
900013 1
 
0.2%
360972 1
 
0.2%
360946 3
0.5%
360917 1
 
0.2%

행정구역
Categorical

HIGH CORRELATION 

Distinct15
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
경안동
66 
광남2동
62 
초월읍
62 
광남1동
58 
송정동
47 
Other values (10)
284 

Length

Max length5
Median length3
Mean length3.4214162
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경안동
2nd row오포1동
3rd row오포1동
4th row오포1동
5th row오포1동

Common Values

ValueCountFrequency (%)
경안동 66
11.4%
광남2동 62
10.7%
초월읍 62
10.7%
광남1동 58
10.0%
송정동 47
8.1%
남종면 47
8.1%
신현동 45
7.8%
퇴촌면 45
7.8%
곤지암읍 41
7.1%
오포1동 33
5.7%
Other values (5) 73
12.6%

Length

2023-12-16T15:59:06.697088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경안동 66
11.4%
광남2동 62
10.7%
초월읍 62
10.7%
광남1동 58
10.0%
송정동 47
8.1%
남종면 47
8.1%
신현동 45
7.8%
퇴촌면 45
7.8%
곤지암읍 41
7.1%
오포1동 33
5.7%
Other values (5) 73
12.6%

법정구역
Categorical

HIGH CORRELATION 

Distinct26
Distinct (%)4.5%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
초월읍
62 
태전동
62 
남종면
47 
퇴촌면
45 
신현동
45 
Other values (21)
318 

Length

Max length5
Median length3
Mean length3.015544
Min length2

Unique

Unique1 ?
Unique (%)0.2%

Sample

1st row쌍령동
2nd row문형동
3rd row문형동
4th row문형동
5th row문형동

Common Values

ValueCountFrequency (%)
초월읍 62
 
10.7%
태전동 62
 
10.7%
남종면 47
 
8.1%
퇴촌면 45
 
7.8%
신현동 45
 
7.8%
곤지암읍 41
 
7.1%
송정동 32
 
5.5%
쌍령동 31
 
5.4%
삼동 28
 
4.8%
도척면 25
 
4.3%
Other values (16) 161
27.8%

Length

2023-12-16T15:59:07.514241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
초월읍 62
 
10.7%
태전동 62
 
10.7%
남종면 47
 
8.1%
퇴촌면 45
 
7.8%
신현동 45
 
7.8%
곤지암읍 41
 
7.1%
송정동 32
 
5.5%
쌍령동 31
 
5.4%
삼동 28
 
4.8%
도척면 25
 
4.3%
Other values (16) 161
27.8%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
경기도 광주시청
579 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기도 광주시청
2nd row경기도 광주시청
3rd row경기도 광주시청
4th row경기도 광주시청
5th row경기도 광주시청

Common Values

ValueCountFrequency (%)
경기도 광주시청 579
100.0%

Length

2023-12-16T15:59:08.114847image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:59:08.763301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 579
50.0%
광주시청 579
50.0%

포장종류
Categorical

IMBALANCE 

Distinct6
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size4.7 KiB
아스콘(아스팔트콘크리트)
442 
기타
103 
투수성콘크리트
 
27
투수성아스팔트
 
4
화강석타일
 
2

Length

Max length13
Median length13
Mean length10.680484
Min length2

Unique

Unique1 ?
Unique (%)0.2%

Sample

1st row세라믹블록
2nd row아스콘(아스팔트콘크리트)
3rd row아스콘(아스팔트콘크리트)
4th row아스콘(아스팔트콘크리트)
5th row아스콘(아스팔트콘크리트)

Common Values

ValueCountFrequency (%)
아스콘(아스팔트콘크리트) 442
76.3%
기타 103
 
17.8%
투수성콘크리트 27
 
4.7%
투수성아스팔트 4
 
0.7%
화강석타일 2
 
0.3%
세라믹블록 1
 
0.2%

Length

2023-12-16T15:59:09.967676image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:59:10.699703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
아스콘(아스팔트콘크리트 442
76.3%
기타 103
 
17.8%
투수성콘크리트 27
 
4.7%
투수성아스팔트 4
 
0.7%
화강석타일 2
 
0.3%
세라믹블록 1
 
0.2%

폭원(미터)
Real number (ℝ)

Distinct329
Distinct (%)56.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7.158342
Minimum0
Maximum236.25
Zeros1
Zeros (%)0.2%
Negative0
Negative (%)0.0%
Memory size5.2 KiB
2023-12-16T15:59:11.938449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2.54
Q13
median3.65
Q36.06
95-th percentile10.072
Maximum236.25
Range236.25
Interquartile range (IQR)3.06

Descriptive statistics

Standard deviation18.899504
Coefficient of variation (CV)2.6402069
Kurtosis76.887053
Mean7.158342
Median Absolute Deviation (MAD)1.02
Skewness8.3987128
Sum4144.68
Variance357.19126
MonotonicityNot monotonic
2023-12-16T15:59:13.554305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3.0 28
 
4.8%
3.24 7
 
1.2%
6.0 7
 
1.2%
2.93 6
 
1.0%
3.01 6
 
1.0%
3.22 6
 
1.0%
2.99 6
 
1.0%
3.18 5
 
0.9%
2.71 5
 
0.9%
2.97 5
 
0.9%
Other values (319) 498
86.0%
ValueCountFrequency (%)
0.0 1
0.2%
0.86 1
0.2%
0.94 1
0.2%
1.34 1
0.2%
1.39 1
0.2%
1.42 1
0.2%
1.47 1
0.2%
1.53 2
0.3%
1.55 1
0.2%
1.59 1
0.2%
ValueCountFrequency (%)
236.25 1
0.2%
176.47 1
0.2%
171.32 1
0.2%
168.34 1
0.2%
153.56 1
0.2%
117.81 1
0.2%
115.04 1
0.2%
96.51 1
0.2%
79.15 1
0.2%
65.45 1
0.2%

연장(미터)
Real number (ℝ)

Distinct543
Distinct (%)93.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean62.664801
Minimum0
Maximum892.64
Zeros1
Zeros (%)0.2%
Negative0
Negative (%)0.0%
Memory size5.2 KiB
2023-12-16T15:59:14.648268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1.322
Q115.735
median35.6
Q377.44
95-th percentile212.318
Maximum892.64
Range892.64
Interquartile range (IQR)61.705

Descriptive statistics

Standard deviation86.244754
Coefficient of variation (CV)1.376287
Kurtosis25.540599
Mean62.664801
Median Absolute Deviation (MAD)24.84
Skewness4.0859775
Sum36282.92
Variance7438.1576
MonotonicityNot monotonic
2023-12-16T15:59:15.778579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.99 5
 
0.9%
1.01 4
 
0.7%
0.97 4
 
0.7%
1.0 3
 
0.5%
0.98 3
 
0.5%
10.76 3
 
0.5%
3.97 2
 
0.3%
35.22 2
 
0.3%
0.95 2
 
0.3%
0.96 2
 
0.3%
Other values (533) 549
94.8%
ValueCountFrequency (%)
0.0 1
 
0.2%
0.95 2
 
0.3%
0.96 2
 
0.3%
0.97 4
0.7%
0.98 3
0.5%
0.99 5
0.9%
1.0 3
0.5%
1.01 4
0.7%
1.02 1
 
0.2%
1.03 1
 
0.2%
ValueCountFrequency (%)
892.64 1
0.2%
728.06 1
0.2%
589.16 1
0.2%
459.43 1
0.2%
445.15 1
0.2%
440.5 1
0.2%
404.93 1
0.2%
403.12 1
0.2%
381.41 1
0.2%
362.88 1
0.2%

Interactions

2023-12-16T15:58:59.938715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:58:54.609334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:58:56.590529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:58:58.545645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:59:00.202542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:58:55.057607image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:58:57.204789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:58:58.874043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:59:00.502149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:58:55.609088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:58:57.618761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:58:59.164351image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:59:00.788078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:58:56.114520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:58:58.086726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:58:59.488084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-16T15:59:16.181946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호도로구간번호행정구역법정구역포장종류폭원(미터)연장(미터)
관리번호1.0000.6880.7550.8250.2050.0000.189
도로구간번호0.6881.0000.9110.9180.7560.5120.210
행정구역0.7550.9111.0001.0000.7020.4050.226
법정구역0.8250.9181.0001.0000.7330.3010.596
포장종류0.2050.7560.7020.7331.0000.0000.000
폭원(미터)0.0000.5120.4050.3010.0001.0000.000
연장(미터)0.1890.2100.2260.5960.0000.0001.000
2023-12-16T15:59:16.619368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
포장종류법정구역행정구역
포장종류1.0000.4310.416
법정구역0.4311.0000.990
행정구역0.4160.9901.000
2023-12-16T15:59:17.098081image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호도로구간번호폭원(미터)연장(미터)행정구역법정구역포장종류
관리번호1.0000.549-0.2990.2900.5380.5850.133
도로구간번호0.5491.000-0.1280.2010.7110.7090.365
폭원(미터)-0.299-0.1281.0000.0800.1850.1220.000
연장(미터)0.2900.2010.0801.0000.0930.2660.000
행정구역0.5380.7110.1850.0931.0000.9900.416
법정구역0.5850.7090.1220.2660.9901.0000.431
포장종류0.1330.3650.0000.0000.4160.4311.000

Missing values

2023-12-16T15:59:01.586811image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-16T15:59:02.284944image/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미끄럼방지시설92021003160467경안동쌍령동경기도 광주시청세라믹블록21.265.14
1미끄럼방지시설92021001120694오포1동문형동경기도 광주시청아스콘(아스팔트콘크리트)6.082.96
2미끄럼방지시설92013001120140오포1동문형동경기도 광주시청아스콘(아스팔트콘크리트)3.08.97
3미끄럼방지시설92004002120164오포1동문형동경기도 광주시청아스콘(아스팔트콘크리트)3.0106.53
4미끄럼방지시설92004001120141오포1동문형동경기도 광주시청아스콘(아스팔트콘크리트)3.08.97
5미끄럼방지시설92003001120156오포1동문형동경기도 광주시청아스콘(아스팔트콘크리트)3.092.25
6미끄럼방지시설92001001120700오포1동문형동경기도 광주시청아스콘(아스팔트콘크리트)3.0109.22
7미끄럼방지시설91918002900050능평동능평동경기도 광주시청투수성콘크리트3.4116.93
8미끄럼방지시설91918001900050능평동능평동경기도 광주시청투수성콘크리트3.42122.59
9미끄럼방지시설91917002120748능평동능평동경기도 광주시청아스콘(아스팔트콘크리트)7.0167.79
지형지물부호관리번호도로구간번호행정구역법정구역관리기관포장종류폭원(미터)연장(미터)
569미끄럼방지시설191512경안동경안동경기도 광주시청아스콘(아스팔트콘크리트)2.9716.8
570미끄럼방지시설13212경안동경안동경기도 광주시청아스콘(아스팔트콘크리트)4.1639.49
571미끄럼방지시설121505경안동경안동경기도 광주시청아스콘(아스팔트콘크리트)5.23149.5
572미끄럼방지시설111505경안동경안동경기도 광주시청아스콘(아스팔트콘크리트)6.2375.13
573미끄럼방지시설100광남2동태전동경기도 광주시청아스콘(아스팔트콘크리트)8.5719.17
574미끄럼방지시설91505경안동경안동경기도 광주시청아스콘(아스팔트콘크리트)5.6410.89
575미끄럼방지시설81505경안동경안동경기도 광주시청아스콘(아스팔트콘크리트)4.3429.88
576미끄럼방지시설4205경안동경안동경기도 광주시청아스콘(아스팔트콘크리트)4.6951.91
577미끄럼방지시설2564송정동송정동경기도 광주시청아스콘(아스팔트콘크리트)2.9851.89
578미끄럼방지시설1564송정동송정동경기도 광주시청아스콘(아스팔트콘크리트)2.9740.62