title: Python Pandas - Converting columns in a df to their IDs stored in another df
body: <p>I have been trying to create a dataframe that contains the ID of a character and the ID of the characters mother(if they have one). The data I am using is of GoT characters and the raw df can be seen below.</p>
  <p><a href="https://i.stack.imgur.com/OoqoO.png" rel="nofollow noreferrer">dataframe1</a></p>
  <p>I have created a dataframe that stores all characters names and the name of their mother (if they have one) however im looking for the character's and mother's ID not their name.</p>
  <p><a href="https://i.stack.imgur.com/SbLxa.png" rel="nofollow noreferrer">dataframe2</a></p>
  <p>I have tried using a merge to solve this but so far have not been able to accomplish.</p>
  <p>Any advice would be much appreciated.</p>