Overview

Dataset statistics

Number of variables9
Number of observations38
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.8 KiB
Average record size in memory76.4 B

Variable types

Numeric1
Text2
Categorical6

Dataset

Description대구광역시 동구_도서관 문화강좌_20220711
Author대구광역시 동구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15102150&dataSetDetailId=1510215018e44f04260e9&provdMethod=FILE

Alerts

데이터기준일자 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 2 other fieldsHigh correlation
연번 has unique valuesUnique

Reproduction

Analysis started2024-04-20 22:57:53.482137
Analysis finished2024-04-20 22:57:54.690886
Duration1.21 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct38
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19.5
Minimum1
Maximum38
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size470.0 B
2024-04-21T07:57:54.804141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.85
Q110.25
median19.5
Q328.75
95-th percentile36.15
Maximum38
Range37
Interquartile range (IQR)18.5

Descriptive statistics

Standard deviation11.113055
Coefficient of variation (CV)0.56990028
Kurtosis-1.2
Mean19.5
Median Absolute Deviation (MAD)9.5
Skewness0
Sum741
Variance123.5
MonotonicityStrictly increasing
2024-04-21T07:57:55.039967image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=38)
ValueCountFrequency (%)
1 1
 
2.6%
30 1
 
2.6%
23 1
 
2.6%
24 1
 
2.6%
25 1
 
2.6%
26 1
 
2.6%
27 1
 
2.6%
28 1
 
2.6%
29 1
 
2.6%
31 1
 
2.6%
Other values (28) 28
73.7%
ValueCountFrequency (%)
1 1
2.6%
2 1
2.6%
3 1
2.6%
4 1
2.6%
5 1
2.6%
6 1
2.6%
7 1
2.6%
8 1
2.6%
9 1
2.6%
10 1
2.6%
ValueCountFrequency (%)
38 1
2.6%
37 1
2.6%
36 1
2.6%
35 1
2.6%
34 1
2.6%
33 1
2.6%
32 1
2.6%
31 1
2.6%
30 1
2.6%
29 1
2.6%
Distinct36
Distinct (%)94.7%
Missing0
Missing (%)0.0%
Memory size432.0 B
2024-04-21T07:57:55.823941image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length17
Mean length11.157895
Min length5

Characters and Unicode

Total characters424
Distinct characters146
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

Unique35 ?
Unique (%)92.1%

Sample

1st row예쁜손글씨캘리그라피
2nd row그림에세이
3rd row그림책놀이터A
4th row그림책놀이터B
5th row영어그림책은내친구A
ValueCountFrequency (%)
그림책놀이터a 3
 
3.2%
독서교실 2
 
2.2%
즐거워지는 2
 
2.2%
가베 2
 
2.2%
2
 
2.2%
인문학 2
 
2.2%
유튜브 2
 
2.2%
꼬꼬무 2
 
2.2%
도형이 2
 
2.2%
1
 
1.1%
Other values (73) 73
78.5%
2024-04-21T07:57:56.835726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
55
 
13.0%
14
 
3.3%
10
 
2.4%
9
 
2.1%
8
 
1.9%
8
 
1.9%
8
 
1.9%
7
 
1.7%
7
 
1.7%
7
 
1.7%
Other values (136) 291
68.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 339
80.0%
Space Separator 55
 
13.0%
Uppercase Letter 10
 
2.4%
Other Punctuation 9
 
2.1%
Close Punctuation 4
 
0.9%
Open Punctuation 4
 
0.9%
Decimal Number 3
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
14
 
4.1%
10
 
2.9%
9
 
2.7%
8
 
2.4%
8
 
2.4%
8
 
2.4%
7
 
2.1%
7
 
2.1%
7
 
2.1%
7
 
2.1%
Other values (125) 254
74.9%
Other Punctuation
ValueCountFrequency (%)
' 6
66.7%
& 2
 
22.2%
? 1
 
11.1%
Uppercase Letter
ValueCountFrequency (%)
A 6
60.0%
B 4
40.0%
Close Punctuation
ValueCountFrequency (%)
) 2
50.0%
] 2
50.0%
Open Punctuation
ValueCountFrequency (%)
( 2
50.0%
[ 2
50.0%
Space Separator
ValueCountFrequency (%)
55
100.0%
Decimal Number
ValueCountFrequency (%)
1 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 339
80.0%
Common 75
 
17.7%
Latin 10
 
2.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
14
 
4.1%
10
 
2.9%
9
 
2.7%
8
 
2.4%
8
 
2.4%
8
 
2.4%
7
 
2.1%
7
 
2.1%
7
 
2.1%
7
 
2.1%
Other values (125) 254
74.9%
Common
ValueCountFrequency (%)
55
73.3%
' 6
 
8.0%
1 3
 
4.0%
& 2
 
2.7%
) 2
 
2.7%
] 2
 
2.7%
( 2
 
2.7%
[ 2
 
2.7%
? 1
 
1.3%
Latin
ValueCountFrequency (%)
A 6
60.0%
B 4
40.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 339
80.0%
ASCII 85
 
20.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
55
64.7%
' 6
 
7.1%
A 6
 
7.1%
B 4
 
4.7%
1 3
 
3.5%
& 2
 
2.4%
) 2
 
2.4%
] 2
 
