Overview

Dataset statistics

Number of variables11
Number of observations69
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.1 KiB
Average record size in memory90.9 B

Variable types

Categorical6
Text1
DateTime3
Numeric1

Dataset

Description인천광역시부평구시설관리공단에서 운영하는 북부교육문화센터의 프로그램 정보(종목, 요일, 요금 등)에 관한 데이터를 제공합니다.
Author인천광역시부평구시설관리공단
URLhttps://www.data.go.kr/data/15062779/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
어린이요금 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 종목 and 5 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 4 other fieldsHigh correlation
대상 is highly imbalanced (51.5%)Imbalance
어린이요금 is highly imbalanced (62.5%)Imbalance

Reproduction

Analysis started2023-12-12 03:39:12.717191
Analysis finished2023-12-12 03:39:13.994643
Duration1.28 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

종목
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)7.2%
Missing0
Missing (%)0.0%
Memory size684.0 B
수영
28 
GX프로그램
19 
문화강좌
8 
다목적체육관
7 
아쿠아로빅
7 

Length

Max length6
Median length5
Mean length4.0434783
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowGX프로그램
2nd rowGX프로그램
3rd rowGX프로그램
4th rowGX프로그램
5th rowGX프로그램

Common Values

ValueCountFrequency (%)
수영 28
40.6%
GX프로그램 19
27.5%
문화강좌 8
 
11.6%
다목적체육관 7
 
10.1%
아쿠아로빅 7
 
10.1%

Length

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

Common Values (Plot)

2023-12-12T12:39:14.344803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
수영 28
40.6%
gx프로그램 19
27.5%
문화강좌 8
 
11.6%
다목적체육관 7
 
10.1%
아쿠아로빅 7
 
10.1%

반명
Text

Distinct55
Distinct (%)79.7%
Missing0
Missing (%)0.0%
Memory size684.0 B
2023-12-12T12:39:14.712385image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length10
Mean length6.3188406
Min length4

Characters and Unicode

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

Unique

Unique41 ?
Unique (%)59.4%

Sample

1st row다이어트요가1반
2nd row다이어트요가2반
3rd row라인댄스 중급
4th row라인댄스 초급
5th row바디펌프
ValueCountFrequency (%)
소도구 3
 
3.8%
필라테스 3
 
3.8%
어린이반2 2
 
2.5%
라인댄스 2
 
2.5%
어린이 2
 
2.5%
오전반3 2
 
2.5%
새벽반1 2
 
2.5%
새벽반2 2
 
2.5%
어린이반1 2
 
2.5%
아쿠아로빅4 2
 
2.5%
Other values (50) 58
72.5%
2023-12-12T12:39:15.231702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
반 31
 
7.1%
2 16
 
3.7%
1 16
 
3.7%
아 14
 
3.2%
( 14
 
3.2%
) 14
 
3.2%
일 12
 
2.8%
12
 
2.8%
어 11
 
2.5%
스 9
 
2.1%
Other values (84) 287
65.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 348
79.8%
Decimal Number 45
 
10.3%
Open Punctuation 14
 
3.2%
Close Punctuation 14
 
3.2%
Space Separator 12
 
2.8%
Uppercase Letter 3
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
반 31
 
8.9%
아 14
 
4.0%
일 12
 
3.4%
어 11
 
3.2%
스 9
 
2.6%
로 9
 
2.6%
이 9
 
2.6%
구 8
 
2.3%
초 7
 
2.0%
쿠 7
 
2.0%
Other values (74) 231
66.4%
Decimal Number
ValueCountFrequency (%)
2 16
35.6%
1 16
35.6%
3 8
17.8%
4 5
 
11.1%
Uppercase Letter
ValueCountFrequency (%)
C 1
33.3%
B 1
33.3%
A 1
33.3%
Open Punctuation
ValueCountFrequency (%)
( 14
100.0%
Close Punctuation
ValueCountFrequency (%)
) 14
100.0%
Space Separator
ValueCountFrequency (%)
12
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 348
79.8%
Common 85
 
19.5%
Latin 3
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
반 31
 
8.9%
아 14
 
4.0%
일 12
 
3.4%
어 11
 
3.2%
스 9
 
2.6%
로 9
 
2.6%
이 9
 
2.6%
구 8
 
2.3%
초 7
 
2.0%
쿠 7
 
2.0%
Other values (74) 231
66.4%
Common
ValueCountFrequency (%)
2 16
18.8%
1 16
18.8%
( 14
16.5%
) 14
16.5%
12
14.1%
3 8
9.4%
4 5
 
5.9%
Latin
ValueCountFrequency (%)
C 1
33.3%
B 1
33.3%
A 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 348
79.8%
ASCII 88
 
