Overview

Dataset statistics

Number of variables5
Number of observations67
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.8 KiB
Average record size in memory43.0 B

Variable types

Numeric1
Categorical2
Text2

Dataset

Description경상북도 예천군 관내에 위치한 폐의약품 수거함 현황(연번, 구분, 장소명, 도로명주소, 데이터기준일자)입니다. 관리주체는 예천군보건소입니다.
URLhttps://www.data.go.kr/data/15113051/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
연번 is highly overall correlated with 구분High correlation
구분 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique
장소명 has unique valuesUnique
도로명주소 has unique valuesUnique

Reproduction

Analysis started2023-12-12 14:22:22.827765
Analysis finished2023-12-12 14:22:23.383769
Duration0.56 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct67
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean34
Minimum1
Maximum67
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size735.0 B
2023-12-12T23:22:23.476050image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.3
Q117.5
median34
Q350.5
95-th percentile63.7
Maximum67
Range66
Interquartile range (IQR)33

Descriptive statistics

Standard deviation19.485037
Coefficient of variation (CV)0.57308932
Kurtosis-1.2
Mean34
Median Absolute Deviation (MAD)17
Skewness0
Sum2278
Variance379.66667
MonotonicityStrictly increasing
2023-12-12T23:22:23.629913image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.5%
44 1
 
1.5%
50 1
 
1.5%
49 1
 
1.5%
48 1
 
1.5%
47 1
 
1.5%
46 1
 
1.5%
45 1
 
1.5%
43 1
 
1.5%
2 1
 
1.5%
Other values (57) 57
85.1%
ValueCountFrequency (%)
1 1
1.5%
2 1
1.5%
3 1
1.5%
4 1
1.5%
5 1
1.5%
6 1
1.5%
7 1
1.5%
8 1
1.5%
9 1
1.5%
10 1
1.5%
ValueCountFrequency (%)
67 1
1.5%
66 1
1.5%
65 1
1.5%
64 1
1.5%
63 1
1.5%
62 1
1.5%
61 1
1.5%
60 1
1.5%
59 1
1.5%
58 1
1.5%

구분
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)7.5%
Missing0
Missing (%)0.0%
Memory size668.0 B
공공보건의료기관
27 
약국
18 
행정복지센터
12 
아파트 관리사무소
9 
노인복지관
 
1

Length

Max length9
Median length8
Mean length6.119403
Min length2

Unique

Unique1 ?
Unique (%)1.5%

Sample

1st row공공보건의료기관
2nd row공공보건의료기관
3rd row공공보건의료기관
4th row공공보건의료기관
5th row공공보건의료기관

Common Values

ValueCountFrequency (%)
공공보건의료기관 27
40.3%
약국 18
26.9%
행정복지센터 12
17.9%
아파트 관리사무소 9
 
13.4%
노인복지관 1
 
1.5%

Length

2023-12-12T23:22:23.785047image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:22:23.930519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공공보건의료기관 27
35.5%
약국 18
23.7%
행정복지센터 12
15.8%
아파트 9
 
11.8%
관리사무소 9
 
11.8%
노인복지관 1
 
1.3%

장소명
Text

UNIQUE 

Distinct67
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size668.0 B
2023-12-12T23:22:24.236946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length10
Mean length7
Min length4

Characters and Unicode

Total characters469
Distinct characters116
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

Unique67 ?
Unique (%)100.0%

Sample

1st row예천군보건소
2nd row용문보건지소
3rd row효자은풍통합보건지소
4th row감천보건지소
5th row보문보건지소
ValueCountFrequency (%)
우방아이유쉘 4
 
5.2%
호반베르디움 2
 
2.6%
1차 2
 
2.6%
2차 2
 
2.6%
예천군보건소 1
 
1.3%
동아당약국 1
 
1.3%
아이파크 1
 
1.3%
경북도청신도시 1
 
1.3%
센트럴 1
 
1.3%
센텀 1
 
1.3%
Other values (61) 61
79.2%
2023-12-12T23:22:24.729693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
보 32
 
6.8%
건 28
 
6.0%
소 28
 
6.0%
지 26
 
5.5%
약 18
 
3.8%
국 18
 
3.8%
진 17
 
3.6%
료 16
 
3.4%
복 14
 
3.0%
센 14
 
3.0%
Other values (106) 258
55.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 455
97.0%
Space Separator 10
 
2.1%
Decimal Number 4
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
보 32
 
7.0%
건 28
 
6.2%
소 28
 
6.2%
지 26
 
5.7%
약 18
 
4.0%
국 18
 
4.0%
진 17
 
3.7%
료 16
 
3.5%
복 14
 
3.1%
센 14
 
3.1%
Other values (103) 244
53.6%
Decimal Number
ValueCountFrequency (%)
1 2
50.0%
2 2
50.0%
Space Separator
ValueCountFrequency (%)
10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 455
97.0%
Common 14
 
3.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
보 32
 
7.0%
건 28
 
6.2%
소 28
 
6.2%
지 26
 
5.7%
약 18
 
4.0%
국 18
 
4.0%
진 17
 
3.7%
료 16
 
3.5%
복 14
 
3.1%
센 14
 
3.1%
Other values (103) 244
53.6%
Common
ValueCountFrequency (%)
10
71.4%
1 2
 
14.3%
2 2
 
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 455
97.0%
ASCII 14
 
3.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
보 32
 
7.0%
건 28
 
6.2%
소 28
 
6.2%
지 26
 
5.7%
약 18
 
4.0%
국 18
 
4.0%
진 17
 
3.7%
료 16
 
3.5%
복 14
 
3.1%
센 14
 
3.1%
Other values (103) 244
53.6%
ASCII
ValueCountFrequency (%)
10
71.4%
1 2
 
14.3%
2 2
 
14.3%

도로명주소
Text

UNIQUE 

Distinct67
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size668.0 B
2023-12-12T23:22:25.085492image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length24
Mean length20.462687
Min length18

Characters and Unicode

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

Unique67 ?
Unique (%)100.0%

Sample

1st row경상북도 예천군 예천읍 군청길 33
2nd row경상북도 예천군 용문면 용문경천로 1209-7
3rd row경상북도 예천군 은풍면 은풍로 100-7
4th row경상북도 예천군 감천면 포리2길 26
5th row경상북도 예천군 보문면 미호길 110
ValueCountFrequency (%)
경상북도 67
20.1%
예천군 67
20.1%
호명면 15
 
4.5%
예천읍 15
 
4.5%
시장로 5
 
1.5%
풍양면 5
 
1.5%
지보면 5
 
1.5%
용궁면 5
 
1.5%
보문면 4
 
1.2%
용문면 4
 
1.2%
Other values (106) 142
42.5%
2023-12-12T23:22:25.610664image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
267
19.5%
천 93
 
6.8%
예 84
 
6.1%
상 71
 
5.2%
군 70
 
5.1%
경 69
 
5.0%
도 68
 
5.0%
북 67
 
4.9%
면 52
 
3.8%
1 49
 
3.6%
Other values (71) 481
35.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 886
64.6%
Space Separator 267
 
19.5%
Decimal Number 200
 
14.6%
Dash Punctuation 18
 
1.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
천 93
 
10.5%
예 84
 
9.5%
상 71
 
8.0%
군 70
 
7.9%
경 69
 
7.8%
도 68
 
7.7%
북 67
 
7.6%
면 52
 
5.9%
로 42
 
4.7%
길 25
 
2.8%
Other values (59) 245
27.7%
Decimal Number
ValueCountFrequency (%)
1 49
24.5%
2 28
14.0%
3 23
11.5%
4 17
 
8.5%
0 17
 
8.5%
8 16
 
8.0%
7 14
 
7.0%
9 13
 
6.5%
5 12
 
6.0%
6 11
 
5.5%
Space Separator
ValueCountFrequency (%)
267
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 18
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 886
64.6%
Common 485
35.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
천 93
 
10.5%
예 84
 
9.5%
상 71
 
8.0%
군 70
 
