Overview

Dataset statistics

Number of variables8
Number of observations6344
Missing cells0
Missing cells (%)0.0%
Duplicate rows190
Duplicate rows (%)3.0%
Total size in memory396.6 KiB
Average record size in memory64.0 B

Variable types

DateTime1
Categorical6
Text1

Dataset

Description양평군 내의 개발행위허가사항을 데이터화하여 제공합니다. 업무체계 는 지역개발 과 지역및 도시입니다. 개발행위허가사항2022-07-25
Author경기도 양평군
URLhttps://www.data.go.kr/data/15102520/fileData.do

Alerts

처리부서명 has constant value ""Constant
민원유형 has constant value ""Constant
최종결과 has constant value ""Constant
Dataset has 190 (3.0%) duplicate rowsDuplicates
민원구분 is highly overall correlated with 민원명High correlation
민원명 is highly overall correlated with 민원구분High correlation
민원구분 is highly imbalanced (55.4%)Imbalance
민원인구분 is highly imbalanced (97.1%)Imbalance
민원명 is highly imbalanced (55.4%)Imbalance

Reproduction

Analysis started2023-12-12 18:59:29.870844
Analysis finished2023-12-12 18:59:31.006830
Duration1.14 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

처리일자
Date

Distinct529
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size49.7 KiB
Minimum2020-01-13 00:00:00
Maximum2021-11-30 00:00:00
2023-12-13T03:59:31.131372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:59:31.370054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

처리부서명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size49.7 KiB
도시건설국 허가과
6344 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row도시건설국 허가과
2nd row도시건설국 허가과
3rd row도시건설국 허가과
4th row도시건설국 허가과
5th row도시건설국 허가과

Common Values

ValueCountFrequency (%)
도시건설국 허가과 6344
100.0%

Length

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

Common Values (Plot)

2023-12-13T03:59:31.765390image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
도시건설국 6344
50.0%
허가과 6344
50.0%

민원구분
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size49.7 KiB
복합민원
5755 
단순민원
589 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row단순민원
2nd row복합민원
3rd row복합민원
4th row복합민원
5th row복합민원

Common Values

ValueCountFrequency (%)
복합민원 5755
90.7%
단순민원 589
 
9.3%

Length

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

Common Values (Plot)

2023-12-13T03:59:32.097748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
복합민원 5755
90.7%
단순민원 589
 
9.3%

민원유형
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size49.7 KiB
허가
6344 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row허가
2nd row허가
3rd row허가
4th row허가
5th row허가

Common Values

ValueCountFrequency (%)
허가 6344
100.0%

Length

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

Common Values (Plot)

2023-12-13T03:59:32.478419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
허가 6344
100.0%

민원인구분
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size49.7 KiB
개인
6325 
사업자
 
19

Length

Max length3
Median length2
Mean length2.002995
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row개인
2nd row개인
3rd row개인
4th row개인
5th row개인

Common Values

ValueCountFrequency (%)
개인 6325
99.7%
사업자 19
 
0.3%

Length

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

Common Values (Plot)

2023-12-13T03:59:32.843167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
개인 6325
99.7%
사업자 19
 
0.3%

민원명
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size49.7 KiB
개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)
5755 
개발행위준공검사신청서
589 

Length

Max length39
Median length39
Mean length36.400378
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row개발행위준공검사신청서
2nd row개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)
3rd row개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)
4th row개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)
5th row개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)

Common Values

ValueCountFrequency (%)
개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치) 5755
90.7%
개발행위준공검사신청서 589
 
9.3%

Length

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

Common Values (Plot)

2023-12-13T03:59:33.322218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
개발행위허가(토지형질변경· 5755
19.6%
토석채취· 5755
19.6%
공작물설치· 5755
19.6%
토지분할· 5755
19.6%
물건적치 5755
19.6%
개발행위준공검사신청서 589
 
2.0%

민원요지
Text

Distinct5403
Distinct (%)85.2%
Missing0
Missing (%)0.0%
Memory size49.7 KiB
2023-12-13T03:59:33.845373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length58
Median length40
Mean length12.544767
Min length1

Characters and Unicode

Total characters79584
Distinct characters205
Distinct categories11 ?
Distinct scripts3 ?
Distinct blocks5 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique4933 ?
Unique (%)77.8%

Sample

1st row강하 전수리529-4외
2nd row옥천 용천리 148-11
3rd row옥천면 용천리 191-33번지외 2필지
4th row용천리 298-1번지외 4필지
5th row옥천면 용천리 191-33번지외 4필지
ValueCountFrequency (%)
용문면 610
 
3.8%
서종면 597
 
3.7%
양평읍 463
 
2.9%
지평면 426
 
2.6%
강하면 423
 
2.6%
양서면 393
 
2.4%
옥천면 374
 
2.3%
강상면 300
 
1.9%
외 251
 
1.6%
단월면 239
 
1.5%
Other values (5274) 12093
74.8%
2023-12-13T03:59:34.706858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
10594
 
13.3%
리 5898
 
7.4%
1 5685
 
7.1%
- 4599
 
5.8%
면 3952
 
5.0%
2 3540
 
4.4%
3 2744
 
3.4%
4 2510
 
3.2%
5 2308
 
2.9%
6 2152
 
2.7%
Other values (195) 35602
44.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 38618
48.5%
Decimal Number 25156
31.6%
Space Separator 10594
 
13.3%
Dash Punctuation 4599
 
5.8%
Open Punctuation 214
 
0.3%
Close Punctuation 214
 
0.3%
Math Symbol 114
 
0.1%
Other Punctuation 40
 
0.1%
Lowercase Letter 28
 
< 0.1%
Uppercase Letter 5
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
리 5898
 
15.3%
면 3952
 
10.2%
외 1972
 
5.1%
지 1944
 
5.0%
산 1329
 
3.4%
양 1187
 
3.1%
서 1138
 
2.9%
평 1101
 
2.9%
문 1010
 
2.6%
용 958
 
2.5%
Other values (171) 18129
46.9%
Decimal Number
ValueCountFrequency (%)
1 5685
22.6%
2 3540
14.1%
3 2744
10.9%
4 2510
10.0%
5 2308
9.2%
6 2152
 
8.6%
7 1684
 
6.7%
8 1627
 
6.5%
9 1478
 
5.9%
0 1428
 
5.7%
Uppercase Letter
ValueCountFrequency (%)
B 2
40.0%
A 1
20.0%
C 1
20.0%
D 1
20.0%
Other Punctuation
ValueCountFrequency (%)
· 38
95.0%
/ 1
 
2.5%
. 1
 
2.5%
Space Separator
ValueCountFrequency (%)
10594
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4599
100.0%
Open Punctuation
ValueCountFrequency (%)
( 214
100.0%
Close Punctuation
ValueCountFrequency (%)
) 214
100.0%
Math Symbol
ValueCountFrequency (%)
+ 114
100.0%
Lowercase Letter
ValueCountFrequency (%)
m 28
100.0%
Other Symbol
ValueCountFrequency (%)
㎡ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 40933
51.4%
Hangul 38618
48.5%
Latin 33
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
리 5898
 
15.3%
면 3952
 
10.2%
외 1972
 
5.1%
지 1944
 
5.0%
산 1329
 
3.4%
양 1187
 
3.1%
서 1138
 
2.9%
평 1101
 
2.9%
문 1010
 
2.6%
용 958
 
2.5%
Other values (171) 18129
46.9%
Common
ValueCountFrequency (%)
10594
25.9%
1 5685
13.9%
- 4599
11.2%
2 3540
 
8.6%
3 2744
 
6.7%
4 2510
 
6.1%
5 2308
 
5.6%
6 2152
 
5.3%
7 1684
 
4.1%
8 1627
 
4.0%
Other values (9) 3490
 
8.5%
Latin
ValueCountFrequency (%)
m 28
84.8%
B 2
 
6.1%
A 1
 
3.0%
C 1
 
3.0%
D 1
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 40926
51.4%
Hangul 38614
48.5%
None 38
 
< 0.1%
Compat Jamo 4
 
< 0.1%
CJK Compat 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
10594
25.9%
1 5685
13.9%
- 4599
11.2%
2 3540
 
8.6%
3 2744
 
6.7%
4 2510
 
6.1%
5 2308
 
5.6%
6 2152
 
5.3%
7 1684
 
4.1%
8 1627
 
4.0%
Other values (12) 3483
 
8.5%
Hangul
ValueCountFrequency (%)
리 5898
 
15.3%
면 3952
 
10.2%
외 1972
 
5.1%
지 1944
 
5.0%
산 1329
 
3.4%
양 1187
 
3.1%
서 1138
 
2.9%
평 1101
 
2.9%
문 1010
 
2.6%
용 958
 
2.5%
Other values (167) 18125
46.9%
None
ValueCountFrequency (%)
· 38
100.0%
CJK Compat
ValueCountFrequency (%)
㎡ 2
100.0%
Compat Jamo
ValueCountFrequency (%)
ㅇ 1
25.0%
ㅈ 1
25.0%
ㅏ 1
25.0%
ㅣ 1
25.0%

최종결과
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size49.7 KiB
해결
6344 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row해결
2nd row해결
3rd row해결
4th row해결
5th row해결

Common Values

ValueCountFrequency (%)
해결 6344
100.0%

Length

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

Common Values (Plot)

2023-12-13T03:59:35.151455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
해결 6344
100.0%

Correlations

2023-12-13T03:59:35.310930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
민원구분민원인구분민원명
민원구분1.0000.0001.000
민원인구분0.0001.0000.000
민원명1.0000.0001.000
2023-12-13T03:59:35.492749image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
민원인구분민원구분민원명
민원인구분1.0000.0000.000
민원구분0.0001.0000.999
민원명0.0000.9991.000
2023-12-13T03:59:35.681747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
민원구분민원인구분민원명
민원구분1.0000.0000.999
민원인구분0.0001.0000.000
민원명0.9990.0001.000

Missing values

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

처리일자처리부서명민원구분민원유형민원인구분민원명민원요지최종결과
02020-01-13도시건설국 허가과단순민원허가개인개발행위준공검사신청서강하 전수리529-4외해결
12020-01-14도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)옥천 용천리 148-11해결
22020-01-14도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)옥천면 용천리 191-33번지외 2필지해결
32020-01-14도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)용천리 298-1번지외 4필지해결
42020-01-14도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)옥천면 용천리 191-33번지외 4필지해결
52020-01-14도시건설국 허가과단순민원허가개인개발행위준공검사신청서지평면 옥현리 979해결
62020-01-14도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)오빈리416-7외1해결
72020-01-14도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)강상면 송학리133-6해결
82020-01-14도시건설국 허가과단순민원허가개인개발행위준공검사신청서양평읍 백안리175-3외 1해결
92020-01-15도시건설국 허가과단순민원허가개인개발행위준공검사신청서청운 가현 산111-5 외 3해결
처리일자처리부서명민원구분민원유형민원인구분민원명민원요지최종결과
63342021-11-30도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)서종면 수입리19(농지협의)해결
63352021-11-30도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)서종면 수능리 산4-51번지해결
63362021-11-30도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)지평면 송현리 391-20번지 외2필지해결
63372021-11-30도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)용천리514-5번지 외1필지해결
63382021-11-30도시건설국 허가과단순민원허가개인개발행위준공검사신청서강하면 왕창리 20-7번지(복구준공협의)해결
63392021-11-30도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)서종면 서후리 164-1번지해결
63402021-11-30도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)청운면 가현리 520번지 외1필지해결
63412021-11-30도시건설국 허가과단순민원허가개인개발행위준공검사신청서서종면 도장리 255-2해결
63422021-11-30도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)개군면 구미리 99-3 외1필지해결
63432021-11-30도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)양평읍 신애리 263해결

Duplicate rows

Most frequently occurring

처리일자처리부서명민원구분민원유형민원인구분민원명민원요지최종결과# duplicates
912020-12-04도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)해결8
942020-12-17도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)옥천면 신복리 산104외해결7
152020-03-04도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)해결6
412020-06-22도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)해결6
802020-11-10도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)강상면 화양리 산4해결6
452020-07-09도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)해결5
662020-10-06도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)해결5
1052021-01-25도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)해결5
1642021-07-15도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)해결5
1862021-11-23도시건설국 허가과복합민원허가개인개발행위허가(토지형질변경· 토석채취· 공작물설치· 토지분할· 물건적치)용문면 중원리 357-52번지+산지전용변경허가신청해결5