Overview

Dataset statistics

Number of variables4
Number of observations675
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory22.5 KiB
Average record size in memory34.2 B

Variable types

Text1
Categorical1
Numeric2

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=15123189

Alerts

면적_도형 is highly overall correlated with 길이_도형High correlation
길이_도형 is highly overall correlated with 면적_도형High correlation
현황도형 관리번호 has unique valuesUnique
면적_도형 has unique valuesUnique
길이_도형 has unique valuesUnique

Reproduction

Analysis started2024-01-09 20:08:21.937665
Analysis finished2024-01-09 20:08:22.816737
Duration0.88 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

현황도형 관리번호
Text

UNIQUE 

Distinct675
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size5.4 KiB
2024-01-10T05:08:23.000711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length24
Mean length24
Min length24

Characters and Unicode

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

Unique675 ?
Unique (%)100.0%

Sample

1st row44130UQ153PS199302230051
2nd row44130UQ153PS199203270003
3rd row44130UQ153PS199203270004
4th row44130UQ153PS199203270005
5th row44130UQ153PS199302230056
ValueCountFrequency (%)
44130uq153ps199302230051 1
 
0.1%
44130uq153ps200912020080 1
 
0.1%
44130uq153ps202111260036 1
 
0.1%
44130uq153ps201207050042 1
 
0.1%
44130uq153ps201207050039 1
 
0.1%
44130uq153ps201207050047 1
 
0.1%
44130uq153ps201207050044 1
 
0.1%
44130uq153ps201207050051 1
 
0.1%
44130uq153ps201207050049 1
 
0.1%
44130uq153ps201207050054 1
 
0.1%
Other values (665) 665
98.5%
2024-01-10T05:08:23.433623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 3816
23.6%
1 2724
16.8%
3 1736
10.7%
4 1632
10.1%
2 1431
 
8.8%
5 955
 
5.9%
U 675
 
4.2%
Q 675
 
4.2%
P 675
 
4.2%
S 675
 
4.2%
Other values (4) 1206
 
7.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 13500
83.3%
Uppercase Letter 2700
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 3816
28.3%
1 2724
20.2%
3 1736
12.9%
4 1632
12.1%
2 1431
 
10.6%
5 955
 
7.1%
9 410
 
3.0%
6 327
 
2.4%
8 242
 
1.8%
7 227
 
1.7%
Uppercase Letter
ValueCountFrequency (%)
U 675
25.0%
Q 675
25.0%
P 675
25.0%
S 675
25.0%

Most occurring scripts

ValueCountFrequency (%)
Common 13500
83.3%
Latin 2700
 
16.7%

Most frequent character per script

Common
ValueCountFrequency (%)
0 3816
28.3%
1 2724
20.2%
3 1736
12.9%
4 1632
12.1%
2 1431
 
10.6%
5 955
 
7.1%
9 410
 
3.0%
6 327
 
2.4%
8 242
 
1.8%
7 227
 
1.7%
Latin
ValueCountFrequency (%)
U 675
25.0%
Q 675
25.0%
P 675
25.0%
S 675
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 16200
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 3816
23.6%
1 2724
16.8%
3 1736
10.7%
4 1632
10.1%
2 1431
 
8.8%
5 955
 
5.9%
U 675
 
4.2%
Q 675
 
4.2%
P 675
 
4.2%
S 675
 
4.2%
Other values (4) 1206
 
7.4%

라벨명
Categorical

Distinct18
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Memory size5.4 KiB
완충녹지
234 
어린이공원
159 
근린공원
76 
경관녹지
62 
기타공원시설
48 
Other values (13)
96 

Length

Max length8
Median length4
Mean length4.5140741
Min length3

Unique

Unique3 ?
Unique (%)0.4%

Sample

1st row어린이공원
2nd row어린이공원
3rd row어린이공원
4th row어린이공원
5th row어린이공원

Common Values

ValueCountFrequency (%)
완충녹지 234
34.7%
어린이공원 159
23.6%
근린공원 76
 
11.3%
경관녹지 62
 
9.2%
기타공원시설 48
 
7.1%
공공공지 39
 
5.8%
기타녹지시설 16
 
2.4%
교차점광장 16
 
2.4%
기타교통광장시설 8
 
1.2%
근린광장 4
 
0.6%
Other values (8) 13
 
1.9%

Length

2024-01-10T05:08:23.633212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
완충녹지 234
34.7%
어린이공원 159
23.6%
근린공원 76
 
11.3%
경관녹지 62
 
9.2%
기타공원시설 48
 
7.1%
공공공지 39
 
5.8%
기타녹지시설 16
 
2.4%
교차점광장 16
 
2.4%
기타교통광장시설 8
 
1.2%
근린광장 4
 
0.6%
Other values (8) 13
 
1.9%

면적_도형
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct675
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean16731.658
Minimum20.899993
Maximum800727.4
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.1 KiB
2024-01-10T05:08:23.801112image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20.899993
5-th percentile539.99432
Q11593.8725
median2895.0109
Q39996.6624
95-th percentile72896.731
Maximum800727.4
Range800706.5
Interquartile range (IQR)8402.7899

Descriptive statistics

