Overview

Dataset statistics

Number of variables6
Number of observations21
Missing cells20
Missing cells (%)15.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.2 KiB
Average record size in memory56.3 B

Variable types

Numeric1
Categorical2
Text3

Dataset

Description서울시 영등포구 관내 바닥형 보행신호등 설치현황에 대한 데이터로 시설물 위차, 설치 주소, 설치년월 등의 정보를 제공합니다.
Author서울특별시 영등포구
URLhttps://www.data.go.kr/data/15066011/fileData.do

Alerts

자치구 has constant value ""Constant
비고 has constant value ""Constant
비고 has 20 (95.2%) missing valuesMissing
연번 has unique valuesUnique
주소 has unique valuesUnique

Reproduction

Analysis started2023-12-12 14:18:15.186189
Analysis finished2023-12-12 14:18:15.713377
Duration0.53 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct21
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11
Minimum1
Maximum21
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size321.0 B
2023-12-12T23:18:15.788959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q16
median11
Q316
95-th percentile20
Maximum21
Range20
Interquartile range (IQR)10

Descriptive statistics

Standard deviation6.2048368
Coefficient of variation (CV)0.56407607
Kurtosis-1.2
Mean11
Median Absolute Deviation (MAD)5
Skewness0
Sum231
Variance38.5
MonotonicityStrictly increasing
2023-12-12T23:18:15.979358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
1 1
 
4.8%
2 1
 
4.8%
21 1
 
4.8%
20 1
 
4.8%
19 1
 
4.8%
18 1
 
4.8%
17 1
 
4.8%
16 1
 
4.8%
15 1
 
4.8%
14 1
 
4.8%
Other values (11) 11
52.4%
ValueCountFrequency (%)
1 1
4.8%
2 1
4.8%
3 1
4.8%
4 1
4.8%
5 1
4.8%
6 1
4.8%
7 1
4.8%
8 1
4.8%
9 1
4.8%
10 1
4.8%
ValueCountFrequency (%)
21 1
4.8%
20 1
4.8%
19 1
4.8%
18 1
4.8%
17 1
4.8%
16 1
4.8%
15 1
4.8%
14 1
4.8%
13 1
4.8%
12 1
4.8%

자치구
Categorical

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
영등포
21 

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 (%)
영등포 21
100.0%

Length

2023-12-12T23:18:16.142100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:18:16.293996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영등포 21
100.0%

시설물위치명
Text

Distinct20
Distinct (%)95.2%
Missing0
Missing (%)0.0%
Memory size300.0 B
2023-12-12T23:18:16.467445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length4
Mean length4.2380952
Min length4

Characters and Unicode

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

Unique

Unique19 ?
Unique (%)90.5%

Sample

1st row여의도초교
2nd row영신초교
3rd row대방초교
4th row대길초교
5th row신대림초교
ValueCountFrequency (%)
당중초교 2
 
9.1%
선유초교 1
 
4.5%
홍우빌딩 1
 
4.5%
영신초교 1
 
4.5%
우신초교 1
 
4.5%
윤중초교 1
 
4.5%
영중초교 1
 
4.5%
영동초교 1
 
4.5%
당산초교 1
 
4.5%
당서초교 1
 
4.5%
Other values (11) 11
50.0%
2023-12-12T23:18:16.768044image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
초 20
22.5%
교 20
22.5%
영 7
 
7.9%
신 5
 
5.6%
당 4
 
4.5%
대 4
 
4.5%
중 4
 
4.5%
문 2
 
2.2%
도 2
 
2.2%
우 2
 
2.2%
Other values (19) 19
21.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 88
98.9%
Space Separator 1
 
1.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
초 20
22.7%
교 20
22.7%
영 7
 
8.0%
신 5
 
5.7%
당 4
 
4.5%
대 4
 
4.5%
중 4
 
4.5%
문 2
 
2.3%
도 2
 
2.3%
우 2
 
2.3%
Other values (18) 18
20.5%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 88
98.9%
Common 1
 
1.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
초 20
22.7%
교 20
22.7%
영 7
 
8.0%
신 5
 
5.7%
당 4
 
4.5%
대 4
 
4.5%
중 4
 
4.5%
문 2
 
2.3%
도 2
 
2.3%
우 2
 
2.3%
Other values (18) 18
20.5%
Common
ValueCountFrequency (%)
1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 88
98.9%
ASCII 1
 
1.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
초 20
22.7%
교 20
22.7%
영 7
 
8.0%
신 5
 
5.7%
당 4
 
4.5%
대 4
 
4.5%
중 4
 
4.5%
문 2
 
2.3%
도 2
 
2.3%
우 2
 
2.3%
Other values (18) 18
20.5%
ASCII
ValueCountFrequency (%)
1
100.0%

주소
Text

UNIQUE 

Distinct21
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size300.0 B
2023-12-12T23:18:17.005663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length16
Mean length14.333333
Min length11

Characters and Unicode

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

Unique

Unique21 ?
Unique (%)100.0%

Sample

1st row영등포구 여의대방로 439
2nd row영등포구 도신로60길 23
3rd row영등포구 여의대방로35길 14
4th row영등포구 대방천로 206
5th row영등포구 대림로8길 25
ValueCountFrequency (%)
영등포구 19
28.8%
14 3
 
4.5%
문래로 2
 
3.0%
32 2
 
3.0%
횡단보도 2
 
3.0%
당중초~롯데마트 2
 
3.0%
하단 1
 
1.5%
선유로55길 1
 
1.5%
상단 1
 
1.5%
선유로43가길 1
 
1.5%
Other values (32) 32
48.5%
2023-12-12T23:18:17.392218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
45
 
15.0%
영 19
 
6.3%
로 19
 
6.3%
등 19
 
6.3%
구 19
 
6.3%
포 19
 
6.3%
3 11
 
3.7%
길 11
 
3.7%
5 9
 
3.0%
2 9
 
3.0%
Other values (58) 121
40.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 193
64.1%
Decimal Number 60
 
19.9%
Space Separator 45
 
15.0%
Math Symbol 2
 
0.7%
Dash Punctuation 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
영 19
 
9.8%
로 19
 
9.8%
등 19
 
9.8%
구 19
 
9.8%
포 19
 
9.8%
길 11
 
5.7%
도 5
 
2.6%
대 5
 
2.6%
단 4
 
2.1%
당 3
 
1.6%
Other values (45) 70
36.3%
Decimal Number
ValueCountFrequency (%)
3 11
18.3%
5 9
15.0%
2 9
15.0%
4 8
13.3%
1 6
10.0%
6 4
 
6.7%
0 4
 
6.7%
8 4
 
6.7%
7 3
 
5.0%
9 2
 
3.3%
Space Separator
ValueCountFrequency (%)
45
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 193
64.1%
Common 108
35.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
영 19
 
9.8%
로 19
 
9.8%
등 19
 
9.8%
구 19
 
9.8%
포 19
 
9.8%
길 11
 
5.7%
도 5
 
2.6%
대 5
 
2.6%
단 4
 
2.1%
당 3
 
1.6%
Other values (45) 70
36.3%
Common
ValueCountFrequency (%)
45
41.7%
3 11
 
10.2%
5 9
 
8.3%
2 9
 
8.3%
4 8
 
7.4%
1 6
 
5.6%
6 4
 
3.7%
0 4
 
3.7%
8 4
 
3.7%
7 3
 
2.8%
Other values (3) 5
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 193
64.1%
ASCII 108
35.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
45
41.7%
3 11
 
10.2%
5 9
 
8.3%
2 9
 
8.3%
4 8
 
7.4%
1 6
 
5.6%
6 4
 
3.7%
0 4
 
3.7%
8 4
 
