Overview

Dataset statistics

Number of variables6
Number of observations121
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.0 KiB
Average record size in memory51.1 B

Variable types

Text2
Categorical3
DateTime1

Dataset

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

Alerts

열람일련번호 has constant value ""Constant
지자체관리코드(진안군 법정동코드) has constant value ""Constant
열람자 is highly imbalanced (66.1%)Imbalance
공고관리번호 has unique valuesUnique

Reproduction

Analysis started2024-03-14 20:05:12.030292
Analysis finished2024-03-14 20:05:13.472237
Duration1.44 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

공고관리번호
Text

UNIQUE 

Distinct121
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2024-03-15T05:05:14.092333image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length20
Mean length20
Min length20

Characters and Unicode

Total characters2420
Distinct characters12
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

Unique121 ?
Unique (%)100.0%

Sample

1st row52720ANN999999990001
2nd row52720ANN200808180002
3rd row52720ANN999999990003
4th row52720ANN201012300004
5th row52720ANN198610240005
ValueCountFrequency (%)
52720ann999999990001 1
 
0.8%
52720ann200707040063 1
 
0.8%
52720ann201001270091 1
 
0.8%
52720ann201001270090 1
 
0.8%
52720ann201011230089 1
 
0.8%
52720ann201001190088 1
 
0.8%
52720ann201010140087 1
 
0.8%
52720ann201008130086 1
 
0.8%
52720ann201001050085 1
 
0.8%
52720ann201001190084 1
 
0.8%
Other values (111) 111
91.7%
2024-03-15T05:05:15.293323image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 631
26.1%
2 394
16.3%
9 257
10.6%
N 242
 
10.0%
1 220
 
9.1%
5 165
 
6.8%
7 165
 
6.8%
A 121
 
5.0%
8 67
 
2.8%
3 53
 
2.2%
Other values (2) 105
 
4.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2057
85.0%
Uppercase Letter 363
 
15.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 631
30.7%
2 394
19.2%
9 257
12.5%
1 220
 
10.7%
5 165
 
8.0%
7 165
 
8.0%
8 67
 
3.3%
3 53
 
2.6%
6 53
 
2.6%
4 52
 
2.5%
Uppercase Letter
ValueCountFrequency (%)
N 242
66.7%
A 121
33.3%

Most occurring scripts

ValueCountFrequency (%)
Common 2057
85.0%
Latin 363
 
15.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 631
30.7%
2 394
19.2%
9 257
12.5%
1 220
 
10.7%
5 165
 
8.0%
7 165
 
8.0%
8 67
 
3.3%
3 53
 
2.6%
6 53
 
2.6%
4 52
 
2.5%
Latin
ValueCountFrequency (%)
N 242
66.7%
A 121
33.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2420
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 631
26.1%
2 394
16.3%
9 257
10.6%
N 242
 
10.0%
1 220
 
9.1%
5 165
 
6.8%
7 165
 
6.8%
A 121
 
5.0%
8 67
 
2.8%
3 53
 
2.2%
Other values (2) 105
 
4.3%

열람일련번호
Categorical

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
1
121 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row1
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 121
100.0%

Length

2024-03-15T05:05:15.759614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T05:05:16.037702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 121
100.0%

지자체관리코드(진안군 법정동코드)
Categorical

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
52720
121 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row52720
2nd row52720
3rd row52720
4th row52720
5th row52720

Common Values

ValueCountFrequency (%)
52720 121
100.0%

Length

2024-03-15T05:05:16.254362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T05:05:16.418912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
52720 121
100.0%

제목
Text

Distinct108
Distinct (%)89.3%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2024-03-15T05:05:17.156525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length85
Median length49
Mean length36.446281
Min length8

Characters and Unicode

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

Unique

Unique100 ?
Unique (%)82.6%

Sample

1st row용담다목적댐건설기본계획
2nd row도시계획시설사업 실시계획인가 공고
3rd row진안 운상상수원보호구역 해제 공고
4th row진안 군계획시설(공공청사)사업 실시계획인가(변경)전 열람공고
5th row진안 도시계획시설 자동차정류장 변경결정 및 지적고시 승인신청에 따른 공람공고
ValueCountFrequency (%)
공고 63
 
8.2%
진안 45
 
5.8%
및 40
 
5.2%
따른 31
 
4.0%
위한 29
 
3.8%
주민의견청취 27
 
3.5%
열람공고 25
 
3.2%
공람 15
 
1.9%
대한 14
 
1.8%
실시계획 14
 
1.8%
Other values (250) 470
60.8%
2024-03-15T05:05:18.322297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
652
 
14.8%
공 190
 
4.3%
계 178
 
4.0%
획 177
 
4.0%
시 156
 
3.5%
고 128
 
2.9%
) 118
 
2.7%
안 118
 
2.7%
( 118
 
2.7%
설 90
 
2.0%
Other values (192) 2485
56.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3427
77.7%
Space Separator 652
 
14.8%
Close Punctuation 119
 
2.7%
Open Punctuation 119
 
2.7%
Decimal Number 33
 
0.7%
Connector Punctuation 28
 
0.6%
Other Punctuation 21
 
0.5%
Dash Punctuation 11
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
공 190
 
5.5%
계 178
 
5.2%
획 177
 
5.2%
시 156
 
4.6%
고 128
 
3.7%
안 118
 
3.4%
설 90
 
2.6%
군 89
 
2.6%
지 85
 
2.5%
진 85
 
2.5%
Other values (176) 2131
62.2%
Decimal Number
ValueCountFrequency (%)
2 12
36.4%
3 11
33.3%
1 3
 
9.1%
7 2
 
6.1%
4 2
 
6.1%
0 2
 
6.1%
6 1
 
3.0%
Close Punctuation
ValueCountFrequency (%)
) 118
99.2%
] 1
 
0.8%
Open Punctuation
ValueCountFrequency (%)
( 118
99.2%
[ 1
 
0.8%
Other Punctuation
ValueCountFrequency (%)
, 19
90.5%
/ 2
 
9.5%
Space Separator
ValueCountFrequency (%)
652
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 28
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3427
77.7%
Common 983
 
22.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
공 190
 
5.5%
계 178
 
5.2%
획 177
 
5.2%
시 156
 
4.6%
고 128
 
3.7%
안 118
 
3.4%
설 90
 
2.6%
군 89
 
2.6%
지 85
 
2.5%
진 85
 
2.5%
Other values (176) 2131
62.2%
Common
ValueCountFrequency (%)
652
66.3%
) 118
 
12.0%
( 118
 
12.0%
_ 28
 
2.8%
, 19
 
1.9%
2 12
 
1.2%
- 11
 
1.1%
3 11
 
1.1%
1 3
 
0.3%
7 2
 
0.2%
Other values (6) 9
 
0.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3427
77.7%
ASCII 983
 
22.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
652
66.3%
) 118
 
12.0%
( 118
 
12.0%
_ 28
 
2.8%
, 19
 
1.9%
2 12
 
1.2%
- 11
 
1.1%
3 11
 
1.1%
1 3
 
0.3%
7 2
 
0.2%
Other values (6) 9
 
0.9%
Hangul
ValueCountFrequency (%)
공 190
 
5.5%
계 178
 
5.2%
획 177
 
5.2%
시 156
 
4.6%
고 128
 
3.7%
안 118
 
3.4%
설 90
 
2.6%
군 89
 
2.6%
지 85
 
2.5%
진 85
 
2.5%
Other values (176) 2131
62.2%

열람자
Categorical

IMBALANCE 

Distinct8
Distinct (%)6.6%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
진안군수
100 
㈜써미트
11 
전북특별자치도지사
 
5
건설부장관
 
1
부귀면농업협동조합
 
1
Other values (3)
 
3

Length

Max length9
Median length4
Mean length4.3305785
Min length4

Unique

Unique5 ?
Unique (%)4.1%

Sample

1st row건설부장관
2nd row전북특별자치도지사
3rd row전북특별자치도지사
4th row전북특별자치도지사
5th row진안군수

Common Values

ValueCountFrequency (%)
진안군수 100
82.6%
㈜써미트 11
 
9.1%
전북특별자치도지사 5
 
4.1%
건설부장관 1
 
0.8%
부귀면농업협동조합 1
 
0.8%
부귀농업협동조합 1
 
0.8%
㈜SUMMIT 1
 
0.8%
진안군교육청 1
 
0.8%

Length

2024-03-15T05:05:18.619011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T05:05:18.876430image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
진안군수 100
82.6%
㈜써미트 11
 
9.1%
전북특별자치도지사 5
 
4.1%
건설부장관 1
 
0.8%
부귀면농업협동조합 1
 
0.8%
부귀농업협동조합 1
 
0.8%
㈜summit 1
 
0.8%
진안군교육청 1
 
0.8%

생성일시
Date

Distinct2
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
Minimum2015-07-29 00:00:00
Maximum2015-12-15 00:00:00
2024-03-15T05:05:19.074447image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T05:05:19.267043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=2)

Correlations

2024-03-15T05:05:19.401396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
열람자생성일시
열람자1.0000.000
생성일시0.0001.000

Missing values

2024-03-15T05:05:12.476446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T05:05:13.259177image/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

공고관리번호열람일련번호지자체관리코드(진안군 법정동코드)제목열람자생성일시
052720ANN999999990001152720용담다목적댐건설기본계획건설부장관2015-07-29
152720ANN200808180002152720도시계획시설사업 실시계획인가 공고전북특별자치도지사2015-07-29
252720ANN999999990003152720진안 운상상수원보호구역 해제 공고전북특별자치도지사2015-07-29
352720ANN201012300004152720진안 군계획시설(공공청사)사업 실시계획인가(변경)전 열람공고전북특별자치도지사2015-07-29
452720ANN198610240005152720진안 도시계획시설 자동차정류장 변경결정 및 지적고시 승인신청에 따른 공람공고진안군수2015-07-29
552720ANN198612040006152720진안도시계획도로일부 변경결정 및 재정비 지적승인진안군수2015-07-29
652720ANN198709090007152720도시계획 사업 진안 일반 여객자동차정류장 사업시행자허가에 따른 공람 공고진안군수2015-07-29
752720ANN198710310008152720도시계획 진안 일반여객 자동차정류장 시설사업 변경허가 승인 신청에 따른 공람 공고진안군수2015-07-29
852720ANN198808010009152720진안농공예정지구 용도변경예 따른 주민의견청취 공고진안군수2015-07-29
952720ANN198811250010152720진안종합병원 건립을 위한 용도변경에 따른 주민의견청취 공고진안군수2015-07-29
공고관리번호열람일련번호지자체관리코드(진안군 법정동코드)제목열람자생성일시
11152720ANN201405300113152720군관리계획(군계획시설_공공청사, 문화시설) 변경, 결정을 위한 공람 공고진안군수2015-07-29
11252720ANN201410060114152720진안 군관리계획(군계획시설_도로)변경, 결정을 위한 공람 공고진안군수2015-07-29
11352720ANN201408140115152720진안군계획시설(체육시설_골프장)사업 실시계획 인가(변경)전 공람공고진안군수2015-07-29
11452720ANN201410060116152720진안 군관리계획(지구단위계획) 변경 결정(안)에 따른 주민공람공고㈜써미트2015-07-29
11552720ANN201411210117152720진안군계획시설(체육시설_골프장)사업 실시계획 인가(변경)전 공람공고진안군수2015-07-29
11652720ANN201504100118152720진안 군계획시설(공공청사_백운면사무소) 실시계획 인가(변경)전 열람공고㈜써미트2015-07-29
11752720ANN201505080119152720진안군계획시설(도로_소로1-3, 소로1-4호선)사업 실시계획인가 전 열람공고진안군수2015-07-29
11852720ANN999999990120152720진안군계획시설(도로) 실시계획 인가 전 열람 공고㈜써미트2015-12-15
11952720ANN999999990121152720진안 군관리계획(군계획시설_수도공급설비) 결정을 위한 주민 공람 공고진안군수2015-12-15
12052720ANN999999990122152720진안군계획시설(월랑공원)공원조성계획 결정(변경)을 위한 공람 공고진안군수2015-12-15