Overview

Dataset statistics

Number of variables6
Number of observations24
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 KiB
Average record size in memory53.5 B

Variable types

Categorical3
Text3

Dataset

Description서울특별시성동광진교육지원청 관내(성동구, 광진구) 중학교의 설립, 행정구, 전화번호, 도로명주소등의 목록 제공
URLhttps://www.data.go.kr/data/15053917/fileData.do

Alerts

기관명 has constant value ""Constant
학교명 has unique valuesUnique
학교전화번호 has unique valuesUnique
도로명주소 has unique valuesUnique

Reproduction

Analysis started2023-12-12 23:50:14.299590
Analysis finished2023-12-12 23:50:14.724238
Duration0.42 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size324.0 B
중학교
24 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
중학교 24
100.0%

Length

2023-12-13T08:50:14.792579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:50:14.897465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
중학교 24
100.0%

학교명
Text

UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size324.0 B
2023-12-13T08:50:15.073496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length5
Mean length6.375
Min length5

Characters and Unicode

Total characters153
Distinct characters41
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

Unique24 ?
Unique (%)100.0%

Sample

1st row경수중학교
2nd row경일중학교
3rd row광남중학교
4th row광양중학교
5th row광장중학교
ValueCountFrequency (%)
경수중학교 1
 
4.2%
경일중학교 1
 
4.2%
선화예술중학교 1
 
4.2%
동국대학교사범대학부속여자중학교 1
 
4.2%
대원국제중학교 1
 
4.2%
건국대학교사범대학부속중학교 1
 
4.2%
행당중학교 1
 
4.2%
자양중학교 1
 
4.2%
용곡중학교 1
 
4.2%
옥정중학교 1
 
4.2%
Other values (14) 14
58.3%
2023-12-13T08:50:15.417804image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
학 31
20.3%
교 27
17.6%
중 24
15.7%
대 7
 
4.6%
광 5
 
3.3%
양 5
 
3.3%
국 3
 
2.0%
사 3
 
2.0%
범 3
 
2.0%
부 3
 
2.0%
Other values (31) 42
27.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 153
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
학 31
20.3%
교 27
17.6%
중 24
15.7%
대 7
 
4.6%
광 5
 
3.3%
양 5
 
3.3%
국 3
 
2.0%
사 3
 
2.0%
범 3
 
2.0%
부 3
 
2.0%
Other values (31) 42
27.5%

Most occurring scripts

ValueCountFrequency (%)
Hangul 153
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
학 31
20.3%
교 27
17.6%
중 24
15.7%
대 7
 
4.6%
광 5
 
3.3%
양 5
 
3.3%
국 3
 
2.0%
사 3
 
2.0%
범 3
 
2.0%
부 3
 
2.0%
Other values (31) 42
27.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 153
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
학 31
20.3%
교 27
17.6%
중 24
15.7%
대 7
 
4.6%
광 5
 
3.3%
양 5
 
3.3%
국 3
 
2.0%
사 3
 
2.0%
범 3
 
2.0%
부 3
 
2.0%
Other values (31) 42
27.5%

설립
Categorical

Distinct2
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size324.0 B
공립
19 
사립
5 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row공립
2nd row공립
3rd row공립
4th row공립
5th row공립

Common Values

ValueCountFrequency (%)
공립 19
79.2%
사립 5
 
20.8%

Length

2023-12-13T08:50:15.570688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:50:15.708824image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공립 19
79.2%
사립 5
 
20.8%

행정구
Categorical

Distinct2
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size324.0 B
광진구
13 
성동구
11 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row성동구
2nd row성동구
3rd row광진구
4th row광진구
5th row광진구

Common Values

ValueCountFrequency (%)
광진구 13
54.2%
성동구 11
45.8%

Length

2023-12-13T08:50:15.839249image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:50:15.948151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광진구 13
54.2%
성동구 11
45.8%

학교전화번호
Text

UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size324.0 B
2023-12-13T08:50:16.112186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11.5
Mean length11.5
Min length11

Characters and Unicode

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

Unique

Unique24 ?
Unique (%)100.0%

Sample

1st row02-464-0675
2nd row02-468-0651
3rd row02-456-8793
4th row02-452-6922
5th row02-452-0745
ValueCountFrequency (%)
02-464-0675 1
 
4.2%
02-468-0651 1
 
4.2%
02-2204-1102 1
 
4.2%
02-6948-2280 1
 
4.2%
02-2204-1592 1
 
4.2%
02-457-0318 1
 
4.2%
02-2292-2721 1
 
4.2%
02-446-0365 1
 
4.2%
02-452-2622 1
 
4.2%
02-2297-4604 1
 
4.2%
Other values (14) 14
58.3%
2023-12-13T08:50:16.402812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 64
23.2%
- 48
17.4%
0 46
16.7%
4 28
10.1%
6 18
 
6.5%
8 15
 
5.4%
5 13
 
4.7%
7 12
 
4.3%
1 12
 
4.3%
9 12
 
4.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 228
82.6%
Dash Punctuation 48
 
17.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 64
28.1%
0 46
20.2%
4 28
12.3%
6 18
 
7.9%
8 15
 
6.6%
5 13
 
5.7%
7 12
 
5.3%
1 12
 
5.3%
9 12
 
5.3%
3 8
 
3.5%
Dash Punctuation
ValueCountFrequency (%)
- 48
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 276
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 64
23.2%
- 48
17.4%
0 46
16.7%
4 28
10.1%
6 18
 
6.5%
8 15
 
5.4%
5 13
 
4.7%
7 12
 
4.3%
1 12
 
4.3%
9 12
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 276
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 64
23.2%
- 48
17.4%
0 46
16.7%
4 28
10.1%
6 18
 
6.5%
8 15
 
5.4%
5 13
 
4.7%
7 12
 
4.3%
1 12
 
4.3%
9 12
 
4.3%

도로명주소
Text

UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size324.0 B
2023-12-13T08:50:16.649017image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length21
Mean length19.5
Min length16

Characters and Unicode

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

Unique

Unique24 ?
Unique (%)100.0%

Sample

1st row서울특별시 성동구 뚝섬로 13길 14
2nd row서울특별시 성동구 성수일로 27
3rd row서울특별시 광진구 아차산로 70길 17-62 (광장동)
4th row서울특별시 광진구 자양로3길 7
5th row서울특별시 광진구 광장로1길1
ValueCountFrequency (%)
서울특별시 24
22.9%
광진구 13
 
12.4%
성동구 11
 
10.5%
22길 2
 
1.9%
뚝섬로 2
 
1.9%
자양동 2
 
1.9%
18 2
 
1.9%
마조로 2
 
1.9%
용마산로 2
 
1.9%
자양강변길73 1
 
1.0%
Other values (44) 44
41.9%
2023-12-13T08:50:17.004043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
81
17.3%
서 26
 
5.6%
울 25
 
5.3%
특 24
 
5.1%
별 24
 
5.1%
시 24
 
5.1%
구 24
 
5.1%
로 19
 
4.1%
길 18
 
3.8%
1 18
 
3.8%
Other values (52) 185
39.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 303
64.7%
Space Separator 81
 
17.3%
Decimal Number 78
 
16.7%
Close Punctuation 2
 
0.4%
Open Punctuation 2
 
0.4%
Dash Punctuation 2
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 26
 
8.6%
울 25
 
8.3%
특 24
 
7.9%
별 24
 
7.9%
시 24
 
7.9%
구 24
 
7.9%
로 19
 
6.3%
길 18
 
5.9%
광 17
 
5.6%
동 14
 
4.6%
Other values (38) 88
29.0%
Decimal Number
ValueCountFrequency (%)
1 18
23.1%
3 11
14.1%
2 11
14.1%
4 9
11.5%
6 9
11.5%
7 7
 
9.0%
0 4
 
5.1%
8 4
 
5.1%
5 3
 
3.8%
9 2
 
2.6%
Space Separator
ValueCountFrequency (%)
81
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 303
64.7%
Common 165
35.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 26
 
8.6%
울 25
 
8.3%
특 24
 
