Overview

Dataset statistics

Number of variables5
Number of observations125
Missing cells124
Missing cells (%)19.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.1 KiB
Average record size in memory42.1 B

Variable types

Numeric1
Text4

Dataset

Description대구광역시 서구_폐의약품 수거함 현황_20240401
Author대구광역시 서구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15112956&dataSetDetailId=151129561e69a926b1d17&provdMethod=FILE

Alerts

비고 has constant value ""Constant
비고 has 124 (99.2%) missing valuesMissing
연번 has unique valuesUnique
관할기관 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2024-04-06 08:05:57.643448
Analysis finished2024-04-06 08:05:58.628517
Duration0.99 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

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

Quantile statistics

Minimum1
5-th percentile7.2
Q132
median63
Q394
95-th percentile118.8
Maximum125
Range124
Interquartile range (IQR)62

Descriptive statistics

Standard deviation36.228442
Coefficient of variation (CV)0.57505463
Kurtosis-1.2
Mean63
Median Absolute Deviation (MAD)31
Skewness0
Sum7875
Variance1312.5
MonotonicityStrictly increasing
2024-04-06T17:05:59.035362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.8%
80 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%
86 1
 
0.8%
Other values (115) 115
92.0%
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 (%)
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%
116 1
0.8%

관할기관
Text

UNIQUE 

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

Length

Max length13
Median length4
Mean length5.472
Min length3

Characters and Unicode

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

Unique125 ?
Unique (%)100.0%

Sample

1st row내당1동 행정복지센터
2nd row내당2.3동 행정복지센터
3rd row내당4동 행정복지센터
4th row비산1동 행정복지센터
5th row비산2.3동 행정복지센터
ValueCountFrequency (%)
행정복지센터 17
 
11.3%
메디팜 3
 
2.0%
달성약국 2
 
1.3%
서대구약국 2
 
1.3%
내당1동 1
 
0.7%
수약국 1
 
0.7%
추계약국 1
 
0.7%
평리약국 1
 
0.7%
명성약국 1
 
0.7%
하나약국 1
 
0.7%
Other values (120) 120
80.0%
2024-04-06T17:06:00.442246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
국 108
 
15.8%
약 107
 
15.6%
25
 
3.7%
동 21
 
3.1%
행 19
 
2.8%
정 19
 
2.8%
복 18
 
2.6%
지 18
 
2.6%
센 17
 
2.5%
터 17
 
2.5%
Other values (121) 315
46.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 640
93.6%
Space Separator 25
 
3.7%
Decimal Number 17
 
2.5%
Other Punctuation 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
국 108
 
16.9%
약 107
 
16.7%
동 21
 
3.3%
행 19
 
3.0%
정 19
 
3.0%
복 18
 
2.8%
지 18
 
2.8%
센 17
 
2.7%
터 17
 
2.7%
리 16
 
2.5%
Other values (112) 280
43.8%
Decimal Number
ValueCountFrequency (%)
1 3
17.6%
4 3
17.6%
2 3
17.6%
3 3
17.6%
5 2
11.8%
6 2
11.8%
7 1
 
5.9%
Space Separator
ValueCountFrequency (%)
25
100.0%
Other Punctuation
ValueCountFrequency (%)
. 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 640
93.6%
Common 44
 
6.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
국 108
 
16.9%
약 107
 
16.7%
동 21
 
3.3%
행 19
 
3.0%
정 19
 
3.0%
복 18
 
2.8%
지 18
 
2.8%
센 17
 
2.7%
터 17
 
2.7%
리 16
 
2.5%
Other values (112) 280
43.8%
Common
ValueCountFrequency (%)
25
56.8%
1 3
 
6.8%
4 3
 
6.8%
2 3
 
6.8%
3 3
 
6.8%
. 2
 
4.5%
5 2
 
4.5%
6 2
 
4.5%
7 1
 
2.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 640
93.6%
ASCII 44
 
6.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
국 108
 
16.9%
약 107
 
16.7%
동 21
 
3.3%
행 19
 
3.0%
정 19
 
3.0%
복 18
 
2.8%
지 18
 
2.8%
센 17
 
2.7%
터 17
 
2.7%
리 16
 
2.5%
Other values (112) 280
43.8%
ASCII
ValueCountFrequency (%)
25
56.8%
1 3
 
6.8%
4 3
 
6.8%
2 3
 
6.8%
3 3
 
6.8%
. 2
 
4.5%
5 2
 
4.5%
6 2
 
4.5%
7 1
 
