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.17.tar.gz
(43.3 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.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
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
977a1896c8eca4b600afdb6d126c53311f87a5a41756c55686ac053f6cc4475d
|
|
| MD5 |
ac446005bbc36bd483f57f2cbb1f282b
|
|
| BLAKE2b-256 |
8632a6ca4555ffa47fe27c66373bde7583744d82a88435b0de08f46cac989af4
|
File details
Details for the file pggm_datalab_utils-2.17-py3-none-any.whl.
File metadata
- Download URL: pggm_datalab_utils-2.17-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 |
e26696e601704ee0346ead73c225791fe9557b4ca85180dc351cd9cb4802fd21
|
|
| MD5 |
fe9b7b106baa24f03dd222b043669bd5
|
|
| BLAKE2b-256 |
9ce9c606610df84293d3e8db5aceff47bd6f2f7aff3548ea77bdbafcda77e213
|