Overview

Dataset statistics

Number of variables8
Number of observations135
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.7 KiB
Average record size in memory66.0 B

Variable types

Categorical4
Numeric1
Text3

Dataset

Description광주광역시 자치구별 생활체육시설 현황
Author광주광역시
URLhttps://www.data.go.kr/data/15001510/fileData.do

Alerts

구별 is highly overall correlated with 기간 and 1 other fieldsHigh correlation
기간 is highly overall correlated with 구별High correlation
지도경력 is highly overall correlated with 구별High correlation

Reproduction

Analysis started2023-12-12 08:37:14.268824
Analysis finished2023-12-12 08:37:15.154047
Duration0.89 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구별
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
광주광역시 북구
32 
광주광역시 남구
30 
광주광역시 서구
25 
광주광역시 광산구
25 
광주광역시 동구
23 

Length

Max length9
Median length8
Mean length8.1851852
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row광주광역시 동구
2nd row광주광역시 동구
3rd row광주광역시 동구
4th row광주광역시 동구
5th row광주광역시 동구

Common Values

ValueCountFrequency (%)
광주광역시 북구 32
23.7%
광주광역시 남구 30
22.2%
광주광역시 서구 25
18.5%
광주광역시 광산구 25
18.5%
광주광역시 동구 23
17.0%

Length

2023-12-12T17:37:15.213195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:37:15.321500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광주광역시 135
50.0%
북구 32
 
11.9%
남구 30
 
11.1%
서구 25
 
9.3%
광산구 25
 
9.3%
동구 23
 
8.5%

연번
Real number (ℝ)

Distinct32
Distinct (%)23.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14.214815
Minimum1
Maximum32
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2023-12-12T17:37:15.435738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q17
median14
Q321
95-th percentile28
Maximum32
Range31
Interquartile range (IQR)14

Descriptive statistics

Standard deviation8.1911722
Coefficient of variation (CV)0.57624192
Kurtosis-0.97818935
Mean14.214815
Median Absolute Deviation (MAD)7
Skewness0.15538252
Sum1919
Variance67.095301
MonotonicityNot monotonic
2023-12-12T17:37:15.570615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=32)
ValueCountFrequency (%)
1 5
 
3.7%
13 5
 
3.7%
23 5
 
3.7%
22 5
 
3.7%
21 5
 
3.7%
20 5
 
3.7%
19 5
 
3.7%
18 5
 
3.7%
2 5
 
3.7%
16 5
 
3.7%
Other values (22) 85
63.0%
ValueCountFrequency (%)
1 5
3.7%
2 5
3.7%
3 5
3.7%
4 5
3.7%
5 5
3.7%
6 5
3.7%
7 5
3.7%
8 5
3.7%
9 5
3.7%
10 5
3.7%
ValueCountFrequency (%)
32 1
 
0.7%
31 1
 
0.7%
30 2
 
1.5%
29 2
 
1.5%
28 2
 
1.5%
27 2
 
1.5%
26 2
 
1.5%
25 4
3.0%
24 4
3.0%
23 5
3.7%

장 소
Text

Distinct130
Distinct (%)96.3%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-12T17:37:15.847224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length11
Mean length5.837037
Min length3

Characters and Unicode

Total characters788
Distinct characters177
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique125 ?
Unique (%)92.6%

Sample

1st row동명게이트볼장
2nd row금호게이트볼장
3rd row산수게이트볼장
4th row용산정구장
5th row서 석 초
ValueCountFrequency (%)
운동장 7
 
4.1%
체육관 5
 
2.9%
전천후구장 2
 
1.2%
광 2
 
1.2%
구 2
 
1.2%
첨단대상 2
 
1.2%
봉선코트장 2
 
1.2%
중 2
 
1.2%
장 2
 
1.2%
학운동 2
 
1.2%
Other values (138) 144
83.7%
2023-12-12T17:37:16.289836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
장 46
 
5.8%
37
 
4.7%
구 27
 
3.4%
동 23
 
2.9%
초 22
 
2.8%
산 20
 
2.5%
운 18
 
2.3%
관 16
 
2.0%
트 14
 
1.8%
교 14
 
1.8%
Other values (167) 551
69.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 733
93.0%
Space Separator 37
 
4.7%
Open Punctuation 4
 
0.5%
Close Punctuation 4
 
0.5%
Decimal Number 4
 
0.5%
Other Punctuation 4
 
0.5%
Uppercase Letter 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
장 46
 
6.3%
구 27
 
3.7%
동 23
 
