Overview

Dataset statistics

Number of variables11
Number of observations213
Missing cells35
Missing cells (%)1.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory18.6 KiB
Average record size in memory89.6 B

Variable types

Categorical3
Text2
DateTime4
Numeric2

Dataset

Description광진중곡체육센터에서 운영하고 있는 강좌명, 강습시간, 강습요일, 정원, 수강료 등을 확인할 수 있습니다. 자세한 내용은 중곡체육팀 3408-4900 으로 문의하여 주시기 바랍니다.
URLhttps://www.data.go.kr/data/15112980/fileData.do

Alerts

장소명 has constant value ""Constant
강좌시작일 has constant value ""Constant
접수종료일 has constant value ""Constant
문의전화 has constant value ""Constant
수강료(월수금_화목) is highly overall correlated with 요일High correlation
요일 is highly overall correlated with 수강료(월수금_화목)High correlation
수강료(월수금_화목) has 35 (16.4%) missing valuesMissing
강좌명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 17:39:27.020030
Analysis finished2023-12-12 17:39:28.565429
Duration1.55 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

장소명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
중곡문화체육센터
213 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row중곡문화체육센터
2nd row중곡문화체육센터
3rd row중곡문화체육센터
4th row중곡문화체육센터
5th row중곡문화체육센터

Common Values

ValueCountFrequency (%)
중곡문화체육센터 213
100.0%

Length

2023-12-13T02:39:28.616407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:39:28.704070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
중곡문화체육센터 213
100.0%

강좌명
Text

UNIQUE 

Distinct213
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-13T02:39:28.862680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length31
Median length23
Mean length15.234742
Min length4

Characters and Unicode

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

Unique

Unique213 ?
Unique (%)100.0%

Sample

1st row새벽수영 06A
2nd row새벽수영 06B
3rd row새벽수영 06C
4th row새벽수영 07A
5th row새벽수영 07B
ValueCountFrequency (%)
a 34
 
5.7%
b 34
 
5.7%
필라테스 19
 
3.2%
소도구 13
 
2.2%
위한 13
 
2.2%
다이어트 12
 
2.0%
c 12
 
2.0%
특화]바른자세&다이어트 12
 
2.0%
요가 11
 
1.8%
오전수영 9
 
1.5%
Other values (266) 426
71.6%
2023-12-13T02:39:29.229500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
382
 
11.8%
] 93
 
2.9%
[ 92
 
2.8%
76
 
2.3%
) 72
 
2.2%
( 72
 
2.2%
69
 
2.1%
68
 
2.1%
67
 
2.1%
B 66
 
2.0%
Other values (286) 2188
67.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2091
64.4%
Space Separator 382
 
11.8%
Uppercase Letter 195
 
6.0%
Close Punctuation 165
 
5.1%
Open Punctuation 164
 
5.1%
Decimal Number 159
 
4.9%
Lowercase Letter 38
 
1.2%
Other Punctuation 37
 
1.1%
Dash Punctuation 8
 
0.2%
Math Symbol 5
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
76
 
3.6%
69
 
3.3%
68
 
3.3%
67
 
3.2%
66
 
3.2%
56
 
2.7%
49
 
2.3%
47
 
2.2%
39
 
1.9%
36
 
1.7%
Other values (232) 1518
72.6%
Uppercase Letter
ValueCountFrequency (%)
B 66
33.8%
A 61
31.3%
C 27
13.8%
S 7
 
3.6%
M 6
 
3.1%
D 6
 
3.1%
E 5
 
2.6%
F 4
 
2.1%
P 3
 
1.5%
L 2
 
1.0%
Other values (7) 8
 
4.1%
Lowercase Letter
ValueCountFrequency (%)
n 9
23.7%
i 4
10.5%
h 3
 
7.9%
a 3
 
7.9%
o 3
 
7.9%
g 3
 
7.9%
c 2
 
5.3%
e 2
 
5.3%
r 2
 
5.3%
u 2
 
5.3%
Other values (4) 5
13.2%
Decimal Number
ValueCountFrequency (%)
1 61
38.4%
0 28
17.6%
2 22
 
13.8%
7 10
 
6.3%
8 9
 
5.7%
9 9
 
5.7%
6 7
 
4.4%
3 6
 
3.8%
5 5
 
3.1%
4 2
 
1.3%
Other Punctuation
ValueCountFrequency (%)
& 26
70.3%
, 7
 
18.9%
! 3
 
8.1%
% 1
 
2.7%
Close Punctuation
ValueCountFrequency (%)
] 93
56.4%
) 72
43.6%
Open Punctuation
ValueCountFrequency (%)
[ 92
56.1%
( 72
43.9%
Math Symbol
ValueCountFrequency (%)
+ 4
80.0%
~ 1
 
20.0%
Space Separator
ValueCountFrequency (%)
382
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2091
64.4%
Common 921
28.4%
Latin 233
 
7.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
76
 
3.6%
69
 
3.3%
68
 
3.3%
67
 
3.2%
66
 
3.2%
56
 
2.7%
49
 
2.3%
47
 
2.2%
39
 
1.9%
36
 
1.7%
Other values (232) 1518
72.6%
Latin
ValueCountFrequency (%)
B 66
28.3%
A 61
26.2%
C 27
11.6%
n 9
 
3.9%
S 7
 
3.0%
M 6
 
2.6%
D 6
 
2.6%
E 5
 
2.1%
F 4
 
1.7%
i 4
 
1.7%
Other values (21) 38
16.3%
Common
ValueCountFrequency (%)
382
41.5%
] 93
 
10.1%
[ 92
 
10.0%
) 72
 
7.8%
( 72
 
7.8%
1 61
 
6.6%
0 28
 
3.0%
& 26
 
2.8%
2 22
 
2.4%
7 10
 
1.1%
Other values (13) 63
 
6.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2091
64.4%
ASCII 1154
35.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
382
33.1%
] 93
 
8.1%
[ 92
 
8.0%
) 72
 
6.2%
( 72
 
6.2%
B 66
 
5.7%
A 61
 
5.3%
1 61
 
5.3%
0 28
 
2.4%
C 27
 
2.3%
Other values (44) 200
17.3%
Hangul
ValueCountFrequency (%)
76
 
3.6%
69
 
3.3%
68
 
3.3%
67
 
3.2%
66
 
3.2%
56
 
2.7%
49
 
2.3%
47
 
2.2%
39
 
1.9%
36
 
1.7%
Other values (232) 1518
72.6%

강좌시작일
Date

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
Minimum2023-03-02 00:00:00
Maximum2023-03-02 00:00:00
2023-12-13T02:39:29.341811image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:39:29.430784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)
Distinct2
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
Minimum2023-03-31 00:00:00
Maximum2023-05-31 00:00:00
2023-12-13T02:39:29.512542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:39:29.597499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=2)

