Overview

Dataset statistics

Number of variables10
Number of observations117
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.4 KiB
Average record size in memory82.1 B

Variable types

Numeric1
Categorical8
Text1

Dataset

Description대전광역시 서구 공공시설물 내진성능 현황(시설물구분, 시설물명, 내진설계적용, 내진성능평가, 내진성능평가결과, 내진보강실시여부, 내진성능, 시설물 준공일, 담당부서) 입니다.
URLhttps://www.data.go.kr/data/15085359/fileData.do

Alerts

시설물구분 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 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 1 other fieldsHigh correlation
내진설계적용유무 is highly overall correlated with 내진성능평가 시행여부 and 2 other fieldsHigh correlation
내진성능 is highly overall correlated with 내진성능평가결과High correlation
내진보강실시여부 is highly imbalanced (57.9%)Imbalance
순번 has unique valuesUnique
시설물명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 13:37:28.056444
Analysis finished2023-12-12 13:37:29.190988
Duration1.13 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct117
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean59
Minimum1
Maximum117
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.2 KiB
2023-12-12T22:37:29.283827image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile6.8
Q130
median59
Q388
95-th percentile111.2
Maximum117
Range116
Interquartile range (IQR)58

Descriptive statistics

Standard deviation33.919021
Coefficient of variation (CV)0.57489866
Kurtosis-1.2
Mean59
Median Absolute Deviation (MAD)29
Skewness0
Sum6903
Variance1150.5
MonotonicityStrictly increasing
2023-12-12T22:37:29.768391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.9%
75 1
 
0.9%
87 1
 
0.9%
86 1
 
0.9%
85 1
 
0.9%
84 1
 
0.9%
83 1
 
0.9%
82 1
 
0.9%
81 1
 
0.9%
80 1
 
0.9%
Other values (107) 107
91.5%
ValueCountFrequency (%)
1 1
0.9%
2 1
0.9%
3 1
0.9%
4 1
0.9%
5 1
0.9%
6 1
0.9%
7 1
0.9%
8 1
0.9%
9 1
0.9%
10 1
0.9%
ValueCountFrequency (%)
117 1
0.9%
116 1
0.9%
115 1
0.9%
114 1
0.9%
113 1
0.9%
112 1
0.9%
111 1
0.9%
110 1
0.9%
109 1
0.9%
108 1
0.9%

시설물구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
공공건축물
102 
교량
15 

Length

Max length5
Median length5
Mean length4.6153846
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row공공건축물
2nd row교량
3rd row교량
4th row교량
5th row교량

Common Values

ValueCountFrequency (%)
공공건축물 102
87.2%
교량 15
 
12.8%

Length

2023-12-12T22:37:29.937041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:37:30.052232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공공건축물 102
87.2%
교량 15
 
12.8%

시설물명
Text

UNIQUE 

Distinct117
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2023-12-12T22:37:30.294122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length9
Mean length6.4957265
Min length3

Characters and Unicode

Total characters760
Distinct characters144
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

Unique117 ?
Unique (%)100.0%

Sample

1st row오량실내테니스장
2nd row우명교
3rd row원정1교
4th row조평교
5th row금곡교
ValueCountFrequency (%)
오량실내테니스장 1
 
0.9%
둔산2동주민센터 1
 
0.9%
청소년문화의집 1
 
0.9%
괴정경로당 1
 
0.9%
월평2동주민센터 1
 
0.9%
하늘경로당 1
 
0.9%
지치울경로당 1
 
0.9%
윗정림경로당 1
 
0.9%
선골경로당 1
 
0.9%
신선암경로당 1
 
0.9%
Other values (107) 107
91.5%
2023-12-12T22:37:30.757182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
경 44
 
5.8%
당 44
 
5.8%
로 44
 
5.8%
동 33
 
4.3%
주 29
 
3.8%
터 28
 
3.7%
센 28
 
3.7%
민 27
 
3.6%
관 19
 
2.5%
장 13
 
1.7%
Other values (134) 451
59.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 723
95.1%
Decimal Number 33
 
4.3%
Close Punctuation 2
 
0.3%
Open Punctuation 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
경 44
 
6.1%
당 44
 
6.1%
로 44
 
6.1%
동 33
 
4.6%
주 29
 
4.0%
터 28
 
3.9%
센 28
 
3.9%
민 27
 
3.7%
관 19
 
2.6%
장 13
 
1.8%
Other values (129) 414
57.3%
Decimal Number
ValueCountFrequency (%)
1 13
39.4%
2 13
39.4%
3 7
21.2%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 723
95.1%
Common 37
 
4.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
경 44
 
6.1%
당 44
 
6.1%
로 44
 
6.1%
동 33
 
4.6%
주 29
 
4.0%
터 28
 
