If someone is trained to the point of working on genetic data at this level, should they not also have been trained to a reasonable level in domain appropriate software and tools?
There’s many times where I don’t want to do anything more than open, sort, filter, and never see the file again. And I’d like something better than Excel, but haven’t found it.
Maybe 70% the time, vi or BBEdit or shell commands work but otherwise excel.
For anything of significance, I use Python notebooks or dedicated data environment.
If there was a better tool, I think people would train. But there’s not, that I’m aware of, so Excel sticks around.
I’ve done some travel to Africa and am amazed at the ingenuity/batshit workflows that exist to get work done and live life.