Rendering Data

Rendering Data with Python

Introduction

This page explains how to create a script to download and process your dataset with Python for QuantConnect distribution.

Using Processing Framework

During this part of the contribution process, you need to edit the Lean.DataSource.<vendorNameDatasetName> / DataProcessing / process.sample.py file so it transforms and moves your raw data into the format and location the GetSource methods expect. The script should save all the data history to the output directory in your machine's root directory (for example, C: / output) and it should save a sample of the data history to the Lean.DataSource.<vendorNameDatasetName> / output directory.

Follow these steps to set up the downloading and processing script for your dataset:

  1. Change the structure of the Lean.DataSource.<vendorNameDatasetName> / output directory to match the path structure you defined in the GetSourceget_source methods (for example, output / alternative / xyzairline / ticketsales).
  2. In the Lean.DataSource.<vendorNameDatasetName> / DataProcessing / process.sample.py file, add some code to time how long it takes to process the entire dataset and how long it takes to update the dataset with one day's worth of data.
  3. You need this information for when you provide the dataset documentation. We need to know how long it takes to process your dataset so we can schedule its processing job.
  4. In the processing file, load the raw data from your source.
  5. You can fetch data from any of the following sources:

    SourceConsiderations
    Local FilesIt can help to first copy the data into location.
    Remote APIStay within the rate limits. You can use the rate gate class.

    You should load and process the data period by period. Use the date range provided to the script to process the specific dates provided.

  6. If your dataset is for universe selection data and it's at a higher frequency than hour resolution, resample your data to hourly or daily resolution.
  7. If any of the following statements are true, skip the rest of the steps in this tutorial:
    • Your dataset is not linked to Equities.
    • Your dataset is related to Equities and already includes the point-in-time tickers.

    If your dataset is related to Equities and your dataset doesn't account for ticker changes, the rest of the steps help you to adjust the tickers over the historical data so they are point-in-time.

  8. If you don't have the US Equity Security Master dataset, contact us.
  9. In the Lean.DataSource.<vendorNameDatasetName> / DataProcessing / Program.cs file, remove the statements of the Main method
  10. In a terminal, compile the data processing project.
  11. $ dotnet build .\DataProcessing\DataProcessing.csproj

    This step generates a file that the CLRImports library uses.

  12. In the Lean.DataSource.<vendorNameDatasetName> / DataProcessing / process.sample.py file, import the CLRImports library.
  13. from CLRImports import *
  14. Create and initialize a map file provider.
  15. map_file_provider = LocalZipMapFileProvider()
    map_file_provider.Initialize(DefaultDataProvider())
  16. Create a security identifier.
  17. sid = SecurityIdentifier.generate_equity(point_in_time_ticker,
        Market.USA, True, map_file_provider, csv_date)
  18. Copy the process.sample.py script to the DataProcessing / bin / debug / net6.0 directory.
  19. You need to place the script under the bin directory so that LEAN's packages dlls are correctly loaded for the CLRImports.

    $ cp process.sample.py DataProcessing/bin/Debug/net6.0
  20. Run the DataProcessing / bin / debug / net6.0 / process.sample.py script to populate the Lean.DataSource.<vendorNameDatasetName> / output directory and the output directory in your machine's root directory.

    $ cd DataProcessing/bin/debug/net6.0/
    $ python process.sample.py
Note: The pull request you make at the end must contain sample data so we can review it and run the demonstration algorithms.

You can also see our Videos. You can also get in touch with us via Discord.

Did you find this page helpful?

Contribute to the documentation: