Overview

Dataset statistics

Number of variables2
Number of observations3503
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory54.9 KiB
Average record size in memory16.0 B

Variable types

Text2

Dataset

Description충청남도 천안시 도시계획정보시스템(UPIS) 대지 분할 합병시 규모 현황으로 현황도형 관리번호, 규제관리번호의 항목을 제공합니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=13&beforeMenuCd=DOM_000000201001001000&publicdatapk=15123831

Alerts

규제관리번호 has unique valuesUnique

Reproduction

Analysis started2024-01-09 22:13:06.979041
Analysis finished2024-01-09 22:13:07.166342
Duration0.19 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

현황도형 관리번호
Text

Distinct190
Distinct (%)5.4%
Missing0
Missing (%)0.0%
Memory size27.5 KiB
2024-01-10T07:13:07.349748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length24
Mean length24
Min length24

Characters and Unicode

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

Unique36 ?
Unique (%)1.0%

Sample

1st row44130UQ161PS200511300001
2nd row44130UQ161PS200511300001
3rd row44130UQ161PS200511300001
4th row44130UQ161PS200511300001
5th row44130UQ161PS200511300001
ValueCountFrequency (%)
44130uq161ps200511300001 786
22.4%
44130uq161ps201306200001 343
 
9.8%
44130uq161ps200002120001 154
 
4.4%
44130uq161ps200404300001 154
 
4.4%
44130uq161ps201305010004 97
 
2.8%
44130uq161ps201302120001 88
 
2.5%
44130uq161ps199701040002 82
 
2.3%
44130uq161ps200901200001 70
 
2.0%
44130uq161ps201207050001 69
 
2.0%
44130uq161ps202211210001 53
 
1.5%
Other values (180) 1607
45.9%
2024-01-10T07:13:07.685013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 24161
28.7%
1 18696
22.2%
4 7972
 
9.5%
2 6093
 
7.2%
3 5884
 
7.0%
6 4325
 
5.1%
U 3503
 
4.2%
Q 3503
 
4.2%
P 3503
 
4.2%
S 3503
 
4.2%
Other values (4) 2929
 
3.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 70060
83.3%
Uppercase Letter 14012
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 24161
34.5%
1 18696
26.7%
4 7972
 
11.4%
2 6093
 
8.7%
3 5884
 
8.4%
6 4325
 
6.2%
5 1470
 
2.1%
9 636
 
0.9%
7 546
 
0.8%
8 277
 
0.4%
Uppercase Letter
ValueCountFrequency (%)
U 3503
25.0%
Q 3503
25.0%
P 3503
25.0%
S 3503
25.0%

Most occurring scripts

ValueCountFrequency (%)
Common 70060
83.3%
Latin 14012
 
16.7%

Most frequent character per script

Common
ValueCountFrequency (%)
0 24161
34.5%
1 18696
26.7%
4 7972
 
11.4%
2 6093
 
8.7%
3 5884
 
8.4%
6 4325
 
6.2%
5 1470
 
2.1%
9 636
 
0.9%
7 546
 
0.8%
8 277
 
0.4%
Latin
ValueCountFrequency (%)
U 3503
25.0%
Q 3503
25.0%
P 3503
25.0%
S 3503
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 84072
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 24161
28.7%
1 18696
22.2%
4 7972
 
9.5%
2 6093
 
7.2%
3 5884
 
7.0%
6 4325
 
5.1%
U 3503
 
4.2%
Q 3503
 
4.2%
P 3503
 
4.2%
S 3503
 
4.2%
Other values (4) 2929
 
3.5%

규제관리번호
Text

UNIQUE 

Distinct3503
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size27.5 KiB
2024-01-10T07:13:07.863961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length24
Mean length24
Min length24

Characters and Unicode

Total characters84072
Distinct characters17
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

Unique3503 ?
Unique (%)100.0%

Sample

1st row44130UQ162HJ201604111646
2nd row44130UQ162HJ201604111647
3rd row44130UQ162HJ201604111648
4th row44130UQ162HJ201604111649
5th row44130UQ162HJ201604111650
ValueCountFrequency (%)
44130uq162hj201604111646 1
 
