gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	22
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.3 KiB
Average record size in memory	59.8 B

Variable types

Numeric	5
Categorical	1

Dataset

Description	무역구제조치 반덤핑, 세이프가드, 불공정 무역행위와 FTA무역 피해지원에 대한 통계 자료로 불공정한 무역행위별로 조치 현황 자료를 포함
Author	산업통상자원부
URL	https://www.data.go.kr/data/15054385/fileData.do

Alerts

`반덤핑_국가` is highly overall correlated with `반덤핑_품목`	High correlation
`반덤핑_품목` is highly overall correlated with `반덤핑_국가`	High correlation
`세이프가드` is highly imbalanced (56.1%)	Imbalance
`연도` has unique values	Unique
`FTA무역피해지원` has 14 (63.6%) zeros	Zeros

Reproduction

Analysis started	2024-03-14 11:58:21.751968
Analysis finished	2024-03-14 11:58:27.255972
Duration	5.5 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

연도
Real number (ℝ)

UNIQUE

Distinct	22
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2012.5

Minimum	2002
Maximum	2023
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	326.0 B

Quantile statistics

Minimum	2002
5-th percentile	2003.05
Q1	2007.25
median	2012.5
Q3	2017.75
95-th percentile	2021.95
Maximum	2023
Range	21
Interquartile range (IQR)	10.5

Descriptive statistics

Standard deviation	6.4935866
Coefficient of variation (CV)	0.0032266269
Kurtosis	-1.2
Mean	2012.5
Median Absolute Deviation (MAD)	5.5
Skewness	0
Sum	44275
Variance	42.166667
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
2002	1	4.5%
2014	1	4.5%
2023	1	4.5%
2022	1	4.5%
2021	1	4.5%
2020	1	4.5%
2019	1	4.5%
2018	1	4.5%
2017	1	4.5%
2016	1	4.5%
Other values (12)	12	54.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2002	1	4.5%
2003	1	4.5%
2004	1	4.5%
2005	1	4.5%
2006	1	4.5%
2007	1	4.5%
2008	1	4.5%
2009	1	4.5%
2010	1	4.5%
2011	1	4.5%

Value	Count	Frequency (%)
2023	1	4.5%
2022	1	4.5%
2021	1	4.5%
2020	1	4.5%
2019	1	4.5%
2018	1	4.5%
2017	1	4.5%
2016	1	4.5%
2015	1	4.5%
2014	1	4.5%

반덤핑_국가
Real number (ℝ)

HIGH CORRELATION

Distinct	11
Distinct (%)	50.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.454545

Minimum	4
Maximum	18
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	326.0 B

Quantile statistics

Minimum	4
5-th percentile	5
Q1	8.25
median	13
Q3	14.75
95-th percentile	17.9
Maximum	18
Range	14
Interquartile range (IQR)	6.5

Descriptive statistics

Standard deviation	4.284271
Coefficient of variation (CV)	0.37402366
Kurtosis	-1.1564616
Mean	11.454545
Median Absolute Deviation (MAD)	3.5
Skewness	-0.23692413
Sum	252
Variance	18.354978
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
14	4	18.2%
15	3	13.6%
9	3	13.6%
18	2	9.1%
5	2	9.1%
7	2	9.1%
13	2	9.1%
4	1	4.5%
8	1	4.5%
16	1	4.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4	1	4.5%
5	2	9.1%
7	2	9.1%
8	1	4.5%
9	3	13.6%
10	1	4.5%
13	2	9.1%
14	4	18.2%
15	3	13.6%
16	1	4.5%

Value	Count	Frequency (%)
18	2	9.1%
16	1	4.5%
15	3	13.6%
14	4	18.2%
13	2	9.1%
10	1	4.5%
9	3	13.6%
8	1	4.5%
7	2	9.1%
5	2	9.1%

반덤핑_품목
Real number (ℝ)

HIGH CORRELATION

Distinct	8
Distinct (%)	36.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.2272727

Minimum	3
Maximum	11
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	326.0 B

Quantile statistics

Minimum	3
5-th percentile	4
Q1	5
median	6
Q3	7
95-th percentile	9.9
Maximum	11
Range	8
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.900672
Coefficient of variation (CV)	0.3052174
Kurtosis	0.99263687
Mean	6.2272727
Median Absolute Deviation (MAD)	1
Skewness	0.87742925
Sum	137
Variance	3.6125541
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
6	7	31.8%
5	5	22.7%
8	3	13.6%
7	2	9.1%
4	2	9.1%
11	1	4.5%
3	1	4.5%
10	1	4.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	1	4.5%
4	2	9.1%
5	5	22.7%
6	7	31.8%
7	2	9.1%
8	3	13.6%
10	1	4.5%
11	1	4.5%

Value	Count	Frequency (%)
11	1	4.5%
10	1	4.5%
8	3	13.6%
7	2	9.1%
6	7	31.8%
5	5	22.7%
4	2	9.1%
3	1	4.5%

세이프가드
Categorical

IMBALANCE

Distinct	2
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Memory size	304.0 B

0	20
1	2

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
0	20	90.9%
1	2	9.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	20	90.9%
1	2	9.1%

불공정무역행위
Real number (ℝ)

Distinct	9
Distinct (%)	40.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.8636364

Minimum	3
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	326.0 B

Quantile statistics

Minimum	3
5-th percentile	4.05
Q1	5.25
median	8
Q3	9
95-th percentile	12
Maximum	13
Range	10
Interquartile range (IQR)	3.75

Descriptive statistics

Standard deviation	2.7132032
Coefficient of variation (CV)	0.34503163
Kurtosis	-0.66518104
Mean	7.8636364
Median Absolute Deviation (MAD)	2
Skewness	0.063721849
Sum	173
Variance	7.3614719
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
9	5	22.7%
5	4	18.2%
8	4	18.2%
6	2	9.1%
12	2	9.1%
10	2	9.1%
4	1	4.5%
13	1	4.5%
3	1	4.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	1	4.5%
4	1	4.5%
5	4	18.2%
6	2	9.1%
8	4	18.2%
9	5	22.7%
10	2	9.1%
12	2	9.1%
13	1	4.5%

Value	Count	Frequency (%)
13	1	4.5%
12	2	9.1%
10	2	9.1%
9	5	22.7%
8	4	18.2%
6	2	9.1%
5	4	18.2%
4	1	4.5%
3	1	4.5%

FTA무역피해지원
Real number (ℝ)

ZEROS

Distinct	8
Distinct (%)	36.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.8636364

Minimum	0
Maximum	31
Zeros	14
Zeros (%)	63.6%
Negative	0
Negative (%)	0.0%
Memory size	326.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3
95-th percentile	27.7
Maximum	31
Range	31
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	9.5732537
Coefficient of variation (CV)	1.9683325
Kurtosis	2.9483224
Mean	4.8636364
Median Absolute Deviation (MAD)	0
Skewness	2.0395902
Sum	107
Variance	91.647186
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	14	63.6%
3	2	9.1%
2	1	4.5%
13	1	4.5%
31	1	4.5%
28	1	4.5%
22	1	4.5%
5	1	4.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14	63.6%
2	1	4.5%
3	2	9.1%
5	1	4.5%
13	1	4.5%
22	1	4.5%
28	1	4.5%
31	1	4.5%

Value	Count	Frequency (%)
31	1	4.5%
28	1	4.5%
22	1	4.5%
13	1	4.5%
5	1	4.5%
3	2	9.1%
2	1	4.5%
0	14	63.6%

Phik (φk)
Auto

Heatmap
Table

	연도	반덤핑_국가	반덤핑_품목	세이프가드	불공정무역행위	FTA무역피해지원
연도	1.000	0.000	0.263	0.371	0.541	0.891
반덤핑_국가	0.000	1.000	0.825	0.323	0.448	0.185
반덤핑_품목	0.263	0.825	1.000	0.772	0.000	0.340
세이프가드	0.371	0.323	0.772	1.000	0.000	0.144
불공정무역행위	0.541	0.448	0.000	0.000	1.000	0.000
FTA무역피해지원	0.891	0.185	0.340	0.144	0.000	1.000

Heatmap
Table

	연도	반덤핑_국가	반덤핑_품목	불공정무역행위	FTA무역피해지원	세이프가드
연도	1.000	-0.180	0.056	0.245	-0.001	0.000
반덤핑_국가	-0.180	1.000	0.765	0.034	-0.263	0.162
반덤핑_품목	0.056	0.765	1.000	0.196	-0.364	0.488
불공정무역행위	0.245	0.034	0.196	1.000	0.427	0.000
FTA무역피해지원	-0.001	-0.263	-0.364	0.427	1.000	0.133
세이프가드	0.000	0.162	0.488	0.000	0.133	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

	연도	반덤핑_국가	반덤핑_품목	세이프가드	불공정무역행위	FTA무역피해지원
0	2002	18	11	1	9	0
1	2003	15	7	0	5	0
2	2004	5	5	0	5	0
3	2005	7	4	0	6	0
4	2006	15	6	0	5	0
5	2007	18	8	0	4	0
6	2008	4	3	0	6	3
7	2009	14	6	0	9	3
8	2010	7	6	0	12	2
9	2011	15	6	0	8	0

	연도	반덤핑_국가	반덤핑_품목	불공정무역행위	FTA무역피해지원
12	2014	16	10	10	28
13	2015	5	4	9	22
14	2016	9	5	12	5
15	2017	14	7	9	0
16	2018	14	6	10	0
17	2019	13	8	13	0
18	2020	9	5	3	0
19	2021	9	6	5	0
20	2022	13	6	8	0
21	2023	10	8	8	0

Overview

Variables

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample