Overview

Dataset statistics

Number of variables6
Number of observations154
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.3 KiB
Average record size in memory48.9 B

Variable types

Text4
Categorical1
DateTime1

Dataset

Description경기도 양주시 도시계획정보시스템(UPIS) 공공문화체육시설 현황으로 현황도형 관리번호, 라벨명, 면적(도형), 길이(도형), 도면번호, 현황도형 생성일 등의 항목을 제공합니다.
URLhttps://www.data.go.kr/data/15115915/fileData.do

Alerts

현황도형 관리번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 11:49:21.025887
Analysis finished2023-12-12 11:49:21.856816
Duration0.83 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

현황도형 관리번호
Text

UNIQUE 

Distinct154
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-12T20:49:22.025216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length24
Mean length24
Min length24

Characters and Unicode

Total characters3696
Distinct characters14
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

Unique154 ?
Unique (%)100.0%

Sample

1st row41630UQ155PS202101120001
2nd row41630UQ155PS201612310004
3rd row41630UQ155PS201612310003
4th row41630UQ155PS201612310002
5th row41630UQ155PS201609260019
ValueCountFrequency (%)
41630uq155ps202101120001 1
 
0.6%
41630uq155ps202303300003 1
 
0.6%
41630uq155ps201609260014 1
 
0.6%
41630uq155ps201609260006 1
 
0.6%
41630uq155ps201609260010 1
 
0.6%
41630uq155ps201706280015 1
 
0.6%
41630uq155ps201706280013 1
 
0.6%
41630uq155ps201706280008 1
 
0.6%
41630uq155ps201706280003 1
 
0.6%
41630uq155ps202303300002 1
 
0.6%
Other values (144) 144
93.5%
2023-12-12T20:49:22.485351image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 800
21.6%
1 585
15.8%
6 400
10.8%
5 336
9.1%
2 328
8.9%
3 205
 
5.5%
4 193
 
5.2%
U 154
 
4.2%
Q 154
 
4.2%
P 154
 
4.2%
Other values (4) 387
10.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 3080
83.3%
Uppercase Letter 616
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 800
26.0%
1 585
19.0%
6 400
13.0%
5 336
10.9%
2 328
10.6%
3 205
 
6.7%
4 193
 
6.3%
9 138
 
4.5%
7 48
 
1.6%
8 47
 
1.5%
Uppercase Letter
ValueCountFrequency (%)
U 154
25.0%
Q 154
25.0%
P 154
25.0%
S 154
25.0%

Most occurring scripts

ValueCountFrequency (%)
Common 3080
83.3%
Latin 616
 
16.7%

Most frequent character per script

Common
ValueCountFrequency (%)
0 800
26.0%
1 585
19.0%
6 400
13.0%
5 336
10.9%
2 328
10.6%
3 205
 
6.7%
4 193
 
6.3%
9 138
 
4.5%
7 48
 
1.6%
8 47
 
1.5%
Latin
ValueCountFrequency (%)
U 154
25.0%
Q 154
25.0%
P 154
25.0%
S 154
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3696
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 800
21.6%
1 585
15.8%
6 400
10.8%
5 336
9.1%
2 328
8.9%
3 205
 
5.5%
4 193
 
5.2%
U 154
 
4.2%
Q 154
 
4.2%
P 154
 
4.2%
Other values (4) 387
10.5%

라벨명
Categorical

Distinct32
Distinct (%)20.8%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
초등학교
58 
기타공공청사시설
17 
중학교
16 
고등학교
10 
기타체육시설
6 
Other values (27)
47 

Length

Max length15
Median length9
Mean length5.012987
Min length3

Unique

Unique19 ?
Unique (%)12.3%

Sample

1st row체육시설
2nd row초등학교
3rd row초등학교
4th row초등학교
5th row초등학교

Common Values

ValueCountFrequency (%)
초등학교 58
37.7%
기타공공청사시설 17
 
11.0%
중학교 16
 
10.4%
고등학교 10
 
6.5%
기타체육시설 6
 
3.9%
기타사회복지시설 5
 
3.2%
기타학교시설 4
 
2.6%
기타 공공청사시설 4
 
