Overview

Dataset statistics

Number of variables3
Number of observations33
Missing cells4
Missing cells (%)4.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory924.0 B
Average record size in memory28.0 B

Variable types

Text3

Dataset

Description이 데이터는 과천시 관내 안전상비의약품 판매업소 현황에 대한 데이터로 점포명, 전화번호, 소재지 등의 항목을 제공합니다.
Author경기도 과천시
URLhttps://www.data.go.kr/data/3044216/fileData.do

Alerts

전화번호 has 4 (12.1%) missing valuesMissing
점포명 has unique valuesUnique
소재지 has unique valuesUnique

Reproduction

Analysis started2023-12-12 13:32:50.647369
Analysis finished2023-12-12 13:32:50.942530
Duration0.3 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

점포명
Text

UNIQUE 

Distinct33
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size396.0 B
2023-12-12T22:32:51.086645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length9.8787879
Min length7

Characters and Unicode

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

Unique

Unique33 ?
Unique (%)100.0%

Sample

1st row세븐일레븐 과천문원점
2nd rowGS25과천삼성점
3rd rowGS25 과천중앙점
4th row씨유과천주공8단지
5th row씨유과천래미안점
ValueCountFrequency (%)
씨유 9
 
16.1%
지에스25 5
 
8.9%
세븐일레븐 4
 
7.1%
gs25 2
 
3.6%
과천중앙점 2
 
3.6%
과천중앙공원점 1
 
1.8%
과천원문점 1
 
1.8%
뉴양재주암점 1
 
1.8%
과천주암점 1
 
1.8%
과천공원점 1
 
1.8%
Other values (29) 29
51.8%
2023-12-12T22:32:51.445187image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 32
 
9.8%
과 31
 
9.5%
천 30
 
9.2%
23
 
7.1%
씨 16
 
4.9%
유 16
 
4.9%
2 12
 
3.7%
5 11
 
3.4%
지 10
 
3.1%
븐 9
 
2.8%
Other values (67) 136
41.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 264
81.0%
Decimal Number 25
 
7.7%
Space Separator 23
 
7.1%
Uppercase Letter 11
 
3.4%
Other Symbol 1
 
0.3%
Open Punctuation 1
 
0.3%
Close Punctuation 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 32
 
12.1%
과 31
 
11.7%
천 30
 
11.4%
씨 16
 
6.1%
유 16
 
6.1%
지 10
 
3.8%
븐 9
 
3.4%
원 7
 
2.7%
스 6
 
2.3%
에 6
 
2.3%
Other values (56) 101
38.3%
Decimal Number
ValueCountFrequency (%)
2 12
48.0%
5 11
44.0%
8 1
 
4.0%
4 1
 
4.0%
Uppercase Letter
ValueCountFrequency (%)
S 5
45.5%
G 5
45.5%
R 1
 
9.1%
Space Separator
ValueCountFrequency (%)
23
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 265
81.3%
Common 50
 
15.3%
Latin 11
 
3.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 32
 
12.1%
과 31
 
11.7%
천 30
 
11.3%
씨 16
 
6.0%
유 16
 
6.0%
지 10
 
3.8%
븐 9
 
3.4%
원 7
 
2.6%
스 6
 
2.3%
에 6
 
2.3%
Other values (57) 102
38.5%
Common
ValueCountFrequency (%)
23
46.0%
2 12
24.0%
5 11
22.0%
8 1
 
2.0%
( 1
 
2.0%
) 1
 
2.0%
4 1
 
2.0%
Latin
ValueCountFrequency (%)
S 5
45.5%
G 5
45.5%
R 1
 
9.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 264
81.0%
ASCII 61
 
18.7%
None 1
 
0.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 32
 
12.1%
과 31
 
11.7%
천 30
 
11.4%
씨 16
 
6.1%
유 16
 
6.1%
지 10
 
3.8%
븐 9
 
3.4%
원 7
 
2.7%
스 6
 
2.3%
에 6
 
2.3%
Other values (56) 101
38.3%
ASCII
ValueCountFrequency (%)
23
37.7%
2 12
19.7%
5 11
18.0%
S 5
 
8.2%
G 5
 
8.2%
8 1
 
1.6%
( 1
 
1.6%
R 1
 
1.6%
) 1
 
1.6%
4 1
 
1.6%
None
ValueCountFrequency (%)
㈜ 1
100.0%

전화번호
Text

MISSING 

Distinct29
Distinct (%)100.0%
Missing4
Missing (%)12.1%
Memory size396.0 B
2023-12-12T22:32:51.672007image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length11
Mean length11.241379
Min length9

