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.19.tar.gz
(44.4 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.19.tar.gz.
File metadata
- Download URL: pggm_datalab_utils-2.19.tar.gz
- Upload date:
- Size: 44.4 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: uv/0.6.3
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
50d0c2acfcf6838af59889e2d6eec02caa4e3ad85c5486c3245d8763414ac5b1
|
|
| MD5 |
fdc59878f8844e6f67ef59bafba2b437
|
|
| BLAKE2b-256 |
cc95217f50291861b08ac2d1214ae6a9ca5c5b203c2c5d39074eda419ad53a04
|
File details
Details for the file pggm_datalab_utils-2.19-py3-none-any.whl.
File metadata
- Download URL: pggm_datalab_utils-2.19-py3-none-any.whl
- Upload date:
- Size: 6.5 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: uv/0.6.3
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
26f458336773ad39b670b3d82f038216c6d05e465a2d51f644f72ac42456801f
|
|
| MD5 |
e7effc82158f9375643eac05d1ac41eb
|
|
| BLAKE2b-256 |
64b27a873ecfd3c01a3f319b6deef6d472566d288dbbb3bf2863f08e98e4dc1a
|
