Hello, my problem with data preparation is:
Screenshot above is structure of my data. My point is to predict label column using Windowing operator based on inputs like: Date(for ex. 12.08.2018), and attibutes (from 1 to 10). My problem is that my attributes return no value during some days, but still giving output in label column. But here is the trick. I want to predict label column, but I can't because in Rapidminer to predict label column I need to have all inputs filled ( for example I can't predict label column for given day, without having for example att3 value or any other att number filled in row). Rapidminer operator "Replace missing values" is no solution because I can't make (min,max, average) of my previous data, its not suitable for my problem.
I would like to hear some advices, maybe some type of "aggregation?" of data, so that I don't need to use replace missing values operator?
Thanks in advance