< 0.1%
44130uq162hj201502030841 1
 
< 0.1%
44130uq162hj201502039136 1
 
< 0.1%
44130uq162hj201502030859 1
 
< 0.1%
44130uq162hj201502039137 1
 
< 0.1%
44130uq162hj201502030839 1
 
< 0.1%
44130uq162hj201502030840 1
 
< 0.1%
44130uq162hj201502030838 1
 
< 0.1%
44130uq162hj201502030837 1
 
< 0.1%
44130uq162hj201502030843 1
 
< 0.1%
Other values (3493) 3493
99.7%
2024-01-10T07:13:08.151144image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 16239
19.3%
1 15061
17.9%
2 11709
13.9%
4 9356
11.1%
3 6326
 
7.5%
6 5468
 
6.5%
J 3503
 
4.2%
H 3503
 
4.2%
Q 3503
 
4.2%
U 3503
 
4.2%
Other values (7) 5901
 
7.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 69931
83.2%
Uppercase Letter 14141
 
16.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 16239
23.2%
1 15061
21.5%
2 11709
16.7%
4 9356
13.4%
3 6326
 
9.0%
6 5468
 
7.8%
5 2541
 
3.6%
8 1309
 
1.9%
7 972
 
1.4%
9 950
 
1.4%
Uppercase Letter
ValueCountFrequency (%)
J 3503
24.8%
H 3503
24.8%
Q 3503
24.8%
U 3503
24.8%
A 127
 
0.9%
C 1
 
< 0.1%
B 1
 
< 0.1%

Most occurring scripts

ValueCountFrequency (%)
Common 69931
83.2%
Latin 14141
 
16.8%

Most frequent character per script

Common
ValueCountFrequency (%)
0 16239
23.2%
1 15061
21.5%
2 11709
16.7%
4 9356
13.4%
3 6326
 
9.0%
6 5468
 
7.8%
5 2541
 
3.6%
8 1309
 
1.9%
7 972
 
1.4%
9 950
 
1.4%
Latin
ValueCountFrequency (%)
J 3503
24.8%
H 3503
24.8%
Q 3503
24.8%
U 3503
24.8%
A 127
 
0.9%
C 1
 
< 0.1%
B 1
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 84072
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 16239
19.3%
1 15061
17.9%
2 11709
13.9%
4 9356
11.1%
3 6326
 
7.5%
6 5468
 
6.5%
J 3503
 
4.2%
H 3503
 
4.2%
Q 3503
 
4.2%
U 3503
 
4.2%
Other values (7) 5901
 
7.0%

Missing values

2024-01-10T07:13:07.087494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T07:13:07.143648image/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

현황도형 관리번호규제관리번호
044130UQ161PS20051130000144130UQ162HJ201604111646
144130UQ161PS20051130000144130UQ162HJ201604111647
244130UQ161PS20051130000144130UQ162HJ201604111648
344130UQ161PS20051130000144130UQ162HJ201604111649
444130UQ161PS20051130000144130UQ162HJ201604111650
544130UQ161PS20051130000144130UQ162HJ201604111651
644130UQ161PS20051130000144130UQ162HJ201604111657
744130UQ161PS20051130000144130UQ162HJ201604111658
844130UQ161PS20051130000144130UQ162HJ201604111659
944130UQ161PS20051130000144130UQ162HJ201604111660
현황도형 관리번호규제관리번호
349344130UQ161PS20201130000144130UQ162HJ202204260013
349444130UQ161PS20201130000144130UQ162HJ202204260014
349544130UQ161PS20201130000144130UQ162HJ202204260015
349644130UQ161PS20201130000144130UQ162HJ202204260016
349744130UQ161PS20201130000144130UQ162HJ202204260017
349844130UQ161PS20201130000144130UQ162HJ202204260018
349944130UQ161PS20201130000144130UQ162HJ202204260019
350044130UQ161PS20201130000144130UQ162HJ202204260020
350144130UQ161PS20201130000144130UQ162HJ202204260021
350244130UQ161PS20201130000144130UQ162HJ202204260022