Overview

Dataset statistics

Number of variables7
Number of observations218
Missing cells217
Missing cells (%)14.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory12.3 KiB
Average record size in memory57.6 B

Variable types

Categorical3
Text3
DateTime1

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 217 (99.5%) missing valuesMissing

Reproduction

Analysis started2024-01-09 19:56:56.020598
Analysis finished2024-01-09 19:56:56.758220
Duration0.74 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

담당부서
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)4.6%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
부리면
50 
금성면
48 
남이면
37 
금산읍
34 
진산면
16 
Other values (5)
33 

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
22.9%
금성면 48
22.0%
남이면 37
17.0%
금산읍 34
15.6%
진산면 16
 
7.3%
남일면 12
 
5.5%
복수면 8
 
3.7%
추부면 7
 
3.2%
제원면 4
 
1.8%
군북면 2
 
0.9%

Length

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

Common Values (Plot)

2024-01-10T04:56:57.032231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
부리면 50
22.9%
금성면 48
22.0%
남이면 37
17.0%
금산읍 34
15.6%
진산면 16
 
7.3%
남일면 12
 
5.5%
복수면 8
 
3.7%
추부면 7
 
3.2%
제원면 4
 
1.8%
군북면 2
 
0.9%

설치년도
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2019
70 
2018
42 
2016
38 
2017
37 
2015
31 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2016
2nd row2016
3rd row2016
4th row2016
5th row2016

Common Values

ValueCountFrequency (%)
2019 70
32.1%
2018 42
19.3%
2016 38
17.4%
2017 37
17.0%
2015 31
14.2%

Length

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

Common Values (Plot)

2024-01-10T04:56:57.835104image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2019 70
32.1%
2018 42
19.3%
2016 38
17.4%
2017 37
17.0%
2015 31
14.2%

설치기구종류
Text

Distinct88
Distinct (%)40.4%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2024-01-10T04:56:58.078180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length72
Median length54
Mean length12.995413
Min length3

Characters and Unicode

Total characters2833
Distinct characters129
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

Unique63 ?
Unique (%)28.9%

Sample

1st row달리기운동/큰활차머신, 공중걷기/허리돌리기
2nd row자전거타기,달리기/큰활차머신,공중걷기/파도타기,허리돌리기/윗몸일으키기
3rd row달리기/큰활차머신,역기내리기/작은활차머신,파도타기/공중걷기,허리돌리기/윗몸일으키기
4th row달리기/큰활차머신,파도타기/공중걷기,다리뻗치기/등허리지압,허리돌리기/윗몸일으키기
5th row자전거타기/허리돌리기, 계단걷기/큰활차머신, 다리뻗치기/공중걷기, 양팔줄당기기/옆파도타기
ValueCountFrequency (%)
공중걷기 45
 
13.2%
허리돌리기 36
 
10.5%
달리기 20
 
5.8%
파도타기 20
 
5.8%
등허리지압기 14
 
4.1%
자전거타기 11
 
3.2%
상체근육풀기 10
 
2.9%
어깨근육풀기 9
 
2.6%
윗몸일으키기 8
 
2.3%
달리기운동/큰활차머신 7
 
2.0%
Other values (92) 162
47.4%
2024-01-10T04:56:58.605640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
기 455
 
16.1%
리 277
 
9.8%
, 163
 
5.8%
124
 
4.4%
허 98
 
3.5%
돌 91
 
3.2%
/ 90
 
3.2%
걷 79
 
2.8%
공 70
 
2.5%
중 70
 
2.5%
Other values (119) 1316
46.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2434
85.9%
Other Punctuation 264
 
9.3%
Space Separator 124
 
4.4%
Math Symbol 8
 
0.3%
Decimal Number 1
 
< 0.1%
Open Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 455
18.7%
리 277
 
11.4%
허 98
 
4.0%
돌 91
 
3.7%
걷 79
 
3.2%
공 70
 
2.9%
중 70
 
2.9%
타 68
 
2.8%
달 53
 
2.2%
파 50
 
2.1%
Other values (110) 1123
46.1%
Other Punctuation
ValueCountFrequency (%)
, 163
61.7%
/ 90
34.1%
& 9
 
3.4%
· 2
 
0.8%
Space Separator
ValueCountFrequency (%)
124
100.0%
Math Symbol
ValueCountFrequency (%)
+ 8
100.0%
Decimal Number
ValueCountFrequency (%)
2 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2434
85.9%
Common 399
 
14.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 455
18.7%
리 277
 
11.4%
허 98
 
4.0%
돌 91
 
3.7%
걷 79
 
3.2%
공 70
 
2.9%
중 70
 
2.9%
타 68
 
2.8%
달 53
 
2.2%
파 50
 
2.1%
Other values (110) 1123
46.1%
Common
ValueCountFrequency (%)
, 163
40.9%
124
31.1%
/ 90
22.6%
& 9
 
2.3%
+ 8
 
2.0%
· 2
 
0.5%
2 1
 
0.3%
( 1
 
0.3%
) 1
 
0.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2434
85.9%
ASCII 397
 
14.0%
None 2
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
기 455
18.7%
리 277
 
11.4%
허 98
 
4.0%
돌 91
 
3.7%
걷 79
 
3.2%
공 70
 
2.9%
중 70
 
2.9%
타 68
 
2.8%
달 53
 
2.2%
파 50
 
2.1%
Other values (110) 1123
46.1%
ASCII
ValueCountFrequency (%)
, 163
41.1%
124
31.2%
/ 90
22.7%
& 9
 
2.3%
+ 8
 
2.0%
2 1
 
0.3%
( 1
 
0.3%
) 1
 
0.3%
None
ValueCountFrequency (%)
· 2
100.0%

설치주소
Text

Distinct106
Distinct (%)48.6%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2024-01-10T04:56:59.092853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length32
Mean length21.972477
Min length19

Characters and Unicode

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

Unique

Unique67 ?
Unique (%)30.7%

Sample

1st row충청남도 금산군 금산읍 상리 31-10
2nd row충청남도 금산군 금산읍 양지리 307
3rd row충청남도 금산군 금산읍 상옥리 326-15
4th row충청남도 금산군 금산읍 상옥리 339-13
5th row충청남도 금산군 금산읍 상옥리 124-1
ValueCountFrequency (%)
충청남도 218
19.9%
금산군 218
19.9%
부리면 50
 
4.6%
금성면 48
 
4.4%
남이면 37
 
3.4%
금산읍 34
 
3.1%
진산면 16
 
1.5%
화림리 15
 
1.4%
남일면 12
 
1.1%
방우리 12
 
1.1%
Other values (175) 438
39.9%
2024-01-10T04:56:59.774707image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
948
19.8%
금 314
 
6.6%
산 276
 
5.8%
남 269
 
5.6%
리 232
 
4.8%
도 229
 
4.8%
군 220
 
4.6%
청 218
 
4.6%
충 218
 
4.6%
면 184
 
3.8%
Other values (116) 1682
35.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2891
60.4%
Space Separator 948
 
19.8%
Decimal Number 800
 
16.7%
Dash Punctuation 143
 
3.0%
Close Punctuation 4
 
0.1%
Open Punctuation 4
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
금 314
10.9%
산 276
9.5%
남 269
 
9.3%
리 232
 
8.0%
도 229
 
7.9%
군 220
 
7.6%
청 218
 
7.5%
충 218
 
7.5%
면 184
 
6.4%
부 58
 
2.0%
Other values (102) 673
23.3%
Decimal Number
ValueCountFrequency (%)
1 148
18.5%
3 131
16.4%
2 118
14.8%
6 87
10.9%
5 74
9.2%
9 73
9.1%
4 68
8.5%
7 39
 
4.9%
8 36
 
4.5%
0 26
 
3.2%
Space Separator
ValueCountFrequency (%)
948
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 143
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2891
60.4%
Common 1899
39.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
금 314
10.9%
산 276
9.5%
남 269
 
9.3%
리 232
 
8.0%
도 229
 
7.9%
군 220
 
7.6%
청 218
 
7.5%
충 218
 
7.5%
면 184
 
6.4%
부 58
 
2.0%
Other values (102) 673
23.3%
Common
ValueCountFrequency (%)
948
49.9%
1 148
 
7.8%
- 143
 
7.5%
3 131
 
6.9%
2 118
 
6.2%
6 87
 
4.6%
5 74
 
3.9%
9 73
 
3.8%
4 68
 
3.6%
7 39
 
2.1%
Other values (4) 70
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2891
60.4%
ASCII 1899
39.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
948
49.9%
1 148
 
7.8%
- 143
 
7.5%
3 131
 
6.9%
2 118
 
6.2%
6 87
 
4.6%
5 74
 
3.9%
9 73
 
3.8%
4 68
 
3.6%
7 39
 
2.1%
Other values (4) 70
 
3.7%
Hangul
ValueCountFrequency (%)
금 314
10.9%
산 276
9.5%
남 269
 
9.3%
리 232
 
8.0%
도 229
 
7.9%
군 220
 
7.6%
청 218
 
7.5%
충 218
 
7.5%
면 184
 
6.4%
부 58
 
2.0%
Other values (102) 673
23.3%

설치업체
Categorical

HIGH CORRELATION 

Distinct19
Distinct (%)8.7%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
가인조경
59 
대전지방조달청
30 
호진기계
29 
금산훤수조경공사
17 
우리스포츠
15 
Other values (14)
68 

Length

Max length9
Median length8
Mean length5.2522936
Min length3

Unique

Unique3 ?
Unique (%)1.4%

Sample

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

Common Values

ValueCountFrequency (%)
가인조경 59
27.1%
대전지방조달청 30
13.8%
호진기계 29
13.3%
금산훤수조경공사 17
 
7.8%
우리스포츠 15
 
6.9%
어반스케이프 10
 
4.6%
윤조경공사 8
 
3.7%
㈜그린나래 8
 
3.7%
대산체육산업 7
 
3.2%
(합)어반스케이프 7
 
3.2%
Other values (9) 28
12.8%

Length

2024-01-10T04:57:00.003089image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
가인조경 59
27.1%
대전지방조달청 30
13.8%
호진기계 29
13.3%
금산훤수조경공사 17
 
7.8%
우리스포츠 15
 
6.9%
어반스케이프 10
 
4.6%
윤조경공사 8
 
3.7%
㈜그린나래 8
 
3.7%
광진체육사 7
 
3.2%
합)어반스케이프 7
 
3.2%
Other values (9) 28
12.8%

고장현황
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing217
Missing (%)99.5%
Memory size1.8 KiB
2024-01-10T04:57:00.204349image/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:57:00.570413image/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%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
Minimum2019-08-13 00:00:00
Maximum2019-08-13 00:00:00
2024-01-10T04:57:00.743761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T04:57:00.879759image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2024-01-10T04:57:00.992686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
담당부서설치년도설치기구종류설치업체
담당부서1.0000.7840.9530.916
설치년도0.7841.0000.7660.930
설치기구종류0.9530.7661.0000.961
설치업체0.9160.9300.9611.000
2024-01-10T04:57:01.142758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치년도담당부서설치업체
설치년도1.0000.4340.757
담당부서0.4341.0000.649
설치업체0.7570.6491.000
2024-01-10T04:57:01.294158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
담당부서설치년도설치업체
담당부서1.0000.4340.649
설치년도0.4341.0000.757
설치업체0.6490.7571.000

Missing values

2024-01-10T04:56:56.538869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T04:56:56.689035image/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>2019-08-13
1금산읍2016자전거타기,달리기/큰활차머신,공중걷기/파도타기,허리돌리기/윗몸일으키기충청남도 금산군 금산읍 양지리 307호진기계<NA>2019-08-13
2금산읍2016달리기/큰활차머신,역기내리기/작은활차머신,파도타기/공중걷기,허리돌리기/윗몸일으키기충청남도 금산군 금산읍 상옥리 326-15호진기계비가림시설누수2019-08-13
3금산읍2016달리기/큰활차머신,파도타기/공중걷기,다리뻗치기/등허리지압,허리돌리기/윗몸일으키기충청남도 금산군 금산읍 상옥리 339-13호진기계<NA>2019-08-13
4금산읍2016자전거타기/허리돌리기, 계단걷기/큰활차머신, 다리뻗치기/공중걷기, 양팔줄당기기/옆파도타기충청남도 금산군 금산읍 상옥리 124-1우리스포츠<NA>2019-08-13
5금산읍2016허리돌리기,양팔줄당기기,파도타기,자전거타기충청남도 금산군 금산읍 비단로 338(주공206동 놀이터 옆)호진기계<NA>2019-08-13
6금산읍2016자전거타기,달리기운동/큰활차머신,공중걷기/허리돌리기,역기내리기/작은활차머신,다리뻗치기/등허리지압기충청남도 금산군 금산읍 비호산로 5(주공1단지 내)호진기계<NA>2019-08-13
7금산읍2017자전거타기, 윗몸일으키기/허리돌리기, 역기내리기/역기올리기충청남도 금산군 금산읍 하옥리 309-14호진기계<NA>2019-08-13
8금산읍2017자전거타기, 달리기운동/큰활차머신, 공중걷기/허리돌리기충청남도 금산군 금산읍 아인리 50-3호진기계<NA>2019-08-13
9금산읍2017달리기운동/큰활차머신, 파도타기/공중걷기, 등허리지압기, 허리돌리기/윗몸일으키기,트렁크로라충청남도 금산군 금산읍 중도리 74-1호진기계<NA>2019-08-13
담당부서설치년도설치기구종류설치주소설치업체고장현황데이터기준일자
208복수면2019공중걷기, 허리돌리기, 어깨근육풀기, 파도타기충청남도 금산군 복수면 곡남리 76-1대산체육산업<NA>2019-08-13
209복수면2019공중걷기, 허리돌리기, 어깨근육풀기, 파도타기충청남도 금산군 복수면 곡남길 46대산체육산업<NA>2019-08-13
210진산면2016허리돌리기, 공중걷기충청남도 금산군 진산면 목골길 129-1어반스케이프<NA>2019-08-13
211추부면2016허리돌리기,윗몸일으키기,옆으로몸통흔들기, 앉아자전거타기충청남도 금산군 추부면 성당1리 435-4에스엠뷰텍<NA>2019-08-13
212추부면2016바디싣업, 푸시웨이트,턴오버스트레칭충청남도 금산군 추부면 마전3리407그린나래<NA>2019-08-13
213추부면2017윗몸일으키기,등허리지압기,마라톤운동,온몸근육풀기, 하늘걷기, 옆파도타기, 온몸허리돌리기충청남도 금산군 추부면 마전리 564-6HARU<NA>2019-08-13
214추부면2018어깨근육풀기, 거꾸로매달리기충청남도 금산군 추부면 마전2리 우수저류시설가인조경<NA>2019-08-13
215추부면2018상체근육풀기, 거꾸로매달리기, 달리기충청남도 금산군 추부면 마전리 96-92가인조경<NA>2019-08-13
216추부면2019앉아서자전거타기, 공중걷기, 달리기, 입식허리돌리기, 옆으로 몸통흔들기, 큰팔돌리기충청남도 금산군 추부면 장대2리 210-1(숭암로 325)가인조경<NA>2019-08-13
217추부면2019허리돌리기충청남도 금산군 추부면 신평2리(신탑)대산체육산업<NA>2019-08-13