2.6%
유치원 4
 
2.6%
공공청사 3
 
1.9%
Other values (22) 27
17.5%

Length

2023-12-12T20:49:22.699647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
초등학교 58
35.4%
기타공공청사시설 17
 
10.4%
중학교 16
 
9.8%
고등학교 10
 
6.1%
기타 10
 
6.1%
기타체육시설 6
 
3.7%
기타사회복지시설 5
 
3.0%
기타학교시설 4
 
2.4%
공공청사시설 4
 
2.4%
유치원 4
 
2.4%
Other values (21) 30
18.3%

면적(도형)
Text

Distinct146
Distinct (%)94.8%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-12T20:49:23.053044image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length11
Mean length10.5
Min length4

Characters and Unicode

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

Unique

Unique145 ?
Unique (%)94.2%

Sample

1st row45885.47919
2nd row15315.68485
3rd row13264.45693
4th row10915.9263
5th row19642.24347
ValueCountFrequency (%)
데이터 9
 
5.5%
미집계 9
 
5.5%
13884.62815 1
 
0.6%
11178.66925 1
 
0.6%
3514.711424 1
 
0.6%
10975.39895 1
 
0.6%
18364.76223 1
 
0.6%
15047.74596 1
 
0.6%
11356.13945 1
 
0.6%
11731.8179 1
 
0.6%
Other values (137) 137
84.0%
2023-12-12T20:49:23.569089image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 237
14.7%
9 156
9.6%
5 146
9.0%
. 144
8.9%
2 140
8.7%
0 134
8.3%
3 128
7.9%
4 122
7.5%
6 121
7.5%
8 120
7.4%
Other values (8) 169
10.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1410
87.2%
Other Punctuation 144
 
8.9%
Other Letter 54
 
3.3%
Space Separator 9
 
0.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 237
16.8%
9 156
11.1%
5 146
10.4%
2 140
9.9%
0 134
9.5%
3 128
9.1%
4 122
8.7%
6 121
8.6%
8 120
8.5%
7 106
7.5%
Other Letter
ValueCountFrequency (%)
이 9
16.7%
계 9
16.7%
집 9
16.7%
미 9
16.7%
터 9
16.7%
데 9
16.7%
Other Punctuation
ValueCountFrequency (%)
. 144
100.0%
Space Separator
ValueCountFrequency (%)
9
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1563
96.7%
Hangul 54
 
3.3%

Most frequent character per script

Common
ValueCountFrequency (%)
1 237
15.2%
9 156
10.0%
5 146
9.3%
. 144
9.2%
2 140
9.0%
0 134
8.6%
3 128
8.2%
4 122
7.8%
6 121
7.7%
8 120
7.7%
Other values (2) 115
7.4%
Hangul
ValueCountFrequency (%)
이 9
16.7%
계 9
16.7%
집 9
16.7%
미 9
16.7%
터 9
16.7%
데 9
16.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1563
96.7%
Hangul 54
 
3.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 237
15.2%
9 156
10.0%
5 146
9.3%
. 144
9.2%
2 140
9.0%
0 134
8.6%
3 128
8.2%
4 122
7.8%
6 121
7.7%
8 120
7.7%
Other values (2) 115
7.4%
Hangul
ValueCountFrequency (%)
이 9
16.7%
계 9
16.7%
집 9
16.7%
미 9
16.7%
터 9
16.7%
데 9
16.7%

길이(도형)
Text

Distinct146
Distinct (%)94.8%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-12T20:49:23.923026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length11
Mean length10.616883
Min length5

Characters and Unicode

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

Unique

Unique145 ?
Unique (%)94.2%

Sample

1st row113713.465
2nd row48321.91691
3rd row45015.03099
4th row41592.5809
5th row59456.28968
ValueCountFrequency (%)
데이터 9
 
5.5%
미집계 9
 
5.5%
46836.1528 1
 
0.6%
42577.60038 1
 
0.6%
24231.37598 1
 
0.6%
41673.63544 1
 
0.6%
54943.67316 1
 
0.6%
56401.1184 1
 
0.6%
43214.191 1
 
0.6%
43441.92713 1
 
