EnergySystemsModellingLab / EnergySystemsModellingLab/MUSE_OS

Create minimal example database with SQLAlchemy and/or DuckDB

Open
#331 0 comments 0 reactions 2 assignees Claimed by @cc-a View on GitHub
inputs
Dominant language
Python
Stars
29
Forks
12
PR merge metrics
No merged PRs in 30d

Description

Before going forward with a full database for all the inputs, it's worth putting together a small database for a subset of the inputs, just to test out the approach and the tooling.

This should consist of:
- a set of csv files containing the data
- an in-memory database that reads in the csv files, with all the necessary validation steps. I think we've identified SQLAlchemy as an appropriate tool
- retrieval of data from the database into xarray and/or pandas

I'd probably go with the commodities section of the database to start with as it's relatively self contained.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.