2.3%

도로명주소
Text

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

Length

Max length49
Median length43
Mean length25.496
Min length18

Characters and Unicode

Total characters3187
Distinct characters81
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique123 ?
Unique (%)98.4%

Sample

1st row대구광역시 서구 서대구로4길 35(내당동)
2nd row대구광역시 서구 큰장로15길 11-1(내당동)
3rd row대구광역시 서구 서대구로3길 46(내당동)
4th row대구광역시 서구 북비산로65길 18(비산동)
5th row대구광역시 서구 국채보상로81길 43(비산동)
ValueCountFrequency (%)
대구광역시 125
19.1%
서구 125
19.1%
비산동 36
 
5.5%
평리동 35
 
5.3%
국채보상로 21
 
3.2%
내당동 20
 
3.1%
1층 20
 
3.1%
달서로 15
 
2.3%
달구벌대로 9
 
1.4%
중리동 9
 
1.4%
Other values (176) 240
36.6%
2024-04-06T17:06:02.458903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
533
16.7%
구 277
 
8.7%
대 163
 
5.1%
서 159
 
5.0%
동 129
 
4.0%
역 127
 
4.0%
1 126
 
4.0%
시 125
 
3.9%
광 125
 
3.9%
로 125
 
3.9%
Other values (71) 1298
40.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1869
58.6%
Space Separator 533
 
16.7%
Decimal Number 486
 
15.2%
Open Punctuation 124
 
3.9%
Close Punctuation 124
 
3.9%
Other Punctuation 38
 
1.2%
Dash Punctuation 12
 
0.4%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 277
14.8%
대 163
 
8.7%
서 159
 
8.5%
동 129
 
6.9%
역 127
 
6.8%
시 125
 
6.7%
광 125
 
6.7%
로 125
 
6.7%
리 64
 
3.4%
산 55
 
2.9%
Other values (55) 520
27.8%
Decimal Number
ValueCountFrequency (%)
1 126
25.9%
3 55
11.3%
2 50
 
10.3%
6 45
 
9.3%
4 45
 
9.3%
5 40
 
8.2%
0 37
 
7.6%
7 36
 
7.4%
8 32
 
6.6%
9 20
 
4.1%
Space Separator
ValueCountFrequency (%)
533
100.0%
Open Punctuation
ValueCountFrequency (%)
( 124
100.0%
Close Punctuation
ValueCountFrequency (%)
) 124
100.0%
Other Punctuation
ValueCountFrequency (%)
, 38
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 12
100.0%
Uppercase Letter
ValueCountFrequency (%)
M 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1869
58.6%
Common 1317
41.3%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 277
14.8%
대 163
 
8.7%
서 159
 
8.5%
동 129
 
6.9%
역 127
 
6.8%
시 125
 
6.7%
광 125
 
6.7%
로 125
 
6.7%
리 64
 
3.4%
산 55
 
2.9%
Other values (55) 520
27.8%
Common
ValueCountFrequency (%)
533
40.5%
1 126
 
9.6%
( 124
 
9.4%
) 124
 
9.4%
3 55
 
4.2%
2 50
 
3.8%
6 45
 
3.4%
4 45
 
3.4%
5 40
 
3.0%
, 38
 
2.9%
Other values (5) 137
 
10.4%
Latin
ValueCountFrequency (%)
M 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1869
58.6%
ASCII 1318
41.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
533
40.4%
1 126
 
9.6%
( 124
 
9.4%
) 124
 
9.4%
3 55
 
4.2%
2 50
 
3.8%
6 45
 
3.4%
4 45
 
3.4%
5 40
 
3.0%
, 38
 
2.9%
Other values (6) 138
 
10.5%
Hangul
ValueCountFrequency (%)
구 277
14.8%
대 163
 
8.7%
서 159
 
8.5%
동 129
 
6.9%
역 127
 
6.8%
시 125
 
6.7%
광 125
 
6.7%
로 125
 
6.7%
리 64
 
3.4%
산 55
 
2.9%
Other values (55) 520
27.8%

전화번호
Text

UNIQUE 

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

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique125 ?
Unique (%)100.0%

Sample

1st row053-663-3301
2nd row053-663-3302
3rd row053-663-3303
4th row053-663-3304
5th row053-663-3305
ValueCountFrequency (%)
053-663-3301 1
 
0.8%
053-525-6677 1
 
0.8%
053-553-5793 1
 
0.8%
053-563-1717 1
 
0.8%
053-352-0660 1
 
