Overview

Dataset statistics

Number of variables6
Number of observations72
Missing cells21
Missing cells (%)4.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.6 KiB
Average record size in memory50.8 B

Variable types

Numeric1
Categorical1
Text3
DateTime1

Dataset

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

Alerts

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

Reproduction

Analysis started2024-01-28 06:57:16.890749
Analysis finished2024-01-28 06:57:17.410138
Duration0.52 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct72
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean36.5
Minimum1
Maximum72
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size780.0 B
2024-01-28T15:57:17.463601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.55
Q118.75
median36.5
Q354.25
95-th percentile68.45
Maximum72
Range71
Interquartile range (IQR)35.5

Descriptive statistics

Standard deviation20.92845
Coefficient of variation (CV)0.57338218
Kurtosis-1.2
Mean36.5
Median Absolute Deviation (MAD)18
Skewness0
Sum2628
Variance438
MonotonicityStrictly increasing
2024-01-28T15:57:17.595719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.4%
38 1
 
1.4%
54 1
 
1.4%
53 1
 
1.4%
52 1
 
1.4%
51 1
 
1.4%
50 1
 
1.4%
49 1
 
1.4%
48 1
 
1.4%
47 1
 
1.4%
Other values (62) 62
86.1%
ValueCountFrequency (%)
1 1
1.4%
2 1
1.4%
3 1
1.4%
4 1
1.4%
5 1
1.4%
6 1
1.4%
7 1
1.4%
8 1
1.4%
9 1
1.4%
10 1
1.4%
ValueCountFrequency (%)
72 1
1.4%
71 1
1.4%
70 1
1.4%
69 1
1.4%
68 1
1.4%
67 1
1.4%
66 1
1.4%
65 1
1.4%
64 1
1.4%
63 1
1.4%

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size708.0 B
단란주점
72 

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 (%)
단란주점 72
100.0%

Length

2024-01-28T15:57:17.714893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T15:57:17.791053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
단란주점 72
100.0%

업소명
Text

Distinct70
Distinct (%)97.2%
Missing0
Missing (%)0.0%
Memory size708.0 B
2024-01-28T15:57:17.971175image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length6.4861111
Min length2

Characters and Unicode

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

Unique

Unique68 ?
Unique (%)94.4%

Sample

1st row라이브 세시봉
2nd row라이브바다
3rd row7080라이브
4th row커플라이브
5th row블랙노래타운
ValueCountFrequency (%)
라이브 6
 
7.0%
팡팡단란주점 2
 
2.3%
세시봉7080라이브 2
 
2.3%
단란주점 2
 
2.3%
7080 2
 
2.3%
가넷주점 1
 
1.2%
메리트단란주점 1
 
1.2%
라틴7080 1
 
1.2%
성원맥주광장 1
 
1.2%
돈키호테 1
 
1.2%
Other values (67) 67
77.9%
2024-01-28T15:57:18.280130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 34
 
7.3%
주 32
 
6.9%
점 29
 
6.2%
이 27
 
5.8%
라 23
 
4.9%
브 22
 
4.7%
란 18
 
3.9%
단 18
 
3.9%
래 16
 
3.4%
8 16
 
3.4%
Other values (126) 232
49.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 381
81.6%
Decimal Number 68
 
14.6%
Space Separator 14
 
3.0%
Lowercase Letter 3
 
0.6%
Uppercase Letter 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 32
 
8.4%
점 29
 
7.6%
이 27
 
7.1%
라 23
 
6.0%
브 22
 
5.8%
란 18
 
4.7%
단 18
 
4.7%
래 16
 
4.2%
노 12
 
3.1%
고 5
 
1.3%
Other values (117) 179
47.0%
Decimal Number
ValueCountFrequency (%)
0 34
50.0%
8 16
23.5%
7 15
22.1%
9 2
 
2.9%
6 1
 
1.5%
Lowercase Letter
ValueCountFrequency (%)
s 2
66.7%
i 1
33.3%
Space Separator
ValueCountFrequency (%)
14
100.0%
Uppercase Letter
ValueCountFrequency (%)
M 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 381
81.6%
Common 82
 
17.6%
Latin 4
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 32
 
8.4%
점 29
 
7.6%
이 27
 
7.1%
라 23
 
6.0%
브 22
 
5.8%
란 18
 
4.7%
단 18
 
4.7%
래 16
 
4.2%
노 12
 
3.1%
고 5
 
1.3%
Other values (117) 179
47.0%
Common
ValueCountFrequency (%)
0 34
41.5%
8 16
19.5%
7 15
18.3%
14
17.1%
9 2
 
2.4%
6 1
 
1.2%
Latin
ValueCountFrequency (%)
s 2
50.0%
i 1
25.0%
M 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 381
81.6%
ASCII 86
 
18.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 34
39.5%
8 16
18.6%
7 15
17.4%
14
16.3%
s 2
 
2.3%
9 2
 
2.3%
6 1
 
1.2%
i 1
 
1.2%
M 1
 
1.2%
Hangul
ValueCountFrequency (%)
주 32
 
