Overview

Dataset statistics

Number of variables7
Number of observations33
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.0 KiB
Average record size in memory62.0 B

Variable types

Numeric2
Text1
Categorical3
DateTime1

Dataset

Description국토안전관리원 특수시설관리실에서 유지관리 중인 33개소의 일반국도 상 특수교량(사장교, 현수교 등) 현황을 제공합니다.
Author국토안전관리원
URLhttps://www.data.go.kr/data/15040881/fileData.do

Alerts

연번 is highly overall correlated with 비고High correlation
관리주체 is highly overall correlated with 비고High correlation
비고 is highly overall correlated with 연번 and 1 other fieldsHigh correlation
비고 is highly imbalanced (52.0%)Imbalance
연번 has unique valuesUnique
교량명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 02:58:26.345808
Analysis finished2023-12-12 02:58:27.271840
Duration0.93 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct33
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17
Minimum1
Maximum33
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size429.0 B
2023-12-12T11:58:27.706172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.6
Q19
median17
Q325
95-th percentile31.4
Maximum33
Range32
Interquartile range (IQR)16

Descriptive statistics

Standard deviation9.6695398
Coefficient of variation (CV)0.56879646
Kurtosis-1.2
Mean17
Median Absolute Deviation (MAD)8
Skewness0
Sum561
Variance93.5
MonotonicityStrictly increasing
2023-12-12T11:58:27.945107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=33)
ValueCountFrequency (%)
1 1
 
3.0%
26 1
 
3.0%
20 1
 
3.0%
21 1
 
3.0%
22 1
 
3.0%
23 1
 
3.0%
24 1
 
3.0%
25 1
 
3.0%
27 1
 
3.0%
2 1
 
3.0%
Other values (23) 23
69.7%
ValueCountFrequency (%)
1 1
3.0%
2 1
3.0%
3 1
3.0%
4 1
3.0%
5 1
3.0%
6 1
3.0%
7 1
3.0%
8 1
3.0%
9 1
3.0%
10 1
3.0%
ValueCountFrequency (%)
33 1
3.0%
32 1
3.0%
31 1
3.0%
30 1
3.0%
29 1
3.0%
28 1
3.0%
27 1
3.0%
26 1
3.0%
25 1
3.0%
24 1
3.0%

교량명
Text

UNIQUE 

Distinct33
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size396.0 B
2023-12-12T11:58:28.216357image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length4
Mean length4.4545455
Min length3

Characters and Unicode

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

Unique

Unique33 ?
Unique (%)100.0%

Sample

1st row진도대교
2nd row신거제대교
3rd row백야대교
4th row제2진도대교
5th row압해대교
ValueCountFrequency (%)
진도대교 1
 
3.0%
팔영대교 1
 
3.0%
임자대교1 1
 
3.0%
원산안면대교 1
 
3.0%
칠산대교 1
 
3.0%
둔병대교 1
 
3.0%
화양조발대교 1
 
3.0%
초양대교 1
 
3.0%
삼천포대교 1
 
3.0%
천사대교2 1
 
3.0%
Other values (23) 23
69.7%
2023-12-12T11:58:28.806005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
교 33
22.4%
대 31
21.1%
도 4
 
2.7%
천 4
 
2.7%
산 3
 
2.0%
거 3
 
2.0%
자 3
 
2.0%
2 3
 
2.0%
동 3
 
2.0%
진 2
 
1.4%
Other values (46) 58
39.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 142
96.6%
Decimal Number 5
 
3.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
교 33
23.2%
대 31
21.8%
도 4
 
2.8%
천 4
 
2.8%
산 3
 
2.1%
거 3
 
2.1%
자 3
 
2.1%
동 3
 
2.1%
진 2
 
1.4%
영 2
 
1.4%
Other values (44) 54
38.0%
Decimal Number
ValueCountFrequency (%)
2 3
60.0%
1 2
40.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 142
96.6%
Common 5
 
3.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
교 33
23.2%
대 31
21.8%
도 4
 
2.8%
천 4
 
2.8%
산 3
 
2.1%
거 3
 
2.1%
자 3
 
2.1%
동 3
 
2.1%
진 2
 
1.4%
영 2
 
1.4%
Other values (44) 54
38.0%
Common
ValueCountFrequency (%)
2 3
60.0%
1 2
40.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 142
96.6%
ASCII 5
 
