Overview

Dataset statistics

Number of variables7
Number of observations246
Missing cells245
Missing cells (%)14.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory13.8 KiB
Average record size in memory57.5 B

Variable types

Categorical3
Numeric1
Text3

Dataset

Description본 데이터는 충청남도 금산군 야외(실외)운동기구(설치주소, 기구, 담당부서, 설치업체, 고장현황 등) 안내입니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=423&beforeMenuCd=DOM_000000201001001000&publicdatapk=15037910

Alerts

고장현황 has constant value ""Constant
데이터기준일자 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
고장현황 has 245 (99.6%) missing valuesMissing

Reproduction

Analysis started2024-01-09 19:56:45.719967
Analysis finished2024-01-09 19:56:46.537055
Duration0.82 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

담당부서
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)4.1%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
부리면
50 
금성면
48 
남이면
37 
금산읍
35 
진산면
29 
Other values (5)
47 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row금산읍
2nd row금산읍
3rd row금산읍
4th row금산읍
5th row금산읍

Common Values

ValueCountFrequency (%)
부리면 50
20.3%
금성면 48
19.5%
남이면 37
15.0%
금산읍 35
14.2%
진산면 29
11.8%
복수면 20
 
8.1%
남일면 12
 
4.9%
추부면 8
 
3.3%
제원면 4
 
1.6%
군북면 3
 
1.2%

Length

2024-01-10T04:56:46.632978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T04:56:46.820148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
부리면 50
20.3%
금성면 48
19.5%
남이면 37
15.0%
금산읍 35
14.2%
진산면 29
11.8%
복수면 20
 
8.1%
남일면 12
 
4.9%
추부면 8
 
3.3%
제원면 4
 
1.6%
군북면 3
 
1.2%

설치년도
Real number (ℝ)

HIGH CORRELATION 

Distinct6
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2017.687
Minimum2015
Maximum2020
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.3 KiB
2024-01-10T04:56:47.009124image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2015
5-th percentile2015
Q12016
median2018
Q32019
95-th percentile2020
Maximum2020
Range5
Interquartile range (IQR)3

Descriptive statistics

Standard deviation1.7853124
Coefficient of variation (CV)0.00088483119
Kurtosis-1.3369451
Mean2017.687
Median Absolute Deviation (MAD)2
Skewness-0.21852078
Sum496351
Variance3.1873403
MonotonicityNot monotonic
2024-01-10T04:56:47.184761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
2019 51
20.7%
2020 49
19.9%
2015 44
17.9%
2018 42
17.1%
2016 34
13.8%
2017 26
10.6%
ValueCountFrequency (%)
2015 44
17.9%
2016 34
13.8%
2017 26
10.6%
2018 42
17.1%
2019 51
20.7%
2020 49
19.9%
ValueCountFrequency (%)
2020 49
19.9%
2019 51
20.7%
2018 42
17.1%
2017 26
10.6%
2016 34
13.8%
2015 44
17.9%

설치기구종류
Text

Distinct111
Distinct (%)45.1%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
2024-01-10T04:56:47.474170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length72
Median length52.5
Mean length14.5
Min length3

Characters and Unicode

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

Unique

Unique85 ?
Unique (%)34.6%

Sample

1st row달리기운동/큰활차머신, 공중걷기/허리돌리기
2nd row자전거타기,달리기/큰활차머신,공중걷기/파도타기,허리돌리기/윗몸일으키기
3rd row달리기/큰활차머신,역기내리기/작은활차머신,파도타기/공중걷기,허리돌리기/윗몸일으키기
4th row달리기/큰활차머신,파도타기/공중걷기,다리뻗치기/등허리지압,허리돌리기/윗몸일으키기
5th row자전거타기/허리돌리기, 계단걷기/큰활차머신, 다리뻗치기/공중걷기, 양팔줄당기기/옆파도타기
ValueCountFrequency (%)
공중걷기 58
 
13.1%
허리돌리기 41
 
9.2%
파도타기 34
 
7.7%
달리기 28
 
6.3%
상체근육풀기 25
 
5.6%
자전거타기 19
 
4.3%
등허리지압기 14
 
3.2%
오금펴기 10
 
2.3%
어깨근육풀기 9
 
2.0%
윗몸일으키기 8
 
1.8%
Other values (115) 198
44.6%
2024-01-10T04:56:48.029118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
기 579
 
16.2%
리 315
 
8.8%
, 241
 
6.8%
198
 
5.6%
허 106
 
3.0%
타 99
 
2.8%
걷 99
 
2.8%
/ 93
 
2.6%
돌 92
 
