Overview

Dataset statistics

Number of variables3
Number of observations22
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory682.0 B
Average record size in memory31.0 B

Variable types

Text2
Numeric1

Dataset

Description서울특별시 관악구 어린이들의 교통안전시설 옐로카펫(어린이횡단보도 대기소 ) 설치 현황(설치위치, 옐로우 카페트 설치연도 등)
URLhttps://www.data.go.kr/data/15034506/fileData.do

Reproduction

Analysis started2023-12-12 06:28:21.516910
Analysis finished2023-12-12 06:28:22.208467
Duration0.69 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct21
Distinct (%)95.5%
Missing0
Missing (%)0.0%
Memory size308.0 B
2023-12-12T15:28:22.371419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length21
Mean length13.045455
Min length6

Characters and Unicode

Total characters287
Distinct characters75
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

Unique20 ?
Unique (%)90.9%

Sample

1st row신우초등학교
2nd row청룡초등학교
3rd row미성초등학교 학교정문 맞은편
4th row미성초교 (라이프아파트 입구)
5th row봉현초등학교(학교정문앞 횡단도보)
ValueCountFrequency (%)
맞은편 4
 
9.3%
구암초등학교 2
 
4.7%
미성초등학교 2
 
4.7%
학교정문 2
 
4.7%
2
 
4.7%
미성초등학교(문성로92 2
 
4.7%
관악구민종합체육센터 1
 
2.3%
봉현초교 1
 
2.3%
동아아파트 1
 
2.3%
106동앞 1
 
2.3%
Other values (25) 25
58.1%
2023-12-12T15:28:22.771136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
24
 
8.4%
23
 
8.0%
21
 
7.3%
20
 
7.0%
17
 
5.9%
) 10
 
