Overview

Dataset statistics

Number of variables14
Number of observations5617
Missing cells2
Missing cells (%)< 0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory641.9 KiB
Average record size in memory117.0 B

Variable types

Numeric5
Categorical8
Text1

Dataset

Description일산스포츠센터 강좌정보입니다. 현재 수강가능한 강좌정보를 제공해드립니다. 강좌일련번호, 강좌명, 수강월, 수강기간, 정원, 수강료, 기간 시작일, 종료일 등 정보 제공
URLhttps://www.data.go.kr/data/15114776/fileData.do

Alerts

기간시작일 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 2 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 overall correlated with 강좌번호High correlation
정원 is highly overall correlated with 수강료High correlation
수강료 is highly overall correlated with 정원High correlation
종목 is highly overall correlated with 강좌번호 and 1 other fieldsHigh correlation
시작시간 is highly overall correlated with 종료시간High correlation
종료시간 is highly overall correlated with 시작시간 and 1 other fieldsHigh correlation
수강대상 is highly overall correlated with 종목 and 1 other fieldsHigh correlation
수강료 is highly skewed (γ1 = 25.94549013)Skewed
일련번호 has unique valuesUnique
정원 has 116 (2.1%) zerosZeros

Reproduction

Analysis started2023-12-12 15:21:44.729231
Analysis finished2023-12-12 15:21:50.881436
Duration6.15 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

일련번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct5617
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2809
Minimum1
Maximum5617
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size49.5 KiB
2023-12-13T00:21:50.979438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile281.8
Q11405
median2809
Q34213
95-th percentile5336.2
Maximum5617
Range5616
Interquartile range (IQR)2808

Descriptive statistics

Standard deviation1621.6326
Coefficient of variation (CV)0.57729888
Kurtosis-1.2
Mean2809
Median Absolute Deviation (MAD)1404
Skewness0
Sum15778153
Variance2629692.2
MonotonicityNot monotonic
2023-12-13T00:21:51.153118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4841 1
 
< 0.1%
3465 1
 
< 0.1%
555 1
 
< 0.1%
1154 1
 
< 0.1%
1249 1
 
< 0.1%
2425 1
 
< 0.1%
3716 1
 
< 0.1%
2842 1
 
< 0.1%
4129 1
 
< 0.1%
3762 1
 
< 0.1%
Other values (5607) 5607
99.8%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
5617 1
< 0.1%
5616 1
< 0.1%
5615 1
< 0.1%
5614 1
< 0.1%
5613 1
< 0.1%
5612 1
< 0.1%
5611 1
< 0.1%
5610 1
< 0.1%
5609 1
< 0.1%
5608 1
< 0.1%

강좌번호
Real number (ℝ)

HIGH CORRELATION 

Distinct673
Distinct (%)12.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean845746.2
Minimum19694
Maximum1016705
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size49.5 KiB
2023-12-13T00:21:51.686831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19694
5-th percentile21373
Q11008385
median1012436
Q31014476
95-th percentile1016064
Maximum1016705
Range997011
Interquartile range (IQR)6091

Descriptive statistics

Standard deviation370688.35
Coefficient of variation (CV)0.43829739
Kurtosis1.1418593
Mean845746.2
Median Absolute Deviation (MAD)2687
Skewness-1.7722909
Sum4.7505564 × 109
Variance1.3740985 × 1011
MonotonicityNot monotonic
2023-12-13T00:21:51.870936image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
21966 19
 
0.3%
21971 19
 
0.3%
1012436 19
 
0.3%
1012238 19
 
0.3%
1002263 19
 
0.3%
23684 19
 
0.3%
23562 19
 
0.3%
23561 19
 
0.3%
1012119 19
 
0.3%
1012140 19
 
