Overview

Dataset statistics

Number of variables6
Number of observations44
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.2 KiB
Average record size in memory52.0 B

Variable types

Numeric1
Categorical1
Text2
DateTime2

Dataset

Description서울특별시 중랑구에 설치된 바닥형 보행신호등 보조장치에 관한 데이터 입니다. 시설물 위치, 주소, 설치일자 등을 제공합니다.
URLhttps://www.data.go.kr/data/15080862/fileData.do

Alerts

자치구 has constant value ""Constant
데이터 기준일자 has constant value ""Constant
연번 has unique valuesUnique
시설물 위치 has unique valuesUnique
주소 has unique valuesUnique

Reproduction

Analysis started2023-12-12 14:41:13.676172
Analysis finished2023-12-12 14:41:14.185916
Duration0.51 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct44
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22.5
Minimum1
Maximum44
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size528.0 B
2023-12-12T23:41:14.266774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.15
Q111.75
median22.5
Q333.25
95-th percentile41.85
Maximum44
Range43
Interquartile range (IQR)21.5

Descriptive statistics

Standard deviation12.845233
Coefficient of variation (CV)0.57089923
Kurtosis-1.2
Mean22.5
Median Absolute Deviation (MAD)11
Skewness0
Sum990
Variance165
MonotonicityStrictly increasing
2023-12-12T23:41:14.390771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=44)
ValueCountFrequency (%)
1 1
 
2.3%
24 1
 
2.3%
26 1
 
2.3%
27 1
 
2.3%
28 1
 
2.3%
29 1
 
2.3%
30 1
 
2.3%
31 1
 
2.3%
32 1
 
2.3%
33 1
 
2.3%
Other values (34) 34
77.3%
ValueCountFrequency (%)
1 1
2.3%
2 1
2.3%
3 1
2.3%
4 1
2.3%
5 1
2.3%
6 1
2.3%
7 1
2.3%
8 1
2.3%
9 1
2.3%
10 1
2.3%
ValueCountFrequency (%)
44 1
2.3%
43 1
2.3%
42 1
2.3%
41 1
2.3%
40 1
2.3%
39 1
2.3%
38 1
2.3%
37 1
2.3%
36 1
2.3%
35 1
2.3%

자치구
Categorical

CONSTANT 

Distinct1
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size484.0 B
중랑구
44 

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 (%)
중랑구 44
100.0%

Length

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

Common Values (Plot)

2023-12-12T23:41:14.612233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
중랑구 44
100.0%

시설물 위치
Text

UNIQUE 

Distinct44
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size484.0 B
2023-12-12T23:41:14.799443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length14
Mean length6.8181818
Min length3

Characters and Unicode

Total characters300
Distinct characters115
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

Unique44 ?
Unique (%)100.0%

Sample

