Overview

Dataset statistics

Number of variables7
Number of observations40
Missing cells6
Missing cells (%)2.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.3 KiB
Average record size in memory59.3 B

Variable types

Categorical2
Text4
DateTime1

Dataset

Description대구광역시 남구_교육시설 현황_20230817
Author대구광역시 남구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=3072418&dataSetDetailId=30724181a16a02f27fcd&provdMethod=FILE

Alerts

데이터기준일자 has constant value ""Constant
홈페이지주소 has 6 (15.0%) missing valuesMissing
학교명 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2023-12-10 20:25:30.433072
Analysis finished2023-12-10 20:25:33.070901
Duration2.64 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

Distinct6
Distinct (%)15.0%
Missing0
Missing (%)0.0%
Memory size452.0 B
초등학교
11 
유치원
10 
고등학교
7 
중학교
6 
대학교
4 

Length

Max length4
Median length3.5
Mean length3.5
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row초등학교
2nd row초등학교
3rd row초등학교
4th row초등학교
5th row초등학교

Common Values

ValueCountFrequency (%)
초등학교 11
27.5%
유치원 10
25.0%
고등학교 7
17.5%
중학교 6
15.0%
대학교 4
 
10.0%
전문대학 2
 
5.0%

Length

2023-12-11T05:25:33.227731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T05:25:33.491589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
초등학교 11
27.5%
유치원 10
25.0%
고등학교 7
17.5%
중학교 6
15.0%
대학교 4
 
10.0%
전문대학 2
 
5.0%

학교명
Text

UNIQUE 

Distinct40
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size452.0 B
2023-12-11T05:25:33.892315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length13
Mean length7.725
Min length5

Characters and Unicode

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

Unique

Unique40 ?
Unique (%)100.0%

Sample

1st row대구영선초등학교
2nd row대구대봉초등학교
3rd row대구봉덕초등학교
4th row대구효명초등학교
5th row남대구초등학교
ValueCountFrequency (%)
대명동캠퍼스 2
 
4.5%
대구영선초등학교 1
 
2.3%
대구캠퍼스 1
 
2.3%
대구여자상업고등학교 1
 
2.3%
경북여자상업고등학교 1
 
2.3%
영남이공대학교 1
 
2.3%
계명문화대학 1
 
2.3%
대구대학교 1
 
2.3%
대구교육대학교 1
 
2.3%
영남대학교 1
 
2.3%
Other values (33) 33
75.0%
2023-12-11T05:25:34.538726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
대 32
 
10.4%
교 31
 
10.0%
학 31
 
10.0%
구 20
 
6.5%
등 19
 
6.1%
초 12
 
3.9%
유 10
 
3.2%
치 10
 
3.2%
원 10
 
3.2%
명 9
 
2.9%
Other values (55) 125
40.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 305
98.7%
Space Separator 4
 
1.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
대 32
 
10.5%
교 31
 
10.2%
학 31
 
10.2%
구 20
 
6.6%
등 19
 
6.2%
초 12
 
3.9%
유 10
 
3.3%
치 10
 
3.3%
원 10
 
3.3%
명 9
 
3.0%
Other values (54) 121
39.7%
Space Separator
ValueCountFrequency (%)
4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 305
98.7%
Common 4
 
1.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
대 32
 
10.5%
교 31
 
10.2%
학 31
 
10.2%
구 20
 
6.6%
등 19
 
6.2%
초 12
 
3.9%
유 10
 
3.3%
치 10
 
3.3%
원 10
 
3.3%
명 9
 
3.0%
Other values (54) 121
39.7%
Common
ValueCountFrequency (%)
4
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 305
98.7%
ASCII 4
 
1.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
대 32
 
10.5%
교 31
 
10.2%
학 31
 
10.2%
구 20
 
6.6%
등 19
 
6.2%
초 12
 
3.9%
유 10
 
3.3%
치 10
 
3.3%
원 10
 
3.3%
명 9
 
3.0%
Other values (54) 121
39.7%
ASCII
ValueCountFrequency (%)
4
100.0%

소재지
Text

Distinct36
Distinct (%)90.0%
Missing0
Missing (%)0.0%
Memory size452.0 B
2023-12-11T05:25:34.925281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length19
Mean length16.925
Min length15

Characters and Unicode

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

Unique

Unique32 ?
Unique (%)80.0%

Sample

1st row대구광역시 남구 영선길 96
2nd row대구광역시 남구 대봉로26길 33
3rd row대구광역시 남구 효성로 71
4th row대구광역시 남구 앞산순환로 707
5th row대구광역시 남구 중앙대로47길 55
ValueCountFrequency (%)
대구광역시 40
25.2%
남구 40
25.2%
33 7
 
4.4%
효성로 6
 
3.8%
앞산순환로 3
 
1.9%
중앙대로47길 2
 
1.3%
효동길 2
 
1.3%
중앙대로 2
 
1.3%
현충로48길 2
 
1.3%
55 2
 
1.3%
Other values (48) 53
33.3%
2023-12-11T05:25:35.600335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
119
17.6%
구 80
11.8%
대 51
 
7.5%
남 41
 
6.1%
광 40
 
5.9%
역 40
 
5.9%
시 40
 
5.9%
로 32
 
4.7%
3 25
 
3.7%
길 22
 
3.2%
Other values (39) 187
27.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 431
63.7%
Decimal Number 125
 
18.5%
Space Separator 119
 
17.6%
Dash Punctuation 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 80
18.6%
대 51
11.8%
남 41
9.5%
광 40
9.3%
역 40
9.3%
시 40
9.3%
로 32
 
7.4%
길 22
 
5.1%
성 9
 
2.1%
효 8
 
1.9%
Other values (27) 68
15.8%
Decimal Number
ValueCountFrequency (%)
3 25
20.0%
1 20
16.0%
7 16
12.8%
0 16
12.8%
4 14
11.2%
2 9
 
7.2%
8 7
 
5.6%
5 7
 
5.6%
6 6
 
4.8%
9 5
 
4.0%
Space Separator
ValueCountFrequency (%)
119
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 431
63.7%
Common 246
36.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 80
18.6%
대 51
11.8%
남 41
9.5%
광 40
9.3%
역 40
9.3%
시 40
9.3%
로 32
 
7.4%
길 22
 
5.1%
성 9
 
2.1%
효 8
 
1.9%
Other values (27) 68
15.8%
Common
ValueCountFrequency (%)
119
48.4%
3 25
 
10.2%
1 20
 
8.1%
7 16
 
6.5%
0 16
 
6.5%
4 14
 
5.7%
2 9
 
3.7%
8 7
 
2.8%
5 7
 
2.8%
6 6
 
2.4%
Other values (2) 7
 
2.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 431
63.7%
ASCII 246
36.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
119
48.4%
3 25
 
10.2%
1 20
 
8.1%
7 16
 
6.5%
0 16
 
6.5%
4 14
 
5.7%
2 9
 
3.7%
8 7
 
2.8%
5 7
 
2.8%
6 6
 
2.4%
Other values (2) 7
 
2.8%
Hangul
ValueCountFrequency (%)
구 80
18.6%
대 51
11.8%
남 41
9.5%
광 40
9.3%
역 40
9.3%
시 40
9.3%
로 32
 
7.4%
길 22
 
5.1%
성 9
 
2.1%
효 8
 
1.9%
Other values (27) 68
15.8%

공사립
Categorical

Distinct5
Distinct (%)12.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
사립
21 
공립
16 
국립
 
1
공립단설
 
1
공립병설
 
1

Length

Max length4
Median length2
Mean length2.1
Min length2

Unique

Unique3 ?
Unique (%)7.5%

Sample

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

Common Values

ValueCountFrequency (%)
사립 21
52.5%
공립 16
40.0%
국립 1
 
2.5%
공립단설 1
 
2.5%
공립병설 1
 
2.5%

Length

2023-12-11T05:25:35.865206image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T05:25:36.072511image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사립 21
52.5%
공립 16
40.0%
국립 1
 
2.5%
공립단설 1
 
2.5%
공립병설 1
 
2.5%

전화번호
Text

UNIQUE 

Distinct40
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size452.0 B
2023-12-11T05:25:36.405570image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique

Unique40 ?
Unique (%)100.0%

Sample

1st row053-234-0470
2nd row053-234-0301
3rd row053-234-0571
4th row053-234-1701
5th row053-234-1711
ValueCountFrequency (%)
053-234-0470 1
 
2.5%
053-234-0301 1
 
