Overview

Dataset statistics

Number of variables10
Number of observations365
Missing cells0
Missing cells (%)0.0%
Duplicate rows14
Duplicate rows (%)3.8%
Total size in memory28.6 KiB
Average record size in memory80.4 B

Variable types

Categorical10

Dataset

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

Alerts

Dataset has 14 (3.8%) duplicate rowsDuplicates
종목 is highly overall correlated with 시설명 and 2 other fieldsHigh correlation
읍면동 is highly overall correlated with 시설명 and 2 other fieldsHigh correlation
장소명 is highly overall correlated with 읍면동 and 4 other fieldsHigh correlation
사용종료일자 is highly overall correlated with 사용시작일자 and 1 other fieldsHigh correlation
단체명 is highly overall correlated with 읍면동 and 4 other fieldsHigh correlation
구분 is highly overall correlated with 장소명 and 3 other fieldsHigh correlation
시설명 is highly overall correlated with 읍면동 and 3 other fieldsHigh correlation
사용시작일자 is highly overall correlated with 사용종료일자 and 1 other fieldsHigh correlation
사용시작시간 is highly overall correlated with 사용종료시간High correlation
사용종료시간 is highly overall correlated with 사용시작시간High correlation
종목 is highly imbalanced (60.6%)Imbalance
구분 is highly imbalanced (97.3%)Imbalance

Reproduction

Analysis started2023-12-12 00:24:45.544379
Analysis finished2023-12-12 00:24:47.020532
Duration1.48 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

읍면동
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
양주2동
257 
회천3동
61 
백석읍
 
18
은현면
 
17
광적면
 
12

Length

Max length4
Median length4
Mean length3.8712329
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row광적면
2nd row광적면
3rd row광적면
4th row광적면
5th row광적면

Common Values

ValueCountFrequency (%)
양주2동 257
70.4%
회천3동 61
 
16.7%
백석읍 18
 
4.9%
은현면 17
 
4.7%
광적면 12
 
3.3%

Length

2023-12-12T09:24:47.075422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T09:24:47.166472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
양주2동 257
70.4%
회천3동 61
 
16.7%
백석읍 18
 
4.9%
은현면 17
 
4.7%
광적면 12
 
3.3%

시설명
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
삼숭생활체육공원
257 
덕정돔구장
45 
백석생활체육공원
 
18
신천생활체육공원
 
17
광적생활체육공원
 
12
Other values (2)
 
16

Length

Max length9
Median length8
Mean length7.6438356
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
삼숭생활체육공원 257
70.4%
덕정돔구장 45
 
12.3%
백석생활체육공원 18
 
4.9%
신천생활체육공원 17
 
4.7%
광적생활체육공원 12
 
3.3%
덕정탁구전용구장 11
 
3.0%
옥정배수지체육공원 5
 
1.4%

Length

2023-12-12T09:24:47.272552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T09:24:47.399951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
삼숭생활체육공원 257
70.4%
덕정돔구장 45
 
12.3%
백석생활체육공원 18
 
4.9%
신천생활체육공원 17
 
4.7%
광적생활체육공원 12
 
3.3%
덕정탁구전용구장 11
 
3.0%
옥정배수지체육공원 5
 
1.4%

장소명
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
삼숭테니스장
249 
덕정돔구장
45 
백석테니스장
 
17
신천테니스장
 
16
광적테니스장
 
12
Other values (5)
26 

Length

Max length8
Median length6
Mean length5.909589
Min length5

Unique

Unique2 ?
Unique (%)0.5%

Sample

1st row광적테니스장
2nd row광적테니스장
3rd row광적테니스장
4th row광적테니스장
5th row광적테니스장

Common Values

ValueCountFrequency (%)
삼숭테니스장 249
68.2%
덕정돔구장 45
 
12.3%
백석테니스장 17
 
4.7%
신천테니스장 16
 
4.4%
광적테니스장 12
 
3.3%
덕정탁구전용구장 11
 
3.0%
삼숭족구장 8
 
2.2%
옥정테니스장 5
 
1.4%
백석축구장 1
 
0.3%
신천족구장 1
 
0.3%

Length

2023-12-12T09:24:47.513373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T09:24:47.631920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
삼숭테니스장 249
68.2%
덕정돔구장 45
 
12.3%
백석테니스장 17
 
4.7%
신천테니스장 16
 
4.4%
광적테니스장 12
 
3.3%
덕정탁구전용구장 11
 
3.0%
삼숭족구장 8
 
2.2%
옥정테니스장 5
 
1.4%
백석축구장 1
 
0.3%
신천족구장 1
 
0.3%

종목
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct5
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
테니스
299 
배드민턴
45 
탁구
 
11
족구
 
9
축구
 
1

Length

Max length4
Median length3
Mean length3.0657534
Min length2

Unique

Unique1 ?
Unique (%)0.3%

Sample

1st row테니스
2nd row테니스
3rd row테니스
4th row테니스
5th row테니스

Common Values

ValueCountFrequency (%)
테니스 299
81.9%
배드민턴 45
 
12.3%
탁구 11
 
3.0%
족구 9
 
2.5%
축구 1
 
0.3%

Length

2023-12-12T09:24:47.809088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T09:24:47.911776image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
테니스 299
81.9%
배드민턴 45
 
12.3%
탁구 11
 
3.0%
족구 9
 
2.5%
축구 1
 
0.3%

사용시작일자
Categorical

HIGH CORRELATION 

Distinct13
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
2019-10-01
34 
2019-02-01
33 
2019-04-01
33 
2019-11-01
33 
2019-05-01
32 
Other values (8)
200 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique1 ?
Unique (%)0.3%

Sample

1st row2019-01-01
2nd row2019-02-01
3rd row2019-03-01
4th row2019-04-01
5th row2019-05-01

Common Values

ValueCountFrequency (%)
2019-10-01 34
9.3%
2019-02-01 33
9.0%
2019-04-01 33
9.0%
2019-11-01 33
9.0%
2019-05-01 32
8.8%
2019-07-01 31
8.5%
2019-12-01 31
8.5%
2019-03-01 30
8.2%
2019-06-01 30
8.2%
2019-01-01 28
7.7%
Other values (3) 50
13.7%

Length

2023-12-12T09:24:48.009016image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2019-10-01 34
9.3%
2019-02-01 33
9.0%
2019-04-01 33
9.0%
2019-11-01 33
9.0%
2019-05-01 32
8.8%
2019-07-01 31
8.5%
2019-12-01 31
8.5%
2019-03-01 30
8.2%
2019-06-01 30
8.2%
2019-01-01 28
7.7%
Other values (3) 50
13.7%

사용종료일자
Categorical

HIGH CORRELATION 

Distinct15
Distinct (%)4.1%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
2019-10-31
34 
2019-02-28
33 
2019-11-30
33 
2019-04-30
32 
2019-05-31
32 
Other values (10)
201 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique3 ?
Unique (%)0.8%

Sample

1st row2019-01-31
2nd row2019-02-28
3rd row2019-03-31
4th row2019-04-30
5th row2019-05-31

Common Values

ValueCountFrequency (%)
2019-10-31 34
9.3%
2019-02-28 33
9.0%
2019-11-30 33
9.0%
2019-04-30 32
8.8%
2019-05-31 32
8.8%
2019-07-31 31
8.5%
2019-12-31 31
8.5%
2019-06-30 30
8.2%
2019-03-31 29
7.9%
2019-01-31 28
7.7%
Other values (5) 52
14.2%

Length

2023-12-12T09:24:48.110420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2019-10-31 34
9.3%
2019-02-28 33
9.0%
2019-11-30 33
9.0%
2019-04-30 32
8.8%
2019-05-31 32
8.8%
2019-07-31 31
8.5%
2019-12-31 31
8.5%
2019-06-30 30
8.2%
2019-03-31 29
7.9%
2019-01-31 28
7.7%
Other values (5) 52
14.2%

구분
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
달
364 
주
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)0.3%

Sample

1st row달
2nd row달
3rd row달
4th row달
5th row달

Common Values

ValueCountFrequency (%)
달 364
99.7%
주 1
 
0.3%

Length

2023-12-12T09:24:48.212135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T09:24:48.296938image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
달 364
99.7%
주 1
 
0.3%

사용시작시간
Categorical

HIGH CORRELATION 

Distinct31
Distinct (%)8.5%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
6:00
62 
10:00
57 
19:00
40 
9:00
26 
18:00
18 
Other values (26)
162 

Length

Max length5
Median length5
Mean length4.6
Min length4

Unique

Unique5 ?
Unique (%)1.4%

Sample

1st row6:00
2nd row6:00
3rd row6:00
4th row6:00
5th row6:00

Common Values

ValueCountFrequency (%)
6:00 62
17.0%
10:00 57
15.6%
19:00 40
 
11.0%
9:00 26
 
7.1%
18:00 18
 
4.9%
20:00 16
 
4.4%
7:00 13
 
3.6%
17:00 11
 
3.0%
<NA> 11
 
3.0%
21:00 10
 
2.7%
Other values (21) 101
27.7%

Length

2023-12-12T09:24:48.385863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
6:00 62
17.0%
10:00 57
15.6%
19:00 40
 
11.0%
9:00 26
 
7.1%
18:00 18
 
4.9%
20:00 16
 
4.4%
7:00 13
 
3.6%
17:00 11
 
3.0%
na 11
 
3.0%
21:00 10
 
2.7%
Other values (21) 101
27.7%

사용종료시간
Categorical

HIGH CORRELATION 

Distinct30
Distinct (%)8.2%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
22:00
88 
12:00
52 
21:00
29 
20:00
20 
7:20
 
12
Other values (25)
164 

Length

Max length5
Median length5
Mean length4.8328767
Min length4

Unique

Unique2 ?
Unique (%)0.5%

Sample

1st row22:00
2nd row22:00
3rd row22:00
4th row22:00
5th row22:00

Common Values

ValueCountFrequency (%)
22:00 88
24.1%
12:00 52
14.2%
21:00 29
 
7.9%
20:00 20
 
5.5%
7:20 12
 
3.3%
<NA> 11
 
3.0%
19:20 11
 
3.0%
10:00 11
 
3.0%
20:40 10
 
2.7%
21:40 10
 
2.7%
Other values (20) 111
30.4%

Length

2023-12-12T09:24:48.490006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
22:00 88
24.1%
12:00 52
14.2%
21:00 29
 
7.9%
20:00 20
 
5.5%
7:20 12
 
3.3%
na 11
 
3.0%
19:20 11
 
3.0%
10:00 11
 
3.0%
20:40 10
 
2.7%
21:40 10
 
2.7%
Other values (20) 111
30.4%

단체명
Categorical

HIGH CORRELATION 

Distinct31
Distinct (%)8.5%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
개인
158 
양주시테니스협회
22 
포시즌
20 
은현테니스클럽
16 
용암클럽
 
14
Other values (26)
135 

Length

Max length10
Median length8
Mean length3.630137
Min length2

Unique

Unique8 ?
Unique (%)2.2%

Sample

1st row도락테니스클럽
2nd row도락테니스클럽
3rd row도락테니스클럽
4th row도락테니스클럽
5th row도락테니스클럽

Common Values

ValueCountFrequency (%)
개인 158
43.3%
양주시테니스협회 22
 
6.0%
포시즌 20
 
5.5%
은현테니스클럽 16
 
4.4%
용암클럽 14
 
3.8%
고읍삼숭 13
 
3.6%
도락테니스클럽 12
 
3.3%
양주클럽 12
 
3.3%
포시즌클럽 11
 
3.0%
텐클럽 11
 
3.0%
Other values (21) 76
20.8%

Length

2023-12-12T09:24:48.601698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
개인 158
43.3%
양주시테니스협회 22
 
6.0%
포시즌 20
 
5.5%
은현테니스클럽 16
 
4.4%
용암클럽 14
 
3.8%
고읍삼숭 13
 
3.6%
도락테니스클럽 12
 
3.3%
양주클럽 12
 
3.3%
포시즌클럽 11
 
3.0%
텐클럽 11
 
3.0%
Other values (21) 76
20.8%

Correlations

2023-12-12T09:24:48.684451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
읍면동시설명장소명종목사용시작일자사용종료일자구분사용시작시간사용종료시간단체명
읍면동1.0001.0001.0000.8460.0000.0000.1750.6840.7770.990
시설명1.0001.0001.0000.8200.0000.0000.1880.5960.7090.975
장소명1.0001.0001.0001.0000.6220.6611.0000.7050.6720.989
종목0.8460.8201.0001.0000.2770.3750.2570.6930.3350.991
사용시작일자0.0000.0000.6220.2771.0001.0001.0000.0000.0000.711
사용종료일자0.0000.0000.6610.3751.0001.0001.0000.0000.0000.727
구분0.1750.1881.0000.2571.0001.0001.0000.0000.0001.000
사용시작시간0.6840.5960.7050.6930.0000.0000.0001.0000.9840.666
사용종료시간0.7770.7090.6720.3350.0000.0000.0000.9841.0000.738
단체명0.9900.9750.9890.9910.7110.7271.0000.6660.7381.000
2023-12-12T09:24:48.794189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
종목읍면동장소명사용시작시간사용종료시간사용종료일자단체명구분시설명사용시작일자
종목1.0000.4810.9930.3640.1590.1660.9160.3130.7100.151
읍면동0.4811.0000.9930.3560.4860.0000.9100.2130.9970.000
장소명0.9930.9931.0000.2940.3000.3120.8870.9890.9960.314
사용시작시간0.3640.3560.2941.0000.7600.0000.2010.0000.2870.000
사용종료시간0.1590.4860.3000.7601.0000.0000.2470.0000.3750.000
사용종료일자0.1660.0000.3120.0000.0001.0000.2950.9820.0000.997
단체명0.9160.9100.8870.2010.2470.2951.0000.9590.8400.301
구분0.3130.2130.9890.0000.0000.9820.9591.0000.2000.985
시설명0.7100.9970.9960.2870.3750.0000.8400.2001.0000.000
사용시작일자0.1510.0000.3140.0000.0000.9970.3010.9850.0001.000
2023-12-12T09:24:48.901581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
읍면동시설명장소명종목사용시작일자사용종료일자구분사용시작시간사용종료시간단체명
읍면동1.0000.9970.9930.4810.0000.0000.2130.3560.4860.910
시설명0.9971.0000.9960.7100.0000.0000.2000.2870.3750.840
장소명0.9930.9961.0000.9930.3140.3120.9890.2940.3000.887
종목0.4810.7100.9931.0000.1510.1660.3130.3640.1590.916
사용시작일자0.0000.0000.3140.1511.0000.9970.9850.0000.0000.301
사용종료일자0.0000.0000.3120.1660.9971.0000.9820.0000.0000.295
구분0.2130.2000.9890.3130.9850.9821.0000.0000.0000.959
사용시작시간0.3560.2870.2940.3640.0000.0000.0001.0000.7600.201
사용종료시간0.4860.3750.3000.1590.0000.0000.0000.7601.0000.247
단체명0.9100.8400.8870.9160.3010.2950.9590.2010.2471.000

Missing values