7.9%
별 24
 
7.9%
시 24
 
7.9%
구 24
 
7.9%
로 19
 
6.3%
길 18
 
5.9%
광 17
 
5.6%
동 14
 
4.6%
Other values (38) 88
29.0%
Common
ValueCountFrequency (%)
81
49.1%
1 18
 
10.9%
3 11
 
6.7%
2 11
 
6.7%
4 9
 
5.5%
6 9
 
5.5%
7 7
 
4.2%
0 4
 
2.4%
8 4
 
2.4%
5 3
 
1.8%
Other values (4) 8
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 303
64.7%
ASCII 165
35.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
81
49.1%
1 18
 
10.9%
3 11
 
6.7%
2 11
 
6.7%
4 9
 
5.5%
6 9
 
5.5%
7 7
 
4.2%
0 4
 
2.4%
8 4
 
2.4%
5 3
 
1.8%
Other values (4) 8
 
4.8%
Hangul
ValueCountFrequency (%)
서 26
 
8.6%
울 25
 
8.3%
특 24
 
7.9%
별 24
 
7.9%
시 24
 
7.9%
구 24
 
7.9%
로 19
 
6.3%
길 18
 
5.9%
광 17
 
5.6%
동 14
 
4.6%
Other values (38) 88
29.0%

Correlations

2023-12-13T08:50:17.107797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
학교명설립행정구학교전화번호도로명주소
학교명1.0001.0001.0001.0001.000
설립1.0001.0000.0001.0001.000
행정구1.0000.0001.0001.0001.000
학교전화번호1.0001.0001.0001.0001.000
도로명주소1.0001.0001.0001.0001.000
2023-12-13T08:50:17.228439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정구설립
행정구1.0000.000
설립0.0001.000
2023-12-13T08:50:17.321862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설립행정구
설립1.0000.000
행정구0.0001.000

Missing values

2023-12-13T08:50:14.569995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T08:50:14.677644image/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중학교경수중학교공립성동구02-464-0675서울특별시 성동구 뚝섬로 13길 14
1중학교경일중학교공립성동구02-468-0651서울특별시 성동구 성수일로 27
2중학교광남중학교공립광진구02-456-8793서울특별시 광진구 아차산로 70길 17-62 (광장동)
3중학교광양중학교공립광진구02-452-6922서울특별시 광진구 자양로3길 7
4중학교광장중학교공립광진구02-452-0745서울특별시 광진구 광장로1길1
5중학교광진중학교공립광진구02-447-2886서울특별시 광진구 뚝섬로64길 45
6중학교광희중학교공립성동구02-2298-0251서울특별시 성동구 독서당로62길 46
7중학교구의중학교공립광진구02-447-4798서울특별시 광진구 광나루로30길 80
8중학교동마중학교공립성동구02-2294-6086서울특별시 성동구 마조로 11길 18
9중학교마장중학교공립성동구02-2282-2933서울특별시 성동구 마장로 35나길 31
기관명학교명설립행정구학교전화번호도로명주소
14중학교양진중학교공립광진구02-2049-1200서울특별시 광진구 워커힐 길 32
15중학교옥정중학교공립성동구02-2297-4604서울특별시 성동구 한림말길 11
16중학교용곡중학교공립광진구02-452-2622서울특별시 광진구 용마산로 22길 76
17중학교자양중학교공립광진구02-446-0365서울특별시 광진구 뚝섬로 41길 33
18중학교행당중학교공립성동구02-2292-2721서울특별시 성동구 왕십리로 189
19중학교건국대학교사범대학부속중학교사립광진구02-457-0318서울특별시 광진구 자양동 자양로 145-1
20중학교대원국제중학교사립광진구02-2204-1592서울특별시 광진구 용마산로 22길 26
21중학교동국대학교사범대학부속여자중학교사립광진구02-6948-2280서울특별시 광진구 광나루로 36길47
22중학교선화예술중학교사립광진구02-2204-1102서울특별시 광진구 천호대로 664
23중학교한양대학교사범대학부속중학교사립성동구02-2200-3700서울특별시 성동구 마조로 42