0.3%
Other values (663) 5427
96.6%
ValueCountFrequency (%)
19694 17
0.3%
19695 19
0.3%
21338 19
0.3%
21339 19
0.3%
21340 19
0.3%
21344 19
0.3%
21345 19
0.3%
21353 19
0.3%
21359 19
0.3%
21361 19
0.3%
ValueCountFrequency (%)
1016705 1
< 0.1%
1016658 1
< 0.1%
1016657 1
< 0.1%
1016656 1
< 0.1%
1016655 1
< 0.1%
1016651 1
< 0.1%
1016650 1
< 0.1%
1016648 1
< 0.1%
1016588 2
< 0.1%
1016560 2
< 0.1%

강좌일련번호
Real number (ℝ)

HIGH CORRELATION 

Distinct136
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean41.880897
Minimum1
Maximum143
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size49.5 KiB
2023-12-13T00:21:52.035601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile5
Q116
median38
Q360
95-th percentile99
Maximum143
Range142
Interquartile range (IQR)44

Descriptive statistics

Standard deviation29.644424
Coefficient of variation (CV)0.70782687
Kurtosis-0.32865032
Mean41.880897
Median Absolute Deviation (MAD)22
Skewness0.6656659
Sum235245
Variance878.7919
MonotonicityNot monotonic
2023-12-13T00:21:52.187605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
7 116
 
2.1%
8 113
 
2.0%
5 113
 
2.0%
9 109
 
1.9%
10 108
 
1.9%
6 103
 
1.8%
12 102
 
1.8%
11 101
 
1.8%
4 99
 
1.8%
13 96
 
1.7%
Other values (126) 4557
81.1%
ValueCountFrequency (%)
1 29
 
0.5%
2 57
1.0%
3 66
1.2%
4 99
1.8%
5 113
2.0%
6 103
1.8%
7 116
2.1%
8 113
2.0%
9 109
1.9%
10 108
1.9%
ValueCountFrequency (%)
143 1
 
< 0.1%
142 1
 
< 0.1%
139 1
 
< 0.1%
138 1
 
< 0.1%
136 1
 
< 0.1%
135 1
 
< 0.1%
134 1
 
< 0.1%
130 2
< 0.1%
129 2
< 0.1%
128 4
0.1%

수강월
Categorical

HIGH CORRELATION 

Distinct19
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size44.0 KiB
Jul-23
390 
Jun-23
386 
Feb-23
377 
Jan-23
 
371
Apr-23
 
356
Other values (14)
3737 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowFeb-23
2nd rowJan-23
3rd rowDec-22
4th rowNov-22
5th rowOct-22

Common Values

ValueCountFrequency (%)
Jul-23 390
 
6.9%
Jun-23 386
 
6.9%
Feb-23 377
 
6.7%
Jan-23 371
 
6.6%
Apr-23 356
 
6.3%
May-23 351
 
6.2%
Mar-23 324
 
5.8%
Dec-22 323
 
5.8%
Nov-22 305
 
5.4%
Jul-22 292
 
5.2%
Other values (9) 2142
38.1%

Length

2023-12-13T00:21:52.344423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
jul-23 390
 
6.9%
jun-23 386
 
6.9%
feb-23 377
 
6.7%
jan-23 371
 
6.6%
apr-23 356
 
6.3%
may-23 351
 
6.2%
mar-23 324
 
5.8%
dec-22 323
 
5.8%
nov-22 305
 
5.4%
jul-22 292
 
5.2%
Other values (9) 2142
38.1%

종목
Categorical

HIGH CORRELATION 

Distinct47
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size44.0 KiB
수영
1211 
골프
655 
기구필라테스
622 
스쿼시
344 
단기속성수영
283 
Other values (42)
2502 

Length

Max length10
Median length8
Mean length3.7751469
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row검도
2nd row검도
3rd row검도
4th row검도
5th row검도

Common Values

ValueCountFrequency (%)
수영 1211
21.6%
골프 655
 
11.7%
기구필라테스 622
 
11.1%
스쿼시 344
 
6.1%
단기속성수영 283
 
5.0%
쥬니어특강 216
 
3.8%
농구 176
 
3.1%
아쿠아로빅 154
 
2.7%
수영소수정예 151
 
2.7%
헬스 127
 
2.3%
Other values (37) 1678
29.9%

Length

2023-12-13T00:21:52.500999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
수영 1211
21.0%
골프 655
 
11.4%
기구필라테스 622
 
10.8%
스쿼시 344
 
6.0%
단기속성수영 283
 
4.9%
쥬니어특강 216
 
3.8%
농구 176
 
3.1%
아쿠아로빅 154
 
2.7%
수영소수정예 151
 
2.6%
헬스 127
 
2.2%
Other values (40) 1819
31.6%

강좌명
Text

Distinct1931
Distinct (%)34.4%
Missing0
Missing (%)0.0%
Memory size44.0 KiB
2023-12-13T00:21:52.770724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length37
Median length28
Mean length16.795086
Min length8

Characters and Unicode

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

Unique

Unique949 ?
Unique (%)16.9%

Sample

1st row검도 21시(월~금)김제휴
2nd row검도 21시(월~금)김제휴
3rd row검도 21시(월~금)오정환
4th row검도 21시(월~금)오정환
5th row검도 21시(월~금)오정환
ValueCountFrequency (%)
수영 639
 
4.8%
기구필라 440
 
3.3%
강습 274
 
2.1%
스쿼시 237
 
1.8%
농구 183
 
1.4%
기구필라테스 182
 
1.4%
10시 162
 
1.2%
09시 160
 
1.2%
아쿠아로빅 154
 
1.2%
소수정예 151
 
1.1%
Other values (1354) 10676
80.5%
2023-12-13T00:21:53.200539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7796
 
8.3%
( 5962
 
6.3%
) 5960
 
6.3%
시 5400
 
5.7%
1 4512
 
4.8%
수 3316
 
3.5%
월 2895
 
3.1%
금 2485
 
2.6%
0 2431
 
2.6%
. 2117
 
2.2%
Other values (295) 51464
54.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 56240
59.6%
Decimal Number 13283
 
14.1%
Space Separator 7796
 
8.3%
Open Punctuation 5962
 
6.3%
Close Punctuation 5960
 
6.3%
Other Punctuation 2907
 
3.1%
Math Symbol 1429
 
1.5%
Uppercase Letter 665
 
0.7%
Lowercase Letter 96
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 5400
 
9.6%
수 3316
 
5.9%
월 2895
 
5.1%
금 2485
 
4.4%
화 1933
 
3.4%
목 1933
 
3.4%
정 1583
 
2.8%
영 1489
 
2.6%
기 1478
 
2.6%
스 1298
 
2.3%
Other values (266) 32430
57.7%
Decimal Number
ValueCountFrequency (%)
1 4512
34.0%
0 2431
18.3%
2 1484
 
11.2%
6 1031
 
7.8%
7 940
 
7.1%
9 805
 
6.1%
3 665
 
5.0%
8 512
 
3.9%
4 457
 
3.4%
5 446
 
3.4%
Uppercase Letter
ValueCountFrequency (%)
A 298
44.8%
B 79
 
11.9%
E 72
 
10.8%
N 72
 
10.8%
P 72
 
10.8%
S 72
 
10.8%
Other Punctuation
ValueCountFrequency (%)
. 2117
72.8%
* 545
 
18.7%
, 214
 
7.4%
: 30
 
1.0%
/ 1
 
< 0.1%
Lowercase Letter
ValueCountFrequency (%)
r 32
33.3%
o 32
33.3%
t 32
33.3%
Math Symbol
ValueCountFrequency (%)
~ 1423
99.6%
+ 6
 