Standard deviation54566.915
Coefficient of variation (CV)3.2612975
Kurtosis88.548945
Mean16731.658
Median Absolute Deviation (MAD)1958.4738
Skewness8.2191874
Sum11293869
Variance2.9775483 × 109
MonotonicityNot monotonic
2024-01-10T05:08:23.977938image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1964.000959 1
 
0.1%
1305.902914 1
 
0.1%
16166.27211 1
 
0.1%
12658.89324 1
 
0.1%
17736.69242 1
 
0.1%
15606.48498 1
 
0.1%
14991.95317 1
 
0.1%
2408.571454 1
 
0.1%
1579.200589 1
 
0.1%
2168.162075 1
 
0.1%
Other values (665) 665
98.5%
ValueCountFrequency (%)
20.89999348 1
0.1%
52.0248905 1
0.1%
68.77617659 1
0.1%
97.98984037 1
0.1%
101.2129908 1
0.1%
169.8939725 1
0.1%
229.2234379 1
0.1%
229.5334922 1
0.1%
279.1919699 1
0.1%
282.39578 1
0.1%
ValueCountFrequency (%)
800727.3975 1
0.1%
536723.3934 1
0.1%
451215.3452 1
0.1%
399748.7335 1
0.1%
353430.4454 1
0.1%
318681.1497 1
0.1%
263324.1495 1
0.1%
255232.1374 1
0.1%
193104.3144 1
0.1%
192169.4411 1
0.1%

길이_도형
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct675
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1025.1351
Minimum37.354745
Maximum30161.82
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.1 KiB
2024-01-10T05:08:24.168993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.354745
5-th percentile117.74674
Q1195.74569
median376.2981
Q3959.23339
95-th percentile2852.2433
Maximum30161.82
Range30124.465
Interquartile range (IQR)763.48769

Descriptive statistics

Standard deviation2462.7836
Coefficient of variation (CV)2.4023992
Kurtosis71.714742
Mean1025.1351
Median Absolute Deviation (MAD)211.09098
Skewness7.6928772
Sum691966.16
Variance6065303.2
MonotonicityNot monotonic
2024-01-10T05:08:24.337584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
174.9320516 1
 
0.1%
279.5268436 1
 
0.1%
1465.624195 1
 
0.1%
1378.137023 1
 
0.1%
1328.404579 1
 
0.1%
870.6568753 1
 
0.1%
833.5834474 1
 
0.1%
268.7130423 1
 
0.1%
195.4115093 1
 
0.1%
481.1223653 1
 
0.1%
Other values (665) 665
98.5%
ValueCountFrequency (%)
37.35474477 1
0.1%
39.5355175 1
0.1%
51.78252574 1
0.1%
62.62398084 1
0.1%
62.81485615 1
0.1%
66.69742102 1
0.1%
70.99637159 1
0.1%
71.32206956 1
0.1%
72.22202473 1
0.1%
74.64924842 1
0.1%
ValueCountFrequency (%)
30161.81964 1
0.1%
27402.38588 1
0.1%
23583.67668 1
0.1%
22437.87049 1
0.1%
16734.97219 1
0.1%
14435.10342 1
0.1%
14256.81527 1
0.1%
13570.00355 1
0.1%
8356.419629 1
0.1%
7962.499613 1
0.1%

Interactions

2024-01-10T05:08:22.371777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:08:22.101055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:08:22.491300image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:08:22.243677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T05:08:24.439840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
라벨명면적_도형길이_도형
라벨명1.0000.7590.354
면적_도형0.7591.0000.577
길이_도형0.3540.5771.000
2024-01-10T05:08:24.549401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
면적_도형길이_도형라벨명
면적_도형1.0000.8580.444
길이_도형0.8581.0000.165
라벨명0.4440.1651.000

Missing values

2024-01-10T05:08:22.644202image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T05:08:22.767925image/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

현황도형 관리번호라벨명면적_도형길이_도형
044130UQ153PS199302230051어린이공원1964.000959174.932052
144130UQ153PS199203270003어린이공원2496.073087201.106161
244130UQ153PS199203270004어린이공원1500.072522162.583381
344130UQ153PS199203270005어린이공원2105.985494183.423533
444130UQ153PS199302230056어린이공원1911.650543181.212628
544130UQ153PS199302230057어린이공원1509.022528151.906409
644130UQ153PS199302230059어린이공원1499.990544152.048802
744130UQ153PS199901090004어린이공원2978.244332216.821338
844130UQ153PS199302230061어린이공원7930.050273352.455015
944130UQ153PS199901090005어린이공원1574.876862155.987142
현황도형 관리번호라벨명면적_도형길이_도형
66544130UQ153PS202305010037경관녹지39700.117143749.25593
66644130UQ153PS201011110002어린이공원4483.540712376.298103
66744130UQ153PS201011110003완충녹지1216.713245284.208177
66844130UQ153PS201011110004완충녹지1454.289854331.717993
66944130UQ153PS201011110005완충녹지1493.302521298.735495
67044130UQ153PS200803310001완충녹지2880.298085634.755057
67144130UQ153PS200101020058완충녹지74286.520916734.97219
67244130UQ153PS200101020079완충녹지1706.444551860.722043
67344130UQ153PS200812010300근린공원263324.14952311.604497
67444130UQ153PS200512300002중심대광장23022.47428703.760393