Overview

Dataset statistics

Number of variables6
Number of observations143
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.0 KiB
Average record size in memory49.9 B

Variable types

Text2
Numeric1
DateTime1
Categorical2

Dataset

Description광주광역시 동구 내 설치된 공공체육시설 현황에 관한 정보로 지역주민에게 시설의 위치와 종류, 이용현황 등의 데이터를 제공하고자 함
Author광주광역시 동구
URLhttps://www.data.go.kr/data/15010914/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
면적 is highly overall correlated with 이용시설현황High correlation
이용시설현황 is highly overall correlated with 면적High correlation
이용시설현황 is highly imbalanced (71.1%)Imbalance
시설명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 02:25:44.892312
Analysis finished2023-12-12 02:25:45.567020
Duration0.67 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시설명
Text

UNIQUE 

Distinct143
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-12T11:25:45.799662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length14
Mean length9.034965
Min length2

Characters and Unicode

Total characters1292
Distinct characters205
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

Unique143 ?
Unique (%)100.0%

Sample

1st row장원봉 중재
2nd row꾀재
3rd row구와산 정상
4th row운림동 무등파크 뒷산
5th row깃대봉
ValueCountFrequency (%)
공터 14
 
4.8%
옆 9
 
3.1%
운림동 8
 
2.7%
지원동 7
 
2.4%
계림동 6
 
2.0%
소태동 6
 
2.0%
소공원 6
 
2.0%
산수동 5
 
1.7%
앞 5
 
1.7%
무등파크 5
 
1.7%
Other values (170) 222
75.8%
2023-12-12T11:25:46.347083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
153
 
11.8%
동 99
 
7.7%
산 47
 
3.6%
공 37
 
2.9%
원 35
 
2.7%
지 28
 
2.2%
터 26
 
2.0%
림 24
 
1.9%
트 24
 
1.9%
파 24
 
1.9%
Other values (195) 795
61.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1103
85.4%
Space Separator 153
 
11.8%
Decimal Number 24
 
1.9%
Open Punctuation 5
 
0.4%
Close Punctuation 5
 
0.4%
Other Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 99
 
9.0%
산 47
 
4.3%
공 37
 
3.4%
원 35
 
3.2%
지 28
 
2.5%
터 26
 
2.4%
림 24
 
2.2%
트 24
 
2.2%
파 24
 
2.2%
학 23
 
2.1%
Other values (186) 736
66.7%
Decimal Number
ValueCountFrequency (%)
1 11
45.8%
2 8
33.3%
4 2
 
8.3%
3 2
 
8.3%
0 1
 