2.6%
공 90
 
2.5%
Other values (126) 1655
46.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2995
84.0%
Other Punctuation 348
 
9.8%
Space Separator 198
 
5.6%
Math Symbol 23
 
0.6%
Close Punctuation 1
 
< 0.1%
Open Punctuation 1
 
< 0.1%
Decimal Number 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 579
19.3%
리 315
 
10.5%
허 106
 
3.5%
타 99
 
3.3%
걷 99
 
3.3%
돌 92
 
3.1%
공 90
 
3.0%
중 90
 
3.0%
파 71
 
2.4%
달 65
 
2.2%
Other values (117) 1389
46.4%
Other Punctuation
ValueCountFrequency (%)
, 241
69.3%
/ 93
 
26.7%
& 12
 
3.4%
· 2
 
0.6%
Space Separator
ValueCountFrequency (%)
198
100.0%
Math Symbol
ValueCountFrequency (%)
+ 23
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Decimal Number
ValueCountFrequency (%)
2 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2995
84.0%
Common 572
 
16.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 579
19.3%
리 315
 
10.5%
허 106
 
3.5%
타 99
 
3.3%
걷 99
 
3.3%
돌 92
 
3.1%
공 90
 
3.0%
중 90
 
3.0%
파 71
 
2.4%
달 65
 
2.2%
Other values (117) 1389
46.4%
Common
ValueCountFrequency (%)
, 241
42.1%
198
34.6%
/ 93
 
16.3%
+ 23
 
4.0%
& 12
 
2.1%
· 2
 
0.3%
) 1
 
0.2%
( 1
 
0.2%
2 1
 
0.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2995
84.0%
ASCII 570
 
16.0%
None 2
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
기 579
19.3%
리 315
 
10.5%
허 106
 
3.5%
타 99
 
3.3%
걷 99
 
3.3%
돌 92
 
3.1%
공 90
 
3.0%
중 90
 
3.0%
파 71
 
2.4%
달 65
 
2.2%
Other values (117) 1389
46.4%
ASCII
ValueCountFrequency (%)
, 241
42.3%
198
34.7%
/ 93
 
16.3%
+ 23
 
4.0%
& 12
 
2.1%
) 1
 
0.2%
( 1
 
0.2%
2 1
 
0.2%
None
ValueCountFrequency (%)
· 2
100.0%

설치주소
Text

Distinct144
Distinct (%)58.5%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
2024-01-10T04:56:48.461229image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length28
Mean length20.96748
Min length6

Characters and Unicode

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

Unique

Unique106 ?
Unique (%)43.1%

Sample

1st row충청남도 금산군 금산읍 상리 31-10
2nd row충청남도 금산군 금산읍 양지리 307
3rd row충청남도 금산군 금산읍 상옥리 326-15
4th row충청남도 금산군 금산읍 상옥리 339-13
5th row충청남도 금산군 금산읍 상옥리 124-1
ValueCountFrequency (%)
충청남도 233
19.8%
금산군 205
17.4%
부리면 50
 
4.2%
금성면 48
 
4.1%
남이면 37
 
3.1%
금산읍 35
 
3.0%
복수면 18
 
1.5%
진산면 16
 
1.4%
남일면 12
 
1.0%
방우리 12
 
1.0%
Other values (240) 512
43.5%
2024-01-10T04:56:49.098483image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1012
19.6%
금 302
 
5.9%
남 284
 
5.5%
산 267
 
5.2%
도 245
 
4.7%
리 244
 
4.7%
충 233
 
4.5%
청 233
 
4.5%
군 208
 
4.0%
면 196
 
3.8%
Other values (131) 1934
37.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3058
59.3%
Space Separator 1012
 
19.6%
Decimal Number 912
 
17.7%
Dash Punctuation 151
 
2.9%
Close Punctuation 10
 
0.2%
Open Punctuation 10
 
0.2%
Other Punctuation 5
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
금 302
 
9.9%
남 284
 
9.3%
산 267
 
8.7%
도 245
 
8.0%
리 244
 
8.0%
충 233
 
7.6%
청 233
 
7.6%
군 208
 
6.8%
면 196
 
6.4%
부 59
 
1.9%
Other values (116) 787
25.7%
Decimal Number
ValueCountFrequency (%)
1 170
18.6%
3 137
15.0%
2 128
14.0%
6 94
10.3%
5 92
10.1%
4 86
9.4%
9 69
7.6%
7 56
 
6.1%
8 48
 
5.3%
0 32
 
3.5%
Space Separator
ValueCountFrequency (%)
1012
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 151
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Other Punctuation
ValueCountFrequency (%)
, 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3058
59.3%
Common 2100
40.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
금 302
 
9.9%
남 284
 
9.3%
산 267
 
8.7%
도 245
 
8.0%
리 244
 
8.0%
충 233
 
7.6%
청 233
 
7.6%
군 208
 
6.8%
면 196
 
6.4%
부 59
 
1.9%
Other values (116) 787
25.7%
Common
ValueCountFrequency (%)
1012
48.2%
1 170
 
8.1%
- 151
 
7.2%
3 137
 
6.5%
2 128
 
6.1%
6 94
 
4.5%
5 92
 
4.4%
4 86
 
4.1%
9 69
 
3.3%
7 56
 
2.7%
Other values (5) 105
 
5.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3058
59.3%
ASCII 2100
40.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1012
48.2%
1 170
 
8.1%
- 151
 
7.2%
3 137
 
6.5%
2 128
 
6.1%
6 94
 
4.5%
5 92
 
4.4%
4 86
 
4.1%
9 69
 
3.3%
7 56
 
2.7%
Other values (5) 105
 
5.0%
Hangul
ValueCountFrequency (%)
금 302
 
9.9%
남 284
 
9.3%
산 267
 
8.7%
도 245
 
8.0%
리 244
 
8.0%
충 233
 
7.6%
청 233
 
7.6%
군 208
 
6.8%
면 196
 
6.4%
부 59
 
1.9%
Other values (116) 787
25.7%

설치업체
Categorical

HIGH CORRELATION 

Distinct28
Distinct (%)11.4%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
가인조경
38 
호진기계
33 
대전지방조달청
30 
한양그린파크
19 
우리스포츠
15 
Other values (23)
111 

Length

Max length11
Median length9
Mean length5.4105691
Min length3

Unique

Unique6 ?
Unique (%)2.4%

Sample

1st row우리스포츠
2nd row호진기계
3rd row호진기계
4th row호진기계
5th row우리스포츠

Common Values

ValueCountFrequency (%)
가인조경 38
15.4%
호진기계 33
13.4%
대전지방조달청 30
12.2%
한양그린파크 19
 
7.7%
우리스포츠 15
 
6.1%
<NA> 14
 
5.7%
어반스케이프 10
 
4.1%
금산훤수조경공사 9
 
3.7%
㈜그린나래 8
 
3.3%
(합)어반스케이프 7
 
2.8%
Other values (18) 63
25.6%

Length

2024-01-10T04:56:49.293569image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
가인조경 38
14.7%
호진기계 36
13.9%
대전지방조달청 30
11.6%
한양그린파크 26
10.0%
우리스포츠 15
 
5.8%
na 14
 
5.4%
어반스케이프 10
 
3.9%
주식회사 10
 
3.9%
금산훤수조경공사 9
 
3.5%
㈜그린나래 8
 
3.1%
Other values (18) 63
24.3%

고장현황
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing245
Missing (%)99.6%
Memory size2.1 KiB
2024-01-10T04:56:49.490338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length7
Mean length7
Min length7

Characters and Unicode

Total characters7
Distinct characters7
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)100.0%

Sample

1st row비가림시설누수
ValueCountFrequency (%)
비가림시설누수 1
100.0%
2024-01-10T04:56:49.829338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
비 1
14.3%
가 1
14.3%
림 1
14.3%
시 1
14.3%
설 1
14.3%
누 1
14.3%
수 1
14.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
비 1
14.3%
가 1
14.3%
림 1
14.3%
시 1
14.3%
설 1
14.3%
누 1
14.3%
수 1
14.3%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
비 1
14.3%
가 1
14.3%
림 1
14.3%
시 1
14.3%
설 1
14.3%
누 1
14.3%
수 1
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
비 1
14.3%
가 1
14.3%
림 1
14.3%
시 1
14.3%
설 1
14.3%
누 1
14.3%
수 1
14.3%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
2022-08-08
246 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-08-08
2nd row2022-08-08
3rd row2022-08-08
4th row2022-08-08
5th row2022-08-08

Common Values

ValueCountFrequency (%)
2022-08-08 246
100.0%

Length

2024-01-10T04:56:50.013996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T04:56:50.144588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-08-08 246
100.0%

Interactions

2024-01-10T04:56:46.105440image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T04:56:50.230571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
담당부서설치년도설치업체
담당부서1.0000.8110.940
설치년도0.8111.0000.963
설치업체0.9400.9631.000
2024-01-10T04:56:50.373810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치업체담당부서
설치업체1.0000.688
담당부서0.6881.000
2024-01-10T04:56:50.514352image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치년도담당부서설치업체
설치년도1.0000.4280.760
담당부서0.4281.0000.688
설치업체0.7600.6881.000

