Overview

Dataset statistics

Number of variables4
Number of observations288
Missing cells0
Missing cells (%)0.0%
Duplicate rows1
Duplicate rows (%)0.3%
Total size in memory9.1 KiB
Average record size in memory32.5 B

Variable types

Text3
DateTime1

Dataset

Description경기도 안산시 약국 현황입니다. (약국명,대표전화,주소,월요일 운영,화요일 운영,수요일 운영,목요일 운영,금요일 운영,토요일 운영,일요일 운영,공휴일 운영,데이터기준일자)
URLhttps://www.data.go.kr/data/3035882/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
Dataset has 1 (0.3%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 22:30:03.452834
Analysis finished2023-12-12 22:30:03.884983
Duration0.43 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

약국명
Text

Distinct285
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
2023-12-13T07:30:04.063459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length5.125
Min length3

Characters and Unicode

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

Unique

Unique282 ?
Unique (%)97.9%

Sample

1st row국제약국
2nd row정다운약국
3rd row다나아약국
4th row한양봄약국
5th row한양온누리약국
ValueCountFrequency (%)
수약국 2
 
0.7%
시장약국 2
 
0.7%
동남약국 2
 
0.7%
선부약국 1
 
0.3%
영풍오층약국 1
 
0.3%
새롬약국 1
 
0.3%
대부약국 1
 
0.3%
정문약국 1
 
0.3%
마트약국 1
 
0.3%
쉼터약국 1
 
0.3%
Other values (276) 276
95.5%
2023-12-13T07:30:04.457071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
국 290
19.6%
약 288
19.5%
리 44
 
3.0%
온 32
 
2.2%
누 31
 
2.1%
한 25
 
1.7%
정 17
 
1.2%
사 16
 
1.1%
성 15
 
1.0%
동 14
 
0.9%
Other values (204) 704
47.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1465
99.3%
Decimal Number 10
 
0.7%
Space Separator 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
국 290
19.8%
약 288
19.7%
리 44
 
3.0%
온 32
 
2.2%
누 31
 
2.1%
한 25
 
1.7%
정 17
 
1.2%
사 16
 
1.1%
성 15
 
1.0%
동 14
 
1.0%
Other values (200) 693
47.3%
Decimal Number
ValueCountFrequency (%)
3 4
40.0%
5 3
30.0%
6 3
30.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1465
99.3%
Common 11
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
국 290
19.8%
약 288
19.7%
리 44
 
3.0%
온 32
 
2.2%
누 31
 
2.1%
한 25
 
1.7%
정 17
 
1.2%
사 16
 
1.1%
성 15
 
1.0%
동 14
 
1.0%
Other values (200) 693
47.3%
Common
ValueCountFrequency (%)
3 4
36.4%
5 3
27.3%
6 3
27.3%
1
 
9.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1465
99.3%
ASCII 11
 
0.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
국 290
19.8%
약 288
19.7%
리 44
 
3.0%
온 32
 
2.2%
누 31
 
2.1%
한 25
 
1.7%
정 17
 
1.2%
사 16
 
1.1%
성 15
 
1.0%
동 14
 
1.0%
Other values (200) 693
47.3%
ASCII
ValueCountFrequency (%)
3 4
36.4%
5 3
27.3%
6 3
27.3%
1
 
9.1%

대표전화
Text

Distinct286
Distinct (%)99.3%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
2023-12-13T07:30:04.733859image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length12.069444
Min length12

Characters and Unicode

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

Unique284 ?
Unique (%)98.6%

Sample

1st row0507-1363-8576
2nd row0507-1312-3652
3rd row031-407-7588
4th row031-407-4399
5th row031-362-6551
ValueCountFrequency (%)
031-482-7232 2
 
0.7%
031-419-7575 2
 
0.7%
031-482-2876 1
 
0.3%
031-484-6659 1
 
0.3%
0507-1363-8576 1
 
0.3%
031-482-0353 1
 
0.3%
032-886-2087 1
 
0.3%
031-480-3811 1
 
0.3%
032-881-1071 1
 
0.3%
031-503-6655 1
 
0.3%
Other values (276) 276
95.8%
2023-12-13T07:30:05.195430image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 579
16.7%
- 576
16.6%
1 512
14.7%
3 442
12.7%
4 367
10.6%
5 213
 
6.1%
8 202
 
5.8%
7 193
 
5.6%
2 143
 
4.1%
9 128
 
3.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2900
83.4%
Dash Punctuation 576
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 579
20.0%
1 512
17.7%
3 442
15.2%
4 367
12.7%
5 213
 
7.3%
8 202
 
7.0%
7 193
 
6.7%
2 143
 
4.9%
9 128
 
4.4%
6 121
 
4.2%
Dash Punctuation
ValueCountFrequency (%)
- 576
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 3476
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 579
16.7%
- 576
16.6%
1 512
14.7%
3 442
12.7%
4 367
10.6%
5 213
 
6.1%
8 202
 
5.8%
7 193
 
5.6%
2 143
 
4.1%
9 128
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3476
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 579
16.7%
- 576
16.6%
1 512
14.7%
3 442
12.7%
4 367
10.6%
5 213
 
6.1%
8 202
 
5.8%
7 193
 
5.6%
2 143
 
4.1%
9 128
 
3.7%

주소
Text

Distinct287
Distinct (%)99.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
2023-12-13T07:30:05.617589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length55
Median length43
Mean length35.28125
Min length23

Characters and Unicode

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

Unique

Unique286 ?
Unique (%)99.3%

Sample

1st row경기도 안산시 상록구 석호로 99, 1층 102호 (사동)
2nd row경기도 안산시 상록구 반석로 118, 103호 (본오동)
3rd row경기도 안산시 상록구 샘골로 157, 초원빌딩 101호 (본오동)
4th row경기도 안산시 상록구 한양대학로 51, 1층 (사동)
5th row경기도 안산시 상록구 석호로 294, 1층 (본오동)
ValueCountFrequency (%)
경기도 288
 
13.0%
안산시 288
 
13.0%
단원구 169
 
7.7%
상록구 119
 
5.4%
1층 86
 
3.9%
고잔동 70
 
3.2%
본오동 41
 
1.9%
선부동 35
 
1.6%
원곡동 28
 
1.3%
사동 18
 
0.8%
Other values (529) 1065
48.3%
2023-12-13T07:30:06.280989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1919
 
18.9%
1 564
 
5.6%
, 377
 
3.7%
동 331
 
3.3%
산 305
 
3.0%
안 298
 
2.9%
시 298
 
2.9%
경 296
 
2.9%
도 296
 
2.9%
구 292
 
2.9%
Other values (219) 5185
51.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5643
55.5%
Space Separator 1919
 
18.9%
Decimal Number 1600
 
15.7%
Other Punctuation 378
 
3.7%
Close Punctuation 291
 
2.9%
Open Punctuation 291
 
2.9%
Dash Punctuation 26
 
0.3%
Uppercase Letter 9
 
0.1%
Math Symbol 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 331
 
5.9%
산 305
 
5.4%
안 298
 
5.3%
시 298
 
5.3%
경 296
 
5.2%
도 296
 
5.2%
구 292
 
5.2%
기 290
 
5.1%
로 268
 
4.7%
원 237
 
4.2%
Other values (196) 2732
48.4%
Decimal Number
ValueCountFrequency (%)
1 564
35.2%
0 220
 
13.8%
2 167
 
10.4%
3 147
 
9.2%
4 113
 
7.1%
5 106
 
6.6%
6 83
 
5.2%
7 72
 
4.5%
8 65
 
4.1%
9 63
 
3.9%
Uppercase Letter
ValueCountFrequency (%)
B 4
44.4%
A 1
 
11.1%
D 1
 
11.1%
F 1
 
11.1%
C 1
 
11.1%
Y 1
 
11.1%
Other Punctuation
ValueCountFrequency (%)
, 377
99.7%
& 1
 
0.3%
Space Separator
ValueCountFrequency (%)
1919
100.0%
Close Punctuation
ValueCountFrequency (%)
) 291
100.0%
Open Punctuation
ValueCountFrequency (%)
( 291
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 26
100.0%
Math Symbol
ValueCountFrequency (%)
~ 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5643
55.5%
Common 4509
44.4%
Latin 9
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 331
 
5.9%
산 305
 
5.4%
안 298
 
5.3%
시 298
 
5.3%
경 296
 
5.2%
도 296
 
5.2%
구 292
 
5.2%
기 290
 
5.1%
로 268
 
4.7%
원 237
 
4.2%
Other values (196) 2732
48.4%
Common
ValueCountFrequency (%)
1919
42.6%
1 564
 
12.5%
, 377
 
8.4%
) 291
 
