My best guess is that you are going up against candidates who are able to fluently process and manipulate CSV data in 40 minutes, probably using python. If that is indeed the gap that is preventing you from passing interviews, consider grinding leetcode problems, and getting good at filtering, sorting, transforming lists and dictionaries, etc.
Finally, I'm sorry to hear your going through this ordeal. Best of luck to you.