Missing values

2024-01-10T04:56:46.271172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T04:56:46.457684image/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

담당부서설치년도설치기구종류설치주소설치업체고장현황데이터기준일자
0금산읍2016달리기운동/큰활차머신, 공중걷기/허리돌리기충청남도 금산군 금산읍 상리 31-10우리스포츠<NA>2022-08-08
1금산읍2016자전거타기,달리기/큰활차머신,공중걷기/파도타기,허리돌리기/윗몸일으키기충청남도 금산군 금산읍 양지리 307호진기계<NA>2022-08-08
2금산읍2016달리기/큰활차머신,역기내리기/작은활차머신,파도타기/공중걷기,허리돌리기/윗몸일으키기충청남도 금산군 금산읍 상옥리 326-15호진기계비가림시설누수2022-08-08
3금산읍2016달리기/큰활차머신,파도타기/공중걷기,다리뻗치기/등허리지압,허리돌리기/윗몸일으키기충청남도 금산군 금산읍 상옥리 339-13호진기계<NA>2022-08-08
4금산읍2016자전거타기/허리돌리기, 계단걷기/큰활차머신, 다리뻗치기/공중걷기, 양팔줄당기기/옆파도타기충청남도 금산군 금산읍 상옥리 124-1우리스포츠<NA>2022-08-08
5금산읍2016허리돌리기,양팔줄당기기,파도타기,자전거타기충청남도 금산군 금산읍 비단로 338(주공206동 놀이터 옆)호진기계<NA>2022-08-08
6금산읍2016자전거타기,달리기운동/큰활차머신,공중걷기/허리돌리기,역기내리기/작은활차머신,다리뻗치기/등허리지압기충청남도 금산군 금산읍 비호산로 5(주공1단지 내)호진기계<NA>2022-08-08
7금산읍2017자전거타기, 윗몸일으키기/허리돌리기, 역기내리기/역기올리기충청남도 금산군 금산읍 하옥리 309-14호진기계<NA>2022-08-08
8금산읍2017자전거타기, 달리기운동/큰활차머신, 공중걷기/허리돌리기충청남도 금산군 금산읍 아인리 50-3호진기계<NA>2022-08-08
9금산읍2017달리기운동/큰활차머신, 파도타기/공중걷기, 등허리지압기, 허리돌리기/윗몸일으키기,트렁크로라충청남도 금산군 금산읍 중도리 74-1호진기계<NA>2022-08-08
담당부서설치년도설치기구종류설치주소설치업체고장현황데이터기준일자
236복수면2020공중걷기, 상체근육풀기, 달리기, 다리뻗히기, 등허리지압기, 자전거타기충청남도 금산군 복수면 지량리 492-12하나조경<NA>2022-08-08
237복수면2020역기올리기, 달리기, 자전거타기, 큰활차충청남도 금산군 복수면 용진리 627번지대륙체육산업<NA>2022-08-08
238추부면2016허리돌리기,윗몸일으키기,옆으로몸통흔들기, 앉아자전거타기충청남도 금산군 추부면 성당1리 435-4에스엠뷰텍<NA>2022-08-08
239추부면2016바디싣업, 푸시웨이트,턴오버스트레칭충청남도 금산군 추부면 마전3리407그린나래<NA>2022-08-08
240추부면2017윗몸일으키기,등허리지압기,마라톤운동,온몸근육풀기, 하늘걷기, 옆파도타기, 온몸허리돌리기충청남도 금산군 추부면 마전리 564-6HARU<NA>2022-08-08
241추부면2018어깨근육풀기, 거꾸로매달리기충청남도 금산군 추부면 마전2리 우수저류시설가인조경<NA>2022-08-08
242추부면2018상체근육풀기, 거꾸로매달리기, 달리기충청남도 금산군 추부면 마전리 96-92가인조경<NA>2022-08-08
243추부면2019앉아서자전거타기, 공중걷기, 달리기, 입식허리돌리기, 옆으로 몸통흔들기, 큰팔돌리기충청남도 금산군 추부면 장대2리 210-1(숭암로 325)가인조경<NA>2022-08-08
244추부면2019허리돌리기충청남도 금산군 추부면 신평2리(신탑)대산체육산업<NA>2022-08-08
245추부면2019낮아서자전거타기, 옆으로 몸통흔들기충청남도 금산군 추부면서대1리가인조경<NA>2022-08-08