Overview

Dataset statistics

Number of variables6
Number of observations135
Missing cells77
Missing cells (%)9.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.6 KiB
Average record size in memory50.0 B

Variable types

Numeric1
Text4
DateTime1

Dataset

Description남동구 옥외광고업 등록현황에 대한 데이터로 순번, 업소명, 성명, 영업장 전화번호, 영업장 도로명주소, 데이터기준일자를 제공합니다.
Author인천광역시 남동구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=3077609&srcSe=7661IVAWM27C61E190

Alerts

데이터 기준 일자 has constant value ""Constant
영업장전화번호 has 74 (54.8%) missing valuesMissing
영업장도로명주소 has 3 (2.2%) missing valuesMissing
순번 has unique valuesUnique

Reproduction

Analysis started2024-01-28 15:09:55.260742
Analysis finished2024-01-28 15:09:55.973808
Duration0.71 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct135
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean68
Minimum1
Maximum135
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2024-01-29T00:09:56.034184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile7.7
Q134.5
median68
Q3101.5
95-th percentile128.3
Maximum135
Range134
Interquartile range (IQR)67

Descriptive statistics

Standard deviation39.115214
Coefficient of variation (CV)0.57522374
Kurtosis-1.2
Mean68
Median Absolute Deviation (MAD)34
Skewness0
Sum9180
Variance1530
MonotonicityStrictly increasing
2024-01-29T00:09:56.152217image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.7%
94 1
 
0.7%
88 1
 
0.7%
89 1
 
0.7%
90 1
 
0.7%
91 1
 
0.7%
92 1
 
0.7%
93 1
 
0.7%
95 1
 
0.7%
2 1
 
0.7%
Other values (125) 125
92.6%
ValueCountFrequency (%)
1 1
0.7%
2 1
0.7%
3 1
0.7%
4 1
0.7%
5 1
0.7%
6 1
0.7%
7 1
0.7%
8 1
0.7%
9 1
0.7%
10 1
0.7%
ValueCountFrequency (%)
135 1
0.7%
134 1
0.7%
133 1
0.7%
132 1
0.7%
131 1
0.7%
130 1
0.7%
129 1
0.7%
128 1
0.7%
127 1
0.7%
126 1
0.7%

업소명
Text

Distinct133
Distinct (%)98.5%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2024-01-29T00:09:56.395020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length16
Mean length6.3407407
Min length2

Characters and Unicode

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

Unique

Unique131 ?
Unique (%)97.0%

Sample

1st row으뜸광고기획
2nd row(주)레드광고
3rd row디애드프레임
4th row수성광고디자인
5th row서원준팩토리
ValueCountFrequency (%)
주식회사 11
 
7.1%
우석광고 2
 
1.3%
디자인 2
 
1.3%
금강기획 2
 
1.3%
두손광고 1
 
0.6%
바로이게디자인 1
 
0.6%
늘푸른광고기획 1
 
0.6%
베리드 1
 
0.6%
메디애드컴 1
 
0.6%
두손종합광고인쇄간판 1
 
0.6%
Other values (132) 132
85.2%
2024-01-29T00:09:56.740945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
광 41
 
4.8%
고 41
 
4.8%
주 36
 
4.2%
인 30
 
3.5%
) 26
 