6.5%
( 291
 
6.5%
0 220
 
4.9%
2 167
 
3.7%
3 147
 
3.3%
4 113
 
2.5%
5 106
 
2.4%
Other values (7) 314
 
7.0%
Latin
ValueCountFrequency (%)
B 4
44.4%
A 1
 
11.1%
D 1
 
11.1%
F 1
 
11.1%
C 1
 
11.1%
Y 1
 
11.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5643
55.5%
ASCII 4518
44.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1919
42.5%
1 564
 
12.5%
, 377
 
8.3%
) 291
 
6.4%
( 291
 
6.4%
0 220
 
4.9%
2 167
 
3.7%
3 147
 
3.3%
4 113
 
2.5%
5 106
 
2.3%
Other values (13) 323
 
7.1%
Hangul
ValueCountFrequency (%)
동 331
 
5.9%
산 305
 
5.4%
안 298
 
5.3%
시 298
 
5.3%
경 296
 
5.2%
도 296
 
5.2%
구 292
 
5.2%
기 290
 
5.1%
로 268
 
4.7%
원 237
 
4.2%
Other values (196) 2732
48.4%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
Minimum2023-06-12 00:00:00
Maximum2023-06-12 00:00:00
2023-12-13T07:30:06.413921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:30:06.555867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2023-12-13T07:30:03.743422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:30:03.848200image/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국제약국0507-1363-8576경기도 안산시 상록구 석호로 99, 1층 102호 (사동)2023-06-12
1정다운약국0507-1312-3652경기도 안산시 상록구 반석로 118, 103호 (본오동)2023-06-12
2다나아약국031-407-7588경기도 안산시 상록구 샘골로 157, 초원빌딩 101호 (본오동)2023-06-12
3한양봄약국031-407-4399경기도 안산시 상록구 한양대학로 51, 1층 (사동)2023-06-12
4한양온누리약국031-362-6551경기도 안산시 상록구 석호로 294, 1층 (본오동)2023-06-12
53층큰별약국031-483-7180경기도 안산시 상록구 화랑로 513, 스타프라자 317호 (성포동)2023-06-12
6바른정문약국031-485-0400경기도 안산시 상록구 예술광장로 63, 성포프라자 101,102호 (성포동)2023-06-12
7자연온누리약국031-401-0267경기도 안산시 상록구 예술광장1로 124, 선경프라자 108호 (성포동)2023-06-12
8보세온누리약국031-415-7755경기도 안산시 상록구 광덕1로 355, 데코스포텔 101,102호 (이동)2023-06-12
9뉴허브약국031-419-4015경기도 안산시 상록구 건건로 66, 스마트타워 1층 103호 (건건동)2023-06-12
약국명대표전화주소데이터기준일자
278계림약국031-491-1727경기도 안산시 단원구 원곡로 38 (원곡동)2023-06-12
279박세영약국031-482-8254경기도 안산시 단원구 선부광장1로 14, 106호 (선부동, 광원빌딩)2023-06-12
280우리약국031-487-2014경기도 안산시 단원구 인현중앙길 29 (고잔동, 삼두상가)2023-06-12
281보경약국031-486-2266경기도 안산시 단원구 선부광장1로 69 (선부동)2023-06-12
282구민사약국031-403-2913경기도 안산시 단원구 화정천서로3길 7 (선부동)2023-06-12
283명수당약국031-411-7556경기도 안산시 단원구 원초로 23, 안산8차푸르지오상가 상가동 1층 B06호 (원곡동)2023-06-12
284오박사약국031-487-0137경기도 안산시 단원구 고잔로 76, 113호 (고잔동, 영풍프라자)2023-06-12
285유한약국031-494-3050경기도 안산시 단원구 화랑로 67 (원곡동)2023-06-12
286도원약국031-494-2889경기도 안산시 단원구 원곡로 41 (원곡동)2023-06-12
287제일약국031-484-4004경기도 안산시 단원구 라성로 36 (원곡동, 반월종합상가 B동)2023-06-12

Duplicate rows

Most frequently occurring

약국명대표전화주소데이터기준일자# duplicates
0동남약국031-419-7575경기도 안산시 상록구 샘골로 147, 1층 105호 (본오동)2023-06-122