Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: perl group by and sort from a csv input file

by Corion (Patriarch)
on Jul 27, 2017 at 07:34 UTC ( [id://1196144]=note: print w/replies, xml ) Need Help??


in reply to perl group by and sort from a csv input file

The easiest approaches are to use either DBD::CSV or to load your CSV data into a database and then to use SQL to run your queries against that. See also DBI.

The harder approach would be to implement the aggregation yourself.

As you don't show any code, it's hard to give you more specific advice, as I can't really tell where you are having problems.

The synopsis section of DBD::CSV shows all there is to using a CSV file as a DBI table.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1196144]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having a coffee break in the Monastery: (5)
As of 2024-03-29 06:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found