Overview

Dataset statistics

Number of variables5
Number of observations527
Missing cells272
Missing cells (%)10.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory20.7 KiB
Average record size in memory40.3 B

Variable types

Categorical2
Text3

Dataset

Description제주특별자치도 제주시 식품관련업 관련 관내 식품 자동판매기 영업 현황 데이터입니다.
Author제주특별자치도 제주시
URLhttps://www.data.go.kr/data/15056167/fileData.do

Alerts

업종명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
전화번호 has 272 (51.6%) missing valuesMissing

Reproduction

Analysis started2023-12-12 05:46:02.857557
Analysis finished2023-12-12 05:46:03.306672
Duration0.45 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
식품자동판매기영업
527 

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 (%)
식품자동판매기영업 527
100.0%

Length

2023-12-12T14:46:03.375302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:46:03.476331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
식품자동판매기영업 527
100.0%

업소명
Text

Distinct526
Distinct (%)99.8%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
2023-12-12T14:46:03.645813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length16
Mean length8.459203
Min length2

Characters and Unicode

Total characters4458
Distinct characters362
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

Unique525 ?
Unique (%)99.6%

Sample

1st row공동주차장
2nd row제주우당도서관구내
3rd row애월읍사무소
4th row삼도2동사무소구내
5th row로즈여관구내
ValueCountFrequency (%)
지에스25 3
 
0.6%
제주도지체장애인협회 2
 
0.4%
주식회사 2
 
0.4%
씨유 2
 
0.4%
씨유제주혜성대유아파트점 1
 
0.2%
씨유제주와산리점 1
 
0.2%
세븐일레븐탑동광장점 1
 
0.2%
지에스25연동삼무점 1
 
0.2%
씨유제주용해로점 1
 
0.2%
씨유제주용연다리점 1
 
0.2%
Other values (523) 523
97.2%
2023-12-12T14:46:03.987224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 328
 
7.4%
주 302
 
6.8%
제 286
 
6.4%
븐 195
 
4.4%
유 155
 
3.5%
씨 144
 
3.2%
일 113
 
2.5%
세 105
 
2.4%
레 105
 
2.4%
스 94
 
2.1%
Other values (352) 2631
59.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4244
95.2%
Decimal Number 157
 
3.5%
Close Punctuation 15
 
0.3%
Open Punctuation 15
 
0.3%
Uppercase Letter 15
 
0.3%
Space Separator 11
 
0.2%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 328
 
7.7%
주 302
 
7.1%
제 286
 
6.7%
븐 195
 
4.6%
유 155
 
3.7%
씨 144
 
3.4%
일 113
 
2.7%
세 105
 
2.5%
레 105
 
2.5%
스 94
 
2.2%
Other values (337) 2417
57.0%
Decimal Number
ValueCountFrequency (%)
2 76
48.4%
5 66
42.0%
4 8
 
5.1%
1 3
 
1.9%
3 2
 
1.3%
6 1
 
0.6%
7 1
 
0.6%
Uppercase Letter
ValueCountFrequency (%)
S 7
46.7%
G 6
40.0%
B 1
 
6.7%
K 1
 
6.7%
Close Punctuation
ValueCountFrequency (%)
) 15
100.0%
Open Punctuation
ValueCountFrequency (%)
( 15
100.0%
Space Separator
ValueCountFrequency (%)
11
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4244
95.2%
Common 199
 
4.5%
Latin 15
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 328
 
7.7%
주 302
 
7.1%
제 286
 
6.7%
븐 195
 
4.6%
유 155
 
3.7%
씨 144
 
3.4%
일 113
 
2.7%
세 105
 
2.5%
레 105
 
2.5%
스 94
 
2.2%
Other values (337) 2417
57.0%
Common
ValueCountFrequency (%)
2 76
38.2%
5 66
33.2%
) 15
 
7.5%
( 15
 
7.5%
11
 
5.5%
4 8
 
4.0%
1 3
 
1.5%
3 2
 
1.0%
6 1
 
0.5%
7 1
 
0.5%
Latin
ValueCountFrequency (%)
S 7
46.7%
G 6
40.0%
B 1
 
6.7%
K 1
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4244
95.2%
ASCII 214
 
4.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 328
 
7.7%
주 302
 
7.1%
제 286
 
6.7%
븐 195
 
4.6%
유 155
 
3.7%
씨 144
 
3.4%
일 113
 
2.7%
세 105
 
2.5%
레 105
 
2.5%
스 94
 
2.2%
Other values (337) 2417
57.0%
ASCII
ValueCountFrequency (%)
2 76
35.5%
5 66
30.8%
) 15
 
