Overview

Dataset statistics

Number of variables7
Number of observations1087
Missing cells115
Missing cells (%)1.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory62.8 KiB
Average record size in memory59.1 B

Variable types

Numeric2
Text2
Categorical3

Dataset

Description대구광역시 동구에 있는 야외 운동 기구 현황에 대한 데이터로 운동기구 관리부서명, 운동기구 설치장소, 설치연도, 설치운동기구종류, 기구개수 등이 포함되어 있습니다.
Author대구광역시 동구
URLhttps://www.data.go.kr/data/15101535/fileData.do

Alerts

비고 is highly overall correlated with 번호 and 2 other fieldsHigh 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 비고High correlation
개수 is highly imbalanced (73.5%)Imbalance
비고 is highly imbalanced (51.1%)Imbalance
설치연도 has 115 (10.6%) missing valuesMissing
번호 has unique valuesUnique

Reproduction

Analysis started2024-04-21 02:07:59.067829
Analysis finished2024-04-21 02:08:01.846707
Duration2.78 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct1087
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean544
Minimum1
Maximum1087
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size9.7 KiB
2024-04-21T11:08:01.947440image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile55.3
Q1272.5
median544
Q3815.5
95-th percentile1032.7
Maximum1087
Range1086
Interquartile range (IQR)543

Descriptive statistics

Standard deviation313.93418
Coefficient of variation (CV)0.57708488
Kurtosis-1.2
Mean544
Median Absolute Deviation (MAD)272
Skewness0
Sum591328
Variance98554.667
MonotonicityStrictly increasing
2024-04-21T11:08:02.102844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
724 1
 
0.1%
730 1
 
0.1%
729 1
 
0.1%
728 1
 
0.1%
727 1
 
0.1%
726 1
 
0.1%
725 1
 
0.1%
723 1
 
0.1%
2 1
 
0.1%
Other values (1077) 1077
99.1%
ValueCountFrequency (%)
1 1
0.1%
2 1
0.1%
3 1
0.1%
4 1
0.1%
5 1
0.1%
6 1
0.1%
7 1
0.1%
8 1
0.1%
9 1
0.1%
10 1
0.1%
ValueCountFrequency (%)
1087 1
0.1%
1086 1
0.1%
1085 1
0.1%
1084 1
0.1%
1083 1
0.1%
1082 1
0.1%
1081 1
0.1%
1080 1
0.1%
1079 1
0.1%
1078 1
0.1%
Distinct221
Distinct (%)20.3%
Missing0
Missing (%)0.0%
Memory size8.6 KiB
2024-04-21T11:08:02.364369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length28
Mean length5.8923643
Min length2

Characters and Unicode

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

Unique

Unique126 ?
Unique (%)11.6%

Sample

1st row달리기
2nd row앉아밀기
3rd row말타기
4th row가로하늘타기
5th row큰활차
ValueCountFrequency (%)
크로스컨트리 67
 
5.6%
허리돌리기 67
 
5.6%
롤링웨이스트 62
 
5.2%
워밍암 62
 
5.2%
스텝사이클 45
 
3.8%
트리플트위스트 40
 
3.3%
35
 
2.9%
윗몸일으키기 35
 
2.9%
풀웨이트 29
 
2.4%
트윈바디싣업 26
 
2.2%
Other values (207) 731
61.0%
2024-04-21T11:08:02.847170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
598
 
9.3%
480
 
7.5%
477
 
7.4%
331
 
5.2%
210
 
3.3%
142
 
2.2%
137
 
2.1%
129
 
2.0%
123
 
1.9%
123
 
1.9%
Other values (174) 3655
57.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6126
95.6%
Space Separator 123
 
1.9%
Math Symbol 98
 
1.5%
Decimal Number 23
 
0.4%
Open Punctuation 9
 
0.1%
Close Punctuation 9
 
0.1%
Other Punctuation 9
 
0.1%
Dash Punctuation 8
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
598
 
9.8%
480
 
7.8%
477
 
7.8%
331
 
5.4%
210
 
3.4%
142
 
2.3%
137
 
2.2%
129
 
2.1%
123
 
2.0%
116
 
1.9%
Other values (161) 3383
55.2%
Decimal Number
ValueCountFrequency (%)
2 14
60.9%
3 6
26.1%
4 2
 
8.7%
6 1
 
4.3%
Other Punctuation
ValueCountFrequency (%)
/ 5
55.6%
· 2
 
22.2%
, 1
 
11.1%
* 1
 
11.1%
Space Separator
ValueCountFrequency (%)
123
100.0%
Math Symbol
ValueCountFrequency (%)
+ 98
100.0%
Open Punctuation
ValueCountFrequency (%)
( 9
100.0%
Close Punctuation
ValueCountFrequency (%)
) 9
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6126
95.6%
Common 279
 
4.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
598
 
9.8%
480
 
7.8%
477
 
7.8%
331
 
5.4%
210
 
3.4%
142
 
2.3%
137
 
2.2%
129
 
2.1%
123
 
2.0%
116
 
1.9%
Other values (161) 3383
55.2%
Common
ValueCountFrequency (%)
123
44.1%
+ 98
35.1%
2 14
 
5.0%
( 9
 
3.2%
) 9
 
3.2%
- 8
 
2.9%
3 6
 
2.2%
/ 5
 
1.8%
· 2
 
0.7%
4 2
 
0.7%
Other values (3) 3
 
1.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6126
95.6%
ASCII 277
 
4.3%
None 2
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
598
 
9.8%
480
 
7.8%
477
 
7.8%
331
 
5.4%
210
 
3.4%
142
 
2.3%
137
 
2.2%
129
 
2.1%
123
 
2.0%
116
 
1.9%
Other values (161) 3383
55.2%
ASCII
ValueCountFrequency (%)
123
44.4%
+ 98
35.4%
2 14
 
5.1%
( 9
 
3.2%
) 9
 
3.2%
- 8
 
2.9%
3 6
 
2.2%
/ 5
 
1.8%
4 2
 
0.7%
6 1
 
0.4%
Other values (2) 2
 
0.7%
None
ValueCountFrequency (%)
· 2
100.0%

개수
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size8.6 KiB
1
965 
2
 
95
3
 
21
4
 
4
6
 
2

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 965
88.8%
2 95
 
8.7%
3 21
 
1.9%
4 4
 
0.4%
6 2
 
0.2%

Length

2024-04-21T11:08:02.963046image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T11:08:03.058204image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 965
88.8%
2 95
 
8.7%
3 21
 
1.9%
4 4
 
0.4%
6 2
 
0.2%

위치
Text

Distinct215
Distinct (%)19.8%
Missing0
Missing (%)0.0%
Memory size8.6 KiB
2024-04-21T11:08:03.314468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length95
Median length46
Mean length20.324747
Min length4

Characters and Unicode

Total characters22093
Distinct characters242
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

Unique47 ?
Unique (%)4.3%

Sample

1st row효동어린이공원(효목동 120-1)
2nd row효동어린이공원(효목동 120-1)
3rd row효동어린이공원(효목동 120-1)
4th row효동어린이공원(효목동 120-1)
5th row효동어린이공원(효목동 120-1)
ValueCountFrequency (%)
82
 
2.5%
대구선 75
 
2.3%
체육시설 67
 
2.0%
동촌공원(용계동 61
 
1.9%
368-2 57
 
1.7%
체육시설(불로동 41
 
1.3%
36
 
1.1%
맞은편 34
 
1.0%
율하체육공원(율하동 30
 
0.9%
인근 29
 
0.9%
Other values (424) 2767
84.4%
2024-04-21T11:08:03.767821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2323
 
10.5%
1478
 
6.7%
1 999
 
4.5%
( 895
 
4.1%
) 892
 
4.0%
642
 
2.9%
604
 
2.7%
585
 
2.6%
- 573
 
2.6%
485
 
2.2%
Other values (232) 12617
57.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 12860
58.2%
Decimal Number 4537
 
20.5%
Space Separator 2323
 
10.5%
Open Punctuation 895
 
4.1%
Close Punctuation 892
 
4.0%
Dash Punctuation 573
 
2.6%
Other Punctuation 13
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
1478
 
11.5%
642
 
5.0%
604
 
4.7%
585
 
4.5%
485
 
3.8%
478
 
3.7%
428
 
3.3%
412
 
3.2%
408
 
3.2%
397
 
3.1%
Other values (217) 6943
54.0%
Decimal Number
ValueCountFrequency (%)
1 999
22.0%
8 477
10.5%
2 461
10.2%
5 459
10.1%
0 448
9.9%
6 437
9.6%
3 424
9.3%
4 304
 
6.7%
9 280
 
6.2%
7 248
 
5.5%
Space Separator
ValueCountFrequency (%)
2323
100.0%
Open Punctuation
ValueCountFrequency (%)
( 895
100.0%
Close Punctuation
ValueCountFrequency (%)
) 892
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 573
100.0%
Other Punctuation
ValueCountFrequency (%)
. 13
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 12860
58.2%
Common 9233
41.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
1478
 
11.5%
642
 
5.0%
604
 
4.7%
585
 
4.5%
485
 
3.8%
478
 
3.7%
428
 
3.3%
412
 
3.2%
408
 
3.2%
397
 
3.1%
Other values (217) 6943
54.0%
Common
ValueCountFrequency (%)
2323
25.2%
1 999
10.8%
( 895
 
9.7%
) 892
 
9.7%
- 573
 
6.2%
8 477
 
5.2%
2 461
 
5.0%
5 459
 
5.0%
0 448
 
4.9%
6 437
 
4.7%
Other values (5) 1269
13.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 12860
58.2%
ASCII 9233
41.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2323
25.2%
1 999
10.8%
( 895
 
9.7%
) 892
 
9.7%
- 573
 
6.2%
8 477
 
5.2%
2 461
 
5.0%
5 459
 
5.0%
0 448
 
4.9%
6 437
 
4.7%
Other values (5) 1269
13.7%
Hangul
ValueCountFrequency (%)
1478
 
11.5%
642
 
5.0%
604
 
4.7%
585
 
4.5%
485
 
3.8%
478
 
3.7%
428
 
3.3%
412
 
3.2%
408
 
3.2%
397
 
3.1%
Other values (217) 6943
54.0%

설치연도
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct23
Distinct (%)2.4%
Missing115
Missing (%)10.6%
Infinite0
Infinite (%)0.0%
Mean2013.3467
Minimum1982
Maximum2024
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size9.7 KiB
2024-04-21T11:08:03.903952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1982
5-th percentile1995
Q12009
median2015
Q32019
95-th percentile2021.45
Maximum2024
Range42
Interquartile range (IQR)10

Descriptive statistics

Standard deviation7.8725794
Coefficient of variation (CV)0.0039101956
Kurtosis3.9713593
Mean2013.3467
Median Absolute Deviation (MAD)4
Skewness-1.774322
Sum1956973
Variance61.977507
MonotonicityNot monotonic
2024-04-21T11:08:04.013458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
2019 164
15.1%
2008 111
10.2%
2015 75
 
6.9%
2021 67
 
6.2%
2016 66
 
6.1%
2010 57
 
5.2%
2013 55
 
5.1%
2017 53
 
4.9%
2018 48
 
4.4%
2006 36
 
3.3%
Other values (13) 240
22.1%
(Missing) 115
10.6%
ValueCountFrequency (%)
1982 19
 
1.7%
1992 5
 
0.5%
1994 23
 
2.1%
1995 14
 
1.3%
1997 8
 
0.7%
2006 36
 
3.3%
2008 111
10.2%
2009 33
 
3.0%
2010 57
5.2%
2011 22
 
2.0%
ValueCountFrequency (%)
2024 7
 
0.6%
2023 28
 
2.6%
2022 14
 
1.3%
2021 67
6.2%
2020 27
 
2.5%
2019 164
15.1%
2018 48
 
4.4%
2017 53
 
4.9%
2016 66
6.1%
2015 75
6.9%

담당부서
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size8.6 KiB
대구광역시 동구청 공원녹지과
648 
대구광역시 동구청 체육진흥과
439 

Length

Max length15
Median length15
Mean length15
Min length15

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대구광역시 동구청 공원녹지과
2nd row대구광역시 동구청 공원녹지과
3rd row대구광역시 동구청 공원녹지과
4th row대구광역시 동구청 공원녹지과
5th row대구광역시 동구청 공원녹지과

Common Values

ValueCountFrequency (%)
대구광역시 동구청 공원녹지과 648
59.6%
대구광역시 동구청 체육진흥과 439
40.4%

Length

2024-04-21T11:08:04.124372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T11:08:04.214205image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대구광역시 1087
33.3%
동구청 1087
33.3%
공원녹지과 648
19.9%
체육진흥과 439
13.5%

비고
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct23
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size8.6 KiB
<NA>
669 
디자인파크
158 
(주)디자인파크개발
 
56
㈜디자인파크개발
 
42
H&S 스포메딕
 
26
Other values (18)
136 

Length

Max length10
Median length4
Mean length4.8712052
Min length1

Unique

Unique2 ?
Unique (%)0.2%

Sample

1st row㈜미래파크
2nd row㈜미래파크
3rd row㈜미래파크
4th row㈜미래파크
5th row㈜미래파크

Common Values

ValueCountFrequency (%)
<NA> 669
61.5%
디자인파크 158
 
14.5%
(주)디자인파크개발 56
 
5.2%
㈜디자인파크개발 42
 
3.9%
H&S 스포메딕 26
 
2.4%
㈜미래파크 20
 
1.8%
㈜케이엘에스 15
 
1.4%
조인존 15
 
1.4%
케이엘에스 14
 
1.3%
성진웰파크 13
 
1.2%
Other values (13) 59
 
5.4%

Length

2024-04-21T11:08:04.334037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 669
60.1%
디자인파크 158
 
14.2%
주)디자인파크개발 56
 
5.0%
㈜디자인파크개발 42
 
3.8%
스포메딕 28
 
2.5%
h&s 26
 
2.3%
㈜미래파크 20
 
1.8%
㈜케이엘에스 15
 
1.3%
조인존 15
 
1.3%
케이엘에스 14
 
1.3%
Other values (13) 71
 
6.4%

Interactions

2024-04-21T11:08:01.329087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T11:08:01.079886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T11:08:01.476087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T11:08:01.218036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-21T11:08:04.437894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호개수설치연도담당부서비고
번호1.0000.6530.6541.0000.888
개수0.6531.0000.2290.2230.437
설치연도0.6540.2291.0000.4030.839
담당부서1.0000.2230.4031.000NaN
비고0.8880.4370.839NaN1.000
2024-04-21T11:08:04.549580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
비고담당부서개수
비고1.0001.0000.249
담당부서1.0001.0000.272
개수0.2490.2721.000
2024-04-21T11:08:04.644641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호설치연도개수담당부서비고
번호1.000-0.1310.3270.9890.681
설치연도-0.1311.0000.1560.4540.611
개수0.3270.1561.0000.2720.249
담당부서0.9890.4540.2721.0001.000
비고0.6810.6110.2491.0001.000

Missing values

2024-04-21T11:08:01.651030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T11:08:01.778530image/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

번호기구명개수위치설치연도담당부서비고
01달리기1효동어린이공원(효목동 120-1)2019대구광역시 동구청 공원녹지과㈜미래파크
12앉아밀기1효동어린이공원(효목동 120-1)2019대구광역시 동구청 공원녹지과㈜미래파크
23말타기1효동어린이공원(효목동 120-1)2019대구광역시 동구청 공원녹지과㈜미래파크
34가로하늘타기1효동어린이공원(효목동 120-1)2019대구광역시 동구청 공원녹지과㈜미래파크
45큰활차1효동어린이공원(효목동 120-1)2019대구광역시 동구청 공원녹지과㈜미래파크
56하늘걷기1효동어린이공원(효목동 120-1)2019대구광역시 동구청 공원녹지과㈜미래파크
67허리돌리기1효동어린이공원(효목동 120-1)2019대구광역시 동구청 공원녹지과㈜미래파크
78스텝사이클1효목어린이공원(효목동 409)2016대구광역시 동구청 공원녹지과㈜디자인파크개발
89트리플트위스트1효목어린이공원(효목동 409)2016대구광역시 동구청 공원녹지과㈜디자인파크개발
910체어풀1효목어린이공원(효목동 409)2016대구광역시 동구청 공원녹지과㈜디자인파크개발
번호기구명개수위치설치연도담당부서비고
10771078달리기운동1입석동 1033-56번지 체육시설2023대구광역시 동구청 체육진흥과<NA>
10781079허리돌리기1입석동 1033-56번지 체육시설2023대구광역시 동구청 체육진흥과<NA>
10791080앉아밀기1입석동 1033-56번지 체육시설2023대구광역시 동구청 체육진흥과<NA>
10801081달리기운동1평광동 108번지 체육시설2024대구광역시 동구청 체육진흥과<NA>
10811082허리돌리기1평광동 108번지 체육시설2024대구광역시 동구청 체육진흥과<NA>
10821083하늘걷기1평광동 108번지 체육시설2024대구광역시 동구청 체육진흥과<NA>
10831084큰활차+작은활차1평광동 108번지 체육시설2024대구광역시 동구청 체육진흥과<NA>
10841085좌식싸이클1능성동 오실지 체육시설2024대구광역시 동구청 체육진흥과<NA>
10851086아래로 당기기1능성동 오실지 체육시설2024대구광역시 동구청 체육진흥과<NA>
10861087온몸근육풀기+허리돌리기1능성동 오실지 체육시설2024대구광역시 동구청 체육진흥과<NA>