Characters and Unicode

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

Unique29 ?
Unique (%)100.0%

Sample

1st row02-502-5030
2nd row02-502-8768
3rd row02-3679-1688
4th row070-7759-3330
5th row02-3679-1104
ValueCountFrequency (%)
02-502-5030 1
 
3.4%
02-507-0334 1
 
3.4%
02-502-8768 1
 
3.4%
02-504-7004 1
 
3.4%
02-503-1585 1
 
3.4%
0507-1360-7152 1
 
3.4%
02-503-2823 1
 
3.4%
02-3418-4226 1
 
3.4%
02-503-5679 1
 
3.4%
02-503-0585 1
 
3.4%
Other values (19) 19
65.5%
2023-12-12T22:32:52.033357image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 69
21.2%
- 57
17.5%
2 48
14.7%
5 37
11.3%
3 23
 
7.1%
7 20
 
6.1%
1 18
 
5.5%
4 17
 
5.2%
8 15
 
4.6%
6 13
 
4.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 269
82.5%
Dash Punctuation 57
 
17.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 69
25.7%
2 48
17.8%
5 37
13.8%
3 23
 
8.6%
7 20
 
7.4%
1 18
 
6.7%
4 17
 
6.3%
8 15
 
5.6%
6 13
 
4.8%
9 9
 
3.3%
Dash Punctuation
ValueCountFrequency (%)
- 57
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 326
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 69
21.2%
- 57
17.5%
2 48
14.7%
5 37
11.3%
3 23
 
7.1%
7 20
 
6.1%
1 18
 
5.5%
4 17
 
5.2%
8 15
 
4.6%
6 13
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 326
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 69
21.2%
- 57
17.5%
2 48
14.7%
5 37
11.3%
3 23
 
7.1%
7 20
 
6.1%
1 18
 
5.5%
4 17
 
5.2%
8 15
 
4.6%
6 13
 
4.0%

소재지
Text

UNIQUE 

Distinct33
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size396.0 B
2023-12-12T22:32:52.320947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length53
Median length34
Mean length30.151515
Min length19

Characters and Unicode

Total characters995
Distinct characters99
Distinct categories10 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique33 ?
Unique (%)100.0%

Sample

1st row경기도 과천시 별양로 64, 3단지 병원상가 109호 (별양동)
2nd row경기도 과천시 별양로 12, c동 1005호 (원문동, 래미안 슈르)
3rd row경기도 과천시 중앙로 137 (중앙동, 가보자빌딩 105호)
4th row경기도 과천시 별양로 184-1, 8단지 상가 1층(부림동)
5th row경기도 과천시 관문로 143, 상가2동 1층 102호 (중앙동)
ValueCountFrequency (%)
경기도 33
 
15.1%
과천시 33
 
15.1%
1층 13
 
5.9%
별양로 8
 
3.7%
별양동 8
 
3.7%
과천동 6
 
2.7%
갈현동 4
 
1.8%
원문동 4
 
1.8%
주암동 3
 
1.4%
별양상가1로 3
 
1.4%
Other values (89) 104
47.5%
2023-12-12T22:32:52.755885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
186
18.7%
1 60
 
6.0%
과 44
 
4.4%
천 44
 
4.4%
동 39
 
3.9%
경 33
 
3.3%
기 33
 
3.3%
) 33
 
3.3%
( 33
 
3.3%
시 33
 
3.3%
Other values (89) 457
45.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 542
54.5%
Space Separator 186
 
18.7%
Decimal Number 163
 
16.4%
Close Punctuation 33
 
3.3%
Open Punctuation 33
 
3.3%
Other Punctuation 31
 
3.1%
Dash Punctuation 4
 
0.4%
Lowercase Letter 1
 
0.1%
Uppercase Letter 1
 
0.1%
Math Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
과 44
 
8.1%
천 44
 
8.1%
동 39
 
7.2%
경 33
 
6.1%
기 33
 
6.1%
시 33
 
6.1%
도 33
 
6.1%
로 28
 
5.2%
양 21
 
3.9%
별 19
 
3.5%
Other values (71) 215
39.7%
Decimal Number
ValueCountFrequency (%)
1 60
36.8%
2 20
 
12.3%
0 19
 
11.7%
3 17
 
10.4%
4 14
 
8.6%
6 9
 
5.5%
8 8
 
4.9%
7 6
 
3.7%
5 6
 
3.7%
9 4
 
2.5%
Space Separator
ValueCountFrequency (%)
186
100.0%
Close Punctuation
ValueCountFrequency (%)
) 33
100.0%
Open Punctuation
ValueCountFrequency (%)
( 33
100.0%
Other Punctuation
ValueCountFrequency (%)
, 31
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%
Lowercase Letter
ValueCountFrequency (%)
c 1
100.0%
Uppercase Letter
ValueCountFrequency (%)
R 1
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 542
54.5%
Common 451
45.3%
Latin 2
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
과 44
 
8.1%
천 44
 
8.1%
동 39
 
7.2%
경 33
 
6.1%
기 33
 
6.1%
시 33
 
6.1%
도 33
 
6.1%
로 28
 
5.2%
양 21
 
3.9%
별 19
 
3.5%
Other values (71) 215
39.7%
Common
ValueCountFrequency (%)
186
41.2%
1 60
 
13.3%
) 33
 
7.3%
( 33
 
7.3%
, 31
 
6.9%
2 20
 
4.4%
0 19
 
4.2%
3 17
 
3.8%
4 14
 
3.1%
6 9
 
2.0%
Other values (6) 29
 
6.4%
Latin
ValueCountFrequency (%)
c 1
50.0%
R 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 542
54.5%
ASCII 453
45.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
186
41.1%
1 60
 
13.2%
) 33
 
7.3%
( 33
 
7.3%
, 31
 
6.8%
2 20
 
4.4%
0 19
 
4.2%
3 17
 
3.8%
4 14
 
3.1%
6 9
 
2.0%
Other values (8) 31
 
6.8%
Hangul
ValueCountFrequency (%)
과 44
 
8.1%
천 44
 
8.1%
동 39
 
7.2%
경 33
 
6.1%
기 33
 
6.1%
시 33
 
6.1%
도 33
 
6.1%
로 28
 
5.2%
양 21
 
3.9%
별 19
 
3.5%
Other values (71) 215
39.7%

Correlations

2023-12-12T22:32:52.868369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
점포명전화번호소재지
점포명1.0001.0001.000
전화번호1.0001.0001.000
소재지1.0001.0001.000

Missing values

2023-12-12T22:32:50.834178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T22:32:50.915828image/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세븐일레븐 과천문원점02-502-5030경기도 과천시 별양로 64, 3단지 병원상가 109호 (별양동)
1GS25과천삼성점02-502-8768경기도 과천시 별양로 12, c동 1005호 (원문동, 래미안 슈르)
2GS25 과천중앙점02-3679-1688경기도 과천시 중앙로 137 (중앙동, 가보자빌딩 105호)
3씨유과천주공8단지070-7759-3330경기도 과천시 별양로 184-1, 8단지 상가 1층(부림동)
4씨유과천래미안점02-3679-1104경기도 과천시 관문로 143, 상가2동 1층 102호 (중앙동)
5지에스25 과천센트럴점02-504-0406경기도 과천시 별양로 163, 1층 101호 (별양동)
6GS25 과천관문점02-504-5747경기도 과천시 용마로 2 (과천동)
7GS25과천양지점02-507-5386경기도 과천시 양지마을1로 47 (과천동)
8GS25과천래미안점02-504-2031경기도 과천시 별양로 28, 1086,1087호 (원문동)
9㈜코리아세븐 관문체육공원점02-502-4192경기도 과천시 부림4길 34 (부림동)
점포명전화번호소재지
23씨유 과천양지점02-3418-4226경기도 과천시 양지마을1로, 36 (과천동)
24세븐일레븐 과천산과들점02-503-2823경기도 과천시 향촌길 3 (별양동)
25씨유 과천 해오름점0507-1360-7152경기도 과천시 중앙로59 제상가12-1동 (갈현동)
26씨유과천별양점02-503-1585경기도 과천시 향촌길 43, 1층 10호 (별양동)
27지에스25 과천위버필드점02-504-7004경기도 과천시 별양로 39, 1동 102, 103호 (원문동)
28지에스25 뉴과천별양점<NA>경기도 과천시 별양상가1로 30, 골든타워 1층 104호 (별양동)
29씨유 과천제이드자이점1577-8007경기도 과천시 과천대로2길 30, 과천제이드자이단지내상가 1층 1,2호 (갈현동)
30씨유과천어울림점<NA>경기도 과천시 과천대로8길 15, 단지내상가 2동 109호 (갈현동, 과천푸르지오어울림라비엔오)
31지에스25 과천자이점<NA>경기도 과천시 별양로 142, 상가동 116-2, 117호 (별양동)
32씨유과천갈현점<NA>경기도 과천시 찬우물로 36, 화이트스톤 1층 (갈현동)