Overview

Dataset statistics

Number of variables5
Number of observations141
Missing cells45
Missing cells (%)6.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.6 KiB
Average record size in memory40.9 B

Variable types

Categorical1
Text3
DateTime1

Dataset

Description인천광역시 중구 유흥주점 및 단란주점에 대한 정보입니다.파일명 인천광역시 중구 유흥주점 및 단란주점 현황내용 업종명, 업소명, 소재지(도로명) 등
Author인천광역시 중구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15066579&srcSe=7661IVAWM27C61E190

Alerts

데이터기준일자 has constant value ""Constant
소재지전화 has 45 (31.9%) missing valuesMissing

Reproduction

Analysis started2024-01-28 13:38:12.392678
Analysis finished2024-01-28 13:38:12.818124
Duration0.43 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

Distinct2
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
유흥주점영업
86 
단란주점
55 

Length

Max length6
Median length6
Mean length5.2198582
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row유흥주점영업
2nd row유흥주점영업
3rd row유흥주점영업
4th row유흥주점영업
5th row유흥주점영업

Common Values

ValueCountFrequency (%)
유흥주점영업 86
61.0%
단란주점 55
39.0%

Length

2024-01-28T22:38:12.876408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T22:38:12.966991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유흥주점영업 86
61.0%
단란주점 55
39.0%

업소명
Text

Distinct140
Distinct (%)99.3%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2024-01-28T22:38:13.192203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length14
Mean length6.0070922
Min length1

Characters and Unicode

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

Unique

Unique139 ?
Unique (%)98.6%

Sample

1st row위스키메리(외국인전용)
2nd row디가디가노래타운
3rd row향도 노래천국
4th row거래처
5th row미
ValueCountFrequency (%)
노래타운 4
 
2.4%
단란주점 3
 
1.8%
노래짱 2
 
1.2%
강남 2
 
1.2%
노래하는 2
 
1.2%
두바이 2
 
1.2%
파티파티노래클럽 2
 
1.2%
연인단란주점 1
 
0.6%
등불 1
 
0.6%
스테이션 1
 
0.6%
Other values (148) 148
88.1%
2024-01-28T22:38:13.546955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
래 52
 
6.1%
노 50
 
5.9%
0 28
 
3.3%
27
 
3.2%
주 21
 
2.5%
운 20
 
2.4%
이 20
 
2.4%
점 19
 
2.2%
타 19
 
2.2%
스 18
 
2.1%
Other values (222) 573
67.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 680
80.3%
Decimal Number 57
 
6.7%
Uppercase Letter 44
 
5.2%
Space Separator 27
 
3.2%
Lowercase Letter 18
 
2.1%
Close Punctuation 8
 
0.9%
Open Punctuation 8
 
0.9%
Letter Number 3
 
0.4%
Math Symbol 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
래 52
 
7.6%
노 50
 
7.4%
주 21
 
3.1%
운 20
 
2.9%
이 20
 
2.9%
점 19
 
2.8%
타 19
 
2.8%
스 18
 
2.6%
라 16
 
2.4%
럽 13
 
1.9%
Other values (179) 432
63.5%
Uppercase Letter
ValueCountFrequency (%)
P 5
11.4%
L 4
9.1%
R 4
9.1%
I 4
9.1%
E 4
9.1%
V 3
 
6.8%
A 3
 
6.8%
O 3
 
6.8%
B 3
 
6.8%
M 2
 
4.5%
Other values (8) 9
20.5%
Lowercase Letter
ValueCountFrequency (%)
a 4
22.2%
e 3
16.7%
v 2
11.1%
i 1
 
5.6%
l 1
 
5.6%
c 1
 
5.6%
n 1
 
5.6%
u 1
 
5.6%
k 1
 
5.6%
w 1
 
5.6%
Other values (2) 2
11.1%
Decimal Number
ValueCountFrequency (%)
0 28
49.1%
7 14
24.6%
8 13
22.8%
3 1
 
1.8%
1 1
 