시간
Text

Distinct54
Distinct (%)25.4%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-13T02:39:29.746915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length11
Mean length11
Min length11

Characters and Unicode

Total characters2343
Distinct characters13
Distinct categories4 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique26 ?
Unique (%)12.2%

Sample

1st row06:00-06:50
2nd row06:00-06:50
3rd row06:00-06:50
4th row07:00-07:50
5th row07:00-07:50
ValueCountFrequency (%)
17:00-17:50 17
 
8.0%
10:00-10:50 15
 
7.0%
11:00-11:50 14
 
6.6%
16:00-16:50 14
 
6.6%
12:00-12:50 13
 
6.1%
09:00-09:50 12
 
5.6%
21:00-21:50 11
 
5.2%
19:00-19:50 10
 
4.7%
20:00-20:50 10
 
4.7%
15:00-15:50 9
 
4.2%
Other values (44) 88
41.3%
2023-12-13T02:39:30.025519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 740
31.6%
: 426
18.2%
1 403
17.2%
5 212
 
9.0%
- 210
 
9.0%
2 119
 
5.1%
9 51
 
2.2%
7 46
 
2.0%
6 42
 
1.8%
3 35
 
1.5%
Other values (3) 59
 
2.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1704
72.7%
Other Punctuation 426
 
18.2%
Dash Punctuation 210
 
9.0%
Math Symbol 3
 
0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 740
43.4%
1 403
23.7%
5 212
 
12.4%
2 119
 
7.0%
9 51
 
3.0%
7 46
 
2.7%
6 42
 
2.5%
3 35
 
2.1%
4 29
 
1.7%
8 27
 
1.6%
Other Punctuation
ValueCountFrequency (%)
: 426
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 210
100.0%
Math Symbol
ValueCountFrequency (%)
~ 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2343
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 740
31.6%
: 426
18.2%
1 403
17.2%
5 212
 
9.0%
- 210
 
9.0%
2 119
 
5.1%
9 51
 
2.2%
7 46
 
2.0%
6 42
 
1.8%
3 35
 
1.5%
Other values (3) 59
 
2.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2343
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 740
31.6%
: 426
18.2%
1 403
17.2%
5 212
 
9.0%
- 210
 
9.0%
2 119
 
5.1%
9 51
 
2.2%
7 46
 
2.0%
6 42
 
1.8%
3 35
 
1.5%
Other values (3) 59
 
2.5%

요일
Categorical

HIGH CORRELATION 

