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)
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.16.tar.gz
(67.0 kB
view details)
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file pggm_datalab_utils-2.16.tar.gz.
File metadata
- Download URL: pggm_datalab_utils-2.16.tar.gz
- Upload date:
- Size: 67.0 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: uv/0.5.10
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
ad88c0c3f5b9db0270bb8dc13d2df7207860355be35a6be73bfe27f339bb6763
|
|
| MD5 |
aa99357edfd5845ac592fc891370e634
|
|
| BLAKE2b-256 |
e3a8e100eaa63d2926992c4d290760c34ad27f3458da99da0df22c547997849c
|
File details
Details for the file pggm_datalab_utils-2.16-py3-none-any.whl.
File metadata
- Download URL: pggm_datalab_utils-2.16-py3-none-any.whl
- Upload date:
- Size: 6.4 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: uv/0.5.10
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
71ffa7cffa77767b117b443e61f33dd0dba30e65ab743e8edf2cfb3a58fccf37
|
|
| MD5 |
7eec76dda78f33f04bc8409a39d728dd
|
|
| BLAKE2b-256 |
fc7b35c06e1390e000bb0538fdc6915cd5cebae08917ac0b1cc81b1c7819df92
|
