Overview

Dataset statistics

Number of variables11
Number of observations30
Missing cells30
Missing cells (%)9.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.8 KiB
Average record size in memory94.4 B

Variable types

Categorical4
Text3
Boolean3
Unsupported1

Dataset

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

Alerts

교육청명 has constant value ""Constant
교육지원청명 has constant value ""Constant
학교안전공제회 대상여부 has constant value ""Constant
학교안전공제회 가입여부 has constant value ""Constant
공시차수 is highly imbalanced (64.6%)Imbalance
교육시설재난공제회 가입여부 has 30 (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 13:50:29.233278
Analysis finished2024-03-13 13:50:31.861834
Duration2.63 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

교육청명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
서울특별시교육청
30 

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

Length

2024-03-13T22:50:31.935237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:50:32.042506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울특별시교육청 30
100.0%

교육지원청명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
서부교육지원청
30 

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

Length

2024-03-13T22:50:32.151731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:50:32.265306image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서부교육지원청 30
100.0%

유치원코드
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2024-03-13T22:50:32.473418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length36
Mean length36
Min length36

Characters and Unicode

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

Unique30 ?
Unique (%)100.0%

Sample

1st row1ecec08d-0e40-b044-e053-0a32095ab044
2nd row1ecec08d-0c0b-b044-e053-0a32095ab044
3rd row1ecec08d-04dc-b044-e053-0a32095ab044
4th row1ecec08d-0b27-b044-e053-0a32095ab044
5th row1ecec08d-0d42-b044-e053-0a32095ab044
ValueCountFrequency (%)
1ecec08d-0e40-b044-e053-0a32095ab044 1
 
3.3%
1ecec08d-0c0b-b044-e053-0a32095ab044 1
 
3.3%
1ecec08d-04b0-b044-e053-0a32095ab044 1
 
3.3%
1ecec08d-04ad-b044-e053-0a32095ab044 1
 
3.3%
1ecec08c-fd1d-b044-e053-0a32095ab044 1
 
3.3%
1ecec08d-0160-b044-e053-0a32095ab044 1
 
3.3%
1ecec08c-fed8-b044-e053-0a32095ab044 1
 
3.3%
1ecec08c-fc56-b044-e053-0a32095ab044 1
 
3.3%
1ecec08c-fb84-b044-e053-0a32095ab044 1
 
3.3%
1ecec08c-f7f6-b044-e053-0a32095ab044 1
 
3.3%
Other values (20) 20
66.7%
2024-03-13T22:50:32.934730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 175
16.2%
- 120
11.1%
4 120
11.1%
e 98
9.1%
c 78
 
7.2%
b 69
 
6.4%
5 62
 
5.7%
a 57
 
5.3%
3 57
 
5.3%
1 45
 
4.2%
Other values (7) 199
18.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 600
55.6%
Lowercase Letter 360
33.3%
Dash Punctuation 120
 
11.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 175
29.2%
4 120
20.0%
5 62
 
10.3%
3 57
 
9.5%
1 45
 
7.5%
8 41
 
6.8%
2 40
 
6.7%
9 31
 
5.2%
7 17
 
2.8%
6 12
 
2.0%
Lowercase Letter
ValueCountFrequency (%)
e 98
27.2%
c 78
21.7%
b 69
19.2%
a 57
15.8%
d 38
 
10.6%
f 20
 
5.6%
Dash Punctuation
ValueCountFrequency (%)
- 120
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 720
66.7%
Latin 360
33.3%

Most frequent character per script

Common
ValueCountFrequency (%)
0 175
24.3%
- 120
16.7%
4 120
16.7%
5 62
 
8.6%
3 57
 
7.9%
1 45
 
6.2%
8 41
 
5.7%
2 40
 
5.6%
9 31
 
4.3%
7 17
 
2.4%
Latin
ValueCountFrequency (%)
e 98
27.2%
c 78
21.7%
b 69
19.2%
a 57
15.8%
d 38
 
10.6%
f 20
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1080
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 175
16.2%
- 120
11.1%
4 120
11.1%
e 98
9.1%
c 78
 
7.2%
b 69
 
6.4%
5 62
 
5.7%
a 57
 
5.3%
3 57
 
5.3%
1 45
 
4.2%
Other values (7) 199
18.4%

유치원명
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2024-03-13T22:50:33.240391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length13
Mean length9.1666667
Min length5

Characters and Unicode

Total characters275
Distinct characters64
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

Unique30 ?
Unique (%)100.0%

Sample

1st row삼성그린유치원
2nd row돌샘유치원
3rd row서울하늘초등학교병설유치원
4th row마포대진유치원
5th row서울공덕초등학교병설유치원
ValueCountFrequency (%)
삼성그린유치원 1
 
3.3%
돌샘유치원 1
 
3.3%
성결유치원 1
 
3.3%
서울창천초등학교병설유치원 1
 
3.3%
아이들이야기유치원 1
 
3.3%
새현대유치원 1
 
3.3%
태영유치원 1
 
3.3%
월드유치원 1
 
3.3%
서울용강초등학교병설유치원 1
 
3.3%
나사렛유치원 1
 
3.3%
Other values (20) 20
66.7%
2024-03-13T22:50:33.617928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
유 30
 
10.9%
치 30
 
10.9%
원 30
 
10.9%
서 17
 
6.2%
교 15
 
5.5%
학 15
 
5.5%
울 14
 
5.1%
초 13
 
4.7%
설 13
 
4.7%
병 13
 
4.7%
Other values (54) 85
30.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 275
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
유 30
 
10.9%
치 30
 
10.9%
원 30
 
10.9%
서 17
 
6.2%
교 15
 
5.5%
학 15
 
5.5%
울 14
 
5.1%
초 13
 
4.7%
설 13
 
4.7%
병 13
 
4.7%
Other values (54) 85
30.9%

Most occurring scripts

ValueCountFrequency (%)
Hangul 275
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
유 30
 
10.9%
치 30
 
10.9%
원 30
 
10.9%
서 17
 
6.2%
교 15
 
5.5%
학 15
 
5.5%
울 14
 
5.1%
초 13
 
4.7%
설 13
 
4.7%
병 13
 
4.7%
Other values (54) 85
30.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 275
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
유 30
 
10.9%
치 30
 
10.9%
원 30
 
10.9%
서 17
 
6.2%
교 15
 
5.5%
학 15
 
5.5%
울 14
 
5.1%
초 13
 
4.7%
설 13
 
4.7%
병 13
 
4.7%
Other values (54) 85
30.9%

설립유형
Categorical

Distinct3
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
사립(사인)
13 
공립(병설)
13 
사립(법인)
4 

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 (%)
사립(사인) 13
43.3%
공립(병설) 13
43.3%
사립(법인) 4
 
13.3%

Length

2024-03-13T22:50:33.770785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:50:33.913172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사립(사인 13
43.3%
공립(병설 13
43.3%
사립(법인 4
 
13.3%

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

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size162.0 B
True
30 
ValueCountFrequency (%)
True 30
100.0%
2024-03-13T22:50:34.028346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

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

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size162.0 B
True
30 
ValueCountFrequency (%)
True 30
100.0%
2024-03-13T22:50:34.120131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

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

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size162.0 B
True
22 
False
8 
ValueCountFrequency (%)
True 22
73.3%
False 8
 
26.7%
2024-03-13T22:50:34.204734image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

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

MISSING  REJECTED  UNSUPPORTED 

Missing30
Missing (%)100.0%
Memory size402.0 B

공시차수
Categorical

IMBALANCE 

Distinct3
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
20232
27 
20182
 
2
20192
 
1

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique1 ?
Unique (%)3.3%

Sample

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

Common Values

ValueCountFrequency (%)
20232 27
90.0%
20182 2
 
6.7%
20192 1
 
3.3%

Length

2024-03-13T22:50:34.345774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:50:34.447868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20232 27
90.0%
20182 2
 
6.7%
20192 1
 
3.3%

주소
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2024-03-13T22:50:34.645239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length20.5
Mean length18.9
Min length16

Characters and Unicode

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

Unique30 ?
Unique (%)100.0%

Sample

1st row서울특별시 마포구 도화4길 62
2nd row서울특별시 마포구 백범로37길 12
3rd row서울특별시 마포구 월드컵북로 502-14
4th row서울특별시 마포구 성미산로 110
5th row서울특별시 마포구 만리재옛길 13
ValueCountFrequency (%)
서울특별시 30
25.0%
마포구 30
25.0%
월드컵북로 4
 
3.3%
월드컵로42길 2
 
1.7%
성미산로 2
 
1.7%
19 2
 
1.7%
독막로28길 1
 
0.8%
매봉산로 1
 
0.8%
30 1
 
0.8%
성미산로11길 1
 
0.8%
Other values (46) 46
38.3%
2024-03-13T22:50:35.030363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
90
15.9%
마 31
 
5.5%
포 31
 
5.5%
서 30
 
5.3%
특 30
 
5.3%
별 30
 
5.3%
시 30
 
5.3%
구 30
 
5.3%
울 30
 
5.3%
로 24
 
4.2%
Other values (44) 211
37.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 370
65.3%
Decimal Number 103
 
18.2%
Space Separator 90
 
15.9%
Dash Punctuation 4
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
마 31
 
8.4%
포 31
 
8.4%
서 30
 
8.1%
특 30
 
8.1%
별 30
 
8.1%
시 30
 
8.1%
구 30
 
8.1%
울 30
 
8.1%
로 24
 
6.5%
길 21
 
5.7%
Other values (32) 83
22.4%
Decimal Number
ValueCountFrequency (%)
1 24
23.3%
2 19
18.4%
3 13
12.6%
4 13
12.6%
6 10
9.7%
5 9
 
8.7%
7 5
 
4.9%
9 4
 
3.9%
0 3
 
2.9%
8 3
 
2.9%
Space Separator
ValueCountFrequency (%)
90
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 370
65.3%
Common 197
34.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
마 31
 
8.4%
포 31
 
8.4%
서 30
 
8.1%
특 30
 
8.1%
별 30
 
8.1%
시 30
 
8.1%
구 30
 
8.1%
울 30
 
8.1%
로 24
 
6.5%
길 21
 
5.7%
Other values (32) 83
22.4%
Common
ValueCountFrequency (%)
90
45.7%
1 24
 
12.2%
2 19
 
9.6%
3 13
 
6.6%
4 13
 
6.6%
6 10
 
5.1%
5 9
 
4.6%
7 5
 
2.5%
9 4
 
2.0%
- 4
 
2.0%
Other values (2) 6
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 370
65.3%
ASCII 197
34.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
90
45.7%
1 24
 
12.2%
2 19
 
9.6%
3 13
 
6.6%
4 13
 
6.6%
6 10
 
5.1%
5 9
 
4.6%
7 5
 
2.5%
9 4
 
2.0%
- 4
 
2.0%
Other values (2) 6
 
3.0%
Hangul
ValueCountFrequency (%)
마 31
 
8.4%
포 31
 
8.4%
서 30
 
8.1%
특 30
 
8.1%
별 30
 
8.1%
시 30
 
8.1%
구 30
 
8.1%
울 30
 
8.1%
로 24
 
6.5%
길 21
 
5.7%
Other values (32) 83
22.4%

Correlations

2024-03-13T22:50:35.133346image/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.2950.2481.000
교육시설재난공제회 대상여부1.0001.0000.2951.0000.2351.000
공시차수1.0001.0000.2480.2351.0001.000
주소1.0001.0001.0001.0001.0001.000
2024-03-13T22:50:35.264130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공시차수설립유형교육시설재난공제회 대상여부
공시차수1.0000.0630.375
설립유형0.0631.0000.466
교육시설재난공제회 대상여부0.3750.4661.000
2024-03-13T22:50:35.357162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설립유형교육시설재난공제회 대상여부공시차수
설립유형1.0000.4660.063
교육시설재난공제회 대상여부0.4661.0000.375
공시차수0.0630.3751.000

Missing values

2024-03-13T22:50:31.543448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T22:50:31.768366image/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서울특별시교육청서부교육지원청1ecec08d-0e40-b044-e053-0a32095ab044삼성그린유치원사립(사인)YYY<NA>20232서울특별시 마포구 도화4길 62
1서울특별시교육청서부교육지원청1ecec08d-0c0b-b044-e053-0a32095ab044돌샘유치원사립(사인)YYY<NA>20232서울특별시 마포구 백범로37길 12
2서울특별시교육청서부교육지원청1ecec08d-04dc-b044-e053-0a32095ab044서울하늘초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 마포구 월드컵북로 502-14
3서울특별시교육청서부교육지원청1ecec08d-0b27-b044-e053-0a32095ab044마포대진유치원사립(법인)YYN<NA>20232서울특별시 마포구 성미산로 110
4서울특별시교육청서부교육지원청1ecec08d-0d42-b044-e053-0a32095ab044서울공덕초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 마포구 만리재옛길 13
5서울특별시교육청서부교육지원청1fc6dd86-cccb-d1d2-e053-0a32095ad1d2서울성산초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 마포구 양화로3길 94
6서울특별시교육청서부교육지원청5c17325b-1fe9-427b-8648-bd0e5dc0130b서울동교초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 마포구 월드컵로25길 86
7서울특별시교육청서부교육지원청7752e1a7-0e79-4b17-a19c-846d041414e2서울성서초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 마포구 성미산로7길 24
8서울특별시교육청서부교육지원청7a4a1b05-c84a-43b0-8f02-ebdbe5072f01서울중동초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 마포구 월드컵북로 152
9서울특별시교육청서부교육지원청eb8cde61-5718-4f14-ab59-7df432e254ee서울한서초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 마포구 대흥로24바길 27
교육청명교육지원청명유치원코드유치원명설립유형학교안전공제회 대상여부학교안전공제회 가입여부교육시설재난공제회 대상여부교육시설재난공제회 가입여부공시차수주소
20서울특별시교육청서부교육지원청1ecec08c-f72b-b044-e053-0a32095ab044정님유치원사립(사인)YYN<NA>20232서울특별시 마포구 숭문6길 19
21서울특별시교육청서부교육지원청1ecec08c-f7f6-b044-e053-0a32095ab044나사렛유치원사립(법인)YYN<NA>20232서울특별시 마포구 매봉산로 24-1
22서울특별시교육청서부교육지원청1ecec08c-fb84-b044-e053-0a32095ab044서울용강초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 마포구 백범로17길 9
23서울특별시교육청서부교육지원청1ecec08c-fc56-b044-e053-0a32095ab044월드유치원사립(사인)YYY<NA>20232서울특별시 마포구 월드컵로42길 38
24서울특별시교육청서부교육지원청1ecec08c-fed8-b044-e053-0a32095ab044태영유치원사립(사인)YYY<NA>20232서울특별시 마포구 독막로 266
25서울특별시교육청서부교육지원청1ecec08d-0160-b044-e053-0a32095ab044새현대유치원사립(사인)YYN<NA>20232서울특별시 마포구 새창로 52
26서울특별시교육청서부교육지원청1ecec08c-fd1d-b044-e053-0a32095ab044아이들이야기유치원사립(사인)YYN<NA>20182서울특별시 마포구 토정로31길 57-11
27서울특별시교육청서부교육지원청1ecec08d-04ad-b044-e053-0a32095ab044서울창천초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 마포구 백범로1길 56
28서울특별시교육청서부교육지원청1ecec08d-04b0-b044-e053-0a32095ab044성결유치원사립(사인)YYN<NA>20232서울특별시 마포구 독막로28길 19
29서울특별시교육청서부교육지원청1ecec08d-08d3-b044-e053-0a32095ab044서울유치원사립(사인)YYY<NA>20192서울특별시 마포구 월드컵북로 233-1