Overview

Dataset statistics

Number of variables11
Number of observations43
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.9 KiB
Average record size in memory92.1 B

Variable types

Categorical9
Text1
DateTime1

Dataset

Description계양구청사 계양문화센터 프로그램 운영정보에 대한 데이터로, 강좌명, 강사명, 강의시간, 강의요일, 강의실 정보 등 항목을 제공합니다.
Author인천광역시계양구시설관리공단
URLhttps://www.data.go.kr/data/15044571/fileData.do

Alerts

교육장소 has constant value ""Constant
도로명주소 has constant value ""Constant
작성기준일 has constant value ""Constant
정원 is highly overall correlated with 요일 and 1 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 정원 and 1 other fieldsHigh correlation
강의실 is highly overall correlated with 강사명 High correlation
정원 is highly imbalanced (63.5%)Imbalance

Reproduction

Analysis started2023-12-12 09:02:19.831641
Analysis finished2023-12-12 09:02:20.734235
Duration0.9 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

교육장소
Categorical

CONSTANT 

Distinct1
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size476.0 B
계양구청사
43 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row계양구청사
2nd row계양구청사
3rd row계양구청사
4th row계양구청사
5th row계양구청사

Common Values

ValueCountFrequency (%)
계양구청사 43
100.0%

Length

2023-12-12T18:02:20.807169image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:02:20.953717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
계양구청사 43
100.0%

도로명주소
Categorical

CONSTANT 

Distinct1
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size476.0 B
인천광역시 계양구 계산새로88
43 

Length

Max length16
Median length16
Mean length16
Min length16

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row인천광역시 계양구 계산새로88
2nd row인천광역시 계양구 계산새로88
3rd row인천광역시 계양구 계산새로88
4th row인천광역시 계양구 계산새로88
5th row인천광역시 계양구 계산새로88

Common Values

ValueCountFrequency (%)
인천광역시 계양구 계산새로88 43
100.0%

Length

2023-12-12T18:02:21.091386image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:02:21.215446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
인천광역시 43
33.3%
계양구 43
33.3%
계산새로88 43
33.3%

강좌명
Text

Distinct42
Distinct (%)97.7%
Missing0
Missing (%)0.0%
Memory size476.0 B
2023-12-12T18:02:21.451992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length13
Mean length9.2093023
Min length3

Characters and Unicode

Total characters396
Distinct characters124
Distinct categories7 ?
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 (%)95.3%

Sample

1st row캘리그라피,펜드로잉,POP 주간
2nd row캘리그라피,펜드로잉,POP 오후
3rd row캘리그라피,펜드로잉,POP 야간
4th row네일아트
5th row헤어미용반
ValueCountFrequency (%)
일본어 5
 
5.6%
중국어 5
 
5.6%
실용영어 4
 
4.4%
야간 4
 
4.4%
주간 4
 
4.4%
핸드메이드 3
 
3.3%
캘리그라피,펜드로잉,pop 3
 
3.3%
가죽공예 3
 
3.3%
초급 2
 
2.2%
영어 2
 
2.2%
Other values (43) 55
61.1%
2023-12-12T18:02:21.946337image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
49
 
12.4%
어 20
 
5.1%
드 9
 
2.3%
화 9
 
2.3%
영 9
 
2.3%
간 8
 
2.0%
스 8
 
2.0%
중 7
 
1.8%
일 7
 
1.8%
초 7
 
1.8%
Other values (114) 263
66.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 325
82.1%
Space Separator 49
 
12.4%
Uppercase Letter 9
 
2.3%
Other Punctuation 9
 
2.3%
Decimal Number 2
 
0.5%
Open Punctuation 1
 
0.3%
Close Punctuation 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
어 20
 
6.2%
드 9
 
2.8%
화 9
 
2.8%
영 9
 
2.8%
간 8
 
2.5%
스 8
 
2.5%
중 7
 
2.2%
일 7
 
2.2%
초 7
 
2.2%
이 7
 
2.2%
Other values (105) 234
72.0%
Uppercase Letter
ValueCountFrequency (%)
P 6
66.7%
O 3
33.3%
Other Punctuation
ValueCountFrequency (%)
, 6
66.7%
& 3
33.3%
Decimal Number
ValueCountFrequency (%)
2 1
50.0%
1 1
50.0%
Space Separator
ValueCountFrequency (%)
49
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 325
82.1%
Common 62
 
15.7%
Latin 9
 
2.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
어 20
 
6.2%
드 9
 
2.8%
화 9
 
2.8%
영 9
 
2.8%
간 8
 
2.5%
스 8
 
2.5%
중 7
 
2.2%
일 7
 
2.2%
초 7
 
2.2%
이 7
 
2.2%
Other values (105) 234
72.0%
Common
ValueCountFrequency (%)
49
79.0%
, 6
 
9.7%
& 3
 
4.8%
2 1
 
1.6%
( 1
 
1.6%
) 1
 
1.6%
1 1
 
1.6%
Latin
ValueCountFrequency (%)
P 6
66.7%
O 3
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 325
82.1%
ASCII 71
 
17.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
49
69.0%
P 6
 
8.5%
, 6
 
8.5%
& 3
 
4.2%
O 3
 
4.2%
2 1
 
1.4%
( 1
 
1.4%
) 1
 
1.4%
1 1
 
1.4%
Hangul
ValueCountFrequency (%)
어 20
 
6.2%
드 9
 
2.8%
화 9
 
2.8%
영 9
 
2.8%
간 8
 
2.5%
스 8
 
2.5%
중 7
 
2.2%
일 7
 
2.2%
초 7
 
2.2%
이 7
 
2.2%
Other values (105) 234
72.0%

정원
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)4.7%
Missing0
Missing (%)0.0%
Memory size476.0 B
10
40 
5
 
3

Length

Max length2
Median length2
Mean length1.9302326
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row10
2nd row10
3rd row10
4th row5
5th row10

Common Values

ValueCountFrequency (%)
10 40
93.0%
5 3
 
7.0%

Length

2023-12-12T18:02:22.146214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:02:22.262692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
10 40
93.0%
5 3
 
7.0%

요일
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)23.3%
Missing0
Missing (%)0.0%
Memory size476.0 B
목
9 
월
8 
화
7 
화, 목
6 
수
4 
Other values (5)
9 

Length

Max length5
Median length1
Mean length1.9069767
Min length1

Unique

Unique2 ?
Unique (%)4.7%

Sample

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

Common Values

ValueCountFrequency (%)
목 9
20.9%
월 8
18.6%
화 7
16.3%
화, 목 6
14.0%
수 4
9.3%
수, 금 3
 
7.0%
금 2
 
4.7%
화, 금 2
 
4.7%
수,금 1
 
2.3%
월,수,금 1
 
2.3%

Length

2023-12-12T18:02:22.401399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:02:22.599239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
목 15
27.8%
화 15
27.8%
월 8
14.8%
수 7
13.0%
금 7
13.0%
수,금 1
 
1.9%
월,수,금 1
 
1.9%

강의시작시간
Categorical

Distinct21
Distinct (%)48.8%
Missing0
Missing (%)0.0%
Memory size476.0 B
10:00
9 
13:00
4 
13:30
3 
18:30
3 
14:00
3 
Other values (16)
21 

Length

Max length12
Median length5
Mean length5.1162791
Min length4

Unique

Unique12 ?
Unique (%)27.9%

Sample

1st row13:30
2nd row15:30
3rd row19:00
4th row10:00
5th row13:30

Common Values

ValueCountFrequency (%)
10:00 9
20.9%
13:00 4
 
9.3%
13:30 3
 
7.0%
18:30 3
 
7.0%
14:00 3
 
7.0%
16:30 3
 
7.0%
19:00 2
 
4.7%
15:00 2
 
4.7%
11:10 2
 
4.7%
9:00 1
 
2.3%
Other values (11) 11
25.6%

Length

2023-12-12T18:02:22.805524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
10:00 9
20.5%
13:00 4
 
9.1%
13:30 3
 
6.8%
18:30 3
 
6.8%
14:00 3
 
6.8%
16:30 3
 
6.8%
19:00 2
 
4.5%
15:00 2
 
4.5%
11:10 2
 
4.5%
12:00 2
 
4.5%
Other values (11) 11
25.0%

강의종료시간
Date

Distinct24
Distinct (%)55.8%
Missing0
Missing (%)0.0%
Memory size476.0 B
Minimum2023-12-12 10:00:00
Maximum2023-12-12 20:30:00
2023-12-12T18:02:22.966583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:02:23.152688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)

강사명
Categorical

HIGH CORRELATION 

Distinct16
Distinct (%)37.2%
Missing0
Missing (%)0.0%
Memory size476.0 B
김윤미
6 
김령희
5 
이영명
5 
이인순
3 
오연지
3 
Other values (11)
21 

Length

Max length3
Median length3
Mean length2.9302326
Min length2

Unique

Unique4 ?
Unique (%)9.3%

Sample

1st row이인순
2nd row이인순
3rd row이인순
4th row조미숙
5th row조미숙

Common Values

ValueCountFrequency (%)
김윤미 6
14.0%
김령희 5
11.6%
이영명 5
11.6%
이인순 3
 
7.0%
오연지 3
 
7.0%
조진순 3
 
7.0%
정경숙 3
 
7.0%
미정 3
 
7.0%
조미숙 2
 
4.7%
김종은 2
 
4.7%
Other values (6) 8
18.6%

Length

2023-12-12T18:02:23.320418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
김윤미 6
14.0%
김령희 5
11.6%
이영명 5
11.6%
이인순 3
 
7.0%
오연지 3
 
7.0%
조진순 3
 
7.0%
정경숙 3
 
7.0%
미정 3
 
7.0%
조미숙 2
 
4.7%
김종은 2
 
4.7%
Other values (6) 8
18.6%

수강료
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)14.0%
Missing0
Missing (%)0.0%
Memory size476.0 B
90,000
16 
80,000
14 
70,000
10 
100,000
 
1
40,000
 
1

Length

Max length7
Median length6
Mean length6.0232558
Min length6

Unique

Unique3 ?
Unique (%)7.0%

Sample

1st row80,000
2nd row80,000
3rd row80,000
4th row80,000
5th row100,000

Common Values

ValueCountFrequency (%)
90,000 16
37.2%
80,000 14
32.6%
70,000 10
23.3%
100,000 1
 
2.3%
40,000 1
 
2.3%
60,000 1
 
2.3%

Length

2023-12-12T18:02:23.481980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:02:23.619337image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
90,000 16
37.2%
80,000 14
32.6%
70,000 10
23.3%
100,000 1
 
2.3%
40,000 1
 
2.3%
60,000 1
 
2.3%

강의실
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)9.3%
Missing0
Missing (%)0.0%
Memory size476.0 B
6층1교실
13 
6층4교실
12 
6층3교실
12 
7층 생활체육교실
6 

Length

Max length9
Median length5
Mean length5.5581395
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row6층4교실
2nd row6층4교실
3rd row6층4교실
4th row6층3교실
5th row6층4교실

Common Values

ValueCountFrequency (%)
6층1교실 13
30.2%
6층4교실 12
27.9%
6층3교실 12
27.9%
7층 생활체육교실 6
14.0%

Length

2023-12-12T18:02:23.804003image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:02:23.980360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
6층1교실 13
26.5%
6층4교실 12
24.5%
6층3교실 12
24.5%
7층 6
12.2%
생활체육교실 6
12.2%

작성기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size476.0 B
2021-03-01
43 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-03-01
2nd row2021-03-01
3rd row2021-03-01
4th row2021-03-01
5th row2021-03-01

Common Values

ValueCountFrequency (%)
2021-03-01 43
100.0%

Length

2023-12-12T18:02:24.145864image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:02:24.278172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-03-01 43
100.0%

Correlations

