Overview

Dataset statistics

Number of variables5
Number of observations127
Missing cells63
Missing cells (%)9.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.2 KiB
Average record size in memory42.0 B

Variable types

Numeric1
Text3
DateTime1

Dataset

Description인천광역시 서구 옥외광고사업자 현황(업소명, 영업장 전화번호, 영업장 도로명주소 등) 에 관한 데이터를 제공합니다.
Author인천광역시 서구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15038876&srcSe=7661IVAWM27C61E190

Alerts

데이터기준일자 has constant value ""Constant
영업장전화번호 has 63 (49.6%) missing valuesMissing
순번 has unique valuesUnique

Reproduction

Analysis started2024-01-28 10:21:49.194509
Analysis finished2024-01-28 10:21:49.870674
Duration0.68 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct127
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean64
Minimum1
Maximum127
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.2 KiB
2024-01-28T19:21:49.924757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile7.3
Q132.5
median64
Q395.5
95-th percentile120.7
Maximum127
Range126
Interquartile range (IQR)63

Descriptive statistics

Standard deviation36.805797
Coefficient of variation (CV)0.57509057
Kurtosis-1.2
Mean64
Median Absolute Deviation (MAD)32
Skewness0
Sum8128
Variance1354.6667
MonotonicityStrictly increasing
2024-01-28T19:21:50.037367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.8%
2 1
 
0.8%
95 1
 
0.8%
94 1
 
0.8%
93 1
 
0.8%
92 1
 
0.8%
91 1
 
0.8%
90 1
 
0.8%
89 1
 
0.8%
88 1
 
0.8%
Other values (117) 117
92.1%
ValueCountFrequency (%)
1 1
0.8%
2 1
0.8%
3 1
0.8%
4 1
0.8%
5 1
0.8%
6 1
0.8%
7 1
0.8%
8 1
0.8%
9 1
0.8%
10 1
0.8%
ValueCountFrequency (%)
127 1
0.8%
126 1
0.8%
125 1
0.8%
124 1
0.8%
123 1
0.8%
122 1
0.8%
121 1
0.8%
120 1
0.8%
119 1
0.8%
118 1
0.8%

업소명
Text

Distinct126
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2024-01-28T19:21:50.245162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length12
Mean length6.0944882
Min length2

Characters and Unicode

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

Unique

Unique125 ?
Unique (%)98.4%

Sample

1st row수기획
2nd row주식회사 유에스씨
3rd row간판공방
4th row금보이엔씨
5th row크로바웍스
ValueCountFrequency (%)
주식회사 18
 
11.5%
광고기획 2
 
1.3%
디자인 2
 
1.3%
광고 2
 
1.3%
수기획 2
 
1.3%
a+간판 1
 
0.6%
가나기획 1
 
0.6%
둘리광고 1
 
0.6%
주)광고활력소 1
 
0.6%
주)대흥엠피에스 1
 
0.6%
Other values (126) 126
80.3%
2024-01-28T19:21:50.581895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 42
 
5.4%
인 31
 
4.0%
광 30
 
3.9%
30
 
3.9%
고 28
 
3.6%
사 25
 
3.2%
) 24
 
3.1%
디 24
 
