Overview

Dataset statistics

Number of variables6
Number of observations48
Missing cells6
Missing cells (%)2.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.4 KiB
Average record size in memory51.8 B

Variable types

Numeric1
Categorical2
Text3

Dataset

Description서울특별시북부교육지원청 관내(노원구, 도봉구)의 학교·평생교육시설 현황 정보(학교명, 주소, 전화번호 등) 제공
Author서울특별시교육청 서울특별시북부교육지원청
URLhttps://www.data.go.kr/data/15100679/fileData.do

Alerts

연번 is highly overall correlated with 시설구분High correlation
시설구분 is highly overall correlated with 연번High correlation
전화번호 has 6 (12.5%) missing valuesMissing
연번 has unique valuesUnique
시설명칭 has unique valuesUnique
주소 has unique valuesUnique

Reproduction

Analysis started2023-12-12 05:32:29.540708
Analysis finished2023-12-12 05:32:30.234874
Duration0.69 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct48
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24.5
Minimum1
Maximum48
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size564.0 B
2023-12-12T14:32:30.329810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.35
Q112.75
median24.5
Q336.25
95-th percentile45.65
Maximum48
Range47
Interquartile range (IQR)23.5

Descriptive statistics

Standard deviation14
Coefficient of variation (CV)0.57142857
Kurtosis-1.2
Mean24.5
Median Absolute Deviation (MAD)12
Skewness0
Sum1176
Variance196
MonotonicityStrictly increasing
2023-12-12T14:32:30.531542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=48)
ValueCountFrequency (%)
1 1
 
2.1%
26 1
 
2.1%
28 1
 
2.1%
29 1
 
2.1%
30 1
 
2.1%
31 1
 
2.1%
32 1
 
2.1%
33 1
 
2.1%
34 1
 
2.1%
35 1
 
2.1%
Other values (38) 38
79.2%
ValueCountFrequency (%)
1 1
2.1%
2 1
2.1%
3 1
2.1%
4 1
2.1%
5 1
2.1%
6 1
2.1%
7 1
2.1%
8 1
2.1%
9 1
2.1%
10 1
2.1%
ValueCountFrequency (%)
48 1
2.1%
47 1
2.1%
46 1
2.1%
45 1
2.1%
44 1
2.1%
43 1
2.1%
42 1
2.1%
41 1
2.1%
40 1
2.1%
39 1
2.1%

시설구분
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)16.7%
Missing0
Missing (%)0.0%
Memory size516.0 B
언론기관부설 평생교육시설
14 
원격평생교육시설
13 
언론기관부설
사업장부설 평생교육시설
지식.인력개발사업관련 평생교육시설
Other values (3)

Length

Max length18
Median length13
Mean length10.354167
Min length6

Unique

Unique3 ?
Unique (%)6.2%

Sample

1st row사업장부설 평생교육시설
2nd row사업장부설 평생교육시설
3rd row사업장부설 평생교육시설
4th row사업장부설 평생교육시설
5th row사업장부설 평생교육시설

Common Values

ValueCountFrequency (%)
언론기관부설 평생교육시설 14
29.2%
원격평생교육시설 13
27.1%
언론기관부설 9
18.8%
사업장부설 평생교육시설 5
 
10.4%
지식.인력개발사업관련 평생교육시설 4
 
8.3%
학교부설 평생교육시설 1
 
2.1%
시민사회단체부설 1
 
2.1%
원격대학형태 1
 
2.1%

Length

2023-12-12T14:32:30.696993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:32:30.842875image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
평생교육시설 24
33.3%
언론기관부설 23
31.9%
원격평생교육시설 13
18.1%
사업장부설 5
 
6.9%
지식.인력개발사업관련 4
 
5.6%
학교부설 1
 
1.4%
시민사회단체부설 1
 
1.4%
원격대학형태 1
 
1.4%

시설명칭
Text

UNIQUE 

