Overview

Dataset statistics

Number of variables7
Number of observations27
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory61.9 B

Variable types

DateTime2
Text4
Numeric1

Dataset

Description서천군 소재 약국현황 정보를 제공하고 있습니다(개설자명, 약국명, 종별, 약국소재지, 연락처 등을 안내하고 있습니다.)
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=429&beforeMenuCd=DOM_000000201001001000&publicdatapk=3073122

Alerts

데이터기준일자 has constant value ""Constant
등록일자 has unique valuesUnique
개설자명 has unique valuesUnique
약국명칭 has unique valuesUnique
약국소재지 has unique valuesUnique
연락처 has unique valuesUnique

Reproduction

Analysis started2024-01-09 23:21:37.249922
Analysis finished2024-01-09 23:21:37.753927
Duration0.5 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

등록일자
Date

UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size348.0 B
Minimum1971-12-03 00:00:00
Maximum2018-11-29 00:00:00
2024-01-10T08:21:37.805008image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T08:21:37.919919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)

개설자명
Text

UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size348.0 B
2024-01-10T08:21:38.098784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters81
Distinct characters54
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

Unique27 ?
Unique (%)100.0%

Sample

1st row김선겸
2nd row고용석
3rd row김진우
4th row이가영
5th row허승무
ValueCountFrequency (%)
김선겸 1
 
3.7%
박공희 1
 
3.7%
조성재 1
 
3.7%
조덕호 1
 
3.7%
손재국 1
 
3.7%
정용석 1
 
3.7%
박승희 1
 
3.7%
손낙순 1
 
3.7%
이두용 1
 
3.7%
조구원 1
 
3.7%
Other values (17) 17
63.0%
2024-01-10T08:21:38.366566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
이 4
 
4.9%
박 4
 
4.9%
조 4
 
4.9%
김 3
 
3.7%
정 3
 
3.7%
용 3
 
3.7%
승 3
 
3.7%
재 2
 
2.5%
손 2
 
2.5%
구 2
 
2.5%
Other values (44) 51
63.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 81
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
이 4
 
4.9%
박 4
 
4.9%
조 4
 
4.9%
김 3
 
3.7%
정 3
 
3.7%
용 3
 
3.7%
승 3
 
3.7%
재 2
 
2.5%
손 2
 
2.5%
구 2
 
2.5%
Other values (44) 51
63.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 81
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
이 4
 
4.9%
박 4
 
4.9%
조 4
 
4.9%
김 3
 
3.7%
정 3
 
3.7%
용 3
 
3.7%
승 3
 
3.7%
재 2
 
2.5%
손 2
 
2.5%
구 2
 
2.5%
Other values (44) 51
63.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 81
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
이 4
 
4.9%
박 4
 
4.9%
조 4
 
4.9%
김 3
 
3.7%
정 3
 
3.7%
용 3
 
3.7%
승 3
 
3.7%
재 2
 
2.5%
손 2
 
2.5%
구 2
 
2.5%
Other values (44) 51
63.0%

약국명칭
Text

UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size348.0 B
2024-01-10T08:21:38.544092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length6
Mean length4.7037037
Min length3

Characters and Unicode

Total characters127
Distinct characters54
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

Unique27 ?
Unique (%)100.0%

Sample

1st row건지약국
2nd row김약국
3rd row늘푸른약국
4th row다나약국
5th row더조은약국
ValueCountFrequency (%)
건지약국 1
 
3.7%
유명약국 1
 
3.7%
화신약국 1
 
3.7%
행복한약국 1
 
3.7%
해맑은약국 1
 
3.7%
한사랑약국 1
 
3.7%
하나약국 1
 
3.7%
하구둑약국 1
 
3.7%
태산약국 1
 
3.7%
진성약국 1
 
3.7%
Other values (17) 17
63.0%
2024-01-10T08:21:38.856660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 27
21.3%
국 27
21.3%
장 4
 
