Overview

Dataset statistics

Number of variables4
Number of observations117
Missing cells35
Missing cells (%)7.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.8 KiB
Average record size in memory33.1 B

Variable types

Text3
Categorical1

Dataset

Description인천광역시 중구 소재 제과점 현황에 관한 정보입니다.파일명 인천광역시_중구_제과점 현황내용 업소명 소재지 소재지전화번호 등
Author인천광역시 중구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15038715&srcSe=7661IVAWM27C61E190

Alerts

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

Reproduction

Analysis started2024-03-18 03:05:40.042824
Analysis finished2024-03-18 03:05:40.930487
Duration0.89 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업소명
Text

UNIQUE 

Distinct117
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2024-03-18T12:05:41.127398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length18
Mean length10.65812
Min length1

Characters and Unicode

Total characters1247
Distinct characters233
Distinct categories9 ?
Distinct scripts4 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique117 ?
Unique (%)100.0%

Sample

1st row인천당
2nd row파리바게트 연안부두점
3rd row도미노피자 동인천역점
4th row신포과자점
5th row배스킨라빈스
ValueCountFrequency (%)
파리바게뜨 10
 
4.8%
던킨도너츠 8
 
3.8%
잠바주스 7
 
3.4%
인천공항 6
 
2.9%
커피앳웍스 6
 
2.9%
파리바게트 5
 
2.4%
파리크라상 4
 
1.9%
2호점 4
 
1.9%
파스쿠찌 4
 
1.9%
뚜레쥬르 4
 
1.9%
Other values (131) 150
72.1%
2024-03-18T12:05:41.538968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
91
 
7.3%
60
 
4.8%
49
 
3.9%
42
 
3.4%
39
 
3.1%
38
 
3.0%
32
 
2.6%
31
 
2.5%
29
 
2.3%
25
 
2.0%
Other values (223) 811
65.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 954
76.5%
Space Separator 91
 
7.3%
Lowercase Letter 74
 
5.9%
Uppercase Letter 51
 
4.1%
Decimal Number 32
 
2.6%
Close Punctuation 19
 
1.5%
Open Punctuation 19
 
1.5%
Other Punctuation 6
 
0.5%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
60
 
6.3%
49
 
5.1%
42
 
4.4%
39
 
4.1%
38
 
4.0%
32
 
3.4%
31
 
3.2%
29
 
3.0%
25
 
2.6%
24
 
2.5%
Other values (170) 585
61.3%
Lowercase Letter
ValueCountFrequency (%)
a 11
14.9%
e 10
13.5%
f 6
 
8.1%
o 6
 
8.1%
k 5
 
6.8%
r 4
 
5.4%
i 4
 
5.4%
s 4
 
5.4%
n 4
 
5.4%
c 4
 
5.4%
Other values (10) 16
21.6%
Uppercase Letter
ValueCountFrequency (%)
T 11
21.6%
A 5
9.8%
C 5
9.8%
E 4
 
7.8%
D 4
 
7.8%
L 4
 
7.8%
S 3
 
5.9%
F 2
 
3.9%
P 2
 
3.9%
B 2
 
3.9%
Other values (7) 9
17.6%
Decimal Number
ValueCountFrequency (%)
2 16
50.0%
1 8
25.0%
3 2
 
6.2%
4 2
 
6.2%
5 1
 
3.1%
6 1
 
3.1%
8 1
 
3.1%
7 1
 
3.1%
Other Punctuation
ValueCountFrequency (%)
@ 2
33.3%
/ 2
33.3%
& 1
16.7%
, 1
16.7%
Space Separator
ValueCountFrequency (%)
91
100.0%
Close Punctuation
ValueCountFrequency (%)
) 19
100.0%
Open Punctuation
ValueCountFrequency (%)
( 19
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 953
76.4%
Common 168
 
13.5%
Latin 125
 
10.0%
Han 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
60
 
6.3%
49
 
5.1%
42
 
4.4%
39
 
4.1%
38
 
4.0%
32
 
3.4%
31
 
3.3%
29
 
3.0%
25
 
2.6%
24
 
2.5%
Other values (169) 584
61.3%
Latin
ValueCountFrequency (%)
a 11
 
8.8%
T 11
 
8.8%
e 10
 
8.0%
f 6
 
4.8%
o 6
 
4.8%
A 5
 
4.0%
k 5
 
4.0%
C 5
 
4.0%
r 4
 
3.2%
E 4
 
3.2%
Other values (27) 58
46.4%
Common
ValueCountFrequency (%)
91
54.2%
) 19
 
11.3%
( 19
 
11.3%
2 16
 
9.5%
1 8
 
4.8%
@ 2
 
1.2%
3 2
 
1.2%
4 2
 
1.2%
/ 2
 
1.2%
& 1
 
0.6%
Other values (6) 6
 
3.6%
Han
ValueCountFrequency (%)
1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 953
76.4%
ASCII 293
 
23.5%
CJK 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
91
31.1%
) 19
 
