#!/usr/bin/env python
# coding: utf-8

# ### Try out the VortexaSDK

# First let's import our requirements

# In[ ]:


from datetime import datetime
import vortexasdk as v


# Lets use the CargoTimeSeries endpoint to answer the following question:

# -  _What was the monthly average barrels per day of crude loaded from Rotterdam over the last year_?

# First we'll find the IDs corresponding to Rotterdam and Crude

# In[ ]:


rotterdam = [g.id for g in v.Geographies().search("Rotterdam", exact_term_match=True).to_list()]


# In[ ]:


crude = [p.id for p in v.Products().search("Crude", exact_term_match=True).to_list()]


# In[ ]:


search_result = v.CargoTimeSeries().search(
    timeseries_unit='bpd',
    timeseries_frequency='month',
    filter_origins=rotterdam,
    filter_products=crude,
    filter_activity='loading_state',
    filter_time_min=datetime(2018, 1, 1),
    filter_time_max=datetime(2018, 12, 31))


# In[ ]:


df = search_result.to_df()


# In[ ]:


df.head()


# That's it! You've successfully loaded data using the Vortexa SDK. Check out https://vortechsa.github.io/python-sdk/ for more examples