3.1%
초 22
 
3.0%
산 20
 
2.7%
운 18
 
2.5%
관 16
 
2.2%
트 14
 
1.9%
교 14
 
1.9%
중 13
 
1.8%
Other values (158) 520
70.9%
Decimal Number
ValueCountFrequency (%)
2 3
75.0%
3 1
 
25.0%
Other Punctuation
ValueCountFrequency (%)
/ 2
50.0%
, 2
50.0%
Uppercase Letter
ValueCountFrequency (%)
J 1
50.0%
K 1
50.0%
Space Separator
ValueCountFrequency (%)
37
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 733
93.0%
Common 53
 
6.7%
Latin 2
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
장 46
 
6.3%
구 27
 
3.7%
동 23
 
3.1%
초 22
 
3.0%
산 20
 
2.7%
운 18
 
2.5%
관 16
 
2.2%
트 14
 
1.9%
교 14
 
1.9%
중 13
 
1.8%
Other values (158) 520
70.9%
Common
ValueCountFrequency (%)
37
69.8%
( 4
 
7.5%
) 4
 
7.5%
2 3
 
5.7%
/ 2
 
3.8%
, 2
 
3.8%
3 1
 
1.9%
Latin
ValueCountFrequency (%)
J 1
50.0%
K 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 733
93.0%
ASCII 55
 
7.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
장 46
 
6.3%
구 27
 
3.7%
동 23
 
3.1%
초 22
 
3.0%
산 20
 
2.7%
운 18
 
2.5%
관 16
 
2.2%
트 14
 
1.9%
교 14
 
1.9%
중 13
 
1.8%
Other values (158) 520
70.9%
ASCII
ValueCountFrequency (%)
37
67.3%
( 4
 
7.3%
) 4
 
7.3%
2 3
 
5.5%
/ 2
 
3.6%
, 2
 
3.6%
J 1
 
1.8%
K 1
 
1.8%
3 1
 
1.8%

기간
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)5.9%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
6개월
32 
5월~11월
30 
상하반기 3개월씩
25 
3월~6월, 9월~11월
19 
4월~11월
15 
Other values (3)
14 

Length

Max length13
Median length9
Mean length6.6888889
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row4월~11월
2nd row4월~11월
3rd row4월~11월
4th row4월~12월
5th row4월~11월

Common Values

ValueCountFrequency (%)
6개월 32
23.7%
5월~11월 30
22.2%
상하반기 3개월씩 25
18.5%
3월~6월, 9월~11월 19
14.1%
4월~11월 15
11.1%
? 6
 
4.4%
11월~12월 5
 
3.7%
4월~12월 3
 
2.2%

Length

2023-12-12T17:37:16.450577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:37:16.593087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
6개월 32
17.9%
5월~11월 30
16.8%
상하반기 25
14.0%
3개월씩 25
14.0%
3월~6월 19
10.6%
9월~11월 19
10.6%
4월~11월 15
8.4%
6
 
3.4%
11월~12월 5
 
2.8%
4월~12월 3
 
1.7%

종목
Categorical

Distinct49
Distinct (%)36.3%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
게이트볼
22 
배드민턴
16 
축구
11 
테니스
9 
생활체조
 
7
Other values (44)
70 

Length

Max length6
Median length5
Mean length3.3259259
Min length2

Unique

Unique26 ?
Unique (%)19.3%

Sample

1st row게이트볼
2nd row게이트볼
3rd row게이트볼
4th row정 구
5th row성인야구

Common Values

ValueCountFrequency (%)
게이트볼 22
16.3%
배드민턴 16
 
11.9%
축구 11
 
8.1%
테니스 9
 
6.7%
생활체조 7
 
5.2%
축 구 4
 
3.0%
탁구 4
 
3.0%
줄넘기 4
 
3.0%
배구 3
 
2.2%
챠밍댄스 3
 
2.2%
Other values (39) 52
38.5%

Length

2023-12-12T17:37:16.735330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
게이트볼 22
 
13.8%
배드민턴 16
 
10.1%
구 13
 
8.2%
축구 11
 
6.9%
테니스 9
 
5.7%
생활체조 7
 
4.4%
축 4
 
2.5%
탁구 4
 
2.5%
줄넘기 4
 
2.5%
챠밍댄스 3
 
1.9%
Other values (48) 66
41.5%

참여인원(1회/연인원)
Text

Distinct80
Distinct (%)59.3%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-12T17:37:16.994604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length8
Mean length8.3333333
Min length6

Characters and Unicode

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

