Overview

Dataset statistics

Number of variables6
Number of observations80
Missing cells35
Missing cells (%)7.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.0 KiB
Average record size in memory50.6 B

Variable types

Numeric1
Categorical2
Text3

Dataset

Description인천광역시 서구 관내에 위치한 유흥주점업(업종명, 업소명, 소재지(도로명), 전화번호)현행 데이터입니다.
Author인천광역시 서구
URLhttps://www.data.go.kr/data/15089618/fileData.do

Alerts

업종명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
소재지전화 has 35 (43.8%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2024-03-14 18:11:23.095646
Analysis finished2024-03-14 18:11:24.602176
Duration1.51 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct80
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean40.5
Minimum1
Maximum80
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size848.0 B
2024-03-15T03:11:24.748368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.95
Q120.75
median40.5
Q360.25
95-th percentile76.05
Maximum80
Range79
Interquartile range (IQR)39.5

Descriptive statistics

Standard deviation23.2379
Coefficient of variation (CV)0.57377531
Kurtosis-1.2
Mean40.5
Median Absolute Deviation (MAD)20
Skewness0
Sum3240
Variance540
MonotonicityStrictly increasing
2024-03-15T03:11:25.014010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.2%
42 1
 
1.2%
60 1
 
1.2%
59 1
 
1.2%
58 1
 
1.2%
57 1
 
1.2%
56 1
 
1.2%
55 1
 
1.2%
54 1
 
1.2%
53 1
 
1.2%
Other values (70) 70
87.5%
ValueCountFrequency (%)
1 1
1.2%
2 1
1.2%
3 1
1.2%
4 1
1.2%
5 1
1.2%
6 1
1.2%
7 1
1.2%
8 1
1.2%
9 1
1.2%
10 1
1.2%
ValueCountFrequency (%)
80 1
1.2%
79 1
1.2%
78 1
1.2%
77 1
1.2%
76 1
1.2%
75 1
1.2%
74 1
1.2%
73 1
1.2%
72 1
1.2%
71 1
1.2%

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size768.0 B
유흥주점영업
80 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
유흥주점영업 80
100.0%

Length

2024-03-15T03:11:25.338969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T03:11:25.645647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유흥주점영업 80
100.0%

업소명
Text

Distinct79
Distinct (%)98.8%
Missing0
Missing (%)0.0%
Memory size768.0 B
2024-03-15T03:11:26.590913image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length9
Mean length6.3375
Min length1

Characters and Unicode

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

Unique

Unique78 ?
Unique (%)97.5%

Sample

1st row뉴서울
2nd row황궁 비지니스
3rd row장녹수미인파티
4th row골드
5th row동경클럽
ValueCountFrequency (%)
노래클럽 4
 
4.3%
션샤인노래타운 2
 
2.2%
노래타운 2
 
2.2%
인천검단점 2
 
2.2%
낭만에대하여 1
 
1.1%
신국빈관 1
 
1.1%
에스지(sg)라이브 1
 
1.1%
여자친구노래바 1
 
1.1%
러블리짱 1
 
1.1%
singha(싱하 1
 
1.1%
Other values (77) 77
82.8%
2024-03-15T03:11:27.831160image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
래 45
 
8.9%
노 44
 
8.7%
럽 26
 
5.1%
클 25
 
4.9%
타 17
 
3.4%
운 15
 
3.0%
13
 
2.6%
이 9
 
1.8%
인 7
 
1.4%
여 7
 
1.4%
Other values (156) 299
59.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 452
89.2%
Uppercase Letter 20
 
3.9%
Decimal Number 14
 
2.8%
Space Separator 13
 
2.6%
Close Punctuation 4
 
0.8%
Open Punctuation 4
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
래 45
 
10.0%
노 44
 
9.7%
럽 26
 
5.8%
클 25
 
5.5%
타 17
 
3.8%
운 15
 
3.3%
이 9
 
2.0%
인 7
 
1.5%
여 7
 
1.5%
스 7
 
1.5%
Other values (136) 250
55.3%
Uppercase Letter
ValueCountFrequency (%)
L 3
15.0%
E 3
15.0%
A 3
15.0%
S 2
10.0%
I 2
10.0%
G 2
10.0%
N 1
 
5.0%
H 1
 
5.0%
Y 1
 
5.0%
V 1
 
5.0%
Decimal Number
ValueCountFrequency (%)
0 4
28.6%
1 3
21.4%
9 3
21.4%
8 2
14.3%
7 1
 
7.1%
2 1
 
7.1%
Space Separator
ValueCountFrequency (%)
13
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 452
89.2%
Common 35
 
6.9%
Latin 20
 
3.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
래 45
 
10.0%
노 44
 
9.7%
럽 26
 
5.8%
클 25
 
5.5%
타 17
 
3.8%
운 15
 
3.3%
이 9
 
2.0%
인 7
 
1.5%
여 7
 
1.5%
스 7
 
1.5%
Other values (136) 250
55.3%
Latin
ValueCountFrequency (%)
L 3
15.0%
E 3
15.0%
A 3
15.0%
S 2
10.0%
I 2
10.0%
G 2
10.0%
N 1
 
5.0%
H 1
 
5.0%
Y 1
 
5.0%
V 1
 
5.0%
Common
ValueCountFrequency (%)
13
37.1%
) 4
 
11.4%
( 4
 
11.4%
0 4
 
11.4%
1 3
 
8.6%
9 3
 
8.6%
8 2
 
5.7%
7 1
 
2.9%
2 1
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 452
89.2%
ASCII 55
 
10.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
래 45
 
10.0%
노 44
 
9.7%
럽 26
 
5.8%
클 25
 
5.5%
타 17
 
3.8%
운 15
 
3.3%
이 9
 
2.0%
인 7
 
1.5%
여 7
 
1.5%
스 7
 
1.5%
Other values (136) 250
55.3%
ASCII
ValueCountFrequency (%)
13
23.6%
) 4
 
7.3%
( 4
 
7.3%
0 4
 
7.3%
L 3
 
5.5%
E 3
 
5.5%
A 3
 
5.5%
1 3
 
5.5%
9 3
 
5.5%
S 2
 
3.6%
Other values (10) 13
23.6%

소재지(도로명)
Text

Distinct78
Distinct (%)97.5%
Missing0
Missing (%)0.0%
Memory size768.0 B
2024-03-15T03:11:29.058475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length56
Median length40.5
Mean length33.7
Min length21

Characters and Unicode

Total characters2696
Distinct characters95
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

Unique76 ?
Unique (%)95.0%

Sample

1st row인천광역시 서구 검단로487번길 6 (마전동)
2nd row인천광역시 서구 완정로 160 (마전동, 지하)
3rd row인천광역시 서구 길주로 71 (석남동)
4th row인천광역시 서구 가정로 256 (석남동)
5th row인천광역시 서구 탁옥로51번길 17, 하나로모텔 지하1층 (심곡동)
ValueCountFrequency (%)
인천광역시 80
 
15.4%
서구 80
 
15.4%
심곡동 28
 
5.4%
탁옥로51번길 14
 
2.7%
원당동 13
 
2.5%
석남동 13
 
2.5%
지하1층 12
 
2.3%
마전동 9
 
1.7%
바리미로 9
 
1.7%
완정로 8
 
1.5%
Other values (131) 252
48.6%
2024-03-15T03:11:30.889216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
438
 
16.2%
1 113
 
4.2%
, 100
 
3.7%
서 90
 
3.3%
) 84
 
3.1%
( 84
 
3.1%
0 82
 
3.0%
로 81
 
3.0%
동 81
 
3.0%
천 80
 
3.0%
Other values (85) 1463
54.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1429
53.0%
Decimal Number 537
 
19.9%
Space Separator 438
 
16.2%
Other Punctuation 100
 
3.7%
Close Punctuation 84
 
3.1%
Open Punctuation 84
 
3.1%
Dash Punctuation 20
 
0.7%
Uppercase Letter 3
 
0.1%
Letter Number 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 90
 
6.3%
로 81
 
5.7%
동 81
 
5.7%
천 80
 
5.6%
인 80
 
5.6%
역 80
 
5.6%
구 80
 
5.6%
시 80
 
5.6%
광 80
 
5.6%
길 49
 
3.4%
Other values (66) 648
45.3%
Decimal Number
ValueCountFrequency (%)
1 113
21.0%
0 82
15.3%
3 71
13.2%
5 69
12.8%
2 64
11.9%
4 50
9.3%
6 28
 
5.2%
7 23
 
4.3%
9 22
 
4.1%
8 15
 
2.8%
Uppercase Letter
ValueCountFrequency (%)
B 1
33.3%
G 1
33.3%
S 1
33.3%
Space Separator
ValueCountFrequency (%)
438
100.0%
Other Punctuation
ValueCountFrequency (%)
, 100
100.0%
Close Punctuation
ValueCountFrequency (%)
) 84
100.0%
Open Punctuation
ValueCountFrequency (%)
( 84
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 20
100.0%
Letter Number
ValueCountFrequency (%)
Ⅲ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1429
53.0%
Common 1263
46.8%
Latin 4
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 90
 
6.3%
로 81
 
5.7%
동 81
 
5.7%
천 80
 
5.6%
인 80
 
5.6%
역 80
 
5.6%
구 80
 
5.6%
시 80
 
5.6%
광 80
 
5.6%
길 49
 
3.4%
Other values (66) 648
45.3%
Common
ValueCountFrequency (%)
438
34.7%
1 113
 
8.9%
, 100
 
7.9%
) 84
 
6.7%
( 84
 
6.7%
0 82
 
6.5%
3 71
 
5.6%
5 69
 
5.5%
2 64
 
5.1%
4 50
 
4.0%
Other values (5) 108
 
8.6%
Latin
ValueCountFrequency (%)
Ⅲ 1
25.0%
B 1
25.0%
G 1
25.0%
S 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1429
53.0%
ASCII 1266
47.0%
Number Forms 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
438
34.6%
1 113
 
8.9%
, 100
 
7.9%
) 84
 
6.6%
( 84
 
6.6%
0 82
 
6.5%
3 71
 
5.6%
5 69
 
5.5%
2 64
 
5.1%
4 50
 
3.9%
Other values (8) 111
 
8.8%
Hangul
ValueCountFrequency (%)
서 90
 
6.3%
로 81
 
5.7%
동 81
 
5.7%
천 80
 
5.6%
인 80
 
5.6%
역 80
 
5.6%
구 80
 
5.6%
시 80
 
5.6%
광 80
 
5.6%
길 49
 
3.4%
Other values (66) 648
45.3%
Number Forms
ValueCountFrequency (%)
Ⅲ 1
100.0%

소재지전화
Text

MISSING 

Distinct45
Distinct (%)100.0%
Missing35
Missing (%)43.8%
Memory size768.0 B
2024-03-15T03:11:31.747178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length14
Mean length14
Min length14

Characters and Unicode

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

Unique45 ?
Unique (%)100.0%

Sample

1st row 032- 563-1997
2nd row 032- 562-2236
3rd row 032- 583-4114
4th row032 -572 -7749
5th row 032- 567-4588
ValueCountFrequency (%)
032 44
42.3%
568 3
 
2.9%
566 2
 
1.9%
561 2
 
1.9%
562-2236 1
 
1.0%
568-4742 1
 
1.0%
562-1999 1
 
1.0%
6648 1
 
1.0%
560 1
 
1.0%
8611 1
 
1.0%
Other values (47) 47
45.2%
2024-03-15T03:11:32.910429image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 90
14.3%
89
14.1%
3 70
11.1%
0 67
10.6%
2 67
10.6%
5 59
9.4%
6 49
7.8%
7 34
 
5.4%
8 34
 
5.4%
1 26
 
4.1%
Other values (2) 45
7.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 451
71.6%
Dash Punctuation 90
 
14.3%
Space Separator 89
 
14.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 70
15.5%
0 67
14.9%
2 67
14.9%
5 59
13.1%
6 49
10.9%
7 34
7.5%
8 34
7.5%
1 26
 
5.8%
4 24
 
5.3%
9 21
 
4.7%
Dash Punctuation
ValueCountFrequency (%)
- 90
100.0%
Space Separator
ValueCountFrequency (%)
89
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 630
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 90
14.3%
89
14.1%
3 70
11.1%
0 67
10.6%
2 67
10.6%
5 59
9.4%
6 49
7.8%
7 34
 
5.4%
8 34
 
5.4%
1 26
 
4.1%
Other values (2) 45
7.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 630
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 90
14.3%
89
14.1%
3 70
11.1%
0 67
10.6%
2 67
10.6%
5 59
9.4%
6 49
7.8%
7 34
 
5.4%
8 34
 
5.4%
1 26
 
4.1%
Other values (2) 45
7.1%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size768.0 B
2023-12-31
80 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-12-31
2nd row2023-12-31
3rd row2023-12-31
4th row2023-12-31
5th row2023-12-31

Common Values

ValueCountFrequency (%)
2023-12-31 80
100.0%

Length

2024-03-15T03:11:33.401522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T03:11:33.595696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-12-31 80
100.0%

Interactions

2024-03-15T03:11:23.754121image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T03:11:33.714877image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업소명소재지(도로명)소재지전화
연번1.0000.9391.0001.000
업소명0.9391.0000.9961.000
소재지(도로명)1.0000.9961.0001.000
소재지전화1.0001.0001.0001.000

Missing values

2024-03-15T03:11:24.344306image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T03:11:24.526709image/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유흥주점영업뉴서울인천광역시 서구 검단로487번길 6 (마전동)032- 563-19972023-12-31
12유흥주점영업황궁 비지니스인천광역시 서구 완정로 160 (마전동, 지하)032- 562-22362023-12-31
23유흥주점영업장녹수미인파티인천광역시 서구 길주로 71 (석남동)032- 583-41142023-12-31
34유흥주점영업골드인천광역시 서구 가정로 256 (석남동)032 -572 -77492023-12-31
45유흥주점영업동경클럽인천광역시 서구 탁옥로51번길 17, 하나로모텔 지하1층 (심곡동)032- 567-45882023-12-31
56유흥주점영업쇼부노래타운인천광역시 서구 길주로75번길 4 (석남동,(지하1층))032- 582-59822023-12-31
67유흥주점영업봉순이19노래노래인천광역시 서구 탁옥로 41 (심곡동, 246-12)032 -566 -78692023-12-31
78유흥주점영업신세계인천광역시 서구 탁옥로51번길 13-11 (심곡동, 지하1층)032 -568 -88002023-12-31
89유흥주점영업파티인천광역시 서구 서곶로301번길 20, 2층 (심곡동, 245-7번지)032- 567-78782023-12-31
910유흥주점영업도도노래클럽인천광역시 서구 탁옥로51번길 13-6, 지하1층 (심곡동)032- 562-58232023-12-31
연번업종명업소명소재지(도로명)소재지전화데이터기준일자
7071유흥주점영업애플 노래클럽인천광역시 서구 바리미로 29, 국제프라자 2차 5층 504호 (원당동)<NA>2023-12-31
7172유흥주점영업캣츠 노래클럽인천광역시 서구 바리미로 29, 국제프라자 2차 3층 303호 (원당동)<NA>2023-12-31
7273유흥주점영업산타나라이브7080클럽인천광역시 서구 가정로 257, 2층 (석남동)<NA>2023-12-31
7374유흥주점영업강남노래짱인천광역시 서구 발산로 27, 선우프라자 3층 305,306호 (원당동)<NA>2023-12-31
7475유흥주점영업아라노래타운인천광역시 서구 바리미로 29, 국제프라자 2차 306,307호 (원당동)<NA>2023-12-31
7576유흥주점영업끌림8090LIVE인천광역시 서구 바리미로 21, 507,508호 (원당동)<NA>2023-12-31
7677유흥주점영업대박노래짱인천광역시 서구 발산로 27, 선우프라자 405,406호 (원당동)<NA>2023-12-31
7778유흥주점영업더노라노래타운인천광역시 서구 바리미로 21, 409,410호 (원당동)<NA>2023-12-31
7879유흥주점영업카카오노래타운인천광역시 서구 바리미로 21, 국제프라자3차 407,408호 (원당동)<NA>2023-12-31
7980유흥주점영업오늘도노래짱인천광역시 서구 발산로 27, 선우프라자 314,315호 (원당동)<NA>2023-12-31