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.18.tar.gz
(44.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.18.tar.gz.
File metadata
- Download URL: pggm_datalab_utils-2.18.tar.gz
- Upload date:
- Size: 44.3 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: uv/0.5.10
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
ad663e421d1444934bb94e194f834501ac1c78cd56fcd5d599b9ae4e7e2d411b
|
|
| MD5 |
d55649d1d285ff4795a4bd6d47840e73
|
|
| BLAKE2b-256 |
7088b38fb55898a1d9165644acefe70f6b0240e14c0b8418cbe11544c2babd34
|
File details
Details for the file pggm_datalab_utils-2.18-py3-none-any.whl.
File metadata
- Download URL: pggm_datalab_utils-2.18-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 |
68a396f943ae4a34f93de12357e00c3a1051c152b9e6b7b925300154eb2cee8f
|
|
| MD5 |
15ea95523bdcc810b12e2cd66edb9ba4
|
|
| BLAKE2b-256 |
5b866d06dc30b3e8c12da439da81ff0fdd55dc019ebebd419b33aa97da968db5
|
