Overview

Dataset statistics

Number of variables4
Number of observations76
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.6 KiB
Average record size in memory34.7 B

Variable types

Numeric1
Text2
DateTime1

Dataset

Description서울특별시 강남구 옥상간판 설치 현황 데이터 입니다. 기타 자세한 사항은 서울특별시 강남구 도시계획과(02-3423-6123)로 문의주시면 자세히 안내드리겠습니다.
Author서울특별시 강남구
URLhttps://www.data.go.kr/data/15115293/fileData.do

Alerts

연번 has unique valuesUnique
광고물 표시 주소 has unique valuesUnique
규격 has unique valuesUnique

Reproduction

Analysis started2023-12-12 14:54:52.892930
Analysis finished2023-12-12 14:54:53.762345
Duration0.87 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct76
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean38.5
Minimum1
Maximum76
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size816.0 B
2023-12-12T23:54:53.841301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.75
Q119.75
median38.5
Q357.25
95-th percentile72.25
Maximum76
Range75
Interquartile range (IQR)37.5

Descriptive statistics

Standard deviation22.083176
Coefficient of variation (CV)0.57358899
Kurtosis-1.2
Mean38.5
Median Absolute Deviation (MAD)19
Skewness0
Sum2926
Variance487.66667
MonotonicityStrictly increasing
2023-12-12T23:54:54.027055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.3%
50 1
 
1.3%
57 1
 
1.3%
56 1
 
1.3%
55 1
 
1.3%
54 1
 
1.3%
53 1
 
1.3%
52 1
 
1.3%
51 1
 
1.3%
49 1
 
1.3%
Other values (66) 66
86.8%
ValueCountFrequency (%)
1 1
1.3%
2 1
1.3%
3 1
1.3%
4 1
1.3%
5 1
1.3%
6 1
1.3%
7 1
1.3%
8 1
1.3%
9 1
1.3%
10 1
1.3%
ValueCountFrequency (%)
76 1
1.3%
75 1
1.3%
74 1
1.3%
73 1
1.3%
72 1
1.3%
71 1
1.3%
70 1
1.3%
69 1
1.3%
68 1
1.3%
67 1
1.3%

광고물 표시 주소
Text

UNIQUE 

Distinct76
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size740.0 B
2023-12-12T23:54:54.370328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length41
Median length38
Mean length26.671053
Min length23

Characters and Unicode

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

Unique

Unique76 ?
Unique (%)100.0%

Sample

1st row서울특별시 강남구 언주로 703 (논현동)
2nd row서울특별시 강남구 도산대로 306 옥상층 (논현동)
3rd row서울특별시 강남구 강남대로 642 (신사동)
4th row서울특별시 강남구 언주로 708 (논현동)
5th row서울특별시 강남구 언주로 651 (논현동)
ValueCountFrequency (%)
강남구 76
18.2%
서울특별시 75
18.0%
논현동 23
 
5.5%
도산대로 21
 
5.0%
강남대로 13
 
3.1%
옥상층 13
 
3.1%
청담동 12
 
2.9%
영동대로 12
 
2.9%
대치동 11
 
2.6%
신사동 11
 
2.6%
Other values (108) 150
36.0%
2023-12-12T23:54:54.935491image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
373
18.4%
동 91
 
4.5%
남 91
 
4.5%
강 90
 
4.4%
구 80
 
3.9%
( 77
 
3.8%
서 77
 
3.8%
) 77
 
3.8%
시 76
 
3.7%
로 76
 
3.7%
Other values (81) 919
45.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1252
61.8%
Space Separator 373
 
18.4%
Decimal Number 244
 
12.0%
Open Punctuation 77
 
3.8%
Close Punctuation 77
 
3.8%
Uppercase Letter 3
 
0.1%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 91
 
7.3%
남 91
 
7.3%
강 90
 
7.2%
구 80
 
6.4%
서 77
 
6.2%
시 76
 
6.1%
로 76
 
6.1%
울 76
 
6.1%
별 75
 
6.0%
특 75
 
6.0%
Other values (64) 445
35.5%
Decimal Number
ValueCountFrequency (%)
1 35
14.3%
4 31
12.7%
2 29
11.9%
5 29
11.9%
6 28
11.5%
3 26
10.7%
0 23
9.4%
8 17
7.0%
7 17
7.0%
9 9
 
3.7%
Uppercase Letter
ValueCountFrequency (%)
T 1
33.3%
D 1
33.3%
A 1
33.3%
Space Separator
ValueCountFrequency (%)
373
100.0%
Open Punctuation
ValueCountFrequency (%)
( 77
100.0%
Close Punctuation
ValueCountFrequency (%)
) 77
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1252
61.8%
Common 772
38.1%
Latin 3
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 91
 
7.3%
남 91
 
7.3%
강 90
 
7.2%
구 80
 
6.4%
서 77
 
6.2%
시 76
 
6.1%
로 76
 
6.1%
울 76
 
6.1%
별 75
 
6.0%
특 75
 
6.0%
Other values (64) 445
35.5%
Common
ValueCountFrequency (%)
373
48.3%
( 77
 
10.0%
) 77
 
10.0%
1 35
 
4.5%
4 31
 
4.0%
2 29
 
3.8%
5 29
 
3.8%
6 28
 
3.6%
3 26
 
3.4%
0 23
 
3.0%
Other values (4) 44
 
5.7%
Latin
ValueCountFrequency (%)
T 1
33.3%
D 1
33.3%
A 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1252
61.8%
ASCII 775
38.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
373
48.1%
( 77
 
9.9%
) 77
 
9.9%
1 35
 
4.5%
4 31
 
4.0%
2 29
 
3.7%
5 29
 
3.7%
6 28
 
3.6%
3 26
 
3.4%
0 23
 
3.0%
Other values (7) 47
 
6.1%
Hangul
ValueCountFrequency (%)
동 91
 
7.3%
남 91
 
7.3%
강 90
 
7.2%
구 80
 
6.4%
서 77
 
6.2%
시 76
 
6.1%
로 76
 
6.1%
울 76
 
6.1%
별 75
 
6.0%
특 75
 
6.0%
Other values (64) 445
35.5%

허가(연장)일자
Date

Distinct68
Distinct (%)89.5%
Missing0
Missing (%)0.0%
Memory size740.0 B
Minimum2020-09-08 00:00:00
Maximum2023-08-24 00:00:00
2023-12-12T23:54:55.110985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:54:55.244024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

규격
Text

UNIQUE 

Distinct76
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size740.0 B
2023-12-12T23:54:55.624871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length30
Mean length18.342105
Min length4

Characters and Unicode

Total characters1394
Distinct characters16
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

Unique76 ?
Unique (%)100.0%

Sample

1st row18.7*8 19*8 19*8 18.7*8
2nd row10*9 15.2*9 15.2*9
3rd row12*9.04
4th row5.4*6.8 10.8*6.8 10.8*6.8
5th row16*9
ValueCountFrequency (%)
10*8 3
 
1.7%
18.7*8 2
 
1.2%
16.6*8 2
 
1.2%
25.0*10.0 2
 
1.2%
18.6*10.6 2
 
1.2%
13*8.1 2
 
1.2%
17*8 2
 
1.2%
15*7.5 2
 
1.2%
18*7.5 2
 
1.2%
10.8*6.2 2
 
1.2%
Other values (126) 151
87.8%
2023-12-12T23:54:56.192448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
269
19.3%
. 203
14.6%
1 170
12.2%
* 170
12.2%
5 98
 
7.0%
8 81
 
5.8%
6 72
 
5.2%
7 70
 
5.0%
0 59
 
4.2%
2 55
 
3.9%
Other values (6) 147
10.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 748
53.7%
Other Punctuation 373
26.8%
Space Separator 269
 
19.3%
Other Letter 4
 
0.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 170
22.7%
5 98
13.1%
8 81
10.8%
6 72
9.6%
7 70
9.4%
0 59
 
7.9%
2 55
 
7.4%
9 53
 
7.1%
4 50
 
6.7%
3 40
 
5.3%
Other Letter
ValueCountFrequency (%)
면 2
50.0%
좌 1
25.0%
우 1
25.0%
Other Punctuation
ValueCountFrequency (%)
. 203
54.4%
* 170
45.6%
Space Separator
ValueCountFrequency (%)
269
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1390
99.7%
Hangul 4
 
0.3%

Most frequent character per script

Common
ValueCountFrequency (%)
269
19.4%
. 203
14.6%
1 170
12.2%
* 170
12.2%
5 98
 
7.1%
8 81
 
5.8%
6 72
 
5.2%
7 70
 
5.0%
0 59
 
4.2%
2 55
 
4.0%
Other values (3) 143
10.3%
Hangul
ValueCountFrequency (%)
면 2
50.0%
좌 1
25.0%
우 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1390
99.7%
Hangul 4
 
0.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
269
19.4%
. 203
14.6%
1 170
12.2%
* 170
12.2%
5 98
 
7.1%
8 81
 
5.8%
6 72
 
5.2%
7 70
 
5.0%
0 59
 
4.2%
2 55
 
4.0%
Other values (3) 143
10.3%
Hangul
ValueCountFrequency (%)
면 2
50.0%
좌 1
25.0%
우 1
25.0%

Interactions

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

Correlations

2023-12-12T23:54:56.325519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번광고물 표시 주소허가(연장)일자규격
연번1.0001.0000.9861.000
광고물 표시 주소1.0001.0001.0001.000
허가(연장)일자0.9861.0001.0001.000
규격1.0001.0001.0001.000

Missing values

2023-12-12T23:54:53.602091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:54:53.720307image/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서울특별시 강남구 언주로 703 (논현동)2020-09-0818.7*8 19*8 19*8 18.7*8
12서울특별시 강남구 도산대로 306 옥상층 (논현동)2020-09-0910*9 15.2*9 15.2*9
23서울특별시 강남구 강남대로 642 (신사동)2020-09-1812*9.04
34서울특별시 강남구 언주로 708 (논현동)2020-10-255.4*6.8 10.8*6.8 10.8*6.8
45서울특별시 강남구 언주로 651 (논현동)2020-10-2716*9
56서울특별시 강남구 논현로 508 (역삼동 옥상)2020-11-0410.8*6 10.8*6
67서울특별시 강남구 영동대로 713 (청담동)2020-12-167.8*9.4 7.8*8.3 6.5*9.4 6.5*7.1
78서울특별시 강남구 영동대로 714 (청담동)2021-01-1516*8
89서울특별시 강남구 언주로 714 (논현동)2021-01-2713.4*7.3 11.8*6.3
910서울특별시 강남구 선릉로 704 (청담동)2021-02-1018.5*8.5
연번광고물 표시 주소허가(연장)일자규격
6667서울특별시 강남구 강남대로 412 옥상층 (역삼동 규정빌딩)2023-03-1018.56*8 3.34*8
6768서울특별시 강남구 언주로 634 쌍둥이빌딩 6층 (논현동)2023-04-2011*8
6869서울특별시 강남구 언주로 625 (논현동)2023-05-0113.4*10
6970서울특별시 강남구 도산대로 524 (청담동)2023-05-1020*10 18*10 18*10
7071서울특별시 강남구 테헤란로 626 (대치동)2023-05-2626.53*10 14*10 14.74*10
7172서울특별시 강남구 봉은사로 641 (삼성동)2023-05-2817.55*6.7
7273서울특별시 강남구 영동대로 312 (대치동)2023-06-2920.1*9
7374서울특별시 강남구 도산대로 127 5층 (신사동 경서빌딩)2023-07-069.5*5.8 9.5*5.8
7475서울특별시 강남구 도곡로 454 (대치동)2023-07-3112.6*10
7576서울특별시 강남구 남부순환로 3008 (대치동)2023-08-2412.6*5.4