Comprehensive EDA Report on OB Report

Dataset statistics

Number of variables	28
Number of observations	79302
Missing cells	745
Missing cells (%)	< 0.1%
Duplicate rows	15
Duplicate rows (%)	< 0.1%
Total size in memory	16.5 MiB
Average record size in memory	218.3 B

Variable types

Numeric	12
Categorical	12
Text	3
DateTime	1

Dataset

Description	Exploratory Data Analysis for OB Report - AWB.xlsx
Author	Baobao Tang
URL

Alerts

`Year` has constant value "2023"	Constant
`Leg Origin` has constant value "MIA"	Constant
Dataset has 15 (< 0.1%) duplicate rows	Duplicates
`Commodity` has a high cardinality: 512 distinct values	High cardinality
`AWB Prefix` is highly overall correlated with `Airway Bill Number`	High correlation
`Airway Bill Number` is highly overall correlated with `AWB Prefix` and 2 other fields	High correlation
`Bellies - Freighters` is highly overall correlated with `LEG` and 4 other fields	High correlation
`KG Chg Operational` is highly overall correlated with `KG OB Chg` and 4 other fields	High correlation
`KG OB Chg` is highly overall correlated with `KG Chg Operational` and 4 other fields	High correlation
`KG OB Gross` is highly overall correlated with `KG Chg Operational` and 4 other fields	High correlation
`KG Volumetric` is highly overall correlated with `KG Chg Operational` and 4 other fields	High correlation
`LEG` is highly overall correlated with `Bellies - Freighters` and 4 other fields	High correlation
`Leg Destination` is highly overall correlated with `Bellies - Freighters` and 4 other fields	High correlation
`Month` is highly overall correlated with `Airway Bill Number` and 1 other fields	High correlation
`OD Network Destination` is highly overall correlated with `LEG` and 2 other fields	High correlation
`OD Real Destination` is highly overall correlated with `LEG` and 2 other fields	High correlation
`Operating Flight Number` is highly overall correlated with `Bellies - Freighters` and 1 other fields	High correlation
`Pieces` is highly overall correlated with `KG Chg Operational` and 4 other fields	High correlation
`ProductCode` is highly overall correlated with `Bellies - Freighters`	High correlation
`Route Owner` is highly overall correlated with `Bellies - Freighters` and 3 other fields	High correlation
`Volume (m3)` is highly overall correlated with `KG Chg Operational` and 4 other fields	High correlation
`Week` is highly overall correlated with `Airway Bill Number` and 1 other fields	High correlation
`Route Owner` is highly imbalanced (71.1%)	Imbalance
`Bellies - Freighters` is highly imbalanced (53.7%)	Imbalance
`Commodity` is highly imbalanced (65.9%)	Imbalance
`OD Network Origin` is highly imbalanced (91.8%)	Imbalance

Reproduction

Analysis started	2024-09-19 03:12:26.597818
Analysis finished	2024-09-19 03:12:35.519369
Duration	8.92 seconds

Day
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.735177

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	619.7 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.6871954
Coefficient of variation (CV)	0.55208756
Kurtosis	-1.177198
Mean	15.735177
Median Absolute Deviation (MAD)	7
Skewness	-0.016842829
Sum	1247831
Variance	75.467364
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
11	3103	3.9%
18	3058	3.9%
22	2994	3.8%
25	2959	3.7%
15	2887	3.6%
8	2821	3.6%
4	2807	3.5%
26	2760	3.5%
2	2757	3.5%
16	2747	3.5%
Other values (21)	50409	63.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2614	3.3%
2	2757	3.5%
3	2115	2.7%
4	2807	3.5%
5	2523	3.2%
6	2496	3.1%
7	2175	2.7%
8	2821	3.6%
9	2594	3.3%
10	2441	3.1%

Value	Count	Frequency (%)
31	1079	1.4%
30	2209	2.8%
29	2537	3.2%
28	2376	3.0%
27	2688	3.4%
26	2760	3.5%
25	2959	3.7%
24	2273	2.9%
23	2715	3.4%
22	2994	3.8%

Month
Real number (ℝ)

HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.6223172

Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	619.7 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	2.2811078
Coefficient of variation (CV)	0.49349876
Kurtosis	-1.230866
Mean	4.6223172
Median Absolute Deviation (MAD)	2
Skewness	-0.052522368
Sum	366559
Variance	5.203453
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
8	10707	13.5%
7	10606	13.4%
3	10547	13.3%
6	10152	12.8%
4	9883	12.5%
5	9551	12.0%
2	8965	11.3%
1	8891	11.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	8891	11.2%
2	8965	11.3%
3	10547	13.3%
4	9883	12.5%
5	9551	12.0%
6	10152	12.8%
7	10606	13.4%
8	10707	13.5%

Value	Count	Frequency (%)
8	10707	13.5%
7	10606	13.4%
6	10152	12.8%
5	9551	12.0%
4	9883	12.5%
3	10547	13.3%
2	8965	11.3%
1	8891	11.2%

Year
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	619.7 KiB

2023	79302

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	317208
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
2023	79302	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2023	79302	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	158604	50.0%
0	79302	25.0%
3	79302	25.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	317208	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	158604	50.0%
0	79302	25.0%
3	79302	25.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	317208	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	158604	50.0%
0	79302	25.0%
3	79302	25.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	317208	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	158604	50.0%
0	79302	25.0%
3	79302	25.0%

Week
Real number (ℝ)

HIGH CORRELATION

Distinct	36
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.079065

Minimum	1
Maximum	36
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	619.7 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	11
median	19
Q3	28
95-th percentile	34
Maximum	36
Range	35
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	9.9501198
Coefficient of variation (CV)	0.52152031
Kurtosis	-1.2120527
Mean	19.079065
Median Absolute Deviation (MAD)	9
Skewness	-0.031603535
Sum	1513008
Variance	99.004883
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=36)

Value	Count	Frequency (%)
27	2539	3.2%
30	2534	3.2%
33	2529	3.2%
32	2521	3.2%
29	2501	3.2%
12	2500	3.2%
24	2497	3.1%
14	2431	3.1%
17	2422	3.1%
31	2409	3.0%
Other values (26)	54419	68.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	156	0.2%
2	1895	2.4%
3	2070	2.6%
4	2163	2.7%
5	2269	2.9%
6	2133	2.7%
7	2345	3.0%
8	2088	2.6%
9	2392	3.0%
10	2308	2.9%

Value	Count	Frequency (%)
36	1062	1.3%
35	2404	3.0%
34	2360	3.0%
33	2529	3.2%
32	2521	3.2%
31	2409	3.0%
30	2534	3.2%
29	2501	3.2%
28	2216	2.8%
27	2539	3.2%

AWB Prefix
Real number (ℝ)

HIGH CORRELATION

Distinct	50
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	676.28516

Minimum	1
Maximum	996
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	619.7 KiB

Quantile statistics

Minimum	1
5-th percentile	160
Q1	729
median	729
Q3	729
95-th percentile	729
Maximum	996
Range	995
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	173.54668
Coefficient of variation (CV)	0.25661761
Kurtosis	7.085297
Mean	676.28516
Median Absolute Deviation (MAD)	0
Skewness	-2.9358276
Sum	53630766
Variance	30118.451
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
729	70850	89.3%
160	2640	3.3%
1	1224	1.5%
47	906	1.1%
202	798	1.0%
403	443	0.6%
810	350	0.4%
133	305	0.4%
805	235	0.3%
125	226	0.3%
Other values (40)	1325	1.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1224	1.5%
14	7	< 0.1%
16	49	0.1%
20	13	< 0.1%
23	29	< 0.1%
45	4	< 0.1%
47	906	1.1%
57	29	< 0.1%
74	28	< 0.1%
75	65	0.1%

Value	Count	Frequency (%)
996	14	< 0.1%
976	105	0.1%
973	2	< 0.1%
932	85	0.1%
930	2	< 0.1%
906	59	0.1%
881	13	< 0.1%
873	24	< 0.1%
817	33	< 0.1%
810	350	0.4%

Operating Flight Number
Real number (ℝ)

HIGH CORRELATION

Distinct	120
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3721.2247

Minimum	3
Maximum	9955
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	619.7 KiB

Quantile statistics

Minimum	3
5-th percentile	31
Q1	4041
median	4085
Q3	4159
95-th percentile	4257
Maximum	9955
Range	9952
Interquartile range (IQR)	118

Descriptive statistics

Standard deviation	1194.1402
Coefficient of variation (CV)	0.32089978
Kurtosis	5.3060834
Mean	3721.2247
Median Absolute Deviation (MAD)	46
Skewness	-2.6881705
Sum	2.9510056 × 10⁸
Variance	1425970.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4039	5586	7.0%
4257	4720	6.0%
4055	4076	5.1%
4087	3580	4.5%
4169	3084	3.9%
31	3043	3.8%
4171	2803	3.5%
4099	2728	3.4%
4091	2716	3.4%
4071	2317	2.9%
Other values (110)	44649	56.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	93	0.1%
5	315	0.4%
7	1279	1.6%
9	76	0.1%
31	3043	3.8%
39	32	< 0.1%
99	237	0.3%
105	133	0.2%
107	7	< 0.1%
127	1112	1.4%

Value	Count	Frequency (%)
9955	1	< 0.1%
5907	1	< 0.1%
5903	2	< 0.1%
5077	4	< 0.1%
4299	329	0.4%
4291	16	< 0.1%
4289	24	< 0.1%
4287	168	0.2%
4285	453	0.6%
4283	636	0.8%

Route Owner
Categorical

HIGH CORRELATION IMBALANCE

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	619.7 KiB

QT	71102
AV	6343
TA	1437
6R	420

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	158604
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
QT	71102	89.7%
AV	6343	8.0%
TA	1437	1.8%
6R	420	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
qt	71102	89.7%
av	6343	8.0%
ta	1437	1.8%
6r	420	0.5%

Most occurring characters

Value	Count	Frequency (%)
T	72539	45.7%
Q	71102	44.8%
A	7780	4.9%
V	6343	4.0%
6	420	0.3%
R	420	0.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	158604	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
T	72539	45.7%
Q	71102	44.8%
A	7780	4.9%
V	6343	4.0%
6	420	0.3%
R	420	0.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	158604	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
T	72539	45.7%
Q	71102	44.8%
A	7780	4.9%
V	6343	4.0%
6	420	0.3%
R	420	0.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	158604	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
T	72539	45.7%
Q	71102	44.8%
A	7780	4.9%
V	6343	4.0%
6	420	0.3%
R	420	0.3%

Leg Origin
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	619.7 KiB

MIA	79302

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	237906
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
MIA	79302	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
mia	79302	100.0%

Most occurring characters

Value	Count	Frequency (%)
M	79302	33.3%
I	79302	33.3%
A	79302	33.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	237906	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
M	79302	33.3%
I	79302	33.3%
A	79302	33.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	237906	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
M	79302	33.3%
I	79302	33.3%
A	79302	33.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	237906	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
M	79302	33.3%
I	79302	33.3%
A	79302	33.3%

Leg Destination
Categorical

HIGH CORRELATION

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	619.7 KiB

BOG	17019
MDE	6627
GYE	5322
SAL	5288
GUA	4826
Other values (19)	40220

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	237906
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CWB
2nd row	ASU
3rd row	GUA
4th row	BOG
5th row	GYE

Common Values

Value	Count	Frequency (%)
BOG	17019	21.5%
MDE	6627	8.4%
GYE	5322	6.7%
SAL	5288	6.7%
GUA	4826	6.1%
UIO	4302	5.4%
CWB	4076	5.1%
ASU	4072	5.1%
SDQ	4049	5.1%
SJO	3804	4.8%
Other values (14)	19917	25.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
bog	17019	21.5%
mde	6627	8.4%
gye	5322	6.7%
sal	5288	6.7%
gua	4826	6.1%
uio	4302	5.4%
cwb	4076	5.1%
asu	4072	5.1%
sdq	4049	5.1%
sjo	3804	4.8%
Other values (14)	19917	25.1%

Most occurring characters

Value	Count	Frequency (%)
O	30967	13.0%
G	29971	12.6%
B	22657	9.5%
A	20969	8.8%
E	18746	7.9%
S	17238	7.2%
D	13707	5.8%
M	13473	5.7%
U	13200	5.5%
L	9066	3.8%
Other values (11)	47912	20.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	237906	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
O	30967	13.0%
G	29971	12.6%
B	22657	9.5%
A	20969	8.8%
E	18746	7.9%
S	17238	7.2%
D	13707	5.8%
M	13473	5.7%
U	13200	5.5%
L	9066	3.8%
Other values (11)	47912	20.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	237906	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
O	30967	13.0%
G	29971	12.6%
B	22657	9.5%
A	20969	8.8%
E	18746	7.9%
S	17238	7.2%
D	13707	5.8%
M	13473	5.7%
U	13200	5.5%
L	9066	3.8%
Other values (11)	47912	20.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	237906	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
O	30967	13.0%
G	29971	12.6%
B	22657	9.5%
A	20969	8.8%
E	18746	7.9%
S	17238	7.2%
D	13707	5.8%
M	13473	5.7%
U	13200	5.5%
L	9066	3.8%
Other values (11)	47912	20.1%

LEG
Categorical

HIGH CORRELATION

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	619.7 KiB

MIABOG	17019
MIAMDE	6627
MIAGYE	5322
MIASAL	5288
MIAGUA	4826
Other values (19)	40220

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	475812
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MIACWB
2nd row	MIAASU
3rd row	MIAGUA
4th row	MIABOG
5th row	MIAGYE

Common Values

Value	Count	Frequency (%)
MIABOG	17019	21.5%
MIAMDE	6627	8.4%
MIAGYE	5322	6.7%
MIASAL	5288	6.7%
MIAGUA	4826	6.1%
MIAUIO	4302	5.4%
MIACWB	4076	5.1%
MIAASU	4072	5.1%
MIASDQ	4049	5.1%
MIASJO	3804	4.8%
Other values (14)	19917	25.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
miabog	17019	21.5%
miamde	6627	8.4%
miagye	5322	6.7%
miasal	5288	6.7%
miagua	4826	6.1%
miauio	4302	5.4%
miacwb	4076	5.1%
miaasu	4072	5.1%
miasdq	4049	5.1%
miasjo	3804	4.8%
Other values (14)	19917	25.1%

Most occurring characters

Value	Count	Frequency (%)
A	100271	21.1%
M	92775	19.5%
I	84673	17.8%
O	30967	6.5%
G	29971	6.3%
B	22657	4.8%
E	18746	3.9%
S	17238	3.6%
D	13707	2.9%
U	13200	2.8%
Other values (11)	51607	10.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	475812	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	100271	21.1%
M	92775	19.5%
I	84673	17.8%
O	30967	6.5%
G	29971	6.3%
B	22657	4.8%
E	18746	3.9%
S	17238	3.6%
D	13707	2.9%
U	13200	2.8%
Other values (11)	51607	10.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	475812	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	100271	21.1%
M	92775	19.5%
I	84673	17.8%
O	30967	6.5%
G	29971	6.3%
B	22657	4.8%
E	18746	3.9%
S	17238	3.6%
D	13707	2.9%
U	13200	2.8%
Other values (11)	51607	10.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	475812	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	100271	21.1%
M	92775	19.5%
I	84673	17.8%
O	30967	6.5%
G	29971	6.3%
B	22657	4.8%
E	18746	3.9%
S	17238	3.6%
D	13707	2.9%
U	13200	2.8%
Other values (11)	51607	10.8%

Pieces
Real number (ℝ)

HIGH CORRELATION

Distinct	389
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.681811

Minimum	1
Maximum	1127
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	619.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	3
Q3	10
95-th percentile	51
Maximum	1127
Range	1126
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	30.506709
Coefficient of variation (CV)	2.6114708
Kurtosis	214.46307
Mean	11.681811
Median Absolute Deviation (MAD)	2
Skewness	10.973131
Sum	926391
Variance	930.65929
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	27655	34.9%
2	9976	12.6%
3	5775	7.3%
4	4246	5.4%
5	3309	4.2%
6	2735	3.4%
7	2005	2.5%
8	1873	2.4%
10	1586	2.0%
9	1551	2.0%
Other values (379)	18591	23.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	27655	34.9%
2	9976	12.6%
3	5775	7.3%
4	4246	5.4%
5	3309	4.2%
6	2735	3.4%
7	2005	2.5%
8	1873	2.4%
9	1551	2.0%
10	1586	2.0%

Value	Count	Frequency (%)
1127	1	< 0.1%
1000	1	< 0.1%
959	1	< 0.1%
928	1	< 0.1%
903	1	< 0.1%
851	1	< 0.1%
824	1	< 0.1%
814	1	< 0.1%
809	1	< 0.1%
798	1	< 0.1%

KG OB Chg
Real number (ℝ)

HIGH CORRELATION

Distinct	9381
Distinct (%)	11.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	892.32101

Minimum	0.5
Maximum	56800
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	619.7 KiB

Quantile statistics

Minimum	0.5
5-th percentile	3
Q1	58.5
median	257
Q3	852
95-th percentile	3618
Maximum	56800
Range	56799.5
Interquartile range (IQR)	793.5

Descriptive statistics

Standard deviation	2164.9667
Coefficient of variation (CV)	2.4262196
Kurtosis	143.45042
Mean	892.32101
Median Absolute Deviation (MAD)	242
Skewness	9.3190106
Sum	70762841
Variance	4687080.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	1773	2.2%
1	1540	1.9%
3	865	1.1%
4	839	1.1%
5	828	1.0%
100	773	1.0%
7	652	0.8%
6	557	0.7%
10	501	0.6%
12	429	0.5%
Other values (9371)	70545	89.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.5	6	< 0.1%
0.6323133027	1	< 0.1%
1	1540	1.9%
1.205681818	1	< 0.1%
1.333	1	< 0.1%
1.5	90	0.1%
1.989411765	1	< 0.1%
2	1773	2.2%
2.078651685	1	< 0.1%
2.409836066	1	< 0.1%

Value	Count	Frequency (%)
56800	1	< 0.1%
54968	1	< 0.1%
54267.5	1	< 0.1%
53117.5	1	< 0.1%
52382	1	< 0.1%
52058.5	1	< 0.1%
51949	1	< 0.1%
50177	1	< 0.1%
49094	1	< 0.1%
49093	1	< 0.1%

KG OB Gross
Real number (ℝ)

HIGH CORRELATION

Distinct	7309
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	765.52645

Minimum	0.2
Maximum	56800
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	619.7 KiB

Quantile statistics

Minimum	0.2
5-th percentile	2
Q1	45
median	202
Q3	704
95-th percentile	3244
Maximum	56800
Range	56799.8
Interquartile range (IQR)	659

Descriptive statistics

Standard deviation	1987.4129
Coefficient of variation (CV)	2.5961388
Kurtosis	186.17082
Mean	765.52645
Median Absolute Deviation (MAD)	192
Skewness	10.718516
Sum	60707779
Variance	3949810.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2706	3.4%
2	1806	2.3%
3	1272	1.6%
4	1010	1.3%
5	890	1.1%
6	804	1.0%
7	686	0.9%
8	595	0.8%
10	579	0.7%
9	524	0.7%
Other values (7299)	68430	86.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2	3	< 0.1%
0.22	1	< 0.1%
0.3	1	< 0.1%
0.4	6	< 0.1%
0.42	1	< 0.1%
0.5	9	< 0.1%
0.54	1	< 0.1%
0.59	2	< 0.1%
0.6	10	< 0.1%
0.65	1	< 0.1%

Value	Count	Frequency (%)
56800	1	< 0.1%
54943.01	1	< 0.1%
54172	1	< 0.1%
53117	1	< 0.1%
51949	1	< 0.1%
51785	1	< 0.1%
50177	1	< 0.1%
49094	1	< 0.1%
49093	1	< 0.1%
48467	1	< 0.1%

Bellies - Freighters
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	619.7 KiB

Freighters	71529
Bellies	7773

Length

Max length	10
Median length	10
Mean length	9.7059469
Min length	7

Characters and Unicode

Total characters	769701
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
Freighters	71529	90.2%
Bellies	7773	9.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
freighters	71529	90.2%
bellies	7773	9.8%

Most occurring characters

Value	Count	Frequency (%)
e	158604	20.6%
r	143058	18.6%
i	79302	10.3%
s	79302	10.3%
F	71529	9.3%
g	71529	9.3%
h	71529	9.3%
t	71529	9.3%
l	15546	2.0%
B	7773	1.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	769701	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	158604	20.6%
r	143058	18.6%
i	79302	10.3%
s	79302	10.3%
F	71529	9.3%
g	71529	9.3%
h	71529	9.3%
t	71529	9.3%
l	15546	2.0%
B	7773	1.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	769701	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	158604	20.6%
r	143058	18.6%
i	79302	10.3%
s	79302	10.3%
F	71529	9.3%
g	71529	9.3%
h	71529	9.3%
t	71529	9.3%
l	15546	2.0%
B	7773	1.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	769701	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	158604	20.6%
r	143058	18.6%
i	79302	10.3%
s	79302	10.3%
F	71529	9.3%
g	71529	9.3%
h	71529	9.3%
t	71529	9.3%
l	15546	2.0%
B	7773	1.0%

ProductCode
Categorical

HIGH CORRELATION

Distinct	15
Distinct (%)	< 0.1%
Missing	643
Missing (%)	0.8%
Memory size	619.7 KiB

GCR	47737
CAC	9175
DGR	7556
AOG	5695
COM	3667
Other values (10)	4829

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	235977
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	DGR
2nd row	CAC
3rd row	HUM
4th row	GCR
5th row	GCR

Common Values

Value	Count	Frequency (%)
GCR	47737	60.2%
CAC	9175	11.6%
DGR	7556	9.5%
AOG	5695	7.2%
COM	3667	4.6%
PER	2760	3.5%
PIL	910	1.1%
HUM	570	0.7%
XCS	236	0.3%
AVI	214	0.3%
Other values (5)	139	0.2%
(Missing)	643	0.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
gcr	47737	60.7%
cac	9175	11.7%
dgr	7556	9.6%
aog	5695	7.2%
com	3667	4.7%
per	2760	3.5%
pil	910	1.2%
hum	570	0.7%
xcs	236	0.3%
avi	214	0.3%
Other values (5)	139	0.2%

Most occurring characters

Value	Count	Frequency (%)
C	70028	29.7%
G	60988	25.8%
R	58060	24.6%
A	15177	6.4%
O	9382	4.0%
D	7556	3.2%
M	4244	1.8%
P	3678	1.6%
E	2760	1.2%
I	1124	0.5%
Other values (6)	2980	1.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	235977	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	70028	29.7%
G	60988	25.8%
R	58060	24.6%
A	15177	6.4%
O	9382	4.0%
D	7556	3.2%
M	4244	1.8%
P	3678	1.6%
E	2760	1.2%
I	1124	0.5%
Other values (6)	2980	1.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	235977	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	70028	29.7%
G	60988	25.8%
R	58060	24.6%
A	15177	6.4%
O	9382	4.0%
D	7556	3.2%
M	4244	1.8%
P	3678	1.6%
E	2760	1.2%
I	1124	0.5%
Other values (6)	2980	1.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	235977	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	70028	29.7%
G	60988	25.8%
R	58060	24.6%
A	15177	6.4%
O	9382	4.0%
D	7556	3.2%
M	4244	1.8%
P	3678	1.6%
E	2760	1.2%
I	1124	0.5%
Other values (6)	2980	1.3%

