-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtest.py
31 lines (24 loc) · 1.23 KB
/
test.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
from datetime import timedelta
from datetime import datetime
def getMissingDatesAndValues(inp):
listOfDates = list(inp.keys())
listOfValues = list(inp.values())
i=0
while listOfDates[-1]!=listOfDates[i]:
numberOfDaysInBetween = (datetime.strptime(listOfDates[i], "%Y-%m-%d").date() - datetime.strptime(listOfDates[i+1], "%Y-%m-%d").date()).days
numberToAddOrSub = int((inp[listOfDates[i]] - inp[listOfDates[i+1]])/numberOfDaysInBetween)
j=-1
if(numberOfDaysInBetween>1):
for j in range(numberOfDaysInBetween-1):
listOfDates.insert(i+j+1,datetime.strftime(datetime.strptime(listOfDates[i],"%Y-%m-%d").date() - timedelta(days=j+1),"%Y-%m-%d"))
listOfValues.insert(i+j+1,listOfValues[i+j]-numberToAddOrSub)
elif(numberOfDaysInBetween<-1):
for j in range(-numberOfDaysInBetween-1):
listOfDates.insert(i+j+1,datetime.strftime(datetime.strptime(listOfDates[i],"%Y-%m-%d").date() + timedelta(days=j+1),"%Y-%m-%d"))
listOfValues.insert(i+j+1,listOfValues[i+j]+numberToAddOrSub)
i+=(1 if j<0 else j+2)
return dict(zip(listOfDates,listOfValues))
inp = {"2019-01-01":100,"2019-01-04":115}
print(getMissingDatesAndValues(inp))
inp = {"2019-01-10":10,"2019-01-11":20,"2019-01-13":10}
print(getMissingDatesAndValues(inp))