title: pandas function to fill missing values from other dataframe based on matching column?
body: <p>So I have two dataframes: one where certain columns are filled in and one where others are filled in but some from the previous df are missing. Both share some common non-empty columns.</p>
  
  
  
  <pre><code>DF1:
  FirstName Uid JoinDate BirthDate
        Bob   1 20160628       NaN
    Charlie   3 20160627       NaN
  
  DF2:
  FirstName Uid JoinDate BirthDate
        Bob   1      NaN  19910524
      Alice   2      NaN  19950403
  
  Result:
  FirstName Uid JoinDate BirthDate
        Bob   1 20160628  19910524
      Alice   2      NaN  19950403
    Charlie   3 20160627       NaN
  </code></pre>
  
  <p>Assuming that these rows do not share index positions in their respective dataframes, is there a way that I can fill the missing values in DF1 with values from DF2 where the rows match on a certain column (in this example Uid)?</p>
  
  <p>Also, is there a way to create a new entry in DF1 from DF2 if there isn't a match on that column (e.g. Uid) without removing rows in DF1 that don't match any rows in DF2?</p>
  
  <p>EDIT: I updated the dataframes to add non-matching results in both dataframes that I need in the result df. I also updated my last question to reflect that.</p>