Overview

Dataset statistics

Number of variables9
Number of observations1878
Missing cells9
Missing cells (%)0.1%
Duplicate rows9
Duplicate rows (%)0.5%
Total size in memory134.0 KiB
Average record size in memory73.1 B

Variable types

Text1
Categorical6
DateTime1
Numeric1

Dataset

Description대구광역시 달성군 내에 대형폐기물 수거 현황과 관련되 데이터로 수거일자, 폐기물구분, 폐기물명(개수), 수거장소 등의 데이터를 포함하고 있습니다.
Author대구광역시 달성군
URLhttps://www.data.go.kr/data/15093678/fileData.do

Alerts

전화번호 has constant value ""Constant
관리기관 has constant value ""Constant
폐기물 구분 has constant value ""Constant
폐기물 규격 has constant value ""Constant
데이터기준일자 has constant value ""Constant
Dataset has 9 (0.5%) duplicate rowsDuplicates

Reproduction

Analysis started2024-04-06 08:50:46.754799
Analysis finished2024-04-06 08:50:48.959995
Duration2.21 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

대형폐기물명(개수)
Text

Distinct829
Distinct (%)44.1%
Missing0
Missing (%)0.0%
Memory size14.8 KiB
2024-04-06T17:50:50.021429image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length84
Median length78
Mean length14.207668
Min length5

Characters and Unicode

Total characters26682
Distinct characters203
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique689 ?
Unique (%)36.7%

Sample

