Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question

results extraction CSVs

asked 2022-04-06 13:25:58 -0500

qirachel's avatar

updated 2022-04-07 08:48:08 -0500


I am trying to exact this circled value from the report 'Component Cost Economics Summary' in the eplustbl.csv output file. However, I have no idea how to differentiate the row from the others since they all start with "--".

Any ideas on how to solve this problem? Thanks in advance :)

image description

edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted

answered 2022-04-18 17:02:26 -0500

Assuming this is an EnergyPlus output table, I would recommend using the SQL output file and executing a query such as

SELECT Value FROM TabularDataWithStrings WHERE TableName = ...

This could be accomplished with a Python script using the sqlite3 library.

edit flag offensive delete link more

answered 2022-04-07 08:17:01 -0500

Jim Dirkes's avatar

Making some assumptions: 1) You're using EnergyPlus

2) It appears you've imported the data into Excel, since there are no commas separating each field

3) an Excel Vlookup(datarange,linenumber,7) should work (or something similar)

4) If you're trying to extract the data from another software, a similar lookup function should be available

ps, the format of eplustbl files varies depending on the reports you specify. For a particular set of reports, though, the format will remain stable and you can make your formula appropriately.

Another idea: I use a macro for extracting tariff information which first looks for a unique text string, then offsets specific rows and columns for the data I'm interested in

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Training Workshops


Question Tools

1 follower


Asked: 2022-04-06 13:25:58 -0500

Seen: 157 times

Last updated: Apr 18 '22