4.2%
Space Separator
ValueCountFrequency (%)
153
100.0%
Open Punctuation
ValueCountFrequency (%)
( 5
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5
100.0%
Other Punctuation
ValueCountFrequency (%)
& 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1103
85.4%
Common 189
 
14.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 99
 
9.0%
산 47
 
4.3%
공 37
 
3.4%
원 35
 
3.2%
지 28
 
2.5%
터 26
 
2.4%
림 24
 
2.2%
트 24
 
2.2%
파 24
 
2.2%
학 23
 
2.1%
Other values (186) 736
66.7%
Common
ValueCountFrequency (%)
153
81.0%
1 11
 
5.8%
2 8
 
4.2%
( 5
 
2.6%
) 5
 
2.6%
& 2
 
1.1%
4 2
 
1.1%
3 2
 
1.1%
0 1
 
0.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1103
85.4%
ASCII 189
 
14.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
153
81.0%
1 11
 
5.8%
2 8
 
4.2%
( 5
 
2.6%
) 5
 
2.6%
& 2
 
1.1%
4 2
 
1.1%
3 2
 
1.1%
0 1
 
0.5%
Hangul
ValueCountFrequency (%)
동 99
 
9.0%
산 47
 
4.3%
공 37
 
3.4%
원 35
 
3.2%
지 28
 
2.5%
터 26
 
2.4%
림 24
 
2.2%
트 24
 
2.2%
파 24
 
2.2%
학 23
 
2.1%
Other values (186) 736
66.7%

소재지도로명주소
Text

Distinct139
Distinct (%)97.2%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-12T11:25:46.675493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length22
Mean length17.314685
Min length14

Characters and Unicode

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

Unique

Unique135 ?
Unique (%)94.4%

Sample

1st row광주광역시 동구 산수동 산 50-1
2nd row광주광역시 동구 산수동 산 59
3rd row광주광역시 동구 지산동 산3
4th row광주광역시 동구 운림동 57
5th row광주광역시 동구 서석동 산 54
ValueCountFrequency (%)
광주광역시 141
24.8%
동구 141
24.8%
소태동 13
 
2.3%
학동 8
 
1.4%
산수동 8
 
1.4%
의재로 7
 
1.2%
필문대로 6
 
1.1%
계림동 6
 
1.1%
운림동 5
 
0.9%
용산동 5
 
0.9%
Other values (179) 229
40.2%
2023-12-12T11:25:47.209431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
429
17.3%
광 286
 
11.6%
동 220
 
8.9%
주 144
 
5.8%
구 143
 
5.8%
역 142
 
5.7%
시 142
 
5.7%
1 78
 
3.2%
2 68
 
2.7%
로 65
 
2.6%
Other values (64) 759
30.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1496
60.4%
Decimal Number 488
 
19.7%
Space Separator 429
 
17.3%
Dash Punctuation 62
 
2.5%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 286
19.1%
동 220
14.7%
주 144
9.6%
구 143
9.6%
역 142
9.5%
시 142
9.5%
로 65
 
4.3%
산 41
 
2.7%
길 22
 
1.5%
소 17
 
1.1%
Other values (51) 274
18.3%
Decimal Number
ValueCountFrequency (%)
1 78
16.0%
2 68
13.9%
3 61
12.5%
5 49
10.0%
7 46
9.4%
4 45
9.2%
8 41
8.4%
9 34
7.0%
6 33
6.8%
0 33
6.8%
Space Separator
ValueCountFrequency (%)
429
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 62
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1496
60.4%
Common 980
39.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 286
19.1%
동 220
14.7%
주 144
9.6%
구 143
9.6%
역 142
9.5%
시 142
9.5%
로 65
 
4.3%
산 41
 
2.7%
길 22
 
1.5%
소 17
 
1.1%
Other values (51) 274
18.3%
Common
ValueCountFrequency (%)
429
43.8%
1 78
 
8.0%
2 68
 
6.9%
- 62
 
6.3%
3 61
 
6.2%
5 49
 
5.0%
7 46
 
4.7%
4 45
 
4.6%
8 41
 
4.2%
9 34
 
3.5%
Other values (3) 67
 
6.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1496
60.4%
ASCII 980
39.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
429
43.8%
1 78
 
8.0%
2 68
 
6.9%
- 62
 
6.3%
3 61
 
6.2%
5 49
 
5.0%
7 46
 
4.7%
4 45
 
4.6%
8 41
 
4.2%
9 34
 
3.5%
Other values (3) 67
 
6.8%
Hangul
ValueCountFrequency (%)
광 286
19.1%
동 220
14.7%
주 144
9.6%
구 143
9.6%
역 142
9.5%
시 142
9.5%
로 65
 
4.3%
산 41
 
2.7%
길 22
 
1.5%
소 17
 
1.1%
Other values (51) 274
18.3%

면적
Real number (ℝ)

HIGH CORRELATION 

Distinct61
Distinct (%)42.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean697.52594
Minimum10
Maximum17753
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.4 KiB
2023-12-12T11:25:47.363880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10
5-th percentile12.3
Q125
median60
Q3355
95-th percentile3881.321
Maximum17753
Range17743
Interquartile range (IQR)330

Descriptive statistics

Standard deviation2284.0809
Coefficient of variation (CV)3.2745462
Kurtosis35.256434
Mean697.52594
Median Absolute Deviation (MAD)40
Skewness5.6291639
Sum99746.21
Variance5217025.7
MonotonicityNot monotonic
2023-12-12T11:25:47.555682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20.0 13
 
9.1%
30.0 10
 
7.0%
60.0 8
 
5.6%
25.0 8
 
5.6%
50.0 8
 
5.6%
10.0 7
 
4.9%
100.0 7
 
4.9%
150.0 6
 
4.2%
15.0 5
 
3.5%
45.0 5
 
3.5%
Other values (51) 66
46.2%
ValueCountFrequency (%)
10.0 7
4.9%
12.0 1
 
0.7%
15.0 5
 
3.5%
18.0 2
 
1.4%
20.0 13
9.1%
24.0 1
 
0.7%
25.0 8
5.6%
28.0 1
 
0.7%
30.0 10
7.0%
40.0 5
 
3.5%
ValueCountFrequency (%)
17753.0 1
0.7%
15519.0 1
0.7%
9920.0 1
0.7%
6063.0 1
0.7%
5280.0 1
0.7%
4513.0 1
0.7%
4378.0 1
0.7%
3907.0 1
0.7%
3650.21 1
0.7%
1850.0 1
0.7%

조성일자
Date

Distinct91
Distinct (%)63.6%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
Minimum1992-09-15 00:00:00
Maximum2023-07-01 00:00:00
2023-12-12T11:25:47.999245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:25:48.182078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

이용시설현황
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct13
Distinct (%)9.1%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
체력단력기구
122 
간이운동,체력단련기구
 
6
게이트볼장
 
4
족구장
 
2
잔디구장, 테니스장, 게이트볼장, 조깅로
 
1
Other values (8)
 
8

Length

Max length22
Median length6
Mean length6.3286713
Min length3

Unique

Unique9 ?
Unique (%)6.3%

Sample

1st row체력단력기구
2nd row체력단력기구
3rd row체력단력기구
4th row체력단력기구
5th row체력단력기구

Common Values

ValueCountFrequency (%)
체력단력기구 122
85.3%
간이운동,체력단련기구 6
 
4.2%
게이트볼장 4
 
2.8%
족구장 2
 
1.4%
잔디구장, 테니스장, 게이트볼장, 조깅로 1
 
0.7%
정구장 1
 
0.7%
수영장, 헬스장, 체육관 1
 
0.7%
풋살장 1
 
0.7%
쳬력단련기구 1
 
0.7%
체육관, 부대시설 1
 
0.7%
Other values (3) 3
 
2.1%

Length

2023-12-12T11:25:48.343785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
체력단력기구 122
80.8%
간이운동,체력단련기구 6
 
4.0%
게이트볼장 5
 
3.3%
족구장 2
 
1.3%
수영장 2
 
1.3%
헬스장 2
 
1.3%
체육관 2
 
1.3%
생활체육관 2
 
1.3%
잔디구장 1
 
0.7%
테니스장 1
 
0.7%
Other values (6) 6
 
4.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-08-29
143 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-08-29
2nd row2023-08-29
3rd row2023-08-29
4th row2023-08-29
5th row2023-08-29

Common Values

ValueCountFrequency (%)
2023-08-29 143
100.0%

Length

2023-12-12T11:25:48.500414image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:25:48.631414image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-08-29 143
100.0%

Interactions

2023-12-12T11:25:45.228139image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T11:25:48.696675image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
면적조성일자이용시설현황
면적1.0000.9370.928
조성일자0.9371.0000.998
이용시설현황0.9280.9981.000
2023-12-12T11:25:48.788441image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
면적이용시설현황
면적1.0000.757
이용시설현황0.7571.000

Missing values

2023-12-12T11:25:45.403171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T11:25:45.523062image/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장원봉 중재광주광역시 동구 산수동 산 50-1800.01992-09-15체력단력기구2023-08-29
1꾀재광주광역시 동구 산수동 산 591850.01992-09-15체력단력기구2023-08-29
2구와산 정상광주광역시 동구 지산동 산3400.01992-09-15체력단력기구2023-08-29
3운림동 무등파크 뒷산광주광역시 동구 운림동 57150.01992-11-10체력단력기구2023-08-29
4깃대봉광주광역시 동구 서석동 산 541500.01993-01-20체력단력기구2023-08-29
5팔각정 중간쉼터광주광역시 동구 학동 산35-1100.01993-01-20체력단력기구2023-08-29
6광주고광주광역시 동구 중앙로 3021300.01993-09-01체력단력기구2023-08-29
7소태동 정수장 뒷산광주광역시 동구 소태동 산17-1300.01993-12-01체력단력기구2023-08-29
8너릿재 공원광주광역시 동구 선교동 4829920.01993-12-31체력단력기구2023-08-29
9내지마을광주광역시 동구 내남동 68450.01994-02-01간이운동,체력단련기구2023-08-29
시설명소재지도로명주소면적조성일자이용시설현황데이터기준일자
133동구문화센터 뒤편 공터광주광역시 동구 소태동 532-199106.02022-06-01체력단력기구2023-08-29
134운림동 남해네오트광주광역시 동구 증심천로 11740.02023-03-01체력단력기구2023-08-29
135계림동 근랜드센트럴광주광역시 동구 경양로 23440.02023-03-01체력단력기구2023-08-29
136소태동 소공원광주광역시 동구 소태동 22930.02023-03-01체력단력기구2023-08-29
137두등동동산책로광주광역시 동구 운림동 411-160.02023-07-01체력단력기구2023-08-29
138무등산파크골프장광주광역시 동구 산251-86063.02022-06-01파크골프장2023-08-29
139동구청소년수련관광주광역시 동구 의재로43번길 27-33907.01999-11-01생활체육관2023-08-29
140산수게이트볼장광주광역시 동구 산수동 401-8300.02001-12-01게이트볼장2023-08-29
141금호게이트볼장광주광역시 동구 필문대로 12-7440.02009-02-01게이트볼장2023-08-29
142지원교하부 제2족구장광주광역시 동구 소태동 산216-3500.02022-08-01족구장2023-08-29