For example to transform or join these 2 tables/files in 1 (with rows order=Id from file/table 1 for the new table joined) and the same heads of columns from the 2 tables:
File/table 1:
File/table 2:
Asked
Active
Viewed 38 times
0
Juan Manuel Luque
- 11
- 1
-
What is your question? What did you try that did not work? Errors or undesired results? Also, please avoid [screenshot of data/code](https://meta.stackoverflow.com/a/285557/1422451). See [How to make a great R reproducible example](https://stackoverflow.com/q/5963269/1422451) – Parfait Mar 14 '22 at 18:02
1 Answers
0
You only have screenshots of your data, but I'm guessing you want this?
DF1 <-read.csv("table1.csv")
DF2 <-read.csv("table2.csv")
combined <- merge(DF1, DF2, by="Id")
mikephel
- 30
- 6
-
1Yes mikephel, that's is what I was looking for. Very well your solution. – Juan Manuel Luque Mar 14 '22 at 20:30
-
Could you please click the checkmark underneath the score of that answer? It will help others find this answer in the future if they have the same question. – mikephel Mar 16 '22 at 18:17