Overview

Dataset statistics

Number of variables9
Number of observations10000
Missing cells120
Missing cells (%)0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory800.8 KiB
Average record size in memory82.0 B

Variable types

Categorical5
Numeric2
Text2

Dataset

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

Alerts

지형지물부호 has constant value ""Constant
관리기관 has constant value ""Constant
데이터기준일 has constant value ""Constant
구간구분 is highly imbalanced (91.6%)Imbalance
폭원(미터) has 3800 (38.0%) zerosZeros

Reproduction

Analysis started2023-12-23 07:49:43.871952
Analysis finished2023-12-23 07:49:49.277258
Duration5.41 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지형지물부호
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
도로중심선
10000 

Length

Max length5
Median length5
Mean length5
Min length5

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-23T07:49:49.653107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-23T07:49:50.286312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
도로중심선 10000
100.0%

관리번호
Real number (ℝ)

Distinct9994
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean158606.61
Minimum1
Maximum900424
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-23T07:49:50.912724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1362.95
Q17318.75
median140270
Q3261680.25
95-th percentile360819.05
Maximum900424
Range900423
Interquartile range (IQR)254361.5

Descriptive statistics

Standard deviation151048.04
Coefficient of variation (CV)0.95234394
Kurtosis5.8710367
Mean158606.61
Median Absolute Deviation (MAD)123403
Skewness1.6115317
Sum1.5860661 × 109
Variance2.2815512 × 1010
MonotonicityNot monotonic
2023-12-23T07:49:52.329717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
8410 2
 
< 0.1%
123083 2
 
< 0.1%
4232 2
 
< 0.1%
8404 2
 
< 0.1%
6602 2
 
< 0.1%
4101 2
 
< 0.1%
240506 1
 
< 0.1%
160068 1
 
< 0.1%
160957 1
 
< 0.1%
100321 1
 
< 0.1%
Other values (9984) 9984
99.8%
ValueCountFrequency (%)
1 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
11 1
< 0.1%
14 1
< 0.1%
18 1
< 0.1%
19 1
< 0.1%
20 1
< 0.1%
21 1
< 0.1%
25 1
< 0.1%
ValueCountFrequency (%)
900424 1
< 0.1%
900422 1
< 0.1%
900421 1
< 0.1%
900418 1
< 0.1%
900417 1
< 0.1%
900416 1
< 0.1%
900414 1
< 0.1%
900412 1
< 0.1%
900410 1
< 0.1%
900409 1
< 0.1%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
경기도 광주시청
10000 

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 (%)
경기도 광주시청 10000
100.0%

Length

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

Common Values (Plot)

2023-12-23T07:49:55.264467image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 10000
50.0%
광주시청 10000
50.0%

구간구분
Categorical

IMBALANCE 

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
차도구간
9677 
교량구간
 
268
기타
 
34
지하차도
 
8
터널구간
 
5
Other values (2)
 
8

Length

Max length4
Median length4
Mean length3.9928
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row차도구간
2nd row차도구간
3rd row차도구간
4th row차도구간
5th row차도구간

Common Values

ValueCountFrequency (%)
차도구간 9677
96.8%
교량구간 268
 
2.7%
기타 34
 
0.3%
지하차도 8
 
0.1%
터널구간 5
 
0.1%
미분류 4
 
< 0.1%
고가도로 4
 
< 0.1%

Length

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

Common Values (Plot)

2023-12-23T07:49:56.820862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
차도구간 9677
96.8%
교량구간 268
 
2.7%
기타 34
 
0.3%
지하차도 8
 
0.1%
터널구간 5
 
< 0.1%
미분류 4
 
< 0.1%
고가도로 4
 
< 0.1%

중용여부
Categorical

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
연결선(가노선)
3863 
일반도로(구간속성)
3382 
일반도로(구간속성아님)
2721 
우선도로(구간속성)
 
23
우선도로(구간속성아님)
 
4
Other values (2)
 
7

Length

Max length12
Median length10
Mean length9.773
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일반도로(구간속성아님)
2nd row일반도로(구간속성)
3rd row일반도로(구간속성)
4th row일반도로(구간속성아님)
5th row일반도로(구간속성)

Common Values

ValueCountFrequency (%)
연결선(가노선) 3863
38.6%
일반도로(구간속성) 3382
33.8%
일반도로(구간속성아님) 2721
27.2%
우선도로(구간속성) 23
 
0.2%
우선도로(구간속성아님) 4
 
< 0.1%
부속도로(구간속성) 4
 
< 0.1%
부속도로(구간속성아님) 3
 
< 0.1%

Length

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

Common Values (Plot)