0.4%
Space Separator
ValueCountFrequency (%)
7796
100.0%
Open Punctuation
ValueCountFrequency (%)
( 5962
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5960
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 56240
59.6%
Common 37337
39.6%
Latin 761
 
0.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 5400
 
9.6%
수 3316
 
5.9%
월 2895
 
5.1%
금 2485
 
4.4%
화 1933
 
3.4%
목 1933
 
3.4%
정 1583
 
2.8%
영 1489
 
2.6%
기 1478
 
2.6%
스 1298
 
2.3%
Other values (266) 32430
57.7%
Common
ValueCountFrequency (%)
7796
20.9%
( 5962
16.0%
) 5960
16.0%
1 4512
12.1%
0 2431
 
6.5%
. 2117
 
5.7%
2 1484
 
4.0%
~ 1423
 
3.8%
6 1031
 
2.8%
7 940
 
2.5%
Other values (10) 3681
9.9%
Latin
ValueCountFrequency (%)
A 298
39.2%
B 79
 
10.4%
E 72
 
9.5%
N 72
 
9.5%
P 72
 
9.5%
S 72
 
9.5%
r 32
 
4.2%
o 32
 
4.2%
t 32
 
4.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 56240
59.6%
ASCII 38098
40.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
7796
20.5%
( 5962
15.6%
) 5960
15.6%
1 4512
11.8%
0 2431
 
6.4%
. 2117
 
5.6%
2 1484
 
3.9%
~ 1423
 
3.7%
6 1031
 
2.7%
7 940
 
2.5%
Other values (19) 4442
11.7%
Hangul
ValueCountFrequency (%)
시 5400
 
9.6%
수 3316
 
5.9%
월 2895
 
5.1%
금 2485
 
4.4%
화 1933
 
3.4%
목 1933
 
3.4%
정 1583
 
2.8%
영 1489
 
2.6%
기 1478
 
2.6%
스 1298
 
2.3%
Other values (266) 32430
57.7%

시작시간
Categorical

HIGH CORRELATION 

Distinct24
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size44.0 KiB
09:00
627 
06:00
518 
10:00
501 
11:00
461 
17:00
442 
Other values (19)
3068 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
09:00 627
11.2%
06:00 518
 
9.2%
10:00 501
 
8.9%
11:00 461
 
8.2%
17:00 442
 
7.9%
16:00 403
 
7.2%
20:00 343
 
6.1%
19:00 334
 
5.9%
15:00 309
 
5.5%
18:00 293
 
5.2%
Other values (14) 1386
24.7%

Length

2023-12-13T00:21:53.374104image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
09:00 627
11.2%
06:00 518
 
9.2%
10:00 501
 
8.9%
11:00 461
 
8.2%
17:00 442
 
7.9%
16:00 403
 
7.2%
20:00 343
 
6.1%
19:00 334
 
5.9%
15:00 309
 
5.5%
18:00 293
 
5.2%
Other values (14) 1386
24.7%

종료시간
Categorical

HIGH CORRELATION 

Distinct50
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size44.0 KiB
21:50
565 
10:50
486 
09:50
441 
17:50
384 
16:50
366 
Other values (45)
3375 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
21:50 565
 
10.1%
10:50 486
 
8.7%
09:50 441
 
7.9%
17:50 384
 
6.8%
16:50 366
 
6.5%
11:50 360
 
6.4%
20:50 291
 
5.2%
18:50 257
 
4.6%
19:50 245
 
4.4%
15:50 239
 
4.3%
Other values (40) 1983
35.3%

Length

2023-12-13T00:21:53.515440image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
21:50 565
 
10.1%
10:50 486
 
8.7%
09:50 441
 
7.9%
17:50 384
 
6.8%
16:50 366
 
6.5%
11:50 360
 
6.4%
20:50 291
 
5.2%
18:50 257
 
4.6%
19:50 245
 
4.4%
15:50 239
 
4.3%
Other values (40) 1983
35.3%

정원
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct48
Distinct (%)0.9%
Missing2
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean21.762778
Minimum0
Maximum370
Zeros116
Zeros (%)2.1%
Negative0
Negative (%)0.0%
Memory size49.5 KiB
2023-12-13T00:21:53.701598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile3
Q17
median15
Q330
95-th percentile50
Maximum370
Range370
Interquartile range (IQR)23

Descriptive statistics

Standard deviation34.31181
Coefficient of variation (CV)1.5766282
Kurtosis51.801092
Mean21.762778
Median Absolute Deviation (MAD)10
Skewness6.6820665
Sum122198
Variance1177.3003
MonotonicityNot monotonic
2023-12-13T00:21:53.888362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=48)
ValueCountFrequency (%)
30 958
17.1%
20 922
16.4%
3 520
9.3%
10 517
9.2%
5 432
7.7%
12 318
 
5.7%
40 296
 
5.3%
15 234
 
4.2%
8 188
 
3.3%
7 170
 
3.0%
Other values (38) 1060
18.9%
ValueCountFrequency (%)
0 116
 
2.1%
1 124
 
2.2%
3 520
9.3%
4 60
 
1.1%
5 432
7.7%
6 127
 
2.3%
7 170
 
3.0%
8 188
 
3.3%
10 517
9.2%
12 318
5.7%
ValueCountFrequency (%)
370 3
 
0.1%
326 2
 
< 0.1%
316 1
 
< 0.1%
300 57
1.0%
264 1
 
< 0.1%
258 1
 
< 0.1%
239 1
 
< 0.1%
238 1
 
< 0.1%
195 1
 
< 0.1%
190 1
 
< 0.1%

수강요일
Categorical

Distinct22
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size44.0 KiB
화,목
1176 
월,수,금
931 
월,화,수,목,금,토,일
871 
월,화,수,목,금
630 
월,수
424 
Other values (17)
1585 

Length

Max length13
Median length11
Mean length6.3626491
Min length1

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
화,목 1176
20.9%
월,수,금 931
16.6%
월,화,수,목,금,토,일 871
15.5%
월,화,수,목,금 630
11.2%
월,수 424
 
7.5%
월,화,수,목,금,일 366
 
6.5%
월,화,수,목,금,토 225
 
4.0%
토 223
 
4.0%
화,목,토 209
 
3.7%
금 158
 
2.8%
Other values (12) 404
 
7.2%

Length

2023-12-13T00:21:54.057203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
화,목 1176
20.9%
월,수,금 931
16.6%
월,화,수,목,금,토,일 871
15.5%
월,화,수,목,금 630
11.2%
월,수 424
 
7.5%
월,화,수,목,금,일 366
 
6.5%
월,화,수,목,금,토 225
 
4.0%
토 223
 
4.0%
화,목,토 209
 
3.7%
금 158
 
2.8%
Other values (12) 404
 
7.2%

수강대상
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size44.0 KiB
성인남여및청소년
2143 
<NA>
1941 
성인남여
750 
청소년
718 
성인여성
 
65

Length

Max length8
Median length4
Mean length5.3982553
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row성인남여
2nd row성인남여
3rd row성인남여
4th row성인남여
5th row성인남여

Common Values

ValueCountFrequency (%)
성인남여및청소년 2143
38.2%
<NA> 1941
34.6%
성인남여 750
 
13.4%
청소년 718
 
12.8%
성인여성 65
 
1.2%

Length

2023-12-13T00:21:54.196058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:21:54.325220image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
성인남여및청소년 2143
38.2%
na 1941
34.6%
성인남여 750
 
13.4%
청소년 718
 
12.8%
성인여성 65
 
1.2%

수강료
Real number (ℝ)

HIGH CORRELATION  SKEWED 

Distinct98
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean101714.39
Minimum4600
Maximum6600000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size49.5 KiB
2023-12-13T00:21:54.521788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4600
5-th percentile33000
Q160000
median70000
Q3100000
95-th percentile200000
Maximum6600000
Range6595400
Interquartile range (IQR)40000

Descriptive statistics

