title: Join two dataframes and overwrite matching rows [R]
body: <p>I've looked around and found a lot of similar questions, but nothing that answers my question, so here it goes.</p>
  
  <p>I want to join two dataframes in R by column (like in rbind) and have the second table overwrite matching values of the first column such that there are no repeats of values for the first column</p>
  
  <p>I want to do something like this:</p>
  
  <pre><code>a&lt;-data.frame(c("Foo", "Moo", "Boo"), c(1, 2, 3), stringsAsFactors=F)
  colnames(a)&lt;-c("Name", "Value")
  b&lt;-data.frame(c("Boo", "Bar", "Bat"), c(11, 12, 13), stringsAsFactors=F)
  colnames(b)&lt;-c("Name", "Value")
  
  rbind_and_overwrite(a, b)
  
  # Output
  #             Name         Value
  # 1           Foo          1
  # 2           Moo          2
  # 3           Boo          11
  # 4           Bar          12
  # 5           Bat          13
  </code></pre>
  
  <p>I'm sure I could do it with a bunch of messy for loops, but I was wondering if there was some fast and elegant way to do it because my tables are somewhat large.</p>