# Time series guided analysis

**URL:** <https://forum.knime.com/t/time-series-guided-analysis/25197>\
**Category:** KCH Workflows\
**Created:** [July 13, 2020, 6:29am UTC](https://forum.knime.com/t/time-series-guided-analysis/25197 "2020-07-13T06:29:49Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hub](https://forum-cdn.knime.com/user_avatar/forum.knime.com/hub/32/5438_2.png) [@Hub](https://forum.knime.com/u/Hub)\
**Post date:** [July 13, 2020, 6:29am UTC](https://forum.knime.com/t/time-series-guided-analysis/25197/1 "2020-07-13T06:29:49Z")

</div>

In this workflow we have taken grocery dataset for 10 stores contains data for 50 different items. This workflow can be deployed for a guided analytics webportal, i.e. easy to use dashborad for time series inspecction and forecasting. Steps: \* Data preparation: data loading, data exploration, data imputation \* Selecting parameters and filtering data: selcting particular store, item , setting parameters for weekly/monthly stats visualizations \* data visualizations: data inspection , weekly/monthly sales \* seasonality inspection: seasionality inspection, seasonality removing, lag preparation \* model training and evaluation: traing model on time series data, matics evaluation, line plot for performance

* * *
This is a companion discussion topic for the original entry at [https://kni.me/w/yHsmiyu2G9KIC3mu](https://kni.me/w/yHsmiyu2G9KIC3mu)

---

<div class="post-metadata">

**Author:** ![Loknica07](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/l/90db22/32.png) [@Loknica07](https://forum.knime.com/u/Loknica07)\
**Post date:** [May 9, 2022, 3:16pm UTC](https://forum.knime.com/t/time-series-guided-analysis/25197/3 "2022-05-09T15:16:05Z")

</div>

Hey, is there any similiar model, where the sales prediction with arima model is performed?

---

<div class="post-metadata">

**Author:** ![ebarr](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/e/919ad9/32.png) [@ebarr](https://forum.knime.com/u/ebarr)\
**Post date:** [December 18, 2024, 5:05am UTC](https://forum.knime.com/t/time-series-guided-analysis/25197/4 "2024-12-18T05:05:21Z")

</div>

i have downloaded the workflow and tried to run it, but am getting an error:

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/e/1/e1bfb798b123ecc01717a387039c5c4badac7e4f.png)

in the following nested components:

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/6/3/63e2b63a5f9baa5b390b4bafab7744e6a2d17430.png)

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/c/4/c4b327e17d1ba1b269d507e3e19126b98ea7147e.png)

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/0/8/08bc24836563f889ca3ce3a767b5fe737507ecac.png)

Is this a simple fix? It’s a linked node, so I can’t make any edits. Or is this a KNIME related issue vs. the workflow related issue?

---

<div class="post-metadata">

**Author:** ![steffen\_KNIME](https://forum-cdn.knime.com/user_avatar/forum.knime.com/steffen_knime/32/33719_2.png) [@steffen\_KNIME](https://forum.knime.com/u/steffen_KNIME)\
**Post date:** [December 18, 2024, 2:40pm UTC](https://forum.knime.com/t/time-series-guided-analysis/25197/5 "2024-12-18T14:40:28Z")

</div>

Hi @ebarr,

seems like `statsmodels` is not installed in the Python environment you use for this node.  
I suggest going to `Preferences -> KNIME -> Python (legacy)`, have a look at the name of conda environment set in the `Python 3 (Default)` section. Let’s say it is called `py3_knime_environment`. Now open a terminal, and enter according to [the documentation of the node, which can be accessed via the node description](https://docs.knime.com/2022-06/python_installation_guide/#python_pck):

```auto
conda install --name py3_knime_environment statsmodels

```

Replace `py3_knime_environment` with the actual name.

Does that help?

Best  
Steffen

---

<div class="post-metadata">

**Author:** ![ebarr](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/e/919ad9/32.png) [@ebarr](https://forum.knime.com/u/ebarr)\
**Post date:** [December 18, 2024, 5:07pm UTC](https://forum.knime.com/t/time-series-guided-analysis/25197/6 "2024-12-18T17:07:06Z")

</div>

> [@steffen\_KNIME](#):
>
> `conda install --name py3_knime_environment statsmodels`

THANK YOU!!!

I spent several hours in a circular loop trying to figure this out. Not sure what was different (ended up reinstalling 5.4), but now it’s successful. Much appreciated!

I don’t see a button for ‘solution’ - but this was the solution