CustomsVersusBps
View or edit on GitHub
This page is synchronized from trase/models/indonesia/palm_oil/CustomsVersusBps.ipynb. Last modified on 2025-12-14 23:19 CET by Trase Admin.
Please view or edit the original file there; changes should be reflected here after a midnight build (CET time),
or manually triggering it with a GitHub action (link).
from trase.tools.sps import *
df_bol = get_pandas_df(
"indonesia/trade/bol/out/BOL_INDONESIA_2022.csv",
sep=";",
na_filter=False,
dtype=str,
).astype({"KG_NET": float, "FOB": float})
print("\n".join(list(df_bol.columns)))
DATE_OF_CLEARANCE
HS
DESCRIPTION
EXPORTER
EXPORTER_ADDRESS
IMPORTER
IMPORTER_ADDRESS
COUNTRY
PORT_LOADING
PORT_EXPORT
PORT_DISCHARGE
KG_NET
FOB
df_bol[~df_bol.duplicated()].groupby("HS")["KG_NET"].sum()
HS
15111000 1.530013e+09
15119020 8.532581e+09
15119031 2.486513e+09
15119032 3.099409e+08
15119036 1.031669e+09
15119037 9.951631e+09
15119039 3.238244e+08
15119041 5.440000e+00
15119049 3.350335e+06
Name: KG_NET, dtype: float64
df_bol[df_bol.duplicated(keep=False)].sort_values(list(df_bol.columns))[:17]
| DATE_OF_CLEARANCE | HS | DESCRIPTION | EXPORTER | EXPORTER_ADDRESS | IMPORTER | IMPORTER_ADDRESS | COUNTRY | PORT_LOADING | PORT_EXPORT | PORT_DISCHARGE | KG_NET | FOB | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 116 | 2022-01-01 | 15119020 | RBD PALM OIL IN BULK | INTIBENUA PERKASATAMA | SPRING TOWER, 02 - 21 JL. YOS SUDARSO TANJUNG ... | INTER-CONTINENTAL OILS AND FATS PTE. LTD., | 150 BEACH ROAD, HEX 16-01, GATEWAY WEST, SINGA... | PAKISTAN | DUMAI | DUMAI | MUHAMMAD BIN QASIM/KARACH | 250000.0 | 298500.0 |
| 117 | 2022-01-01 | 15119020 | RBD PALM OIL IN BULK | INTIBENUA PERKASATAMA | SPRING TOWER, 02 - 21 JL. YOS SUDARSO TANJUNG ... | INTER-CONTINENTAL OILS AND FATS PTE. LTD., | 150 BEACH ROAD, HEX 16-01, GATEWAY WEST, SINGA... | PAKISTAN | DUMAI | DUMAI | MUHAMMAD BIN QASIM/KARACH | 250000.0 | 298500.0 |
| 106 | 2022-01-01 | 15119020 | RBD PALM OIL IN BULK | INTIBENUA PERKASATAMA | SPRING TOWER, 02 - 21 JL. YOS SUDARSO TANJUNG ... | INTER-CONTINENTAL OILS AND FATS PTE. LTD., | 150 BEACH ROAD, HEX 16-01, GATEWAY WEST, SINGA... | PAKISTAN | DUMAI | DUMAI | MUHAMMAD BIN QASIM/KARACH | 250000.0 | 310000.0 |
| 110 | 2022-01-01 | 15119020 | RBD PALM OIL IN BULK | INTIBENUA PERKASATAMA | SPRING TOWER, 02 - 21 JL. YOS SUDARSO TANJUNG ... | INTER-CONTINENTAL OILS AND FATS PTE. LTD., | 150 BEACH ROAD, HEX 16-01, GATEWAY WEST, SINGA... | PAKISTAN | DUMAI | DUMAI | MUHAMMAD BIN QASIM/KARACH | 250000.0 | 310000.0 |
| 112 | 2022-01-01 | 15119020 | RBD PALM OIL IN BULK | INTIBENUA PERKASATAMA | SPRING TOWER, 02 - 21 JL. YOS SUDARSO TANJUNG ... | INTER-CONTINENTAL OILS AND FATS PTE. LTD., | 150 BEACH ROAD, HEX 16-01, GATEWAY WEST, SINGA... | PAKISTAN | DUMAI | DUMAI | MUHAMMAD BIN QASIM/KARACH | 250000.0 | 310000.0 |
| 84 | 2022-01-01 | 15119020 | RBD PALM OIL IN BULK | INTIBENUA PERKASATAMA | SPRING TOWER, 02 - 21 JL. YOS SUDARSO TANJUNG ... | INTER-CONTINENTAL OILS AND FATS PTE. LTD., | 150 BEACH ROAD, HEX 16-01, GATEWAY WEST, SINGA... | PAKISTAN | DUMAI | DUMAI | MUHAMMAD BIN QASIM/KARACH | 750000.0 | 284250.0 |
| 95 | 2022-01-01 | 15119020 | RBD PALM OIL IN BULK | INTIBENUA PERKASATAMA | SPRING TOWER, 02 - 21 JL. YOS SUDARSO TANJUNG ... | INTER-CONTINENTAL OILS AND FATS PTE. LTD., | 150 BEACH ROAD, HEX 16-01, GATEWAY WEST, SINGA... | PAKISTAN | DUMAI | DUMAI | MUHAMMAD BIN QASIM/KARACH | 750000.0 | 284250.0 |
| 85 | 2022-01-01 | 15119020 | RBD PALM OIL IN BULK | INTIBENUA PERKASATAMA | SPRING TOWER, 02 - 21 JL. YOS SUDARSO TANJUNG ... | INTER-CONTINENTAL OILS AND FATS PTE. LTD., | 150 BEACH ROAD, HEX 16-01, GATEWAY WEST, SINGA... | PAKISTAN | DUMAI | DUMAI | MUHAMMAD BIN QASIM/KARACH | 750000.0 | 578000.0 |
| 96 | 2022-01-01 | 15119020 | RBD PALM OIL IN BULK | INTIBENUA PERKASATAMA | SPRING TOWER, 02 - 21 JL. YOS SUDARSO TANJUNG ... | INTER-CONTINENTAL OILS AND FATS PTE. LTD., | 150 BEACH ROAD, HEX 16-01, GATEWAY WEST, SINGA... | PAKISTAN | DUMAI | DUMAI | MUHAMMAD BIN QASIM/KARACH | 750000.0 | 578000.0 |
| 119 | 2022-01-01 | 15119020 | RBD PALM OIL IN BULK | INTIBENUA PERKASATAMA | SPRING TOWER, 02 - 21 JL. YOS SUDARSO TANJUNG ... | INTER-CONTINENTAL OILS AND FATS PTE. LTD., | 150 BEACH ROAD, HEX 16-01, GATEWAY WEST, SINGA... | PAKISTAN | DUMAI | DUMAI | MUHAMMAD BIN QASIM/KARACH | 750000.0 | 578000.0 |
| 86 | 2022-01-01 | 15119020 | RBD PALM OIL IN BULK | INTIBENUA PERKASATAMA | SPRING TOWER, 02 - 21 JL. YOS SUDARSO TANJUNG ... | INTER-CONTINENTAL OILS AND FATS PTE. LTD., | 150 BEACH ROAD, HEX 16-01, GATEWAY WEST, SINGA... | PAKISTAN | DUMAI | DUMAI | MUHAMMAD BIN QASIM/KARACH | 1000000.0 | 284250.0 |
| 100 | 2022-01-01 | 15119020 | RBD PALM OIL IN BULK | INTIBENUA PERKASATAMA | SPRING TOWER, 02 - 21 JL. YOS SUDARSO TANJUNG ... | INTER-CONTINENTAL OILS AND FATS PTE. LTD., | 150 BEACH ROAD, HEX 16-01, GATEWAY WEST, SINGA... | PAKISTAN | DUMAI | DUMAI | MUHAMMAD BIN QASIM/KARACH | 1000000.0 | 284250.0 |
| 114 | 2022-01-01 | 15119020 | RBD PALM OIL IN BULK | INTIBENUA PERKASATAMA | SPRING TOWER, 02 - 21 JL. YOS SUDARSO TANJUNG ... | INTER-CONTINENTAL OILS AND FATS PTE. LTD., | 150 BEACH ROAD, HEX 16-01, GATEWAY WEST, SINGA... | PAKISTAN | DUMAI | DUMAI | MUHAMMAD BIN QASIM/KARACH | 1000000.0 | 284250.0 |
| 87 | 2022-01-01 | 15119020 | RBD PALM OIL IN BULK | INTIBENUA PERKASATAMA | SPRING TOWER, 02 - 21 JL. YOS SUDARSO TANJUNG ... | INTER-CONTINENTAL OILS AND FATS PTE. LTD., | 150 BEACH ROAD, HEX 16-01, GATEWAY WEST, SINGA... | PAKISTAN | DUMAI | DUMAI | MUHAMMAD BIN QASIM/KARACH | 1000000.0 | 578000.0 |
| 105 | 2022-01-01 | 15119020 | RBD PALM OIL IN BULK | INTIBENUA PERKASATAMA | SPRING TOWER, 02 - 21 JL. YOS SUDARSO TANJUNG ... | INTER-CONTINENTAL OILS AND FATS PTE. LTD., | 150 BEACH ROAD, HEX 16-01, GATEWAY WEST, SINGA... | PAKISTAN | DUMAI | DUMAI | MUHAMMAD BIN QASIM/KARACH | 1000000.0 | 578000.0 |
| 101 | 2022-01-01 | 15119020 | RBD PALM OIL IN BULK | INTIBENUA PERKASATAMA | SPRING TOWER, 02 - 21 JL. YOS SUDARSO TANJUNG ... | INTER-CONTINENTAL OILS AND FATS PTE. LTD., | 150 BEACH ROAD, HEX 16-01, GATEWAY WEST, SINGA... | PAKISTAN | DUMAI | DUMAI | MUHAMMAD BIN QASIM/KARACH | 1000000.0 | 867000.0 |
| 115 | 2022-01-01 | 15119020 | RBD PALM OIL IN BULK | INTIBENUA PERKASATAMA | SPRING TOWER, 02 - 21 JL. YOS SUDARSO TANJUNG ... | INTER-CONTINENTAL OILS AND FATS PTE. LTD., | 150 BEACH ROAD, HEX 16-01, GATEWAY WEST, SINGA... | PAKISTAN | DUMAI | DUMAI | MUHAMMAD BIN QASIM/KARACH | 1000000.0 | 867000.0 |