3.1%
서 4
 
3.1%
로 3
 
2.4%
천 3
 
2.4%
랑 2
 
1.6%
한 2
 
1.6%
종 2
 
1.6%
시 2
 
1.6%
Other values (44) 51
40.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 127
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 27
21.3%
국 27
21.3%
장 4
 
3.1%
서 4
 
3.1%
로 3
 
2.4%
천 3
 
2.4%
랑 2
 
1.6%
한 2
 
1.6%
종 2
 
1.6%
시 2
 
1.6%
Other values (44) 51
40.2%

Most occurring scripts

ValueCountFrequency (%)
Hangul 127
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 27
21.3%
국 27
21.3%
장 4
 
3.1%
서 4
 
3.1%
로 3
 
2.4%
천 3
 
2.4%
랑 2
 
1.6%
한 2
 
1.6%
종 2
 
1.6%
시 2
 
1.6%
Other values (44) 51
40.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 127
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 27
21.3%
국 27
21.3%
장 4
 
3.1%
서 4
 
3.1%
로 3
 
2.4%
천 3
 
2.4%
랑 2
 
1.6%
한 2
 
1.6%
종 2
 
1.6%
시 2
 
1.6%
Other values (44) 51
40.2%

우편번호
Real number (ℝ)

Distinct15
Distinct (%)55.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean33642.037
Minimum33602
Maximum33674
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size375.0 B
2024-01-10T08:21:38.958436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum33602
5-th percentile33604.5
Q133635
median33642
Q333652
95-th percentile33672.7
Maximum33674
Range72
Interquartile range (IQR)17

Descriptive statistics

Standard deviation21.239443
Coefficient of variation (CV)0.00063133643
Kurtosis-0.39407178
Mean33642.037
Median Absolute Deviation (MAD)7
Skewness-0.23512261
Sum908335
Variance451.11396
MonotonicityNot monotonic
2024-01-10T08:21:39.052523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
33642 8
29.6%
33624 2
 
7.4%
33608 2
 
7.4%
33635 2
 
7.4%
33670 2
 
7.4%
33643 2
 
7.4%
33640 1
 
3.7%
33647 1
 
3.7%
33674 1
 
3.7%
33672 1
 
3.7%
Other values (5) 5
18.5%
ValueCountFrequency (%)
33602 1
 
3.7%
33603 1
 
3.7%
33608 2
 
7.4%
33624 2
 
7.4%
33635 2
 
7.4%
33640 1
 
3.7%
33642 8
29.6%
33643 2
 
7.4%
33647 1
 
3.7%
33657 1
 
3.7%
ValueCountFrequency (%)
33674 1
 
3.7%
33673 1
 
3.7%
33672 1
 
3.7%
33671 1
 
3.7%
33670 2
 
7.4%
33657 1
 
3.7%
33647 1
 
3.7%
33643 2
 
7.4%
33642 8
29.6%
33640 1
 
3.7%

약국소재지
Text

UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size348.0 B
2024-01-10T08:21:39.220544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length24
Mean length21.037037
Min length18

Characters and Unicode

Total characters568
Distinct characters41
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

Unique27 ?
Unique (%)100.0%

Sample

1st row충청남도 서천군 한산면 한산모시길 30
2nd row충청남도 서천군 비인면 비인로 207-2
3rd row충청남도 서천군 서천읍 충절로59번길 22
4th row충청남도 서천군 서천읍 충절로59번길 31-5
5th row충청남도 서천군 서천읍 사곡로43번길 1
ValueCountFrequency (%)
충청남도 27
19.9%
서천군 27
19.9%
서천읍 14
 
10.3%
장항읍 6
 
4.4%
장항로 4
 
2.9%
1 3
 
2.2%
서천로 3
 
2.2%
충절로59번길 3
 
2.2%
서면 2
 
1.5%
충절로 2
 
