Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:
Hi,
Here is what I am trying to do.
Read the CSV (excel sheet saved as a comma separated file) file into a perl data structure (either hash of array OR array of arrays). And sort based on one of the columns. When this is done, I want the rest of the columns too to be re-ordered based on the sorted column. That is the columns of a row must remain same.
For eg: This is the CSV file.
Name,Score,State
Mike,67,CA
Rob,63,FL
Jim,72,IL
Chan,32,AZ
When this is read into a perl data structure, and suppose I sort the column for Score in ascending order, I want the rest of the fields corresponding to the column to be re-ordered. So the result should be
Chan,32,AZ
Rob,63,FL
Mike,67,CA
Jim,72,IL
1. What data structure is best suited for above?
2. And how to achieve the above?
Thanks in advance.
Here is what I am trying to do.
Read the CSV (excel sheet saved as a comma separated file) file into a perl data structure (either hash of array OR array of arrays). And sort based on one of the columns. When this is done, I want the rest of the columns too to be re-ordered based on the sorted column. That is the columns of a row must remain same.
For eg: This is the CSV file.
Name,Score,State
Mike,67,CA
Rob,63,FL
Jim,72,IL
Chan,32,AZ
When this is read into a perl data structure, and suppose I sort the column for Score in ascending order, I want the rest of the fields corresponding to the column to be re-ordered. So the result should be
Chan,32,AZ
Rob,63,FL
Mike,67,CA
Jim,72,IL
1. What data structure is best suited for above?
2. And how to achieve the above?
Thanks in advance.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: sorting CSV files
by ptum (Priest) on Nov 30, 2005 at 14:35 UTC | |
Re: sorting CSV files
by derby (Abbot) on Nov 30, 2005 at 14:36 UTC | |
by argupta (Initiate) on Feb 05, 2009 at 22:43 UTC | |
by derby (Abbot) on Feb 05, 2009 at 23:12 UTC | |
Re: sorting CSV files
by dorward (Curate) on Nov 30, 2005 at 14:59 UTC | |
Re: sorting CSV files
by swkronenfeld (Hermit) on Nov 30, 2005 at 18:37 UTC | |
Re: sorting CSV files
by hakkr (Chaplain) on Nov 30, 2005 at 14:37 UTC | |
Re: sorting CSV files
by crashtest (Curate) on Dec 01, 2005 at 02:04 UTC | |
by Anonymous Monk on Apr 28, 2008 at 07:19 UTC | |
by crashtest (Curate) on May 01, 2008 at 18:16 UTC | |
by Anonymous Monk on May 06, 2008 at 07:57 UTC |
Back to
Seekers of Perl Wisdom