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