3.5%
( 10
 
3.5%
9
 
3.1%
8
 
2.8%
7
 
2.4%
Other values (65) 138
48.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 222
77.4%
Space Separator 23
 
8.0%
Decimal Number 21
 
7.3%
Close Punctuation 10
 
3.5%
Open Punctuation 10
 
3.5%
Math Symbol 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
24
 
10.8%
21
 
9.5%
20
 
9.0%
17
 
7.7%
9
 
4.1%
8
 
3.6%
7
 
3.2%
6
 
2.7%
6
 
2.7%
5
 
2.3%
Other values (53) 99
44.6%
Decimal Number
ValueCountFrequency (%)
1 7
33.3%
0 4
19.0%
9 3
14.3%
2 3
14.3%
4 1
 
4.8%
7 1
 
4.8%
6 1
 
4.8%
8 1
 
4.8%
Space Separator
ValueCountFrequency (%)
23
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Math Symbol
ValueCountFrequency (%)
+ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 222
77.4%
Common 65
 
22.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
24
 
10.8%
21
 
9.5%
20
 
9.0%
17
 
7.7%
9
 
4.1%
8
 
3.6%
7
 
3.2%
6
 
2.7%
6
 
2.7%
5
 
2.3%
Other values (53) 99
44.6%
Common
ValueCountFrequency (%)
23
35.4%
) 10
15.4%
( 10
15.4%
1 7
 
10.8%
0 4
 
6.2%
9 3
 
4.6%
2 3
 
4.6%
4 1
 
1.5%
7 1
 
1.5%
6 1
 
1.5%
Other values (2) 2
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 222
77.4%
ASCII 65
 
22.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
24
 
10.8%
21
 
9.5%
20
 
9.0%
17
 
7.7%
9
 
4.1%
8
 
3.6%
7
 
3.2%
6
 
2.7%
6
 
2.7%
5
 
2.3%
Other values (53) 99
44.6%
ASCII
ValueCountFrequency (%)
23
35.4%
) 10
15.4%
( 10
15.4%
1 7
 
10.8%
0 4
 
6.2%
9 3
 
4.6%
2 3
 
4.6%
4 1
 
1.5%
7 1
 
1.5%
6 1
 
1.5%
Other values (2) 2
 
3.1%
Distinct17
Distinct (%)77.3%
Missing0
Missing (%)0.0%
Memory size308.0 B
2023-12-12T15:28:23.024245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length19
Mean length17.136364
Min length15

Characters and Unicode

Total characters377
Distinct characters39
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

Unique14 ?
Unique (%)63.6%

Sample

1st row서울특별시 관악구 호암로 498
2nd row서울특별시 관악구 관악로5길 61
3rd row서울특별시 관악구 문성로 79
4th row서울특별시 관악구 문성로 82
5th row서울특별시 관악구 성현로 117
ValueCountFrequency (%)
서울특별시 22
25.0%
관악구 22
25.0%
문성로 6
 
6.8%
성현로 5
 
5.7%
117 5
 
5.7%
구암길 2
 
2.3%
1 2
 
2.3%
92 2
 
2.3%
79 2
 
2.3%
37 1
 
1.1%
Other values (19) 19
21.6%
2023-12-12T15:28:23.454109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
76
20.2%
24
 
6.4%
23
 
6.1%
23
 
6.1%
22
 
5.8%
22
 
5.8%
22
 
5.8%
22
 
5.8%
22
 
5.8%
17
 
4.5%
Other values (29) 104
27.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 247
65.5%
Space Separator 76
 
20.2%
Decimal Number 54
 
14.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
24
9.7%
23
9.3%
23
9.3%
22
8.9%
22
8.9%
22
8.9%
22
8.9%
22
8.9%
17
6.9%
12
 
4.9%
Other values (18) 38
15.4%
Decimal Number
ValueCountFrequency (%)
1 17
31.5%
7 11
20.4%
9 7
13.0%
3 4
 
7.4%
5 4
 
7.4%
2 4
 
7.4%
8 2
 
3.7%
6 2
 
3.7%
4 2
 
3.7%
0 1
 
1.9%
Space Separator
ValueCountFrequency (%)
76
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 247
65.5%
Common 130
34.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
24
9.7%
23
9.3%
23
9.3%
22
8.9%
22
8.9%
22
8.9%
22
8.9%
22
8.9%
17
6.9%
12
 
4.9%
Other values (18) 38
15.4%
Common
ValueCountFrequency (%)
76
58.5%
1 17
 
13.1%
7 11
 
8.5%
9 7
 
5.4%
3 4
 
3.1%
5 4
 
3.1%
2 4
 
3.1%
8 2
 
1.5%
6 2
 
1.5%
4 2
 
1.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 247
65.5%
ASCII 130
34.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
76
58.5%
1 17
 
13.1%
7 11
 
8.5%
9 7
 
5.4%
3 4
 
3.1%
5 4
 
3.1%
2 4
 
3.1%
8 2
 
1.5%
6 2
 
1.5%
4 2
 
1.5%
Hangul
ValueCountFrequency (%)
24
9.7%
23
9.3%
23
9.3%
22
8.9%
22
8.9%
22
8.9%
22
8.9%
22
8.9%
17
6.9%
12
 
4.9%
Other values (18) 38
15.4%

설치연도
Real number (ℝ)

Distinct6
Distinct (%)27.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2018.2727
Minimum2015
Maximum2023
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size330.0 B
2023-12-12T15:28:23.634035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2015
5-th percentile2016.05
Q12017
median2017
Q32018
95-th percentile2023
Maximum2023
Range8
Interquartile range (IQR)1

Descriptive statistics

Standard deviation2.4138848
Coefficient of variation (CV)0.0011960152
Kurtosis0.56272229
Mean2018.2727
Median Absolute Deviation (MAD)1
Skewness1.3236941
Sum44402
Variance5.8268398
MonotonicityIncreasing
2023-12-12T15:28:23.777592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
2017 10
45.5%
2018 5
22.7%
2023 4
 
18.2%
2015 1
 
4.5%
2016 1
 
4.5%
2019 1
 
4.5%
ValueCountFrequency (%)
2015 1
 
4.5%
2016 1
 
4.5%
2017 10
45.5%
2018 5
22.7%
2019 1
 
4.5%
2023 4
 
18.2%
ValueCountFrequency (%)
2023 4
 
18.2%
2019 1
 
4.5%
2018 5
22.7%
2017 10
45.5%
2016 1
 
4.5%
2015 1
 
4.5%

Interactions

2023-12-12T15:28:21.652683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T15:28:23.901507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치위치도로명주소설치연도
설치위치1.0001.0000.000
도로명주소1.0001.0000.751
설치연도0.0000.7511.000

Missing values

2023-12-12T15:28:22.103614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T15:28:22.178787image/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신우초등학교서울특별시 관악구 호암로 4982015
1청룡초등학교서울특별시 관악구 관악로5길 612016
2미성초등학교 학교정문 맞은편서울특별시 관악구 문성로 792017
3미성초교 (라이프아파트 입구)서울특별시 관악구 문성로 822017
4봉현초등학교(학교정문앞 횡단도보)서울특별시 관악구 성현로 1172017
5봉현초등학교(입구삼거리 104동 맞은편)서울특별시 관악구 성현로 1172017
6구암초등학교서울특별시 관악구 구암길 12017
7조원초등학교서울특별시 관악구 조원로 672017
8난곡초등학교서울특별시 관악구 난곡로35길 1022017
9원신초등학교(입구 삼거리)서울특별시 관악구 광신길 1772017
설치위치도로명주소설치연도
12사당초등학교 학교북문 앞서울특별시 관악구 남현4길 512018
13봉현초교 (학교정문 맞은편+ 동아아파트 106동앞)서울특별시 관악구 성현로 1172018
14봉현초교(107동 앞)서울특별시 관악구 성현로 1172018
15관악노인종합복지관1서울특별시 관악구 보라매로 352018
16관악구민종합체육센터서울특별시 관악구 낙성대로3길 372018
17구암초등학교서울특별시 관악구 구암길 12019
18미성초등학교 정문앞서울특별시 관악구 문성로 792023
19미성초등학교(문성로92 대주수산앞1)서울특별시 관악구 문성로 922023
20미성초등학교(문성로92 대주수산앞2)서울특별시 관악구 문성로 922023
21미성초등학교(문성로 91 산일자원)서울특별시 관악구 문성로 912023