🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Add missing months and examples with zeros or values in a Time Series

User: "P_Seb"
New Altair Community Member
Updated by Jocelyn
Hello,

I would like to add missing examples in my time series for example with zeros. My Analysis is on sales data with montly example sets. Some of the materiales are not sold every month and so these months are missing in my data set up. In the following example I would like to add October and January with "0" for attr_3 and attr_2 and another Value for attr_1.


I have already tried "Replace Missing Values" (For Series and normal), "Impute Missing Values", with subprocesses in "Loop Values" and "Generate Values" but did not find a solution. So I hope you could help me.

I am using RapidMiner 9.7.

This is a part of my process - the picture above is generated after "Remove Duplicates":


Thank you in advance.

Best Regards

Find more posts tagged with

Sort by:
1 - 1 of 11