Advertisement
Guest User

Untitled

a guest
May 29th, 2016
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. import csv, time
  2. from datetime import date, timedelta
  3.  
  4. class RunDates():
  5.  
  6. def __init__(self):
  7. self.enterDate = '4/12/14'
  8. self.reader = csv.DictReader(open('dates.csv', 'rb'))
  9.  
  10. def findRunDate(self):
  11.  
  12. # Get the row of entered date or next closest
  13. csv = enumerate(self.reader)
  14. for i in range(5):
  15. t = time.strptime(self.enterDate, '%m/%d/%y')
  16. newdateArr = (date(t.tm_year, t.tm_mon,t.tm_mday)+timedelta(days=i)).strftime('%m/%d/%y').split('/')
  17. newdateStr = '/'.join( [str(int(newdateArr[0])), str(int(newdateArr[1])), newdateArr[2]] )
  18. print newdateStr, i
  19.  
  20. for num, row in csv:
  21. print row['Date'], num
  22. break
  23. if newdateStr == row['Date']:
  24. print 'Row Number: ' + str(num)
  25. print 'Row Date: ' + row['Date']
  26. print 'new Date: ' + newdateStr
  27. break
  28. else:
  29. pass
  30.  
  31.  
  32.  
  33. #Testing
  34. a = RunDates()
  35. a.findRunDate()
  36.  
  37. 4/12/14 0
  38. 4/29/16 0
  39. 4/13/14 1
  40. 4/28/16 1
  41. 4/14/14 2
  42. 4/27/16 2
  43. 4/15/14 3
  44. 4/26/16 3
  45. 4/16/14 4
  46. 4/25/16 4
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement