Overview

Dataset statistics

Number of variables9
Number of observations206
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory15.4 KiB
Average record size in memory76.6 B

Variable types

Numeric2
Categorical6
Text1

Dataset

Description충청남도 청양군의 과속방지턱에 규격 테이터 현행화 에 따른 정보(관리 기관,도로 구분,노선 구분,위치,차로 수,설치 길이, 설치 높이, 재료 등)입니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=30&beforeMenuCd=DOM_000000201001001000&publicdatapk=15118816

Alerts

관리기관 (도로관리청) has constant value ""Constant
재료 has constant value ""Constant
노선번호 is highly overall correlated with 연번 and 3 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
설치 길이(m) is highly overall correlated with 노선번호High correlation
설치 길이(m) is highly imbalanced (94.4%)Imbalance
연번 has unique valuesUnique

Reproduction

Analysis started2024-01-09 19:43:53.082856
Analysis finished2024-01-09 19:43:53.847164
Duration0.76 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct206
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean103.5
Minimum1
Maximum206
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2024-01-10T04:43:53.932806image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile11.25
Q152.25
median103.5
Q3154.75
95-th percentile195.75
Maximum206
Range205
Interquartile range (IQR)102.5

Descriptive statistics

Standard deviation59.611241
Coefficient of variation (CV)0.57595401
Kurtosis-1.2
Mean103.5
Median Absolute Deviation (MAD)51.5
Skewness0
Sum21321
Variance3553.5
MonotonicityStrictly increasing
2024-01-10T04:43:54.050388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.5%
143 1
 
0.5%
133 1
 
0.5%
134 1
 
0.5%
135 1
 
0.5%
136 1
 
0.5%
137 1
 
0.5%
138 1
 
0.5%
139 1
 
0.5%
140 1
 
0.5%
Other values (196) 196
95.1%
ValueCountFrequency (%)
1 1
0.5%
2 1
0.5%
3 1
0.5%
4 1
0.5%
5 1
0.5%
6 1
0.5%
7 1
0.5%
8 1
0.5%
9 1
0.5%
10 1
0.5%
ValueCountFrequency (%)
206 1
0.5%
205 1
0.5%
204 1
0.5%
203 1
0.5%
202 1
0.5%
201 1
0.5%
200 1
0.5%
199 1
0.5%
198 1
0.5%
197 1
0.5%

관리기관 (도로관리청)
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
청양군
206 

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 (%)
청양군 206
100.0%

Length

2024-01-10T04:43:54.150307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T04:43:54.233577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
청양군 206
100.0%

도로구분
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
군도
96 
기타도로
88 
도시계획도로
22 

Length

Max length6
Median length4
Mean length3.2815534
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
군도 96
46.6%
기타도로 88
42.7%
도시계획도로 22
 
10.7%

Length

2024-01-10T04:43:54.328288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T04:43:54.453464image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
군도 96
46.6%
기타도로 88
42.7%
도시계획도로 22
 
10.7%

노선번호
Categorical

HIGH CORRELATION 

Distinct32
Distinct (%)15.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
면도101
23 
1
21 
리도201
 
12
8
 
11
리도202
 
11
Other values (27)
128 

Length

Max length5
Median length5
Mean length3.2669903
Min length1

Unique

Unique3 ?
Unique (%)1.5%

Sample

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

Common Values

ValueCountFrequency (%)
면도101 23
 
11.2%
1 21
 
10.2%
리도201 12
 
5.8%
8 11
 
5.3%
리도202 11
 
5.3%
10 10
 
4.9%
리도204 9
 
4.4%
면도102 9
 
4.4%
리도205 8
 
3.9%
13 8
 
3.9%
Other values (22) 84
40.8%

Length

2024-01-10T04:43:54.658546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
면도101 23
 
11.2%
1 21
 
10.2%
리도201 12
 
5.8%
8 11
 
5.3%
리도202 11
 
5.3%
10 10
 
4.9%
리도204 9
 
4.4%
면도102 9
 
4.4%
13 8
 
3.9%
리도207 8
 
3.9%
Other values (22) 84
40.8%

위치
Text

Distinct189
Distinct (%)91.7%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2024-01-10T04:43:55.071646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length20
Mean length19.606796
Min length16

Characters and Unicode

Total characters4039
Distinct characters91
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique180 ?
Unique (%)87.4%

Sample

1st row충남 청양군 비봉면 강정리 258-5
2nd row충남 청양군 비봉면 강정리 276-7
3rd row충남 청양군 비봉면 강정리 71-2
4th row충남 청양군 비봉면 강정리 89-3
5th row충남 청양군 비봉면 강정리 90-9
ValueCountFrequency (%)
충남 206
20.0%
청양군 206
20.0%
청양읍 39
 
3.8%
대치면 34
 
