gimi9 Pandas Profiling

Dataset statistics

Number of variables	3
Number of observations	62
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.8 KiB
Average record size in memory	29.1 B

Variable types

Numeric	3

Dataset

Description	이 자료는 1962년부터 2023년까지 우리나라에 들어온 외국인직접투자(도착금액 기준) 중 투자 지역이 "제주도"인 외국인직접투자 통계입니다.(연도, 도착금액 등)
Author	산업통상자원부
URL	https://www.data.go.kr/data/15054395/fileData.do

Alerts

`연번` is highly overall correlated with `연도(년)` and 1 other fields	High correlation
`연도(년)` is highly overall correlated with `연번` and 1 other fields	High correlation
`도착금액(백만불)` is highly overall correlated with `연번` and 1 other fields	High correlation
`연번` has unique values	Unique
`연도(년)` has unique values	Unique
`도착금액(백만불)` has 26 (41.9%) zeros	Zeros

Reproduction

Analysis started	2024-04-06 08:21:19.084357
Analysis finished	2024-04-06 08:21:21.619083
Duration	2.53 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

연번
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	62
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.5

Minimum	1
Maximum	62
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	690.0 B

Quantile statistics

Minimum	1
5-th percentile	4.05
Q1	16.25
median	31.5
Q3	46.75
95-th percentile	58.95
Maximum	62
Range	61
Interquartile range (IQR)	30.5

Descriptive statistics

Standard deviation	18.041619
Coefficient of variation (CV)	0.5727498
Kurtosis	-1.2
Mean	31.5
Median Absolute Deviation (MAD)	15.5
Skewness	0
Sum	1953
Variance	325.5
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	1.6%
48	1	1.6%
35	1	1.6%
36	1	1.6%
37	1	1.6%
38	1	1.6%
39	1	1.6%
40	1	1.6%
41	1	1.6%
42	1	1.6%
Other values (52)	52	83.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	1.6%
2	1	1.6%
3	1	1.6%
4	1	1.6%
5	1	1.6%
6	1	1.6%
7	1	1.6%
8	1	1.6%
9	1	1.6%
10	1	1.6%

Value	Count	Frequency (%)
62	1	1.6%
61	1	1.6%
60	1	1.6%
59	1	1.6%
58	1	1.6%
57	1	1.6%
56	1	1.6%
55	1	1.6%
54	1	1.6%
53	1	1.6%

연도(년)
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	62
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1992.5

Minimum	1962
Maximum	2023
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	690.0 B

Quantile statistics

Minimum	1962
5-th percentile	1965.05
Q1	1977.25
median	1992.5
Q3	2007.75
95-th percentile	2019.95
Maximum	2023
Range	61
Interquartile range (IQR)	30.5

Descriptive statistics

Standard deviation	18.041619
Coefficient of variation (CV)	0.0090547646
Kurtosis	-1.2
Mean	1992.5
Median Absolute Deviation (MAD)	15.5
Skewness	0
Sum	123535
Variance	325.5
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1962	1	1.6%
2009	1	1.6%
1996	1	1.6%
1997	1	1.6%
1998	1	1.6%
1999	1	1.6%
2000	1	1.6%
2001	1	1.6%
2002	1	1.6%
2003	1	1.6%
Other values (52)	52	83.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1962	1	1.6%
1963	1	1.6%
1964	1	1.6%
1965	1	1.6%
1966	1	1.6%
1967	1	1.6%
1968	1	1.6%
1969	1	1.6%
1970	1	1.6%
1971	1	1.6%

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

도착금액(백만불)
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	25
Distinct (%)	40.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	79.403226

Minimum	0
Maximum	908
Zeros	26
Zeros (%)	41.9%
Negative	0
Negative (%)	0.0%
Memory size	690.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	19.5
95-th percentile	546.1
Maximum	908
Range	908
Interquartile range (IQR)	19.5

Descriptive statistics

Standard deviation	203.1959
Coefficient of variation (CV)	2.5590383
Kurtosis	9.0372099
Mean	79.403226
Median Absolute Deviation (MAD)	1
Skewness	3.0673846
Sum	4923
Variance	41288.572
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
0	26	41.9%
1	6	9.7%
2	4	6.5%
4	2	3.2%
34	2	3.2%
6	2	3.2%
9	2	3.2%
554	1	1.6%
103	1	1.6%
396	1	1.6%
Other values (15)	15	24.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	26	41.9%
1	6	9.7%
2	4	6.5%
4	2	3.2%
5	1	1.6%
6	2	3.2%
7	1	1.6%
8	1	1.6%
9	2	3.2%
18	1	1.6%

Value	Count	Frequency (%)
908	1	1.6%
900	1	1.6%
704	1	1.6%
554	1	1.6%
396	1	1.6%
357	1	1.6%
314	1	1.6%
224	1	1.6%
126	1	1.6%
103	1	1.6%

Phik (φk)
Auto

Heatmap
Table

	연번	연도(년)	도착금액(백만불)
연번	1.000	1.000	0.346
연도(년)	1.000	1.000	0.330
도착금액(백만불)	0.346	0.330	1.000

Heatmap
Table

	연번	연도(년)	도착금액(백만불)
연번	1.000	1.000	0.795
연도(년)	1.000	1.000	0.795
도착금액(백만불)	0.795	0.795	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	1	1962
1	2	1963
2	3	1964
3	4	1965
4	5	1966
5	6	1967
6	7	1968
7	8	1969
8	9	1970
9	10	1971

	연번	연도(년)	도착금액(백만불)
52	53	2014	554
53	54	2015	704
54	55	2016	908
55	56	2017	900
56	57	2018	357
57	58	2019	314
58	59	2020	396
59	60	2021	103
60	61	2022	34
61	62	2023	34

Overview

Variables

Interactions

Correlations

Missing values

Sample