gimi9 Pandas Profiling

Dataset statistics

Number of variables	7
Number of observations	63
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.9 KiB
Average record size in memory	64.1 B

Variable types

DateTime	1
Numeric	6

Dataset

Description	기업이 세관에 수입 신고하는 과정에서 생산된 운임정보를 화물정보와 연계하여 컨테이너 당 평균 수입 운송비용을 산출·공표하는 데이터로, 수출입 물류업계 등에서 참고자료로 활용 가능. 단위 : 천원/2TEU항로 : 항구 단위가 아닌 국가·지역 단위거래조건 : 운임을 포함하지 않는 대표적인 정형거래조건(국가 간 무역거래에서 널리 쓰이는 무역거래조건에 관한 해석 규칙(국제상업회의소 제정))인 FOB(Free On Board)를 거래조건으로 하는 수입신고 건적재형태 : 컨테이너에 단일 화주의 물품만 적재되는 FCL(Full Container Load) 형태만 선별컨테이너 종류 : 40피트(2TEU) 일반화물 운송용(GP, Genaral Purpose) 컨테이너
Author	관세청
URL	https://www.data.go.kr/data/15116806/fileData.do

Alerts

`미국서부` is highly overall correlated with `미국동부` and 4 other fields	High correlation
`미국동부` is highly overall correlated with `미국서부` and 3 other fields	High correlation
`유럽연합` is highly overall correlated with `미국서부` and 3 other fields	High correlation
`중국` is highly overall correlated with `미국서부` and 4 other fields	High correlation
`일본` is highly overall correlated with `미국서부` and 4 other fields	High correlation
`베트남` is highly overall correlated with `미국서부` and 4 other fields	High correlation
`기간` has unique values	Unique

Reproduction

Analysis started	2024-04-21 02:25:44.290905
Analysis finished	2024-04-21 02:25:49.222089
Duration	4.93 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

기간
Date

UNIQUE

Distinct	63
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	636.0 B

Minimum	2019-01-01 00:00:00
Maximum	2024-03-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

미국서부
Real number (ℝ)

HIGH CORRELATION

Distinct	61
Distinct (%)	96.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2498

Minimum	1548
Maximum	3832
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	699.0 B

Quantile statistics

Minimum	1548
5-th percentile	1648.8
Q1	2055
median	2494
Q3	2859.5
95-th percentile	3483.9
Maximum	3832
Range	2284
Interquartile range (IQR)	804.5

Descriptive statistics

Standard deviation	566.17765
Coefficient of variation (CV)	0.22665238
Kurtosis	-0.65282924
Mean	2498
Median Absolute Deviation (MAD)	419
Skewness	0.28416036
Sum	157374
Variance	320557.13
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2663	2	3.2%
2106	2	3.2%
2065	1	1.6%
2838	1	1.6%
2913	1	1.6%
3232	1	1.6%
2620	1	1.6%
2951	1	1.6%
3218	1	1.6%
3324	1	1.6%
Other values (51)	51	81.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1548	1	1.6%
1623	1	1.6%
1636	1	1.6%
1644	1	1.6%
1692	1	1.6%
1721	1	1.6%
1754	1	1.6%
1758	1	1.6%
1762	1	1.6%
1886	1	1.6%

Value	Count	Frequency (%)
3832	1	1.6%
3536	1	1.6%
3519	1	1.6%
3487	1	1.6%
3456	1	1.6%
3353	1	1.6%
3324	1	1.6%
3287	1	1.6%
3232	1	1.6%
3218	1	1.6%

미국동부
Real number (ℝ)

HIGH CORRELATION

Distinct	61
Distinct (%)	96.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2016.2381

Minimum	1308
Maximum	3128
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	699.0 B

Quantile statistics

Minimum	1308
5-th percentile	1496.6
Q1	1702.5
median	1920
Q3	2304.5
95-th percentile	2773.7
Maximum	3128
Range	1820
Interquartile range (IQR)	602

Descriptive statistics

Standard deviation	413.68001
Coefficient of variation (CV)	0.20517419
Kurtosis	-0.20213874
Mean	2016.2381
Median Absolute Deviation (MAD)	274
Skewness	0.67813331
Sum	127023
Variance	171131.15
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1830	2	3.2%
2740	2	3.2%
2194	1	1.6%
2049	1	1.6%
2332	1	1.6%
2394	1	1.6%
2303	1	1.6%
2333	1	1.6%
2190	1	1.6%
2830	1	1.6%
Other values (51)	51	81.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1308	1	1.6%
1392	1	1.6%
1406	1	1.6%
1491	1	1.6%
1547	1	1.6%
1563	1	1.6%
1587	1	1.6%
1601	1	1.6%
1612	1	1.6%
1620	1	1.6%

