Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import csv, time
- from datetime import date, timedelta
- class RunDates():
- def __init__(self):
- self.enterDate = '4/12/14'
- self.reader = csv.DictReader(open('dates.csv', 'rb'))
- def findRunDate(self):
- # Get the row of entered date or next closest
- csv = enumerate(self.reader)
- for i in range(5):
- t = time.strptime(self.enterDate, '%m/%d/%y')
- newdateArr = (date(t.tm_year, t.tm_mon,t.tm_mday)+timedelta(days=i)).strftime('%m/%d/%y').split('/')
- newdateStr = '/'.join( [str(int(newdateArr[0])), str(int(newdateArr[1])), newdateArr[2]] )
- print newdateStr, i
- for num, row in csv:
- print row['Date'], num
- break
- if newdateStr == row['Date']:
- print 'Row Number: ' + str(num)
- print 'Row Date: ' + row['Date']
- print 'new Date: ' + newdateStr
- break
- else:
- pass
- #Testing
- a = RunDates()
- a.findRunDate()
- 4/12/14 0
- 4/29/16 0
- 4/13/14 1
- 4/28/16 1
- 4/14/14 2
- 4/27/16 2
- 4/15/14 3
- 4/26/16 3
- 4/16/14 4
- 4/25/16 4
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement