Overview

Dataset statistics

Number of variables9
Number of observations6088
Missing cells0
Missing cells (%)0.0%
Duplicate rows54
Duplicate rows (%)0.9%
Total size in memory428.2 KiB
Average record size in memory72.0 B

Variable types

Categorical5
DateTime3
Text1

Dataset

Description경기도 양주시 체육시설 대관 현황 (시설명, 장소명, 종목, 사용일자, 요일, 사용시간, 단체명 등)
Author양주시시설관리공단
URLhttps://www.data.go.kr/data/15074359/fileData.do

Alerts

Dataset has 54 (0.9%) duplicate rowsDuplicates
시설명 is highly overall correlated with 지역명 and 2 other fieldsHigh correlation
종목 is highly overall correlated with 시설명 and 1 other fieldsHigh correlation
장소명 is highly overall correlated with 지역명 and 2 other fieldsHigh correlation
지역명 is highly overall correlated with 시설명 and 1 other fieldsHigh correlation
종목 is highly imbalanced (64.6%)Imbalance

Reproduction

Analysis started2023-12-12 02:42:43.557313
Analysis finished2023-12-12 02:42:44.240258
Duration0.68 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지역명
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size47.7 KiB
양주2동
1216 
장흥면
1194 
회천3동
1006 
회천2동
833 
백석읍
789 
Other values (2)
1050 

Length

Max length4
Median length4
Mean length3.5018068
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row회천2동
2nd row회천2동
3rd row회천2동
4th row회천2동
5th row회천2동

Common Values

ValueCountFrequency (%)
양주2동 1216
20.0%
장흥면 1194
19.6%
회천3동 1006
16.5%
회천2동 833
13.7%
백석읍 789
13.0%
은현면 635
10.4%
광적면 415
 
6.8%

Length

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

Common Values (Plot)

2023-12-12T11:42:44.382994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
양주2동 1216
20.0%
장흥면 1194
19.6%
회천3동 1006
16.5%
회천2동 833
13.7%
백석읍 789
13.0%
은현면 635
10.4%
광적면 415
 
6.8%

시설명
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size47.7 KiB
장흥생활체육공원
1194 
옥정생활체육공원
893 
고덕생활체육공원
833 
백석생활체육공원
789 
고읍생활체육공원
724 
Other values (6)
1655 

Length

Max length9
Median length8
Mean length7.9691196
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row고덕생활체육공원
2nd row고덕생활체육공원
3rd row고덕생활체육공원
4th row고덕생활체육공원
5th row고덕생활체육공원

Common Values

ValueCountFrequency (%)
장흥생활체육공원 1194
19.6%
옥정생활체육공원 893
14.7%
고덕생활체육공원 833
13.7%
백석생활체육공원 789
13.0%
고읍생활체육공원 724
11.9%
신천생활체육공원 635
10.4%
삼숭생활체육공원 492
8.1%
광적생활체육공원 415
 
6.8%
덕정돔구장 66
 
1.1%
덕정탁구전용구장 37
 
0.6%

Length

2023-12-12T11:42:44.502251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
장흥생활체육공원 1194
19.6%
옥정생활체육공원 893
14.7%
고덕생활체육공원 833
13.7%
백석생활체육공원 789
13.0%
고읍생활체육공원 724
11.9%
신천생활체육공원 635
10.4%
삼숭생활체육공원 492
8.1%
광적생활체육공원 415
 
6.8%
덕정돔구장 66
 
1.1%
덕정탁구전용구장 37
 
0.6%

장소명
Categorical

HIGH CORRELATION 

Distinct18
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size47.7 KiB
장흥축구장
947 
옥정축구장
893 
고덕축구장
816 
고읍축구장
724 
백석축구장
666 
Other values (13)
2042 

Length

Max length8
Median length5
Mean length5.1263141
Min length5

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row고덕축구장
2nd row고덕축구장
3rd row고덕축구장
4th row고덕축구장
5th row고덕축구장

Common Values

ValueCountFrequency (%)
장흥축구장 947
15.6%
옥정축구장 893
14.7%
고덕축구장 816
13.4%
고읍축구장 724
11.9%
백석축구장 666
10.9%
신천축구장 605
9.9%
광적축구장 414
6.8%
삼숭테니스장 381
6.3%
장흥야구장 247
 
