Overview

Dataset statistics

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

Variable types

Categorical3
Text3
Boolean3
Unsupported1
Numeric1

Dataset

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

Alerts

교육청명 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 (85.9%)Imbalance
교육시설재난공제회 가입여부 has 50 (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 17:43:35.396039
Analysis finished2024-03-13 17:43:35.980256
Duration0.58 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

교육청명
Categorical

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
서울특별시교육청
50 

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

Length

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

Common Values (Plot)

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

교육지원청명
Categorical

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
서부교육지원청
50 

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

Length

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

Common Values (Plot)

2024-03-14T02:43:36.241810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서부교육지원청 50
100.0%

유치원코드
Text

UNIQUE 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2024-03-14T02:43:36.388485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length36
Mean length36
Min length36

Characters and Unicode

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

Unique50 ?
Unique (%)100.0%

Sample

1st row1ecec08c-ed89-b044-e053-0a32095ab044
2nd row1ecec08c-f60c-b044-e053-0a32095ab044
3rd row1ecec08c-f496-b044-e053-0a32095ab044
4th row1ecec08c-fdb9-b044-e053-0a32095ab044
5th row1ecec08d-015f-b044-e053-0a32095ab044
ValueCountFrequency (%)
1ecec08c-ed89-b044-e053-0a32095ab044 1
 
2.0%
1ecec08d-059b-b044-e053-0a32095ab044 1
 
2.0%
e120b286-7861-486d-9b3f-f3c7b49f3c1c 1
 
2.0%
1ecec08c-faa5-b044-e053-0a32095ab044 1
 
2.0%
1ecec08c-fadd-b044-e053-0a32095ab044 1
 
2.0%
1ecec08c-fe45-b044-e053-0a32095ab044 1
 
2.0%
1ecec08d-015d-b044-e053-0a32095ab044 1
 
2.0%
1ecec08d-029e-b044-e053-0a32095ab044 1
 
2.0%
1ecec08d-02b1-b044-e053-0a32095ab044 1
 
2.0%
1ecec08d-04ab-b044-e053-0a32095ab044 1
 
2.0%
Other values (40) 40
80.0%
2024-03-14T02:43:36.661547image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 285
15.8%
4 202
11.2%
- 200
11.1%
e 157
8.7%
c 132
7.3%
a 115
 
6.4%
b 109
 
6.1%
5 106
 
5.9%
3 105
 
5.8%
1 78
 
4.3%
Other values (7) 311
17.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1019
56.6%
Lowercase Letter 581
32.3%
Dash Punctuation 200
 
11.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 285
28.0%
4 202
19.8%
5 106
 
10.4%
3 105
 
10.3%
1 78
 
7.7%
9 70
 
6.9%
8 62
 
6.1%
2 62
 
6.1%
7 26
 
2.6%
6 23
 
2.3%
Lowercase Letter
ValueCountFrequency (%)
e 157
27.0%
c 132
22.7%
a 115
19.8%
b 109
18.8%
f 36
 
6.2%
d 32
 
5.5%
Dash Punctuation
ValueCountFrequency (%)
- 200
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1219
67.7%
Latin 581
32.3%

Most frequent character per script

Common
ValueCountFrequency (%)
0 285
23.4%
4 202
16.6%
- 200
16.4%
5 106
 
8.7%
3 105
 
8.6%
1 78
 
6.4%
9 70
 
5.7%
8 62
 
5.1%
2 62
 
5.1%
7 26
 
2.1%
Latin
ValueCountFrequency (%)
e 157
27.0%
c 132
22.7%
a 115
19.8%
b 109
18.8%
f 36
 
6.2%
d 32
 
5.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1800
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 285
15.8%
4 202
11.2%
- 200
11.1%
e 157
8.7%
c 132
7.3%
a 115
 
6.4%
b 109
 
6.1%
5 106
 
5.9%
3 105
 
5.8%
1 78
 
4.3%
Other values (7) 311
17.3%

유치원명
Text

UNIQUE 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2024-03-14T02:43:36.856443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length8
Mean length7.66
Min length4

Characters and Unicode

Total characters383
Distinct characters83
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

Unique50 ?
Unique (%)100.0%

Sample

1st row궁전유치원
2nd row피노키오유치원
3rd row하늘유치원
4th row하나유치원
5th row보림유치원
ValueCountFrequency (%)
궁전유치원 1
 
2.0%
자연유치원 1
 
2.0%
서울어울초등학교병설유치원 1
 
2.0%
충암유치원 1
 
2.0%
녹번유치원 1
 
2.0%
서울은명초등학교병설유치원 1
 
2.0%
백합유치원 1
 
2.0%
서울수색초등학교병설유치원 1
 
2.0%
서울연신초등학교병설유치원 1
 
2.0%
서문유치원 1
 
2.0%
Other values (40) 40
80.0%
2024-03-14T02:43:37.127939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
51
13.3%
50
 
13.1%
50
 
13.1%
20
 
5.2%
20
 
5.2%
13
 
3.4%
13
 
3.4%
13
 
3.4%
13
 
3.4%
13
 
3.4%
Other values (73) 127
33.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 383
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
51
13.3%
50
 
13.1%
50
 
13.1%
20
 
5.2%
20
 
5.2%
13
 
3.4%
13
 
3.4%
13
 
3.4%
13
 
3.4%
13
 
3.4%
Other values (73) 127
33.2%

Most occurring scripts

ValueCountFrequency (%)
Hangul 383
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
51
13.3%
50
 
13.1%
50
 
13.1%
20
 
5.2%
20
 
5.2%
13
 
3.4%
13
 
3.4%
13
 
3.4%
13
 
3.4%
13
 
3.4%
Other values (73) 127
33.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 383
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
51
13.3%
50
 
13.1%
50
 
13.1%
20
 
5.2%
20
 
5.2%
13
 
3.4%
13
 
3.4%
13
 
3.4%
13
 
3.4%
13
 
3.4%
Other values (73) 127
33.2%

설립유형
Categorical

Distinct4
Distinct (%)8.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
사립(사인)
24 
공립(병설)
13 
사립(법인)
공립(단설)

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 (%)
사립(사인) 24
48.0%
공립(병설) 13
26.0%
사립(법인) 8
 
16.0%
공립(단설) 5
 
10.0%

Length

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

Common Values (Plot)

2024-03-14T02:43:37.299792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사립(사인 24
48.0%
공립(병설 13
26.0%
사립(법인 8
 
16.0%
공립(단설 5
 
10.0%
Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size182.0 B
True
50 
ValueCountFrequency (%)
True 50
100.0%
2024-03-14T02:43:37.379394image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

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

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size182.0 B
True
49 
False
 
1
ValueCountFrequency (%)
True 49
98.0%
False 1
 
2.0%
2024-03-14T02:43:37.447274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Distinct2
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size182.0 B
True
34 
False
16 
ValueCountFrequency (%)
True 34
68.0%
False 16
32.0%
2024-03-14T02:43:37.516754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

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

MISSING  REJECTED  UNSUPPORTED 

Missing50
Missing (%)100.0%
Memory size582.0 B

공시차수
Real number (ℝ)

HIGH CORRELATION 

Distinct6
Distinct (%)12.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20223.8
Minimum20182
Maximum20232
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size582.0 B
2024-03-14T02:43:37.581158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20182
5-th percentile20192
Q120224.5
median20232
Q320232
95-th percentile20232
Maximum20232
Range50
Interquartile range (IQR)7.5

Descriptive statistics

Standard deviation15.608736
Coefficient of variation (CV)0.00077180038
Kurtosis1.342488
Mean20223.8
Median Absolute Deviation (MAD)0
Skewness-1.686889
Sum1011190
Variance243.63265
MonotonicityNot monotonic
2024-03-14T02:43:37.660473image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
20232 37
74.0%
20192 5
 
10.0%
20212 3
 
6.0%
20182 2
 
4.0%
20222 2
 
4.0%
20202 1
 
2.0%
ValueCountFrequency (%)
20182 2
 
4.0%
20192 5
 
10.0%
20202 1
 
2.0%
20212 3
 
6.0%
20222 2
 
4.0%
20232 37
74.0%
ValueCountFrequency (%)
20232 37
74.0%
20222 2
 
4.0%
20212 3
 
6.0%
20202 1
 
2.0%
20192 5
 
10.0%
20182 2
 
4.0%

주소
Text

Distinct47
Distinct (%)94.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2024-03-14T02:43:37.876236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length20
Mean length18.74
Min length16

Characters and Unicode

Total characters937
Distinct characters45
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

Unique44 ?
Unique (%)88.0%

Sample

1st row서울특별시 은평구 갈현로33길 24
2nd row서울특별시 은평구 증산로15길 35-8
3rd row서울특별시 은평구 진관1로 77-15
4th row서울특별시 은평구 진관4로 93
5th row서울특별시 은평구 연서로17길 35-1
ValueCountFrequency (%)
서울특별시 50
25.0%
은평구 50
25.0%
진관1로 3
 
1.5%
진관4로 3
 
1.5%
통일로 3
 
1.5%
갈현로 3
 
1.5%
21 2
 
1.0%
51 2
 
1.0%
불광로 2
 
1.0%
은평로16길 2
 
1.0%
Other values (69) 80
40.0%
2024-03-14T02:43:38.183329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
150
16.0%
58
 
6.2%
57
 
6.1%
57
 
6.1%
50
 
5.3%
50
 
5.3%
50
 
5.3%
50
 
5.3%
50
 
5.3%
49
 
5.2%
Other values (35) 316
33.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 586
62.5%
Decimal Number 185
 
19.7%
Space Separator 150
 
16.0%
Dash Punctuation 16
 
1.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
58
9.9%
57
9.7%
57
9.7%
50
8.5%
50
8.5%
50
8.5%
50
8.5%
50
8.5%
49
8.4%
28
 
4.8%
Other values (23) 87
14.8%
Decimal Number
ValueCountFrequency (%)
1 46
24.9%
2 29
15.7%
3 25
13.5%
7 22
11.9%
5 19
10.3%
4 13
 
7.0%
0 10
 
5.4%
9 9
 
4.9%
6 9
 
4.9%
8 3
 
1.6%
Space Separator
ValueCountFrequency (%)
150
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 16
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 586
62.5%
Common 351
37.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
58
9.9%
57
9.7%
57
9.7%
50
8.5%
50
8.5%
50
8.5%
50
8.5%
50
8.5%
49
8.4%
28
 
4.8%
Other values (23) 87
14.8%
Common
ValueCountFrequency (%)
150
42.7%
1 46
 
13.1%
2 29
 
8.3%
3 25
 
7.1%
7 22
 
6.3%
5 19
 
5.4%
- 16
 
4.6%
4 13
 
3.7%
0 10
 
2.8%
9 9
 
2.6%
Other values (2) 12
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 586
62.5%
ASCII 351
37.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
150
42.7%
1 46
 
13.1%
2 29
 
8.3%
3 25
 
7.1%
7 22
 
6.3%
5 19
 
5.4%
- 16
 
4.6%
4 13
 
3.7%
0 10
 
2.8%
9 9
 
2.6%
Other values (2) 12
 
3.4%
Hangul
ValueCountFrequency (%)
58
9.9%
57
9.7%
57
9.7%
50
8.5%
50
8.5%
50
8.5%
50
8.5%
50
8.5%
49
8.4%
28
 
4.8%
Other values (23) 87
14.8%

Interactions

2024-03-14T02:43:35.711652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T02:43:38.263937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
유치원코드유치원명설립유형학교안전공제회 가입여부교육시설재난공제회 대상여부공시차수주소
유치원코드1.0001.0001.0001.0001.0001.0001.000
유치원명1.0001.0001.0001.0001.0001.0001.000
설립유형1.0001.0001.0000.3350.5540.1190.000
학교안전공제회 가입여부1.0001.0000.3351.0000.0000.5501.000
교육시설재난공제회 대상여부1.0001.0000.5540.0001.0000.2050.000
공시차수1.0001.0000.1190.5500.2051.0000.000
주소1.0001.0000.0001.0000.0000.0001.000
2024-03-14T02:43:38.349017image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설립유형교육시설재난공제회 대상여부학교안전공제회 가입여부
설립유형1.0000.3700.217
교육시설재난공제회 대상여부0.3701.0000.000
학교안전공제회 가입여부0.2170.0001.000
2024-03-14T02:43:38.415312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공시차수설립유형학교안전공제회 가입여부교육시설재난공제회 대상여부
공시차수1.0000.0470.6290.238
설립유형0.0471.0000.2170.370
학교안전공제회 가입여부0.6290.2171.0000.000
교육시설재난공제회 대상여부0.2380.3700.0001.000

Missing values

2024-03-14T02:43:35.812096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T02:43:35.933441image/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-ed89-b044-e053-0a32095ab044궁전유치원사립(사인)YYY<NA>20182서울특별시 은평구 갈현로33길 24
1서울특별시교육청서부교육지원청1ecec08c-f60c-b044-e053-0a32095ab044피노키오유치원사립(사인)YYY<NA>20182서울특별시 은평구 증산로15길 35-8
2서울특별시교육청서부교육지원청1ecec08c-f496-b044-e053-0a32095ab044하늘유치원사립(사인)YYN<NA>20192서울특별시 은평구 진관1로 77-15
3서울특별시교육청서부교육지원청1ecec08c-fdb9-b044-e053-0a32095ab044하나유치원사립(사인)YYY<NA>20192서울특별시 은평구 진관4로 93
4서울특별시교육청서부교육지원청1ecec08d-015f-b044-e053-0a32095ab044보림유치원사립(사인)YYN<NA>20192서울특별시 은평구 연서로17길 35-1
5서울특별시교육청서부교육지원청1ecec08d-041e-b044-e053-0a32095ab044엔젤유치원사립(사인)YYY<NA>20192서울특별시 은평구 진흥로7길 25
6서울특별시교육청서부교육지원청1ecec08d-0838-b044-e053-0a32095ab044자인유치원사립(사인)YYN<NA>20192서울특별시 은평구 갈현로 169-7
7서울특별시교육청서부교육지원청1ecec08c-fea8-b044-e053-0a32095ab044은혜유치원사립(법인)YNY<NA>20222서울특별시 은평구 통일로78가길 20
8서울특별시교육청서부교육지원청1ecec08c-fed9-b044-e053-0a32095ab044효림유치원사립(사인)YYY<NA>20232서울특별시 은평구 은평터널로 65
9서울특별시교육청서부교육지원청1ecec08c-ffa8-b044-e053-0a32095ab044은평국제유치원사립(사인)YYY<NA>20232서울특별시 은평구 은평로3가길 32
교육청명교육지원청명유치원코드유치원명설립유형학교안전공제회 대상여부학교안전공제회 가입여부교육시설재난공제회 대상여부교육시설재난공제회 가입여부공시차수주소
40서울특별시교육청서부교육지원청1ecec08d-09db-b044-e053-0a32095ab044바다의별유치원사립(법인)YYN<NA>20232서울특별시 은평구 통일로 790-1
41서울특별시교육청서부교육지원청1ecec08d-0ba5-b044-e053-0a32095ab044숲유치원사립(사인)YYN<NA>20232서울특별시 은평구 진관2로 37
42서울특별시교육청서부교육지원청1ecec08d-0e41-b044-e053-0a32095ab044새보람유치원사립(사인)YYY<NA>20232서울특별시 은평구 불광로 107
43서울특별시교육청서부교육지원청799c1c12-8e72-44b1-80ba-84c6907a6037서울불광초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 은평구 불광로 51
44서울특별시교육청서부교육지원청7a2cc871-7f4c-4c45-b4a9-5610093f33fa서울응암초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 은평구 가좌로6길 20
45서울특별시교육청서부교육지원청a4246c73-08e0-4da3-8211-ad2976de52ea은평하랑유치원사립(사인)YYN<NA>20232서울특별시 은평구 은평로16길 9-1
46서울특별시교육청서부교육지원청abfb8257-6e64-417e-9fb4-1e145a31f5fe서울산울림유치원공립(단설)YYY<NA>20232서울특별시 은평구 진관4로 93
47서울특별시교육청서부교육지원청ccb06417-04c0-411a-b29e-6ff1a22fabab서울북한산유치원공립(단설)YYY<NA>20232서울특별시 은평구 진관1로 77-15
48서울특별시교육청서부교육지원청e120b286-7861-486d-9b3f-f3c7b49f3c1c서울어울초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 은평구 통일로 650
49서울특별시교육청서부교육지원청1ecec08c-f559-b044-e053-0a32095ab044서울구현초등학교병설유치원공립(병설)YYY<NA>20232서울특별시 은평구 갈현로15길 51