Overview

Dataset statistics

Number of variables9
Number of observations57
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.4 KiB
Average record size in memory78.3 B

Variable types

Numeric3
Text2
Categorical4

Dataset

Description서울특별시 광진구 관내 횡단보도 LED바닥형 보행신호등 관련 공공데이터 자료(주소, 상세위치, 수량, 좌표, 관리기관 등)
Author서울특별시 광진구
URLhttps://www.data.go.kr/data/15067064/fileData.do

Alerts

관리기관 has constant value ""Constant
연락처 has constant value ""Constant
자료기준일 has constant value ""Constant
연번 has unique valuesUnique
경도 has unique valuesUnique

Reproduction

Analysis started2023-12-12 20:32:41.938050
Analysis finished2023-12-12 20:32:43.518849
Duration1.58 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct57
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean29
Minimum1
Maximum57
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size645.0 B
2023-12-13T05:32:43.605287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.8
Q115
median29
Q343
95-th percentile54.2
Maximum57
Range56
Interquartile range (IQR)28

Descriptive statistics

Standard deviation16.598193
Coefficient of variation (CV)0.57235147
Kurtosis-1.2
Mean29
Median Absolute Deviation (MAD)14
Skewness0
Sum1653
Variance275.5
MonotonicityStrictly increasing
2023-12-13T05:32:43.746095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.8%
44 1
 
1.8%
32 1
 
1.8%
33 1
 
1.8%
34 1
 
1.8%
35 1
 
1.8%
36 1
 
1.8%
37 1
 
1.8%
38 1
 
1.8%
39 1
 
1.8%
Other values (47) 47
82.5%
ValueCountFrequency (%)
1 1
1.8%
2 1
1.8%
3 1
1.8%
4 1
1.8%
5 1
1.8%
6 1
1.8%
7 1
1.8%
8 1
1.8%
9 1
1.8%
10 1
1.8%
ValueCountFrequency (%)
57 1
1.8%
56 1
1.8%
55 1
1.8%
54 1
1.8%
53 1
1.8%
52 1
1.8%
51 1
1.8%
50 1
1.8%
49 1
1.8%
48 1
1.8%

도로명주소
Text

Distinct56
Distinct (%)98.2%
Missing0
Missing (%)0.0%
Memory size588.0 B
2023-12-13T05:32:44.052221image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length24
Mean length22.508772
Min length21

Characters and Unicode

Total characters1283
Distinct characters60
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

Unique55 ?
Unique (%)96.5%

Sample

1st row서울특별시 광진구 면목로 131(중곡동)
2nd row서울특별시 광진구 강변역로4길 10(구의동)
3rd row서울특별시 광진구 강변역로 50(구의동)
4th row서울특별시 광진구 아차산로 244(자양동)
5th row서울특별시 광진구 능동로 103(자양동)
ValueCountFrequency (%)
서울특별시 57
24.8%
광진구 57
24.8%
뚝섬로 7
 
3.0%
용마산로 6
 
2.6%
능동로 6
 
2.6%
자양로 6
 
2.6%
아차산로 5
 
2.2%
광나루로 4
 
1.7%
77(구의동 3
 
1.3%
구의강변로 3
 
1.3%
Other values (68) 76
33.0%
2023-12-13T05:32:44.504194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
174
 
13.6%
구 76
 
5.9%
동 66
 
5.1%
광 65
 
5.1%
서 57
 
4.4%
) 57
 
4.4%
특 57
 
4.4%
별 57
 
4.4%
시 57
 
4.4%
진 57
 
4.4%
Other values (50) 560
43.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 832
64.8%
Space Separator 174
 
13.6%
Decimal Number 161
 
12.5%
Close Punctuation 57
 
4.4%
Open Punctuation 57
 
4.4%
Dash Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 76
 
9.1%
동 66
 
7.9%
광 65
 
7.8%
서 57
 
6.9%
특 57
 
6.9%
별 57
 
6.9%
시 57
 
6.9%
진 57
 
6.9%
울 57
 
6.9%
로 56
 
6.7%
Other values (36) 227
27.3%
Decimal Number
ValueCountFrequency (%)
1 29
18.0%
5 26
16.1%
2 19
11.8%
3 16
9.9%
0 16
9.9%
4 14
8.7%
7 14
8.7%
6 12
7.5%
8 8
 
5.0%
9 7
 
4.3%
Space Separator
ValueCountFrequency (%)
174
100.0%
Close Punctuation
ValueCountFrequency (%)
) 57
100.0%
Open Punctuation
ValueCountFrequency (%)
( 57
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 832
64.8%
Common 451
35.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 76
 
9.1%
동 66
 
7.9%
광 65
 
7.8%
서 57
 
6.9%
특 57
 
6.9%
별 57
 
6.9%
시 57
 
6.9%
진 57
 
6.9%
울 57
 
6.9%
로 56
 
6.7%
Other values (36) 227
27.3%
Common
ValueCountFrequency (%)
174
38.6%
) 57
 
12.6%
( 57
 
12.6%
1 29
 
6.4%
5 26
 
5.8%
2 19
 
4.2%
3 16
 
3.5%
0 16
 
3.5%
4 14
 
3.1%
7 14
 
3.1%
Other values (4) 29
 
6.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 832
64.8%
ASCII 451
35.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
174
38.6%
) 57
 
12.6%
( 57
 
12.6%
1 29
 
6.4%
5 26
 
5.8%
2 19
 
4.2%
3 16
 
3.5%
0 16
 
3.5%
4 14
 
3.1%
7 14
 
3.1%
Other values (4) 29
 
6.4%
Hangul
ValueCountFrequency (%)
구 76
 
9.1%
동 66
 
7.9%
광 65
 
7.8%
서 57
 
6.9%
특 57
 
6.9%
별 57
 
6.9%
시 57
 
6.9%
진 57
 
6.9%
울 57
 
6.9%
로 56
 
6.7%
Other values (36) 227
27.3%

상세위치
Text

Distinct48
Distinct (%)84.2%
Missing0
Missing (%)0.0%
Memory size588.0 B
2023-12-13T05:32:44.749423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length6.6315789
Min length4

Characters and Unicode

Total characters378
Distinct characters102
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

Unique40 ?
Unique (%)70.2%

Sample

1st row중마초등학교
2nd row강변역(동서울터미널)
3rd row강변역(동서울터미널)
4th row건대입구역
5th row건대입구역
ValueCountFrequency (%)
앞 7
 
8.9%
사거리 6
 
7.6%
인근 5
 
6.3%
건대입구역 3
 
3.8%
신양초등학교 2
 
2.5%
강변역(동서울터미널 2
 
2.5%
동자초등학교 2
 
2.5%
성자초등학교 2
 
2.5%
용곡초 2
 
2.5%
대원외고 2
 
2.5%
Other values (44) 46
58.2%
2023-12-13T05:32:45.155666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
초 24
 
6.3%
22
 
5.8%
교 21
 
5.6%
등 18
 
4.8%
학 18
 
4.8%
구 12
 
3.2%
리 11
 
2.9%
거 11
 
2.9%
사 10
 
2.6%
동 9
 
2.4%
Other values (92) 222
58.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 347
91.8%
Space Separator 22
 
5.8%
Close Punctuation 3
 
0.8%
Open Punctuation 3
 
0.8%
Decimal Number 3
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
초 24
 
6.9%
교 21
 
6.1%
등 18
 
5.2%
학 18
 
5.2%
구 12
 
3.5%
리 11
 
3.2%
거 11
 
3.2%
사 10
 
2.9%
동 9
 
2.6%
자 9
 
2.6%
Other values (87) 204
58.8%
Decimal Number
ValueCountFrequency (%)
1 2
66.7%
3 1
33.3%
Space Separator
ValueCountFrequency (%)
22
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 347
91.8%
Common 31
 
8.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
초 24
 
6.9%
교 21
 
6.1%
등 18
 
5.2%
학 18
 
5.2%
구 12
 
3.5%
리 11
 
3.2%
거 11
 
3.2%
사 10
 
2.9%
동 9
 
2.6%
자 9
 
2.6%
Other values (87) 204
58.8%
Common
ValueCountFrequency (%)
22
71.0%
) 3
 
9.7%
( 3
 
9.7%
1 2
 
6.5%
3 1
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 347
91.8%
ASCII 31
 
8.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
초 24
 
6.9%
교 21
 
6.1%
등 18
 
5.2%
학 18
 
5.2%
구 12
 
3.5%
리 11
 
3.2%
거 11
 
3.2%
사 10
 
2.9%
동 9
 
2.6%
자 9
 
2.6%
Other values (87) 204
58.8%
ASCII
ValueCountFrequency (%)
22
71.0%
) 3
 
9.7%
( 3
 
9.7%
1 2
 
6.5%
3 1
 
3.2%

수량
Categorical

Distinct3
Distinct (%)5.3%
Missing0
Missing (%)0.0%
Memory size588.0 B
1
41 
2
8 
4
8 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row2
3rd row1
4th row2
5th row1

Common Values

ValueCountFrequency (%)
1 41
71.9%
2 8
 
14.0%
4 8
 
14.0%

Length

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

Common Values (Plot)

2023-12-13T05:32:45.466177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 41
71.9%
2 8
 
14.0%
4 8
 
14.0%

위도
Real number (ℝ)

Distinct56
Distinct (%)98.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.546301
Minimum37.53159
Maximum37.568252
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size645.0 B
2023-12-13T05:32:45.616631image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.53159
5-th percentile37.533035
Q137.537172
median37.54279
Q337.554514
95-th percentile37.565426
Maximum37.568252
Range0.03666216
Interquartile range (IQR)0.017342

Descriptive statistics

Standard deviation0.011300905
Coefficient of variation (CV)0.00030098584
Kurtosis-1.1099771
Mean37.546301
Median Absolute Deviation (MAD)0.007837
Skewness0.53053961
Sum2140.1391
Variance0.00012771045
MonotonicityNot monotonic
2023-12-13T05:32:45.792244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.53726 2
 
3.5%
37.56520483 1
 
1.8%
37.55369368 1
 
1.8%
37.5333 1
 
1.8%
37.568252 1
 
1.8%
37.53652 1
 
1.8%
37.54112 1
 
1.8%
37.55722 1
 
1.8%
37.56631 1
 
1.8%
37.55949 1
 
1.8%
Other values (46) 46
80.7%
ValueCountFrequency (%)
37.53158984 1
1.8%
37.53161932 1
1.8%
37.531974 1
1.8%
37.5333 1
1.8%
37.53430592 1
1.8%
37.534374 1
1.8%
37.53453766 1
1.8%
37.534625 1
1.8%
37.5347 1
1.8%
37.534953 1
1.8%
ValueCountFrequency (%)
37.568252 1
1.8%
37.56633 1
1.8%
37.56631 1
1.8%
37.56520483 1
1.8%
37.56498243 1
1.8%
37.56439475 1
1.8%
37.56368652 1
1.8%
37.56338999 1
1.8%
37.563149 1
1.8%
37.5605 1
1.8%

경도
Real number (ℝ)

UNIQUE 

Distinct57
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.0836
Minimum127.06825
Maximum127.10233
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size645.0 B
2023-12-13T05:32:45.945232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.06825
5-th percentile127.07045
Q1127.07546
median127.08371
Q3127.09034
95-th percentile127.09658
Maximum127.10233
Range0.0340763
Interquartile range (IQR)0.014879

Descriptive statistics

Standard deviation0.0087155156
Coefficient of variation (CV)6.8580961 × 10-5
Kurtosis-0.87800059
Mean127.0836
Median Absolute Deviation (MAD)0.007406
Skewness-0.03828408
Sum7243.7654
Variance7.5960213 × 10-5
MonotonicityNot monotonic
2023-12-13T05:32:46.087291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.08074 1
 
1.8%
127.0942 1
 
1.8%
127.09312 1
 
1.8%
127.07546 1
 
1.8%
127.085871 1
 
1.8%
127.08377 1
 
1.8%
127.0963 1
 
1.8%
127.07982 1
 
1.8%
127.08457 1
 
1.8%
127.09302 1
 
1.8%
Other values (47) 47
82.5%
ValueCountFrequency (%)
127.068253 1
1.8%
127.070078 1
1.8%
127.0702007 1
1.8%
127.07051 1
1.8%
127.070941 1
1.8%
127.0710582 1
1.8%
127.0712168 1
1.8%
127.071223 1
1.8%
127.071275 1
1.8%
127.0719117 1
1.8%
ValueCountFrequency (%)
127.1023293 1
1.8%
127.0988538 1
1.8%
127.0977177 1
1.8%
127.0963 1
1.8%
127.09435 1
1.8%
127.0942 1
1.8%
127.0941846 1
1.8%
127.0938485 1
1.8%
127.0934054 1
1.8%
127.09312 1
1.8%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size588.0 B
광진구청
57 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
광진구청 57
100.0%

Length

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

Common Values (Plot)

2023-12-13T05:32:46.630516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광진구청 57
100.0%

연락처
Categorical

CONSTANT 

Distinct1
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size588.0 B
02-450-7928
57 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row02-450-7928
2nd row02-450-7928
3rd row02-450-7928
4th row02-450-7928
5th row02-450-7928

Common Values

ValueCountFrequency (%)
02-450-7928 57
100.0%

Length

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

Common Values (Plot)

2023-12-13T05:32:46.842888image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
02-450-7928 57
100.0%

자료기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size588.0 B
2023-11-13
57 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-11-13
2nd row2023-11-13
3rd row2023-11-13
4th row2023-11-13
5th row2023-11-13

Common Values

ValueCountFrequency (%)
2023-11-13 57
100.0%

Length

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

Common Values (Plot)

2023-12-13T05:32:47.053682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-11-13 57
100.0%

Interactions

2023-12-13T05:32:42.990798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:32:42.341161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:32:42.648783image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:32:43.075419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:32:42.441616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:32:42.752203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:32:43.182343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:32:42.549493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:32:42.876882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T05:32:47.120028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번도로명주소상세위치수량위도경도
연번1.0000.9410.9570.6110.3870.590
도로명주소0.9411.0000.9860.0001.0001.000
상세위치0.9570.9861.0000.9130.9880.989
수량0.6110.0000.9131.0000.0000.000
위도0.3871.0000.9880.0001.0000.695
경도0.5901.0000.9890.0000.6951.000
2023-12-13T05:32:47.217935image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번위도경도수량
연번1.0000.0600.0020.422
위도0.0601.0000.1070.000
경도0.0020.1071.0000.000
수량0.4220.0000.0001.000

Missing values

2023-12-13T05:32:43.322442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T05:32:43.461029image/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서울특별시 광진구 면목로 131(중곡동)중마초등학교137.565205127.08074광진구청02-450-79282023-11-13
12서울특별시 광진구 강변역로4길 10(구의동)강변역(동서울터미널)237.535352127.093405광진구청02-450-79282023-11-13
23서울특별시 광진구 강변역로 50(구의동)강변역(동서울터미널)137.534538127.094185광진구청02-450-79282023-11-13
34서울특별시 광진구 아차산로 244(자양동)건대입구역237.539731127.070201광진구청02-450-79282023-11-13
45서울특별시 광진구 능동로 103(자양동)건대입구역137.540337127.07051광진구청02-450-79282023-11-13
56서울특별시 광진구 능동로 92(자양동)건대입구역137.539127.071217광진구청02-450-79282023-11-13
67서울특별시 광진구 천호대로 655(중곡동)아차산역237.552597127.089722광진구청02-450-79282023-11-13
78서울특별시 광진구 광장로 45(광장동)광장초등학교137.546998127.102329광진구청02-450-79282023-11-13
89서울특별시 광진구 자양로 247(구의동)광진초등학교137.548652127.088842광진구청02-450-79282023-11-13
910서울특별시 광진구 자양로 150(구의동)구의초등학교137.540945127.083821광진구청02-450-79282023-11-13
연번도로명주소상세위치수량위도경도관리기관연락처자료기준일
4748서울특별시 광진구 자양동 550-2 (자양동)신양초등학교 사거리137.534953127.068253광진구청02-450-79282023-11-13
4849서울특별시 광진구 긴고랑로 32(중곡동)중곡1동사거리437.563149127.079792광진구청02-450-79282023-11-13
4950서울특별시 광진구 뚝섬로 632(자양동)국민은행 자양동지점437.531974127.07968광진구청02-450-79282023-11-13
5051서울특별시 광진구 자양로 167(자양동)광진경찰서137.543104127.083715광진구청02-450-79282023-11-13
5152서울특별시 광진구 아차산로 342(자양동)서문도장137.537172127.080517광진구청02-450-79282023-11-13
5253서울특별시 광진구 뚝섬로569(자양동)우성1차아파트137.534374127.074575광진구청02-450-79282023-11-13
5354서울특별시 광진구 군자로 70(군자동)온아치과의원137.549569127.070941광진구청02-450-79282023-11-13
5455서울특별시 광진구 아차산로58길 77(구의동)한양연립437.5347127.090339광진구청02-450-79282023-11-13
5556서울특별시 광진구 뚝섬로 741(구의동)새마을금고 구의3동지점437.534625127.091298광진구청02-450-79282023-11-13
5657서울특별시 광진구 동일로 260(군자동)조은빌딩137.554514127.071223광진구청02-450-79282023-11-13