-
join the result of a depivot operation warning
Hello, I'm new to RapidMiner so bear with me :) I'm trying to do a rather simple process in which I use de-pivot (aka "melt") an example set and then use the result example set in a join operation. The de-pivot works exactly as I'd expected but the follow up join does not find the newly created column which I'd like to use…
-
add identifier attribute for joining datasets
data set A: a1,b1,c1a2,b2,c2 data set B:x1,y1,z1x2,y2,z2 right now I am manually adding a final row column of data after exporting; for which dataset the data came from ie: data set A: a1,b1,c1,setAa2,b2,c2,setA data set B:x1,y1,z1,setBx2,y2,z2,setB before joining them together, Im wondering if there is a way to do that…
-
(NEW USER) -- How to use the Join Operator?
I am working through the Tutorials section, specially the "Merging and Grouping" section. I'm at the "(3/6) Join the data" section. I can't seem to find the Join Operator that I want. I've tried using the available Join Operators (there are 6 of them), but none of them come with any parameters (by the looks of it), so I'm…
-
Different Join Result from Studio to Server
I'm working on joining two rather large datasets together. Due to their sizes, I will have to perform the join on the server. Testing in RMstudio with a fraction of the data from each dataset does what I expect, completing the join successfully. However, when I run the same process with the same test data on the server,…
-
Changing Data in Rapidminer
Hello everyone, I am currently working with rapidminer and I got a question for which i didnt find any helpful information yet. For preparing my data I have a huge Excel file which i uploaded in Rapidminer. Since I want to analyse the data I need some new rows which I would like to create in Rapidminer. For example I have…
-
Relational data indexed
I have three tables (for example) Sales table = Date, productID, qty, amount, customerIDCustomer table = CustomerID, First, Last, Phone, email, loyalty pointsProduct table = ProductID, origin, weight, lead time, price, aisle#, supplier, category How to connect these for analysis?
-
How to do multiple Twitter search and join them together?
Hi guys, I need to do multiple Twitter search and sentiment analysis to compare each query. For example, I want to compare the sentiment among the different candidates. I learned from the community that I can use Loop Examples to save me some time: My question: Is there an easy way to join the ExampleSets above? I can save…
-
How to join multiple excel sheets to combine them into one cluster (k-means) ?
Hey there, I'm trying to join (in this example 2 but the purpose is to join a huge number of excels) some excel sheets with the join operator to cluster similar documents from different datasets. My problem is, that the join operator overwrites the datasets which are identical in their structure to that the exampleset that…
-
Process failed: Label Array must not contain duplicates
I encountered this when both my data sets have no duplicates before join. what should i do?
-
Number of Attributes After Join Operation
Hi everyone, After joining two datasets the Join Operator removes double attributes. However, I am seeing the removed attributes on the metadata popup window when I hover on the output node. I also see removed attributes in the list of Select Attributes Operator. Is this a bug or an intended result? I wonder If somebody…
-
No examples after joining
Hi I am working on an assignment but I have a problem. There are 2 datasets, the first has some flight information and the second has weather information. I want to predict whether a flight will depart with a delay of 15 minutes or more (using a decision tree). I have done the following: - Import flight data -- select…
-
Specific case for Joining multiple datasets
Hi everyboday, In a data science project I have recieved 4 cleaned datasets on an intersting topic healthy diet to protects ourselselves against Covid-19. I have already imported these 4 data sets in Rapidminer Studio. before I analyse them with machine learning, modelling and statistical preditions I would like to join…
-
I cannot find join operator in Rapidminer studio 9.6
Dear All I used to use join operator to create an excel file of prediction models, but now the previous models don't run as it cannot find Join operator. Do you know the equivalent of this in the new version? Regards. Mansour
-
how to append/join two extract bank micro
how to append/join two extract micro e.g. extract macro names are qurery and query1 query=sachin,abhay,ravi query1=om,john,clara I want result query2=sachin,abhay,ravi,om,john,clara
-
Need help on grouping the records and compare against other groups
I have a dataset with 2 columns PSR,TASK_TYPE. Here PSR is unique numbers. But there are many task types which can be repeated. Now I have applied a group by using aggregate operator. Now I want compare the PSR's among the task types, I don't want same PSR to be in all the task types. I just need that PSR be only in task…
-
Matching stock return dates (Mo-Fr) with sentiment (daily) - join two datasets
Dear community, I am doing a sentiment analysis on stock returns on the example of a specific company. Now I am looking for the easiest way to match my sentiment measures with the firm-specific stock prices. As Xetra is only open Monday through Friday with exception of national holidays, I want to average my sentiment…
-
Date importing in different time zones
My team and I sit in different time zones. I created a data set on our server where the first row reads Mar 1, 2019. Because I provided no time, it sets my time as midnight. My time zone is in Texas, CST. If I copy and paste that value into a notepad it comes in as: Fri Mar 01 00:00:00 CST 2019 My teammate sits in…
-
How to Join two unrelated data in RapidMiner ???
How to Join two unrelated data in RapidMiner ???
-
join object from different collection
Dear all, i made a process whiwh split two documents (in fonction on his column), the results is 2 collections in which I have a number of object (this number = the number of column), now I want to join two objects, one from the first collection and the other one from the other, I really need your help to do this. Thank's…
-
no key attribute list shown for Join in tutorial process
I follow Tutorial on Merging and Grouping within Get Started.
Under 3/6 Join the data I have:
- retrieved Products and Transactions
- selected Join and connected it with two data tables
- under 4. selected Edit List (of attributes) but no List was shown
What am I doing wrong?
-
How can I after I've split my dataset join them together again in the same order as befo
Hi people, How can I after I've split my dataset join them together again in the same order as before? Below is an example, I just want the ID to go from 1 to 150 again in a chronological order. But just sorting the ID doesn't work. Also, how can I change the order of attributes in the results? Thanks -Prentice
-
Comparing 2 datasets
How do I compare 2 data sets and display whats different. The tables have the same data but differ in column Names. I have attached my process below. Please help.
-
How to join automatically
Hi, I want to analyse the content of files. One per line and the other one by column because data are group together in that way. For now I transpose the first one twice, i split the two documents in fonction on their number of column for the first one, and his number of lines for the second one. I have to write manually…
-
Can't select all attributes after a join. Only one side of the join.
I have had this problem recently. It seems that in some cases the meta data is not passed on correctly and I can't select attributes. Attached is a demo process that reproduces this at least for me on 9.2.
-
Downsampling of Data (From 1 hour each to 1 day[24hrs] each)
My data is divided into 3 months of 1 hour each, so there's roughly 2000 over examples. How can I merge the data into 1 day(24hrs) each instead? There should be about 90+ examples. I thought about using Generate Attribute, but I don't think that would work. Thank you! Regards, AY