Compete in RapidMiner's 3rd Competition: Fantasy Football. Top prize is $750. Deadline December 19.
Download RapidMiner Studio or Server 8.0 Public Beta. Let us know how you like it! Ends November 27.
Watch RapidMiner's "Getting Started" videos on YouTube. Everything you need to do data science - fast and simple!
currently I am facing a problem concerning the filtlering of times e.g. filter all times between 8:00 AM and 23:00 PM. I have the right format and everything, but RapidMiner just gives me an error when reaching the filter-operator.
"Instantiation error: Cannot instantiate 'custom filters': The filter value '8:00 AM' fpr the attribute 'Zeitgrid' is not in a valid format"
Thanks for your help
Solved! Go to Solution.
This is where your data formats need to be correct. Are you times in data-time or nominal format? If htey are actually date-time formats then you will be presented with a mini calendar to choose from. If nominal, then the standard "contains" or " "equals."
Okay, I managed to fix the error. It was due to the format somehow. RapidMiner wanted the time format as "hh:mm:ss a" whereas I filtered for "hh:mm a".
But now another problem occured. In a previous step I replaced a dot with a comma (1.34 ->1,34) because I have to further work with the data in excel. Now what happens is that RM thinks these numbers are Polynominal and when exporting them into an excel file they are declared as text. Is there an easy and fast way to transform them into numbers (maintaining the comma)?
Unfortunately not as I know right now. When I write Excel I usually do it raw and then format later inside Excel. You could check out the new Advanced Reporting Extension which uses an Excel Template and then RM writes to it. https://oldworldcomputing.com/blog/2017/03/advanced-reporting-extension-published