import datetime
min = datetime.date(2008, 1, 1)
max = datetime.date(2012, 12, 31)
file = open ('test2.txt','r')
line = file.readline()[-1]
while line:
# your code
2011/3/9 nookasree ponamala <nookas...@yahoo.com>
> Hi,
>
> I need help in finding the minimum date and maximum date in a file.
> Here is my test file:
> s.no: dt1 amt id1 id2
> 452 2010-02-20 $23.26 059542 06107
> 452 2010-02-05 $20.78 059542 06107
> 451 2010-02-24 $5.99 059542 20151
> 452 2010-02-12 $114.25 839745 98101
> 452 2010-02-06 $28.00 839745 06032
> 451 2010-02-12 $57.00 839745 06269
>
> I want to get the minimum and maximum dt1 for each id1
>
> Required result:
>
> id1 mindate maxdate
> 059542 2010-02-24 2010-02-20
> 839745 2010-02-06 2010-02-12
>
> Code: The code I tried. It doesn't work though.
>
> import sys
> import os
> t = ()
> tot = []
> maxyr = 2012
> minyr = 2008
> maxday = 31
> minday = 1
> maxmon = 12
> minmon = 1
>
> for line in open ('test2.txt','r'):
> data = line.rstrip().split()
> a = data[3]
> b = data[1]
> (year, month, day) = b.split('-')
> year = int(year)
> month = int(month)
> day = int(day)
> if year > maxyr:
> maxyr = year
> elif year < minyr:
> minyr = year
> if month > maxmon:
> maxmon = month
> elif month < minmon:
> minmon = month
> if day > maxday:
> maxday = day
> elif day < minday:
> minday = day
> max = (maxyr,maxmon,maxday)
> min = (minyr,minmon,minday)
> t = (a,b,max,min)
> tot.append(t)
> print t
>
> Could you pls. help me with this.
>
> Thanks
> Sree.
>
>
>
>
> _______________________________________________
> Tutor maillist - Tutor@python.org
> To unsubscribe or change subscription options:
> http://mail.python.org/mailman/listinfo/tutor
>
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor
