Overview

Dataset statistics

Number of variables4
Number of observations269
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.5 KiB
Average record size in memory32.5 B

Variable types

Text2
Categorical2

Dataset

Description충청남도 청양군 야외(실외)운동기구 현황으로 설치주소, 설치기구종류, 담당부서, 설치년도에 대한 정보를 제공하고 있습니다.
URLhttps://www.data.go.kr/data/15037863/fileData.do

Alerts

담당부서 is highly imbalanced (82.7%)Imbalance

Reproduction

Analysis started2023-12-12 16:21:19.043392
Analysis finished2023-12-12 16:21:19.404713
Duration0.36 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

설치주소
Text

Distinct265
Distinct (%)98.5%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
2023-12-13T01:21:19.694348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length33
Median length30
Mean length21.594796
Min length16

Characters and Unicode

Total characters5809
Distinct characters135
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

Unique261 ?
Unique (%)97.0%

Sample

1st row충청남도 청양군 청양읍 정좌리 110-1
2nd row충청남도 청양군 청양읍 송방리 47
3rd row충청남도 청양군 청양읍 군량리 125-8
4th row충청남도 청양군 청양읍 송방리 317-1
5th row충청남도 청양군 청양읍 정좌리 275
ValueCountFrequency (%)
충청남도 269
19.9%
청양군 269
19.9%
청양읍 37
 
2.7%
남양면 30
 
2.2%
청남면 29
 
2.1%
정산면 29
 
2.1%
운곡면 25
 
1.8%
화성면 25
 
1.8%
비봉면 25
 
1.8%
대치면 24
 
1.8%
Other values (379) 592
43.7%
2023-12-13T01:21:20.189704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1087
18.7%
청 609
 
10.5%
양 347
 
6.0%
남 332
 
5.7%
군 270
 
4.6%
충 269
 
4.6%
도 269
 
4.6%
리 266
 
4.6%
면 232
 
4.0%
- 200
 
3.4%
Other values (125) 1928
33.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3499
60.2%
Space Separator 1087
 
18.7%
Decimal Number 1014
 
17.5%
Dash Punctuation 200
 
3.4%
Other Punctuation 7
 
0.1%
Open Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
청 609
17.4%
양 347
9.9%
남 332
9.5%
군 270
 
7.7%
충 269
 
7.7%
도 269
 
7.7%
리 266
 
7.6%
면 232
 
6.6%
정 59
 
1.7%
읍 47
 
1.3%
Other values (109) 799
22.8%
Decimal Number
ValueCountFrequency (%)
1 199
19.6%
2 125
12.3%
3 118
11.6%
6 106
10.5%
4 106
10.5%
5 99
9.8%
7 83
8.2%
8 66
 
6.5%
9 58
 
5.7%
0 54
 
5.3%
Other Punctuation
ValueCountFrequency (%)
, 6
85.7%
/ 1
 
14.3%
Space Separator
ValueCountFrequency (%)
1087
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 200
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3499
60.2%
Common 2310
39.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
청 609
17.4%
양 347
9.9%
남 332
9.5%
군 270
 
7.7%
충 269
 
7.7%
도 269
 
7.7%
리 266
 
7.6%
면 232
 
6.6%
정 59
 
1.7%
읍 47
 
1.3%
Other values (109) 799
22.8%
Common
ValueCountFrequency (%)
1087
47.1%
- 200
 
8.7%
1 199
 
8.6%
2 125
 
5.4%
3 118
 
5.1%
6 106
 
4.6%
4 106
 
4.6%
5 99
 
4.3%
7 83
 
3.6%
8 66
 
2.9%
Other values (6) 121
 
5.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3499
60.2%
ASCII 2310
39.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1087
47.1%
- 200
 
8.7%
1 199
 
8.6%
2 125
 
5.4%
3 118
 
5.1%
6 106
 
4.6%
4 106
 
4.6%
5 99
 
4.3%
7 83
 
3.6%
8 66
 
2.9%
Other values (6) 121
 
5.2%
Hangul
ValueCountFrequency (%)
청 609
17.4%
양 347
9.9%
남 332
9.5%
군 270
 
7.7%
충 269
 
7.7%
도 269
 
7.7%
리 266
 
7.6%
면 232
 
6.6%
정 59
 
1.7%
읍 47
 
1.3%
Other values (109) 799
22.8%

설치기구 종류
Text

Distinct110
Distinct (%)40.9%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
2023-12-13T01:21:20.403738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length68
Median length60
Mean length21.360595
Min length6

Characters and Unicode

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

Unique

Unique96 ?
Unique (%)35.7%

Sample

1st row허리돌리기1개+ 상체근육풀기1개
2nd row허리돌리기1개+ 상체근육풀기1개
3rd row허리돌리기1개+ 상체근육풀기1개+레그프레스1개
4th row허리돌리기1개
5th row허리돌리기1개+ 상체근육풀기1개
ValueCountFrequency (%)
허리돌리기1개 189
26.7%
상체근육풀기1개 159
22.4%
공중걷기1개 40
 
5.6%
1개 37
 
5.2%
1 21
 
3.0%
허리돌리기 18
 
2.5%
달리기유형1개 15
 
2.1%
공중걷기 15
 
2.1%
파도타기1개 13
 
1.8%
활차머신1개 11
 
1.6%
Other values (116) 191
26.9%
2023-12-13T01:21:20.785166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
기 699
12.2%
1 579
 
10.1%
개 559
 
9.7%
리 550
 
9.6%
457
 
8.0%
+ 444
 
7.7%
허 245
 
4.3%
돌 239
 
4.2%
육 202
 
3.5%
근 202
 
3.5%
Other values (93) 1570
27.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4218
73.4%
Decimal Number 587
 
10.2%
Space Separator 457
 
8.0%
Math Symbol 444
 
7.7%
Open Punctuation 15
 
0.3%
Close Punctuation 15
 
0.3%
Other Punctuation 9
 
0.2%
Connector Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 699
16.6%
개 559
13.3%
리 550
13.0%
허 245
 
5.8%
돌 239
 
5.7%
육 202
 
4.8%
근 202
 
4.8%
풀 201
 
4.8%
체 189
 
4.5%
상 187
 
4.4%
Other values (83) 945
22.4%
Decimal Number
ValueCountFrequency (%)
1 579
98.6%
2 7
 
1.2%
3 1
 
0.2%
Other Punctuation
ValueCountFrequency (%)
, 7
77.8%
/ 2
 
22.2%
Space Separator
ValueCountFrequency (%)
457
100.0%
Math Symbol
ValueCountFrequency (%)
+ 444
100.0%
Open Punctuation
ValueCountFrequency (%)
( 15
100.0%
Close Punctuation
ValueCountFrequency (%)
) 15
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4218
73.4%
Common 1528
 
26.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 699
16.6%
개 559
13.3%
리 550
13.0%
허 245
 
5.8%
돌 239
 
5.7%
육 202
 
4.8%
근 202
 
4.8%
풀 201
 
4.8%
체 189
 
4.5%
상 187
 
4.4%
Other values (83) 945
22.4%
Common
ValueCountFrequency (%)
1 579
37.9%
457
29.9%
+ 444
29.1%
( 15
 
1.0%
) 15
 
1.0%
, 7
 
0.5%
2 7
 
0.5%
/ 2
 
0.1%
_ 1
 
0.1%
3 1
 
0.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4218
73.4%
ASCII 1528
 
26.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
기 699
16.6%
개 559
13.3%
리 550
13.0%
허 245
 
5.8%
돌 239
 
5.7%
육 202
 
4.8%
근 202
 
4.8%
풀 201
 
4.8%
체 189
 
4.5%
상 187
 
4.4%
Other values (83) 945
22.4%
ASCII
ValueCountFrequency (%)
1 579
37.9%
457
29.9%
+ 444
29.1%
( 15
 
1.0%
) 15
 
1.0%
, 7
 
0.5%
2 7
 
0.5%
/ 2
 
0.1%
_ 1
 
0.1%
3 1
 
0.1%

담당부서
Categorical

IMBALANCE 

Distinct8
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
문화체육관광과
251 
농촌공동체과
 
6
 
5
환경보호과
 
2
<NA>
 
2
Other values (3)
 
3

Length

Max length7
Median length7
Mean length6.8066914
Min length1

Unique

Unique3 ?
Unique (%)1.1%

Sample

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

Common Values

ValueCountFrequency (%)
문화체육관광과 251
93.3%
농촌공동체과 6
 
2.2%
5
 
1.9%
환경보호과 2
 
0.7%
<NA> 2
 
0.7%
건설도시과 1
 
0.4%
안전재난과 1
 
0.4%
미래전략과 1
 
0.4%

Length

2023-12-13T01:21:20.918373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T01:21:21.044207image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
문화체육관광과 251
95.1%
농촌공동체과 6
 
2.3%
환경보호과 2
 