2.4%
( 2
 
2.4%
[ 2
 
2.4%
Hangul
ValueCountFrequency (%)
14
 
4.1%
10
 
2.9%
9
 
2.7%
8
 
2.4%
8
 
2.4%
8
 
2.4%
7
 
2.1%
7
 
2.1%
7
 
2.1%
7
 
2.1%
Other values (125) 254
74.9%

강사
Text

Distinct27
Distinct (%)71.1%
Missing0
Missing (%)0.0%
Memory size432.0 B
2024-04-21T07:57:57.463353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length3
Mean length3.4210526
Min length3

Characters and Unicode

Total characters130
Distinct characters54
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique21 ?
Unique (%)55.3%

Sample

1st row김옥선
2nd row이선형
3rd row손혜미
4th row손혜미
5th row김영실
ValueCountFrequency (%)
손혜미 4
 
9.5%
조혜영 4
 
9.5%
3
 
7.1%
이명환 3
 
7.1%
김옥선 2
 
4.8%
김영실 2
 
4.8%
정윤희 2
 
4.8%
정예은 1
 
2.4%
전명남 1
 
2.4%
교수 1
 
2.4%
Other values (19) 19
45.2%
2024-04-21T07:57:58.296178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
8
 
6.2%
7
 
5.4%
7
 
5.4%
7
 
5.4%
7
 
5.4%
6
 
4.6%
5
 
3.8%
5
 
3.8%
5
 
3.8%
5
 
3.8%
Other values (44) 68
52.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 125
96.2%
Space Separator 4
 
3.1%
Other Punctuation 1
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
8
 
6.4%
7
 
5.6%
7
 
5.6%
7
 
5.6%
7
 
5.6%
6
 
4.8%
5
 
4.0%
5
 
4.0%
5
 
4.0%
5
 
4.0%
Other values (42) 63
50.4%
Space Separator
ValueCountFrequency (%)
4
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 125
96.2%
Common 5
 
3.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
8
 
6.4%
7
 
5.6%
7
 
5.6%
7
 
5.6%
7
 
5.6%
6
 
4.8%
5
 
4.0%
5
 
4.0%
5
 
4.0%
5
 
4.0%
Other values (42) 63
50.4%
Common
ValueCountFrequency (%)
4
80.0%
, 1
 
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 125
96.2%
ASCII 5
 
3.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
8
 
6.4%
7
 
5.6%
7
 
5.6%
7
 
5.6%
7
 
5.6%
6
 
4.8%
5
 
4.0%
5
 
4.0%
5
 
4.0%
5
 
4.0%
Other values (42) 63
50.4%
ASCII
ValueCountFrequency (%)
4
80.0%
, 1
 
20.0%

대상
Categorical

Distinct15
Distinct (%)39.5%
Missing0
Missing (%)0.0%
Memory size432.0 B
성인
15 
초1~2
6~7세
7세
초3~4
Other values (10)
13 

Length

Max length8
Median length7
Mean length3.7631579
Min length2

Unique

Unique7 ?
Unique (%)18.4%

Sample

1st row성인
2nd row성인
3rd row초1~2
4th row7세
5th row초1~2

Common Values

ValueCountFrequency (%)
성인 15
39.5%
초1~2 3
 
7.9%
6~7세 3
 
7.9%
7세 2
 
5.3%
초3~4 2
 
5.3%
초등저학년 2
 
5.3%
초등4-6학년 2
 
5.3%
초등3-4학년 2
 
5.3%
초등고학년 1
 
2.6%
초등3-5학년 1
 
2.6%
Other values (5) 5
 
13.2%

Length

2024-04-21T07:57:58.534137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
성인 15
38.5%
초1~2 3
 
7.7%
6~7세 3
 
7.7%
7세 2
 
5.1%
초3~4 2
 
5.1%
초등저학년 2
 
5.1%
초등4-6학년 2
 
5.1%
초등3-4학년 2
 
5.1%
초등고학년 1
 
2.6%
초등3-5학년 1
 
2.6%
Other values (6) 6
 
15.4%

운영요일
Categorical

Distinct11
Distinct (%)28.9%
Missing0
Missing (%)0.0%
Memory size432.0 B
10 
화+수+목+금
Other values (6)

Length

Max length8
Median length1
Mean length2.0526316
Min length1

Unique

Unique5 ?
Unique (%)13.2%

Sample

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

Common Values

ValueCountFrequency (%)
10
26.3%
6
15.8%
6
15.8%
4
 
10.5%
화+수+목+금 4
 
10.5%
3
 
7.9%
화+금 1
 
2.6%
수+목 1
 
2.6%
<NA> 1
 
2.6%
매월 마지막 수 1
 
2.6%

Length

2024-04-21T07:57:58.768863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
11
27.5%
6
15.0%
6
15.0%
4
 
10.0%
화+수+목+금 4
 
10.0%
3
 
7.5%
화+금 1
 
2.5%
수+목 1
 
2.5%
na 1
 
2.5%
매월 1
 
2.5%
Other values (2) 2
 
5.0%

장소
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)13.2%
Missing0
Missing (%)0.0%
Memory size432.0 B
시청각실
17 
강좌실
13 
세미나실
북스타트룸
 
1
미디어팩토리
 
1

Length

Max length6
Median length4
Mean length3.7368421
Min length3

Unique

Unique2 ?
Unique (%)5.3%

Sample

1st row강좌실
2nd row강좌실
3rd row강좌실
4th row강좌실
5th row북스타트룸

Common Values

ValueCountFrequency (%)
시청각실 17
44.7%
강좌실 13
34.2%
세미나실 6
 
15.8%
북스타트룸 1
 
2.6%
미디어팩토리 1
 
2.6%

Length

2024-04-21T07:57:58.991095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T07:57:59.184675image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
시청각실 17
44.7%
강좌실 13
34.2%
세미나실 6
 
15.8%
북스타트룸 1
 
2.6%
미디어팩토리 1
 
2.6%

수강료
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)7.9%
Missing0
Missing (%)0.0%
Memory size432.0 B
무료
15 
무료(재료/교재비 별도)
14 
무료(재료비 별도)

Length

Max length13
Median length10
Mean length7.9473684
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row무료
2nd row무료(재료비 별도)
3rd row무료(재료비 별도)
4th row무료(재료비 별도)
5th row무료(재료비 별도)

Common Values

ValueCountFrequency (%)
무료 15
39.5%
무료(재료/교재비 별도) 14
36.8%
무료(재료비 별도) 9
23.7%

Length

2024-04-21T07:57:59.388097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T07:57:59.566494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
별도 23
37.7%
무료 15
24.6%
무료(재료/교재비 14
23.0%
무료(재료비 9
 
14.8%

도서관명
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)5.3%
Missing0
Missing (%)0.0%
Memory size432.0 B
안심도서관
24 
신천도서관
14 

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 (%)
안심도서관 24
63.2%
신천도서관 14
36.8%

Length

2024-04-21T07:57:59.758130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T07:57:59.933675image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
안심도서관 24
63.2%
신천도서관 14
36.8%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size432.0 B
2022-07-11
38 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-07-11
2nd row2022-07-11
3rd row2022-07-11
4th row2022-07-11
5th row2022-07-11

Common Values

ValueCountFrequency (%)
2022-07-11 38
100.0%

Length

2024-04-21T07:58:00.217800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T07:58:00.534645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-07-11 38
100.0%

Interactions

2024-04-21T07:57:54.163420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-21T07:58:00.727985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번강좌명강사대상운영요일장소수강료도서관명
연번1.0000.9490.8060.5590.6300.8080.7130.997
강좌명0.9491.0001.0000.9601.0001.0001.0001.000
강사0.8061.0001.0000.5940.9730.7760.9770.876
대상0.5590.9600.5941.0000.0000.4700.8040.608
운영요일0.6301.0000.9730.0001.0000.0000.3880.000
장소0.8081.0000.7760.4700.0001.0000.6421.000
수강료0.7131.0000.9770.8040.3880.6421.0000.513
도서관명0.9971.0000.8760.6080.0001.0000.5131.000
2024-04-21T07:58:01.002524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
장소수강료운영요일대상도서관명
장소1.0000.5870.0000.1510.957
수강료0.5871.0000.2100.4260.765
운영요일0.0000.2101.0000.0000.000
대상0.1510.4260.0001.0000.440
도서관명0.9570.7650.0000.4401.000
2024-04-21T07:58:01.250418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번대상운영요일장소수강료도서관명
연번1.0000.1920.2200.4220.5080.837
대상0.1921.0000.0000.1510.4260.440
운영요일0.2200.0001.0000.0000.2100.000
장소0.4220.1510.0001.0000.5870.957
수강료0.5080.4260.2100.5871.0000.765
도서관명0.8370.4400.0000.9570.7651.000

Missing values

2024-04-21T07:57:54.371125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T07:57:54.603698image/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예쁜손글씨캘리그라피김옥선성인강좌실무료신천도서관2022-07-11
12그림에세이이선형성인강좌실무료(재료비 별도)신천도서관2022-07-11
23그림책놀이터A손혜미초1~2강좌실무료(재료비 별도)신천도서관2022-07-11
34그림책놀이터B손혜미7세강좌실무료(재료비 별도)신천도서관2022-07-11
45영어그림책은내친구A김영실초1~2북스타트룸무료(재료비 별도)신천도서관2022-07-11
56영어그림책은내친구B김영실6~7세강좌실무료(재료비 별도)신천도서관2022-07-11
67시시캘캘(1관1단)이지희,김옥선성인강좌실무료신천도서관2022-07-11
78길위의인문학정수경외성인강좌실무료신천도서관2022-07-11
89예쁜손글씨쓰기(캘리)김옥선성인강좌실무료신천도서관2022-07-11
910그림책놀이터A손혜미초1~2강좌실무료(재료비 별도)신천도서관2022-07-11
연번강좌명강사대상운영요일장소수강료도서관명데이터기준일자
2829인문그림책 & 북아트신지원초등1-2학년시청각실무료(재료/교재비 별도)안심도서관2022-07-11
2930인문고전으로 만나는 경제학김상규시니어시청각실무료안심도서관2022-07-11
3031독서와 연극놀이황명희초등3-4학년세미나실무료(재료/교재비 별도)안심도서관2022-07-11
3132프리미어프로를 활용한 유튜브 영상제작 기초정예은성인화+수+목+금미디어팩토리무료안심도서관2022-07-11
3233한밤의 인문학 콘서트전명남 교수 외성인매월 마지막 수시청각실무료안심도서관2022-07-11
3334안심독서대학 1기권미숙 외성인시청각실무료안심도서관2022-07-11
3435지금 시작하는 유튜브 & 미디어류순희신중년이상시청각실무료안심도서관2022-07-11
3536상주작가 프로그램 '내 마음의 빈칸'변희수성인시청각실무료안심도서관2022-07-11
3637길위의 인문학 '책의 길을 걷다'박광헌 외성인목+토시청각실무료안심도서관2022-07-11
3738도서관 지혜학교 '글쓰기에서 배우는 삶의 지혜'배지연지역주민 10명시청각실무료안심도서관2022-07-11