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 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 >>> <[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, >>>> >>>> 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/ _______________________________________________ Users mailing list [email protected] http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