3.9%
센 28
 
3.9%
민 27
 
3.7%
관 19
 
2.6%
장 13
 
1.8%
Other values (129) 414
57.3%
Common
ValueCountFrequency (%)
1 13
35.1%
2 13
35.1%
3 7
18.9%
) 2
 
5.4%
( 2
 
5.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 723
95.1%
ASCII 37
 
4.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
경 44
 
6.1%
당 44
 
6.1%
로 44
 
6.1%
동 33
 
4.6%
주 29
 
4.0%
터 28
 
3.9%
센 28
 
3.9%
민 27
 
3.7%
관 19
 
2.6%
장 13
 
1.8%
Other values (129) 414
57.3%
ASCII
ValueCountFrequency (%)
1 13
35.1%
2 13
35.1%
3 7
18.9%
) 2
 
5.4%
( 2
 
5.4%

시설물종류
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
공공건축물
102 
도로시설물
15 

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 (%)
공공건축물 102
87.2%
도로시설물 15
 
12.8%

Length

2023-12-12T22:37:30.935193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:37:31.049998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공공건축물 102
87.2%
도로시설물 15
 
12.8%

내진설계적용유무
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
미적용
83 
적용
34 

Length

Max length3
Median length3
Mean length2.7094017
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row적용
2nd row미적용
3rd row미적용
4th row미적용
5th row미적용

Common Values

ValueCountFrequency (%)
미적용 83
70.9%
적용 34
29.1%

Length

2023-12-12T22:37:31.175881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:37:31.282220image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
미적용 83
70.9%
적용 34
29.1%

내진성능평가 시행여부
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
시행
84 
해당없음
33 

Length

Max length4
Median length2
Mean length2.5641026
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row해당없음
2nd row시행
3rd row시행
4th row시행
5th row시행

Common Values

ValueCountFrequency (%)
시행 84
71.8%
해당없음 33
 
28.2%

Length

2023-12-12T22:37:31.401787image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:37:31.509187image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
시행 84
71.8%
해당없음 33
 
28.2%

내진성능평가결과
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
적합
45 
부적합
39 
해당없음
33 

Length

Max length4
Median length3
Mean length2.8974359
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row해당없음
2nd row적합
3rd row부적합
4th row적합
5th row적합

Common Values

ValueCountFrequency (%)
적합 45
38.5%
부적합 39
33.3%
해당없음 33
28.2%

Length

2023-12-12T22:37:31.645510image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:37:31.759500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
적합 45
38.5%
부적합 39
33.3%
해당없음 33
28.2%

내진보강실시여부
Categorical

IMBALANCE 

Distinct3
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
해당없음
99 
실시
17 
실시 중
 
1

Length

Max length4
Median length4
Mean length3.7094017
Min length2

Unique

Unique1 ?
Unique (%)0.9%

Sample

1st row해당없음
2nd row해당없음
3rd row해당없음
4th row해당없음
5th row해당없음

Common Values

ValueCountFrequency (%)
해당없음 99
84.6%
실시 17
 
14.5%
실시 중 1
 
0.9%

Length

2023-12-12T22:37:31.887542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:37:32.015959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
해당없음 99
83.9%
실시 18
 
15.3%
중 1
 
0.8%

내진성능
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
적합
93 
부적합
24 

Length

Max length3
Median length2
Mean length2.2051282
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row적합
2nd row적합
3rd row부적합
4th row적합
5th row적합

Common Values

ValueCountFrequency (%)
적합 93
79.5%
부적합 24
 
20.5%

Length

2023-12-12T22:37:32.131320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:37:32.252857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
적합 93
79.5%
부적합 24
 
20.5%

담당부서
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)8.5%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
사회복지과
49 
자치분권과
26 
건설과
15 
문화체육과
9 
복지정책과
 
4
Other values (5)
14 

Length

Max length6
Median length5
Mean length4.7264957
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row문화체육과
2nd row건설과
3rd row건설과
4th row건설과
5th row건설과

Common Values

ValueCountFrequency (%)
사회복지과 49
41.9%
자치분권과 26
22.2%
건설과 15
 
12.8%
문화체육과 9
 
7.7%
복지정책과 4
 
3.4%
주차행정과 4
 
3.4%
평생학습원 4
 
3.4%
여성가족과 2
 
1.7%
일자리경제실 2
 
1.7%
보건소 2
 
1.7%

Length

2023-12-12T22:37:32.388232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:37:32.524858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사회복지과 49
41.9%
자치분권과 26
22.2%
건설과 15
 
12.8%
문화체육과 9
 
7.7%
복지정책과 4
 
3.4%
주차행정과 4
 
3.4%
평생학습원 4
 
3.4%
여성가족과 2
 
1.7%
일자리경제실 2
 
1.7%
보건소 2
 
1.7%

Interactions

2023-12-12T22:37:28.754318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T22:37:32.656944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번시설물구분시설물종류내진설계적용유무내진성능평가 시행여부내진성능평가결과내진보강실시여부내진성능담당부서
순번1.0000.9650.9650.4260.4090.3390.1360.0330.845
시설물구분0.9651.0000.9980.1220.1410.0830.0000.0591.000
시설물종류0.9650.9981.0000.1220.1410.0830.0000.0591.000
내진설계적용유무0.4260.1220.1221.0000.9800.6300.1460.4380.696
내진성능평가 시행여부0.4090.1410.1410.9801.0001.0000.0600.4280.690
내진성능평가결과0.3390.0830.0830.6301.0001.0000.6790.4610.532
내진보강실시여부0.1360.0000.0000.1460.0600.6791.0000.1460.118
내진성능0.0330.0590.0590.4380.4280.4610.1461.0000.397
담당부서0.8451.0001.0000.6960.6900.5320.1180.3971.000
2023-12-12T22:37:32.814430image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시설물구분내진성능평가 시행여부내진설계적용유무내진보강실시여부담당부서시설물종류내진성능평가결과내진성능
시설물구분1.0000.0900.0770.0000.9650.9610.1360.037
내진성능평가 시행여부0.0901.0000.8740.0980.5190.0900.9960.281
내진설계적용유무0.0770.8741.0000.2400.5240.0770.8920.288
내진보강실시여부0.0000.0980.2401.0000.0630.0000.3370.240
담당부서0.9650.5190.5240.0631.0000.9650.3640.293
시설물종류0.9610.0900.0770.0000.9651.0000.1360.037
내진성능평가결과0.1360.9960.8920.3370.3640.1361.0000.709
내진성능0.0370.2810.2880.2400.2930.0370.7091.000
2023-12-12T22:37:32.949872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번시설물구분시설물종류내진설계적용유무내진성능평가 시행여부내진성능평가결과내진보강실시여부내진성능담당부서
순번1.0000.8090.8090.3150.3020.2080.0740.0000.414
시설물구분0.8091.0000.9610.0770.0900.1360.0000.0370.965
시설물종류0.8090.9611.0000.0770.0900.1360.0000.0370.965
내진설계적용유무0.3150.0770.0771.0000.8740.8920.2400.2880.524
내진성능평가 시행여부0.3020.0900.0900.8741.0000.9960.0980.2810.519
내진성능평가결과0.2080.1360.1360.8920.9961.0000.3370.7090.364
내진보강실시여부0.0740.0000.0000.2400.0980.3371.0000.2400.063
내진성능0.0000.0370.0370.2880.2810.7090.2401.0000.293
담당부서0.4140.9650.9650.5240.5190.3640.0630.2931.000

Missing values

2023-12-12T22:37:28.881088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T22:37:29.117051image/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공공건축물오량실내테니스장공공건축물적용해당없음해당없음해당없음적합문화체육과
12교량우명교도로시설물미적용시행적합해당없음적합건설과
23교량원정1교도로시설물미적용시행부적합해당없음부적합건설과
34교량조평교도로시설물미적용시행적합해당없음적합건설과
45교량금곡교도로시설물미적용시행적합해당없음적합건설과
56교량매노1구소교도로시설물미적용시행적합해당없음적합건설과
67교량용태울다리도로시설물미적용시행적합해당없음적합건설과
78교량미리미교도로시설물적용해당없음해당없음해당없음적합건설과
89교량원정교도로시설물적용해당없음해당없음해당없음적합건설과
910교량구봉1교도로시설물적용해당없음해당없음해당없음적합건설과
순번시설물구분시설물명시설물종류내진설계적용유무내진성능평가 시행여부내진성능평가결과내진보강실시여부내진성능담당부서
107108공공건축물가수원도서관공공건축물미적용시행적합해당없음적합평생학습원
108109공공건축물기성다목적종합복지센터공공건축물적용시행적합해당없음적합복지정책과
109110공공건축물도마실국민체육센터공공건축물적용해당없음해당없음해당없음적합문화체육과
110111공공건축물월평동공영주차장공공건축물적용해당없음해당없음해당없음적합주차행정과
111112공공건축물관저문예회관공공건축물적용해당없음해당없음해당없음적합주차행정과
112113공공건축물갈마제2경로당공공건축물미적용시행부적합해당없음부적합사회복지과
113114공공건축물대신경로당공공건축물미적용시행부적합실시적합사회복지과
114115공공건축물백야경로당공공건축물미적용시행부적합실시적합사회복지과
115116공공건축물건강체련관공공건축물미적용시행부적합실시 중부적합사회복지과
116117공공건축물둔산3동주민센터공공건축물미적용시행부적합실시적합자치분권과