0.6%
Other values (137) 137
84.0%
2023-12-12T20:49:24.696894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4 195
11.9%
1 166
10.2%
5 162
9.9%
3 162
9.9%
. 144
8.8%
8 142
8.7%
2 130
8.0%
9 126
7.7%
6 121
7.4%
7 120
7.3%
Other values (8) 167
10.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1428
87.3%
Other Punctuation 144
 
8.8%
Other Letter 54
 
3.3%
Space Separator 9
 
0.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 195
13.7%
1 166
11.6%
5 162
11.3%
3 162
11.3%
8 142
9.9%
2 130
9.1%
9 126
8.8%
6 121
8.5%
7 120
8.4%
0 104
7.3%
Other Letter
ValueCountFrequency (%)
이 9
16.7%
계 9
16.7%
집 9
16.7%
미 9
16.7%
터 9
16.7%
데 9
16.7%
Other Punctuation
ValueCountFrequency (%)
. 144
100.0%
Space Separator
ValueCountFrequency (%)
9
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1581
96.7%
Hangul 54
 
3.3%

Most frequent character per script

Common
ValueCountFrequency (%)
4 195
12.3%
1 166
10.5%
5 162
10.2%
3 162
10.2%
. 144
9.1%
8 142
9.0%
2 130
8.2%
9 126
8.0%
6 121
7.7%
7 120
7.6%
Other values (2) 113
7.1%
Hangul
ValueCountFrequency (%)
이 9
16.7%
계 9
16.7%
집 9
16.7%
미 9
16.7%
터 9
16.7%
데 9
16.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1581
96.7%
Hangul 54
 
3.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4 195
12.3%
1 166
10.5%
5 162
10.2%
3 162
10.2%
. 144
9.1%
8 142
9.0%
2 130
8.2%
9 126
8.0%
6 121
7.7%
7 120
7.6%
Other values (2) 113
7.1%
Hangul
ValueCountFrequency (%)
이 9
16.7%
계 9
16.7%
집 9
16.7%
미 9
16.7%
터 9
16.7%
데 9
16.7%

도면번호
Text

Distinct82
Distinct (%)53.2%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-12T20:49:25.034001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length6
Mean length2.3181818
Min length1

Characters and Unicode

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

Unique

Unique58 ?
Unique (%)37.7%

Sample

1st row10
2nd row데이터 미집계
3rd row(삼숭)1
4th row데이터 미집계
5th row31
ValueCountFrequency (%)
1 16
 
10.0%
a 7
 
4.4%
데이터 6
 
3.8%
미집계 6
 
3.8%
2 6
 
3.8%
4 6
 
3.8%
10 5
 
3.1%
3 4
 
2.5%
옥1 4
 
2.5%
5 4
 
2.5%
Other values (73) 96
60.0%
2023-12-12T20:49:25.517756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 63
17.6%
옥 32
 
9.0%
2 31
 
8.7%
3 21
 
5.9%
4 16
 
4.5%
) 15
 
4.2%
( 15
 
4.2%
8 11
 
3.1%
지 10
 
2.8%
0 10
 
2.8%
Other values (29) 133
37.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 191
53.5%
Other Letter 123
34.5%
Close Punctuation 15
 
4.2%
Open Punctuation 15
 
4.2%
Lowercase Letter 7
 
2.0%
Space Separator 6
 
1.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
옥 32
26.0%
지 10
 
8.1%
복 10
 
8.1%
고 8
 
6.5%
교 6
 
4.9%
학 6
 
4.9%
계 6
 
4.9%
데 6
 
4.9%
집 6
 
4.9%
이 6
 
4.9%
Other values (15) 27
22.0%
Decimal Number
ValueCountFrequency (%)
1 63
33.0%
2 31
16.2%
3 21
 
11.0%
4 16
 
8.4%
8 11
 
5.8%
0 10
 
5.2%
7 10
 
5.2%
5 10
 
5.2%
9 10
 
5.2%
6 9
 
4.7%
Close Punctuation
ValueCountFrequency (%)
) 15
100.0%
Open Punctuation
ValueCountFrequency (%)
( 15
100.0%
Lowercase Letter
ValueCountFrequency (%)
a 7
100.0%
Space Separator
ValueCountFrequency (%)
6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 227
63.6%
Hangul 123
34.5%
Latin 7
 
2.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
옥 32
26.0%
지 10
 
8.1%
복 10
 
8.1%
고 8
 
6.5%
교 6
 
4.9%
학 6
 
4.9%
계 6
 
4.9%
데 6
 
4.9%
집 6
 
4.9%
이 6
 
4.9%
Other values (15) 27
22.0%
Common
ValueCountFrequency (%)
1 63
27.8%
2 31
13.7%
3 21
 
9.3%
4 16
 
7.0%
) 15
 
