Overview

Dataset statistics

Number of variables8
Number of observations208
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory13.7 KiB
Average record size in memory67.6 B

Variable types

Numeric3
Text1
Categorical4

Dataset

Description서울특별시 강북구 야외운동기구현황(기구종류, 설치주소, 설치년도, 설치업체 등) 현행화 데이터로 208건 제공합니다.
URLhttps://www.data.go.kr/data/15037868/fileData.do

Alerts

자료기준일 has constant value ""Constant
설치업체 is highly overall correlated with 연번 and 3 other fieldsHigh correlation
담당부서 is highly overall correlated with 연번 and 2 other fieldsHigh correlation
설치주소 is highly overall correlated with 연번 and 3 other fieldsHigh correlation
연번 is highly overall correlated with 설치주소 and 2 other fieldsHigh correlation
설치년도 is highly overall correlated with 설치주소 and 1 other fieldsHigh correlation
연번 has unique valuesUnique
설치년도 has 72 (34.6%) zerosZeros

Reproduction

Analysis started2023-12-12 03:02:28.706727
Analysis finished2023-12-12 03:02:30.547817
Duration1.84 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct208
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean104.5
Minimum1
Maximum208
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.0 KiB
2023-12-12T12:02:30.651669image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile11.35
Q152.75
median104.5
Q3156.25
95-th percentile197.65
Maximum208
Range207
Interquartile range (IQR)103.5

Descriptive statistics

Standard deviation60.188592
Coefficient of variation (CV)0.57596739
Kurtosis-1.2
Mean104.5
Median Absolute Deviation (MAD)52
Skewness0
Sum21736
Variance3622.6667
MonotonicityStrictly increasing
2023-12-12T12:02:30.813726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.5%
106 1
 
0.5%
134 1
 
0.5%
135 1
 
0.5%
136 1
 
0.5%
137 1
 
0.5%
138 1
 
0.5%
139 1
 
0.5%
140 1
 
0.5%
141 1
 
0.5%
Other values (198) 198
95.2%
ValueCountFrequency (%)
1 1
0.5%
2 1
0.5%
3 1
0.5%
4 1
0.5%
5 1
0.5%
6 1
0.5%
7 1
0.5%
8 1
0.5%
9 1
0.5%
10 1
0.5%
ValueCountFrequency (%)
208 1
0.5%
207 1
0.5%
206 1
0.5%
205 1
0.5%
204 1
0.5%
203 1
0.5%
202 1
0.5%
201 1
0.5%
200 1
0.5%
199 1
0.5%

운동기구종류
Text

Distinct84
Distinct (%)40.4%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-12T12:02:31.035150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length13
Mean length5.3269231
Min length2

Characters and Unicode

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

Unique

Unique46 ?
Unique (%)22.1%

Sample

1st row달리기운동
2nd row역기
3rd row오금펴기
4th row윗몸일으키기
5th row철봉
ValueCountFrequency (%)
허리돌리기 17
 
7.9%
파도타기 11
 
5.1%
윗몸일으키기 9
 
4.2%
철봉 9
 
4.2%
오금펴기 7
 
3.3%
노젓기 7
 
3.3%
평행봉 6
 
2.8%
공중걷기 6
 
2.8%
상체근육풀기 5
 
2.3%
양팔줄당기기 5
 
2.3%
Other values (76) 132
61.7%
2023-12-12T12:02:31.419722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
기 177
 
16.0%
리 83
 
7.5%
허 27
 
2.4%
스 27
 
2.4%
풀 23
 
2.1%
돌 22
 
2.0%
+ 20
 
1.8%
육 19
 
1.7%
근 19
 
1.7%
체 19
 
1.7%
Other values (122) 672
60.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1082
97.7%
Math Symbol 20
 
1.8%
Space Separator 6
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 177
 
16.4%
리 83
 
7.7%
허 27
 
2.5%
스 27
 
2.5%
풀 23
 
2.1%
돌 22
 
2.0%
육 19
 
1.8%
근 19
 
1.8%
체 19
 
1.8%
역 17
 
1.6%
Other values (120) 649
60.0%
Math Symbol
ValueCountFrequency (%)
+ 20
100.0%
Space Separator
ValueCountFrequency (%)
6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1082
97.7%
Common 26
 
2.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 177
 
16.4%
리 83
 
7.7%
허 27
 
2.5%
스 27
 
2.5%
풀 23
 
2.1%
돌 22
 
2.0%
육 19
 
1.8%
근 19
 
1.8%
체 19
 
1.8%
역 17
 
1.6%
Other values (120) 649
60.0%
Common
ValueCountFrequency (%)
+ 20
76.9%
6
 
23.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1082
97.7%
ASCII 26
 
2.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
기 177
 
16.4%
리 83
 
7.7%
허 27
 
2.5%
스 27
 
2.5%
풀 23
 
2.1%
돌 22
 
2.0%
육 19
 
1.8%
근 19
 
1.8%
체 19
 
1.8%
역 17
 
1.6%
Other values (120) 649
60.0%
ASCII
ValueCountFrequency (%)
+ 20
76.9%
6
 
23.1%

설치주소
Categorical

HIGH CORRELATION 

Distinct35
Distinct (%)16.8%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
서울 강북구 번동 655-3
19 
서울 강북구 번동 612-3
19 
서울 강북구 수유동 산127-1
19 
서울 강북구 수유동 647-4
18 
서울 강북구 수유동 647-2
15 
Other values (30)
118 

Length

Max length34
Median length29.5
Mean length18.894231
Min length15

Unique

Unique5 ?
Unique (%)2.4%

Sample

1st row서울 강북구 미아동 산108-9
2nd row서울 강북구 미아동 산108-9
3rd row서울 강북구 미아동 산108-9
4th row서울 강북구 미아동 산108-9
5th row서울 강북구 미아동 산108-9

Common Values

ValueCountFrequency (%)
서울 강북구 번동 655-3 19
 
9.1%
서울 강북구 번동 612-3 19
 
9.1%
서울 강북구 수유동 산127-1 19
 
9.1%
서울 강북구 수유동 647-4 18
 
8.7%
서울 강북구 수유동 647-2 15
 
7.2%
서울 강북구 수유1동 산127-17(쌈지마을마당) 9
 
4.3%
서울 강북구 미아동 산108-9 8
 
3.8%
서울 강북구 번동 619-27 7
 
3.4%
서울 강북구 번동 655-1 7
 
3.4%
서울 강북구 미아동 791-1776(하늘어린이공원) 7
 
3.4%
Other values (25) 80
38.5%

Length

2023-12-12T12:02:31.616095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
서울 208
24.5%
강북구 208
24.5%
수유동 79
 
9.3%
번동 71
 
8.4%
미아동 38
 
4.5%
612-3 19
 
2.2%
655-3 19
 
2.2%
산127-1 19
 
2.2%
647-4 18
 
2.1%
647-2 15
 
1.8%
Other values (37) 155
18.3%

개수
Real number (ℝ)

Distinct15
Distinct (%)7.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0480769
Minimum1
Maximum33
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.0 KiB
2023-12-12T12:02:31.756157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q31
95-th percentile8.3
Maximum33
Range32
Interquartile range (IQR)0

Descriptive statistics

Standard deviation3.4818503
Coefficient of variation (CV)1.7000583
Kurtosis36.141725
Mean2.0480769
Median Absolute Deviation (MAD)0
Skewness5.3944255
Sum426
Variance12.123281
MonotonicityNot monotonic
2023-12-12T12:02:31.894614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
1 162
77.9%
2 18
 
8.7%
4 7
 
3.4%
3 7
 
3.4%
5 2
 
1.0%
9 2
 
1.0%
10 2
 
1.0%
7 1
 
0.5%
17 1
 
0.5%
13 1
 
0.5%
Other values (5) 5
 
2.4%
ValueCountFrequency (%)
1 162
77.9%
2 18
 
