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-20845/S/1/datasetView.do

Alerts

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

Reproduction

Analysis started2024-03-13 08:19:00.034014
Analysis finished2024-03-13 08:19:00.535264
Duration0.5 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-13T17:19:00.588060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T17:19:00.666414image/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-13T17:19:00.784763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T17:19:00.871683image/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-13T17:19:01.043482image/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-efa0-b044-e053-0a32095ab044
2nd row1ecec08c-f052-b044-e053-0a32095ab044
3rd row1ecec08c-f1b3-b044-e053-0a32095ab044
4th row1ecec08c-f1b4-b044-e053-0a32095ab044
5th row1ecec08c-f3e4-b044-e053-0a32095ab044
ValueCountFrequency (%)
1ecec08c-efa0-b044-e053-0a32095ab044 1
 
2.8%
1ecec08c-f052-b044-e053-0a32095ab044 1
 
2.8%
1ecec08d-0e10-b044-e053-0a32095ab044 1
 
2.8%
2e5397a8-bcbc-4691-accf-e2e60e8c5cfe 1
 
2.8%
89ed1bdc-67a2-4124-a077-bc925d6a901a 1
 
2.8%
dd6206b2-a72a-4bdd-992a-3922a54bdb4b 1
 
2.8%
1ecec08c-eecb-b044-e053-0a32095ab044 1
 
2.8%
1ecec08d-08be-b044-e053-0a32095ab044 1
 
2.8%
1ecec08d-0e01-b044-e053-0a32095ab044 1
 
2.8%
1ecec08d-012c-b044-e053-0a32095ab044 1
 
2.8%
Other values (26) 26
72.2%
2024-03-13T17:19:01.392421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 223
17.2%
- 144
11.1%
4 141
10.9%
e 116
9.0%
c 99
7.6%
b 81
 
6.2%
5 80
 
6.2%
a 79
 
6.1%
3 74
 
5.7%
2 51
 
3.9%
Other values (7) 208
16.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 722
55.7%
Lowercase Letter 430
33.2%
Dash Punctuation 144
 
11.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 223
30.9%
4 141
19.5%
5 80
 
11.1%
3 74
 
10.2%
2 51
 
7.1%
9 46
 
6.4%
1 46
 
6.4%
8 39
 
5.4%
6 12
 
1.7%
7 10
 
1.4%
Lowercase Letter
ValueCountFrequency (%)
e 116
27.0%
c 99
23.0%
b 81
18.8%
a 79
18.4%
d 28
 
6.5%
f 27
 
6.3%
Dash Punctuation
ValueCountFrequency (%)
- 144
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 866
66.8%
Latin 430
33.2%

Most frequent character per script

Common
ValueCountFrequency (%)
0 223
25.8%
- 144
16.6%
4 141
16.3%
5 80
 
9.2%
3 74
 
8.5%
2 51
 
5.9%
9 46
 
5.3%
1 46
 
5.3%
8 39
 
4.5%
6 12
 
1.4%
Latin
ValueCountFrequency (%)
e 116
27.0%
c 99
23.0%
b 81
18.8%
a 79
18.4%
d 28
 
6.5%
f 27
 
6.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1296
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 223
17.2%
- 144
11.1%
4 141
10.9%
e 116
9.0%
c 99
7.6%
b 81
 
6.2%
5 80
 
6.2%
a 79
 
6.1%
3 74
 
5.7%
2 51
 
3.9%
Other values (7) 208
16.0%

유치원명
Text

UNIQUE 

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

Length

Max length14
Median length13
Mean length8.1666667
Min length5

Characters and Unicode

Total characters294
Distinct characters67
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-13T17:19:01.903021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
38
12.9%
36
 
12.2%
36
 
12.2%
17
 
5.8%
16
 
5.4%
12
 
4.1%
12
 
4.1%
12
 
4.1%
12
 
4.1%
12
 
4.1%
Other values (57) 91
31.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 294
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
38
12.9%
36
 
12.2%
36
 
12.2%
17
 
5.8%
16
 
5.4%
12
 
4.1%
12
 
4.1%
12
 
4.1%
12
 
4.1%
12
 
4.1%
Other values (57) 91
31.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 294
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
38
12.9%
36
 
12.2%
36
 
12.2%
17
 
5.8%
16
 
5.4%
12
 
4.1%
12
 
4.1%
12
 
4.1%
12
 
4.1%
12
 
4.1%
Other values (57) 91
31.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 294
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
38
12.9%
36
 
12.2%
36
 
12.2%
17
 
5.8%
16
 
5.4%
12
 
4.1%
12
 
4.1%
12
 
4.1%
12
 
4.1%
12
 
4.1%
Other values (57) 91
31.0%

설립유형
Categorical

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

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 (%)
사립(사인) 18
50.0%
공립(병설) 12
33.3%
사립(법인) 4
 
