Overview

Dataset statistics

Number of variables21
Number of observations4612
Missing cells0
Missing cells (%)0.0%
Duplicate rows83
Duplicate rows (%)1.8%
Total size in memory792.8 KiB
Average record size in memory176.0 B

Variable types

Categorical17
Numeric4

Dataset

Description경기도 화성시_자전거도로에 대한 데이터로 지형지물부호, 관리번호, 행정읍면동, 관리기관, 설치일자, 자전거노선명, 자전거도로구분, 위치구분, 자전거도로재질, 연장, 폭원, 국비, 시비, 기타비, 경계종류, 대장초기화여부, 비고, 도로구간번호, 공사번호, 납품업체, 로딩일자 등의 항목을 제공하고 있습니다.
Author경기도 화성시
URLhttps://www.data.go.kr/data/15093544/fileData.do

Alerts

국비 has constant value ""Constant
시비 has constant value ""Constant
기타비 has constant value ""Constant
대장초기화여부 has constant value ""Constant
Dataset has 83 (1.8%) duplicate rowsDuplicates
지형지물부호 is highly imbalanced (98.0%)Imbalance
관리기관 is highly imbalanced (62.4%)Imbalance
자전거노선명 is highly imbalanced (87.9%)Imbalance
공사번호 is highly imbalanced (99.5%)Imbalance
도로구간번호 has 83 (1.8%) zerosZeros

Reproduction

Analysis started2023-12-12 02:25:07.261308
Analysis finished2023-12-12 02:25:07.761552
Duration0.5 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지형지물부호
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size36.2 KiB
자전거도로
4603 
보도구간
 
9

Length

Max length5
Median length5
Mean length4.9980486
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row자전거도로
2nd row자전거도로
3rd row자전거도로
4th row자전거도로
5th row자전거도로

Common Values

ValueCountFrequency (%)
자전거도로 4603
99.8%
보도구간 9
 
0.2%

Length

2023-12-12T11:25:07.831015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:25:07.941417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
자전거도로 4603
99.8%
보도구간 9
 
0.2%

관리번호
Real number (ℝ)

Distinct990
Distinct (%)21.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.5263513 × 1013
Minimum100002
Maximum8.99919 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size40.7 KiB
2023-12-12T11:25:08.084441image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum100002
5-th percentile411042.55
Q12.11302 × 1011
median5.31509 × 1011
Q38.21118 × 1013
95-th percentile8.99919 × 1013
Maximum8.99919 × 1013
Range8.99919 × 1013
Interquartile range (IQR)8.1900498 × 1013

Descriptive statistics

Standard deviation3.7694428 × 1013
Coefficient of variation (CV)1.4920502
Kurtosis-0.8920904
Mean2.5263513 × 1013
Median Absolute Deviation (MAD)5.3150859 × 1011
Skewness1.0105417
Sum1.1651532 × 1017
Variance1.4208699 × 1027
MonotonicityNot monotonic
2023-12-12T11:25:08.247620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
89991900000000 587
 
12.7%
511308000000 334
 
7.2%
511307000000 239
 
5.2%
89991600000000 226
 
4.9%
888615000000 216
 
4.7%
215304000000 182
 
3.9%
531509000000 162
 
3.5%
82111800000000 158
 
3.4%
206307000000 133
 
2.9%
82161800000000 116
 
2.5%
Other values (980) 2259
49.0%
ValueCountFrequency (%)
100002 1
< 0.1%
100003 1
< 0.1%
100004 1
< 0.1%
100005 1
< 0.1%
100006 1
< 0.1%
100007 1
< 0.1%
100008 1
< 0.1%
100009 1
< 0.1%
100010 1
< 0.1%
100011 1
< 0.1%
ValueCountFrequency (%)
89991900000000 587
12.7%
89991600000000 226
 
4.9%
82992000000000 66
 
1.4%
82162000000000 1
 
< 0.1%
82161900000000 6
 
0.1%
82161800000000 116
 
2.5%
82112000000000 51
 
1.1%
82111900000000 2
 
< 0.1%
82111800000000 158
 
3.4%
32161800000000 106
 
2.3%

행정읍면동
Categorical

