Com.py duplicate rows where more than one "Common_PreTechID" [bug]

[simularis]

Pull Request (PR) Description

Corrects an issue where more than one "Common_PreTechID" in the batch of measures causes the renaming step to fail silently and generate duplicate rows with mismatched data.

This change was previously applied in residential scripts via PR #19, commit 9da1f04.

PR Author

• [x] Make sure the PR branch is up to date with main branch at the time of the PR submission
• [x] Craft a succinct title that effectively encapsulates the essence of the pull request, providing a general overview of the proposed changes.
• [x] Label the PR with at least one of the following: New Measure, Bug, or Feature.
• [x] Provide a concise description of the measure, bug, or feature. Submit one PR per measure.
• N/A - For a new measure, attach a workbook named DEER_EnergyPlus_Modelkit_Measure_list_working.xlsx, containing only rows used for post-processing the measure.
• [x] Add comments in the code when necessary to facilitate the review process.
• [x] Add a comment before the added code, including the author's full name, company, and specifying if it's a bug fix, new measure, or feature.
• N/A - For a new feature or bug, demonstrate the impact on energy consumption for selected cases with justification using plots and descriptions.
• N/A - For a new measure, add a summary table showing total energy consumption per simulated case.

  PR Reviewer

• [ ] Conduct a thorough code review.
• [ ] If the branch is behind the main, merge the branch locally to check for potential conflicts.
• [ ] If a bug, locally reproduce it and compare energy consumptions before and after.
• [ ] Explore creative ways to stress-test the code.
• [ ] Locally check the error file and other outputs.

[lyt5410]

This is okay to merge. @amine-lazrak

[simularis]

Thank you.