Overview

Dataset statistics

Number of variables10
Number of observations310
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory24.7 KiB
Average record size in memory81.4 B

Variable types

Numeric1
Text1
Categorical8

Dataset

Description광주광역시 종합건설본부에서 관리 중인 도로시설물 정기안전점검 결과에 대한 데이터로 시설명, 분류(교량, 터널, 옹벽 등), 도로시설물종별, 안전점검시작 및 종료일자 등에 관한 항목을 담고 있습니다.
Author광주광역시
URLhttps://www.data.go.kr/data/15095336/fileData.do

Alerts

안전점검시작일자 has constant value ""Constant
안전점검종료일자 has constant value ""Constant
데이터기준일자 has constant value ""Constant
점검결과 is highly overall correlated with 종별 and 2 other fieldsHigh correlation
조치계획 is highly overall correlated with 점검결과 and 1 other fieldsHigh correlation
안전등급 is highly overall correlated with 종별 and 2 other fieldsHigh correlation
종별 is highly overall correlated with 점검결과 and 1 other fieldsHigh correlation
조치계획 is highly imbalanced (63.9%)Imbalance
연번 has unique valuesUnique
시설명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 15:23:10.288300
Analysis finished2023-12-12 15:23:11.033610
Duration0.75 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct310
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean155.5
Minimum1
Maximum310
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.9 KiB
2023-12-13T00:23:11.110992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile16.45
Q178.25
median155.5
Q3232.75
95-th percentile294.55
Maximum310
Range309
Interquartile range (IQR)154.5

Descriptive statistics

Standard deviation89.633513
Coefficient of variation (CV)0.57642131
Kurtosis-1.2
Mean155.5
Median Absolute Deviation (MAD)77.5
Skewness0
Sum48205
Variance8034.1667
MonotonicityStrictly increasing
2023-12-13T00:23:11.261122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
206 1
 
0.3%
213 1
 
0.3%
212 1
 
0.3%
211 1
 
0.3%
210 1
 
0.3%
209 1
 
0.3%
208 1
 
0.3%
207 1
 
0.3%
205 1
 
0.3%
Other values (300) 300
96.8%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
310 1
0.3%
309 1
0.3%
308 1
0.3%
307 1
0.3%
306 1
0.3%
305 1
0.3%
304 1
0.3%
303 1
0.3%
302 1
0.3%
301 1
0.3%

시설명
Text

UNIQUE 

Distinct310
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.6 KiB
2023-12-13T00:23:11.445746image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length21
Mean length6.1387097
Min length2

Characters and Unicode

Total characters1903
Distinct characters189
Distinct categories10 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique310 ?
Unique (%)100.0%

Sample

1st row양유교
2nd row광천1교
3rd row양동교
4th row동산교
5th row천변구조물17교
ValueCountFrequency (%)
운남대교 4
 
1.2%
국지도49호선 2
 
0.6%
제2순환도로 2
 
0.6%
손재로좌6 1
 
0.3%
우산2교 1
 
0.3%
우산1교 1
 
0.3%
본덕교 1
 
0.3%
하남산단8번로우2 1
 
0.3%
하남산단7번로우1 1
 