Standard deviation175219.89
Coefficient of variation (CV)1.7226658
Kurtosis845.53102
Mean101714.39
Median Absolute Deviation (MAD)20000
Skewness25.94549
Sum5.7132972 × 108
Variance3.0702011 × 1010
MonotonicityNot monotonic
2023-12-13T00:21:54.697345image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
160000 555
 
9.9%
80000 445
 
7.9%
70000 337
 
6.0%
60000 294
 
5.2%
64000 259
 
4.6%
100000 256
 
4.6%
180000 237
 
4.2%
96000 195
 
3.5%
65000 193
 
3.4%
95000 193
 
3.4%
Other values (88) 2653
47.2%
ValueCountFrequency (%)
4600 1
 
< 0.1%
7000 1
 
< 0.1%
8620 1
 
< 0.1%
8840 1
 
< 0.1%
9050 1
 
< 0.1%
9100 1
 
< 0.1%
9350 1
 
< 0.1%
10000 8
0.1%
10100 1
 
< 0.1%
10560 1
 
< 0.1%
ValueCountFrequency (%)
6600000 1
 
< 0.1%
6500000 1
 
< 0.1%
4400000 3
 
0.1%
595000 5
 
0.1%
570000 26
0.5%
565000 10
 
0.2%
550000 1
 
< 0.1%
545000 10
 
0.2%
540000 26
0.5%
520000 14
0.2%

기간시작일
Categorical

HIGH CORRELATION 

Distinct20
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size44.0 KiB
2023-07-01
390 
2023-06-01
386 
2023-02-01
 
374
2023-01-01
 
371
2023-04-01
 
356
Other values (15)
3740 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-02-01
2nd row2023-01-01
3rd row2022-12-01
4th row2022-11-01
5th row2022-10-01

Common Values

ValueCountFrequency (%)
2023-07-01 390
 
6.9%
2023-06-01 386
 
6.9%
2023-02-01 374
 
6.7%
2023-01-01 371
 
6.6%
2023-04-01 356
 
6.3%
2023-05-01 351
 
6.2%
2023-03-01 324
 
5.8%
2022-12-01 323
 
5.8%
2022-11-01 305
 
5.4%
2022-07-01 292
 
5.2%
Other values (10) 2145
38.2%

Length

2023-12-13T00:21:54.891041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2023-07-01 390
 
6.9%
2023-06-01 386
 
6.9%
2023-02-01 374
 
6.7%
2023-01-01 371
 
6.6%
2023-04-01 356
 
6.3%
2023-05-01 351
 
6.2%
2023-03-01 324
 
5.8%
2022-12-01 323
 
5.8%
2022-11-01 305
 
5.4%
2022-07-01 292
 
5.2%
Other values (10) 2145
38.2%

기간종료일
Categorical

HIGH CORRELATION 

Distinct20
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size44.0 KiB
9999-12-31
391 
2023-06-30
385 
2023-02-28
377 
2023-01-31
 
371
2023-04-30
 
356
Other values (15)
3737 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-02-28
2nd row2023-01-31
3rd row2022-12-31
4th row2022-11-30
5th row2022-10-31

Common Values

ValueCountFrequency (%)
9999-12-31 391
 
7.0%
2023-06-30 385
 
6.9%
2023-02-28 377
 
6.7%
2023-01-31 371
 
6.6%
2023-04-30 356
 
6.3%
2023-05-31 351
 
6.2%
2022-12-31 346
 
6.2%
2023-03-31 324
 
5.8%
2022-11-30 308
 
5.5%
2022-09-30 281
 
5.0%
Other values (10) 2127
37.9%

Length

2023-12-13T00:21:55.039924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
9999-12-31 391
 
7.0%
2023-06-30 385
 
6.9%
2023-02-28 377
 
6.7%
2023-01-31 371
 
6.6%
2023-04-30 356
 
6.3%
2023-05-31 351
 
6.2%
2022-12-31 346
 
6.2%
2023-03-31 324
 
5.8%
2022-11-30 308
 
5.5%
2022-09-30 281
 
5.0%
Other values (10) 2127
37.9%

Interactions

2023-12-13T00:21:49.840789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:47.255242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:47.890691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:48.530623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:49.183256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:49.968858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:47.377583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:48.010386image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:48.643637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:49.306055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:50.094478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:47.487967image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:48.135189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:48.763302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:49.435742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:50.217584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:47.619079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:48.261194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:48.905628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:49.569394image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:50.340190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:47.755571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:48.383998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:49.042521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:21:49.709367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T00:21:55.165916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호강좌번호강좌일련번호수강월종목시작시간종료시간정원수강요일수강대상수강료기간시작일기간종료일
일련번호1.0000.1760.4010.8660.5770.3160.4140.1250.3520.3580.0660.9130.911
강좌번호0.1761.0000.7950.1120.8980.3220.4080.0440.4480.1720.0000.1250.135
강좌일련번호0.4010.7951.0000.3140.6610.3530.5060.2040.4890.3110.0000.3630.374
수강월0.8660.1120.3141.0000.3120.2040.0000.0750.4010.2190.0151.0000.999
종목0.5770.8980.6610.3121.0000.8790.9460.7570.9250.9810.4720.3030.410
시작시간0.3160.3220.3530.2040.8791.0000.9890.4350.6380.6860.1770.2010.212
종료시간0.4140.4080.5060.0000.9460.9891.0000.6200.8540.7760.4720.0000.000
정원0.1250.0440.2040.0750.7570.4350.6201.0000.3730.2810.0000.0670.065
수강요일0.3520.4480.4890.4010.9250.6380.8540.3731.0000.6240.0000.3970.401
수강대상0.3580.1720.3110.2190.9810.6860.7760.2810.6241.0000.0470.2500.311
수강료0.0660.0000.0000.0150.4720.1770.4720.0000.0000.0471.0000.0000.000
기간시작일0.9130.1250.3631.0000.3030.2010.0000.0670.3970.2500.0001.0001.000
기간종료일0.9110.1350.3740.9990.4100.2120.0000.0650.4010.3110.0001.0001.000
2023-12-13T00:21:55.331001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
종목기간시작일종료시간수강월수강요일수강대상시작시간기간종료일
종목1.0000.0790.4360.0830.4990.8950.3910.112
기간시작일0.0791.0000.0001.0000.1220.1200.0560.966
종료시간0.4360.0001.0000.0000.3670.5100.7990.000
수강월0.0831.0000.0001.0000.1260.1210.0590.993
수강요일0.4990.1220.3670.1261.0000.3410.2190.123
수강대상0.8950.1200.5100.1210.3411.0000.4400.151
시작시간0.3910.0560.7990.0590.2190.4401.0000.060
기간종료일0.1120.9660.0000.9930.1230.1510.0601.000
2023-12-13T00:21:55.469658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호강좌번호강좌일련번호정원수강료수강월종목시작시간종료시간수강요일수강대상기간시작일기간종료일
일련번호1.0000.1960.1420.0370.0150.5570.2360.1210.1440.1380.2210.5570.554
강좌번호0.1961.000-0.725-0.057-0.0330.0980.8050.2520.3220.3530.1090.0980.105
강좌일련번호0.142-0.7251.0000.0780.0920.1220.2910.1370.1850.2040.1900.1220.126
정원0.037-0.0570.0781.000-0.5580.0290.3890.1810.2740.1540.1830.0260.025
수강료0.015-0.0330.092-0.5581.0000.0080.2590.0810.2580.0000.0450.0000.000
수강월0.5570.0980.1220.0290.0081.0000.0830.0590.0000.1260.1211.0000.993
종목0.2360.8050.2910.3890.2590.0831.0000.3910.4360.4990.8950.0790.112
시작시간0.1210.2520.1370.1810.0810.0590.3911.0000.7990.2190.4400.0560.060
종료시간0.1440.3220.1850.2740.2580.0000.4360.7991.0000.3670.5100.0000.000
수강요일0.1380.3530.2040.1540.0000.1260.4990.2190.3671.0000.3410.1220.123
수강대상0.2210.1090.1900.1830.0450.1210.8950.4400.5100.3411.0000.1200.151
기간시작일0.5570.0980.1220.0260.0001.0000.0790.0560.0000.1220.1201.0000.966
기간종료일0.5540.1050.1260.0250.0000.9930.1120.0600.0000.1230.1510.9661.000

Missing values

2023-12-13T00:21:50.526109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T00:21:50.780349image/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

일련번호강좌번호강좌일련번호수강월종목강좌명시작시간종료시간정원수강요일수강대상수강료기간시작일기간종료일
04841100286092Feb-23검도검도 21시(월~금)김제휴21:0022:3020월,화,수,목,금성인남여700002023-02-012023-02-28
12585100286078Jan-23검도검도 21시(월~금)김제휴21:0022:3020월,화,수,목,금성인남여700002023-01-012023-01-31
23603100286072Dec-22검도검도 21시(월~금)오정환21:0022:3020월,화,수,목,금성인남여700002022-12-012022-12-31
33970100286071Nov-22검도검도 21시(월~금)오정환21:0022:3020월,화,수,목,금성인남여700002022-11-012022-11-30
44175100286070Oct-22검도검도 21시(월~금)오정환21:0022:3020월,화,수,목,금성인남여700002022-10-012022-10-31
52678100286069Sep-22검도검도 21시(월~금)오정환21:0022:3020월,화,수,목,금성인남여700002022-09-012022-09-30
6847100286068Aug-22검도검도 21시(월~금)오정환21:0022:3020월,화,수,목,금성인남여700002022-08-012022-08-31
759100286067Jul-22검도검도 21시(월~금)오정환21:0022:3020월,화,수,목,금성인남여700002022-07-012022-07-31
81037100286066Jun-22검도검도 21시(월~금)오정환21:0022:3020월,화,수,목,금성인남여700002022-06-012022-06-30
91146100286065May-22검도검도 21시(월~금)오정환21:0022:3020월,화,수,목,금성인남여700002022-05-012022-05-31
일련번호강좌번호강좌일련번호수강월종목강좌명시작시간종료시간정원수강요일수강대상수강료기간시작일기간종료일
56072948101615013May-23골프단기속성단기속성 20시(화목)김제성20:0020:504월,화,수,목,금,토,일성인남여2100002023-05-012023-05-31
56082949101615014Apr-23골프단기속성단기속성 20시(화목)김제성20:0020:504월,화,수,목,금,토,일성인남여2100002023-04-012023-04-30
56092950101614910Jul-23골프단기속성단기속성 18시(화목)김제성18:0018:504월,화,수,목,금,토,일성인남여2100002023-07-019999-12-31
56102951101614911Jun-23골프단기속성단기속성 18시(화목)김제성18:0018:504월,화,수,목,금,토,일성인남여2100002023-06-012023-06-30
56112952101614912May-23골프단기속성단기속성 18시(화목)김제성18:0018:504월,화,수,목,금,토,일성인남여2100002023-05-012023-05-31
56122953101614913Apr-23골프단기속성단기속성 18시(화목)김제성18:0018:504월,화,수,목,금,토,일성인남여2100002023-04-012023-04-30
56132954101614810Jul-23골프단기속성단기속성 16시(화목)김제성16:0016:504월,화,수,목,금,토,일성인남여2100002023-07-019999-12-31
56142955101614811Jun-23골프단기속성단기속성 16시(화목)김제성16:0016:504월,화,수,목,금,토,일성인남여2100002023-06-012023-06-30
56152956101614812May-23골프단기속성단기속성 16시(화목)김제성16:0016:504월,화,수,목,금,토,일성인남여2100002023-05-012023-05-31
56162957101614813Apr-23골프단기속성단기속성 16시(화목)김제성16:0016:504월,화,수,목,금,토,일성인남여2100002023-04-012023-04-30