Consider using SQL instead of Spreadsheet/Excel
tanin.nanakorn.com
tanin.nanakorn.com
I'm comfortable with programming languages, but I rarely write a Ruby code to process a CSV file. I still prefer using spreadsheet or SQL for simpler tasks.
Panda/Python is the most powerful option for sure, but it's hard to say whether a person would prefer this option.