Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. carMonthly = pd.DataFrame(data={'avSpeed': [40.3, 23.4], 'dist': [100, 150]},
  2. index=pd.PeriodIndex(['2019-02', '2019-05'], freq='M'))
  3.  
  4. avSpeed dist
  5. 2019-02 40.3 100
  6. 2019-05 23.4 150
  7.  
  8. avSpeed dist
  9. 2019-02-01 40.3 3.571428
  10. 2019-02-02 40.3 3.571428
  11. ...
  12. 2019-02-27 40.3 3.571428
  13. 2019-02-28 40.3 3.571428 #until end of February
  14. 2019-05-01 23.4 4.838710
  15. 2019-05-02 23.4 4.838710
  16. ...
  17. 2019-05-30 23.4 4.838710
  18. 2019-05-31 23.4 4.838710
  19.  
  20. carDaily = pd.DataFrame()
  21. carDaily['avSpeed'] = carMonthly['avSpeed'].resample('D').ffill()
  22. tempSeries = carMonthly['dist'].resample('D').first()
  23. carDaily['dist'] = tempSeries.groupby(tempSeries.notna().cumsum())
  24. .apply(lambda x: x/len(x.index)).ffill()
  25.  
  26. avSpeed dist
  27. 2019-02-01 40.3 1.123596
  28. 2019-02-02 40.3 1.123596
  29. ...
  30. 2019-04-29 40.3 1.123596
  31. 2019-04-30 40.3 1.123596 #until end of April
  32. 2019-05-01 23.4 4.838710
  33. 2019-05-02 23.4 4.838710
  34. ...
  35. 2019-05-30 23.4 4.838710
  36. 2019-05-31 23.4 4.838710
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement