-
Collaborative Filtering Item Recommendation how can I create output "item_id" with title name
hi I use Rapidminner for Collaborative Filtering Item Recommendation with user k-nn and the result at "item_id" is number like this so how can I replace Movie Name (title) instead of item_id. I try to use set role operator and set additional roles : attribute 'title' with 'item identification' but output is the same. the…
-
Revert Tokenized words back to sentences
Hello, I would like to ask. How do I change my tokenized words attribute back into my own text attribute in Excel file? I was doing tokenized words for correcting many mistakes in my text by using Stem (Dictionary) and many other operators within Process Documents from Data. The thing is that I can't find any operator that…
-
Remove leading zero, space and dash in existing column and return the output in new column
I have a dataset something like this: I want to remove leading zero, space, and dash in column_1 and return the new data in a new column. Expected output: Thank you.
-
\n command doesn't work in Replace Token Operator
Hi, I'm trying to read pdf-files in RapidMiner through the "Read Document" operator and then use the "Replace Token Operator" to delete all line-breaks. I replace "\n" with " ", but when I then copy the text, all line breaks are still in place. Weirdly, when I use the "Create Document" operator and manually copy the text…
-
Delete hyphens after reading pdf-files
Hi there, I'm very new to RapidMiner. I'm reading german pdf-files and tokenizing them, which is working fine... However, the pdf-files contain hyphens that seperate a fair amount of words in to two parts, like the following example: "die Bedeutung der finan- ziellen Interessen der Union" I'm trying to dehyphenate the…
-
Problems with processing the answer from a GET request
Hi guys,I want to mine performance data of footballers for an essay. As a source I found Goaloo1 (I cant post links yet). The problem is that they don't provide the information in a file, so I want to use the Web Mining Extension instead. I managed to identify the GET request URL that provides all the data for a given…
-
How to replace one value as another value?
Hey there, I want to change the "Together,Married, etc." values into "inRelationship" and "Single,Divorced, etc." into "Single". I'm not sure how to do it. Do I have the use the Map operator? Thanks in advance!
-
Replace (Dictionary) operator has problem
hi.i want to replace some codes whit cities name's.but i have a problem.for example imagine this:1----> A2----> B12----> Cbut when i run my process instead of replacing "12" whit "C", it replaces "12" whit "AB"I would appreciate it if help me.
-
how to exclude words from returns of a regex in a replace with dictionary operator
hi everybody, after many hours on internet, I must acknowledge I can't find any solution in order to exclude words from results a REGEX. I use regular expressions in a spreadsheet connecte to a "replace with dictionary" operator. Some REGEX capture too many words. one example: - the…
-
Replacing whole words with dictionnary
Hi Rapid miner community,I don't find the solution to replace whole words after a "read excel" operator. If I use a "Replace (dictionary)" operator linked with an excel file, words are partially substituted - as they are not tokenized - and sometimes part of the word is substituted and aggregated with the rest of the word.…
-
replace "\" character in cells
Hi there, I'd like to replace in a excel column the "\" character with the ">" one but the process fails, as "\" correspond to a character used in regular expressions... Of course I can replace it in excel before importing data, but I'd rather prefer to do it in a rapidminer process. thanks a lot for your help
-
Possibility to capitalize first letter in each word
Hello all, I'd like to capitalize each word in an example set. Source (all lower case): Result (first letter ist upper case): I tried different approaches with RegEx but I couldn't achieve my goal. Maybe you can help me out? :) Kind regards, Patrick
-
Substitute Search result in RegEx with new line doesn't work
Hello support team, I might found a bug in the RegEx implementation of Rapidminer. My goal is to replace a "blank" with a "new line" character. Searching in following Text: Sri Lanka Using the Replace operator: Search for ( ) Replace with: \n leads to: SrinLanka I created a workaround using the "split" operator which you…
-
Replace Old Multiple Column Names with New Column Names
I have an example set with many attributes. I want ot replace these attributes with new names which would be there in an example set. How can we do that it in rapidminer. Example: Old_Column_Name New_Column_Name a apple b ball c cat
-
Replace values by conditional match
Hi all, I searched the community and couldn't find the answer. Maybe it was solved before but I need it urgently. So appreciate if you answer again. I am working on a very messy dataset. As you look above, models L200, L 200, MITSUBISHI L200 etc. (I mean all of them) are the same model of a brand. I would like to replace…
-
Differentiating data per attribute
Hello all, I have the following data att1 att2 att3 1 8 9 9 2 9 10 8 So, attribute 1 can assume values 8 or 9, attribute 2 values 9 and 10, and attribute 3 values 8 and 9. Thing is, all those nines do not represent the same thing. How can I change those values in order to avoid conflict? If I change all the nines at the…
-
How to remove characters from end of string using regular expression within Replace operator?
Hi, I'm trying to remove certain characters from the end of string in a text field using Replace operator, for example, Current value: abcd(xxx) Desired value: abcd In the replace operator, I use the following regular expression to locate strings end with (xxx), but what should I put in as Replacement? (.*)(?:abc)(.*)…
-
Does the map operator work also for the label field?
I am trying to replace the numerical key values of the label field with their real name values, just before publishing to a web app. But I'm getting the following error. "Failed to run process '/apps/xxxxxx/process/initialization' on click. Operator 'Execute task_xxxxxx' reports: The 'Map' operator in the process executed…
-
Why does the Replace operator accepts only nominal values?
The general concept of what I am trying to do is that I have trained a model and now I want to apply it on a single example. My original dataset has too many attributes, so I thought, in order not to write all those values by hand, to just Store a part of it during training and then Retrieve and Filter by range 1-1 to get…
-
Replace (dictionary)
I have a data set that has 30+ attributes. Each data row has numerical codes in each column that correlate to a classification. For example; Gender is an attribute with codes 1-3 meaning Male, Female, and not provided, respectively. There are similar code structures for ethnicity, race, etc. I have set up a dictionary for…
-
How to replace missing values with the last given Value
Hello,i have a Database with the following scheme: +-----------+----------------+ | Field | Type | +-----------+----------------+ | object | varchar(50) | | attribute | int(11) | | value | float | | date | datetime | +-----------+----------------+ Object = manufacturing plantattribute = Sensor name Value = sensor valuedate…
-
How do I restore a previous version of a process?
Hello, I am using rapidminer Studio 9-3-001 on an OSX platform. I am needing to restore a previously saved version of a process. I am trying to restore my process back to my original file from July 23, 2019, as I saved over a version I really need. Is there any way to restore the July 30th file back to the previously saved…
-
Replace(Dictionary) is changing two attributes with similar values. How do I stop this?
Hello! I am using the Replace(Dictionary) operator to have two attributes get their values changed into the same thing when they are not the same thing. For instance, I have a value that is A12 and I want it to be changed into "Less than 500DM" then I have another value that is A121 and I need that to say "No Property".…
-
Replace Nominal Values of Dataset with mode
Hi There, Please lemme know "How to change nominal attributes(S) missing values in the dataset with mode"????
-
"While exporting to Excel i need to replace
I need to have blanks data while exporting to Excel but it is exported with "?" symbols , Please help me to show only blanks instead of Question mark symbol..