Overview

Dataset statistics

Number of variables4
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows1606
Duplicate rows (%)16.1%
Total size in memory390.6 KiB
Average record size in memory40.0 B

Variable types

Text1
Categorical1
DateTime2

Dataset

Description국토안전관리원의 시설물점검진단시스템이 보유하고 있는 보고서 관련 정보입니다. 시설물번호별 보고서 유형이 구분되어있습니다.
Author국토안전관리원
URLhttps://www.data.go.kr/data/15064180/fileData.do

Alerts

Dataset has 1606 (16.1%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 18:03:41.825847
Analysis finished2023-12-12 18:03:42.526013
Duration0.7 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시설물번호
Text

Distinct5937
Distinct (%)59.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-13T03:03:42.770757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

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

Unique

Unique3192 ?
Unique (%)31.9%

Sample

1st rowAY20190352
2nd rowAY20190026
3rd rowAS20080063
4th rowAY20180157
5th rowAY20160096
ValueCountFrequency (%)
ay20170080 9
 
0.1%
ay20190334 7
 
0.1%
ay20160244 7
 
0.1%
ay20190478 7
 
0.1%
ay20190040 6
 
0.1%
ay20180152 6
 
0.1%
ay20190078 6
 
0.1%
ay20190057 6
 
0.1%
ay20140199 6
 
0.1%
ay20190157 6
 
0.1%
Other values (5927) 9934
99.3%
2023-12-13T03:03:43.311182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 24772
24.8%
1 15832
15.8%
2 14820
14.8%
A 10000
10.0%
S 5358
 
5.4%
Y 4642
 
4.6%
3 4501
 
4.5%
4 4426
 
4.4%
9 3740
 
3.7%
7 3183
 
3.2%
Other values (3) 8726
 
8.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 80000
80.0%
Uppercase Letter 20000
 
20.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 24772
31.0%
1 15832
19.8%
2 14820
18.5%
3 4501
 
5.6%
4 4426
 
5.5%
9 3740
 
4.7%
7 3183
 
4.0%
8 2937
 
3.7%
5 2932
 
3.7%
6 2857
 
3.6%
Uppercase Letter
ValueCountFrequency (%)
A 10000
50.0%
S 5358
26.8%
Y 4642
23.2%

Most occurring scripts

ValueCountFrequency (%)
Common 80000
80.0%
Latin 20000
 
20.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 24772
31.0%
1 15832
19.8%
2 14820
18.5%
3 4501
 
5.6%
4 4426
 
5.5%
9 3740
 
4.7%
7 3183
 
4.0%
8 2937
 
3.7%
5 2932
 
3.7%
6 2857
 
3.6%
Latin
ValueCountFrequency (%)
A 10000
50.0%
S 5358
26.8%
Y 4642
23.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 100000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 24772
24.8%
1 15832
15.8%
2 14820
14.8%
A 10000
10.0%
S 5358
 
5.4%
Y 4642
 
4.6%
3 4501
 
4.5%
4 4426
 
4.4%
9 3740
 
3.7%
7 3183
 
3.2%
Other values (3) 8726
 
8.7%

보고서구분
Categorical

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
총평 및 건의사항
3184 
안전점검보고서_유지관리방안
2454 
유지관리방안
2174 
안전점검보고서_총평
1730 
안전점검보고서_기타청문사항
379 

Length

Max length15
Median length14
Mean length9.9847
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row안전점검보고서_총평
2nd row안전점검보고서_유지관리방안
3rd row총평 및 건의사항
4th row안전점검보고서_유지관리방안
5th row안전점검보고서_총평

Common Values

ValueCountFrequency (%)
총평 및 건의사항 3184
31.8%
안전점검보고서_유지관리방안 2454
24.5%
유지관리방안 2174
21.7%
안전점검보고서_총평 1730
17.3%
안전점검보고서_기타청문사항 379
 
3.8%
안전점검보고서_기존보고서검토 79
 
0.8%

Length

2023-12-13T03:03:43.488692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:03:43.657149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
총평 3184
19.5%
및 3184
19.5%
건의사항 3184
19.5%
안전점검보고서_유지관리방안 2454
15.0%
유지관리방안 2174
13.3%
안전점검보고서_총평 1730
10.6%
안전점검보고서_기타청문사항 379
 
2.3%
안전점검보고서_기존보고서검토 79
 
0.5%

최초등록일시
Date

Distinct6363
Distinct (%)63.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2012-01-09 17:54:26
Maximum2019-11-11 14:02:12
2023-12-13T03:03:43.848212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:03:44.038140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

최종수정일시
Date

Distinct6202
Distinct (%)62.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2012-01-27 10:05:36
Maximum2019-11-11 14:02:12
2023-12-13T03:03:44.221758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:03:44.402410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Missing values

2023-12-13T03:03:42.369499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T03:03:42.472693image/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

시설물번호보고서구분최초등록일시최종수정일시
37601AY20190352안전점검보고서_총평2019-06-19 18:03:372019-06-19 18:03:37
37297AY20190026안전점검보고서_유지관리방안2019-08-16 10:41:562019-08-16 10:41:56
11270AS20080063총평 및 건의사항2014-02-26 16:22:442014-02-26 16:22:44
35221AY20180157안전점검보고서_유지관리방안2018-10-01 17:05:252018-10-01 17:05:25
33063AY20160096안전점검보고서_총평2016-10-12 21:37:052016-10-12 21:37:05
30017AY20170299안전점검보고서_유지관리방안2017-09-13 14:15:542017-09-13 14:15:54
36360AY20190429안전점검보고서_유지관리방안2019-03-19 14:40:192019-03-19 14:40:19
5660AS20130251유지관리방안2013-05-06 17:44:472013-05-06 17:44:47
10566AS20110480유지관리방안2014-02-18 09:17:052014-02-18 09:17:05
33074AY20180299안전점검보고서_유지관리방안2018-10-10 14:57:392018-10-10 14:57:39
시설물번호보고서구분최초등록일시최종수정일시
32340AY20180208안전점검보고서_총평2018-07-31 11:35:142018-07-31 11:35:14
26260AY20160280안전점검보고서_총평2016-10-11 17:10:332016-10-11 17:10:33
12729AS20111202총평 및 건의사항2014-02-03 14:31:512014-02-03 14:31:51
22710AY20130158안전점검보고서_유지관리방안2013-07-18 14:46:492013-10-02 13:42:26
28988AY20150144안전점검보고서_총평2015-09-11 16:03:472015-11-09 17:53:31
34494AY20170117안전점검보고서_총평2017-10-06 17:05:492017-10-06 17:05:49
19408AS20141158총평 및 건의사항2014-09-04 16:17:252014-09-11 10:19:17
912AS20121087총평 및 건의사항2012-05-31 09:50:392012-05-31 09:50:39
13313AS20110635총평 및 건의사항2014-02-07 10:30:412014-02-07 10:30:41
7670AS20090489유지관리방안2014-02-26 16:45:482014-02-26 16:45:48

Duplicate rows

Most frequently occurring

시설물번호보고서구분최초등록일시최종수정일시# duplicates
1064AY20170080안전점검보고서_총평2017-10-20 18:06:452017-10-20 18:06:455
376AS20121185유지관리방안2012-09-20 10:41:292012-09-20 10:41:294
900AY20160074안전점검보고서_유지관리방안2016-10-07 16:46:082016-10-07 16:46:084
908AY20160095안전점검보고서_유지관리방안2016-08-29 14:57:402016-08-29 14:57:404
982AY20160244안전점검보고서_유지관리방안2016-10-20 16:21:592016-10-20 16:21:594
995AY20160266안전점검보고서_유지관리방안2016-10-19 09:49:532016-10-19 09:49:534
1020AY20160310안전점검보고서_유지관리방안2016-10-10 15:57:142016-10-10 15:57:144
1037AY20170031안전점검보고서_유지관리방안2017-10-08 22:29:072017-10-08 22:29:074
1069AY20170087안전점검보고서_총평2017-10-16 17:04:022017-10-16 17:04:024
1077AY20170099안전점검보고서_유지관리방안2017-10-23 15:50:212017-10-23 15:50:214