Overview

Dataset statistics

Number of variables4
Number of observations92
Missing cells3
Missing cells (%)0.8%
Duplicate rows1
Duplicate rows (%)1.1%
Total size in memory3.0 KiB
Average record size in memory33.4 B

Variable types

Text3
Categorical1

Dataset

Description대전광역시 대덕구 약국정보에 대한 데이터로 (명칭, 소재지주소(도로명주소), 전화번호)에 대한 항목을 제공합니다.
URLhttps://www.data.go.kr/data/3070216/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
Dataset has 1 (1.1%) duplicate rowsDuplicates
약국전화번호 has 3 (3.3%) missing valuesMissing

Reproduction

Analysis started2023-12-12 07:18:24.049463
Analysis finished2023-12-12 07:18:24.532966
Duration0.48 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

약국명칭
Text

Distinct91
Distinct (%)98.9%
Missing0
Missing (%)0.0%
Memory size868.0 B
2023-12-12T16:18:24.762591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length8
Mean length4.8369565
Min length3

Characters and Unicode

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

Unique

Unique90 ?
Unique (%)97.8%

Sample

1st row조은종로약국
2nd row미소약국
3rd row신세계훼미리약국
4th row연세약국
5th row동명약국
ValueCountFrequency (%)
명약국 2
 
2.1%
약국 2
 
2.1%
보건당약국 1
 
1.0%
씨티약국 1
 
1.0%
상아약국 1
 
1.0%
홍인약국 1
 
1.0%
메디팜송촌약국 1
 
1.0%
하나약국 1
 
1.0%
두레약국 1
 
1.0%
참사랑약국 1
 
1.0%
Other values (84) 84
87.5%
2023-12-12T16:18:25.256245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
국 92
20.7%
약 92
20.7%
한 10
 
2.2%
리 8
 
1.8%
명 7
 
1.6%
동 7
 
1.6%
신 7
 
1.6%
당 7
 
1.6%
세 5
 
1.1%
새 5
 
1.1%
Other values (114) 205
46.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 441
99.1%
Space Separator 4
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
국 92
20.9%
약 92
20.9%
한 10
 
2.3%
리 8
 
1.8%
명 7
 
1.6%
동 7
 
1.6%
신 7
 
1.6%
당 7
 
1.6%
세 5
 
1.1%
새 5
 
1.1%
Other values (113) 201
45.6%
Space Separator
ValueCountFrequency (%)
4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 441
99.1%
Common 4
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
국 92
20.9%
약 92
20.9%
한 10
 
2.3%
리 8
 
1.8%
명 7
 
1.6%
동 7
 
1.6%
신 7
 
1.6%
당 7
 
1.6%
세 5
 
1.1%
새 5
 
1.1%
Other values (113) 201
45.6%
Common
ValueCountFrequency (%)
4
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 441
99.1%
ASCII 4
 
0.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
국 92
20.9%
약 92
20.9%
한 10
 
2.3%
리 8
 
1.8%
명 7
 
1.6%
동 7
 
1.6%
신 7
 
1.6%
당 7
 
1.6%
세 5
 
1.1%
새 5
 
1.1%
Other values (113) 201
45.6%
ASCII
ValueCountFrequency (%)
4
100.0%

약국전화번호
Text

MISSING 

Distinct88
Distinct (%)98.9%
Missing3
Missing (%)3.3%
Memory size868.0 B
2023-12-12T16:18:25.539191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.988764
Min length11

Characters and Unicode

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

Unique87 ?
Unique (%)97.8%

Sample

1st row042-932-5775
2nd row042-934-1383
3rd row042-637-4627
4th row042-863-2350
5th row042-931-0200
ValueCountFrequency (%)
042-624-3525 2
 
2.2%
042-933-2903 1
 
1.1%
042-932-5775 1
 
1.1%
042-632-5489 1
 
1.1%
042-631-8191 1
 
1.1%
042-638-8275 1
 
1.1%
042-628-8288 1
 
1.1%
042-635-9291 1
 
1.1%
042-638-1919 1
 
1.1%
042-635-7515 1
 
1.1%
Other values (78) 78
87.6%
2023-12-12T16:18:25.983651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 177
16.6%
2 174
16.3%
0 129
12.1%
4 126
11.8%
3 108
10.1%
6 92
8.6%
7 63
 
5.9%
9 61
 
5.7%
5 52
 
4.9%
1 50
 
4.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 890
83.4%
Dash Punctuation 177
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 174
19.6%
0 129
14.5%
4 126
14.2%
3 108
12.1%
6 92
10.3%
7 63
 
7.1%
9 61
 
6.9%
5 52
 
5.8%
1 50
 
5.6%
8 35
 
3.9%
Dash Punctuation
ValueCountFrequency (%)
- 177
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1067
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 177
16.6%
2 174
16.3%
0 129
12.1%
4 126
11.8%
3 108
10.1%
6 92
8.6%
7 63
 
5.9%
9 61
 
5.7%
5 52
 
4.9%
1 50
 
4.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1067
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 177
16.6%
2 174
16.3%
0 129
12.1%
4 126
11.8%
3 108
10.1%
6 92
8.6%
7 63
 
5.9%
9 61
 
5.7%
5 52
 
4.9%
1 50
 
4.7%

약국소재지(도로명)
Text

Distinct91
Distinct (%)98.9%
Missing0
Missing (%)0.0%
Memory size868.0 B
2023-12-12T16:18:26.270664image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length51
Median length43
Mean length28.782609
Min length21

Characters and Unicode

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

Unique

Unique90 ?
Unique (%)97.8%

Sample

1st row대전광역시 대덕구 신탄진로 790(신탄진동)
2nd row대전광역시 대덕구 석봉로37번길 60-19, 1층 (석봉동)
3rd row대전광역시 대덕구 대화11길 14 (대화동)
4th row대전광역시 대덕구 한남로114번길 71 (오정동)
5th row대전광역시 대덕구 덕암로136번길 15, (주)동명양행 (상서동)
ValueCountFrequency (%)
대전광역시 92
 
17.9%
대덕구 92
 
17.9%
1층 17
 
3.3%
법동 14
 
2.7%
중리동 13
 
2.5%
송촌동 12
 
2.3%
오정동 11
 
2.1%
신탄진동 10
 
1.9%
신탄진로 9
 
1.7%
석봉동 8
 
1.6%
Other values (161) 237
46.0%
2023-12-12T16:18:26.652932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
423
 
16.0%
대 220
 
8.3%
1 129
 
4.9%
동 114
 
4.3%
덕 109
 
4.1%
전 99
 
3.7%
( 93
 
3.5%
광 93
 
3.5%
) 93
 
3.5%
역 92
 
3.5%
Other values (100) 1183
44.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1554
58.7%
Decimal Number 425
 
16.0%
Space Separator 423
 
16.0%
Open Punctuation 93
 
3.5%
Close Punctuation 93
 
3.5%
Other Punctuation 51
 
1.9%
Dash Punctuation 9
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
대 220
14.2%
동 114
 
7.3%
덕 109
 
7.0%
전 99
 
6.4%
광 93
 
6.0%
역 92
 
5.9%
시 92
 
5.9%
구 92
 
5.9%
로 92
 
5.9%
길 41
 
2.6%
Other values (85) 510
32.8%
Decimal Number
ValueCountFrequency (%)
1 129
30.4%
2 52
12.2%
0 44
 
10.4%
3 38
 
8.9%
6 34
 
8.0%
7 30
 
7.1%
8 26
 
6.1%
4 26
 
6.1%
5 23
 
5.4%
9 23
 
5.4%
Space Separator
ValueCountFrequency (%)
423
100.0%
Open Punctuation
ValueCountFrequency (%)
( 93
100.0%
Close Punctuation
ValueCountFrequency (%)
) 93
100.0%
Other Punctuation
ValueCountFrequency (%)
, 51
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 9
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1554
58.7%
Common 1094
41.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
대 220
14.2%
동 114
 
7.3%
덕 109
 
7.0%
전 99
 
6.4%
광 93
 
6.0%
역 92
 
5.9%
시 92
 
5.9%
구 92
 
5.9%
로 92
 
5.9%
길 41
 
2.6%
Other values (85) 510
32.8%
Common
ValueCountFrequency (%)
423
38.7%
1 129
 