1st row침대(1)
2nd row쇼파(2)
3rd row냉장고(1),청소기(1)
4th row의자(1)
5th row장식장(1),가방류(1)
ValueCountFrequency (%)
침대(1 211
 
10.1%
의자(1 130
 
6.2%
침대(1),침대(1 62
 
3.0%
등(1 52
 
2.5%
서랍장(1 41
 
2.0%
전기담요 37
 
1.8%
쇼파(1 36
 
1.7%
의자(일반의자)(1 36
 
1.7%
책상(1 29
 
1.4%
이불 29
 
1.4%
Other values (854) 1427
68.3%
2024-04-06T17:50:51.136865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
( 4438
16.6%
) 4438
16.6%
1 3231
12.1%
, 2140
 
8.0%
자 885
 
3.3%
장 831
 
3.1%
대 810
 
3.0%
침 710
 
2.7%
의 705
 
2.6%
파 492
 
1.8%
Other values (193) 8002
30.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 11238
42.1%
Open Punctuation 4438
 
16.6%
Close Punctuation 4438
 
16.6%
Decimal Number 3995
 
15.0%
Other Punctuation 2280
 
8.5%
Space Separator 212
 
0.8%
Uppercase Letter 81
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
자 885
 
7.9%
장 831
 
7.4%
대 810
 
7.2%
침 710
 
6.3%
의 705
 
6.3%
파 492
 
4.4%
쇼 484
 
4.3%
책 407
 
3.6%
기 373
 
3.3%
상 280
 
2.5%
Other values (172) 5261
46.8%
Decimal Number
ValueCountFrequency (%)
1 3231
80.9%
2 464
 
11.6%
3 134
 
3.4%
4 63
 
1.6%
5 32
 
0.8%
9 22
 
0.6%
0 19
 
0.5%
6 15
 
0.4%
8 10
 
0.3%
7 5
 
0.1%
Uppercase Letter
ValueCountFrequency (%)
V 33
40.7%
T 33
40.7%
R 5
 
6.2%
F 5
 
6.2%
P 5
 
6.2%
Other Punctuation
ValueCountFrequency (%)
, 2140
93.9%
· 97
 
4.3%
. 43
 
1.9%
Open Punctuation
ValueCountFrequency (%)
( 4438
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4438
100.0%
Space Separator
ValueCountFrequency (%)
212
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 15363
57.6%
Hangul 11238
42.1%
Latin 81
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
자 885
 
7.9%
장 831
 
7.4%
대 810
 
7.2%
침 710
 
6.3%
의 705
 
6.3%
파 492
 
4.4%
쇼 484
 
4.3%
책 407
 
3.6%
기 373
 
3.3%
상 280
 
2.5%
Other values (172) 5261
46.8%
Common
ValueCountFrequency (%)
( 4438
28.9%
) 4438
28.9%
1 3231
21.0%
, 2140
13.9%
2 464
 
3.0%
212
 
1.4%
3 134
 
0.9%
· 97
 
0.6%
4 63
 
0.4%
. 43
 
0.3%
Other values (6) 103
 
0.7%
Latin
ValueCountFrequency (%)
V 33
40.7%
T 33
40.7%
R 5
 
6.2%
F 5
 
6.2%
P 5
 
6.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 15347
57.5%
Hangul 11238
42.1%
None 97
 
0.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
( 4438
28.9%
) 4438
28.9%
1 3231
21.1%
, 2140
13.9%
2 464
 
3.0%
212
 
1.4%
3 134
 
0.9%
4 63
 
0.4%
. 43
 
0.3%
V 33
 
0.2%
Other values (10) 151
 
1.0%
Hangul
ValueCountFrequency (%)
자 885
 
7.9%
장 831
 
7.4%
대 810
 
7.2%
침 710
 
6.3%
의 705
 
6.3%
파 492
 
4.4%
쇼 484
 
4.3%
책 407
 
3.6%
기 373
 
3.3%
상 280
 
2.5%
Other values (172) 5261
46.8%
None
ValueCountFrequency (%)
· 97
100.0%

수거지역
Categorical

Distinct12
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size14.8 KiB
다사읍
367 
화원읍
364 
현풍읍
318 
다사읍서재출장소
219 
유가읍
162 
Other values (7)
448 

Length

Max length8
Median length3
Mean length3.8791267
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row유가읍
2nd row다사읍서재출장소
3rd row다사읍
4th row<NA>
5th row유가읍

Common Values

ValueCountFrequency (%)
다사읍 367
19.5%
화원읍 364
19.4%
현풍읍 318
16.9%
다사읍서재출장소 219
11.7%
유가읍 162
8.6%
논공읍공단출장소 98
 
5.2%
옥포읍 81
 
4.3%
<NA> 66
 
3.5%
가창면 62
 
3.3%
구지면 62
 
3.3%
Other values (2) 79
 
4.2%

Length

2024-04-06T17:50:51.581904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
다사읍 367
19.5%
화원읍 364
19.4%
현풍읍 318
16.9%
다사읍서재출장소 219
11.7%
유가읍 162
8.6%
논공읍공단출장소 98
 
5.2%
옥포읍 81
 
4.3%
na 66
 
3.5%
가창면 62
 
3.3%
구지면 62
 
3.3%
Other values (2) 79
 
4.2%

전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size14.8 KiB
053-668-2714
1878 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row053-668-2714
2nd row053-668-2714
3rd row053-668-2714
4th row053-668-2714
5th row053-668-2714

Common Values

ValueCountFrequency (%)
053-668-2714 1878
100.0%

Length

2024-04-06T17:50:51.913968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:50:52.240839image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
053-668-2714 1878
100.0%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size14.8 KiB
청소위생과
1878 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row청소위생과
2nd row청소위생과
3rd row청소위생과
4th row청소위생과
5th row청소위생과

Common Values

ValueCountFrequency (%)
청소위생과 1878
100.0%

Length

2024-04-06T17:50:52.579073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:50:52.864639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
청소위생과 1878
100.0%

폐기물 구분
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size14.8 KiB
기타
1878 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row기타
2nd row기타
3rd row기타
4th row기타
5th row기타

Common Values

ValueCountFrequency (%)
기타 1878
100.0%

Length

2024-04-06T17:50:53.199927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:50:53.492813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기타 1878
100.0%

폐기물 규격
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size14.8 KiB
기타
1878 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row기타
2nd row기타
3rd row기타
4th row기타
5th row기타

Common Values

ValueCountFrequency (%)
기타 1878
100.0%

Length

2024-04-06T17:50:53.768507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:50:54.152573image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기타 1878
100.0%

수거일자
Date

Distinct970
Distinct (%)51.7%
Missing0
Missing (%)0.0%
Memory size14.8 KiB
Minimum2019-11-01 00:00:00
Maximum2023-12-30 00:00:00
2024-04-06T17:50:54.513862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:50:54.920760image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

수수료
Real number (ℝ)

Distinct68
Distinct (%)3.6%
Missing9
Missing (%)0.5%
Infinite0
Infinite (%)0.0%
Mean10059.39
Minimum1000
Maximum126000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size16.6 KiB
2024-04-06T17:50:55.363469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1000
5-th percentile2000
Q14000
median6000
Q312000
95-th percentile29000
Maximum126000
Range125000
Interquartile range (IQR)8000

Descriptive statistics

Standard deviation11523.052
Coefficient of variation (CV)1.1455021
Kurtosis25.952995
Mean10059.39
Median Absolute Deviation (MAD)3000
Skewness4.0576368
Sum18801000
Variance1.3278073 × 108
MonotonicityNot monotonic
2024-04-06T17:50:55.786228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
5000 245
13.0%
2000 235
12.5%
7000 155
 
8.3%
6000 154
 
8.2%
3000 137
 
7.3%
4000 129
 
6.9%
10000 104
 
5.5%
13000 74
 
3.9%
8000 66
 
3.5%
9000 58
 
3.1%
Other values (58) 512
27.3%
ValueCountFrequency (%)
1000 44
 
2.3%
2000 235
12.5%
3000 137
7.3%
4000 129
6.9%
5000 245
13.0%
6000 154
8.2%
7000 155
8.3%
8000 66
 
3.5%
9000 58
 
3.1%
10000 104
5.5%
ValueCountFrequency (%)
126000 1
0.1%
124000 1
0.1%
120000 1
0.1%
112000 1
0.1%
110000 1
0.1%
80000 1
0.1%
79000 1
0.1%
74000 1
0.1%
73000 1
0.1%
66000 1
0.1%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size14.8 KiB
2024-03-29
1878 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2024-03-29
2nd row2024-03-29
3rd row2024-03-29
4th row2024-03-29
5th row2024-03-29

Common Values

ValueCountFrequency (%)
2024-03-29 1878
100.0%

Length

2024-04-06T17:50:56.189509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:50:56.467280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2024-03-29 1878
100.0%

Interactions

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

Correlations

2024-04-06T17:50:56.676844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수거지역수수료
수거지역1.0000.086
수수료0.0861.000
2024-04-06T17:50:56.903327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수수료수거지역
수수료1.0000.036
수거지역0.0361.000

Missing values

2024-04-06T17:50:48.076620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T17:50:48.630776image/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침대(1)유가읍053-668-2714청소위생과기타기타2019-11-0150002024-03-29
1쇼파(2)다사읍서재출장소053-668-2714청소위생과기타기타2019-11-0260002024-03-29
2냉장고(1),청소기(1)다사읍053-668-2714청소위생과기타기타2019-11-0470002024-03-29
3의자(1)<NA>053-668-2714청소위생과기타기타2019-11-0820002024-03-29
4장식장(1),가방류(1)유가읍053-668-2714청소위생과기타기타2019-11-1150002024-03-29
5식탁(1),항아리(2),책장(책꽂이)(2),책상(1),책상(1),쇼파(2),쇼파(1),서랍장(4),의자(1),장식장(1)화원읍053-668-2714청소위생과기타기타2019-11-11520002024-03-29
6의자(1)다사읍053-668-2714청소위생과기타기타2019-11-1420002024-03-29
7의자(1)다사읍053-668-2714청소위생과기타기타2019-11-1810002024-03-29
8쇼파(1),쇼파(1),쇼파(1),쇼파(1)유가읍053-668-2714청소위생과기타기타2019-11-1860002024-03-29
9침대(1),침대(1)다사읍053-668-2714청소위생과기타기타2019-11-18130002024-03-29
대형폐기물명(개수)수거지역전화번호관리기관폐기물 구분폐기물 규격수거일자수수료데이터기준일자
1868카펫(1),유리(1),가방류(1),쇼파(1),서랍장(1),복사기(1),의자(일반의자)(2)옥포읍053-668-2714청소위생과기타기타2023-12-25230002024-03-29
1869쇼파(1)옥포읍053-668-2714청소위생과기타기타2023-12-2560002024-03-29
1870의자(일반의자)(1),침대(1),문갑(원목)(4)화원읍053-668-2714청소위생과기타기타2023-12-26160002024-03-29
1871장판, 비닐, 천막(1),장판, 비닐, 천막(1)다사읍053-668-2714청소위생과기타기타2023-12-2740002024-03-29
1872장롱(3),침대(1),칠판(게시판)(1)현풍읍053-668-2714청소위생과기타기타2023-12-27390002024-03-29
1873책상(유리별도)(1)화원읍053-668-2714청소위생과기타기타2023-12-2840002024-03-29
1874쇼파(1),쇼파(1)화원읍053-668-2714청소위생과기타기타2023-12-2940002024-03-29
1875상(판)(1)현풍읍053-668-2714청소위생과기타기타2023-12-2920002024-03-29
1876책상(유리별도)(1)다사읍053-668-2714청소위생과기타기타2023-12-2940002024-03-29
1877전기담요 등(2)화원읍053-668-2714청소위생과기타기타2023-12-3040002024-03-29

Duplicate rows

Most frequently occurring

대형폐기물명(개수)수거지역전화번호관리기관폐기물 구분폐기물 규격수거일자수수료데이터기준일자# duplicates
6침대(1)현풍읍053-668-2714청소위생과기타기타2021-10-1850002024-03-294
2식탁(1)다사읍053-668-2714청소위생과기타기타2021-10-0340002024-03-293
0쇼파(1),쇼파(1)논공읍053-668-2714청소위생과기타기타2021-10-0840002024-03-292
1식탁(1)논공읍공단출장소053-668-2714청소위생과기타기타2021-10-2050002024-03-292
3옷걸이(1),의자(1),의자(1),거울·액자(1),상(판)(5),전기담요 등(1)다사읍053-668-2714청소위생과기타기타2021-09-27190002024-03-292
4의자(1)화원읍053-668-2714청소위생과기타기타2021-12-3020002024-03-292
5이불 등(1)다사읍053-668-2714청소위생과기타기타2023-02-1820002024-03-292
7침대(1)현풍읍053-668-2714청소위생과기타기타2021-10-2450002024-03-292
8침대(1)현풍읍053-668-2714청소위생과기타기타2023-11-1750002024-03-292