An almost-generic approach to any problem of this sort is, first, to use a package like Text::CSV (or do a search at http://search.cpan.org for the (currently) 463 packages that match the search-term “CSV”), then write a solution that uses lists and/or hashes.

Or, consider a purely non-Perl solution, such as what is offered by the (public domain!) SQLite database (http://www.sqlite.org), which is a server-less, “all in one file” SQL engine that is certainly in your cell phone and maybe also in your microwave oven.   Now, all your data is in “one file” that you can query, and you did not have to “write a program” either to get the CSV-formatted data into it, nor to get your answers out.   And, when (your manager | your customer | the sales department) says to you, “this is wonderful, but now can you tell me <this?>, umm, right now?” ... you can probably just about do it on the spot.   And that, to me, says, “Win!”