Overview

Dataset statistics

Number of variables5
Number of observations286
Missing cells113
Missing cells (%)7.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.6 KiB
Average record size in memory41.4 B

Variable types

Numeric1
Categorical1
Text3

Dataset

Description전북특별자치도 군산시에 소재하고 있는 유흥주점 및 단란주점 현황(연번, 업종, 업소명, 전화번호, 도로명주소)입니다.
Author전북특별자치도 군산시
URLhttps://www.data.go.kr/data/15087032/fileData.do

Alerts

전화번호 has 113 (39.5%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2024-03-14 15:23:06.363019
Analysis finished2024-03-14 15:23:07.590677
Duration1.23 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct286
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean143.5
Minimum1
Maximum286
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.6 KiB
2024-03-15T00:23:07.751636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile15.25
Q172.25
median143.5
Q3214.75
95-th percentile271.75
Maximum286
Range285
Interquartile range (IQR)142.5

Descriptive statistics

Standard deviation82.7053
Coefficient of variation (CV)0.57634355
Kurtosis-1.2
Mean143.5
Median Absolute Deviation (MAD)71.5
Skewness0
Sum41041
Variance6840.1667
MonotonicityStrictly increasing
2024-03-15T00:23:08.010383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
190 1
 
0.3%
196 1
 
0.3%
195 1
 
0.3%
194 1
 
0.3%
193 1
 
0.3%
192 1
 
0.3%
191 1
 
0.3%
189 1
 
0.3%
198 1
 
0.3%
Other values (276) 276
96.5%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
286 1
0.3%
285 1
0.3%
284 1
0.3%
283 1
0.3%
282 1
0.3%
281 1
0.3%
280 1
0.3%
279 1
0.3%
278 1
0.3%
277 1
0.3%

업종
Categorical

Distinct2
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
유흥주점영업
223 
단란주점
63 

Length

Max length6
Median length6
Mean length5.5594406
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
유흥주점영업 223
78.0%
단란주점 63
 
22.0%

Length

2024-03-15T00:23:08.264122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T00:23:08.449602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유흥주점영업 223
78.0%
단란주점 63
 
22.0%

업소명
Text

Distinct277
Distinct (%)96.9%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
2024-03-15T00:23:09.328861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length10
Mean length4.6818182
Min length1

Characters and Unicode

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

Unique

Unique268 ?
Unique (%)93.7%

Sample

1st row킹주점
2nd row킹콩단란주점
3rd row놀이마당
4th row그리스단란주점
5th row쎄븐노래단란주점
ValueCountFrequency (%)
단란주점 4
 
1.3%
가요주점 3
 
1.0%
칸 2
 
0.7%
뮤직홀 2
 
0.7%
7080 2
 
0.7%
노래주점 2
 
0.7%
킹 2
 
0.7%
비타민 2
 
0.7%
이화 2
 
0.7%
맨하탄단란주점 2
 
0.7%
Other values (278) 282
92.5%
2024-03-15T00:23:10.751664image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 80
 
6.0%
점 78
 
5.8%
노 40
 
3.0%
래 39
 
2.9%
이 33
 
2.5%
가 32
 
2.4%
스 32
 
2.4%
단 28
 
2.1%
란 28
 
2.1%
요 26
 
1.9%
Other values (296) 923
68.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1259
94.0%
Decimal Number 53
 
4.0%
Space Separator 19
 
1.4%
Close Punctuation 2
 
0.1%
Open Punctuation 2
 
0.1%
Uppercase Letter 2
 
0.1%
Letter Number 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 80
 
6.4%
점 78
 
6.2%
노 40
 
3.2%
래 39
 
3.1%
이 33
 
2.6%
가 32
 
2.5%
스 32
 
2.5%
단 28
 
2.2%
란 28
 
2.2%
요 26
 
2.1%
Other values (282) 843
67.0%
Decimal Number
ValueCountFrequency (%)
0 22
41.5%
8 12
22.6%
7 12
22.6%
1 2
 
3.8%
2 2
 
3.8%
9 2
 
3.8%
3 1
 
1.9%
Uppercase Letter
ValueCountFrequency (%)
A 1
50.0%
M 1
50.0%
Letter Number
ValueCountFrequency (%)
Ⅲ 1
50.0%
Ⅱ 1
50.0%
Space Separator
ValueCountFrequency (%)
19
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1259
94.0%
Common 76
 
5.7%
Latin 4
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 80
 
6.4%
점 78
 
6.2%
노 40
 
3.2%
래 39
 
3.1%
이 33
 
2.6%
가 32
 
2.5%
스 32
 
2.5%
단 28
 
2.2%
란 28
 
2.2%
요 26
 
2.1%
Other values (282) 843
67.0%
Common
ValueCountFrequency (%)
0 22
28.9%
19
25.0%
8 12
15.8%
7 12
15.8%
1 2
 
2.6%
) 2
 
2.6%
2 2
 
2.6%
( 2
 
2.6%
9 2
 
2.6%
3 1
 
1.3%
Latin
ValueCountFrequency (%)
A 1
25.0%
Ⅲ 1
25.0%
Ⅱ 1
25.0%
M 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1259
94.0%
ASCII 78
 
5.8%
Number Forms 2
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 80
 
6.4%
점 78
 
6.2%
노 40
 
3.2%
래 39
 
3.1%
이 33
 
2.6%
가 32
 
2.5%
스 32
 
2.5%
단 28
 
2.2%
란 28
 
2.2%
요 26
 
2.1%
Other values (282) 843
67.0%
ASCII
ValueCountFrequency (%)
0 22
28.2%
19
24.4%
8 12
15.4%
7 12
15.4%
1 2
 
2.6%
) 2
 
2.6%
2 2
 
2.6%
( 2
 
2.6%
9 2
 
2.6%
A 1
 
1.3%
Other values (2) 2
 
2.6%
Number Forms
ValueCountFrequency (%)
Ⅲ 1
50.0%
Ⅱ 1
50.0%

전화번호
Text

MISSING 

Distinct171
Distinct (%)98.8%
Missing113
Missing (%)39.5%
Memory size2.4 KiB
2024-03-15T00:23:11.663140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length12.456647
Min length12

Characters and Unicode

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

Unique169 ?
Unique (%)97.7%

Sample

1st row063-468-7237
2nd row063-466-0830
3rd row063-471-6037
4th row063-443-5700
5th row063-446-9713
ValueCountFrequency (%)
0630-4420-0053 2
 
1.2%
063-445-7957 2
 
1.2%
063-463-7182 1
 
0.6%
063-463-2167 1
 
0.6%
063-445-8177 1
 
0.6%
063-442-7773 1
 
0.6%
063-446-1867 1
 
0.6%
063-445-4959 1
 
0.6%
063-467-9589 1
 
0.6%
063-467-3686 1
 
0.6%
Other values (161) 161
93.1%
2024-03-15T00:23:12.764726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6 362
16.8%
- 346
16.1%
0 339
15.7%
4 304
14.1%
3 270
12.5%
5 122
 
5.7%
2 100
 
4.6%
7 90
 
4.2%
1 83
 
3.9%
8 77
 
3.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1809
83.9%
Dash Punctuation 346
 
16.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 362
20.0%
0 339
18.7%
4 304
16.8%
3 270
14.9%
5 122
 
6.7%
2 100
 
5.5%
7 90
 
5.0%
1 83
 
4.6%
8 77
 
4.3%
9 62
 
3.4%
Dash Punctuation
ValueCountFrequency (%)
- 346
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2155
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
6 362
16.8%
- 346
16.1%
0 339
15.7%
4 304
14.1%
3 270
12.5%
5 122
 
5.7%
2 100
 
4.6%
7 90
 
4.2%
1 83
 
3.9%
8 77
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2155
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6 362
16.8%
- 346
16.1%
0 339
15.7%
4 304
14.1%
3 270
12.5%
5 122
 
5.7%
2 100
 
4.6%
7 90
 
4.2%
1 83
 
3.9%
8 77
 
3.6%

도로명주소
Text

Distinct221
Distinct (%)77.3%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
2024-03-15T00:23:13.722749image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length34
Mean length26.27972
Min length21

Characters and Unicode

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

Unique

Unique176 ?
Unique (%)61.5%

Sample

1st row전북특별자치도 군산시 가도로 17, 2층 (오식도동)
2nd row전북특별자치도 군산시 가도로 17, 2층 (오식도동)
3rd row전북특별자치도 군산시 가도로 175, 101호 (오식도동)
4th row전북특별자치도 군산시 가도로 176 (오식도동)
5th row전북특별자치도 군산시 가도로 181 (오식도동)
ValueCountFrequency (%)
전북특별자치도 286
19.5%
군산시 286
19.5%
나운동 92
 
6.3%
부곡4길 33
 
2.2%
임사길 21
 
1.4%
산북동 21
 
1.4%
영화동 20
 
1.4%
장미동 19
 
1.3%
소룡동 19
 
1.3%
부곡3길 18
 
1.2%
Other values (251) 655
44.6%
2024-03-15T00:23:15.115936image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1184
 
15.8%
도 315
 
4.2%
산 310
 
4.1%
북 309
 
4.1%
시 292
 
3.9%
전 287
 
3.8%
군 287
 
3.8%
특 286
 
3.8%
별 286
 
3.8%
자 286
 
3.8%
Other values (103) 3674
48.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4707
62.6%
Space Separator 1184
 
15.8%
Decimal Number 935
 
12.4%
Open Punctuation 280
 
3.7%
Close Punctuation 280
 
3.7%
Dash Punctuation 85
 
1.1%
Other Punctuation 44
 
0.6%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
도 315
 
6.7%
산 310
 
6.6%
북 309
 
6.6%
시 292
 
6.2%
전 287
 
6.1%
군 287
 
6.1%
특 286
 
6.1%
별 286
 
6.1%
자 286
 
6.1%
치 286
 
6.1%
Other values (86) 1763
37.5%
Decimal Number
ValueCountFrequency (%)
1 283
30.3%
2 150
16.0%
3 108
 
11.6%
4 82
 
8.8%
7 78
 
8.3%
5 69
 
7.4%
6 60
 
6.4%
0 43
 
4.6%
8 34
 
3.6%
9 28
 
3.0%
Other Punctuation
ValueCountFrequency (%)
, 43
97.7%
. 1
 
2.3%
Space Separator
ValueCountFrequency (%)
1184
100.0%
Open Punctuation
ValueCountFrequency (%)
( 280
100.0%
Close Punctuation
ValueCountFrequency (%)
) 280
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 85
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4707
62.6%
Common 2809
37.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
도 315
 
6.7%
산 310
 
6.6%
북 309
 
6.6%
시 292
 
6.2%
전 287
 
6.1%
군 287
 
6.1%
특 286
 
6.1%
별 286
 
6.1%
자 286
 
6.1%
치 286
 
6.1%
Other values (86) 1763
37.5%
Common
ValueCountFrequency (%)
1184
42.2%
1 283
 
10.1%
( 280
 
10.0%
) 280
 
10.0%
2 150
 
5.3%
3 108
 
3.8%
- 85
 
3.0%
4 82
 
2.9%
7 78
 
2.8%
5 69
 
2.5%
Other values (7) 210
 
7.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4707
62.6%
ASCII 2809
37.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1184
42.2%
1 283
 
10.1%
( 280
 
10.0%
) 280
 
10.0%
2 150
 
5.3%
3 108
 
3.8%
- 85
 
3.0%
4 82
 
2.9%
7 78
 
2.8%
5 69
 
2.5%
Other values (7) 210
 
7.5%
Hangul
ValueCountFrequency (%)
도 315
 
6.7%
산 310
 
6.6%
북 309
 
6.6%
시 292
 
6.2%
전 287
 
6.1%
군 287
 
6.1%
특 286
 
6.1%
별 286
 
6.1%
자 286
 
6.1%
치 286
 
6.1%
Other values (86) 1763
37.5%

Interactions

2024-03-15T00:23:06.822881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T00:23:15.367613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종
연번1.0000.349
업종0.3491.000
2024-03-15T00:23:15.600452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종
연번1.0000.263
업종0.2631.000

Missing values

2024-03-15T00:23:07.154865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T00:23:07.468090image/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>전북특별자치도 군산시 가도로 17, 2층 (오식도동)
12단란주점킹콩단란주점<NA>전북특별자치도 군산시 가도로 17, 2층 (오식도동)
23단란주점놀이마당<NA>전북특별자치도 군산시 가도로 175, 101호 (오식도동)
34단란주점그리스단란주점063-468-7237전북특별자치도 군산시 가도로 176 (오식도동)
45단란주점쎄븐노래단란주점<NA>전북특별자치도 군산시 가도로 181 (오식도동)
56단란주점궁단란주점<NA>전북특별자치도 군산시 가도로 181, 2층 (오식도동)
67단란주점쿵쿵따7890라이브063-466-0830전북특별자치도 군산시 가도로 188 (오식도동)
78단란주점맨하탄단란주점063-471-6037전북특별자치도 군산시 가도로 207, 2층 (오식도동)
89단란주점히든싱어단란주점<NA>전북특별자치도 군산시 가도로 208 (오식도동)
910유흥주점영업시크릿가요주점<NA>전북특별자치도 군산시 가도로 21 (오식도동)
연번업종업소명전화번호도로명주소
276277유흥주점영업지중해0630-4450-8388전북특별자치도 군산시 평화길 131 (장미동)
277278유흥주점영업보물섬노래주점063-445-0642전북특별자치도 군산시 평화길 131 (장미동)
278279단란주점사하라063-445-3158전북특별자치도 군산시 평화길 132 (장미동)
279280단란주점뉴다인단란주점063-446-5246전북특별자치도 군산시 평화길 3 (평화동)
280281단란주점작은음악회 단란주점063-466-5002전북특별자치도 군산시 하나운안1길 8-3 (나운동)
281282단란주점월드단란주점063-467-8113전북특별자치도 군산시 하나운안1길 8-3 (나운동)
282283단란주점압구정노래단란주점063-463-7182전북특별자치도 군산시 하나운안1길 8-7 (나운동)
283284단란주점청담노래주점063-467-9541전북특별자치도 군산시 하나운안1길 8-7 (나운동)
284285유흥주점영업리무진063-442-7280전북특별자치도 군산시 해망로 217-2 (장미동)
285286단란주점맨하탄단란주점0630-4450-3396전북특별자치도 군산시 해망로 233 (장미동)