0.8%
053-522-4398 1
 
0.8%
053-357-6825 1
 
0.8%
053-527-5093 1
 
0.8%
053-557-0075 1
 
0.8%
053-521-0717 1
 
0.8%
Other values (115) 115
92.0%
2024-04-06T17:06:03.749146image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 338
22.5%
3 253
16.9%
- 250
16.7%
0 189
12.6%
6 102
 
6.8%
7 88
 
5.9%
2 84
 
5.6%
1 70
 
4.7%
4 49
 
3.3%
8 44
 
2.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1250
83.3%
Dash Punctuation 250
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 338
27.0%
3 253
20.2%
0 189
15.1%
6 102
 
8.2%
7 88
 
7.0%
2 84
 
6.7%
1 70
 
5.6%
4 49
 
3.9%
8 44
 
3.5%
9 33
 
2.6%
Dash Punctuation
ValueCountFrequency (%)
- 250
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1500
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 338
22.5%
3 253
16.9%
- 250
16.7%
0 189
12.6%
6 102
 
6.8%
7 88
 
5.9%
2 84
 
5.6%
1 70
 
4.7%
4 49
 
3.3%
8 44
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1500
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 338
22.5%
3 253
16.9%
- 250
16.7%
0 189
12.6%
6 102
 
6.8%
7 88
 
5.9%
2 84
 
5.6%
1 70
 
4.7%
4 49
 
3.3%
8 44
 
2.9%

비고
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing124
Missing (%)99.2%
Memory size1.1 KiB
2024-04-06T17:06:03.990097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length4
Mean length4
Min length4

Characters and Unicode

Total characters4
Distinct characters4
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

Unique1 ?
Unique (%)100.0%

Sample

1st row임시청사
ValueCountFrequency (%)
임시청사 1
100.0%
2024-04-06T17:06:04.508612image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
임 1
25.0%
시 1
25.0%
청 1
25.0%
사 1
25.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
임 1
25.0%
시 1
25.0%
청 1
25.0%
사 1
25.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
임 1
25.0%
시 1
25.0%
청 1
25.0%
사 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
임 1
25.0%
시 1
25.0%
청 1
25.0%
사 1
25.0%

Interactions

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

Missing values

2024-04-06T17:05:58.318349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T17:05:58.565552image/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내당1동 행정복지센터대구광역시 서구 서대구로4길 35(내당동)053-663-3301<NA>
12내당2.3동 행정복지센터대구광역시 서구 큰장로15길 11-1(내당동)053-663-3302<NA>
23내당4동 행정복지센터대구광역시 서구 서대구로3길 46(내당동)053-663-3303<NA>
34비산1동 행정복지센터대구광역시 서구 북비산로65길 18(비산동)053-663-3304<NA>
45비산2.3동 행정복지센터대구광역시 서구 국채보상로81길 43(비산동)053-663-3305<NA>
56비산4동 행정복지센터대구광역시 서구 국채보상로78길 29-4(비산동)053-663-3306<NA>
67비산5동 행정복지센터대구광역시 서구 달서천로65길 17(비산동)053-663-3307<NA>
78비산6동 행정복지센터대구광역시 서구 문화로67길 3(비산동)053-663-3308<NA>
89비산7동 행정복지센터대구광역시 서구 염색공단로5길 4(비산동)053-663-3309<NA>
910평리1동 행정복지센터대구광역시 서구 문화로 280(평리동)053-663-3310<NA>
연번관할기관도로명주소전화번호비고
115116유창약국대구광역시 서구 서대구로 304 (비산동)053-357-0463<NA>
116117건강당약국대구광역시 서구 문화로 300-1 (평리동)053-553-5007<NA>
117118우성약국대구광역시 서구 북비산로 319-1 (비산동)053-552-7551<NA>
118119동화약국대구광역시 서구 평리로55길 17 (평리동)053-567-4884<NA>
119120천우당약국대구광역시 서구 달서로 76 (비산동)053-571-0390<NA>
120121보성약국대구광역시 서구 북비산로74길 46 (비산동)053-554-3643<NA>
121122희온누리약국대구광역시 서구 평리로 236, 111호 (내당동)053-556-0079<NA>
122123경명약국대구광역시 서구 달서천로49길 15 (비산동)053-355-7255<NA>
123124세일약국대구광역시 서구 달서천로41길 66-4 (비산동)053-357-1279<NA>
124125봉산약국대구광역시 서구 북비산로74길 8-1 (비산동)053-554-6598<NA>