-
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.
-
Extracting a number from a string under specific conditions
Hi, I'm struggling on doing something that looks easy (and maybe dumb), but I don't find a way. I need to extract a number from a string that matches specific conditions. I have a column with different strings like: John Alpha U23 Mike Beta C57 Ann Cole U73456 Amy Utta J94857 I want RM to create a new colum that picks only…
-
Converting Dates for Use in Model to Predict Oil & Gas Drill Timing?
Hi There! I recently completed MIT's "No-Code AI & Machine Learning" certificate where we used RapidMiner on some more simple models. I'm now trying to put what I've learned into use in my business. I am trying to use certain "key drilling indicators" to predict when a drilling rig will show up on a given tract of land.…
-
ARIMA - impossible to work with generated forecast from Arima
dear Community, I did a revenue forecast using the Arima model, before this and to have stationary data, I use the operator logarithm, I obtained the forecast from Arima operator followed by "apply forecast", my next step was to generate an attribute using the function "exp" (exponentiel) however I cannot see the select…
-
How to add the coding of expression
Hello everyone, Im looking for the top 5 ranked highest revenue. In order to to add an attributes, how to type the coding of expression according to the top 5 ranked highest revenue in the generate attribute operator
-
Compare 2 different attributes
Hi, I want to compare one column with all other columns. No column have same number of rows. 1 column may have 5, another10, another 12, 6,4,9... so on.. i want to create new columns after comparison Ex: N | A | B | C 1 3 7 6 3 1 4 2 6 2 1 7 8 4 --------------------------- new columns are: A1 | B1 | C1 3 7 6 1 4 1
-
Reuse the result from loop
Hi i am trying this <?xml version="1.0" encoding="UTF-8"?><process version="9.9.002"> <context> <input/> <output/> <macros/> </context> <operator activated="true" class="process" compatibility="9.9.002" expanded="true" name="Process"> <parameter key="logverbosity" value="init"/> <parameter key="random_seed" value="2001"/>…
-
Create dictionary
Hi, I want to create a dictionary like this in rapidminer {Fruits:["Apple","Banana","Orange"]} can anyone help me how to create it
-
Get the index of every word start index and end index in a sentence
Hi, i am trying to generate 2 new columns that gives start and end index of every word in a sentence and there is only 1 sentence. Ex: This is an apple | | | | | | index: 0 3 5 8 11 15 Word | Start | End This | 0 | 3 is | 5 | 6 an | 8 | 9 apple | 11 | 15 Can anyone please help me here.
-
Can anyone help me code/change age(days) format to real age in generate attribute? Here my rmp file
I do not know how to use function expressions and change the age in days format here to real age. A little help on the functions will be really helpful thank you.
-
Use pdf file name as attribute
Hello everyone :smile: I want to do some simple Text Mining using pdf files in RM but I'm a little stuck right now. I created a process using the loop files and process document operator for reading in several pdf files. As I have a lot of files to analyze, which I also want to compare, I would like to create an attribute…
-
ERROR al hacer PIVOT de tabla y luego agregar campos calculados
Por favor, alguien sabe si es una limitación de Rapidminer o estoy haciendo algo mal? Tengo una tabla, hice pivot para dejar en las columnas los años y a partir de ahí quiero calcular la diferencia entre una columna y otra pero Rapidminer no reconoce esos campos como válidos para hacer los cálculos. Adjunto pantallas Tabla…
-
Generate attribute: Column name* macro
I am trying to do this A B C D 2 1 1 4 3 2 4 1 ' using generate attribute i want to multiply each column with macro but i am getting error ( '*' must have a argument of type numerical). A* macro like that i have given function.
-
Divide a column values with a column in another table.
I have a Table with these columns A B C D 2 3 4 3 4 6 8 6 6 9 2 3 8 3 6 9 I have another table with same column names A B C D 2 3 2 3 I want to get the result A B C D 1 1 2 1 2 2 4 2 3 3 1 1 4 1 3 3 can anyone suggest what should i do here
-
Calculating sum of square for each column
This is what I want to implement in my columns. A B C D I 5 1 3 1 J 6 3 2 7 K 6 0 1 7 L 4 2 5 1 I want to implement this formula for each column I have created a loop attribute, and inside generate attribute. But dont know about the formula for . Can somebody tell me how to do that? New to this rapidminer. Thanks in…
-
Aggregate / Generate Attribute - merge and sum up multiple example rows
Dear Ladies and Gentlemen, I would like to sum up my Data row values per date for each item, in order to have only one row per date with the total quantity data ("Menge kg") for the individual item. Varying prices ("Preisherkunft") exist, which has resulted in multiple entries for the same item ("Artikel-Nr",…
-
Add leading zeros if length = 4
I have a dataset something like this: I want to add leading 0 if the length of data in column_1 is 4 and return in a new column. So that all data in the new column will be the length of 5. Expected output: Thank you.
-
Generate Attributes
I want to create an attributes to show whether the member base is fully active or not. Is it possible to make it like if the figure of 'member base' attributes equal to figure of 'active member' attributes then, the new attributes will show as 'full active membership' otherwise 'not full active membership' ? Thanks for any…
-
Where this number came from ?
I'm using operator "Optimize by Generation (Evolutionary Aggregation) with Decision Tree. Compared with only Decision Tree, this operator only using 2 atributes and 1 generated atribute, i want to know how this atribute get the number from other 2 atributes This is before using Optimize by Generation (Evolutionary…
-
auxiliary attribute
Hey community, i got a question with which you may help me, its more regarding "literature". I am currently working on a ML project. For the data analysis I take "auxiliary attribute" (that's how i call them), for getting information regarding the data quality. Taken the example for a databases with: "date_1"; "date_2";…
-
How To Use Generate Attribute
Hi， I have trouble in using generate attribute. Score one attribute to get another attribute. There are four kinds of scores in total. thank you~
-
Generate binominal attribute based on comparison of two values
Hello, I'm quite new to RapidMiner, but I have an assignment from school. I want to generate a new attribute (Difference in estimated revenue), based on a comparison of two REALs in two different attributes. If the two values are the same, the generated attribute value should be set to "true". If otherwise, the value…
-
Send out mails to different individuals with separate info.
Number City Arrival Airport Name Email 234 New York 2:39 PM JFK Alex alex@email.com 221 Alabama 7:21 AM ALB John john@email.com 122 Maine 7:07 PM LGA Chris chris@email.com I have a dataset like this, I want to use the email of the dataset to send out mails to each individual with their information. I have used the Send…
-
Only search for a specific keyword from a text
Hello, I want to search for a specific keyword from a text and assign them by their type. I am using the Generate Attributes operator and writing a function to search for the keywords. I have this problem, I have words like, "liar", "lies", "lied" in the list. The function expression that I am using picks up words like…
-
Referring to other attributes and data rows when generating new attributes
Hi guys, I am a newbie in RapidMiner and am trying to do Time Series Analysis combined with sensex. I have forecasted values with Arima model and I would like to compare forecasted value in row x with real value in row x-1. I tried using Generate attributes operator but I am unsure on how to reffer to different attributes…