11.8%
( 93
 
8.5%
) 93
 
8.5%
2 52
 
4.8%
, 51
 
4.7%
0 44
 
4.0%
3 38
 
3.5%
6 34
 
3.1%
7 30
 
2.7%
Other values (5) 107
 
9.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1554
58.7%
ASCII 1094
41.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
423
38.7%
1 129
 
11.8%
( 93
 
8.5%
) 93
 
8.5%
2 52
 
4.8%
, 51
 
4.7%
0 44
 
4.0%
3 38
 
3.5%
6 34
 
3.1%
7 30
 
2.7%
Other values (5) 107
 
9.8%
Hangul
ValueCountFrequency (%)
대 220
14.2%
동 114
 
7.3%
덕 109
 
7.0%
전 99
 
6.4%
광 93
 
6.0%
역 92
 
5.9%
시 92
 
5.9%
구 92
 
5.9%
로 92
 
5.9%
길 41
 
2.6%
Other values (85) 510
32.8%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size868.0 B
2023-08-18
92 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2023-08-18 92
100.0%

Length

2023-12-12T16:18:26.757862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:18:26.832067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-08-18 92
100.0%

Correlations

2023-12-12T16:18:26.881159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
약국명칭약국전화번호약국소재지(도로명)
약국명칭1.0001.0001.000
약국전화번호1.0001.0001.000
약국소재지(도로명)1.0001.0001.000

Missing values

2023-12-12T16:18:24.376176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:18:24.492684image/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조은종로약국042-932-5775대전광역시 대덕구 신탄진로 790(신탄진동)2023-08-18
1미소약국042-934-1383대전광역시 대덕구 석봉로37번길 60-19, 1층 (석봉동)2023-08-18
2신세계훼미리약국<NA>대전광역시 대덕구 대화11길 14 (대화동)2023-08-18
3연세약국042-637-4627대전광역시 대덕구 한남로114번길 71 (오정동)2023-08-18
4동명약국042-863-2350대전광역시 대덕구 덕암로136번길 15, (주)동명양행 (상서동)2023-08-18
5바른약국042-931-0200대전광역시 대덕구 신탄진로 811, 현대증권 1층 (신탄진동)2023-08-18
6열린약국042-628-7100대전광역시 대덕구 중리로75번길 2 (중리동)2023-08-18
7신약국042-633-7588대전광역시 대덕구 동춘당로 179, 골드타워 102호 (법동)2023-08-18
8스마트약국042-639-8837대전광역시 대덕구 송촌북로 60 (송촌동)2023-08-18
9명약국042-624-3525대전광역시 대덕구 한남로 123 (오정동, 문화빌딩)2023-08-18
약국명칭약국전화번호약국소재지(도로명)데이터기준일자
82신탄대한약국042-934-7575대전광역시 대덕구 석봉로38번길 67 (석봉동)2023-08-18
83세진약국042-636-6601대전광역시 대덕구 대전로1177번길 63-8, 23호 (오정동)2023-08-18
84김명관약국042-933-2422대전광역시 대덕구 신탄진로 814 (신탄진동)2023-08-18
85삼호약국042-623-2305대전광역시 대덕구 계족로663번길 32, 103,104호 (법동, 삼호아파트)2023-08-18
86동남약국042-631-9932대전광역시 대덕구 계족로761번길 24, 111호 (읍내동, 현대상가)2023-08-18
87대전약국042-622-5869대전광역시 대덕구 중리로 82 (중리동)2023-08-18
88세실약국042-622-4779대전광역시 대덕구 한밭대로1036번길 37 (오정동)2023-08-18
89신성약국042-932-2916대전광역시 대덕구 신탄진동로23번길 48 (신탄진동)2023-08-18
90메디팜프라자약국042-672-8305대전광역시 대덕구 대전로 1369 (읍내동)2023-08-18
91신탄약국042-932-1155대전광역시 대덕구 대덕대로1470번길 68 (목상동)2023-08-18

Duplicate rows

Most frequently occurring

약국명칭약국전화번호약국소재지(도로명)데이터기준일자# duplicates
0명약국042-624-3525대전광역시 대덕구 한남로 123 (오정동, 문화빌딩)2023-08-182