Overview

Dataset statistics

Number of variables8
Number of observations204
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory13.3 KiB
Average record size in memory66.6 B

Variable types

Numeric2
Text2
Categorical4

Dataset

Description야외 운동기구 설치 종류 및 설치업체, 연도별 고장현황실외 운동기구의 종류 위치 설치업체의 제공을 통해 예산군민의 복지 제고
Author충청남도 예산군
URLhttps://www.data.go.kr/data/15038006/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
설치년도 is highly overall correlated with 비고High correlation
수 량 is highly overall correlated with 비고High correlation
설치업체 is highly overall correlated with 관리부서 and 1 other fieldsHigh correlation
관리부서 is highly overall correlated with 설치업체 and 1 other fieldsHigh correlation
비고 is highly overall correlated with 설치년도 and 3 other fieldsHigh correlation
비고 is highly imbalanced (75.2%)Imbalance

Reproduction

Analysis started2023-12-12 04:23:54.445473
Analysis finished2023-12-12 04:23:56.061143
Duration1.62 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

설치년도
Real number (ℝ)

HIGH CORRELATION 

Distinct9
Distinct (%)4.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2018.2794
Minimum2015
Maximum2023
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-12T13:23:56.123113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2015
5-th percentile2016
Q12017
median2018
Q32019
95-th percentile2022
Maximum2023
Range8
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.8316774
Coefficient of variation (CV)0.000907544
Kurtosis-0.014820899
Mean2018.2794
Median Absolute Deviation (MAD)1
Skewness0.48867608
Sum411729
Variance3.355042
MonotonicityNot monotonic
2023-12-12T13:23:56.297472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
2018 64
31.4%
2019 35
17.2%
2017 28
13.7%
2016 25
 
12.3%
2020 16
 
7.8%
2022 14
 
6.9%
2015 10
 
4.9%
2021 9
 
4.4%
2023 3
 
1.5%
ValueCountFrequency (%)
2015 10
 
4.9%
2016 25
 
12.3%
2017 28
13.7%
2018 64
31.4%
2019 35
17.2%
2020 16
 
7.8%
2021 9
 
4.4%
2022 14
 
6.9%
2023 3
 
1.5%
ValueCountFrequency (%)
2023 3
 
1.5%
2022 14
 
6.9%
2021 9
 
4.4%
2020 16
 
7.8%
2019 35
17.2%
2018 64
31.4%
2017 28
13.7%
2016 25
 
12.3%
2015 10
 
4.9%

설 치 위 치
Text

Distinct190
Distinct (%)93.1%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2023-12-12T13:23:56.612825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length17
Mean length13.495098
Min length9

Characters and Unicode

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

Unique

Unique180 ?
Unique (%)88.2%

Sample

1st row예산읍 주교리 337-5
2nd row삽교읍 두리 575-55
3rd row삽교읍 신가리 266-46
4th row삽교읍 평촌리 148-1
5th row대술면 마전리 750-57
ValueCountFrequency (%)
예산읍 37
 
6.2%
삽교읍 30
 
5.0%
광시면 22
 
3.7%
신양면 18
 
3.0%
고덕면 17
 
2.9%
대술면 15
 
2.5%
응봉면 12
 
2.0%
덕산면 12
 
2.0%
대흥면 11
 
1.8%
예산군 9
 
1.5%
Other values (332) 412
69.2%
2023-12-12T13:23:57.146062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
393
 
14.3%
리 160
 
5.8%
1 131
 
4.8%
면 116
 
4.2%
- 116
 
4.2%
3 106
 
3.9%
2 101
 
3.7%
산 81
 
2.9%
5 71
 
2.6%
읍 67
 
2.4%
Other values (151) 1411
51.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1442
52.4%
Decimal Number 742
27.0%
Space Separator 393
 
14.3%
Dash Punctuation 116
 
4.2%
Open Punctuation 29
 
1.1%
Close Punctuation 29
 
1.1%
Uppercase Letter 1
 
< 0.1%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
리 160
 
11.1%
면 116
 
8.0%
산 81
 
5.6%
읍 67
 
4.6%
신 51
 
3.5%
예 51
 
3.5%
길 50
 
3.5%
대 36
 
2.5%
천 35
 
2.4%
교 35
 
2.4%
Other values (135) 760
52.7%
Decimal Number
ValueCountFrequency (%)
1 131
17.7%
3 106
14.3%
2 101
13.6%
5 71
9.6%
7 66
8.9%
6 65
8.8%
8 63
8.5%
4 61
8.2%
0 41
 
5.5%
9 37
 
5.0%
Space Separator
ValueCountFrequency (%)
393
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 116
100.0%
Open Punctuation
ValueCountFrequency (%)
( 29
100.0%
Close Punctuation
ValueCountFrequency (%)
) 29
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1442
52.4%
Common 1310
47.6%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
리 160
 
11.1%
면 116
 
8.0%
산 81
 
5.6%
읍 67
 
4.6%
신 51
 
3.5%
예 51
 
3.5%
길 50
 
3.5%
대 36
 
2.5%
천 35
 
2.4%
교 35
 
2.4%
Other values (135) 760
52.7%
Common
ValueCountFrequency (%)
393
30.0%
1 131
 
10.0%
- 116
 
8.9%
3 106
 
8.1%
2 101
 
7.7%
5 71
 
5.4%
7 66
 
5.0%
6 65
 
5.0%
8 63
 
4.8%
4 61
 
4.7%
Other values (5) 137
 
10.5%
Latin
ValueCountFrequency (%)
A 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1442
52.4%
ASCII 1311
47.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
393
30.0%
1 131
 
10.0%
- 116
 
8.8%
3 106
 
8.1%
2 101
 
7.7%
5 71
 
5.4%
7 66
 
5.0%
6 65
 
5.0%
8 63
 
4.8%
4 61
 
4.7%
Other values (6) 138
 
10.5%
Hangul
ValueCountFrequency (%)
리 160
 
11.1%
면 116
 
8.0%
산 81
 
5.6%
읍 67
 
4.6%
신 51
 
3.5%
예 51
 
3.5%
길 50
 
3.5%
대 36
 
2.5%
천 35
 
2.4%
교 35
 
2.4%
Other values (135) 760
52.7%

기구종류
Text

Distinct179
Distinct (%)87.7%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2023-12-12T13:23:57.432797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length64
Median length37.5
Mean length25.676471
Min length3

Characters and Unicode

Total characters5238
Distinct characters141
Distinct categories6 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique161 ?
Unique (%)78.9%

Sample

1st row입식사이클 역기올리기 좌식사이클 달리기 등허리지압
2nd row허리돌리기 숄더휠 에어워커
3rd row허리돌리기 숄더휠 에어워커
4th row허리돌리기 숄더휠 에어워커
5th row허리돌리기 롤링머신 하늘걷기 어깨돌리기
ValueCountFrequency (%)
허리돌리기 103
 
11.7%
하늘걷기 60
 
6.8%
달리기 51
 
5.8%
물결타기 47
 
5.4%
상체근육풀기 47
 
5.4%
오금펴기 39
 
4.4%
싸이클 31
 
3.5%
역기올리기 30
 
3.4%
공중걷기 28
 
3.2%
어깨근육풀기 26
 
3.0%
Other values (131) 415
47.3%
2023-12-12T13:23:57.970976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
987
18.8%
기 750
 
14.3%
리 437
 
8.3%
허 145
 
2.8%
돌 145
 
2.8%
풀 103
 
2.0%
어 100
 
1.9%
걷 100
 
1.9%
육 92
 
1.8%
근 91
 
1.7%
Other values (131) 2288
43.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4202
80.2%
Space Separator 987
 
18.8%
Other Punctuation 36
 
0.7%
Open Punctuation 5
 
0.1%
Close Punctuation 5
 
0.1%
Decimal Number 3
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 750
 
17.8%
리 437
 
10.4%
허 145
 
3.5%
돌 145
 
3.5%
풀 103
 
2.5%
어 100
 
2.4%
걷 100
 
2.4%
육 92
 
2.2%
근 91
 
2.2%
하 83
 
