gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	42
Missing cells	15
Missing cells (%)	6.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.2 KiB
Average record size in memory	53.1 B

Variable types

Numeric	1
Categorical	1
DateTime	3
Boolean	1

Dataset

Description	전기전자제품및자동차의재활용시스템 내 부과징수 추가관리 정보를 제공(전자납부 번호, 업체 조사 순번, 업체 조사 일자, 휴폐업 일자, 말소 여부, 말소 일자)
Author	환경부
URL	https://www.data.go.kr/data/15092521/fileData.do

Alerts

`업체 조사 순번` is highly imbalanced (52.8%)	Imbalance
`휴폐업 일자` has 15 (35.7%) missing values	Missing

Reproduction

Analysis started	2024-04-17 10:54:39.788956
Analysis finished	2024-04-17 10:54:40.141126
Duration	0.35 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

전자납부 번호
Real number (ℝ)

Distinct	35
Distinct (%)	83.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.3427118 × 10¹⁷

Minimum	1.341508 × 10¹⁷
Maximum	1.3499162 × 10¹⁷
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	510.0 B

Quantile statistics

Minimum	1.341508 × 10¹⁷
5-th percentile	1.341508 × 10¹⁷
Q1	1.341509 × 10¹⁷
median	1.3415121 × 10¹⁷
Q3	1.3415149 × 10¹⁷
95-th percentile	1.3499142 × 10¹⁷
Maximum	1.3499162 × 10¹⁷
Range	8.40817 × 10¹⁴
Interquartile range (IQR)	5.9100151 × 10¹¹

Descriptive statistics

Standard deviation	2.9762606 × 10¹⁴
Coefficient of variation (CV)	0.0022166041
Kurtosis	2.6062971
Mean	1.3427118 × 10¹⁷
Median Absolute Deviation (MAD)	3.0300396 × 10¹¹
Skewness	2.1176315
Sum	5.6393897 × 10¹⁸
Variance	8.858127 × 10²⁸
Monotonicity	Increasing

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
134991416104172101	3	7.1%
134151314101472001	2	4.8%
134151314101551001	2	4.8%
134151314102843001	2	4.8%
134150900101250001	2	4.8%
134151213101710001	2	4.8%
134151516103749002	1	2.4%
134151415101984001	1	2.4%
134151415103654001	1	2.4%
134151416105181001	1	2.4%
Other values (25)	25	59.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
134150800100854001	1	2.4%
134150800101089001	1	2.4%
134150800101427001	1	2.4%
134150800101936001	1	2.4%
134150800101991001	1	2.4%
134150900100881001	1	2.4%
134150900100976001	1	2.4%
134150900101250001	2	4.8%
134150900101943001	1	2.4%
134150900102595001	1	2.4%

Value	Count	Frequency (%)
134991617104752003	1	2.4%
134991617104752002	1	2.4%
134991416104172101	3	7.1%
134991415104796102	1	2.4%
134151617102947002	1	2.4%
134151516106279006	1	2.4%
134151516105674003	1	2.4%
134151516105674002	1	2.4%
134151516103749002	1	2.4%
134151416105181001	1	2.4%

업체 조사 순번
Categorical

IMBALANCE

Distinct	3
Distinct (%)	7.1%
Missing	0
Missing (%)	0.0%
Memory size	468.0 B

1	35
2	6
3	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	1 ?
Unique (%)	2.4%

Sample

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

Common Values

Value	Count	Frequency (%)
1	35	83.3%
2	6	14.3%
3	1	2.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	35	83.3%
2	6	14.3%
3	1	2.4%

업체 조사 일자
Date

Distinct	27
Distinct (%)	64.3%
Missing	0
Missing (%)	0.0%
Memory size	468.0 B

Minimum	2010-02-24 00:00:00
Maximum	2018-02-01 00:00:00

Histogram

Histogram with fixed size bins (bins=27)

휴폐업 일자
Date

MISSING

Distinct	23
Distinct (%)	85.2%
Missing	15
Missing (%)	35.7%
Memory size	468.0 B

Minimum	2009-12-28 00:00:00
Maximum	2017-07-21 00:00:00

Histogram

Histogram with fixed size bins (bins=23)

말소 여부
Boolean

Distinct	2
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Memory size	174.0 B

False	33
True	9

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	33	78.6%
True	9	21.4%

말소 일자
Date

Distinct	9
Distinct (%)	21.4%
Missing	0
Missing (%)	0.0%
Memory size	468.0 B

Minimum	2009-12-28 00:00:00
Maximum	2099-01-01 00:00:00

Histogram

Histogram with fixed size bins (bins=9)

전자납부 번호

전자납부 번호

Heatmap
Table

	전자납부 번호	업체 조사 순번	업체 조사 일자	휴폐업 일자	말소 여부	말소 일자
전자납부 번호	1.000	0.197	1.000	1.000	0.000	0.000
업체 조사 순번	0.197	1.000	0.918	0.000	0.000	0.000
업체 조사 일자	1.000	0.918	1.000	0.946	0.373	0.000
휴폐업 일자	1.000	0.000	0.946	1.000	1.000	0.000
말소 여부	0.000	0.000	0.373	1.000	1.000	0.797
말소 일자	0.000	0.000	0.000	0.000	0.797	1.000

Heatmap
Table

	업체 조사 순번	말소 여부
업체 조사 순번	1.000	0.000
말소 여부	0.000	1.000

Heatmap
Table

	전자납부 번호	업체 조사 순번	말소 여부
전자납부 번호	1.000	0.321	0.000
업체 조사 순번	0.321	1.000	0.000
말소 여부	0.000	0.000	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	전자납부 번호	업체 조사 순번	업체 조사 일자	휴폐업 일자	말소 여부	말소 일자
0	134150800100854001	1	2010-02-24	2009-12-28	Y	2009-12-28
1	134150800101089001	1	2017-06-30	2010-04-06	N	2099-01-01
2	134150800101427001	1	2017-07-18	2010-11-30	Y	2099-01-01
3	134150800101936001	1	2017-07-10	<NA>	N	2099-01-01
4	134150800101991001	1	2017-07-05	2009-12-31	N	2099-01-01
5	134150900100881001	1	2017-12-06	2011-02-28	Y	2015-12-03
6	134150900100976001	1	2017-06-09	2013-12-31	Y	2014-08-25
7	134150900101250001	1	2010-08-20	<NA>	N	2099-01-01
8	134150900101250001	2	2017-07-17	2011-09-30	Y	2099-01-01
9	134150900101943001	1	2017-07-05	2009-12-31	N	2010-06-14

	전자납부 번호	업체 조사 순번	업체 조사 일자	휴폐업 일자	말소 여부	말소 일자
32	134151516105674002	1	2016-10-19	<NA>	N	2099-01-01
33	134151516105674003	1	2017-05-19	<NA>	N	2099-01-01
34	134151516106279006	1	2016-12-31	2016-12-31	N	2099-01-01
35	134151617102947002	1	2017-12-06	<NA>	N	2099-01-01
36	134991415104796102	1	2017-11-30	2015-06-30	Y	2015-12-01
37	134991416104172101	1	2018-02-01	<NA>	N	2099-01-01
38	134991416104172101	2	2017-06-21	<NA>	N	2099-01-01
39	134991416104172101	3	2017-12-11	<NA>	N	2099-01-01
40	134991617104752002	1	2017-11-13	<NA>	N	2099-01-01
41	134991617104752003	1	2018-01-25	<NA>	N	2099-01-01

Overview

Variables

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample