Overview

Dataset statistics

Number of variables10
Number of observations329
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory27.1 KiB
Average record size in memory84.4 B

Variable types

Numeric4
Categorical2
Text1
DateTime3

Dataset

Description대구시설공단 체육시설 강습정보입니다.
Author대구시설공단
URLhttps://www.data.go.kr/data/15088094/fileData.do

Alerts

순번 is highly overall correlated with 웹수강정원 and 1 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 순번 and 2 other fieldsHigh correlation
강습요일 is highly overall correlated with 방문수강정원 and 1 other fieldsHigh correlation
순번 has unique valuesUnique
방문수강정원 has 291 (88.4%) zerosZeros
웹수강정원 has 235 (71.4%) zerosZeros

Reproduction

Analysis started2023-12-12 16:35:20.229989
Analysis finished2023-12-12 16:35:23.338315
Duration3.11 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct329
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean165
Minimum1
Maximum329
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.0 KiB
2023-12-13T01:35:23.435738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile17.4
Q183
median165
Q3247
95-th percentile312.6
Maximum329
Range328
Interquartile range (IQR)164

Descriptive statistics

Standard deviation95.118347
Coefficient of variation (CV)0.57647483
Kurtosis-1.2
Mean165
Median Absolute Deviation (MAD)82
Skewness0
Sum54285
Variance9047.5
MonotonicityStrictly increasing
2023-12-13T01:35:23.605785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
227 1
 
0.3%
225 1
 
0.3%
224 1
 
0.3%
223 1
 
0.3%
222 1
 
0.3%
221 1
 
0.3%
220 1
 
0.3%
219 1
 
0.3%
218 1
 
0.3%
Other values (319) 319
97.0%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
329 1
0.3%
328 1
0.3%
327 1
0.3%
326 1
0.3%
325 1
0.3%
324 1
0.3%
323 1
0.3%
322 1
0.3%
321 1
0.3%
320 1
0.3%

시설명
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size2.7 KiB
올림픽기념국민생활관
150 
서재문화체육센터
124 
대구실내빙상장
55 

Length

Max length10
Median length8
Mean length8.7446809
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서재문화체육센터
2nd row대구실내빙상장
3rd row대구실내빙상장
4th row대구실내빙상장
5th row대구실내빙상장

Common Values

ValueCountFrequency (%)
올림픽기념국민생활관 150
45.6%
서재문화체육센터 124
37.7%
대구실내빙상장 55
 
16.7%

Length

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

Common Values (Plot)

2023-12-13T01:35:23.915887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
올림픽기념국민생활관 150
45.6%
서재문화체육센터 124
37.7%
대구실내빙상장 55
 
16.7%

강습반명
Text

Distinct281
Distinct (%)85.4%
Missing0
Missing (%)0.0%
Memory size2.7 KiB
2023-12-13T01:35:24.201490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length19
Mean length16.574468
Min length4

Characters and Unicode

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

Unique

Unique244 ?
Unique (%)74.2%

Sample

1st row(13)2차방학배드민턴_주5회
2nd row방학특강[쇼트]_중급15시
3rd row방학특강[쇼트]_초급15시
4th row방학특강[쇼트]_초급16시
5th row방학특강[쇼트]_중급16시
ValueCountFrequency (%)
주2회 27
 
4.7%
주3회 24
 
4.2%
성인 21
 
3.7%
연수 17
 
3.0%
코 17
 
3.0%
자유수영(청소년 17
 
3.0%
일일헬스(청소년 14
 
2.5%
교정a 12
 
2.1%
교정b 12
 
2.1%
레슨 11
 
1.9%
Other values (235) 398
69.8%
2023-12-13T01:35:24.711458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 579
 
10.6%
) 337
 
6.2%
( 337
 
6.2%
1 281
 
5.2%
258
 
4.7%
: 216
 
4.0%
수 206
 
3.8%
/ 179
 
3.3%
영 137
 
2.5%
~ 108
 
2.0%
Other values (117) 2815
51.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2525
46.3%
Decimal Number 1293
23.7%
Other Punctuation 423
 
7.8%
Close Punctuation 388
 
7.1%
Open Punctuation 388
 
7.1%
Space Separator 258
 
4.7%
Math Symbol 108
 
2.0%
Connector Punctuation 29
 
0.5%
Uppercase Letter 27
 
0.5%
Dash Punctuation 14
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
수 206
 
8.2%
영 137
 
5.4%
일 107
 
4.2%
유 103
 
4.1%
자 103
 
4.1%
시 87
 
3.4%
회 78
 
3.1%
주 72
 
2.9%
정 69
 
2.7%
화 68
 
2.7%
Other values (93) 1495
59.2%
Decimal Number
ValueCountFrequency (%)
0 579
44.8%
1 281
21.7%
2 97
 
7.5%
3 65
 
5.0%
6 52
 
4.0%
8 52
 
4.0%
5 45
 
3.5%
4 41
 
3.2%
9 41
 
3.2%
7 40
 
3.1%
Other Punctuation
ValueCountFrequency (%)
: 216
51.1%
/ 179
42.3%
, 28
 
6.6%
Uppercase Letter
ValueCountFrequency (%)
A 14
51.9%
B 12
44.4%
X 1
 
3.7%
Close Punctuation
ValueCountFrequency (%)
) 337
86.9%
] 51
 
13.1%
Open Punctuation
ValueCountFrequency (%)
( 337
86.9%
[ 51
 
13.1%
Space Separator
ValueCountFrequency (%)
258
100.0%
Math Symbol
ValueCountFrequency (%)
~ 108
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 29
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 14
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2901
53.2%
Hangul 2525
46.3%
Latin 27
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
수 206
 
8.2%
영 137
 
5.4%
일 107
 
4.2%
유 103
 
4.1%
자 103
 
4.1%
시 87
 
3.4%
회 78
 
3.1%
주 72
 
2.9%
정 69
 
2.7%
화 68
 
2.7%
Other values (93) 1495
59.2%
Common
ValueCountFrequency (%)
0 579
20.0%
) 337
11.6%
( 337
11.6%
1 281
9.7%
258
8.9%
: 216
 
7.4%
/ 179
 
6.2%
~ 108
 
3.7%
2 97
 
3.3%
3 65
 
2.2%
Other values (11) 444
15.3%
Latin
ValueCountFrequency (%)
A 14
51.9%
B 12
44.4%
X 1
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2928
53.7%
Hangul 2525
46.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 579
19.8%
) 337
11.5%
( 337
11.5%
1 281
9.6%
258
8.8%
: 216
 
7.4%
/ 179
 
6.1%
~ 108
 
3.7%
2 97
 
3.3%
3 65
 
2.2%
Other values (14) 471
16.1%
Hangul
ValueCountFrequency (%)
수 206
 
8.2%
영 137
 
5.4%
일 107
 
4.2%
유 103
 
4.1%
자 103
 
4.1%
시 87
 
3.4%
회 78
 
3.1%
주 72
 
2.9%
정 69
 
2.7%
화 68
 
2.7%
Other values (93) 1495
59.2%

강습시작시간
Date

Distinct28
Distinct (%)8.5%
Missing0
Missing (%)0.0%
Memory size2.7 KiB
Minimum2023-12-13 06:00:00
Maximum2023-12-13 20:00:00
2023-12-13T01:35:24.872130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:35:24.993279image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)

강습종료시간
Date

Distinct44
Distinct (%)13.4%
Missing0
Missing (%)0.0%
Memory size2.7 KiB
Minimum2023-12-13 06:50:00
Maximum2023-12-13 22:00:00
2023-12-13T01:35:25.159413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:35:25.343645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=44)

강습총정원
Real number (ℝ)

Distinct27
Distinct (%)8.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean34.799392
Minimum0
Maximum500
Zeros1
Zeros (%)0.3%
Negative0
Negative (%)0.0%
Memory size3.0 KiB
2023-12-13T01:35:25.516866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile7
Q120
median30
Q342
95-th percentile54
Maximum500
Range500
Interquartile range (IQR)22

Descriptive statistics

Standard deviation41.203494
Coefficient of variation (CV)1.1840291
Kurtosis98.142507
Mean34.799392
Median Absolute Deviation (MAD)12
Skewness8.9291603
Sum11449
Variance1697.7279
MonotonicityNot monotonic
2023-12-13T01:35:25.694845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
42 51
15.5%
20 49
14.9%
30 35
10.6%
15 30
9.1%
46 20
 
6.1%
25 19
 
5.8%
39 15
 
4.6%
54 14
 
4.3%
7 12
 
3.6%
10 11
 
3.3%
Other values (17) 73
22.2%
ValueCountFrequency (%)
0 1
 
0.3%
1 1
 
0.3%
6 10
 
3.0%
7 12
 
3.6%
10 11
 