Distinct48
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size516.0 B
2023-12-12T14:32:31.081528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length16
Mean length12.979167
Min length7

Characters and Unicode

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

Unique

Unique48 ?
Unique (%)100.0%

Sample

1st row롯데마트문화센터중계점평생교육시설
2nd row롯데백화점 노원점 문화센터
3rd row컬처클럽 월계점
4th row홈플러스문화센터방학점
5th row홈플러스문화센터중계점
ValueCountFrequency (%)
평생교육원 21
 
22.8%
필라테스 4
 
4.3%
중계점 2
 
2.2%
화랑대점 2
 
2.2%
창동점 2
 
2.2%
원격평생교육원 2
 
2.2%
롯데마트문화센터중계점평생교육시설 1
 
1.1%
한국필라테스협회 1
 
1.1%
아이보람창동 1
 
1.1%
송석평생교육원 1
 
1.1%
Other values (55) 55
59.8%
2023-12-12T14:32:31.541332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
52
 
8.3%
44
 
7.1%
44
 
7.1%
42
 
6.7%
41
 
6.6%
40
 
6.4%
22
 
3.5%
19
 
3.0%
17
 
2.7%
16
 
2.6%
Other values (143) 286
45.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 564
90.5%
Space Separator 44
 
7.1%
Lowercase Letter 7
 
1.1%
Uppercase Letter 4
 
0.6%
Other Punctuation 2
 
0.3%
Decimal Number 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
52
 
9.2%
44
 
7.8%
42
 
7.4%
41
 
7.3%
40
 
7.1%
22
 
3.9%
19
 
3.4%
17
 
3.0%
16
 
2.8%
16
 
2.8%
Other values (129) 255
45.2%
Lowercase Letter
ValueCountFrequency (%)
n 2
28.6%
d 1
14.3%
t 1
14.3%
o 1
14.3%
p 1
14.3%
i 1
14.3%
Uppercase Letter
ValueCountFrequency (%)
E 1
25.0%
H 1
25.0%
C 1
25.0%
W 1
25.0%
Decimal Number
ValueCountFrequency (%)
0 1
50.0%
8 1
50.0%
Space Separator
ValueCountFrequency (%)
44
100.0%
Other Punctuation
ValueCountFrequency (%)
& 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 564
90.5%
Common 48
 
7.7%
Latin 11
 
1.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
52
 
9.2%
44
 
7.8%
42
 
7.4%
41
 
7.3%
40
 
7.1%
22
 
3.9%
19
 
3.4%
17
 
3.0%
16
 
2.8%
16
 
2.8%
Other values (129) 255
45.2%
Latin
ValueCountFrequency (%)
n 2
18.2%
E 1
9.1%
d 1
9.1%
t 1
9.1%
o 1
9.1%
p 1
9.1%
i 1
9.1%
H 1
9.1%
C 1
9.1%
W 1
9.1%
Common
ValueCountFrequency (%)
44
91.7%
& 2
 
4.2%
0 1
 
2.1%
8 1
 
2.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 564
90.5%
ASCII 59
 
9.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
52
 
9.2%
44
 
7.8%
42
 
7.4%
41
 
7.3%
40
 
7.1%
22
 
3.9%
19
 
3.4%
17
 
3.0%
16
 
2.8%
16
 
2.8%
Other values (129) 255
45.2%
ASCII
ValueCountFrequency (%)
44
74.6%
n 2
 
3.4%
& 2
 
3.4%
E 1
 
1.7%
d 1
 
1.7%
t 1
 
1.7%
o 1
 
1.7%
p 1
 
1.7%
i 1
 
1.7%
0 1
 
1.7%
Other values (4) 4
 
6.8%

지역구
Categorical

Distinct3
Distinct (%)6.2%
Missing0
Missing (%)0.0%
Memory size516.0 B
노원구
29 
도봉구
18 
노원구
 
1

Length

Max length4
Median length3
Mean length3.0208333
Min length3

Unique

