Overview

Dataset statistics

Number of variables11
Number of observations36
Missing cells36
Missing cells (%)9.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.3 KiB
Average record size in memory93.7 B

Variable types

Categorical4
Text3
Boolean3
Unsupported1

Dataset

Description교육청명,교육지원청명,유치원코드,유치원명,설립유형,학교안전공제회 대상여부,학교안전공제회 가입여부,교육시설재난공제회 대상여부,교육시설재난공제회 가입여부,공시차수,주소
Author도봉구
URLhttps://data.seoul.go.kr/dataList/OA-20838/S/1/datasetView.do

Alerts

교육청명 has constant value ""Constant
교육지원청명 has constant value ""Constant
학교안전공제회 대상여부 has constant value ""Constant
학교안전공제회 가입여부 is highly overall correlated with 공시차수High correlation
공시차수 is highly overall correlated with 학교안전공제회 가입여부High correlation
학교안전공제회 가입여부 is highly imbalanced (81.7%)Imbalance
교육시설재난공제회 가입여부 has 36 (100.0%) missing valuesMissing
유치원코드 has unique valuesUnique
유치원명 has unique valuesUnique
교육시설재난공제회 가입여부 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-03-13 14:17:52.359168
Analysis finished2024-03-13 14:17:52.918685
Duration0.56 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

교육청명
Categorical

CONSTANT 

Distinct1
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Memory size420.0 B
서울특별시교육청
36 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서울특별시교육청
2nd row서울특별시교육청
3rd row서울특별시교육청
4th row서울특별시교육청
5th row서울특별시교육청

Common Values

ValueCountFrequency (%)
서울특별시교육청 36
100.0%

Length

2024-03-13T23:17:53.281322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T23:17:53.381446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울특별시교육청 36
100.0%

교육지원청명
Categorical

CONSTANT 

Distinct1
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Memory size420.0 B
북부교육지원청
36 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row북부교육지원청
2nd row북부교육지원청
3rd row북부교육지원청
4th row북부교육지원청
5th row북부교육지원청

Common Values

ValueCountFrequency (%)
북부교육지원청 36
100.0%

Length

2024-03-13T23:17:53.475947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T23:17:53.567765image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
북부교육지원청 36
100.0%

유치원코드
Text

UNIQUE 

Distinct36
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size420.0 B
2024-03-13T23:17:53.746611image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length36
Mean length36
Min length36

Characters and Unicode

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

Unique

Unique36 ?
Unique (%)100.0%

Sample

1st row1ecec08c-f404-b044-e053-0a32095ab044
2nd row1ecec08c-f54e-b044-e053-0a32095ab044
3rd row1ecec08d-0158-b044-e053-0a32095ab044
4th row1ecec08d-0ba6-b044-e053-0a32095ab044
5th row1ecec08d-0e36-b044-e053-0a32095ab044
ValueCountFrequency (%)
1ecec08c-f404-b044-e053-0a32095ab044 1
 
2.8%
1ecec08c-f54e-b044-e053-0a32095ab044 1
 
2.8%
1ecec08d-0b9f-b044-e053-0a32095ab044 1
 
2.8%
1ecec08d-00a8-b044-e053-0a32095ab044 1
 
2.8%
1ecec08d-0157-b044-e053-0a32095ab044 1
 
2.8%
1ecec08d-040a-b044-e053-0a32095ab044 1
 
2.8%
1ecec08d-078f-b044-e053-0a32095ab044 1
 
2.8%
1ecec08d-08cf-b044-e053-0a32095ab044 1
 
2.8%
1ecec08d-09d1-b044-e053-0a32095ab044 1
 
2.8%
1ecec08d-0d3d-b044-e053-0a32095ab044 1
 
2.8%
Other values (26) 26
72.2%
2024-03-13T23:17:54.183411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 201
15.5%
- 144
11.1%
4 142
11.0%
e 114
8.8%
c 95
 
7.3%
a 82
 
6.3%
b 76
 
5.9%
3 76
 
5.9%
5 74
 
5.7%
1 53
 
4.1%
Other values (7) 239
18.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 721
55.6%
Lowercase Letter 431
33.3%
Dash Punctuation 144
 
11.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 201
27.9%
4 142
19.7%
3 76
 
10.5%
5 74
 
10.3%
1 53
 
7.4%
8 51
 
7.1%
9 48
 
6.7%
2 47
 
6.5%
6 15
 
2.1%
7 14
 
1.9%
Lowercase Letter
ValueCountFrequency (%)
e 114
26.5%
c 95
22.0%
a 82
19.0%
b 76
17.6%
d 36
 
