Ruby is a great scripting language, it’s easy to read and write, and it can automate pretty much anything. It’s a prime candidate for data analysis and general business process automation.
When working with CRM exports to carry out audience analyses, one simple time saver would be if we could instantly delete irrelevant columns that haven’t got enough data in them to be useful. To that end, I wrote this little ruby script that deletes columns with fewer than 10 records, it uses nothing other than ruby’s standard CSV library.
This opens the CSV as a table and sets it to be handled by columns
Here we delete columns if they have fewer than 10 records, using .compact to discount empty cells
Finally, we save the file in a new CSV.
I hope that by sharing this I can save others in the same situation some time. 👍