Unique1 ?
Unique (%)2.1%

Sample

1st row노원구
2nd row노원구
3rd row노원구
4th row도봉구
5th row노원구

Common Values

ValueCountFrequency (%)
노원구 29
60.4%
도봉구 18
37.5%
노원구 1
 
2.1%

Length

2023-12-12T14:32:31.711196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:32:31.844693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
노원구 30
62.5%
도봉구 18
37.5%

주소
Text

UNIQUE 

Distinct48
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size516.0 B
2023-12-12T14:32:32.188515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length61
Median length40
Mean length35.791667
Min length23

Characters and Unicode

Total characters1718
Distinct characters149
Distinct categories10 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique48 ?
Unique (%)100.0%

Sample

1st row서울특별시 노원구 노원로 330, 롯데마트중계점 지층일부 (중계동)
2nd row서울특별시 노원구 동일로 1414 , 6층 일부(노원역환승센터) (상계동)
3rd row서울특별시 노원구 마들로3길 15, 월계이마트 2층일부 (월계동)
4th row서울특별시 도봉구 도봉로 678, 홈플러스테스코 방학점 2층일부 (방학동)
5th row서울특별시 노원구 동일로204가길 12, 홈플러스테스코 중계점 2층일부 (중계동)
ValueCountFrequency (%)
서울특별시 47
 
14.0%
노원구 30
 
9.0%
도봉구 18
 
5.4%
일부 15
 
4.5%
동일로 7
 
2.1%
2층 5
 
1.5%
5
 
1.5%
3층 4
 
1.2%
2층일부 4
 
1.2%
4층 4
 
1.2%
Other values (161) 196
58.5%
2023-12-12T14:32:32.781331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
295
 
17.2%
, 66
 
3.8%
1 52
 
3.0%
51
 
3.0%
51
 
3.0%
50
 
2.9%
2 49
 
2.9%
48
 
2.8%
48
 
2.8%
47
 
2.7%
Other values (139) 961
55.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 997
58.0%
Space Separator 295
 
17.2%
Decimal Number 274
 
15.9%
Other Punctuation 66
 
3.8%
Open Punctuation 36
 
2.1%
Close Punctuation 36
 
2.1%
Uppercase Letter 9
 
0.5%
Math Symbol 2
 
0.1%
Dash Punctuation 2
 
0.1%
Modifier Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
51
 
5.1%
51
 
5.1%
50
 
5.0%
48
 
4.8%
48
 
4.8%
47
 
4.7%
47
 
4.7%
47
 
4.7%
47
 
4.7%
42
 
4.2%
Other values (114) 519
52.1%
Decimal Number
ValueCountFrequency (%)
1 52
19.0%
2 49
17.9%
3 39
14.2%
0 32
11.7%
4 31
11.3%
5 25
9.1%
6 19
 
6.9%
7 11
 
4.0%
9 8
 
2.9%
8 8
 
2.9%
Uppercase Letter
ValueCountFrequency (%)
A 2
22.2%
G 1
11.1%
K 1
11.1%
I 1
11.1%
B 1
11.1%
N 1
11.1%
E 1
11.1%
S 1
11.1%
Space Separator
ValueCountFrequency (%)
295
100.0%
Other Punctuation
ValueCountFrequency (%)
, 66
100.0%
Open Punctuation
ValueCountFrequency (%)
( 36
100.0%
Close Punctuation
ValueCountFrequency (%)
) 36
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 997
58.0%
Common 712
41.4%
Latin 9
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
51
 
5.1%
51
 
5.1%
50
 
5.0%
48
 
4.8%
48
 
4.8%
47
 
4.7%
47
 
4.7%
47
 
4.7%
47
 
4.7%
42
 
4.2%
Other values (114) 519
52.1%
Common
ValueCountFrequency (%)
295
41.4%
, 66
 
9.3%
1 52
 
7.3%
2 49
 
6.9%
3 39
 
5.5%
( 36
 
5.1%
) 36
 
