Overview

Dataset statistics

Number of variables6
Number of observations288
Missing cells288
Missing cells (%)16.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory14.2 KiB
Average record size in memory50.5 B

Variable types

Categorical2
Text2
Numeric1
Unsupported1

Dataset

Description성북구 관내에 있는 야외 운동기구 현황(성북구 공원녹지과 관리 공원, 공원구역, 어린이공원 및 마을마당, 쉼터 내 야외 운동기구 현황)
Author서울특별시 성북구
URLhttps://www.data.go.kr/data/15086034/fileData.do

Alerts

구분 is highly overall correlated with 공원명High correlation
공원명 is highly overall correlated with 구분High correlation
구분 is highly imbalanced (69.0%)Imbalance
Unnamed: 5 has 288 (100.0%) missing valuesMissing
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 13:04:53.758278
Analysis finished2023-12-12 13:04:54.213027
Duration0.45 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
시공원
272 
마을마당 및 기타공원
 
16

Length

Max length16
Median length3
Mean length3.7222222
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row시공원
2nd row시공원
3rd row시공원
4th row시공원
5th row시공원

Common Values

ValueCountFrequency (%)
시공원 272
94.4%
마을마당 및 기타공원 16
 
5.6%

Length

2023-12-12T22:04:54.278161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:04:54.373194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
시공원 272
85.0%
마을마당 16
 
5.0%
및 16
 
5.0%
기타공원 16
 
5.0%

공원명
Categorical

HIGH CORRELATION 

Distinct48
Distinct (%)16.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
북한산도시자연공원
40 
개운산근린공원
33 
청량근린공원
22 
오동근린공원
21 
성북근린공원 (북악산도시자연공원구역 포함
17 
Other values (43)
155 

Length

Max length40
Median length12
Mean length6.9895833
Min length2

Unique

Unique17 ?
Unique (%)5.9%

Sample

1st row북한산도시자연공원
2nd row북한산도시자연공원
3rd row북한산도시자연공원
4th row북한산도시자연공원
5th row북한산도시자연공원

Common Values

ValueCountFrequency (%)
북한산도시자연공원 40
 
13.9%
개운산근린공원 33
 
11.5%
청량근린공원 22
 
7.6%
오동근린공원 21
 
7.3%
성북근린공원 (북악산도시자연공원구역 포함 17
 
5.9%
한울 12
 
4.2%
꿈나라 9
 
3.1%
솔향기 8
 
2.8%
삼선 8
 
2.8%
샛별 8
 
2.8%
Other values (38) 110
38.2%

Length

2023-12-12T22:04:54.481148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
북한산도시자연공원 40
 
11.9%
개운산근린공원 33
 
9.8%
청량근린공원 22
 
6.5%
오동근린공원 21
 
6.2%
성북근린공원 17
 
5.0%
북악산도시자연공원구역 17
 
5.0%
포함 17
 
5.0%
한울 12
 
3.6%
꿈나라 9
 
2.7%
샛별 8
 
2.4%
Other values (50) 141
41.8%

주소
Text

Distinct136
Distinct (%)47.2%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
2023-12-12T22:04:54.797241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length13
Mean length9.8611111
Min length8

Characters and Unicode

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

Unique

Unique111 ?
Unique (%)38.5%

Sample

1st row정릉동 산1-1
2nd row정릉동 산1-2
3rd row정릉동 산1-3
4th row정릉동 산1-4
5th row정릉동 산1-5
ValueCountFrequency (%)
정릉동 49
 
7.9%
석관동 38
 
6.1%
하월곡동 35
 
5.6%
돈암1동 34
 
5.5%
산1-5 23
 
3.7%
산2-1 21
 
3.4%
길음1동 19
 
3.1%
종암동 18
 
2.9%
등 17
 
2.7%
산85-1 17
 
2.7%
Other values (158) 350
56.4%
2023-12-12T22:04:55.276638image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 353
 
12.4%
337
 
11.9%
동 286
 
10.1%
- 268
 
9.4%
2 173
 
6.1%
산 139
 
4.9%
3 105
 
3.7%
6 92
 
3.2%
5 85
 
3.0%
0 78
 
2.7%
Other values (31) 924
32.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1133
39.9%
Other Letter 1102
38.8%
Space Separator 337
 
11.9%
Dash Punctuation 268
 
9.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 286
26.0%
산 139
12.6%
암 77
 
7.0%
릉 73
 
6.6%
정 73
 
6.6%
돈 51
 
4.6%
곡 43
 
3.9%
월 43
 
3.9%
관 40
 
3.6%
석 40
 
3.6%
Other values (19) 237
21.5%
Decimal Number
ValueCountFrequency (%)
1 353
31.2%
2 173
15.3%
3 105
 
9.3%
6 92
 
8.1%
5 85
 
7.5%
0 78
 
6.9%
8 74
 
6.5%
9 69
 
6.1%
7 56
 
4.9%
4 48
 
4.2%
Space Separator
ValueCountFrequency (%)
337
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 268
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1738
61.2%
Hangul 1102
38.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 286
26.0%
산 139
12.6%
암 77
 
7.0%
릉 73
 
6.6%
정 73
 
6.6%
돈 51
 
4.6%
곡 43
 
3.9%
월 43
 
3.9%
관 40
 
3.6%
석 40
 
3.6%
Other values (19) 237
21.5%
Common
ValueCountFrequency (%)
1 353
20.3%
337
19.4%
- 268
15.4%
2 173
10.0%
3 105
 
6.0%
6 92
 
5.3%
5 85
 
4.9%
0 78
 
4.5%
8 74
 
4.3%
9 69
 
4.0%
Other values (2) 104
 
6.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1738
61.2%
Hangul 1102
38.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 353
20.3%
337
19.4%
- 268
15.4%
2 173
10.0%
3 105
 
6.0%
6 92
 
5.3%
5 85
 
4.9%
0 78
 
4.5%
8 74
 
4.3%
9 69
 
4.0%
Other values (2) 104
 
6.0%
Hangul
ValueCountFrequency (%)
동 286
26.0%
산 139
12.6%
암 77
 
7.0%
릉 73
 
6.6%
정 73
 
6.6%
돈 51
 
4.6%
곡 43
 
3.9%
월 43
 
3.9%
관 40
 
3.6%
석 40
 
3.6%
Other values (19) 237
21.5%

운동기구명
Text

Distinct102
Distinct (%)35.4%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
2023-12-12T22:04:55.643857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length5.15625
Min length2

Characters and Unicode

Total characters1485
Distinct characters148
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

Unique57 ?
Unique (%)19.8%

Sample

1st row공중걷기
2nd row파도타기
3rd row허리돌리기
4th row상체근육풀기
5th row달리기
ValueCountFrequency (%)
허리돌리기 24
 
8.3%
운동기구 16
 
5.5%
파도타기 15
 
5.2%
윗몸일으키기 13
 
4.5%
철봉 9
 
3.1%
공중걷기 9
 
3.1%
상체근육풀기 8
 
2.8%
평행봉 8
 
2.8%
팔굽혀펴기 7
 
2.4%
역기올리기 7
 
2.4%
Other values (94) 174
60.0%
2023-12-12T22:04:56.136215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
기 250
 
16.8%
리 115
 
7.7%
동 39
 
2.6%
운 37
 
2.5%
허 35
 
2.4%
돌 35
 
2.4%
체 34
 
2.3%
근 27
 
1.8%
스 26
 
1.8%
풀 26
 
1.8%
Other values (138) 861
58.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1458
98.2%
Other Punctuation 22
 
1.5%
Space Separator 2
 
0.1%
Open Punctuation 1
 
0.1%
Close Punctuation 1
 
0.1%
Decimal Number 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 250
 
17.1%
리 115
 
7.9%
동 39
 
2.7%
운 37
 
2.5%
허 35
 
2.4%
돌 35
 
2.4%
체 34
 
2.3%
근 27
 
1.9%
스 26
 
1.8%
풀 26
 
1.8%
Other values (132) 834
57.2%
Other Punctuation
ValueCountFrequency (%)
& 21
95.5%
, 1
 
4.5%
Space Separator
ValueCountFrequency (%)
2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Decimal Number
ValueCountFrequency (%)
4 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1458
98.2%
Common 27
 
1.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 250
 
17.1%
리 115
 
7.9%
동 39
 
2.7%
운 37
 
2.5%
허 35
 
2.4%
돌 35
 
2.4%
체 34
 
2.3%
근 27
 
1.9%
스 26
 
1.8%
풀 26
 
1.8%
Other values (132) 834
57.2%
Common
ValueCountFrequency (%)
& 21
77.8%
2
 
7.4%
( 1
 
3.7%
) 1
 
3.7%
, 1
 
3.7%
4 1
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1458
98.2%
ASCII 27
 
1.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
기 250
 
17.1%
리 115
 
7.9%
동 39
 
2.7%
운 37
 
2.5%
허 35
 
2.4%
돌 35
 
2.4%
체 34
 
2.3%
근 27
 
1.9%
스 26
 
1.8%
풀 26
 
1.8%
Other values (132) 834
57.2%
ASCII
ValueCountFrequency (%)
& 21
77.8%
2
 
7.4%
( 1
 
3.7%
) 1
 
3.7%
, 1
 
3.7%
4 1
 
3.7%

수량
Real number (ℝ)

Distinct15
Distinct (%)5.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.3159722
Minimum1
Maximum24
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.7 KiB
2023-12-12T22:04:56.306798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q32
95-th percentile7
Maximum24
Range23
Interquartile range (IQR)1

Descriptive statistics

Standard deviation2.6844802
Coefficient of variation (CV)1.1591159
Kurtosis19.790812
Mean2.3159722
Median Absolute Deviation (MAD)0
Skewness3.7487941
Sum667
Variance7.2064339
MonotonicityNot monotonic
2023-12-12T22:04:56.484721image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
1 173
60.1%
2 46
 
16.0%
3 20
 
6.9%
5 13
 
4.5%
4 9
 
3.1%
6 8
 
2.8%
7 7
 
2.4%
8 4
 
1.4%
11 2
 
0.7%
15 1
 
0.3%
Other values (5) 5
 
1.7%
ValueCountFrequency (%)
1 173
60.1%
2 46
 
16.0%
3 20
 
6.9%
4 9
 
3.1%
5 13
 
4.5%
6 8
 
2.8%
7 7
 
2.4%
8 4
 
1.4%
9 1
 
0.3%
11 2
 
0.7%
ValueCountFrequency (%)
24 1
 
0.3%
16 1
 
0.3%
15 1
 
0.3%
14 1
 
0.3%
12 1
 
0.3%
11 2
 
0.7%
9 1
 
0.3%
8 4
1.4%
7 7
2.4%
6 8
2.8%

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing288
Missing (%)100.0%
Memory size2.7 KiB

Interactions

2023-12-12T22:04:53.967383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T22:04:56.580680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분공원명수량
구분1.0001.0000.301
공원명1.0001.0000.088
수량0.3010.0881.000
2023-12-12T22:04:56.685579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분공원명
구분1.0000.916
공원명0.9161.000
2023-12-12T22:04:56.786463image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수량구분공원명
수량1.0000.2230.016
구분0.2231.0000.916
공원명0.0160.9161.000

Missing values

2023-12-12T22:04:54.077490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T22:04:54.174809image/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

구분공원명주소운동기구명수량Unnamed: 5
0시공원북한산도시자연공원정릉동 산1-1공중걷기11<NA>
1시공원북한산도시자연공원정릉동 산1-2파도타기7<NA>
2시공원북한산도시자연공원정릉동 산1-3허리돌리기15<NA>
3시공원북한산도시자연공원정릉동 산1-4상체근육풀기1<NA>
4시공원북한산도시자연공원정릉동 산1-5달리기7<NA>
5시공원북한산도시자연공원정릉동 산1-6역기올리기6<NA>
6시공원북한산도시자연공원정릉동 산1-7레그프레스1<NA>
7시공원북한산도시자연공원정릉동 산1-8어깨근육풀기7<NA>
8시공원북한산도시자연공원정릉동 산1-9윗몸일으키기7<NA>
9시공원북한산도시자연공원정릉동 산1-10역기내리기3<NA>
구분공원명주소운동기구명수량Unnamed: 5
278마을마당 및 기타공원성북동 쉼터성북2동 118-2운동기구9<NA>
279마을마당 및 기타공원성북 우정의 공원성북동 276-5 일대운동기구5<NA>
280마을마당 및 기타공원동소문 가로휴식공간동소문동1가 1-4 일대운동기구3<NA>
281마을마당 및 기타공원정릉2동고가아래쉼터정릉2동382-10운동기구1<NA>
282마을마당 및 기타공원종암2동 정릉천변 수림대종암2동 115-103운동기구2<NA>
283마을마당 및 기타공원월곡1동 녹지쉼터월곡1동 96-113운동기구5<NA>
284마을마당 및 기타공원월곡2동 가로쉼터(1)월곡2동5-2 일대운동기구2<NA>
285마을마당 및 기타공원상월곡동 가로쉼터상월곡동75-54운동기구4<NA>
286마을마당 및 기타공원석관1동 쉼터석관1동281-1 일대운동기구5<NA>
287마을마당 및 기타공원석관2동 돌곳이 쉼터석관2동 257-2 일대운동기구2<NA>