Overview

Dataset statistics

Number of variables5
Number of observations113
Missing cells0
Missing cells (%)0.0%
Duplicate rows2
Duplicate rows (%)1.8%
Total size in memory4.5 KiB
Average record size in memory41.1 B

Variable types

Text2
DateTime3

Dataset

Description전북특별자치도 진안군 도시계획정보시스템 공고에 대한 데이터로 공고번호, 제목, 공고일자, 열람시작일자, 열람종료일자 정보를 제공합니다.
Author전북특별자치도 진안군
URLhttps://www.data.go.kr/data/15119131/fileData.do

Alerts

Dataset has 2 (1.8%) duplicate rowsDuplicates

Reproduction

Analysis started2024-04-21 14:28:47.358837
Analysis finished2024-04-21 14:28:48.125417
Duration0.77 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct110
Distinct (%)97.3%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2024-04-21T23:28:49.053392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length8
Mean length7.7345133
Min length6

Characters and Unicode

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

Unique

Unique108 ?
Unique (%)95.6%

Sample

1st row2022-1339
2nd row2022-1336
3rd row1989-61
4th row1990-14
5th row1990-16
ValueCountFrequency (%)
1999-15 3
 
2.7%
2008-296 2
 
1.8%
2013-326 1
 
0.9%
2010-447 1
 
0.9%
2022-1339 1
 
0.9%
2015-194 1
 
0.9%
2014-707 1
 
0.9%
2014-528 1
 
0.9%
2014-423 1
 
0.9%
2014-151 1
 
0.9%
Other values (100) 100
88.5%
2024-04-21T23:28:50.324009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 158
18.1%
1 123
14.1%
2 121
13.8%
- 113
12.9%
9 96
11.0%
6 56
 
6.4%
7 48
 
5.5%
4 43
 
4.9%
8 42
 
4.8%
3 40
 
4.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 761
87.1%
Dash Punctuation 113
 
12.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 158
20.8%
1 123
16.2%
2 121
15.9%
9 96
12.6%
6 56
 
7.4%
7 48
 
6.3%
4 43
 
5.7%
8 42
 
5.5%
3 40
 
5.3%
5 34
 
4.5%
Dash Punctuation
ValueCountFrequency (%)
- 113
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 874
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 158
18.1%
1 123
14.1%
2 121
13.8%
- 113
12.9%
9 96
11.0%
6 56
 
6.4%
7 48
 
5.5%
4 43
 
4.9%
8 42
 
4.8%
3 40
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 874
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 158
18.1%
1 123
14.1%
2 121
13.8%
- 113
12.9%
9 96
11.0%
6 56
 
6.4%
7 48
 
5.5%
4 43
 
4.9%
8 42
 
4.8%
3 40
 
4.6%

제목
Text

Distinct103
Distinct (%)91.2%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2024-04-21T23:28:51.052094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length85
Median length48
Mean length37.566372
Min length12

Characters and Unicode

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

Unique

Unique98 ?
Unique (%)86.7%

Sample

1st row진안 군계획시설(체육공원, 월랑공원)사업 실시계획 인가(변경) 열람공고
2nd row진안 군계획시설(공공청사, 진안경찰서)사업 실시계획 인가(변경) 열람공고
3rd row진안종합병원 건립을 위한 용도변경에 따른 주민의견청취 공고
4th row진안읍 도시계획시설 농산물도매시장(인삼집하장) 세부시설 결정 및 지적고시 신청을 위한 주민의견청취 공고
5th row진안읍 도시계획시설 농산물도매시장(인삼집하장) 세부시설 결정 및 지적고시 신청을 위한 주민의견청취 공고
ValueCountFrequency (%)
공고 63
 
8.4%
진안 51
 
6.8%
38
 
5.1%
위한 28
 
3.8%
따른 28
 
3.8%
열람공고 26
 
3.5%
주민의견청취 25
 
3.4%
공람 17
 
2.3%
실시계획 14
 
1.9%
열람 14
 
1.9%
Other values (245) 442
59.2%
2024-04-21T23:28:52.050294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
633
 
14.9%
190
 
4.5%
174
 
4.1%
172
 
4.1%
152
 
3.6%
118
 
2.8%
) 117
 
2.8%
( 117
 
2.8%
112
 
2.6%
92
 
2.2%
Other values (197) 2368
55.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3272
77.1%
Space Separator 633
 
14.9%
Close Punctuation 118
 
2.8%
Open Punctuation 118
 
2.8%
Other Punctuation 33
 
0.8%
Decimal Number 33
 
0.8%
Connector Punctuation 23
 
0.5%
Dash Punctuation 11
 
0.3%
Uppercase Letter 4
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
190
 
5.8%
174
 
5.3%
172
 
5.3%
152
 
4.6%
118
 
3.6%
112
 
3.4%
92
 
2.8%
90
 
2.8%
84
 
2.6%
81
 
2.5%
Other values (175) 2007
61.3%
Decimal Number
ValueCountFrequency (%)
3 11
33.3%
2 11
33.3%
1 6
18.2%
4 2
 
6.1%
7 1
 
3.0%
6 1
 
3.0%
0 1
 
3.0%
Other Punctuation
ValueCountFrequency (%)
, 21
63.6%
/ 8
 
24.2%
. 3
 
9.1%
: 1
 
3.0%
Uppercase Letter
ValueCountFrequency (%)
G 1
25.0%
S 1
25.0%
J 1
25.0%
A 1
25.0%
Close Punctuation
ValueCountFrequency (%)
) 117
99.2%
] 1
 
0.8%
Open Punctuation
ValueCountFrequency (%)
( 117
99.2%
[ 1
 
0.8%
Space Separator
ValueCountFrequency (%)
633
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 23
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3272
77.1%
Common 969
 
22.8%
Latin 4
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
190
 
5.8%
174
 
5.3%
172
 
5.3%
152
 
4.6%
118
 
3.6%
112
 
3.4%
92
 
2.8%
90
 
2.8%
84
 
2.6%
81
 
2.5%
Other values (175) 2007
61.3%
Common
ValueCountFrequency (%)
633
65.3%
) 117
 
12.1%
( 117
 
12.1%
_ 23
 
2.4%
, 21
 
2.2%
3 11
 
1.1%
- 11
 
1.1%
2 11
 
1.1%
/ 8
 
0.8%
1 6
 
0.6%
Other values (8) 11
 
1.1%
Latin
ValueCountFrequency (%)
G 1
25.0%
S 1
25.0%
J 1
25.0%
A 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3272
77.1%
ASCII 973
 
22.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
633
65.1%
) 117
 
12.0%
( 117
 
12.0%
_ 23
 
2.4%
, 21
 
2.2%
3 11
 
1.1%
- 11
 
1.1%
2 11
 
1.1%
/ 8
 
0.8%
1 6
 
0.6%
Other values (12) 15
 
1.5%
Hangul
ValueCountFrequency (%)
190
 
5.8%
174
 
5.3%
172
 
5.3%
152
 
4.6%
118
 
3.6%
112
 
3.4%
92
 
2.8%
90
 
2.8%
84
 
2.6%
81
 
2.5%
Other values (175) 2007
61.3%
Distinct102
Distinct (%)90.3%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
Minimum1986-05-06 00:00:00
Maximum2022-12-30 00:00:00
2024-04-21T23:28:52.277881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T23:28:52.523434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct103
Distinct (%)91.2%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
Minimum1986-05-06 00:00:00
Maximum2022-12-30 00:00:00
2024-04-21T23:28:52.763647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T23:28:53.007685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct103
Distinct (%)91.2%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
Minimum1986-05-21 00:00:00
Maximum2023-01-12 00:00:00
2024-04-21T23:28:53.247274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T23:28:53.501727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Missing values

2024-04-21T23:28:47.686777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T23:28:48.002582image/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

공고번호제목공고일자열람시작일자열람종료일자
02022-1339진안 군계획시설(체육공원, 월랑공원)사업 실시계획 인가(변경) 열람공고2022-12-302022-12-302023-01-12
12022-1336진안 군계획시설(공공청사, 진안경찰서)사업 실시계획 인가(변경) 열람공고2022-12-302022-12-302023-01-12
21989-61진안종합병원 건립을 위한 용도변경에 따른 주민의견청취 공고1989-01-311989-01-311989-02-19
31990-14진안읍 도시계획시설 농산물도매시장(인삼집하장) 세부시설 결정 및 지적고시 신청을 위한 주민의견청취 공고1990-02-101990-02-101990-02-23
41990-16진안읍 도시계획시설 농산물도매시장(인삼집하장) 세부시설 결정 및 지적고시 신청을 위한 주민의견청취 공고1990-02-151990-02-151990-02-28
51990-48국토이용계획 취락지역 개발계획수립1990-05-091990-05-091990-05-28
61990-55도시계획시설사업 진안농산물도매시장 사업시행허가에 따른 공람공고1990-05-261990-05-261990-06-10
71990-65운일암/반일암 관광지 예정지구 용도변경함에 따른 주민의견청취 공고1990-06-201990-06-201990-07-09
81991-26주천면 주양지구 취락지역 예정지구 일부용도변경 및 개발계획수립내용 주민의견청취 공고1991-03-051991-03-051991-03-24
91992-66진안읍 도시계획 학교(진안중고등학교) 시설 결정 및 지적고시 변경을 위한 주민의견청취 공고1992-04-011992-04-011992-04-15
공고번호제목공고일자열람시작일자열람종료일자
1032007-695진안 제2종지구단위계획구역 및 계획 결정(안) 공람공고2007-12-282007-12-292008-01-12
1042007-698군관리계획(공공청사_산림환경연구소) 결정에 따른 열람 및 사전환경성검토 초안 열람, 주민설명회 개최공고2007-12-312008-01-012008-01-20
1052008-51진안군도시계획시설(체육시설_진안부귀써미트콜프클럽 27홀 대중콜프장)사업 실시계획 열람공고2008-02-012008-02-022008-02-21
1061986-17진안 도시계획시설 자동차정류장 변경결정 및 지적고시 승인신청에 따른 공람공고1986-05-061986-05-061986-05-21
1071986-67진안도시계획도로일부 변경결정 및 재정비 지적승인1986-12-011986-12-011986-12-15
1081986-42도시계획 사업 진안 일반 여객자동차정류장 사업시행자허가에 따른 공람 공고1987-08-011987-08-011987-08-15
1091987-52도시계획 진안 일반여객 자동차정류장 시설사업 변경허가 승인 신청에 따른 공람 공고1987-09-011987-09-011987-09-15
1101987-62진안농공예정지구 용도변경예 따른 주민의견청취 공고1987-11-271987-11-271987-12-17
1111988-18진안 농공예정지구 용도변경에 따른 주민의견청취 공고1988-03-091988-03-091988-03-28
1121988-16진안종합병원 건립을 위한 용도변경에 따른 주민의견청취 공고1988-03-091988-03-091988-03-28

Duplicate rows

Most frequently occurring

공고번호제목공고일자열람시작일자열람종료일자# duplicates
01999-15국토이용계획변경 및 준도시지역(취락지구)개발계획 수립을 위한 주민의견청취 공고1999-02-011999-02-011999-02-203
12008-296진안 군관리계획(군계획시설_도로) 입안에 따른 주민의견청취 공고2008-06-192008-06-192008-07-032