Overview

Dataset statistics

Number of variables11
Number of observations53
Missing cells53
Missing cells (%)9.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.8 KiB
Average record size in memory92.5 B

Variable types

Categorical4
Text3
Boolean3
Unsupported1

Dataset

Description교육청명,교육지원청명,유치원코드,유치원명,설립유형,학교안전공제회 대상여부,학교안전공제회 가입여부,교육시설재난공제회 대상여부,교육시설재난공제회 가입여부,공시차수,주소
Author성북구
URLhttps://data.seoul.go.kr/dataList/OA-20836/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 (65.3%)Imbalance
교육시설재난공제회 가입여부 has 53 (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 12:47:58.177091
Analysis finished2024-03-13 12:47:59.051842
Duration0.87 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

교육청명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size556.0 B
서울특별시교육청
53 

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

Length

2024-03-13T21:47:59.144370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T21:47:59.282678image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울특별시교육청 53
100.0%

교육지원청명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size556.0 B
성북강북교육지원청
53 

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 (%)
성북강북교육지원청 53
100.0%

Length

2024-03-13T21:47:59.415645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T21:47:59.555252image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
성북강북교육지원청 53
100.0%

유치원코드
Text

UNIQUE 

Distinct53
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size556.0 B
2024-03-13T21:47:59.868625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length36
Mean length36
Min length36

Characters and Unicode

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

Unique53 ?
Unique (%)100.0%

Sample

1st row1ecec08c-f350-b044-e053-0a32095ab044
2nd row1ecec08c-f81f-b044-e053-0a32095ab044
3rd row1ecec08c-fff3-b044-e053-0a32095ab044
4th row1ecec08c-ee4e-b044-e053-0a32095ab044
5th row1ecec08c-ef38-b044-e053-0a32095ab044
ValueCountFrequency (%)
1ecec08c-f350-b044-e053-0a32095ab044 1
 
1.9%
1ecec08d-0251-b044-e053-0a32095ab044 1
 
1.9%
1ecec08d-084c-b044-e053-0a32095ab044 1
 
1.9%
1ecec08d-0269-b044-e053-0a32095ab044 1
 
1.9%
1ecec08d-02aa-b044-e053-0a32095ab044 1
 
1.9%
1ecec08d-0426-b044-e053-0a32095ab044 1
 
1.9%
1ecec08d-0427-b044-e053-0a32095ab044 1
 
1.9%
1ecec08d-0428-b044-e053-0a32095ab044 1
 
1.9%
1ecec08d-0429-b044-e053-0a32095ab044 1
 
1.9%
1ecec08d-062f-b044-e053-0a32095ab044 1
 
1.9%
Other values (43) 43
81.1%
2024-03-13T21:48:00.423318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 337
17.7%
4 221
11.6%
- 212
11.1%
e 180
9.4%
c 137
7.2%
5 113
 
5.9%
3 113
 
5.9%
b 111
 
5.8%
a 110
 
5.8%
9 72
 
3.8%
Other values (7) 302
15.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1082
56.7%
Lowercase Letter 614
32.2%
Dash Punctuation 212
 
11.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 337
31.1%
4 221
20.4%
5 113
 
10.4%
3 113
 
10.4%
9 72
 
6.7%
2 70
 
6.5%
8 66
 
6.1%
1 65
 
6.0%
6 14
 
1.3%
7 11
 
1.0%
Lowercase Letter
ValueCountFrequency (%)
e 180
29.3%
c 137
22.3%
b 111
18.1%
a 110
17.9%
f 39
 
6.4%
d 37
 
6.0%
Dash Punctuation
ValueCountFrequency (%)
- 212
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1294
67.8%
Latin 614
32.2%

Most frequent character per script

Common
ValueCountFrequency (%)
0 337
26.0%
4 221
17.1%
- 212
16.4%
5 113
 
8.7%
3 113
 
8.7%
9 72
 
5.6%
2 70
 
5.4%
8 66
 
5.1%
1 65
 
5.0%
6 14
 
1.1%
Latin
ValueCountFrequency (%)
e 180
29.3%
c 137
22.3%
b 111
18.1%
a 110
17.9%
f 39
 
6.4%
d 37
 
6.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1908
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 337
17.7%
4 221
11.6%
- 212
11.1%
e 180
9.4%
c 137
7.2%
5 113
 
5.9%
3 113
 
5.9%
b 111
 
5.8%
a 110
 
5.8%
9 72
 
3.8%
Other values (7) 302
15.8%

유치원명
Text

UNIQUE 

Distinct53
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size556.0 B
2024-03-13T21:48:00.792318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length7.6037736
Min length5

Characters and Unicode

Total characters403
Distinct characters92
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

Unique53 ?
Unique (%)100.0%

Sample

1st row빛나라유치원
2nd row명덕유치원
3rd row까망유치원
4th row개동유치원
5th row새싹유치원
ValueCountFrequency (%)
빛나라유치원 1
 
1.9%
나래유치원 1
 
1.9%
예린유치원 1
 
1.9%
반디유치원 1
 
1.9%
한가람유치원 1
 
1.9%
서울길음유치원 1
 
1.9%
서울삼선초등학교병설유치원 1
 
1.9%
서울성북초등학교병설유치원 1
 
1.9%
서울숭곡초등학교병설유치원 1
 
1.9%
루이유치원 1
 
1.9%
Other values (43) 43
81.1%
2024-03-13T21:48:01.410294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
원 55
 
13.6%
유 53
 
13.2%
치 53
 
13.2%
울 17
 
4.2%
서 17
 
4.2%
학 14
 
3.5%
교 14
 
3.5%
초 13
 
3.2%
등 13
 
3.2%
병 13
 
3.2%
Other values (82) 141
35.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 403
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
원 55
 
13.6%
유 53
 
13.2%
치 53
 
13.2%
울 17
 
4.2%
서 17
 
4.2%
학 14
 
3.5%
교 14
 
3.5%
초 13
 
3.2%
등 13
 
3.2%
병 13
 
3.2%
Other values (82) 141
35.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 403
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
원 55
 
13.6%
유 53
 
13.2%
치 53
 
13.2%
울 17
 
4.2%
서 17
 
4.2%
학 14
 
3.5%
교 14
 
3.5%
초 13
 
3.2%
등 13
 
3.2%
병 13
 
3.2%
Other values (82) 141
35.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 403
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
원 55
 
13.6%
유 53
 
13.2%
치 53
 
13.2%
울 17
 
4.2%
서 17
 
4.2%
학 14
 
3.5%
교 14
 
3.5%
초 13
 
3.2%
등 13
 
3.2%
병 13
 
3.2%
Other values (82) 141
35.0%

설립유형
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)7.5%
Missing0
Missing (%)0.0%
Memory size556.0 B
사립(사인)
20 
사립(법인)
17 
공립(병설)
13 
공립(단설)
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 (%)
사립(사인) 20
37.7%
사립(법인) 17
32.1%
공립(병설) 13
24.5%
공립(단설) 3
 