8.4%
f 28
 
6.5%
Dash Punctuation
ValueCountFrequency (%)
- 144
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 865
66.7%
Latin 431
33.3%

Most frequent character per script

Common
ValueCountFrequency (%)
0 201
23.2%
- 144
16.6%
4 142
16.4%
3 76
 
8.8%
5 74
 
8.6%
1 53
 
6.1%
8 51
 
5.9%
9 48
 
5.5%
2 47
 
5.4%
6 15
 
1.7%
Latin
ValueCountFrequency (%)
e 114
26.5%
c 95
22.0%
a 82
19.0%
b 76
17.6%
d 36
 
8.4%
f 28
 
6.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1296
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 201
15.5%
- 144
11.1%
4 142
11.0%
e 114
8.8%
c 95
 
7.3%
a 82
 
6.3%
b 76
 
5.9%
3 76
 
5.9%
5 74
 
5.7%
1 53
 
4.1%
Other values (7) 239
18.4%

유치원명
Text

UNIQUE 

Distinct36
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size420.0 B
2024-03-13T23:17:54.477827image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length5
Mean length7.4444444
Min length5

Characters and Unicode

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

Unique

Unique36 ?
Unique (%)100.0%

Sample

1st row다솜유치원
2nd row현대유치원
3rd row천사유치원
4th row예그린유치원
5th row지현유치원
ValueCountFrequency (%)
다솜유치원 1
 
2.8%
현대유치원 1
 
2.8%
서울신창초등학교병설유치원 1
 
2.8%
삼풍유치원 1
 
2.8%
자연유치원 1
 
2.8%
사랑유치원 1
 
2.8%
한사랑유치원 1
 
2.8%
솔샘유치원 1
 
2.8%
유화유치원 1
 
2.8%
신창유치원 1
 
2.8%
Other values (26) 26
72.2%
2024-03-13T23:17:54.830621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
37
13.8%
36
13.4%
36
13.4%
12
 
4.5%
11
 
4.1%
11
 
4.1%
10
 
3.7%
9
 
3.4%
9
 
3.4%
9
 
3.4%
Other values (60) 88
32.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 268
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
37
13.8%
36
13.4%
36
13.4%
12
 
4.5%
11
 
4.1%
11
 
4.1%
10
 
3.7%
9
 
3.4%
9
 
3.4%
9
 
3.4%
Other values (60) 88
32.8%

Most occurring scripts

ValueCountFrequency (%)
Hangul 268
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
37
13.8%
36
13.4%
36
13.4%
12
 
4.5%
11
 
4.1%
11
 
4.1%
10
 
3.7%
9
 
3.4%
9
 
3.4%
9
 
3.4%
Other values (60) 88
32.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 268
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
37
13.8%
36
13.4%
36
13.4%
12
 
4.5%
11
 
4.1%
11
 
4.1%
10
 
3.7%
9
 
3.4%
9
 
3.4%
9
 
3.4%
Other values (60) 88
32.8%

설립유형
Categorical

Distinct4
Distinct (%)11.1%
Missing0
Missing (%)0.0%
Memory size420.0 B
사립(사인)
22 
공립(병설)
사립(법인)
공립(단설)
 
2

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row사립(사인)
2nd row사립(사인)
3rd row사립(사인)
4th row사립(사인)
5th row사립(사인)

Common Values

ValueCountFrequency (%)
사립(사인) 22
61.1%
공립(병설) 9
25.0%
사립(법인) 3
 
8.3%
공립(단설) 2
 
5.6%

Length

