Hey, I have this data set of 78 different locations where I have to predict the price of a single product for the next 3 months. The data has daily entries for about 6 months (April - October). But, when I run the model it gives me this error. Please help me to resolve this error.
Error: object of type 'closure' is not subsettable
My code:
Area_forecast <- data1 %>%
filter(product == "garri") %>%
select( level2code, ds, y = pred) %>%
mutate(ds = paste(ds, "01", "01", sep = "-") %>% as.Date()) %>%
group_by(level2code) %>%
do(model = prophet(.),
Predicted_values = make_future_dataframe(model,92),
results = predict(model, Predicted_values))
Disabling yearly seasonality. Run prophet with yearly.seasonality=TRUE to override this.
Disabling daily seasonality. Run prophet with daily.seasonality=TRUE to override this.
Sample data set:
| ds | product | level2code | pred |
|---|---|---|---|
| 2021-04-01 | garri | NG020001 | 366.1540473 |
| 2021-04-01 | garri | NG020002 | 393.3557317 |
| 2021-04-01 | garri | NG020003 | 374.3132972 |
| 2021-04-01 | garri | NG021001 | 353.1266783 |
| 2021-04-01 | garri | NG021002 | 329.9673004 |
| 2021-04-01 | garri | NG021003 | 391.1370065 |
| 2021-04-01 | garri | NG021004 | 306.1356683 |
| 2021-04-01 | garri | NG020004 | 372.8115048 |
| 2021-04-01 | garri | NG020005 | 350.0100309 |
| 2021-04-01 | garri | NG021005 | 373.0025842 |
| 2021-04-01 | garri | NG020006 | 383.1839042 |
| 2021-04-01 | garri | NG021006 | 383.5212653 |
| 2021-04-01 | garri | NG020007 | 486.8226379 |
| 2021-04-01 | garri | NG020008 | 334.8151487 |
| 2021-04-01 | garri | NG021007 | 379.89125 |
| 2021-04-01 | garri | NG021008 | 370.9376296 |
| 2021-04-01 | garri | NG021009 | 389.4640031 |
| 2021-04-01 | garri | NG021010 | 365.9266992 |
| 2021-04-01 | garri | NG020009 | 380.4655716 |
| 2021-04-01 | garri | NG020010 | 352.6139069 |
| 2021-04-01 | garri | NG020011 | 243.5701952 |
| 2021-04-01 | garri | NG021011 | 366.6883205 |
| 2021-04-01 | garri | NG021012 | 326.9402671 |
| 2021-04-01 | garri | NG020012 | 403.5666062 |
| 2021-04-01 | garri | NG021013 | 405.2860516 |
| 2021-04-01 | garri | NG021014 | 348.023662 |
| 2021-04-01 | garri | NG020013 | 372.7586167 |
| 2021-04-01 | garri | NG020014 | 392.5432373 |
| 2021-04-01 | garri | NG020015 | 362.1098193 |
| 2021-04-01 | garri | NG020016 | 343.9205353 |
| 2021-04-01 | garri | NG020017 | 366.5290601 |
| 2021-04-01 | garri | NG020018 | 431.0832709 |
| 2021-04-01 | garri | NG020019 | 411.3581413 |
| 2021-04-01 | garri | NG021015 | 348.3274897 |
| 2021-04-01 | garri | NG021016 | 336.3743799 |
| 2021-04-01 | garri | NG020020 | 393.8901327 |
| 2021-04-01 | garri | NG021017 | 391.7393648 |
| 2021-04-01 | garri | NG021018 | 346.0988762 |
| 2021-04-01 | garri | NG021019 | 346.1310667 |
| 2021-04-01 | garri | NG021020 | 359.2837766 |
| 2021-04-01 | garri | NG020021 | 450.4413674 |
| 2021-04-01 | garri | NG020022 | 373.6406838 |
| 2021-04-01 | garri | NG021021 | 420.0838824 |
| 2021-04-01 | garri | NG020023 | 408.6912783 |
| 2021-04-01 | garri | NG020024 | 285.8249281 |
| 2021-04-01 | garri | NG020025 | 388.3307999 |
| 2021-04-01 | garri | NG020026 | 365.1686898 |
| 2021-04-01 | garri | NG020027 | 391.6867595 |
| 2021-04-01 | garri | NG021022 | 384.1850593 |
| 2021-04-01 | garri | NG021023 | 397.7172044 |
| 2021-04-01 | garri | NG020028 | 331.2182171 |
| 2021-04-01 | garri | NG021024 | 393.323333 |
| 2021-04-01 | garri | NG020029 | 405.5813127 |
| 2021-04-01 | garri | NG021025 | 359.658715 |
| 2021-04-01 | garri | NG021026 | 370.3166839 |
| 2021-04-01 | garri | NG021027 | 391.088788 |
| 2021-04-01 | garri | NG021028 | 364.2770249 |
| 2021-04-01 | garri | NG020030 | 375.2600611 |
| 2021-04-01 | garri | NG021029 | 358.9618615 |
| 2021-04-01 | garri | NG020031 | 439.1322423 |
| 2021-04-01 | garri | NG020032 | 402.7340519 |
| 2021-04-01 | garri | NG021030 | 345.2253201 |
| 2021-04-01 | garri | NG020033 | 356.2798309 |
| 2021-04-01 | garri | NG020034 | 369.3260162 |
| 2021-04-01 | garri | NG021031 | 368.6820545 |
| 2021-04-01 | garri | NG021032 | 342.8985896 |
| 2021-04-01 | garri | NG021033 | 388.3937476 |
| 2021-04-01 | garri | NG020035 | 369.5370586 |
| 2021-04-01 | garri | NG020036 | 374.2149029 |
| 2021-04-01 | garri | NG020037 | 374.3105323 |
| 2021-04-01 | garri | NG020038 | 419.9881972 |
| 2021-04-01 | garri | NG020039 | 356.6891081 |
| 2021-04-01 | garri | NG020040 | 385.9381759 |
| 2021-04-01 | garri | NG020041 | 308.1801669 |
| 2021-04-01 | garri | NG020042 | 383.1544687 |
| 2021-04-01 | garri | NG020043 | 381.4891835 |
| 2021-04-01 | garri | NG020044 | 362.6149694 |
| 2021-04-01 | garri | NG021034 | 351.0315915 |
| 2021-04-02 | garri | NG020001 | 347.5080909 |
| 2021-04-02 | garri | NG020002 | 417.7950263 |
| 2021-04-02 | garri | NG020003 | 357.6293544 |
| 2021-04-02 | garri | NG021001 | 364.0809209 |
| 2021-04-02 | garri | NG021002 | 350.5885553 |
| 2021-04-02 | garri | NG021003 | 412.9410955 |
| 2021-04-02 | garri | NG021004 | 326.3732426 |
| 2021-04-02 | garri | NG020004 | 374.9451842 |
| 2021-04-02 | garri | NG020005 | 335.0886535 |
| 2021-04-02 | garri | NG021005 | 365.002555 |
| 2021-04-02 | garri | NG020006 | 392.6334097 |
| 2021-04-02 | garri | NG021006 | 379.2592638 |
| 2021-04-02 | garri | NG020007 | 438.0161714 |
| 2021-04-02 | garri | NG020008 | 361.915949 |
| 2021-04-02 | garri | NG021007 | 357.060549 |
| 2021-04-02 | garri | NG021008 | 382.9647718 |
| 2021-04-02 | garri | NG021009 | 389.1019382 |
| 2021-04-02 | garri | NG021010 | 333.3285699 |
| 2021-04-02 | garri | NG020009 | 406.0860302 |
| 2021-04-02 | garri | NG020010 | 342.7835896 |
| 2021-04-02 | garri | NG020011 | 243.602651 |
| 2021-04-02 | garri | NG021011 | 358.4753587 |
| 2021-04-02 | garri | NG021012 | 333.9547987 |
| 2021-04-02 | garri | NG020012 | 424.8915992 |
| 2021-04-02 | garri | NG021013 | 407.2047254 |
| 2021-04-02 | garri | NG021014 | 356.6045034 |
| 2021-04-02 | garri | NG020013 | 358.297996 |
| 2021-04-02 | garri | NG020014 | 432.0024885 |
| 2021-04-02 | garri | NG020015 | 363.1590239 |
| 2021-04-02 | garri | NG020016 | 334.1112816 |
| 2021-04-02 | garri | NG020017 | 376.0309518 |
| 2021-04-02 | garri | NG020018 | 426.4144669 |
| 2021-04-02 | garri | NG020019 | 400.1660285 |
| 2021-04-02 | garri | NG021015 | 337.3337231 |
| 2021-04-02 | garri | NG021016 | 341.8770212 |
| 2021-04-02 | garri | NG020020 | 391.1870559 |
| 2021-04-02 | garri | NG021017 | 397.611482 |
| 2021-04-02 | garri | NG021018 | 345.1756482 |
| 2021-04-02 | garri | NG021019 | 346.5591129 |
| 2021-04-02 | garri | NG021020 | 347.5115345 |
| 2021-04-02 | garri | NG020021 | 435.024338 |
| 2021-04-02 | garri | NG020022 | 382.7996258 |
| 2021-04-02 | garri | NG021021 | 388.406993 |
| 2021-04-02 | garri | NG020023 | 417.0865963 |
| 2021-04-02 | garri | NG020024 | 293.7273414 |
| 2021-04-02 | garri | NG020025 | 408.075575 |
| 2021-04-02 | garri | NG020026 | 360.3596338 |
| 2021-04-02 | garri | NG020027 | 398.2523865 |
| 2021-04-02 | garri | NG021022 | 395.1357617 |
| 2021-04-02 | garri | NG021023 | 387.7742073 |
| 2021-04-02 | garri | NG020028 | 341.8796137 |
| 2021-04-02 | garri | NG021024 | 383.3824892 |
| 2021-04-02 | garri | NG020029 | 415.2975719 |
| 2021-04-02 | garri | NG021025 | 367.5180956 |
| 2021-04-02 | garri | NG021026 | 373.8995221 |
| 2021-04-02 | garri | NG021027 | 390.6734957 |
| 2021-04-02 | garri | NG021028 | 348.9460594 |
| 2021-04-02 | garri | NG020030 | 397.2809552 |
| 2021-04-02 | garri | NG021029 | 352.6791518 |
| 2021-04-02 | garri | NG020031 | 431.4367737 |
| 2021-04-02 | garri | NG020032 | 394.5424715 |
| 2021-04-02 | garri | NG021030 | 388.4691285 |
| 2021-04-02 | garri | NG020033 | 350.0768082 |
| 2021-04-02 | garri | NG020034 | 370.2760778 |
| 2021-04-02 | garri | NG021031 | 365.5463449 |
| 2021-04-02 | garri | NG021032 | 353.6569909 |
| 2021-04-02 | garri | NG021033 | 347.2475542 |
| 2021-04-02 | garri | NG020035 | 371.0247191 |
| 2021-04-02 | garri | NG020036 | 380.1494315 |
| 2021-04-02 | garri | NG020037 | 395.302709 |
| 2021-04-02 | garri | NG020038 | 433.3253765 |
| 2021-04-02 | garri | NG020039 | 350.8312732 |
| 2021-04-02 | garri | NG020040 | 382.1718306 |
| 2021-04-02 | garri | NG020041 | 316.6798756 |
| 2021-04-02 | garri | NG020042 | 409.7501652 |
| 2021-04-02 | garri | NG020043 | 385.8142597 |
| 2021-04-02 | garri | NG020044 | 379.9411943 |
| 2021-04-02 | garri | NG021034 | 345.6267946 |