Overview

Dataset statistics

Number of variables4
Number of observations173
Missing cells70
Missing cells (%)10.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.7 KiB
Average record size in memory33.8 B

Variable types

Numeric1
Text3

Dataset

Description인천광역시 부평구 유흥주점 현황 데이터는 유흥주점 업소명, 업소 소재지, 업소 전화번호에 대한 데이터를 제공합니다.
Author인천광역시 부평구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15104148&srcSe=7661IVAWM27C61E190

Alerts

소재지(도로명) has 4 (2.3%) missing valuesMissing
소재지전화 has 66 (38.2%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2024-01-28 15:10:28.579487
Analysis finished2024-01-28 15:10:29.122963
Duration0.54 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct173
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean87
Minimum1
Maximum173
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2024-01-29T00:10:29.177677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile9.6
Q144
median87
Q3130
95-th percentile164.4
Maximum173
Range172
Interquartile range (IQR)86

Descriptive statistics

Standard deviation50.084928
Coefficient of variation (CV)0.57568883
Kurtosis-1.2
Mean87
Median Absolute Deviation (MAD)43
Skewness0
Sum15051
Variance2508.5
MonotonicityStrictly increasing
2024-01-29T00:10:29.289792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.6%
120 1
 
0.6%
112 1
 
0.6%
113 1
 
0.6%
114 1
 
0.6%
115 1
 
0.6%
116 1
 
0.6%
117 1
 
0.6%
118 1
 
0.6%
119 1
 
0.6%
Other values (163) 163
94.2%
ValueCountFrequency (%)
1 1
0.6%
2 1
0.6%
3 1
0.6%
4 1
0.6%
5 1
0.6%
6 1
0.6%
7 1
0.6%
8 1
0.6%
9 1
0.6%
10 1
0.6%
ValueCountFrequency (%)
173 1
0.6%
172 1
0.6%
171 1
0.6%
170 1
0.6%
169 1
0.6%
168 1
0.6%
167 1
0.6%
166 1
0.6%
165 1
0.6%
164 1
0.6%

업소명
Text

Distinct164
Distinct (%)94.8%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
2024-01-29T00:10:29.497656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length12
Mean length5.7976879
Min length1

Characters and Unicode

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

Unique

Unique155 ?
Unique (%)89.6%

Sample

1st row개구리
2nd row챠밍노래클럽
3rd row꼭지노래클럽
4th row루이베트남노래클럽
5th row삼정노래짱
ValueCountFrequency (%)
노래클럽 3
 
1.6%
발리노래클럽 2
 
1.1%
노래타운 2
 
1.1%
백악관 2
 
1.1%
수노래클럽 2
 
1.1%
대박노래클럽 2
 
1.1%
쎄븐노래클럽 2
 
1.1%
갤러리 2
 
1.1%
망고노래클럽 2
 
1.1%
빙고 2
 
1.1%
Other values (159) 161
88.5%
2024-01-29T00:10:29.811112image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
노 113
 
11.3%
래 112
 
11.2%
럽 74
 
7.4%
클 74
 
7.4%
이 17
 
1.7%
스 16
 
1.6%
( 15
 
1.5%
) 15
 
1.5%
주 13
 
1.3%
점 12
 
1.2%
Other values (222) 542
54.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 909
90.6%
Uppercase Letter 32
 
3.2%
Open Punctuation 15
 
1.5%
Close Punctuation 15
 
1.5%
Decimal Number 15
 
1.5%
Space Separator 9
 
0.9%
Lowercase Letter 6
 
0.6%
Letter Number 1
 
0.1%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
노 113
 
12.4%
래 112
 
12.3%
럽 74
 
8.1%
클 74
 
8.1%
이 17
 
1.9%
스 16
 
1.8%
주 13
 
1.4%
점 12
 
1.3%
마 11
 
1.2%
리 10
 
1.1%
Other values (192) 457
50.3%
Uppercase Letter
ValueCountFrequency (%)
M 4
12.5%
S 4
12.5%
K 3
9.4%
B 3
9.4%
N 3
9.4%
E 3
9.4%
G 2
 
6.2%
O 2
 
6.2%
I 2
 
6.2%
Y 1
 
3.1%
Other values (5) 5
15.6%
Decimal Number
ValueCountFrequency (%)
1 7
46.7%
0 3
20.0%
3 2
 
13.3%
5 2
 
13.3%
2 1
 
6.7%
Lowercase Letter
ValueCountFrequency (%)
s 2
33.3%
o 1
16.7%
e 1
16.7%
h 1
16.7%
t 1
16.7%
Open Punctuation
ValueCountFrequency (%)
( 15
100.0%
Close Punctuation
ValueCountFrequency (%)
) 15
100.0%
Space Separator
ValueCountFrequency (%)
9
100.0%
Letter Number
ValueCountFrequency (%)
Ⅱ 1
100.0%
Other Punctuation
ValueCountFrequency (%)
# 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 906
90.3%
Common 55
 
5.5%
Latin 39
 
3.9%
Han 3
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
노 113
 
12.5%
래 112
 
12.4%
럽 74
 
8.2%
클 74
 
8.2%
이 17
 
1.9%
스 16
 
1.8%
주 13
 
1.4%
점 12
 
1.3%
마 11
 
1.2%
리 10
 
1.1%
Other values (189) 454
50.1%
Latin
ValueCountFrequency (%)
M 4
 
10.3%
S 4
 
10.3%
K 3
 
7.7%
B 3
 
7.7%
N 3
 
7.7%
E 3
 
7.7%
G 2
 
5.1%
O 2
 
5.1%
s 2
 
5.1%
I 2
 
5.1%
Other values (11) 11
28.2%
Common
ValueCountFrequency (%)
( 15
27.3%
) 15
27.3%
9
16.4%
1 7
12.7%
0 3
 
5.5%
3 2
 
3.6%
5 2
 
3.6%
2 1
 
1.8%
# 1
 
1.8%
Han
ValueCountFrequency (%)
車 1
33.3%
品 1
33.3%
名 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 906
90.3%
ASCII 93
 
9.3%
CJK 3
 
0.3%
Number Forms 1
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
노 113
 
12.5%
래 112
 
12.4%
럽 74
 
8.2%
클 74
 
8.2%
이 17
 
1.9%
스 16
 
1.8%
주 13
 
1.4%
점 12
 
1.3%
마 11
 
1.2%
리 10
 
1.1%
Other values (189) 454
50.1%
ASCII
ValueCountFrequency (%)
( 15
16.1%
) 15
16.1%
9
 
9.7%
1 7
 
7.5%
M 4
 
4.3%
S 4
 
4.3%
K 3
 
3.2%
B 3
 
3.2%
N 3
 
3.2%
E 3
 
3.2%
Other values (19) 27
29.0%
CJK
ValueCountFrequency (%)
車 1
33.3%
品 1
33.3%
名 1
33.3%
Number Forms
ValueCountFrequency (%)
Ⅱ 1
100.0%

소재지(도로명)
Text

MISSING 

Distinct166
Distinct (%)98.2%
Missing4
Missing (%)2.3%
Memory size1.5 KiB
2024-01-29T00:10:30.017766image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length42
Mean length29.863905
Min length22

Characters and Unicode

Total characters5047
Distinct characters100
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

Unique163 ?
Unique (%)96.4%

Sample

1st row인천광역시 부평구 부평대로 44 (부평동)
2nd row인천광역시 부평구 부평문화로 54 (부평동)
3rd row인천광역시 부평구 시장로 38 (부평동)
4th row인천광역시 부평구 부평대로32번길 7 (부평동)
5th row인천광역시 부평구 열우물로 45 (십정동, 지하1층 일부)
ValueCountFrequency (%)
인천광역시 169
17.7%
부평구 169
17.7%
부평동 109
 
11.4%
지하1층 28
 
2.9%
시장로 21
 
2.2%
십정동 20
 
2.1%
2층 16
 
1.7%
경원대로1403번길 15
 
1.6%
열우물로 14
 
1.5%
부평동,지하1층 12
 
1.3%
Other values (193) 384
40.1%
2024-01-29T00:10:30.329784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
788
 
15.6%
부 375
 
7.4%
평 341
 
6.8%
시 209
 
4.1%
1 208
 
4.1%
) 186
 
