Overview

Dataset statistics

Number of variables6
Number of observations1772
Missing cells1264
Missing cells (%)11.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory84.9 KiB
Average record size in memory49.1 B

Variable types

Numeric1
Categorical1
Text3
DateTime1

Dataset

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

Alerts

업종명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
전화번호 has 1264 (71.3%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 21:31:52.076370
Analysis finished2023-12-12 21:31:53.015042
Duration0.94 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct1772
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean886.5
Minimum1
Maximum1772
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size15.7 KiB
2023-12-13T06:31:53.096917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile89.55
Q1443.75
median886.5
Q31329.25
95-th percentile1683.45
Maximum1772
Range1771
Interquartile range (IQR)885.5

Descriptive statistics

Standard deviation511.67666
Coefficient of variation (CV)0.57718743
Kurtosis-1.2
Mean886.5
Median Absolute Deviation (MAD)443
Skewness0
Sum1570878
Variance261813
MonotonicityStrictly increasing
2023-12-13T06:31:53.245685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
1179 1
 
0.1%
1190 1
 
0.1%
1189 1
 
0.1%
1188 1
 
0.1%
1187 1
 
0.1%
1186 1
 
0.1%
1185 1
 
0.1%
1184 1
 
0.1%
1183 1
 
0.1%
Other values (1762) 1762
99.4%
ValueCountFrequency (%)
1 1
0.1%
2 1
0.1%
3 1
0.1%
4 1
0.1%
5 1
0.1%
6 1
0.1%
7 1
0.1%
8 1
0.1%
9 1
0.1%
10 1
0.1%
ValueCountFrequency (%)
1772 1
0.1%
1771 1
0.1%
1770 1
0.1%
1769 1
0.1%
1768 1
0.1%
1767 1
0.1%
1766 1
0.1%
1765 1
0.1%
1764 1
0.1%
1763 1
0.1%

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size14.0 KiB
휴게음식점
1772 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row휴게음식점
2nd row휴게음식점
3rd row휴게음식점
4th row휴게음식점
5th row휴게음식점

Common Values

ValueCountFrequency (%)
휴게음식점 1772
100.0%

Length

2023-12-13T06:31:53.401633image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:31:53.509777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
휴게음식점 1772
100.0%

업소명
Text

Distinct1718
Distinct (%)97.0%
Missing0
Missing (%)0.0%
Memory size14.0 KiB
2023-12-13T06:31:53.732719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length31
Median length22
Mean length8.5654628
Min length1

Characters and Unicode

Total characters15178
Distinct characters665
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

Unique1677 ?
Unique (%)94.6%

Sample

1st row별다방
2nd row영다방
3rd row신현다방
4th row딸기다방
5th row베스킨라빈스 신현점
ValueCountFrequency (%)
세븐일레븐 55
 
2.3%
씨유 36
 
1.5%
청라점 21
 
0.9%
메가엠지씨커피 19
 
0.8%
gs25 19
 
0.8%
이마트24 16
 
0.7%
지에스25 16
 
0.7%
coffee 15
 
0.6%
더벤티 15
 
0.6%
인천청라점 15
 
0.6%
Other values (1813) 2176
90.6%
2023-12-13T06:31:54.207655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 896
 
5.9%
632
 
4.2%
스 402
 
2.6%
라 333
 
2.2%
이 312
 
2.1%
피 308
 
2.0%
커 278
 
1.8%
청 272
 
1.8%
인 265
 
1.7%
천 239
 
1.6%
Other values (655) 11241
74.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 12512
82.4%
Uppercase Letter 776
 
5.1%
Space Separator 632
 
4.2%
Decimal Number 514
 
3.4%
Lowercase Letter 368
 
2.4%
Open Punctuation 175
 
1.2%
Close Punctuation 175
 
1.2%
Other Punctuation 19
 
0.1%
Dash Punctuation 7
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 896
 
7.2%
스 402
 
3.2%
라 333
 
2.7%
이 312
 
2.5%
피 308
 
2.5%
커 278
 
2.2%
청 272
 
2.2%
인 265
 
2.1%
천 239
 
1.9%
븐 206
 
1.6%
Other values (589) 9001
71.9%
Uppercase Letter
ValueCountFrequency (%)
S 115
14.8%
C 110
14.2%
G 92
11.9%
E 69
8.9%
P 49
 
6.3%
O 46
 
5.9%
F 45
 
5.8%
U 32
 
4.1%
A 29
 
3.7%
D 25
 
3.2%
Other values (15) 164
21.1%
Lowercase Letter
ValueCountFrequency (%)
e 66
17.9%
f 40
10.9%
o 36
 
9.8%
a 32
 
8.7%
c 26
 
7.1%
i 17
 
4.6%
r 16
 
4.3%
l 15
 
4.1%
s 15
 
4.1%
t 14
 
3.8%
Other values (12) 91
24.7%
Decimal Number
ValueCountFrequency (%)
2 210
40.9%
5 136
26.5%
4 67
 
13.0%
3 27
 
5.3%
9 27
 
5.3%
1 14
 
2.7%
0 12
 
2.3%
8 12
 
2.3%
7 5
 
1.0%
6 4
 
0.8%
Other Punctuation
ValueCountFrequency (%)
& 10
52.6%
' 3
 
15.8%
# 2
 
10.5%
/ 2
 
10.5%
. 2
 
10.5%
Space Separator
ValueCountFrequency (%)
632
100.0%
Open Punctuation
ValueCountFrequency (%)
( 175
100.0%
Close Punctuation
ValueCountFrequency (%)
) 175
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 12512
82.4%
Common 1522
 
10.0%
Latin 1144
 
7.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 896
 
7.2%
스 402
 
3.2%
라 333
 
2.7%
이 312
 
2.5%
피 308
 
2.5%
커 278
 
2.2%
청 272
 
2.2%
인 265
 
2.1%
천 239
 
1.9%
븐 206
 
1.6%
Other values (589) 9001
71.9%
Latin
ValueCountFrequency (%)
S 115
 
10.1%
C 110
 
9.6%
G 92
 
8.0%
E 69
 
6.0%
e 66
 
5.8%
P 49
 
4.3%
O 46
 
4.0%
F 45
 
3.9%
f 40
 
3.5%
o 36
 
3.1%
Other values (37) 476
41.6%
Common
ValueCountFrequency (%)
632
41.5%
2 210
 
13.8%
( 175
 
11.5%
) 175
 
11.5%
5 136
 
8.9%
4 67
 
4.4%
3 27
 
1.8%
9 27
 
1.8%
1 14
 
0.9%
0 12
 
0.8%
Other values (9) 47
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 12512
82.4%
ASCII 2666
 
17.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 896
 
7.2%
스 402
 
3.2%
라 333
 
2.7%
이 312
 
2.5%
피 308
 
2.5%
커 278
 
2.2%
청 272
 
2.2%
인 265
 
2.1%
천 239
 
1.9%
븐 206
 
1.6%
Other values (589) 9001
71.9%
ASCII
ValueCountFrequency (%)
632
23.7%
2 210
 
7.9%
( 175
 
6.6%
) 175
 
6.6%
5 136
 
5.1%
S 115
 
4.3%
C 110
 
4.1%
G 92
 
3.5%
E 69
 
2.6%
4 67
 
2.5%
Other values (56) 885
33.2%

소재지(도로명)
Text

Distinct1756
Distinct (%)99.1%
Missing0
Missing (%)0.0%
Memory size14.0 KiB
2023-12-13T06:31:54.597467image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length72
Median length55
Mean length35.058126
Min length9

Characters and Unicode

Total characters62123
Distinct characters428
Distinct categories11 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1744 ?
Unique (%)98.4%

Sample

1st row인천광역시 서구 가정로 191 (석남동지하 특호)
2nd row인천광역시 서구 거북로83번길 1 (석남동 지하)
3rd row인천광역시 서구 염곡로 335 지하1층 (신현동 143-21(지하1층))
4th row인천광역시 서구 가정로 311-1 (석남동 지하)
5th row인천광역시 서구 가정로 370 (가정동)
ValueCountFrequency (%)
인천광역시 1768
 
14.0%
서구 1767
 
14.0%
1층 525
 
4.2%
청라동 347
 
2.7%
일부 202
 
1.6%
일부호 196
 
1.6%
가좌동 193
 
1.5%
석남동 188
 
1.5%
가정동 142
 
1.1%
마전동 124
 
1.0%
Other values (2073) 7191
56.9%
2023-12-13T06:31:55.191865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
10880
 
17.5%
1 3441
 
5.5%
동 2046
 
3.3%
서 1948
 
3.1%
시 1835
 
3.0%
( 1835
 
3.0%
) 1834
 
3.0%
로 1831
 
2.9%
인 1815
 
2.9%
천 1804
 
2.9%
Other values (418) 32854
52.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 35532
57.2%
Decimal Number 11208
 
18.0%
Space Separator 10880
 
17.5%
Open Punctuation 1835
 
3.0%
Close Punctuation 1834
 
3.0%
Uppercase Letter 384
 
0.6%
Dash Punctuation 310
 
0.5%
Lowercase Letter 94
 
0.2%
Other Punctuation 25
 
< 0.1%
Math Symbol 19
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 2046
 
5.8%
서 1948
 
5.5%
시 1835
 
5.2%
로 1831
 
5.2%
인 1815
 
5.1%
천 1804
 
5.1%
광 1781
 
5.0%
역 1781
 
5.0%
구 1778
 
5.0%
호 1275
 
3.6%
Other values (366) 17638
49.6%
Uppercase Letter
ValueCountFrequency (%)
B 78
20.3%
S 38
9.9%
E 33
8.6%
A 33
8.6%
K 27
 
7.0%
L 23
 
6.0%
I 21
 
5.5%
C 20
 
5.2%
W 19
 
4.9%
V 19
 
4.9%
Other values (11) 73
19.0%
Decimal Number
ValueCountFrequency (%)
1 3441
30.7%
2 1462
13.0%
0 1455
13.0%
3 939
 
8.4%
4 795
 
7.1%
6 670
 
6.0%
5 669
 
6.0%
7 616
 
5.5%
8 604
 
5.4%
9 557
 
5.0%
Lowercase Letter
ValueCountFrequency (%)
e 31
33.0%
s 17
18.1%
r 15
16.0%
d 15
16.0%
a 15
16.0%
o 1
 
1.1%
Other Punctuation
ValueCountFrequency (%)
' 15
60.0%
. 4
 
16.0%
" 2
 
8.0%
& 2
 
8.0%
/ 1
 
4.0%
@ 1
 
4.0%
Math Symbol
ValueCountFrequency (%)
~ 9
47.4%
< 5
26.3%
> 5
26.3%
Letter Number
ValueCountFrequency (%)
Ⅱ 1
50.0%
Ⅰ 1
50.0%
Space Separator
ValueCountFrequency (%)
10880
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1835
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1834
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 310
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 35532
57.2%
Common 26111
42.0%
Latin 480
 
0.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 2046
 
5.8%
서 1948
 
5.5%
시 1835
 
5.2%
로 1831
 
5.2%
인 1815
 
5.1%
천 1804
 
5.1%
광 1781
 
5.0%
역 1781
 
5.0%
구 1778
 
5.0%
호 1275
 
3.6%
Other values (366) 17638
49.6%
Latin
ValueCountFrequency (%)
B 78
16.2%
S 38
 
7.9%
E 33
 
6.9%
A 33
 
6.9%
e 31
 
6.5%
K 27
 
5.6%
L 23
 
4.8%
I 21
 
4.4%
C 20
 
4.2%
W 19
 
4.0%
Other values (19) 157
32.7%
Common
ValueCountFrequency (%)
10880
41.7%
1 3441
 
13.2%
( 1835
 
7.0%
) 1834
 
7.0%
2 1462
 
5.6%
0 1455
 
5.6%
3 939
 
3.6%
4 795
 
3.0%
6 670
 
2.6%
5 669
 
2.6%
Other values (13) 2131
 
8.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 35505
57.2%
ASCII 26589
42.8%
Compat Jamo 27
 
< 0.1%
Number Forms 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
10880
40.9%
1 3441
 
12.9%
( 1835
 
6.9%
) 1834
 
6.9%
2 1462
 
5.5%
0 1455
 
5.5%
3 939
 
3.5%
4 795
 
3.0%
6 670
 
2.5%
5 669
 
2.5%
Other values (40) 2609
 
9.8%
Hangul
ValueCountFrequency (%)
동 2046
 
5.8%
서 1948
 
5.5%
시 1835
 
5.2%
로 1831
 
5.2%
인 1815
 
5.1%
천 1804
 
5.1%
광 1781
 
5.0%
역 1781
 
5.0%
구 1778
 
5.0%
호 1275
 
3.6%
Other values (365) 17611
49.6%
Compat Jamo
ValueCountFrequency (%)
ㆍ 27
100.0%
Number Forms
ValueCountFrequency (%)
Ⅱ 1
50.0%
Ⅰ 1
50.0%

전화번호
Text

MISSING 

Distinct499
Distinct (%)98.2%
Missing1264
Missing (%)71.3%
Memory size14.0 KiB
2023-12-13T06:31:55.502274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length12.068898
Min length11

Characters and Unicode

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

Unique493 ?
Unique (%)97.0%

Sample

1st row02-1577-3663
2nd row02-2670-6177
3rd row02-3284-8116
4th row02-3284-8168
5th row031-376-0035
ValueCountFrequency (%)
02-3284-8116 4
 
0.8%
02-3284-8129 3
 
0.6%
032-564-7942 2
 
0.4%
070-7403-9112 2
 
0.4%
032-560-2500 2
 
0.4%
032-572-8801 2
 
0.4%
032-568-2890 1
 
0.2%
032-567-8344 1
 
0.2%
032-567-8962 1
 
0.2%
032-568-0720 1
 
0.2%
Other values (489) 489
96.3%
2023-12-13T06:31:55.830085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 1016
16.6%
0 863
14.1%
2 797
13.0%
3 686
11.2%
5 686
11.2%
6 477
7.8%
7 466
7.6%
1 336
 
5.5%
8 324
 
5.3%
9 251
 
4.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 5115
83.4%
Dash Punctuation 1016
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 863
16.9%
2 797
15.6%
3 686
13.4%
5 686
13.4%
6 477
9.3%
7 466
9.1%
1 336
 
6.6%
8 324
 
6.3%
9 251
 
4.9%
4 229
 
4.5%
Dash Punctuation
ValueCountFrequency (%)
- 1016
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 6131
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 1016
16.6%
0 863
14.1%
2 797
13.0%
3 686
11.2%
5 686
11.2%
6 477
7.8%
7 466
7.6%
1 336
 
5.5%
8 324
 
5.3%
9 251
 
4.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 6131
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 1016
16.6%
0 863
14.1%
2 797
13.0%
3 686
11.2%
5 686
11.2%
6 477
7.8%
7 466
7.6%
1 336
 
5.5%
8 324
 
5.3%
9 251
 
4.1%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size14.0 KiB
Minimum2022-09-06 00:00:00
Maximum2022-09-06 00:00:00
2023-12-13T06:31:55.922475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:31:56.013982image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T06:31:52.695177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-13T06:31:52.825497image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T06:31:52.953912image/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휴게음식점별다방인천광역시 서구 가정로 191 (석남동지하 특호)<NA>2022-09-06
12휴게음식점영다방인천광역시 서구 거북로83번길 1 (석남동 지하)<NA>2022-09-06
23휴게음식점신현다방인천광역시 서구 염곡로 335 지하1층 (신현동 143-21(지하1층))<NA>2022-09-06
34휴게음식점딸기다방인천광역시 서구 가정로 311-1 (석남동 지하)<NA>2022-09-06
45휴게음식점베스킨라빈스 신현점인천광역시 서구 가정로 370 (가정동)<NA>2022-09-06
56휴게음식점정다방인천광역시 서구 원창로239번길 2 (가정동 510-13)<NA>2022-09-06
67휴게음식점타코빌(Tako vill)인천광역시 서구 검단로 480 (왕길동 검단리치웰프라자112호)<NA>2022-09-06
78휴게음식점다정다방인천광역시 서구 가정로 229 (석남동 지하)<NA>2022-09-06
89휴게음식점행복다방인천광역시 서구 율도로 62 (석남동지하)<NA>2022-09-06
910휴게음식점유성다방인천광역시 서구 건지로 269 지하1층 (석남동 579-3(지하1층))<NA>2022-09-06
연번업종명업소명소재지(도로명)전화번호데이터기준일자
17621763휴게음식점맛나당인천광역시 서구 청라루비로42번길 9 1층 (청라동)<NA>2022-09-06
17631764휴게음식점씨유 검단한내들후문점인천광역시 서구 이음3로 130 후문상가동 103104호 (당하동 유승한내들 에듀파크)<NA>2022-09-06
17641765휴게음식점이마트24 검단완정로점인천광역시 서구 완정로 147 유영빌딩 106107호 (왕길동)<NA>2022-09-06
17651766휴게음식점배스킨라빈스 인천검단금호점인천광역시 서구 이음1로 389 A플러스타워 104105호 (원당동)<NA>2022-09-06
17661767휴게음식점컴포즈커피 인천검단금호점인천광역시 서구 이음5로 66 서영아너시티1차 1층 107호 (원당동)<NA>2022-09-06
17671768휴게음식점해수워터피아거인인천광역시 서구 봉수대로 257 3층 일부호 (가좌동)<NA>2022-09-06
17681769휴게음식점GS25 검단4동점인천광역시 서구 청마로167번길 18 현대프라자 1층 101호 (당하동)<NA>2022-09-06
17691770휴게음식점에그드랍(청라국제업무단지점)인천광역시 서구 청라한내로100번길 10 109호 (청라동)<NA>2022-09-06
17701771휴게음식점달빛설기인천광역시 서구 이음5로 62 정인프라자 410호 (원당동)<NA>2022-09-06
17711772휴게음식점인디커피인천광역시 서구 뱃길1로 11 1층 일부 (오류동)<NA>2022-09-06