Overview

Dataset statistics

Number of variables6
Number of observations76
Missing cells23
Missing cells (%)5.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.8 KiB
Average record size in memory50.7 B

Variable types

Numeric1
Categorical1
Text3
DateTime1

Dataset

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

Alerts

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

Reproduction

Analysis started2024-03-14 15:58:17.261407
Analysis finished2024-03-14 15:58:18.647373
Duration1.39 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct76
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean38.5
Minimum1
Maximum76
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size812.0 B
2024-03-15T00:58:18.856580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.75
Q119.75
median38.5
Q357.25
95-th percentile72.25
Maximum76
Range75
Interquartile range (IQR)37.5

Descriptive statistics

Standard deviation22.083176
Coefficient of variation (CV)0.57358899
Kurtosis-1.2
Mean38.5
Median Absolute Deviation (MAD)19
Skewness0
Sum2926
Variance487.66667
MonotonicityStrictly increasing
2024-03-15T00:58:19.309894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.3%
50 1
 
1.3%
57 1
 
1.3%
56 1
 
1.3%
55 1
 
1.3%
54 1
 
1.3%
53 1
 
1.3%
52 1
 
1.3%
51 1
 
1.3%
49 1
 
1.3%
Other values (66) 66
86.8%
ValueCountFrequency (%)
1 1
1.3%
2 1
1.3%
3 1
1.3%
4 1
1.3%
5 1
1.3%
6 1
1.3%
7 1
1.3%
8 1
1.3%
9 1
1.3%
10 1
1.3%
ValueCountFrequency (%)
76 1
1.3%
75 1
1.3%
74 1
1.3%
73 1
1.3%
72 1
1.3%
71 1
1.3%
70 1
1.3%
69 1
1.3%
68 1
1.3%
67 1
1.3%

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size736.0 B
단란주점
76 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row단란주점
2nd row단란주점
3rd row단란주점
4th row단란주점
5th row단란주점

Common Values

ValueCountFrequency (%)
단란주점 76
100.0%

Length

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

Common Values (Plot)

2024-03-15T00:58:19.823193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
단란주점 76
100.0%

업소명
Text

Distinct74
Distinct (%)97.4%
Missing0
Missing (%)0.0%
Memory size736.0 B
2024-03-15T00:58:20.604341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length6.5
Min length2

Characters and Unicode

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

Unique

Unique72 ?
Unique (%)94.7%

Sample

1st row스타라이브
2nd row뱅크7080라이브
3rd row핑크단란주점
4th row맘모스
5th row별밤가요주점
ValueCountFrequency (%)
라이브 8
 
8.9%
세시봉7080라이브 2
 
2.2%
7080 2
 
2.2%
팡팡단란주점 2
 
2.2%
별이빛나는밤에 1
 
1.1%
스타라이브 1
 
1.1%
화인단란주점 1
 
1.1%
블랙노래타운 1
 
1.1%
나인단란주점 1
 
1.1%
커플라이브 1
 
1.1%
Other values (70) 70
77.8%
2024-03-15T00:58:21.690812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 40
 
8.1%
이 33
 
6.7%
주 30
 
6.1%
라 29
 
5.9%
점 29
 
5.9%
브 27
 
5.5%
7 19
 
3.8%
8 19
 
3.8%
란 18
 
3.6%
단 18
 
3.6%
Other values (124) 232
47.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 393
79.6%
Decimal Number 80
 
16.2%
Space Separator 14
 
2.8%
Lowercase Letter 3
 
0.6%
Uppercase Letter 2
 
0.4%
Close Punctuation 1
 
0.2%
Open Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
이 33
 
8.4%
주 30
 
7.6%
라 29
 
7.4%
점 29
 
7.4%
브 27
 
6.9%
란 18
 
4.6%
단 18
 
4.6%
래 14
 
3.6%
노 10
 
2.5%
고 6
 
1.5%
Other values (113) 179
45.5%
Decimal Number
ValueCountFrequency (%)
0 40
50.0%
7 19
23.8%
8 19
23.8%
9 2
 
2.5%
Lowercase Letter
ValueCountFrequency (%)
s 2
66.7%
i 1
33.3%
Uppercase Letter
ValueCountFrequency (%)
J 1
50.0%
M 1
50.0%
Space Separator
ValueCountFrequency (%)
14
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 393
79.6%
Common 96
 
19.4%
Latin 5
 
1.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
이 33
 
8.4%
주 30
 
7.6%
라 29
 
7.4%
점 29
 
7.4%
브 27
 
6.9%
란 18
 
4.6%
단 18
 
4.6%
래 14
 
3.6%
노 10
 
2.5%
고 6
 
1.5%
Other values (113) 179
45.5%
Common
ValueCountFrequency (%)
0 40
41.7%
7 19
19.8%
8 19
19.8%
14
 
14.6%
9 2
 
2.1%
) 1
 
1.0%
( 1
 
1.0%
Latin
ValueCountFrequency (%)
s 2
40.0%
J 1
20.0%
M 1
20.0%
i 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 393
79.6%
ASCII 101
 
20.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 40
39.6%
7 19
18.8%
8 19
18.8%
14
 
13.9%
s 2
 
2.0%
9 2
 
2.0%
) 1
 
