PSR Lakehouse 🏞️🏡
A Python client library for accessing PSR's data lakehouse API, providing easy access to Brazilian energy market data including ANEEL, CCEE and ONS datasets.
📦 Installation
pip install psr-lakehouse
⚙️ Quick Start
Configure the API URL:
export LAKEHOUSE_API_URL="https://api.example.com"
Log in (the production lakehouse is behind PSR's Cognito sign-in — the session is cached in ~/.psr-lakehouse/, so this is a one-off):
psr-lakehouse login
Fetch data from the API:
from psr.lakehouse import client
# Fetch CCEE spot price data
df = client.fetch_dataframe(
table_name="ccee_spot_price",
data_columns=["spot_price"],
start_reference_date="2023-05-01",
end_reference_date="2023-05-02",
filters={"subsystem": "SOUTHEAST"},
)
print(df)
📚 Documentation
For complete documentation including advanced features, API reference, and examples, visit the full documentation.
Features include:
- Data filtering and aggregation
- Temporal aggregation with datetime granularity
- Complex queries with table joins
- Schema discovery and exploration
- Custom ordering and timezone support
💬 Support
For questions or issues, please open an issue on the project repository.
1 maintainer
Release files for psr-lakehouse 0.5.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| psr_lakehouse-0.5.0.tar.gz | 982.0 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| psr_lakehouse-0.5.0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 1.0 MB
Release files / psr_lakehouse-0.5.0.tar.gz
| Download URL | psr_lakehouse-0.5.0.tar.gz |
|---|---|
| Size | 982.0 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
e9694023793f71e97b5f1000923371090ab0e7acb8a3bdadf6179b37e68225d4
|
|
BLAKE2b-256 checksum How to use checksums |
2209c2dff4b658f6d92207abd5e9b7ea7a69138c6a2ceb60924b61208fc64268
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
uv/0.12.3 {"installer":{"name":"uv","version":"0.12.3","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}
|
Release files / psr_lakehouse-0.5.0-py3-none-any.whl
| Download URL | psr_lakehouse-0.5.0-py3-none-any.whl |
|---|---|
| Size | 23.2 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
901177144559174771e5527cc3b78d37c6345138a252d4077673c0853f202dc8
|
|
BLAKE2b-256 checksum How to use checksums |
7418a4cf89fdfc8259bba3a7c8dfcba47e9e8bd235f0ad6c63bc64e911d5b2e7
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
uv/0.12.3 {"installer":{"name":"uv","version":"0.12.3","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}
|
