Overview

Dataset statistics

Number of variables4
Number of observations488
Missing cells37
Missing cells (%)1.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory15.4 KiB
Average record size in memory32.3 B

Variable types

Text3
Categorical1

Dataset

Description전라남도 여수시 도시계획정보시스템(UPIS) 공간시설 현황 데이터 자료로 공간시설명(공원, 녹지 등) 등을 제공합니다.
URLhttps://www.data.go.kr/data/15119076/fileData.do

Alerts

도면번호 has 37 (7.6%) missing valuesMissing
현황도형 관리번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 11:14:35.001422
Analysis finished2023-12-12 11:14:35.444946
Duration0.44 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct488
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size3.9 KiB
2023-12-12T20:14:35.631763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length24
Mean length24
Min length24

Characters and Unicode

Total characters11712
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

Unique488 ?
Unique (%)100.0%

Sample

1st row46130UQ153PS201602870054
2nd row46130UQ153PS201903150055
3rd row46130UQ153PS202000840056
4th row46130UQ153PS201500950057
5th row46130UQ153PS201500950058
ValueCountFrequency (%)
46130uq153ps201602870054 1
 
0.2%
46130uq153ps201303830405 1
 
0.2%
46130uq153ps201800280143 1
 
0.2%
46130uq153ps202004610477 1
 
0.2%
46130uq153ps201800610016 1
 
0.2%
46130uq153ps202211160002 1
 
0.2%
46130uq153ps201500950420 1
 
0.2%
46130uq153ps201004110385 1
 
0.2%
46130uq153ps201004110384 1
 
0.2%
46130uq153ps201004110383 1
 
0.2%
Other values (478) 478
98.0%
2023-12-12T20:14:36.127943image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 2498
21.3%
1 1805
15.4%
3 1337
11.4%
2 900
 
7.7%
5 853
 
7.3%
4 826
 
7.1%
6 703
 
6.0%
9 497
 
4.2%
U 488
 
4.2%
Q 488
 
4.2%
Other values (4) 1317
11.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 9760
83.3%
Uppercase Letter 1952
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 2498
25.6%
1 1805
18.5%
3 1337
13.7%
2 900
 
9.2%
5 853
 
8.7%
4 826
 
8.5%
6 703
 
7.2%
9 497
 
5.1%
7 172
 
1.8%
8 169
 
1.7%
Uppercase Letter
ValueCountFrequency (%)
U 488
25.0%
Q 488
25.0%
P 488
25.0%
S 488
25.0%

Most occurring scripts

ValueCountFrequency (%)
Common 9760
83.3%
Latin 1952
 
16.7%

Most frequent character per script

Common
ValueCountFrequency (%)
0 2498
25.6%
1 1805
18.5%
3 1337
13.7%
2 900
 
9.2%
5 853
 
8.7%
4 826
 
8.5%
6 703
 
7.2%
9 497
 
5.1%
7 172
 
1.8%
8 169
 
1.7%
Latin
ValueCountFrequency (%)
U 488
25.0%
Q 488
25.0%
P 488
25.0%
S 488
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 11712
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 2498
21.3%
1 1805
15.4%
3 1337
11.4%
2 900
 
7.7%
5 853
 
7.3%
4 826
 
7.1%
6 703
 
6.0%
9 497
 
4.2%
U 488
 
4.2%
Q 488
 
4.2%
Other values (4) 1317
11.2%
Distinct188
Distinct (%)38.5%
Missing0
Missing (%)0.0%
Memory size3.9 KiB
2023-12-12T20:14:36.467084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length4
Mean length4.3504098
Min length3

Characters and Unicode

Total characters2123
Distinct characters187
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

Unique173 ?
Unique (%)35.5%

Sample

1st row돌산대교제2공원
2nd row죽림15공원
3rd row무선산공원
4th row건천공원
5th row조산들공원
ValueCountFrequency (%)
완충녹지 122
24.8%
경관녹지 103
21.0%
교통광장 26
 
5.3%
공공공지 15
 
3.1%
일반광장 11
 
2.2%
연결녹지 8
 
1.6%
어린이공원 7
 
1.4%
소공원 6
 
1.2%
근린공원 3
 
0.6%
미관광장 3
 
0.6%
Other values (179) 187
38.1%
2023-12-12T20:14:37.015392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
272
12.8%
243
 
11.4%
214
 
10.1%
183
 
8.6%
131
 
6.2%
130
 
6.1%
108
 
5.1%
106
 
5.0%
59
 
2.8%
52
 
2.4%
Other values (177) 625
29.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2076
97.8%
Decimal Number 41
 
1.9%
Space Separator 3
 
0.1%
Open Punctuation 1
 
< 0.1%
Dash Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
272
13.1%
243
11.7%
214
 
10.3%
183
 
8.8%
131
 
6.3%
130
 
6.3%
108
 
5.2%
106
 
5.1%
59
 
2.8%
52
 
2.5%
Other values (165) 578
27.8%
Decimal Number
ValueCountFrequency (%)
1 14
34.1%
3 7
17.1%
2 7
17.1%
4 6
14.6%
9 3
 
7.3%
5 2
 
4.9%
6 1
 
2.4%
7 1
 
2.4%
Space Separator
ValueCountFrequency (%)
3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2076
97.8%
Common 47
 
2.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
272
13.1%
243
11.7%
214
 
10.3%
183
 
8.8%
131
 
6.3%
130
 
6.3%
108
 
5.2%
106
 
5.1%
59
 
2.8%
52
 
2.5%
Other values (165) 578
27.8%
Common
ValueCountFrequency (%)
1 14
29.8%
3 7
14.9%
2 7
14.9%
4 6
12.8%
3
 
6.4%
9 3
 
6.4%
5 2
 