3.0%
( 26
 
3.0%
기 25
 
2.9%
이 23
 
2.7%
디 22
 
2.6%
20
 
2.3%
Other values (205) 566
66.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 744
86.9%
Close Punctuation 26
 
3.0%
Open Punctuation 26
 
3.0%
Space Separator 20
 
2.3%
Lowercase Letter 17
 
2.0%
Uppercase Letter 17
 
2.0%
Other Punctuation 4
 
0.5%
Decimal Number 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 41
 
5.5%
고 41
 
5.5%
주 36
 
4.8%
인 30
 
4.0%
기 25
 
3.4%
이 23
 
3.1%
디 22
 
3.0%
드 20
 
2.7%
획 19
 
2.6%
자 19
 
2.6%
Other values (175) 468
62.9%
Uppercase Letter
ValueCountFrequency (%)
D 3
17.6%
M 2
11.8%
L 2
11.8%
O 2
11.8%
A 1
 
5.9%
H 1
 
5.9%
E 1
 
5.9%
K 1
 
5.9%
C 1
 
5.9%
Q 1
 
5.9%
Other values (2) 2
11.8%
Lowercase Letter
ValueCountFrequency (%)
e 3
17.6%
n 3
17.6%
r 2
11.8%
t 2
11.8%
v 1
 
5.9%
a 1
 
5.9%
g 1
 
5.9%
i 1
 
5.9%
s 1
 
5.9%
d 1
 
5.9%
Other Punctuation
ValueCountFrequency (%)
. 2
50.0%
, 2
50.0%
Decimal Number
ValueCountFrequency (%)
1 1
50.0%
2 1
50.0%
Close Punctuation
ValueCountFrequency (%)
) 26
100.0%
Open Punctuation
ValueCountFrequency (%)
( 26
100.0%
Space Separator
ValueCountFrequency (%)
20
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 744
86.9%
Common 78
 
9.1%
Latin 34
 
4.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 41
 
5.5%
고 41
 
5.5%
주 36
 
4.8%
인 30
 
4.0%
기 25
 
3.4%
이 23
 
3.1%
디 22
 
3.0%
드 20
 
2.7%
획 19
 
2.6%
자 19
 
2.6%
Other values (175) 468
62.9%
Latin
ValueCountFrequency (%)
e 3
 
8.8%
D 3
 
8.8%
n 3
 
8.8%
M 2
 
5.9%
r 2
 
5.9%
L 2
 
5.9%
t 2
 
5.9%
O 2
 
5.9%
A 1
 
2.9%
v 1
 
2.9%
Other values (13) 13
38.2%
Common
ValueCountFrequency (%)
) 26
33.3%
( 26
33.3%
20
25.6%
. 2
 
2.6%
, 2
 
2.6%
1 1
 
1.3%
2 1
 
1.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 744
86.9%
ASCII 112
 
13.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
광 41
 
5.5%
고 41
 
5.5%
주 36
 
4.8%
인 30
 
4.0%
기 25
 
3.4%
이 23
 
3.1%
디 22
 
3.0%
드 20
 
2.7%
획 19
 
2.6%
자 19
 
2.6%
Other values (175) 468
62.9%
ASCII
ValueCountFrequency (%)
) 26
23.2%
( 26
23.2%
20
17.9%
e 3
 
2.7%
D 3
 
2.7%
n 3
 
2.7%
M 2
 
1.8%
r 2
 
1.8%
L 2
 
1.8%
. 2
 
1.8%
Other values (20) 23
20.5%

성명
Text

Distinct134
Distinct (%)99.3%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2024-01-29T00:09:57.042016image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length3
Mean length3.0518519
Min length2

Characters and Unicode

Total characters412
Distinct characters118
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

Unique133 ?
Unique (%)98.5%

Sample

1st row전응엽
2nd row조익현
3rd row김석신
4th row김경호
5th row이정주
ValueCountFrequency (%)
채성일 2
 
1.5%
지용현 1
 
0.7%
유정일 1
 
0.7%
이지영 1
 
0.7%
엄건영 1
 
0.7%
최화자 1
 
0.7%
박종수 1
 
0.7%
권준민 1
 
0.7%
문기한 1
 
0.7%
최문환 1
 
0.7%
Other values (124) 124
91.9%
2024-01-29T00:09:57.692632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 25
 
6.1%
이 22
 
5.3%
성 12
 
2.9%
정 12
 
2.9%
박 12
 
2.9%
영 12
 
2.9%
민 9
 
2.2%
수 9
 
2.2%
한 8
 
1.9%
규 8
 
1.9%
Other values (108) 283
68.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 409
99.3%
Close Punctuation 1
 
0.2%
Open Punctuation 1
 
0.2%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 25
 
6.1%
이 22
 
5.4%
성 12
 
2.9%
정 12
 
2.9%
박 12
 
2.9%
영 12
 
2.9%
민 9
 
2.2%
수 9
 
2.2%
한 8
 
2.0%
규 8
 
2.0%
Other values (105) 280
68.5%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 409
99.3%
Common 3
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 25
 
6.1%
이 22
 
5.4%
성 12
 
2.9%
정 12
 
2.9%
박 12
 
2.9%
영 12
 
2.9%
민 9
 
2.2%
수 9
 
2.2%
한 8
 
2.0%
규 8
 
2.0%
Other values (105) 280
68.5%
Common
ValueCountFrequency (%)
) 1
33.3%
( 1
33.3%
, 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 409
99.3%
ASCII 3
 
0.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 25
 
6.1%
이 22
 
5.4%
성 12
 
2.9%
정 12
 
2.9%
박 12
 
2.9%
영 12
 
2.9%
민 9
 
2.2%
수 9
 
2.2%
한 8
 
2.0%
규 8
 
2.0%
Other values (105) 280
68.5%
ASCII
ValueCountFrequency (%)
) 1
33.3%
( 1
33.3%
, 1
33.3%

영업장전화번호
Text

MISSING 

Distinct61
Distinct (%)100.0%
Missing74
Missing (%)54.8%
Memory size1.2 KiB
2024-01-29T00:09:57.905485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.885246
Min length9

Characters and Unicode

Total characters725
Distinct characters11
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique61 ?
Unique (%)100.0%

Sample

1st row032-261-0399
2nd row032-437-1937
3rd row032-281-6717
4th row032-875-1102
5th row032-471-7947
ValueCountFrequency (%)
032-210-6673 1
 
1.6%
1544-6952 1
 
1.6%
032-464-3535 1
 
1.6%
032-463-4642 1
 
1.6%
032-432-5808 1
 
1.6%
032-876-2501 1
 
1.6%
032-461-6699 1
 
1.6%
032-428-0452 1
 
1.6%
032-435-0820 1
 
1.6%
032-472-8166 1
 
1.6%
Other values (51) 51
83.6%
2024-01-29T00:09:58.232188image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 120
16.6%
2 112
15.4%
3 91
12.6%
0 88
12.1%
4 72
9.9%
6 49
6.8%
1 45
 
6.2%
5 43
 
5.9%
7 42
 
5.8%
8 35
 
4.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 605
83.4%
Dash Punctuation 120
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 112
18.5%
3 91
15.0%
0 88
14.5%
4 72
11.9%
6 49
8.1%
1 45
7.4%
5 43
 
7.1%
7 42
 
6.9%
8 35
 
5.8%
9 28
 
4.6%
Dash Punctuation
ValueCountFrequency (%)
- 120
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 725
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 120
16.6%
2 112
15.4%
3 91
12.6%
0 88
12.1%
4 72
9.9%
6 49
6.8%
1 45
 
6.2%
5 43
 
5.9%
7 42
 
5.8%
8 35
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 725
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 120
16.6%
2 112
15.4%
3 91
12.6%
0 88
12.1%
4 72
9.9%
6 49
6.8%
1 45
 
6.2%
5 43
 
5.9%
7 42
 
5.8%
8 35
 
4.8%

영업장도로명주소
Text

MISSING 

Distinct132
Distinct (%)100.0%
Missing3
Missing (%)2.2%
Memory size1.2 KiB
2024-01-29T00:09:58.497471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length58
Median length41
Mean length31.742424
Min length22

Characters and Unicode

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

Unique

Unique132 ?
Unique (%)100.0%

Sample

1st row인천광역시 남동구 경인로 742, 306호 (간석동)
2nd row인천광역시 남동구 선수촌공원로 1, 구월테크노밸리 D동 409호 (구월동)
3rd row인천광역시 남동구 남동대로898번길 80 (간석동, 경인빌리지5차)
4th row인천광역시 남동구 에코중앙로 96, 903동 1702호 (논현동, 에코메트로 9블록 한화 꿈에그린아파트)
5th row인천광역시 남동구 경인로 758 (간석동)
ValueCountFrequency (%)
인천광역시 132
 
16.2%
남동구 132
 
16.2%
구월동 39
 
4.8%
만수동 28
 
3.4%
간석동 24
 
2.9%
1층 19
 
2.3%
고잔동 17
 
2.1%
인주대로 13
 
1.6%
호구포로 12
 
1.5%
백범로 11
 
1.3%
Other values (286) 388
47.6%
2024-01-29T00:09:58.870487image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
683
 
16.3%
동 307
 
7.3%
구 201
 
4.8%
남 159
 
3.8%
인 158
 
3.8%
로 136
 
3.2%
역 134
 
3.2%
시 133
 
3.2%
광 133
 
3.2%
) 133
 
