Overview

Dataset statistics

Number of variables4
Number of observations92
Missing cells156
Missing cells (%)42.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.1 KiB
Average record size in memory34.4 B

Variable types

Text2
Categorical1
Unsupported1

Dataset

Description춘천 초등학교 학군 자료
Author강원특별자치도교육청 강원특별자치도춘천교육지원청
URLhttps://www.data.go.kr/data/3038337/fileData.do

Alerts

행정동명 has 64 (69.6%) missing valuesMissing
비고 has 92 (100.0%) missing valuesMissing
통학구역 has unique valuesUnique
비고 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 00:10:19.715126
Analysis finished2023-12-12 00:10:20.032751
Duration0.32 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

행정동명
Text

MISSING 

Distinct28
Distinct (%)100.0%
Missing64
Missing (%)69.6%
Memory size868.0 B
2023-12-12T09:10:20.168952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length6
Mean length3.5357143
Min length2

Characters and Unicode

Total characters99
Distinct characters37
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique28 ?
Unique (%)100.0%

Sample

1st row소양동
2nd row교동
3rd row조운동
4th row약사명동
5th row근화동
ValueCountFrequency (%)
홍천군 2
 
6.5%
서면 2
 
6.5%
강남동 1
 
3.2%
신동면 1
 
3.2%
화천군 1
 
3.2%
신사우동 1
 
3.2%
북방면 1
 
3.2%
북산면 1
 
3.2%
사북면 1
 
3.2%
남산면 1
 
3.2%
Other values (19) 19
61.3%
2023-12-12T09:10:20.452361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 19
19.2%
면 12
 
12.1%
북 4
 
4.0%
남 4
 
4.0%
사 4
 
4.0%
후 3
 
3.0%
신 3
 
3.0%
산 3
 
3.0%
자 3
 
3.0%
효 3
 
3.0%
Other values (27) 41
41.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 90
90.9%
Decimal Number 6
 
6.1%
Space Separator 3
 
3.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 19
21.1%
면 12
 
13.3%
북 4
 
4.4%
남 4
 
4.4%
사 4
 
4.4%
후 3
 
3.3%
신 3
 
3.3%
산 3
 
3.3%
자 3
 
3.3%
효 3
 
3.3%
Other values (23) 32
35.6%
Decimal Number
ValueCountFrequency (%)
1 2
33.3%
2 2
33.3%
3 2
33.3%
Space Separator
ValueCountFrequency (%)
3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 90
90.9%
Common 9
 
9.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 19
21.1%
면 12
 
13.3%
북 4
 
4.4%
남 4
 
4.4%
사 4
 
4.4%
후 3
 
3.3%
신 3
 
3.3%
산 3
 
3.3%
자 3
 
3.3%
효 3
 
3.3%
Other values (23) 32
35.6%
Common
ValueCountFrequency (%)
3
33.3%
1 2
22.2%
2 2
22.2%
3 2
22.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 90
90.9%
ASCII 9
 
9.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 19
21.1%
면 12
 
13.3%
북 4
 
4.4%
남 4
 
4.4%
사 4
 
4.4%
후 3
 
3.3%
신 3
 
3.3%
산 3
 
3.3%
자 3
 
3.3%
효 3
 
3.3%
Other values (23) 32
35.6%
ASCII
ValueCountFrequency (%)
3
33.3%
1 2
22.2%
2 2
22.2%
3 2
22.2%

관할학교명
Categorical

Distinct41
Distinct (%)44.6%
Missing0
Missing (%)0.0%
Memory size868.0 B
<NA>
10 
교동초
 
4
봉의초
 
4
춘천초
 
4
광판초
 
4
Other values (36)
66 

Length

Max length8
Median length3
Mean length3.326087
Min length3

Unique

Unique12 ?
Unique (%)13.0%

Sample

1st row근화초
2nd row중앙초
3rd row<NA>
4th row교동초
5th row교동초

Common Values

ValueCountFrequency (%)
<NA> 10
 
10.9%
교동초 4
 
4.3%
봉의초 4
 
4.3%
춘천초 4
 
4.3%
광판초 4
 
4.3%
동춘천초 3
 
3.3%
중앙초 3
 
3.3%
남산초 3
 
3.3%
효제초 3
 
3.3%
신동초 3
 
3.3%
Other values (31) 51
55.4%

Length

2023-12-12T09:10:20.571479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 10
 
10.9%
봉의초 4
 
4.3%
춘천초 4
 
4.3%
광판초 4
 
4.3%
교동초 4
 
4.3%
효제초 3
 
3.3%
동부초 3
 
3.3%
신동초 3
 
3.3%
남산초 3
 
3.3%
중앙초 3
 
3.3%
Other values (31) 51
55.4%

통학구역
Text

UNIQUE 

Distinct92
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size868.0 B
2023-12-12T09:10:20.868944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length75
Median length52
Mean length23.75
Min length2

Characters and Unicode

Total characters2185
Distinct characters122
Distinct categories8 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique92 ?
Unique (%)100.0%

Sample

1st row1~6통, 7통(1~2반), 10통(1~2반), 23통(4~7반), 26~27통
2nd row7통(3~5반),8~9통,10통(3~5반),11통(1~2반),12통(5~6반),13~22통,
3rd row23통(1~3반), 24~25통, 소양촉진5구역 육군관사
4th row11통(3~6반), 12통(1~4반)
5th row전지역
ValueCountFrequency (%)
공동학구 11
 
3.9%
1통 5
 
1.8%
제외 5
 
1.8%
만천초와 4
 
1.4%
12통 2
 
0.7%
1~2통 2
 
0.7%
장학초와 2
 
0.7%
4~5통(후평초 2
 
0.7%
1통(후평초 2
 
0.7%
194,195-1~32,197-1~11,198,199-7~8,201-3,201-4번지 2
 
0.7%
Other values (234) 246
86.9%
2023-12-12T09:10:21.287902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
, 240
 
11.0%
1 208
 
9.5%
198
 
9.1%
통 141
 
6.5%
2 124
 
5.7%
~ 117
 
5.4%
리 107
 
4.9%
3 81
 
3.7%
4 72
 
3.3%
7 69
 
3.2%
Other values (112) 828
37.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 784
35.9%
Other Letter 665
30.4%
Other Punctuation 245
 
11.2%
Space Separator 198
 
9.1%
Math Symbol 117
 
5.4%
Open Punctuation 59
 
2.7%
Close Punctuation 59
 
2.7%
Dash Punctuation 58
 
2.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
통 141
21.2%
리 107
16.1%
반 54
 
8.1%
학 22
 
3.3%
동 16
 
2.4%
초 16
 
2.4%
지 15
 
2.3%
구 14
 
2.1%
공 11
 
1.7%
와 11
 
1.7%
Other values (94) 258
38.8%
Decimal Number
ValueCountFrequency (%)
1 208
26.5%
2 124
15.8%
3 81
 
10.3%
4 72
 
9.2%
7 69
 
8.8%
8 53
 
6.8%
5 51
 
6.5%
6 46
 
5.9%
9 45
 
5.7%
0 35
 
4.5%
Other Punctuation
ValueCountFrequency (%)
, 240
98.0%
? 4
 
1.6%
· 1
 
0.4%
Space Separator
ValueCountFrequency (%)
198
100.0%
Math Symbol
ValueCountFrequency (%)
~ 117
100.0%
Open Punctuation
ValueCountFrequency (%)
( 59
100.0%
Close Punctuation
ValueCountFrequency (%)
) 59
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 58
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1520
69.6%
Hangul 665
30.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
통 141
21.2%
리 107
16.1%
반 54
 
8.1%
학 22
 
3.3%
동 16
 
2.4%
초 16
 
2.4%
지 15
 
2.3%
구 14
 
2.1%
공 11
 
1.7%
와 11
 
1.7%
Other values (94) 258
38.8%
Common
ValueCountFrequency (%)
, 240
15.8%
1 208
13.7%
198
13.0%
2 124
8.2%
~ 117
 
7.7%
3 81
 
5.3%
4 72
 
4.7%
7 69
 
4.5%
( 59
 
3.9%
) 59
 
3.9%
Other values (8) 293
19.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1519
69.5%
Hangul 665
30.4%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
, 240
15.8%
1 208
13.7%
198
13.0%
2 124
8.2%
~ 117
7.7%
3 81
 
5.3%
4 72
 
4.7%
7 69
 
4.5%
( 59
 
3.9%
) 59
 
3.9%
Other values (7) 292
19.2%
Hangul
ValueCountFrequency (%)
통 141
21.2%
리 107
16.1%
반 54
 
8.1%
학 22
 
3.3%
동 16
 
2.4%
초 16
 
2.4%
지 15
 
2.3%
구 14
 
2.1%
공 11
 
1.7%
와 11
 
1.7%
Other values (94) 258
38.8%
None
ValueCountFrequency (%)
· 1
100.0%

비고
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing92
Missing (%)100.0%
Memory size960.0 B

Correlations

2023-12-12T09:10:21.364207image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동명관할학교명통학구역
행정동명1.0001.0001.000
관할학교명1.0001.0001.000
통학구역1.0001.0001.000

Missing values

2023-12-12T09:10:19.916790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T09:10:19.994896image/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소양동근화초1~6통, 7통(1~2반), 10통(1~2반), 23통(4~7반), 26~27통<NA>
1<NA>중앙초7통(3~5반),8~9통,10통(3~5반),11통(1~2반),12통(5~6반),13~22통,<NA>
2<NA><NA>23통(1~3반), 24~25통, 소양촉진5구역 육군관사<NA>
3<NA>교동초11통(3~6반), 12통(1~4반)<NA>
4교동교동초전지역<NA>
5조운동교동초3통, 7통(5반), 8~9통, 11통<NA>
6<NA>봉의초1~2통, 4~7통(1~4반), 10통, 12통<NA>
7약사명동봉의초1~4통<NA>
8<NA>춘천초5~11통, 12통(1~2반), 13~16통<NA>
9<NA>중앙초12통(3~4반)<NA>
행정동명관할학교명통학구역비고
82사북면지촌초지촌리, 신포리, 원평리, 오탄리<NA>
83<NA>지촌초지암분교장지암리<NA>
84<NA>송화초고탄리, 고성리, 송암리, 인람리, 가일리<NA>
85북산면추곡초추곡리, 대동리, 대곡리, 추전리, 오항리, 부귀리, 조교리, 내평리<NA>
86<NA>상천초청평리<NA>
87<NA>천전초물로리<NA>
88홍천군 북방면조양초역전평리, 본궁리, 굴지리, 장항리<NA>
89<NA>광판초구만리, 원소리<NA>
90홍천군 서면광판초어유포리, 팔봉 1~2리<NA>
91화천군 하남면지촌초서오지리(1반)<NA>