Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
Combine two files
[Deleted User]
Posts: 0 Newbie
in Help
hi
Is it possible to combine two data(train+test) and make a new data which the train part has label and the test with out label?
thank you
Is it possible to combine two data(train+test) and make a new data which the train part has label and the test with out label?
thank you
Tagged:
1
Best Answers
-
varunm1 Member Posts: 1,207 UnicornHello @mbs
If the dataset has the same attribute names, you can use the append operator to append two datasets. If the test or train datasets have extra columns compared to each other, then you can use append (superset). Regarding testing data, do you have labels for testing data? If you do not have labels, you can use filter examples to separate testing data and use it for prediction.
If you have labels for testing data, my suggestion is to use "generate attribute" to add a new attribute (with the same name) in both training and testing sets, this new attribute can have a value "Tra" for training and "Tes" for testing. This way, we can filter them after appending using this new column.Regards,
Varun
https://www.varunmandalapu.com/Be Safe. Follow precautions and Maintain Social Distancing
1 -
varunm1 Member Posts: 1,207 UnicornYou informed me that you already created a single file (manually) with data consisting of unlabeled and labeled samples, Am I right? If you did this, just import that new file and use filter examples as I said earlier. If you still have a problem with attribute names, delete that row and try to create new attribute names.Regards,
Varun
https://www.varunmandalapu.com/Be Safe. Follow precautions and Maintain Social Distancing
0
Answers
thank you for the answer but it is a bit complex so could you please send me an example ( process)?
you saw my data before
thank you
Here is the dummy data created and the .rmp file that you can import to rapidminer and see. The append (superset) operator is in the opertor toolbox that you need to install from the marketplace.
Varun
https://www.varunmandalapu.com/
Be Safe. Follow precautions and Maintain Social Distancing
it has read excel operator and again i got error
thanks
Varun
https://www.varunmandalapu.com/
Be Safe. Follow precautions and Maintain Social Distancing
does it has any label?
label is important for my work
Varun
https://www.varunmandalapu.com/
Be Safe. Follow precautions and Maintain Social Distancing
hi
still i see error
the name of some empty column in my data is error
Varun
https://www.varunmandalapu.com/
Be Safe. Follow precautions and Maintain Social Distancing
i dont have any space in data.
i try it in my friend lap top (RM version 9.2) but still it has problem
Varun
https://www.varunmandalapu.com/
Be Safe. Follow precautions and Maintain Social Distancing
Also, try creating dummy names for the column name and see how it works.
Varun
https://www.varunmandalapu.com/
Be Safe. Follow precautions and Maintain Social Distancing
thank you for your help
i did this file manually and copy it to other excel and fix it but now half of my data has label and the other part doesnt have label . so in this situation what is your suggestion?
regards
mbs
Varun
https://www.varunmandalapu.com/
Be Safe. Follow precautions and Maintain Social Distancing
now is there any other way for that?
thank you
Finally it works
thank you very much @varunm1