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/