Commodity Unificado
Text

Distinct	340
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	619.7 KiB

Length

Max length	23
Median length	19
Mean length	5.5585736
Min length	3

Characters and Unicode

Total characters	440806
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	142 ?
Unique (%)	0.2%

Sample

1st row	DGR
2nd row	CAC
3rd row	HUM
4th row	GCR
5th row	STD,GCR

Value	Count	Frequency (%)
std,gcr	32511	41.0%
gcr	10604	13.4%
cac	9175	11.6%
dgr	7627	9.6%
aog	5231	6.6%
com,gcr	3453	4.4%
std,gcr,nsc	1565	2.0%
col,std,per	818	1.0%
pip	692	0.9%
hum	570	0.7%
Other values (330)	7056	8.9%

Most occurring characters

Value	Count	Frequency (%)
C	79454	18.0%
G	66034	15.0%
R	63571	14.4%
,	50725	11.5%
D	45915	10.4%
S	42331	9.6%
T	38939	8.8%
A	15539	3.5%
O	11418	2.6%
P	5814	1.3%
Other values (14)	21066	4.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	440806	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	79454	18.0%
G	66034	15.0%
R	63571	14.4%
,	50725	11.5%
D	45915	10.4%
S	42331	9.6%
T	38939	8.8%
A	15539	3.5%
O	11418	2.6%
P	5814	1.3%
Other values (14)	21066	4.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	440806	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	79454	18.0%
G	66034	15.0%
R	63571	14.4%
,	50725	11.5%
D	45915	10.4%
S	42331	9.6%
T	38939	8.8%
A	15539	3.5%
O	11418	2.6%
P	5814	1.3%
Other values (14)	21066	4.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	440806	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	79454	18.0%
G	66034	15.0%
R	63571	14.4%
,	50725	11.5%
D	45915	10.4%
S	42331	9.6%
T	38939	8.8%
A	15539	3.5%
O	11418	2.6%
P	5814	1.3%
Other values (14)	21066	4.8%

Commodity
Categorical

HIGH CARDINALITY IMBALANCE

Distinct	512
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	175.2 KiB

9985	44092
9997	8735
4105	5365
9724	4176
9731	2160
Other values (507)	14774

Length

Max length	4
Median length	4
Mean length	3.9877935
Min length	1

Characters and Unicode

Total characters	316240
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	155 ?
Unique (%)	0.2%

Sample

1st row	5506
2nd row	9997
3rd row	9091
4th row	9985
5th row	9985

Common Values

Value	Count	Frequency (%)
9985	44092	55.6%
9997	8735	11.0%
4105	5365	6.8%
9724	4176	5.3%
9731	2160	2.7%
6200	1689	2.1%
4406	736	0.9%
6500	693	0.9%
4711	609	0.8%
3480	605	0.8%
Other values (502)	10442	13.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
9985	44092	55.6%
9997	8735	11.0%
4105	5365	6.8%
9724	4176	5.3%
9731	2160	2.7%
6200	1689	2.1%
4406	736	0.9%
6500	693	0.9%
4711	609	0.8%
3480	605	0.8%
Other values (502)	10442	13.2%

Most occurring characters

Value	Count	Frequency (%)
9	130432	41.2%
5	52730	16.7%
8	46209	14.6%
7	19117	6.0%
0	16616	5.3%
4	14982	4.7%
1	14692	4.6%
2	9442	3.0%
6	6052	1.9%
3	5521	1.7%
Other values (8)	447	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	316240	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
9	130432	41.2%
5	52730	16.7%
8	46209	14.6%
7	19117	6.0%
0	16616	5.3%
4	14982	4.7%
1	14692	4.6%
2	9442	3.0%
6	6052	1.9%
3	5521	1.7%
Other values (8)	447	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	316240	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
9	130432	41.2%
5	52730	16.7%
8	46209	14.6%
7	19117	6.0%
0	16616	5.3%
4	14982	4.7%
1	14692	4.6%
2	9442	3.0%
6	6052	1.9%
3	5521	1.7%
Other values (8)	447	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	316240	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
9	130432	41.2%
5	52730	16.7%
8	46209	14.6%
7	19117	6.0%
0	16616	5.3%
4	14982	4.7%
1	14692	4.6%
2	9442	3.0%
6	6052	1.9%
3	5521	1.7%
Other values (8)	447	0.1%

OD Real Origin
Text

Distinct	248
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	619.7 KiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	237906
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	61 ?
Unique (%)	0.1%

Sample

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

Value	Count	Frequency (%)
mia	64856	81.8%
pvg	1185	1.5%
xmn	1130	1.4%
pek	1086	1.4%
iah	679	0.9%
lhr	524	0.7%
ord	501	0.6%
mex	463	0.6%
vcp	454	0.6%
dfw	428	0.5%
Other values (238)	7996	10.1%

Most occurring characters

Value	Count	Frequency (%)
M	67805	28.5%
A	67219	28.3%
I	66684	28.0%
P	3331	1.4%
G	2740	1.2%
E	2460	1.0%
H	2303	1.0%
X	2179	0.9%
D	2091	0.9%
R	2034	0.9%
Other values (16)	19060	8.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	237906	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
M	67805	28.5%
A	67219	28.3%
I	66684	28.0%
P	3331	1.4%
G	2740	1.2%
E	2460	1.0%
H	2303	1.0%
X	2179	0.9%
D	2091	0.9%
R	2034	0.9%
Other values (16)	19060	8.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	237906	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
M	67805	28.5%
A	67219	28.3%
I	66684	28.0%
P	3331	1.4%
G	2740	1.2%
E	2460	1.0%
H	2303	1.0%
X	2179	0.9%
D	2091	0.9%
R	2034	0.9%
Other values (16)	19060	8.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	237906	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
M	67805	28.5%
A	67219	28.3%
I	66684	28.0%
P	3331	1.4%
G	2740	1.2%
E	2460	1.0%
H	2303	1.0%
X	2179	0.9%
D	2091	0.9%
R	2034	0.9%
Other values (16)	19060	8.0%

OD Real Destination
Categorical

HIGH CORRELATION

Distinct	37
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	619.7 KiB

BOG	14925
MDE	7769
UIO	6025
GUA	5008
SAL	4603
Other values (32)	40972

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	237906
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6 ?
Unique (%)	< 0.1%

Sample

1st row	CWB
2nd row	ASU
3rd row	GUA
4th row	BOG
5th row	UIO

Common Values

Value	Count	Frequency (%)
BOG	14925	18.8%
MDE	7769	9.8%
UIO	6025	7.6%
GUA	5008	6.3%
SAL	4603	5.8%
VCP	4588	5.8%
SJO	3962	5.0%
GYE	3958	5.0%
SDQ	3705	4.7%
MVD	3028	3.8%
Other values (27)	21731	27.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
bog	14925	18.8%
mde	7769	9.8%
uio	6025	7.6%
gua	5008	6.3%
sal	4603	5.8%
vcp	4588	5.8%
sjo	3962	5.0%
gye	3958	5.0%
sdq	3705	4.7%
mvd	3028	3.8%
Other values (27)	21731	27.4%

Most occurring characters

Value	Count	Frequency (%)
O	28640	12.0%
G	25409	10.7%
S	18767	7.9%
B	18586	7.8%
A	17120	7.2%
E	15536	6.5%
M	15435	6.5%
U	14935	6.3%
D	14505	6.1%
L	11450	4.8%
Other values (15)	57523	24.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	237906	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
O	28640	12.0%
G	25409	10.7%
S	18767	7.9%
B	18586	7.8%
A	17120	7.2%
E	15536	6.5%
M	15435	6.5%
U	14935	6.3%
D	14505	6.1%
L	11450	4.8%
Other values (15)	57523	24.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	237906	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
O	28640	12.0%
G	25409	10.7%
S	18767	7.9%
B	18586	7.8%
A	17120	7.2%
E	15536	6.5%
M	15435	6.5%
U	14935	6.3%
D	14505	6.1%
L	11450	4.8%
Other values (15)	57523	24.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	237906	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
O	28640	12.0%
G	25409	10.7%
S	18767	7.9%
B	18586	7.8%
A	17120	7.2%
E	15536	6.5%
M	15435	6.5%
U	14935	6.3%
D	14505	6.1%
L	11450	4.8%
Other values (15)	57523	24.2%

OD Network Origin
Categorical

IMBALANCE

Distinct	35
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	619.7 KiB

MIA	75910
LHR	555
VCP	454
GRU	366
MAD	351
Other values (30)	1666

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	237906
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

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

Common Values

Value	Count	Frequency (%)
MIA	75910	95.7%
LHR	555	0.7%
VCP	454	0.6%
GRU	366	0.5%
MAD	351	0.4%
BOG	254	0.3%
UIO	246	0.3%
MDE	143	0.2%
EZE	139	0.2%
SCL	127	0.2%
Other values (25)	757	1.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
mia	75910	95.7%
lhr	555	0.7%
vcp	454	0.6%
gru	366	0.5%
mad	351	0.4%
bog	254	0.3%
uio	246	0.3%
mde	143	0.2%
eze	139	0.2%
scl	127	0.2%
Other values (25)	757	1.0%

Most occurring characters

Value	Count	Frequency (%)
M	76663	32.2%
A	76326	32.1%
I	76314	32.1%
R	921	0.4%
L	857	0.4%
C	731	0.3%
D	672	0.3%
O	656	0.3%
G	643	0.3%
U	622	0.3%
Other values (16)	3501	1.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	237906	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
M	76663	32.2%
A	76326	32.1%
I	76314	32.1%
R	921	0.4%
L	857	0.4%
C	731	0.3%
D	672	0.3%
O	656	0.3%
G	643	0.3%
U	622	0.3%
Other values (16)	3501	1.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	237906	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
M	76663	32.2%
A	76326	32.1%
I	76314	32.1%
R	921	0.4%
L	857	0.4%
C	731	0.3%
D	672	0.3%
O	656	0.3%
G	643	0.3%
U	622	0.3%
Other values (16)	3501	1.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	237906	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
M	76663	32.2%
A	76326	32.1%
I	76314	32.1%
R	921	0.4%
L	857	0.4%
C	731	0.3%
D	672	0.3%
O	656	0.3%
G	643	0.3%
U	622	0.3%
Other values (16)	3501	1.5%

OD Network Destination
Categorical

HIGH CORRELATION

Distinct	35
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	619.7 KiB

BOG	14947
MDE	7749
UIO	6026
GUA	5007
SAL	4604
Other values (30)	40969

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	237906
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	CWB
2nd row	ASU
3rd row	GUA
4th row	BOG
5th row	UIO

Common Values

Value	Count	Frequency (%)
BOG	14947	18.8%
MDE	7749	9.8%
UIO	6026	7.6%
GUA	5007	6.3%
SAL	4604	5.8%
VCP	4555	5.7%
GYE	3957	5.0%
SJO	3942	5.0%
SDQ	3701	4.7%
MVD	3060	3.9%
Other values (25)	21754	27.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
bog	14947	18.8%
mde	7749	9.8%
uio	6026	7.6%
gua	5007	6.3%
sal	4604	5.8%
vcp	4555	5.7%
gye	3957	5.0%
sjo	3942	5.0%
sdq	3701	4.7%
mvd	3060	3.9%
Other values (25)	21754	27.4%

Most occurring characters

Value	Count	Frequency (%)
O	28660	12.0%
G	25416	10.7%
S	18725	7.9%
B	18599	7.8%
A	17098	7.2%
E	15520	6.5%
M	15490	6.5%
U	14928	6.3%
D	14552	6.1%
L	11470	4.8%
Other values (12)	57448	24.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	237906	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
O	28660	12.0%
G	25416	10.7%
S	18725	7.9%
B	18599	7.8%
A	17098	7.2%
E	15520	6.5%
M	15490	6.5%
U	14928	6.3%
D	14552	6.1%
L	11470	4.8%
Other values (12)	57448	24.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	237906	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
O	28660	12.0%
G	25416	10.7%
S	18725	7.9%
B	18599	7.8%
A	17098	7.2%
E	15520	6.5%
M	15490	6.5%
U	14928	6.3%
D	14552	6.1%
L	11470	4.8%
Other values (12)	57448	24.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	237906	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
O	28660	12.0%
G	25416	10.7%
S	18725	7.9%
B	18599	7.8%
A	17098	7.2%
E	15520	6.5%
M	15490	6.5%
U	14928	6.3%
D	14552	6.1%
L	11470	4.8%
Other values (12)	57448	24.1%

Airway Bill Number
Real number (ℝ)

HIGH CORRELATION

Distinct	78798
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.7671095 × 10¹⁰

Minimum	1.3069979 × 10⁸
Maximum	9.9612717 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	619.7 KiB

Quantile statistics

Minimum	1.3069979 × 10⁸
5-th percentile	1.6056014 × 10¹⁰
Q1	7.2941526 × 10¹⁰
median	7.2941767 × 10¹⁰
Q3	7.2942016 × 10¹⁰
95-th percentile	7.2947241 × 10¹⁰
Maximum	9.9612717 × 10¹⁰
Range	9.9482017 × 10¹⁰
Interquartile range (IQR)	489946.5

Descriptive statistics

Standard deviation	1.7352089 × 10¹⁰
Coefficient of variation (CV)	0.25641803
Kurtosis	7.0836618
Mean	6.7671095 × 10¹⁰
Median Absolute Deviation (MAD)	246004
Skewness	-2.9356186
Sum	5.3664532 × 10¹⁵
Variance	3.0109498 × 10²⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.294687497 × 10¹⁰	3	< 0.1%
7.294143811 × 10¹⁰	3	< 0.1%
7.294200908 × 10¹⁰	3	< 0.1%
7.294743217 × 10¹⁰	3	< 0.1%
7.294125522 × 10¹⁰	2	< 0.1%
2.023023032 × 10¹⁰	2	< 0.1%
7.294212536 × 10¹⁰	2	< 0.1%
7.294134278 × 10¹⁰	2	< 0.1%
7.294189501 × 10¹⁰	2	< 0.1%
7.294196226 × 10¹⁰	2	< 0.1%
Other values (78788)	79278	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
130699793	1	< 0.1%
130699830	1	< 0.1%
130906282	1	< 0.1%
130970881	1	< 0.1%
131039411	1	< 0.1%
131039433	1	< 0.1%
131042852	1	< 0.1%
131084874	1	< 0.1%
131084900	1	< 0.1%
131417422	1	< 0.1%

Value	Count	Frequency (%)
9.96127172 × 10¹⁰	1	< 0.1%
9.96126112 × 10¹⁰	1	< 0.1%
9.961260382 × 10¹⁰	1	< 0.1%
9.961255786 × 10¹⁰	1	< 0.1%
9.961247806 × 10¹⁰	1	< 0.1%
9.961244774 × 10¹⁰	1	< 0.1%
9.961232388 × 10¹⁰	1	< 0.1%
9.961227529 × 10¹⁰	1	< 0.1%
9.961227366 × 10¹⁰	1	< 0.1%
9.961225519 × 10¹⁰	1	< 0.1%

Flight_date
Date

Distinct	243
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	619.7 KiB

Minimum	2023-01-01 00:00:00
Maximum	2023-08-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Agency
Text

Distinct	1465
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	619.7 KiB

Length

Max length	73
Median length	49
Mean length	18.406509
Min length	3

Characters and Unicode

Total characters	1459673
Distinct characters	74
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	444 ?
Unique (%)	0.6%

Sample

1st row	HERCO FREIGHT FORWARDERS INC
2nd row	INTERLINEO - UPS
3rd row	SOUTHERN CROSS TRADING INC
4th row	INTERLINEO - CATHAY PACIFIC
5th row	FLASHCARGO GROUP CORP

Value	Count	Frequency (%)
inc	13645	6.1%
	11240	5.0%
cargo	10382	4.6%
logistics	8513	3.8%
interlineo	7368	3.3%
avianca	6279	2.8%
international	4954	2.2%
corp	4846	2.2%
llc	4550	2.0%
freight	4335	1.9%
Other values (1610)	148367	66.1%

Most occurring characters

Value	Count	Frequency (%)
	147677	10.1%
A	140000	9.6%
I	138162	9.5%
R	107549	7.4%
N	101167	6.9%
E	100758	6.9%
O	97702	6.7%
C	92840	6.4%
S	85621	5.9%
T	80909	5.5%
Other values (64)	367288	25.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1459673	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	147677	10.1%
A	140000	9.6%
I	138162	9.5%
R	107549	7.4%
N	101167	6.9%
E	100758	6.9%
O	97702	6.7%
C	92840	6.4%
S	85621	5.9%
T	80909	5.5%
Other values (64)	367288	25.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1459673	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	147677	10.1%
A	140000	9.6%
I	138162	9.5%
R	107549	7.4%
N	101167	6.9%
E	100758	6.9%
O	97702	6.7%
C	92840	6.4%
S	85621	5.9%
T	80909	5.5%
Other values (64)	367288	25.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1459673	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	147677	10.1%
A	140000	9.6%
I	138162	9.5%
R	107549	7.4%
N	101167	6.9%
E	100758	6.9%
O	97702	6.7%
C	92840	6.4%
S	85621	5.9%
T	80909	5.5%
Other values (64)	367288	25.2%

Volume (m3)
Real number (ℝ)

HIGH CORRELATION

Distinct	36460
Distinct (%)	46.0%
Missing	51
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	4.9458124

Minimum	0
Maximum	461.39077
Zeros	40
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	619.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0.016379672
Q1	0.26639467
median	1.2904542
Q3	4.5460491
95-th percentile	21.609678
Maximum	461.39077
Range	461.39077
Interquartile range (IQR)	4.2796544

Descriptive statistics

Standard deviation	12.166427
Coefficient of variation (CV)	2.4599452
Kurtosis	175.76605
Mean	4.9458124
Median Absolute Deviation (MAD)	1.2222356
Skewness	9.67206
Sum	391960.57
Variance	148.02195
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.005999880002	1729	2.2%
0.01199976	1053	1.3%
9.899802004	743	0.9%
0.01799964001	672	0.8%
0.02399952001	544	0.7%
0.03599928001	451	0.6%
0.02999940001	433	0.5%
0.04199916002	334	0.4%
0.04799904002	301	0.4%
0.05999880002	247	0.3%
Other values (36450)	72744	91.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	40	0.1%
0.0001199976	2	< 0.1%
0.0004199916002	1	< 0.1%
0.0005399892002	1	< 0.1%
0.0008399832003	3	< 0.1%
0.0009599808004	3	< 0.1%
0.0011399772	1	< 0.1%
0.001199976	1	< 0.1%
0.001319973601	1	< 0.1%
0.001379972401	1	< 0.1%

Value	Count	Frequency (%)
461.3907722	1	< 0.1%
425.7843643	1	< 0.1%
413.9917202	1	< 0.1%
376.4215516	1	< 0.1%
353.0929381	1	< 0.1%
314.2838543	1	< 0.1%
272.3945521	1	< 0.1%
271.7945641	1	< 0.1%
267.8600228	1	< 0.1%
262.1947561	1	< 0.1%

KG Volumetric
Real number (ℝ)

HIGH CORRELATION

Distinct	37082
Distinct (%)	46.8%
Missing	51
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	824.31854

Minimum	0
Maximum	76900
Zeros	40
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	619.7 KiB

Quantile statistics

Minimum	0
5-th percentile	2.73
Q1	44.4
median	215.08
Q3	757.69
95-th percentile	3601.685
Maximum	76900
Range	76900
Interquartile range (IQR)	713.29

Descriptive statistics

Standard deviation	2027.7784
Coefficient of variation (CV)	2.4599452
Kurtosis	175.76605
Mean	824.31854
Median Absolute Deviation (MAD)	203.71
Skewness	9.67206
Sum	65328069
Variance	4111885.4
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1729	2.2%
2	1053	1.3%
1650	743	0.9%
3	672	0.8%
4	544	0.7%
6	451	0.6%
5	433	0.5%
7	334	0.4%
8	300	0.4%
10	247	0.3%
Other values (37072)	72745	91.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	40	0.1%
0.02	2	< 0.1%
0.07	1	< 0.1%
0.09	1	< 0.1%
0.14	3	< 0.1%
0.16	3	< 0.1%
0.19	1	< 0.1%
0.2	1	< 0.1%
0.22	1	< 0.1%
0.23	1	< 0.1%

Value	Count	Frequency (%)
76900	1	< 0.1%
70965.48	1	< 0.1%
69000	1	< 0.1%
62738.18	1	< 0.1%
58850	1	< 0.1%
52381.69	1	< 0.1%
45400	1	< 0.1%
45300	1	< 0.1%
44644.23	1	< 0.1%
43700	1	< 0.1%

Cargo Type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	619.7 KiB

Others	41422
Volume	20475
Dense	17405

Length

Max length	6
Median length	6
Mean length	5.7805226
Min length	5

Characters and Unicode

Total characters	458407
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
Others	41422	52.2%
Volume	20475	25.8%
Dense	17405	21.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
others	41422	52.2%
volume	20475	25.8%
dense	17405	21.9%

Most occurring characters

Value	Count	Frequency (%)
e	96707	21.1%
s	58827	12.8%
O	41422	9.0%
t	41422	9.0%
h	41422	9.0%
r	41422	9.0%
V	20475	4.5%
o	20475	4.5%
l	20475	4.5%
u	20475	4.5%
Other values (3)	55285	12.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	458407	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	96707	21.1%
s	58827	12.8%
O	41422	9.0%
t	41422	9.0%
h	41422	9.0%
r	41422	9.0%
V	20475	4.5%
o	20475	4.5%
l	20475	4.5%
u	20475	4.5%
Other values (3)	55285	12.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	458407	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	96707	21.1%
s	58827	12.8%
O	41422	9.0%
t	41422	9.0%
h	41422	9.0%
r	41422	9.0%
V	20475	4.5%
o	20475	4.5%
l	20475	4.5%
u	20475	4.5%
Other values (3)	55285	12.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	458407	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	96707	21.1%
s	58827	12.8%
O	41422	9.0%
t	41422	9.0%
h	41422	9.0%
r	41422	9.0%
V	20475	4.5%
o	20475	4.5%
l	20475	4.5%
u	20475	4.5%
Other values (3)	55285	12.1%

KG Chg Operational
Real number (ℝ)

HIGH CORRELATION

Distinct	28662
Distinct (%)	36.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	945.32825

Minimum	0.33
Maximum	76900
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	619.7 KiB

Quantile statistics

Minimum	0.33
5-th percentile	3
Q1	58
median	262.3
Q3	898
95-th percentile	4077.0226
Maximum	76900
Range	76899.67
Interquartile range (IQR)	840

Descriptive statistics

Standard deviation	2277.5988
Coefficient of variation (CV)	2.4093206
Kurtosis	162.02157
Mean	945.32825
Median Absolute Deviation (MAD)	248.3
Skewness	9.5737907
Sum	74966421
Variance	5187456.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1904	2.4%
2	1190	1.5%
3	820	1.0%
4	693	0.9%
6	569	0.7%
5	562	0.7%
1650	428	0.5%
7	414	0.5%
8	413	0.5%
10	360	0.5%
Other values (28652)	71949	90.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.33	1	< 0.1%
0.4	1	< 0.1%
0.5	2	< 0.1%
0.6	1	< 0.1%
0.6321309656	1	< 0.1%
0.78	1	< 0.1%
0.9	1	< 0.1%
0.96	2	< 0.1%
1	1904	2.4%
1.00002	9	< 0.1%

