I have the following two data sets that looks like:
ID | X | Y | Z |
4 | 24 | 23 | 29 |
5 | 42 | 31 | 36 |
6 | 50 | 43 | 42 |
7 | 43 | 31 | 21 |
8 | 50 | 44 | 28 |
9 | 42 | 49 | 30 |
and
ID | W |
1 | 60 |
2 | 78 |
3 | 93 |
4 | 43 |
5 | 98 |
6 | 97 |
7 | 83 |
8 | 51 |
9 | 83 |
10 | 42 |
11 | 63 |
12 | 95 |
13 | 46 |
14 | 72 |
I want to merge these for only complete information. I.e. I want to keep all of the ID's for the first data set and create a new column W which comes from the second data set. My desired result looks like this:
ID | X | Y | Z | W |
4 | 24 | 23 | 29 | 43 |
5 | 42 | 31 | 36 | 98 |
6 | 50 | 43 | 42 | 97 |
7 | 43 | 31 | 21 | 83 |
8 | 50 | 44 | 28 | 51 |
9 | 42 | 49 | 30 | 83 |
How can I achieve this result?