3.2%
Other values (171) 2013
48.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2431
58.0%
Space Separator 683
 
16.3%
Decimal Number 672
 
16.0%
Close Punctuation 135
 
3.2%
Open Punctuation 135
 
3.2%
Other Punctuation 106
 
2.5%
Dash Punctuation 22
 
0.5%
Uppercase Letter 6
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 307
 
12.6%
구 201
 
8.3%
남 159
 
6.5%
인 158
 
6.5%
로 136
 
5.6%
역 134
 
5.5%
시 133
 
5.5%
광 133
 
5.5%
천 133
 
5.5%
호 65
 
2.7%
Other values (147) 872
35.9%
Decimal Number
ValueCountFrequency (%)
1 128
19.0%
2 95
14.1%
3 79
11.8%
0 79
11.8%
5 66
9.8%
7 56
8.3%
6 53
7.9%
4 50
 
7.4%
8 38
 
5.7%
9 28
 
4.2%
Uppercase Letter
ValueCountFrequency (%)
S 1
16.7%
T 1
16.7%
D 1
16.7%
C 1
16.7%
B 1
16.7%
A 1
16.7%
Close Punctuation
ValueCountFrequency (%)
) 133
98.5%
] 2
 
1.5%
Open Punctuation
ValueCountFrequency (%)
( 133
98.5%
[ 2
 
1.5%
Other Punctuation
ValueCountFrequency (%)
, 105
99.1%
/ 1
 
0.9%
Space Separator
ValueCountFrequency (%)
683
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 22
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2431
58.0%
Common 1753
41.8%
Latin 6
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 307
 
12.6%
구 201
 
8.3%
남 159
 
6.5%
인 158
 
6.5%
로 136
 
5.6%
역 134
 
5.5%
시 133
 
5.5%
광 133
 
5.5%
천 133
 
5.5%
호 65
 
2.7%
Other values (147) 872
35.9%
Common
ValueCountFrequency (%)
683
39.0%
) 133
 
7.6%
( 133
 
7.6%
1 128
 
7.3%
, 105
 
6.0%
2 95
 
5.4%
3 79
 
4.5%
0 79
 
4.5%
5 66
 
3.8%
7 56
 
3.2%
Other values (8) 196
 
11.2%
Latin
ValueCountFrequency (%)
S 1
16.7%
T 1
16.7%
D 1
16.7%
C 1
16.7%
B 1
16.7%
A 1
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2431
58.0%
ASCII 1759
42.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
683
38.8%
) 133
 
7.6%
( 133
 
7.6%
1 128
 
7.3%
, 105
 
6.0%
2 95
 
5.4%
3 79
 
4.5%
0 79
 
4.5%
5 66
 
3.8%
7 56
 
3.2%
Other values (14) 202
 
11.5%
Hangul
ValueCountFrequency (%)
동 307
 
12.6%
구 201
 
8.3%
남 159
 
6.5%
인 158
 
6.5%
로 136
 
5.6%
역 134
 
5.5%
시 133
 
5.5%
광 133
 
5.5%
천 133
 
5.5%
호 65
 
2.7%
Other values (147) 872
35.9%

데이터 기준 일자
Date

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
Minimum2023-05-17 00:00:00
Maximum2023-05-17 00:00:00
2024-01-29T00:09:58.969288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-29T00:09:59.043159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-01-29T00:09:55.615424image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-29T00:09:59.098262image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번영업장전화번호
순번1.0001.000
영업장전화번호1.0001.000

Missing values

2024-01-29T00:09:55.744830image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-29T00:09:55.850637image/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.
2024-01-29T00:09:55.933375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

순번업소명성명영업장전화번호영업장도로명주소데이터 기준 일자
01으뜸광고기획전응엽<NA>인천광역시 남동구 경인로 742, 306호 (간석동)2023-05-17
12(주)레드광고조익현<NA>인천광역시 남동구 선수촌공원로 1, 구월테크노밸리 D동 409호 (구월동)2023-05-17
23디애드프레임김석신032-261-0399<NA>2023-05-17
34수성광고디자인김경호032-437-1937인천광역시 남동구 남동대로898번길 80 (간석동, 경인빌리지5차)2023-05-17
45서원준팩토리이정주<NA>인천광역시 남동구 에코중앙로 96, 903동 1702호 (논현동, 에코메트로 9블록 한화 꿈에그린아파트)2023-05-17
56플러스주영민032-281-6717인천광역시 남동구 경인로 758 (간석동)2023-05-17
67나라광고이시우032-875-1102인천광역시 남동구 백범로226번길 55, 101호 (만수동, 선진맨션)2023-05-17
78이음지알피박종섭<NA>인천광역시 남동구 호구포로 189, 남동테크노타워 지식산업센터 127호 (고잔동)2023-05-17
89천사광고박상식032-471-7947인천광역시 남동구 인주대로710번길 39, 1층 (구월동)2023-05-17
910가나안광고기획홍운희032-467-4747인천광역시 남동구 인주대로 805 (구월동)2023-05-17
순번업소명성명영업장전화번호영업장도로명주소데이터 기준 일자
125126이미지파워장수혁032-525-7410인천광역시 남동구 예술로 334 (간석동)2023-05-17
126127흥수기획오석환032-468-5527인천광역시 남동구 하촌로45번길 12, 1층 4호 (만수동)2023-05-17
127128푸른종합광고이경자032-439-2702인천광역시 남동구 경인로 652 (간석동)2023-05-17
128129평화종합광고권정수032-421-7397인천광역시 남동구 남동대로 737-1 (구월동)2023-05-17
129130중앙현수막손만석032-423-4073인천광역시 남동구 백범로 267 (간석동)2023-05-17
130131아트피아광고김극화032-469-2731인천광역시 남동구 인주대로 705 (구월동,청솔상가)2023-05-17
131132아트클릭신정철032-472-9265인천광역시 남동구 구월로 334, 2층호 (만수동)2023-05-17
132133아주종합광고김명호032-461-9965인천광역시 남동구 인주대로 785 (구월동)2023-05-17
133134두손광고윤용건032-431-2993인천광역시 남동구 인주대로 545 (구월동)2023-05-17
134135경신광고이현미032-468-8811인천광역시 남동구 장승남로47번길 32-11 (만수동)2023-05-17