7.9%
경 69
 
7.8%
도 68
 
7.7%
북 67
 
7.6%
면 52
 
5.9%
로 42
 
4.7%
길 25
 
2.8%
Other values (59) 245
27.7%
Common
ValueCountFrequency (%)
267
55.1%
1 49
 
10.1%
2 28
 
5.8%
3 23
 
4.7%
- 18
 
3.7%
4 17
 
3.5%
0 17
 
3.5%
8 16
 
3.3%
7 14
 
2.9%
9 13
 
2.7%
Other values (2) 23
 
4.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 886
64.6%
ASCII 485
35.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
267
55.1%
1 49
 
10.1%
2 28
 
5.8%
3 23
 
4.7%
- 18
 
3.7%
4 17
 
3.5%
0 17
 
3.5%
8 16
 
3.3%
7 14
 
2.9%
9 13
 
2.7%
Other values (2) 23
 
4.7%
Hangul
ValueCountFrequency (%)
천 93
 
10.5%
예 84
 
9.5%
상 71
 
8.0%
군 70
 
7.9%
경 69
 
7.8%
도 68
 
7.7%
북 67
 
7.6%
면 52
 
5.9%
로 42
 
4.7%
길 25
 
2.8%
Other values (59) 245
27.7%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size668.0 B
2023-03-30
67 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-03-30
2nd row2023-03-30
3rd row2023-03-30
4th row2023-03-30
5th row2023-03-30

Common Values

ValueCountFrequency (%)
2023-03-30 67
100.0%

Length

2023-12-12T23:22:25.825237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:22:25.965729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-03-30 67
100.0%

Interactions

2023-12-12T23:22:23.062698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:22:26.034541image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분장소명도로명주소
연번1.0000.9821.0001.000
구분0.9821.0001.0001.000
장소명1.0001.0001.0001.000
도로명주소1.0001.0001.0001.000
2023-12-12T23:22:26.137802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분
연번1.0000.774
구분0.7741.000

Missing values

2023-12-12T23:22:23.204212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:22:23.331385image/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공공보건의료기관예천군보건소경상북도 예천군 예천읍 군청길 332023-03-30
12공공보건의료기관용문보건지소경상북도 예천군 용문면 용문경천로 1209-72023-03-30
23공공보건의료기관효자은풍통합보건지소경상북도 예천군 은풍면 은풍로 100-72023-03-30
34공공보건의료기관감천보건지소경상북도 예천군 감천면 포리2길 262023-03-30
45공공보건의료기관보문보건지소경상북도 예천군 보문면 미호길 1102023-03-30
56공공보건의료기관호명보건지소경상북도 예천군 호명면 오천길 232023-03-30
67공공보건의료기관유천보건지소경상북도 예천군 유천면 예성로 6852023-03-30
78공공보건의료기관용궁보건지소경상북도 예천군 용궁면 용개로 122023-03-30
89공공보건의료기관개포보건지소경상북도 예천군 개포면 용개로 10152023-03-30
910공공보건의료기관지보보건지소경상북도 예천군 지보면 소화1길 20-72023-03-30
연번구분장소명도로명주소데이터기준일자
5758약국조은약국경상북도 예천군 예천읍 군청앞길 16-12023-03-30
5859약국수정온누리약국경상북도 예천군 예천읍 시장로 1402023-03-30
5960약국하나약국경상북도 예천군 예천읍 효자로 1232023-03-30
6061약국푸른약국경상북도 예천군 예천읍 시장로 1082023-03-30
6162약국행복한약국경상북도 예천군 예천읍 효자로 932023-03-30
6263약국삼선당약국경상북도 예천군 예천읍 중앙로 33-12023-03-30
6364약국에덴약국경상북도 예천군 호명면 새움3로 202023-03-30
6465약국경북솔약국경상북도 예천군 호명면 새움3로 462023-03-30
6566약국행운약국경상북도 예천군 호명면 새움3로 262023-03-30
6667노인복지관예천군 노인복지관경상북도 예천군 예천읍 충효로 209-192023-03-30