title: Merge columns with same header no duplicate columns
body: <p>So I've tried looking into many articles explaining how merge or concat, join, etc. work for pandas in python, or just general r. Nothing seems to work the way I need when I test it out with my data. I'm going to post sample data with arbitrary numbers and headers that has the characteristics of my data and how I want it to look in the final product. I generally have tried using Genus as my common column because that column has the most common info and all other columns are information describing that column. These are text files.</p>
  
  <p>Dataframe 1:</p>
  
  <pre><code>Genus    Data    Facts    Info
  Dog    1    2    N/A
  Cat    3    1    N/A
  Elephant    N/A    3    3
  Pig    N/A    N/A    N/A
  Mouse    N/A    N/A    N/A
  </code></pre>
  
  <p>Dataframe 2:</p>
  
  <pre><code>Genus    Info    Stats
  Dog    2    3
  Cat    1    2
  Elephant    N/A    1
  Pig    N/A    N/A
  Mouse    N/A    N/A
  Bird    N/A    N/A
  </code></pre>
  
  <p>Desired Outcome:</p>
  
  <pre><code>Genus    Data    Facts    Info    Stats
  Dog    1    2    2    3
  Cat    3    1    1    2
  Elephant    N/A    3    3    1
  Pig    N/A    N/A    N/A    N/A
  Mouse    N/A    N/A    N/A    N/A
  Bird    N/A    N/A    N/A    N/A
  </code></pre>
  
  <p>Is there any way to create this outcome using either python or r? I'm kind of new to python and r and don't know /all/ of the ins and outs, so I may just be missing something or not searching with the right terminology, but I have been trying for about 3 weeks now reading what other people have done to similar situations and trying to bank off of them. I can't use Excel because it auto changes some number inputs into dates and does other small changes that if someone tried to redo it, they may not realize to fix those nuances. </p>