6.5%
( 19
 
6.5%
2 16
 
5.5%
a 11
 
3.8%
T 11
 
3.8%
e 10
 
3.4%
1 8
 
2.7%
f 6
 
2.0%
o 6
 
2.0%
Other values (43) 96
32.8%
Hangul
ValueCountFrequency (%)
60
 
6.3%
49
 
5.1%
42
 
4.4%
39
 
4.1%
38
 
4.0%
32
 
3.4%
31
 
3.3%
29
 
3.0%
25
 
2.6%
24
 
2.5%
Other values (169) 584
61.3%
CJK
ValueCountFrequency (%)
1
100.0%
Distinct92
Distinct (%)78.6%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2024-03-18T12:05:41.778948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length78
Median length51
Mean length39.153846
Min length16

Characters and Unicode

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

Unique

Unique82 ?
Unique (%)70.1%

Sample

1st row인천광역시 중구 인현동 23
2nd row인천광역시 중구 축항대로86번길 38 (항동7가, 58-3번지 라이프상가 1층 106호 107호 110호)
3rd row인천광역시 중구 참외전로 188 (율목동, 1층)
4th row인천광역시 중구 우현로 45 (신포동, 9)
5th row인천광역시 중구 우현로87번길 2 (인현동)
ValueCountFrequency (%)
인천광역시 117
 
13.4%
중구 117
 
13.4%
운서동 63
 
7.2%
1층 45
 
5.1%
3층 34
 
3.9%
공항로 32
 
3.7%
272 31
 
3.5%
중산동 16
 
1.8%
인천국제공항여객터미널 15
 
1.7%
면세동 12
 
1.4%
Other values (226) 392
44.9%
2024-03-18T12:05:42.209721image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
759
 
16.6%
1 216
 
4.7%
173
 
3.8%
, 163
 
3.6%
161
 
3.5%
157
 
3.4%
2 148
 
3.2%
141
 
3.1%
124
 
2.7%
119
 
2.6%
Other values (160) 2420
52.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2619
57.2%
Space Separator 759
 
16.6%
Decimal Number 743
 
16.2%
Other Punctuation 163
 
3.6%
Open Punctuation 118
 
2.6%
Close Punctuation 118
 
2.6%
Dash Punctuation 32
 
0.7%
Uppercase Letter 23
 
0.5%
Math Symbol 4
 
0.1%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
173
 
6.6%
161
 
6.1%
157
 
6.0%
141
 
5.4%
124
 
4.7%
119
 
4.5%
118
 
4.5%
117
 
4.5%
117
 
4.5%
107
 
4.1%
Other values (139) 1285
49.1%
Decimal Number
ValueCountFrequency (%)
1 216
29.1%
2 148
19.9%
3 86
 
11.6%
0 61
 
8.2%
7 60
 
8.1%
4 55
 
7.4%
5 41
 
5.5%
6 37
 
5.0%
8 21
 
2.8%
9 18
 
2.4%
Uppercase Letter
ValueCountFrequency (%)
B 10
43.5%
F 7
30.4%
P 6
26.1%
Space Separator
ValueCountFrequency (%)
759
100.0%
Other Punctuation
ValueCountFrequency (%)
, 163
100.0%
Open Punctuation
ValueCountFrequency (%)
( 118
100.0%
Close Punctuation
ValueCountFrequency (%)
) 118
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 32
100.0%
Math Symbol
ValueCountFrequency (%)
~ 4
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%
Letter Number
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2619
57.2%
Common 1937
42.3%
Latin 25
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
173
 
6.6%
161
 
6.1%
157
 
6.0%
141
 
5.4%
124
 
4.7%
119
 
4.5%
118
 
4.5%
117
 
4.5%
117
 
4.5%
107
 
4.1%
Other values (139) 1285
49.1%
Common
ValueCountFrequency (%)
759
39.2%
1 216
 
11.2%
, 163
 
8.4%
2 148
 
7.6%
( 118
 
6.1%
) 118
 
6.1%
3 86
 
4.4%
0 61
 
3.1%
7 60
 
3.1%
4 55
 
2.8%
Other values (6) 153
 
7.9%
Latin
ValueCountFrequency (%)
B 10
40.0%
F 7
28.0%
P 6
24.0%
e 1
 
4.0%
1
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2619
57.2%
ASCII 1961
42.8%
Number Forms 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
759
38.7%
1 216
 
11.0%
, 163
 
8.3%
2 148
 
7.5%
( 118
 
6.0%
) 118
 
6.0%
3 86
 
4.4%
0 61
 
3.1%
7 60
 
3.1%
4 55
 
2.8%
Other values (10) 177
 
9.0%
Hangul
ValueCountFrequency (%)
173
 
6.6%
161
 
6.1%
157
 
6.0%
141
 
5.4%
124
 
4.7%
119
 
4.5%
118
 
4.5%
117
 
4.5%
117
 
4.5%
107
 
4.1%
Other values (139) 1285
49.1%
Number Forms
ValueCountFrequency (%)
1
100.0%

소재지전화
Text

MISSING 

Distinct79
Distinct (%)96.3%
Missing35
Missing (%)29.9%
Memory size1.0 KiB
2024-03-18T12:05:42.414207image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length14
Mean length13.987805
Min length13

Characters and Unicode

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

Unique77 ?
Unique (%)93.9%

Sample

1st row032 - 766-0287
2nd row032 - 885-2448
3rd row032 - 761-3094
4th row032 - 761-0229
5th row032 - 764-2888
ValueCountFrequency (%)
032 67
34.0%
6
 
3.0%
743 5
 
2.5%
752 4
 
2.0%
070 4
 
2.0%
746 4
 
2.0%
751 4
 
2.0%
02-2276-4755 3
 
1.5%
777 3
 
1.5%
010 2
 
1.0%
Other values (93) 95
48.2%
2024-03-18T12:05:42.743931image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 163
14.2%
158
13.8%
0 152
13.3%
3 132
11.5%
7 131
11.4%
2 128
11.2%
4 68
5.9%
5 52
 
4.5%
8 51
 
4.4%
6 43
 
3.7%
Other values (2) 69
6.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 826
72.0%
Dash Punctuation 163
 
14.2%
Space Separator 158
 
13.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 152
18.4%
3 132
16.0%
7 131
15.9%
2 128
15.5%
4 68
8.2%
5 52
 
6.3%
8 51
 
6.2%
6 43
 
5.2%
1 41
 
5.0%
9 28
 
3.4%
Dash Punctuation
ValueCountFrequency (%)
- 163
100.0%
Space Separator
ValueCountFrequency (%)
158
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1147
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 163
14.2%
158
13.8%
0 152
13.3%
3 132
11.5%
7 131
11.4%
2 128
11.2%
4 68
5.9%
5 52
 
4.5%
8 51
 
4.4%
6 43
 
3.7%
Other values (2) 69
6.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1147
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 163
14.2%
158
13.8%
0 152
13.3%
3 132
11.5%
7 131
11.4%
2 128
11.2%
4 68
5.9%
5 52
 
4.5%
8 51
 
4.4%
6 43
 
3.7%
Other values (2) 69
6.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2023-07-05
117 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-07-05
2nd row2023-07-05
3rd row2023-07-05
4th row2023-07-05
5th row2023-07-05

Common Values

ValueCountFrequency (%)
2023-07-05 117
100.0%

Length

2024-03-18T12:05:42.901192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T12:05:43.010383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-07-05 117
100.0%

Correlations

2024-03-18T12:05:43.059503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
소재지소재지전화
소재지1.0000.995
소재지전화0.9951.000

Missing values

2024-03-18T12:05:40.832090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-18T12:05:40.901106image/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

업소명소재지소재지전화데이터기준일자
0인천당인천광역시 중구 인현동 23032 - 766-02872023-07-05
1파리바게트 연안부두점인천광역시 중구 축항대로86번길 38 (항동7가, 58-3번지 라이프상가 1층 106호 107호 110호)032 - 885-24482023-07-05
2도미노피자 동인천역점인천광역시 중구 참외전로 188 (율목동, 1층)032 - 761-30942023-07-05
3신포과자점인천광역시 중구 우현로 45 (신포동, 9)032 - 761-02292023-07-05
4배스킨라빈스인천광역시 중구 우현로87번길 2 (인현동)032 - 764-28882023-07-05
5한국맥도날드동인천점인천광역시 중구 우현로 85-1 (인현동, 27-3번지 1층,2층)032 - 766-29872023-07-05
6(주)신세계푸드 블랑제리 동인천점인천광역시 중구 인중로 134 (신생동, 이마트동인천점)032 -777 -81832023-07-05
7신흥맥도날드인천광역시 중구 인항로 38 (신흥동3가)070 -7017-06002023-07-05
8신포제빵소인천광역시 중구 제물량로 156 (신생동, 7-37번지 1층)032- 766-28822023-07-05
9파리바게뜨공항신도시점인천광역시 중구 흰바위로 31, 110호 (운서동, 에어로시티)032 -751 -90902023-07-05
업소명소재지소재지전화데이터기준일자
107케이크앤조이인천광역시 중구 하늘별빛로 71, 타임프라자 3층 304호 일부 (중산동)<NA>2023-07-05
108콜투마인드인천광역시 중구 영종진로11번길 23, 1층 일부 (중산동)070 -4234-33572023-07-05
109세아베이커리인천광역시 중구 하늘달빛로 88, 채운 에비뉴 1층 110호 (중산동)032 -746 -00052023-07-05
110뉴레이션인천광역시 중구 영종대로196번길 15-15, 스카이파크리움 지하1층 B101호 (운서동)032 -747 -01522023-07-05
111뚜레쥬르 하늘중앙점인천광역시 중구 하늘중앙로225번길 11, 1층 105,106호 (중산동)032 -746 -77092023-07-05
112삼남매 빵집인천광역시 중구 하늘중앙로 272, 306동 B103호 (중산동, 영종국제도시 동원로얄듀크 마리나포레)070 -8287-12582023-07-05
113위쿠키유인천광역시 중구 모랫말로5번길 11, 1층 (운서동)032 -760 -69972023-07-05
114빵 드 오늘(pain de 오늘) 2호점인천광역시 중구 영종대로196번길 25, 1층 115호 (운서동)032 -746 -80462023-07-05
115연(緣)인천광역시 중구 화랑목로 66-1, 1층 104호 (운서동)010 -4735-01282023-07-05
116Landbrot(란트브로트)인천광역시 중구 운남서로10번길 29, 1층 103,104호 (운남동)<NA>2023-07-05