Overview

Dataset statistics

Number of variables5
Number of observations46
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.0 KiB
Average record size in memory43.9 B

Variable types

Numeric1
Text4

Dataset

Description충청남도 홍성군 관내 약국 현황에 대한 공공데이터 정보입니다. 군청홈페이지에서도 확인 가능합니다.(순번, 약국명, 개설자명, 주소, 전화번호)
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=47&beforeMenuCd=DOM_000000201001001000&publicdatapk=15113345

Alerts

순번 has unique valuesUnique
약국명 has unique valuesUnique
개설자명 has unique valuesUnique
주소 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2024-01-09 20:57:28.413859
Analysis finished2024-01-09 20:57:28.879466
Duration0.47 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct46
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23.5
Minimum1
Maximum46
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size546.0 B
2024-01-10T05:57:28.936809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.25
Q112.25
median23.5
Q334.75
95-th percentile43.75
Maximum46
Range45
Interquartile range (IQR)22.5

Descriptive statistics

Standard deviation13.422618
Coefficient of variation (CV)0.57117522
Kurtosis-1.2
Mean23.5
Median Absolute Deviation (MAD)11.5
Skewness0
Sum1081
Variance180.16667
MonotonicityStrictly increasing
2024-01-10T05:57:29.065736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=46)
ValueCountFrequency (%)
1 1
 
2.2%
36 1
 
2.2%
27 1
 
2.2%
28 1
 
2.2%
29 1
 
2.2%
30 1
 
2.2%
31 1
 
2.2%
32 1
 
2.2%
33 1
 
2.2%
34 1
 
2.2%
Other values (36) 36
78.3%
ValueCountFrequency (%)
1 1
2.2%
2 1
2.2%
3 1
2.2%
4 1
2.2%
5 1
2.2%
6 1
2.2%
7 1
2.2%
8 1
2.2%
9 1
2.2%
10 1
2.2%
ValueCountFrequency (%)
46 1
2.2%
45 1
2.2%
44 1
2.2%
43 1
2.2%
42 1
2.2%
41 1
2.2%
40 1
2.2%
39 1
2.2%
38 1
2.2%
37 1
2.2%

약국명
Text

UNIQUE 

Distinct46
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size500.0 B
2024-01-10T05:57:29.324260image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length7
Mean length4.673913
Min length3

Characters and Unicode

Total characters215
Distinct characters86
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

Unique46 ?
Unique (%)100.0%

Sample

1st row신신약국
2nd row우리들약국
3rd row성심약국
4th row시민약국
5th row시장약국
ValueCountFrequency (%)
신신약국 1
 
2.2%
행복나눔약국 1
 
2.2%
홍주한약국 1
 
2.2%
메디팜정약국 1
 
2.2%
조광약국 1
 
2.2%
조은약국 1
 
2.2%
홍성종합약국 1
 
2.2%
참약국 1
 
2.2%
하나프라자약국 1
 
2.2%
한아름약국 1
 
2.2%
Other values (36) 36
78.3%
2024-01-10T05:57:29.639942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
국 46
21.4%
약 46
21.4%
한 6
 
2.8%
리 6
 
2.8%
홍 6
 
2.8%
신 5
 
2.3%
일 3
 
1.4%
우 3
 
1.4%
보 3
 
1.4%
성 3
 
1.4%
Other values (76) 88
40.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 211
98.1%
Decimal Number 3
 
1.4%
Space Separator 1
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
국 46
21.8%
약 46
21.8%
한 6
 
2.8%
리 6
 
2.8%
홍 6
 
2.8%
신 5
 
2.4%
일 3
 
1.4%
우 3
 
1.4%
보 3
 
1.4%
성 3
 
1.4%
Other values (72) 84
39.8%
Decimal Number
ValueCountFrequency (%)
6 1
33.3%
3 1
33.3%
5 1
33.3%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 211
98.1%
Common 4
 
1.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
국 46
21.8%
약 46
21.8%
한 6
 
2.8%
리 6
 
2.8%
홍 6
 
2.8%
신 5
 
2.4%
일 3
 
1.4%
우 3
 
1.4%
보 3
 
1.4%
성 3
 
1.4%
Other values (72) 84
39.8%
Common
ValueCountFrequency (%)
6 1
25.0%
1
25.0%
3 1
25.0%
5 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 211
98.1%
ASCII 4
 
1.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
국 46
21.8%
약 46
21.8%
한 6
 
2.8%
리 6
 
2.8%
홍 6
 
2.8%
신 5
 
2.4%
일 3
 
1.4%
우 3
 
1.4%
보 3
 
1.4%
성 3
 
1.4%
Other values (72) 84
39.8%
ASCII
ValueCountFrequency (%)
6 1
25.0%
1
25.0%
3 1
25.0%
5 1
25.0%

개설자명
Text

UNIQUE 

Distinct46
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size500.0 B
2024-01-10T05:57:29.852160image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length2.9782609
Min length2