3.1%
( 23
 
3.0%
기 19
 
2.5%
Other values (182) 498
64.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 673
87.0%
Space Separator 30
 
3.9%
Close Punctuation 24
 
3.1%
Open Punctuation 23
 
3.0%
Uppercase Letter 13
 
1.7%
Decimal Number 7
 
0.9%
Other Punctuation 3
 
0.4%
Math Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 42
 
6.2%
인 31
 
4.6%
광 30
 
4.5%
고 28
 
4.2%
사 25
 
3.7%
디 24
 
3.6%
기 19
 
2.8%
자 18
 
2.7%
회 18
 
2.7%
식 18
 
2.7%
Other values (164) 420
62.4%
Uppercase Letter
ValueCountFrequency (%)
A 3
23.1%
I 3
23.1%
G 2
15.4%
M 2
15.4%
C 1
 
7.7%
D 1
 
7.7%
S 1
 
7.7%
Decimal Number
ValueCountFrequency (%)
0 2
28.6%
9 2
28.6%
2 1
14.3%
1 1
14.3%
8 1
14.3%
Other Punctuation
ValueCountFrequency (%)
& 2
66.7%
＆ 1
33.3%
Space Separator
ValueCountFrequency (%)
30
100.0%
Close Punctuation
ValueCountFrequency (%)
) 24
100.0%
Open Punctuation
ValueCountFrequency (%)
( 23
100.0%
Math Symbol
ValueCountFrequency (%)
+ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 673
87.0%
Common 88
 
11.4%
Latin 13
 
1.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 42
 
6.2%
인 31
 
4.6%
광 30
 
4.5%
고 28
 
4.2%
사 25
 
3.7%
디 24
 
3.6%
기 19
 
2.8%
자 18
 
2.7%
회 18
 
2.7%
식 18
 
2.7%
Other values (164) 420
62.4%
Common
ValueCountFrequency (%)
30
34.1%
) 24
27.3%
( 23
26.1%
& 2
 
2.3%
0 2
 
2.3%
9 2
 
2.3%
2 1
 
1.1%
1 1
 
1.1%
8 1
 
1.1%
+ 1
 
1.1%
Latin
ValueCountFrequency (%)
A 3
23.1%
I 3
23.1%
G 2
15.4%
M 2
15.4%
C 1
 
7.7%
D 1
 
7.7%
S 1
 
7.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 673
87.0%
ASCII 100
 
12.9%
None 1
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 42
 
6.2%
인 31
 
4.6%
광 30
 
4.5%
고 28
 
4.2%
사 25
 
3.7%
디 24
 
3.6%
기 19
 
2.8%
자 18
 
2.7%
회 18
 
2.7%
식 18
 
2.7%
Other values (164) 420
62.4%
ASCII
ValueCountFrequency (%)
30
30.0%
) 24
24.0%
( 23
23.0%
A 3
 
3.0%
I 3
 
3.0%
& 2
 
2.0%
0 2
 
2.0%
9 2
 
2.0%
G 2
 
2.0%
M 2
 
2.0%
Other values (7) 7
 
7.0%
None
ValueCountFrequency (%)
＆ 1
100.0%

영업장전화번호
Text

MISSING 

Distinct64
Distinct (%)100.0%
Missing63
Missing (%)49.6%
Memory size1.1 KiB
2024-01-28T19:21:50.788345image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.8125
Min length9

Characters and Unicode

Total characters756
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

Unique64 ?
Unique (%)100.0%

Sample

1st row032-562-0041
2nd row02-305-7771
3rd row032-567-2245
4th row031-986-2111
5th row032-267-7777
ValueCountFrequency (%)
032-562-0041 1
 
1.6%
02-305-7771 1
 
1.6%
032-582-8266 1
 
1.6%
032-563-8486 1
 
1.6%
032-567-8977 1
 
1.6%
032-584-8800 1
 
1.6%
1666-4560 1
 
1.6%
032-891-0344 1
 
1.6%
032-472-7004 1
 
1.6%
032-579-3383 1
 
1.6%
Other values (54) 54
84.4%
2024-01-28T19:21:51.093089image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 125
16.5%
0 102
13.5%
2 99
13.1%
3 85
11.2%
5 84
11.1%
7 65
8.6%
6 60
7.9%
8 41
 
5.4%
4 36
 
4.8%
1 31
 
4.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 631
83.5%
Dash Punctuation 125
 
16.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 102
16.2%
2 99
15.7%
3 85
13.5%
5 84
13.3%
7 65
10.3%
6 60
9.5%
8 41
6.5%
4 36
 
5.7%
1 31
 
4.9%
9 28
 
4.4%
Dash Punctuation
ValueCountFrequency (%)
- 125
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 756
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 125
16.5%
0 102
13.5%
2 99
13.1%
3 85
11.2%
5 84
11.1%
7 65
8.6%
6 60
7.9%
8 41
 
5.4%
4 36
 
4.8%
1 31
 
4.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 756
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 125
16.5%
0 102
13.5%
2 99
13.1%
3 85
11.2%
5 84
11.1%
7 65
8.6%
6 60
7.9%
8 41
 
5.4%
4 36
 
4.8%
1 31
 
4.1%

영업장도로명주소
Text

Distinct123
Distinct (%)96.9%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2024-01-28T19:21:51.295473image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length52
Median length44
Mean length29.259843
Min length21

Characters and Unicode

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

Unique

Unique121 ?
Unique (%)95.3%

Sample

1st row인천광역시 서구 원적로 63, 센트럴시티뷰 921호 (가좌동)
2nd row인천광역시 서구 한서로 66 (백석동)
3rd row인천광역시 서구 봉수대로501번길 25 (원창동)
4th row인천광역시 서구 건지로153번길 11-4 (석남동)
5th row인천광역시 서구 신현로7번길 8, 202호 (신현동, 청실빌라)
ValueCountFrequency (%)
인천광역시 127
 
17.0%
서구 126
 
16.9%
가좌동 32
 
4.3%
석남동 22
 
2.9%
심곡동 8
 
1.1%
청라동 8
 
1.1%
오류동 8
 
1.1%
왕길동 8
 
1.1%
신현동 8
 
1.1%
30 7
 
0.9%
Other values (280) 392
52.5%
2024-01-28T19:21:51.597548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
628
 
16.9%
동 146
 
3.9%
1 138
 
3.7%
광 134
 
3.6%
서 134
 
3.6%
로 132
 
3.6%
인 131
 
3.5%
시 131
 
3.5%
천 129
 
3.5%
) 128
 