8.4%
점 29
 
7.6%
이 27
 
7.1%
라 23
 
6.0%
브 22
 
5.8%
란 18
 
4.7%
단 18
 
4.7%
래 16
 
4.2%
노 12
 
3.1%
고 5
 
1.3%
Other values (117) 179
47.0%

소재지(도로명)
Text

UNIQUE 

Distinct72
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size708.0 B
2024-01-28T15:57:18.477340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length63
Median length42.5
Mean length31.069444
Min length21

Characters and Unicode

Total characters2237
Distinct characters122
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

Unique72 ?
Unique (%)100.0%

Sample

1st row인천광역시 서구 길주로 79, 성한캣슬1동 2층 206호 (석남동, 518-18외4필지 성한캣슬1 2층 206호)
2nd row인천광역시 서구 길주로 79, 203호 (석남동, 성한캣슬)
3rd row인천광역시 서구 청라에메랄드로102번길 8-22, 미라클프라자 701호 (청라동)
4th row인천광역시 서구 길주로 79, 304호 (석남동)
5th row인천광역시 서구 검단로459번길 10, 3층 303호 (왕길동, 왕길프라자)
ValueCountFrequency (%)
인천광역시 72
 
16.1%
서구 72
 
16.1%
석남동 26
 
5.8%
가정로 20
 
4.5%
길주로 11
 
2.5%
가좌동 10
 
2.2%
심곡동 9
 
2.0%
지하1층 9
 
2.0%
2층 9
 
2.0%
연희동 5
 
1.1%
Other values (162) 203
45.5%
2024-01-28T15:57:18.991835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
374
 
16.7%
1 89
 
4.0%
) 77
 
3.4%
( 77
 
3.4%
서 75
 
3.4%
동 74
 
3.3%
천 73
 
3.3%
인 72
 
3.2%
광 72
 
3.2%
역 72
 
3.2%
Other values (112) 1182
52.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1223
54.7%
Decimal Number 396
 
17.7%
Space Separator 374
 
16.7%
Close Punctuation 77
 
3.4%
Open Punctuation 77
 
3.4%
Other Punctuation 61
 
2.7%
Dash Punctuation 27
 
1.2%
Uppercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 75
 
6.1%
동 74
 
6.1%
천 73
 
6.0%
인 72
 
5.9%
광 72
 
5.9%
역 72
 
5.9%
시 72
 
5.9%
구 72
 
5.9%
로 72
 
5.9%
가 40
 
3.3%
Other values (96) 529
43.3%
Decimal Number
ValueCountFrequency (%)
1 89
22.5%
2 58
14.6%
3 51
12.9%
0 43
10.9%
5 38
9.6%
4 31
 
7.8%
6 25
 
6.3%
8 21
 
5.3%
9 20
 
5.1%
7 20
 
5.1%
Space Separator
ValueCountFrequency (%)
374
100.0%
Close Punctuation
ValueCountFrequency (%)
) 77
100.0%
Open Punctuation
ValueCountFrequency (%)
( 77
100.0%
Other Punctuation
ValueCountFrequency (%)
, 61
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 27
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1223
54.7%
Common 1012
45.2%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 75
 
6.1%
동 74
 
6.1%
천 73
 
6.0%
인 72
 
5.9%
광 72
 
5.9%
역 72
 
5.9%
시 72
 
5.9%
구 72
 
5.9%
로 72
 
5.9%
가 40
 
3.3%
Other values (96) 529
43.3%
Common
ValueCountFrequency (%)
374
37.0%
1 89
 
8.8%
) 77
 
7.6%
( 77
 
7.6%
, 61
 
6.0%
2 58
 
5.7%
3 51
 
5.0%
0 43
 
4.2%
5 38
 
3.8%
4 31
 
3.1%
Other values (5) 113
 
11.2%
Latin
ValueCountFrequency (%)
B 2
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1223
54.7%
ASCII 1014
45.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
374
36.9%
1 89
 
8.8%
) 77
 