Characters and Unicode

Total characters137
Distinct characters76
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique46 ?
Unique (%)100.0%

Sample

1st row김희수
2nd row윤현수
3rd row김준호
4th row이동혁
5th row김창식
ValueCountFrequency (%)
김희수 1
 
2.2%
서정의 1
 
2.2%
권성일 1
 
2.2%
정미란 1
 
2.2%
조덕희 1
 
2.2%
이희룡 1
 
2.2%
최장현 1
 
2.2%
백인숙 1
 
2.2%
조한군 1
 
2.2%
이서판 1
 
2.2%
Other values (36) 36
78.3%
2024-01-10T05:57:30.214100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 11
 
8.0%
이 6
 
4.4%
희 5
 
3.6%
정 5
 
3.6%
성 5
 
3.6%
조 4
 
2.9%
준 4
 
2.9%
수 3
 
2.2%
호 3
 
2.2%
동 3
 
2.2%
Other values (66) 88
64.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 137
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 11
 
8.0%
이 6
 
4.4%
희 5
 
3.6%
정 5
 
3.6%
성 5
 
3.6%
조 4
 
2.9%
준 4
 
2.9%
수 3
 
2.2%
호 3
 
2.2%
동 3
 
2.2%
Other values (66) 88
64.2%

Most occurring scripts

ValueCountFrequency (%)
Hangul 137
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 11
 
8.0%
이 6
 
4.4%
희 5
 
3.6%
정 5
 
3.6%
성 5
 
3.6%
조 4
 
2.9%
준 4
 
2.9%
수 3
 
2.2%
호 3
 
2.2%
동 3
 
2.2%
Other values (66) 88
64.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 137
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 11
 
8.0%
이 6
 
4.4%
희 5
 
3.6%
정 5
 
3.6%
성 5
 
3.6%
조 4
 
2.9%
준 4
 
2.9%
수 3
 
2.2%
호 3
 
2.2%
동 3
 
2.2%
Other values (66) 88
64.2%

주소
Text

UNIQUE 

Distinct46
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size500.0 B
2024-01-10T05:57:30.446988image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length38
Median length26
Mean length21.652174
Min length18

Characters and Unicode

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

Unique

Unique46 ?
Unique (%)100.0%

Sample

1st row충청남도 홍성군 갈산면 상촌로 12-1
2nd row충청남도 홍성군 갈산면 상촌로 8
3rd row충청남도 홍성군 광천읍 홍남로 662-2
4th row충청남도 홍성군 광천읍 홍남로 684
5th row충청남도 홍성군 광천읍 광천로329번길 23
ValueCountFrequency (%)
충청남도 46
19.2%
홍성군 46
19.2%
홍성읍 31
12.9%
조양로 14
 
5.8%
광천읍 7
 
2.9%
홍북읍 6
 
2.5%
내포로 5
 
2.1%
홍성천길 4
 
1.7%
홍남로 4
 
1.7%
8 3
 
1.2%
Other values (68) 74
30.8%
2024-01-10T05:57:30.799763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
196
19.7%
홍 93
 
9.3%
성 81
 
8.1%
청 50
 
5.0%
남 50
 
5.0%
충 49
 
4.9%
도 46
 
4.6%
군 46
 
4.6%
읍 44
 
4.4%
로 41
 
4.1%
Other values (54) 300
30.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 638
64.1%
Space Separator 196
 
19.7%
Decimal Number 152
 
15.3%
Dash Punctuation 8
 
0.8%
Other Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
홍 93
14.6%
성 81
12.7%
청 50
7.8%
남 50
7.8%
충 49
 
7.7%
도 46
 
7.2%
군 46
 
7.2%
읍 44
 
6.9%
로 41
 
6.4%
양 15
 
2.4%
Other values (41) 123
19.3%
Decimal Number
ValueCountFrequency (%)
1 38
25.0%
2 30
19.7%
6 18
11.8%
8 12
 
7.9%
9 11
 
7.2%
3 11
 
7.2%
4 11
 
7.2%
0 10
 
6.6%
7 6
 
3.9%
5 5
 
3.3%
Space Separator
ValueCountFrequency (%)
196
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%
Other Punctuation
ValueCountFrequency (%)
, 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 638
64.1%
Common 358
35.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
홍 93
14.6%
성 81
12.7%
청 50
7.8%
남 50
7.8%
충 49
 
7.7%
도 46
 
7.2%
군 46
 
7.2%
읍 44
 
6.9%
로 41
 
6.4%
양 15
 
2.4%
Other values (41) 123
19.3%
Common
ValueCountFrequency (%)
196
54.7%
1 38
 
10.6%
2 30
 
8.4%
6 18
 
5.0%
8 12
 
3.4%
9 11
 
3.1%
3 11
 
3.1%
4 11
 
3.1%
0 10
 
2.8%
- 8
 
2.2%
Other values (3) 13
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 638
64.1%
ASCII 358
35.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
196
54.7%
1 38
 
10.6%
2 30
 
8.4%
6 18
 
5.0%
8 12
 
3.4%
9 11
 
3.1%
3 11
 
3.1%
4 11
 
3.1%
0 10
 
2.8%
- 8
 
2.2%
Other values (3) 13
 
3.6%
Hangul
ValueCountFrequency (%)
홍 93
14.6%
성 81
12.7%
청 50
7.8%
남 50
7.8%
충 49
 
7.7%
도 46
 
7.2%
군 46
 
7.2%
읍 44
 
6.9%
로 41
 
6.4%
양 15
 
2.4%
Other values (41) 123
19.3%

전화번호
Text

UNIQUE 

Distinct46
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size500.0 B
2024-01-10T05:57:31.016015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique46 ?
Unique (%)100.0%

Sample

1st row041-633-2143
2nd row041-632-1949
3rd row041-642-3510
4th row041-641-2765
5th row041-642-5616
ValueCountFrequency (%)
041-633-2143 1
 
2.2%
041-634-2728 1
 
2.2%
041-632-2301 1
 
2.2%
041-634-6001 1
 
2.2%
041-634-1865 1
 
2.2%
041-634-1335 1
 
2.2%
041-631-3838 1
 
2.2%
041-631-7114 1
 
2.2%
041-632-1637 1
 
2.2%
041-631-8400 1
 
2.2%
Other values (36) 36
78.3%
2024-01-10T05:57:31.339772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 92
16.7%
1 91
16.5%
3 71
12.9%
0 69
12.5%
4 69
12.5%
6 60
10.9%
2 33
 
6.0%
5 19
 
3.4%
8 18
 
3.3%
7 17
 
3.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 460
83.3%
Dash Punctuation 92
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 91
19.8%
3 71
15.4%
0 69
15.0%
4 69
15.0%
6 60
13.0%
2 33
 
7.2%
5 19
 
4.1%
8 18
 
3.9%
7 17
 
3.7%
9 13
 
2.8%
Dash Punctuation
ValueCountFrequency (%)
- 92
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 552
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 92
16.7%
1 91
16.5%
3 71
12.9%
0 69
12.5%
4 69
12.5%
6 60
10.9%
2 33
 
6.0%
5 19
 
3.4%
8 18
 
3.3%
7 17
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 552
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 92
16.7%
1 91
16.5%
3 71
12.9%
0 69
12.5%
4 69
12.5%
6 60
10.9%
2 33
 
6.0%
5 19
 
3.4%
8 18
 
3.3%
7 17
 
3.1%

Interactions

2024-01-10T05:57:28.672789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T05:57:31.435053image/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.0001.000
전화번호1.0001.0001.0001.0001.000

Missing values

2024-01-10T05:57:28.766382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T05:57:28.847921image/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신신약국김희수충청남도 홍성군 갈산면 상촌로 12-1041-633-2143
12우리들약국윤현수충청남도 홍성군 갈산면 상촌로 8041-632-1949
23성심약국김준호충청남도 홍성군 광천읍 홍남로 662-2041-642-3510
34시민약국이동혁충청남도 홍성군 광천읍 홍남로 684041-641-2765
45시장약국김창식충청남도 홍성군 광천읍 광천로329번길 23041-642-5616
56신피보약국오세준충청남도 홍성군 광천읍 광천로 297041-641-8882
67우리약국이태규충청남도 홍성군 광천읍 홍남로 666041-641-3303
78한솔약국한창희충청남도 홍성군 광천읍 광천로 320-1041-641-4117
89허약국허규충청남도 홍성군 광천읍 홍남로 664041-642-2001
910건강약국온재숙충청남도 홍성군 홍성읍 내포로 18041-631-8901
순번약국명개설자명주소전화번호
3637홍주약국이동일충청남도 홍성군 홍성읍 내포로 2041-632-2300
3738알리오약국성시훈충청남도 홍성군 홍성읍 조양로 247번길 9, 롯데마트 1층 약국코너010-641-7138
3839내포우리약국김희연충청남도 홍성군 홍북읍 청사로48번길 4041-635-1117
3940사랑약국하태섭충청남도 홍성군 홍북읍 청사로 36041-631-8274
4041365스마일약국이병수충청남도 홍성군 홍북읍 홍학로 95 아이프라자2041-634-3657
4142내포중앙약국방준석충청남도 홍성군 홍북읍 청사로 150번길 10041-631-0802
4243홍예약국신민환충청남도 홍성군 홍북읍 청사로 146 센텀시티 2층041-631-1956
4344착한약국차정환충청남도 홍성군 홍북읍 의향로 267, 115호041-631-0999
4445홍주한약국권성일충청남도 홍성군 홍성읍 의사로 49041-632-2301
4546경희윤한약국지승혁충청남도 홍성군 홍성읍 충서로1322번길 8041-632-6169