Exercise
Its time to start running some time series queries using the RTDIP SDK.
-
Using the python file you created in the previous exercise, import the necessary time series query classes from the RTDIP SDK.
-
Pass the connector you created in the previous exercise to the time series query class.
-
Run a
Raw
query to retrieve some data from your time series data source. -
Now run a query to
Resample
this data to a 15 minute interval average. -
Convert the resample query to an
Interpolation
query that executes thelinear
interpolation method. -
Finally, try running a
Time Weighted Average
query on the data, withStep
set to False.
Additional Task
- The data returned from these queries is in the form of a pandas DataFrame. Use the
matplotlib
orplotly
library to plot the data returned from theTime Weighted Average
query.
Course Progress
- Introduction
- SDK
- Authentication
- Connectors
- Queries
- Power BI
- APIs
- Excel Connector