Overview

Dataset statistics

Number of variables3
Number of observations245
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.1 KiB
Average record size in memory25.5 B

Variable types

Numeric1
Categorical1
Text1

Dataset

Description국도상에 위치한 특수교량의 계측데이터를 관리하는 업무로 특수교통합계측관리시스템에서 관리하는 특수교량의 위치 법정코드를 제공함
Author국토교통부
URLhttps://www.data.go.kr/data/15123652/fileData.do

Alerts

시군구법정코드1 is highly overall correlated with 시군구법정코드2High correlation
시군구법정코드2 is highly overall correlated with 시군구법정코드1High correlation
시군구법정코드1 has unique valuesUnique

Reproduction

Analysis started2023-12-12 20:01:16.675510
Analysis finished2023-12-12 20:01:17.211149
Duration0.54 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시군구법정코드1
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct245
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.7604682 × 109
Minimum1.1 × 109
Maximum5.013 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.3 KiB
2023-12-13T05:01:17.327774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.1 × 109
5-th percentile1.1386 × 109
Q12.871 × 109
median4.272 × 109
Q34.672 × 109
95-th percentile4.8642 × 109
Maximum5.013 × 109
Range3.913 × 109
Interquartile range (IQR)1.801 × 109

Descriptive statistics

Standard deviation1.1623881 × 109
Coefficient of variation (CV)0.30910729
Kurtosis0.10264549
Mean3.7604682 × 109
Median Absolute Deviation (MAD)4.47 × 108
Skewness-1.1280356
Sum9.213147 × 1011
Variance1.3511462 × 1018
MonotonicityStrictly increasing
2023-12-13T05:01:17.537528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1100000000 1
 
0.4%
4471000000 1
 
0.4%
4477000000 1
 
0.4%
4479000000 1
 
0.4%
4480000000 1
 
0.4%
4481000000 1
 
0.4%
4482500000 1
 
0.4%
4500000000 1
 
0.4%
4511000000 1
 
0.4%
4513000000 1
 
0.4%
Other values (235) 235
95.9%
ValueCountFrequency (%)
1100000000 1
0.4%
1111000000 1
0.4%
1114000000 1
0.4%
1117000000 1
0.4%
1120000000 1
0.4%
1121500000 1
0.4%
1123000000 1
0.4%
1126000000 1
0.4%
1129000000 1
0.4%
1130500000 1
0.4%
ValueCountFrequency (%)
5013000000 1
0.4%
5011000000 1
0.4%
5000000000 1
0.4%
4889000000 1
0.4%
4888000000 1
0.4%
4887000000 1
0.4%
4886000000 1
0.4%
4885000000 1
0.4%
4884000000 1
0.4%
4882000000 1
0.4%

시군구법정코드2
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)6.9%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
4100000000
31 
1100000000
25 
4700000000
23 
4600000000
22 
4800000000
18 
Other values (12)
126 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
4100000000 31
12.7%
1100000000 25
10.2%
4700000000 23
9.4%
4600000000 22
9.0%
4800000000 18
 
7.3%
4200000000 18
 
7.3%
17
 
6.9%
2600000000 16
 
6.5%
4400000000 15
 
6.1%
4500000000 14
 
5.7%
Other values (7) 46
18.8%

Length

2023-12-13T05:01:17.682645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
4100000000 31
13.6%
1100000000 25
11.0%
4700000000 23
10.1%
4600000000 22
9.6%
4800000000 18
7.9%
4200000000 18
7.9%
2600000000 16
7.0%
4400000000 15
6.6%
4500000000 14
 
6.1%
4300000000 11
 
4.8%
Other values (6) 35
15.4%

시군구명
Text

Distinct222
Distinct (%)90.6%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2023-12-13T05:01:18.028680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length3
Mean length3.044898
Min length2

Characters and Unicode

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

Unique

Unique215 ?
Unique (%)87.8%

Sample

1st row서울특별시
2nd row종로구
3rd row중구
4th row용산구
5th row성동구
ValueCountFrequency (%)
중구 6
 
2.4%
동구 6
 
2.4%
남구 5
 
2.0%
서구 5
 
2.0%
북구 4
 
1.6%
고성군 2
 
0.8%
강서구 2
 
0.8%
남원시 1
 
0.4%
완주군 1
 
0.4%
김제시 1
 
0.4%
Other values (212) 212
86.5%
2023-12-13T05:01:18.507817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
시 86
 
11.5%
군 85
 
11.4%
구 75
 
10.1%
천 23
 
3.1%
주 22
 
2.9%
성 18
 
2.4%
산 18
 
2.4%
양 18
 
2.4%
동 17
 
2.3%
남 16
 
2.1%
Other values (127) 368
49.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 746
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 86
 
11.5%
군 85
 
11.4%
구 75
 
10.1%
천 23
 
3.1%
주 22
 
2.9%
성 18
 
2.4%
산 18
 
2.4%
양 18
 
2.4%
동 17
 
2.3%
남 16
 
2.1%
Other values (127) 368
49.3%

Most occurring scripts

ValueCountFrequency (%)
Hangul 746
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 86
 
11.5%
군 85
 
11.4%
구 75
 
10.1%
천 23
 
3.1%
주 22
 
2.9%
성 18
 
2.4%
산 18
 
2.4%
양 18
 
2.4%
동 17
 
2.3%
남 16
 
2.1%
Other values (127) 368
49.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 746
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
시 86
 
11.5%
군 85
 
11.4%
구 75
 
10.1%
천 23
 
3.1%
주 22
 
2.9%
성 18
 
2.4%
산 18
 
2.4%
양 18
 
2.4%
동 17
 
2.3%
남 16
 
2.1%
Other values (127) 368
49.3%

Interactions

2023-12-13T05:01:16.840922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T05:01:18.648948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구법정코드1시군구법정코드2
시군구법정코드11.0000.967
시군구법정코드20.9671.000
2023-12-13T05:01:18.786878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구법정코드1시군구법정코드2
시군구법정코드11.0000.836
시군구법정코드20.8361.000

Missing values

2023-12-13T05:01:17.025923image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T05:01:17.148928image/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

시군구법정코드1시군구법정코드2시군구명
01100000000서울특별시
111110000001100000000종로구
211140000001100000000중구
311170000001100000000용산구
411200000001100000000성동구
511215000001100000000광진구
611230000001100000000동대문구
711260000001100000000중랑구
811290000001100000000성북구
911305000001100000000강북구
시군구법정코드1시군구법정코드2시군구명
23548820000004800000000고성군
23648840000004800000000남해군
23748850000004800000000하동군
23848860000004800000000산청군
23948870000004800000000함양군
24048880000004800000000거창군
24148890000004800000000합천군
2425000000000제주특별자치도
24350110000005000000000제주시
24450130000005000000000서귀포시