20.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
반 31
 
8.9%
아 14
 
4.0%
일 12
 
3.4%
어 11
 
3.2%
스 9
 
2.6%
로 9
 
2.6%
이 9
 
2.6%
구 8
 
2.3%
초 7
 
2.0%
쿠 7
 
2.0%
Other values (74) 231
66.4%
ASCII
ValueCountFrequency (%)
2 16
18.2%
1 16
18.2%
( 14
15.9%
) 14
15.9%
12
13.6%
3 8
9.1%
4 5
 
5.7%
C 1
 
1.1%
B 1
 
1.1%
A 1
 
1.1%

시작시간
Date

Distinct25
Distinct (%)36.2%
Missing0
Missing (%)0.0%
Memory size684.0 B
Minimum2023-12-12 06:00:00
Maximum2023-12-12 20:00:00
2023-12-12T12:39:15.412213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:39:15.664516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)

종료시간
Date

Distinct25
Distinct (%)36.2%
Missing0
Missing (%)0.0%
Memory size684.0 B
Minimum2023-12-12 06:50:00
Maximum2023-12-12 20:50:00
2023-12-12T12:39:15.782430image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:39:15.917946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)

대상
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct5
Distinct (%)7.2%
Missing0
Missing (%)0.0%
Memory size684.0 B
성인/청소년
53 
초등학생
9 
성인/청소년/어린이
 
5
성인/초등학생
 
1
중고등부
 
1

Length

Max length10
Median length6
Mean length6.0144928
Min length4

Unique

Unique2 ?
Unique (%)2.9%

Sample

1st row성인/청소년
2nd row성인/청소년
3rd row성인/초등학생
4th row성인/청소년
5th row성인/청소년

Common Values

ValueCountFrequency (%)
성인/청소년 53
76.8%
초등학생 9
 
13.0%
성인/청소년/어린이 5
 
7.2%
성인/초등학생 1
 
1.4%
중고등부 1
 
1.4%

Length

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

Common Values (Plot)

2023-12-12T12:39:16.208542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
성인/청소년 53
76.8%
초등학생 9
 
13.0%
성인/청소년/어린이 5
 
7.2%
성인/초등학생 1
 
1.4%
중고등부 1
 
1.4%

요일
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)11.6%
Missing0
Missing (%)0.0%
Memory size684.0 B
월/수/금
28 
화/목
16 
월/화/수/목/금
12 
토
5 
목
3 
Other values (3)
5 

Length

Max length9
Median length5
Mean length4.5072464
Min length1

Unique

Unique1 ?
Unique (%)1.4%

Sample

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

Common Values

ValueCountFrequency (%)
월/수/금 28
40.6%
화/목 16
23.2%
월/화/수/목/금 12
17.4%
토 5
 
7.2%
목 3
 
4.3%
수 2
 
2.9%
수금 2
 
2.9%
금 1
 
1.4%

Length

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

Common Values (Plot)

2023-12-12T12:39:16.505462image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
월/수/금 28
40.6%
화/목 16
23.2%
월/화/수/목/금 12
17.4%
토 5
 
7.2%
목 3
 
4.3%
수 2
 
2.9%
수금 2
 
2.9%
금 1
 
1.4%

요금
Real number (ℝ)

HIGH CORRELATION 

Distinct13
Distinct (%)18.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean50079.71
Minimum6000
Maximum72000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size753.0 B
2023-12-12T12:39:16.617693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum6000
5-th percentile6000
Q144000
median48000
Q366000
95-th percentile72000
Maximum72000
Range66000
Interquartile range (IQR)22000

Descriptive statistics

Standard deviation18520.581
Coefficient of variation (CV)0.36982206
Kurtosis0.50120705
Mean50079.71
Median Absolute Deviation (MAD)14000
Skewness-0.94233568
Sum3455500
Variance3.4301194 × 108
MonotonicityNot monotonic
2023-12-12T12:39:16.751137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
48000 15
21.7%
66000 7
10.1%
72000 7
10.1%
44000 6
 
8.7%
6000 6
 
8.7%
37500 5
 
7.2%
70000 4
 
5.8%
30000 4
 
5.8%
56000 4
 
5.8%
68000 4
 
5.8%
Other values (3) 7
10.1%
ValueCountFrequency (%)
6000 6
 
8.7%
30000 4
 
5.8%
37500 5
 
7.2%
40000 2
 
2.9%
44000 6
 
8.7%
48000 15
21.7%
56000 4
 
5.8%
60000 2
 
2.9%
62000 3
 
4.3%
66000 7
10.1%
ValueCountFrequency (%)
72000 7
10.1%
70000 4
 
5.8%
68000 4
 
5.8%
66000 7
10.1%
62000 3
 
4.3%
60000 2
 
2.9%
56000 4
 
5.8%
48000 15
21.7%
44000 6
 
8.7%
40000 2
 
2.9%

청소년요금
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)7.2%
Missing0
Missing (%)0.0%
Memory size684.0 B
청소년요금 없음
45 
54000
7 
60000
7 
5000
6 
48000
 
4

Length

Max length8
Median length8
Mean length6.8695652
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row청소년요금 없음
2nd row청소년요금 없음
3rd row청소년요금 없음
4th row청소년요금 없음
5th row청소년요금 없음

Common Values

ValueCountFrequency (%)
청소년요금 없음 45
65.2%
54000 7
 
10.1%
60000 7
 
10.1%
5000 6
 
8.7%
48000 4
 
5.8%

Length

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

Common Values (Plot)

2023-12-12T12:39:17.047312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
청소년요금 45
39.5%
없음 45
39.5%
54000 7
 
6.1%
60000 7
 
6.1%
5000 6
 
5.3%
48000 4
 
3.5%

어린이요금
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
어린이요금 없음
64 
3000
 
5

Length

Max length8
Median length8
Mean length7.7101449
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row어린이요금 없음
2nd row어린이요금 없음
3rd row어린이요금 없음
4th row어린이요금 없음
5th row어린이요금 없음

Common Values

ValueCountFrequency (%)
어린이요금 없음 64
92.8%
3000 5
 
7.2%

Length

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

Common Values (Plot)

2023-12-12T12:39:17.351264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
어린이요금 64
48.1%
없음 64
48.1%
3000 5
 
3.8%

기타사항
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)5.8%
Missing0
Missing (%)0.0%
Memory size684.0 B
기타사항 없음
51 
요금은 월 4회기준 강습일수 변동시 가격변동(매월공지) 준비물 개인지참 재료비 담당강사 통해 별도 공지
8 
어린이 이용불가 시간 - 평일 1부 평일 10분전 토요일 정시 입장 5세 이하 입장 불가. 6~7세 입장 시 동성보호자(성인) 동반입장 필수 이용객 증가로 수영장 내 혼잡할 경우 입장제한가능
6 
청소년미만등록불가
 
4

Length

Max length106
Median length7
Mean length21.521739
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row기타사항 없음
2nd row기타사항 없음
3rd row기타사항 없음
4th row기타사항 없음
5th row기타사항 없음

Common Values

ValueCountFrequency (%)
기타사항 없음 51
73.9%
요금은 월 4회기준 강습일수 변동시 가격변동(매월공지) 준비물 개인지참 재료비 담당강사 통해 별도 공지 8
 
11.6%
어린이 이용불가 시간 - 평일 1부 평일 10분전 토요일 정시 입장 5세 이하 입장 불가. 6~7세 입장 시 동성보호자(성인) 동반입장 필수 이용객 증가로 수영장 내 혼잡할 경우 입장제한가능 6
 
8.7%
청소년미만등록불가 4
 
5.8%

Length

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

Common Values (Plot)

2023-12-12T12:39:17.605464image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기타사항 51
 
13.5%
없음 51
 
13.5%
입장 18
 
4.8%
평일 12
 
3.2%
개인지참 8
 
2.1%
별도 8
 
2.1%
통해 8
 
2.1%
담당강사 8
 
2.1%
재료비 8
 
2.1%
공지 8
 
2.1%
Other values (31) 198
52.4%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size684.0 B
Minimum2023-10-31 00:00:00
Maximum2023-10-31 00:00:00
2023-12-12T12:39:17.755451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:39:17.856449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T12:39:13.614161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T12:39:17.979623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
종목반명시작시간종료시간대상요일요금청소년요금어린이요금기타사항
종목1.0001.0000.8610.8260.4350.7380.8080.7600.2000.678
반명1.0001.0000.9990.9990.9970.9180.9720.0000.8201.000
시작시간0.8610.9991.0000.9910.6230.0000.6210.0000.1820.000
종료시간0.8260.9990.9911.0000.9470.0000.5170.0000.0000.000
대상0.4350.9970.6230.9471.0000.3610.4730.7991.0000.570
요일0.7380.9180.0000.0000.3611.0000.8680.6120.5500.946
요금0.8080.9720.6210.5170.4730.8681.0000.784NaN0.911
청소년요금0.7600.0000.0000.0000.7990.6120.7841.0000.7660.840
어린이요금0.2000.8200.1820.0001.0000.550NaN0.7661.0000.988
기타사항0.6781.0000.0000.0000.5700.9460.9110.8400.9881.000
2023-12-12T12:39:18.154434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
종목기타사항청소년요금어린이요금요일대상
종목1.0000.6060.3810.2370.5590.172
기타사항0.6061.0000.8080.8880.6740.492
청소년요금0.3810.8081.0000.8790.4230.422
어린이요금0.2370.8880.8791.0000.3940.977
요일0.5590.6740.4230.3941.0000.222
대상0.1720.4920.4220.9770.2221.000
2023-12-12T12:39:18.286720image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
요금종목대상요일청소년요금어린이요금기타사항
요금1.0000.6860.5190.6200.7490.8530.917
종목0.6861.0000.1720.5590.3810.2370.606
대상0.5190.1721.0000.2220.4220.9770.492
요일0.6200.5590.2221.0000.4230.3940.674
청소년요금0.7490.3810.4220.4231.0000.8790.808
어린이요금0.8530.2370.9770.3940.8791.0000.888
기타사항0.9170.6060.4920.6740.8080.8881.000

