Integrate data and insert new columns

elena2020chao

Hello. I searched the forum but did not get it. I have two Excel files with the same number and number of columns. That row information is different. I want to merge them together and have a file. But I do not know how to do it? And I want to tag them after completing data clustering. Create a new column and put "yes or no" in that column. But do not know how For example, I want to say that the cluster has a "Yes" labels and the cluster has two "No" labels. Can anyone help me? Thank you so much for the help of my friends

lionelderkrikor

Hi @elena2020chao,

 

Can you share your dataset(s) in order we can better understand.

Moreover can you, from your initial dataset(s), give an example of what you want to obtain ?

 

Regards,

 

Lionel