[GLLUG] Digests of CSV files

Bernard Peek bap at shrdlu.com
Fri Jan 5 19:10:18 UTC 2018



On 05/01/18 18:11, John Levin via GLLUG wrote:
> Dear list,
>
> I'm having a bad google day, and am not sure what terms to search on, 
> so I hope the list will point me in the right direction.
>
> I have a number of csv files (of c18th imprisoned debtors). There are 
> three important columns: gender, prison, trade. What I want is a 
> program or script that will simply digest each column and relate them 
> to each other, producing something along the lines of:
> There are 200 weavers.
> There are 190 male weavers.
> There are 20 weavers in Norwich Castle.
> There are 18 male weavers in Norwich Castle.

My approach would be to load the data into a database and write SQL 
queries against it. Second-best solution would probably be a 
spreadsheet. But if you want to write scripts then I suppose perl or awk 
are candidates.

-- 
Bernard Peek

   bap at shrdlu.com




More information about the GLLUG mailing list