4.1%
백석성인야구장 120
 
2.0%
Other values (8) 275
 
4.5%

Length

2023-12-12T11:42:44.612630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
장흥축구장 947
15.6%
옥정축구장 893
14.7%
고덕축구장 816
13.4%
고읍축구장 724
11.9%
백석축구장 666
10.9%
신천축구장 605
9.9%
광적축구장 414
6.8%
삼숭테니스장 381
6.3%
장흥야구장 247
 
4.1%
백석성인야구장 120
 
2.0%
Other values (8) 275
 
4.5%

종목
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size47.7 KiB
축구
5065 
테니스
 
382
야구
 
370
족구
 
141
배드민턴
 
66
Other values (2)
 
64

Length

Max length4
Median length2
Mean length2.0844284
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row축구
2nd row축구
3rd row축구
4th row축구
5th row축구

Common Values

ValueCountFrequency (%)
축구 5065
83.2%
테니스 382
 
6.3%
야구 370
 
6.1%
족구 141
 
2.3%
배드민턴 66
 
1.1%
탁구 37
 
0.6%
풋살 27
 
0.4%

Length

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

Common Values (Plot)

2023-12-12T11:42:44.844410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
축구 5065
83.2%
테니스 382
 
6.3%
야구 370
 
6.1%
족구 141
 
2.3%
배드민턴 66
 
1.1%
탁구 37
 
0.6%
풋살 27
 
0.4%

사용일자
Date

Distinct361
Distinct (%)5.9%
Missing0
Missing (%)0.0%
Memory size47.7 KiB
Minimum2019-01-02 00:00:00
Maximum2019-12-31 00:00:00
2023-12-12T11:42:44.950207image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:42:45.105889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

요일
Categorical

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size47.7 KiB
일
1180 
목
904 
토
883 
화
861 
수
823 
Other values (2)
1437 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row수
2nd row수
3rd row토
4th row토
5th row일

Common Values

ValueCountFrequency (%)
일 1180
19.4%
목 904
14.8%
토 883
14.5%
화 861
14.1%
수 823
13.5%
금 737
12.1%
월 700
11.5%

Length

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

Common Values (Plot)

2023-12-12T11:42:45.411629image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일 1180
19.4%
목 904
14.8%
토 883
14.5%
화 861
14.1%
수 823
13.5%
금 737
12.1%
월 700
11.5%

사용시작시간
Date

Distinct18
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size47.7 KiB
Minimum2023-12-12 06:00:00
Maximum2023-12-12 21:00:00
2023-12-12T11:42:45.533669image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:42:45.654080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)

사용종료시간
Date

Distinct18
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size47.7 KiB
Minimum2023-12-12 07:00:00
Maximum2023-12-12 22:00:00
2023-12-12T11:42:45.766583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:42:45.899209image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)

단체명
Text

Distinct693
Distinct (%)11.4%
Missing0
Missing (%)0.0%
Memory size47.7 KiB
2023-12-12T11:42:46.225240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length17
Mean length5.1670499
Min length1

Characters and Unicode

Total characters31457
Distinct characters425
Distinct categories11 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique333 ?
Unique (%)5.5%

Sample

1st row양주디씨
2nd rowFC킥스
3rd row예향FC
4th row브라더FC
5th rowFC FIVOTER
ValueCountFrequency (%)
장흥면 444
 
6.8%
굿모닝fc 303
 
4.6%
개인 286
 
4.4%
fc 251
 
3.8%
sc주니어축구클럽 214
 
3.3%
은현면 185
 
2.8%
시민구단 183
 
2.8%
양주2동노인회 140
 
2.1%
양주시티즌 128
 
2.0%
양주2동연합회 120
 
1.8%
Other values (701) 4297
65.6%
2023-12-12T11:42:46.726672image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
C 1711
 
5.4%
회 1590
 
5.1%
F 1506
 
4.8%
인 983
 
3.1%
주 891
 
2.8%
구 846
 
2.7%
동 682
 
2.2%
면 672
 
2.1%
노 665
 
2.1%
양 589
 
1.9%
Other values (415) 21322
67.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 22704
72.2%
Uppercase Letter 4904
 
15.6%
Decimal Number 2116
 
6.7%
Lowercase Letter 785
 
2.5%
Space Separator 486
 