Distinct23
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size36.2 KiB
<NA>
1207 
동탄6동
676 
향남읍
387 
서신면
269 
남양읍
251 
Other values (18)
1822 

Length

Max length4
Median length4
Mean length3.5888985
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row향남읍
2nd row봉담읍
3rd row진안동
4th row향남읍
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 1207
26.2%
동탄6동 676
14.7%
향남읍 387
 
8.4%
서신면 269
 
5.8%
남양읍 251
 
5.4%
반월동 229
 
5.0%
진안동 203
 
4.4%
동탄4동 171
 
3.7%
동탄2동 164
 
3.6%
동탄1동 154
 
3.3%
Other values (13) 901
19.5%

Length

2023-12-12T11:25:08.392104image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 1207
26.2%
동탄6동 676
14.7%
향남읍 387
 
8.4%
서신면 269
 
5.8%
남양읍 251
 
5.4%
반월동 229
 
5.0%
진안동 203
 
4.4%
동탄4동 171
 
3.7%
동탄2동 164
 
3.6%
동탄1동 154
 
3.3%
Other values (13) 901
19.5%

관리기관
Categorical

IMBALANCE 

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size36.2 KiB
<NA>
3987 
도로과
609 
화성시
 
16

Length

Max length4
Median length4
Mean length3.864484
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 3987
86.4%
도로과 609
 
13.2%
화성시 16
 
0.3%

Length

2023-12-12T11:25:08.531590image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:25:08.639320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 3987
86.4%
도로과 609
 
13.2%
화성시 16
 
0.3%

설치일자
Categorical

Distinct39
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size36.2 KiB
2014-01-01
928 
2016-01-01
663 
2007-11-01
402 
354 
1900-01-01
289 
Other values (34)
1976 

Length

Max length10
Median length10
Mean length9.3091934
Min length1

Unique

Unique3 ?
Unique (%)0.1%

Sample

1st row2009-01-01
2nd row2008-07-24
3rd row1900-01-01
4th row2009-01-01
5th row2010-01-01

Common Values

ValueCountFrequency (%)
2014-01-01 928
20.1%
2016-01-01 663
14.4%
2007-11-01 402
8.7%
354
 
7.7%
1900-01-01 289
 
6.3%
2017-01-01 265
 
5.7%
2018-01-01 264
 
5.7%
2015-01-01 204
 
4.4%
2017-12-31 139
 
3.0%
2019-12-01 110
 
2.4%
Other values (29) 994
21.6%

Length

2023-12-12T11:25:08.744233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2014-01-01 928
21.8%
2016-01-01 663
15.6%
2007-11-01 402
9.4%
1900-01-01 289
 
6.8%
2017-01-01 265
 
6.2%
2018-01-01 264
 
6.2%
2015-01-01 204
 
4.8%
2017-12-31 139
 
3.3%
2019-12-01 110
 
2.6%
2006-06-20 106
 
2.5%
Other values (28) 888
20.9%

자전거노선명
Categorical

IMBALANCE 

Distinct23
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size36.2 KiB
4298 
도시계획도
 
147
국지도084
 
48
지방도318호
 
32
조암택지
 
19
Other values (18)
 
68

Length

Max length8
Median length1
Mean length1.3187337
Min length1

Unique

Unique5 ?
Unique (%)0.1%

Sample

1st row
2nd row
3rd row도시계획도
4th row
5th row

Common Values

ValueCountFrequency (%)
4298
93.2%
도시계획도 147
 
3.2%
국지도084 48
 
1.0%
지방도318호 32
 
0.7%
조암택지 19
 
0.4%
시도71호선 14
 
0.3%
미분류3025 11
 
0.2%
미분류3029 7
 
0.2%
미분류2107 6
 
0.1%
미분류2085 4
 
0.1%
Other values (13) 26
 
0.6%

Length

2023-12-12T11:25:08.870953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
도시계획도 147
46.8%
국지도084 48
 
15.3%
지방도318호 32
 
10.2%
조암택지 19
 
6.1%
시도71호선 14
 
4.5%
미분류3025 11
 
3.5%
미분류3029 7
 
2.2%
미분류2107 6
 
1.9%
미분류2085 4
 
1.3%
지방도315호 4
 
1.3%
Other values (12) 22
 
7.0%

자전거도로구분
Categorical

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size36.2 KiB
자전거보행자겸용도로
2876 
자전거 횡단보도
773 
자전거전용도로
629 
자전거자동차겸용도로
304 
미분류
 
30

Length

Max length10
Median length10
Mean length9.2101041
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row자전거전용도로
2nd row자전거전용도로
3rd row자전거보행자겸용도로
4th row자전거전용도로
5th row자전거보행자겸용도로

Common Values

ValueCountFrequency (%)
자전거보행자겸용도로 2876
62.4%
자전거 횡단보도 773
 
16.8%
자전거전용도로 629
 
13.6%
자전거자동차겸용도로 304
 
6.6%
미분류 30
 
0.7%

Length

2023-12-12T11:25:09.007898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:25:09.122188image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
자전거보행자겸용도로 2876
53.4%
자전거 773
 
14.4%
횡단보도 773
 
14.4%
자전거전용도로 629
 
11.7%
자전거자동차겸용도로 304
 
5.6%
미분류 30
 
0.6%

위치구분
Categorical

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size36.2 KiB
우
1911 
좌
1762 
중앙
870 
기타
 
39
미분류
 
30

Length

Max length3
Median length1
Mean length1.2101041
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row좌
2nd row좌
3rd row우
4th row우
5th row우

Common Values

ValueCountFrequency (%)
우 1911
41.4%
좌 1762
38.2%
중앙 870
18.9%
기타 39
 
0.8%
미분류 30
 
0.7%

Length

2023-12-12T11:25:09.263106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:25:09.402092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
우 1911
41.4%
좌 1762
38.2%
중앙 870
18.9%
기타 39
 
0.8%
미분류 30
 
0.7%

자전거도로재질
Categorical

Distinct7
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size36.2 KiB
투수성콘크리트
1528 
아스콘
1276 
아스팔트
1167 
소형고압블럭
521 
블록
 
74
Other values (2)
 
46

Length

Max length7
Median length6
Mean length4.8976583
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row투수성콘크리트
2nd row투수성콘크리트
3rd row투수성콘크리트
4th row투수성콘크리트
5th row아스콘

Common Values

ValueCountFrequency (%)
투수성콘크리트 1528
33.1%
아스콘 1276
27.7%
아스팔트 1167
25.3%
소형고압블럭 521
 
11.3%
블록 74
 
1.6%
미분류 30
 
0.7%
기타 16
 
0.3%

Length

2023-12-12T11:25:09.516061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:25:09.623512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
투수성콘크리트 1528
33.1%
아스콘 1276
27.7%
아스팔트 1167
25.3%
소형고압블럭 521
 
11.3%
블록 74
 
1.6%
미분류 30
 
0.7%
기타 16
 
0.3%

연장
Real number (ℝ)

Distinct3374
Distinct (%)73.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean64.267125
Minimum0
Maximum1339.19
Zeros1
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size40.7 KiB
2023-12-12T11:25:09.787846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1.1
Q112.9
median32.585
Q379.4825
95-th percentile219.9565
Maximum1339.19
Range1339.19
Interquartile range (IQR)66.5825

Descriptive statistics

Standard deviation94.484182
Coefficient of variation (CV)1.4701791
Kurtosis34.447058
Mean64.267125
Median Absolute Deviation (MAD)23.23
Skewness4.5745885
Sum296399.98
Variance8927.2607
MonotonicityNot monotonic
2023-12-12T11:25:09.981658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1.1 331
 
7.2%
1.0 13
 
0.3%
12.0 10
 
0.2%
11.0 8
 
0.2%
2.0 7
 
0.2%
7.0 7
 
0.2%
4.0 6
 
0.1%
9.99 6
 
0.1%
30.0 6
 
0.1%
32.0 6
 
0.1%
Other values (3364) 4212
91.3%
ValueCountFrequency (%)
0.0 1
 
< 0.1%
0.23 1
 
< 0.1%
0.43 1
 
< 0.1%
0.95 1
 
< 0.1%
1.0 13
 
0.3%
1.1 331
7.2%
1.18 1
 
< 0.1%
1.24 1
 
< 0.1%
1.81 1
 
< 0.1%
2.0 7
 
0.2%
ValueCountFrequency (%)
1339.19 1
< 0.1%
1253.92 1
< 0.1%
1071.56 1
< 0.1%
1068.0 1
< 0.1%
1021.97 1
< 0.1%
984.08 1
< 0.1%
950.59 1
< 0.1%
845.84 1
< 0.1%
790.51 1
< 0.1%
783.47 1
< 0.1%

폭원
Real number (ℝ)

Distinct360
Distinct (%)7.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.2068322
Minimum0
Maximum12
Zeros1
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size40.7 KiB
2023-12-12T11:25:10.175036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1.33
Q11.87
median2.1
Q32.48
95-th percentile3.209
Maximum12
Range12
Interquartile range (IQR)0.61

Descriptive statistics

Standard deviation0.74113903
Coefficient of variation (CV)0.33583842
Kurtosis15.222891
Mean2.2068322
Median Absolute Deviation (MAD)0.35
Skewness2.4691072
Sum10177.91
Variance0.54928706
MonotonicityNot monotonic
2023-12-12T11:25:10.354079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2.1 458
 
9.9%
2.0 363
 
7.9%
1.5 138
 
3.0%
1.9 136
 
2.9%
2.4 118
 
2.6%
2.2 103
 
2.2%
3.0 78
 
1.7%
1.53 56
 
1.2%
1.49 53
 
1.1%
2.01 51
 
1.1%
Other values (350) 3058
66.3%
ValueCountFrequency (%)
0.0 1
 
< 0.1%
0.37 1
 
< 0.1%
0.43 1
 
< 0.1%
0.53 1
 
< 0.1%
0.54 1
 
< 0.1%
0.73 1
 
< 0.1%
0.75 1
 
< 0.1%
0.78 1
 
< 0.1%
0.79 3
0.1%
0.8 2
< 0.1%
ValueCountFrequency (%)
12.0 1
< 0.1%
7.43 1
< 0.1%
7.42 1
< 0.1%
7.39 1
< 0.1%
7.36 1
< 0.1%
7.19 1
< 0.1%
7.11 1
< 0.1%
7.06 1
< 0.1%
7.04 1
< 0.1%
7.02 2
< 0.1%

국비
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size36.2 KiB
0
4612 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 4612
100.0%

Length

2023-12-12T11:25:10.485617image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:25:10.593327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 4612
100.0%

시비
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size36.2 KiB
0
4612 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 4612
100.0%

Length

2023-12-12T11:25:10.696840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:25:10.789844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 4612
100.0%

기타비
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size36.2 KiB
0
4612 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 4612
100.0%

Length

2023-12-12T11:25:10.931262image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:25:11.044450image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 4612
100.0%

경계종류
Categorical

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size36.2 KiB
경계석
3017 
도색
1361 
고압블록
 
178
미분류
 
33
기타
 
23

Length

Max length4
Median length3
Mean length2.7385082
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경계석
2nd row경계석
3rd row도색
4th row경계석
5th row경계석

Common Values

ValueCountFrequency (%)
경계석 3017
65.4%
도색 1361
29.5%
고압블록 178
 
3.9%
미분류 33
 
0.7%
기타 23
 
0.5%

Length

2023-12-12T11:25:11.172720image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:25:11.288858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경계석 3017
65.4%
도색 1361
29.5%
고압블록 178
 
3.9%
미분류 33
 
0.7%
기타 23
 
0.5%

대장초기화여부
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size36.2 KiB
1
4612 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row1
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 4612
100.0%

Length

2023-12-12T11:25:11.403402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:25:11.528017image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 4612
100.0%

비고
Categorical

Distinct41
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size36.2 KiB
2013 
화성동탄 일반산업단지 조성공사 중 GIS구축
573 
동탄(2)택지개발사업 부지공사(1단계)GIS DB구축용역
355 
화성 향남 2지구 도로 및 지하시설물 DB 구축(20170831)
242 
화성 남양 뉴타운 도로 및 지하시설물 GIS 구축 용역(2차)
232 
Other values (36)
1197 