0.3%
봉선터널(용산방향 1
 
0.3%
Other values (305) 305
95.3%
2023-12-13T00:23:11.809300image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
교 211
 
11.1%
산 83
 
4.4%
1 78
 
4.1%
로 61
 
3.2%
2 60
 
3.2%
하 60
 
3.2%
벽 55
 
2.9%
옹 54
 
2.8%
남 54
 
2.8%
우 52
 
2.7%
Other values (179) 1135
59.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1556
81.8%
Decimal Number 209
 
11.0%
Uppercase Letter 67
 
3.5%
Open Punctuation 16
 
0.8%
Close Punctuation 16
 
0.8%
Dash Punctuation 16
 
0.8%
Space Separator 10
 
0.5%
Math Symbol 6
 
0.3%
Connector Punctuation 6
 
0.3%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
교 211
 
13.6%
산 83
 
5.3%
로 61
 
3.9%
하 60
 
3.9%
벽 55
 
3.5%
옹 54
 
3.5%
남 54
 
3.5%
우 52
 
3.3%
진 46
 
3.0%
단 43
 
2.8%
Other values (150) 837
53.8%
Uppercase Letter
ValueCountFrequency (%)
A 12
17.9%
R 12
17.9%
I 9
13.4%
C 9
13.4%
P 8
11.9%
M 8
11.9%
B 2
 
3.0%
E 2
 
3.0%
H 2
 
3.0%
K 1
 
1.5%
Other values (2) 2
 
3.0%
Decimal Number
ValueCountFrequency (%)
1 78
37.3%
2 60
28.7%
3 22
 
10.5%
4 15
 
7.2%
7 6
 
2.9%
5 6
 
2.9%
6 6
 
2.9%
8 6
 
2.9%
9 6
 
2.9%
0 4
 
1.9%
Open Punctuation
ValueCountFrequency (%)
( 16
100.0%
Close Punctuation
ValueCountFrequency (%)
) 16
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 16
100.0%
Space Separator
ValueCountFrequency (%)
10
100.0%
Math Symbol
ValueCountFrequency (%)
~ 6
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 6
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1556
81.8%
Common 280
 
14.7%
Latin 67
 
3.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
교 211
 
13.6%
산 83
 
5.3%
로 61
 
3.9%
하 60
 
3.9%
벽 55
 
3.5%
옹 54
 
3.5%
남 54
 
3.5%
우 52
 
3.3%
진 46
 
3.0%
단 43
 
2.8%
Other values (150) 837
53.8%
Common
ValueCountFrequency (%)
1 78
27.9%
2 60
21.4%
3 22
 
7.9%
( 16
 
5.7%
) 16
 
5.7%
- 16
 
5.7%
4 15
 
5.4%
10
 
3.6%
~ 6
 
2.1%
7 6
 
2.1%
Other values (7) 35
12.5%
Latin
ValueCountFrequency (%)
A 12
17.9%
R 12
17.9%
I 9
13.4%
C 9
13.4%
P 8
11.9%
M 8
11.9%
B 2
 
3.0%
E 2
 
3.0%
H 2
 
3.0%
K 1
 
1.5%
Other values (2) 2
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1556
81.8%
ASCII 347
 
18.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
교 211
 
13.6%
산 83
 
5.3%
로 61
 
3.9%
하 60
 
3.9%
벽 55
 
3.5%
옹 54
 
3.5%
남 54
 
3.5%
우 52
 
3.3%
진 46
 
3.0%
단 43
 
2.8%
Other values (150) 837
53.8%
ASCII
ValueCountFrequency (%)
1 78
22.5%
2 60
17.3%
3 22
 
6.3%
( 16
 
4.6%
) 16
 
4.6%
- 16
 
4.6%
4 15
 
4.3%
A 12
 
3.5%
R 12
 
3.5%
10
 
2.9%
Other values (19) 90
25.9%

분류
Categorical

Distinct7
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size2.6 KiB
교량
180 
옹벽
100 
지하차도
 
12
터널
 
11
절토사면
 
4
Other values (2)
 
3

Length

Max length4
Median length2
Mean length2.1225806
Min length2

Unique

Unique1 ?
Unique (%)0.3%

Sample

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

Common Values

ValueCountFrequency (%)
교량 180
58.1%
옹벽 100
32.3%
지하차도 12
 
3.9%
터널 11
 
3.5%
절토사면 4
 
1.3%
복개도로 2
 
0.6%
<NA> 1
 
0.3%

Length

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

Common Values (Plot)

2023-12-13T00:23:12.252201image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
교량 180
58.1%
옹벽 100
32.3%
지하차도 12
 
3.9%
터널 11
 
3.5%
절토사면 4
 
1.3%
복개도로 2
 
0.6%
na 1
 
0.3%

종별
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size2.6 KiB
기타
165 
2
64 
3
60 
1
21 

Length

Max length2
Median length2
Mean length1.5322581
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
기타 165
53.2%
2 64
 
20.6%
3 60
 
19.4%
1 21
 
6.8%

Length

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

Common Values (Plot)

2023-12-13T00:23:12.549535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기타 165
53.2%
2 64
 
20.6%
3 60
 
19.4%
1 21
 
6.8%

안전점검시작일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.6 KiB
2022-03-11
310 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-03-11
2nd row2022-03-11
3rd row2022-03-11
4th row2022-03-11
5th row2022-03-11

Common Values

ValueCountFrequency (%)
2022-03-11 310
100.0%

Length

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

Common Values (Plot)

2023-12-13T00:23:12.829717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-03-11 310
100.0%

안전점검종료일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.6 KiB
2022-06-08
310 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-06-08
2nd row2022-06-08
3rd row2022-06-08
4th row2022-06-08
5th row2022-06-08

Common Values

ValueCountFrequency (%)
2022-06-08 310
100.0%

Length

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

Common Values (Plot)

2023-12-13T00:23:13.088447image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-06-08 310
100.0%

점검결과
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size2.6 KiB
특이사항 없음
204 
보수필요
106 

Length

Max length7
Median length7
Mean length5.9741935
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row보수필요
2nd row보수필요
3rd row보수필요
4th row보수필요
5th row보수필요

Common Values

ValueCountFrequency (%)
특이사항 없음 204
65.8%
보수필요 106
34.2%

Length

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

Common Values (Plot)

2023-12-13T00:23:13.360549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
특이사항 204
39.7%
없음 204
39.7%
보수필요 106
20.6%

안전등급
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size2.6 KiB
양호
196 
B
66 
보통
31 
A
 
10
C
 
7

Length

Max length2
Median length2
Mean length1.7322581
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowC
2nd rowB
3rd rowB
4th rowB
5th row보통

Common Values

ValueCountFrequency (%)
양호 196
63.2%
B 66
 
21.3%
보통 31
 
10.0%
A 10
 
3.2%
C 7
 
2.3%

Length

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

Common Values (Plot)

2023-12-13T00:23:13.599327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
양호 196
63.2%
b 66
 
21.3%
보통 31
 
10.0%
a 10
 
3.2%
c 7
 
2.3%

조치계획
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct8
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size2.6 KiB
지속관찰
204 
주의관찰
100 
향후보수(표면처리, 단면복구(무근), 단면복구(방청), 재포장, 청소 등)
 
1
향후보수(표면처리, 단면복구(무근), 단면복구(방청), 배수로 설치, 재포장, 청소 등)
 
1
향후보수(표면처리, 단면복구, 오염제거, 청소 등)
 
1
Other values (3)
 
3

Length

Max length49
Median length4
Mean length4.5903226
Min length4

Unique

Unique6 ?
Unique (%)1.9%

Sample

1st row향후보수(표면처리, 단면복구(무근), 단면복구(방청), 재포장, 청소 등)
2nd row주의관찰
3rd row주의관찰
4th row주의관찰
5th row주의관찰

Common Values

ValueCountFrequency (%)
지속관찰 204
65.8%
주의관찰 100
32.3%
향후보수(표면처리, 단면복구(무근), 단면복구(방청), 재포장, 청소 등) 1
 
0.3%
향후보수(표면처리, 단면복구(무근), 단면복구(방청), 배수로 설치, 재포장, 청소 등) 1
 
0.3%
향후보수(표면처리, 단면복구, 오염제거, 청소 등) 1
 
0.3%
향후보수(균열보수, 단변보수, 배수구 보수, 실링재 보수 등) 1
 
0.3%
향후보수(표면보수, 단면보수(방청), 부분보수 등) 1
 
0.3%
향후보수(균열보수, 배수관길이연장, 단면보수 등) 1
 
0.3%

Length

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

Common Values (Plot)

2023-12-13T00:23:13.907566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
지속관찰 204
60.4%
주의관찰 100
29.6%
등 6
 
1.8%
향후보수(표면처리 3
 
0.9%
청소 3
 
0.9%
보수 2
 
0.6%
단면복구(무근 2
 
0.6%
단면복구(방청 2
 
0.6%
재포장 2
 
0.6%
향후보수(균열보수 2
 
0.6%
Other values (12) 12
 
3.6%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.6 KiB
2022-06-10
310 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-06-10
2nd row2022-06-10
3rd row2022-06-10
4th row2022-06-10
5th row2022-06-10

Common Values

ValueCountFrequency (%)
2022-06-10 310
100.0%

Length

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

Common Values (Plot)

2023-12-13T00:23:14.170667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-06-10 310
100.0%

Interactions

2023-12-13T00:23:10.707527image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T00:23:14.250572image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번분류종별점검결과안전등급조치계획
연번1.0000.0000.0000.4070.6040.241
분류0.0001.0000.5130.6310.3410.346
종별0.0000.5131.0000.8340.5880.691
점검결과0.4070.6310.8341.0000.7981.000
안전등급0.6040.3410.5880.7981.0000.793
조치계획0.2410.3460.6911.0000.7931.000
2023-12-13T00:23:14.389373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
점검결과조치계획종별분류안전등급
점검결과1.0000.9830.6270.4570.923
조치계획0.9831.0000.3650.2000.645
종별0.6270.3651.0000.3550.515
분류0.4570.2000.3551.0000.238
안전등급0.9230.6450.5150.2381.000
2023-12-13T00:23:14.542215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번분류종별점검결과안전등급조치계획
연번1.0000.0000.0000.3090.2910.116
분류0.0001.0000.3550.4570.2380.200
종별0.0000.3551.0000.6270.5150.365
점검결과0.3090.4570.6271.0000.9230.983
안전등급0.2910.2380.5150.9231.0000.645
조치계획0.1160.2000.3650.9830.6451.000

Missing values

2023-12-13T00:23:10.830671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T00:23:10.970798image/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

연번시설명분류종별안전점검시작일자안전점검종료일자점검결과안전등급조치계획데이터기준일자
01양유교교량32022-03-112022-06-08보수필요C향후보수(표면처리, 단면복구(무근), 단면복구(방청), 재포장, 청소 등)2022-06-10
12광천1교교량32022-03-112022-06-08보수필요B주의관찰2022-06-10
23양동교교량32022-03-112022-06-08보수필요B주의관찰2022-06-10
34동산교교량32022-03-112022-06-08보수필요B주의관찰2022-06-10
45천변구조물17교교량22022-03-112022-06-08보수필요보통주의관찰2022-06-10
56천변구조물18교교량22022-03-112022-06-08보수필요보통주의관찰2022-06-10
67천변구조물19교교량22022-03-112022-06-08보수필요보통주의관찰2022-06-10
78천교교량32022-03-112022-06-08보수필요B주의관찰2022-06-10
89서광주역교교량32022-03-112022-06-08보수필요B주의관찰2022-06-10
910매월교교량32022-03-112022-06-08보수필요B주의관찰2022-06-10
연번시설명분류종별안전점검시작일자안전점검종료일자점검결과안전등급조치계획데이터기준일자
300301유촌동옹벽1옹벽22022-03-112022-06-08특이사항 없음양호지속관찰2022-06-10
301302유촌동옹벽2옹벽22022-03-112022-06-08특이사항 없음양호지속관찰2022-06-10
302303무진교옹벽1옹벽기타2022-03-112022-06-08특이사항 없음양호지속관찰2022-06-10
303304무진교옹벽2옹벽기타2022-03-112022-06-08특이사항 없음양호지속관찰2022-06-10
304305무진교옹벽3옹벽기타2022-03-112022-06-08특이사항 없음양호지속관찰2022-06-10
305306무진교옹벽4옹벽22022-03-112022-06-08특이사항 없음양호지속관찰2022-06-10
306307무진교옹벽5옹벽기타2022-03-112022-06-08특이사항 없음양호지속관찰2022-06-10
307308무진교옹벽6옹벽22022-03-112022-06-08특이사항 없음양호지속관찰2022-06-10
308309우산3교옹벽1옹벽기타2022-03-112022-06-08특이사항 없음양호지속관찰2022-06-10
309310우산3교옹벽2옹벽기타2022-03-112022-06-08특이사항 없음양호지속관찰2022-06-10