Distinct13
Distinct (%)6.1%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
화,목
57 
월,수,금
44 
26 
17 
월,화,수,목,금
15 
Other values (8)
54 

Length

Max length11
Median length9
Mean length3.3286385
Min length1

Unique

Unique1 ?
Unique (%)0.5%

Sample

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

Common Values

ValueCountFrequency (%)
화,목 57
26.8%
월,수,금 44
20.7%
26
12.2%
17
 
8.0%
월,화,수,목,금 15
 
7.0%
12
 
5.6%
11
 
5.2%
9
 
4.2%
월,수 7
 
3.3%
6
 
2.8%
Other values (3) 9
 
4.2%

Length

2023-12-13T02:39:30.140396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
화,목 57
26.8%
월,수,금 44
20.7%
26
12.2%
17
 
8.0%
월,화,수,목,금 15
 
7.0%
12
 
5.6%
11
 
5.2%
9
 
4.2%
월,수 7
 
3.3%
6
 
2.8%
Other values (3) 9
 
4.2%

정원
Real number (ℝ)

Distinct26
Distinct (%)12.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean25.676056
Minimum4
Maximum420
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.0 KiB
2023-12-13T02:39:30.244115image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4
5-th percentile8
Q112
median20
Q330
95-th percentile65
Maximum420
Range416
Interquartile range (IQR)18

Descriptive statistics

Standard deviation32.008891
Coefficient of variation (CV)1.2466436
Kurtosis109.07442
Mean25.676056
Median Absolute Deviation (MAD)9
Skewness9.0829259
Sum5469
Variance1024.5691
MonotonicityNot monotonic
2023-12-13T02:39:30.347958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%)
12 30
14.1%
25 21
9.9%
20 21
9.9%
30 19
 
8.9%
15 15
 
7.0%
8 15
 
7.0%
11 11
 
5.2%
40 11
 
5.2%
35 11
 
5.2%
10 10
 
4.7%
Other values (16) 49
23.0%
ValueCountFrequency (%)
4 4
 
1.9%
5 2
 
0.9%
6 3
 
1.4%
8 15
7.0%
10 10
 
4.7%
11 11
 
5.2%
12 30
14.1%
14 4
 
1.9%
15 15
7.0%
17 2
 
0.9%
ValueCountFrequency (%)
420 1
 
0.5%
80 5
2.3%
70 1
 
0.5%
65 6
2.8%
60 5
2.3%
55 2
 
0.9%
50 2
 
0.9%
45 1
 
0.5%
44 1
 
0.5%
40 11
5.2%

수강료(월수금_화목)
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct31
Distinct (%)17.4%
Missing35
Missing (%)16.4%
Infinite0
Infinite (%)0.0%
Mean78162.921
Minimum22000
Maximum770000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.0 KiB
2023-12-13T02:39:30.447882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum22000
5-th percentile30000
Q140000
median70000
Q3100000
95-th percentile132000
Maximum770000
Range748000
Interquartile range (IQR)60000

Descriptive statistics

Standard deviation67831.558
Coefficient of variation (CV)0.8678227
Kurtosis65.054817
Mean78162.921
Median Absolute Deviation (MAD)30000
Skewness6.9073645
Sum13913000
Variance4.6011202 × 109
MonotonicityNot monotonic
2023-12-13T02:39:30.558239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)
ValueCountFrequency (%)
100000 28
13.1%
90000 21
9.9%
50000 13
 
6.1%
40000 11
 
5.2%
120000 11
 
5.2%
36000 11
 
5.2%
35000 10
 
4.7%
45000 8
 
3.8%
60000 7
 
3.3%
65000 6
 
2.8%
Other values (21) 52
24.4%
(Missing) 35
16.4%
ValueCountFrequency (%)
22000 3
 
1.4%
23000 1
 
0.5%
25000 1
 
0.5%
28000 1
 
0.5%
30000 6
2.8%
33000 6
2.8%
35000 10
4.7%
36000 11
5.2%
39000 1
 
0.5%
40000 11
5.2%
ValueCountFrequency (%)
770000 1
 
0.5%
440000 1
 
0.5%
160000 3
 
1.4%
132000 6
 
2.8%
126000 1
 
0.5%
120000 11
 
5.2%
118000 1
 
0.5%
105000 4
 
1.9%
100000 28
13.1%
95000 1
 
0.5%
Distinct2
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
Minimum2022-02-10 00:00:00
Maximum2022-02-22 00:00:00
2023-12-13T02:39:30.670279image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:39:30.762085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=2)

접수종료일
Date

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
Minimum2022-02-28 00:00:00
Maximum2022-02-28 00:00:00
2023-12-13T02:39:30.840410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:39:30.929526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