1.8%
Letter Number
ValueCountFrequency (%)
Ⅱ 1
33.3%
Ⅲ 1
33.3%
Ⅰ 1
33.3%
Math Symbol
ValueCountFrequency (%)
> 1
50.0%
< 1
50.0%
Space Separator
ValueCountFrequency (%)
27
100.0%
Close Punctuation
ValueCountFrequency (%)
) 8
100.0%
Open Punctuation
ValueCountFrequency (%)
( 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 680
80.3%
Common 102
 
12.0%
Latin 65
 
7.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
래 52
 
7.6%
노 50
 
7.4%
주 21
 
3.1%
운 20
 
2.9%
이 20
 
2.9%
점 19
 
2.8%
타 19
 
2.8%
스 18
 
2.6%
라 16
 
2.4%
럽 13
 
1.9%
Other values (179) 432
63.5%
Latin
ValueCountFrequency (%)
P 5
 
7.7%
L 4
 
6.2%
a 4
 
6.2%
R 4
 
6.2%
I 4
 
6.2%
E 4
 
6.2%
V 3
 
4.6%
A 3
 
4.6%
e 3
 
4.6%
O 3
 
4.6%
Other values (23) 28
43.1%
Common
ValueCountFrequency (%)
0 28
27.5%
27
26.5%
7 14
13.7%
8 13
12.7%
) 8
 
7.8%
( 8
 
7.8%
> 1
 
1.0%
< 1
 
1.0%
3 1
 
1.0%
1 1
 
1.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 680
80.3%
ASCII 164
 
19.4%
Number Forms 3
 
0.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
래 52
 
7.6%
노 50
 
7.4%
주 21
 
3.1%
운 20
 
2.9%
이 20
 
2.9%
점 19
 
2.8%
타 19
 
2.8%
스 18
 
2.6%
라 16
 
2.4%
럽 13
 
1.9%
Other values (179) 432
63.5%
ASCII
ValueCountFrequency (%)
0 28
17.1%
27
16.5%
7 14
 
8.5%
8 13
 
7.9%
) 8
 
