-
Generate Attribute Quarter from Date
Trying to create attribute to have Quarter from a date attribute. Getting Month number using "date_get([Date Inserted],DATE_UNIT_MONTH,"GMT")+1" but not able to convert or calculate Quarter. Thank you.
-
Data to JSON , Date conversion?
I want to read data from a MongoDB collection using RapidMiner Studio and will be giving a criteria (a json format) to the Read Mongo DB operator. To do this, I need a datapoint stored in a dataset and converted it to table format using Data to JSON operator. Given that I have a field called 'Date' in ISO date format, when…
-
INSERTAR FILAS NUEVAS PARA QUE ME RELLENE LOS DIAS FALTANTES
HOLA A TOD@S, SOY NUEVO EN ESTO Y CON RAPIDMINER, TENGO UNA HOJA CON VENTAS DIARIAS Y COMO ES LOGICO NO HE VENDIDO TODOS LOS DIAS, ASI QUE NECESITARIA INCLUIR FILAS NUEVAS CON LOS DIAS QUE NO ESTAN ENTRE LOS DIAS QUE SI TENGO, COMO SE PUEDE HACER ESTO ??????
-
Converting Numerical Date back to Date Format
Hello community! Sorry for bothering with my Newbie-Question! My problem:I have missing values for a certain date attribute -Date1- that I want to fill up. It's actually quite easy, because I have two other attributes that will help me calculate the missing values. So there's a numeric attribute like -DaysUntil- and the…
-
I have a seperate field for Year and another field for Month. How can I combine them together
I have a seperate field for Year and another field for Month. How can I combine them together and sort by the new date/month field
-
How to pass Date column to RM
Hi, I'm trying to get a simple Execute Python script to read data from a website and pass it to RM. The data is daily volumes and has a Date column. It is a python pandas' DataFrame. It works, but RM ignores da Date column. A printout from the script and the result in RM are: What am missing in the script? Thanks.
-
Macro using dates for SQL
Hi: I'm trying to use a macro with date in an SQL statement but I'm getting an error from the SQL side. Here is part of the SQL statement: Declare @fDate date, @tdate date , @processingdate date, @lag int =%{lag}SET @fDate =%{themonth} error message is "Operand type clash: int is incompatible with date." How do I resolve…
-
Right import format for columns
Hi, I’m trying to import StudyHour Data inside Rapidminer,
which shows the number of hours someone studied a day. The issue is that it converts into time as what time it is (pm/am) but I’m trying to get hours as the amount of time passed while studying. Not
the actual time. I used the type “hh:mm” in excel as you can see…
-
Getting parts of a date
Hello together. I got a question. When I want to create a new attribute I have the following problem.I have a date which is in forma contaning month, day, year, time.However I just want to extract the Month and the year so that the format is YYYY:MM I found in the internet only the date_get(Att1,DATE_UNIT_MONTH) Operator.…
-
Wrong datetime after Write in Database
Hi everyone, I have process which retrieves data from a database, does some feature engineering and then store the result in another database. One of the attributes is a datetime (CET timezone) and I would expect that the destination datetime is equivalent to the source. When I run the process locally, the process works as…
-
How to replace a time value
Hi dears I've struggled to change a certain of time value for almost one day, which is turning the "12:00:00 AM" into "12:00:00 PM", I 've used "Date to nominal" to deal with it, but after doing so the time value would be changed, so I gave up this method. Now I am trying to use "Generate Macro", but I have no idea how to…
-
How do I calculate the time difference between many values?
Hello everybody,I want to calculate the production time of a machine per order (idOrder). There are a total of 53 orders.In this example, I have to subtract the time of line number 408 from 399, since the machine was active at that time. Can you tell me how I calculate the production time? Best regards and thank you very…
-
Convert polynomial to date format
I am having a column which contains date in the following format: Apr 1, 2021, 5:30:00 AM GMT+5:30 The datatype of the column is polynomial, I want to convert it into date-time format using the nominal to date operator but is getting the error that "cannot parse date: unparseable date". Please help
-
Dates/Times retrieved from DB gets convert to time zone in settings- How can I prevent this
I just realized that the dates retrieved from a database using the 'Read Database' operator gets converted to what ever the time zone setting is in the preferences. I do not want this to happen. I want RM to use return the date/time exactly as it is in the database. How can I do this?
-
Example Set Transpose to Attribute Names
Hi All, Hoping I'm missing the simple answer here but I'm trying to transpose an aggregated set of data (Sales Months) to be Attribute Names (trying to make this dynamic as the number of months varies from data set to data set). below is a screenshot of current view. I attempted to "Rename by Example Set" but ended up with…
-
adding solar calender
hi guys.i want to know how can i use solar calender(hijri shamsi)?
-
Date Month Names - numbers to titles.
Hi All - Is there an easy way to convert Date Month Number (0,1,2,etc) into month names (Jan, Feb,etc) other than the below general if statement? if(eval(%{Data_Month})==0,"January", if(eval(%{Data_Month})==1,"February", if(eval(%{Data_Month})==2,"March", if(eval(%{Data_Month})==3,"April", if(eval(%{Data_Month})==4,"May",…
-
as excel format :short date and accounting
Hi dears could you please show me how to change date as MM/DD/YYYY or as shown in the attached file? and columns b,c,d and e as accounting? I wonder how to change them in RM. Thanks
-
Date Conversion
Hi All, How to Convert The Numeric Attribute <DTYYYYMMDD> to Normal Date? (Image 1) Because When i use Numerical to Date Attribute ,All Date convert and back to 1970!!
-
Change unix time stamp on loop
Hi - i have spent a lot of time searching the forum, but cant work it out. Wondering if anyone can help me please. I am trying to loop using a macro and changing a value that is inserted in to the URL (a different UNIX timestamp) on each iteration,. I want to do this in order to loop sucessive calls to the API to get more…
-
Why does a correctly formatted Excel date import as a long row of nominal numbers?
Hi there, Wondering why my correctly formatted (short date) in Excel (dd/mm/yyyy) imports as a long row of nominal numbers when using xlsx? I've seen a huge amount of coverage on this but nothing that addresses the reason why a string of (meaningless to me!) nominal numbers would somehow be easier to interpret?…
-
How to get the time format without the date
Hi, could you help me change the Data time format? I have a dataset with "time" in polynomial form (00:00:00), I need to turn it into time.I used generate attributes, but got the format "Jan 1 1970 12:00:00 AM CET" Is there a way to have the Time format "HH: mm: ss"? here is the xlm: <?xml version="1.0"…
-
calculate Date_Diff between same value in one Column
Hello everyone, I am working with MySQL Database and Rapidminer. I already connected Rapidminer Software with MySQL Database and i get this kind of Table(as you see in photo). Now i would like to calculate Date Time difference between Eingang(Column) and Ausgang(Column). For example For value 4B6B831A (in Column wert-1), i…
-
How to transform daily time series to monthly data and keeping the years ?
These are the dataset statistics. As you can see it runs over several years (from jan 2015 till may 2020) Here is a sample of how my data looks like before transformation. How can I transform my dataset to something like this ? Sum of Sales per month per year. I already tried the following: - convert date to numerical…
-
How can I change the actual day or create a new date for the database?
Hi, I have an issue with my performance. I have to do a classification to predict which donors will donate. How can we add/create a new date to say for example that the date of today is 2016-12-31. I want to do this to be able to use the 'date_diff ' and compute how many days have passed since the last donation and this…