Overview

Dataset statistics

Number of variables11
Number of observations25
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.4 KiB
Average record size in memory96.3 B

Variable types

Text3
Categorical6
Numeric2

Dataset

Description교육행정구역 현황(제공표준)
Author경기도
URLhttps://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=QEX7CAQ59C7WIWTL83HH24586687&infSeq=1

Alerts

교육행정분류명 has constant value ""Constant
시도교육청코드 has constant value ""Constant
시도교육청명 has constant value ""Constant
생성일자 has constant value ""Constant
데이터기준일자 has constant value ""Constant
교육행정구역ID has unique valuesUnique
교육행정구역명 has unique valuesUnique
교육지원청코드 has unique valuesUnique
교육지원청명 has unique valuesUnique
공간객체ID has unique valuesUnique

Reproduction

Analysis started2023-12-10 22:16:01.034701
Analysis finished2023-12-10 22:16:01.842884
Duration0.81 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct25
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2023-12-11T07:16:01.962917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

Total characters250
Distinct characters11
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique25 ?
Unique (%)100.0%

Sample

1st rowS000000040
2nd rowS000000041
3rd rowS000000042
4th rowS000000043
5th rowS000000044
ValueCountFrequency (%)
s000000040 1
 
4.0%
s000000053 1
 
4.0%
s000000063 1
 
4.0%
s000000062 1
 
4.0%
s000000061 1
 
4.0%
s000000060 1
 
4.0%
s000000059 1
 
4.0%
s000000058 1
 
4.0%
s000000057 1
 
4.0%
s000000056 1
 
4.0%
Other values (15) 15
60.0%
2023-12-11T07:16:02.230808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 178
71.2%
S 25
 
10.0%
4 13
 
5.2%
5 12
 
4.8%
6 7
 
2.8%
1 3
 
1.2%
2 3
 
1.2%
3 3
 
1.2%
7 2
 
0.8%
8 2
 
0.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 225
90.0%
Uppercase Letter 25
 
10.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 178
79.1%
4 13
 
5.8%
5 12
 
5.3%
6 7
 
3.1%
1 3
 
1.3%
2 3
 
1.3%
3 3
 
1.3%
7 2
 
0.9%
8 2
 
0.9%
9 2
 
0.9%
Uppercase Letter
ValueCountFrequency (%)
S 25
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 225
90.0%
Latin 25
 
10.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 178
79.1%
4 13
 
5.8%
5 12
 
5.3%
6 7
 
3.1%
1 3
 
1.3%
2 3
 
1.3%
3 3
 
1.3%
7 2
 
0.9%
8 2
 
0.9%
9 2
 
0.9%
Latin
ValueCountFrequency (%)
S 25
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 250
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 178
71.2%
S 25
 
10.0%
4 13
 
5.2%
5 12
 
4.8%
6 7
 
2.8%
1 3
 
1.2%
2 3
 
1.2%
3 3
 
1.2%
7 2
 
0.8%
8 2
 
0.8%
Distinct25
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2023-12-11T07:16:02.412462image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length5
Median length2
Mean length2.6
Min length2

Characters and Unicode

Total characters65
Distinct characters38
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

Unique25 ?
Unique (%)100.0%

Sample

1st row수원
2nd row성남
3rd row의정부
4th row안양과천
5th row부천
ValueCountFrequency (%)
수원 1
 
4.0%
화성오산 1
 
4.0%
김포 1
 
4.0%
안성 1
 
4.0%
용인 1
 
4.0%
이천 1
 
4.0%
양평 1
 
4.0%
가평 1
 
4.0%
포천 1
 
4.0%
연천 1
 
4.0%
Other values (15) 15
60.0%
2023-12-11T07:16:02.713315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6
 
9.2%
5
 
7.7%
5
 
7.7%
3
 
4.6%
3
 
4.6%
3
 
4.6%
3
 
4.6%
3
 
4.6%
2
 
3.1%
2
 
3.1%
Other values (28) 30
46.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 65
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
6
 
9.2%
5
 
7.7%
5
 
7.7%
3
 