Value	Count	Frequency (%)
76900	1	< 0.1%
70965.48	1	< 0.1%
69000	1	< 0.1%
62738.18	1	< 0.1%
58850	1	< 0.1%
56800	1	< 0.1%
54943.01	1	< 0.1%
54172	1	< 0.1%
53117	1	< 0.1%
52381.69	1	< 0.1%

Auto

Heatmap
Table

	AWB Prefix	Airway Bill Number	Bellies - Freighters	Cargo Type	Day	KG Chg Operational	KG OB Chg	KG OB Gross	KG Volumetric	LEG	Leg Destination	Month	OD Network Destination	OD Network Origin	OD Real Destination	Operating Flight Number	Pieces	ProductCode	Route Owner	Volume (m3)	Week
AWB Prefix	1.000	0.536	0.095	0.066	-0.006	0.049	0.044	0.031	0.074	0.071	0.071	-0.026	0.099	0.196	0.099	-0.021	0.003	0.081	0.063	0.074	-0.027
Airway Bill Number	0.536	1.000	0.095	0.066	0.060	0.048	0.043	0.036	0.064	0.071	0.071	0.557	0.099	0.196	0.099	0.003	-0.005	0.081	0.063	0.064	0.559
Bellies - Freighters	0.095	0.095	1.000	0.277	0.015	0.033	0.041	0.039	0.029	0.602	0.602	0.029	0.500	0.061	0.500	0.999	0.035	0.763	0.999	0.029	0.021
Cargo Type	0.066	0.066	0.277	1.000	0.004	0.081	0.104	0.086	0.077	0.142	0.142	0.016	0.161	0.090	0.161	0.195	0.051	0.265	0.196	0.077	0.015
Day	-0.006	0.060	0.015	0.004	1.000	0.005	0.002	0.002	0.005	0.069	0.069	0.003	0.042	0.024	0.037	0.012	0.000	0.008	0.027	0.005	0.127
KG Chg Operational	0.049	0.048	0.033	0.081	0.005	1.000	0.995	0.980	0.982	0.060	0.060	0.025	0.171	0.000	0.173	0.219	0.612	0.018	0.018	0.982	0.025
KG OB Chg	0.044	0.043	0.041	0.104	0.002	0.995	1.000	0.981	0.974	0.067	0.067	0.022	0.178	0.000	0.180	0.220	0.604	0.024	0.022	0.974	0.022
KG OB Gross	0.031	0.036	0.039	0.086	0.002	0.980	0.981	1.000	0.948	0.066	0.066	0.023	0.185	0.000	0.187	0.209	0.606	0.019	0.021	0.948	0.023
KG Volumetric	0.074	0.064	0.029	0.077	0.005	0.982	0.974	0.948	1.000	0.055	0.055	0.025	0.148	0.000	0.150	0.217	0.617	0.018	0.015	1.000	0.024
LEG	0.071	0.071	0.602	0.142	0.069	0.060	0.067	0.066	0.055	1.000	1.000	0.103	0.745	0.081	0.745	0.301	0.055	0.187	0.601	0.055	0.092
Leg Destination	0.071	0.071	0.602	0.142	0.069	0.060	0.067	0.066	0.055	1.000	1.000	0.103	0.745	0.081	0.745	0.301	0.055	0.187	0.601	0.055	0.092
Month	-0.026	0.557	0.029	0.016	0.003	0.025	0.022	0.023	0.025	0.103	0.103	1.000	0.046	0.032	0.039	0.028	0.013	0.030	0.078	0.025	0.992
OD Network Destination	0.099	0.099	0.500	0.161	0.042	0.171	0.178	0.185	0.148	0.745	0.745	0.046	1.000	0.142	0.968	0.251	0.078	0.204	0.463	0.148	0.043
OD Network Origin	0.196	0.196	0.061	0.090	0.024	0.000	0.000	0.000	0.000	0.081	0.081	0.032	0.142	1.000	0.065	0.024	0.000	0.110	0.059	0.000	0.029
OD Real Destination	0.099	0.099	0.500	0.161	0.037	0.173	0.180	0.187	0.150	0.745	0.745	0.039	0.968	0.065	1.000	0.250	0.078	0.204	0.463	0.150	0.037
Operating Flight Number	-0.021	0.003	0.999	0.195	0.012	0.219	0.220	0.209	0.217	0.301	0.301	0.028	0.251	0.024	0.250	1.000	0.101	0.382	0.578	0.217	0.027
Pieces	0.003	-0.005	0.035	0.051	0.000	0.612	0.604	0.606	0.617	0.055	0.055	0.013	0.078	0.000	0.078	0.101	1.000	0.013	0.019	0.617	0.012
ProductCode	0.081	0.081	0.763	0.265	0.008	0.018	0.024	0.019	0.018	0.187	0.187	0.030	0.204	0.110	0.204	0.382	0.013	1.000	0.455	0.018	0.026
Route Owner	0.063	0.063	0.999	0.196	0.027	0.018	0.022	0.021	0.015	0.601	0.601	0.078	0.463	0.059	0.463	0.578	0.019	0.455	1.000	0.015	0.070
Volume (m3)	0.074	0.064	0.029	0.077	0.005	0.982	0.974	0.948	1.000	0.055	0.055	0.025	0.148	0.000	0.150	0.217	0.617	0.018	0.015	1.000	0.024
Week	-0.027	0.559	0.021	0.015	0.127	0.025	0.022	0.023	0.024	0.092	0.092	0.992	0.043	0.029	0.037	0.027	0.012	0.026	0.070	0.024	1.000

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.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	Day	Month	Year	Week	AWB Prefix	Operating Flight Number	Route Owner	Leg Origin	Leg Destination	LEG	Pieces	KG OB Chg	KG OB Gross	Bellies - Freighters	ProductCode	Commodity Unificado	Commodity	OD Real Origin	OD Real Destination	OD Network Origin	OD Network Destination	Airway Bill Number	Flight_date	Agency	Cargo Type	KG Chg Operational
0	29	1	2023	5	729	4055	QT	MIA	CWB	MIACWB	1	132.0	132.0	Freighters	DGR	DGR	5506	MIA	CWB	MIA	CWB	72941471065	2023-01-29	HERCO FREIGHT FORWARDERS INC	Dense	132.0
1	20	4	2023	17	406	4087	QT	MIA	ASU	MIAASU	64	755.0	754.0	Freighters	CAC	CAC	9997	MIA	ASU	MIA	ASU	40601511355	2023-04-20	INTERLINEO - UPS	Others	754.0
2	11	1	2023	3	729	4069	QT	MIA	GUA	MIAGUA	1	150.0	150.0	Freighters	HUM	HUM	9091	MIA	GUA	MIA	GUA	72941603531	2023-01-11	SOUTHERN CROSS TRADING INC	Dense	150.0
3	14	8	2023	34	160	4281	QT	MIA	BOG	MIABOG	41	337.0	337.0	Freighters	GCR	GCR	9985	XMN	BOG	MIA	BOG	16055155192	2023-08-14	INTERLINEO - CATHAY PACIFIC	Others	337.0
4	27	4	2023	18	729	4039	QT	MIA	GYE	MIAGYE	7	263.0	263.0	Freighters	GCR	STD,GCR	9985	MIA	UIO	MIA	UIO	72941688124	2023-04-27	FLASHCARGO GROUP CORP	Others	263.0
5	23	2	2023	9	729	4171	QT	MIA	SJO	MIASJO	1	268.5	122.0	Freighters	GCR	PRI,GCR	8575	MIA	SJO	MIA	SJO	72941726296	2023-02-23	KUEHNE & NAGEL	Volume	122.0
6	6	5	2023	19	729	4071	QT	MIA	PTY	MIAPTY	24	1612.5	134.0	Freighters	GCR	STD,GCR	4711	VCP	PTY	VCP	PTY	72946767453	2023-05-06	VENTANA CARGO DO BRASIL	Others	134.0
7	9	2	2023	7	729	4171	QT	MIA	SJO	MIASJO	1	280.0	130.0	Freighters	GCR	STD,GCR	9985	MIA	SJO	MIA	SJO	72941481366	2023-02-09	MAGNUM FREIGHT CORPORATION	Volume	130.0
8	30	8	2023	36	729	4071	QT	MIA	PTY	MIAPTY	3	101.0	101.0	Freighters	CAC	CAC	9997	MIA	BOG	MIA	BOG	72941953435	2023-08-30	COLOMBIANA DE CARGA	Others	101.0
9	25	3	2023	13	729	4129	QT	MIA	MDE	MIAMDE	3	146.0	82.0	Freighters	GCR	STD,GCR	4119	UIO	MDE	UIO	MDE	72947241891	2023-03-25	AEROGAL	Others	82.0

	Day	Month	Year	Week	AWB Prefix	Operating Flight Number	Route Owner	Leg Origin	Leg Destination	LEG	Pieces	KG OB Chg	KG OB Gross	Bellies - Freighters	ProductCode	Commodity Unificado	Commodity	OD Real Origin	OD Real Destination	OD Network Origin	OD Network Destination	Airway Bill Number	Flight_date	Agency	Volume (m3)	KG Volumetric	Cargo Type	KG Chg Operational
79292	7	7	2023	28	160	4085	QT	MIA	SDQ	MIASDQ	2	172.0	172.0	Freighters	GCR	GCR	9985	PVG	SDQ	MIA	SDQ	16056711362	2023-07-07	INTERLINEO - CATHAY PACIFIC	NaN	NaN	Dense	172.0
79293	19	2	2023	8	729	4041	QT	MIA	BOG	MIABOG	2	50.0	20.0	Freighters	DGR	DGR	4406	DFW	LIM	MIA	LIM	72941343584	2023-02-19	DHL GLOBAL FORWARDING	NaN	NaN	Others	20.0
79294	9	7	2023	28	729	4141	QT	MIA	BOG	MIABOG	3	897.0	644.2	Freighters	PIL	PIP	6502	OMA	LIM	MIA	LIM	72941926802	2023-07-09	DSV	NaN	NaN	Volume	644.2
79295	6	7	2023	28	729	4171	QT	MIA	SJO	MIASJO	1	5211.0	124.0	Freighters	GCR	GCR	9985	MIA	VCP	MIA	SJO	72941943860	2023-07-06	HERMES AVIATION LLC	NaN	NaN	Volume	124.0
79296	16	4	2023	16	202	4055	QT	MIA	CWB	MIACWB	3	28.0	12.0	Freighters	GCR	GCR	9985	FLR	CWB	MAD	CWB	20230332046	2023-04-16	ALBINI ANDPITIGLIANI	NaN	NaN	Others	12.0
79297	16	8	2023	34	729	4051	QT	MIA	VCP	MIAVCP	10	2623.0	2623.0	Freighters	DGR	DGR	3077	ORD	VCP	MIA	VCP	72942169702	2023-08-16	HERMES AVIATION LLC	NaN	NaN	Dense	2623.0
79298	23	3	2023	13	729	4091	QT	MIA	MVD	MIAMVD	1	3.5	1.0	Freighters	GCR	STD,GCR	6010	IAD	MVD	MIA	MVD	72941390904	2023-03-23	EXPEDITORS	NaN	NaN	Others	1.0
79299	18	6	2023	25	729	4047	QT	MIA	AGT	MIAAGT	1	9.5	1.0	Freighters	DGR	DGR	5506	DFW	VCP	MIA	VCP	72941291202	2023-06-18	DB SCHENKER	NaN	NaN	Others	1.0
79300	9	6	2023	24	729	4083	QT	MIA	SDQ	MIASDQ	6	324.5	305.0	Freighters	GCR	STD,EAP,GCR	9985	CWB	SDQ	VCP	SDQ	72946778561	2023-06-09	GEODIS WILSON	NaN	NaN	Volume	305.0
79301	4	5	2023	19	729	4071	QT	MIA	PTY	MIAPTY	1	236.0	236.0	Freighters	GCR	GCR	4711	YHM	PTY	MIA	PTY	72948337730	2023-05-04	CARGOLUTIONS INC	NaN	NaN	Dense	236.0

	Day	Month	Year	Week	AWB Prefix	Operating Flight Number	Route Owner	Leg Origin	Leg Destination	LEG	Pieces	KG OB Chg	KG OB Gross	Bellies - Freighters	ProductCode	Commodity Unificado	Commodity	OD Real Origin	OD Real Destination	OD Network Origin	OD Network Destination	Airway Bill Number	Flight_date	Agency	Volume (m3)	KG Volumetric	Cargo Type	KG Chg Operational
45838	25	5	2023	22	729	4225	QT	MIA	CLO	MIACLO	1	305.000000	248.00	Freighters	GCR	STD,GCR	9985	MIA	CLO	MIA	CLO	72942034215	2023-05-25	FAST CARGO CORP	1.828523	304.76000	Volume	304.76000
27272	30	8	2023	36	235	4257	QT	MIA	SAL	MIASAL	8	135.000000	135.00	Freighters	NaN	GCR	0	CAN	SAL	MIA	SAL	23529289455	2023-08-30	INTERLINEO - TURKISH AIRLINES	0.590148	98.36000	Others	135.00000
16635	8	1	2023	2	729	4099	QT	MIA	EZE	MIAEZE	5	28.500000	22.00	Freighters	DGR	DGR	9735	MIA	MVD	MIA	MVD	72940171014	2023-01-08	USA CARGO & COURIER	0.173097	28.85000	Others	28.85000
58539	8	6	2023	24	729	4133	QT	MIA	BOG	MIABOG	12	354.000000	316.00	Freighters	GCR	STD,GCR	9985	MIA	GYE	MIA	GYE	72941910643	2023-06-08	GLOVAL SHIPPING USA LLC	4.240355	706.74000	Others	706.74000
8062	3	6	2023	23	729	4073	QT	MIA	PTY	MIAPTY	3	8.500000	3.00	Freighters	DGR	DGR	9735	MIA	PTY	MIA	PTY	72942043562	2023-06-03	TLA LOGISTICS CORP	0.039479	6.58000	Others	6.58000
51667	8	2	2023	7	729	4069	QT	MIA	GUA	MIAGUA	1	446.000000	177.00	Freighters	GCR	STD,GCR	9985	MIA	GUA	MIA	GUA	72941547214	2023-02-08	TALATRANS WORLDWIDE CORPORATION	2.675346	445.90000	Volume	445.90000
49801	28	1	2023	5	729	4211	QT	MIA	MDE	MIAMDE	1	394.000000	306.00	Freighters	DGR	DGR	2631	MIA	MDE	MIA	MDE	72941498192	2023-01-28	AIR MARINE FORWARDING	2.364253	394.05000	Volume	394.05000
64902	29	4	2023	18	729	4191	QT	MIA	BOG	MIABOG	35	1277.000000	748.00	Freighters	CAC	CAC	9997	MIA	BOG	MIA	BOG	72941853346	2023-04-29	LATIN LOGISTICS	6.988360	1164.75000	Others	1164.75000
49313	13	8	2023	33	729	4257	QT	MIA	SAL	MIASAL	2	381.000000	198.00	Freighters	GCR	GCR	9985	MIA	SAL	MIA	SAL	72942134271	2023-08-13	EXPEDITORS	2.291414	381.91000	Volume	381.91000
22517	19	4	2023	17	729	4257	QT	MIA	SAL	MIASAL	3	61.000000	61.00	Freighters	COM	COM,GCR	9724	MIA	SAL	MIA	SAL	72941810370	2023-04-19	COMAT AERONAUTICO MIA	0.365993	61.00000	Others	61.00000
74519	22	6	2023	26	729	4139	QT	MIA	BOG	MIABOG	5	2667.000000	2667.00	Freighters	CAC	CAC	9997	MIA	BOG	MIA	BOG	72941699943	2023-06-22	LARS COURIER	19.373673	3229.01000	Dense	3229.01000
77048	11	3	2023	11	729	4085	QT	MIA	SDQ	MIASDQ	51	3181.000000	3164.00	Freighters	CAC	CAC	9997	MIA	SDQ	MIA	SDQ	72941668535	2023-03-11	ATALLAH BUSINESS GROUP	30.764865	5127.58000	Volume	5127.58000
4936	14	5	2023	20	729	4087	QT	MIA	ASU	MIAASU	1	3.500000	1.00	Freighters	PER	COL,STD,GCR,PER	8575	MIA	SCL	MIA	SCL	72941510512	2023-05-14	KUEHNE & NAGEL	0.018900	3.15000	Others	3.15000
64124	17	6	2023	25	729	4145	QT	MIA	BOG	MIABOG	29	1092.000000	748.00	Freighters	DGR	DGR	5506	MIA	BOG	MIA	BOG	72942112022	2023-06-17	MAGNUM FREIGHT CORPORATION	6.519230	1086.56000	Others	1086.56000
43995	3	6	2023	23	729	4171	QT	MIA	SJO	MIASJO	2	274.500000	93.00	Freighters	GCR	STD,GCR	9985	MIA	SJO	MIA	SJO	72941835555	2023-06-03	GROUND CARGO TRANSPORTATION	1.646007	274.34000	Others	274.34000
59714	27	8	2023	35	319	4087	QT	MIA	ASU	MIAASU	118	1677.000000	1676.00	Freighters	PER	STD,CRT,PER	9731	BOM	ASU	MIA	ASU	31901500925	2023-08-27	INTERLINEO - FITS AVIATION	4.642527	773.77000	Others	1676.00000
1870	4	8	2023	32	729	4035	QT	MIA	UIO	MIAUIO	1	1.000000	1.00	Freighters	AOG	AOG	4105	MIA	UIO	MIA	UIO	72942096471	2023-08-04	COMAT AERONAUTICO MIA	0.006000	1.00000	Others	1.00000
26352	25	2	2023	9	729	4201	QT	MIA	BOG	MIABOG	1	90.000000	71.00	Freighters	DGR	DGR	2631	MIA	BOG	MIA	BOG	72941713464	2023-02-25	ACCESS INTERNATIONAL SERVICES CORP	0.539509	89.92000	Volume	89.92000
47451	5	2	2023	6	729	4087	QT	MIA	ASU	MIAASU	3	349.500000	285.00	Freighters	PER	COL,STD,PER	9731	MIA	ASU	MIA	ASU	72941517162	2023-02-05	KUEHNE & NAGEL	2.018600	336.44000	Volume	336.44000
62378	29	1	2023	5	729	4087	QT	MIA	ASU	MIAASU	13	1148.000000	1098.00	Freighters	GCR	GCR	9985	MIA	ASU	MIA	ASU	72941578670	2023-01-29	DSV	5.665327	944.24000	Volume	1098.00000
63171	3	6	2023	23	729	4047	QT	MIA	AGT	MIAAGT	3	1739.000000	1739.00	Freighters	GCR	STD,GCR	9985	MIA	VCP	MIA	VCP	72942040390	2023-06-03	EXPEDITORS	6.036899	1006.17000	Dense	1739.00000
54742	22	6	2023	26	729	4171	QT	MIA	SJO	MIASJO	2	542.000000	441.00	Freighters	GCR	STD,GCR	9985	MIA	SJO	MIA	SJO	72942053281	2023-06-22	FREIGHT LATAM LLC	3.244855	540.82000	Volume	540.82000
45137	17	6	2023	25	729	4137	QT	MIA	BOG	MIABOG	2	404.000000	404.00	Freighters	GCR	STD,GCR	9985	MIA	BOG	MIA	BOG	72941888254	2023-06-17	ROYALTY EXIMPORT	1.762645	293.78000	Dense	404.00000
42847	6	8	2023	32	729	4141	QT	MIA	BOG	MIABOG	1	257.000000	196.00	Freighters	PER	STD,CRT,PER	9731	MIA	LIM	MIA	LIM	72942133346	2023-08-06	EXPEDITORS	1.542269	257.05000	Volume	257.05000
3503	17	6	2023	25	729	4039	QT	MIA	GYE	MIAGYE	1	2.000000	1.00	Freighters	AOG	AOG	4105	MIA	UIO	MIA	UIO	72941815550	2023-06-17	COMAT AERONAUTICO MIA	0.012000	2.00000	Others	2.00000
53744	9	8	2023	33	729	4123	QT	MIA	MDE	MIAMDE	3	506.500000	329.00	Freighters	GCR	STD,GCR	9985	MIA	MDE	MIA	MDE	72942221616	2023-08-09	AMERIMPEX	3.038879	506.49000	Volume	506.49000
34924	2	4	2023	14	729	4099	QT	MIA	EZE	MIAEZE	3	168.000000	159.00	Freighters	GCR	GCR	9985	MIA	MVD	MIA	MVD	72941502436	2023-04-02	UPS SCS	0.986260	164.38000	Volume	164.38000
18814	9	4	2023	15	729	4091	QT	MIA	MVD	MIAMVD	2	39.500000	32.00	Freighters	GCR	STD,GCR	9985	MIA	MVD	MIA	MVD	72940380141	2023-04-09	FIRST CARGO CORP	0.236515	39.42000	Others	39.42000
41561	14	1	2023	3	729	4067	QT	MIA	MID	MIAMID	11	424.000000	424.00	Freighters	GCR	STD,GCR	9985	MIA	SJO	MIA	SJO	72941500314	2023-01-14	FLASHCARGO GROUP CORP	1.442611	240.44000	Others	424.00000
64906	17	5	2023	21	729	4099	QT	MIA	EZE	MIAEZE	18	1198.000000	1198.00	Freighters	GCR	STD,GCR	9985	MIA	VCP	MIA	VCP	72941742960	2023-05-17	DHL GLOBAL FORWARDING	6.990460	1165.10000	Dense	1198.00000
42425	21	6	2023	26	729	4099	QT	MIA	EZE	MIAEZE	1	126.000000	49.00	Freighters	GCR	GCR,NSC	9985	MIA	VCP	MIA	VCP	72942037516	2023-06-21	DB SCHENKER	1.510770	251.80000	Others	251.80000
64097	27	7	2023	31	729	4083	QT	MIA	SDQ	MIASDQ	21	664.000000	664.00	Freighters	NaN	COU	9997	MIA	SDQ	MIA	SDQ	72942150614	2023-07-27	RENAISSANCE INTERNATIONAL TRADING INC	6.506450	1084.43000	Others	1084.43000
60239	16	4	2023	16	729	4055	QT	MIA	CWB	MIACWB	1	1371.000000	1371.00	Freighters	GCR	STD,GCR	4711	ATL	CWB	MIA	CWB	72941762615	2023-04-16	NETWORK CARGO	4.819584	803.28000	Dense	1371.00000
55420	25	4	2023	18	729	4053	QT	MIA	EZE	MIAEZE	2	1550.000000	1550.00	Freighters	DGR	DGR	1133	MIA	EZE	MIA	EZE	72941754882	2023-04-25	JNC LOGISTICS SERVICES INC	3.399292	566.56000	Dense	1550.00000
40604	18	1	2023	4	729	4099	QT	MIA	EZE	MIAEZE	10	230.000000	118.00	Freighters	GCR	GCR	9985	MIA	VCP	MIA	VCP	72941559276	2023-01-18	SUPPLY CHAIN SHIPPING LLC	1.369473	228.25000	Others	228.25000
66227	23	6	2023	26	729	4257	QT	MIA	SAL	MIASAL	18	1310.000000	909.00	Freighters	GCR	STD,GCR	9985	MIA	SAL	MIA	SAL	72942069521	2023-06-23	UPS SCS	7.856483	1309.44000	Volume	1309.44000
35948	10	8	2023	33	729	4077	6R	MIA	GUA	MIAGUA	1	175.000000	166.00	Freighters	HUM	HUM	9091	MIA	GUA	MIA	GUA	72941883170	2023-08-10	TAMPA TRAFICO	1.049679	174.95000	Volume	174.95000
69754	2	4	2023	14	729	4099	QT	MIA	EZE	MIAEZE	21	1959.000000	1959.00	Freighters	GCR	STD,GCR	9985	MIA	MVD	MIA	MVD	72941739585	2023-04-02	JAUSER CARGO	10.487130	1747.89000	Dense	1959.00000
66790	13	5	2023	20	729	4137	QT	MIA	BOG	MIABOG	4	1075.000000	1075.00	Freighters	CAC	CAC	9997	MIA	BOG	MIA	BOG	72941900110	2023-05-13	A TIEMPO CARGO INC	8.332993	1388.86000	Dense	1388.86000
65765	17	4	2023	17	729	4237	QT	MIA	UIO	MIAUIO	46	1312.000000	1312.00	Freighters	CAC	CAC	9997	MIA	UIO	MIA	UIO	72941845020	2023-04-17	CARGO MASTER LOGISTICS INC	7.521510	1253.61000	Others	1312.00000
6935	26	2	2023	9	729	4091	QT	MIA	MVD	MIAMVD	1	5.000000	2.00	Freighters	GCR	STD,GCR	9985	MIA	MVD	MIA	MVD	72941235073	2023-02-26	NIPPON EXPRESS USA INC	0.030239	5.04000	Others	5.04000
46256	24	7	2023	31	729	4089	QT	MIA	ASU	MIAASU	8	346.000000	346.00	Freighters	GCR	GCR	9985	PVG	ASU	MIA	ASU	72948396784	2023-07-24	ALL LINK LOGISTICS SHANGHAI	1.878982	313.17000	Others	346.00000
32174	8	3	2023	11	729	4257	QT	MIA	SAL	MIASAL	2	150.000000	150.00	Freighters	GCR	GCR	9985	MIA	SAL	MIA	SAL	72941699206	2023-03-08	TRANS EXPRESS INC	0.818384	136.40000	Dense	150.00000
28352	22	8	2023	35	729	4145	QT	MIA	BOG	MIABOG	2	75.500000	31.00	Freighters	CAC	CAC	9997	MIA	BOG	MIA	BOG	72942106455	2023-08-22	UNION CARGO INTERNACIONAL LTDA	0.627947	104.66000	Others	104.66000
63950	9	5	2023	20	729	4083	QT	MIA	SDQ	MIASDQ	1	1073.000000	1073.00	Freighters	GCR	STD,GCR	6805	MDE	SDQ	MDE	SDQ	72943998850	2023-05-09	TRANSTAINER SAS	6.437871	1073.00000	Dense	1073.00000
14044	3	6	2023	23	1	4039	QT	MIA	GYE	MIAGYE	3	29.000000	28.00	Freighters	GCR	STD,GCR	9985	MIA	GYE	MIA	GYE	174211126	2023-06-03	INTERLINEO - AMERICAN AIRLINES	0.115678	19.28000	Others	28.00000
40789	17	5	2023	21	729	4057	QT	MIA	MAO	MIAMAO	1	780.000000	780.00	Freighters	GCR	GCR	9985	MIA	MAO	MIA	MAO	72941869520	2023-05-17	SAMSUNG	1.384892	230.82000	Dense	780.00000
63684	30	5	2023	23	729	4001	QT	MIA	BOG	MIABOG	3	1064.000000	1064.00	Freighters	GCR	STD,GCR	9985	MIA	BOG	MIA	BOG	72942047600	2023-05-30	RUSH AIRWAYS INC	6.312774	1052.15000	Dense	1064.00000
48284	15	1	2023	3	729	4283	QT	MIA	BOG	MIABOG	1	1078.000000	1078.00	Freighters	GCR	GCR	9985	MIA	BOG	MIA	BOG	72941406691	2023-01-15	GLOBAL CARGO ALLIANCE/COLBOX I	2.134397	355.74000	Dense	1078.00000
33583	6	6	2023	24	729	4231	QT	MIA	UIO	MIAUIO	6	104.000000	104.00	Freighters	CAC	CAC	9997	MIA	UIO	MIA	UIO	72942005806	2023-06-06	SFS CARGO EXPRESS INC	0.906462	151.08000	Others	151.08000
14589	21	1	2023	4	729	4225	QT	MIA	CLO	MIACLO	3	27.000000	27.00	Freighters	GCR	STD,GCR	9985	MIA	MDE	MIA	MDE	72941559335	2023-01-21	SUPPLY CHAIN SHIPPING LLC	0.127437	21.24000	Others	27.00000
69108	24	6	2023	26	729	4171	QT	MIA	SJO	MIASJO	1	1100.000000	1100.00	Freighters	CAC	CAC	9992	MIA	SJO	MIA	SJO	72942071676	2023-06-24	AEROPOST INTL SERV	9.899802	1650.00000	Dense	1650.00000
562	7	3	2023	11	729	127	AV	MIA	BOG	MIABOG	1	1.000000	1.00	Bellies	AOG	AOG	4105	MIA	BOG	MIA	BOG	72941642145	2023-03-07	AVIANCA	0.006000	1.00000	Others	1.00000
595	14	3	2023	12	729	31	AV	MIA	MDE	MIAMDE	2	1.000000	1.00	Bellies	AOG	AOG	4105	MIA	MDE	MIA	MDE	72941644186	2023-03-14	AVIANCA	0.006000	1.00000	Others	1.00000
65879	1	4	2023	14	729	4151	QT	MIA	BOG	MIABOG	60	1269.000000	1153.00	Freighters	GCR	GCR	9985	MIA	BOG	MIA	BOG	72941502241	2023-04-01	UPS SCS	7.613968	1269.02000	Others	1269.02000
29173	6	7	2023	28	729	4171	QT	MIA	SJO	MIASJO	1	110.000000	86.00	Freighters	AVI	AVI	1001	MIA	SJO	MIA	SJO	72941883634	2023-07-06	TAMPA TRAFICO	0.660947	110.16000	Volume	110.16000
44772	15	8	2023	34	729	4101	QT	MIA	CLO	MIACLO	1	288.500000	68.00	Freighters	GCR	GCR	9797	MIA	SCL	MIA	SCL	72942274422	2023-08-15	CONTROL TOWERS INTERNATIONAL INC	1.728925	288.16000	Volume	288.16000
54904	26	2	2023	9	729	4041	QT	MIA	BOG	MIABOG	28	573.000000	573.00	Freighters	GCR	STD,GCR	9985	MIA	LIM	MIA	LIM	72941489490	2023-02-26	SAMSUNG	3.275994	546.01000	Others	573.00000
57084	11	3	2023	11	729	4085	QT	MIA	SDQ	MIASDQ	2	851.500000	851.00	Freighters	GCR	GCR	9985	MIA	SDQ	MIA	SDQ	72941760600	2023-03-11	NETWORK CARGO	3.799784	633.31000	Volume	851.00000
75531	28	2	2023	10	729	4039	QT	MIA	GYE	MIAGYE	38	4418.500000	4418.00	Freighters	GCR	STD,GCR	9985	MIA	GYE	MIA	GYE	72941576802	2023-02-28	DSV	22.631487	3771.99000	Volume	4418.00000
74108	23	5	2023	22	729	4093	QT	MIA	CLO	MIACLO	17	3032.000000	1536.00	Freighters	GCR	GCR	9985	MIA	SCL	MIA	SCL	72941796716	2023-05-23	GRUPO DELPA CORP	18.194456	3032.47000	Volume	3032.47000
28994	22	4	2023	17	729	4039	QT	MIA	GYE	MIAGYE	1	179.000000	179.00	Freighters	GCR	STD,GCR,NSC	9797	SLC	GYE	MIA	GYE	72941752885	2023-04-22	DSV	0.654647	109.11000	Dense	179.00000
9208	15	6	2023	25	729	127	AV	MIA	BOG	MIABOG	1	4.000000	4.00	Bellies	COM	COM,GCR	9724	MIA	BOG	MIA	BOG	72941971591	2023-06-15	AVIANCA	0.047999	8.00000	Others	8.00000
12626	9	7	2023	28	729	4055	QT	MIA	CWB	MIACWB	1	15.000000	15.00	Freighters	GCR	STD,GCR,NSC	9985	LHR	CWB	LHR	CWB	72948462411	2023-07-09	DB SCHENKER	0.089998	15.00000	Others	15.00000
31170	10	6	2023	24	160	4039	QT	MIA	GYE	MIAGYE	4	127.500000	58.00	Freighters	GCR	STD,GCR	9985	XMN	GYE	MIA	GYE	16057546005	2023-06-10	INTERLINEO - CATHAY PACIFIC	0.763125	127.19000	Others	127.19000
30793	9	2	2023	7	729	4141	QT	MIA	BOG	MIABOG	1	125.000000	124.00	Freighters	PER	PER,PES	9731	MIA	BOG	MIA	BOG	72941548651	2023-02-09	ROYALTY EXIMPORT	0.747525	124.59000	Volume	124.59000
21129	14	2	2023	8	160	4039	QT	MIA	GYE	MIAGYE	1	45.000000	21.00	Freighters	DGR	DGR	6200	HGH	UIO	MIA	UIO	16052074551	2023-02-14	INTERLINEO - CATHAY PACIFIC	0.309834	51.64000	Others	51.64000
44085	19	2	2023	8	729	4087	QT	MIA	ASU	MIAASU	1	276.159722	228.00	Freighters	GCR	GCR	9985	MIA	EZE	MIA	EZE	72941438110	2023-02-19	CH ROBINSON	1.656953	276.16434	Volume	276.16434
56796	24	4	2023	18	729	4225	QT	MIA	CLO	MIACLO	30	622.000000	577.00	Freighters	GCR	STD,GCR	9985	MIA	CLO	MIA	CLO	72941703130	2023-04-24	GLOBAL CARGO ALLIANCE/COLBOX I	3.729525	621.60000	Others	621.60000
76549	8	5	2023	20	729	4089	QT	MIA	ASU	MIAASU	12	4765.500000	1744.00	Freighters	GCR	STD,GCR	9985	MIA	VCP	MIA	VCP	72941780653	2023-05-08	EXPEDITORS	28.003540	4667.35000	Volume	4667.35000
43011	19	4	2023	17	729	4083	QT	MIA	SDQ	MIASDQ	5	259.500000	196.00	Freighters	GCR	GCR	9985	MIA	SDQ	MIA	SDQ	72941753106	2023-04-19	DSV	1.555409	259.24000	Others	259.24000
22489	27	6	2023	27	729	4039	QT	MIA	GYE	MIAGYE	2	61.000000	61.00	Freighters	CAC	CAC	9997	MIA	GYE	MIA	GYE	72942052360	2023-06-27	WFL INC	0.365093	60.85000	Others	61.00000
19177	8	4	2023	15	729	4045	QT	MIA	AGT	MIAAGT	3	41.500000	24.00	Freighters	GCR	STD,GCR	9985	MIA	SCL	MIA	SCL	72941609772	2023-04-08	DRACO FREIGHT LOGISTICS CORPORATION	0.248995	41.50000	Others	41.50000
30096	6	7	2023	28	729	4055	QT	MIA	CWB	MIACWB	2	118.000000	67.00	Freighters	GCR	STD,GCR	9985	MIA	CWB	MIA	CWB	72942130550	2023-07-06	EXPEDITORS	0.706846	117.81000	Others	117.81000
73382	8	6	2023	24	729	4055	QT	MIA	CWB	MIACWB	13	6172.000000	6172.00	Freighters	GCR	STD,GCR	9985	MIA	CWB	MIA	CWB	72941830456	2023-06-08	AIB INTERNATIONAL LLC	16.282654	2713.83000	Dense	6172.00000
49815	14	5	2023	20	729	4091	QT	MIA	MVD	MIAMVD	2	395.500000	366.00	Freighters	GCR	STD,ELI,GCR	9985	MIA	EZE	MIA	EZE	72941512166	2023-05-14	KUEHNE & NAGEL	2.366893	394.49000	Volume	394.49000
61040	1	4	2023	14	729	4225	QT	MIA	CLO	MIACLO	7	651.000000	384.00	Freighters	GCR	GCR	9985	PVG	CLO	MIA	CLO	72947782195	2023-04-01	PEACE FREIGHTER INTERNATIONAL LOGISTICS CO LTD	5.116278	852.73000	Volume	852.73000
51606	31	8	2023	36	729	4171	QT	MIA	SJO	MIASJO	2	444.500000	444.00	Freighters	GCR	STD,GCR	4711	VCP	SJO	VCP	SJO	72948665525	2023-08-31	NEW FLAG LOGISTICS LTDA	2.663947	444.00000	Volume	444.00000
64982	20	1	2023	4	729	4239	QT	MIA	UIO	MIAUIO	28	1056.000000	1055.64	Freighters	CAC	CAC	9997	MIA	UIO	MIA	UIO	72940951993	2023-01-20	DBL EXPRESS LLC	7.034859	1172.50000	Others	1172.50000
8063	15	7	2023	29	729	4071	QT	MIA	PTY	MIAPTY	2	7.000000	2.00	Freighters	DGR	DGR	1224	MIA	PTY	MIA	PTY	72942055510	2023-07-15	INTERCONTINENTAL CARGO	0.039599	6.60000	Others	6.60000
6503	17	1	2023	4	729	31	AV	MIA	MDE	MIAMDE	1	5.000000	5.00	Bellies	COM	COM,GCR	9724	MIA	MDE	MIA	MDE	72941628204	2023-01-17	AVIANCA	0.029999	5.00000	Others	5.00000
4370	2	5	2023	19	729	127	AV	MIA	BOG	MIABOG	1	3.000000	3.00	Bellies	AOG	AOG	4105	MIA	BOG	MIA	BOG	72941656775	2023-05-02	AVIANCA	0.018000	3.00000	Others	3.00000
73034	6	4	2023	15	729	4039	QT	MIA	UIO	MIAUIO	7	2578.000000	1936.00	Freighters	GCR	GCR	9985	MIA	UIO	MIA	UIO	72940435511	2023-04-06	TMA LOGISTICS CORP	15.468411	2578.12000	Volume	2578.12000
73169	20	7	2023	30	729	4171	QT	MIA	SJO	MIASJO	19	2634.500000	2180.00	Freighters	GCR	STD,GCR	9985	MIA	SJO	MIA	SJO	72942131784	2023-07-20	EXPEDITORS	15.806384	2634.45000	Volume	2634.45000
21497	25	8	2023	35	729	5	AV	MIA	BOG	MIABOG	2	54.000000	54.00	Bellies	AOG	AOG	4105	MIA	BOG	MIA	BOG	72941989441	2023-08-25	AVIANCA	0.323994	54.00000	Others	54.00000
36941	18	3	2023	12	729	4171	QT	MIA	SJO	MIASJO	26	590.000000	589.00	Freighters	DGR	DGR	6200	MIA	SJO	MIA	SJO	72941685652	2023-03-18	PEGASUS LOGISTICS GROUP INC	1.104818	184.14000	Others	589.00000
53301	23	7	2023	30	729	4055	QT	MIA	CWB	MIACWB	10	496.500000	282.00	Freighters	DGR	DGR	9750	MIA	VCP	MIA	BOG	72942117283	2023-07-23	DHL GLOBAL FORWARDING	2.969941	495.00000	Others	495.00000
6513	31	1	2023	6	729	31	AV	MIA	MDE	MIAMDE	1	5.000000	5.00	Bellies	COM	COM,GCR	9724	MIA	MDE	MIA	MDE	72941631866	2023-01-31	AVIANCA	0.029999	5.00000	Others	5.00000
32265	28	5	2023	22	160	4169	QT	MIA	GUA	MIAGUA	25	213.000000	213.00	Freighters	GCR	GCR	9985	XMN	GUA	MIA	GUA	16055134951	2023-05-28	INTERLINEO - CATHAY PACIFIC	0.826183	137.70000	Others	213.00000
916	23	3	2023	13	729	31	AV	MIA	MDE	MIAMDE	1	2.000000	1.00	Bellies	AOG	GCR,AOG	9724	MIA	MDE	MIA	MDE	72941817591	2023-03-23	TAMPA CARGO	0.006000	1.00000	Others	1.00000
12884	26	7	2023	31	729	4135	QT	MIA	BOG	MIABOG	1	18.000000	18.00	Freighters	GCR	STD,GCR	9985	MIA	BOG	MIA	BOG	72942106330	2023-07-26	UNION CARGO INTERNACIONAL LTDA	0.095578	15.93000	Others	18.00000
45432	29	8	2023	36	729	4067	QT	MIA	SJO	MIASJO	1	299.000000	232.00	Freighters	GCR	STD,GCR	9985	MIA	SJO	MIA	SJO	72942119383	2023-08-29	DHL GLOBAL FORWARDING	1.794084	299.02000	Volume	299.02000
6869	26	8	2023	35	729	31	AV	MIA	MDE	MIAMDE	1	5.000000	5.00	Bellies	AOG	AOG	4105	MIA	MDE	MIA	MDE	72941990034	2023-08-26	AVIANCA	0.029999	5.00000	Others	5.00000
632	22	3	2023	13	729	31	AV	MIA	MDE	MIAMDE	1	1.000000	1.00	Bellies	AOG	AOG	4105	MIA	MDE	MIA	MDE	72941646533	2023-03-22	AVIANCA	0.006000	1.00000	Others	1.00000
56168	18	6	2023	25	729	4055	QT	MIA	CWB	MIACWB	12	300.000000	297.00	Freighters	GCR	STD,GCR	9985	MIA	VCP	MIA	VCP	72941850152	2023-06-18	STAR FREIGHT LOGISTICS LLC	3.580608	596.78000	Others	596.78000
54916	4	8	2023	32	729	4035	QT	MIA	UIO	MIAUIO	2	545.500000	498.00	Freighters	GCR	STD,GCR	9985	MIA	UIO	MIA	UIO	72941537344	2023-08-04	APOLLO INTERNATIONAL FORWINC	3.278454	546.42000	Volume	546.42000
9809	4	2	2023	6	729	451	TA	MIA	MGA	MIAMGA	1	9.000000	9.00	Bellies	COM	COM,GCR	9724	MIA	SAL	MIA	SAL	72941528955	2023-02-04	COMAT AERONAUTICO MIA	0.054779	9.13000	Others	9.13000
18144	21	7	2023	30	729	127	AV	MIA	BOG	MIABOG	2	36.000000	36.00	Bellies	COM	COM,GCR	9724	MIA	BOG	MIA	BOG	72941980691	2023-07-21	AVIANCA	0.215996	36.00000	Others	36.00000
36087	20	7	2023	30	729	4055	QT	MIA	CWB	MIACWB	30	234.000000	219.00	Freighters	GCR	GCR	9985	PVG	CWB	MIA	CWB	72948396865	2023-07-20	ALL LINK LOGISTICS SHANGHAI	1.058259	176.38000	Others	219.00000
19868	26	3	2023	13	160	4087	QT	MIA	ASU	MIAASU	2	45.000000	22.00	Freighters	GCR	GCR	9985	HGH	ASU	MIA	ASU	16054564882	2023-03-26	INTERLINEO - CATHAY PACIFIC	0.268855	44.81000	Others	44.81000

Most frequently occurring

	Day	Month	Year	Week	AWB Prefix	Operating Flight Number	Route Owner	Leg Origin	Leg Destination	LEG	Pieces	KG OB Chg	KG OB Gross	Bellies - Freighters	ProductCode	Commodity Unificado	Commodity	OD Real Origin	OD Real Destination	OD Network Origin	OD Network Destination	Airway Bill Number	Flight_date	Agency	Volume (m3)	KG Volumetric	Cargo Type	KG Chg Operational	# duplicates
0	1	7	2023	27	729	451	TA	MIA	MGA	MIAMGA	37	319.0	296.0	Bellies	GCR	STD,GCR	9996	SCL	MGA	SCL	MGA	72946874973	2023-07-01	ICHECK CARGO LIMITADA	1.913962	319.00	Others	319.00	2
1	15	5	2023	21	16	4149	QT	MIA	BOG	MIABOG	1	181.0	181.0	Freighters	GCR	STD,GCR	9985	PEK	BOG	MIA	BOG	1666406432	2023-05-15	INTERLINEO - UNITED AIRLINES	0.419692	69.95	Dense	181.00	2
2	15	5	2023	21	16	4149	QT	MIA	BOG	MIABOG	1	226.0	226.0	Freighters	GCR	GCR	9985	PEK	BOG	MIA	BOG	1656394096	2023-05-15	INTERLINEO - UNITED AIRLINES	0.207716	34.62	Dense	226.00	2
3	15	5	2023	21	16	4149	QT	MIA	BOG	MIABOG	17	1600.0	1600.0	Freighters	GCR	GCR	9985	PVG	BOG	MIA	BOG	1666902511	2023-05-15	INTERLINEO - UNITED AIRLINES	2.600948	433.50	Dense	1600.00	2
4	15	5	2023	21	160	4149	QT	MIA	BOG	MIABOG	2	59.0	59.0	Freighters	GCR	STD,GCR	9985	XMN	BOG	MIA	BOG	16057244784	2023-05-15	INTERLINEO - CATHAY PACIFIC	0.073439	12.24	Others	59.00	2
5	15	5	2023	21	160	4149	QT	MIA	BOG	MIABOG	3	626.5	540.0	Freighters	GCR	STD,GCR	9985	XMN	BOG	MIA	BOG	16055135743	2023-05-15	INTERLINEO - CATHAY PACIFIC	3.762165	627.04	Volume	627.04	2
6	15	5	2023	21	160	4149	QT	MIA	BOG	MIABOG	8	1109.0	1109.0	Freighters	GCR	STD,GCR	9985	XMN	BOG	MIA	BOG	16055134590	2023-05-15	INTERLINEO - CATHAY PACIFIC	4.443451	740.59	Dense	1109.00	2
7	15	5	2023	21	160	4149	QT	MIA	BOG	MIABOG	16	297.0	261.0	Freighters	GCR	STD,GCR	9985	XMN	BOG	MIA	BOG	16057244611	2023-05-15	INTERLINEO - CATHAY PACIFIC	1.788804	298.14	Others	298.14	2
8	15	5	2023	21	160	4149	QT	MIA	BOG	MIABOG	24	286.0	183.0	Freighters	GCR	STD,GCR	9985	XMN	BOG	MIA	BOG	16057244622	2023-05-15	INTERLINEO - CATHAY PACIFIC	1.725145	287.53	Others	287.53	2
9	15	5	2023	21	729	4149	QT	MIA	BOG	MIABOG	1	5.5	3.0	Freighters	GCR	STD,GCR,NSC	9985	MIA	GRU	MIA	GRU	72941862494	2023-05-15	DB SCHENKER	0.033059	5.51	Others	5.51	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length