2023-12-12T09:24:46.532724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T09:24:46.972572image/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광적면광적생활체육공원광적테니스장테니스2019-01-012019-01-31달6:0022:00도락테니스클럽
1광적면광적생활체육공원광적테니스장테니스2019-02-012019-02-28달6:0022:00도락테니스클럽
2광적면광적생활체육공원광적테니스장테니스2019-03-012019-03-31달6:0022:00도락테니스클럽
3광적면광적생활체육공원광적테니스장테니스2019-04-012019-04-30달6:0022:00도락테니스클럽
4광적면광적생활체육공원광적테니스장테니스2019-05-012019-05-31달6:0022:00도락테니스클럽
5광적면광적생활체육공원광적테니스장테니스2019-06-012019-06-30달6:0022:00도락테니스클럽
6광적면광적생활체육공원광적테니스장테니스2019-07-012019-07-31달6:0022:00도락테니스클럽
7광적면광적생활체육공원광적테니스장테니스2019-08-012019-08-31달6:0022:00도락테니스클럽
8광적면광적생활체육공원광적테니스장테니스2019-09-012019-09-30달6:0022:00도락테니스클럽
9광적면광적생활체육공원광적테니스장테니스2019-10-012019-10-31달6:0022:00도락테니스클럽
읍면동시설명장소명종목사용시작일자사용종료일자구분사용시작시간사용종료시간단체명
355은현면신천생활체육공원신천테니스장테니스2019-02-012019-02-28달19:0022:00은현테니스클럽
356은현면신천생활체육공원신천테니스장테니스2019-03-012019-03-31달19:0022:00은현테니스클럽
357은현면신천생활체육공원신천테니스장테니스2019-04-012019-04-30달19:0022:00은현테니스클럽
358은현면신천생활체육공원신천테니스장테니스2019-11-012019-11-30달<NA><NA>은현테니스클럽
359은현면신천생활체육공원신천테니스장테니스2019-12-012019-12-31달<NA><NA>은현테니스클럽
360회천3동옥정배수지체육공원옥정테니스장테니스2019-06-012019-06-30달6:0022:00양주시테니스협회
361회천3동옥정배수지체육공원옥정테니스장테니스2019-07-012019-07-31달6:0022:00양주시테니스협회
362회천3동옥정배수지체육공원옥정테니스장테니스2019-11-012019-11-30달6:0022:00양주시테니스협회
363회천3동옥정배수지체육공원옥정테니스장테니스2019-09-012019-09-30달9:0022:00양주시테니스협회
364회천3동옥정배수지체육공원옥정테니스장테니스2019-12-012019-12-31달<NA><NA>양주시테니스협회

Duplicate rows

Most frequently occurring

읍면동시설명장소명종목사용시작일자사용종료일자구분사용시작시간사용종료시간단체명# duplicates
4양주2동삼숭생활체육공원삼숭테니스장테니스2019-04-012019-04-30달10:0012:00개인10
2양주2동삼숭생활체육공원삼숭테니스장테니스2019-02-012019-02-28달10:0012:00개인8
3양주2동삼숭생활체육공원삼숭테니스장테니스2019-03-012019-03-31달10:0012:00개인3
0백석읍백석생활체육공원백석테니스장테니스2019-02-012019-02-28달6:0017:00양주시테니스협회2
1백석읍백석생활체육공원백석테니스장테니스2019-03-012019-03-31달17:0022:00양주시테니스협회2
5양주2동삼숭생활체육공원삼숭테니스장테니스2019-05-012019-05-31달19:0021:00개인2
6양주2동삼숭생활체육공원삼숭테니스장테니스2019-05-012019-05-31달19:4020:00개인2
7양주2동삼숭생활체육공원삼숭테니스장테니스2019-06-012019-06-30달19:0021:00포시즌2
8양주2동삼숭생활체육공원삼숭테니스장테니스2019-10-012019-10-31달10:0012:00용암2
9양주2동삼숭생활체육공원삼숭테니스장테니스2019-10-012019-10-31달19:0019:20포시즌2