Skip to main content

Utilities created and used by the Datalab of PGGM

Project description

Datalab utils

Well-specified utilities from the Datalab of PGGM. Our aim with this package is to provide some tooling to make our lives a bit easier. So far the package contains:

  • Database utilities, allowing you to connect to cloud databases using pyodbc in a standard pattern.
  • Helpers around nested lists (flattening and unflattening).
  • Helpers to make working with lists of dictionaries a bit easier so you don't have to resort to Pandas as fast.

How to use the database helpers

from pggm_datalab_utils.db import cursor, query

bbg_id = 'WOW'

with cursor('pggm-sql-lre-o.database.windows.net', 'lre') as c:
    data = query(c, 'select sedol, name from portfolio where bbg_id=?', bbg_id)

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pggm_datalab_utils-2.17.tar.gz (43.3 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

pggm_datalab_utils-2.17-py3-none-any.whl (6.4 kB view details)

Uploaded Python 3

File details

Details for the file pggm_datalab_utils-2.17.tar.gz.

File metadata

  • Download URL: pggm_datalab_utils-2.17.tar.gz
  • Upload date:
  • Size: 43.3 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: uv/0.5.10

File hashes

Hashes for pggm_datalab_utils-2.17.tar.gz
Algorithm Hash digest
SHA256 977a1896c8eca4b600afdb6d126c53311f87a5a41756c55686ac053f6cc4475d
MD5 ac446005bbc36bd483f57f2cbb1f282b
BLAKE2b-256 8632a6ca4555ffa47fe27c66373bde7583744d82a88435b0de08f46cac989af4

See more details on using hashes here.

File details

Details for the file pggm_datalab_utils-2.17-py3-none-any.whl.

File metadata

File hashes

Hashes for pggm_datalab_utils-2.17-py3-none-any.whl
Algorithm Hash digest
SHA256 e26696e601704ee0346ead73c225791fe9557b4ca85180dc351cd9cb4802fd21
MD5 fe9b7b106baa24f03dd222b043669bd5
BLAKE2b-256 9ce9c606610df84293d3e8db5aceff47bd6f2f7aff3548ea77bdbafcda77e213

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page