Length

Max length56
Median length50
Mean length17.947528
Min length1

Unique

Unique4 ?
Unique (%)0.1%

Sample

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

Common Values

ValueCountFrequency (%)
2013
43.6%
화성동탄 일반산업단지 조성공사 중 GIS구축 573
 
12.4%
동탄(2)택지개발사업 부지공사(1단계)GIS DB구축용역 355
 
7.7%
화성 향남 2지구 도로 및 지하시설물 DB 구축(20170831) 242
 
5.2%
화성 남양 뉴타운 도로 및 지하시설물 GIS 구축 용역(2차) 232
 
5.0%
전곡해양산업단지 도로 및 지하시설물 GIS DB구축 용역(20171207) 162
 
3.5%
화성남양뉴타운 도로 및 지하시설물 GIS DB 구축 용역 106
 
2.3%
화성-정남 일반산업단지 조성사업 GIS DB 구축용역 99
 
2.1%
백미-송교간 도로확포장공사 GIS DB 구축용역 85
 
1.8%
경기화성바이오밸리 84
 
1.8%
Other values (31) 661
 
14.3%

Length

2023-12-12T11:25:11.672736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
gis 1318
 
8.3%
및 1149
 
7.2%
도로 1016
 
6.4%
db 950
 
6.0%
지하시설물 778
 
4.9%
일반산업단지 672
 
4.2%
중 604
 
3.8%
조성공사 575
 
3.6%
화성동탄 573
 
3.6%
gis구축 573
 
3.6%
Other values (103) 7669
48.3%

도로구간번호
Real number (ℝ)

ZEROS 

Distinct1147
Distinct (%)24.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.4618251 × 1013
Minimum0
Maximum8.99919 × 1013
Zeros83
Zeros (%)1.8%
Negative0
Negative (%)0.0%
Memory size40.7 KiB
2023-12-12T11:25:11.812469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile6.1473034 × 108
Q19.0020441 × 109
median5.1130768 × 1010
Q38.21117 × 1013
95-th percentile8.99919 × 1013
Maximum8.99919 × 1013
Range8.99919 × 1013
Interquartile range (IQR)8.2102698 × 1013

Descriptive statistics

Standard deviation3.7766399 × 1013
Coefficient of variation (CV)1.5340813
Kurtosis-0.85521181
Mean2.4618251 × 1013
Median Absolute Deviation (MAD)4.9030637 × 1010
Skewness1.0303889
Sum1.1353937 × 1017
Variance1.4263009 × 1027
MonotonicityNot monotonic
2023-12-12T11:25:12.335600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
89991900000000 575
 
12.5%
89991600000000 226
 
4.9%
82111700000000 158
 
3.4%
82161800000000 116
 
2.5%
32161800000000 106
 
2.3%
12111900000000 99
 
2.1%
0 83
 
1.8%
82992000000000 66
 
1.4%
12111800000000 65
 
1.4%
12111700000000 57
 
1.2%
Other values (1137) 3061
66.4%
ValueCountFrequency (%)
0 83
1.8%
307590001 1
 
< 0.1%
307590002 1
 
< 0.1%
307590004 1
 
< 0.1%
307590006 2
 
< 0.1%
307590007 1
 
< 0.1%
307780010 1
 
< 0.1%
307780011 1
 
< 0.1%
307780013 1
 
< 0.1%
307780015 2
 
< 0.1%
ValueCountFrequency (%)
89991900000000 575
12.5%
89991600000000 226
 
4.9%
82992000000000 66
 
1.4%
82162000000000 1
 
< 0.1%
82161900000000 4
 
0.1%
82161800000000 116
 
2.5%
82112000000000 51
 
1.1%
82111900000000 2
 
< 0.1%
82111700000000 158
 
3.4%
32161800000000 106
 
2.3%

공사번호
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size36.2 KiB
4610 
1
 
2

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
4610
> 99.9%
1 2
 
< 0.1%

Length

2023-12-12T11:25:12.484457image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:25:12.578174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 2
100.0%

납품업체
Categorical

Distinct11
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size36.2 KiB
3029 
새한항업
417 
㈜한양지에스티
 
232
㈜진성이엔씨
 
