I got 2 pandas dataframes like below. I want to merge them so I can find the ID's in the second dataframe who doesn't exist.
+----+---------+
| ID | Name |
+----+---------+
| 1 | Henk |
| 2 | Jon |
| 3 | Sjord |
| 4 | Bjorn |
| 5 | Margita |
| 6 | Marry |
| 7 | John |
| 8 | Sam |
| 9 | Hertog |
+----+---------+
+-----+-----------+
| ID | Feature_1 |
+-----+-----------+
| 1 | 1.1 |
| 1 | 2.2 |
| 2 | 4.4 |
| 2 | 100.10 |
| 4 | 0.1 |
| 4 | 13.2 |
| 7 | 18.2 |
| 82 | 19.21 |
| 100 | 992.21 |
+-----+-----------+
How can I search which ID in the second set doesn’t exist and place them in another dataframe like below?
+-----+-----------+
| ID | Feature_1 |
+-----+-----------+
| 82 | 19.21 |
| 100 | 992.21 |
+-----+-----------+