Added data (/sample names) to the template (in dict form)

[hepcat72]

Summary Change Description

The data to add is extracted from errors:

• AllMissingSamplesError
  • The exception actually contains sample headers, so to get the sample name, it is modified to remove commonly appended strings such as "_pos"
• AllMissingTissues
• AllMissingTreatments

Row data is extracted in the form of a dict keyed on sheets. That dict records "row records" using a unique key. The record is a dict keyed on header name and is associated with the value to enter in the sheet.

Once all the data to add has been extracted from the exceptions, the sheet (in the form of a pandas-style dict) is then updated by grabbing the next available row and adding the new data to it.

Affected Issues/Pull Requests

• Partially addresses #829
• Merges into PR #931
• Next PR: #933

Review Notes

See comments in-line.

Checklist

This pull request will be merged once the following requirements are met. The author and/or reviewers should uncheck any unmet requirements:

• Review requirements
  • Minimum approvals: 1
  • No changes requested
  • All blocking issues resolved by reviewers
  • Specific reviewers: @add_username_here
  • Review period: 2 days
• Associated issue/pull request requirements:
  • [x] All requirements in affected issues marked "resolved" are satisfied
  • [x] All required pull requests are merged (or none)
• Basic requirements
  • [x] All linters pass
  • [x] All tests pass
  • [x] All conflicts resolved
• Overhead requirements
  • [x] New/changed method tests implemented/updated (or no change)
  • [ ] Updated Unreleased section of changelog.md (or no change)
  • [x] Migrations created & committed (or no change)

[hepcat72]

Rebase update coming. Just relinting and testing before push.