Missing values

2023-12-12T12:39:13.754329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T12:39:13.918442image/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

종목반명시작시간종료시간대상요일요금청소년요금어린이요금기타사항데이터기준일자
0GX프로그램다이어트요가1반18:30:0019:20:00성인/청소년화/목44000청소년요금 없음어린이요금 없음기타사항 없음2023-10-31
1GX프로그램다이어트요가2반19:30:0020:20:00성인/청소년화/목44000청소년요금 없음어린이요금 없음기타사항 없음2023-10-31
2GX프로그램라인댄스 중급13:00:0013:50:00성인/초등학생월/수/금48000청소년요금 없음어린이요금 없음기타사항 없음2023-10-31
3GX프로그램라인댄스 초급11:30:0012:20:00성인/청소년월/수/금48000청소년요금 없음어린이요금 없음기타사항 없음2023-10-31
4GX프로그램바디펌프10:30:0011:20:00성인/청소년화/목44000청소년요금 없음어린이요금 없음기타사항 없음2023-10-31
5GX프로그램소도구 필라테스 1반7:30:008:20:00성인/청소년월/수/금48000청소년요금 없음어린이요금 없음기타사항 없음2023-10-31
6GX프로그램소도구 필라테스 2반8:30:009:20:00성인/청소년월/수/금48000청소년요금 없음어린이요금 없음기타사항 없음2023-10-31
7GX프로그램소도구 필라테스 3반16:00:0016:50:00성인/청소년월/수/금48000청소년요금 없음어린이요금 없음기타사항 없음2023-10-31
8GX프로그램어린이방송댄스16:00:0016:50:00초등학생월/수/금48000청소년요금 없음어린이요금 없음기타사항 없음2023-10-31
9GX프로그램요가(주3회)6:30:007:20:00성인/청소년월/수/금48000청소년요금 없음어린이요금 없음기타사항 없음2023-10-31
종목반명시작시간종료시간대상요일요금청소년요금어린이요금기타사항데이터기준일자
59수영저녁반119:00:0019:50:00성인/청소년월/수/금7200060000어린이요금 없음기타사항 없음2023-10-31
60수영저녁반220:00:0020:50:00성인/청소년화/목6600054000어린이요금 없음기타사항 없음2023-10-31
61수영저녁반220:00:0020:50:00성인/청소년월/수/금7200060000어린이요금 없음기타사항 없음2023-10-31
62아쿠아로빅아쿠아로빅18:00:008:50:00성인/청소년화/목62000청소년요금 없음어린이요금 없음기타사항 없음2023-10-31
63아쿠아로빅아쿠아로빅18:00:008:50:00성인/청소년월/수/금68000청소년요금 없음어린이요금 없음기타사항 없음2023-10-31
64아쿠아로빅아쿠아로빅212:00:0012:50:00성인/청소년화/목62000청소년요금 없음어린이요금 없음기타사항 없음2023-10-31
65아쿠아로빅아쿠아로빅212:00:0012:50:00성인/청소년월/수/금68000청소년요금 없음어린이요금 없음기타사항 없음2023-10-31
66아쿠아로빅아쿠아로빅315:00:0015:50:00성인/청소년월/수/금68000청소년요금 없음어린이요금 없음기타사항 없음2023-10-31
67아쿠아로빅아쿠아로빅418:00:0018:50:00성인/청소년화/목62000청소년요금 없음어린이요금 없음기타사항 없음2023-10-31
68아쿠아로빅아쿠아로빅418:00:0018:50:00성인/청소년월/수/금68000청소년요금 없음어린이요금 없음기타사항 없음2023-10-31