7.6%
( 77
 
7.6%
, 61
 
6.0%
2 58
 
5.7%
3 51
 
5.0%
0 43
 
4.2%
5 38
 
3.7%
4 31
 
3.1%
Other values (6) 115
 
11.3%
Hangul
ValueCountFrequency (%)
서 75
 
6.1%
동 74
 
6.1%
천 73
 
6.0%
인 72
 
5.9%
광 72
 
5.9%
역 72
 
5.9%
시 72
 
5.9%
구 72
 
5.9%
로 72
 
5.9%
가 40
 
3.3%
Other values (96) 529
43.3%

전화번호
Text

MISSING 

Distinct50
Distinct (%)98.0%
Missing21
Missing (%)29.2%
Memory size708.0 B
2024-01-28T15:57:19.177912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique49 ?
Unique (%)96.1%

Sample

1st row032-562-7703
2nd row032-563-5993
3rd row032-566-9735
4th row032-567-9646
5th row032-571-3290
ValueCountFrequency (%)
032-582-4041 2
 
3.9%
032-571-2289 1
 
2.0%
032-599-7080 1
 
2.0%
032-562-0404 1
 
2.0%
032-583-0780 1
 
2.0%
032-583-1657 1
 
2.0%
032-583-3213 1
 
2.0%
032-583-3890 1
 
2.0%
032-583-3915 1
 
2.0%
032-583-5006 1
 
2.0%
Other values (40) 40
78.4%
2024-01-28T15:57:19.483069image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 102
16.7%
3 88
14.4%
0 85
13.9%
2 80
13.1%
5 71
11.6%
7 47
7.7%
6 35
 
5.7%
8 31
 
5.1%
1 28
 
4.6%
9 24
 
3.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 510
83.3%
Dash Punctuation 102
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 88
17.3%
0 85
16.7%
2 80
15.7%
5 71
13.9%
7 47
9.2%
6 35
 
6.9%
8 31
 
6.1%
1 28
 
5.5%
9 24
 
4.7%
4 21
 
4.1%
Dash Punctuation
ValueCountFrequency (%)
- 102
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 612
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 102
16.7%
3 88
14.4%
0 85
13.9%
2 80
13.1%
5 71
11.6%
7 47
7.7%
6 35
 
5.7%
8 31
 
5.1%
1 28
 
4.6%
9 24
 
3.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 612
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 102
16.7%
3 88
14.4%
0 85
13.9%
2 80
13.1%
5 71
11.6%
7 47
7.7%
6 35
 
5.7%
8 31
 
5.1%
1 28
 
4.6%
9 24
 
3.9%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size708.0 B
Minimum2022-09-01 00:00:00
Maximum2022-09-01 00:00:00
2024-01-28T15:57:19.572785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T15:57:19.642041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-01-28T15:57:17.219490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-28T15:57:19.709281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업소명소재지(도로명)전화번호
연번1.0000.8671.0001.000
업소명0.8671.0001.0000.997
소재지(도로명)1.0001.0001.0001.000
전화번호1.0000.9971.0001.000

Missing values

2024-01-28T15:57:17.304503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T15:57:17.380349image/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단란주점라이브 세시봉인천광역시 서구 길주로 79, 성한캣슬1동 2층 206호 (석남동, 518-18외4필지 성한캣슬1 2층 206호)<NA>2022-09-01
12단란주점라이브바다인천광역시 서구 길주로 79, 203호 (석남동, 성한캣슬)<NA>2022-09-01
23단란주점7080라이브인천광역시 서구 청라에메랄드로102번길 8-22, 미라클프라자 701호 (청라동)<NA>2022-09-01
34단란주점커플라이브인천광역시 서구 길주로 79, 304호 (석남동)<NA>2022-09-01
45단란주점블랙노래타운인천광역시 서구 검단로459번길 10, 3층 303호 (왕길동, 왕길프라자)<NA>2022-09-01
56단란주점추억의라이브마이마이인천광역시 서구 탁옥로 37, 우리타워 301호 (심곡동)<NA>2022-09-01
67단란주점힐링7080인천광역시 서구 원당대로 644, 패션타운 파티 B동 201호 (당하동)<NA>2022-09-01
78단란주점뷰7080인천광역시 서구 중봉대로586번길 9-4, 쓰리엠타워 305호 (청라동)<NA>2022-09-01
89단란주점세시봉7080라이브인천광역시 서구 청마로7번길 21, 2층 (당하동)<NA>2022-09-01
910단란주점에이플노래짱인천광역시 서구 길주로 83, 2층 일부호 (석남동)<NA>2022-09-01
연번업종명업소명소재지(도로명)전화번호데이터기준일자
6263단란주점원라이브7080인천광역시 서구 거북로 87, 3층 (석남동)032-599-70802022-09-01
6364단란주점팡팡단란주점인천광역시 서구 가정로 124 (가좌동)032-577-83832022-09-01
6465단란주점수8090라이브인천광역시 서구 청라라임로 65, 라임타워 310호 (청라동)<NA>2022-09-01
6566단란주점화인단란주점인천광역시 서구 길주로 87 (석남동, 지하1층)<NA>2022-09-01
6667단란주점산타나7080라이브인천광역시 서구 서곶로301번길 16, 태영프라자 2층 203호 (심곡동)<NA>2022-09-01
6768단란주점동해라이브인천광역시 서구 가정로 259, 2층 일부호 (석남동)<NA>2022-09-01
6869단란주점와이6090 단란주점인천광역시 서구 중봉대로612번길 10-16, 112호 (연희동, 청라마르씨엘)<NA>2022-09-01
6970단란주점청춘뮤직인천광역시 서구 중봉대로612번길 10-8, 반안프라자 2층 202,203호 (연희동)<NA>2022-09-01
7071단란주점별밤7080라이브인천광역시 서구 검단로 463, 현대프라자 B01호 (왕길동)<NA>2022-09-01
7172단란주점쿵쿵따 가요주점인천광역시 서구 서곶로315번길 23, 4층 (심곡동)<NA>2022-09-01