Overview

Dataset statistics

Number of variables4
Number of observations44
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.5 KiB
Average record size in memory36.0 B

Variable types

Numeric1
Categorical1
Text2

Dataset

Description해당 데이터는 서울특별시 서초구 옥상간판 현황입니다.광고물 종류, 규격, 표시 장소 등의 내용으로 구성되어 있습니다.
Author서울특별시 서초구
URLhttps://www.data.go.kr/data/15124236/fileData.do

Alerts

광고물종류 has constant value ""Constant
순번 has unique valuesUnique
광고물규격(미터) has unique valuesUnique
표시장소 has unique valuesUnique

Reproduction

Analysis started2023-12-12 07:43:53.954592
Analysis finished2023-12-12 07:43:54.294192
Duration0.34 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-12T16:43:54.363772image/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-12T16:43:54.510005image/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 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 (%)
옥상간판 44
100.0%

Length

2023-12-12T16:43:54.635960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:43:54.755525image/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-12T16:43:55.058760image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length43
Median length28
Mean length22.295455
Min length5

Characters and Unicode

Total characters981
Distinct characters13
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
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 row20*7 11.6*7 11.6*7
2nd row13*6.3 8.6*6.3
3rd row13.5*8 13.5*8 15*8 15*8
4th row14*7 14*7
5th row12.8*8.3
ValueCountFrequency (%)
14*7 4
 
3.3%
19.5*9 4
 
3.3%
15*9 4
 
3.3%
20*9 4
 
3.3%
20*7 3
 
2.4%
15*8 3
 
2.4%
4.3*4.3 3
 
2.4%
14.6*6.3 2
 
1.6%
8.5*6 2
 
1.6%
16.3*8 2
 
1.6%
Other values (61) 92
74.8%
2023-12-12T16:43:55.525064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
244
24.9%
. 132
13.5%
* 123
12.5%
1 100
10.2%
5 76
 
7.7%
6 53
 
5.4%
8 48
 
4.9%
7 45
 
4.6%
9 40
 
4.1%
3 34
 
3.5%
Other values (3) 86
 
8.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 482
49.1%
Other Punctuation 255
26.0%
Space Separator 244
24.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 100
20.7%
5 76
15.8%
6 53
11.0%
8 48
10.0%
7 45
9.3%
9 40
 
8.3%
3 34
 
7.1%
4 34
 
7.1%
2 31
 
6.4%
0 21
 
4.4%
Other Punctuation
ValueCountFrequency (%)
. 132
51.8%
* 123
48.2%
Space Separator
ValueCountFrequency (%)
244
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 981
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
244
24.9%
. 132
13.5%
* 123
12.5%
1 100
10.2%
5 76
 
7.7%
6 53
 
5.4%
8 48
 
4.9%
7 45
 
4.6%
9 40
 
4.1%
3 34
 
3.5%
Other values (3) 86
 
8.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 981
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
244
24.9%
. 132
13.5%
* 123
12.5%
1 100
10.2%
5 76
 
7.7%
6 53
 
5.4%
8 48
 
4.9%
7 45
 
4.6%
9 40
 
4.1%
3 34
 
3.5%
Other values (3) 86
 
8.8%

표시장소
Text

UNIQUE 

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

Length

Max length20
Median length18
Mean length17.931818
Min length15

Characters and Unicode

Total characters789
Distinct characters49
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

Unique44 ?
Unique (%)100.0%

Sample

1st row서울특별시 서초구 방배천로2길 22
2nd row서울특별시 서초구 강남대로 603
3rd row서울특별시 서초구 서초대로 286
4th row서울특별시 서초구 강남대로 565
5th row서울특별시 서초구 강남대로 243
ValueCountFrequency (%)
서울특별시 44
25.0%
서초구 44
25.0%
강남대로 15
 
8.5%
서초중앙로 4
 
2.3%
신반포로 3
 
1.7%
사평대로 3
 
1.7%
남부순환로 3
 
1.7%
동작대로 2
 
1.1%
반포대로 2
 
1.1%
서운로1길 2
 
1.1%
Other values (53) 54
30.7%
2023-12-12T16:43:56.141451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
134
17.0%
서 97
12.3%
초 50
 
6.3%
울 44
 
5.6%
특 44
 
5.6%
별 44
 
5.6%
시 44
 
5.6%
구 44
 
5.6%
로 44
 
5.6%
대 24
 
3.0%
Other values (39) 220
27.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 532
67.4%
Space Separator 134
 
17.0%
Decimal Number 122
 
15.5%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 97
18.2%
초 50
9.4%
울 44
8.3%
특 44
8.3%
별 44
8.3%
시 44
8.3%
구 44
8.3%
로 44
8.3%
대 24
 
4.5%
남 18
 
3.4%
Other values (27) 79
14.8%
Decimal Number
ValueCountFrequency (%)
3 21
17.2%
2 18
14.8%
5 17
13.9%
1 14
11.5%
4 12
9.8%
7 11
9.0%
6 10
8.2%
9 8
 
6.6%
8 7
 
5.7%
0 4
 
3.3%
Space Separator
ValueCountFrequency (%)
134
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 532
67.4%
Common 257
32.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 97
18.2%
초 50
9.4%
울 44
8.3%
특 44
8.3%
별 44
8.3%
시 44
8.3%
구 44
8.3%
로 44
8.3%
대 24
 
4.5%
남 18
 
3.4%
Other values (27) 79
14.8%
Common
ValueCountFrequency (%)
134
52.1%
3 21
 
8.2%
2 18
 
7.0%
5 17
 
6.6%
1 14
 
5.4%
4 12
 
4.7%
7 11
 
4.3%
6 10
 
3.9%
9 8
 
3.1%
8 7
 
2.7%
Other values (2) 5
 
1.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 532
67.4%
ASCII 257
32.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
134
52.1%
3 21
 
8.2%
2 18
 
7.0%
5 17
 
6.6%
1 14
 
5.4%
4 12
 
4.7%
7 11
 
4.3%
6 10
 
3.9%
9 8
 
3.1%
8 7
 
2.7%
Other values (2) 5
 
1.9%
Hangul
ValueCountFrequency (%)
서 97
18.2%
초 50
9.4%
울 44
8.3%
특 44
8.3%
별 44
8.3%
시 44
8.3%
구 44
8.3%
로 44
8.3%
대 24
 
4.5%
남 18
 
3.4%
Other values (27) 79
14.8%

Interactions

2023-12-12T16:43:54.076005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T16:43:56.260126image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번광고물규격(미터)표시장소
순번1.0001.0001.000
광고물규격(미터)1.0001.0001.000
표시장소1.0001.0001.000

Missing values

2023-12-12T16:43:54.172256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:43:54.251914image/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옥상간판20*7 11.6*7 11.6*7서울특별시 서초구 방배천로2길 22
12옥상간판13*6.3 8.6*6.3서울특별시 서초구 강남대로 603
23옥상간판13.5*8 13.5*8 15*8 15*8서울특별시 서초구 서초대로 286
34옥상간판14*7 14*7서울특별시 서초구 강남대로 565
45옥상간판12.8*8.3서울특별시 서초구 강남대로 243
56옥상간판16.2*7.7 16.2*7.7 14.4*7.7 14.4*7.7서울특별시 서초구 강남대로 617
67옥상간판19*8.5 14.9*8.5서울특별시 서초구 방배천로 5-3
78옥상간판19.8*11서울특별시 서초구 신반포로 194
89옥상간판17.3*10.1서울특별시 서초구 강남대로 399
910옥상간판20.6*8.5 20.6*8.5 16*8.5 16*8.5서울특별시 서초구 서초중앙로 85
순번광고물종류광고물규격(미터)표시장소
3435옥상간판18.8*10 15*10서울특별시 서초구 신반포로 162
3536옥상간판8.4*5 8.4*5서울특별시 서초구 서운로1길 21
3637옥상간판33.5*9서울특별시 서초구 효령로 304
3738옥상간판20*9 20*9 15.9*9 15.9*9서울특별시 서초구 강남대로 631
3839옥상간판12.8*8.5 12.8*8.5 12.6*8.5 12.6*8.5서울특별시 서초구 남부순환로 2606
3940옥상간판8*1.5서울특별시 서초구 반포대로 217
4041옥상간판18*9.5 10*9.5 15*9.5 16*9.5서울특별시 서초구 신반포로 339
4142옥상간판12.5*8.2서울특별시 서초구 사평대로 373
4243옥상간판14*7 14*7 10*7 10*7서울특별시 서초구 서초중앙로 39
4344옥상간판21.6*4 11*4 11*4서울특별시 서초구 사평대로 84