1.0%
J 1
 
1.0%
( 1
 
1.0%
M 1
 
1.0%
Hangul
ValueCountFrequency (%)
이 33
 
8.4%
주 30
 
7.6%
라 29
 
7.4%
점 29
 
7.4%
브 27
 
6.9%
란 18
 
4.6%
단 18
 
4.6%
래 14
 
3.6%
노 10
 
2.5%
고 6
 
1.5%
Other values (113) 179
45.5%

소재지(도로명)
Text

UNIQUE 

Distinct76
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size736.0 B
2024-03-15T00:58:22.719194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length41.5
Mean length30.513158
Min length21

Characters and Unicode

Total characters2319
Distinct characters120
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

Unique76 ?
Unique (%)100.0%

Sample

1st row인천광역시 서구 가정로 132 (가좌동,(지하1층))
2nd row인천광역시 서구 염곡로 242-1 (석남동, 527)
3rd row인천광역시 서구 길주로 84-1 (석남동, 533-54)
4th row인천광역시 서구 가정로 301 (석남동)
5th row인천광역시 서구 원적로 43, 지하1층 (가좌동, 260-15)
ValueCountFrequency (%)
인천광역시 76
 
16.3%
서구 76
 
16.3%
석남동 25
 
5.4%
가정로 20
 
4.3%
길주로 11
 
2.4%
가좌동 10
 
2.1%
심곡동 9
 
1.9%
지하1층 9
 
1.9%
2층 7
 
1.5%
가정동 6
 
1.3%
Other values (169) 217
46.6%
2024-03-15T00:58:24.173404image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
390
 
16.8%
1 85
 
3.7%
) 80
 
3.4%
( 80
 
3.4%
서 79
 
3.4%
천 77
 
3.3%
시 77
 
3.3%
동 77
 
3.3%
인 76
 
3.3%
광 76
 
3.3%
Other values (110) 1222
52.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1274
54.9%
Decimal Number 407
 
17.6%
Space Separator 390
 
16.8%
Close Punctuation 80
 
3.4%
Open Punctuation 80
 
3.4%
Other Punctuation 62
 
2.7%
Dash Punctuation 24
 
1.0%
Math Symbol 1
 
< 0.1%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 79
 
6.2%
천 77
 
6.0%
시 77
 
6.0%
동 77
 
6.0%
인 76
 
6.0%
광 76
 
6.0%
역 76
 
6.0%
구 76
 
6.0%
로 76
 
6.0%
가 43
 
3.4%
Other values (93) 541
42.5%
Decimal Number
ValueCountFrequency (%)
1 85
20.9%
3 60
14.7%
2 56
13.8%
0 45
11.1%
5 38
9.3%
4 36
8.8%
6 23
 
5.7%
9 23
 
5.7%
8 21
 
5.2%
7 20
 
4.9%
Space Separator
ValueCountFrequency (%)
390
100.0%
Close Punctuation
ValueCountFrequency (%)
) 80
100.0%
Open Punctuation
ValueCountFrequency (%)
( 80
100.0%
Other Punctuation
ValueCountFrequency (%)
, 62
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 24
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1274
54.9%
Common 1044
45.0%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 79
 
6.2%
천 77
 
6.0%
시 77
 
6.0%
동 77
 
6.0%
인 76
 
6.0%
광 76
 
6.0%
역 76
 
6.0%
구 76
 
6.0%
로 76
 
6.0%
가 43
 
3.4%
Other values (93) 541
42.5%
Common
ValueCountFrequency (%)
390
37.4%
1 85
 
8.1%
) 80
 
7.7%
( 80
 
7.7%
, 62
 
5.9%
3 60
 
5.7%
2 56
 
5.4%
0 45
 
4.3%
5 38
 
3.6%
4 36
 
3.4%
Other values (6) 112
 
10.7%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1274
54.9%
ASCII 1045
45.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
390
37.3%
1 85
 
8.1%
) 80
 