Value	Count	Frequency (%)
3128	1	1.6%
2841	1	1.6%
2830	1	1.6%
2777	1	1.6%
2744	1	1.6%
2740	2	3.2%
2619	1	1.6%
2540	1	1.6%
2416	1	1.6%
2394	1	1.6%

유럽연합
Real number (ℝ)

HIGH CORRELATION

Distinct	61
Distinct (%)	96.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1639.4603

Minimum	900
Maximum	2343
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	699.0 B

Quantile statistics

Minimum	900
5-th percentile	1136.6
Q1	1299.5
median	1478
Q3	2072
95-th percentile	2234.8
Maximum	2343
Range	1443
Interquartile range (IQR)	772.5

Descriptive statistics

Standard deviation	413.9615
Coefficient of variation (CV)	0.25249864
Kurtosis	-1.4111035
Mean	1639.4603
Median Absolute Deviation (MAD)	313
Skewness	0.29256773
Sum	103286
Variance	171364.12
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2199	2	3.2%
1250	2	3.2%
1136	1	1.6%
1920	1	1.6%
2068	1	1.6%
2112	1	1.6%
2122	1	1.6%
2332	1	1.6%
2064	1	1.6%
2235	1	1.6%
Other values (51)	51	81.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
900	1	1.6%
1082	1	1.6%
1109	1	1.6%
1136	1	1.6%
1142	1	1.6%
1152	1	1.6%
1164	1	1.6%
1165	1	1.6%
1189	1	1.6%
1238	1	1.6%

Value	Count	Frequency (%)
2343	1	1.6%
2332	1	1.6%
2307	1	1.6%
2235	1	1.6%
2233	1	1.6%
2201	1	1.6%
2200	1	1.6%
2199	2	3.2%
2159	1	1.6%
2155	1	1.6%

중국
Real number (ℝ)

HIGH CORRELATION

Distinct	60
Distinct (%)	95.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1504.7937

Minimum	630
Maximum	2975
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	699.0 B

Quantile statistics

Minimum	630
5-th percentile	671
Q1	739
median	1101
Q3	2179.5
95-th percentile	2904.4
Maximum	2975
Range	2345
Interquartile range (IQR)	1440.5

Descriptive statistics

Standard deviation	822.00477
Coefficient of variation (CV)	0.54625747
Kurtosis	-1.3367465
Mean	1504.7937
Median Absolute Deviation (MAD)	431
Skewness	0.48860743
Sum	94802
Variance	675691.84
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
745	2	3.2%
692	2	3.2%
767	2	3.2%
712	1	1.6%
2755	1	1.6%
2246	1	1.6%
2440	1	1.6%
2720	1	1.6%
2769	1	1.6%
2912	1	1.6%
Other values (50)	50	79.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
630	1	1.6%
640	1	1.6%
662	1	1.6%
670	1	1.6%
680	1	1.6%
689	1	1.6%
690	1	1.6%
691	1	1.6%
692	2	3.2%
708	1	1.6%

Value	Count	Frequency (%)
2975	1	1.6%
2917	1	1.6%
2912	1	1.6%
2910	1	1.6%
2854	1	1.6%
2826	1	1.6%
2779	1	1.6%
2769	1	1.6%
2755	1	1.6%
2720	1	1.6%

일본
Real number (ℝ)

HIGH CORRELATION

Distinct	62
Distinct (%)	98.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1119.9524

Minimum	712
Maximum	1723
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	699.0 B

Quantile statistics

Minimum	712
5-th percentile	762.7
Q1	891
median	1111
Q3	1303
95-th percentile	1591.6
Maximum	1723
Range	1011
Interquartile range (IQR)	412

Descriptive statistics

Standard deviation	273.93474
Coefficient of variation (CV)	0.24459499
Kurtosis	-0.8291781
Mean	1119.9524
Median Absolute Deviation (MAD)	211
Skewness	0.4065513
Sum	70557
Variance	75040.24
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
769	2	3.2%
1467	1	1.6%
1314	1	1.6%
1102	1	1.6%
1136	1	1.6%
1172	1	1.6%
1222	1	1.6%
1304	1	1.6%
1512	1	1.6%
1552	1	1.6%
Other values (52)	52	82.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
712	1	1.6%
751	1	1.6%
757	1	1.6%
762	1	1.6%
769	2	3.2%
771	1	1.6%
797	1	1.6%
798	1	1.6%
814	1	1.6%
827	1	1.6%

