[IronPython] Sorting CSV file

[Slide]

On Fri, Jan 23, 2009 at 7:28 AM, Michael Foord
<fuzzyman at voidspace.org.uk> wrote:
> 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
>
>


Ah, could be, although I thought I had used it in IronPython before,
but I could be thinking of something else.

slide


-- 
slide-o-blog
http://slide-o-blog.blogspot.com/