7.7%
( 80
 
7.7%
, 62
 
5.9%
3 60
 
5.7%
2 56
 
5.4%
0 45
 
4.3%
5 38
 
3.6%
4 36
 
3.4%
Other values (7) 113
 
10.8%
Hangul
ValueCountFrequency (%)
서 79
 
6.2%
천 77
 
6.0%
시 77
 
6.0%
동 77
 
6.0%
인 76
 
6.0%
광 76
 
6.0%
역 76
 
6.0%
구 76
 
6.0%
로 76
 
6.0%
가 43
 
3.4%
Other values (93) 541
42.5%

소재지전화
Text

MISSING 

Distinct52
Distinct (%)98.1%
Missing23
Missing (%)30.3%
Memory size736.0 B
2024-03-15T00:58:24.879035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length14
Mean length13.943396
Min length12

Characters and Unicode

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

Unique51 ?
Unique (%)96.2%

Sample

1st row032 -572 -5430
2nd row 032- 579-0116
3rd row 032- 577-0971
4th row 032- 583-3915
5th row032 - 571-2289
ValueCountFrequency (%)
032 51
42.5%
3
 
2.5%
582-4041 2
 
1.7%
561 2
 
1.7%
568 2
 
1.7%
562 2
 
1.7%
573 2
 
1.7%
2690 1
 
0.8%
1254 1
 
0.8%
565 1
 
0.8%
Other values (53) 53
44.2%
2024-03-15T00:58:25.902585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 106
14.3%
102
13.8%
0 91
12.3%
3 90
12.2%
2 80
10.8%
5 74
10.0%
7 51
6.9%
6 37
 
5.0%
8 32
 
4.3%
1 31
 
4.2%
Other values (2) 45
6.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 531
71.9%
Dash Punctuation 106
 
14.3%
Space Separator 102
 
13.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 91
17.1%
3 90
16.9%
2 80
15.1%
5 74
13.9%
7 51
9.6%
6 37
7.0%
8 32
 
6.0%
1 31
 
5.8%
4 23
 
4.3%
9 22
 
4.1%
Dash Punctuation
ValueCountFrequency (%)
- 106
100.0%
Space Separator
ValueCountFrequency (%)
102
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 739
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 106
14.3%
102
13.8%
0 91
12.3%
3 90
12.2%
2 80
10.8%
5 74
10.0%
7 51
6.9%
6 37
 
5.0%
8 32
 
4.3%
1 31
 
4.2%
Other values (2) 45
6.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 739
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 106
14.3%
102
13.8%
0 91
12.3%
3 90
12.2%
2 80
10.8%
5 74
10.0%
7 51
6.9%
6 37
 
5.0%
8 32
 
4.3%
1 31
 
4.2%
Other values (2) 45
6.1%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size736.0 B
Minimum2023-12-31 00:00:00
Maximum2023-12-31 00:00:00
2024-03-15T00:58:26.326738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T00:58:26.656061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

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

Correlations

2024-03-15T00:58:26.874654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업소명소재지(도로명)소재지전화
연번1.0000.8591.0000.970
업소명0.8591.0001.0000.997
소재지(도로명)1.0001.0001.0001.000
소재지전화0.9700.9971.0001.000

Missing values

2024-03-15T00:58:18.156474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T00:58:18.508305image/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단란주점스타라이브인천광역시 서구 가정로 132 (가좌동,(지하1층))032 -572 -54302023-12-31
12단란주점뱅크7080라이브인천광역시 서구 염곡로 242-1 (석남동, 527)032- 579-01162023-12-31
23단란주점핑크단란주점인천광역시 서구 길주로 84-1 (석남동, 533-54)032- 577-09712023-12-31
34단란주점맘모스인천광역시 서구 가정로 301 (석남동)032- 583-39152023-12-31
45단란주점별밤가요주점인천광역시 서구 원적로 43, 지하1층 (가좌동, 260-15)032 - 571-22892023-12-31
56단란주점두발로 라이브인천광역시 서구 검단로 496 (마전동)032- 582-40412023-12-31
67단란주점진이노래주점인천광역시 서구 가정로 193 (석남동, 583-6)032- 583-50062023-12-31
78단란주점미인 라이브 7080인천광역시 서구 가정로 311 (석남동, 455-6)032- 575-01652023-12-31
89단란주점즐거운단란주점인천광역시 서구 가정로 146 (가좌동)032- 578-83532023-12-31
910단란주점동창생인천광역시 서구 탁옥로 54, 지하1층 (심곡동)032- 566-97352023-12-31
연번업종명업소명소재지(도로명)소재지전화데이터기준일자
6667단란주점산타나7080라이브인천광역시 서구 서곶로301번길 16, 태영프라자 2층 203호 (심곡동)<NA>2023-12-31
6768단란주점소풍 뮤직펍 라이브인천광역시 서구 탁옥로51번길 4, 금진빌딩 2층 일부호 (심곡동)032 -561 -80052023-12-31
6869단란주점돌고래라이브바인천광역시 서구 북항로32번안길 41, 건원프라자 503,504호 (원창동)<NA>2023-12-31
6970단란주점블루밍라이브7080인천광역시 서구 완정로 158, 3층 3층호 (마전동)<NA>2023-12-31
7071단란주점제이(J)인천광역시 서구 북항로32번길 28, 대건프라자 203호 (원창동)<NA>2023-12-31
7172단란주점영7080인천광역시 서구 청라한내로 90, 409호 (청라동)<NA>2023-12-31
7273단란주점원7090라이브인천광역시 서구 염곡로464번길 15, 쓰리엠타워 308호 (가정동)<NA>2023-12-31
7374단란주점별이빛나는밤에인천광역시 서구 염곡로464번길 30, 벨라미 루원 3층 309~311호 (가정동)<NA>2023-12-31
7475단란주점올라인천광역시 서구 북항로32번안길 11, 403호 (원창동)<NA>2023-12-31
7576단란주점시티7080라이브인천광역시 서구 염곡로464번길 23, 엔시티타워 202호 (가정동)032 -565 -70802023-12-31