Overview

Dataset statistics

Number of variables7
Number of observations236
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory13.3 KiB
Average record size in memory57.5 B

Variable types

Categorical6
DateTime1

Dataset

Description인천광역시 서구 쓰레기종량제봉투 입출고재고 현황에 대한 데이터로 군구명, 봉투종류, 재고수량, 재고금액 등의 정보가 포함되어 있습니다.
Author인천광역시 서구
URLhttps://www.data.go.kr/data/15090786/fileData.do

Alerts

재고금액 has constant value ""Constant
데이터기준일자 has constant value ""Constant
군구명 is highly overall correlated with 군구코드High correlation
군구코드 is highly overall correlated with 군구명High correlation
봉투종류 is highly overall correlated with 수정구분High correlation
수정구분 is highly overall correlated with 봉투종류High correlation

Reproduction

Analysis started2024-03-14 10:52:59.412075
Analysis finished2024-03-14 10:53:00.473918
Duration1.06 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

군구코드
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)7.2%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
1서구청서구시설관리공단
38 
서구청
33 
1서구청검암경서동
 
11
1서구청연희동
 
11
1서구청가정1동
 
11
Other values (12)
132 

Length

Max length12
Median length8
Mean length7.9915254
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서구청
2nd row서구청
3rd row서구청
4th row서구청
5th row서구청

Common Values

ValueCountFrequency (%)
1서구청서구시설관리공단 38
16.1%
서구청 33
14.0%
1서구청검암경서동 11
 
4.7%
1서구청연희동 11
 
4.7%
1서구청가정1동 11
 
4.7%
1서구청가정2동 11
 
4.7%
1서구청가정3동 11
 
4.7%
1서구청신현원창동 11
 
4.7%
1서구청석남1동 11
 
4.7%
1서구청석남2동 11
 
4.7%
Other values (7) 77
32.6%

Length

2024-03-14T19:53:00.702846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
1서구청서구시설관리공단 38
16.1%
서구청 33
14.0%
1서구청석남2동 11
 
4.7%
1서구청석남3동 11
 
4.7%
1서구청검단1동 11
 
4.7%
1서구청가좌4동 11
 
4.7%
1서구청가좌3동 11
 
4.7%
1서구청가좌2동 11
 
4.7%
1서구청가좌1동 11
 
4.7%
1서구청석남1동 11
 
4.7%
Other values (7) 77
32.6%

군구명
Categorical

HIGH CORRELATION 

Distinct19
Distinct (%)8.1%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
서구시설관리공단
36 
서구청
33 
가정2동
19 
가좌3동
15 
가좌1동
15 
Other values (14)
118 

Length

Max length12
Median length4
Mean length4.6016949
Min length3

Unique

Unique1 ?
Unique (%)0.4%

Sample

1st row서구청
2nd row서구청
3rd row서구청
4th row서구청
5th row서구청

Common Values

ValueCountFrequency (%)
서구시설관리공단 36
15.3%
서구청 33
14.0%
가정2동 19
 
8.1%
가좌3동 15
 
6.4%
가좌1동 15
 
6.4%
신현원창동 11
 
4.7%
검단2동 11
 
4.7%
연희동 11
 
4.7%
가정1동 11
 
4.7%
석남3동 11
 
4.7%
Other values (9) 63
26.7%

Length

2024-03-14T19:53:01.045334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
서구시설관리공단 36
15.3%
서구청 33
14.0%
가정2동 19
 
8.1%
가좌3동 15
 
6.4%
가좌1동 15
 
6.4%
가정1동 11
 
4.7%
석남1동 11
 
4.7%
검암경서동 11
 
4.7%
석남3동 11
 
4.7%
연희동 11
 
4.7%
Other values (9) 63
26.7%

봉투종류
Categorical

HIGH CORRELATION 

Distinct39
Distinct (%)16.5%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
일반용 5L
17 
스티커 1000원권
17 
사업계용 125L
17 
일반용 50L
17 
일반용 100L
17 
Other values (34)
151 

Length

Max length12
Median length11
Mean length8.4915254
Min length5

Unique

Unique7 ?
Unique (%)3.0%

Sample

1st row일반용 5L
2nd row일반용 10L
3rd row일반용 20L
4th row일반용 50L
5th row일반용 100L

Common Values

ValueCountFrequency (%)
일반용 5L 17
 
7.2%
스티커 1000원권 17
 
7.2%
사업계용 125L 17
 
7.2%
일반용 50L 17
 
7.2%
일반용 100L 17
 
7.2%
사업계용 60L 17
 
7.2%
일반용 20L 17
 
7.2%
스티커 5000원권 17
 
7.2%
스티커 10000원권 17
 
7.2%
스티커 3000원권 17
 
7.2%
Other values (29) 66
28.0%

Length

2024-03-14T19:53:01.277635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
일반용 91
19.2%
스티커 69
14.6%
사업계용 36
 
7.6%
20l 21
 
4.4%
10l 21
 
4.4%
5l 20
 
4.2%
60l 19
 
4.0%
50l 19
 
4.0%
125l 17
 
3.6%
10000원권 17
 
3.6%
Other values (22) 143
30.2%

재고금액
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
0
236 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 236
100.0%

Length

2024-03-14T19:53:01.494408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T19:53:01.647237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 236
100.0%
Distinct57
Distinct (%)24.2%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
Minimum2003-01-29 00:00:00
Maximum2023-12-07 00:00:00
2024-03-14T19:53:01.917444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T19:53:02.340300image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

수정구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
I
134 
M
102 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowM
2nd rowM
3rd rowM
4th rowM
5th rowM

Common Values

ValueCountFrequency (%)
I 134
56.8%
M 102
43.2%

Length

2024-03-14T19:53:02.665989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T19:53:02.973215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
i 134
56.8%
m 102
43.2%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2023-12-06
236 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-12-06
2nd row2023-12-06
3rd row2023-12-06
4th row2023-12-06
5th row2023-12-06

Common Values

ValueCountFrequency (%)
2023-12-06 236
100.0%

Length

2024-03-14T19:53:03.143216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T19:53:03.294312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-12-06 236
100.0%

Correlations

2024-03-14T19:53:03.394453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
군구코드군구명봉투종류수정일자수정구분
군구코드1.0000.9920.0000.9770.144
군구명0.9921.0000.0000.9740.331
봉투종류0.0000.0001.0000.9470.914
수정일자0.9770.9740.9471.0000.548
수정구분0.1440.3310.9140.5481.000
2024-03-14T19:53:03.563701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수정구분군구명군구코드봉투종류
수정구분1.0000.2820.1240.764
군구명0.2821.0000.9230.000
군구코드0.1240.9231.0000.000
봉투종류0.7640.0000.0001.000
2024-03-14T19:53:03.732313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
군구코드군구명봉투종류수정구분
군구코드1.0000.9230.0000.124
군구명0.9231.0000.0000.282
봉투종류0.0000.0001.0000.764
수정구분0.1240.2820.7641.000

Missing values

2024-03-14T19:52:59.928558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T19:53:00.326430image/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서구청서구청일반용 5L02013-02-25M2023-12-06
1서구청서구청일반용 10L02023-06-19M2023-12-06
2서구청서구청일반용 20L02021-03-30M2023-12-06
3서구청서구청일반용 50L02021-04-20M2023-12-06
4서구청서구청일반용 100L02021-02-09M2023-12-06
51서구청검암경서동검암경서동일반용 5L02003-01-29M2023-12-06
61서구청검암경서동검암경서동일반용 10L02003-03-13M2023-12-06
71서구청검암경서동검암경서동일반용 20L02003-03-13M2023-12-06
81서구청검암경서동검암경서동일반용 50L02003-03-12M2023-12-06
91서구청검암경서동검암경서동일반용 100L02003-01-30M2023-12-06
군구코드군구명봉투종류재고금액수정일자수정구분데이터기준일자
2261서구청서구시설관리공단서구시설관리공단일반용 50L02023-12-07M2023-12-06
2271서구청서구시설관리공단서구시설관리공단일반용 100L02023-05-16M2023-12-06
2281서구청서구시설관리공단서구시설관리공단불연성 10L02023-12-07M2023-12-06
2291서구청서구시설관리공단서구시설관리공단불연성 20L02023-12-07M2023-12-06
2301서구청서구시설관리공단서구시설관리공단불연성 50L02023-12-07M2023-12-06
2311서구청서구시설관리공단서구시설관리공단사업계용 30L02023-12-07M2023-12-06
2321서구청서구시설관리공단서구시설관리공단사업계용 60L02023-12-07M2023-12-06
2331서구청서구시설관리공단서구시설관리공단사업계용 125L02023-11-18M2023-12-06
2341서구청서구시설관리공단서구시설관리공단음식물 20L(김장용)02023-12-07M2023-12-06
2351서구청서구시설관리공단서구시설관리공단필증 3L02023-12-07M2023-12-06