[IronPython] Sorting CSV file

[Michael Foord]

Slide wrote:
> 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.
>   

Isn't the standard library csv module dependent on a C extension?

There are recipes here for reading a CSV with a .NET library and IronPython:
http://www.ironpython.info/index.php/Reading_CSV_Files
http://www.ironpython.info/index.php/Talk:Reading_CSV_Files

Michael


> _______________________________________________
> Users mailing list
> Users at lists.ironpython.com
> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
>