8.7%
3 7
 
3.4%
4 7
 
3.4%
5 2
 
1.0%
7 1
 
0.5%
9 2
 
1.0%
10 2
 
1.0%
12 1
 
0.5%
13 1
 
0.5%
ValueCountFrequency (%)
33 1
0.5%
20 1
0.5%
17 1
0.5%
15 1
0.5%
14 1
0.5%
13 1
0.5%
12 1
0.5%
10 2
1.0%
9 2
1.0%
7 1
0.5%

설치년도
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct8
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1319.1106
Minimum0
Maximum2020
Zeros72
Zeros (%)34.6%
Negative0
Negative (%)0.0%
Memory size2.0 KiB
2023-12-12T12:02:32.025504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median2016
Q32018
95-th percentile2020
Maximum2020
Range2020
Interquartile range (IQR)2018

Descriptive statistics

Standard deviation962.11033
Coefficient of variation (CV)0.72936291
Kurtosis-1.5909788
Mean1319.1106
Median Absolute Deviation (MAD)3
Skewness-0.65146357
Sum274375
Variance925656.28
MonotonicityNot monotonic
2023-12-12T12:02:32.440315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
0 72
34.6%
2018 37
17.8%
2017 24
 
11.5%
2019 24
 
11.5%
2016 21
 
10.1%
2020 13
 
6.2%
2015 11
 
5.3%
2014 6
 
2.9%
ValueCountFrequency (%)
0 72
34.6%
2014 6
 
2.9%
2015 11
 
5.3%
2016 21
 
10.1%
2017 24
 
11.5%
2018 37
17.8%
2019 24
 
11.5%
2020 13
 
6.2%
ValueCountFrequency (%)
2020 13
 
6.2%
2019 24
 
11.5%
2018 37
17.8%
2017 24
 
11.5%
2016 21
 
10.1%
2015 11
 
5.3%
2014 6
 
2.9%
0 72
34.6%

설치업체
Categorical

HIGH CORRELATION 

Distinct19
Distinct (%)9.1%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
미상
60 
그린나래
36 
한양그린파크
34 
오리온햄프로
20 
지스포텍
15 
Other values (14)
43 

Length

Max length8
Median length7
Mean length3.9903846
Min length2

Unique

Unique6 ?
Unique (%)2.9%

Sample

1st row미상
2nd row미상
3rd row미상
4th row미상
5th row미상

Common Values

ValueCountFrequency (%)
미상 60
28.8%
그린나래 36
17.3%
한양그린파크 34
16.3%
오리온햄프로 20
 
9.6%
지스포텍 15
 
7.2%
상우 14
 
6.7%
성원에스피 5
 
2.4%
한국조경건설 5
 
2.4%
디자인파크개발 4
 
1.9%
에드케이 3
 
1.4%
Other values (9) 12
 
5.8%

Length

2023-12-12T12:02:32.570202image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
미상 60
28.8%
그린나래 36
17.3%
한양그린파크 34
16.3%
오리온햄프로 20
 
9.6%
지스포텍 15
 
7.2%
상우 14
 
6.7%
성원에스피 5
 
2.4%
한국조경건설 5
 
2.4%
디자인파크개발 4
 
1.9%
에드케이 3
 
1.4%
Other values (9) 12
 
5.8%

담당부서
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
문화관광체육과
145 
공원녹지과
63 

Length

Max length7
Median length7
Mean length6.3942308
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row문화관광체육과
2nd row문화관광체육과
3rd row문화관광체육과
4th row문화관광체육과
5th row문화관광체육과

Common Values

ValueCountFrequency (%)
문화관광체육과 145
69.7%
공원녹지과 63
30.3%

Length

2023-12-12T12:02:32.717989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:02:32.841849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
문화관광체육과 145
69.7%
공원녹지과 63
30.3%

자료기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-05-26
208 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-05-26
2nd row2023-05-26
3rd row2023-05-26
4th row2023-05-26
5th row2023-05-26

