[IronPython] Sorting CSV file

[Slide]

On Fri, Jan 23, 2009 at 6:21 AM, Dody Gunawinata
<empirebuilder at gmail.com> wrote:
> 1. Define a class to hold individual data
> 2. Go through every single line
> 3. Split based on ',' and insert the values to the object and add them to
> the list
> 4. Sort the list based on the fields you want.
> On Fri, Jan 23, 2009 at 10:28 AM, Sheetal Gophane
> <sheetal_gophane at persistent.co.in> wrote:
>>
>> Hi All,
>>
>>
>>
>> I have csv file in following format
>>
>> LogTime,ApetClientID,OperationName,Status,StartTime,Duration
>>
>> 2009-01-07/10:41:03,1,fun1,1,2009-01-07/10:41:02,314.8173162
>>
>> 2009-01-07/10:41:03,1,Login,0,2009-01-07/10:41:02,618.2695007
>>
>> 2009-01-07/10:41:03,1,Login,1,2009-01-07/10:40:52,10997.29274
>>
>> 2009-01-07/10:41:04,1,fun2,1,2009-01-07/10:41:03,364.0241288
>>
>> 2009-01-07/10:41:04,1,DoLogin,1,2009-01-07/10:40:52,11248.42243
>>
>> 2009-01-07/10:41:04,1,fun3,1,2009-01-07/10:41:03,1197.179181
>>
>>
>>
>> I want to sort this file on the basis of first field i.e. LogTime
>>
>> Any pointers,how to do this?
>>
>> Thanks in advance.
>>
>>
>>
>> Thanks & Regards,
>>
>> Sheetal
>>
>>
>>


Why not use the csv module from the standard library? Should be simple
to read the lines in using the CSVReader and have it already split for
you. I'd recommend reading it into a dict and then sorting the dict
based on that field as was already mentioned.