Unique

Unique62 ?
Unique (%)45.9%

Sample

1st row15/1,500
2nd row10/1,000
3rd row15/1,500
4th row20/2,000
5th row15/1,100
ValueCountFrequency (%)
32
 
15.7%
1,200 21
 
10.3%
20 20
 
9.8%
900 11
 
5.4%
15 10
 
4.9%
25／1,800 8
 
3.9%
25／1,200 5
 
2.5%
20／1,440 4
 
2.0%
25/600 2
 
1.0%
10／ 2
 
1.0%
Other values (76) 89
43.6%
2023-12-12T17:37:17.387157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 237
21.1%
1 150
13.3%
2 136
12.1%
/ 107
9.5%
, 88
 
7.8%
69
 
6.1%
5 67
 
6.0%
명 50
 
4.4%
4 48
 
4.3%
8 39
 
3.5%
Other values (5) 134
11.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 783
69.6%
Other Punctuation 223
 
19.8%
Space Separator 69
 
6.1%
Other Letter 50
 
4.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 237
30.3%
1 150
19.2%
2 136
17.4%
5 67
 
8.6%
4 48
 
6.1%
8 39
 
5.0%
6 32
 
4.1%
3 32
 
4.1%
9 30
 
3.8%
7 12
 
1.5%
Other Punctuation
ValueCountFrequency (%)
/ 107
48.0%
, 88
39.5%
／ 28
 
12.6%
Space Separator
ValueCountFrequency (%)
69
100.0%
Other Letter
ValueCountFrequency (%)
명 50
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1075
95.6%
Hangul 50
 
4.4%

Most frequent character per script

Common
ValueCountFrequency (%)
0 237
22.0%
1 150
14.0%
2 136
12.7%
/ 107
10.0%
, 88
 
8.2%
69
 
6.4%
5 67
 
6.2%
4 48
 
4.5%
8 39
 
3.6%
6 32
 
3.0%
Other values (4) 102
9.5%
Hangul
ValueCountFrequency (%)
명 50
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1047
93.1%
Hangul 50
 
4.4%
None 28
 
2.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 237
22.6%
1 150
14.3%
2 136
13.0%
/ 107
10.2%
, 88
 
8.4%
69
 
6.6%
5 67
 
6.4%
4 48
 
4.6%
8 39
 
3.7%
6 32
 
3.1%
Other values (3) 74
 
7.1%
Hangul
ValueCountFrequency (%)
명 50
100.0%
None
ValueCountFrequency (%)
／ 28
100.0%

운영자(지도자)
Text

Distinct132
Distinct (%)97.8%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-12T17:37:17.787723image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length2.9851852
Min length2

Characters and Unicode

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

Unique

Unique129 ?
Unique (%)95.6%

Sample

1st row김말례
2nd row이기연
3rd row김창중
4th row박석남
5th row김민수
ValueCountFrequency (%)
전소정 2
 
1.5%
정광아 2
 
1.5%
정수경 2
 
1.5%
이길연 1
 
0.7%
최상찬 1
 
0.7%
정권종 1
 
0.7%
공정기 1
 
0.7%
김경아 1
 
0.7%
곽석순 1
 
0.7%
박종은 1
 
0.7%
Other values (123) 123
90.4%
2023-12-12T17:37:18.343803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 30
 
7.4%
정 23
 
5.7%
이 18
 
4.5%
영 15
 
3.7%
박 14
 
3.5%
성 10
 
2.5%
수 10
 
2.5%
기 9
 
2.2%
선 8
 
2.0%
철 7
 
1.7%
Other values (103) 259
64.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 402
99.8%
Space Separator 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 30
 
7.5%
정 23
 
5.7%
이 18
 
4.5%
영 15
 
3.7%
박 14
 
3.5%
성 10
 
2.5%
수 10
 
2.5%
기 9
 
2.2%
선 8
 
2.0%
철 7
 
1.7%
Other values (102) 258
64.2%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 402
99.8%
Common 1
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 30
 
7.5%
정 23
 
5.7%
이 18
 
4.5%
영 15
 
3.7%
박 14
 
3.5%
성 10
 
2.5%
수 10
 
2.5%
기 9
 
2.2%
선 8
 
2.0%
철 7
 
1.7%
Other values (102) 258
64.2%
Common
ValueCountFrequency (%)
1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 402
99.8%
ASCII 1
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 30
 
7.5%
정 23
 
5.7%
이 18
 
4.5%
영 15
 
3.7%
박 14
 
3.5%
성 10
 
