Overview

Dataset statistics

Number of variables4
Number of observations228
Missing cells37
Missing cells (%)4.1%
Duplicate rows1
Duplicate rows (%)0.4%
Total size in memory7.5 KiB
Average record size in memory33.6 B

Variable types

Text1
Categorical2
Numeric1

Dataset

Description충청남도 공주시 실외운동기구현황에 대한 데이터로 (실외운동기구 설치주소, 설치기구종류, 담당부서, 최근5년설치현황) 등의 항목을 제공합니다,
Author충청남도 공주시
URLhttps://www.data.go.kr/data/15037936/fileData.do

Alerts

담당부서 has constant value ""Constant
Dataset has 1 (0.4%) duplicate rowsDuplicates
최근5년설치현황 is highly overall correlated with 설치기구종류High correlation
설치기구종류 is highly overall correlated with 최근5년설치현황High correlation
최근5년설치현황 has 37 (16.2%) missing valuesMissing

Reproduction

Analysis started2023-12-12 21:59:52.378501
Analysis finished2023-12-12 21:59:52.876906
Duration0.5 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

설치 주소
Text

Distinct225
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2023-12-13T06:59:53.155756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length26
Mean length13.131579
Min length4

Characters and Unicode

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

Unique

Unique222 ?
Unique (%)97.4%

Sample

1st row계룡면 화헌리 235
2nd row계룡면 경천리 246
3rd row계룡면 경천리 375
4th row계룡면 봉명리 119
5th row계룡면 유평리 400
ValueCountFrequency (%)
우성면 22
 
3.3%
탄천면 22
 
3.3%
계룡면 21
 
3.1%
유구읍 19
 
2.8%
반포면 18
 
2.7%
사곡면 18
 
2.7%
이인면 17
 
2.5%
정안면 14
 
2.1%
신풍면 13
 
1.9%
의당면 10
 
1.5%
Other values (399) 498
74.1%
2023-12-13T06:59:53.653767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
452
 
15.1%
리 163
 
5.4%
면 156
 
5.2%
1 144
 
4.8%
2 130
 
4.3%
- 116
 
3.9%
3 111
 
3.7%
4 84
 
2.8%
5 64
 
2.1%
동 62
 
2.1%
Other values (182) 1512
50.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1565
52.3%
Decimal Number 773
25.8%
Space Separator 452
 
15.1%
Dash Punctuation 116
 
3.9%
Open Punctuation 43
 
1.4%
Close Punctuation 42
 
1.4%
Other Punctuation 2
 
0.1%
Connector Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
리 163
 
10.4%
면 156
 
10.0%
동 62
 
4.0%
신 40
 
2.6%
룡 36
 
2.3%
천 35
 
2.2%
성 32
 
2.0%
곡 30
 
1.9%
계 28
 
1.8%
구 27
 
1.7%
Other values (166) 956
61.1%
Decimal Number
ValueCountFrequency (%)
1 144
18.6%
2 130
16.8%
3 111
14.4%
4 84
10.9%
5 64
8.3%
6 60
7.8%
7 57
 
7.4%
0 47
 
6.1%
9 44
 
5.7%
8 32
 
4.1%
Space Separator
ValueCountFrequency (%)
452
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 116
100.0%
Open Punctuation
ValueCountFrequency (%)
( 43
100.0%
Close Punctuation
ValueCountFrequency (%)
) 42
100.0%
Other Punctuation
ValueCountFrequency (%)
, 2
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1565
52.3%
Common 1429
47.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
리 163
 
10.4%
면 156
 
10.0%
동 62
 
4.0%
신 40
 
2.6%
룡 36
 
2.3%
천 35
 
2.2%
성 32
 
2.0%
곡 30
 
1.9%
계 28
 
1.8%
구 27
 
1.7%
Other values (166) 956
61.1%
Common
ValueCountFrequency (%)
452
31.6%
1 144
 
10.1%
2 130
 
9.1%
- 116
 
8.1%
3 111
 
7.8%
4 84
 
5.9%
5 64
 
4.5%
6 60
 
4.2%
7 57
 
4.0%
0 47
 
3.3%
Other values (6) 164
 
11.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1565
52.3%
ASCII 1429
47.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
452
31.6%
1 144
 
10.1%
2 130
 
9.1%
- 116
 
8.1%
3 111
 
7.8%
4 84
 
5.9%
5 64
 
4.5%
6 60
 
4.2%
7 57
 
4.0%
0 47
 
3.3%
Other values (6) 164
 
11.5%
Hangul
ValueCountFrequency (%)
리 163
 
10.4%
면 156
 
10.0%
동 62
 
4.0%
신 40
 
2.6%
룡 36
 
2.3%
천 35
 
2.2%
성 32
 
2.0%
곡 30
 
1.9%
계 28
 
1.8%
구 27
 
1.7%
Other values (166) 956
61.1%

설치기구종류
Categorical

HIGH CORRELATION 

Distinct28
Distinct (%)12.3%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
운동기구 4점
58 
운동기구 5점
35 
운동기구 6점
35 
운동기구 3점
17 
운동기구 7점
17 
Other values (23)
66 

Length

