Overview

Dataset statistics

Number of variables9
Number of observations2871
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory207.6 KiB
Average record size in memory74.0 B

Variable types

Text3
Categorical5
Numeric1

Dataset

Description학교 학구도 연계 정보 현황(제공표준)
Author경기도
URLhttps://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=BLOCL22HQG85SKWEKUYB24598765&infSeq=1

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

Reproduction

Analysis started2023-12-10 21:49:42.515885
Analysis finished2023-12-10 21:49:43.510286
Duration0.99 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

학구ID
Text

Distinct1859
Distinct (%)64.8%
Missing0
Missing (%)0.0%
Memory size22.6 KiB
2023-12-11T06:49:43.710716image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

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

Unique1420 ?
Unique (%)49.5%

Sample

1st rowZ000101944
2nd rowZ000101945
3rd rowZ000101946
4th rowZ000101947
5th rowZ000101948
ValueCountFrequency (%)
z000200204 32
 
1.1%
z000210025 23
 
0.8%
z000300037 23
 
0.8%
z000200200 19
 
0.7%
z000200196 19
 
0.7%
z000300031 18
 
0.6%
z000200198 18
 
0.6%
z000300033 18
 
0.6%
z000300042 16
 
0.6%
z000200202 15
 
0.5%
Other values (1849) 2670
93.0%
2023-12-11T06:49:44.087100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 13418
46.7%
1 3321
 
11.6%
2 2961
 
10.3%
Z 2871
 
10.0%
3 1277
 
4.4%
5 1259
 
4.4%
8 753
 
2.6%
9 739
 
2.6%
4 721
 
2.5%
7 714
 
2.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 25839
90.0%
Uppercase Letter 2871
 
10.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 13418
51.9%
1 3321
 
12.9%
2 2961
 
11.5%
3 1277
 
4.9%
5 1259
 
4.9%
8 753
 
2.9%
9 739
 
2.9%
4 721
 
2.8%
7 714
 
2.8%
6 676
 
2.6%
Uppercase Letter
ValueCountFrequency (%)
Z 2871
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 25839
90.0%
Latin 2871
 
10.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 13418
51.9%
1 3321
 
12.9%
2 2961
 
11.5%
3 1277
 
4.9%
5 1259
 
4.9%
8 753
 
2.9%
9 739
 
2.9%
4 721
 
2.8%
7 714
 
2.8%
6 676
 
2.6%
Latin
ValueCountFrequency (%)
Z 2871
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 28710
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 13418
46.7%
1 3321
 
11.6%
2 2961
 
10.3%
Z 2871
 
10.0%
3 1277
 
4.4%
5 1259
 
4.4%
8 753
 
2.6%
9 739
 
2.6%
4 721
 
2.5%
7 714
 
2.5%

학교ID
Text

Distinct2123
Distinct (%)73.9%
Missing0
Missing (%)0.0%
Memory size22.6 KiB
2023-12-11T06:49:44.302912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

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

Unique1623 ?
Unique (%)56.5%

Sample

1st rowB000003880
2nd rowB000003867
3rd rowB000003860
4th rowB000003856
5th rowB000003870
ValueCountFrequency (%)
b000004808 7
 
0.2%
b000009442 6
 
0.2%
b000009443 6
 
0.2%
b000004485 6
 
0.2%
b000004676 5
 
0.2%
b000004322 5
 
0.2%
b000003762 5
 
0.2%
b000004502 5
 
0.2%
b000004523 5
 
0.2%
b000024813 5
 
0.2%
Other values (2113) 2816
98.1%
2023-12-11T06:49:44.646137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 14686
51.2%
B 2871
 
10.0%
4 2288
 
8.0%
9 1456
 
5.1%
3 1424
 
5.0%
2 1260
 
4.4%
6 1055
 
3.7%
1 1023
 
3.6%
5 957
 
3.3%
7 914
 
3.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 25839
90.0%
Uppercase Letter 2871
 
10.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 14686
56.8%
4 2288
 
8.9%
9 1456
 
5.6%
3 1424
 
5.5%
2 1260
 
4.9%
6 1055
 
4.1%
1 1023
 
4.0%
5 957
 
3.7%
7 914
 
3.5%
8 776
 
3.0%
Uppercase Letter
ValueCountFrequency (%)
B 2871
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 25839
90.0%
Latin 2871
 
10.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 14686
56.8%
4 2288
 
8.9%
9 1456
 
5.6%
3 1424
 
5.5%
2 1260
 
4.9%
6 1055
 
4.1%
1 1023
 
4.0%
5 957
 
3.7%
7 914
 
3.5%
8 776
 
3.0%
Latin
ValueCountFrequency (%)
B 2871
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 28710
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 14686
51.2%
B 2871
 
10.0%
4 2288
 
8.0%
9 1456
 
5.1%
3 1424
 
5.0%
2 1260
 
4.4%
6 1055
 
3.7%
1 1023
 
3.6%
5 957
 
3.3%
7 914
 
3.2%

학교명
Text

Distinct2116
Distinct (%)73.7%
Missing0
Missing (%)0.0%
Memory size22.6 KiB
2023-12-11T06:49:44.916176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length6
Mean length6.1170324
Min length5

Characters and Unicode

Total characters17562
Distinct characters294
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

Unique1615 ?
Unique (%)56.3%

Sample

1st row관문초등학교
2nd row관양초등학교
3rd row귀인초등학교
4th row나눔초등학교
5th row달안초등학교
ValueCountFrequency (%)
전곡초등학교 7
 
0.2%
봉담중학교 6
 
0.2%
화성동화중학교 6
 
0.2%
성석초등학교 6
 
0.2%
비봉중학교 5
 
0.2%
푸른솔초등학교 5
 
0.2%
왕남초등학교 5
 
0.2%
야탑초등학교 5
 
0.2%
일산초등학교 5
 
0.2%
신원초등학교 5
 
0.2%
Other values (2106) 2816
98.1%
2023-12-11T06:49:45.314834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
교 2920
16.6%
학 2887
16.4%
등 2091
 
11.9%
초 1909
 
10.9%
중 835
 
4.8%
고 262
 
1.5%
성 196
 
1.1%
산 182
 
1.0%
양 176
 
1.0%
동 172
 
1.0%
Other values (284) 5932
33.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 17562
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
교 2920
16.6%
학 2887
16.4%
등 2091
 
11.9%
초 1909
 
10.9%
중 835
 
4.8%
고 262
 
1.5%
성 196
 
1.1%
산 182
 
1.0%
양 176
 
1.0%
동 172
 
1.0%
Other values (284) 5932
33.8%

Most occurring scripts

ValueCountFrequency (%)
Hangul 17562
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
교 2920
16.6%
학 2887
16.4%
등 2091
 
11.9%
초 1909
 
10.9%
중 835
 
4.8%
고 262
 
1.5%
성 196
 
1.1%
산 182
 
1.0%
양 176
 
1.0%
동 172
 
1.0%
Other values (284) 5932
33.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 17562
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
교 2920
16.6%
학 2887
16.4%
등 2091
 
11.9%
초 1909
 
10.9%
중 835
 
4.8%
고 262
 
1.5%
성 196
 
1.1%
산 182
 
1.0%
양 176
 
1.0%
동 172
 
1.0%
Other values (284) 5932
33.8%

학교급구분
Categorical

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size22.6 KiB
초등학교
1893 
중학교
779 
고등학교
199 

Length

Max length4
Median length4
Mean length3.728666
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row초등학교
2nd row초등학교
3rd row초등학교
4th row초등학교
5th row초등학교

Common Values

ValueCountFrequency (%)
초등학교 1893
65.9%
중학교 779
27.1%
고등학교 199
 