3.7%
( 186
 
3.7%
광 177
 
3.5%
동 177
 
3.5%
인 169
 
3.3%
Other values (90) 2231
44.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3036
60.2%
Space Separator 788
 
15.6%
Decimal Number 714
 
14.1%
Close Punctuation 186
 
3.7%
Open Punctuation 186
 
3.7%
Other Punctuation 109
 
2.2%
Dash Punctuation 19
 
0.4%
Uppercase Letter 9
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
부 375
12.4%
평 341
 
11.2%
시 209
 
6.9%
광 177
 
5.8%
동 177
 
5.8%
인 169
 
5.6%
역 169
 
5.6%
구 169
 
5.6%
천 169
 
5.6%
로 169
 
5.6%
Other values (69) 912
30.0%
Decimal Number
ValueCountFrequency (%)
1 208
29.1%
3 109
15.3%
4 92
12.9%
2 86
12.0%
0 62
 
8.7%
7 41
 
5.7%
6 38
 
5.3%
5 31
 
4.3%
8 29
 
4.1%
9 18
 
2.5%
Uppercase Letter
ValueCountFrequency (%)
E 3
33.3%
B 2
22.2%
N 1
 
11.1%
V 1
 
11.1%
L 1
 
11.1%
A 1
 
11.1%
Space Separator
ValueCountFrequency (%)
788
100.0%
Close Punctuation
ValueCountFrequency (%)
) 186
100.0%
Open Punctuation
ValueCountFrequency (%)
( 186
100.0%
Other Punctuation
ValueCountFrequency (%)
, 109
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 19
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3036
60.2%
Common 2002
39.7%
Latin 9
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
부 375
12.4%
평 341
 
11.2%
시 209
 
6.9%
광 177
 
5.8%
동 177
 
5.8%
인 169
 
5.6%
역 169
 
5.6%
구 169
 
5.6%
천 169
 
5.6%
로 169
 
5.6%
Other values (69) 912
30.0%
Common
ValueCountFrequency (%)
788
39.4%
1 208
 
10.4%
) 186
 
9.3%
( 186
 
9.3%
3 109
 
5.4%
, 109
 
5.4%
4 92
 
4.6%
2 86
 
4.3%
0 62
 
3.1%
7 41
 
2.0%
Other values (5) 135
 
6.7%
Latin
ValueCountFrequency (%)
E 3
33.3%
B 2
22.2%
N 1
 
11.1%
V 1
 
11.1%
L 1
 
11.1%
A 1
 
11.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3036
60.2%
ASCII 2011
39.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
788
39.2%
1 208
 
10.3%
) 186
 
9.2%
( 186
 
9.2%
3 109
 
5.4%
, 109
 
5.4%
4 92
 
4.6%
2 86
 
4.3%
0 62
 
3.1%
7 41
 
2.0%
Other values (11) 144
 
7.2%
Hangul
ValueCountFrequency (%)
부 375
12.4%
평 341
 
11.2%
시 209
 
6.9%
광 177
 
5.8%
동 177
 
5.8%
인 169
 
5.6%
역 169
 
5.6%
구 169
 
5.6%
천 169
 
5.6%
로 169
 
5.6%
Other values (69) 912
30.0%

소재지전화
Text

MISSING 

Distinct106
Distinct (%)99.1%
Missing66
Missing (%)38.2%
Memory size1.5 KiB
2024-01-29T00:10:30.519393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique105 ?
Unique (%)98.1%

Sample

1st row032-507-3895
2nd row032-528-1870
3rd row032-523-9777
4th row032-528-4523
5th row032-437-3449
ValueCountFrequency (%)
032-506-4888 2
 
1.9%
032-423-6886 1
 
0.9%
032-505-9338 1
 
0.9%
032-504-9755 1
 
0.9%
032-330-8827 1
 
0.9%
032-330-0510 1
 
0.9%
032-514-0777 1
 
0.9%
032-506-0989 1
 
0.9%
032-505-0802 1
 
0.9%
032-501-0257 1
 
0.9%
Other values (96) 96
89.7%
2024-01-29T00:10:30.826728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 214
16.7%
2 207
16.1%
0 195
15.2%
3 177
13.8%
5 131
10.2%
1 87
6.8%
8 66
 
5.1%
7 61
 
4.8%
6 57
 
4.4%
4 55
 
4.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1070
83.3%
Dash Punctuation 214
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 207
19.3%
0 195
18.2%
3 177
16.5%
5 131
12.2%
1 87
8.1%
8 66
 
6.2%
7 61
 
5.7%
6 57
 
5.3%
4 55
 
5.1%
9 34
 
3.2%
Dash Punctuation
ValueCountFrequency (%)
- 214
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1284
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 214
16.7%
2 207
16.1%
0 195
15.2%
3 177
13.8%
5 131
10.2%
1 87
6.8%
8 66
 
5.1%
7 61
 
4.8%
6 57
 
4.4%
4 55
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1284
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 214
16.7%
2 207
16.1%
0 195
15.2%
3 177
13.8%
5 131
10.2%
1 87
6.8%
8 66
 
5.1%
7 61
 
4.8%
6 57
 
4.4%
4 55
 
4.3%

Interactions

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

Missing values

2024-01-29T00:10:28.925008image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-29T00:10:29.017154image/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:10:29.085503image/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개구리인천광역시 부평구 부평대로 44 (부평동)032-507-3895
12챠밍노래클럽인천광역시 부평구 부평문화로 54 (부평동)032-528-1870
23꼭지노래클럽인천광역시 부평구 시장로 38 (부평동)032-523-9777
34루이베트남노래클럽인천광역시 부평구 부평대로32번길 7 (부평동)032-528-4523
45삼정노래짱인천광역시 부평구 열우물로 45 (십정동, 지하1층 일부)032-437-3449
56올인노래클럽인천광역시 부평구 경원대로1377번길 47 (부평동)032-522-0740
67와인천광역시 부평구 부평대로 40 (부평동)032-516-1163
78대박노래인천광역시 부평구 부평대로32번길 2 (부평동)032-512-6128
89에르메스인천광역시 부평구 부평대로17번길 22 (부평동)<NA>
910뉴머슴인천광역시 부평구 경원대로1354번길 11 (부평동)032-517-0261
연번업소명소재지(도로명)소재지전화
163164라운딩노래클럽인천광역시 부평구 대정로 72, 3층 일부호 (부평동)<NA>
164165준노래클럽인천광역시 부평구 시장로 82, 나동 지하1층 1호 (부평동)<NA>
165166빙고노래뮤직클럽인천광역시 부평구 경원대로 1436, 3층 (부평동)<NA>
166167궁노래광장인천광역시 부평구 부평대로 120, 2층 (부평동)<NA>
167168지어이다국적노래클럽인천광역시 부평구 경원대로 1412, 타이콘스빌딩 지하1층 일부호 (부평동)<NA>
168169썬노래광장인천광역시 부평구 대정로 30, 지하1층 일부호 (부평동)<NA>
169170준투노래타운인천광역시 부평구 경원대로1403번길 21, 동강 2빌딩 3층 일부호 (부평동)<NA>
170171킹마이웨이인천광역시 부평구 부평대로 24, 가나베스트빌 14층 1403호 (부평동)<NA>
171172퀸노래타운인천광역시 부평구 부평대로 24, 가나베스트빌 14층 1404호 (부평동)<NA>
172173패션나이트인천광역시 부평구 시장로 47, 3층 (부평동)<NA>