Overview

Dataset statistics

Number of variables5
Number of observations109
Missing cells40
Missing cells (%)7.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.5 KiB
Average record size in memory42.2 B

Variable types

Numeric1
Categorical1
Text3

Dataset

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

Alerts

업종명 has constant value ""Constant
소재지전화 has 40 (36.7%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 19:15:42.769244
Analysis finished2023-12-12 19:15:43.650957
Duration0.88 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct109
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean55
Minimum1
Maximum109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.1 KiB
2023-12-13T04:15:43.735285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile6.4
Q128
median55
Q382
95-th percentile103.6
Maximum109
Range108
Interquartile range (IQR)54

Descriptive statistics

Standard deviation31.609598
Coefficient of variation (CV)0.57471996
Kurtosis-1.2
Mean55
Median Absolute Deviation (MAD)27
Skewness0
Sum5995
Variance999.16667
MonotonicityStrictly increasing
2023-12-13T04:15:43.944860image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.9%
70 1
 
0.9%
81 1
 
0.9%
80 1
 
0.9%
79 1
 
0.9%
78 1
 
0.9%
77 1
 
0.9%
76 1
 
0.9%
75 1
 
0.9%
74 1
 
0.9%
Other values (99) 99
90.8%
ValueCountFrequency (%)
1 1
0.9%
2 1
0.9%
3 1
0.9%
4 1
0.9%
5 1
0.9%
6 1
0.9%
7 1
0.9%
8 1
0.9%
9 1
0.9%
10 1
0.9%
ValueCountFrequency (%)
109 1
0.9%
108 1
0.9%
107 1
0.9%
106 1
0.9%
105 1
0.9%
104 1
0.9%
103 1
0.9%
102 1
0.9%
101 1
0.9%
100 1
0.9%

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1004.0 B
단란주점
109 

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

Length

2023-12-13T04:15:44.127371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T04:15:44.241944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
단란주점 109
100.0%

업소명
Text

Distinct107
Distinct (%)98.2%
Missing0
Missing (%)0.0%
Memory size1004.0 B
2023-12-13T04:15:44.500882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length6.5321101
Min length2

Characters and Unicode

Total characters712
Distinct characters202
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

Unique105 ?
Unique (%)96.3%

Sample

1st row늘푸른가요주점
2nd row7080보통사람들
3rd row팡팡단란주점
4th row추억의7080라이브
5th row별이빛나는밤에7080
ValueCountFrequency (%)
팡팡단란주점 2
 
1.8%
가요주점 2
 
1.8%
쉘브르 2
 
1.8%
제이제이(jj)라이브클럽 1
 
0.9%
늘푸른가요주점 1
 
0.9%
뉴쎄븐단란주점 1
 
0.9%
술한잔 1
 
0.9%
노래하며 1
 
0.9%
별밤라이브클럽 1
 
0.9%
술마시는빙고 1
 
0.9%
Other values (100) 100
88.5%
2023-12-13T04:15:44.998410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 61
 
8.6%
점 57
 
8.0%
0 37
 
5.2%
단 34
 
4.8%
란 33
 
4.6%
래 22
 
3.1%
7 19
 
2.7%
노 19
 
2.7%
8 17
 
2.4%
이 17
 
2.4%
Other values (192) 396
55.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 612
86.0%
Decimal Number 78
 
11.0%
Uppercase Letter 10
 
1.4%
Space Separator 4
 
0.6%
Open Punctuation 3
 
0.4%
Close Punctuation 3
 
0.4%
Lowercase Letter 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 61
 
10.0%
점 57
 
9.3%
단 34
 
5.6%
란 33
 
5.4%
래 22
 
3.6%
노 19
 
3.1%
이 17
 
2.8%
가 15
 
2.5%
라 14
 
2.3%
브 13
 
2.1%
Other values (173) 327
53.4%
Uppercase Letter
ValueCountFrequency (%)
F 2
20.0%
N 2
20.0%
B 1
10.0%
O 1
10.0%
C 1
10.0%
A 1
10.0%
E 1
10.0%
K 1
10.0%
Decimal Number
ValueCountFrequency (%)
0 37
47.4%
7 19
24.4%
8 17
21.8%
4 2
 
2.6%
3 1
 
1.3%
2 1
 
1.3%
9 1
 
1.3%
Space Separator
ValueCountFrequency (%)
4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Lowercase Letter
ValueCountFrequency (%)
j 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 612
86.0%
Common 88
 
12.4%
Latin 12
 
1.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 61
 
10.0%
점 57
 
9.3%
단 34
 
5.6%
란 33
 
5.4%
래 22
 
3.6%
노 19
 
3.1%
이 17
 
2.8%
가 15
 
2.5%
라 14
 
2.3%
브 13
 
2.1%
Other values (173) 327
53.4%
Common
ValueCountFrequency (%)
0 37
42.0%
7 19
21.6%
8 17
19.3%
4
 
4.5%
( 3
 
3.4%
) 3
 
3.4%
4 2
 
2.3%
3 1
 
1.1%
2 1
 
1.1%
9 1
 
1.1%
Latin
ValueCountFrequency (%)
F 2
16.7%
j 2
16.7%
N 2
16.7%
B 1
8.3%
O 1
8.3%
C 1
8.3%
A 1
8.3%
E 1
8.3%
K 1
8.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 612
86.0%
ASCII 100
 
14.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 61
 
10.0%
점 57
 
9.3%
단 34
 
5.6%
란 33
 
5.4%
래 22
 
3.6%
노 19
 
3.1%
이 17
 
2.8%
가 15
 
2.5%
라 14
 
2.3%
브 13
 
2.1%
Other values (173) 327
53.4%
ASCII
ValueCountFrequency (%)
0 37
37.0%
7 19
19.0%
8 17
17.0%
4
 
4.0%
( 3
 
3.0%
) 3
 
3.0%
4 2
 
2.0%
F 2
 
2.0%
j 2
 
2.0%
N 2
 
2.0%
Other values (9) 9
 
9.0%

소재지(도로명)
Text

Distinct108
Distinct (%)99.1%
Missing0
Missing (%)0.0%
Memory size1004.0 B
2023-12-13T04:15:45.384983image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length43
Mean length27.495413
Min length21

Characters and Unicode

Total characters2997
Distinct characters92
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

Unique107 ?
Unique (%)98.2%

Sample

1st row인천광역시 부평구 시장로 59, 3층 (부평동)
2nd row인천광역시 부평구 길주남로 90 (부평동)
3rd row인천광역시 부평구 경인로 952 (부평동)
4th row인천광역시 부평구 마장로393번길 2 (산곡동)
5th row인천광역시 부평구 평천로 328 (갈산동)
ValueCountFrequency (%)
인천광역시 109
18.4%
부평구 109
18.4%
부평동 45
 
7.6%
십정동 20
 
3.4%
청천동 9
 
1.5%
지하1층 7
 
1.2%
3층 7
 
1.2%
경원대로1377번길 6
 
1.0%
2층 6
 
1.0%
일부호 6
 
1.0%
Other values (169) 267
45.2%
2023-12-13T04:15:45.942802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
483
 
16.1%
부 197
 
6.6%
평 174
 
5.8%
천 122
 
4.1%
시 122
 
4.1%
동 116
 
3.9%
) 115
 
3.8%
( 115
 
3.8%
인 113
 
3.8%
광 113
 
3.8%
Other values (82) 1327
44.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1799
60.0%
Space Separator 483
 
16.1%
Decimal Number 430
 
14.3%
Close Punctuation 115
 
3.8%
Open Punctuation 115
 
3.8%
Other Punctuation 41
 
1.4%
Dash Punctuation 12
 
0.4%
Uppercase Letter 1
 
< 0.1%
Letter Number 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
부 197
 
11.0%
평 174
 
9.7%
천 122
 
6.8%
시 122
 
6.8%
동 116
 
6.4%
인 113
 
6.3%
광 113
 
6.3%
구 109
 
6.1%
역 109
 
6.1%
로 109
 
6.1%
Other values (65) 515
28.6%
Decimal Number
ValueCountFrequency (%)
1 101
23.5%
3 77
17.9%
2 52
12.1%
4 49
11.4%
5 30
 
7.0%
7 29
 
6.7%
6 28
 
6.5%
0 26
 
6.0%
8 22
 
5.1%
9 16
 
3.7%
Space Separator
ValueCountFrequency (%)
483
100.0%
Close Punctuation
ValueCountFrequency (%)
) 115
100.0%
Open Punctuation
ValueCountFrequency (%)
( 115
100.0%
Other Punctuation
ValueCountFrequency (%)
, 41
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 12
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%
Letter Number
ValueCountFrequency (%)
Ⅱ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1799
60.0%
Common 1196
39.9%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
부 197
 
11.0%
평 174
 
9.7%
천 122
 
6.8%
시 122
 
6.8%
동 116
 
6.4%
인 113
 
6.3%
광 113
 
6.3%
구 109
 
6.1%
역 109
 
6.1%
로 109
 
6.1%
Other values (65) 515
28.6%
Common
ValueCountFrequency (%)
483
40.4%
) 115
 
9.6%
( 115
 
9.6%
1 101
 
8.4%
3 77
 
6.4%
2 52
 
4.3%
4 49
 
4.1%
, 41
 
3.4%
5 30
 
2.5%
7 29
 
2.4%
Other values (5) 104
 
8.7%
Latin
ValueCountFrequency (%)
B 1
50.0%
Ⅱ 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1799
60.0%
ASCII 1197
39.9%
Number Forms 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
483
40.4%
) 115
 
