Overview

Dataset statistics

Number of variables19
Number of observations30
Missing cells244
Missing cells (%)42.8%
Duplicate rows6
Duplicate rows (%)20.0%
Total size in memory4.6 KiB
Average record size in memory156.4 B

Variable types

Text1
Categorical1
Unsupported17

Dataset

Description인천광역시교육청 관내 모든 학교 일반현황에 대한 데이터로 학교명, 소재지, 전화번호, 학급수, 학생수 등의 항목을 제공합니다.
URLhttps://www.data.go.kr/data/15004947/fileData.do

Alerts

Dataset has 6 (20.0%) duplicate rowsDuplicates
2023. 4. 1.자 학교 현황 has 14 (46.7%) missing valuesMissing
Unnamed: 2 has 9 (30.0%) missing valuesMissing
Unnamed: 3 has 14 (46.7%) missing valuesMissing
Unnamed: 4 has 11 (36.7%) missing valuesMissing
Unnamed: 5 has 9 (30.0%) missing valuesMissing
Unnamed: 6 has 15 (50.0%) missing valuesMissing
Unnamed: 7 has 13 (43.3%) missing valuesMissing
Unnamed: 8 has 10 (33.3%) missing valuesMissing
Unnamed: 9 has 12 (40.0%) missing valuesMissing
Unnamed: 10 has 16 (53.3%) missing valuesMissing
Unnamed: 11 has 16 (53.3%) missing valuesMissing
Unnamed: 12 has 16 (53.3%) missing valuesMissing
Unnamed: 13 has 16 (53.3%) missing valuesMissing
Unnamed: 14 has 16 (53.3%) missing valuesMissing
Unnamed: 15 has 12 (40.0%) missing valuesMissing
Unnamed: 16 has 11 (36.7%) missing valuesMissing
Unnamed: 17 has 17 (56.7%) missing valuesMissing
Unnamed: 18 has 17 (56.7%) missing valuesMissing
Unnamed: 2 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

Reproduction

Analysis started2023-12-12 17:35:06.809212
Analysis finished2023-12-12 17:35:07.868633
Duration1.06 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

2023. 4. 1.자 학교 현황
Text

MISSING 

Distinct13
Distinct (%)81.2%
Missing14
Missing (%)46.7%
Memory size372.0 B
2023-12-13T02:35:07.986824image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length2
Mean length5.25
Min length2

Characters and Unicode

Total characters84
Distinct characters40
Distinct categories7 ?
Distinct scripts2 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique10 ?
Unique (%)62.5%

Sample

1st row▶ 작성기준일: 2023. 4. 1.
2nd row구분
3rd row국립
4th row공립
5th row사립
ValueCountFrequency (%)
구분 2
 
9.1%
소계 2
 
9.1%
합계 2
 
9.1%
※ 1
 
4.5%
개교(원 1
 
4.5%
증감 1
 
4.5%
2023년도 1
 
4.5%
2022년도 1
 
4.5%
비교(변동사항 1
 
4.5%
2022.4.1.자와 1
 
4.5%
Other values (9) 9
40.9%
2023-12-13T02:35:08.332042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 10
 
11.9%
. 6
 
7.1%
6
 
7.1%
계 4
 
4.8%
0 4
 
4.8%
립 3
 
3.6%
) 3
 
3.6%
( 3
 
3.6%
교 3
 
3.6%
원 2
 
2.4%
Other values (30) 40
47.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 43
51.2%
Decimal Number 20
23.8%
Other Punctuation 8
 
9.5%
Space Separator 6
 
7.1%
Close Punctuation 3
 
3.6%
Open Punctuation 3
 
3.6%
Other Symbol 1
 
1.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
계 4
 
9.3%
립 3
 
7.0%
교 3
 
7.0%
원 2
 
4.7%
도 2
 
4.7%
년 2
 
4.7%
사 2
 
4.7%
분 2
 
4.7%
구 2
 
4.7%
합 2
 
4.7%
Other values (18) 19
44.2%
Decimal Number
ValueCountFrequency (%)
2 10
50.0%
0 4
 
20.0%
1 2
 
10.0%
4 2
 
10.0%
3 2
 
10.0%
Other Punctuation
ValueCountFrequency (%)
. 6
75.0%
: 1
 
12.5%
※ 1
 
12.5%
Space Separator
ValueCountFrequency (%)
6
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Other Symbol
ValueCountFrequency (%)
▶ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 43
51.2%
Common 41
48.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
계 4
 
9.3%
립 3
 
7.0%
교 3
 
7.0%
원 2
 
4.7%
도 2
 
4.7%
년 2
 
4.7%
사 2
 
4.7%
분 2
 
4.7%
구 2
 
4.7%
합 2
 
4.7%
Other values (18) 19
44.2%
Common
ValueCountFrequency (%)
2 10
24.4%
. 6
14.6%
6
14.6%
0 4
 
9.8%
) 3
 
7.3%
( 3
 
7.3%
1 2
 
4.9%
4 2
 
4.9%
3 2
 
4.9%
▶ 1
 
2.4%
Other values (2) 2
 
4.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 43
51.2%
ASCII 39
46.4%
Geometric Shapes 1
 
1.2%
Punctuation 1
 
1.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 10
25.6%
. 6
15.4%
6
15.4%
0 4
 
10.3%
) 3
 
7.7%
( 3
 
7.7%
1 2
 
5.1%
4 2
 
5.1%
3 2
 
5.1%
: 1
 
2.6%
Hangul
ValueCountFrequency (%)
계 4
 
9.3%
립 3
 
7.0%
교 3
 
7.0%
원 2
 
4.7%
도 2
 
4.7%
년 2
 
4.7%
사 2
 
4.7%
분 2
 
4.7%
구 2
 
4.7%
합 2
 
4.7%
Other values (18) 19
44.2%
Geometric Shapes
ValueCountFrequency (%)
▶ 1
100.0%
Punctuation
ValueCountFrequency (%)
※ 1
100.0%

Unnamed: 1
Categorical

Distinct6
Distinct (%)20.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
<NA>
14 
학교수
4 
학급수
4 
학생수
4 
공립
2 

Length

Max length4
Median length3
Mean length3.3333333
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row학교수
5th row학급수

Common Values

ValueCountFrequency (%)
<NA> 14
46.7%
학교수 4
 
13.3%
학급수 4
 
13.3%
학생수 4
 
13.3%
공립 2
 
6.7%
사립 2
 
6.7%

Length

2023-12-13T02:35:08.514923image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:35:08.654812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 14
46.7%
학교수 4
 
13.3%
학급수 4
 
13.3%
학생수 4
 
13.3%
공립 2
 
6.7%
사립 2
 
6.7%

Unnamed: 2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9
Missing (%)30.0%
Memory size372.0 B

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing14
Missing (%)46.7%
Memory size372.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing11
Missing (%)36.7%
Memory size372.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9
Missing (%)30.0%
Memory size372.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing15
Missing (%)50.0%
Memory size372.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing13
Missing (%)43.3%
Memory size372.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing10
Missing (%)33.3%
Memory size372.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing12
Missing (%)40.0%
Memory size372.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing16
Missing (%)53.3%
Memory size372.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing16
Missing (%)53.3%
Memory size372.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing16
Missing (%)53.3%
Memory size372.0 B

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing16
Missing (%)53.3%
Memory size372.0 B

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing16
Missing (%)53.3%
Memory size372.0 B

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing12
Missing (%)40.0%
Memory size372.0 B

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing11
Missing (%)36.7%
Memory size372.0 B

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing17
Missing (%)56.7%
Memory size372.0 B

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing17
Missing (%)56.7%
Memory size372.0 B

Correlations

2023-12-13T02:35:08.734147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023. 4. 1.자 학교 현황Unnamed: 1
2023. 4. 1.자 학교 현황1.0001.000
Unnamed: 11.0001.000

Missing values

2023-12-13T02:35:07.044607image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T02:35:07.335019image/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.
2023-12-13T02:35:07.611979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

2023. 4. 1.자 학교 현황Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18
0▶ 작성기준일: 2023. 4. 1.<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1구분<NA>유치원NaNNaN초등학교NaN중학교고등학교특수학교각종학교NaN국제학교영재학교방송통신\n중고등학교학력인정평생교육시설합계NaNNaN
2<NA><NA>단설병설계NaN(분교)NaNNaNNaNNaN(위탁)NaNNaNNaNNaNNaN(분교)(위탁)
3국립학교수NaNNaNNaN1NaNNaN1NaNNaNNaNNaNNaNNaNNaN200
4<NA>학급수NaNNaNNaN25NaNNaN18NaNNaNNaNNaNNaNNaNNaN4300
5<NA>학생수NaNNaNNaN572NaNNaN314NaNNaNNaNNaNNaNNaNNaN88600
6공립학교수181761942568133926NaN3NaN13NaN68583
7<NA>학급수23147570671172428782306269NaN30NaN1524NaN133152430
8<NA>학생수30744892796615242711874423532721555NaN296NaN240507NaN290390118296
9사립학교수198NaN1985NaN103343NaN1NaNNaN225600
2023. 4. 1.자 학교 현황Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18
202022년도<NA>2201742601014212610161132956분교포함NaNNaN
212023년도<NA>216176262814312610061132954분교포함NaNNaN
22증감<NA>-422-2100-100000-2NaNNaNNaN
23개교(원)공립132NaN1NaNNaNNaNNaNNaNNaNNaNNaN7- 유치원\n인천서로꿈유치원(23.3.)\n인천이음초등학교병설유치원(22.9.)\n인천남부초등학교이작분교장병설유치원(22.9.)\n인천아람초등학교병설유치원(23.3.)\n\n- 초등학교\n인천이음초등학교(22.9.)\n인천아람초등학교(23.3.)\n\n- 중학교\n인천루원중학교(23.3.)NaNNaN
24<NA>사립NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaN
25소계<NA>13201000000007NaNNaNNaN
26폐교(원)공립NaN1NaN2NaNNaNNaNNaNNaNNaNNaNNaNNaN3- 유치원\n교동초등학교지석분교장병설유치원(23.2.)\n\n- 초등학교\n인천용유초등학교무의분교장(23.2.)\n교동초등학교지석분교장(23.2.)NaNNaN
27<NA>사립5NaNNaNNaNNaNNaNNaN1NaNNaNNaNNaNNaN6- 유치원\n영보유치원(22.4.)\n숲속의유치원(23.3.)\n딩동댕유치원(23.3.)\n유석화유치원(23.3.)\n동진유치원(23.3.)\n\n- 고등기술학교 한진고등기술학교(23.3.)NaNNaN
28소계<NA>51020001000009NaNNaNNaN
29합계<NA>-422-2100-100000-2NaNNaNNaN

Duplicate rows

Most frequently occurring

2023. 4. 1.자 학교 현황Unnamed: 1# duplicates
3<NA>학급수4
4<NA>학생수4
5<NA><NA>4
0구분<NA>2
1소계<NA>2
2<NA>사립2