5.1%
0 32
 
4.5%
4 31
 
4.4%
5 25
 
3.5%
Other values (7) 51
 
7.2%
Latin
ValueCountFrequency (%)
A 2
22.2%
G 1
11.1%
K 1
11.1%
I 1
11.1%
B 1
11.1%
N 1
11.1%
E 1
11.1%
S 1
11.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 997
58.0%
ASCII 721
42.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
295
40.9%
, 66
 
9.2%
1 52
 
7.2%
2 49
 
6.8%
3 39
 
5.4%
( 36
 
5.0%
) 36
 
5.0%
0 32
 
4.4%
4 31
 
4.3%
5 25
 
3.5%
Other values (15) 60
 
8.3%
Hangul
ValueCountFrequency (%)
51
 
5.1%
51
 
5.1%
50
 
5.0%
48
 
4.8%
48
 
4.8%
47
 
4.7%
47
 
4.7%
47
 
4.7%
47
 
4.7%
42
 
4.2%
Other values (114) 519
52.1%

전화번호
Text

MISSING 

Distinct42
Distinct (%)100.0%
Missing6
Missing (%)12.5%
Memory size516.0 B
2023-12-12T14:32:33.041275image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length13.5
Mean length11.714286
Min length9

Characters and Unicode

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

Unique

Unique42 ?
Unique (%)100.0%

Sample

1st row02-2092-2590
2nd row02-950-2814~5
3rd row02-2092-1250
4th row02-956-2033
5th row02-978-2032
ValueCountFrequency (%)
02-6959-2589 1
 
2.4%
02-455-7789 1
 
2.4%
02-6954-0150 1
 
2.4%
0507-1402-5072 1
 
2.4%
02-944-6000 1
 
2.4%
02-954-0203 1
 
2.4%
02-908-8919 1
 
2.4%
02-2268-8685 1
 
2.4%
02-905-1880 1
 
2.4%
02-2038-3380 1
 
2.4%
Other values (32) 32
76.2%
2023-12-12T14:32:33.424789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 90
18.3%
- 82
16.7%
2 69
14.0%
9 50
10.2%
5 40
8.1%
1 35
 
7.1%
7 32
 
6.5%
8 26
 
5.3%
3 26
 
5.3%
4 24
 
4.9%
Other values (2) 18
 
3.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 409
83.1%
Dash Punctuation 82
 
16.7%
Math Symbol 1
 
0.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 90
22.0%
2 69
16.9%
9 50
12.2%
5 40
9.8%
1 35
 
8.6%
7 32
 
7.8%
8 26
 
6.4%
3 26
 
6.4%
4 24
 
5.9%
6 17
 
4.2%
Dash Punctuation
ValueCountFrequency (%)
- 82
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 492
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 90
18.3%
- 82
16.7%
2 69
14.0%
9 50
10.2%
5 40
8.1%
1 35
 
7.1%
7 32
 
6.5%
8 26
 
5.3%
3 26
 
5.3%
4 24
 
4.9%
Other values (2) 18
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 492
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 90
18.3%
- 82
16.7%
2 69
14.0%
9 50
10.2%
5 40
8.1%
1 35
 
7.1%
7 32
 
6.5%
8 26
 
5.3%
3 26
 
5.3%
4 24
 
4.9%
Other values (2) 18
 
3.7%

Interactions

2023-12-12T14:32:29.927264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T14:32:33.537076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번시설구분시설명칭지역구주소전화번호
연번1.0000.8501.0000.0001.0001.000
시설구분0.8501.0001.0000.0001.0001.000
시설명칭1.0001.0001.0001.0001.0001.000
지역구0.0000.0001.0001.0001.0001.000
주소1.0001.0001.0001.0001.0001.000
전화번호1.0001.0001.0001.0001.0001.000
2023-12-12T14:32:33.641324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지역구시설구분
지역구1.0000.000
시설구분0.0001.000
2023-12-12T14:32:33.773047image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번시설구분지역구
연번1.0000.6100.000
시설구분0.6101.0000.000
지역구0.0000.0001.000

