Overview

Dataset statistics

Number of variables7
Number of observations74
Missing cells2
Missing cells (%)0.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.3 KiB
Average record size in memory59.8 B

Variable types

Text3
Categorical1
Numeric2
DateTime1

Dataset

Description강남구 관내에 설치되어 있는 바닥신호등에 대한 데이터로 신호등명, 도로명주소, 지번주소, 관리기관 등의 항목을 제공합니다
Author서울특별시 강남구
URLhttps://www.data.go.kr/data/15067095/fileData.do

Alerts

관리기관명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
위도 is highly overall correlated with 경도High correlation
경도 is highly overall correlated with 위도High correlation
소재지도로명주소 has 2 (2.7%) missing valuesMissing
신호등명 has unique valuesUnique
위도 has unique valuesUnique
경도 has unique valuesUnique

Reproduction

Analysis started2023-12-12 04:08:04.626368
Analysis finished2023-12-12 04:08:05.980546
Duration1.35 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

신호등명
Text

UNIQUE 

Distinct74
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size724.0 B
2023-12-12T13:08:06.266509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length9
Mean length6.1891892
Min length3

Characters and Unicode

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

Unique

Unique74 ?
Unique (%)100.0%

Sample

1st row청담초교앞
2nd row포이초교앞
3rd row수서동성당앞
4th row자곡사거리
5th row만강식당앞
ValueCountFrequency (%)
앞 5
 
5.3%
강남세무서 3
 
3.2%
사거리 2
 
2.1%
후문 2
 
2.1%
연등 2
 
2.1%
성수대교남단 1
 
1.1%
삼성중앙역 1
 
1.1%
르네상스호텔 1
 
1.1%
도성초교사거리 1
 
1.1%
강남구청역 1
 
1.1%
Other values (75) 75
79.8%
2023-12-12T13:08:06.878255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
20
 
4.4%
초 19
 
4.1%
교 19
 
4.1%
앞 16
 
3.5%
사 14
 
3.1%
리 14
 
3.1%
거 13
 
2.8%
대 13
 
2.8%
남 12
 
2.6%
역 10
 
2.2%
Other values (117) 308
67.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 428
93.4%
Space Separator 20
 
4.4%
Decimal Number 9
 
2.0%
Lowercase Letter 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
초 19
 
4.4%
교 19
 
4.4%
앞 16
 
3.7%
사 14
 
3.3%
리 14
 
3.3%
거 13
 
3.0%
대 13
 
3.0%
남 12
 
2.8%
역 10
 
2.3%
동 10
 
2.3%
Other values (111) 288
67.3%
Decimal Number
ValueCountFrequency (%)
2 5
55.6%
1 2
 
22.2%
5 1
 
11.1%
0 1
 
11.1%
Space Separator
ValueCountFrequency (%)
20
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 428
93.4%
Common 29
 
6.3%
Latin 1
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
초 19
 
4.4%
교 19
 
4.4%
앞 16
 
3.7%
사 14
 
3.3%
리 14
 
3.3%
거 13
 
3.0%
대 13
 
3.0%
남 12
 
2.8%
역 10
 
2.3%
동 10
 
2.3%
Other values (111) 288
67.3%
Common
ValueCountFrequency (%)
20
69.0%
2 5
 
17.2%
1 2
 
6.9%
5 1
 
3.4%
0 1
 
3.4%
Latin
ValueCountFrequency (%)
e 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 428
93.4%
ASCII 30
 
6.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
20
66.7%
2 5
 
16.7%
1 2
 
6.7%
5 1
 
3.3%
0 1
 
3.3%
e 1
 
3.3%
Hangul
ValueCountFrequency (%)
초 19
 
4.4%
교 19
 
4.4%
앞 16
 
3.7%
사 14
 
3.3%
리 14
 
3.3%
거 13
 
3.0%
대 13
 
3.0%
남 12
 
2.8%
역 10
 
2.3%
동 10
 
2.3%
Other values (111) 288
67.3%

소재지도로명주소
Text

MISSING 

Distinct70
Distinct (%)97.2%
Missing2
Missing (%)2.7%
Memory size724.0 B
2023-12-12T13:08:07.263172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length18
Mean length15.722222
Min length14

Characters and Unicode

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

Unique68 ?
Unique (%)94.4%

Sample

1st row서울시 강남구 압구정로 429
2nd row서울시 강남구 개포로22길 87
3rd row서울시 강남구 광평로 199
4th row서울시 강남구 밤고개로 206
5th row서울시 강남구 밤고개로21길 81
ValueCountFrequency (%)
서울시 72
24.9%
강남구 72
24.9%
삼성로 8
 