4.6%
3
 
4.6%
3
 
4.6%
3
 
4.6%
3
 
4.6%
2
 
3.1%
2
 
3.1%
Other values (28) 30
46.2%

Most occurring scripts

ValueCountFrequency (%)
Hangul 65
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
6
 
9.2%
5
 
7.7%
5
 
7.7%
3
 
4.6%
3
 
4.6%
3
 
4.6%
3
 
4.6%
3
 
4.6%
2
 
3.1%
2
 
3.1%
Other values (28) 30
46.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 65
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
6
 
9.2%
5
 
7.7%
5
 
7.7%
3
 
4.6%
3
 
4.6%
3
 
4.6%
3
 
4.6%
3
 
4.6%
2
 
3.1%
2
 
3.1%
Other values (28) 30
46.2%

교육행정분류명
Categorical

CONSTANT 

Distinct1
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
교육지원청
25 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row교육지원청
2nd row교육지원청
3rd row교육지원청
4th row교육지원청
5th row교육지원청

Common Values

ValueCountFrequency (%)
교육지원청 25
100.0%

Length

2023-12-11T07:16:03.067761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:16:03.150812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
교육지원청 25
100.0%

시도교육청코드
Categorical

CONSTANT 

Distinct1
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
7530000
25 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
7530000 25
100.0%

Length

2023-12-11T07:16:03.237485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:16:03.311524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
7530000 25
100.0%

시도교육청명
Categorical

CONSTANT 

Distinct1
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
경기도교육청
25 

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 (%)
경기도교육청 25
100.0%

Length

2023-12-11T07:16:03.388834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:16:03.466214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도교육청 25
100.0%

교육지원청코드
Real number (ℝ)

UNIQUE 

Distinct25
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7661400
Minimum7541000
Maximum7781000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size357.0 B
2023-12-11T07:16:03.561377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum7541000
5-th percentile7553000
Q17602000
median7661000
Q37721000
95-th percentile7769000
Maximum7781000
Range240000
Interquartile range (IQR)119000

Descriptive statistics

Standard deviation73730.365
Coefficient of variation (CV)0.0096236151
Kurtosis-1.2058368
Mean7661400
Median Absolute Deviation (MAD)60000
Skewness-0.021084449
Sum1.91535 × 108
Variance5.4361667 × 109
MonotonicityStrictly increasing
2023-12-11T07:16:03.661599image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)
ValueCountFrequency (%)
7541000 1
 
4.0%
7551000 1
 
4.0%
7781000 1
 
4.0%
7771000 1
 
4.0%
7761000 1
 
4.0%
7751000 1
 
4.0%
7741000 1
 
4.0%
7731000 1
 
4.0%
7721000 1
 
4.0%
7711000 1
 
4.0%
Other values (15) 15
60.0%
ValueCountFrequency (%)
7541000 1
4.0%
7551000 1
4.0%
7561000 1
4.0%
7569000 1
4.0%
7581000 1
4.0%
7591000 1
4.0%
7602000 1
4.0%
7611000 1
4.0%
7621000 1
4.0%
7631000 1
4.0%
ValueCountFrequency (%)
7781000 1
4.0%
7771000 1
4.0%
7761000 1
4.0%
7751000 1
4.0%
7741000 1
4.0%
7731000 1
4.0%
7721000 1
4.0%
7711000 1
4.0%
7701000 1
4.0%
7692000 1
4.0%

교육지원청명
Text

UNIQUE 

Distinct25
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2023-12-11T07:16:03.836955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length7
Mean length7.6
Min length7

Characters and Unicode

Total characters190
Distinct characters42
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

Unique25 ?
Unique (%)100.0%

Sample

1st row수원교육지원청
2nd row성남교육지원청
3rd row의정부교육지원청
4th row안양과천교육지원청
5th row부천교육지원청
ValueCountFrequency (%)
수원교육지원청 1
 
4.0%
화성오산교육지원청 1
 
4.0%
김포교육지원청 1
 
4.0%
안성교육지원청 1
 
4.0%
용인교육지원청 1
 
4.0%
이천교육지원청 1
 
4.0%
양평교육지원청 1
 
4.0%
가평교육지원청 1
 
4.0%
포천교육지원청 1
 
4.0%
연천교육지원청 1
 
4.0%
Other values (15) 15
60.0%
2023-12-11T07:16:04.156589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
26
13.7%
25
13.2%
25
13.2%
25
13.2%
25
13.2%
6
 
3.2%
5
 
2.6%
5
 
2.6%
3
 
1.6%
3
 
1.6%
Other values (32) 42
22.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 190
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
26
13.7%
25
13.2%
25
13.2%
25
13.2%
25
13.2%
6
 
3.2%
5
 
2.6%
5
 
2.6%
3
 
1.6%
3
 
1.6%
Other values (32) 42
22.1%

Most occurring scripts

ValueCountFrequency (%)
Hangul 190
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
26
13.7%
25
13.2%
25
13.2%
25
13.2%
25
13.2%
6
 
3.2%
5
 
2.6%
5
 
2.6%
3
 
1.6%
3
 
1.6%
Other values (32) 42
22.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 190
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
26
13.7%
25
13.2%
25
13.2%
25
13.2%
25
13.2%
6
 
3.2%
5
 
2.6%
5
 
2.6%
3
 
1.6%
3
 
1.6%
Other values (32) 42
22.1%

생성일자
Categorical

CONSTANT 

Distinct1
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2013-04-30
25 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2013-04-30
2nd row2013-04-30
3rd row2013-04-30
4th row2013-04-30
5th row2013-04-30

Common Values

ValueCountFrequency (%)
2013-04-30 25
100.0%

Length

2023-12-11T07:16:04.273315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:16:04.367112image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2013-04-30 25
100.0%

변경일자
Categorical

Distinct4
Distinct (%)16.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2013-04-30
17 
2018-09-06
2018-09-05
2015-02-16
 
1

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique1 ?
Unique (%)4.0%

Sample

1st row2018-09-05
2nd row2018-09-06
3rd row2013-04-30
4th row2018-09-06
5th row2015-02-16

Common Values

ValueCountFrequency (%)
2013-04-30 17
68.0%
2018-09-06 4
 
16.0%
2018-09-05 3
 
12.0%
2015-02-16 1
 
4.0%

Length

2023-12-11T07:16:04.467666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:16:04.566371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2013-04-30 17
68.0%
2018-09-06 4
 
16.0%
2018-09-05 3
 
12.0%
2015-02-16 1
 
4.0%

공간객체ID
Real number (ℝ)

UNIQUE 

Distinct25
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean62.76
Minimum27
Maximum177
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size357.0 B
2023-12-11T07:16:04.679077image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum27
5-th percentile28.2
Q133
median39
Q345
95-th percentile174.2
Maximum177
Range150
Interquartile range (IQR)12

Descriptive statistics

Standard deviation54.005617
Coefficient of variation (CV)0.86051015
Kurtosis0.643684
Mean62.76
Median Absolute Deviation (MAD)6
Skewness1.5803752
Sum1569
Variance2916.6067
MonotonicityNot monotonic
2023-12-11T07:16:04.784315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)
ValueCountFrequency (%)
27 1
 
4.0%
28 1
 
4.0%
36 1
 
4.0%
41 1
 
4.0%
40 1
 
4.0%
153 1
 
4.0%
39 1
 
4.0%
46 1
 
4.0%
45 1
 
4.0%
42 1
 
4.0%
Other values (15) 15
60.0%
ValueCountFrequency (%)
27 1
4.0%
28 1
4.0%
29 1
4.0%
30 1
4.0%
31 1
4.0%
32 1
4.0%
33 1
4.0%
34 1
4.0%
35 1
4.0%
36 1
4.0%
ValueCountFrequency (%)
177 1
4.0%
176 1
4.0%
167 1
4.0%
166 1
4.0%
153 1
4.0%
46 1
4.0%
45 1
4.0%
44 1
4.0%
43 1
4.0%
42 1
4.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2019-09-16
25 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2019-09-16
2nd row2019-09-16
3rd row2019-09-16
4th row2019-09-16
5th row2019-09-16

