Overview

Dataset statistics

Number of variables11
Number of observations43
Missing cells43
Missing cells (%)9.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.9 KiB
Average record size in memory93.1 B

Variable types

Categorical4
Text3
Boolean3
Unsupported1

Dataset

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

Alerts

교육청명 has constant value ""Constant
교육지원청명 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 (54.9%)Imbalance
교육시설재난공제회 가입여부 has 43 (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 17:48:38.578465
Analysis finished2024-03-13 17:48:39.077646
Duration0.5 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

교육청명
Categorical

CONSTANT 

Distinct1
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size476.0 B
서울특별시교육청
43 

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

Length

2024-03-14T02:48:39.128802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T02:48:39.449326image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울특별시교육청 43
100.0%

교육지원청명
Categorical

CONSTANT 

Distinct1
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size476.0 B
강남서초교육지원청
43 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row강남서초교육지원청
2nd row강남서초교육지원청
3rd row강남서초교육지원청
4th row강남서초교육지원청
5th row강남서초교육지원청

Common Values

ValueCountFrequency (%)
강남서초교육지원청 43
100.0%

Length

2024-03-14T02:48:39.528175image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T02:48:39.600539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
강남서초교육지원청 43
100.0%

유치원코드
Text

UNIQUE 

Distinct43
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size476.0 B
2024-03-14T02:48:39.777692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length36
Mean length36
Min length36

Characters and Unicode

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

Unique43 ?
Unique (%)100.0%

Sample

1st row16f86a3d-1aa1-471d-bcd4-a563853f8658
2nd row18f5dfe2-27c7-47f3-af41-5a4a944a77fe
3rd row1ecec08c-ed1e-b044-e053-0a32095ab044
4th row1ecec08c-fea4-b044-e053-0a32095ab044
5th row1ecec08d-0e4d-b044-e053-0a32095ab044
ValueCountFrequency (%)
16f86a3d-1aa1-471d-bcd4-a563853f8658 1
 
2.3%
1ecec08c-fea3-b044-e053-0a32095ab044 1
 
2.3%
1ecec08c-fea6-b044-e053-0a32095ab044 1
 
2.3%
1ecec08d-007b-b044-e053-0a32095ab044 1
 
2.3%
1ecec08d-0184-b044-e053-0a32095ab044 1
 
2.3%
1ecec08d-01d8-b044-e053-0a32095ab044 1
 
2.3%
1ecec08d-04db-b044-e053-0a32095ab044 1
 
2.3%
1ecec08d-0e63-b044-e053-0a32095ab044 1
 
2.3%
1ecec08d-0a98-b044-e053-0a32095ab044 1
 
2.3%
1ecec08d-0b98-b044-e053-0a32095ab044 1
 
2.3%
Other values (33) 33
76.7%
2024-03-14T02:48:40.081859image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 247
16.0%
4 176
11.4%
- 172
11.1%
e 144
9.3%
c 107
 
6.9%
a 96
 
6.2%
3 91
 
5.9%
5 91
 
5.9%
b 87
 
5.6%
1 57
 
3.7%
Other values (7) 280
18.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 857
55.4%
Lowercase Letter 519
33.5%
Dash Punctuation 172
 
11.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 247
28.8%
4 176
20.5%
3 91
 
10.6%
5 91
 
10.6%
1 57
 
6.7%
8 55
 
6.4%
9 52
 
6.1%
2 47
 
5.5%
6 21
 
2.5%
7 20
 
2.3%
Lowercase Letter
ValueCountFrequency (%)
e 144
27.7%
c 107
20.6%
a 96
18.5%
b 87
16.8%
d 44
 
8.5%
f 41
 
7.9%
Dash Punctuation
ValueCountFrequency (%)
- 172
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1029
66.5%
Latin 519
33.5%

Most frequent character per script

Common
ValueCountFrequency (%)
0 247
24.0%
4 176
17.1%
- 172
16.7%
3 91
 
8.8%
5 91
 
8.8%
1 57
 
5.5%
8 55
 
5.3%
9 52
 
5.1%
2 47
 
4.6%
6 21
 
2.0%
Latin
ValueCountFrequency (%)
e 144
27.7%
c 107
20.6%
a 96
18.5%
b 87
16.8%
d 44
 
8.5%
f 41
 
7.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1548
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 247
16.0%
4 176
11.4%
- 172
11.1%
e 144
9.3%
c 107
 
6.9%
a 96
 
6.2%
3 91
 
5.9%
5 91
 
5.9%
b 87
 
5.6%
1 57
 
3.7%
Other values (7) 280
18.1%

유치원명
Text

UNIQUE 

Distinct43
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size476.0 B
2024-03-14T02:48:40.262182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length9
Mean length8.2790698
Min length5

Characters and Unicode

Total characters356
Distinct characters82
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

Unique43 ?
Unique (%)100.0%

Sample

1st row서울신구유치원
2nd row서울세명유치원
3rd row서울개원초등학교병설유치원
4th row럭키유치원
5th row청운교회부설유치원
ValueCountFrequency (%)
서울신구유치원 1
 
2.3%
돌샘유치원 1
 
2.3%
묘동유치원 1
 
2.3%
초원유치원 1
 
2.3%
아란유치원 1
 
2.3%
서울율현초등학교병설유치원 1
 
2.3%
서울논현초등학교병설유치원 1
 
2.3%
성결유치원 1
 
2.3%
오즈의마법사유치원 1
 
2.3%
반디유치원 1
 
2.3%
Other values (33) 33
76.7%
2024-03-14T02:48:40.540540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
원 45
 
12.6%
유 44
 
12.4%
치 43
 
12.1%
서 19
 
5.3%
울 18
 
5.1%
초 15
 
4.2%
학 15
 
4.2%
교 15
 
4.2%
설 15
 
4.2%
등 14
 
3.9%
Other values (72) 113
31.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 356
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
원 45
 
12.6%
유 44
 
12.4%
치 43
 
12.1%
서 19
 
5.3%
울 18
 
5.1%
초 15
 
4.2%
학 15
 
4.2%
교 15
 
4.2%
설 15
 
4.2%
등 14
 
3.9%
Other values (72) 113
31.7%

Most occurring scripts

ValueCountFrequency (%)
Hangul 356
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
원 45
 
12.6%
유 44
 
12.4%
치 43
 
12.1%
서 19
 
5.3%
울 18
 
5.1%
초 15
 
4.2%
학 15
 
4.2%
교 15
 
4.2%
설 15
 
4.2%
등 14
 
3.9%
Other values (72) 113
31.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 356
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
원 45
 
12.6%
유 44
 
12.4%
치 43
 
12.1%
서 19
 
5.3%
울 18
 
5.1%
초 15
 
4.2%
학 15
 
4.2%
교 15
 
4.2%
설 15
 
4.2%
등 14
 
3.9%
Other values (72) 113
31.7%

설립유형
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)9.3%
Missing0
Missing (%)0.0%
Memory size476.0 B
사립(사인)
22 
공립(병설)
14 
공립(단설)
4 
사립(법인)
3 

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
51.2%
공립(병설) 14
32.6%
공립(단설) 4
 