6.9%

Length

2023-12-11T06:49:45.477110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T06:49:45.593254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
초등학교 1893
65.9%
중학교 779
27.1%
고등학교 199
 
6.9%

시도교육청코드
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size22.6 KiB
7530000
2871 

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 2871
100.0%

Length

2023-12-11T06:49:45.686778image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T06:49:45.771084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
7530000 2871
100.0%

시도교육청명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size22.6 KiB
경기도교육청
2871 

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

Length

2023-12-11T06:49:45.877999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T06:49:45.969387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도교육청 2871
100.0%

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

HIGH CORRELATION 

Distinct25
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7651332.3
Minimum7541000
Maximum7781000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size25.4 KiB
2023-12-11T06:49:46.079162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum7541000
5-th percentile7541000
Q17591000
median7652000
Q37701000
95-th percentile7771000
Maximum7781000
Range240000
Interquartile range (IQR)110000

Descriptive statistics

Standard deviation72347.682
Coefficient of variation (CV)0.0094555666
Kurtosis-1.117258
Mean7651332.3
Median Absolute Deviation (MAD)59000
Skewness0.11687657
Sum2.1966975 × 1010
Variance5.2341871 × 109
MonotonicityNot monotonic
2023-12-11T06:49:46.199751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)
ValueCountFrequency (%)
7679000 270
 
9.4%
7751000 262
 
9.1%
7621000 259
 
9.0%
7541000 201
 
7.0%
7551000 190
 
6.6%
7631000 152
 
5.3%
7581000 148
 
5.2%
7652000 134
 
4.7%
7681000 121
 
4.2%
7692000 118
 
4.1%
Other values (15) 1016
35.4%
ValueCountFrequency (%)
7541000 201
7.0%
7551000 190
6.6%
7561000 78
 
2.7%
7569000 95
 
3.3%
7581000 148
5.2%
7591000 51
 
1.8%
7602000 69
 
2.4%
7611000 105
3.7%
7621000 259
9.0%
7631000 152
5.3%
ValueCountFrequency (%)
7781000 71
 
2.5%
7771000 113
3.9%
7761000 48
 
1.7%
7751000 262
9.1%
7741000 58
 
2.0%
7731000 37
 
1.3%
7721000 38
 
1.3%
7711000 87
 
3.0%
7701000 48
 
1.7%
7692000 118
4.1%

교육지원청명
Categorical

HIGH CORRELATION 

Distinct25
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size22.6 KiB
경기도화성오산교육지원청
270 
경기도용인교육지원청
262 
경기도고양교육지원청
259 
경기도수원교육지원청
201 
경기도성남교육지원청
190 
Other values (20)
1689 

Length

Max length13
Median length10
Mean length10.626611
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기도안양과천교육지원청
2nd row경기도안양과천교육지원청
3rd row경기도안양과천교육지원청
4th row경기도안양과천교육지원청
5th row경기도안양과천교육지원청

Common Values

ValueCountFrequency (%)
경기도화성오산교육지원청 270
 
9.4%
경기도용인교육지원청 262
 
9.1%
경기도고양교육지원청 259
 
9.0%
경기도수원교육지원청 201
 
7.0%
경기도성남교육지원청 190
 
6.6%
경기도평택교육지원청 152
 
5.3%
경기도부천교육지원청 148
 
5.2%
경기도구리남양주교육지원청 134
 
4.7%
경기도파주교육지원청 121
 
4.2%
경기도광주하남교육지원청 118
 
4.1%
Other values (15) 1016
35.4%

Length

2023-12-11T06:49:46.351726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경기도화성오산교육지원청 270
 
9.4%
경기도용인교육지원청 262
 
9.1%
경기도고양교육지원청 259
 
9.0%
경기도수원교육지원청 201
 
7.0%
경기도성남교육지원청 190
 
6.6%
경기도평택교육지원청 152
 