3.3%
12 1
 
0.3%
13 2
 
0.6%
15 30
9.1%
16 5
 
1.5%
18 5
 
1.5%
ValueCountFrequency (%)
500 2
 
0.6%
100 10
 
3.0%
87 4
 
1.2%
54 14
 
4.3%
50 10
 
3.0%
48 3
 
0.9%
46 20
 
6.1%
43 3
 
0.9%
42 51
15.5%
39 15
 
4.6%

방문수강정원
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct6
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.893617
Minimum0
Maximum100
Zeros291
Zeros (%)88.4%
Negative0
Negative (%)0.0%
Memory size3.0 KiB
2023-12-13T01:35:25.864657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile30
Maximum100
Range100
Interquartile range (IQR)0

Descriptive statistics

Standard deviation18.077684
Coefficient of variation (CV)3.6941355
Kurtosis20.920487
Mean4.893617
Median Absolute Deviation (MAD)0
Skewness4.5650258
Sum1610
Variance326.80267
MonotonicityNot monotonic
2023-12-13T01:35:26.001061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
0 291
88.4%
30 13
 
4.0%
100 10
 
3.0%
15 6
 
1.8%
18 5
 
1.5%
10 4
 
1.2%
ValueCountFrequency (%)
0 291
88.4%
10 4
 
1.2%
15 6
 
1.8%
18 5
 
1.5%
30 13
 
4.0%
100 10
 
3.0%
ValueCountFrequency (%)
100 10
 
3.0%
30 13
 
4.0%
18 5
 
1.5%
15 6
 
1.8%
10 4
 
1.2%
0 291
88.4%

웹수강정원
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct9
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.2462006
Minimum0
Maximum39
Zeros235
Zeros (%)71.4%
Negative0
Negative (%)0.0%
Memory size3.0 KiB
2023-12-13T01:35:26.149064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q315
95-th percentile21
Maximum39
Range39
Interquartile range (IQR)15

Descriptive statistics

Standard deviation8.6745102
Coefficient of variation (CV)1.6534843
Kurtosis0.33269237
Mean5.2462006
Median Absolute Deviation (MAD)0
Skewness1.2849416
Sum1726
Variance75.247127
MonotonicityNot monotonic
2023-12-13T01:35:26.294443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
0 235
71.4%
17 48
 
14.6%
27 14
 
4.3%
18 13
 
4.0%
12 8
 
2.4%
15 6
 
1.8%
21 3
 
0.9%
39 1
 
0.3%
10 1
 
0.3%
ValueCountFrequency (%)
0 235
71.4%
10 1
 
0.3%
12 8
 
2.4%
15 6
 
1.8%
17 48
 
14.6%
18 13
 
4.0%
21 3
 
0.9%
27 14
 
4.3%
39 1
 
0.3%
ValueCountFrequency (%)
39 1
 
0.3%
27 14
 
4.3%
21 3
 
0.9%
18 13
 
4.0%
17 48
 
14.6%
15 6
 
1.8%
12 8
 
2.4%
10 1
 
0.3%
0 235
71.4%

강습요일
Categorical

HIGH CORRELATION 

Distinct13
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size2.7 KiB
화목
44 
월수금
44 
월화수목금
41 
월목
40 
화금
40 
Other values (8)
120 

Length

Max length7
Median length6
Mean length2.8693009
Min length1

Unique

Unique1 ?
Unique (%)0.3%

Sample

1st row월화수목금
2nd row월화수목금
3rd row월화수목금
4th row월화수목금
5th row월화수목금

Common Values

ValueCountFrequency (%)
화목 44
13.4%
월수금 44
13.4%
월화수목금 41
12.5%
월목 40
12.2%
화금 40
12.2%
월화수목금토 30
9.1%
수토 27
8.2%
일 19
5.8%
화목토 18
5.5%
토 17
 
5.2%
Other values (3) 9
 
2.7%

Length

2023-12-13T01:35:26.474054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
화목 44
13.4%
월수금 44
13.4%
월화수목금 41
12.5%
월목 40
12.2%
화금 40
12.2%
월화수목금토 30
9.1%
수토 27
8.2%
일 19
5.8%
화목토 18
5.5%
토 17
 
5.2%
Other values (3) 9
 
2.7%

등록일시
Date

Distinct250
Distinct (%)76.0%
Missing0
Missing (%)0.0%
Memory size2.7 KiB
Minimum2019-12-09 10:15:00
Maximum2021-06-29 13:07:00
2023-12-13T01:35:26.610515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:35:26.754259image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-13T01:35:22.191578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:35:20.706917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:35:21.199596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:35:21.670604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:35:22.320509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:35:20.815941image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:35:21.310957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:35:21.807949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:35:22.441458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:35:20.935652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:35:21.437072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:35:21.937596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:35:22.561796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:35:21.066352image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:35:21.547505image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:35:22.054575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T01:35:26.872813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번시설명강습시작시간강습종료시간강습총정원방문수강정원웹수강정원강습요일
순번1.0000.7070.6330.7790.5150.5730.6080.730
시설명0.7071.0000.7870.8830.2980.5580.4120.848
강습시작시간0.6330.7871.0000.9920.2720.7870.0000.841
강습종료시간0.7790.8830.9921.0000.8970.7880.0000.867
강습총정원0.5150.2980.2720.8971.0000.8940.5250.538
방문수강정원0.5730.5580.7870.7880.8941.0000.0000.708
웹수강정원0.6080.4120.0000.0000.5250.0001.0000.654
강습요일0.7300.8480.8410.8670.5380.7080.6541.000
2023-12-13T01:35:26.997473image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시설명강습요일
시설명1.0000.718
강습요일0.7181.000
2023-12-13T01:35:27.091889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번강습총정원방문수강정원웹수강정원시설명강습요일
순번1.000-0.1520.104-0.5150.5600.409
강습총정원-0.1521.0000.0260.4600.1710.254
방문수강정원0.1040.0261.000-0.2240.5290.503
웹수강정원-0.5150.460-0.2241.0000.3030.373
시설명0.5600.1710.5290.3031.0000.718
강습요일0.4090.2540.5030.3730.7181.000

Missing values

2023-12-13T01:35:23.055093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T01:35:23.243127image/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

순번시설명강습반명강습시작시간강습종료시간강습총정원방문수강정원웹수강정원강습요일등록일시
01서재문화체육센터(13)2차방학배드민턴_주5회13:0013:502000월화수목금2019-12-09 10:15
12대구실내빙상장방학특강[쇼트]_중급15시12:0016:3018180월화수목금2020-01-24 18:14
23대구실내빙상장방학특강[쇼트]_초급15시14:0017:301001000월화수목금2020-01-24 18:15
34대구실내빙상장방학특강[쇼트]_초급16시14:0017:3030300월화수목금2020-01-24 18:17
45대구실내빙상장방학특강[쇼트]_중급16시12:0016:3018180월화수목금2020-01-24 18:17
56대구실내빙상장방학특강[피겨]_중급15시14:0017:3018180월화수목금2020-01-24 18:23
67대구실내빙상장방학특강[피겨]_초급14시14:0017:3015150월화수목금2020-01-24 18:23
78올림픽기념국민생활관스포츠이용권(헬스)_할인6:0022:0050000월화수목금토2020-02-11 10:18
89올림픽기념국민생활관6시교정1(화목/토자유)6:006:5025012화목토2020-02-14 11:56
910올림픽기념국민생활관6시교정2(화목/토자유)6:006:5025012화목토2020-02-14 12:06
순번시설명강습반명강습시작시간강습종료시간강습총정원방문수강정원웹수강정원강습요일등록일시
319320대구실내빙상장정규반[쇼트]-초급/토/1시12:1014:1030300토2021-04-01 14:44
320321서재문화체육센터(19) 초급 탁구 레슨 (주2회)19:0020:00600화목2021-04-26 5:08
321322서재문화체육센터(10) 고급 탁구 레슨 (주2회)10:0011:00600화목2021-04-26 5:09
322323대구실내빙상장정규반[피겨]통합/토/1시12:0013:003000토2021-05-01 10:14
323324서재문화체육센터(15)성인수영 교정B (주2회)15:0015:50700화목2021-06-02 8:38
324325서재문화체육센터(16)성인수영 교정B (주2회)16:3017:20700화목2021-06-02 8:40
325326대구실내빙상장방학특강[피겨]_기초10시9:0013:0030300월화수목금2021-06-23 10:17
326327대구실내빙상장방학특강[피겨]_기초11시9:0013:0030300월화수목금2021-06-23 10:18
327328대구실내빙상장방학특강[피겨]_기초14시9:0013:0030300월화수목금2021-06-23 10:18
328329대구실내빙상장정규반[피겨]통합/수금/3시13:0016:301000수금2021-06-29 13:07