2.5%
053-650-4455 1
 
2.5%
053-235-9190 1
 
2.5%
053-235-9398 1
 
2.5%
053-650-9114 1
 
2.5%
053-580-5114 1
 
2.5%
053-850-5000 1
 
2.5%
053-620-1114 1
 
2.5%
053-640-6808 1
 
2.5%
Other values (30) 30
75.0%
2023-12-11T05:25:36.966123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 83
17.3%
- 80
16.7%
3 76
15.8%
5 70
14.6%
2 41
8.5%
4 39
8.1%
1 29
 
6.0%
6 19
 
4.0%
7 16
 
3.3%
8 15
 
3.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 400
83.3%
Dash Punctuation 80
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 83
20.8%
3 76
19.0%
5 70
17.5%
2 41
10.2%
4 39
9.8%
1 29
 
7.2%
6 19
 
4.8%
7 16
 
4.0%
8 15
 
3.8%
9 12
 
3.0%
Dash Punctuation
ValueCountFrequency (%)
- 80
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 480
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 83
17.3%
- 80
16.7%
3 76
15.8%
5 70
14.6%
2 41
8.5%
4 39
8.1%
1 29
 
6.0%
6 19
 
4.0%
7 16
 
3.3%
8 15
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 480
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 83
17.3%
- 80
16.7%
3 76
15.8%
5 70
14.6%
2 41
8.5%
4 39
8.1%
1 29
 
6.0%
6 19
 
4.0%
7 16
 
3.3%
8 15
 
3.1%

홈페이지주소
Text

MISSING 

Distinct34
Distinct (%)100.0%
Missing6
Missing (%)15.0%
Memory size452.0 B
2023-12-11T05:25:37.307569image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length29
Mean length25.470588
Min length19

Characters and Unicode

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

Unique

Unique34 ?
Unique (%)100.0%

Sample

1st rowhttp://www.youngsun.es.kr/
2nd rowhttp://www.daebong.es.kr/
3rd rowhttp://www.dgbongdeok.es.kr/
4th rowhttp://www.hyomyong.es.kr/
5th rowhttp://www.namdaegu.es.kr/
ValueCountFrequency (%)
http://www.namdeok.es.kr 1
 
2.9%
http://www.dnue.ac.kr 1
 
2.9%
http://www.daegu.ac.kr 1
 
2.9%
http://www.kyeongsang-th.hs.kr 1
 
2.9%
http://www.g-il.hs.kr 1
 
2.9%
http://www.daegu-gch.hs.kr 1
 
2.9%
http://www.gbgc.kr 1
 
2.9%
http://www.ync.ac.kr 1
 
2.9%
http://www.gahs.or.kr 1
 
2.9%
http://www.dgbongdeok.es.kr 1
 
2.9%
Other values (24) 24
70.6%
2023-12-11T05:25:37.900525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
/ 99
 
11.4%
. 98
 
11.3%
w 90
 
10.4%
t 72
 
8.3%
h 47
 
5.4%
k 44
 
5.1%
p 36
 
4.2%
g 36
 
4.2%
: 34
 
3.9%
e 34
 
3.9%
Other values (18) 276
31.9%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 618
71.4%
Other Punctuation 231
 
26.7%
Dash Punctuation 10
 
1.2%
Decimal Number 7
 
0.8%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
w 90
14.6%
t 72
11.7%
h 47
 
7.6%
k 44
 
7.1%
p 36
 
5.8%
g 36
 
5.8%
e 34
 
5.5%
r 33
 
5.3%
a 32
 
5.2%
s 31
 
5.0%
Other values (11) 163
26.4%
Other Punctuation
ValueCountFrequency (%)
/ 99
42.9%
. 98
42.4%
: 34
 
14.7%
Decimal Number
ValueCountFrequency (%)
7 3
42.9%
6 3
42.9%
4 1
 
14.3%
Dash Punctuation
ValueCountFrequency (%)
- 10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 618
71.4%
Common 248
28.6%

Most frequent character per script

Latin
ValueCountFrequency (%)
w 90
14.6%
t 72
11.7%
h 47
 
7.6%
k 44
 
7.1%
p 36
 
5.8%
g 36
 
5.8%
e 34
 
5.5%
r 33
 
5.3%
a 32
 
5.2%
s 31
 
5.0%
Other values (11) 163
26.4%
Common
ValueCountFrequency (%)
/ 99
39.9%
. 98
39.5%
: 34
 
13.7%
- 10
 
4.0%
7 3
 
1.2%
6 3
 
1.2%
4 1
 
0.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 866
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
/ 99
 
11.4%
. 98
 
11.3%
w 90
 
10.4%
t 72
 
8.3%
h 47
 
5.4%
k 44
 
5.1%
p 36
 
4.2%
g 36
 
4.2%
: 34
 
3.9%
e 34
 
3.9%
Other values (18) 276
31.9%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
Minimum2023-08-17 00:00:00
Maximum2023-08-17 00:00:00
2023-12-11T05:25:38.095705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T05:25:38.214360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-11T05:25:38.306548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분학교명소재지공사립전화번호홈페이지주소
구분1.0001.0000.0000.5511.0001.000
학교명1.0001.0001.0001.0001.0001.000
소재지0.0001.0001.0000.0001.0001.000
공사립0.5511.0000.0001.0001.0001.000
전화번호1.0001.0001.0001.0001.0001.000
홈페이지주소1.0001.0001.0001.0001.0001.000
2023-12-11T05:25:38.471694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분공사립
구분1.0000.403
공사립0.4031.000
2023-12-11T05:25:38.626055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분공사립
구분1.0000.403
공사립0.4031.000

Missing values

2023-12-11T05:25:32.569818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T05:25:32.950808image/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초등학교대구영선초등학교대구광역시 남구 영선길 96공립053-234-0470http://www.youngsun.es.kr/2023-08-17
1초등학교대구대봉초등학교대구광역시 남구 대봉로26길 33공립053-234-0301http://www.daebong.es.kr/2023-08-17
2초등학교대구봉덕초등학교대구광역시 남구 효성로 71공립053-234-0571http://www.dgbongdeok.es.kr/2023-08-17
3초등학교대구효명초등학교대구광역시 남구 앞산순환로 707공립053-234-1701http://www.hyomyong.es.kr/2023-08-17
4초등학교남대구초등학교대구광역시 남구 중앙대로47길 55공립053-234-1711http://www.namdaegu.es.kr/2023-08-17
5초등학교대구성명초등학교대구광역시 남구 성당로30길 55공립053-234-0910http://www.sungmyoung.es.kr/2023-08-17
6초등학교대구남도초등학교대구광역시 남구 현충동길 74공립053-234-0882http://www.namdo.es.kr/2023-08-17
7초등학교대구대명초등학교대구광역시 남구 대명로 100공립053-234-0203http://www.daegu-daemyoung.es.kr/2023-08-17
8초등학교대구남명초등학교대구광역시 남구 큰골4길 41공립053-234-1940http://www.daegu-nammyeong.es.kr/2023-08-17
9초등학교대구남덕초등학교대구광역시 남구 앞산순환로93길 33공립053-234-2355http://www.namdeok.es.kr/2023-08-17
구분학교명소재지공사립전화번호홈페이지주소데이터기준일자
30유치원대구경상유치원대구광역시 남구 현충로48길 31-8공립단설053-234-5551http://www.ksang-i.kg.kr/2023-08-17
31유치원대구봉덕초등학교병설유치원대구광역시 남구 효성로 71공립병설053-234-5087<NA>2023-08-17
32유치원계명유치원대구광역시 남구 명덕로20길 24사립053-652-5561http://cafe.daum.net/kmkg-child2023-08-17
33유치원룸비니유치원대구광역시 남구 대명남로140사립053-621-1003<NA>2023-08-17
34유치원반야유치원대구광역시 남구 장전1길 92사립053-655-0222<NA>2023-08-17
35유치원참좋은유치원대구광역시 남구 삼정2길 36사립053-476-6767http://cafe.daum.net/476-67672023-08-17
36유치원스콜라유치원대구광역시 남구 앞산순환로 467사립053-217-7500<NA>2023-08-17
37유치원아이린유치원대구광역시 남구 효동길 14사립053-267-3300<NA>2023-08-17
38유치원드림유치원대구광역시 남구 대봉로30길 36-8사립053-472-3800https://cafe.daum.net/dreamdaegu2023-08-17
39유치원아름그루유치원대구광역시 남구 효동길 91사립053-473-0494<NA>2023-08-17