Overview

Dataset statistics

Number of variables7
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.8 KiB
Average record size in memory60.4 B

Variable types

Categorical4
Text3

Dataset

Description의왕시 코로나19 안심식당 지정현황입니다.상호, 소재지, 전화번호, 지정일 등을 제공, 시민들이 안심하고 먹을 수 있는 식당을 인증합니다
Author경기도 의왕시
URLhttps://www.data.go.kr/data/15100255/fileData.do

Alerts

시군명 has constant value ""Constant
업종 has constant value ""Constant
업소명 has unique valuesUnique
소재지 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2024-04-29 23:00:17.925622
Analysis finished2024-04-29 23:00:20.002656
Duration2.08 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시군명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
의왕시
30 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row의왕시
2nd row의왕시
3rd row의왕시
4th row의왕시
5th row의왕시

Common Values

ValueCountFrequency (%)
의왕시 30
100.0%

Length

2024-04-30T08:00:20.070480image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T08:00:20.161813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
의왕시 30
100.0%

업종
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
일반음식점
30 

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 (%)
일반음식점 30
100.0%

Length

2024-04-30T08:00:20.258052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T08:00:20.352310image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반음식점 30
100.0%

업소명
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2024-04-30T08:00:20.502237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length8
Mean length5.1333333
Min length2

Characters and Unicode

Total characters154
Distinct characters104
Distinct categories6 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique30 ?
Unique (%)100.0%

Sample

1st row해마루
2nd row오봉산장
3rd row풍경
4th row농군의집
5th row장수촌
ValueCountFrequency (%)
한정식 4
 
10.5%
해마루 1
 
2.6%
전복촌 1
 
2.6%
㈜송이향 1
 
2.6%
이우철 1
 
2.6%
학의뜰 1
 
2.6%
지지힐 1
 
2.6%
백운 1
 
2.6%
라따 1
 
2.6%
㈜갈비대첩 1
 
2.6%
Other values (25) 25
65.8%
2024-04-30T08:00:20.810168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
8
 
5.2%
정 6
 
3.9%
한 4
 
2.6%
이 4
 
2.6%
의 4
 
2.6%
식 4
 
2.6%
오 4
 
2.6%
라 3
 
1.9%
주 2
 
1.3%
코 2
 
1.3%
Other values (94) 113
73.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 140
90.9%
Space Separator 8
 
5.2%
Other Symbol 2
 
1.3%
Decimal Number 2
 
1.3%
Close Punctuation 1
 
0.6%
Open Punctuation 1
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
정 6
 
4.3%
한 4
 
2.9%
이 4
 
2.9%
의 4
 
2.9%
식 4
 
2.9%
오 4
 
2.9%
라 3
 
2.1%
주 2
 
1.4%
코 2
 
1.4%
담 2
 
1.4%
Other values (89) 105
75.0%
Space Separator
ValueCountFrequency (%)
8
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 2
100.0%
Decimal Number
ValueCountFrequency (%)
8 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 142
92.2%
Common 12
 
7.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
정 6
 
4.2%
한 4
 
2.8%
이 4
 
2.8%
의 4
 
2.8%
식 4
 
2.8%
오 4
 
2.8%
라 3
 
2.1%
주 2
 
1.4%
코 2
 
1.4%
담 2
 
1.4%
Other values (90) 107
75.4%
Common
ValueCountFrequency (%)
8
66.7%
8 2
 
16.7%
) 1
 
8.3%
( 1
 
8.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 140
90.9%
ASCII 12
 
7.8%
None 2
 
1.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
8
66.7%
8 2
 
16.7%
) 1
 
8.3%
( 1
 
8.3%
Hangul
ValueCountFrequency (%)
정 6
 
4.3%
한 4
 
2.9%
이 4
 
2.9%
의 4
 
2.9%
식 4
 
2.9%
오 4
 
2.9%
라 3
 
2.1%
주 2
 
1.4%
코 2
 
1.4%
담 2
 
1.4%
Other values (89) 105
75.0%
None
ValueCountFrequency (%)
㈜ 2
100.0%

소재지
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2024-04-30T08:00:20.980957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length11
Mean length8.1333333
Min length5

Characters and Unicode

Total characters244
Distinct characters95
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

Unique30 ?
Unique (%)100.0%

Sample

1st row경기도 마루
2nd row경기도 봉산장
3rd row경기도 경
4th row경기도 군의집
5th row경기도 수촌
ValueCountFrequency (%)
경기도 30
44.1%
한정식 3
 
4.4%
갈비대첩 1
 
1.5%
송이향 1
 
1.5%
우철 1
 
1.5%
의뜰 1
 
1.5%
지힐 1
 
1.5%
정식 1
 
1.5%
백운 1
 
1.5%
복촌 1
 
1.5%
Other values (27) 27
39.7%
2024-04-30T08:00:21.274727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
38
 
15.6%
경 31
 
12.7%
도 30
 
12.3%
기 30
 
12.3%
정 5
 
2.0%
식 4
 
1.6%
의 4
 
1.6%
한 3
 
1.2%
오 2
 
0.8%
라 2
 
0.8%
Other values (85) 95
38.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 204
83.6%
Space Separator 38
 
15.6%
Decimal Number 1
 
0.4%
Close Punctuation 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
경 31
 
15.2%
도 30
 
14.7%
기 30
 
14.7%
정 5
 
2.5%
식 4
 
2.0%
의 4
 
2.0%
한 3
 
1.5%
오 2
 
1.0%
라 2
 
1.0%
철 2
 
1.0%
Other values (82) 91
44.6%
Space Separator
ValueCountFrequency (%)
38
100.0%
Decimal Number
ValueCountFrequency (%)
8 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 204
83.6%
Common 40
 
16.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
경 31
 
15.2%
도 30
 
14.7%
기 30
 
14.7%
정 5
 
2.5%
식 4
 
2.0%
의 4
 
2.0%
한 3
 
1.5%
오 2
 
1.0%
라 2
 
1.0%
철 2
 
1.0%
Other values (82) 91
44.6%
Common
ValueCountFrequency (%)
38
95.0%
8 1
 
2.5%
) 1
 
2.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 204
83.6%
ASCII 40
 
16.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
38
95.0%
8 1
 
2.5%
) 1
 
2.5%
Hangul
ValueCountFrequency (%)
경 31
 
15.2%
도 30
 
14.7%
기 30
 
14.7%
정 5
 
2.5%
식 4
 
2.0%
의 4
 
2.0%
한 3
 
1.5%
오 2
 
1.0%
라 2
 
1.0%
철 2
 
1.0%
Other values (82) 91
44.6%

전화번호
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2024-04-30T08:00:21.470657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique30 ?
Unique (%)100.0%

Sample

1st row031-450-6979
2nd row031-457-5650
3rd row031-461-3500
4th row031-456-0228
5th row031-422-9952
ValueCountFrequency (%)
031-450-6979 1
 
3.3%
031-457-5650 1
 
3.3%
031-462-2115 1
 
3.3%
031-456-5162 1
 
3.3%
031-426-1008 1
 
3.3%
031-423-7220 1
 
3.3%
031-422-6544 1
 
3.3%
031-421-9595 1
 
3.3%
031-429-7441 1
 
3.3%
031-426-2004 1
 
3.3%
Other values (20) 20
66.7%
2024-04-30T08:00:21.796080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 60
16.7%
0 49
13.6%
3 49
13.6%
1 45
12.5%
2 40
11.1%
4 37
10.3%
5 24
 
6.7%
9 18
 
5.0%
6 13
 
3.6%
8 13
 
3.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 300
83.3%
Dash Punctuation 60
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 49
16.3%
3 49
16.3%
1 45
15.0%
2 40
13.3%
4 37
12.3%
5 24
8.0%
9 18
 
6.0%
6 13
 
4.3%
8 13
 
4.3%
7 12
 
4.0%
Dash Punctuation
ValueCountFrequency (%)
- 60
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 360
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 60
16.7%
0 49
13.6%
3 49
13.6%
1 45
12.5%
2 40
11.1%
4 37
10.3%
5 24
 
6.7%
9 18
 
5.0%
6 13
 
3.6%
8 13
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 360
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 60
16.7%
0 49
13.6%
3 49
13.6%
1 45
12.5%
2 40
11.1%
4 37
10.3%
5 24
 
6.7%
9 18
 
5.0%
6 13
 
3.6%
8 13
 
3.6%

업종 상세
Categorical

Distinct4
Distinct (%)13.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
한식
20 
서양식
6 
기타 음식점업
 
2
일식
 
2

Length

Max length7
Median length2
Mean length2.5333333
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row한식
2nd row한식
3rd row기타 음식점업
4th row서양식
5th row한식

Common Values

ValueCountFrequency (%)
한식 20
66.7%
서양식 6
 
20.0%
기타 음식점업 2
 
6.7%
일식 2
 
6.7%

Length

2024-04-30T08:00:21.968419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T08:00:22.081821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
한식 20
62.5%
서양식 6
 
18.8%
기타 2
 
6.2%
음식점업 2
 
6.2%
일식 2
 
6.2%

지정일
Categorical

Distinct7
Distinct (%)23.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2021-05-27
12 
2020-08-18
9 
2020-12-03
3 
2020-10-14
2 
2021-06-09
2 
Other values (2)
2 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique2 ?
Unique (%)6.7%

Sample

1st row2020-08-18
2nd row2020-08-18
3rd row2020-08-18
4th row2020-08-18
5th row2020-08-18

Common Values

ValueCountFrequency (%)
2021-05-27 12
40.0%
2020-08-18 9
30.0%
2020-12-03 3
 
10.0%
2020-10-14 2
 
6.7%
2021-06-09 2
 
6.7%
2020-08-24 1
 
3.3%
2021-07-16 1
 
3.3%

Length

2024-04-30T08:00:22.192791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T08:00:22.304301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-05-27 12
40.0%
2020-08-18 9
30.0%
2020-12-03 3
 
10.0%
2020-10-14 2
 
6.7%
2021-06-09 2
 
6.7%
2020-08-24 1
 
3.3%
2021-07-16 1
 
3.3%

Correlations

2024-04-30T08:00:22.390959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업소명소재지전화번호업종 상세지정일
업소명1.0001.0001.0001.0001.000
소재지1.0001.0001.0001.0001.000
전화번호1.0001.0001.0001.0001.000
업종 상세1.0001.0001.0001.0000.615
지정일1.0001.0001.0000.6151.000
2024-04-30T08:00:22.486927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종 상세지정일
업종 상세1.0000.440
지정일0.4401.000
2024-04-30T08:00:22.564123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종 상세지정일
업종 상세1.0000.440
지정일0.4401.000

Missing values

2024-04-30T08:00:19.832730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-30T08:00:19.954736image/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의왕시일반음식점해마루경기도 마루031-450-6979한식2020-08-18
1의왕시일반음식점오봉산장경기도 봉산장031-457-5650한식2020-08-18
2의왕시일반음식점풍경경기도 경031-461-3500기타 음식점업2020-08-18
3의왕시일반음식점농군의집경기도 군의집031-456-0228서양식2020-08-18
4의왕시일반음식점장수촌경기도 수촌031-422-9952한식2020-08-18
5의왕시일반음식점오이시쿠경기도 이시쿠031-422-5219일식2020-08-18
6의왕시일반음식점참중나무경기도 중나무031-455-2835한식2020-08-18
7의왕시일반음식점원조포일감자탕경기도 조포일감자탕031-423-0558한식2020-08-18
8의왕시일반음식점정성담경기도 성담031-458-2300한식2020-08-18
9의왕시일반음식점코바코경기도 바코031-429-3381일식2020-08-24
시군명업종업소명소재지전화번호업종 상세지정일
20의왕시일반음식점이우철 한정식경기도 우철 한정식031-424-8882한식2021-05-27
21의왕시일반음식점학의뜰 한정식경기도 의뜰 한정식031-426-2004한식2021-05-27
22의왕시일반음식점지지힐경기도 지힐031-429-7441서양식2021-05-27
23의왕시일반음식점한정식 백운경기도 정식 백운031-421-9595한식2021-05-27
24의왕시일반음식점전복촌경기도 복촌031-422-6544한식2021-05-27
25의왕시일반음식점라따경기도 따031-423-7220서양식2021-05-27
26의왕시일반음식점(주)올라인터내셔널경기도 주)올라인터내셔널031-426-1008서양식2021-05-27
27의왕시일반음식점추오정 남원추어탕 의왕점경기도 오정 남원추어탕 의왕점031-456-5162한식2021-06-09
28의왕시일반음식점88철판오리경기도 8철판오리031-462-2115한식2021-06-09
29의왕시일반음식점카페 메모르경기도 페 메모르031-422-1011기타 음식점업2021-07-16