Re: [Tutor] Processing CSV files

2013-10-08 Thread Leena Gupta
all the rows. I am planning to do this in Python. Do you foresee any issues with this approach? Any advise on this will be greatly appreciated. Thanks a ton! On Tue, Oct 8, 2013 at 2:28 PM, Dave Angel wrote: > On 8/10/2013 16:46, Leena Gupta wrote: > > > Hello, > > > >

[Tutor] Processing CSV files

2013-10-08 Thread Leena Gupta
Hello, Looking for some inputs on Python's csv processing feature. I need to process a large csv file every 5-10 minutes. The file could contain 3mill to 10 mill rows and size could be 6MB to 10MB(+). As part of the processing, I need to sum up a number value by grouping on certain attributes and

[Tutor] Regex Question

2013-09-30 Thread Leena Gupta
Hello, I have a TSV file that has the city,state,country information in this format: Name Display name Code San Jose SJC SJC - SJ (POP), CA (US) San Francisco SFOSFO - SF, CA (US) I need to extract the state and country for each