Common Values

ValueCountFrequency (%)
2023-05-26 208
100.0%

Length

2023-12-12T12:02:33.064555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:02:33.246455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-05-26 208
100.0%

Interactions

2023-12-12T12:02:29.976241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:02:29.260164image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:02:29.598940image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:02:30.066469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:02:29.376185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:02:29.713842image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:02:30.188958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:02:29.482764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:02:29.858259image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T12:02:33.352295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번운동기구종류설치주소개수설치년도설치업체담당부서
연번1.0000.5080.9870.4380.8730.8551.000
운동기구종류0.5081.0000.8680.0000.6770.0000.920
설치주소0.9870.8681.0000.0000.8810.9411.000
개수0.4380.0000.0001.0000.2760.0000.047
설치년도0.8730.6770.8810.2761.0000.9480.667
설치업체0.8550.0000.9410.0000.9481.0001.000
담당부서1.0000.9201.0000.0470.6671.0001.000
2023-12-12T12:02:33.475791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치업체담당부서설치주소
설치업체1.0000.9580.565
담당부서0.9581.0000.916
설치주소0.5650.9161.000
2023-12-12T12:02:33.586387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번개수설치년도설치주소설치업체담당부서
연번1.000-0.2190.2840.8250.5240.980
개수-0.2191.000-0.3410.0000.0000.049
설치년도0.284-0.3411.0000.7280.8880.465
설치주소0.8250.0000.7281.0000.5650.916
설치업체0.5240.0000.8880.5651.0000.958
담당부서0.9800.0490.4650.9160.9581.000

Missing values

2023-12-12T12:02:30.333137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T12:02:30.490979image/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달리기운동서울 강북구 미아동 산108-910미상문화관광체육과2023-05-26
12역기서울 강북구 미아동 산108-940미상문화관광체육과2023-05-26
23오금펴기서울 강북구 미아동 산108-930미상문화관광체육과2023-05-26
34윗몸일으키기서울 강북구 미아동 산108-970미상문화관광체육과2023-05-26
45철봉서울 강북구 미아동 산108-920미상문화관광체육과2023-05-26
56팔굽혀펴기서울 강북구 미아동 산108-940미상문화관광체육과2023-05-26
67평행봉서울 강북구 미아동 산108-920미상문화관광체육과2023-05-26
78허리돌리기서울 강북구 미아동 산108-940미상문화관광체육과2023-05-26
89공중걷기서울 강북구 번동 612-342017에드케이문화관광체육과2023-05-26
910노젓기서울 강북구 번동 612-312017지스포텍문화관광체육과2023-05-26
연번운동기구종류설치주소개수설치년도설치업체담당부서자료기준일
198199크로스워킹서울 강북구 수유1동 산127-17(쌈지마을마당)12019그린나래공원녹지과2023-05-26
199200터닝암서울 강북구 수유1동 산127-17(쌈지마을마당)12019그린나래공원녹지과2023-05-26
200201턴오버스트레칭서울 강북구 수유1동 산127-17(쌈지마을마당)12019그린나래공원녹지과2023-05-26
201202트위스트머신서울 강북구 수유1동 산127-17(쌈지마을마당)12019그린나래공원녹지과2023-05-26
202203풀웨이트서울 강북구 수유1동 산127-17(쌈지마을마당)12019그린나래공원녹지과2023-05-26
203204온몸근육풀기서울 강북구 수유동 172-209(은모루어린이공원)12015오리온햄프로공원녹지과2023-05-26
204205체스트프레스서울 강북구 수유동 172-209(은모루어린이공원)12015오리온햄프로공원녹지과2023-05-26
205206하체흔들기서울 강북구 수유동 172-209(은모루어린이공원)12015오리온햄프로공원녹지과2023-05-26
206207사이드스윙서울 강북구 수유동 224-4(상산어린이공원)12018그린나래공원녹지과2023-05-26
207208달리기서울 강북구 인수동 400-1512020금보인터내셔널공원녹지과2023-05-26