oemof-solph icon indicating copy to clipboard operation
oemof-solph copied to clipboard

Results to CSV

Open simnh opened this issue 6 years ago • 2 comments

I think it might be a nice feature to write results to CSV based on a standard logic (e.g. as we had in renpassGIS). We would need a structure for this, the implementation would be pretty simple and straight forward based on the processing etc. functionalities.

Somebody also interested? Willing to make a proposal for the resulting structure of CSV / directories?

simnh avatar Mar 11 '18 08:03 simnh

An issue that I won on the dev meeting for pushing it forward :)

Actually, I have no idea how the structure in renpassGIS looks like. Generally, from the user perspective I think this feature could be helpful. The difficulty is probably to design a good structure. Everybody’s models are different, so it will be very difficult to design a structure that satisfies everybody’s need. So my first, really simple suggestion would be a csv table containing all the flows (sequences) and a second csv table containing all the scalars if investment options are used. For the csv table of sequences, two options could be selected. In both ways all sequences are exported without redundancy (right? ;)):

  1. bus-oriented structure: so all flows of the buses are put next to each other (multiindex level 1: label bus; multiindex level 2: flow)
  2. components-oriented structure: multi-index level 1: Sources/Sinks/Transformer/Storages; multiindex level 2: label of components; multiindex level 3: flows

actually, I don't know if multiindex is that practical for csv files. Maybe we could include the option of a selection of csv, excel etc. as output?

joroeder avatar Jun 04 '19 09:06 joroeder

At the moment, this topic does not seem to be on the agenda of somebody. Or, shall we close this issue?

joroeder avatar Mar 12 '20 10:03 joroeder