1.5%
Other values (39) 45
33.1%
2024-01-10T08:21:39.508118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
109
19.2%
서 50
 
8.8%
천 44
 
7.7%
충 35
 
6.2%
청 28
 
4.9%
남 28
 
4.9%
군 28
 
4.9%
도 27
 
4.8%
로 24
 
4.2%
1 22
 
3.9%
Other values (31) 173
30.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 372
65.5%
Space Separator 109
 
19.2%
Decimal Number 81
 
14.3%
Dash Punctuation 5
 
0.9%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 50
13.4%
천 44
11.8%
충 35
9.4%
청 28
 
7.5%
남 28
 
7.5%
군 28
 
7.5%
도 27
 
7.3%
로 24
 
6.5%
읍 20
 
5.4%
장 13
 
3.5%
Other values (18) 75
20.2%
Decimal Number
ValueCountFrequency (%)
1 22
27.2%
5 11
13.6%
9 9
11.1%
4 7
 
8.6%
7 7
 
8.6%
3 7
 
8.6%
2 6
 
7.4%
8 5
 
6.2%
0 4
 
4.9%
6 3
 
3.7%
Space Separator
ValueCountFrequency (%)
109
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 372
65.5%
Common 196
34.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 50
13.4%
천 44
11.8%
충 35
9.4%
청 28
 
7.5%
남 28
 
7.5%
군 28
 
7.5%
도 27
 
7.3%
로 24
 
6.5%
읍 20
 
5.4%
장 13
 
3.5%
Other values (18) 75
20.2%
Common
ValueCountFrequency (%)
109
55.6%
1 22
 
11.2%
5 11
 
5.6%
9 9
 
4.6%
4 7
 
3.6%
7 7
 
3.6%
3 7
 
3.6%
2 6
 
3.1%
- 5
 
2.6%
8 5
 
2.6%
Other values (3) 8
 
4.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 372
65.5%
ASCII 196
34.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
109
55.6%
1 22
 
11.2%
5 11
 
5.6%
9 9
 
4.6%
4 7
 
3.6%
7 7
 
3.6%
3 7
 
3.6%
2 6
 
3.1%
- 5
 
2.6%
8 5
 
2.6%
Other values (3) 8
 
4.1%
Hangul
ValueCountFrequency (%)
서 50
13.4%
천 44
11.8%
충 35
9.4%
청 28
 
7.5%
남 28
 
7.5%
군 28
 
7.5%
도 27
 
7.3%
로 24
 
6.5%
읍 20
 
5.4%
장 13
 
3.5%
Other values (18) 75
20.2%

연락처
Text

UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size348.0 B
2024-01-10T08:21:39.682077image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique27 ?
Unique (%)100.0%

Sample

1st row041-951-7779
2nd row041-952-3959
3rd row041-953-5212
4th row041-953-0189
5th row041-953-6227
ValueCountFrequency (%)
041-951-7779 1
 
3.7%
041-952-7045 1
 
3.7%
041-956-0405 1
 
3.7%
041-952-1502 1
 
3.7%
041-951-7576 1
 
3.7%
041-956-3047 1
 
3.7%
041-953-2034 1
 
3.7%
041-956-8920 1
 
3.7%
041-951-7515 1
 
3.7%
041-952-1510 1
 
3.7%
Other values (17) 17
63.0%
2024-01-10T08:21:39.956325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 54
16.7%
1 45
13.9%
0 44
13.6%
5 42
13.0%
9 36
11.1%
4 33
10.2%
2 18
 
5.6%
3 16
 
4.9%
7 14
 
4.3%
6 13
 
4.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 270
83.3%
Dash Punctuation 54
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 45
16.7%
0 44
16.3%
5 42
15.6%
9 36
13.3%
4 33
12.2%
2 18
 
6.7%
3 16
 
5.9%
7 14
 
5.2%
6 13
 
4.8%
8 9
 
3.3%
Dash Punctuation
ValueCountFrequency (%)
- 54
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 324
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 54
16.7%
1 45
13.9%
0 44
13.6%
5 42
13.0%
9 36
11.1%
4 33
10.2%
2 18
 
5.6%
3 16
 
4.9%
7 14
 
4.3%
6 13
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 324
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 54
16.7%
1 45
13.9%
0 44
13.6%
5 42
13.0%
9 36
11.1%
4 33
10.2%
2 18
 
5.6%
3 16
 
4.9%
7 14
 
4.3%
6 13
 
4.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
Minimum2019-05-21 00:00:00
Maximum2019-05-21 00:00:00
2024-01-10T08:21:40.052881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T08:21:40.127708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-01-10T08:21:37.525019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T08:21:40.184763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
등록일자개설자명약국명칭우편번호약국소재지연락처
등록일자1.0001.0001.0001.0001.0001.000
개설자명1.0001.0001.0001.0001.0001.000
약국명칭1.0001.0001.0001.0001.0001.000
우편번호1.0001.0001.0001.0001.0001.000
약국소재지1.0001.0001.0001.0001.0001.000
연락처1.0001.0001.0001.0001.0001.000

Missing values

2024-01-10T08:21:37.624030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T08:21:37.715685image/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

등록일자개설자명약국명칭우편번호약국소재지연락처데이터기준일자
02013-02-01김선겸건지약국33624충청남도 서천군 한산면 한산모시길 30041-951-77792019-05-21
12013-12-17고용석김약국33608충청남도 서천군 비인면 비인로 207-2041-952-39592019-05-21
22000-08-23김진우늘푸른약국33642충청남도 서천군 서천읍 충절로59번길 22041-953-52122019-05-21
32008-10-06이가영다나약국33642충청남도 서천군 서천읍 충절로59번길 31-5041-953-01892019-05-21
42018-11-29허승무더조은약국33635충청남도 서천군 서천읍 사곡로43번길 1041-953-62272019-05-21
52013-10-07김정호동양약국33670충청남도 서천군 장항읍 장항로 135041-957-02342019-05-21
62017-09-06조헤정사랑약국33635충청남도 서천군 서천읍 사곡로 17041-952-57152019-05-21
72015-11-03신승현새대전약국33624충청남도 서천군 한산면 한산모시길 31041-952-91182019-05-21
81971-12-03전하창서울약국33643충청남도 서천군 서천읍 서천로 96041-953-07502019-05-21
92018-03-02이민수서천세계로약국33643충청남도 서천군 서천읍 서천로 94041-952-80012019-05-21
등록일자개설자명약국명칭우편번호약국소재지연락처데이터기준일자
172007-01-02구충환장항종로약국33673충청남도 서천군 장항읍 장서로 30041-956-80502019-05-21
182001-11-06조구원진성약국33603충청남도 서천군 서면 공암남촌길 176041-952-15102019-05-21
191997-01-16이두용태산약국33642충청남도 서천군 서천읍 충절로41번길 1041-951-75152019-05-21
202001-03-14손낙순하구둑약국33657충청남도 서천군 마서면 장산로 851041-956-89202019-05-21
212007-05-18박승희하나약국33642충청남도 서천군 서천읍 충절로49번길 11-5, 1층041-953-20342019-05-21
222011-03-07정용석한사랑약국33671충청남도 서천군 장항읍 장서로29번길 1041-956-30472019-05-21
232012-10-15손재국해맑은약국33642충청남도 서천군 서천읍 군청로 7041-951-75762019-05-21
242014-10-01조덕호행복한약국33602충청남도 서천군 서면 서인로 758041-952-15022019-05-21
251974-05-02조성재화신약국33670충청남도 서천군 장항읍 장항로 131041-956-04052019-05-21
262006-09-05한애경희망찬약국33642충청남도 서천군 서천읍 충절로59번길 18041-953-89692019-05-21