Missing values

2023-12-12T14:32:30.064861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T14:32:30.188441image/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

연번시설구분시설명칭지역구주소전화번호
01사업장부설 평생교육시설롯데마트문화센터중계점평생교육시설노원구서울특별시 노원구 노원로 330, 롯데마트중계점 지층일부 (중계동)02-2092-2590
12사업장부설 평생교육시설롯데백화점 노원점 문화센터노원구서울특별시 노원구 동일로 1414 , 6층 일부(노원역환승센터) (상계동)02-950-2814~5
23사업장부설 평생교육시설컬처클럽 월계점노원구서울특별시 노원구 마들로3길 15, 월계이마트 2층일부 (월계동)02-2092-1250
34사업장부설 평생교육시설홈플러스문화센터방학점도봉구서울특별시 도봉구 도봉로 678, 홈플러스테스코 방학점 2층일부 (방학동)02-956-2033
45사업장부설 평생교육시설홈플러스문화센터중계점노원구서울특별시 노원구 동일로204가길 12, 홈플러스테스코 중계점 2층일부 (중계동)02-978-2032
56학교부설 평생교육시설청암예술학교부설평생교육시설노원구서울특별시 노원구 중계로 244, 강의동 지하1층 일부(중계동, 청암예술학교)02-951-4772
67시민사회단체부설밸런스워팅피티평생교육원도봉구서울특별시 도봉구 노해로 162 , 2층 일부 (쌍문동)<NA>
78언론기관부설 평생교육시설H&C 평생교육원노원구서울특별시 노원구 중계로18길 9, 503호일부(중계동, 에덴프라자)1588-3149
89언론기관부설 평생교육시설누리비젼평생교육원노원구서울특별시 노원구 덕릉로 773, 5층일부(상계동)070-7715-2363
910언론기관부설 평생교육시설바디멀티기구 필라테스 평생교육원도봉구서울시 도봉구 도봉로150길 43, 20`~203호(방학동,ESA아파트)02-954-5412
연번시설구분시설명칭지역구주소전화번호
3839원격평생교육시설반려동물산업기술원 원격평생교육원도봉구서울특별시 도봉구 방학로2길 44, 1층(방학동, 보성빌딩)02-455-7789
3940원격평생교육시설비베스트원격평생교육원도봉구서울특별시 도봉구 도봉로 150다길 28, 상가202호 일부(방학동, 방학지음재힐스)02-6004-5025
4041원격평생교육시설삼육대학교원격평생교육원노원구서울특별시 노원구 화랑로 815, 삼육대학교 제1실습관 1층일부, 에스라관 2층일부, 도서관 지층일부(공릉동)02-3399-2070
4142원격평생교육시설심리상담기술원 원격평생교육원도봉구서울특별시 도봉구 방학로2길 44, 2층(방학동, 보성빌딩)02-455-1752
4243원격평생교육시설클린트 잉글리쉬도봉구서울특별시 도봉구 방학로192, 2층 일부070-8064-3668
4344원격평생교육시설킴아카원격평생교육원노원구서울특별시 노원구 중계로 90, 204호 (중계동)02-937-3981
4445원격평생교육시설파워잉글리쉬원격평생교육시설노원구서울특별시 노원구 한글비석로 245, 중계 두타빌 에이동 203호1688-8672
4546원격평생교육시설한국자격평가원노원구서울특별시 노원구 동일로173가길 31, 2층(공릉동, 플러스빌)02-6959-8700
4647원격평생교육시설영파고원격평생교육원도봉구서울특별시 도봉구 노해로67길 2, 한국빌딩B2 일부02-996-4541
4748원격대학형태이지탑에듀 평생교육시설노원구서울특별시 노원구 동일로 1368, 롯데프라자빌딩 5층 504-A호02-954-5571