Overview

Dataset statistics

Number of variables6
Number of observations64
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.2 KiB
Average record size in memory51.1 B

Variable types

Numeric1
Text4
Categorical1

Dataset

Description업종,약국명,약국소재지,약국전화번호,당번일자,영업시간
Author강북구
URLhttps://data.seoul.go.kr/dataList/OA-11613/S/1/datasetView.do

Alerts

업종 has unique valuesUnique
약국명 has unique valuesUnique
약국전화번호 has unique valuesUnique

Reproduction

Analysis started2023-12-11 05:35:36.015571
Analysis finished2023-12-11 05:35:36.759265
Duration0.74 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종
Real number (ℝ)

UNIQUE 

Distinct64
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean32.5
Minimum1
Maximum64
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size708.0 B
2023-12-11T14:35:36.833882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.15
Q116.75
median32.5
Q348.25
95-th percentile60.85
Maximum64
Range63
Interquartile range (IQR)31.5

Descriptive statistics

Standard deviation18.618987
Coefficient of variation (CV)0.5728919
Kurtosis-1.2
Mean32.5
Median Absolute Deviation (MAD)16
Skewness0
Sum2080
Variance346.66667
MonotonicityStrictly increasing
2023-12-11T14:35:36.979344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.6%
34 1
 
1.6%
36 1
 
1.6%
37 1
 
1.6%
38 1
 
1.6%
39 1
 
1.6%
40 1
 
1.6%
41 1
 
1.6%
42 1
 
1.6%
43 1
 
1.6%
Other values (54) 54
84.4%
ValueCountFrequency (%)
1 1
1.6%
2 1
1.6%
3 1
1.6%
4 1
1.6%
5 1
1.6%
6 1
1.6%
7 1
1.6%
8 1
1.6%
9 1
1.6%
10 1
1.6%
ValueCountFrequency (%)
64 1
1.6%
63 1
1.6%
62 1
1.6%
61 1
1.6%
60 1
1.6%
59 1
1.6%
58 1
1.6%
57 1
1.6%
56 1
1.6%
55 1
1.6%

약국명
Text

UNIQUE 

Distinct64
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size644.0 B
2023-12-11T14:35:37.284067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length9
Mean length5.25
Min length3

Characters and Unicode

Total characters336
Distinct characters110
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

Unique64 ?
Unique (%)100.0%

Sample

1st row송도약국
2nd row백화점약국
3rd row새현대약국
4th row길약국
5th row현대약국
ValueCountFrequency (%)
송도약국 1
 
1.6%
백화점약국 1
 
1.6%
세계로약국 1
 
1.6%
번동약국 1
 
1.6%
수유프라자약국 1
 
1.6%
번동종로약국 1
 
1.6%
세일약국 1
 
1.6%
생수당약국 1
 
1.6%
옵티마네오프라자약국 1
 
1.6%
상아약국 1
 
1.6%
Other values (54) 54
84.4%
2023-12-11T14:35:38.111891image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 64
19.0%
국 64
19.0%
리 10
 
3.0%
누 9
 
2.7%
대 8
 
2.4%
온 8
 
2.4%
수 7
 
2.1%
동 6
 
1.8%
일 5
 
1.5%
유 5
 
1.5%
Other values (100) 150
44.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 333
99.1%
Close Punctuation 1
 
0.3%
Open Punctuation 1
 
0.3%
Decimal Number 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 64
19.2%
국 64
19.2%
리 10
 
3.0%
누 9
 
2.7%
대 8
 
2.4%
온 8
 
2.4%
수 7
 
2.1%
동 6
 
1.8%
일 5
 
1.5%
유 5
 
1.5%
Other values (97) 147
44.1%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Decimal Number
ValueCountFrequency (%)
7 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 333
99.1%
Common 3
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 64
19.2%
국 64
19.2%
리 10
 
3.0%
누 9
 
2.7%
대 8
 
2.4%
온 8
 
2.4%
수 7
 
2.1%
동 6
 
1.8%
일 5
 
1.5%
유 5
 
1.5%
Other values (97) 147
44.1%
Common
ValueCountFrequency (%)
) 1
33.3%
( 1
33.3%
7 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 333
99.1%
ASCII 3
 
0.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 64
19.2%
국 64
19.2%
리 10
 
3.0%
누 9
 
2.7%
대 8
 
2.4%
온 8
 
2.4%
수 7
 
2.1%
동 6
 
1.8%
일 5
 
1.5%
유 5
 
1.5%
Other values (97) 147
44.1%
ASCII
ValueCountFrequency (%)
) 1
33.3%
( 1
33.3%
7 1
33.3%

약국소재지
Text

Distinct63
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Memory size644.0 B
2023-12-11T14:35:38.456742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length17
Mean length17.875
Min length16

Characters and Unicode

Total characters1144
Distinct characters45
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

Unique62 ?
Unique (%)96.9%

Sample

1st row서울특별시 강북구 도봉로 343
2nd row서울특별시 강북구 도봉로96길 11
3rd row서울특별시 강북구 인수봉로55길 13
4th row서울특별시 강북구 도봉로67길 21
5th row서울특별시 강북구 도봉로67길 18
ValueCountFrequency (%)
서울특별시 64
24.8%
강북구 64
24.8%
도봉로 19
 
7.4%
삼양로 13
 
5.0%
솔샘로 5
 
1.9%
도봉로67길 4
 
1.6%
한천로 3
 
1.2%
34 3
 
1.2%
59 2
 
0.8%
13 2
 
0.8%
Other values (77) 79
30.6%
2023-12-11T14:35:38.993717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
194
17.0%
서 64
 
5.6%
강 64
 
5.6%
울 64
 
5.6%
로 64
 
5.6%
북 64
 
5.6%
구 64
 
5.6%
시 64
 
5.6%
별 64
 
5.6%
특 64
 
5.6%
Other values (35) 374
32.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 729
63.7%
Decimal Number 215
 
18.8%
Space Separator 194
 
17.0%
Dash Punctuation 6
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 64
8.8%
강 64
8.8%
울 64
8.8%
로 64
8.8%
북 64
8.8%
구 64
8.8%
시 64
8.8%
별 64
8.8%
특 64
8.8%
봉 30
 
4.1%
Other values (23) 123
16.9%
Decimal Number
ValueCountFrequency (%)
1 37
17.2%
3 34
15.8%
4 33
15.3%
2 31
14.4%
7 17
7.9%
5 16
7.4%
9 13
 
6.0%
8 13
 
6.0%
6 13
 
6.0%
0 8
 
3.7%
Space Separator
ValueCountFrequency (%)
194
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 729
63.7%
Common 415
36.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 64
8.8%
강 64
8.8%
울 64
8.8%
로 64
8.8%
북 64
8.8%
구 64
8.8%
시 64
8.8%
별 64
8.8%
특 64
8.8%
봉 30
 
4.1%
Other values (23) 123
16.9%
Common
ValueCountFrequency (%)
194
46.7%
1 37
 
8.9%
3 34
 
8.2%
4 33
 
8.0%
2 31
 
7.5%
7 17
 
4.1%
5 16
 
3.9%
9 13
 
3.1%
8 13
 
3.1%
6 13
 
3.1%
Other values (2) 14
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 729
63.7%
ASCII 415
36.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
194
46.7%
1 37
 
8.9%
3 34
 
8.2%
4 33
 
8.0%
2 31
 
7.5%
7 17
 
4.1%
5 16
 
3.9%
9 13
 
3.1%
8 13
 
3.1%
6 13
 
3.1%
Other values (2) 14
 
3.4%
Hangul
ValueCountFrequency (%)
서 64
8.8%
강 64
8.8%
울 64
8.8%
로 64
8.8%
북 64
8.8%
구 64
8.8%
시 64
8.8%
별 64
8.8%
특 64
8.8%
봉 30
 
4.1%
Other values (23) 123
16.9%

약국전화번호
Text

UNIQUE 

Distinct64
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size644.0 B
2023-12-11T14:35:39.360501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length11
Mean length11
Min length11

Characters and Unicode

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

Unique64 ?
Unique (%)100.0%

Sample

1st row02-908-4270
2nd row02-994-1282
3rd row02-902-8373
4th row02-989-7852
5th row02-988-1614
ValueCountFrequency (%)
02-908-4270 1
 
1.6%
02-994-1282 1
 
1.6%
02-985-0502 1
 
1.6%
02-985-3423 1
 
1.6%
02-985-0071 1
 
1.6%
02-981-2030 1
 
1.6%
02-989-1682 1
 
1.6%
02-988-4986 1
 
1.6%
02-995-8276 1
 
1.6%
02-985-3211 1
 
1.6%
Other values (54) 54
84.4%
2023-12-11T14:35:39.878514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 128
18.2%
2 116
16.5%
0 107
15.2%
9 93
13.2%
8 75
10.7%
4 37
 
5.3%
7 35
 
5.0%
5 33
 
4.7%
1 30
 
4.3%
3 29
 
4.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 576
81.8%
Dash Punctuation 128
 
18.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 116
20.1%
0 107
18.6%
9 93
16.1%
8 75
13.0%
4 37
 
6.4%
7 35
 
6.1%
5 33
 
5.7%
1 30
 
5.2%
3 29
 
5.0%
6 21
 
3.6%
Dash Punctuation
ValueCountFrequency (%)
- 128
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 704
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 128
18.2%
2 116
16.5%
0 107
15.2%
9 93
13.2%
8 75
10.7%
4 37
 
5.3%
7 35
 
5.0%
5 33
 
4.7%
1 30
 
4.3%
3 29
 
4.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 704
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 128
18.2%
2 116
16.5%
0 107
15.2%
9 93
13.2%
8 75
10.7%
4 37
 
5.3%
7 35
 
5.0%
5 33
 
4.7%
1 30
 
4.3%
3 29
 
4.1%

당번일자
Categorical

Distinct19
Distinct (%)29.7%
Missing0
Missing (%)0.0%
Memory size644.0 B
매주 일요일
22 
4졎주 일요일
9 
1째주 일요일
6 
2째주 일요일
5 
2 4째주 일요일
3 
Other values (14)
19 

Length

Max length13
Median length7
Mean length7.953125
Min length7

Unique

Unique10 ?
Unique (%)15.6%

Sample

1st row2 4째주 일요일
2nd row매주 일요일
3rd row4째주 일요일
4th row1 3째주 일요일
5th row1 3 5째주 일요일

Common Values

ValueCountFrequency (%)
매주 일요일 22
34.4%
4졎주 일요일 9
14.1%
1째주 일요일 6
 
9.4%
2째주 일요일 5
 
7.8%
2 4째주 일요일 3
 
4.7%
1 3 5째주 일요일 3
 
4.7%
3졎주 일요일 2
 
3.1%
1 3째주 일요일 2
 
3.1%
2 4 5째주 일요일 2
 
3.1%
1 2 3 5째주 일요일 1
 
1.6%
Other values (9) 9
14.1%

Length

2023-12-11T14:35:40.073681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
일요일 63
39.9%
매주 22
 
13.9%
2 10
 
6.3%
5째주 10
 
6.3%
4졎주 9
 
5.7%
1 8
 
5.1%
3 7
 
4.4%
1째주 6
 
3.8%
4 6
 
3.8%
2째주 5
 
3.2%
Other values (6) 12
 
7.6%

영업시간
Text

Distinct42
Distinct (%)65.6%
Missing0
Missing (%)0.0%
Memory size644.0 B
2023-12-11T14:35:40.366594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length11
Mean length11
Min length11

Characters and Unicode

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

Unique29 ?
Unique (%)45.3%

Sample

1st row10:00~18:30
2nd row09:00~17:00
3rd row15:00~21:00
4th row08:30~17:00
5th row09:30~20:30
ValueCountFrequency (%)
09:00~21:00 9
 
14.1%
09:00~19:00 3
 
4.7%
10:00~19:00 3
 
4.7%
09:00~20:00 2
 
3.1%
10:00~18:30 2
 
3.1%
10:00~18:00 2
 
3.1%
10:00~17:00 2
 
3.1%
10:00~16:00 2
 
3.1%
11:00~16:00 2
 
3.1%
09:00~16:00 2
 
3.1%
Other values (32) 35
54.7%
2023-12-11T14:35:40.818465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 291
41.3%
: 128
18.2%
1 101
 
14.3%
~ 64
 
9.1%
2 32
 
4.5%
9 30
 
4.3%
3 23
 
3.3%
8 11
 
1.6%
7 7
 
1.0%
4 7
 
1.0%
Other values (2) 10
 
1.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 512
72.7%
Other Punctuation 128
 
18.2%
Math Symbol 64
 
9.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 291
56.8%
1 101
 
19.7%
2 32
 
6.2%
9 30
 
5.9%
3 23
 
4.5%
8 11
 
2.1%
7 7
 
1.4%
4 7
 
1.4%
6 6
 
1.2%
5 4
 
0.8%
Other Punctuation
ValueCountFrequency (%)
: 128
100.0%
Math Symbol
ValueCountFrequency (%)
~ 64
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 704
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 291
41.3%
: 128
18.2%
1 101
 
14.3%
~ 64
 
9.1%
2 32
 
4.5%
9 30
 
4.3%
3 23
 
3.3%
8 11
 
1.6%
7 7
 
1.0%
4 7
 
1.0%
Other values (2) 10
 
1.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 704
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 291
41.3%
: 128
18.2%
1 101
 
14.3%
~ 64
 
9.1%
2 32
 
4.5%
9 30
 
4.3%
3 23
 
3.3%
8 11
 
1.6%
7 7
 
1.0%
4 7
 
1.0%
Other values (2) 10
 
1.4%

Interactions

2023-12-11T14:35:36.477963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T14:35:40.964804image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종약국명약국소재지약국전화번호당번일자영업시간
업종1.0001.0000.9371.0000.0000.000
약국명1.0001.0001.0001.0001.0001.000
약국소재지0.9371.0001.0001.0000.9910.998
약국전화번호1.0001.0001.0001.0001.0001.000
당번일자0.0001.0000.9911.0001.0000.000
영업시간0.0001.0000.9981.0000.0001.000
2023-12-11T14:35:41.113336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종당번일자
업종1.0000.000
당번일자0.0001.000

Missing values

2023-12-11T14:35:36.593280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T14:35:36.708416image/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

업종약국명약국소재지약국전화번호당번일자영업시간
01송도약국서울특별시 강북구 도봉로 34302-908-42702 4째주 일요일10:00~18:30
12백화점약국서울특별시 강북구 도봉로96길 1102-994-1282매주 일요일09:00~17:00
23새현대약국서울특별시 강북구 인수봉로55길 1302-902-83734째주 일요일15:00~21:00
34길약국서울특별시 강북구 도봉로67길 2102-989-78521 3째주 일요일08:30~17:00
45현대약국서울특별시 강북구 도봉로67길 1802-988-16141 3 5째주 일요일09:30~20:30
56한독약국서울특별시 강북구 수유로23길 5702-902-17361째주 일요일09:00~21:00
67수유동약국서울특별시 강북구 수유로 8302-903-1313매주 일요일11:00~20:00
78시대약국서울특별시 강북구 솔샘로 22702-988-25251 2 4 5째주일요일10:30~22:00
89화신약국서울특별시 강북구 삼양로 42402-907-53842째주 일요일08:30~19:00
910이원약국서울특별시 강북구 삼양로 24402-946-19584졎주 일요일08:00~20:00
업종약국명약국소재지약국전화번호당번일자영업시간
5455사랑온누리약국서울특별시 강북구 도봉로 40 1층02-983-24254졎주 일요일09:00~21:00
5556수유파랑새서울특별시 강북구 삼양로123길 6-802-993-6240매주 일요일09:00~18:00
5657숭인약국(동물약국)서울특별시 강북구 도봉로 5902-988-7196매주 일요일11:00~21:00
5758열린대학약국서울특별시 강북구 숭인로 63-102-986-1022매주 일요일10:00~12:00
5859건강비타민약국서울특별시 강북구 솔매로 5902-984-47772 5째주 일요일09:00~21:00
5960조은약국서울특별시 강북구 도봉로 31702-994-7808매주 일요일09:00~16:00
6061대지약국서울특별시 강북구 삼양로 24702-945-89461 3 5째주 일요일10:00~22:00
6162엄마약국서울특별시 강북구 도봉로14길 7-802-981-2588매주 일요일09:00~13:00
6263화원약국서울특별시 강북구 삼양로 46902-993-5103매주 일요일09:00~19:00
6364미아역온누리약국서울특별시 강북구 도봉로 21702-985-77034졎주 일요일11:00~18:00