2.0%
Other values (126) 2156
51.3%
Space Separator
ValueCountFrequency (%)
987
100.0%
Other Punctuation
ValueCountFrequency (%)
· 36
100.0%
Open Punctuation
ValueCountFrequency (%)
( 5
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5
100.0%
Decimal Number
ValueCountFrequency (%)
2 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4202
80.2%
Common 1036
 
19.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 750
 
17.8%
리 437
 
10.4%
허 145
 
3.5%
돌 145
 
3.5%
풀 103
 
2.5%
어 100
 
2.4%
걷 100
 
2.4%
육 92
 
2.2%
근 91
 
2.2%
하 83
 
2.0%
Other values (126) 2156
51.3%
Common
ValueCountFrequency (%)
987
95.3%
· 36
 
3.5%
( 5
 
0.5%
) 5
 
0.5%
2 3
 
0.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4202
80.2%
ASCII 1000
 
19.1%
None 36
 
0.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
987
98.7%
( 5
 
0.5%
) 5
 
0.5%
2 3
 
0.3%
Hangul
ValueCountFrequency (%)
기 750
 
17.8%
리 437
 
10.4%
허 145
 
3.5%
돌 145
 
3.5%
풀 103
 
2.5%
어 100
 
2.4%
걷 100
 
2.4%
육 92
 
2.2%
근 91
 
2.2%
하 83
 
2.0%
Other values (126) 2156
51.3%
None
ValueCountFrequency (%)
· 36
100.0%

수 량
Real number (ℝ)

HIGH CORRELATION 

Distinct8
Distinct (%)3.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.2107843
Minimum1
Maximum10
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-12T13:23:58.143573image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median3
Q34
95-th percentile6
Maximum10
Range9
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.349943
Coefficient of variation (CV)0.42044027
Kurtosis3.0629016
Mean3.2107843
Median Absolute Deviation (MAD)1
Skewness1.0417846
Sum655
Variance1.8223462
MonotonicityNot monotonic
2023-12-12T13:23:58.287033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
3 77
37.7%
4 46
22.5%
2 39
19.1%
1 17
 
8.3%
6 12
 
5.9%
5 11
 
5.4%
8 1
 
0.5%
10 1
 
0.5%
ValueCountFrequency (%)
1 17
 
8.3%
2 39
19.1%
3 77
37.7%
4 46
22.5%
5 11
 
5.4%
6 12
 
5.9%
8 1
 
0.5%
10 1
 
0.5%
ValueCountFrequency (%)
10 1
 
0.5%
8 1
 
0.5%
6 12
 
5.9%
5 11
 
5.4%
4 46
22.5%
3 77
37.7%
2 39
19.1%
1 17
 
8.3%

설치업체
Categorical

HIGH CORRELATION 

Distinct22
Distinct (%)10.8%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
명성이앤비
86 
명성이앤비㈜
71 
아이세상
 
7
이랜드체육조경㈜
 
5
㈜한울조경
 
4
Other values (17)
31 

Length

Max length9
Median length8
Mean length5.5343137
Min length4

Unique

Unique9 ?
Unique (%)4.4%

Sample

1st row명성이앤비
2nd row명성이앤비
3rd row명성이앤비
4th row명성이앤비
5th row명성이앤비

Common Values

ValueCountFrequency (%)
명성이앤비 86
42.2%
명성이앤비㈜ 71
34.8%
아이세상 7
 
3.4%
이랜드체육조경㈜ 5
 
2.5%
㈜한울조경 4
 
2.0%
㈜디자인파크개발 4
 
2.0%
세민조경 4
 
2.0%
스포츠클릭 4
 
2.0%
한국조경건설㈜ 2
 
1.0%
금보인터내셔널 2
 
1.0%
Other values (12) 15
 
7.4%

Length

2023-12-12T13:23:58.459611image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
명성이앤비 86
42.2%
명성이앤비㈜ 71
34.8%
아이세상 7
 
3.4%
이랜드체육조경㈜ 5
 
2.5%
㈜한울조경 4
 
2.0%
㈜디자인파크개발 4
 
2.0%
세민조경 4
 
2.0%
스포츠클릭 4
 
2.0%
㈜대한조경공사 2
 
1.0%
㈜그린나래 2
 
1.0%
Other values (12) 15
 
7.4%

관리부서
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
예산읍
35 
오가면
22 
광시면
22 
삽교읍
21 
신양면
18 
Other values (12)
86 

Length

Max length7
Median length3
Mean length3.245098
Min length3

Unique

Unique2 ?
Unique (%)1.0%

Sample

1st row예산읍
2nd row삽교읍
3rd row삽교읍
4th row삽교읍
5th row대술면

Common Values

ValueCountFrequency (%)
예산읍 35
17.2%
오가면 22
10.8%
광시면 22
10.8%
삽교읍 21
10.3%
신양면 18
8.8%
고덕면 15
7.4%
대술면 14
 
6.9%
응봉면 13
 
6.4%
덕산면 11
 
5.4%
내포문화사업소 8
 
3.9%
Other values (7) 25
12.3%

Length

2023-12-12T13:23:58.671603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
예산읍 35
17.2%
오가면 22
10.8%
광시면 22
10.8%
삽교읍 21
10.3%
신양면 18
8.8%
고덕면 15
7.4%
대술면 14
 
6.9%
응봉면 13
 
6.4%
덕산면 11
 
5.4%
내포문화사업소 8
 
3.9%
Other values (7) 25
12.3%

비고
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct4
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
<NA>
189 
건설교통과
 
5
관광시설
 
5
교육체육과
 
5

Length

Max length5
Median length4
Mean length4.0490196
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 189
92.6%
건설교통과 5
 
2.5%
관광시설 5
 
2.5%
교육체육과 5
 
2.5%

Length

2023-12-12T13:23:58.830797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:23:58.964600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 189
92.6%
건설교통과 5
 
2.5%
관광시설 5
 
2.5%
교육체육과 5
 
2.5%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2023-09-27
204 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-09-27
2nd row2023-09-27
3rd row2023-09-27
4th row2023-09-27
5th row2023-09-27

Common Values

ValueCountFrequency (%)
2023-09-27 204
100.0%

Length

2023-12-12T13:23:59.096170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:23:59.259616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-09-27 204
100.0%

Interactions

2023-12-12T13:23:55.193316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:23:54.945971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:23:55.320900image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:23:55.091597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T13:23:59.347682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치년도수 량설치업체관리부서비고
설치년도1.0000.4680.5440.5860.598
수 량0.4681.0000.5770.6770.800
설치업체0.5440.5771.0000.8871.000
관리부서0.5860.6770.8871.0000.739
비고0.5980.8001.0000.7391.000
2023-12-12T13:23:59.507641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
비고설치업체관리부서
비고1.0000.8660.527
설치업체0.8661.0000.501
관리부서0.5270.5011.000
2023-12-12T13:23:59.630053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치년도수 량설치업체관리부서비고
설치년도1.000-0.0230.2450.2690.577
수 량-0.0231.0000.2670.3540.744
설치업체0.2450.2671.0000.5010.866
관리부서0.2690.3540.5011.0000.527
비고0.5770.7440.8660.5271.000

Missing values

2023-12-12T13:23:55.487128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T13:23:56.000721image/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

설치년도설 치 위 치기구종류수 량설치업체관리부서비고데이터기준일자
02015예산읍 주교리 337-5입식사이클 역기올리기 좌식사이클 달리기 등허리지압4명성이앤비예산읍<NA>2023-09-27
12015삽교읍 두리 575-55허리돌리기 숄더휠 에어워커4명성이앤비삽교읍<NA>2023-09-27
22015삽교읍 신가리 266-46허리돌리기 숄더휠 에어워커5명성이앤비삽교읍<NA>2023-09-27
32015삽교읍 평촌리 148-1허리돌리기 숄더휠 에어워커3명성이앤비삽교읍<NA>2023-09-27
42015대술면 마전리 750-57허리돌리기 롤링머신 하늘걷기 어깨돌리기4명성이앤비대술면<NA>2023-09-27
52015신양면 신양리 554-3트위스트머신 가슴강화기 싸이클런 옥외용벤치4명성이앤비신양면<NA>2023-09-27
62015광시면 광시리 48달리기운동 다리뻗치기 윗몸일으키기3제일휘트니스광시면<NA>2023-09-27
72015대흥면 탄방리 83허리돌리기 하이풀리 크로스컬츄리3명성이앤비㈜대흥면<NA>2023-09-27
82015대흥면 손지리 869-2체스트프레스 하이풀리 등허리지압 공중걷기 온몸노젖기3㈜홍디자인대흥면<NA>2023-09-27
92015고덕면 호음리 628허리강화기 마사지기 숄더휠 체어풀4명성이앤비고덕면<NA>2023-09-27
설치년도설 치 위 치기구종류수 량설치업체관리부서비고데이터기준일자
1942021광시면 노전리 687-1하늘걷기 윗몸일으키기 자전거 오금펴기 역기올리기4명성이앤비㈜광시면<NA>2023-09-27
1952021광시면 장전리 296-6상체근육풀기 허리돌리기 자전거 오금펴기2아이세상광시면<NA>2023-09-27
1962021광시면 관음리 263공중걷기 작은활차 오금펴기 달리기2명성이앤비㈜광시면<NA>2023-09-27
1972022광시면 광시리 221상체근육풀기 어깨근육풀기 자전거 오금펴기 허리돌리기6명성이앤비㈜광시면<NA>2023-09-27
1982022광시면 운산리 336하늘걷기 물결타기 자전거 오금펴기 양팔줄당기기 허리돌리기4명성이앤비㈜광시면<NA>2023-09-27
1992022광시면 용두리 286상체근육풀기 어깨풀기 자전거 등지압기 물결타기 오금펴기3명성이앤비㈜광시면<NA>2023-09-27
2002022대흥면 대률리 262-3하늘걷기 물결타기 역기올리기3세민조경대흥면<NA>2023-09-27
2012021응봉면 원골길 1어깨유연성운동 싸이클 허리돌리기3명성이앤비㈜응봉면<NA>2023-09-27
2022022응봉면 예당로 1702-5윗몸일으키기 상체근육풀기 물결타기 허리돌리기2명성이앤비㈜응봉면<NA>2023-09-27
2032021덕산면 둔리 405-4허리돌리기 등지압기 철봉 레그프레스 달리기 큰활차 공중걷기6명성이앤비㈜응봉면<NA>2023-09-27