9.3%
사립(법인) 3
 
7.0%

Length

2024-03-14T02:48:40.640751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T02:48:40.723256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사립(사인 22
51.2%
공립(병설 14
32.6%
공립(단설 4
 
9.3%
사립(법인 3
 
7.0%

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

CONSTANT 

Distinct1
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size175.0 B
True
43 
ValueCountFrequency (%)
True 43
100.0%
2024-03-14T02:48:40.811313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

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

CONSTANT 

Distinct1
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size175.0 B
True
43 
ValueCountFrequency (%)
True 43
100.0%
2024-03-14T02:48:40.875580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

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

HIGH CORRELATION 

Distinct2
Distinct (%)4.7%
Missing0
Missing (%)0.0%
Memory size175.0 B
True
29 
False
14 
ValueCountFrequency (%)
True 29
67.4%
False 14
32.6%
2024-03-14T02:48:40.939575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

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

MISSING  REJECTED  UNSUPPORTED 

Missing43
Missing (%)100.0%
Memory size519.0 B

공시차수
Categorical

IMBALANCE 

Distinct5
Distinct (%)11.6%
Missing0
Missing (%)0.0%
Memory size476.0 B
20232
35 
20182
 
3
20192
 
2
20202
 
2
20212
 
1

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique1 ?
Unique (%)2.3%

Sample

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

Common Values

ValueCountFrequency (%)
20232 35
81.4%
20182 3
 
7.0%
20192 2
 
4.7%
20202 2
 
4.7%
20212 1
 
2.3%

Length

2024-03-14T02:48:41.027908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T02:48:41.108635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20232 35
81.4%
20182 3
 
7.0%
20192 2
 
4.7%
20202 2
 
4.7%
20212 1
 
2.3%

주소
Text

UNIQUE 

Distinct43
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size476.0 B
2024-03-14T02:48:41.290994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length21
Mean length18.790698
Min length16

Characters and Unicode

Total characters808
Distinct characters53
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

Unique43 ?
Unique (%)100.0%

Sample

1st row서울특별시 강남구 압구정로18길 28
2nd row서울특별시 강남구 자곡로 55
3rd row서울특별시 강남구 선릉로 29
4th row서울특별시 강남구 논현로 213
5th row서울특별시 강남구 언주로65길 5
ValueCountFrequency (%)
서울특별시 43
25.0%
강남구 43
25.0%
15 4
 
2.3%
5 3
 
1.7%
28 3
 
1.7%
17 3
 
1.7%
21 2
 
1.2%
33 2
 
1.2%
8 2
 
1.2%
일원로 2
 
1.2%
Other values (62) 65
37.8%
2024-03-14T02:48:41.587521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
129
16.0%
1 47
 
5.8%
구 47
 
5.8%
남 46
 
5.7%
강 45
 
5.6%
서 43
 
5.3%
로 43
 
5.3%
울 43
 
5.3%
시 43
 
5.3%
별 43
 
5.3%
Other values (43) 279
34.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 515
63.7%
Decimal Number 163
 
20.2%
Space Separator 129
 
16.0%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 47
9.1%
남 46
8.9%
강 45
8.7%
서 43
8.3%
로 43
8.3%
울 43
8.3%
시 43
8.3%
별 43
8.3%
특 43
8.3%
길 32
 
6.2%
Other values (31) 87
16.9%
Decimal Number
ValueCountFrequency (%)
1 47
28.8%
2 23
14.1%
5 20
12.3%
6 14
 
8.6%
8 12
 
7.4%
3 10
 
6.1%
7 10
 
6.1%
4 10
 
6.1%
0 9
 
5.5%
9 8
 
4.9%
Space Separator
ValueCountFrequency (%)
129
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 515
63.7%
Common 293
36.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 47
9.1%
남 46
8.9%
강 45
8.7%
서 43
8.3%
로 43
8.3%
울 43
8.3%
시 43
8.3%
별 43
8.3%
특 43
8.3%
길 32
 
6.2%
Other values (31) 87
16.9%
Common
ValueCountFrequency (%)
129
44.0%
1 47
 
16.0%
2 23
 
7.8%
5 20
 
6.8%
6 14
 
4.8%
8 12
 
4.1%
3 10
 
3.4%
7 10
 
3.4%
4 10
 
3.4%
0 9
 
3.1%
Other values (2) 9
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 515
63.7%
ASCII 293
36.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
129
44.0%
1 47
 
16.0%
2 23
 
7.8%
5 20
 
6.8%
6 14
 
4.8%
8 12
 
4.1%
3 10
 
3.4%
7 10
 
3.4%
4 10
 
3.4%
0 9
 
3.1%
Other values (2) 9
 
3.1%
Hangul
ValueCountFrequency (%)
구 47
9.1%
남 46
8.9%
강 45
8.7%
서 43
8.3%
로 43
8.3%
울 43
8.3%
시 43
8.3%
별 43
8.3%
특 43
8.3%
길 32
 
6.2%
Other values (31) 87
16.9%

Correlations

2024-03-14T02:48:41.664692image/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.7730.0001.000
교육시설재난공제회 대상여부1.0001.0000.7731.0000.1281.000
공시차수1.0001.0000.0000.1281.0001.000
주소1.0001.0001.0001.0001.0001.000
2024-03-14T02:48:41.743314image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공시차수설립유형교육시설재난공제회 대상여부
공시차수1.0000.0000.144
설립유형0.0001.0000.549
교육시설재난공제회 대상여부0.1440.5491.000
2024-03-14T02:48:41.810568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설립유형교육시설재난공제회 대상여부공시차수
설립유형1.0000.5490.000
교육시설재난공제회 대상여부0.5491.0000.144
공시차수0.0000.1441.000

Missing values

2024-03-14T02:48:38.873824image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T02:48:39.025320image/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서울특별시교육청강남서초교육지원청16f86a3d-1aa1-471d-bcd4-a563853f8658서울신구유치원공립(단설)YYY<NA>20232서울특별시 강남구 압구정로18길 28
1서울특별시교육청강남서초교육지원청18f5dfe2-27c7-47f3-af41-5a4a944a77fe서울세명유치원공립(단설)YYY<NA>20232서울특별시 강남구 자곡로 55
2서울특별시교육청강남서초교육지원청1ecec08c-ed1e-b044-e053-0a32095ab044서울개원초등학교병설유치원공립(병설)YYY<NA>20182서울특별시 강남구 선릉로 29
3서울특별시교육청강남서초교육지원청1ecec08c-fea4-b044-e053-0a32095ab044럭키유치원사립(사인)YYN<NA>20182서울특별시 강남구 논현로 213
4서울특별시교육청강남서초교육지원청1ecec08d-0e4d-b044-e053-0a32095ab044청운교회부설유치원사립(사인)YYN<NA>20182서울특별시 강남구 언주로65길 5
5서울특별시교육청강남서초교육지원청1ecec08c-fd48-b044-e053-0a32095ab044신우주유치원사립(사인)YYY<NA>20192서울특별시 강남구 일원로 120
6서울특별시교육청강남서초교육지원청1ecec08c-fea2-b044-e053-0a32095ab044하늘빛유치원사립(사인)YYN<NA>20192서울특별시 강남구 양재대로55길 12
7서울특별시교육청강남서초교육지원청1ecec08c-ed1d-b044-e053-0a32095ab044서울언주초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 강남구 남부순환로363길 19
8서울특별시교육청강남서초교육지원청1ecec08c-ef04-b044-e053-0a32095ab044도곡렉슬유치원사립(사인)YYN<NA>20232서울특별시 강남구 선릉로 221
9서울특별시교육청강남서초교육지원청1ecec08c-efef-b044-e053-0a32095ab044영동제일유치원사립(사인)YYY<NA>20232서울특별시 강남구 삼성로120길 28
교육청명교육지원청명유치원코드유치원명설립유형학교안전공제회 대상여부학교안전공제회 가입여부교육시설재난공제회 대상여부교육시설재난공제회 가입여부공시차수주소
33서울특별시교육청강남서초교육지원청1ecec08d-0e60-b044-e053-0a32095ab044서울개포유치원공립(단설)YYY<NA>20232서울특별시 강남구 삼성로4길 20
34서울특별시교육청강남서초교육지원청1ecec08d-0e61-b044-e053-0a32095ab044서울대현초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 강남구 역삼로98길 16
35서울특별시교육청강남서초교육지원청1ecec08d-0e64-b044-e053-0a32095ab044성요셉유치원사립(법인)YYY<NA>20232서울특별시 강남구 압구정로77길 28
36서울특별시교육청강남서초교육지원청1ecec08d-0e65-b044-e053-0a32095ab044소망유치원사립(사인)YYN<NA>20232서울특별시 강남구 광평로56길 11
37서울특별시교육청강남서초교육지원청1fd6777e-1508-e0b0-e053-0a32095ae0b0서울은곡유치원공립(단설)YYY<NA>20232서울특별시 강남구 헌릉로569길 41
38서울특별시교육청강남서초교육지원청34140010-58e8-44b4-9e91-49d5eb6669e1강남유정유치원사립(사인)YYN<NA>20232서울특별시 강남구 광평로34길 17
39서울특별시교육청강남서초교육지원청3cedfdf0-2006-43f2-853b-29e001e6637a서울영희초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 강남구 일원로 21
40서울특별시교육청강남서초교육지원청b2d7325d-5742-4adf-ad7a-4fcc9ea8f9dc서울청담초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 강남구 압구정로71길 9
41서울특별시교육청강남서초교육지원청d66d57de-9a60-4eab-8ca9-38b9d53c57e0서울포이초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 강남구 개포로22길 87
42서울특별시교육청강남서초교육지원청fccf9482-0b1c-4f4b-a7e7-cffe7f40b07b서울학동초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 강남구 선릉로115길 42