Overview

Dataset statistics

Number of variables7
Number of observations28
Missing cells1
Missing cells (%)0.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.7 KiB
Average record size in memory60.7 B

Variable types

DateTime1
Text5
Categorical1

Dataset

Description서천군 소재 약국현황 정보를 제공하고 있습니다(개설자명, 약국명, 종별, 약국소재지, 연락처 등을 안내하고 있습니다.)
URLhttps://www.data.go.kr/data/3073122/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
연락처 has 1 (3.6%) missing valuesMissing
개설자명 has unique valuesUnique
약국명칭 has unique valuesUnique
약국소재지 has unique valuesUnique

Reproduction

Analysis started2023-12-12 05:01:44.452441
Analysis finished2023-12-12 05:01:45.147305
Duration0.69 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

등록일자
Date

Distinct16
Distinct (%)57.1%
Missing0
Missing (%)0.0%
Memory size356.0 B
Minimum2008-12-06 00:00:00
Maximum2022-07-28 00:00:00
2023-12-12T14:01:45.222690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:01:45.380004image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)

개설자명
Text

UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size356.0 B
2023-12-12T14:01:45.613042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters84
Distinct characters50
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

Unique28 ?
Unique (%)100.0%

Sample

1st row한정훈
2nd row김용진
3rd row허승무
4th row박주형
5th row이민수
ValueCountFrequency (%)
한정훈 1
 
3.6%
김용진 1
 
3.6%
조성재 1
 
3.6%
이두용 1
 
3.6%
이종현 1
 
3.6%
김진우 1
 
3.6%
손낙순 1
 
3.6%
조구원 1
 
3.6%
박종형 1
 
3.6%
구충환 1
 
3.6%
Other values (18) 18
64.3%
2023-12-12T14:01:46.044506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
박 5
 
6.0%
이 4
 
4.8%
정 4
 
4.8%
김 4
 
4.8%
용 4
 
4.8%
승 3
 
3.6%
조 3
 
3.6%
영 3
 
3.6%
손 2
 
2.4%
재 2
 
2.4%
Other values (40) 50
59.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 84
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
박 5
 
6.0%
이 4
 
4.8%
정 4
 
4.8%
김 4
 
4.8%
용 4
 
4.8%
승 3
 
3.6%
조 3
 
3.6%
영 3
 
3.6%
손 2
 
2.4%
재 2
 
2.4%
Other values (40) 50
59.5%

Most occurring scripts

ValueCountFrequency (%)
Hangul 84
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
박 5
 
6.0%
이 4
 
4.8%
정 4
 
4.8%
김 4
 
4.8%
용 4
 
4.8%
승 3
 
3.6%
조 3
 
3.6%
영 3
 
3.6%
손 2
 
2.4%
재 2
 
2.4%
Other values (40) 50
59.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 84
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
박 5
 
6.0%
이 4
 
4.8%
정 4
 
4.8%
김 4
 
4.8%
용 4
 
4.8%
승 3
 
3.6%
조 3
 
3.6%
영 3
 
3.6%
손 2
 
2.4%
재 2
 
2.4%
Other values (40) 50
59.5%

약국명칭
Text

UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size356.0 B
2023-12-12T14:01:46.342372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length6
Mean length4.6785714
Min length3

Characters and Unicode

Total characters131
Distinct characters55
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

Unique28 ?
Unique (%)100.0%

Sample

1st row정약국
2nd row서천드림약국
3rd row더조은약국
4th row시장약국
5th row서천세계로약국
ValueCountFrequency (%)
정약국 1
 
3.6%
서천드림약국 1
 
3.6%
화신약국 1
 
3.6%
태산약국 1
 
3.6%
시장종로약국 1
 
3.6%
늘푸른약국 1
 
3.6%
하구둑약국 1
 
3.6%
진성약국 1
 
3.6%
희망찬약국 1
 
3.6%
장항종로약국 1
 
3.6%
Other values (18) 18
64.3%
2023-12-12T14:01:46.817488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
국 28
21.4%
약 28
21.4%
서 5
 
3.8%
장 4
 
3.1%
천 4
 
3.1%
로 3
 
2.3%
세 2
 
1.5%
종 2
 
1.5%
랑 2
 
1.5%
사 2
 
1.5%
Other values (45) 51
38.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 131
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
국 28
21.4%
약 28
21.4%
서 5
 
3.8%
장 4
 
3.1%
천 4
 
3.1%
로 3
 
2.3%
세 2
 
1.5%
종 2
 
1.5%
랑 2
 
1.5%
사 2
 
1.5%
Other values (45) 51
38.9%

Most occurring scripts

ValueCountFrequency (%)
Hangul 131
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
국 28
21.4%
약 28
21.4%
서 5
 
3.8%
장 4
 
3.1%
천 4
 
3.1%
로 3
 
2.3%
세 2
 
1.5%
종 2
 
1.5%
랑 2
 
1.5%
사 2
 
1.5%
Other values (45) 51
38.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 131
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
국 28
21.4%
약 28
21.4%
서 5
 
3.8%
장 4
 
3.1%
천 4
 
3.1%
로 3
 
2.3%
세 2
 
1.5%
종 2
 
1.5%
랑 2
 
1.5%
사 2
 
1.5%
Other values (45) 51
38.9%

우편번호
Text

Distinct15
Distinct (%)53.6%
Missing0
Missing (%)0.0%
Memory size356.0 B
2023-12-12T14:01:47.020719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length6
Mean length5.8928571
Min length5

Characters and Unicode

Total characters165
Distinct characters10
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

Unique9 ?
Unique (%)32.1%

Sample

1st row'33675
2nd row'33642
3rd row'33635
4th row'33647
5th row'33643
ValueCountFrequency (%)
33642 9
32.1%
33635 2
 
7.1%
33643 2
 
7.1%
33608 2
 
7.1%
33624 2
 
7.1%
33670 2
 
7.1%
33675 1
 
3.6%
33647 1
 
3.6%
33672 1
 
3.6%
33671 1
 
3.6%
Other values (5) 5
17.9%
2023-12-12T14:01:47.412541image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 62
37.6%
6 28
17.0%
' 25
15.2%
4 16
 
9.7%
2 12
 
7.3%
7 9
 
5.5%
0 6
 
3.6%
5 4
 
2.4%
8 2
 
1.2%
1 1
 
0.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 140
84.8%
Other Punctuation 25
 
15.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 62
44.3%
6 28
20.0%
4 16
 
11.4%
2 12
 
8.6%
7 9
 
6.4%
0 6
 
4.3%
5 4
 
2.9%
8 2
 
1.4%
1 1
 
0.7%
Other Punctuation
ValueCountFrequency (%)
' 25
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 165
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 62
37.6%
6 28
17.0%
' 25
15.2%
4 16
 
9.7%
2 12
 
7.3%
7 9
 
5.5%
0 6
 
3.6%
5 4
 
2.4%
8 2
 
1.2%
1 1
 
0.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 165
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 62
37.6%
6 28
17.0%
' 25
15.2%
4 16
 
9.7%
2 12
 
7.3%
7 9
 
5.5%
0 6
 
3.6%
5 4
 
2.4%
8 2
 
1.2%
1 1
 
0.6%

약국소재지
Text

UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size356.0 B
2023-12-12T14:01:47.726866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length38
Median length28
Mean length22.035714
Min length18

Characters and Unicode

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

Unique

Unique28 ?
Unique (%)100.0%

Sample

1st row충청남도 서천군 장항읍 성주로 6
2nd row충청남도 서천군 서천읍 충절로41번길 11
3rd row충청남도 서천군 서천읍 사곡로43번길 1
4th row충청남도 서천군 서천읍 충절로 50
5th row충청남도 서천군 서천읍 서천로 94
ValueCountFrequency (%)
충청남도 28
19.3%
서천군 28
19.3%
서천읍 15
 
10.3%
장항읍 7
 
4.8%
장항로 4
 
2.8%
1 3
 
2.1%
서천로 3
 
2.1%
충절로59번길 3
 
2.1%
충절로41번길 3
 
2.1%
비인로 2
 