Value	Count	Frequency (%)
1723	1	1.6%
1686	1	1.6%
1668	1	1.6%
1596	1	1.6%
1552	1	1.6%
1512	1	1.6%
1505	1	1.6%
1469	1	1.6%
1467	1	1.6%
1460	1	1.6%

베트남
Real number (ℝ)

HIGH CORRELATION

Distinct	61
Distinct (%)	96.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1338.5079

Minimum	394
Maximum	3277
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	699.0 B

Quantile statistics

Minimum	394
5-th percentile	405.5
Q1	507
median	794
Q3	2202.5
95-th percentile	3051.2
Maximum	3277
Range	2883
Interquartile range (IQR)	1695.5

Descriptive statistics

Standard deviation	1001.4725
Coefficient of variation (CV)	0.74820065
Kurtosis	-1.0912363
Mean	1338.5079
Median Absolute Deviation (MAD)	371
Skewness	0.73178956
Sum	84326
Variance	1002947.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
404	2	3.2%
525	2	3.2%
423	1	1.6%
3017	1	1.6%
2296	1	1.6%
2697	1	1.6%
3055	1	1.6%
3123	1	1.6%
2980	1	1.6%
2899	1	1.6%
Other values (51)	51	81.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
394	1	1.6%
396	1	1.6%
404	2	3.2%
419	1	1.6%
423	1	1.6%
427	1	1.6%
429	1	1.6%
438	1	1.6%
441	1	1.6%
455	1	1.6%

Value	Count	Frequency (%)
3277	1	1.6%
3123	1	1.6%
3119	1	1.6%
3055	1	1.6%
3017	1	1.6%
2983	1	1.6%
2980	1	1.6%
2899	1	1.6%
2876	1	1.6%
2832	1	1.6%

Phik (φk)
Auto

Heatmap
Table

	기간	미국서부	미국동부	유럽연합	중국	일본	베트남
기간	1.000	1.000	1.000	1.000	1.000	1.000	1.000
미국서부	1.000	1.000	0.812	0.463	0.749	0.849	0.757
미국동부	1.000	0.812	1.000	0.611	0.758	0.795	0.527
유럽연합	1.000	0.463	0.611	1.000	0.749	0.326	0.633
중국	1.000	0.749	0.758	0.749	1.000	0.773	0.936
일본	1.000	0.849	0.795	0.326	0.773	1.000	0.785
베트남	1.000	0.757	0.527	0.633	0.936	0.785	1.000

Heatmap
Table

	미국서부	미국동부	유럽연합	중국	일본	베트남
미국서부	1.000	0.759	0.657	0.782	0.832	0.801
미국동부	0.759	1.000	0.360	0.566	0.805	0.596
유럽연합	0.657	0.360	1.000	0.830	0.501	0.835
중국	0.782	0.566	0.830	1.000	0.696	0.952
일본	0.832	0.805	0.501	0.696	1.000	0.746
베트남	0.801	0.596	0.835	0.952	0.746	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	2019-01	2065	1830	1136	712	769	423
1	2019-02	1636	1850	1164	690	762	427
2	2019-03	1692	1491	1142	680	892	429
3	2019-04	1758	1815	1369	662	797	441
4	2019-05	2552	1620	1429	692	901	404
5	2019-06	1754	1810	1467	691	832	394
6	2019-07	1762	1695	1251	630	827	419
7	2019-08	1721	1769	1238	692	894	438
8	2019-09	1548	1587	1359	815	837	456
9	2019-10	1904	1705	1250	747	890	396

	기간	미국서부	미국동부	유럽연합	중국	일본	베트남
53	2023-06	2562	1946	1418	1285	1322	968
54	2023-07	2663	1830	1497	1101	1211	794
55	2023-08	2494	2319	1301	986	1284	771
56	2023-09	2396	2416	1404	928	1273	795
57	2023-10	2879	2146	1352	951	1240	740
58	2023-11	2409	2306	1109	1005	1166	597
59	2023-12	2609	2245	1298	980	1183	613
60	2024-01	2312	2178	900	956	1127	651
61	2024-02	2840	1920	1250	942	1141	594
62	2024-03	2664	1901	1378	1026	1161	600

Overview

Variables

Interactions

Correlations

Missing values

Sample