{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Module 5\n", "\n", "## Video 23: Filtering by Geography\n", "**Python for the Energy Industry**\n", "\n", "In previous lessons, we have seen that the Geography endpoint of the Vortexa SDK can be used to search for, and get ID numbers for different types of location - countries, shipping regions, ports, etc. These IDs can be used to filter searches based on e.g. origin and destination. \n", "\n", "[Geographies endpoint documentation.](https://vortechsa.github.io/python-sdk/endpoints/geographies/)" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "# Some initial imports / settings\n", "from datetime import datetime\n", "from dateutil.relativedelta import relativedelta\n", "import vortexasdk as v\n", "\n", "now = datetime.utcnow()\n", "one_month_ago = now - relativedelta(months=1)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "If we use the Geographies endpoint search function to search for a high-level term like 'china', we will likely get a scattering of results at different levels that match that search term:" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "2020-12-10 16:24:14,147 vortexasdk.client — WARNING — You are using vortexasdk version 0.26.0, however version 0.27.1 is available.\n", "You should consider upgrading via the 'pip install vortexasdk --upgrade' command.\n" ] }, { "data": { "text/html": [ "
\n", " | name | \n", "layer | \n", "
---|---|---|
0 | \n", "China | \n", "[country] | \n", "
1 | \n", "South China | \n", "[shipping_region] | \n", "
2 | \n", "North China | \n", "[shipping_region] | \n", "
3 | \n", "China (excl. HK & Macau) | \n", "[shipping_region] | \n", "
4 | \n", "China Steel Chemical | \n", "[terminal] | \n", "
5 | \n", "China Energy Services Ningbo | \n", "[terminal] | \n", "
6 | \n", "East China Sea STS | \n", "[sts_zone] | \n", "
7 | \n", "Multipurpose (China Merchants) Terminal | \n", "[terminal] | \n", "
8 | \n", "China Union, Freeport Of Monrovia | \n", "[terminal] | \n", "
9 | \n", "China Resources Chemical Holding Terminal | \n", "[terminal] | \n", "
10 | \n", "China General Terminal Distribution Corp | \n", "[terminal] | \n", "
11 | \n", "China Bay(Ioc Terminal) (Ex-Trincomalee) | \n", "[terminal] | \n", "
12 | \n", "Wenzhou China Petroleum Fuel Bitumen Co., Ltd. | \n", "[terminal] | \n", "
\n", " | vessel_name | \n", "vessel_class | \n", "product_group | \n", "product_grade | \n", "quantity | \n", "status | \n", "loading_port | \n", "loading_finish | \n", "unloading_port | \n", "unloading_finish | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "ATLANTICOS | \n", "handysize | \n", "Dirty Petroleum Products | \n", "NaN | \n", "167491 | \n", "unloaded_state | \n", "Slavyanka [RU] | \n", "2020-11-19 10:59:27+00:00 | \n", "Ningbo (Beilun) [CN] | \n", "2020-12-03 02:16:24+00:00 | \n", "
1 | \n", "SW SOUTHPORT I | \n", "handymax | \n", "Clean Petroleum Products | \n", "NaN | \n", "273706 | \n", "unloaded_state | \n", "Yeosu (Yosu), Gwangyang [KR] | \n", "2020-11-25 15:27:26+00:00 | \n", "Dongguan, Humen [CN] | \n", "2020-12-03 04:13:26+00:00 | \n", "
2 | \n", "NEW TINOS | \n", "vlcc_plus | \n", "Dirty Petroleum Products | \n", "NaN | \n", "670951 | \n", "unloaded_state | \n", "NaN | \n", "NaT | \n", "Hong Kong [CN] | \n", "2020-11-25 19:11:45+00:00 | \n", "
3 | \n", "HANG HAI YOU 17 | \n", "general_purpose | \n", "Crude/Condensates | \n", "NaN | \n", "147432 | \n", "unloaded_state | \n", "Dongjiakou [CN] | \n", "2020-12-08 04:04:06+00:00 | \n", "Rizhao - Lanshan Area [CN] | \n", "2020-12-09 23:47:47+00:00 | \n", "
4 | \n", "QUANLINLIANGYOU 5 | \n", "tiny_tanker | \n", "Clean Petroleum Products | \n", "NaN | \n", "35952 | \n", "unloaded_state | \n", "Taixing [CN] | \n", "2020-11-21 03:39:28+00:00 | \n", "Nantong [CN] | \n", "2020-11-22 05:44:38+00:00 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2294 | \n", "XIN DE116 | \n", "tiny_tanker | \n", "Clean Petroleum Products | \n", "NaN | \n", "35398 | \n", "unloaded_state | \n", "Dalian [CN] | \n", "2020-11-29 19:46:12+00:00 | \n", "Shanghai [CN] | \n", "2020-12-04 05:44:43+00:00 | \n", "
2295 | \n", "SC TIANJIN | \n", "general_purpose | \n", "Clean Petroleum Products | \n", "Monoethylene Glycol (MEG) | \n", "14774 | \n", "unloaded_state | \n", "Mai Liao - Taiwan [TW] | \n", "2020-12-01 11:38:16+00:00 | \n", "Jiangyin [CN] | \n", "2020-12-10 05:46:48+00:00 | \n", "
2296 | \n", "TIAN EN 1001 | \n", "tiny_tanker | \n", "Clean Petroleum Products | \n", "NaN | \n", "15850 | \n", "unloaded_state | \n", "Nanjing [CN] | \n", "2020-12-03 21:04:10+00:00 | \n", "Zhenjiang [CN] | \n", "2020-12-05 08:43:42+00:00 | \n", "
2297 | \n", "SC DALIAN | \n", "general_purpose | \n", "Clean Petroleum Products | \n", "NaN | \n", "38952 | \n", "unloaded_state | \n", "Ulsan, Onsan [KR] | \n", "2020-11-25 23:36:28+00:00 | \n", "Jingjiang [CN] | \n", "2020-11-30 14:27:25+00:00 | \n", "
2298 | \n", "BLUE SPRING | \n", "handymax | \n", "Clean Petroleum Products | \n", "NaN | \n", "175340 | \n", "unloaded_state | \n", "NaN | \n", "2020-11-16 15:52:16+00:00 | \n", "Nantong [CN] | \n", "2020-11-26 08:20:41+00:00 | \n", "
2299 rows × 10 columns
\n", "\n", " | vessel_name | \n", "vessel_class | \n", "product_group | \n", "product_grade | \n", "quantity | \n", "status | \n", "loading_port | \n", "loading_finish | \n", "unloading_port | \n", "unloading_finish | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "SC XIAMEN | \n", "general_purpose | \n", "Clean Petroleum Products | \n", "NaN | \n", "88906 | \n", "unloaded_state | \n", "Ulsan, Onsan [KR] | \n", "2020-11-25 23:29:57+00:00 | \n", "Pinghu, Jiaxing [CN] | \n", "2020-12-09 01:18:41+00:00 | \n", "
1 | \n", "HEUNG-A PIONEER | \n", "general_purpose | \n", "Clean Petroleum Products | \n", "NaN | \n", "76018 | \n", "transiting_state | \n", "Singapore [SG] | \n", "2020-12-05 10:00:50+00:00 | \n", "Zhangjiagang [CN] | \n", "NaT | \n", "
2 | \n", "STX IRIS | \n", "general_purpose | \n", "Clean Petroleum Products | \n", "NaN | \n", "97850 | \n", "unloaded_state | \n", "Daesan [KR] | \n", "2020-11-12 21:04:00+00:00 | \n", "Pinghu, Jiaxing [CN] | \n", "2020-11-21 06:31:10+00:00 | \n", "
3 | \n", "SEA CRYSTAL | \n", "general_purpose | \n", "Clean Petroleum Products | \n", "NaN | \n", "102649 | \n", "unloaded_state | \n", "Incheon [KR] | \n", "2020-11-27 22:34:18+00:00 | \n", "Jiangyin [CN] | \n", "2020-12-03 05:40:32+00:00 | \n", "
4 | \n", "JS NANJING | \n", "tiny_tanker | \n", "Dirty Petroleum Products | \n", "NaN | \n", "15460 | \n", "unloaded_state | \n", "Yeosu (Yosu), Gwangyang [KR] | \n", "2020-11-19 00:00:45+00:00 | \n", "Nanjing [CN] | \n", "2020-11-25 18:12:21+00:00 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1053 | \n", "NAVE ATROPOS | \n", "panamax | \n", "Clean Petroleum Products | \n", "NaN | \n", "295545 | \n", "transiting_state | \n", "Singapore [SG] | \n", "2020-11-21 15:05:26+00:00 | \n", "Dalian [CN] | \n", "NaT | \n", "
1054 | \n", "ASIA DAWN | \n", "vlcc_plus | \n", "Crude/Condensates | \n", "Oman Blend | \n", "1931245 | \n", "transiting_state | \n", "Mina Al Fahal, Muscat [OM] | \n", "2020-11-27 21:14:27+00:00 | \n", "Rizhao - Lanshan Area [CN] | \n", "NaT | \n", "
1055 | \n", "SC TIANJIN | \n", "general_purpose | \n", "Clean Petroleum Products | \n", "Monoethylene Glycol (MEG) | \n", "14774 | \n", "unloaded_state | \n", "Mai Liao - Taiwan [TW] | \n", "2020-12-01 11:38:16+00:00 | \n", "Jiangyin [CN] | \n", "2020-12-10 05:46:48+00:00 | \n", "
1056 | \n", "SC DALIAN | \n", "general_purpose | \n", "Clean Petroleum Products | \n", "NaN | \n", "38952 | \n", "unloaded_state | \n", "Ulsan, Onsan [KR] | \n", "2020-11-25 23:36:28+00:00 | \n", "Jingjiang [CN] | \n", "2020-11-30 14:27:25+00:00 | \n", "
1057 | \n", "BLUE SPRING | \n", "handymax | \n", "Clean Petroleum Products | \n", "NaN | \n", "175340 | \n", "unloaded_state | \n", "NaN | \n", "2020-11-16 15:52:16+00:00 | \n", "Nantong [CN] | \n", "2020-11-26 08:20:41+00:00 | \n", "
1058 rows × 10 columns
\n", "\n", " | vessel_name | \n", "vessel_class | \n", "product_group | \n", "product_grade | \n", "quantity | \n", "status | \n", "loading_port | \n", "loading_finish | \n", "unloading_port | \n", "unloading_finish | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "SC XIAMEN | \n", "general_purpose | \n", "Clean Petroleum Products | \n", "NaN | \n", "88906 | \n", "unloaded_state | \n", "Ulsan, Onsan [KR] | \n", "2020-11-25 23:29:57+00:00 | \n", "Pinghu, Jiaxing [CN] | \n", "2020-12-09 01:18:41+00:00 | \n", "
1 | \n", "STX IRIS | \n", "general_purpose | \n", "Clean Petroleum Products | \n", "NaN | \n", "97850 | \n", "unloaded_state | \n", "Daesan [KR] | \n", "2020-11-12 21:04:00+00:00 | \n", "Pinghu, Jiaxing [CN] | \n", "2020-11-21 06:31:10+00:00 | \n", "
2 | \n", "SEA CRYSTAL | \n", "general_purpose | \n", "Clean Petroleum Products | \n", "NaN | \n", "102649 | \n", "unloaded_state | \n", "Incheon [KR] | \n", "2020-11-27 22:34:18+00:00 | \n", "Jiangyin [CN] | \n", "2020-12-03 05:40:32+00:00 | \n", "
3 | \n", "JS NANJING | \n", "tiny_tanker | \n", "Dirty Petroleum Products | \n", "NaN | \n", "15460 | \n", "unloaded_state | \n", "Yeosu (Yosu), Gwangyang [KR] | \n", "2020-11-19 00:00:45+00:00 | \n", "Nanjing [CN] | \n", "2020-11-25 18:12:21+00:00 | \n", "
4 | \n", "GAS EMERALD | \n", "sgc | \n", "Clean Petroleum Products | \n", "NaN | \n", "7610 | \n", "unloaded_state | \n", "Ulsan, Onsan [KR] | \n", "2020-11-17 17:27:54+00:00 | \n", "Zhapu [CN] | \n", "2020-11-21 06:42:21+00:00 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
366 | \n", "HUA HANG HE CHANG | \n", "tiny_tanker | \n", "Dirty Petroleum Products | \n", "NaN | \n", "34310 | \n", "unloaded_state | \n", "Yeosu (Yosu), Gwangyang [KR] | \n", "2020-11-23 07:50:40+00:00 | \n", "Nanjing [CN] | \n", "2020-11-30 06:21:44+00:00 | \n", "
367 | \n", "CRANE MIMOSA | \n", "tiny_tanker | \n", "Clean Petroleum Products | \n", "NaN | \n", "48745 | \n", "unloaded_state | \n", "Anegasaki-Chiba [JP] | \n", "2020-11-25 21:47:22+00:00 | \n", "Zhangjiagang [CN] | \n", "2020-12-02 00:44:23+00:00 | \n", "
368 | \n", "NEW SILVER | \n", "general_purpose | \n", "Clean Petroleum Products | \n", "NaN | \n", "18831 | \n", "unloaded_state | \n", "Ulsan, Onsan [KR] | \n", "2020-11-19 01:29:57+00:00 | \n", "Dalian [CN] | \n", "2020-11-26 08:01:41+00:00 | \n", "
369 | \n", "WOOSHIN ACE | \n", "tiny_tanker | \n", "Clean Petroleum Products | \n", "NaN | \n", "21328 | \n", "unloaded_state | \n", "Yeosu (Yosu), Gwangyang [KR] | \n", "2020-11-23 17:53:11+00:00 | \n", "Nantong [CN] | \n", "2020-11-26 23:46:12+00:00 | \n", "
370 | \n", "SC DALIAN | \n", "general_purpose | \n", "Clean Petroleum Products | \n", "NaN | \n", "38952 | \n", "unloaded_state | \n", "Ulsan, Onsan [KR] | \n", "2020-11-25 23:36:28+00:00 | \n", "Jingjiang [CN] | \n", "2020-11-30 14:27:25+00:00 | \n", "
371 rows × 10 columns
\n", "