It feels a lot like storing your data as an essay in a Word doc instead of a spreadsheet. It can work and all of the math is probably correct, but it's very much the wrong tool when the structured data was right there to be used instead.
You can only correct for missing entries by doing the same work you’d need to start from scratch. But after that you now have a second list to consider.
Of course it’s not the kind of question you can get an objectively correct answer for, but you could come up with the correct answer for a given methodology.
Especially in cases such as this. For well known works of literature and music structured data exists already.