Overview

Dataset statistics

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

Variable types

Numeric1
Text4

Dataset

Description충청남도 홍성군 관내 약국 현황에 대한 공공데이터 정보입니다. 군청홈페이지에서도 확인 가능합니다.(순번, 약국명, 개설자명, 주소, 전화번호)
Author충청남도 홍성군
URLhttps://www.data.go.kr/data/15113345/fileData.do

Alerts

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

Reproduction

Analysis started2024-04-21 02:19:21.700827
Analysis finished2024-04-21 02:19:24.197061
Duration2.5 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23
Minimum1
Maximum45
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size537.0 B
2024-04-21T11:19:24.280867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.2
Q112
median23
Q334
95-th percentile42.8
Maximum45
Range44
Interquartile range (IQR)22

Descriptive statistics

Standard deviation13.133926
Coefficient of variation (CV)0.57104024
Kurtosis-1.2
Mean23
Median Absolute Deviation (MAD)11
Skewness0
Sum1035
Variance172.5
MonotonicityStrictly increasing
2024-04-21T11:19:24.432154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=45)
ValueCountFrequency (%)
1 1
 
2.2%
35 1
 
2.2%
26 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%
Other values (35) 35
77.8%
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 (%)
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%
36 1
2.2%

약국명
Text

UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size492.0 B
2024-04-21T11:19:24.754475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length7
Mean length4.6888889
Min length3

Characters and Unicode

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

Unique45 ?
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 (35) 35
77.8%
2024-04-21T11:19:25.173744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
국 45
21.3%
약 45
21.3%
리 6
 
2.8%
홍 6
 
2.8%
신 5
 
2.4%
한 5
 
2.4%
우 3
 
1.4%
성 3
 
1.4%
보 3
 
1.4%
중 2
 
0.9%
Other values (76) 88
41.7%

Most occurring categories

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

Most frequent character per category

Other Letter
ValueCountFrequency (%)
국 45
21.7%
약 45
21.7%
리 6
 
2.9%
홍 6
 
2.9%
신 5
 
2.4%
한 5
 
2.4%
우 3
 
1.4%
성 3
 
1.4%
보 3
 
1.4%
중 2
 
1.0%
Other values (72) 84
40.6%
Decimal Number
ValueCountFrequency (%)
3 1
33.3%
6 1
33.3%
5 1
33.3%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

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

Most frequent character per script

Hangul
ValueCountFrequency (%)
국 45
21.7%
약 45
21.7%
리 6
 
2.9%
홍 6
 
2.9%
신 5
 
2.4%
한 5
 
2.4%
우 3
 
1.4%
성 3
 
1.4%
보 3
 
1.4%
중 2
 
1.0%
Other values (72) 84
40.6%
Common
ValueCountFrequency (%)
1
25.0%
3 1
25.0%
6 1
25.0%
5 1
25.0%

Most occurring blocks

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

Most frequent character per block

Hangul
ValueCountFrequency (%)
국 45
21.7%
약 45
21.7%
리 6
 
2.9%
홍 6
 
2.9%
신 5
 
2.4%
한 5
 
2.4%
우 3
 
1.4%
성 3
 
1.4%
보 3
 
1.4%
중 2
 
1.0%
Other values (72) 84
40.6%
ASCII
ValueCountFrequency (%)
1
25.0%
3 1
25.0%
6 1
25.0%
5 1
25.0%

개설자명
Text

UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size492.0 B
2024-04-21T11:19:25.469589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length2.9777778
Min length2

Characters and Unicode

Total characters134
Distinct characters74
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

Unique45 ?
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 (35) 35
77.8%
2024-04-21T11:19:25.833336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 11
 
8.2%
이 6
 
4.5%
정 5
 
3.7%
희 5
 
3.7%
성 5
 
3.7%
준 4
 
3.0%
조 4
 
3.0%
신 3
 
2.2%
수 3
 
2.2%
호 3
 
2.2%
Other values (64) 85
63.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 134
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 11
 
8.2%
이 6
 
4.5%
정 5
 
3.7%
희 5
 
3.7%
성 5
 
3.7%
준 4
 
3.0%
조 4
 
3.0%
신 3
 
2.2%
수 3
 
2.2%
호 3
 
2.2%
Other values (64) 85
63.4%

Most occurring scripts

ValueCountFrequency (%)
Hangul 134
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 11
 
8.2%
이 6
 
4.5%
정 5
 
3.7%
희 5
 
3.7%
성 5
 
3.7%
준 4
 
3.0%
조 4
 
3.0%
신 3
 
2.2%
수 3
 
2.2%
호 3
 
2.2%
Other values (64) 85
63.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 134
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 11
 
8.2%
이 6
 
4.5%
정 5
 
3.7%
희 5
 
3.7%
성 5
 
3.7%
준 4
 
3.0%
조 4
 
3.0%
신 3
 
2.2%
수 3
 
2.2%
호 3
 
2.2%
Other values (64) 85
63.4%

주소
Text

UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size492.0 B
2024-04-21T11:19:26.075195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length38
Median length26
Mean length21.666667
Min length18

Characters and Unicode

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

Unique45 ?
Unique (%)100.0%

Sample

1st row충청남도 홍성군 갈산면 상촌로 12-1
2nd row충청남도 홍성군 갈산면 상촌로 8
3rd row충청남도 홍성군 광천읍 홍남로 662-2
4th row충청남도 홍성군 광천읍 홍남로 684
5th row충청남도 홍성군 광천읍 광천로329번길 23
ValueCountFrequency (%)
충청남도 45
19.1%
홍성군 45
19.1%
홍성읍 30
12.8%
조양로 14
 
6.0%
광천읍 7
 
3.0%
홍북읍 6
 
2.6%
내포로 5
 
2.1%
홍성천길 4
 
1.7%
홍남로 4
 
1.7%
청사로 3
 
1.3%
Other values (66) 72
30.6%
2024-04-21T11:19:26.507614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
192
19.7%
홍 91
 
9.3%
성 79
 
8.1%
남 49
 
5.0%
청 49
 
5.0%
충 48
 
4.9%
도 45
 
4.6%
군 45
 
4.6%
읍 43
 
4.4%
로 41
 
4.2%
Other values (54) 293
30.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 625
64.1%
Space Separator 192
 
19.7%
Decimal Number 149
 
15.3%
Dash Punctuation 7
 
0.7%
Other Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
홍 91
14.6%
성 79
12.6%
남 49
7.8%
청 49
7.8%
충 48
 
7.7%
도 45
 
7.2%
군 45
 
7.2%
읍 43
 
6.9%
로 41
 
6.6%
조 15
 
2.4%
Other values (41) 120
19.2%
Decimal Number
ValueCountFrequency (%)
1 37
24.8%
2 30
20.1%
6 18
12.1%
8 12
 
8.1%
4 11
 
7.4%
9 11
 
7.4%
0 10
 
6.7%
3 10
 
6.7%
7 5
 
3.4%
5 5
 
3.4%
Space Separator
ValueCountFrequency (%)
192
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%
Other Punctuation
ValueCountFrequency (%)
, 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 625
64.1%
Common 350
35.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
홍 91
14.6%
성 79
12.6%
남 49
7.8%
청 49
7.8%
충 48
 
7.7%
도 45
 
7.2%
군 45
 
7.2%
읍 43
 
6.9%
로 41
 
6.6%
조 15
 
2.4%
Other values (41) 120
19.2%
Common
ValueCountFrequency (%)
192
54.9%
1 37
 
10.6%
2 30
 
8.6%
6 18
 
5.1%
8 12
 
3.4%
4 11
 
3.1%
9 11
 
3.1%
0 10
 
2.9%
3 10
 
2.9%
- 7
 
2.0%
Other values (3) 12
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 625
64.1%
ASCII 350
35.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
192
54.9%
1 37
 
10.6%
2 30
 
8.6%
6 18
 
5.1%
8 12
 
3.4%
4 11
 
3.1%
9 11
 
3.1%
0 10
 
2.9%
3 10
 
2.9%
- 7
 
2.0%
Other values (3) 12
 
3.4%
Hangul
ValueCountFrequency (%)
홍 91
14.6%
성 79
12.6%
남 49
7.8%
청 49
7.8%
충 48
 
7.7%
도 45
 
7.2%
군 45
 
7.2%
읍 43
 
6.9%
로 41
 
6.6%
조 15
 
2.4%
Other values (41) 120
19.2%

전화번호
Text

UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size492.0 B
2024-04-21T11:19:26.723311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique45 ?
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-631-3900 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%
041-634-2728 1
 
2.2%
Other values (35) 35
77.8%
2024-04-21T11:19:27.073193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 90
16.7%
- 90
16.7%
3 69
12.8%
0 68
12.6%
4 68
12.6%
6 59
10.9%
2 30
 
5.6%
5 18
 
3.3%
8 18
 
3.3%
7 17
 
3.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 450
83.3%
Dash Punctuation 90
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 90
20.0%
3 69
15.3%
0 68
15.1%
4 68
15.1%
6 59
13.1%
2 30
 
6.7%
5 18
 
4.0%
8 18
 
4.0%
7 17
 
3.8%
9 13
 
2.9%
Dash Punctuation
ValueCountFrequency (%)
- 90
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 540
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
1 90
16.7%
- 90
16.7%
3 69
12.8%
0 68
12.6%
4 68
12.6%
6 59
10.9%
2 30
 
5.6%
5 18
 
3.3%
8 18
 
3.3%
7 17
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 540
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 90
16.7%
- 90
16.7%
3 69
12.8%
0 68
12.6%
4 68
12.6%
6 59
10.9%
2 30
 
5.6%
5 18
 
3.3%
8 18
 
3.3%
7 17
 
3.1%

Interactions

2024-04-21T11:19:23.785901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-21T11:19:27.173168image/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-04-21T11:19:24.004422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T11:19:24.150679image/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
순번약국명개설자명주소전화번호
3536홍주약국이동일충청남도 홍성군 홍성읍 내포로 2041-632-2300
3637알리오약국성시훈충청남도 홍성군 홍성읍 조양로 247번길 9, 롯데마트 1층 약국코너010-641-7138
3738내포우리약국김희연충청남도 홍성군 홍북읍 청사로48번길 4041-635-1117
3839사랑약국하태섭충청남도 홍성군 홍북읍 청사로 36041-631-8274
3940365스마일약국이병수충청남도 홍성군 홍북읍 홍학로 95 아이프라자2041-634-3657
4041내포중앙약국방준석충청남도 홍성군 홍북읍 청사로 150번길 10041-631-0802
4142홍예약국신민환충청남도 홍성군 홍북읍 청사로 146 센텀시티 2층041-631-1956
4243착한약국차정환충청남도 홍성군 홍북읍 의향로 267, 115호041-631-0999
4344홍주한약국권성일충청남도 홍성군 홍성읍 의사로 49041-632-2301
4445경희윤한약국지승혁충청남도 홍성군 홍성읍 충서로1322번길 8041-632-6169