217
(주)지아이에스21
 
211
Other values (6)
506 

Length

Max length10
Median length1
Mean length2.9050304
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3029
65.7%
새한항업 417
 
9.0%
㈜한양지에스티 232
 
5.0%
㈜진성이엔씨 217
 
4.7%
(주)지아이에스21 211
 
4.6%
(주)진성이엔씨 121
 
2.6%
지오스 106
 
2.3%
(주)성원공간정보 92
 
2.0%
(주)우주공간정보 85
 
1.8%
제일항업(주) 66
 
1.4%

Length

2023-12-12T11:25:12.707561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
새한항업 417
26.3%
㈜한양지에스티 232
14.7%
㈜진성이엔씨 217
13.7%
주)지아이에스21 211
13.3%
주)진성이엔씨 121
 
7.6%
지오스 106
 
6.7%
주)성원공간정보 92
 
5.8%
주)우주공간정보 85
 
5.4%
제일항업(주 66
 
4.2%
주)한라지리정보 36
 
2.3%

로딩일자
Categorical

Distinct31
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size36.2 KiB
2156 
2019-12-04
355 
2020-05-20
338 
2017-08-31
238 
2019-01-05
226 
Other values (26)
1299 

Length

Max length10
Median length10
Mean length5.7927147
Min length1

Unique

Unique3 ?
Unique (%)0.1%

Sample

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

Common Values

ValueCountFrequency (%)
2156
46.7%
2019-12-04 355
 
7.7%
2020-05-20 338
 
7.3%
2017-08-31 238
 
5.2%
2019-01-05 226
 
4.9%
2021-03-23 211
 
4.6%
2019-04-05 190
 
4.1%
2017-12-07 162
 
3.5%
2020-03-04 99
 
2.1%
2018-09-17 93
 
2.0%
Other values (21) 544
 
11.8%

Length

2023-12-12T11:25:12.872320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2019-12-04 355
14.5%
2020-05-20 338
13.8%
2017-08-31 238
9.7%
2019-01-05 226
9.2%
2021-03-23 211
8.6%
2019-04-05 190
7.7%
2017-12-07 162
 
6.6%
2020-03-04 99
 
4.0%
2018-09-17 93
 
3.8%
2018-11-02 85
 
3.5%
Other values (20) 459
18.7%

Sample

지형지물부호관리번호행정읍면동관리기관설치일자자전거노선명자전거도로구분위치구분자전거도로재질연장폭원국비시비기타비경계종류대장초기화여부비고도로구간번호공사번호납품업체로딩일자
0자전거도로888614000000향남읍<NA>2009-01-01자전거전용도로좌투수성콘크리트31.591.5000경계석188614360004
1자전거도로426010봉담읍<NA>2008-07-24자전거전용도로좌투수성콘크리트236.072.71000경계석11019042011
2자전거도로500079진안동<NA>1900-01-01도시계획도자전거보행자겸용도로우투수성콘크리트27.02.24000도색12400231001
3자전거도로888614000000향남읍<NA>2009-01-01자전거전용도로우투수성콘크리트90.02.0000경계석188614360003
4자전거도로999617000000<NA><NA>2010-01-01자전거보행자겸용도로우아스콘0.231.9000경계석199617230020
5자전거도로500226화산동<NA>1900-01-01도시계획도자전거보행자겸용도로우투수성콘크리트155.01.66000경계석11208431001
6자전거도로411064동탄2동<NA>2007-11-01자전거보행자겸용도로좌투수성콘크리트76.82.1000경계석12300519004
7자전거도로426008봉담읍<NA>2008-07-24자전거전용도로좌투수성콘크리트99.512.65000경계석11019042011
8자전거도로411133동탄2동<NA>2007-11-01자전거보행자겸용도로우투수성콘크리트279.332.1000경계석12300219008
9자전거도로500168병점1동<NA>2005-01-01도시계획도자전거보행자겸용도로좌투수성콘크리트71.01.43000경계석12500231002
지형지물부호관리번호행정읍면동관리기관설치일자자전거노선명자전거도로구분위치구분자전거도로재질연장폭원국비시비기타비경계종류대장초기화여부비고도로구간번호공사번호납품업체로딩일자
4602자전거도로82111800000000<NA>도로과2018-01-01자전거 횡단보도우아스팔트21.782.4000경계석182111700000000(주)지아이에스212021-03-23
4603자전거도로82111800000000<NA>도로과2018-01-01자전거전용도로우아스콘32.022.2000경계석182111700000000(주)지아이에스212021-03-23
4604자전거도로82111800000000<NA>도로과2018-01-01자전거전용도로좌아스콘54.062.2000경계석182111700000000(주)지아이에스212021-03-23
4605자전거도로82111800000000<NA>도로과2018-01-01자전거전용도로좌아스콘14.032.2000경계석182111700000000(주)지아이에스212021-03-23
4606자전거도로82111800000000<NA>도로과2018-01-01자전거전용도로좌아스콘31.322.2000경계석182111700000000(주)지아이에스212021-03-23
4607자전거도로82111800000000<NA>도로과2018-01-01자전거전용도로좌아스콘20.482.2000경계석182111700000000(주)지아이에스212021-03-23
4608자전거도로82111800000000<NA>도로과2018-01-01자전거전용도로우아스콘35.632.2000경계석182111700000000(주)지아이에스212021-03-23
4609자전거도로82111800000000<NA>도로과2018-01-01자전거 횡단보도우아스팔트19.72.4000경계석182111700000000(주)지아이에스212021-03-23
4610자전거도로82111800000000<NA>도로과2018-01-01자전거 횡단보도우아스팔트19.612.4000경계석182111700000000(주)지아이에스212021-03-23
4611자전거도로82111800000000<NA>도로과2018-01-01자전거전용도로우아스콘46.452.2000경계석182111700000000(주)지아이에스212021-03-23