6.6%
( 15
 
6.6%
8 11
 
4.8%
0 10
 
4.4%
7 10
 
4.4%
5 10
 
4.4%
Other values (3) 25
 
11.0%
Latin
ValueCountFrequency (%)
a 7
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 234
65.5%
Hangul 123
34.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 63
26.9%
2 31
13.2%
3 21
 
9.0%
4 16
 
6.8%
) 15
 
6.4%
( 15
 
6.4%
8 11
 
4.7%
0 10
 
4.3%
7 10
 
4.3%
5 10
 
4.3%
Other values (4) 32
13.7%
Hangul
ValueCountFrequency (%)
옥 32
26.0%
지 10
 
8.1%
복 10
 
8.1%
고 8
 
6.5%
교 6
 
4.9%
학 6
 
4.9%
계 6
 
4.9%
데 6
 
4.9%
집 6
 
4.9%
이 6
 
4.9%
Other values (15) 27
22.0%

현황도형 생성일
Date

Distinct28
Distinct (%)18.2%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
Minimum2015-10-01 00:00:00
Maximum2023-05-03 00:00:00
2023-12-12T20:49:25.699201image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:49:25.895154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)

Correlations

2023-12-12T20:49:26.037112image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
라벨명도면번호현황도형 생성일
라벨명1.0000.0000.947
도면번호0.0001.0000.000
현황도형 생성일0.9470.0001.000

Missing values

2023-12-12T20:49:21.671263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T20:49:21.802449image/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

현황도형 관리번호라벨명면적(도형)길이(도형)도면번호현황도형 생성일
041630UQ155PS202101120001체육시설45885.47919113713.465102021-01-12
141630UQ155PS201612310004초등학교15315.6848548321.91691데이터 미집계2016-12-31
241630UQ155PS201612310003초등학교13264.4569345015.03099(삼숭)12020-09-03
341630UQ155PS201612310002초등학교10915.926341592.5809데이터 미집계2016-12-31
441630UQ155PS201609260019초등학교19642.2434759456.28968312015-10-01
541630UQ155PS201609260018초등학교9076.28173242015.0886892015-10-01
641630UQ155PS201810100142중학교12615.0455845105.18285옥112018-10-10
741630UQ155PS201810100141초등학교11014.0110542566.30081옥102018-10-10
841630UQ155PS201810100140초등학교11348.0075541867.35739옥82018-10-10
941630UQ155PS202106250001근린공공시설(소방서,파출소)2500.13512219893.956412021-06-25
현황도형 관리번호라벨명면적(도형)길이(도형)도면번호현황도형 생성일
14441630UQ155PS201609260112서정대학교120399.9014162186.4667392022-05-23
14541630UQ155PS201609260070기타공공청사시설9928.29786645205.8023112015-10-01
14641630UQ155PS201609260069초등학교13559.079147098.05888272015-10-01
14741630UQ155PS201609260034기타공공청사시설5088.52760529781.69104옥52020-12-08
14841630UQ155PS201609260135유치원9611.973839977.01463옥192018-10-10
14941630UQ155PS201609260137중학교13472.2774547439.78645옥122018-10-10
15041630UQ155PS201609260136초등학교11178.6692542577.60038옥32018-10-10
15141630UQ155PS201609260133고등학교13884.6281546836.1528옥162018-10-10
15241630UQ155PS201609260134초등학교11013.327941881.66428옥22018-10-10
15341630UQ155PS201810100144특수학교12828.2302646270.85281옥202018-10-10