2.8%
압구정로 5
 
1.7%
선릉로 5
 
1.7%
개포로 5
 
1.7%
테헤란로 5
 
1.7%
학동로 5
 
1.7%
봉은사로 4
 
1.4%
언주로 4
 
1.4%
Other values (87) 104
36.0%
2023-12-12T13:08:07.789175image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
217
19.2%
구 77
 
6.8%
남 75
 
6.6%
서 72
 
6.4%
로 72
 
6.4%
울 72
 
6.4%
강 72
 
6.4%
시 72
 
6.4%
1 47
 
4.2%
2 33
 
2.9%
Other values (50) 323
28.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 690
61.0%
Decimal Number 225
 
19.9%
Space Separator 217
 
19.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 77
11.2%
남 75
10.9%
서 72
10.4%
로 72
10.4%
울 72
10.4%
강 72
10.4%
시 72
10.4%
길 13
 
1.9%
삼 11
 
1.6%
개 10
 
1.4%
Other values (39) 144
20.9%
Decimal Number
ValueCountFrequency (%)
1 47
20.9%
2 33
14.7%
3 28
12.4%
4 25
11.1%
5 23
10.2%
6 22
9.8%
0 19
8.4%
9 11
 
4.9%
7 9
 
4.0%
8 8
 
3.6%
Space Separator
ValueCountFrequency (%)
217
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 690
61.0%
Common 442
39.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 77
11.2%
남 75
10.9%
서 72
10.4%
로 72
10.4%
울 72
10.4%
강 72
10.4%
시 72
10.4%
길 13
 
1.9%
삼 11
 
1.6%
개 10
 
1.4%
Other values (39) 144
20.9%
Common
ValueCountFrequency (%)
217
49.1%
1 47
 
10.6%
2 33
 
7.5%
3 28
 
6.3%
4 25
 
5.7%
5 23
 
5.2%
6 22
 
5.0%
0 19
 
4.3%
9 11
 
2.5%
7 9
 
2.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 690
61.0%
ASCII 442
39.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
217
49.1%
1 47
 
10.6%
2 33
 
7.5%
3 28
 
6.3%
4 25
 
5.7%
5 23
 
5.2%
6 22
 
5.0%
0 19
 
4.3%
9 11
 
2.5%
7 9
 
2.0%
Hangul
ValueCountFrequency (%)
구 77
11.2%
남 75
10.9%
서 72
10.4%
로 72
10.4%
울 72
10.4%
강 72
10.4%
시 72
10.4%
길 13
 
1.9%
삼 11
 
1.6%
개 10
 
1.4%
Other values (39) 144
20.9%

소재지지번주소
Text

Distinct73
Distinct (%)98.6%
Missing0
Missing (%)0.0%
Memory size724.0 B
2023-12-12T13:08:08.129945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length16
Mean length13.297297
Min length6

Characters and Unicode

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

Unique

Unique72 ?
Unique (%)97.3%

Sample

1st row서울시 강남구 청담동 141-18
2nd row서울시 강남구 개포동 1273
3rd row서울시 강남구 수서동 739
4th row서울시 강남구 자곡동 591
5th row서울시 강남구 율현동 69
ValueCountFrequency (%)
서울시 49
19.9%
강남구 49
19.9%
대치동 13
 
5.3%
개포동 11
 
4.5%
삼성동 10
 
4.1%
일원동 5
 
2.0%
역삼동 5
 
2.0%
자곡동 5
 
2.0%
논현동 5
 
2.0%
세곡동 4
 
1.6%
Other values (82) 90
36.6%
2023-12-12T13:08:08.680783image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
172
17.5%
동 71
 
7.2%
서 52
 
5.3%
1 52
 
5.3%
구 51
 
5.2%
시 49
 
5.0%
강 49
 
5.0%
남 49
 
5.0%
울 49
 
5.0%
- 35
 
3.6%
Other values (36) 355
36.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 519
52.7%
Decimal Number 258
26.2%
Space Separator 172
 
17.5%
Dash Punctuation 35
 
3.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 71
13.7%
서 52
10.0%
구 51
9.8%
시 49
9.4%
강 49
9.4%
남 49
9.4%
울 49
9.4%
삼 17
 
3.3%
치 13
 
2.5%
대 13
 
2.5%
Other values (24) 106
20.4%
Decimal Number
ValueCountFrequency (%)
1 52
20.2%
2 32
12.4%
6 32
12.4%
7 30
11.6%
5 30
11.6%
8 19
 
7.4%
9 18
 
7.0%
4 17
 
6.6%
3 16
 
6.2%
0 12
 
4.7%
Space Separator
ValueCountFrequency (%)
172
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 35
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 519
52.7%
Common 465
47.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 71
13.7%
서 52
10.0%
구 51
9.8%
시 49
9.4%
강 49
9.4%
남 49
9.4%
울 49
9.4%
삼 17
 
3.3%
치 13
 
2.5%
대 13
 
2.5%
Other values (24) 106
20.4%
Common
ValueCountFrequency (%)
172
37.0%
1 52
 
11.2%
- 35
 
7.5%
2 32
 
6.9%
6 32
 
6.9%
7 30
 
6.5%
5 30
 
6.5%
8 19
 
4.1%
9 18
 
3.9%
4 17
 
3.7%
Other values (2) 28
 
6.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 519
52.7%
ASCII 465
47.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
172
37.0%
1 52
 
11.2%
- 35
 
7.5%
2 32
 
6.9%
6 32
 
6.9%
7 30
 
6.5%
5 30
 
6.5%
8 19
 
4.1%
9 18
 
3.9%
4 17
 
3.7%
Other values (2) 28
 
6.0%
Hangul
ValueCountFrequency (%)
동 71
13.7%
서 52
10.0%
구 51
9.8%
시 49
9.4%
강 49
9.4%
남 49
9.4%
울 49
9.4%
삼 17
 
3.3%
치 13
 
2.5%
대 13
 
2.5%
Other values (24) 106
20.4%

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size724.0 B
서울특별시 강남구
74 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서울특별시 강남구
2nd row서울특별시 강남구
3rd row서울특별시 강남구
4th row서울특별시 강남구
5th row서울특별시 강남구

Common Values

ValueCountFrequency (%)
서울특별시 강남구 74
100.0%

Length

2023-12-12T13:08:08.845318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:08:08.961275image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울특별시 74
50.0%
강남구 74
50.0%

위도
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct74
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.49668
Minimum37.46477
Maximum37.529218
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size798.0 B
2023-12-12T13:08:09.085679image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.46477
5-th percentile37.468302
Q137.485604
median37.494253
Q337.510463
95-th percentile37.525751
Maximum37.529218
Range0.064448
Interquartile range (IQR)0.02485875

Descriptive statistics

Standard deviation0.017062926
Coefficient of variation (CV)0.00045505164
Kurtosis-0.70693891
Mean37.49668
Median Absolute Deviation (MAD)0.012157
Skewness0.040636419
Sum2774.7543
Variance0.00029114343
MonotonicityNot monotonic
2023-12-12T13:08:09.384239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.52721 1
 
1.4%
37.509779 1
 
1.4%
37.498224 1
 
1.4%
37.513531 1
 
1.4%
37.518827 1
 
1.4%
37.512993 1
 
1.4%
37.502705 1
 
1.4%
37.500627 1
 
1.4%
37.51718 1
 
1.4%
37.513887 1
 
1.4%
Other values (64) 64
86.5%
ValueCountFrequency (%)
37.46477 1
1.4%
37.46481 1
1.4%
37.46528 1
1.4%
37.46576 1
1.4%
37.46967 1
1.4%
37.470998 1
1.4%
37.4728 1
1.4%
37.473872 1
1.4%
37.47416 1
1.4%
37.47448 1
1.4%
ValueCountFrequency (%)
37.529218 1
1.4%
37.529154 1
1.4%
37.52813 1
1.4%
37.52721 1
1.4%
37.524965 1
1.4%
37.52492 1
1.4%
37.518827 1
1.4%
37.51821 1
1.4%
37.51813 1
1.4%
37.51791 1
1.4%

경도
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct74
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.06301
Minimum127.02395
Maximum127.11686
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size798.0 B
2023-12-12T13:08:09.595739image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.02395
5-th percentile127.03178
Q1127.04664
median127.05746
Q3127.07601
95-th percentile127.10699
Maximum127.11686
Range0.092912
Interquartile range (IQR)0.0293735

Descriptive statistics

Standard deviation0.023425651
Coefficient of variation (CV)0.00018436248
Kurtosis-0.46698187
Mean127.06301
Median Absolute Deviation (MAD)0.013545
Skewness0.66023289
Sum9402.6627
Variance0.00054876113
MonotonicityNot monotonic
2023-12-12T13:08:09.858738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.04406 1
 
1.4%
127.066365 1
 
1.4%
127.058801 1
 
1.4%
127.056323 1
 