2023-12-23T07:49:57.975749image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
연결선(가노선 3863
38.6%
일반도로(구간속성 3382
33.8%
일반도로(구간속성아님 2721
27.2%
우선도로(구간속성 23
 
0.2%
우선도로(구간속성아님 4
 
< 0.1%
부속도로(구간속성 4
 
< 0.1%
부속도로(구간속성아님 3
 
< 0.1%

연장(미터)
Text

Distinct5867
Distinct (%)58.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-23T07:49:59.293444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length6
Mean length4.8168
Min length4

Characters and Unicode

Total characters48168
Distinct characters12
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique4260 ?
Unique (%)42.6%

Sample

1st row157.42
2nd row31.34
3rd row27.34
4th row805.10
5th row13.65
ValueCountFrequency (%)
3.11 14
 
0.1%
3.99 14
 
0.1%
3.46 14
 
0.1%
3.25 14
 
0.1%
2.65 13
 
0.1%
2.75 13
 
0.1%
2.64 13
 
0.1%
3.04 13
 
0.1%
2.21 13
 
0.1%
2.39 12
 
0.1%
Other values (5857) 9867
98.7%
2023-12-23T07:50:01.030074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
. 10000
20.8%
1 5523
11.5%
2 4661
9.7%
3 4233
8.8%
4 3979
 
8.3%
5 3752
 
7.8%
6 3438
 
7.1%
7 3267
 
6.8%
8 3095
 
6.4%
0 3090
 
6.4%
Other values (2) 3130
 
6.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 38121
79.1%
Other Punctuation 10047
 
20.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 5523
14.5%
2 4661
12.2%
3 4233
11.1%
4 3979
10.4%
5 3752
9.8%
6 3438
9.0%
7 3267
8.6%
8 3095
8.1%
0 3090
8.1%
9 3083
8.1%
Other Punctuation
ValueCountFrequency (%)
. 10000
99.5%
, 47
 
0.5%

Most occurring scripts

ValueCountFrequency (%)
Common 48168
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
. 10000
20.8%
1 5523
11.5%
2 4661
9.7%
3 4233
8.8%
4 3979
 
8.3%
5 3752
 
7.8%
6 3438
 
7.1%
7 3267
 
6.8%
8 3095
 
6.4%
0 3090
 
6.4%
Other values (2) 3130
 
6.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 48168
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
. 10000
20.8%
1 5523
11.5%
2 4661
9.7%
3 4233
8.8%
4 3979
 
8.3%
5 3752
 
7.8%
6 3438
 
7.1%
7 3267
 
6.8%
8 3095
 
6.4%
0 3090
 
6.4%
Other values (2) 3130
 
6.5%

면적(제곱미터)
Text

Distinct5888
Distinct (%)59.2%
Missing60
Missing (%)0.6%
Memory size156.2 KiB
2023-12-23T07:50:01.838480image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length9
Mean length5.3720322
Min length4

Characters and Unicode

Total characters53398
Distinct characters12
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique5650 ?
Unique (%)56.8%

Sample

1st row1,253.95
2nd row181.77
3rd row160.15
4th row6,345.94
5th row59.58
ValueCountFrequency (%)
0.00 3801
38.2%
81.15 4
 
< 0.1%
219.92 4
 
< 0.1%
140.08 3
 
< 0.1%
502.94 3
 
< 0.1%
79.21 3
 
< 0.1%
628.75 3
 
< 0.1%
85.88 3
 
< 0.1%
369.39 3
 
< 0.1%
75.98 3
 
< 0.1%
Other values (5878) 6110
61.5%
2023-12-23T07:50:03.460534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 14118
26.4%
. 9940
18.6%
1 4363
 
8.2%
2 3563
 
6.7%
3 3267
 
6.1%
4 3032
 
5.7%
6 2910
 
5.4%
5 2854
 
5.3%
7 2830
 
5.3%
8 2725
 
5.1%
Other values (2) 3796
 
7.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 42291
79.2%
Other Punctuation 11107
 
20.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 14118
33.4%
1 4363
 
10.3%
2 3563
 
8.4%
3 3267
 
7.7%
4 3032
 
7.2%
6 2910
 
6.9%
5 2854
 
6.7%
7 2830
 
6.7%
8 2725
 
6.4%
9 2629
 
6.2%
Other Punctuation
ValueCountFrequency (%)
. 9940
89.5%
, 1167
 
10.5%

Most occurring scripts

ValueCountFrequency (%)
Common 53398
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 14118
26.4%
. 9940
18.6%
1 4363
 
8.2%
2 3563
 
6.7%
3 3267
 
6.1%
4 3032
 
5.7%
6 2910
 
5.4%
5 2854
 
5.3%
7 2830
 
5.3%
8 2725
 
5.1%
Other values (2) 3796
 
7.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 53398
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 14118
26.4%
. 9940
18.6%
1 4363
 
8.2%
2 3563
 
6.7%
3 3267
 
6.1%
4 3032
 
5.7%
6 2910
 
5.4%
5 2854
 
5.3%
7 2830
 
5.3%
8 2725
 
5.1%
Other values (2) 3796
 
7.1%

폭원(미터)
Real number (ℝ)

ZEROS 

Distinct1438
Distinct (%)14.5%
Missing60
Missing (%)0.6%
Infinite0
Infinite (%)0.0%
Mean4.529833
Minimum0
Maximum149.64
Zeros3800
Zeros (%)38.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-23T07:50:03.871464image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median3.94
Q36.1325
95-th percentile15.0505
Maximum149.64
Range149.64
Interquartile range (IQR)6.1325

Descriptive statistics

Standard deviation5.9566041
Coefficient of variation (CV)1.3149721
Kurtosis57.04913
Mean4.529833
Median Absolute Deviation (MAD)3.94
Skewness4.4756856
Sum45026.54
Variance35.481133
MonotonicityNot monotonic
2023-12-23T07:50:04.340575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 3800
38.0%
4.2 53
 
0.5%
4.0 49
 
0.5%
4.3 39
 
0.4%
5.0 31
 
0.3%
3.9 31
 
0.3%
6.0 29
 
0.3%
4.1 29
 
0.3%
4.4 27
 
0.3%
4.07 24
 
0.2%
Other values (1428) 5828
58.3%
(Missing) 60
 
0.6%
ValueCountFrequency (%)
0.0 3800
38.0%
1.36 1
 
< 0.1%
1.45 1
 
< 0.1%
1.62 1
 
< 0.1%
1.65 1
 
< 0.1%
1.76 1
 
< 0.1%
1.81 1
 
< 0.1%
2.04 1
 
< 0.1%
2.1 1
 
< 0.1%
2.13 1
 
< 0.1%
ValueCountFrequency (%)
149.64 1
< 0.1%
101.05 1
< 0.1%
90.68 1
< 0.1%
70.66 1
< 0.1%
68.23 1
< 0.1%
67.26 1
< 0.1%
61.12 1
< 0.1%
56.68 1
< 0.1%
52.43 1
< 0.1%
52.03 1
< 0.1%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-08
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-12-08
2nd row2023-12-08
3rd row2023-12-08
4th row2023-12-08
5th row2023-12-08

Common Values

ValueCountFrequency (%)
2023-12-08 10000
100.0%

Length

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

Common Values (Plot)

2023-12-23T07:50:05.549519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-12-08 10000
100.0%

Interactions

2023-12-23T07:49:46.592695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-23T07:49:45.751758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-23T07:49:47.122406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-23T07:49:46.261051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-23T07:50:05.738689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호구간구분중용여부폭원(미터)
관리번호1.0000.1340.5950.162
구간구분0.1341.0000.1870.000
중용여부0.5950.1871.0000.223
폭원(미터)0.1620.0000.2231.000
2023-12-23T07:50:06.133503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
중용여부구간구분
중용여부1.0000.066
구간구분0.0661.000
2023-12-23T07:50:06.512737image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호폭원(미터)구간구분중용여부
관리번호1.0000.0320.0470.243
폭원(미터)0.0321.0000.0000.079
구간구분0.0470.0001.0000.066
중용여부0.2430.0790.0661.000

Missing values

2023-12-23T07:49:47.781588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-23T07:49:48.405511image/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.
2023-12-23T07:49:48.937507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

지형지물부호관리번호관리기관구간구분중용여부연장(미터)면적(제곱미터)폭원(미터)데이터기준일
15338도로중심선6768경기도 광주시청차도구간일반도로(구간속성아님)157.421,253.957.912023-12-08
4480도로중심선262117경기도 광주시청차도구간일반도로(구간속성)31.34181.775.82023-12-08
3848도로중심선262804경기도 광주시청차도구간일반도로(구간속성)27.34160.155.862023-12-08
12213도로중심선120489경기도 광주시청차도구간일반도로(구간속성아님)805.106,345.947.532023-12-08
5648도로중심선260909경기도 광주시청차도구간일반도로(구간속성)13.6559.584.362023-12-08
2837도로중심선263879경기도 광주시청차도구간일반도로(구간속성)19.79108.525.482023-12-08
17995도로중심선2835경기도 광주시청차도구간일반도로(구간속성아님)34.07223.606.32023-12-08
15462도로중심선6640경기도 광주시청차도구간연결선(가노선)7.740.000.02023-12-08
19128도로중심선878경기도 광주시청차도구간연결선(가노선)7.040.000.02023-12-08
10930도로중심선122195경기도 광주시청차도구간연결선(가노선)16.280.000.02023-12-08
지형지물부호관리번호관리기관구간구분중용여부연장(미터)면적(제곱미터)폭원(미터)데이터기준일
4185도로중심선262441경기도 광주시청차도구간일반도로(구간속성)20.8572.393.472023-12-08
2039도로중심선320367경기도 광주시청차도구간연결선(가노선)6.360.000.02023-12-08
3014도로중심선263691경기도 광주시청차도구간일반도로(구간속성)57.38198.573.462023-12-08
14228도로중심선7908경기도 광주시청차도구간일반도로(구간속성아님)231.561,535.296.342023-12-08
15749도로중심선6344경기도 광주시청차도구간연결선(가노선)2.220.000.02023-12-08
10453도로중심선122828경기도 광주시청차도구간일반도로(구간속성)23.22109.226.342023-12-08
1789도로중심선340255경기도 광주시청차도구간연결선(가노선)2.850.000.02023-12-08
3442도로중심선263223경기도 광주시청차도구간연결선(가노선)2.600.000.02023-12-08
14922도로중심선7196경기도 광주시청차도구간일반도로(구간속성아님)201.29563.263.552023-12-08
12640도로중심선100317경기도 광주시청차도구간일반도로(구간속성아님)71.99492.047.372023-12-08