Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Update a subset of data through Scenario.read_excel() #409

Open
behnam-zakeri opened this issue Mar 25, 2021 · 1 comment
Open

Update a subset of data through Scenario.read_excel() #409

behnam-zakeri opened this issue Mar 25, 2021 · 1 comment
Labels
enh New features & functionality

Comments

@behnam-zakeri
Copy link
Contributor

For some users who aim to import the data by reading that from Excel, there is only one option and that is to import the entire Excel workbook through ixmp.Scenario.read_excel(). This may be unnessary and time-consuming, if a user aims to edit a subset of data in Excel, e.g., only in one parameter, and update that part of data in their database. This type of workflow does not need to import the whole data again each time using read-excel().
It will be useful to add a feature to read_excel() to select a subset of data, either by sheet names, by filtering using the same syntax as ixmp, or combination of both.
For example: ixmp.Scenario.read_excel('filename.xlsx', sheet_name='bar', filters={'node': 'foo'})

@behnam-zakeri behnam-zakeri added the enh New features & functionality label Mar 25, 2021
@khaeru
Copy link
Member

khaeru commented Mar 25, 2021

Thanks for noting this @behnam-zakeri!

I removed assignments for myself and @OFR-IIASA because it has not been decided who will work on this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enh New features & functionality
Projects
None yet
Development

No branches or pull requests

3 participants