Overview

Dataset statistics

Number of variables10
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.6 KiB
Average record size in memory89.4 B

Variable types

Numeric2
Categorical8

Dataset

Description인천광역시 중구 관내에 위치한 쓰레기종량제봉투 입출고재고 현황에 대한 데이터 입니다.파일명 인천광역시_중구_쓰레기종량제봉투 입출고재고 현황파일내용 군구코드, 군구명, 봉투종류 등
Author인천광역시 중구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15049360&srcSe=7661IVAWM27C61E190

Alerts

군구코드 has constant value ""Constant
군구명 has constant value ""Constant
재고수량 has constant value ""Constant
재고금액 has constant value ""Constant
데이터기준일자 has constant value ""Constant
수정일자 is highly overall correlated with 입력일자 and 1 other fieldsHigh correlation
입력일자 is highly overall correlated with 연번 and 3 other fieldsHigh correlation
수정구분 is highly overall correlated with 연번 and 2 other fieldsHigh correlation
연번 is highly overall correlated with 봉투종류 and 2 other fieldsHigh correlation
봉투종류 is highly overall correlated with 연번 and 1 other fieldsHigh correlation
연번 has unique valuesUnique
봉투종류 has unique valuesUnique

Reproduction

Analysis started2024-03-18 03:29:01.053266
Analysis finished2024-03-18 03:29:03.016276
Duration1.96 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15.5
Minimum1
Maximum30
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-03-18T12:29:03.092800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.45
Q18.25
median15.5
Q322.75
95-th percentile28.55
Maximum30
Range29
Interquartile range (IQR)14.5

Descriptive statistics

Standard deviation8.8034084
Coefficient of variation (CV)0.56796183
Kurtosis-1.2
Mean15.5
Median Absolute Deviation (MAD)7.5
Skewness0
Sum465
Variance77.5
MonotonicityStrictly increasing
2024-03-18T12:29:03.216937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
1 1
 
3.3%
17 1
 
3.3%
30 1
 
3.3%
29 1
 
3.3%
28 1
 
3.3%
27 1
 
3.3%
26 1
 
3.3%
25 1
 
3.3%
24 1
 
3.3%
23 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
1 1
3.3%
2 1
3.3%
3 1
3.3%
4 1
3.3%
5 1
3.3%
6 1
3.3%
7 1
3.3%
8 1
3.3%
9 1
3.3%
10 1
3.3%
ValueCountFrequency (%)
30 1
3.3%
29 1
3.3%
28 1
3.3%
27 1
3.3%
26 1
3.3%
25 1
3.3%
24 1
3.3%
23 1
3.3%
22 1
3.3%
21 1
3.3%

군구코드
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
110301
30 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
110301 30
100.0%

Length

2024-03-18T12:29:03.316760image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T12:29:03.402020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
110301 30
100.0%

군구명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
인천광역시 중구
30 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row인천광역시 중구
2nd row인천광역시 중구
3rd row인천광역시 중구
4th row인천광역시 중구
5th row인천광역시 중구

Common Values

ValueCountFrequency (%)
인천광역시 중구 30
100.0%

Length

2024-03-18T12:29:03.485724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T12:29:03.565582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
인천광역시 30
50.0%
중구 30
50.0%

봉투종류
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean45092.767
Minimum10122
Maximum80152
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-03-18T12:29:03.648814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10122
5-th percentile10141
Q118389.5
median51196
Q361124.5
95-th percentile70728
Maximum80152
Range70030
Interquartile range (IQR)42735

Descriptive statistics

Standard deviation22977.676
Coefficient of variation (CV)0.50956456
Kurtosis-1.0896137
Mean45092.767
Median Absolute Deviation (MAD)11009
Skewness-0.63607855
Sum1352783
Variance5.2797359 × 108
MonotonicityStrictly increasing
2024-03-18T12:29:03.747894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
10122 1
 
3.3%
60102 1
 
3.3%
80152 1
 
3.3%
70737 1
 
3.3%
70717 1
 
3.3%
64128 1
 
3.3%
63227 1
 
3.3%
62132 1
 
3.3%
62122 1
 
3.3%
61132 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
10122 1
3.3%
10132 1
3.3%
10152 1
3.3%
10172 1
3.3%
10192 1
3.3%
10202 1
3.3%
11122 1
3.3%
11132 1
3.3%
40162 1
3.3%
40172 1
3.3%
ValueCountFrequency (%)
80152 1
3.3%
70737 1
3.3%
70717 1
3.3%
64128 1
3.3%
63227 1
3.3%
62132 1
3.3%
62122 1
3.3%
61132 1
3.3%
61102 1
3.3%
60152 1
3.3%

재고수량
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
0
30 

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 30
100.0%

Length

2024-03-18T12:29:03.854426image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T12:29:03.926206image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 30
100.0%

재고금액
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
0
30 

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 30
100.0%

Length

2024-03-18T12:29:03.999244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T12:29:04.070842image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 30
100.0%

입력일자
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
2014-03-28
20 
<NA>
10 

