python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - forecasting

How to check if date in Table 1 fits between 2 dates in Table 2, and merge tables if ID value also matches?

I have two SQL tables. Table1 ItemNum,Date,Sales qty Table2 ItemNum,StartDate,EndDate, promotionValue. I want to check if the Date in table 1 falls under Start and End dates in table 2, and if th...
test-img

Coder212_97

mysql

dataframe

time-series

forecasting

Votes: 0

Answers: 1

Latest Answer

Try this: SELECT t1.*, t2.* FROM table1 t1 JOIN table2 t2 ON t1.ItemNum = t2 WHERE t1.Date >= t2.StartDate AND t1.Date <= t2.EndDate;
test-img

Ibrahim Hammed

SARIMAX: Calculating the Seasional_order(P, D Q, M) values

Is there a function or library (like auto_arima to get the order(p,d,q) values) available to calculate the P, D, Q and M values to be used in Seasional_order(P,D,Q,M) in SARIMAX model. Thanks,
test-img

SM079

time-series

forecasting

arima

pmdarima

sarimax

Votes: 0

Answers: 1

Latest Answer

The auto_arima function can do that. You can set the parameter seasonal = True and give the length of the season with the parameter m: auto_arima(y=your_data, seasonal=True, m=length) If you want to o...
test-img

Arne Decker

How to make a loop for out-of-sample forecast

I am beginner to R and was hoping to have ideas for making a loop. I would like to automate the following for each observation out of 726 observation making a 5 ahead out-of-sample forecast based on a...
test-img

Olivier Lemire

r

loops

forecasting

Votes: 0

Answers: 1

Latest Answer

My understanding is the following: you first run the loop on each of the five sets of observations, with an IF statement for when you reach the final iteration which goes into the pred column instead...
test-img

Harrison Jones

TypeError: __init__() got an unexpected keyword argument &#39;model_list&#39;

Getting the error like TypeError: init() got an unexpected keyword argument 'model_list' When I am running following script: from autots import AutoTS model_list = ['LastValueNaive','GLS','ETS','Aver...
test-img

bhagya laxmi sanapala

python

forecasting

Votes: 0

Answers: 1

Latest Answer

Try without making strings in model_list like so: model_list = [LastValueNaive,GLS,ETS,AverageValueNaive] This approach worked for me when using neuralforecast, mlforecast from Nixtla. Maybe it works...
test-img

DariusM11

Posts

Questions

Blogs

Jobs