Max length21
Median length7
Mean length7.1578947
Min length4

Unique

Unique15 ?
Unique (%)6.6%

Sample

1st row운동기구 8점
2nd row운동기구 4점
3rd row운동기구 11점
4th row운동기구 9점
5th row운동기구 3점

Common Values

ValueCountFrequency (%)
운동기구 4점 58
25.4%
운동기구 5점 35
15.4%
운동기구 6점 35
15.4%
운동기구 3점 17
 
7.5%
운동기구 7점 17
 
7.5%
운동기구 5종 10
 
4.4%
운동기구 6종 9
 
3.9%
운동기구 8점 8
 
3.5%
운동기구 2점 8
 
3.5%
운동기구 9점 7
 
3.1%
Other values (18) 24
10.5%

Length

2023-12-13T06:59:53.830124image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
운동기구 224
49.0%
4점 59
 
12.9%
6점 36
 
7.9%
5점 35
 
7.7%
3점 17
 
3.7%
7점 17
 
3.7%
5종 10
 
2.2%
6종 10
 
2.2%
8점 8
 
1.8%
2점 8
 
1.8%
Other values (20) 33
 
7.2%

담당부서
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
문화체육과
228 

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 (%)
문화체육과 228
100.0%

Length

2023-12-13T06:59:53.964110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:59:54.066265image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
문화체육과 228
100.0%

최근5년설치현황
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct21
Distinct (%)11.0%
Missing37
Missing (%)16.2%
Infinite0
Infinite (%)0.0%
Mean2015.2408
Minimum1990
Maximum2019
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.1 KiB
2023-12-13T06:59:54.198404image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1990
5-th percentile2001.5
Q12015
median2016
Q32018
95-th percentile2019
Maximum2019
Range29
Interquartile range (IQR)3

Descriptive statistics

Standard deviation5.0465838
Coefficient of variation (CV)0.0025042088
Kurtosis8.9258869
Mean2015.2408
Median Absolute Deviation (MAD)1
Skewness-2.9283202
Sum384911
Variance25.468008
MonotonicityNot monotonic
2023-12-13T06:59:54.353906image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
2019 41
18.0%
2016 38
16.7%
2015 37
16.2%
2017 27
11.8%
2018 15
 
6.6%
2014 12
 
5.3%
2013 3
 
1.3%
1997 2
 
0.9%
1995 2
 
0.9%
2002 2
 
0.9%
Other values (11) 12
 
5.3%
(Missing) 37
16.2%
ValueCountFrequency (%)
1990 1
0.4%
1995 2
0.9%
1996 1
0.4%
1997 2
0.9%
1998 1
0.4%
1999 1
0.4%
2000 1
0.4%
2001 1
0.4%
2002 2
0.9%
2008 1
0.4%
ValueCountFrequency (%)
2019 41
18.0%
2018 15
 
6.6%
2017 27
11.8%
2016 38
16.7%
2015 37
16.2%
2014 12
 
5.3%
2013 3
 
1.3%
2012 1
 
0.4%
2011 2
 
0.9%
2010 1
 
0.4%

Interactions

2023-12-13T06:59:52.558451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T06:59:54.469700image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치기구종류최근5년설치현황
설치기구종류1.0000.809
최근5년설치현황0.8091.000
2023-12-13T06:59:54.558580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
최근5년설치현황설치기구종류
최근5년설치현황1.0000.564
설치기구종류0.5641.000

Missing values

2023-12-13T06:59:52.724592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T06:59:52.833487image/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

설치 주소설치기구종류담당부서최근5년설치현황
0계룡면 화헌리 235운동기구 8점문화체육과2008
1계룡면 경천리 246운동기구 4점문화체육과2015
2계룡면 경천리 375운동기구 11점문화체육과2015
3계룡면 봉명리 119운동기구 9점문화체육과2015
4계룡면 유평리 400운동기구 3점문화체육과2015
5계룡면 향지리 345운동기구 9점문화체육과2015
6계룡면 양화1리 165-1운동기구 4점문화체육과2016
7계룡면 월암리 385운동기구 4점문화체육과2016
8계룡면 내흥리 629운동기구 4점문화체육과2016
9계룡면 중장리 379-6운동기구 4점문화체육과2016
설치 주소설치기구종류담당부서최근5년설치현황
218신관동 13통 602-14운동기구 7점문화체육과2019
219신풍면 산정1리 311-2운동기구 6점문화체육과2019
220유구읍 신영리 102운동기구 5점문화체육과2019
221유구읍 여드니2길 6운동기구 5점문화체육과2019
222유구읍 신설동 1길 61운동기구 5점문화체육과2019
223유구읍 덕골길 76운동기구 5점문화체육과2019
224정안면 고성리 306일원, 농촌휴양마을체험장운동기구 6점문화체육과2019
225의당면 가산리 330-23운동기구 6점문화체육과2019
226금학동 240-4운동기구 5점문화체육과2019
227이인면 운암리 164 자원순환센터운동기구 5점문화체육과2019

Duplicate rows

Most frequently occurring

설치 주소설치기구종류담당부서최근5년설치현황# duplicates
0웅진동 교동 3운동기구 5점문화체육과20142