3.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
교 33
23.2%
대 31
21.8%
도 4
 
2.8%
천 4
 
2.8%
산 3
 
2.1%
거 3
 
2.1%
자 3
 
2.1%
동 3
 
2.1%
진 2
 
1.4%
영 2
 
1.4%
Other values (44) 54
38.0%
ASCII
ValueCountFrequency (%)
2 3
60.0%
1 2
40.0%

형식
Categorical

Distinct4
Distinct (%)12.1%
Missing0
Missing (%)0.0%
Memory size396.0 B
사장교
24 
현수교
5 
아치교
3 
강상형교
 
1

Length

Max length4
Median length3
Mean length3.030303
Min length3

Unique

Unique1 ?
Unique (%)3.0%

Sample

1st row사장교
2nd row강상형교
3rd row아치교
4th row사장교
5th row아치교

Common Values

ValueCountFrequency (%)
사장교 24
72.7%
현수교 5
 
15.2%
아치교 3
 
9.1%
강상형교 1
 
3.0%

Length

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

Common Values (Plot)

2023-12-12T11:58:29.272753image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사장교 24
72.7%
현수교 5
 
15.2%
아치교 3
 
9.1%
강상형교 1
 
3.0%

연장(m)
Real number (ℝ)

Distinct30
Distinct (%)90.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1136.9394
Minimum317
Maximum3640
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size429.0 B
2023-12-12T11:58:29.447222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum317
5-th percentile406
Q1576
median875
Q31340
95-th percentile3269.6
Maximum3640
Range3323
Interquartile range (IQR)764

Descriptive statistics

Standard deviation856.57658
Coefficient of variation (CV)0.75340566
Kurtosis3.1500381
Mean1136.9394
Median Absolute Deviation (MAD)375
Skewness1.8625608
Sum37519
Variance733723.43
MonotonicityNot monotonic
2023-12-12T11:58:29.681468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
484 2
 
6.1%
595 2
 
6.1%
990 2
 
6.1%
1340 1
 
3.0%
1135 1
 
3.0%
750 1
 
3.0%
1755 1
 
3.0%
1820 1
 
3.0%
854 1
 
3.0%
317 1
 
3.0%
Other values (20) 20
60.6%
ValueCountFrequency (%)
317 1
3.0%
325 1
3.0%
460 1
3.0%
484 2
6.1%
495 1
3.0%
500 1
3.0%
550 1
3.0%
576 1
3.0%
590 1
3.0%
595 2
6.1%
ValueCountFrequency (%)
3640 1
3.0%
3584 1
3.0%
3060 1
3.0%
2028 1
3.0%
1820 1
3.0%
1755 1
3.0%
1420 1
3.0%
1345 1
3.0%
1340 1
3.0%
1305 1
3.0%

준공시기
Date

Distinct26
Distinct (%)78.8%
Missing0
Missing (%)0.0%
Memory size396.0 B
Minimum1984-10-01 00:00:00
Maximum2021-03-01 00:00:00
2023-12-12T11:58:29.994555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:58:30.228580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)

관리주체
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)27.3%
Missing0
Missing (%)0.0%
Memory size396.0 B
익산청(해상교량안전과)
23 
부산청(진주국토)
 
2
경상남도 사천시
 
2
원주청(정선국토)
 
1
부산청(영주국토)
 
1
Other values (4)
4 

Length

Max length12
Median length12
Mean length10.878788
Min length3

Unique

Unique6 ?
Unique (%)18.2%

Sample

1st row익산청(해상교량안전과)
2nd row부산청(진주국토)
3rd row익산청(해상교량안전과)
4th row익산청(해상교량안전과)
5th row익산청(해상교량안전과)

Common Values

ValueCountFrequency (%)
익산청(해상교량안전과) 23
69.7%
부산청(진주국토) 2
 
6.1%
경상남도 사천시 2
 
6.1%
원주청(정선국토) 1
 
3.0%
부산청(영주국토) 1
 
3.0%
서울청(의정부국토) 1
 
3.0%
익산청(전주국토) 1
 
3.0%
익산청(순천국토) 1
 
3.0%
대전청 1
 
3.0%

Length

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

Common Values (Plot)