1.4%
127.050237 1
 
1.4%
127.053245 1
 
1.4%
127.042501 1
 
1.4%
127.050914 1
 
1.4%
127.041414 1
 
1.4%
127.030862 1
 
1.4%
Other values (64) 64
86.5%
ValueCountFrequency (%)
127.023948 1
1.4%
127.03024 1
1.4%
127.030862 1
1.4%
127.030954 1
1.4%
127.032222 1
1.4%
127.033516 1
1.4%
127.03403 1
1.4%
127.035398 1
1.4%
127.03666 1
1.4%
127.037958 1
1.4%
ValueCountFrequency (%)
127.11686 1
1.4%
127.11536 1
1.4%
127.1082 1
1.4%
127.107872 1
1.4%
127.10652 1
1.4%
127.1056 1
1.4%
127.10183 1
1.4%
127.10123 1
1.4%
127.10001 1
1.4%
127.09781 1
1.4%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size724.0 B
Minimum2022-09-22 00:00:00
Maximum2022-09-22 00:00:00
2023-12-12T13:08:10.041769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:08:10.175826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T13:08:05.324670image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:08:05.056058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:08:05.476807image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:08:05.181559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T13:08:10.292869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
신호등명소재지도로명주소소재지지번주소위도경도
신호등명1.0001.0001.0001.0001.000
소재지도로명주소1.0001.0001.0001.0001.000
소재지지번주소1.0001.0001.0001.0001.000
위도1.0001.0001.0001.0000.787
경도1.0001.0001.0000.7871.000
2023-12-12T13:08:10.459861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.000-0.748
경도-0.7481.000

Missing values

2023-12-12T13:08:05.687880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T13:08:05.905364image/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청담초교앞서울시 강남구 압구정로 429서울시 강남구 청담동 141-18서울특별시 강남구37.52721127.044062022-09-22
1포이초교앞서울시 강남구 개포로22길 87서울시 강남구 개포동 1273서울특별시 강남구37.47592127.052512022-09-22
2수서동성당앞서울시 강남구 광평로 199서울시 강남구 수서동 739서울특별시 강남구37.48469127.094852022-09-22
3자곡사거리서울시 강남구 밤고개로 206서울시 강남구 자곡동 591서울특별시 강남구37.47576127.10562022-09-22
4만강식당앞서울시 강남구 밤고개로21길 81서울시 강남구 율현동 69서울특별시 강남구37.47416127.115362022-09-22
5율현공원앞<NA>서울시 강남구 율현동 66-8서울특별시 강남구37.47448127.116862022-09-22
6강남리더스프라자앞서울시 강남구 헌릉로 569서울시 강남구 세곡동 581서울특별시 강남구37.46576127.101232022-09-22
7자곡초서울시 강남구 자곡로 150서울시 강남구 자곡동 641서울특별시 강남구37.4728127.100012022-09-22
8일원역사거리서울시 강남구 일원로 115서울시 강남구 일원동 717서울특별시 강남구37.48324127.083862022-09-22
9개포고교사거리서울시 강남구 개포로 402서울시 강남구 개포동 173서울특별시 강남구37.4848127.057932022-09-22
신호등명소재지도로명주소소재지지번주소관리기관명위도경도데이터기준일자
64우성2차201동앞서울시 강남구 도곡로 531대치동 986-6서울특별시 강남구37.500081127.0646552022-09-22
65르엘대치정문앞서울시 강남구 도곡로93길 23대치동 977-8서울특별시 강남구37.501603127.0650952022-09-22
66센트럴아이파크 연동서울시 강남구 삼성로 634삼성동 65-5서울특별시 강남구37.516411127.0514812022-09-22
67대치사거리서울시 강남구 삼성로 352대치동 961서울특별시 강남구37.503112127.0587252022-09-22
68개포2동주민센터서울시 강남구 개포로 511개포동 182서울특별시 강남구37.489552127.0691212022-09-22
69영동5교서울시 강남구 삼성로 40개포동 186서울특별시 강남구37.489148127.0660942022-09-22
70강남세브란스서울시 강남구 언주로 301역삼동 785-13서울특별시 강남구37.494089127.0465222022-09-22
71도곡역서울시 강남구 남부순환로 2912대치동 500서울특별시 강남구37.4911127.055522022-09-22
72경남아파트 앞서울시 강남구 언주로 107개포동 654서울특별시 강남구37.483143127.0524882022-09-22
73일원우체국서울시 강남구 양재대로55길 14일원동 712-3서울특별시 강남구37.491671127.087832022-09-22