4.9%
( 8
 
4.9%
P 5
 
3.0%
L 4
 
2.4%
a 4
 
2.4%
R 4
 
2.4%
Other values (30) 49
29.9%
Number Forms
ValueCountFrequency (%)
Ⅱ 1
33.3%
Ⅲ 1
33.3%
Ⅰ 1
33.3%

소재지
Text

Distinct137
Distinct (%)97.2%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2024-01-28T22:38:14.093402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length50
Median length39
Mean length31.460993
Min length21

Characters and Unicode

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

Unique

Unique133 ?
Unique (%)94.3%

Sample

1st row인천광역시 중구 개항로 5 (중앙동4가)
2nd row인천광역시 중구 홍예문로98번길 9 (인현동)
3rd row인천광역시 중구 서해대로 462-3 (신흥동2가, 1-35번지 1층)
4th row인천광역시 중구 신포로27번길 32 (관동2가)
5th row인천광역시 중구 신포로23번길 32 (중앙동3가, 1층)
ValueCountFrequency (%)
인천광역시 141
 
16.5%
중구 141
 
16.5%
지하1층 34
 
4.0%
2층 32
 
3.8%
운서동 25
 
2.9%
중앙동4가 20
 
2.3%
1층 16
 
1.9%
항동7가 12
 
1.4%
중앙동3가 11
 
1.3%
개항로 11
 
1.3%
Other values (194) 410
48.1%
2024-01-28T22:38:14.457515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
712
 
16.1%
1 195
 
4.4%
중 184
 
4.1%
시 161
 
3.6%
인 152
 
3.4%
2 151
 
3.4%
( 144
 
3.2%
) 143
 
3.2%
천 142
 
3.2%
로 142
 
3.2%
Other values (120) 2310
52.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2490
56.1%
Decimal Number 766
 
17.3%
Space Separator 712
 
16.1%
Open Punctuation 144
 
3.2%
Close Punctuation 143
 
3.2%
Other Punctuation 129
 
2.9%
Dash Punctuation 46
 
1.0%
Uppercase Letter 5
 
0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
중 184
 
7.4%
시 161
 
6.5%
인 152
 
6.1%
천 142
 
5.7%
로 142
 
5.7%
광 141
 
5.7%
역 141
 
5.7%
구 141
 
5.7%
동 141
 
5.7%
층 95
 
3.8%
Other values (103) 1050
42.2%
Decimal Number
ValueCountFrequency (%)
1 195
25.5%
2 151
19.7%
3 117
15.3%
4 78
 
10.2%
0 46
 
6.0%
5 44
 
5.7%
7 42
 
5.5%
9 33
 
4.3%
6 33
 
4.3%
8 27
 
3.5%
Space Separator
ValueCountFrequency (%)
712
100.0%
Open Punctuation
ValueCountFrequency (%)
( 144
100.0%
Close Punctuation
ValueCountFrequency (%)
) 143
100.0%
Other Punctuation
ValueCountFrequency (%)
, 129
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 46
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 5
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2490
56.1%
Common 1941
43.8%
Latin 5
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
중 184
 
7.4%
시 161
 
6.5%
인 152
 
6.1%
천 142
 
5.7%
로 142
 
5.7%
광 141
 
5.7%
역 141
 
5.7%
구 141
 
5.7%
동 141
 
5.7%
층 95
 
3.8%
Other values (103) 1050
42.2%
Common
ValueCountFrequency (%)
712
36.7%
1 195
 
10.0%
2 151
 
7.8%
( 144
 
7.4%
) 143
 
7.4%
, 129
 
6.6%
3 117
 
6.0%
4 78
 
4.0%
0 46
 
2.4%
- 46
 
2.4%
Other values (6) 180
 
9.3%
Latin
ValueCountFrequency (%)
B 5
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2490
56.1%
ASCII 1946
43.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
712
36.6%
1 195
 
10.0%
2 151
 
7.8%
( 144
 
7.4%
) 143
 
7.3%
, 129
 
6.6%
3 117
 
6.0%
4 78
 
4.0%
0 46
 
2.4%
- 46
 
2.4%
Other values (7) 185
 
9.5%
Hangul
ValueCountFrequency (%)
중 184
 
7.4%
시 161
 
6.5%
인 152
 
6.1%
천 142
 
5.7%
로 142
 
5.7%
광 141
 
5.7%
역 141
 
5.7%
구 141
 
5.7%
동 141
 
5.7%
층 95
 
3.8%
Other values (103) 1050
42.2%

소재지전화
Text

MISSING 

Distinct94
Distinct (%)97.9%
Missing45
Missing (%)31.9%
Memory size1.2 KiB
2024-01-28T22:38:14.699555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length14
Mean length14
Min length14

Characters and Unicode

Total characters1344
Distinct characters12
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

Unique93 ?
Unique (%)96.9%

Sample

1st row032 -772 -7542
2nd row032 - 883-5611
3rd row032 - 765-2430
4th row032 - 762-4443
5th row032 - 884-3327
ValueCountFrequency (%)
032 95
37.8%
31
 
12.4%
777 4
 
1.6%
765 4
 
1.6%
746 4
 
1.6%
766 3
 
1.2%
746-0806 3
 
1.2%
773 2
 
0.8%
7494 2
 
0.8%
751-9748 1
 
0.4%
Other values (102) 102
40.6%
2024-01-28T22:38:15.041597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 192
14.3%
191
14.2%
2 157
11.7%
7 156
11.6%
0 151
11.2%
3 148
11.0%
8 83
6.2%
6 82
6.1%
5 57
 
4.2%
1 52
 
3.9%
Other values (2) 75
 
5.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 961
71.5%
Dash Punctuation 192
 
14.3%
Space Separator 191
 
14.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 157
16.3%
7 156
16.2%
0 151
15.7%
3 148
15.4%
8 83
8.6%
6 82
8.5%
5 57
 
5.9%
1 52
 
5.4%
4 49
 
5.1%
9 26
 
2.7%
Dash Punctuation
ValueCountFrequency (%)
- 192
100.0%
Space Separator
ValueCountFrequency (%)
191
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1344
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 192
14.3%
191
14.2%
2 157
11.7%
7 156
11.6%
0 151
11.2%
3 148
11.0%
8 83
6.2%
6 82
6.1%
5 57
 
4.2%
1 52
 
3.9%
Other values (2) 75
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1344
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 192
14.3%
191
14.2%
2 157
11.7%
7 156
11.6%
0 151
11.2%
3 148
11.0%
8 83
6.2%
6 82
6.1%
5 57
 
4.2%
1 52
 
3.9%
Other values (2) 75
 
5.6%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
Minimum2023-07-05 00:00:00
Maximum2023-07-05 00:00:00
2024-01-28T22:38:15.145500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T22:38:15.219951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2024-01-28T22:38:15.275531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종명소재지전화
업종명1.0001.000
소재지전화1.0001.000

Missing values

2024-01-28T22:38:12.696924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T22:38:12.784388image/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유흥주점영업위스키메리(외국인전용)인천광역시 중구 개항로 5 (중앙동4가)<NA>2023-07-05
1유흥주점영업디가디가노래타운인천광역시 중구 홍예문로98번길 9 (인현동)032 -772 -75422023-07-05
2유흥주점영업향도 노래천국인천광역시 중구 서해대로 462-3 (신흥동2가, 1-35번지 1층)032 - 883-56112023-07-05
3유흥주점영업거래처인천광역시 중구 신포로27번길 32 (관동2가)032 - 765-24302023-07-05
4유흥주점영업미인천광역시 중구 신포로23번길 32 (중앙동3가, 1층)032 - 762-44432023-07-05
5유흥주점영업첼로노래타운인천광역시 중구 서해대로 462-2, 2층 (신흥동2가)032 - 884-33272023-07-05
6유흥주점영업씽씽가요방인천광역시 중구 큰우물로 13 (용동)032 - 772-97752023-07-05
7유흥주점영업사탕인천광역시 중구 신포로23번길 9 (중앙동4가)032 -777 -03242023-07-05
8유흥주점영업카카오 노래바인천광역시 중구 홍예문로 13-2 (중앙동3가)032 - 772-31102023-07-05
9유흥주점영업1학년3반 노래타운인천광역시 중구 제물량로 81 (신흥동2가)032- 762-17202023-07-05
업종명업소명소재지소재지전화데이터기준일자
131단란주점오션노래타운인천광역시 중구 은하수로 1, 오션뷰 402호 (중산동)<NA>2023-07-05
132단란주점바커스7080인천광역시 중구 흰바위로 37, 영종프라자 303호 (운서동)<NA>2023-07-05
133단란주점PINOY PUB 앤 RESTO BAR인천광역시 중구 신포로35번길 3, 지하1층 (관동3가)<NA>2023-07-05
134단란주점라스칼라(Lascala)주점인천광역시 중구 큰우물로 22, 1층 (용동)<NA>2023-07-05
135단란주점버즈LIVE인천광역시 중구 은하수로 42, 7층 704호 (중산동)<NA>2023-07-05
136단란주점채플린인천광역시 중구 연안부두로33번길 24, 지하1층 (항동7가)070 -4353-07712023-07-05
137단란주점두바이 노래타운인천광역시 중구 은하수로29번길 47, 지하1층 B01-2호 (중산동)<NA>2023-07-05
138단란주점노래하는 술창고인천광역시 중구 연안부두로 13, 2층 (항동7가)<NA>2023-07-05
139단란주점헤이노래타운인천광역시 중구 신도시남로141번길 9, 골드프라자 4층 404호 (운서동)<NA>2023-07-05
140단란주점거해7080인천광역시 중구 은하수로 28, 로데오프라자 2층 201호 (중산동)032 -746 -22702023-07-05