Overview

Dataset statistics

Number of variables3
Number of observations44
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.2 KiB
Average record size in memory28.0 B

Variable types

Text1
Categorical1
Numeric1

Dataset

Description충청남도 천안시 도시계획정보시스템(UPIS) 건축한계선 현황으로 현황도형 관리번호, 라벨명 등의 항목을 제공합니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=14&beforeMenuCd=DOM_000000201001001000&publicdatapk=15123188

Alerts

라벨명 has constant value ""Constant
현황도형 관리번호 has unique valuesUnique
길이_도형 has unique valuesUnique

Reproduction

Analysis started2024-01-09 22:43:45.859128
Analysis finished2024-01-09 22:43:46.132393
Duration0.27 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

현황도형 관리번호
Text

UNIQUE 

Distinct44
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size484.0 B
2024-01-10T07:43:46.255786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length24
Mean length24
Min length24

Characters and Unicode

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

Unique44 ?
Unique (%)100.0%

Sample

1st row44130UQ161PS199604200001
2nd row44130UQ161PS199701040001
3rd row44130UQ161PS199701040002
4th row44130UQ161PS200501060001
5th row44130UQ161PS200506240001
ValueCountFrequency (%)
44130uq161ps199604200001 1
 
2.3%
44130uq161ps199701040001 1
 
2.3%
44130uq161ps201808130008 1
 
2.3%
44130uq161ps201508210002 1
 
2.3%
44130uq161ps201511230002 1
 
2.3%
44130uq161ps201512010006 1
 
2.3%
44130uq161ps201608010033 1
 
2.3%
44130uq161ps201609010039 1
 
2.3%
44130uq161ps201610210046 1
 
2.3%
44130uq161ps201804020002 1
 
2.3%
Other values (34) 34
77.3%
2024-01-10T07:43:46.545523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 281
26.6%
1 235
22.3%
4 99
 
9.4%
2 93
 
8.8%
3 65
 
6.2%
6 61
 
5.8%
U 44
 
4.2%
Q 44
 
4.2%
P 44
 
4.2%
S 44
 
4.2%
Other values (4) 46
 
4.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 880
83.3%
Uppercase Letter 176
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 281
31.9%
1 235
26.7%
4 99
 
11.2%
2 93
 
10.6%
3 65
 
7.4%
6 61
 
6.9%
5 20
 
2.3%
8 13
 
1.5%
9 9
 
1.0%
7 4
 
0.5%
Uppercase Letter
ValueCountFrequency (%)
U 44
25.0%
Q 44
25.0%
P 44
25.0%
S 44
25.0%

Most occurring scripts

ValueCountFrequency (%)
Common 880
83.3%
Latin 176
 
16.7%

Most frequent character per script

Common
ValueCountFrequency (%)
0 281
31.9%
1 235
26.7%
4 99
 
11.2%
2 93
 
10.6%
3 65
 
7.4%
6 61
 
6.9%
5 20
 
2.3%
8 13
 
1.5%
9 9
 
1.0%
7 4
 
0.5%
Latin
ValueCountFrequency (%)
U 44
25.0%
Q 44
25.0%
P 44
25.0%
S 44
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1056
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 281
26.6%
1 235
22.3%
4 99
 
9.4%
2 93
 
8.8%
3 65
 
6.2%
6 61
 
5.8%
U 44
 
4.2%
Q 44
 
4.2%
P 44
 
4.2%
S 44
 
4.2%
Other values (4) 46
 
4.4%

라벨명
Categorical

CONSTANT 

Distinct1
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size484.0 B
건축한계선
44 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row건축한계선
2nd row건축한계선
3rd row건축한계선
4th row건축한계선
5th row건축한계선

Common Values

ValueCountFrequency (%)
건축한계선 44
100.0%

Length

2024-01-10T07:43:46.692536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:43:46.779113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
건축한계선 44
100.0%

길이_도형
Real number (ℝ)

UNIQUE 

Distinct44
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3842.2181
Minimum287.95017
Maximum31602.69
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size528.0 B
2024-01-10T07:43:46.874843image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum287.95017
5-th percentile458.27451
Q1658.38805
median1225.5668
Q34251.5454
95-th percentile14720.154
Maximum31602.69
Range31314.74
Interquartile range (IQR)3593.1573

Descriptive statistics

Standard deviation5846.6578
Coefficient of variation (CV)1.5216881
Kurtosis11.576524
Mean3842.2181
Median Absolute Deviation (MAD)760.1486
Skewness3.0789031
Sum169057.6
Variance34183407
MonotonicityNot monotonic
2024-01-10T07:43:46.997258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=44)
ValueCountFrequency (%)
4301.639836 1
 
2.3%
3904.037034 1
 
2.3%
932.4569874 1
 
2.3%
498.7330538 1
 
2.3%
511.6068257 1
 
2.3%
789.4471839 1
 
2.3%
455.1901166 1
 
2.3%
2606.218385 1
 
2.3%
1458.298195 1
 
2.3%
808.4633145 1
 
2.3%
Other values (34) 34
77.3%
ValueCountFrequency (%)
287.9501683 1
2.3%
455.1901166 1
2.3%
455.2129339 1
2.3%
475.6234496 1
2.3%
498.7330538 1
2.3%
511.6068257 1
2.3%
548.3685591 1
2.3%
639.7345927 1
2.3%
644.3604233 1
2.3%
647.6180881 1
2.3%
ValueCountFrequency (%)
31602.6904 1
2.3%
16415.45124 1
2.3%
15080.48168 1
2.3%
12678.29594 1
2.3%
11244.6106 1
2.3%
7135.64402 1
2.3%
7121.130585 1
2.3%
7023.623342 1
2.3%
5928.879971 1
2.3%
4824.428713 1
2.3%

Interactions

2024-01-10T07:43:45.922350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T07:43:47.082210image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
현황도형 관리번호길이_도형
현황도형 관리번호1.0001.000
길이_도형1.0001.000

Missing values

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

현황도형 관리번호라벨명길이_도형
044130UQ161PS199604200001건축한계선4301.639836
144130UQ161PS199701040001건축한계선655.710997
244130UQ161PS199701040002건축한계선16415.45124
344130UQ161PS200501060001건축한계선1168.936651
444130UQ161PS200506240001건축한계선7023.623342
544130UQ161PS200511300001건축한계선7121.130585
644130UQ161PS200605100001건축한계선475.62345
744130UQ161PS200710220002건축한계선1282.196934
844130UQ161PS200804300002건축한계선2201.759646
944130UQ161PS200810240001건축한계선1158.429808
현황도형 관리번호라벨명길이_도형
3444130UQ161PS202002210006건축한계선691.202436
3544130UQ161PS202006110003건축한계선4234.847253
3644130UQ161PS202011230002건축한계선647.618088
3744130UQ161PS202011300001건축한계선15080.48168
3844130UQ161PS202108230003건축한계선4824.428713
3944130UQ161PS202111110015건축한계선685.933837
4044130UQ161PS202111260001건축한계선11244.6106
4144130UQ161PS202203020005건축한계선287.950168
4244130UQ161PS202205020001건축한계선719.133159
4344130UQ161PS202206210001건축한계선455.212934