3.7%
7 3
 
2.8%
Other values (3) 5
 
4.6%
Hangul
ValueCountFrequency (%)
영 19
 
9.8%
로 19
 
9.8%
등 19
 
9.8%
구 19
 
9.8%
포 19
 
9.8%
길 11
 
5.7%
도 5
 
2.6%
대 5
 
2.6%
단 4
 
2.1%
당 3
 
1.6%
Other values (45) 70
36.3%

설치년월
Categorical

Distinct3
Distinct (%)14.3%
Missing0
Missing (%)0.0%
Memory size300.0 B
2020.07
17 
2020.12
3 
2019.12
 
1

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique1 ?
Unique (%)4.8%

Sample

1st row2019.12
2nd row2020.07
3rd row2020.07
4th row2020.07
5th row2020.07

Common Values

ValueCountFrequency (%)
2020.07 17
81.0%
2020.12 3
 
14.3%
2019.12 1
 
4.8%

Length

2023-12-12T23:18:17.577735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:18:17.699960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020.07 17
81.0%
2020.12 3
 
14.3%
2019.12 1
 
4.8%

비고
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing20
Missing (%)95.2%
Memory size300.0 B
2023-12-12T23:18:17.833191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length4
Mean length4
Min length4

Characters and Unicode

Total characters4
Distinct characters4
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

Unique1 ?
Unique (%)100.0%

Sample

1st row시범설치
ValueCountFrequency (%)
시범설치 1
100.0%
2023-12-12T23:18:18.130995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
시 1
25.0%
범 1
25.0%
설 1
25.0%
치 1
25.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 1
25.0%
범 1
25.0%
설 1
25.0%
치 1
25.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 1
25.0%
범 1
25.0%
설 1
25.0%
치 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
시 1
25.0%
범 1
25.0%
설 1
25.0%
치 1
25.0%

Interactions

2023-12-12T23:18:15.399439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:18:18.214197image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번시설물위치명주소설치년월
연번1.0000.9691.0000.828
시설물위치명0.9691.0001.0000.000
주소1.0001.0001.0001.000
설치년월0.8280.0001.0001.000
2023-12-12T23:18:18.300095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설치년월
연번1.0000.332
설치년월0.3321.000

Missing values

2023-12-12T23:18:15.522389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:18:15.671045image/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영등포여의도초교영등포구 여의대방로 4392019.12시범설치
12영등포영신초교영등포구 도신로60길 232020.07<NA>
23영등포대방초교영등포구 여의대방로35길 142020.07<NA>
34영등포대길초교영등포구 대방천로 2062020.07<NA>
45영등포신대림초교영등포구 대림로8길 252020.07<NA>
56영등포대영초교영등포구 신길로23길 432020.07<NA>
67영등포도신초교영등포구 도림로53길 32-92020.07<NA>
78영등포신영초교영등포구 도신로4길 322020.07<NA>
89영등포영등포초교영등포구 경인로 7562020.07<NA>
910영등포문래초교영등포구 문래로 1042020.07<NA>
연번자치구시설물위치명주소설치년월비고
1112영등포당중초교당중초~롯데마트 횡단보도 상단2020.07<NA>
1213영등포선유초교영등포구 선유로43가길 142020.07<NA>
1314영등포당서초교영등포구 당산로 1872020.07<NA>
1415영등포당산초교영등포구 선유로55길 322020.07<NA>
1516영등포영동초교영등포구 국회대로53길 202020.07<NA>
1617영등포영중초교영등포구 양산로 1852020.07<NA>
1718영등포윤중초교영등포구 여의나루로2길 142020.07<NA>
1819영등포우신초교영등포구 사러가시장앞 교차로 동측2020.12<NA>
1920영등포당중초교당중초~롯데마트 횡단보도 하단2020.12<NA>
2021영등포홍우빌딩 앞영등포구 국제금융로 78 홍무빌딩 앞2020.12<NA>