Overview

Dataset statistics

Number of variables21
Number of observations45
Missing cells185
Missing cells (%)19.6%
Duplicate rows13
Duplicate rows (%)28.9%
Total size in memory7.5 KiB
Average record size in memory170.9 B

Variable types

Unsupported19
Categorical2

Dataset

Description2021~2023년도 경기도교육청의 유치원,초등학교,중학교,고등학교 ,특수학교, 기타학교의 교원 현황 데이터로, 연령별 성별 항목으로 세분화하였습니다.
Author경기도교육청
URLhttps://www.data.go.kr/data/15077327/fileData.do

Alerts

Dataset has 13 (28.9%) duplicate rowsDuplicates
Unnamed: 0 has 41 (91.1%) missing valuesMissing
Unnamed: 3 has 6 (13.3%) missing valuesMissing
Unnamed: 4 has 9 (20.0%) missing valuesMissing
Unnamed: 5 has 9 (20.0%) missing valuesMissing
Unnamed: 6 has 6 (13.3%) missing valuesMissing
Unnamed: 7 has 9 (20.0%) missing valuesMissing
Unnamed: 8 has 9 (20.0%) missing valuesMissing
Unnamed: 9 has 6 (13.3%) missing valuesMissing
Unnamed: 10 has 9 (20.0%) missing valuesMissing
Unnamed: 11 has 9 (20.0%) missing valuesMissing
Unnamed: 12 has 6 (13.3%) missing valuesMissing
Unnamed: 13 has 9 (20.0%) missing valuesMissing
Unnamed: 14 has 9 (20.0%) missing valuesMissing
Unnamed: 15 has 6 (13.3%) missing valuesMissing
Unnamed: 16 has 9 (20.0%) missing valuesMissing
Unnamed: 17 has 9 (20.0%) missing valuesMissing
Unnamed: 18 has 6 (13.3%) missing valuesMissing
Unnamed: 19 has 9 (20.0%) missing valuesMissing
Unnamed: 20 has 9 (20.0%) missing valuesMissing
Unnamed: 0 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 3 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 4 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 6 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 11 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 13 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 14 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 15 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 16 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 17 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 18 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 19 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 20 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-03-16 04:15:15.186839
Analysis finished2024-03-16 04:15:15.331212
Duration0.14 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Unnamed: 0
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing41
Missing (%)91.1%
Memory size492.0 B

■ 2021년~2023년 경기도 유_초_중_고_특수학교_기타학교 연령별 성별 교원 현황
Categorical

Distinct13
Distinct (%)28.9%
Missing0
Missing (%)0.0%
Memory size492.0 B
<NA>
17 
구 분
3 
합계
3 
유치원
3 
초등학교
3 
Other values (8)
16 

Length

Max length60
Median length4
Mean length6.9555556
Min length2

Unique

Unique4 ?
Unique (%)8.9%

Sample

1st row<NA>
2nd row* 출처 : 교육기본통계 DB
3rd row* 조사기준일 : 당해년도 4월 1일 기준
4th row* 단위 : 명
5th row* 교원수에는 정규직 및 기간제가 포함되며, 시간강사 제외됨/ 재직 및 휴직 교원 포함되며 퇴직 교원 제외딤

Common Values

ValueCountFrequency (%)
<NA> 17
37.8%
구 분 3
 
6.7%
합계 3
 
6.7%
유치원 3
 
6.7%
초등학교 3
 
6.7%
중학교 3
 
6.7%
고등학교 3
 
6.7%
특수학교 3
 
6.7%
기타학교 3
 
6.7%
* 출처 : 교육기본통계 DB 1
 
2.2%
Other values (3) 3
 
6.7%

Length

2024-03-16T13:15:15.438736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 17
22.4%
7
 
9.2%
분 3
 
3.9%
구 3
 
3.9%
유치원 3
 
3.9%
초등학교 3
 
3.9%
중학교 3
 
3.9%
고등학교 3
 
3.9%
특수학교 3
 
3.9%
기타학교 3
 
3.9%
Other values (23) 28
36.8%

Unnamed: 2
Categorical

Distinct6
Distinct (%)13.3%
Missing0
Missing (%)0.0%
Memory size492.0 B
<NA>
30 
소계
 
3
일반고
 
3
특수목적고
 
3
특성화고
 
3

Length

Max length5
Median length4
Mean length3.8
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 30
66.7%
소계 3
 
6.7%
일반고 3
 
6.7%
특수목적고 3
 
6.7%
특성화고 3
 
6.7%
자율고 3
 
6.7%

Length

2024-03-16T13:15:15.645179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-16T13:15:15.925088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 30
66.7%
소계 3
 
6.7%
일반고 3
 
6.7%
특수목적고 3
 
6.7%
특성화고 3
 
6.7%
자율고 3
 
6.7%

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)13.3%
Memory size492.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9
Missing (%)20.0%
Memory size492.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9
Missing (%)20.0%
Memory size492.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)13.3%
Memory size492.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9
Missing (%)20.0%
Memory size492.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9
Missing (%)20.0%
Memory size492.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)13.3%
Memory size492.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9
Missing (%)20.0%
Memory size492.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9
Missing (%)20.0%
Memory size492.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)13.3%
Memory size492.0 B

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9
Missing (%)20.0%
Memory size492.0 B

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9
Missing (%)20.0%
Memory size492.0 B

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)13.3%
Memory size492.0 B

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9
Missing (%)20.0%
Memory size492.0 B

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9
Missing (%)20.0%
Memory size492.0 B

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)13.3%
Memory size492.0 B

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9
Missing (%)20.0%
Memory size492.0 B

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9
Missing (%)20.0%
Memory size492.0 B

Sample

Unnamed: 0■ 2021년~2023년 경기도 유_초_중_고_특수학교_기타학교 연령별 성별 교원 현황Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20
0NaN<NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1NaN* 출처 : 교육기본통계 DB<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2NaN* 조사기준일 : 당해년도 4월 1일 기준<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
3NaN* 단위 : 명<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
4NaN* 교원수에는 정규직 및 기간제가 포함되며, 시간강사 제외됨/ 재직 및 휴직 교원 포함되며 퇴직 교원 제외딤<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
5NaN<NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
6연도구 분<NA>전체NaNNaN만 29세 이하NaNNaN만 30~39세NaNNaN만 40~49세NaNNaN만 50~59세NaNNaN만 60세 이상NaNNaN
7NaN<NA><NA>계남여계남여계남여계남여계남여계남여
82021합계<NA>125192293079588520916338517531338347964258704347890643441423902750116401306213931669
9NaN유치원<NA>1383922913610635659629735828035022218192199134232131034139302
Unnamed: 0■ 2021년~2023년 경기도 유_초_중_고_특수학교_기타학교 연령별 성별 교원 현황Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20
35NaN유치원<NA>16301456811733611167604439489238562651202631142818141040537368
36NaN초등학교<NA>564202824728173854016806860126153098951716944281014134100292105792417673561411
37NaN중학교<NA>330041773415270353495325817079182852511180821189690668417594925754416338
38NaN고등학교소계3304616608164382935704217086252719603612769397289697281353435721092783223
39NaN<NA>일반고270691372113348237157717947139220349361055629917565583026573173788585203
40NaN<NA>특수목적고10305344968824642931291644982142842391459429263
41NaN<NA>특성화고465822172441464116348113442171315995661033111552958626520461
42NaN<NA>자율고289136153124859213811639779764331091
43NaN특수학교<NA>241411171297517135382777285492552160392379105274441331
44NaN기타학교<NA>3011321693983110634728223595226261495

Duplicate rows

Most frequently occurring

■ 2021년~2023년 경기도 유_초_중_고_특수학교_기타학교 연령별 성별 교원 현황Unnamed: 2# duplicates
12<NA><NA>5
0고등학교소계3
1구 분<NA>3
2기타학교<NA>3
3유치원<NA>3
4중학교<NA>3
5초등학교<NA>3
6특수학교<NA>3
7합계<NA>3
8<NA>일반고3