1.5%
Other Punctuation 314
 
1.0%
Dash Punctuation 64
 
0.2%
Open Punctuation 38
 
0.1%
Close Punctuation 36
 
0.1%
Math Symbol 9
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
회 1590
 
7.0%
인 983
 
4.3%
주 891
 
3.9%
구 846
 
3.7%
동 682
 
3.0%
면 672
 
3.0%
노 665
 
2.9%
양 589
 
2.6%
시 550
 
2.4%
축 534
 
2.4%
Other values (349) 14702
64.8%
Uppercase Letter
ValueCountFrequency (%)
C 1711
34.9%
F 1506
30.7%
S 272
 
5.5%
O 165
 
3.4%
T 164
 
3.3%
E 164
 
3.3%
U 138
 
2.8%
D 126
 
2.6%
N 112
 
2.3%
P 97
 
2.0%
Other values (14) 449
 
9.2%
Lowercase Letter
ValueCountFrequency (%)
c 239
30.4%
f 209
26.6%
a 42
 
5.4%
g 38
 
4.8%
w 37
 
4.7%
e 33
 
4.2%
m 30
 
3.8%
n 28
 
3.6%
i 26
 
3.3%
r 25
 
3.2%
Other values (11) 78
 
9.9%
Decimal Number
ValueCountFrequency (%)
2 518
24.5%
3 233
11.0%
0 230
10.9%
1 221
10.4%
6 181
 
8.6%
9 164
 
7.8%
5 160
 
7.6%
4 153
 
7.2%
8 145
 
6.9%
7 111
 
5.2%
Other Punctuation
ValueCountFrequency (%)
. 165
52.5%
, 77
24.5%
& 53
 
16.9%
/ 18
 
5.7%
' 1
 
0.3%
Space Separator
ValueCountFrequency (%)
486
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 64
100.0%
Open Punctuation
ValueCountFrequency (%)
( 38
100.0%
Close Punctuation
ValueCountFrequency (%)
) 36
100.0%
Math Symbol
ValueCountFrequency (%)
~ 9
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 22704
72.2%
Latin 5689
 
18.1%
Common 3064
 
9.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
회 1590
 
7.0%
인 983
 
4.3%
주 891
 
3.9%
구 846
 
3.7%
동 682
 
3.0%
면 672
 
3.0%
노 665
 
2.9%
양 589
 
2.6%
시 550
 
2.4%
축 534
 
2.4%
Other values (349) 14702
64.8%
Latin
ValueCountFrequency (%)
C 1711
30.1%
F 1506
26.5%
S 272
 
4.8%
c 239
 
4.2%
f 209
 
3.7%
O 165
 
2.9%
T 164
 
2.9%
E 164
 
2.9%
U 138
 
2.4%
D 126
 
2.2%
Other values (35) 995
17.5%
Common
ValueCountFrequency (%)
2 518
16.9%
486
15.9%
3 233
7.6%
0 230
7.5%
1 221
 
7.2%
6 181
 
5.9%
. 165
 
5.4%
9 164
 
5.4%
5 160
 
5.2%
4 153
 
5.0%
Other values (11) 553
18.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 22702
72.2%
ASCII 8753
 
27.8%
Compat Jamo 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
C 1711
19.5%
F 1506
17.2%
2 518
 
5.9%
486
 
5.6%
S 272
 
3.1%
c 239
 
2.7%
3 233
 
2.7%
0 230
 
2.6%
1 221
 
2.5%
f 209
 
2.4%
Other values (56) 3128
35.7%
Hangul
ValueCountFrequency (%)
회 1590
 
7.0%
인 983
 
4.3%
주 891
 
3.9%
구 846
 
3.7%
동 682
 
3.0%
면 672
 
3.0%
노 665
 
2.9%
양 589
 
2.6%
시 550
 
2.4%
축 534
 
2.4%
Other values (348) 14700
64.8%
Compat Jamo
ValueCountFrequency (%)
ㆍ 2
100.0%

Correlations

2023-12-12T11:42:46.843053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지역명시설명장소명종목요일사용시작시간사용종료시간
지역명1.0001.0001.0000.6910.2510.5010.523
시설명1.0001.0001.0000.9090.2060.5490.584
장소명1.0001.0001.0001.0000.2940.6930.725
종목0.6910.9091.0001.0000.2280.5050.564
요일0.2510.2060.2940.2281.0000.4430.374
사용시작시간0.5010.5490.6930.5050.4431.0000.984
사용종료시간0.5230.5840.7250.5640.3740.9841.000
2023-12-12T11:42:46.950579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시설명종목요일장소명지역명
시설명1.0000.7590.1030.9991.000
종목0.7591.0000.0810.9990.303
요일0.1030.0811.0000.1350.090
장소명0.9990.9990.1351.0000.999
지역명1.0000.3030.0900.9991.000
2023-12-12T11:42:47.053981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지역명시설명장소명종목요일
지역명1.0001.0000.9990.3030.090
시설명1.0001.0000.9990.7590.103
장소명0.9990.9991.0000.9990.135
종목0.3030.7590.9991.0000.081
요일0.0900.1030.1350.0811.000

Missing values

2023-12-12T11:42:44.089856image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T11:42:44.191359image/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회천2동고덕생활체육공원고덕축구장축구2019-01-02수8:0010:00양주디씨
1회천2동고덕생활체육공원고덕축구장축구2019-01-02수20:0022:00FC킥스
2회천2동고덕생활체육공원고덕축구장축구2019-01-05토8:0010:00예향FC
3회천2동고덕생활체육공원고덕축구장축구2019-01-05토10:0012:00브라더FC
4회천2동고덕생활체육공원고덕축구장축구2019-01-06일8:0010:00FC FIVOTER
5회천2동고덕생활체육공원고덕축구장축구2019-01-06일14:0016:00세븐FC
6회천2동고덕생활체육공원고덕축구장축구2019-01-06일18:0020:00열린FC
7회천2동고덕생활체육공원고덕축구장축구2019-01-07월20:0022:00시민구단
8회천2동고덕생활체육공원고덕축구장축구2019-01-08화20:0022:00시민구단
9회천2동고덕생활체육공원고덕축구장축구2019-01-09수18:0020:00시민구단
지역명시설명장소명종목사용일자요일사용시작시간사용종료시간단체명
6078장흥면장흥생활체육공원장흥축구장축구2019-12-26목20:0022:00장흥면
6079장흥면장흥생활체육공원장흥축구장축구2019-12-27금16:0018:00SC주니어축구클럽
6080장흥면장흥생활체육공원장흥축구장축구2019-12-28토6:008:00어울림FC
6081장흥면장흥생활체육공원장흥축구장축구2019-12-28토8:0012:00장흥면
6082장흥면장흥생활체육공원장흥축구장축구2019-12-28토12:0014:00서포FC
6083장흥면장흥생활체육공원장흥축구장축구2019-12-28토14:0016:00SC주니어축구클럽
6084장흥면장흥생활체육공원장흥축구장축구2019-12-29일8:0012:00장흥면
6085장흥면장흥생활체육공원장흥축구장축구2019-12-30월16:0018:00SC주니어축구클럽
6086장흥면장흥생활체육공원장흥축구장축구2019-12-31화16:0018:00SC주니어축구클럽
6087장흥면장흥생활체육공원장흥축구장축구2019-12-31화20:0022:00장흥면

Duplicate rows

Most frequently occurring

지역명시설명장소명종목사용일자요일사용시작시간사용종료시간단체명# duplicates
48회천3동덕정탁구전용구장덕정탁구전용구장탁구2019-12-05목18:0020:00개인5
44은현면신천생활체육공원신천축구장축구2019-06-09일16:0018:00CUFC4
16양주2동삼숭생활체육공원삼숭테니스장테니스2019-05-02목10:0012:00개인3
17양주2동삼숭생활체육공원삼숭테니스장테니스2019-05-02목12:0014:00개인3
0백석읍백석생활체육공원백석성인야구장야구2019-10-06일19:0022:00양주파파스2
1백석읍백석생활체육공원백석축구장축구2019-02-07목20:0022:00백석연합회2
2백석읍백석생활체육공원백석축구장축구2019-06-02일12:0014:00PLAY2
3백석읍백석생활체육공원백석축구장축구2019-07-10수20:0022:00청솔축구회2
4백석읍백석생활체육공원백석축구장축구2019-10-06일10:0012:00백석축구회2
5백석읍백석생활체육공원백석축구장축구2019-12-19목18:0022:00백석오백회2