-
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…
-
Read XML data with multiple child nodes and transform into examples
I have records in XML like the one below. Each record has one parent <Id></id> and unlimited number of child events. Each event has it's own <EventId></EventId>. All <Id> and <EventId> are unique. <Request> <hd_att1>false</hd_att1> <hd_att2>true</hd_att2> <detail> <info1>false</info1> <info2>false</info2> <Id>14901</Id>…
-
How to a use Auto Model for data that I have already split into train and test?
I am trying to solve an imbalanced binary classification problem using a model to predict the minority class (stroke victims). I used oversampling on the training data to make synthetic instances of stroke cases so that I could address the data imbalance issue. However, I kept the test data as its normal imbalanced…
-
filter test data and split it into sub sets
Hello, I am new to rapidminer. I would like to train a model using cross validation and test it later on subsets ( like female and male users and different regions subsets). I wonder how I can split the test set into subsets, which operators? and what to use for applying the model and getting it performance on those…
-
The split operator makes a new attribute, but I can't actually access or use it
I am trying to use the Split operator to split the values of an attribute (Departure_Time). This attribute stores time values in the format: hh:mmOf this time attribute, I need only the hours, not the minutes. So if the value is 21:55, I only need the 21. The data type of the attribute is polynominal.When I use the Split…
-
How to use Split
Hello, everyone! I'm a beginner and I have a problem in using Split to process data so that the effect is the same as that on the picture. Please help me solve the problem. Thank you~ :)
-
Split data operator error message
My screen shot displays the Split data error message: Non-numerical parameter value. The value of parameter 'partitions' must be numerical. Sometimes a parameter value must be of a certain type, which cannot be assured during the process setup (as usual). Please make sure that you set an appropriate parameter value. I…
-
How to create new Rows data based on split character values in Column data
I have data like as below Name Subject Grade John Eng,Math A,B Clarice Eng,Science O,B Kennedy Math O Kevin Eng A How do i generate new rows based on the column which has , on them Name Subject Grade John Eng A John Math B Clarice Eng O Clarice Science B Kennedy Math O Kevin Eng A
-
How to split and store splited data in macro
Hello, I have one Column "Parameter" that contains values below Parameter Financial Product=REMITTANCE|MESSAGEDIRECTION=I I want to store both in macro after split like %{Key} %{value} %{key_1} %{value_1}
-
Automatic sampling_type in Split Operator
Hello all, Just one quick question if anyone has any idea on this. For the Automatic sampling_type in Split Operator, it is said that it will use stratified sampling if the label is nominal, shuffled sampling otherwise. What if the label is polynominal? It will be used stratified sampling? Because I have imbalanced classes…
-
How to split macros values.
Hello, I have two macro %{key} and %{value} Product and Credit Card,Travel Card I want output Product = Credit card and Product = Travel Card
-
How to split column values
Hello, I have column 'type' and "Attribute" that contain values 1 ?
2 FINANCIAL PRODUCT=REMITTANCE;Travel Card;Foreign Exchange
3 FINANCIAL PRODUCT=REMITTANCE;Travel Card
4 FINANCIAL PRODUCT=REMITTANCE;Travel Card |MESSAGE DIRECTION=I
5 ?
6 ? how can split this column like FInancial Product MessageDirection…
-
How to reduce RMSE/SE when it's too high
Hi All, My data has 2 integers and all other polynomial attributes id state year month leads (int) responses (int) typeOfMail status I used split model where I split my data between 20 and 2 months for 22 months and I got 12.41 RSME and squared_error: 154.176 +/- 335.663. I don't know how to reduce this and also not sure…
-
Split Validation within Backward Elimination
Hello together, I am currently executing a Backward Elimination with contains a simple Naive Bayes by using Split Validation. But the subprocess is iterativeley working by switching between the milestones Naive Bayes --> Apply Model --> Performance and subsequently again starts with Naive Bayes (see attached). Is this…
-
hi How do I submit a document to Rapid Miner? Split this words?
hi How do I submit a document to Rapid Miner?Split this words?Remove stop words from it?And then calculate the weight of the words? Help me please Thanks
-
Get file name from csv/excel operator dynamically, split file name and pass it write db operator
Hi, i am very new to RM. I have to read file name from csv/excel file. Split the file name with _ delimiter and pass them to write database operator to store them in database. Could you please suggest me how we can implement this solution? Thanks, Radhakrishna
-
Split cell data into rows
Hello, Is there a way to split data in a cell to rows, instead columns? Example: What I really need now is the results one below the other, instead of columns.... Thank you!
-
Is it possible to get 100% for split validation accuracy ?
Is it possible to get 100% for split validation accuracy and what are the pros of getting 100% accuracy ?Thank you
-
Splitting time and date
Hi experts, I wanted to split the date and time and put them into the separate columns. My date format is like "Tue Oct 14 21:59:59 CDT 2014". Does anyone have any idea how can I do it?
-
how to split date
i have date and time attribute, i want to split the date into new column , how can i implement this operation thank you
-
is it usefull to retrain the selected modell on the full dataset after tested on split data?
i have a basic data-science theoretical question (apoligies if answered somewhere, i could not find it): after selecting a satisfying modell (using split datasets via k-fold cross-validation) is it usefull to retrain the modell on the full dataset before using it for prediction?
-
Cross Validation or Split Validation
Which operator is better to use, Cross validation or Split Validation , in Rapidminer?
-
How to split an attribute based on a condition on the split pattern ?
Hi, I'm extracting usernames of e-mails and I want to split these usernames according to the separator between the first name and the last name. (the separator is different for each username). For example here the initial dataset : Username john.doe John_Doe I want to obtain the following dataset : Username_1 Username_2…
-
How to adjust testing and training split ratio in automodel
Hello all, is there any way to adjust the split ratio of training and testing data in automodel feature instead of 60:40 which is preset but i have really less data and cannot give 40% for testing of my model.
-
Split preformatted text (of web page) on paragraphs
Hello, I crawled multiple pages with the "get Pages"-Operator (Webmining Extension). All of the text of the website is in a <pre>-HTML-tag. I want to cut the preformatted-text by the paragraphs. The "get Content"-Operator extracts the text perfectly, but destroys the formatting. Any solution? Thanks!