3.3%
비봉면 31
 
3.0%
정산면 24
 
2.3%
남양면 20
 
1.9%
목면 17
 
1.6%
장평면 17
 
1.6%
청남면 15
 
1.5%
Other values (250) 422
40.9%
2024-01-10T04:43:55.648315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
825
20.4%
양 284
 
7.0%
청 269
 
6.7%
남 243
 
6.0%
군 210
 
5.2%
충 206
 
5.1%
리 205
 
5.1%
- 179
 
4.4%
면 167
 
4.1%
1 122
 
3.0%
Other values (81) 1329
32.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2249
55.7%
Space Separator 825
 
20.4%
Decimal Number 786
 
19.5%
Dash Punctuation 179
 
4.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
양 284
12.6%
청 269
12.0%
남 243
10.8%
군 210
9.3%
충 206
 
9.2%
리 205
 
9.1%
면 167
 
7.4%
읍 54
 
2.4%
정 48
 
2.1%
치 42
 
1.9%
Other values (69) 521
23.2%
Decimal Number
ValueCountFrequency (%)
1 122
15.5%
2 118
15.0%
3 111
14.1%
5 80
10.2%
4 70
8.9%
6 67
8.5%
7 63
8.0%
8 60
7.6%
9 55
7.0%
0 40
 
5.1%
Space Separator
ValueCountFrequency (%)
825
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 179
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2249
55.7%
Common 1790
44.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
양 284
12.6%
청 269
12.0%
남 243
10.8%
군 210
9.3%
충 206
 
9.2%
리 205
 
9.1%
면 167
 
7.4%
읍 54
 
2.4%
정 48
 
2.1%
치 42
 
1.9%
Other values (69) 521
23.2%
Common
ValueCountFrequency (%)
825
46.1%
- 179
 
10.0%
1 122
 
6.8%
2 118
 
6.6%
3 111
 
6.2%
5 80
 
4.5%
4 70
 
3.9%
6 67
 
3.7%
7 63
 
3.5%
8 60
 
3.4%
Other values (2) 95
 
5.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2249
55.7%
ASCII 1790
44.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
825
46.1%
- 179
 
10.0%
1 122
 
6.8%
2 118
 
6.6%
3 111
 
6.2%
5 80
 
4.5%
4 70
 
3.9%
6 67
 
3.7%
7 63
 
3.5%
8 60
 
3.4%
Other values (2) 95
 
5.3%
Hangul
ValueCountFrequency (%)
양 284
12.6%
청 269
12.0%
남 243
10.8%
군 210
9.3%
충 206
 
9.2%
리 205
 
9.1%
면 167
 
7.4%
읍 54
 
2.4%
정 48
 
2.1%
치 42
 
1.9%
Other values (69) 521
23.2%

차로수(왕복)
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2
143 
1
58 
4
 
3
3
 
2

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2 143
69.4%
1 58
28.2%
4 3
 
1.5%
3 2
 
1.0%

Length

2024-01-10T04:43:55.788120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T04:43:56.186233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 143
69.4%
1 58
28.2%
4 3
 
1.5%
3 2
 
1.0%

설치 길이(m)
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
3.6
204 
4.8
 
1
6.5
 
1

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique2 ?
Unique (%)1.0%

Sample

1st row3.6
2nd row3.6
3rd row3.6
4th row3.6
5th row3.6

Common Values

ValueCountFrequency (%)
3.6 204
99.0%
4.8 1
 
0.5%
6.5 1
 
0.5%

Length

2024-01-10T04:43:56.307479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T04:43:56.484540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3.6 204
99.0%
4.8 1
 
0.5%
6.5 1
 
0.5%

설치 높이(㎝)
Real number (ℝ)

Distinct27
Distinct (%)13.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean10.254369
Minimum7.5
Maximum14.2
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2024-01-10T04:43:56.597652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum7.5
5-th percentile10
Q110
median10
Q310
95-th percentile12.45
Maximum14.2
Range6.7
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.82370687
Coefficient of variation (CV)0.080327408
Kurtosis7.8353503
Mean10.254369
Median Absolute Deviation (MAD)0
Skewness2.3360569
Sum2112.4
Variance0.67849301
MonotonicityNot monotonic
2024-01-10T04:43:56.736396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
10.0 163
79.1%
10.7 4
 
1.9%
10.9 3
 
1.5%
10.8 3
 
1.5%
12.7 3
 
1.5%
11.2 3
 
1.5%
11.7 2
 
1.0%
10.3 2
 
1.0%
12.9 2
 
1.0%
10.2 2
 
1.0%
Other values (17) 19
 
9.2%
ValueCountFrequency (%)
7.5 1
 
0.5%
7.9 1
 
0.5%
9.1 1
 
0.5%
9.5 1
 
0.5%
9.6 2
 
1.0%
10.0 163
79.1%
10.1 1
 
0.5%
10.2 2
 
1.0%
10.3 2
 
1.0%
10.5 1
 
0.5%
ValueCountFrequency (%)
14.2 1
 
0.5%
14.0 1
 
0.5%
13.2 1
 
0.5%
13.1 1
 
0.5%
12.9 2
1.0%
12.8 1
 
0.5%
12.7 3
1.5%
12.5 1
 
0.5%
12.3 1
 
0.5%
12.1 1
 
0.5%

재료
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
포장 재료 동일
206 

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 (%)
포장 재료 동일 206
100.0%

Length

2024-01-10T04:43:56.841030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T04:43:56.919521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
포장 206
33.3%
재료 206
33.3%
동일 206
33.3%

Interactions

2024-01-10T04:43:53.537854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T04:43:53.399962image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T04:43:53.602381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T04:43:53.465103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T04:43:56.975398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번도로구분노선번호차로수(왕복)설치 길이(m)설치 높이(㎝)
연번1.0000.9590.9890.7340.0370.132
도로구분0.9591.0001.0000.5570.4570.000
노선번호0.9891.0001.0000.9710.8900.000
차로수(왕복)0.7340.5570.9711.0000.4010.000
설치 길이(m)0.0370.4570.8900.4011.0000.000
설치 높이(㎝)0.1320.0000.0000.0000.0001.000
2024-01-10T04:43:57.067364image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
차로수(왕복)노선번호도로구분설치 길이(m)
차로수(왕복)1.0000.7520.5620.391
노선번호0.7521.0000.9260.672
도로구분0.5620.9261.0000.178
설치 길이(m)0.3910.6720.1781.000
2024-01-10T04:43:57.148066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설치 높이(㎝)도로구분노선번호차로수(왕복)설치 길이(m)
연번1.000-0.0440.9420.8550.5360.016
설치 높이(㎝)-0.0441.0000.0000.0000.0000.000
도로구분0.9420.0001.0000.9260.5620.178
노선번호0.8550.0000.9261.0000.7520.672
차로수(왕복)0.5360.0000.5620.7521.0000.391
설치 길이(m)0.0160.0000.1780.6720.3911.000

Missing values

2024-01-10T04:43:53.700944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T04:43:53.803363image/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

연번관리기관 (도로관리청)도로구분노선번호위치차로수(왕복)설치 길이(m)설치 높이(㎝)재료
01청양군군도1충남 청양군 비봉면 강정리 258-523.610.0포장 재료 동일
12청양군군도1충남 청양군 비봉면 강정리 276-723.610.0포장 재료 동일
23청양군군도1충남 청양군 비봉면 강정리 71-223.612.7포장 재료 동일
34청양군군도1충남 청양군 비봉면 강정리 89-323.611.0포장 재료 동일
45청양군군도1충남 청양군 비봉면 강정리 90-923.610.1포장 재료 동일
56청양군군도1충남 청양군 비봉면 록평리 242-223.610.0포장 재료 동일
67청양군군도1충남 청양군 비봉면 록평리 72-1223.610.9포장 재료 동일
78청양군군도1충남 청양군 비봉면 방한리 254-723.610.0포장 재료 동일
89청양군군도1충남 청양군 비봉면 방한리 334-123.610.0포장 재료 동일
910청양군군도1충남 청양군 비봉면 양사리 256-223.610.0포장 재료 동일
연번관리기관 (도로관리청)도로구분노선번호위치차로수(왕복)설치 길이(m)설치 높이(㎝)재료
196197청양군도시계획도로소로2-9충남 청양군 청양읍 읍내리 396-123.610.0포장 재료 동일
197198청양군도시계획도로대로3-4충남 청양군 청양읍 송방리 375-2323.610.0포장 재료 동일
198199청양군도시계획도로중로3-1충남 청양군 정산면 역촌리 760-723.610.0포장 재료 동일
199200청양군도시계획도로중로1-1충남 청양군 정산면 서정리 54823.610.0포장 재료 동일
200201청양군도시계획도로중로1-1충남 청양군 정산면 서정리 60-323.610.0포장 재료 동일
201202청양군도시계획도로대로3-4충남 청양군 청양읍 송방리 346-343.610.0포장 재료 동일
202203청양군도시계획도로소로3-8충남 청양군 청양읍 377-323.610.0포장 재료 동일
203204청양군도시계획도로소로3-8충남 청양군 청양읍 읍내리 377-423.610.0포장 재료 동일
204205청양군도시계획도로소로2-9충남 청양군 청양읍 읍내리 396-123.610.0포장 재료 동일
205206청양군도시계획도로소로2-9충남 청양군 청양읍 읍내리 396-123.610.0포장 재료 동일