Overview

Dataset statistics

Number of variables11
Number of observations23
Missing cells23
Missing cells (%)9.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.2 KiB
Average record size in memory95.7 B

Variable types

Categorical4
Text3
Boolean3
Unsupported1

Dataset

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

Alerts

교육청명 has constant value ""Constant
교육지원청명 has constant value ""Constant
학교안전공제회 대상여부 has constant value ""Constant
학교안전공제회 가입여부 has constant value ""Constant
공시차수 is highly imbalanced (67.6%)Imbalance
교육시설재난공제회 가입여부 has 23 (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 16:31:27.622103
Analysis finished2024-03-13 16:31:28.053626
Duration0.43 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

교육청명
Categorical

CONSTANT 

Distinct1
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size316.0 B
서울특별시교육청
23 

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 (%)
서울특별시교육청 23
100.0%

Length

2024-03-14T01:31:28.102780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:31:28.167918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울특별시교육청 23
100.0%

교육지원청명
Categorical

CONSTANT 

Distinct1
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size316.0 B
서부교육지원청
23 

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 (%)
서부교육지원청 23
100.0%

Length

2024-03-14T01:31:28.236418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:31:28.302304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서부교육지원청 23
100.0%

유치원코드
Text

UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size316.0 B
2024-03-14T01:31:28.466513image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length36
Mean length36
Min length36

Characters and Unicode

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

Unique23 ?
Unique (%)100.0%

Sample

1st row1ecec08c-f41d-b044-e053-0a32095ab044
2nd row1ecec08c-ef03-b044-e053-0a32095ab044
3rd row1ecec08c-f41c-b044-e053-0a32095ab044
4th row1ecec08c-f42e-b044-e053-0a32095ab044
5th row1ecec08c-f60d-b044-e053-0a32095ab044
ValueCountFrequency (%)
1ecec08c-f41d-b044-e053-0a32095ab044 1
 
4.3%
1ecec08c-fd1f-b044-e053-0a32095ab044 1
 
4.3%
1ecec08d-0bc9-b044-e053-0a32095ab044 1
 
4.3%
1ecec08d-0bc7-b044-e053-0a32095ab044 1
 
4.3%
8029c453-5828-459d-86ad-38f5de7ecda7 1
 
4.3%
1ecec08d-0cb3-b044-e053-0a32095ab044 1
 
4.3%
1ecec08d-0ba0-b044-e053-0a32095ab044 1
 
4.3%
1ecec08d-04ae-b044-e053-0a32095ab044 1
 
4.3%
1ecec08d-01d3-b044-e053-0a32095ab044 1
 
4.3%
1ecec08d-0071-b044-e053-0a32095ab044 1
 
4.3%
Other values (13) 13
56.5%
2024-03-14T01:31:28.783474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 146
17.6%
4 96
11.6%
- 92
11.1%
e 72
8.7%
c 66
8.0%
b 53
 
6.4%
a 52
 
6.3%
3 49
 
5.9%
5 48
 
5.8%
8 29
 
3.5%
Other values (7) 125
15.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 458
55.3%
Lowercase Letter 278
33.6%
Dash Punctuation 92
 
11.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 146
31.9%
4 96
21.0%
3 49
 
10.7%
5 48
 
10.5%
8 29
 
6.3%
1 28
 
6.1%
2 26
 
5.7%
9 26
 
5.7%
6 5
 
1.1%
7 5
 
1.1%
Lowercase Letter
ValueCountFrequency (%)
e 72
25.9%
c 66
23.7%
b 53
19.1%
a 52
18.7%
d 18
 
6.5%
f 17
 
6.1%
Dash Punctuation
ValueCountFrequency (%)
- 92
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 550
66.4%
Latin 278
33.6%

Most frequent character per script

Common
ValueCountFrequency (%)
0 146
26.5%
4 96
17.5%
- 92
16.7%
3 49
 
8.9%
5 48
 
8.7%
8 29
 
5.3%
1 28
 
5.1%
2 26
 
4.7%
9 26
 
4.7%
6 5
 
0.9%
Latin
ValueCountFrequency (%)
e 72
25.9%
c 66
23.7%
b 53
19.1%
a 52
18.7%
d 18
 
6.5%
f 17
 
6.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 828
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 146
17.6%
4 96
11.6%
- 92
11.1%
e 72
8.7%
c 66
8.0%
b 53
 
6.4%
a 52
 
6.3%
3 49
 
5.9%
5 48
 
5.8%
8 29
 
3.5%
Other values (7) 125
15.1%

유치원명
Text

UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size316.0 B
2024-03-14T01:31:28.952504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length14
Mean length7.826087
Min length4

Characters and Unicode

Total characters180
Distinct characters58
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

Unique23 ?
Unique (%)100.0%

Sample

1st row예그린유치원
2nd row연유치원
3rd row벧엘유치원
4th row서울인왕초등학교병설유치원
5th row한양제일유치원
ValueCountFrequency (%)
예그린유치원 1
 
4.3%
새나유치원 1
 
4.3%
홍제성당유치원 1
 
4.3%
현대경복유치원 1
 
4.3%
서울가재울초등학교병설유치원 1
 
4.3%
신현유치원 1
 
4.3%
명지전문대학부속명지유치원 1
 
4.3%
서울홍제초등학교병설유치원 1
 
4.3%
해맑은유치원 1
 
4.3%
서울금화초등학교병설유치원 1
 
4.3%
Other values (13) 13
56.5%
2024-03-14T01:31:29.212456image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
유 23
 
12.8%
치 23
 
12.8%
원 23
 
12.8%
학 7
 
3.9%
울 6
 
3.3%
교 5
 
2.8%
대 5
 
2.8%
서 5
 
2.8%
설 4
 
2.2%
병 4
 
2.2%
Other values (48) 75
41.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 180
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
유 23
 
12.8%
치 23
 
12.8%
원 23
 
12.8%
학 7
 
3.9%
울 6
 
3.3%
교 5
 
2.8%
대 5
 
2.8%
서 5
 
2.8%
설 4
 
2.2%
병 4
 
2.2%
Other values (48) 75
41.7%

Most occurring scripts

ValueCountFrequency (%)
Hangul 180
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
유 23
 
12.8%
치 23
 
12.8%
원 23
 
12.8%
학 7
 
3.9%
울 6
 
3.3%
교 5
 
2.8%
대 5
 
2.8%
서 5
 
2.8%
설 4
 
2.2%
병 4
 
2.2%
Other values (48) 75
41.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 180
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
유 23
 
12.8%
치 23
 
12.8%
원 23
 
12.8%
학 7
 
3.9%
울 6
 
3.3%
교 5
 
2.8%
대 5
 
2.8%
서 5
 
2.8%
설 4
 
2.2%
병 4
 
2.2%
Other values (48) 75
41.7%

설립유형
Categorical

Distinct4
Distinct (%)17.4%
Missing0
Missing (%)0.0%
Memory size316.0 B
사립(사인)
14 
공립(병설)
4 
사립(법인)
4 
공립(단설)
 
1

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique1 ?
Unique (%)4.3%

Sample

1st row사립(사인)
2nd row사립(사인)
3rd row사립(사인)
4th row공립(병설)
5th row사립(법인)

Common Values

ValueCountFrequency (%)
사립(사인) 14
60.9%
공립(병설) 4
 
17.4%
사립(법인) 4
 
17.4%
공립(단설) 1
 
4.3%

Length

2024-03-14T01:31:29.311276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:31:29.389161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사립(사인 14
60.9%
공립(병설 4
 
17.4%
사립(법인 4
 
17.4%
공립(단설 1
 
4.3%

학교안전공제회 대상여부
Boolean

CONSTANT 

Distinct1
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size155.0 B
True
23 
ValueCountFrequency (%)
True 23
100.0%
2024-03-14T01:31:29.464718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

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

CONSTANT 

Distinct1
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size155.0 B
True
23 
ValueCountFrequency (%)
True 23
100.0%
2024-03-14T01:31:29.517538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

교육시설재난공제회 대상여부
Boolean

Distinct2
Distinct (%)8.7%
Missing0
Missing (%)0.0%
Memory size155.0 B
True
17 
False
6 
ValueCountFrequency (%)
True 17
73.9%
False 6
 
26.1%
2024-03-14T01:31:29.614654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

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

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

공시차수
Categorical

IMBALANCE 

Distinct3
Distinct (%)13.0%
Missing0
Missing (%)0.0%
Memory size316.0 B
20232
21 
20192
 
1
20212
 
1

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique2 ?
Unique (%)8.7%

Sample

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

Common Values

ValueCountFrequency (%)
20232 21
91.3%
20192 1
 
4.3%
20212 1
 
4.3%

Length

2024-03-14T01:31:29.738209image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:31:29.854995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20232 21
91.3%
20192 1
 
4.3%
20212 1
 
4.3%

주소
Text

UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size316.0 B
2024-03-14T01:31:30.067456image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length21
Mean length19.608696
Min length17

Characters and Unicode

Total characters451
Distinct characters54
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

Unique23 ?
Unique (%)100.0%

Sample

1st row서울특별시 서대문구 홍제내길 84
2nd row서울특별시 서대문구 명지대길 39-4
3rd row서울특별시 서대문구 연희로10길 17-6
4th row서울특별시 서대문구 세무서길 33-9
5th row서울특별시 서대문구 통일로25길 30
ValueCountFrequency (%)
서울특별시 23
25.0%
서대문구 23
25.0%
가재울로 1
 
1.1%
45 1
 
1.1%
신촌로 1
 
1.1%
43 1
 
1.1%
통일로 1
 
1.1%
165 1
 
1.1%
거북골로21길 1
 
1.1%
55 1
 
1.1%
Other values (38) 38
41.3%
2024-03-14T01:31:30.414931image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
69
15.3%
서 47
 
10.4%
대 26
 
5.8%
울 24
 
5.3%
특 23
 
5.1%
별 23
 
5.1%
시 23
 
5.1%
문 23
 
5.1%
구 23
 
5.1%
길 17
 
3.8%
Other values (44) 153
33.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 305
67.6%
Decimal Number 74
 
16.4%
Space Separator 69
 
15.3%
Dash Punctuation 3
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 47
15.4%
대 26
8.5%
울 24
7.9%
특 23
 
7.5%
별 23
 
7.5%
시 23
 
7.5%
문 23
 
7.5%
구 23
 
7.5%
길 17
 
5.6%
로 17
 
5.6%
Other values (32) 59
19.3%
Decimal Number
ValueCountFrequency (%)
1 14
18.9%
3 13
17.6%
2 11
14.9%
5 8
10.8%
4 7
9.5%
6 7
9.5%
8 4
 
5.4%
0 4
 
5.4%
9 4
 
5.4%
7 2
 
2.7%
Space Separator
ValueCountFrequency (%)
69
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 305
67.6%
Common 146
32.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 47
15.4%
대 26
8.5%
울 24
7.9%
특 23
 
7.5%
별 23
 
7.5%
시 23
 
7.5%
문 23
 
7.5%
구 23
 
7.5%
길 17
 
5.6%
로 17
 
5.6%
Other values (32) 59
19.3%
Common
ValueCountFrequency (%)
69
47.3%
1 14
 
9.6%
3 13
 
8.9%
2 11
 
7.5%
5 8
 
5.5%
4 7
 
4.8%
6 7
 
4.8%
8 4
 
2.7%
0 4
 
2.7%
9 4
 
2.7%
Other values (2) 5
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 305
67.6%
ASCII 146
32.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
69
47.3%
1 14
 
9.6%
3 13
 
8.9%
2 11
 
7.5%
5 8
 
5.5%
4 7
 
4.8%
6 7
 
4.8%
8 4
 
2.7%
0 4
 
2.7%
9 4
 
2.7%
Other values (2) 5
 
3.4%
Hangul
ValueCountFrequency (%)
서 47
15.4%
대 26
8.5%
울 24
7.9%
특 23
 
7.5%
별 23
 
7.5%
시 23
 
7.5%
문 23
 
7.5%
구 23
 
7.5%
길 17
 
5.6%
로 17
 
5.6%
Other values (32) 59
19.3%

Correlations

2024-03-14T01:31:30.520769image/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.0000.0001.000
교육시설재난공제회 대상여부1.0001.0000.0001.0000.1471.000
공시차수1.0001.0000.0000.1471.0001.000
주소1.0001.0001.0001.0001.0001.000
2024-03-14T01:31:30.629158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공시차수설립유형교육시설재난공제회 대상여부
공시차수1.0000.0000.229
설립유형0.0001.0000.000
교육시설재난공제회 대상여부0.2290.0001.000
2024-03-14T01:31:30.723382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설립유형교육시설재난공제회 대상여부공시차수
설립유형1.0000.0000.000
교육시설재난공제회 대상여부0.0001.0000.229
공시차수0.0000.2291.000

Missing values

2024-03-14T01:31:27.881889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T01:31:28.003986image/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-f41d-b044-e053-0a32095ab044예그린유치원사립(사인)YYN<NA>20192서울특별시 서대문구 홍제내길 84
1서울특별시교육청서부교육지원청1ecec08c-ef03-b044-e053-0a32095ab044연유치원사립(사인)YYY<NA>20232서울특별시 서대문구 명지대길 39-4
2서울특별시교육청서부교육지원청1ecec08c-f41c-b044-e053-0a32095ab044벧엘유치원사립(사인)YYY<NA>20232서울특별시 서대문구 연희로10길 17-6
3서울특별시교육청서부교육지원청1ecec08c-f42e-b044-e053-0a32095ab044서울인왕초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 서대문구 세무서길 33-9
4서울특별시교육청서부교육지원청1ecec08c-f60d-b044-e053-0a32095ab044한양제일유치원사립(법인)YYY<NA>20232서울특별시 서대문구 통일로25길 30
5서울특별시교육청서부교육지원청1ecec08c-f64b-b044-e053-0a32095ab044경복유치원사립(사인)YYY<NA>20232서울특별시 서대문구 세검정로1길 95
6서울특별시교육청서부교육지원청1ecec08c-faa4-b044-e053-0a32095ab044조은유치원사립(사인)YYY<NA>20232서울특별시 서대문구 증가로 191
7서울특별시교육청서부교육지원청1ecec08c-faa6-b044-e053-0a32095ab044현대홍익유치원사립(사인)YYN<NA>20232서울특별시 서대문구 모래내로 432
8서울특별시교육청서부교육지원청1ecec08c-fb86-b044-e053-0a32095ab044이화여자대학교사범대학부속이화유치원사립(법인)YYY<NA>20232서울특별시 서대문구 이화여대길 52
9서울특별시교육청서부교육지원청1ecec08c-fb87-b044-e053-0a32095ab044인왕유치원사립(사인)YYY<NA>20212서울특별시 서대문구 통일로32길 23
교육청명교육지원청명유치원코드유치원명설립유형학교안전공제회 대상여부학교안전공제회 가입여부교육시설재난공제회 대상여부교육시설재난공제회 가입여부공시차수주소
13서울특별시교육청서부교육지원청1ecec08c-ffd9-b044-e053-0a32095ab044신촌유치원사립(사인)YYN<NA>20232서울특별시 서대문구 신촌로 43
14서울특별시교육청서부교육지원청1ecec08d-0071-b044-e053-0a32095ab044서울금화초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 서대문구 통일로 165
15서울특별시교육청서부교육지원청1ecec08d-01d3-b044-e053-0a32095ab044해맑은유치원사립(사인)YYY<NA>20232서울특별시 서대문구 거북골로21길 55
16서울특별시교육청서부교육지원청1ecec08d-04ae-b044-e053-0a32095ab044서울홍제초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 서대문구 홍은중앙로 13
17서울특별시교육청서부교육지원청1ecec08d-0ba0-b044-e053-0a32095ab044명지전문대학부속명지유치원사립(법인)YYY<NA>20232서울특별시 서대문구 명지2길 37
18서울특별시교육청서부교육지원청1ecec08d-0cb3-b044-e053-0a32095ab044신현유치원사립(사인)YYN<NA>20232서울특별시 서대문구 이화여대8길 28
19서울특별시교육청서부교육지원청8029c453-5828-459d-86ad-38f5de7ecda7서울가재울초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 서대문구 모래내로15길 61
20서울특별시교육청서부교육지원청1ecec08d-0bc7-b044-e053-0a32095ab044현대경복유치원사립(사인)YYY<NA>20232서울특별시 서대문구 통일로34길 66
21서울특별시교육청서부교육지원청1ecec08d-0bc9-b044-e053-0a32095ab044홍제성당유치원사립(법인)YYN<NA>20232서울특별시 서대문구 통일로40길 18
22서울특별시교육청서부교육지원청1ecec08d-0cb2-b044-e053-0a32095ab044세종유치원사립(사인)YYY<NA>20232서울특별시 서대문구 거북골로16길 36