5.3%
경기도부천교육지원청 148
 
5.2%
경기도구리남양주교육지원청 134
 
4.7%
경기도파주교육지원청 121
 
4.2%
경기도광주하남교육지원청 118
 
4.1%
Other values (15) 1016
35.4%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size22.6 KiB
2019-09-16
2871 

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 2871
100.0%

Length

2023-12-11T06:49:46.471912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T06:49:46.567768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2019-09-16 2871
100.0%

Interactions

2023-12-11T06:49:42.885699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T06:49:46.625032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
학교급구분교육지원청코드교육지원청명
학교급구분1.0000.2830.402
교육지원청코드0.2831.0001.000
교육지원청명0.4021.0001.000
2023-12-11T06:49:46.709315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
학교급구분교육지원청명
학교급구분1.0000.226
교육지원청명0.2261.000
2023-12-11T06:49:46.809991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
교육지원청코드학교급구분교육지원청명
교육지원청코드1.0000.1760.997
학교급구분0.1761.0000.226
교육지원청명0.9970.2261.000

Missing values

2023-12-11T06:49:43.292061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T06:49:43.432047image/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학교명학교급구분시도교육청코드시도교육청명교육지원청코드교육지원청명데이터기준일자
0Z000101944B000003880관문초등학교초등학교7530000경기도교육청7569000경기도안양과천교육지원청2019-09-16
1Z000101945B000003867관양초등학교초등학교7530000경기도교육청7569000경기도안양과천교육지원청2019-09-16
2Z000101946B000003860귀인초등학교초등학교7530000경기도교육청7569000경기도안양과천교육지원청2019-09-16
3Z000101947B000003856나눔초등학교초등학교7530000경기도교육청7569000경기도안양과천교육지원청2019-09-16
4Z000101948B000003870달안초등학교초등학교7530000경기도교육청7569000경기도안양과천교육지원청2019-09-16
5Z000101949B000003837덕천초등학교초등학교7530000경기도교육청7569000경기도안양과천교육지원청2019-09-16
6Z000101743B000003649고색초등학교초등학교7530000경기도교육청7541000경기도수원교육지원청2019-09-16
7Z000101744B000003648고현초등학교초등학교7530000경기도교육청7541000경기도수원교육지원청2019-09-16
8Z000101745B000003640곡반초등학교초등학교7530000경기도교육청7541000경기도수원교육지원청2019-09-16
9Z000101746B000003654곡선초등학교초등학교7530000경기도교육청7541000경기도수원교육지원청2019-09-16
학구ID학교ID학교명학교급구분시도교육청코드시도교육청명교육지원청코드교육지원청명데이터기준일자
2861Z000300039B000012521초지고등학교고등학교7530000경기도교육청7611000경기도안산교육지원청2019-09-16
2862Z000300039B000012516단원고등학교고등학교7530000경기도교육청7611000경기도안산교육지원청2019-09-16
2863Z000300039B000012518양지고등학교고등학교7530000경기도교육청7611000경기도안산교육지원청2019-09-16
2864Z000300039B000012528안산강서고등학교고등학교7530000경기도교육청7611000경기도안산교육지원청2019-09-16
2865Z000300039B000012519선부고등학교고등학교7530000경기도교육청7611000경기도안산교육지원청2019-09-16
2866Z000300040B000012522고잔고등학교고등학교7530000경기도교육청7611000경기도안산교육지원청2019-09-16
2867Z000300040B000022587부곡고등학교고등학교7530000경기도교육청7611000경기도안산교육지원청2019-09-16
2868Z000300040B000012524광덕고등학교고등학교7530000경기도교육청7611000경기도안산교육지원청2019-09-16
2869Z000300040B000012529안산고등학교고등학교7530000경기도교육청7611000경기도안산교육지원청2019-09-16
2870Z000300040B000012526성안고등학교고등학교7530000경기도교육청7611000경기도안산교육지원청2019-09-16