Overview

Dataset statistics

Number of variables5
Number of observations146
Missing cells38
Missing cells (%)5.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.8 KiB
Average record size in memory40.9 B

Variable types

Categorical1
Text4

Dataset

Description대전광역시 동구 관내 식품자동판매기 현황에 관한 데이터로서,
Author대전광역시 동구
URLhttps://www.data.go.kr/data/15067214/fileData.do

Alerts

업종명 has constant value ""Constant
소재지전화 has 38 (26.0%) missing valuesMissing
업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 12:47:04.400501
Analysis finished2023-12-12 12:47:04.823204
Duration0.42 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
식품자동판매기영업
146 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row식품자동판매기영업
2nd row식품자동판매기영업
3rd row식품자동판매기영업
4th row식품자동판매기영업
5th row식품자동판매기영업

Common Values

ValueCountFrequency (%)
식품자동판매기영업 146
100.0%

Length

2023-12-12T21:47:04.881577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:47:04.974636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
식품자동판매기영업 146
100.0%

업소명
Text

UNIQUE 

Distinct146
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-12T21:47:05.142934image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length17
Mean length9.1369863
Min length2

Characters and Unicode

Total characters1334
Distinct characters256
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

Unique146 ?
Unique (%)100.0%

Sample

1st row판암자판기
2nd row궁중자판기
3rd row대동건강원자판기
4th row알뜰소비자슈퍼
5th row나상연정형외과
ValueCountFrequency (%)
이마트24 13
 
7.4%
세븐일레븐 6
 
3.4%
자판기 3
 
1.7%
지에스25 2
 
1.1%
판암자판기 1
 
0.6%
원룸점 1
 
0.6%
씨유성남행복점 1
 
0.6%
지에스25판암아이씨점 1
 
0.6%
씨유한밭자이점 1
 
0.6%
씨유대전삼성타운점 1
 
0.6%
Other values (146) 146
83.0%
2023-12-12T21:47:05.500242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
78
 
5.8%
78
 
5.8%
76
 
5.7%
57
 
4.3%
50
 
3.7%
48
 
3.6%
30
 
2.2%
2 29
 
2.2%
29
 
2.2%
28
 
2.1%
Other values (246) 831
62.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1191
89.3%
Decimal Number 59
 
4.4%
Space Separator 30
 
2.2%
Uppercase Letter 24
 
1.8%
Close Punctuation 13
 
1.0%
Open Punctuation 12
 
0.9%
Dash Punctuation 3
 
0.2%
Lowercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
78
 
6.5%
78
 
6.5%
76
 
6.4%
57
 
4.8%
50
 
4.2%
48
 
4.0%
29
 
2.4%
28
 
2.4%
26
 
2.2%
25
 
2.1%
Other values (221) 696
58.4%
Uppercase Letter
ValueCountFrequency (%)
C 7
29.2%
I 3
12.5%
P 3
12.5%
A 2
 
8.3%
O 1
 
4.2%
F 1
 
4.2%
E 1
 
4.2%
T 1
 
4.2%
U 1
 
4.2%
R 1
 
4.2%
Other values (3) 3
12.5%
Decimal Number
ValueCountFrequency (%)
2 29
49.2%
4 19
32.2%
5 8
 
13.6%
3 1
 
1.7%
6 1
 
1.7%
1 1
 