Length

Max length10
Median length10
Mean length8
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2014-03-28
2nd row2014-03-28
3rd row2014-03-28
4th row2014-03-28
5th row2014-03-28

Common Values

ValueCountFrequency (%)
2014-03-28 20
66.7%
<NA> 10
33.3%

Length

2024-03-18T12:29:04.153861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T12:29:04.235800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2014-03-28 20
66.7%
na 10
33.3%

수정일자
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)33.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2017-07-13
12 
2022-06-28
6 
2014-03-28
3 
2021-08-03
3 
2021-05-18
 
1
Other values (5)
5 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique6 ?
Unique (%)20.0%

Sample

1st row2017-07-13
2nd row2021-05-18
3rd row2023-03-13
4th row2021-04-12
5th row2017-07-13

Common Values

ValueCountFrequency (%)
2017-07-13 12
40.0%
2022-06-28 6
20.0%
2014-03-28 3
 
10.0%
2021-08-03 3
 
10.0%
2021-05-18 1
 
3.3%
2023-03-13 1
 
3.3%
2021-04-12 1
 
3.3%
2019-03-14 1
 
3.3%
2018-12-12 1
 
3.3%
2017-07-04 1
 
3.3%

Length

2024-03-18T12:29:04.318329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T12:29:04.422588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2017-07-13 12
40.0%
2022-06-28 6
20.0%
2014-03-28 3
 
10.0%
2021-08-03 3
 
10.0%
2021-05-18 1
 
3.3%
2023-03-13 1
 
3.3%
2021-04-12 1
 
3.3%
2019-03-14 1
 
3.3%
2018-12-12 1
 
3.3%
2017-07-04 1
 
3.3%

수정구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
M
20 
I
10 

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 (%)
M 20
66.7%
I 10
33.3%

Length

2024-03-18T12:29:04.536561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T12:29:04.644626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
m 20
66.7%
i 10
33.3%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-08-29
30 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-08-29
2nd row2023-08-29
3rd row2023-08-29
4th row2023-08-29
5th row2023-08-29

Common Values

ValueCountFrequency (%)
2023-08-29 30
100.0%

Length

2024-03-18T12:29:04.743482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T12:29:04.820659image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-08-29 30
100.0%

Interactions

2024-03-18T12:29:02.619096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:29:02.170829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:29:02.687610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:29:02.343865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-18T12:29:04.870874image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번봉투종류수정일자수정구분
연번1.0000.8580.7280.914
봉투종류0.8581.0000.7300.154
수정일자0.7280.7301.0000.952
수정구분0.9140.1540.9521.000
2024-03-18T12:29:04.967231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수정일자입력일자수정구분
수정일자1.0001.0000.684
입력일자1.0001.0001.000
수정구분0.6841.0001.000
2024-03-18T12:29:05.067090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번봉투종류입력일자수정일자수정구분
연번1.0001.0001.0000.2790.635
봉투종류1.0001.0001.0000.4380.118
입력일자1.0001.0001.0001.0001.000
수정일자0.2790.4381.0001.0000.684
수정구분0.6350.1181.0000.6841.000

Missing values

2024-03-18T12:29:02.805741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-18T12:29:02.943250image/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

연번군구코드군구명봉투종류재고수량재고금액입력일자수정일자수정구분데이터기준일자
01110301인천광역시 중구10122002014-03-282017-07-13M2023-08-29
12110301인천광역시 중구10132002014-03-282021-05-18M2023-08-29
23110301인천광역시 중구10152002014-03-282023-03-13M2023-08-29
34110301인천광역시 중구10172002014-03-282021-04-12M2023-08-29
45110301인천광역시 중구10192002014-03-282017-07-13M2023-08-29
56110301인천광역시 중구10202002014-03-282017-07-13M2023-08-29
67110301인천광역시 중구1112200<NA>2022-06-28I2023-08-29
78110301인천광역시 중구1113200<NA>2022-06-28I2023-08-29
89110301인천광역시 중구40162002014-03-282017-07-13M2023-08-29
910110301인천광역시 중구40172002014-03-282019-03-14M2023-08-29
연번군구코드군구명봉투종류재고수량재고금액입력일자수정일자수정구분데이터기준일자
2021110301인천광역시 중구60152002014-03-282017-07-13M2023-08-29
2122110301인천광역시 중구6110200<NA>2022-06-28I2023-08-29
2223110301인천광역시 중구6113200<NA>2022-06-28I2023-08-29
2324110301인천광역시 중구6212200<NA>2022-06-28I2023-08-29
2425110301인천광역시 중구6213200<NA>2022-06-28I2023-08-29
2526110301인천광역시 중구6322700<NA>2018-12-12I2023-08-29
2627110301인천광역시 중구6412800<NA>2017-07-13I2023-08-29
2728110301인천광역시 중구70717002014-03-282017-07-04M2023-08-29
2829110301인천광역시 중구70737002014-03-282017-07-13M2023-08-29
2930110301인천광역시 중구80152002014-03-282014-03-28M2023-08-29