Merging two matrix when the number of lines is different

[Jilano]

Hello everyone ! Thank you for reading me

I have two data frame

Dataframe1 :

   €     |  £         

a| 1 | 4
b| 2 | 2
c| 1 | 1
d| 6 | 3
e| 4 | 1

And dataframe2 :

    ¥     |    ₩

a| 1 | 1
d| 4 | 2
e| 2 | 2

I want to merge the two data frame in order to have :

   €    |   £    |    ¥  |     ₩

a| 1 | 4 | 1 | 1
d| 6 | 3 | 4 | 2
e| 4 | 1 | 2 | 2

But i'm struggling with the fact that the number of lines are not the same between the two matrix

Do you have any idea of how to proceed ?
Thank you

[nirgrahamuk]

in R there are differences between data.frames and matrices.
I think you would be wise to make them data.frames, and to have the common key be in a proper column.
Then you can do a simple inner join to find matching rows

[Jilano]

Thank you for answering so fast !

Yes, my bad.
Wonderfull i didn't know about inner join.
I'll try that.