2.5%
수 10
 
2.5%
기 9
 
2.2%
선 8
 
2.0%
철 7
 
1.7%
Other values (102) 258
64.2%
ASCII
ValueCountFrequency (%)
1
100.0%

지도경력
Categorical

HIGH CORRELATION 

Distinct24
Distinct (%)17.8%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
6
17 
10
17 
5
12 
1
11 
15
11 
Other values (19)
67 

Length

Max length5
Median length2
Mean length1.5333333
Min length1

Unique

Unique4 ?
Unique (%)3.0%

Sample

1st row3
2nd row6
3rd row6
4th row6
5th row5

Common Values

ValueCountFrequency (%)
6 17
12.6%
10 17
12.6%
5 12
 
8.9%
1 11
 
8.1%
15 11
 
8.1%
3 9
 
6.7%
8 7
 
5.2%
1년 7
 
5.2%
6년 6
 
4.4%
20 4
 
3.0%
Other values (14) 34
25.2%

Length

2023-12-12T17:37:18.494654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
6 17
12.6%
10 17
12.6%
5 12
 
8.9%
1 11
 
8.1%
15 11
 
8.1%
3 9
 
6.7%
8 7
 
5.2%
1년 7
 
5.2%
6년 6
 
4.4%
3년 4
 
3.0%
Other values (14) 34
25.2%

Interactions

2023-12-12T17:37:14.843800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T17:37:18.615064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구별연번기간종목참여인원(1회/연인원)지도경력
구별1.0000.0001.0000.7161.0000.891
연번0.0001.0000.2660.8920.5150.000
기간1.0000.2661.0000.7210.9990.856
종목0.7160.8920.7211.0000.0000.000
참여인원(1회/연인원)1.0000.5150.9990.0001.0000.942
지도경력0.8910.0000.8560.0000.9421.000
2023-12-12T17:37:18.749715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구별기간지도경력종목
구별1.0000.9880.6320.340
기간0.9881.0000.4640.298
지도경력0.6320.4641.0000.000
종목0.3400.2980.0001.000
2023-12-12T17:37:18.848348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구별기간종목지도경력
연번1.0000.0000.1270.4660.000
구별0.0001.0000.9880.3400.632
기간0.1270.9881.0000.2980.464
종목0.4660.3400.2981.0000.000
지도경력0.0000.6320.4640.0001.000

Missing values

2023-12-12T17:37:14.964325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:37:15.106436image/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

구별연번장 소기간종목참여인원(1회/연인원)운영자(지도자)지도경력
0광주광역시 동구1동명게이트볼장4월~11월게이트볼15/1,500김말례3
1광주광역시 동구2금호게이트볼장4월~11월게이트볼10/1,000이기연6
2광주광역시 동구3산수게이트볼장4월~11월게이트볼15/1,500김창중6
3광주광역시 동구4용산정구장4월~12월정 구20/2,000박석남6
4광주광역시 동구5서 석 초4월~11월성인야구15/1,100김민수5
5광주광역시 동구6지산볼링장4월~11월볼 링20/1,440김평중1
6광주광역시 동구7학운동 자치센타4월~11월우리춤30/1,440마선희5
7광주광역시 동구8지산2주민자치센타4월~11월우리춤20/1,000안성민6
8광주광역시 동구9동명동자치센타4월~11월레크리에이션20/960신은실4
9광주광역시 동구10용산 테니스장4월~11월테니스15/1,080정기수6
구별연번장 소기간종목참여인원(1회/연인원)운영자(지도자)지도경력
125광주광역시 광산구16송우초상하반기 3개월씩배구26/1,872김남중15
126광주광역시 광산구17선창초(자모)상하반기 3개월씩배구17/1,224조정숙9
127광주광역시 광산구18월계초상하반기 3개월씩배구53/3,816유태영8
128광주광역시 광산구19첨단대상상하반기 3개월씩족 구41/2,952홍진국5
129광주광역시 광산구20무진로하부상하반기 3개월씩족 구43/3,096김기근5
130광주광역시 광산구21송무정상하반기 3개월씩궁도30/2,160박범철8
131광주광역시 광산구22우산동정구장상하반기 3개월씩정구43/3,096양동기12
132광주광역시 광산구23산정공원상하반기 3개월씩생활체조45/3,240김금자21
133광주광역시 광산구24대주상가2층상하반기 3개월씩줄넘기21/1,512이미애6
134광주광역시 광산구25첨단대상상하반기 3개월씩줄넘기25/1,800나윤성5