EnergySystemsModellingLab / EnergySystemsModellingLab/MUSE_OS

Create minimal example database with SQLAlchemy and/or DuckDB

Aperta
#331 0 commenti 0 reazioni 2 assegnatari Rivendicata da @cc-a Vedi su GitHub
inputs
Lingua principale
Python
Stelle
29
Fork
12
Metriche di merge delle PR
Nessuna PR unita negli ultimi 30g

Descrizione

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.

Guida per i contributori

Nessuna guida per i contributori indicizzata per questo repository

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.