1.4%
Other values (44) 49
33.8%
2023-12-12T14:01:48.262440image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
117
19.0%
서 50
 
8.1%
천 46
 
7.5%
충 37
 
6.0%
남 29
 
4.7%
군 29
 
4.7%
청 29
 
4.7%
도 28
 
4.5%
1 27
 
4.4%
로 25
 
4.1%
Other values (48) 200
32.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 403
65.3%
Space Separator 117
 
19.0%
Decimal Number 87
 
14.1%
Dash Punctuation 5
 
0.8%
Open Punctuation 2
 
0.3%
Close Punctuation 2
 
0.3%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 50
12.4%
천 46
11.4%
충 37
 
9.2%
남 29
 
7.2%
군 29
 
7.2%
청 29
 
7.2%
도 28
 
6.9%
로 25
 
6.2%
읍 22
 
5.5%
장 14
 
3.5%
Other values (33) 94
23.3%
Decimal Number
ValueCountFrequency (%)
1 27
31.0%
9 9
 
10.3%
5 9
 
10.3%
4 8
 
9.2%
3 8
 
9.2%
7 6
 
6.9%
2 6
 
6.9%
0 6
 
6.9%
8 4
 
4.6%
6 4
 
4.6%
Space Separator
ValueCountFrequency (%)
117
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 403
65.3%
Common 214
34.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 50
12.4%
천 46
11.4%
충 37
 
9.2%
남 29
 
7.2%
군 29
 
7.2%
청 29
 
7.2%
도 28
 
6.9%
로 25
 
6.2%
읍 22
 
5.5%
장 14
 
3.5%
Other values (33) 94
23.3%
Common
ValueCountFrequency (%)
117
54.7%
1 27
 
12.6%
9 9
 
4.2%
5 9
 
4.2%
4 8
 
3.7%
3 8
 
3.7%
7 6
 
2.8%
2 6
 
2.8%
0 6
 
2.8%
- 5
 
2.3%
Other values (5) 13
 
6.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 403
65.3%
ASCII 214
34.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
117
54.7%
1 27
 
12.6%
9 9
 
4.2%
5 9
 
4.2%
4 8
 
3.7%
3 8
 
3.7%
7 6
 
2.8%
2 6
 
2.8%
0 6
 
2.8%
- 5
 
2.3%
Other values (5) 13
 
6.1%
Hangul
ValueCountFrequency (%)
서 50
12.4%
천 46
11.4%
충 37
 
9.2%
남 29
 
7.2%
군 29
 
7.2%
청 29
 
7.2%
도 28
 
6.9%
로 25
 
6.2%
읍 22
 
5.5%
장 14
 
3.5%
Other values (33) 94
23.3%

연락처
Text

MISSING 

Distinct27
Distinct (%)100.0%
Missing1
Missing (%)3.6%
Memory size356.0 B
2023-12-12T14:01:48.544825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.962963
Min length11

Characters and Unicode

Total characters323
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-7599
2nd row041-953-6227
3rd row041-951-3223
4th row041-952-8001
5th row041-952-5715
ValueCountFrequency (%)
041-951-7599 1
 
3.7%
041-9530189 1
 
3.7%
041-956-0405 1
 
3.7%
041-951-7515 1
 
3.7%
041-953-5665 1
 
3.7%
041-953-5212 1
 
3.7%
041-956-8920 1
 
3.7%
041-952-1510 1
 
3.7%
041-953-8969 1
 
3.7%
041-956-8050 1
 
3.7%
Other values (17) 17
63.0%
2023-12-12T14:01:48.935558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 53
16.4%
1 45
13.9%
0 43
13.3%
5 42
13.0%
9 38
11.8%
4 33
10.2%
3 16
 
5.0%
2 16
 
5.0%
7 15
 
4.6%
6 13
 
4.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 270
83.6%
Dash Punctuation 53
 
16.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 45
16.7%
0 43
15.9%
5 42
15.6%
9 38
14.1%
4 33
12.2%
3 16
 
5.9%
2 16
 
5.9%
7 15
 
5.6%
6 13
 
4.8%
8 9
 
3.3%
Dash Punctuation
ValueCountFrequency (%)
- 53
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 323
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 53
16.4%
1 45
13.9%
0 43
13.3%
5 42
13.0%
9 38
11.8%
4 33
10.2%
3 16
 
5.0%
2 16
 
5.0%
7 15
 
4.6%
6 13
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 323
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 53
16.4%
1 45
13.9%
0 43
13.3%
5 42
13.0%
9 38
11.8%
4 33
10.2%
3 16
 
5.0%
2 16
 
5.0%
7 15
 
4.6%
6 13
 
4.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size356.0 B
2023-07-12
28 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-07-12
2nd row2023-07-12
3rd row2023-07-12
4th row2023-07-12
5th row2023-07-12

Common Values

ValueCountFrequency (%)
2023-07-12 28
100.0%

Length

2023-12-12T14:01:49.131183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:01:49.239493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-07-12 28
100.0%

Correlations

2023-12-12T14:01:49.309588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
등록일자개설자명약국명칭우편번호약국소재지연락처
등록일자1.0001.0001.0000.8501.0001.000
개설자명1.0001.0001.0001.0001.0001.000
약국명칭1.0001.0001.0001.0001.0001.000
우편번호0.8501.0001.0001.0001.0001.000
약국소재지1.0001.0001.0001.0001.0001.000
연락처1.0001.0001.0001.0001.0001.000

Missing values

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

등록일자개설자명약국명칭우편번호약국소재지연락처데이터기준일자
02022-07-28한정훈정약국'33675충청남도 서천군 장항읍 성주로 6<NA>2023-07-12
12020-07-13김용진서천드림약국'33642충청남도 서천군 서천읍 충절로41번길 11041-951-75992023-07-12
22018-11-30허승무더조은약국'33635충청남도 서천군 서천읍 사곡로43번길 1041-953-62272023-07-12
32018-08-31박주형시장약국'33647충청남도 서천군 서천읍 충절로 50041-951-32232023-07-12
42018-03-02이민수서천세계로약국'33643충청남도 서천군 서천읍 서천로 94041-952-80012023-07-12
52017-09-06조혜정사랑약국'33635충청남도 서천군 서천읍 사곡로 17 (휴먼시아아파트 상가동 103호)041-952-57152023-07-12
62016-08-22박공희유명약국'33608충청남도 서천군 비인면 비인로 174041-952-70452023-07-12
72015-11-03신승현새대전약국'33624충청남도 서천군 한산면 한산모시길 31041-952-91182023-07-12
82014-06-05남준영장항약국'33672충청남도 서천군 장항읍 장항로 181-2041-956-77612023-07-12
92013-12-17고용석김약국'33608충청남도 서천군 비인면 비인로 207-2041-952-39592023-07-12
등록일자개설자명약국명칭우편번호약국소재지연락처데이터기준일자
182008-12-06박승희하나약국'33642충청남도 서천군 서천읍 충절로49번길 11-5, 1층041-953-20342023-07-12
192008-12-06구충환장항종로약국'33673충청남도 서천군 장항읍 장서로 30041-956-80502023-07-12
202008-12-06박종형희망찬약국'33642충청남도 서천군 서천읍 충절로59번길 18041-953-89692023-07-12
212008-12-06조구원진성약국33603충청남도 서천군 서면 공암남촌길 176041-952-15102023-07-12
222008-12-06손낙순하구둑약국'33657충청남도 서천군 마서면 장산로 851041-956-89202023-07-12
232008-12-06김진우늘푸른약국'33642충청남도 서천군 서천읍 충절로59번길 22041-953-52122023-07-12
242008-12-06이종현시장종로약국'33642충청남도 서천군 서천읍 충절로 49041-953-56652023-07-12
252008-12-06이두용태산약국'33642충청남도 서천군 서천읍 충절로41번길 1041-951-75152023-07-12
262008-12-06조성재화신약국'33670충청남도 서천군 장항읍 장항로 131041-956-04052023-07-12
272008-12-06노민영서울약국'33643충청남도 서천군 서천읍 서천로 96041-953-07502023-07-12