davedec
New Member
- Joined
- Jul 15, 2013
- Messages
- 11
Hi there, I have a basic time series data with dates and returned results (weights of animals).
The capture is on a monthly basis, however the capture is not always exactly the same period between periods (i.e. one capture point maybe on the 15th of one month and the 18th of another month)
In order to forecast animal weights in the future my approach has been to interpolate the time series to a daily basis then use the forecast.ets function based on the history of capture points, and future dates to provide a forecast.
I am striking a couple of issues:
1. The need to take the time series to a daily basis is due to irregular data capture in points in time
2. Using the forecast.ets function to provide a forecast on a daily basis seems to be resource heavy and slow
3. Does anyone know if it is possible to change to arrangement of the fx to flip the forecast question around. i.e. instead of providing a history of dates and weights and asking the weight for a future date, could it be asked based on a history of dates and weights at what date would the animal be a certain weight?
Any thoughts or suggestions would be greatly appreciated
Regards
Dave
Apologies there seems to be a difficulty capturing the Fx in this range - forecast is in yellow
The capture is on a monthly basis, however the capture is not always exactly the same period between periods (i.e. one capture point maybe on the 15th of one month and the 18th of another month)
In order to forecast animal weights in the future my approach has been to interpolate the time series to a daily basis then use the forecast.ets function based on the history of capture points, and future dates to provide a forecast.
I am striking a couple of issues:
1. The need to take the time series to a daily basis is due to irregular data capture in points in time
2. Using the forecast.ets function to provide a forecast on a daily basis seems to be resource heavy and slow
3. Does anyone know if it is possible to change to arrangement of the fx to flip the forecast question around. i.e. instead of providing a history of dates and weights and asking the weight for a future date, could it be asked based on a history of dates and weights at what date would the animal be a certain weight?
Any thoughts or suggestions would be greatly appreciated
Regards
Dave
Apologies there seems to be a difficulty capturing the Fx in this range - forecast is in yellow
EID | 951 000310440436 | |||||||
Day | Hist / Forecast | Date / Weights --> | Scan | Last Weight | Next Weight | Last Date | Next Date | ETS |
454 | Hist | 29-Nov-2019 | 311 | 311 | 311 | 29-Nov-2019 | 29-Nov-2019 | 311.00 |
455 | Hist | 30-Nov-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 311.73 | |
456 | Hist | 01-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 312.46 | |
457 | Hist | 02-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 313.20 | |
458 | Hist | 03-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 313.93 | |
459 | Hist | 04-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 314.66 | |
460 | Hist | 05-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 315.39 | |
461 | Hist | 06-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 316.12 | |
462 | Hist | 07-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 316.85 | |
463 | Hist | 08-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 317.59 | |
464 | Hist | 09-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 318.32 | |
465 | Hist | 10-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 319.05 | |
466 | Hist | 11-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 319.78 | |
467 | Hist | 12-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 320.51 | |
468 | Hist | 13-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 321.24 | |
469 | Hist | 14-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 321.98 | |
470 | Hist | 15-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 322.71 | |
471 | Hist | 16-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 323.44 | |
472 | Hist | 17-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 324.17 | |
473 | Hist | 18-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 324.90 | |
474 | Hist | 19-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 325.63 | |
475 | Hist | 20-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 326.37 | |
476 | Hist | 21-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 327.10 | |
477 | Hist | 22-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 327.83 | |
478 | Hist | 23-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 328.56 | |
479 | Hist | 24-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 329.29 | |
480 | Hist | 25-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 330.02 | |
481 | Hist | 26-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 330.76 | |
482 | Hist | 27-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 331.49 | |
483 | Hist | 28-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 332.22 | |
484 | Hist | 29-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 332.95 | |
485 | Hist | 30-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 333.68 | |
486 | Hist | 31-Dec-2019 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 334.41 | |
487 | Hist | 01-Jan-2020 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 335.15 | |
488 | Hist | 02-Jan-2020 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 335.88 | |
489 | Hist | 03-Jan-2020 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 336.61 | |
490 | Hist | 04-Jan-2020 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 337.34 | |
491 | Hist | 05-Jan-2020 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 338.07 | |
492 | Hist | 06-Jan-2020 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 338.80 | |
493 | Hist | 07-Jan-2020 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 339.54 | |
494 | Hist | 08-Jan-2020 | 311 | 341 | 29-Nov-2019 | 09-Jan-2020 | 340.27 | |
495 | Hist | 09-Jan-2020 | 341 | 341 | 341 | 09-Jan-2020 | 09-Jan-2020 | 341.00 |
496 | Hist | 10-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 341.28 | |
497 | Hist | 11-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 341.56 | |
498 | Hist | 12-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 341.84 | |
499 | Hist | 13-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 342.13 | |
500 | Hist | 14-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 342.41 | |
501 | Hist | 15-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 342.69 | |
502 | Hist | 16-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 342.97 | |
503 | Hist | 17-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 343.25 | |
504 | Hist | 18-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 343.53 | |
505 | Hist | 19-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 343.81 | |
506 | Hist | 20-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 344.09 | |
507 | Hist | 21-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 344.38 | |
508 | Hist | 22-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 344.66 | |
509 | Hist | 23-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 344.94 | |
510 | Hist | 24-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 345.22 | |
511 | Hist | 25-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 345.50 | |
512 | Hist | 26-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 345.78 | |
513 | Hist | 27-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 346.06 | |
514 | Hist | 28-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 346.34 | |
515 | Hist | 29-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 346.63 | |
516 | Hist | 30-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 346.91 | |
517 | Hist | 31-Jan-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 347.19 | |
518 | Hist | 01-Feb-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 347.47 | |
519 | Hist | 02-Feb-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 347.75 | |
520 | Hist | 03-Feb-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 348.03 | |
521 | Hist | 04-Feb-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 348.31 | |
522 | Hist | 05-Feb-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 348.59 | |
523 | Hist | 06-Feb-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 348.88 | |
524 | Hist | 07-Feb-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 349.16 | |
525 | Hist | 08-Feb-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 349.44 | |
526 | Hist | 09-Feb-2020 | 341 | 350 | 09-Jan-2020 | 10-Feb-2020 | 349.72 | |
527 | Hist | 10-Feb-2020 | 350 | 350 | 350 | 10-Feb-2020 | 10-Feb-2020 | 350.00 |
528 | Hist | 11-Feb-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 350.34 | |
529 | Hist | 12-Feb-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 350.69 | |
530 | Hist | 13-Feb-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 351.03 | |
531 | Hist | 14-Feb-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 351.38 | |
532 | Hist | 15-Feb-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 351.72 | |
533 | Hist | 16-Feb-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 352.07 | |
534 | Hist | 17-Feb-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 352.41 | |
535 | Hist | 18-Feb-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 352.76 | |
536 | Hist | 19-Feb-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 353.10 | |
537 | Hist | 20-Feb-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 353.45 | |
538 | Hist | 21-Feb-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 353.79 | |
539 | Hist | 22-Feb-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 354.14 | |
540 | Hist | 23-Feb-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 354.48 | |
541 | Hist | 24-Feb-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 354.83 | |
542 | Hist | 25-Feb-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 355.17 | |
543 | Hist | 26-Feb-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 355.52 | |
544 | Hist | 27-Feb-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 355.86 | |
545 | Hist | 28-Feb-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 356.21 | |
546 | Hist | 29-Feb-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 356.55 | |
547 | Hist | 01-Mar-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 356.90 | |
548 | Hist | 02-Mar-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 357.24 | |
549 | Hist | 03-Mar-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 357.59 | |
550 | Hist | 04-Mar-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 357.93 | |
551 | Hist | 05-Mar-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 358.28 | |
552 | Hist | 06-Mar-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 358.62 | |
553 | Hist | 07-Mar-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 358.97 | |
554 | Hist | 08-Mar-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 359.31 | |
555 | Hist | 09-Mar-2020 | 350 | 360 | 10-Feb-2020 | 10-Mar-2020 | 359.66 | |
556 | Hist | 10-Mar-2020 | 360 | 360 | 360 | 10-Mar-2020 | 10-Mar-2020 | 360.00 |
557 | F_Cast | 11-Mar-2020 | 360.34 | |||||
558 | F_Cast | 12-Mar-2020 | 360.69 | |||||
559 | F_Cast | 13-Mar-2020 | 361.03 | |||||
560 | F_Cast | 14-Mar-2020 | 361.38 | |||||
561 | F_Cast | 15-Mar-2020 | 361.72 | |||||
562 | F_Cast | 16-Mar-2020 | 362.07 | |||||
563 | F_Cast | 17-Mar-2020 | 362.41 | |||||
564 | F_Cast | 18-Mar-2020 | 362.76 | |||||
565 | F_Cast | 19-Mar-2020 | 363.10 | |||||
566 | F_Cast | 20-Mar-2020 | 363.45 | |||||
567 | F_Cast | 21-Mar-2020 | 363.79 | |||||
568 | F_Cast | 22-Mar-2020 | 364.14 | |||||
569 | F_Cast | 23-Mar-2020 | 364.48 | |||||
570 | F_Cast | 24-Mar-2020 | 364.83 | |||||
571 | F_Cast | 25-Mar-2020 | 365.17 | |||||
572 | F_Cast | 26-Mar-2020 | 365.52 | |||||
573 | F_Cast | 27-Mar-2020 | 365.86 | |||||
574 | F_Cast | 28-Mar-2020 | 366.21 | |||||
575 | F_Cast | 29-Mar-2020 | 366.55 | |||||
576 | F_Cast | 30-Mar-2020 | 366.90 | |||||
577 | F_Cast | 31-Mar-2020 | 367.24 | |||||
578 | F_Cast | 01-Apr-2020 | 367.59 | |||||
579 | F_Cast | 02-Apr-2020 | 367.93 | |||||
580 | F_Cast | 03-Apr-2020 | 368.28 | |||||
581 | F_Cast | 04-Apr-2020 | 368.62 | |||||
582 | F_Cast | 05-Apr-2020 | 368.97 | |||||
583 | F_Cast | 06-Apr-2020 | 369.31 | |||||
584 | F_Cast | 07-Apr-2020 | 369.66 | |||||
585 | F_Cast | 08-Apr-2020 | 370.00 | |||||