1.7%
Lowercase Letter
ValueCountFrequency (%)
t 1
50.0%
s 1
50.0%
Space Separator
ValueCountFrequency (%)
30
100.0%
Close Punctuation
ValueCountFrequency (%)
) 13
100.0%
Open Punctuation
ValueCountFrequency (%)
( 12
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1191
89.3%
Common 117
 
8.8%
Latin 26
 
1.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
78
 
6.5%
78
 
6.5%
76
 
6.4%
57
 
4.8%
50
 
4.2%
48
 
4.0%
29
 
2.4%
28
 
2.4%
26
 
2.2%
25
 
2.1%
Other values (221) 696
58.4%
Latin
ValueCountFrequency (%)
C 7
26.9%
I 3
11.5%
P 3
11.5%
A 2
 
7.7%
O 1
 
3.8%
F 1
 
3.8%
E 1
 
3.8%
T 1
 
3.8%
U 1
 
3.8%
t 1
 
3.8%
Other values (5) 5
19.2%
Common
ValueCountFrequency (%)
30
25.6%
2 29
24.8%
4 19
16.2%
) 13
11.1%
( 12
 
10.3%
5 8
 
6.8%
- 3
 
2.6%
3 1
 
0.9%
6 1
 
0.9%
1 1
 
0.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1191
89.3%
ASCII 143
 
10.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
78
 
6.5%
78
 
6.5%
76
 
6.4%
57
 
4.8%
50
 
4.2%
48
 
4.0%
29
 
2.4%
28
 
2.4%
26
 
2.2%
25
 
2.1%
Other values (221) 696
58.4%
ASCII
ValueCountFrequency (%)
30
21.0%
2 29
20.3%
4 19
13.3%
) 13
9.1%
( 12
 
8.4%
5 8
 
5.6%
C 7
 
4.9%
- 3
 
2.1%
I 3
 
2.1%
P 3
 
2.1%
Other values (15) 16
11.2%
Distinct144
Distinct (%)98.6%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-12T21:47:05.839504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length43
Mean length27.575342
Min length1

Characters and Unicode

Total characters4026
Distinct characters164
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

Unique142 ?
Unique (%)97.3%

Sample

1st row대전광역시 동구 옥천로180번길 23 (판암동,주공상가)
2nd row대전광역시 동구 대전로 677 (인동)
3rd row대전광역시 동구 백룡로11번길 157 (자양동)
4th row대전광역시 동구 산서로 1630 (대별동)
5th row대전광역시 동구 동대전로 59-1 (대동)
ValueCountFrequency (%)
대전광역시 145
 
17.7%
동구 145
 
17.7%
1층 21
 
2.6%
가양동 16
 
2.0%
대전로 15
 
1.8%
성남동 13
 
1.6%
용전동 10
 
1.2%
용운동 9
 
1.1%
정동 8
 
1.0%
삼성동 8
 
1.0%
Other values (280) 427
52.3%
2023-12-12T21:47:06.382976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
671
 
16.7%
335
 
8.3%
216
 
5.4%
192
 
4.8%
1 161
 
4.0%
150
 
3.7%
) 150
 
3.7%
( 149
 
3.7%
148
 
3.7%
147
 
3.7%
Other values (154) 1707
42.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2292
56.9%
Space Separator 671
 
16.7%
Decimal Number 654
 
16.2%
Close Punctuation 150
 
3.7%
Open Punctuation 149
 
3.7%
Other Punctuation 77
 
1.9%
Dash Punctuation 31
 
0.8%
Uppercase Letter 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
335
14.6%
216
 
9.4%
192
 
8.4%
150
 
6.5%
148
 
6.5%
147
 
6.4%
145
 
6.3%
137
 
6.0%
51
 
2.2%
43
 
1.9%
Other values (136) 728
31.8%
Decimal Number
ValueCountFrequency (%)
1 161
24.6%
2 93
14.2%
5 76
11.6%
3 68
10.4%
0 57
 
8.7%
6 47
 
7.2%
7 43
 
6.6%
8 39
 
6.0%
4 35
 
5.4%
9 35
 
5.4%
Other Punctuation
ValueCountFrequency (%)
, 76
98.7%
@ 1
 
1.3%
Uppercase Letter
ValueCountFrequency (%)
C 1
50.0%
B 1
50.0%
Space Separator
ValueCountFrequency (%)
671
100.0%
Close Punctuation
ValueCountFrequency (%)
) 150
100.0%
Open Punctuation
ValueCountFrequency (%)
( 149
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 31
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2292
56.9%
Common 1732
43.0%
Latin 2
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
335
14.6%
216
 
9.4%
192
 
8.4%
150
 
6.5%
148
 
6.5%
147
 
6.4%
145
 
6.3%
137
 
6.0%
51
 
2.2%
43
 
1.9%
Other values (136) 728
31.8%
Common
ValueCountFrequency (%)
671
38.7%
1 161
 
9.3%
) 150
 
8.7%
( 149
 
8.6%
2 93
 
5.4%
, 76
 
4.4%
5 76
 
4.4%
3 68
 
3.9%
0 57
 
3.3%
6 47
 
2.7%
Other values (6) 184
 
10.6%
Latin
ValueCountFrequency (%)
C 1
50.0%
B 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2292
56.9%
ASCII 1734
43.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
671
38.7%
1 161
 
9.3%
) 150
 
8.7%
( 149
 
8.6%
2 93
 
5.4%
, 76
 
4.4%
5 76
 
4.4%
3 68
 
3.9%
0 57
 
3.3%
6 47
 
2.7%
Other values (8) 186
 
10.7%
Hangul
ValueCountFrequency (%)
335
14.6%
216
 
9.4%
192
 
8.4%
150
 
6.5%
148
 
6.5%
147
 
6.4%
145
 
6.3%
137
 
6.0%
51
 
2.2%
43
 
1.9%
Other values (136) 728
31.8%
Distinct144
Distinct (%)98.6%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-12T21:47:06.636775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length37
Median length35
Mean length20.671233
Min length15

Characters and Unicode

Total characters3018
Distinct characters121
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

Unique142 ?
Unique (%)97.3%

Sample

1st row대전광역시 동구 판암동 202 주공상가
2nd row대전광역시 동구 인동 43-1
3rd row대전광역시 동구 자양동 188-4
4th row대전광역시 동구 대별동 163-4
5th row대전광역시 동구 대동 162-1
ValueCountFrequency (%)
대전광역시 146
22.7%
동구 146
22.7%
가양동 18
 
2.8%
성남동 14
 
2.2%
용전동 12
 
1.9%
판암동 11
 
1.7%
용운동 9
 
1.4%
삼성동 9
 
1.4%
정동 8
 
1.2%
낭월동 7
 
1.1%
Other values (207) 262
40.8%
2023-12-12T21:47:06.991665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
635
21.0%
301
 
10.0%
168
 
5.6%
165
 
5.5%
149
 
4.9%
148
 
4.9%
147
 
4.9%
146
 
4.8%
1 130
 
4.3%
- 120
 
4.0%
Other values (111) 909
30.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1640
54.3%
Space Separator 635
 
21.0%
Decimal Number 610
 
20.2%
Dash Punctuation 120
 
4.0%
Close Punctuation 5
 
0.2%
Open Punctuation 4
 
0.1%
Other Punctuation 3
 
0.1%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
301
18.4%
168
10.2%
165
10.1%
149
9.1%
148
9.0%
147
9.0%
146
8.9%
36
 
2.2%
27
 
1.6%
25
 
1.5%
Other values (95) 328
20.0%
Decimal Number
ValueCountFrequency (%)
1 130
21.3%
2 91
14.9%
4 65
10.7%
3 62
10.2%
5 60
9.8%
0 52
 
8.5%
6 46
 
7.5%
7 40
 
6.6%
8 36
 
5.9%
9 28
 
4.6%
Space Separator
ValueCountFrequency (%)
635
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 120
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Other Punctuation
ValueCountFrequency (%)
, 3
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1640
54.3%
Common 1377
45.6%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
301
18.4%
168
10.2%
165
10.1%
149
9.1%
148
9.0%
147
9.0%
146
8.9%
36
 
2.2%
27
 
1.6%
25
 
1.5%
Other values (95) 328
20.0%
Common
ValueCountFrequency (%)
635
46.1%
1 130
 
9.4%
- 120
 
8.7%
2 91
 
6.6%
4 65
 
4.7%
3 62
 
4.5%
5 60
 
4.4%
0 52
 
3.8%
6 46
 
3.3%
7 40
 
2.9%
Other values (5) 76
 
5.5%
Latin
ValueCountFrequency (%)
A 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1640
54.3%
ASCII 1378
45.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
635
46.1%
1 130
 
9.4%
- 120
 
8.7%
2 91
 
6.6%
4 65
 
4.7%
3 62
 
4.5%
5 60
 
4.4%
0 52
 
3.8%
6 46
 
3.3%
7 40
 
2.9%
Other values (6) 77
 
5.6%
Hangul
ValueCountFrequency (%)
301
18.4%
168
10.2%
165
10.1%
149
9.1%
148
9.0%
147
9.0%
146
8.9%
36
 
2.2%
27
 
1.6%
25
 
1.5%
Other values (95) 328
20.0%

소재지전화
Text

MISSING 

Distinct104
Distinct (%)96.3%
Missing38
Missing (%)26.0%
Memory size1.3 KiB
2023-12-12T21:47:07.283273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length11.990741
Min length9

Characters and Unicode

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

Unique101 ?
Unique (%)93.5%

Sample

1st row042-271-4779
2nd row042-283-1722
3rd row042-634-8318
4th row042-271-6558
5th row042-628-3600
ValueCountFrequency (%)
02-6916-1500 3
 
2.8%
042-622-4337 2
 
1.9%
042-627-2298 2
 
1.9%
042-672-0029 1
 
0.9%
042-273-4210 1
 
0.9%
042-625-0429 1
 
0.9%
042-285-6163 1
 
0.9%
042-285-1534 1
 
0.9%
042-272-4039 1
 
0.9%
070-8222-6089 1
 
0.9%
Other values (94) 94
87.0%
2023-12-12T21:47:07.775521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 254
19.6%
- 214
16.5%
0 167
12.9%
4 154
11.9%
6 95
 
7.3%
3 84
 
6.5%
7 81
 
6.3%
8 73
 
5.6%
1 66
 
5.1%
5 59
 
4.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1081
83.5%
Dash Punctuation 214
 
16.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 254
23.5%
0 167
15.4%
4 154
14.2%
6 95
 
8.8%
3 84
 
7.8%
7 81
 
7.5%
8 73
 
6.8%
1 66
 
6.1%
5 59
 
5.5%
9 48
 
4.4%
Dash Punctuation
ValueCountFrequency (%)
- 214
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1295
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 254
19.6%
- 214
16.5%
0 167
12.9%
4 154
11.9%
6 95
 
7.3%
3 84
 
6.5%
7 81
 
6.3%
8 73
 
5.6%
1 66
 
5.1%
5 59
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1295
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 254
19.6%
- 214
16.5%
0 167
12.9%
4 154
11.9%
6 95
 
7.3%
3 84
 
6.5%
7 81
 
6.3%
8 73
 
5.6%
1 66
 
5.1%
5 59
 
4.6%

Missing values

2023-12-12T21:47:04.706957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:47:04.790824image/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식품자동판매기영업판암자판기대전광역시 동구 옥천로180번길 23 (판암동,주공상가)대전광역시 동구 판암동 202 주공상가042-271-4779
1식품자동판매기영업궁중자판기대전광역시 동구 대전로 677 (인동)대전광역시 동구 인동 43-1042-283-1722
2식품자동판매기영업대동건강원자판기대전광역시 동구 백룡로11번길 157 (자양동)대전광역시 동구 자양동 188-4042-634-8318
3식품자동판매기영업알뜰소비자슈퍼대전광역시 동구 산서로 1630 (대별동)대전광역시 동구 대별동 163-4042-271-6558
4식품자동판매기영업나상연정형외과대전광역시 동구 동대전로 59-1 (대동)대전광역시 동구 대동 162-1042-628-3600
5식품자동판매기영업천일슈퍼자판기대전광역시 동구 대전로839번길 32 (정동)대전광역시 동구 정동 36-45042-256-4609
6식품자동판매기영업코레일유통(주)대전역자판기대전광역시 동구 중앙로 215 (정동)대전광역시 동구 정동 1-1042-256-1982
7식품자동판매기영업동화극장자판기대전광역시 동구 대전천동로 462 (인동)대전광역시 동구 인동 29-4042-284-4611
8식품자동판매기영업구) 팔팔개발인력커피자판기대전광역시 동구 삼성시장1길 22 (삼성동)대전광역시 동구 삼성동 105-1042-223-8916
9식품자동판매기영업고속가스충전소자판기대전광역시 동구 동서대로 1660 (성남동)대전광역시 동구 성남동 502-4042-634-0002
업종명업소명소재지(도로명)소재지(지번)소재지전화
136식품자동판매기영업이마트24 대전대2생활관점대전광역시 동구 대학로 62, 대전대학교 이마트24 2생활관점 (용운동)대전광역시 동구 용운동 96-3 대전대학교 이마트24 2생활관점042-286-0850
137식품자동판매기영업이마트24 대전가양로점대전광역시 동구 동대전로 321, 2층 (가양동)대전광역시 동구 가양동 429-1 , 2층02-6916-1500
138식품자동판매기영업이마트24 대전신흥마을점대전광역시 동구 옥천로 38, 101호 (신흥동, 신흥마을아파트)대전광역시 동구 신흥동 212 신흥마을아파트 상가동 101호042-286-7473
139식품자동판매기영업씨유대전하늘채점대전광역시 동구 동구청로 35, 상가동 1층 (대성동, 은어송마을2단지 코오롱하늘채)대전광역시 동구 대성동 130 은어송마을2단지 코오롱하늘채 상가동042-271-6801
140식품자동판매기영업오토카페(AUTO CAFE)대전광역시 동구 계족로 170, 1층 (대동)대전광역시 동구 대동 140-3 ,1층1599-7992
141식품자동판매기영업미스터 컵대전광역시 동구 중앙로 지하 218, 지하1층 104-2호 (중동)대전광역시 동구 중동 317 대전역(도시철도)0507-1328-3748
142식품자동판매기영업씨유에이치디셀프스토리주유소점대전광역시 동구 동서대로 1627, 1층 (홍도동)대전광역시 동구 홍도동 11-24 ,1층042-637-8838
143식품자동판매기영업나래대전광역시 동구 합내로 46, 1층 (가양동)대전광역시 동구 가양동 447-140507-1349-2774
144식품자동판매기영업(사)대전광역시관광협회-트래블라운지대전광역시 동구 중앙로 187-1, 트래블라운지 1층 (중동)대전광역시 동구 중동 26-14<NA>
145식품자동판매기영업더블유스터디카페대전광역시 동구 우암로 159, 지앤지빌딩 5층 501호 (성남동)대전광역시 동구 성남동 155-1 지앤지빌딩<NA>