2024-03-13T23:17:54.971570image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T23:17:55.098298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사립(사인 22
61.1%
공립(병설 9
25.0%
사립(법인 3
 
8.3%
공립(단설 2
 
5.6%
Distinct1
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Memory size168.0 B
True
36 
ValueCountFrequency (%)
True 36
100.0%
2024-03-13T23:17:55.212720image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

학교안전공제회 가입여부
Boolean

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)5.6%
Missing0
Missing (%)0.0%
Memory size168.0 B
True
35 
False
 
1
ValueCountFrequency (%)
True 35
97.2%
False 1
 
2.8%
2024-03-13T23:17:55.281878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Distinct2
Distinct (%)5.6%
Missing0
Missing (%)0.0%
Memory size168.0 B
True
25 
False
11 
ValueCountFrequency (%)
True 25
69.4%
False 11
30.6%
2024-03-13T23:17:55.362367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

교육시설재난공제회 가입여부
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing36
Missing (%)100.0%
Memory size456.0 B

공시차수
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)11.1%
Missing0
Missing (%)0.0%
Memory size420.0 B
20232
28 
20182
20192
 
2
20212
 
1

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique1 ?
Unique (%)2.8%

Sample

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

Common Values

ValueCountFrequency (%)
20232 28
77.8%
20182 5
 
13.9%
20192 2
 
5.6%
20212 1
 
2.8%

Length

2024-03-13T23:17:55.462034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T23:17:55.554455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20232 28
77.8%
20182 5
 
13.9%
20192 2
 
5.6%
20212 1
 
2.8%

주소
Text

Distinct34
Distinct (%)94.4%
Missing0
Missing (%)0.0%
Memory size420.0 B
2024-03-13T23:17:55.756536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length21
Mean length18.805556
Min length17

Characters and Unicode

Total characters677
Distinct characters43
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 (%)88.9%

Sample

1st row서울특별시 도봉구 해등로 195
2nd row서울특별시 도봉구 삼양로 574-38
3rd row서울특별시 도봉구 해등로26길 20
4th row서울특별시 도봉구 노해로 201-1
5th row서울특별시 도봉구 도봉산3길 21
ValueCountFrequency (%)
서울특별시 36
25.0%
도봉구 36
25.0%
해등로 5
 
3.5%
마들로 4
 
2.8%
노해로 2
 
1.4%
시루봉로 2
 
1.4%
96 2
 
1.4%
101 2
 
1.4%
14-11 2
 
1.4%
도당로6길 2
 
1.4%
Other values (50) 51
35.4%
2024-03-13T23:17:56.104139image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
108
16.0%
43
 
6.4%
42
 
6.2%
39
 
5.8%
36
 
5.3%
36
 
5.3%
36
 
5.3%
36
 
5.3%
36
 
5.3%
35
 
5.2%
Other values (33) 230
34.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 425
62.8%
Decimal Number 137
 
20.2%
Space Separator 108
 
16.0%
Dash Punctuation 7
 
1.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
43
10.1%
42
9.9%
39
9.2%
36
8.5%
36
8.5%
36
8.5%
36
8.5%
36
8.5%
35
8.2%
19
 
4.5%
Other values (21) 67
15.8%
Decimal Number
ValueCountFrequency (%)
1 28
20.4%
6 21
15.3%
3 15
10.9%
2 14
10.2%
9 13
9.5%
4 12
8.8%
7 11
 
8.0%
0 10
 
7.3%
8 7
 
5.1%
5 6
 
4.4%
Space Separator
ValueCountFrequency (%)
108
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 425
62.8%
Common 252
37.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
43
10.1%
42
9.9%
39
9.2%
36
8.5%
36
8.5%
36
8.5%
36
8.5%
36
8.5%
35
8.2%
19
 
4.5%
Other values (21) 67
15.8%
Common
ValueCountFrequency (%)
108
42.9%
1 28
 
11.1%
6 21
 
8.3%
3 15
 
6.0%
2 14
 
5.6%
9 13
 
5.2%
4 12
 
4.8%
7 11
 
4.4%
0 10
 
4.0%
- 7
 
2.8%
Other values (2) 13
 
5.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 425
62.8%
ASCII 252
37.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
108
42.9%
1 28
 
11.1%
6 21
 
8.3%
3 15
 
6.0%
2 14
 
5.6%
9 13
 
5.2%
4 12
 
4.8%
7 11
 
4.4%
0 10
 
4.0%
- 7
 
2.8%
Other values (2) 13
 
5.2%
Hangul
ValueCountFrequency (%)
43
10.1%
42
9.9%
39
9.2%
36
8.5%
36
8.5%
36
8.5%
36
8.5%
36
8.5%
35
8.2%
19
 
4.5%
Other values (21) 67
15.8%

Correlations

2024-03-13T23:17:56.214216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
유치원코드유치원명설립유형학교안전공제회 가입여부교육시설재난공제회 대상여부공시차수주소
유치원코드1.0001.0001.0001.0001.0001.0001.000
유치원명1.0001.0001.0001.0001.0001.0001.000
설립유형1.0001.0001.0000.0000.5210.0000.000
학교안전공제회 가입여부1.0001.0000.0001.0000.0000.8620.000
교육시설재난공제회 대상여부1.0001.0000.5210.0001.0000.5740.000
공시차수1.0001.0000.0000.8620.5741.0000.000
주소1.0001.0000.0000.0000.0000.0001.000
2024-03-13T23:17:56.363606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공시차수설립유형교육시설재난공제회 대상여부학교안전공제회 가입여부
공시차수1.0000.0000.3800.642
설립유형0.0001.0000.3410.000
교육시설재난공제회 대상여부0.3800.3411.0000.000
학교안전공제회 가입여부0.6420.0000.0001.000
2024-03-13T23:17:56.520113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설립유형학교안전공제회 가입여부교육시설재난공제회 대상여부공시차수
설립유형1.0000.0000.3410.000
학교안전공제회 가입여부0.0001.0000.0000.642
교육시설재난공제회 대상여부0.3410.0001.0000.380
공시차수0.0000.6420.3801.000

Missing values

2024-03-13T23:17:52.716730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T23:17:52.863210image/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서울특별시교육청북부교육지원청1ecec08c-f404-b044-e053-0a32095ab044다솜유치원사립(사인)YYN<NA>20182서울특별시 도봉구 해등로 195
1서울특별시교육청북부교육지원청1ecec08c-f54e-b044-e053-0a32095ab044현대유치원사립(사인)YYN<NA>20182서울특별시 도봉구 삼양로 574-38
2서울특별시교육청북부교육지원청1ecec08d-0158-b044-e053-0a32095ab044천사유치원사립(사인)YYY<NA>20182서울특별시 도봉구 해등로26길 20
3서울특별시교육청북부교육지원청1ecec08d-0ba6-b044-e053-0a32095ab044예그린유치원사립(사인)YYY<NA>20182서울특별시 도봉구 노해로 201-1
4서울특별시교육청북부교육지원청1ecec08d-0e36-b044-e053-0a32095ab044지현유치원사립(사인)YYN<NA>20182서울특별시 도봉구 도봉산3길 21
5서울특별시교육청북부교육지원청1ecec08c-eed0-b044-e053-0a32095ab044슬기유치원사립(사인)YYY<NA>20232서울특별시 도봉구 도봉로180나길 33-29
6서울특별시교육청북부교육지원청1ecec08c-eecf-b044-e053-0a32095ab044선희유치원사립(사인)YYY<NA>20232서울특별시 도봉구 해등로 241
7서울특별시교육청북부교육지원청9274b95a-f964-4434-aa72-f188312b1983서울오봉초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 도봉구 시루봉로 285
8서울특별시교육청북부교육지원청12c109c2-23b7-4e98-a3e1-57e391f3a55a서울월천초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 도봉구 노해로70길 96
9서울특별시교육청북부교육지원청1ecec08c-ed87-b044-e053-0a32095ab044햇살유치원사립(사인)YYN<NA>20232서울특별시 도봉구 우이천로32길 38
교육청명교육지원청명유치원코드유치원명설립유형학교안전공제회 대상여부학교안전공제회 가입여부교육시설재난공제회 대상여부교육시설재난공제회 가입여부공시차수주소
26서울특별시교육청북부교육지원청1ecec08d-0b9f-b044-e053-0a32095ab044서울신창초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 도봉구 덕릉로60길 93
27서울특별시교육청북부교육지원청1ecec08d-0d3d-b044-e053-0a32095ab044신창유치원사립(사인)YYY<NA>20232서울특별시 도봉구 덕릉로 272
28서울특별시교육청북부교육지원청1ecec08d-0e2d-b044-e053-0a32095ab044나래유치원사립(사인)YYN<NA>20232서울특별시 도봉구 마들로 684-9
29서울특별시교육청북부교육지원청1ecec08d-0ec5-b044-e053-0a32095ab044자연아이유치원사립(사인)YNN<NA>20192서울특별시 도봉구 도당로6길 14-11
30서울특별시교육청북부교육지원청6a9d51ce-eb32-4ff3-b2c8-16baa768c7ed서울신학초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 도봉구 방학로 247-21
31서울특별시교육청북부교육지원청78c914ee-918a-42da-bb74-3214158a262e서울쌍문초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 도봉구 우이천로 360
32서울특별시교육청북부교육지원청86a6794b-12d6-4ee1-b47c-f03260e69af8서울가인초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 도봉구 도봉로136다길 4
33서울특별시교육청북부교육지원청90accaf4-0b0f-42a0-bf14-dabb5c82db9f서울방학유치원공립(단설)YYY<NA>20232서울특별시 도봉구 도당로6길 14-11
34서울특별시교육청북부교육지원청bbc01edd-3428-41d0-9a8c-8369c54e1fd5서울마들유치원공립(단설)YYY<NA>20232서울특별시 도봉구 마들로 567
35서울특별시교육청북부교육지원청c17caf35-438d-4c89-b23f-458335cc0ac0서울숭미초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 도봉구 노해로 179