Overview

Dataset statistics

Number of variables6
Number of observations126
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.2 KiB
Average record size in memory50.0 B

Variable types

Numeric1
Categorical1
Text3
DateTime1

Dataset

Description폐의약품 수거함 현황에 대한 데이터로 연번, 행정동, 수거함위치명, 소재지(도로명주소), 전화번호, 데이터기준일자 항목을 제공합니다.
Author경상북도 안동시
URLhttps://www.data.go.kr/data/15113197/fileData.do

Alerts

등록기준일자 has constant value ""Constant
연번 has unique valuesUnique
수거함위치명 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2024-04-06 08:24:55.318099
Analysis finished2024-04-06 08:24:57.173633
Duration1.86 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct126
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean63.5
Minimum1
Maximum126
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.2 KiB
2024-04-06T17:24:57.321732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile7.25
Q132.25
median63.5
Q394.75
95-th percentile119.75
Maximum126
Range125
Interquartile range (IQR)62.5

Descriptive statistics

Standard deviation36.517119
Coefficient of variation (CV)0.57507274
Kurtosis-1.2
Mean63.5
Median Absolute Deviation (MAD)31.5
Skewness0
Sum8001
Variance1333.5
MonotonicityStrictly increasing
2024-04-06T17:24:57.625451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.8%
81 1
 
0.8%
94 1
 
0.8%
93 1
 
0.8%
92 1
 
0.8%
91 1
 
0.8%
90 1
 
0.8%
89 1
 
0.8%
88 1
 
0.8%
87 1
 
0.8%
Other values (116) 116
92.1%
ValueCountFrequency (%)
1 1
0.8%
2 1
0.8%
3 1
0.8%
4 1
0.8%
5 1
0.8%
6 1
0.8%
7 1
0.8%
8 1
0.8%
9 1
0.8%
10 1
0.8%
ValueCountFrequency (%)
126 1
0.8%
125 1
0.8%
124 1
0.8%
123 1
0.8%
122 1
0.8%
121 1
0.8%
120 1
0.8%
119 1
0.8%
118 1
0.8%
117 1
0.8%

행정동
Categorical

Distinct27
Distinct (%)21.4%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
중구동
16 
서구동
13 
옥동
10 
강남동
용상동
Other values (22)
71 

Length

Max length3
Median length3
Mean length2.9206349
Min length2

Unique

Unique5 ?
Unique (%)4.0%

Sample

1st row강남동
2nd row수상동
3rd row옥동
4th row정하동
5th row용상동

Common Values

ValueCountFrequency (%)
중구동 16
 
12.7%
서구동 13
 
10.3%
옥동 10
 
7.9%
강남동 8
 
6.3%
용상동 8
 
6.3%
풍산읍 7
 
5.6%
풍천면 7
 
5.6%
길안면 5
 
4.0%
예안면 4
 
3.2%
서후면 4
 
3.2%
Other values (17) 44
34.9%

Length

2024-04-06T17:24:57.899371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
중구동 16
 
12.7%
서구동 13
 
10.3%
옥동 10
 
7.9%
강남동 8
 
6.3%
용상동 8
 
6.3%
풍산읍 7
 
5.6%
풍천면 7
 
5.6%
길안면 5
 
4.0%
일직면 4
 
3.2%
녹전면 4
 
3.2%
Other values (17) 44
34.9%

수거함위치명
Text

UNIQUE 

Distinct126
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2024-04-06T17:24:58.486460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length8
Mean length6.1984127
Min length3

Characters and Unicode

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

Unique126 ?
Unique (%)100.0%

Sample

1st row복약국
2nd row안동중앙약국
3rd row서울약국
4th row정하우리약국
5th row금빛약국
ValueCountFrequency (%)
복약국 1
 
0.8%
예안면행정복지센터 1
 
0.8%
남후면보건지소 1
 
0.8%
원림보건진료소 1
 
0.8%
남선면보건지소 1
 
0.8%
송사보건진료소 1
 
0.8%
구수보건진료소 1
 
0.8%
길안면보건지소 1
 
0.8%
안동시보건소 1
 
0.8%
풍천면행정복지센터 1
 
0.8%
Other values (116) 116
92.1%
2024-04-06T17:24:59.299240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
62
 
7.9%
61
 
7.8%
42
 
5.4%
42
 
5.4%
40
 
5.1%
39
 
5.0%
26
 
3.3%
26
 
3.3%
26
 
3.3%
25
 
3.2%
Other values (121) 392
50.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 776
99.4%
Decimal Number 3
 
0.4%
Space Separator 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
62
 
8.0%
61
 
7.9%
42
 
5.4%
42
 
5.4%
40
 
5.2%
39
 
5.0%
26
 
3.4%
26
 
3.4%
26
 
3.4%
25
 