1st row중랑구청사거리(신내로)
2nd row봉화삼거리(봉화산로)
3rd row동성아파트(신내로)
4th row동성3차,신내10단지(신내로)
5th row상봉동홈플러스(망우로)
ValueCountFrequency (%)
중랑구청사거리(신내로 1
 
2.3%
봉화삼거리(봉화산로 1
 
2.3%
동양엔파트(1 1
 
2.3%
중랑구청입구 1
 
2.3%
능산지하차도 1
 
2.3%
중랑구민체육센터 1
 
2.3%
중흥초교 1
 
2.3%
면남초교 1
 
2.3%
무궁화약국 1
 
2.3%
금성초교 1
 
2.3%
Other values (34) 34
77.3%
2023-12-12T23:41:15.235930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
교 13
 
4.3%
초 11
 
3.7%
중 10
 
3.3%
) 10
 
3.3%
( 10
 
3.3%
동 9
 
3.0%
로 9
 
3.0%
화 8
 
2.7%
마 7
 
2.3%
트 6
 
2.0%
Other values (105) 207
69.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 268
89.3%
Close Punctuation 10
 
3.3%
Open Punctuation 10
 
3.3%
Decimal Number 10
 
3.3%
Other Punctuation 2
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
교 13
 
4.9%
초 11
 
4.1%
중 10
 
3.7%
동 9
 
3.4%
로 9
 
3.4%
화 8
 
3.0%
마 7
 
2.6%
트 6
 
2.2%
봉 6
 
2.2%
면 6
 
2.2%
Other values (96) 183
68.3%
Decimal Number
ValueCountFrequency (%)
1 5
50.0%
2 1
 
10.0%
9 1
 
10.0%
3 1
 
10.0%
0 1
 
10.0%
4 1
 
10.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Other Punctuation
ValueCountFrequency (%)
, 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 268
89.3%
Common 32
 
10.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
교 13
 
4.9%
초 11
 
4.1%
중 10
 
3.7%
동 9
 
3.4%
로 9
 
3.4%
화 8
 
3.0%
마 7
 
2.6%
트 6
 
2.2%
봉 6
 
2.2%
면 6
 
2.2%
Other values (96) 183
68.3%
Common
ValueCountFrequency (%)
) 10
31.2%
( 10
31.2%
1 5
15.6%
, 2
 
6.2%
2 1
 
3.1%
9 1
 
3.1%
3 1
 
3.1%
0 1
 
3.1%
4 1
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 268
89.3%
ASCII 32
 
10.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
교 13
 
4.9%
초 11
 
4.1%
중 10
 
3.7%
동 9
 
3.4%
로 9
 
3.4%
화 8
 
3.0%
마 7
 
2.6%
트 6
 
2.2%
봉 6
 
2.2%
면 6
 
2.2%
Other values (96) 183
68.3%
ASCII
ValueCountFrequency (%)
) 10
31.2%
( 10
31.2%
1 5
15.6%
, 2
 
6.2%
2 1
 
3.1%
9 1
 
3.1%
3 1
 
3.1%
0 1
 
3.1%
4 1
 
3.1%

주소
Text

UNIQUE 

Distinct44
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size484.0 B
2023-12-12T23:41:15.502627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length19
Mean length17.795455
Min length16

Characters and Unicode

Total characters783
Distinct characters45
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

Unique44 ?
Unique (%)100.0%

Sample

1st row서울특별시 중랑구 봉화산로 194
2nd row서울특별시 중랑구 봉화산로 115
3rd row서울특별시 중랑구 신내로 126
4th row서울특별시 중랑구 신내로 112
5th row서울특별시 중랑구 상봉동 500
ValueCountFrequency (%)
서울특별시 44
25.0%
중랑구 44
25.0%
용마산로 7
 
4.0%
면목로 6
 
3.4%
봉화산로 5
 
2.8%
망우로 4
 
2.3%
동일로 3
 
1.7%
사가정로 3
 
1.7%
신내로 2
 
1.1%
신내로15길 2
 
1.1%
Other values (54) 56
31.8%
2023-12-12T23:41:15.971013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
133
17.0%
서 44
 
5.6%
특 44
 
5.6%
별 44
 
5.6%
시 44
 
5.6%
중 44
 
5.6%
랑 44
 
5.6%
구 44
 
5.6%
울 44
 
5.6%
로 43
 
5.5%
Other values (35) 255
32.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 512
65.4%
Decimal Number 138
 
17.6%
Space Separator 133
 
17.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 44
8.6%
특 44
8.6%
별 44
8.6%
시 44
8.6%
중 44
8.6%
랑 44
8.6%
구 44
8.6%
울 44
8.6%
로 43
8.4%
산 14
 
2.7%
Other values (24) 103
20.1%
Decimal Number
ValueCountFrequency (%)
1 28
20.3%
2 23
16.7%
5 16
11.6%
3 15
10.9%
0 12
8.7%
4 11
 
8.0%
9 9
 
6.5%
7 9
 
6.5%
8 9
 
6.5%
6 6
 
4.3%
Space Separator
ValueCountFrequency (%)
133
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 512
65.4%
Common 271
34.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 44
8.6%
특 44
8.6%
별 44
8.6%
시 44
8.6%
중 44
8.6%
랑 44
8.6%
구 44
8.6%
울 44
8.6%
로 43
8.4%
산 14
 
2.7%
Other values (24) 103
20.1%
Common
ValueCountFrequency (%)
133
49.1%
1 28
 
10.3%
2 23
 
8.5%
5 16
 
5.9%
3 15
 
5.5%
0 12
 
4.4%
4 11
 
4.1%
9 9
 
3.3%
7 9
 
3.3%
8 9
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 512
65.4%
ASCII 271
34.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
133
49.1%
1 28
 
10.3%
2 23
 
8.5%
5 16
 
5.9%
3 15
 
5.5%
0 12
 
4.4%
4 11
 
4.1%
9 9
 
3.3%
7 9
 
3.3%
8 9
 
3.3%
Hangul
ValueCountFrequency (%)
서 44
8.6%
특 44
8.6%
별 44
8.6%
시 44
8.6%
중 44
8.6%
랑 44
8.6%
구 44
8.6%
울 44
8.6%
로 43
8.4%
산 14
 
2.7%
Other values (24) 103
20.1%

설치일자
Date

Distinct9
Distinct (%)20.5%
Missing0
Missing (%)0.0%
Memory size484.0 B
Minimum2021-03-31 00:00:00
Maximum2022-12-31 00:00:00
2023-12-12T23:41:16.111629image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:41:16.221585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)

데이터 기준일자
Date

CONSTANT 

Distinct1
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size484.0 B
Minimum2023-04-27 00:00:00
Maximum2023-04-27 00:00:00
2023-12-12T23:41:16.349612image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:41:16.478626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

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

Correlations

2023-12-12T23:41:16.574614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번시설물 위치주소설치일자
연번1.0001.0001.0000.889
시설물 위치1.0001.0001.0001.000
주소1.0001.0001.0001.000
설치일자0.8891.0001.0001.000

Missing values

2023-12-12T23:41:14.016670image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:41:14.140799image/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중랑구중랑구청사거리(신내로)서울특별시 중랑구 봉화산로 1942021-03-312023-04-27
12중랑구봉화삼거리(봉화산로)서울특별시 중랑구 봉화산로 1152021-03-312023-04-27
23중랑구동성아파트(신내로)서울특별시 중랑구 신내로 1262021-03-312023-04-27
34중랑구동성3차,신내10단지(신내로)서울특별시 중랑구 신내로 1122021-03-312023-04-27
45중랑구상봉동홈플러스(망우로)서울특별시 중랑구 상봉동 5002021-03-312023-04-27
56중랑구송곡대학교,태창빌딩(망우로)서울특별시 중랑구 망우로 4862021-03-312023-04-27
67중랑구동부제일병원교차로(망우로)서울특별시 중랑구 망우로 5062021-03-312023-04-27
78중랑구동성타워프라자(봉화산로)서울특별시 중랑구 봉화산로 2172021-03-312023-04-27
89중랑구면목역서울특별시 중랑구 겸재로 1812021-10-122023-04-27
910중랑구사가정역서울특별시 중랑구 사가정로 3952021-10-122023-04-27
연번자치구시설물 위치주소설치일자데이터 기준일자
3435중랑구망우119안전센터서울특별시 중랑구 용마산로 5222022-04-302023-04-27
3536중랑구용마스파랜드서울특별시 중랑구 용마산로 5382022-04-302023-04-27
3637중랑구이마트상봉점서울특별시 중랑구 상봉로 1182022-04-302023-04-27
3738중랑구새솔초교사거리서울특별시 중랑구 신내역로 1742022-09-302023-04-27
3839중랑구원묵초삼거리서울특별시 중랑구 숙선옹주로 1112022-12-312023-04-27
3940중랑구봉화초삼거리서울특별시 중랑구 신내로15길 1102022-12-312023-04-27
4041중랑구면목홈플러스서울특별시 중랑구 사가정로 3322022-12-312023-04-27
4142중랑구가락홈마트서울특별시 중랑구 면목로 3762022-12-312023-04-27
4243중랑구중곡초교서울특별시 중랑구 면목로27길 242022-12-312023-04-27
4344중랑구북부운수서울특별시 중랑구 면목로 2232022-12-312023-04-27