On 24/01/2009 5:13 PM, Sheetal Gophane wrote:
Thank you all for your suggestions. I followed the following way 1.Define a class 2.In class overwrite __cmp__ function. 3.While reading file populate class object and append it in array. 4.Call array.sort() method. Internally it calls __cmp__ function.Thanks, Sheetal -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Slide Sent: Friday, January 23, 2009 9:15 PM To: Discussion of IronPython Subject: Re: [IronPython] Sorting CSV file On Fri, Jan 23, 2009 at 7:28 AM, Michael Foord <[email protected]> wrote:Slide wrote:On Fri, Jan 23, 2009 at 6:21 AM, Dody Gunawinata <[email protected]> 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 themtothe list 4. Sort the list based on the fields you want. On Fri, Jan 23, 2009 at 10:28 AM, Sheetal Gophane <[email protected]> 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, SheetalWhy 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 andIronPython:http://www.ironpython.info/index.php/Reading_CSV_Files http://www.ironpython.info/index.php/Talk:Reading_CSV_Files MichaelAh, could be, although I thought I had used it in IronPython before, but I could be thinking of something else. slide
_______________________________________________ Users mailing list [email protected] http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