9.6%
( 115
 
9.6%
1 101
 
8.4%
3 77
 
6.4%
2 52
 
4.3%
4 49
 
4.1%
, 41
 
3.4%
5 30
 
2.5%
7 29
 
2.4%
Other values (6) 105
 
8.8%
Hangul
ValueCountFrequency (%)
부 197
 
11.0%
평 174
 
9.7%
천 122
 
6.8%
시 122
 
6.8%
동 116
 
6.4%
인 113
 
6.3%
광 113
 
6.3%
구 109
 
6.1%
역 109
 
6.1%
로 109
 
6.1%
Other values (65) 515
28.6%
Number Forms
ValueCountFrequency (%)
Ⅱ 1
100.0%

소재지전화
Text

MISSING 

Distinct69
Distinct (%)100.0%
Missing40
Missing (%)36.7%
Memory size1004.0 B
2023-12-13T04:15:46.271438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique69 ?
Unique (%)100.0%

Sample

1st row032-529-0826
2nd row032-505-8688
3rd row032-522-8484
4th row032-524-9305
5th row032-511-6454
ValueCountFrequency (%)
032-526-5957 1
 
1.4%
032-441-1477 1
 
1.4%
032-501-5947 1
 
1.4%
032-512-8198 1
 
1.4%
032-526-8531 1
 
1.4%
032-527-7470 1
 
1.4%
032-511-1239 1
 
1.4%
032-518-2442 1
 
1.4%
032-525-9199 1
 
1.4%
032-424-7552 1
 
1.4%
Other values (59) 59
85.5%
2023-12-13T04:15:46.785123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 138
16.7%
2 131
15.8%
0 116
14.0%
3 107
12.9%
5 90
10.9%
4 60
7.2%
1 47
 
5.7%
8 40
 
4.8%
7 37
 
4.5%
9 32
 
3.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 690
83.3%
Dash Punctuation 138
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 131
19.0%
0 116
16.8%
3 107
15.5%
5 90
13.0%
4 60
8.7%
1 47
 
6.8%
8 40
 
5.8%
7 37
 
5.4%
9 32
 
4.6%
6 30
 
4.3%
Dash Punctuation
ValueCountFrequency (%)
- 138
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 828
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 138
16.7%
2 131
15.8%
0 116
14.0%
3 107
12.9%
5 90
10.9%
4 60
7.2%
1 47
 
5.7%
8 40
 
4.8%
7 37
 
4.5%
9 32
 
3.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 828
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 138
16.7%
2 131
15.8%
0 116
14.0%
3 107
12.9%
5 90
10.9%
4 60
7.2%
1 47
 
5.7%
8 40
 
4.8%
7 37
 
4.5%
9 32
 
3.9%

Interactions

2023-12-13T04:15:43.029358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T04:15:46.908523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번소재지전화
연번1.0001.000
소재지전화1.0001.000

Missing values

2023-12-13T04:15:43.178951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T04:15:43.612420image/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단란주점늘푸른가요주점인천광역시 부평구 시장로 59, 3층 (부평동)032-529-0826
12단란주점7080보통사람들인천광역시 부평구 길주남로 90 (부평동)032-505-8688
23단란주점팡팡단란주점인천광역시 부평구 경인로 952 (부평동)032-522-8484
34단란주점추억의7080라이브인천광역시 부평구 마장로393번길 2 (산곡동)032-524-9305
45단란주점별이빛나는밤에7080인천광역시 부평구 평천로 328 (갈산동)032-511-6454
56단란주점미투로단란주점인천광역시 부평구 경인로1118번길 9 (일신동)032-502-2523
67단란주점터치단란주점인천광역시 부평구 일신로 10 (일신동)<NA>
78단란주점가요주점인천광역시 부평구 부흥로 383 (부개동)032-525-5010
89단란주점불꽃단란주점인천광역시 부평구 경인로1046번길 4 (부개동)032-525-2869
910단란주점푸른시절7080인천광역시 부평구 부흥로385번길 3 (부개동)032-526-5957
연번업종명업소명소재지(도로명)소재지전화
99100단란주점3F단란주점인천광역시 부평구 경원대로 1368, 3층 (부평동)<NA>
100101단란주점단밤단란주점인천광역시 부평구 대정로 30, 지하1층 일부호 (부평동)<NA>
101102단란주점쉘브르인천광역시 부평구 부평문화로105번길 5, 3층 (부평동)<NA>
102103단란주점뮤직뱅크라운딩인천광역시 부평구 대정로 72, 3층 일부호 (부평동)<NA>
103104단란주점황제트롯시대인천광역시 부평구 부흥로334번길 65, 지하1층 일부호 (부평동)<NA>
104105단란주점주다단란주점인천광역시 부평구 경원대로1403번길 21, 동강 2빌딩 3층 일부호 (부평동)<NA>
105106단란주점뷰라운지인천광역시 부평구 부평대로 24, 가나베스트빌 14층 1402호 (부평동)<NA>
106107단란주점궁단란주점인천광역시 부평구 광장로4번길 22, 2층 (부평동)<NA>
107108단란주점제이제이(jj)라이브클럽인천광역시 부평구 시장로12번길 6, 3층 일부 (부평동)<NA>
108109단란주점레인인천광역시 부평구 경원대로 1368, 지하1층 (부평동)<NA>