2023-12-12T11:58:30.681157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
익산청(해상교량안전과 23
65.7%
부산청(진주국토 2
 
5.7%
경상남도 2
 
5.7%
사천시 2
 
5.7%
원주청(정선국토 1
 
2.9%
부산청(영주국토 1
 
2.9%
서울청(의정부국토 1
 
2.9%
익산청(전주국토 1
 
2.9%
익산청(순천국토 1
 
2.9%
대전청 1
 
2.9%

비고
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)9.1%
Missing0
Missing (%)0.0%
Memory size396.0 B
<NA>
28 
일반교량(계측시스템만 운영)
3 
지자체 관리교량
 
2

Length

Max length15
Median length4
Mean length5.2424242
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row일반교량(계측시스템만 운영)
3rd row일반교량(계측시스템만 운영)
4th row<NA>
5th row일반교량(계측시스템만 운영)

Common Values

ValueCountFrequency (%)
<NA> 28
84.8%
일반교량(계측시스템만 운영) 3
 
9.1%
지자체 관리교량 2
 
6.1%

Length

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

Common Values (Plot)

2023-12-12T11:58:31.088710image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 28
73.7%
일반교량(계측시스템만 3
 
7.9%
운영 3
 
7.9%
지자체 2
 
5.3%
관리교량 2
 
5.3%

Interactions

2023-12-12T11:58:26.840136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:58:26.653921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:58:26.931905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:58:26.742683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T11:58:31.239224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번교량명형식연장(m)준공시기관리주체비고
연번1.0001.0000.0000.5100.9670.1671.000
교량명1.0001.0001.0001.0001.0001.0001.000
형식0.0001.0001.0000.0000.7090.1810.165
연장(m)0.5101.0000.0001.0000.8480.0001.000
준공시기0.9671.0000.7090.8481.0000.9621.000
관리주체0.1671.0000.1810.0000.9621.0001.000
비고1.0001.0000.1651.0001.0001.0001.000
2023-12-12T11:58:31.511467image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리주체형식비고
관리주체1.0000.0550.816
형식0.0551.0000.000
비고0.8160.0001.000
2023-12-12T11:58:31.735453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번연장(m)형식관리주체비고
연번1.0000.3180.0000.0000.577
연장(m)0.3181.0000.0000.0000.000
형식0.0000.0001.0000.0550.000
관리주체0.0000.0000.0551.0000.816
비고0.5770.0000.0000.8161.000

Missing values

2023-12-12T11:58:27.064415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T11:58:27.213918image/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진도대교사장교4841984-10-01익산청(해상교량안전과)<NA>
12신거제대교강상형교9402000-07-01부산청(진주국토)일반교량(계측시스템만 운영)
23백야대교아치교3252005-03-01익산청(해상교량안전과)일반교량(계측시스템만 운영)
34제2진도대교사장교4842006-04-01익산청(해상교량안전과)<NA>
45압해대교아치교14202009-01-01익산청(해상교량안전과)일반교량(계측시스템만 운영)
56소록대교현수교11602009-01-01익산청(해상교량안전과)<NA>
67동강대교사장교4602009-07-01원주청(정선국토)<NA>
78거금대교사장교20282012-04-01익산청(해상교량안전과)<NA>
89거북선대교사장교7442012-06-01익산청(해상교량안전과)<NA>
910완도대교사장교5002012-12-01익산청(해상교량안전과)<NA>
연번교량명형식연장(m)준공시기관리주체비고
2324천사대교1사장교35842019-04-01익산청(해상교량안전과)<NA>
2425천사대교2현수교36402019-04-01익산청(해상교량안전과)<NA>
2526삼천포대교사장교10562003-05-01경상남도 사천시지자체 관리교량
2627초양대교아치교3172003-05-01경상남도 사천시지자체 관리교량
2728화양조발대교사장교8542020-03-01익산청(해상교량안전과)<NA>
2829둔병대교사장교9902019-12-01익산청(해상교량안전과)<NA>
2930칠산대교사장교18202019-12-01익산청(해상교량안전과)<NA>
3031원산안면대교사장교17552019-12-01대전청<NA>
3132임자대교1사장교7502021-03-01익산청(해상교량안전과)<NA>
3233임자대교2사장교11352021-03-01익산청(해상교량안전과)<NA>