Overview

Dataset statistics

Number of variables5
Number of observations216
Missing cells80
Missing cells (%)7.4%
Duplicate rows1
Duplicate rows (%)0.5%
Total size in memory8.6 KiB
Average record size in memory40.6 B

Variable types

Categorical2
Text3

Dataset

Description칠곡교육지원청내 학원 및 교습소 현황에 대하여 공공데이터 목록등록관리 시스템에 공개하는 데이터로 학원별 분야구분과 학원주소 및 전화번호의 목록입니다.
Author경상북도교육청 경상북도칠곡교육지원청
URLhttps://www.data.go.kr/data/3070821/fileData.do

Alerts

Dataset has 1 (0.5%) duplicate rowsDuplicates
전화번호 has 80 (37.0%) missing valuesMissing

Reproduction

Analysis started2023-12-12 20:06:35.607611
Analysis finished2023-12-12 20:06:36.510669
Duration0.9 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

Distinct2
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
학원
172 
교습소
44 

Length

Max length3
Median length2
Mean length2.2037037
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
학원 172
79.6%
교습소 44
 
20.4%

Length

2023-12-13T05:06:36.582393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:06:36.707555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
학원 172
79.6%
교습소 44
 
20.4%
Distinct215
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-13T05:06:36.935703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length19
Mean length8.9907407
Min length4

Characters and Unicode

Total characters1942
Distinct characters305
Distinct categories9 ?
Distinct scripts4 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique214 ?
Unique (%)99.1%

Sample

1st row글로리음악학원
2nd row최원철학원
3rd row새롬학원
4th row예린음악학원
5th row아트진미술학원
ValueCountFrequency (%)
레인보우이베스트학원 2
 
0.9%
혜윰수학학원 2
 
0.9%
좋아요미술학원 1
 
0.4%
윈독서실(여성전용 1
 
0.4%
민수학맵플러스학원 1
 
0.4%
시매쓰왜관학원 1
 
0.4%
일센치 1
 
0.4%
이엔엠(e&m)학원 1
 
0.4%
더플랜수학(독서논술)학원 1
 
0.4%
노랑미술학원 1
 
0.4%
Other values (218) 218
94.8%
2023-12-13T05:06:37.323128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
197
 
10.1%
178
 
9.2%
53
 
2.7%
51
 
2.6%
48
 
2.5%
47
 
2.4%
43
 
2.2%
42
 
2.2%
40
 
2.1%
32
 
1.6%
Other values (295) 1211
62.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1786
92.0%
Lowercase Letter 50
 
2.6%
Uppercase Letter 42
 
2.2%
Close Punctuation 17
 
0.9%
Open Punctuation 17
 
0.9%
Space Separator 14
 
0.7%
Other Punctuation 12
 
0.6%
Decimal Number 3
 
0.2%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
197
 
11.0%
178
 
10.0%
53
 
3.0%
51
 
2.9%
48
 
2.7%
47
 
2.6%
43
 
2.4%
42
 
2.4%
40
 
2.2%
32
 
1.8%
Other values (247) 1055
59.1%
Uppercase Letter
ValueCountFrequency (%)
E 8
19.0%
M 5
11.9%
I 4
 
9.5%
G 3
 
7.1%
T 3
 
7.1%
U 2
 
4.8%
D 2
 
4.8%
S 2
 
4.8%
A 2
 
4.8%
H 1
 
2.4%
Other values (10) 10
23.8%
Lowercase Letter
ValueCountFrequency (%)
e 7
14.0%
s 6
12.0%
n 4
 
8.0%
h 3
 
6.0%
i 3
 
6.0%
l 3
 
6.0%
g 3
 
6.0%
a 3
 
6.0%
y 3
 
6.0%
d 3
 
6.0%
Other values (8) 12
24.0%
Other Punctuation
ValueCountFrequency (%)
· 8
66.7%
' 2
 
16.7%
& 2
 
16.7%
Decimal Number
ValueCountFrequency (%)
2 1
33.3%
3 1
33.3%
4 1
33.3%
Close Punctuation
ValueCountFrequency (%)
) 17
100.0%
Open Punctuation
ValueCountFrequency (%)
( 17
100.0%
Space Separator
ValueCountFrequency (%)
14
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1785
91.9%
Latin 92
 
4.7%
Common 64
 
3.3%
Han 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
197
 
11.0%
178
 
10.0%
53
 
3.0%
51
 
2.9%
48
 
2.7%
47
 
2.6%
43
 
2.4%
42
 
2.4%
40
 
2.2%
32
 
1.8%
Other values (246) 1054
59.0%
Latin
ValueCountFrequency (%)
E 8
 
8.7%
e 7
 
7.6%
s 6
 
6.5%
M 5
 
5.4%
n 4
 
4.3%
I 4
 
4.3%
h 3
 
3.3%
G 3
 
3.3%
i 3
 
3.3%
l 3
 
3.3%
Other values (28) 46
50.0%
Common
ValueCountFrequency (%)
) 17
26.6%
( 17
26.6%
14
21.9%
· 8
12.5%
' 2
 
3.1%
& 2
 
3.1%
2 1
 
1.6%
3 1
 
1.6%
4 1
 
1.6%
- 1
 
1.6%
Han
ValueCountFrequency (%)
1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1785
91.9%
ASCII 148
 
7.6%
None 8
 
0.4%
CJK 1
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
197
 
11.0%
178
 
10.0%
53
 
3.0%
51
 
2.9%
48
 
2.7%
47
 
2.6%
43
 
2.4%
42
 
2.4%
40
 
2.2%
32
 
1.8%
Other values (246) 1054
59.0%
ASCII
ValueCountFrequency (%)
) 17
 
11.5%
( 17
 
11.5%
14
 
9.5%
E 8
 
5.4%
e 7
 
4.7%
s 6
 
4.1%
M 5
 
3.4%
n 4
 
2.7%
I 4
 
2.7%
h 3
 
2.0%
Other values (37) 63
42.6%
None
ValueCountFrequency (%)
· 8
100.0%
CJK
ValueCountFrequency (%)
1
100.0%

분야구분
Categorical

Distinct8
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
입시.검정 및 보습
111 
예능(대)
64 
종합(대)
18 
국제화
 
11
기타(대)
 
4
Other values (3)
 
8

Length

Max length10
Median length10
Mean length7.4212963
Min length3

Unique

Unique1 ?
Unique (%)0.5%

Sample

1st row예능(대)
2nd row종합(대)
3rd row입시.검정 및 보습
4th row예능(대)
5th row예능(대)

Common Values

ValueCountFrequency (%)
입시.검정 및 보습 111
51.4%
예능(대) 64
29.6%
종합(대) 18
 
8.3%
국제화 11
 
5.1%
기타(대) 4
 
1.9%
직업기술 4
 
1.9%
독서실 3
 
1.4%
기예(대) 1
 
0.5%

Length

2023-12-13T05:06:37.471596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:06:37.596899image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
입시.검정 111
25.3%
111
25.3%
보습 111
25.3%
예능(대 64
14.6%
종합(대 18
 
4.1%
국제화 11
 
2.5%
기타(대 4
 
0.9%
직업기술 4
 
0.9%
독서실 3
 
0.7%
기예(대 1
 
0.2%
Distinct207
Distinct (%)95.8%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-13T05:06:37.858176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length62
Median length51
Mean length32.782407
Min length22

Characters and Unicode

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

Unique

Unique198 ?
Unique (%)91.7%

Sample

1st row경상북도 칠곡군 왜관읍 평장2길 45 (왜관읍)
2nd row경상북도 칠곡군 왜관읍 석전로 88 (왜관읍,새마을금고)
3rd row경상북도 칠곡군 석적읍 석적로 933-11 , 802동 301호 (석적읍,우방신천지아파트)
4th row경상북도 칠곡군 석적읍 석적로 933-11 , 802동 305호 (석적읍,우방신천지아파트)
5th row경상북도 칠곡군 북삼읍 북삼로8길 11 (북삼읍)
ValueCountFrequency (%)
경상북도 216
 
13.5%
칠곡군 216
 
13.5%
석적읍 147
 
9.2%
왜관읍 130
 
8.1%
127
 
7.9%
북삼읍 113
 
7.1%
2층 58
 
3.6%
석적로 23
 
1.4%
3층 14
 
0.9%
안산2길 14
 
0.9%
Other values (285) 540
33.8%
2023-12-13T05:06:38.261833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1405
19.8%
400
 
5.6%
354
 
5.0%
244
 
3.4%
220
 
3.1%
220
 
3.1%
2 219
 
3.1%
216
 
3.1%
216
 
3.1%
216
 
3.1%
Other values (136) 3371
47.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3986
56.3%
Space Separator 1405
 
19.8%
Decimal Number 1013
 
14.3%
Close Punctuation 209
 
3.0%
Open Punctuation 209
 
3.0%
Other Punctuation 159
 
2.2%
Dash Punctuation 94
 
1.3%
Uppercase Letter 6
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
400
 
10.0%
354
 
8.9%
244
 
6.1%
220
 
5.5%
220
 
5.5%
216
 
5.4%
216
 
5.4%
216
 
5.4%
189
 
4.7%
176
 
4.4%
Other values (116) 1535
38.5%
Decimal Number
ValueCountFrequency (%)
2 219
21.6%
1 197
19.4%
3 143
14.1%
0 101
10.0%
9 75
 
7.4%
5 74
 
7.3%
8 58
 
5.7%
6 57
 
5.6%
4 48
 
4.7%
7 41
 
4.0%
Uppercase Letter
ValueCountFrequency (%)
A 2
33.3%
P 1
16.7%
T 1
16.7%
C 1
16.7%
B 1
16.7%
Space Separator
ValueCountFrequency (%)
1405
100.0%
Close Punctuation
ValueCountFrequency (%)
) 209
100.0%
Open Punctuation
ValueCountFrequency (%)
( 209
100.0%
Other Punctuation
ValueCountFrequency (%)
, 159
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 94
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3986
56.3%
Common 3089
43.6%
Latin 6
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
400
 
10.0%
354
 
8.9%
244
 
6.1%
220
 
5.5%
220
 
5.5%
216
 
5.4%
216
 
5.4%
216
 
5.4%
189
 
4.7%
176
 
4.4%
Other values (116) 1535
38.5%
Common
ValueCountFrequency (%)
1405
45.5%
2 219
 
7.1%
) 209
 
6.8%
( 209
 
6.8%
1 197
 
6.4%
, 159
 
5.1%
3 143
 
4.6%
0 101
 
3.3%
- 94
 
3.0%
9 75
 
2.4%
Other values (5) 278
 
9.0%
Latin
ValueCountFrequency (%)
A 2
33.3%
P 1
16.7%
T 1
16.7%
C 1
16.7%
B 1
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3986
56.3%
ASCII 3095
43.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1405
45.4%
2 219
 
7.1%
) 209
 
6.8%
( 209
 
6.8%
1 197
 
6.4%
, 159
 
5.1%
3 143
 
4.6%
0 101
 
3.3%
- 94
 
3.0%
9 75
 
2.4%
Other values (10) 284
 
9.2%
Hangul
ValueCountFrequency (%)
400
 
10.0%
354
 
8.9%
244
 
6.1%
220
 
5.5%
220
 
5.5%
216
 
5.4%
216
 
5.4%
216
 
5.4%
189
 
4.7%
176
 
4.4%
Other values (116) 1535
38.5%

전화번호
Text

MISSING 

Distinct135
Distinct (%)99.3%
Missing80
Missing (%)37.0%
Memory size1.8 KiB
2023-12-13T05:06:38.463278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.014706
Min length12

Characters and Unicode

Total characters1634
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

Unique134 ?
Unique (%)98.5%

Sample

1st row054-975-5670
2nd row054-974-1130
3rd row054-977-8978
4th row054-977-7547
5th row054-975-4222
ValueCountFrequency (%)
054-975-2777 2
 
1.5%
054-972-4789 1
 
0.7%
054-977-0608 1
 
0.7%
054-973-7555 1
 
0.7%
054-977-1322 1
 
0.7%
054-977-2333 1
 
0.7%
054-977-7813 1
 
0.7%
054-973-7774 1
 
0.7%
054-974-5855 1
 
0.7%
054-975-5670 1
 
0.7%
Other values (125) 125
91.9%
2023-12-13T05:06:38.757881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 272
16.6%
7 223
13.6%
5 222
13.6%
0 213
13.0%
4 187
11.4%
9 179
11.0%
3 76
 
4.7%
1 76
 
4.7%
2 71
 
4.3%
6 63
 
3.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1362
83.4%
Dash Punctuation 272
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
7 223
16.4%
5 222
16.3%
0 213
15.6%
4 187
13.7%
9 179
13.1%
3 76
 
5.6%
1 76
 
5.6%
2 71
 
5.2%
6 63
 
4.6%
8 52
 
3.8%
Dash Punctuation
ValueCountFrequency (%)
- 272
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1634
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 272
16.6%
7 223
13.6%
5 222
13.6%
0 213
13.0%
4 187
11.4%
9 179
11.0%
3 76
 
4.7%
1 76
 
4.7%
2 71
 
4.3%
6 63
 
3.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1634
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 272
16.6%
7 223
13.6%
5 222
13.6%
0 213
13.0%
4 187
11.4%
9 179
11.0%
3 76
 
4.7%
1 76
 
4.7%
2 71
 
4.3%
6 63
 
3.9%

Correlations

2023-12-13T05:06:38.844929image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분분야구분
구분1.0000.356
분야구분0.3561.000
2023-12-13T05:06:38.920717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분분야구분
구분1.0000.263
분야구분0.2631.000
2023-12-13T05:06:38.987361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분분야구분
구분1.0000.263
분야구분0.2631.000

Missing values

2023-12-13T05:06:36.048035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T05:06:36.453491image/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학원글로리음악학원예능(대)경상북도 칠곡군 왜관읍 평장2길 45 (왜관읍)054-975-5670
1학원최원철학원종합(대)경상북도 칠곡군 왜관읍 석전로 88 (왜관읍,새마을금고)054-974-1130
2학원새롬학원입시.검정 및 보습경상북도 칠곡군 석적읍 석적로 933-11 , 802동 301호 (석적읍,우방신천지아파트)054-977-8978
3학원예린음악학원예능(대)경상북도 칠곡군 석적읍 석적로 933-11 , 802동 305호 (석적읍,우방신천지아파트)054-977-7547
4학원아트진미술학원예능(대)경상북도 칠곡군 북삼읍 북삼로8길 11 (북삼읍)054-975-4222
5학원신천지체르또입시학원종합(대)경상북도 칠곡군 석적읍 석적로 955-9 (석적읍)054-976-1251
6학원대경컴퓨터학원기타(대)경상북도 칠곡군 석적읍 석적로 955-3 (석적읍)054-977-4001
7학원신나는음악미술전문학원종합(대)경상북도 칠곡군 석적읍 석적로 933-3 , 2층 (석적읍)054-977-5505
8학원소리엘음악학원예능(대)경상북도 칠곡군 약목면 복성1길 18 (약목면)054-974-6488
9학원알파학원입시.검정 및 보습경상북도 칠곡군 북삼읍 안산4길 9 (북삼읍,삼우빌)054-974-7230
구분학원명분야구분학원주소전화번호
206교습소더플러스영어교습소입시.검정 및 보습경상북도 칠곡군 왜관읍 구상길 180-1 , 2층 (왜관읍)<NA>
207교습소한솔플러스왜관영어교습소입시.검정 및 보습경상북도 칠곡군 왜관읍 석전로 66-1 , 1층 (왜관읍)<NA>
208교습소피타팻영어교습소입시.검정 및 보습경상북도 칠곡군 석적읍 남율로5길 53-24 (석적읍)<NA>
209교습소두드림영어교습소입시.검정 및 보습경상북도 칠곡군 왜관읍 달오2길 37 , 301동202호 (왜관읍, 칠곡 왜관 태왕아너스 센텀)<NA>
210교습소노리논술교습소입시.검정 및 보습경상북도 칠곡군 북삼읍 안산2길 13-1 (북삼읍)<NA>
211교습소링키영어교습소(칠곡북삼점)입시.검정 및 보습경상북도 칠곡군 북삼읍 인강1길 79 , 2층 (북삼읍)<NA>
212교습소그리고꿈꾸다미술교습소예능(대)경상북도 칠곡군 왜관읍 석전로 77-2 , 201동 103호 (왜관읍)<NA>
213교습소호산나피아노과외교습소예능(대)경상북도 칠곡군 약목면 약목로3길 15 (약목면)054-974-0478
214교습소신라수학교습소입시.검정 및 보습경상북도 칠곡군 왜관읍 남부2길 2-1054-971-0640
215교습소예일과외교습소입시.검정 및 보습경상북도 칠곡군 왜관읍 외기2길 16-3054-975-1217

Duplicate rows

Most frequently occurring

구분학원명분야구분학원주소전화번호# duplicates
0학원레인보우이베스트학원종합(대)경상북도 칠곡군 북삼읍 금오대로 59 (북삼읍)054-975-27772