Duplicate rows

Most frequently occurring

지형지물부호관리번호행정읍면동관리기관설치일자자전거노선명자전거도로구분위치구분자전거도로재질연장폭원국비시비기타비경계종류대장초기화여부비고도로구간번호공사번호납품업체로딩일자# duplicates
2자전거도로511307000000동탄6동<NA>2014-01-01자전거보행자겸용도로우소형고압블럭1.12.1000경계석1화성동탄 일반산업단지 조성공사 중 GIS구축511307390186
3자전거도로511307000000동탄6동<NA>2014-01-01자전거보행자겸용도로우소형고압블럭1.12.1000경계석1화성동탄 일반산업단지 조성공사 중 GIS구축511307390236
16자전거도로511307000000동탄6동<NA>2014-01-01자전거보행자겸용도로우투수성콘크리트1.12.1000경계석1화성동탄 일반산업단지 조성공사 중 GIS구축511307390116
29자전거도로511307000000동탄6동<NA>2014-01-01자전거보행자겸용도로좌투수성콘크리트1.12.1000경계석1화성동탄 일반산업단지 조성공사 중 GIS구축511307390236
9자전거도로511307000000동탄6동<NA>2014-01-01자전거보행자겸용도로우소형고압블럭1.12.1000경계석1화성동탄 일반산업단지 조성공사 중 GIS구축511307480975
14자전거도로511307000000동탄6동<NA>2014-01-01자전거보행자겸용도로우소형고압블럭1.12.1000경계석1화성동탄 일반산업단지 조성공사 중 GIS구축511307491165
18자전거도로511307000000동탄6동<NA>2014-01-01자전거보행자겸용도로좌소형고압블럭1.12.1000경계석1화성동탄 일반산업단지 조성공사 중 GIS구축511307390115
28자전거도로511307000000동탄6동<NA>2014-01-01자전거보행자겸용도로좌투수성콘크리트1.12.1000경계석1화성동탄 일반산업단지 조성공사 중 GIS구축511307390185
45자전거도로511308000000동탄6동<NA>2014-01-01자전거보행자겸용도로우소형고압블럭1.12.1000경계석1화성동탄 일반산업단지 조성공사 중 GIS구축511307690985
47자전거도로511308000000동탄6동<NA>2014-01-01자전거보행자겸용도로우소형고압블럭1.12.1000경계석1화성동탄 일반산업단지 조성공사 중 GIS구축511307770565