11.1%
공립(단설) 2
 
5.6%

Length

2024-03-13T17:19:02.052382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T17:19:02.165450image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사립(사인 18
50.0%
공립(병설 12
33.3%
사립(법인 4
 
11.1%
공립(단설 2
 
5.6%
Distinct1
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Memory size168.0 B
True
36 
ValueCountFrequency (%)
True 36
100.0%
2024-03-13T17:19:02.242704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Distinct1
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Memory size168.0 B
True
36 
ValueCountFrequency (%)
True 36
100.0%
2024-03-13T17:19:02.303551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Distinct2
Distinct (%)5.6%
Missing0
Missing (%)0.0%
Memory size168.0 B
True
26 
False
10 
ValueCountFrequency (%)
True 26
72.2%
False 10
 
27.8%
2024-03-13T17:19:02.373684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

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

MISSING  REJECTED  UNSUPPORTED 

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

공시차수
Categorical

IMBALANCE 

Distinct4
Distinct (%)11.1%
Missing0
Missing (%)0.0%
Memory size420.0 B
20232
30 
20192
20212
 
1
20222
 
1

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique2 ?
Unique (%)5.6%

Sample

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

Common Values

ValueCountFrequency (%)
20232 30
83.3%
20192 4
 
11.1%
20212 1
 
2.8%
20222 1
 
2.8%

Length

2024-03-13T17:19:02.462942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T17:19:02.548248image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20232 30
83.3%
20192 4
 
11.1%
20212 1
 
2.8%
20222 1
 
2.8%

주소
Text

UNIQUE 

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

Length

Max length22
Median length20.5
Mean length18.305556
Min length15

Characters and Unicode

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

Unique36 ?
Unique (%)100.0%

Sample

1st row서울특별시 구로구 개봉로18길 37
2nd row서울특별시 구로구 고척로33길 34
3rd row서울특별시 구로구 개봉로16길 30-11
4th row서울특별시 구로구 도림로20길 57
5th row서울특별시 구로구 도림로 59
ValueCountFrequency (%)
서울특별시 36
25.0%
구로구 36
25.0%
고척로 3
 
2.1%
11 3
 
2.1%
도림로 2
 
1.4%
15 2
 
1.4%
22 2
 
1.4%
6 2
 
1.4%
신도림로 2
 
1.4%
개봉로18길 2
 
1.4%
Other values (53) 54
37.5%
2024-03-13T17:19:03.049585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
108
16.4%
76
11.5%
73
11.1%
39
 
5.9%
36
 
5.5%
36
 
5.5%
36
 
5.5%
36
 
5.5%
1 29
 
4.4%
22
 
3.3%
Other values (39) 168
25.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 428
64.9%
Decimal Number 119
 
18.1%
Space Separator 108
 
16.4%
Dash Punctuation 4
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
76
17.8%
73
17.1%
39
9.1%
36
8.4%
36
8.4%
36
8.4%
36
8.4%
22
 
5.1%
6
 
1.4%
6
 
1.4%
Other values (27) 62
14.5%
Decimal Number
ValueCountFrequency (%)
1 29
24.4%
2 21
17.6%
3 11
 
9.2%
6 10
 
8.4%
7 10
 
8.4%
8 9
 
7.6%
5 9
 
7.6%
4 8
 
6.7%
0 8
 
6.7%
9 4
 
3.4%
Space Separator
ValueCountFrequency (%)
108
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 428
64.9%
Common 231
35.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
76
17.8%
73
17.1%
39
9.1%
36
8.4%
36
8.4%
36
8.4%
36
8.4%
22
 
5.1%
6
 
1.4%
6
 
1.4%
Other values (27) 62
14.5%
Common
ValueCountFrequency (%)
108
46.8%
1 29
 
12.6%
2 21
 
9.1%
3 11
 
4.8%
6 10
 
4.3%
7 10
 
4.3%
8 9
 
3.9%
5 9
 
3.9%
4 8
 
3.5%
0 8
 
3.5%
Other values (2) 8
 
3.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 428
64.9%
ASCII 231
35.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
108
46.8%
1 29
 
12.6%
2 21
 
9.1%
3 11
 
4.8%
6 10
 
4.3%
7 10
 
4.3%
8 9
 
3.9%
5 9
 
3.9%
4 8
 
3.5%
0 8
 
3.5%
Other values (2) 8
 
3.5%
Hangul
ValueCountFrequency (%)
76
17.8%
73
17.1%
39
9.1%
36
8.4%
36
8.4%
36
8.4%
36
8.4%
22
 
5.1%
6
 
1.4%
6
 
1.4%
Other values (27) 62
14.5%

Correlations

2024-03-13T17:19:03.145687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
유치원코드유치원명설립유형교육시설재난공제회 대상여부공시차수주소
유치원코드1.0001.0001.0001.0001.0001.000
유치원명1.0001.0001.0001.0001.0001.000
설립유형1.0001.0001.0000.6090.0001.000
교육시설재난공제회 대상여부1.0001.0000.6091.0000.5841.000
공시차수1.0001.0000.0000.5841.0001.000
주소1.0001.0001.0001.0001.0001.000
2024-03-13T17:19:03.230944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공시차수설립유형교육시설재난공제회 대상여부
공시차수1.0000.0000.387
설립유형0.0001.0000.406
교육시설재난공제회 대상여부0.3870.4061.000
2024-03-13T17:19:03.303375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설립유형교육시설재난공제회 대상여부공시차수
설립유형1.0000.4060.000
교육시설재난공제회 대상여부0.4061.0000.387
공시차수0.0000.3871.000

Missing values

2024-03-13T17:19:00.322170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T17:19:00.484807image/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-efa0-b044-e053-0a32095ab044미림유치원사립(사인)YYY<NA>20232서울특별시 구로구 개봉로18길 37
1서울특별시교육청남부교육지원청1ecec08c-f052-b044-e053-0a32095ab044서울세곡초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 구로구 고척로33길 34
2서울특별시교육청남부교육지원청1ecec08c-f1b3-b044-e053-0a32095ab044서울개봉초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 구로구 개봉로16길 30-11
3서울특별시교육청남부교육지원청1ecec08c-f1b4-b044-e053-0a32095ab044서울영서초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 구로구 도림로20길 57
4서울특별시교육청남부교육지원청1ecec08c-f3e4-b044-e053-0a32095ab044새두산유치원사립(사인)YYN<NA>20232서울특별시 구로구 도림로 59
5서울특별시교육청남부교육지원청1ecec08c-f3f7-b044-e053-0a32095ab044세희유치원사립(사인)YYN<NA>20232서울특별시 구로구 도림로 107
6서울특별시교육청남부교육지원청1ecec08c-f5d6-b044-e053-0a32095ab044서울매봉초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 구로구 고척로21길 55
7서울특별시교육청남부교육지원청1ecec08c-f5fd-b044-e053-0a32095ab044서울고척초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 구로구 경서로 31
8서울특별시교육청남부교육지원청1ecec08c-f5fe-b044-e053-0a32095ab044서울남유치원사립(사인)YYY<NA>20232서울특별시 구로구 구로동로17길 37-4
9서울특별시교육청남부교육지원청1ecec08c-f707-b044-e053-0a32095ab044목원유치원사립(사인)YYN<NA>20232서울특별시 구로구 개봉로20길 6
교육청명교육지원청명유치원코드유치원명설립유형학교안전공제회 대상여부학교안전공제회 가입여부교육시설재난공제회 대상여부교육시설재난공제회 가입여부공시차수주소
26서울특별시교육청남부교육지원청1ecec08d-0e10-b044-e053-0a32095ab044신도유치원사립(사인)YYY<NA>20232서울특별시 구로구 구일로2길 45
27서울특별시교육청남부교육지원청1ecec08d-012c-b044-e053-0a32095ab044동부유치원사립(사인)YYY<NA>20212서울특별시 구로구 고척로 49
28서울특별시교육청남부교육지원청1ecec08c-f32a-b044-e053-0a32095ab044준희유치원사립(사인)YYN<NA>20192서울특별시 구로구 경인로19길 8
29서울특별시교육청남부교육지원청1ecec08c-ed2f-b044-e053-0a32095ab044서울아람유치원사립(사인)YYN<NA>20192서울특별시 구로구 고척로25길 62
30서울특별시교육청남부교육지원청1ecec08c-f321-b044-e053-0a32095ab044나비유치원사립(사인)YYN<NA>20222서울특별시 구로구 고척로 30
31서울특별시교육청남부교육지원청1ecec08c-feac-b044-e053-0a32095ab044서울구로남초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 구로구 디지털로27길 76
32서울특별시교육청남부교육지원청1ecec08d-08c9-b044-e053-0a32095ab044일신유치원사립(사인)YYY<NA>20192서울특별시 구로구 오류로8길 22
33서울특별시교육청남부교육지원청1ecec08d-099f-b044-e053-0a32095ab044버들유치원사립(사인)YYN<NA>20192서울특별시 구로구 오류로8길 40
34서울특별시교육청남부교육지원청1ecec08d-02b2-b044-e053-0a32095ab044서울하늘숲유치원공립(단설)YYY<NA>20232서울특별시 구로구 오리로 1102-19
35서울특별시교육청남부교육지원청1ecec08d-0557-b044-e053-0a32095ab044바니유치원사립(사인)YYY<NA>20232서울특별시 구로구 구일로4길 46