3.2%
Other values (117) 387
49.9%
Decimal Number
ValueCountFrequency (%)
5 1
33.3%
6 1
33.3%
3 1
33.3%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 776
99.4%
Common 5
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
62
 
8.0%
61
 
7.9%
42
 
5.4%
42
 
5.4%
40
 
5.2%
39
 
5.0%
26
 
3.4%
26
 
3.4%
26
 
3.4%
25
 
3.2%
Other values (117) 387
49.9%
Common
ValueCountFrequency (%)
2
40.0%
5 1
20.0%
6 1
20.0%
3 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 776
99.4%
ASCII 5
 
0.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
62
 
8.0%
61
 
7.9%
42
 
5.4%
42
 
5.4%
40
 
5.2%
39
 
5.0%
26
 
3.4%
26
 
3.4%
26
 
3.4%
25
 
3.2%
Other values (117) 387
49.9%
ASCII
ValueCountFrequency (%)
2
40.0%
5 1
20.0%
6 1
20.0%
3 1
20.0%
Distinct123
Distinct (%)97.6%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2024-04-06T17:24:59.986581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length27
Mean length21.563492
Min length16

Characters and Unicode

Total characters2717
Distinct characters124
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

Unique120 ?
Unique (%)95.2%

Sample

1st row경상북도 안동시 경북대로 171, 1층 (수상동)
2nd row경상북도 안동시 앙실로 15 (수상동)
3rd row경상북도 안동시 옥서1길 81, 스카이빌딩 101호 (옥동)
4th row경상북도 안동시 강남1길 69 (정하동)
5th row경상북도 안동시 경동로 847 (용상동)
ValueCountFrequency (%)
경상북도 126
20.0%
안동시 126
20.0%
경북대로 11
 
1.7%
경동로 11
 
1.7%
옥동 9
 
1.4%
풍산읍 7
 
1.1%
풍천면 7
 
1.1%
수상동 7
 
1.1%
퇴계로 7
 
1.1%
1층 6
 
1.0%
Other values (203) 313
49.7%
2024-04-06T17:25:00.968791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
508
18.7%
207
 
7.6%
149
 
5.5%
148
 
5.4%
148
 
5.4%
139
 
5.1%
130
 
4.8%
129
 
4.7%
1 99
 
3.6%
81
 
3.0%
Other values (114) 979
36.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1681
61.9%
Space Separator 508
 
18.7%
Decimal Number 385
 
14.2%
Close Punctuation 57
 
2.1%
Open Punctuation 57
 
2.1%
Dash Punctuation 17
 
0.6%
Other Punctuation 12
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
207
12.3%
149
 
8.9%
148
 
8.8%
148
 
8.8%
139
 
8.3%
130
 
7.7%
129
 
7.7%
81
 
4.8%
54
 
3.2%
50
 
3.0%
Other values (99) 446
26.5%
Decimal Number
ValueCountFrequency (%)
1 99
25.7%
7 49
12.7%
5 38
 
9.9%
3 32
 
8.3%
0 31
 
8.1%
2 30
 
7.8%
4 28
 
7.3%
8 28
 
7.3%
6 27
 
7.0%
9 23
 
6.0%
Space Separator
ValueCountFrequency (%)
508
100.0%
Close Punctuation
ValueCountFrequency (%)
) 57
100.0%
Open Punctuation
ValueCountFrequency (%)
( 57
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 17
100.0%
Other Punctuation
ValueCountFrequency (%)
, 12
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1681
61.9%
Common 1036
38.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
207
12.3%
149
 
8.9%
148
 
8.8%
148
 
8.8%
139
 
8.3%
130
 
7.7%
129
 
7.7%
81
 
4.8%
54
 
3.2%
50
 
3.0%
Other values (99) 446
26.5%
Common
ValueCountFrequency (%)
508
49.0%
1 99
 
9.6%
) 57
 
5.5%
( 57
 
5.5%
7 49
 
4.7%
5 38
 
3.7%
3 32
 
3.1%
0 31
 
3.0%
2 30
 
2.9%
4 28
 
2.7%
Other values (5) 107
 
10.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1681
61.9%
ASCII 1036
38.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
508
49.0%
1 99
 
9.6%
) 57
 