0.8%
na 2
 
0.8%
건설도시과 1
 
0.4%
안전재난과 1
 
0.4%
미래전략과 1
 
0.4%

설치년도
Categorical

Distinct19
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
2016
29 
2017
27 
2020
25 
2013
25 
2018
23 
Other values (14)
140 

Length

Max length14
Median length4
Mean length4.0297398
Min length1

Unique

Unique3 ?
Unique (%)1.1%

Sample

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

Common Values

ValueCountFrequency (%)
2016 29
10.8%
2017 27
10.0%
2020 25
9.3%
2013 25
9.3%
2018 23
8.6%
2015 23
8.6%
2019 19
 
7.1%
2021 19
 
7.1%
2014 16
 
5.9%
<NA> 13
 
4.8%
Other values (9) 50
18.6%

Length

2023-12-13T01:21:21.218168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2016 29
10.9%
2017 27
10.2%
2020 26
9.8%
2013 25
9.4%
2018 24
9.1%
2015 23
8.7%
2019 19
7.2%
2021 19
7.2%
2014 17
 
6.4%
na 13
 
4.9%
Other values (6) 43
16.2%

Correlations

2023-12-13T01:21:21.298626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
담당부서설치년도
담당부서1.0000.828
설치년도0.8281.000
2023-12-13T01:21:21.439443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
담당부서설치년도
담당부서1.0000.480
설치년도0.4801.000
2023-12-13T01:21:21.572013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
담당부서설치년도
담당부서1.0000.480
설치년도0.4801.000

Missing values

2023-12-13T01:21:19.296309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T01:21:19.374483image/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충청남도 청양군 청양읍 정좌리 110-1허리돌리기1개+ 상체근육풀기1개문화체육관광과2014
1충청남도 청양군 청양읍 송방리 47허리돌리기1개+ 상체근육풀기1개문화체육관광과2015
2충청남도 청양군 청양읍 군량리 125-8허리돌리기1개+ 상체근육풀기1개+레그프레스1개문화체육관광과2016
3충청남도 청양군 청양읍 송방리 317-1허리돌리기1개문화체육관광과2016
4충청남도 청양군 청양읍 정좌리 275허리돌리기1개+ 상체근육풀기1개문화체육관광과2016
5충청남도 청양군 청양읍 학당리 553-4허리돌리기1개+ 상체근육풀기1개문화체육관광과2016
6충청남도 청양군 청양읍 읍내리 284-11공중걷기1개+ 허리돌리기1개+ 상체근육풀기1개문화체육관광과2017
7충청남도 청양군 청양읍 장승리 280-3파도타기1개+ 상체근육풀기1개문화체육관광과2017
8충청남도 청양군 청양읍 읍내리 306공중걷기1개+ 역기올리기1개+ 레그프레스1개문화체육관광과2018
9충청남도 청양군 청양읍 학당리허리돌리기1개+ 상체근육풀기1개문화체육관광과2018
설치주소설치기구 종류담당부서설치년도
259충청남도 청양군 비봉면 방한리 993허리돌리기+ 등허리지압기+ 공중걷기미래전략과<NA>
260충청남도 청양군 비봉면 용천리 307공중걷기+ 매달리기+ 양팔줄당기기+ 등허리지압기농촌공동체과<NA>
261충청남도 청양군 청양읍 읍내리 104-228상체근육풀기+달리기1개, 하늘걷기+하늘돌리기1개문화체육관광과2023
262충청남도 청양군 운곡면 미량리 1011-46하늘걷기+달리기1개문화체육관광과2023
263충청남도 청양군 청남면 내직리 364역기올리기+역기내리기1개, 하늘걷기+허리돌리기1개문화체육관광과2023
264충청남도 청양군 남양면 용두리 101-1상체근육풀기+어깨근육풀기1개, 하늘걷기+허리돌리기1개문화체육관광과2023
265충청남도 청양군 남양면 금정리 117-4상체근육풀기+어깨근육풀기1개, 싸이클링+오금펴기1개문화체육관광과2023
266충청남도 청양군 화성면 화강리 687싸이클링+오금펴기1개, 하늘걷기+허리돌리기1개문화체육관광과2023
267충청남도 청양군 화성면 화강리 688역기올리기+역기내리기1개, 상체근육풀기+어깨근육풀기1개문화체육관광과2023
268충청남도 청양군 화성면 용당리 182-7윗몸일으키키+오금펴기1개, 하늘걷기+노젓기1개문화체육관광과2023