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
Release history Release notifications | RSS feed
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.9.tar.gz
(5.9 kB
view hashes)
Built Distribution
Close
Hashes for pggm_datalab_utils-2.9-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ec558ac8b896ed25d5cd3c9714f67ae4f8dcf30b8a35ad18d10840e85939c6da |
|
MD5 | 5f9c92572e8eef835b3e23d7d99a0f9d |
|
BLAKE2b-256 | 83c46981d1d618986f38e1cfaea0b20a8a5255f5554c5ca0a79a66ba3c1750c2 |