7.0%
( 15
 
7.0%
11
 
5.1%
4 8
 
3.7%
S 7
 
3.3%
G 6
 
2.8%
1 3
 
1.4%
3 2
 
0.9%
Other values (5) 5
 
2.3%

소재지
Text

Distinct509
Distinct (%)96.6%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
2023-12-12T14:46:04.329491image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length28
Mean length21.28463
Min length17

Characters and Unicode

Total characters11217
Distinct characters161
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique493 ?
Unique (%)93.5%

Sample

1st row제주특별자치도 제주시 오라일동 2441
2nd row제주특별자치도 제주시 사라봉동길 30
3rd row제주특별자치도 제주시 애월읍 일주서로 6322
4th row제주특별자치도 제주시 관덕로6길 15
5th row제주특별자치도 제주시 동문로 136-1
ValueCountFrequency (%)
제주특별자치도 527
23.4%
제주시 527
23.4%
애월읍 41
 
1.8%
한림읍 32
 
1.4%
조천읍 29
 
1.3%
구좌읍 27
 
1.2%
중앙로 14
 
0.6%
일주서로 11
 
0.5%
노연로 11
 
0.5%
서해안로 11
 
0.5%
Other values (575) 1024
45.4%
2023-12-12T14:46:04.886240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2032
18.1%
주 1080
 
9.6%
제 1059
 
9.4%
도 554
 
4.9%
자 528
 
4.7%
특 527
 
4.7%
별 527
 
4.7%
치 527
 
4.7%
시 527
 
4.7%
로 412
 
3.7%
Other values (151) 3444
30.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7571
67.5%
Space Separator 2032
 
18.1%
Decimal Number 1554
 
13.9%
Dash Punctuation 60
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 1080
14.3%
제 1059
14.0%
도 554
 
7.3%
자 528
 
7.0%
특 527
 
7.0%
별 527
 
7.0%
치 527
 
7.0%
시 527
 
7.0%
로 412
 
5.4%
길 188
 
2.5%
Other values (139) 1642
21.7%
Decimal Number
ValueCountFrequency (%)
1 344
22.1%
2 216
13.9%
4 167
10.7%
3 155
10.0%
6 132
 
8.5%
5 130
 
8.4%
0 117
 
7.5%
7 112
 
7.2%
9 92
 
5.9%
8 89
 
5.7%
Space Separator
ValueCountFrequency (%)
2032
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 60
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7571
67.5%
Common 3646
32.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 1080
14.3%
제 1059
14.0%
도 554
 
7.3%
자 528
 
7.0%
특 527
 
7.0%
별 527
 
7.0%
치 527
 
7.0%
시 527
 
7.0%
로 412
 
5.4%
길 188
 
2.5%
Other values (139) 1642
21.7%
Common
ValueCountFrequency (%)
2032
55.7%
1 344
 
9.4%
2 216
 
5.9%
4 167
 
4.6%
3 155
 
4.3%
6 132
 
3.6%
5 130
 
3.6%
0 117
 
3.2%
7 112
 
3.1%
9 92
 
2.5%
Other values (2) 149
 
4.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7571
67.5%
ASCII 3646
32.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2032
55.7%
1 344
 
9.4%
2 216
 
5.9%
4 167
 
4.6%
3 155
 
4.3%
6 132
 
3.6%
5 130
 
3.6%
0 117
 
3.2%
7 112
 
3.1%
9 92
 
2.5%
Other values (2) 149
 
4.1%
Hangul
ValueCountFrequency (%)
주 1080
14.3%
제 1059
14.0%
도 554
 
7.3%
자 528
 
7.0%
특 527
 
7.0%
별 527
 
7.0%
치 527
 
7.0%
시 527
 
7.0%
로 412
 
5.4%
길 188
 
2.5%
Other values (139) 1642
21.7%

전화번호
Text

MISSING 

Distinct244
Distinct (%)95.7%
Missing272
Missing (%)51.6%
Memory size4.2 KiB
2023-12-12T14:46:05.169275image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.913725
Min length1

Characters and Unicode

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

Unique238 ?
Unique (%)93.3%

Sample

1st row064-746-1961
2nd row064-799-3001
3rd row064-723-1236
4th row064-753-5501
5th row064-740-1156
ValueCountFrequency (%)
064-726-7050 6
 
2.4%
064-726-1185 3
 
1.2%
064-756-4980 2
 
0.8%
064-726-7320 2
 
0.8%
064-796-3001 2
 
0.8%
064-757-2697 1
 
0.4%
064-759-7662 1
 
0.4%
064-721-0125 1
 
0.4%
064-724-1819 1
 
0.4%
064-727-0400 1
 
0.4%
Other values (233) 233
92.1%
2023-12-12T14:46:05.640094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 506
16.7%
0 452
14.9%
4 407
13.4%
6 388
12.8%
7 370
12.2%
2 212
7.0%
5 181
 
6.0%
1 161
 
5.3%
3 125
 
4.1%
8 124
 
4.1%
Other values (2) 112
 
3.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2530
83.3%
Dash Punctuation 506
 
16.7%
Space Separator 2
 
0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 452
17.9%
4 407
16.1%
6 388
15.3%
7 370
14.6%
2 212
8.4%
5 181
7.2%
1 161
 
6.4%
3 125
 
4.9%
8 124
 
4.9%
9 110
 
4.3%
Dash Punctuation
ValueCountFrequency (%)
- 506
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 3038
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 506
16.7%
0 452
14.9%
4 407
13.4%
6 388
12.8%
7 370
12.2%
2 212
7.0%
5 181
 
6.0%
1 161
 
5.3%
3 125
 
4.1%
8 124
 
4.1%
Other values (2) 112
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3038
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 506
16.7%
0 452
14.9%
4 407
13.4%
6 388
12.8%
7 370
12.2%
2 212
7.0%
5 181
 
6.0%
1 161
 
5.3%
3 125
 
4.1%
8 124
 
4.1%
Other values (2) 112
 
3.7%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
2021-02-26
527 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-02-26
2nd row2021-02-26
3rd row2021-02-26
4th row2021-02-26
5th row2021-02-26

Common Values

ValueCountFrequency (%)
2021-02-26 527
100.0%

Length

2023-12-12T14:46:05.806521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:46:05.920330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-02-26 527
100.0%

Missing values

2023-12-12T14:46:03.172918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T14:46:03.270086image/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식품자동판매기영업공동주차장제주특별자치도 제주시 오라일동 2441064-746-19612021-02-26
1식품자동판매기영업제주우당도서관구내제주특별자치도 제주시 사라봉동길 30<NA>2021-02-26
2식품자동판매기영업애월읍사무소제주특별자치도 제주시 애월읍 일주서로 6322064-799-30012021-02-26
3식품자동판매기영업삼도2동사무소구내제주특별자치도 제주시 관덕로6길 15064-723-12362021-02-26
4식품자동판매기영업로즈여관구내제주특별자치도 제주시 동문로 136-1064-753-55012021-02-26
5식품자동판매기영업제주도청후생복지회제주특별자치도 제주시 문연로 6064-740-11562021-02-26
6식품자동판매기영업연동새마을부녀회제주특별자치도 제주시 신대로 101064-742-42882021-02-26
7식품자동판매기영업제주도민속자연사박물관구내제주특별자치도 제주시 삼성로 40064-722-24652021-02-26
8식품자동판매기영업구좌읍사무소제주특별자치도 제주시 구좌읍 세화5길 6-9064-728-77142021-02-26
9식품자동판매기영업북제주군보건소제주특별자치도 제주시 한림읍 강구로 5064-796-29112021-02-26
업종명업소명소재지전화번호데이터기준일자
517식품자동판매기영업씨유제주광령2리점제주특별자치도 제주시 애월읍 하광로 472<NA>2021-02-26
518식품자동판매기영업지에스25제주아로마점제주특별자치도 제주시 연동10길 5<NA>2021-02-26
519식품자동판매기영업김녕미로공원제주특별자치도 제주시 구좌읍 만장굴길 122064-782-92662021-02-26
520식품자동판매기영업스터디홀릭커피제주특별자치도 제주시 중앙로 325-1<NA>2021-02-26
521식품자동판매기영업뚜르제주특별자치도 제주시 중앙로 415<NA>2021-02-26
522식품자동판매기영업세븐일레븐제주삼양해수욕장점제주특별자치도 제주시 원당로5길 36<NA>2021-02-26
523식품자동판매기영업벤티모호텔앤레지던스제주특별자치도 제주시 연삼로 14<NA>2021-02-26
524식품자동판매기영업씨유제주그랜드점제주특별자치도 제주시 노연로 73<NA>2021-02-26
525식품자동판매기영업씨유제주용천점제주특별자치도 제주시 신광로10길 30<NA>2021-02-26
526식품자동판매기영업돈벼락복권제주특별자치도 제주시 화남로 53<NA>2021-02-26