Overview

Dataset statistics

Number of variables6
Number of observations68
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.3 KiB
Average record size in memory49.9 B

Variable types

Text4
Categorical1
DateTime1

Dataset

Description충청남도 논산시 의약품판매업소 파일데이터로 업소명, 행정동, 소재지도로명주소, 소재지지번주소, 전화번호 정보를 제공하고 있습니다.
Author충청남도 논산시
URLhttps://www.data.go.kr/data/3073211/fileData.do

Alerts

기준일자 has constant value ""Constant
업소명 has unique valuesUnique
소재지도로명주소 has unique valuesUnique
소재지지번주소 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2024-03-14 09:00:51.970828
Analysis finished2024-03-14 09:00:52.980252
Duration1.01 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업소명
Text

UNIQUE 

Distinct68
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size672.0 B
2024-03-14T18:00:53.766748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length8
Mean length4.7941176
Min length3

Characters and Unicode

Total characters326
Distinct characters102
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

Unique68 ?
Unique (%)100.0%

Sample

1st row논산온누리약국
2nd row삼삼약국
3rd row모자약국
4th row박약국
5th row전약국
ValueCountFrequency (%)
논산온누리약국 1
 
1.5%
황화약국 1
 
1.5%
안심약국 1
 
1.5%
영진약국 1
 
1.5%
미소약국 1
 
1.5%
현대약국 1
 
1.5%
단골약국 1
 
1.5%
삼삼약국 1
 
1.5%
인삼당약국 1
 
1.5%
차부약국 1
 
1.5%
Other values (58) 58
85.3%
2024-03-14T18:00:55.422633image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
69
21.2%
68
20.9%
9
 
2.8%
9
 
2.8%
6
 
1.8%
6
 
1.8%
5
 
1.5%
5
 
1.5%
5
 
1.5%
5
 
1.5%
Other values (92) 139
42.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 326
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
69
21.2%
68
20.9%
9
 
2.8%
9
 
2.8%
6
 
1.8%
6
 
1.8%
5
 
1.5%
5
 
1.5%
5
 
1.5%
5
 
1.5%
Other values (92) 139
42.6%

Most occurring scripts

ValueCountFrequency (%)
Hangul 326
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
69
21.2%
68
20.9%
9
 
2.8%
9
 
2.8%
6
 
1.8%
6
 
1.8%
5
 
1.5%
5
 
1.5%
5
 
1.5%
5
 
1.5%
Other values (92) 139
42.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 326
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
69
21.2%
68
20.9%
9
 
2.8%
9
 
2.8%
6
 
1.8%
6
 
1.8%
5
 
1.5%
5
 
1.5%
5
 
1.5%
5
 
1.5%
Other values (92) 139
42.6%

행정동
Categorical

Distinct7
Distinct (%)10.3%
Missing0
Missing (%)0.0%
Memory size672.0 B
취암동
42 
강경읍
11 
연무읍
양촌면
 
3
연산면
 
3
Other values (2)
 
3

Length

Max length4
Median length3
Mean length3.0147059
Min length3

Unique

Unique1 ?
Unique (%)1.5%

Sample

1st row취암동
2nd row강경읍
3rd row강경읍
4th row양촌면
5th row취암동

Common Values

ValueCountFrequency (%)
취암동 42
61.8%
강경읍 11
 
16.2%
연무읍 6
 
8.8%
양촌면 3
 
4.4%
연산면 3
 
4.4%
부창동 2
 
2.9%
취암동 1
 
1.5%

Length

2024-03-14T18:00:55.858062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T18:00:56.208378image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
취암동 43
63.2%
강경읍 11
 
16.2%
연무읍 6
 
8.8%
양촌면 3
 
4.4%
연산면 3
 
4.4%
부창동 2
 
2.9%
Distinct68
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size672.0 B
2024-03-14T18:00:57.276223image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length23
Mean length18.705882
Min length15

Characters and Unicode

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

Unique

Unique68 ?
Unique (%)100.0%

Sample

1st row충청남도 논산시 중앙로 494
2nd row충청남도 논산시 강경읍 계백로 104-3
3rd row충청남도 논산시 강경읍 옥녀봉로27번길 10-5
4th row충청남도 논산시 양촌면 매죽헌로 1685
5th row충청남도 논산시 계백로 1020
ValueCountFrequency (%)
충청남도 68
22.9%
논산시 68
22.9%
계백로 13
 
4.4%
중앙로 11
 
3.7%
강경읍 11
 
3.7%
시민로 6
 
2.0%
연무읍 6
 
2.0%
해월로 4
 
1.3%
연산면 3
 
1.0%
중앙로480번길 3
 
1.0%
Other values (86) 104
35.0%
2024-03-14T18:00:58.534100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
229
18.0%
77
 
6.1%
75
 
5.9%
69
 
5.4%
69
 
5.4%
68
 
5.3%
68
 
5.3%
68
 
5.3%
66
 
5.2%
1 58
 
4.6%
Other values (49) 425
33.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 797
62.7%
Decimal Number 238
 
18.7%
Space Separator 229
 
18.0%
Dash Punctuation 8
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
77
 
9.7%
75
 
9.4%
69
 
8.7%
69
 
8.7%
68
 
8.5%
68
 
8.5%
68
 
8.5%
66
 
8.3%
22
 
2.8%
20
 
2.5%
Other values (37) 195
24.5%
Decimal Number
ValueCountFrequency (%)
1 58
24.4%
4 34
14.3%
2 28
11.8%
8 21
 
8.8%
0 21
 
8.8%
6 19
 
8.0%
9 15
 
6.3%
3 15
 
6.3%
7 14
 
5.9%
5 13
 
5.5%
Space Separator
ValueCountFrequency (%)
229
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 797
62.7%
Common 475
37.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
77
 
9.7%
75
 
9.4%
69
 
8.7%
69
 
8.7%
68
 
8.5%
68
 
8.5%
68
 
8.5%
66
 
8.3%
22
 
2.8%
20
 
2.5%
Other values (37) 195
24.5%
Common
ValueCountFrequency (%)
229
48.2%
1 58
 
12.2%
4 34
 
7.2%
2 28
 
5.9%
8 21
 
4.4%
0 21
 
4.4%
6 19
 
4.0%
9 15
 
3.2%
3 15
 
3.2%
7 14
 
2.9%
Other values (2) 21
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 797
62.7%
ASCII 475
37.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
229
48.2%
1 58
 
12.2%
4 34
 
7.2%
2 28
 
5.9%
8 21
 
4.4%
0 21
 
4.4%
6 19
 
4.0%
9 15
 
3.2%
3 15
 
3.2%
7 14
 
2.9%
Other values (2) 21
 
4.4%
Hangul
ValueCountFrequency (%)
77
 
9.7%
75
 
9.4%
69
 
8.7%
69
 
8.7%
68
 
8.5%
68
 
8.5%
68
 
8.5%
66
 
8.3%
22
 
2.8%
20
 
2.5%
Other values (37) 195
24.5%
Distinct68
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size672.0 B
2024-03-14T18:00:59.589441image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length25
Mean length21.617647
Min length16

Characters and Unicode

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

Unique

Unique68 ?
Unique (%)100.0%

Sample

1st row충청남도 논산시 화지동 91-9번지
2nd row충청남도 논산시 강경읍 대흥리 48-2번지
3rd row충청남도 논산시 강경읍 태평리 1-11번지
4th row충청남도 논산시 양촌면 인천리 324-3번지
5th row충청남도 논산시 취암동 1040-25번지
ValueCountFrequency (%)
충청남도 68
23.0%
논산시 68
23.0%
취암동 13
 
4.4%
반월동 13
 
4.4%
강경읍 11
 
3.7%
대흥리 9
 
3.0%
내동 8
 
2.7%
화지동 8
 
2.7%
연무읍 6
 
2.0%
안심리 4
 
1.4%
Other values (81) 88
29.7%
2024-03-14T18:01:00.775595image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
292
19.9%
77
 
5.2%
73
 
5.0%
69
 
4.7%
68
 
4.6%
68
 
4.6%
68
 
4.6%
68
 
4.6%
68
 
4.6%
64
 
4.4%
Other values (41) 555
37.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 872
59.3%
Space Separator 292
 
19.9%
Decimal Number 250
 
17.0%
Dash Punctuation 56
 
3.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
77
 
8.8%
73
 
8.4%
69
 
7.9%
68
 
7.8%
68
 
7.8%
68
 
7.8%
68
 
7.8%
68
 
7.8%
64
 
7.3%
47
 
5.4%
Other values (29) 202
23.2%
Decimal Number
ValueCountFrequency (%)
1 57
22.8%
6 34
13.6%
2 27
10.8%
3 24
9.6%
8 23
9.2%
4 19
 
7.6%
0 19
 
7.6%
5 18
 
7.2%
9 18
 
7.2%
7 11
 
4.4%
Space Separator
ValueCountFrequency (%)
292
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 56
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 872
59.3%
Common 598
40.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
77
 
8.8%
73
 
8.4%
69
 
7.9%
68
 
7.8%
68
 
7.8%
68
 
7.8%
68
 
7.8%
68
 
7.8%
64
 
7.3%
47
 
5.4%
Other values (29) 202
23.2%
Common
ValueCountFrequency (%)
292
48.8%
1 57
 
9.5%
- 56
 
9.4%
6 34
 
5.7%
2 27
 
4.5%
3 24
 
4.0%
8 23
 
3.8%
4 19
 
3.2%
0 19
 
3.2%
5 18
 
3.0%
Other values (2) 29
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 872
59.3%
ASCII 598
40.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
292
48.8%
1 57
 
9.5%
- 56
 
9.4%
6 34
 
5.7%
2 27
 
4.5%
3 24
 
4.0%
8 23
 
3.8%
4 19
 
3.2%
0 19
 
3.2%
5 18
 
3.0%
Other values (2) 29
 
4.8%
Hangul
ValueCountFrequency (%)
77
 
8.8%
73
 
8.4%
69
 
7.9%
68
 
7.8%
68
 
7.8%
68
 
7.8%
68
 
7.8%
68
 
7.8%
64
 
7.3%
47
 
5.4%
Other values (29) 202
23.2%

전화번호
Text

UNIQUE 

Distinct68
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size672.0 B
2024-03-14T18:01:01.738389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique68 ?
Unique (%)100.0%

Sample

1st row041-735-2253
2nd row041-745-4759
3rd row041-745-5391
4th row041-741-2345
5th row041-735-4820
ValueCountFrequency (%)
041-735-2253 1
 
1.5%
041-742-4178 1
 
1.5%
041-742-8280 1
 
1.5%
041-735-6497 1
 
1.5%
041-733-0733 1
 
1.5%
041-736-0818 1
 
1.5%
041-742-9110 1
 
1.5%
041-745-4759 1
 
1.5%
041-745-5757 1
 
1.5%
041-732-2408 1
 
1.5%
Other values (58) 58
85.3%
2024-03-14T18:01:02.930307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 136
16.7%
4 107
13.1%
7 104
12.7%
0 98
12.0%
1 97
11.9%
3 86
10.5%
5 67
8.2%
2 47
 
5.8%
6 30
 
3.7%
8 23
 
2.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 680
83.3%
Dash Punctuation 136
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 107
15.7%
7 104
15.3%
0 98
14.4%
1 97
14.3%
3 86
12.6%
5 67
9.9%
2 47
6.9%
6 30
 
4.4%
8 23
 
3.4%
9 21
 
3.1%
Dash Punctuation
ValueCountFrequency (%)
- 136
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 816
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 136
16.7%
4 107
13.1%
7 104
12.7%
0 98
12.0%
1 97
11.9%
3 86
10.5%
5 67
8.2%
2 47
 
5.8%
6 30
 
3.7%
8 23
 
2.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 816
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 136
16.7%
4 107
13.1%
7 104
12.7%
0 98
12.0%
1 97
11.9%
3 86
10.5%
5 67
8.2%
2 47
 
5.8%
6 30
 
3.7%
8 23
 
2.8%

기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size672.0 B
Minimum2024-01-18 00:00:00
Maximum2024-01-18 00:00:00
2024-03-14T18:01:03.133646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:01:03.293373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2024-03-14T18:01:03.421280image/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-03-14T18:00:52.494603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T18:00:52.844529image/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

업소명행정동소재지도로명주소소재지지번주소전화번호기준일자
0논산온누리약국취암동충청남도 논산시 중앙로 494충청남도 논산시 화지동 91-9번지041-735-22532024-01-18
1삼삼약국강경읍충청남도 논산시 강경읍 계백로 104-3충청남도 논산시 강경읍 대흥리 48-2번지041-745-47592024-01-18
2모자약국강경읍충청남도 논산시 강경읍 옥녀봉로27번길 10-5충청남도 논산시 강경읍 태평리 1-11번지041-745-53912024-01-18
3박약국양촌면충청남도 논산시 양촌면 매죽헌로 1685충청남도 논산시 양촌면 인천리 324-3번지041-741-23452024-01-18
4전약국취암동충청남도 논산시 계백로 1020충청남도 논산시 취암동 1040-25번지041-735-48202024-01-18
5우리약국강경읍충청남도 논산시 강경읍 계백로 116충청남도 논산시 강경읍 대흥리 16-20번지041-745-05332024-01-18
6주원약국연무읍충청남도 논산시 연무읍 안심로 109충청남도 논산시 연무읍 안심리 1-2번지041-741-43772024-01-18
7대우약국취암동충청남도 논산시 중앙로492번길 19충청남도 논산시 화지동 45-1번지041-735-39522024-01-18
8차부약국취암동충청남도 논산시 계백로 1008충청남도 논산시 취암동 1040-18번지041-732-24082024-01-18
9부창약국취암동충청남도 논산시 중앙로 249충청남도 논산시 내동 382-2번지041-734-31972024-01-18
업소명행정동소재지도로명주소소재지지번주소전화번호기준일자
58대한약국취암동충청남도 논산시 대화로70번길 17충청남도 논산시 화지동 47-1번지041-735-22552024-01-18
59대명약국취암동충청남도 논산시 중앙로480번길 22충청남도 논산시 반월동 83-3번지041-735-19222024-01-18
60연산약국연산면충청남도 논산시 연산면 황룡재로 49충청남도 논산시 연산면 연산리 92-6번지041-733-87102024-01-18
61젊은약사약국취암동충청남도 논산시 해월로 169충청남도 논산시 반월동 68-22번지041-736-90482024-01-18
62삼성약국취암동충청남도 논산시 시민로 307번길 3충청남도 논산시 내동 1031번지041-734-66232024-01-18
63내동온누리약국취암동충청남도 논산시 대학로65번길 18-1충청남도 논산시 내동 1195번지041-734-34502024-01-18
64푸른솔약국취암동충청남도 논산시 중앙로 483충청남도 논산시 화지동 106-2041-736-77812024-01-18
65참조은약국양촌면충청남도 논산시 양촌면 매죽헌로 1691충청남도 논산시 양촌면 인천리 313041-741-09092024-01-18
66나나약국취암동충청남도 논산시 시민로 132번길 48충청남도 논산시 내동 1128041-736-50352024-01-18
67반월약국취암동충청남도 논산시 중앙로 461충청남도 논산시 반월동 113-1041-733-15302024-01-18