5.5%
( 57
 
5.5%
7 49
 
4.7%
5 38
 
3.7%
3 32
 
3.1%
0 31
 
3.0%
2 30
 
2.9%
4 28
 
2.7%
Other values (5) 107
 
10.3%
Hangul
ValueCountFrequency (%)
207
12.3%
149
 
8.9%
148
 
8.8%
148
 
8.8%
139
 
8.3%
130
 
7.7%
129
 
7.7%
81
 
4.8%
54
 
3.2%
50
 
3.0%
Other values (99) 446
26.5%

전화번호
Text

UNIQUE 

Distinct126
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2024-04-06T17:25:01.601521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique126 ?
Unique (%)100.0%

Sample

1st row054-858-0011
2nd row054-852-1199
3rd row054-856-8118
4th row054-841-6999
5th row054-822-8989
ValueCountFrequency (%)
054-858-0011 1
 
0.8%
054-822-2574 1
 
0.8%
054-859-6714 1
 
0.8%
054-859-6775 1
 
0.8%
054-822-8614 1
 
0.8%
054-822-8004 1
 
0.8%
054-822-6301 1
 
0.8%
054-822-2025 1
 
0.8%
054-855-5986 1
 
0.8%
054-853-2005 1
 
0.8%
Other values (116) 116
92.1%
2024-04-06T17:25:02.558638image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 272
18.0%
- 252
16.7%
0 210
13.9%
4 190
12.6%
8 184
12.2%
2 106
 
7.0%
3 74
 
4.9%
1 69
 
4.6%
9 62
 
4.1%
6 50
 
3.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1260
83.3%
Dash Punctuation 252
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 272
21.6%
0 210
16.7%
4 190
15.1%
8 184
14.6%
2 106
 
8.4%
3 74
 
5.9%
1 69
 
5.5%
9 62
 
4.9%
6 50
 
4.0%
7 43
 
3.4%
Dash Punctuation
ValueCountFrequency (%)
- 252
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1512
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 272
18.0%
- 252
16.7%
0 210
13.9%
4 190
12.6%
8 184
12.2%
2 106
 
7.0%
3 74
 
4.9%
1 69
 
4.6%
9 62
 
4.1%
6 50
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1512
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 272
18.0%
- 252
16.7%
0 210
13.9%
4 190
12.6%
8 184
12.2%
2 106
 
7.0%
3 74
 
4.9%
1 69
 
4.6%
9 62
 
4.1%
6 50
 
3.3%

등록기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
Minimum2024-02-29 00:00:00
Maximum2024-02-29 00:00:00
2024-04-06T17:25:02.816561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:25:03.047637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-04-06T17:24:56.572161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-06T17:25:03.265971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번행정동
연번1.0000.758
행정동0.7581.000
2024-04-06T17:25:03.472154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번행정동
연번1.0000.360
행정동0.3601.000

Missing values

2024-04-06T17:24:56.824823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T17:24:57.039637image/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강남동복약국경상북도 안동시 경북대로 171, 1층 (수상동)054-858-00112024-02-29
12수상동안동중앙약국경상북도 안동시 앙실로 15 (수상동)054-852-11992024-02-29
23옥동서울약국경상북도 안동시 옥서1길 81, 스카이빌딩 101호 (옥동)054-856-81182024-02-29
34정하동정하우리약국경상북도 안동시 강남1길 69 (정하동)054-841-69992024-02-29
45용상동금빛약국경상북도 안동시 경동로 847 (용상동)054-822-89892024-02-29
56중구동금성약국경상북도 안동시 대안로 177, 1층 (운흥동)054-841-43562024-02-29
67평화동라라약국경상북도 안동시 서동문로 7, 1층 101호 (평화동)054-859-33352024-02-29
78서구동명성약국경상북도 안동시 금곡길 11 (금곡동)054-854-09982024-02-29
89옥동365약국경상북도 안동시 경북대로 385, 1층 (옥동)054-858-88962024-02-29
910옥동소망약국경상북도 안동시 광명로 170, 1층 (옥동)054-855-33692024-02-29
연번행정동수거함위치명소재지(도로명주소)전화번호등록기준일자
116117풍산읍풍산읍보건지소경상북도 안동시 풍산읍 풍산중앙길 99054-858-68942024-02-29
117118풍산읍만운보건진료소경상북도 안동시 풍산읍 평지1길 7054-842-56402024-02-29
118119풍산읍신양보건진료소경상북도 안동시 풍산읍 현애길 1054-852-69502024-02-29
119120풍산읍회곡보건진료소경상북도 안동시 풍산읍 풍산태사로 1703-2054-852-93002024-02-29
120121풍천면풍천면보건지소경상북도 안동시 풍천면 지풍로 1465-4054-853-26392024-02-29
121122풍천면가곡보건진료소경상북도 안동시 풍천면 가일선원길 57-3054-853-25042024-02-29
122123풍천면신성보건진료소경상북도 안동시 풍천면 신성큰마길 40054-841-33512024-02-29
123124풍천면어담보건진료소경상북도 안동시 풍천면 풍일로 1354054-841-91632024-02-29
124125풍천면하회보건진료소경상북도 안동시 풍천면 하회종가길 38054-853-24812024-02-29
125126용상동용상현대아파트경상북도 안동시 길주길 101-12054-821-05482024-02-29