4.3%
( 1
 
2.1%
- 1
 
2.1%
6 1
 
2.1%
Other values (2) 2
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2076
97.8%
ASCII 47
 
2.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
272
13.1%
243
11.7%
214
 
10.3%
183
 
8.8%
131
 
6.3%
130
 
6.3%
108
 
5.2%
106
 
5.1%
59
 
2.8%
52
 
2.5%
Other values (165) 578
27.8%
ASCII
ValueCountFrequency (%)
1 14
29.8%
3 7
14.9%
2 7
14.9%
4 6
12.8%
3
 
6.4%
9 3
 
6.4%
5 2
 
4.3%
( 1
 
2.1%
- 1
 
2.1%
6 1
 
2.1%
Other values (2) 2
 
4.3%

도면번호
Text

MISSING 

Distinct295
Distinct (%)65.4%
Missing37
Missing (%)7.6%
Memory size3.9 KiB
2023-12-12T20:14:37.649370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length3
Mean length2.5277162
Min length1

Characters and Unicode

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

Unique

Unique210 ?
Unique (%)46.6%

Sample

1st row208
2nd row3
3rd row101
4th row146
5th row2
ValueCountFrequency (%)
1 25
 
5.5%
2 16
 
3.5%
3 8
 
1.8%
6 6
 
1.3%
4 6
 
1.3%
13 6
 
1.3%
23 4
 
0.9%
148 4
 
0.9%
10 4
 
0.9%
11 4
 
0.9%
Other values (285) 368
81.6%
2023-12-12T20:14:38.450787image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 279
24.5%
2 140
12.3%
3 98
 
8.6%
4 91
 
8.0%
6 84
 
7.4%
7 81
 
7.1%
5 73
 
6.4%
9 69
 
6.1%
8 67
 
5.9%
0 66
 
5.8%
Other values (6) 92
 
8.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1048
91.9%
Other Letter 81
 
7.1%
Open Punctuation 4
 
0.4%
Close Punctuation 4
 
0.4%
Dash Punctuation 3
 
0.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 279
26.6%
2 140
13.4%
3 98
 
9.4%
4 91
 
8.7%
6 84
 
8.0%
7 81
 
7.7%
5 73
 
7.0%
9 69
 
6.6%
8 67
 
6.4%
0 66
 
6.3%
Other Letter
ValueCountFrequency (%)
41
50.6%
34
42.0%
6
 
7.4%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1059
92.9%
Hangul 81
 
7.1%

Most frequent character per script

Common
ValueCountFrequency (%)
1 279
26.3%
2 140
13.2%
3 98
 
9.3%
4 91
 
8.6%
6 84
 
7.9%
7 81
 
7.6%
5 73
 
6.9%
9 69
 
6.5%
8 67
 
6.3%
0 66
 
6.2%
Other values (3) 11
 
1.0%
Hangul
ValueCountFrequency (%)
41
50.6%
34
42.0%
6
 
7.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1059
92.9%
Hangul 81
 
7.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 279
26.3%
2 140
13.2%
3 98
 
9.3%
4 91
 
8.6%
6 84
 
7.9%
7 81
 
7.6%
5 73
 
6.9%
9 69
 
6.5%
8 67
 
6.3%
0 66
 
6.2%
Other values (3) 11
 
1.0%
Hangul
ValueCountFrequency (%)
41
50.6%
34
42.0%
6
 
7.4%
Distinct11
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size3.9 KiB
2018-02-28 0:00
267 
2021-10-29 0:00
83 
2010-05-01 0:00
45 
2018-06-30 0:00
43 
2018-10-31 0:00
 
20
Other values (6)
30 

Length

Max length15
Median length15
Mean length15
Min length15

Unique

Unique2 ?
Unique (%)0.4%

Sample

1st row2018-02-28 0:00
2nd row2021-10-29 0:00
3rd row2021-10-29 0:00
4th row2018-02-28 0:00
5th row2018-02-28 0:00

Common Values

ValueCountFrequency (%)
2018-02-28 0:00 267
54.7%
2021-10-29 0:00 83
 
17.0%
2010-05-01 0:00 45
 
9.2%
2018-06-30 0:00 43
 
8.8%
2018-10-31 0:00 20
 
4.1%
2021-12-31 0:00 11
 
2.3%
2023-02-08 0:00 7
 
1.4%
2018-05-31 0:00 5
 
1.0%
2022-11-16 0:00 5
 
1.0%
2018-08-07 0:00 1
 
0.2%

Length

2023-12-12T20:14:38.691177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
0:00 488
50.0%
2018-02-28 267
27.4%
2021-10-29 83
 
8.5%
2010-05-01 45
 
4.6%
2018-06-30 43
 
4.4%
2018-10-31 20
 
2.0%
2021-12-31 11
 
1.1%
2023-02-08 7
 
0.7%
2018-05-31 5
 
0.5%
2022-11-16 5
 
0.5%
Other values (2) 2
 
0.2%

Missing values

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

현황도형 관리번호라벨명도면번호현황도형 생성일
046130UQ153PS201602870054돌산대교제2공원2082018-02-28 0:00
146130UQ153PS201903150055죽림15공원32021-10-29 0:00
246130UQ153PS202000840056무선산공원<NA>2021-10-29 0:00
346130UQ153PS201500950057건천공원1012018-02-28 0:00
446130UQ153PS201500950058조산들공원1462018-02-28 0:00
546130UQ153PS201903150059죽림14공원22021-10-29 0:00
646130UQ153PS201903150060죽림13공원12021-10-29 0:00
746130UQ153PS201903150061완충녹지82021-10-29 0:00
846130UQ153PS201903150062경관녹지92021-10-29 0:00
946130UQ153PS200208120063평여1442010-05-01 0:00
현황도형 관리번호라벨명도면번호현황도형 생성일
47846130UQ153PS201500950044서교공원1302018-02-28 0:00
47946130UQ153PS200208120045경관녹지14-12010-05-01 0:00
48046130UQ153PS201500950046수정공원1372018-02-28 0:00
48146130UQ153PS201500950047관문공원1382018-02-28 0:00
48246130UQ153PS201500950048율촌장도공원732018-02-28 0:00
48346130UQ153PS201602290049경관녹지2572018-02-28 0:00
48446130UQ153PS201903150050공공공지22021-10-29 0:00
48546130UQ153PS200801110051경관광장422010-05-01 0:00
48646130UQ153PS202100840052죽림3공원1532021-10-29 0:00
48746130UQ153PS201500460053연등공원282018-02-28 0:00