문의전화
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
02-3408-4900
213 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row02-3408-4900
2nd row02-3408-4900
3rd row02-3408-4900
4th row02-3408-4900
5th row02-3408-4900

Common Values

ValueCountFrequency (%)
02-3408-4900 213
100.0%

Length

2023-12-13T02:39:31.042297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:39:31.229748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
02-3408-4900 213
100.0%

Interactions

2023-12-13T02:39:27.676330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:39:27.407829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:39:27.813519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:39:27.491631image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T02:39:31.362699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
강좌종료일시간요일정원수강료(월수금_화목)접수시작일
강좌종료일1.0000.7380.9320.1470.2631.000
시간0.7381.0000.9010.4420.0000.738
요일0.9320.9011.0000.5300.7260.932
정원0.1470.4420.5301.0000.8730.147
수강료(월수금_화목)0.2630.0000.7260.8731.0000.263
접수시작일1.0000.7380.9320.1470.2631.000
2023-12-13T02:39:31.517463image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
정원수강료(월수금_화목)요일
정원1.0000.0420.344
수강료(월수금_화목)0.0421.0000.549
요일0.3440.5491.000

Missing values

2023-12-13T02:39:28.045923image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T02:39:28.194252image/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중곡문화체육센터새벽수영 06A2023-03-022023-03-3106:00-06:50월,수,금6055000_390002022-02-222022-02-2802-3408-4900
1중곡문화체육센터새벽수영 06B2023-03-022023-03-3106:00-06:50화,목6046000_330002022-02-222022-02-2802-3408-4900
2중곡문화체육센터새벽수영 06C2023-03-022023-03-3106:00-06:50월,화,수,목,금4077000_540002022-02-222022-02-2802-3408-4900
3중곡문화체육센터새벽수영 07A2023-03-022023-03-3107:00-07:50월,수,금6055000_390002022-02-222022-02-2802-3408-4900
4중곡문화체육센터새벽수영 07B2023-03-022023-03-3107:00-07:50화,목6046000_330002022-02-222022-02-2802-3408-4900
5중곡문화체육센터새벽수영 07C2023-03-022023-03-3107:00-07:50월,화,수,목,금4077000_540002022-02-222022-02-2802-3408-4900
6중곡문화체육센터성인소그룹수영09B2023-03-022023-03-3109:00-09:50화,목41320002022-02-222022-02-2802-3408-4900
7중곡문화체육센터성인소그룹수영10B2023-03-022023-03-3110:00-10:50화,목41320002022-02-222022-02-2802-3408-4900
8중곡문화체육센터성인소그룹수영11B2023-03-022023-03-3111:00-11:50화,목41320002022-02-222022-02-2802-3408-4900
9중곡문화체육센터성인소그룹수영18B2023-03-022023-03-3118:00-18:50화,목41320002022-02-222022-02-2802-3408-4900
장소명강좌명강좌시작일강좌종료일시간요일정원수강료(월수금_화목)접수시작일접수종료일문의전화
203중곡문화체육센터[토]자신감있는 아이로 만드는 동화연극놀이 스피치2023-03-022023-05-3110:00-10:5015900002022-02-102022-02-2802-3408-4900
204중곡문화체육센터[토]키쑥쑥 클래식 유아발레2023-03-022023-05-3113:00-13:5018900002022-02-102022-02-2802-3408-4900
205중곡문화체육센터[토]탄력 S라인 필라테스2023-03-022023-05-3109:00-09:5025600002022-02-102022-02-2802-3408-4900
206중곡문화체육센터[토]통통 창의 클레이&종이접기 A2023-03-022023-05-3110:00-10:5014850002022-02-102022-02-2802-3408-4900
207중곡문화체육센터[토]통통 창의 클레이&종이접기 B2023-03-022023-05-3111:00-11:5014850002022-02-102022-02-2802-3408-4900
208중곡문화체육센터[토]파워다이어트 요가2023-03-022023-05-3110:00-10:5025600002022-02-102022-02-2802-3408-4900
209중곡문화체육센터[토]홍익 창의아트워크(소그룹 드로잉&페인팅) C2023-03-022023-05-3114:00-14:508900002022-02-102022-02-2802-3408-4900
210중곡문화체육센터[토]홍익 창의아트워크(소그룹 초등 창의미술) B2023-03-022023-05-3113:00-13:508900002022-02-102022-02-2802-3408-4900
211중곡문화체육센터[토]홍익 창의아트워크(소그룹 초등 창의미술) D2023-03-022023-05-3115:00-15:508900002022-02-102022-02-2802-3408-4900
212중곡문화체육센터[토]홍익 창의아트워크(소그룹 킨더 창의미술) A2023-03-022023-05-3112:00-12:508900002022-02-102022-02-2802-3408-4900