{ "cells": [ { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [], "source": [ "from datetime import datetime\n", "from vortexasdk import CargoMovements" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [], "source": [ "dt = datetime(2017, 8, 1)" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "2020-04-21 10:04:27,631 vortexasdk.operations — INFO — Searching CargoMovements with params: {'filter_activity': 'loading_state', 'filter_time_min': '2017-08-01T00:00:00.000Z', 'filter_time_max': '2017-08-01T00:00:00.000Z', 'timeseries_activity_time_span_min': None, 'timeseries_activity_time_span_max': None, 'cm_unit': 'b', 'filter_charterers': [], 'filter_owners': [], 'filter_products': [], 'filter_vessels': [], 'filter_destinations': [], 'filter_origins': [], 'filter_storage_locations': [], 'filter_ship_to_ship_locations': [], 'filter_waypoints': [], 'disable_geographic_exclusion_rules': None, 'size': 500}\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ "\r", "Loading from API: 0%| | 0/837 [00:00, ?it/s]" ] }, { "name": "stdout", "output_type": "stream", "text": [ "2020-04-21 10:04:28,007 vortexasdk.client — INFO — 837 Results to retreive. Sending 2 post requests in parallel using 6 threads.\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ "Loading from API: 1000it [00:01, 887.58it/s] \n" ] }, { "data": { "text/html": [ "
\n", " | events.cargo_port_load_event.0.location.port.label | \n", "events.cargo_port_unload_event.0.location.port.label | \n", "product.group.label | \n", "product.grade.label | \n", "quantity | \n", "vessels.0.name | \n", "events.cargo_port_load_event.0.end_timestamp | \n", "events.cargo_port_unload_event.0.start_timestamp | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "Baton Rouge, LA [US] | \n", "La Libertad [EC] | \n", "Clean Petroleum Products | \n", "NaN | \n", "218878 | \n", "CANAL STREET | \n", "2017-08-01T21:14:22+0000 | \n", "2017-08-21T21:22:22+0000 | \n", "
1 | \n", "Taman [RU] | \n", "Augusta [IT] | \n", "Dirty Petroleum Products | \n", "NaN | \n", "201896 | \n", "NAFTILOS AN | \n", "2017-08-02T09:59:28+0000 | \n", "2017-08-11T11:54:11+0000 | \n", "
2 | \n", "NaN | \n", "Ceyhan [TR] | \n", "Clean Petroleum Products | \n", "NaN | \n", "265756 | \n", "VIKTOR BAKAEV | \n", "NaN | \n", "2017-08-10T08:41:59+0000 | \n", "
3 | \n", "Malacca (Melaka) [MY] | \n", "Port Kelang [MY] | \n", "Dirty Petroleum Products | \n", "NaN | \n", "18944 | \n", "M T SIDRA MESSAIED | \n", "2017-08-03T11:31:56+0000 | \n", "2017-08-03T21:04:35+0000 | \n", "
4 | \n", "Yeosu (Yosu), Gwangyang [KR] | \n", "Barbers Point-Honolulu, HI [US] | \n", "Crude/Condensates | \n", "Sokol (Sakhalin I) | \n", "720729 | \n", "NEW ACCORD | \n", "2017-08-02T01:29:38+0000 | \n", "2017-08-18T19:55:31+0000 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
832 | \n", "Ulsan, Onsan [KR] | \n", "Pinghu, Jiaxing [CN] | \n", "Clean Petroleum Products | \n", "NaN | \n", "13453 | \n", "NO.9 SJGAS | \n", "2017-08-01T02:34:47+0000 | \n", "2017-08-05T03:55:49+0000 | \n", "
833 | \n", "Houston, TX [US] | \n", "Wakayama [JP] | \n", "Clean Petroleum Products | \n", "NaN | \n", "87855 | \n", "IVY EXPRESS | \n", "2017-08-01T17:36:03+0000 | \n", "2017-09-08T02:32:18+0000 | \n", "
834 | \n", "Le Havre [FR] | \n", "Alexandria [EG] | \n", "Clean Petroleum Products | \n", "NaN | \n", "4805 | \n", "ALSIA SWAN | \n", "2017-08-01T06:10:45+0000 | \n", "2017-08-12T19:37:38+0000 | \n", "
835 | \n", "Yeosu (Yosu), Gwangyang [KR] | \n", "Rotterdam [NL] | \n", "Clean Petroleum Products | \n", "Jet A-1 | \n", "275046 | \n", "EAGLE LYON | \n", "2017-08-07T03:10:21+0000 | \n", "2017-09-15T00:07:54+0000 | \n", "
836 | \n", "Yeosu (Yosu), Gwangyang [KR] | \n", "Ulsan, Onsan [KR] | \n", "Clean Petroleum Products | \n", "NaN | \n", "46720 | \n", "WOOJIN KELLY | \n", "2017-08-01T17:06:12+0000 | \n", "2017-08-02T04:28:11+0000 | \n", "
837 rows × 8 columns
\n", "