2023-12-12T18:02:24.356368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
강좌명정원요일강의시작시간강의종료시간강사명수강료강의실
강좌명1.0000.0000.0000.0000.9531.0000.0001.000
정원0.0001.0000.7230.0000.0000.3660.7430.289
요일0.0000.7231.0000.2770.7710.8650.7680.609
강의시작시간0.0000.0000.2771.0000.9650.6330.4830.615
강의종료시간0.9530.0000.7710.9651.0000.5890.5160.762
강사명1.0000.3660.8650.6330.5891.0000.7550.993
수강료0.0000.7430.7680.4830.5160.7551.0000.457
강의실1.0000.2890.6090.6150.7620.9930.4571.000
2023-12-12T18:02:24.482506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
정원수강료요일강의실강사명강의시작시간
정원1.0000.5230.5040.1830.2160.000
수강료0.5231.0000.5090.2980.4090.150
요일0.5040.5091.0000.3730.5120.000
강의실0.1830.2980.3731.0000.7390.268
강사명0.2160.4090.5120.7391.0000.184
강의시작시간0.0000.1500.0000.2680.1841.000
2023-12-12T18:02:24.647320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
정원요일강의시작시간강사명수강료강의실
정원1.0000.5040.0000.2160.5230.183
요일0.5041.0000.0000.5120.5090.373
강의시작시간0.0000.0001.0000.1840.1500.268
강사명0.2160.5120.1841.0000.4090.739
수강료0.5230.5090.1500.4091.0000.298
강의실0.1830.3730.2680.7390.2981.000

Missing values

2023-12-12T18:02:20.429951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:02:20.665161image/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계양구청사인천광역시 계양구 계산새로88캘리그라피,펜드로잉,POP 주간10화13:3015:00이인순80,0006층4교실2021-03-01
1계양구청사인천광역시 계양구 계산새로88캘리그라피,펜드로잉,POP 오후10화15:3017:00이인순80,0006층4교실2021-03-01
2계양구청사인천광역시 계양구 계산새로88캘리그라피,펜드로잉,POP 야간10화19:0020:30이인순80,0006층4교실2021-03-01
3계양구청사인천광역시 계양구 계산새로88네일아트5수10:0012:00조미숙80,0006층3교실2021-03-01
4계양구청사인천광역시 계양구 계산새로88헤어미용반10수,금13:3015:30조미숙100,0006층4교실2021-03-01
5계양구청사인천광역시 계양구 계산새로88수채화10화19:0020:30최은주90,0006층3교실2021-03-01
6계양구청사인천광역시 계양구 계산새로88김종은 서양화 주간10금10:0013:00김종은90,0006층3교실2021-03-01
7계양구청사인천광역시 계양구 계산새로88김종은 서양화 야간10목18:0020:30김종은90,0006층3교실2021-03-01
8계양구청사인천광역시 계양구 계산새로88보테니컬아트&꽃그림10화10:0012:00오연지90,0006층4교실2021-03-01
9계양구청사인천광역시 계양구 계산새로88풍경스케치 오전10목10:0012:00오연지90,0006층4교실2021-03-01
교육장소도로명주소강좌명정원요일강의시작시간강의종료시간강사명수강료강의실작성기준일
33계양구청사인천광역시 계양구 계산새로88실전여행 일본어10화14:1015:40김윤미70,0006층1교실2021-03-01
34계양구청사인천광역시 계양구 계산새로88일본어 생활 회화10목9:3011:00김윤미70,0006층3교실2021-03-01
35계양구청사인천광역시 계양구 계산새로88함께 읽는 일본소설10목11:1012:40김윤미90,0006층3교실2021-03-01
36계양구청사인천광역시 계양구 계산새로88일본어 초급10목13:3015:00김윤미70,0006층1교실2021-03-01
37계양구청사인천광역시 계양구 계산새로88일본어 중급10목15:1016:40김윤미70,0006층1교실2021-03-01
38계양구청사인천광역시 계양구 계산새로88왕초보 중국어10수16:3018:00이영명70,0006층3교실2021-03-01
39계양구청사인천광역시 계양구 계산새로88입이 트이는 중국어10월15:4017:10이영명70,0006층3교실2021-03-01
40계양구청사인천광역시 계양구 계산새로88완전정복 중국어10화, 금14:0015:30이영명90,0006층3교실2021-03-01
41계양구청사인천광역시 계양구 계산새로88생활 중국어10화, 금16:3018:00이영명90,0006층3교실2021-03-01
42계양구청사인천광역시 계양구 계산새로88중국어 회화 고급10월14:0015:30이영명70,0006층3교실2021-03-01