Common Values

ValueCountFrequency (%)
2019-09-16 25
100.0%

Length

2023-12-11T07:16:04.904071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:16:04.985332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2019-09-16 25
100.0%

Interactions

2023-12-11T07:16:01.441798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:16:01.286374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:16:01.531397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:16:01.350732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T07:16:05.040455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
교육행정구역ID교육행정구역명교육지원청코드교육지원청명변경일자공간객체ID
교육행정구역ID1.0001.0001.0001.0001.0001.000
교육행정구역명1.0001.0001.0001.0001.0001.000
교육지원청코드1.0001.0001.0001.0000.3420.610
교육지원청명1.0001.0001.0001.0001.0001.000
변경일자1.0001.0000.3421.0001.0000.614
공간객체ID1.0001.0000.6101.0000.6141.000
2023-12-11T07:16:05.133846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
교육지원청코드공간객체ID변경일자
교육지원청코드1.0000.4480.039
공간객체ID0.4481.0000.260
변경일자0.0390.2601.000

Missing values

2023-12-11T07:16:01.655600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T07:16:01.781562image/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

교육행정구역ID교육행정구역명교육행정분류명시도교육청코드시도교육청명교육지원청코드교육지원청명생성일자변경일자공간객체ID데이터기준일자
0S000000040수원교육지원청7530000경기도교육청7541000수원교육지원청2013-04-302018-09-05272019-09-16
1S000000041성남교육지원청7530000경기도교육청7551000성남교육지원청2013-04-302018-09-06282019-09-16
2S000000042의정부교육지원청7530000경기도교육청7561000의정부교육지원청2013-04-302013-04-30292019-09-16
3S000000043안양과천교육지원청7530000경기도교육청7569000안양과천교육지원청2013-04-302018-09-061772019-09-16
4S000000044부천교육지원청7530000경기도교육청7581000부천교육지원청2013-04-302015-02-16302019-09-16
5S000000045광명교육지원청7530000경기도교육청7591000광명교육지원청2013-04-302013-04-30312019-09-16
6S000000046동두천양주교육지원청7530000경기도교육청7602000동두천양주교육지원청2013-04-302013-04-30332019-09-16
7S000000047안산교육지원청7530000경기도교육청7611000안산교육지원청2013-04-302018-09-051672019-09-16
8S000000048고양교육지원청7530000경기도교육청7621000고양교육지원청2013-04-302013-04-30342019-09-16
9S000000049평택교육지원청7530000경기도교육청7631000평택교육지원청2013-04-302013-04-30322019-09-16
교육행정구역ID교육행정구역명교육행정분류명시도교육청코드시도교육청명교육지원청코드교육지원청명생성일자변경일자공간객체ID데이터기준일자
15S000000055광주하남교육지원청7530000경기도교육청7692000광주하남교육지원청2013-04-302018-09-06372019-09-16
16S000000056연천교육지원청7530000경기도교육청7701000연천교육지원청2013-04-302013-04-30442019-09-16
17S000000057포천교육지원청7530000경기도교육청7711000포천교육지원청2013-04-302013-04-30422019-09-16
18S000000058가평교육지원청7530000경기도교육청7721000가평교육지원청2013-04-302013-04-30452019-09-16
19S000000059양평교육지원청7530000경기도교육청7731000양평교육지원청2013-04-302013-04-30462019-09-16
20S000000060이천교육지원청7530000경기도교육청7741000이천교육지원청2013-04-302013-04-30392019-09-16
21S000000061용인교육지원청7530000경기도교육청7751000용인교육지원청2013-04-302013-04-301532019-09-16
22S000000062안성교육지원청7530000경기도교육청7761000안성교육지원청2013-04-302013-04-30402019-09-16
23S000000063김포교육지원청7530000경기도교육청7771000김포교육지원청2013-04-302013-04-30412019-09-16
24S000000064시흥교육지원청7530000경기도교육청7781000시흥교육지원청2013-04-302013-04-30362019-09-16