Overview

Dataset statistics

Number of variables11
Number of observations753
Missing cells1
Missing cells (%)< 0.1%
Duplicate rows3
Duplicate rows (%)0.4%
Total size in memory64.8 KiB
Average record size in memory88.2 B

Variable types

Categorical6
Text3
DateTime2

Dataset

Description경기도 고양시_공유수면점용허가현황에 대한 데이터로 허가번호, 허가일자, 위치, 점용면적, 점용기간 등의 항목을 제공합니다.
Author경기도 고양시
URLhttps://www.data.go.kr/data/15055134/fileData.do

Alerts

시군 has constant value ""Constant
구 has constant value ""Constant
관리기관명 has constant value ""Constant
관리기관전화번호 has constant value ""Constant
데이터기준일 has constant value ""Constant
Dataset has 3 (0.4%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 07:15:19.486315
Analysis finished2023-12-12 07:15:20.109424
Duration0.62 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시군
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
고양시
753 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row고양시
2nd row고양시
3rd row고양시
4th row고양시
5th row고양시

Common Values

ValueCountFrequency (%)
고양시 753
100.0%

Length

2023-12-12T16:15:20.185615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:15:20.310890image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
고양시 753
100.0%

구
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
덕양구
753 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row덕양구
2nd row덕양구
3rd row덕양구
4th row덕양구
5th row덕양구

Common Values

ValueCountFrequency (%)
덕양구 753
100.0%

Length

2023-12-12T16:15:20.448928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:15:20.882125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
덕양구 753
100.0%

허가번호
Text

Distinct750
Distinct (%)99.6%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
2023-12-12T16:15:21.144936image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length9
Mean length9
Min length9

Characters and Unicode

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

Unique

Unique747 ?
Unique (%)99.2%

Sample

1st row23-변경-046
2nd row23-변경-047
3rd row23-변경-048
4th row23-변경-049
5th row23-변경-050
ValueCountFrequency (%)
18-변경-067 2
 
0.3%
18-변경-066 2
 
0.3%
18-변경-065 2
 
0.3%
19-변경-104 1
 
0.1%
22-변경-110 1
 
0.1%
22-변경-132 1
 
0.1%
22-변경-102 1
 
0.1%
22-변경-106 1
 
0.1%
22-변경-130 1
 
0.1%
23-변경-046 1
 
0.1%
Other values (740) 740
98.3%
2023-12-12T16:15:21.570329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 1506
22.2%
2 1050
15.5%
1 786
11.6%
0 673
9.9%
변 536
 
7.9%
경 536
 
7.9%
3 230
 
3.4%
규 216
 
3.2%
신 216
 
3.2%
9 211
 
3.1%
Other values (7) 817
12.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 3765
55.6%
Dash Punctuation 1506
 
22.2%
Other Letter 1506
 
22.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 1050
27.9%
1 786
20.9%
0 673
17.9%
3 230
 
6.1%
9 211
 
5.6%
8 184
 
4.9%
4 175
 
4.6%
5 170
 
4.5%
6 151
 
4.0%
7 135
 
3.6%
Other Letter
ValueCountFrequency (%)
변 536
35.6%
경 536
35.6%
규 216
14.3%
신 216
14.3%
영 1
 
0.1%
구 1
 
0.1%
Dash Punctuation
ValueCountFrequency (%)
- 1506
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 5271
77.8%
Hangul 1506
 
22.2%

Most frequent character per script

Common
ValueCountFrequency (%)
- 1506
28.6%
2 1050
19.9%
1 786
14.9%
0 673
12.8%
3 230
 
4.4%
9 211
 
4.0%
8 184
 
3.5%
4 175
 
3.3%
5 170
 
3.2%
6 151
 
2.9%
Hangul
ValueCountFrequency (%)
변 536
35.6%
경 536
35.6%
규 216
14.3%
신 216
14.3%
영 1
 
0.1%
구 1
 
0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 5271
77.8%
Hangul 1506
 
22.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 1506
28.6%
2 1050
19.9%
1 786
14.9%
0 673
12.8%
3 230
 
4.4%
9 211
 
4.0%
8 184
 
3.5%
4 175
 
3.3%
5 170
 
3.2%
6 151
 
2.9%
Hangul
ValueCountFrequency (%)
변 536
35.6%
경 536
35.6%
규 216
14.3%
신 216
14.3%
영 1
 
0.1%
구 1
 
0.1%

허가일자
Date

Distinct400
Distinct (%)53.1%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
Minimum2004-12-20 00:00:00
Maximum2023-05-12 00:00:00
2023-12-12T16:15:21.754818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:15:21.960081image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

소재지 지번주소
Text

Distinct420
Distinct (%)55.9%
Missing1
Missing (%)0.1%
Memory size6.0 KiB
2023-12-12T16:15:22.275878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length119
Median length42
Mean length11.424202
Min length7

Characters and Unicode

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

Unique

Unique279 ?
Unique (%)37.1%

Sample

1st row원흥동 578-16
2nd row강매동 662-2
3rd row내유동 1024번지
4th row동산동 310-6번지
5th row용두동 893-16번지
ValueCountFrequency (%)
대자동 96
 
5.9%
관산동 88
 
5.4%
내유동 77
 
4.7%
벽제동 65
 
4.0%
성사동 59
 
3.6%
화전동 48
 
2.9%
원당동 42
 
2.6%
동산동 41
 
2.5%
용두동 37
 
2.3%
원흥동 25
 
1.5%
Other values (481) 1050
64.5%
2023-12-12T16:15:22.750907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
883
 
10.3%
동 814
 
9.5%
지 651
 
7.6%
번 619
 
7.2%
1 615
 
7.2%
- 490
 
5.7%
2 381
 
4.4%
9 373
 
4.3%
8 328
 
3.8%
6 311
 
3.6%
Other values (94) 3126
36.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3705
43.1%
Decimal Number 3400
39.6%
Space Separator 883
 
10.3%
Dash Punctuation 490
 
5.7%
Other Punctuation 95
 
1.1%
Close Punctuation 9
 
0.1%
Open Punctuation 9
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 814
22.0%
지 651
17.6%
번 619
16.7%
산 132
 
3.6%
자 103
 
2.8%
대 100
 
2.7%
내 95
 
2.6%
유 90
 
2.4%
관 88
 
2.4%
원 84
 
2.3%
Other values (77) 929
25.1%
Decimal Number
ValueCountFrequency (%)
1 615
18.1%
2 381
11.2%
9 373
11.0%
8 328
9.6%
6 311
9.1%
3 299
8.8%
7 295
8.7%
4 273
8.0%
5 265
7.8%
0 260
7.6%
Other Punctuation
ValueCountFrequency (%)
, 93
97.9%
: 1
 
1.1%
. 1
 
1.1%
Space Separator
ValueCountFrequency (%)
883
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 490
100.0%
Close Punctuation
ValueCountFrequency (%)
) 9
100.0%
Open Punctuation
ValueCountFrequency (%)
( 9
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 4886
56.9%
Hangul 3705
43.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 814
22.0%
지 651
17.6%
번 619
16.7%
산 132
 
3.6%
자 103
 
2.8%
대 100
 
2.7%
내 95
 
2.6%
유 90
 
2.4%
관 88
 
2.4%
원 84
 
2.3%
Other values (77) 929
25.1%
Common
ValueCountFrequency (%)
883
18.1%
1 615
12.6%
- 490
10.0%
2 381
7.8%
9 373
7.6%
8 328
 
6.7%
6 311
 
6.4%
3 299
 
6.1%
7 295
 
6.0%
4 273
 
5.6%
Other values (7) 638
13.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 4886
56.9%
Hangul 3705
43.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
883
18.1%
1 615
12.6%
- 490
10.0%
2 381
7.8%
9 373
7.6%
8 328
 
6.7%
6 311
 
6.4%
3 299
 
6.1%
7 295
 
6.0%
4 273
 
5.6%
Other values (7) 638
13.1%
Hangul
ValueCountFrequency (%)
동 814
22.0%
지 651
17.6%
번 619
16.7%
산 132
 
3.6%
자 103
 
2.8%
대 100
 
2.7%
내 95
 
2.6%
유 90
 
2.4%
관 88
 
2.4%
원 84
 
2.3%
Other values (77) 929
25.1%

점용면적(제곱미터)
Text

Distinct392
Distinct (%)52.1%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
2023-12-12T16:15:23.178863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length15
Mean length2.9920319
Min length1

Characters and Unicode

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

Unique

Unique270 ?
Unique (%)35.9%

Sample

1st row12
2nd row3074
3rd row2.5
4th row0.252
5th row0.126
ValueCountFrequency (%)
1 31
 
4.1%
0.126 14
 
1.8%
0.189 14
 
1.8%
0.252 13
 
1.7%
2 12
 
1.6%
3 12
 
1.6%
0.315 11
 
1.4%
13 10
 
1.3%
11 10
 
1.3%
9 9
 
1.2%
Other values (387) 624
82.1%
2023-12-12T16:15:23.828572image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 336
14.9%
0 268
11.9%
2 266
11.8%
. 243
10.8%
3 205
9.1%
5 193
8.6%
6 170
7.5%
4 169
7.5%
9 125
 
5.5%
7 122
 
5.4%
Other values (17) 156
6.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1971
87.5%
Other Punctuation 251
 
11.1%
Other Letter 18
 
0.8%
Space Separator 7
 
0.3%
Close Punctuation 3
 
0.1%
Open Punctuation 3
 
0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 336
17.0%
0 268
13.6%
2 266
13.5%
3 205
10.4%
5 193
9.8%
6 170
8.6%
4 169
8.6%
9 125
 
6.3%
7 122
 
6.2%
8 117
 
5.9%
Other Letter
ValueCountFrequency (%)
작 3
16.7%
경 3
16.7%
일 2
11.1%
시 2
11.1%
진 2
11.1%
입 2
11.1%
출 1
 
5.6%
영 1
 
5.6%
구 1
 
5.6%
로 1
 
5.6%
Other Punctuation
ValueCountFrequency (%)
. 243
96.8%
, 5
 
2.0%
: 2
 
0.8%
/ 1
 
0.4%
Space Separator
ValueCountFrequency (%)
7
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2235
99.2%
Hangul 18
 
0.8%

Most frequent character per script

Common
ValueCountFrequency (%)
1 336
15.0%
0 268
12.0%
2 266
11.9%
. 243
10.9%
3 205
9.2%
5 193
8.6%
6 170
7.6%
4 169
7.6%
9 125
 
5.6%
7 122
 
5.5%
Other values (7) 138
6.2%
Hangul
ValueCountFrequency (%)
작 3
16.7%
경 3
16.7%
일 2
11.1%
시 2
11.1%
진 2
11.1%
입 2
11.1%
출 1
 
5.6%
영 1
 
5.6%
구 1
 
5.6%
로 1
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2235
99.2%
Hangul 18
 
0.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 336
15.0%
0 268
12.0%
2 266
11.9%
. 243
10.9%
3 205
9.2%
5 193
8.6%
6 170
7.6%
4 169
7.6%
9 125
 
5.6%
7 122
 
5.5%
Other values (7) 138
6.2%
Hangul
ValueCountFrequency (%)
작 3
16.7%
경 3
16.7%
일 2
11.1%
시 2
11.1%
진 2
11.1%
입 2
11.1%
출 1
 
5.6%
영 1
 
5.6%
구 1
 
5.6%
로 1
 
5.6%

점용 시작일자
Date

Distinct373
Distinct (%)49.5%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
Minimum2004-01-01 00:00:00
Maximum2026-05-31 00:00:00
2023-12-12T16:15:23.981748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:15:24.147295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

점용 종료일자
Categorical

Distinct13
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
2027-05-31
197 
2026-05-31
178 
2025-05-31
169 
2024-05-31
120 
2023-05-31
56 
Other values (8)
33 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique5 ?
Unique (%)0.7%

Sample

1st row2028-05-31
2nd row2028-05-31
3rd row2028-05-31
4th row2028-05-31
5th row2028-05-31

Common Values

ValueCountFrequency (%)
2027-05-31 197
26.2%
2026-05-31 178
23.6%
2025-05-31 169
22.4%
2024-05-31 120
15.9%
2023-05-31 56
 
7.4%
2028-05-31 22
 
2.9%
2029-05-31 4
 
0.5%
2032-05-31 2
 
0.3%
2023-12-31 1
 
0.1%
2023-06-11 1
 
0.1%
Other values (3) 3
 
0.4%

Length

2023-12-12T16:15:24.292306image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2027-05-31 197
26.2%
2026-05-31 178
23.6%
2025-05-31 169
22.4%
2024-05-31 120
15.9%
2023-05-31 56
 
7.4%
2028-05-31 22
 
2.9%
2029-05-31 4
 
0.5%
2032-05-31 2
 
0.3%
2023-12-31 1
 
0.1%
2023-06-11 1
 
0.1%
Other values (3) 3
 
0.4%

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
덕양구 환경녹지과
753 

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 (%)
덕양구 환경녹지과 753
100.0%

Length

2023-12-12T16:15:24.415701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:15:24.537937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
덕양구 753
50.0%
환경녹지과 753
50.0%

관리기관전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
031-8075-5234
753 

Length

Max length13
Median length13
Mean length13
Min length13

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row031-8075-5234
2nd row031-8075-5234
3rd row031-8075-5234
4th row031-8075-5234
5th row031-8075-5234

Common Values

ValueCountFrequency (%)
031-8075-5234 753
100.0%

Length

2023-12-12T16:15:24.659601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:15:24.765607image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
031-8075-5234 753
100.0%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.0 KiB
2023-05-15
753 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-05-15
2nd row2023-05-15
3rd row2023-05-15
4th row2023-05-15
5th row2023-05-15

Common Values

ValueCountFrequency (%)
2023-05-15 753
100.0%

Length

2023-12-12T16:15:24.886001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:15:25.016522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-05-15 753
100.0%

Missing values

2023-12-12T16:15:19.828802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:15:20.043726image/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

시군구허가번호허가일자소재지 지번주소점용면적(제곱미터)점용 시작일자점용 종료일자관리기관명관리기관전화번호데이터기준일
0고양시덕양구23-변경-0462018-11-01원흥동 578-16122018-11-012028-05-31덕양구 환경녹지과031-8075-52342023-05-15
1고양시덕양구23-변경-0472018-06-01강매동 662-230742018-06-012028-05-31덕양구 환경녹지과031-8075-52342023-05-15
2고양시덕양구23-변경-0482018-04-25내유동 1024번지2.52018-04-252028-05-31덕양구 환경녹지과031-8075-52342023-05-15
3고양시덕양구23-변경-0492018-03-29동산동 310-6번지0.2522018-03-292028-05-31덕양구 환경녹지과031-8075-52342023-05-15
4고양시덕양구23-변경-0502018-03-19용두동 893-16번지0.1262018-03-192028-05-31덕양구 환경녹지과031-8075-52342023-05-15
5고양시덕양구23-변경-0512018-05-04내곡동 504-4번지6.022018-05-042028-05-31덕양구 환경녹지과031-8075-52342023-05-15
6고양시덕양구23-변경-0522018-07-23원흥동 578-2번지0.2522018-07-232028-05-31덕양구 환경녹지과031-8075-52342023-05-15
7고양시덕양구23-변경-0532018-07-30내곡동 504-4번지0.6232018-07-302028-05-31덕양구 환경녹지과031-8075-52342023-05-15
8고양시덕양구23-변경-0542018-11-01행주내동 713-8번지0.1262018-11-012028-05-31덕양구 환경녹지과031-8075-52342023-05-15
9고양시덕양구23-변경-0552018-11-01행주내동 713-8번지0.1262018-11-012028-05-31덕양구 환경녹지과031-8075-52342023-05-15
시군구허가번호허가일자소재지 지번주소점용면적(제곱미터)점용 시작일자점용 종료일자관리기관명관리기관전화번호데이터기준일
743고양시덕양구18-변경-0552015-06-12현천동 780-8, 강매동660-32진입로363, 경작18852015-06-122023-05-31덕양구 환경녹지과031-8075-52342023-05-15
744고양시덕양구18-신규-0562018-07-19성사동 668번지0.72018-07-182023-05-31덕양구 환경녹지과031-8075-52342023-05-15
745고양시덕양구18-변경-1022018-05-21대자동 1243번지16.72018-05-172023-05-31덕양구 환경녹지과031-8075-52342023-05-15
746고양시덕양구18-신규-1192018-11-29현천동 788번지402018-11-292023-05-31덕양구 환경녹지과031-8075-52342023-05-15
747고양시덕양구18-신규-1202018-11-29현천동 788번지442018-11-292023-05-31덕양구 환경녹지과031-8075-52342023-05-15
748고양시덕양구19-변경-0032019-01-10화전동 843번지632018-06-012023-05-31덕양구 환경녹지과031-8075-52342023-05-15
749고양시덕양구19-변경-0102018-10-01대자동 1214-7번지32018-10-012023-05-31덕양구 환경녹지과031-8075-52342023-05-15
750고양시덕양구19-변경-1042018-06-01대장동 542번지2592018-06-012023-05-31덕양구 환경녹지과031-8075-52342023-05-15
751고양시덕양구21-변경-2452014-01-24원흥동 578-1번지1752013-06-012023-05-31덕양구 환경녹지과031-8075-52342023-05-15
752고양시덕양구22-변경-0672009-11-03관산동 910-421092009-11-032023-05-31덕양구 환경녹지과031-8075-52342023-05-15

Duplicate rows

Most frequently occurring

시군구허가번호허가일자소재지 지번주소점용면적(제곱미터)점용 시작일자점용 종료일자관리기관명관리기관전화번호데이터기준일# duplicates
0고양시덕양구18-변경-0652013-01-01화전동 843번지232013-01-012023-05-31덕양구 환경녹지과031-8075-52342023-05-152
1고양시덕양구18-변경-0662013-06-01현천동 788번지172013-06-012023-05-31덕양구 환경녹지과031-8075-52342023-05-152
2고양시덕양구18-변경-0672013-06-01현천동 788번지92013-06-012023-05-31덕양구 환경녹지과031-8075-52342023-05-152