3.4%
Other values (185) 1885
50.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2133
57.4%
Space Separator 628
 
16.9%
Decimal Number 590
 
15.9%
Close Punctuation 128
 
3.4%
Open Punctuation 128
 
3.4%
Other Punctuation 74
 
2.0%
Dash Punctuation 25
 
0.7%
Uppercase Letter 7
 
0.2%
Lowercase Letter 2
 
0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 146
 
6.8%
광 134
 
6.3%
서 134
 
6.3%
로 132
 
6.2%
인 131
 
6.1%
시 131
 
6.1%
천 129
 
6.0%
역 128
 
6.0%
구 127
 
6.0%
가 59
 
2.8%
Other values (161) 882
41.4%
Decimal Number
ValueCountFrequency (%)
1 138
23.4%
2 75
12.7%
0 58
9.8%
3 56
9.5%
4 54
 
9.2%
6 51
 
8.6%
5 48
 
8.1%
7 42
 
7.1%
8 38
 
6.4%
9 30
 
5.1%
Uppercase Letter
ValueCountFrequency (%)
B 2
28.6%
T 1
14.3%
K 1
14.3%
A 1
14.3%
G 1
14.3%
J 1
14.3%
Lowercase Letter
ValueCountFrequency (%)
k 1
50.0%
s 1
50.0%
Space Separator
ValueCountFrequency (%)
628
100.0%
Close Punctuation
ValueCountFrequency (%)
) 128
100.0%
Open Punctuation
ValueCountFrequency (%)
( 128
100.0%
Other Punctuation
ValueCountFrequency (%)
, 74
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 25
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2133
57.4%
Common 1574
42.4%
Latin 9
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 146
 
6.8%
광 134
 
6.3%
서 134
 
6.3%
로 132
 
6.2%
인 131
 
6.1%
시 131
 
6.1%
천 129
 
6.0%
역 128
 
6.0%
구 127
 
6.0%
가 59
 
2.8%
Other values (161) 882
41.4%
Common
ValueCountFrequency (%)
628
39.9%
1 138
 
8.8%
) 128
 
8.1%
( 128
 
8.1%
2 75
 
4.8%
, 74
 
4.7%
0 58
 
3.7%
3 56
 
3.6%
4 54
 
3.4%
6 51
 
3.2%
Other values (6) 184
 
11.7%
Latin
ValueCountFrequency (%)
B 2
22.2%
T 1
11.1%
K 1
11.1%
A 1
11.1%
k 1
11.1%
s 1
11.1%
G 1
11.1%
J 1
11.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2133
57.4%
ASCII 1583
42.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
628
39.7%
1 138
 
8.7%
) 128
 
8.1%
( 128
 
8.1%
2 75
 
4.7%
, 74
 
4.7%
0 58
 
3.7%
3 56
 
3.5%
4 54
 
3.4%
6 51
 
3.2%
Other values (14) 193
 
12.2%
Hangul
ValueCountFrequency (%)
동 146
 
6.8%
광 134
 
6.3%
서 134
 
6.3%
로 132
 
6.2%
인 131
 
6.1%
시 131
 
6.1%
천 129
 
6.0%
역 128
 
6.0%
구 127
 
6.0%
가 59
 
2.8%
Other values (161) 882
41.4%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
Minimum2023-08-01 00:00:00
Maximum2023-08-01 00:00:00
2024-01-28T19:21:51.690517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T19:21:51.757693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-01-28T19:21:49.454065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-28T19:21:51.806659image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번영업장전화번호
순번1.0001.000
영업장전화번호1.0001.000

Missing values

2024-01-28T19:21:49.773768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T19:21:49.842471image/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수기획<NA>인천광역시 서구 원적로 63, 센트럴시티뷰 921호 (가좌동)2023-08-01
12주식회사 유에스씨<NA>인천광역시 서구 한서로 66 (백석동)2023-08-01
23간판공방<NA>인천광역시 서구 봉수대로501번길 25 (원창동)2023-08-01
34금보이엔씨<NA>인천광역시 서구 건지로153번길 11-4 (석남동)2023-08-01
45크로바웍스<NA>인천광역시 서구 신현로7번길 8, 202호 (신현동, 청실빌라)2023-08-01
56주영광고032-562-0041인천광역시 서구 열우물로 270-19 (가좌동)2023-08-01
671989디자인<NA>인천광역시 서구 가석로156번길 2 (가좌동)2023-08-01
78MIGA＆MIGA(미가앤미가)02-305-7771인천광역시 서구 가현산로46번안길 21 (대곡동)2023-08-01
89주식회사 아크릴마트<NA>인천광역시 서구 건지로 83, 이레전자(주) (석남동)2023-08-01
910(주)오케이 모닝아트032-567-2245인천광역시 서구 중봉대로 490, 629호 (청라동)2023-08-01
순번업소명영업장전화번호영업장도로명주소데이터기준일자
117118진성디자인<NA>인천광역시 서구 장고개로 245 (가좌동)2023-08-01
118119태양광고032-577-9572인천광역시 서구 여우재로 110 (가좌동)2023-08-01
119120영종광고032-576-4790인천광역시 서구 건지로284번길 1 (가좌동)2023-08-01
120121예전아트<NA>인천광역시 서구 염곡로 208 (석남동)2023-08-01
121122가나기획 광고032-578-5886인천광역시 서구 옻우물로14번길 9 (석남동)2023-08-01
122123A+간판032-583-8406인천광역시 서구 신석로77번길 28 (석남동)2023-08-01
123124둘리광고032-566-7076인천광역시 서구 탁옥로 14 (심곡동,상원빌딩)2023-08-01
124125광고세상032-575-7237인천광역시 서구 염곡로 342-1 (신현동)2023-08-01
125126동인사032-581-7550인천광역시 서구 거북로 65 (석남동,상명상가 1층 103호)2023-08-01
126127유성광고032-583-3445인천광역시 서구 신석로 89 (석남동)2023-08-01