Overview

Dataset statistics

Number of variables5
Number of observations1578
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory64.9 KiB
Average record size in memory42.1 B

Variable types

Categorical4
Numeric1

Dataset

Description광주광역시 서구 관급봉투관리시스템의 종량제봉투(납부필증) 제작관리에 관한 정보입니다.
Author광주광역시 서구
URLhttps://www.data.go.kr/data/15039803/fileData.do

Alerts

기관명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
발주바코드 has unique valuesUnique

Reproduction

Analysis started2023-12-11 23:31:07.005674
Analysis finished2023-12-11 23:31:07.459315
Duration0.45 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size12.5 KiB
서구청
1578 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
서구청 1578
100.0%

Length

2023-12-12T08:31:07.796219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T08:31:07.888885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서구청 1578
100.0%

발주바코드
Real number (ℝ)

UNIQUE 

Distinct1578
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean51106.479
Minimum12
Maximum99983
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size14.0 KiB
2023-12-12T08:31:07.985946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum12
5-th percentile3243.85
Q124103.25
median54610
Q378363.75
95-th percentile96211.15
Maximum99983
Range99971
Interquartile range (IQR)54260.5

Descriptive statistics

Standard deviation30386.461
Coefficient of variation (CV)0.59457159
Kurtosis-1.2631762
Mean51106.479
Median Absolute Deviation (MAD)26905.5
Skewness-0.075570515
Sum80646024
Variance9.2333699 × 108
MonotonicityNot monotonic
2023-12-12T08:31:08.118127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99930 1
 
0.1%
74656 1
 
0.1%
85568 1
 
0.1%
85567 1
 
0.1%
85566 1
 
0.1%
93344 1
 
0.1%
93343 1
 
0.1%
93342 1
 
0.1%
68027 1
 
0.1%
68026 1
 
0.1%
Other values (1568) 1568
99.4%
ValueCountFrequency (%)
12 1
0.1%
13 1
0.1%
14 1
0.1%
21 1
0.1%
22 1
0.1%
23 1
0.1%
30 1
0.1%
31 1
0.1%
32 1
0.1%
42 1
0.1%
ValueCountFrequency (%)
99983 1
0.1%
99982 1
0.1%
99981 1
0.1%
99980 1
0.1%
99979 1
0.1%
99978 1
0.1%
99953 1
0.1%
99952 1
0.1%
99951 1
0.1%
99947 1
0.1%

봉투코드
Categorical

Distinct3
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size12.5 KiB
1
526 
2
526 
3
526 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row2
3rd row3
4th row1
5th row2

Common Values

ValueCountFrequency (%)
1 526
33.3%
2 526
33.3%
3 526
33.3%

Length

2023-12-12T08:31:08.237469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T08:31:08.336052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 526
33.3%
2 526
33.3%
3 526
33.3%

봉투구분
Categorical

Distinct17
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size12.5 KiB
20리터
240 
10리터
195 
50리터
192 
100리터
189 
30리터
183 
Other values (12)
579 

Length

Max length9
Median length4
Mean length4.6577947
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row공공용50
2nd row공공용50
3rd row공공용50
4th row공공용50
5th row공공용50

Common Values

ValueCountFrequency (%)
20리터 240
15.2%
10리터 195
12.4%
50리터 192
12.2%
100리터 189
12.0%
30리터 183
11.6%
5리터 132
8.4%
75리터 105
6.7%
재사용20리터 96
 
6.1%
음식물3리터 45
 
2.9%
음식물20리터 42
 
2.7%
Other values (7) 159
10.1%

Length

2023-12-12T08:31:08.436473image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
20리터 240
15.2%
10리터 195
12.4%
50리터 192
12.2%
100리터 189
12.0%
30리터 183
11.6%
5리터 132
8.4%
75리터 105
6.7%
재사용20리터 96
 
6.1%
음식물3리터 45
 
2.9%
음식물20리터 42
 
2.7%
Other values (7) 159
10.1%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size12.5 KiB
2021-01-07
1578 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-01-07
2nd row2021-01-07
3rd row2021-01-07
4th row2021-01-07
5th row2021-01-07

Common Values

ValueCountFrequency (%)
2021-01-07 1578
100.0%

Length

2023-12-12T08:31:08.556476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T08:31:08.663252image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-01-07 1578
100.0%

Interactions

2023-12-12T08:31:07.149961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T08:31:08.724493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
발주바코드봉투코드봉투구분
발주바코드1.0000.0000.339
봉투코드0.0001.0000.000
봉투구분0.3390.0001.000
2023-12-12T08:31:08.804213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
봉투코드봉투구분
봉투코드1.0000.000
봉투구분0.0001.000
2023-12-12T08:31:08.893978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
발주바코드봉투코드봉투구분
발주바코드1.0000.0000.139
봉투코드0.0001.0000.000
봉투구분0.1390.0001.000

Missing values

2023-12-12T08:31:07.293306image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T08:31:07.410086image/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서구청999301공공용502021-01-07
1서구청999312공공용502021-01-07
2서구청999323공공용502021-01-07
3서구청999331공공용502021-01-07
4서구청999342공공용502021-01-07
5서구청999353공공용502021-01-07
6서구청999781공공용502021-01-07
7서구청999792공공용502021-01-07
8서구청999803공공용502021-01-07
9서구청121261공공용502021-01-07
기관명발주바코드봉투코드봉투구분데이터기준일자
1568서구청305843재사용5리터2021-01-07
1569서구청668311재사용5리터2021-01-07
1570서구청668322재사용5리터2021-01-07
1571서구청668333재사용5리터2021-01-07
1572서구청79351재사용5리터2021-01-07
1573서구청79362재사용5리터2021-01-07
1574서구청79373재사용5리터2021-01-07
1575서구청166051재사용5리터2021-01-07
1576서구청166062재사용5리터2021-01-07
1577서구청166073재사용5리터2021-01-07