5.7%

Length

2024-03-13T21:48:01.578825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T21:48:01.745962image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사립(사인 20
37.7%
사립(법인 17
32.1%
공립(병설 13
24.5%
공립(단설 3
 
5.7%

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

CONSTANT 

Distinct1
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size185.0 B
True
53 
ValueCountFrequency (%)
True 53
100.0%
2024-03-13T21:48:01.940689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

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

CONSTANT 

Distinct1
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size185.0 B
True
53 
ValueCountFrequency (%)
True 53
100.0%
2024-03-13T21:48:02.080854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

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

HIGH CORRELATION 

Distinct2
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size185.0 B
True
30 
False
23 
ValueCountFrequency (%)
True 30
56.6%
False 23
43.4%
2024-03-13T21:48:02.230698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

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

MISSING  REJECTED  UNSUPPORTED 

Missing53
Missing (%)100.0%
Memory size609.0 B

공시차수
Categorical

IMBALANCE 

Distinct5
Distinct (%)9.4%
Missing0
Missing (%)0.0%
Memory size556.0 B
20232
46 
20182
 
3
20192
 
2
20222
 
1
20191
 
1

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique2 ?
Unique (%)3.8%

Sample

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

Common Values

ValueCountFrequency (%)
20232 46
86.8%
20182 3
 
5.7%
20192 2
 
3.8%
20222 1
 
1.9%
20191 1
 
1.9%

Length

2024-03-13T21:48:02.391502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T21:48:02.561095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20232 46
86.8%
20182 3
 
5.7%
20192 2
 
3.8%
20222 1
 
1.9%
20191 1
 
1.9%

주소
Text

Distinct50
Distinct (%)94.3%
Missing0
Missing (%)0.0%
Memory size556.0 B
2024-03-13T21:48:02.923029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length19
Mean length18.207547
Min length16

Characters and Unicode

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

Unique48 ?
Unique (%)90.6%

Sample

1st row서울특별시 성북구 종암로9길 78
2nd row서울특별시 성북구 삼양로 74
3rd row서울특별시 성북구 장월로 102
4th row서울특별시 성북구 보국문로 143
5th row서울특별시 성북구 정릉로 282
ValueCountFrequency (%)
서울특별시 53
25.0%
성북구 53
25.0%
성북로4길 4
 
1.9%
52 4
 
1.9%
16 3
 
1.4%
50 2
 
0.9%
73 2
 
0.9%
북악산로 2
 
0.9%
66 2
 
0.9%
9 2
 
0.9%
Other values (79) 85
40.1%
2024-03-13T21:48:03.568219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
159
16.5%
북 62
 
6.4%
성 60
 
6.2%
서 56
 
5.8%
울 53
 
5.5%
구 53
 
5.5%
시 53
 
5.5%
별 53
 
5.5%
특 53
 
5.5%
로 51
 
5.3%
Other values (48) 312
32.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 634
65.7%
Decimal Number 170
 
17.6%
Space Separator 159
 
16.5%
Dash Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
북 62
9.8%
성 60
9.5%
서 56
8.8%
울 53
8.4%
구 53
8.4%
시 53
8.4%
별 53
8.4%
특 53
8.4%
로 51
8.0%
길 41
6.5%
Other values (36) 99
15.6%
Decimal Number
ValueCountFrequency (%)
1 35
20.6%
2 28
16.5%
4 21
12.4%
3 17
10.0%
6 15
8.8%
5 15
8.8%
7 11
 
6.5%
9 10
 
5.9%
8 9
 
5.3%
0 9
 
5.3%
Space Separator
ValueCountFrequency (%)
159
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 634
65.7%
Common 331
34.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
북 62
9.8%
성 60
9.5%
서 56
8.8%
울 53
8.4%
구 53
8.4%
시 53
8.4%
별 53
8.4%
특 53
8.4%
로 51
8.0%
길 41
6.5%
Other values (36) 99
15.6%
Common
ValueCountFrequency (%)
159
48.0%
1 35
 
10.6%
2 28
 
8.5%
4 21
 
6.3%
3 17
 
5.1%
6 15
 
4.5%
5 15
 
4.5%
7 11
 
3.3%
9 10
 
3.0%
8 9
 
2.7%
Other values (2) 11
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 634
65.7%
ASCII 331
34.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
159
48.0%
1 35
 
10.6%
2 28
 
8.5%
4 21
 
6.3%
3 17
 
5.1%
6 15
 
4.5%
5 15
 
4.5%
7 11
 
3.3%
9 10
 
3.0%
8 9
 
2.7%
Other values (2) 11
 
3.3%
Hangul
ValueCountFrequency (%)
북 62
9.8%
성 60
9.5%
서 56
8.8%
울 53
8.4%
구 53
8.4%
시 53
8.4%
별 53
8.4%
특 53
8.4%
로 51
8.0%
길 41
6.5%
Other values (36) 99
15.6%

Correlations

2024-03-13T21:48:03.703717image/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.7990.0000.658
교육시설재난공제회 대상여부1.0001.0000.7991.0000.2130.000
공시차수1.0001.0000.0000.2131.0000.000
주소1.0001.0000.6580.0000.0001.000
2024-03-13T21:48:03.867156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공시차수설립유형교육시설재난공제회 대상여부
공시차수1.0000.0000.250
설립유형0.0001.0000.579
교육시설재난공제회 대상여부0.2500.5791.000
2024-03-13T21:48:04.022439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설립유형교육시설재난공제회 대상여부공시차수
설립유형1.0000.5790.000
교육시설재난공제회 대상여부0.5791.0000.250
공시차수0.0000.2501.000

Missing values

2024-03-13T21:47:58.682579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T21:47:58.964804image/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-f350-b044-e053-0a32095ab044빛나라유치원사립(사인)YYN<NA>20182서울특별시 성북구 종암로9길 78
1서울특별시교육청성북강북교육지원청1ecec08c-f81f-b044-e053-0a32095ab044명덕유치원사립(사인)YYN<NA>20182서울특별시 성북구 삼양로 74
2서울특별시교육청성북강북교육지원청1ecec08c-fff3-b044-e053-0a32095ab044까망유치원사립(사인)YYN<NA>20182서울특별시 성북구 장월로 102
3서울특별시교육청성북강북교육지원청1ecec08c-ee4e-b044-e053-0a32095ab044개동유치원사립(법인)YYY<NA>20232서울특별시 성북구 보국문로 143
4서울특별시교육청성북강북교육지원청1ecec08c-ef38-b044-e053-0a32095ab044새싹유치원사립(법인)YYN<NA>20232서울특별시 성북구 정릉로 282
5서울특별시교육청성북강북교육지원청1ecec08c-efed-b044-e053-0a32095ab044영암유치원사립(법인)YYN<NA>20232서울특별시 성북구 안암로7길 66
6서울특별시교육청성북강북교육지원청1ecec08c-efee-b044-e053-0a32095ab044성신유치원사립(법인)YYY<NA>20232서울특별시 성북구 보문로34다길 2
7서울특별시교육청성북강북교육지원청1ecec08c-f051-b044-e053-0a32095ab044서울장곡초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 성북구 장월로23길 16
8서울특별시교육청성북강북교육지원청1ecec08c-f372-b044-e053-0a32095ab044선한유치원사립(법인)YYY<NA>20232서울특별시 성북구 길음로9길 73
9서울특별시교육청성북강북교육지원청1ecec08c-f425-b044-e053-0a32095ab044사랑유치원사립(사인)YYN<NA>20232서울특별시 성북구 월곡로7길 72
교육청명교육지원청명유치원코드유치원명설립유형학교안전공제회 대상여부학교안전공제회 가입여부교육시설재난공제회 대상여부교육시설재난공제회 가입여부공시차수주소
43서울특별시교육청성북강북교육지원청7ec89e9b-5287-4ece-b0d3-24499defde1b서울장위초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 성북구 장월로8가길 41
44서울특별시교육청성북강북교육지원청1ecec08c-ee4f-b044-e053-0a32095ab044영광유치원사립(사인)YYN<NA>20232서울특별시 성북구 북악산로 913
45서울특별시교육청성북강북교육지원청1ecec08d-080a-b044-e053-0a32095ab044서울길원초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 성북구 길음로15길 55
46서울특별시교육청성북강북교육지원청1ecec08d-0841-b044-e053-0a32095ab044서울정덕초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 성북구 아리랑로 63
47서울특별시교육청성북강북교육지원청1ecec08d-084d-b044-e053-0a32095ab044영천유치원사립(법인)YYY<NA>20232서울특별시 성북구 장위로 34
48서울특별시교육청성북강북교육지원청1ecec08d-0ae6-b044-e053-0a32095ab044좋은나라유치원사립(사인)YYN<NA>20232서울특별시 성북구 종암로24가길 53
49서울특별시교육청성북강북교육지원청1ecec08d-0af8-b044-e053-0a32095ab044세아유치원사립(사인)YYN<NA>20232서울특별시 성북구 성북로4길 52
50서울특별시교육청성북강북교육지원청1ecec08d-0b26-b044-e053-0a32095ab044서울석관초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 성북구 돌곶이로22길 21
51서울특별시교육청성북강북교육지원청1ecec08d-0d94-b044-e053-0a32095ab044동덕여자대학교부속유치원사립(법인)YYY<NA>20232서울특별시 성북구 장월로1가길 9
52서울특별시교육청성북강북교육지원청1ecec08c-f561-b044-e053-0a32095ab044아랑유치원사립(사인)YYN<NA>20232서울특별시 성북구 북악산로 844