title: How can I use pandas to combine rows in DataFrame?
body: <p>I have a set of dataframes that I combined like this:</p>
  
  <pre><code>frames = [df1, df2, df3, df4, df5]
  result = pd.concat(frames)
  </code></pre>
  
  <p>This gives me an output that looks like this:</p>
  
  <pre><code>     name    time    thing   stuff 
   0   a       NaN     X       NaN 
   0   a       10:00   NaN     NaN
   0   a       NaN     NaN     blah
   1   b       11:00   NaN     NaN
   1   b       NaN     Y       NaN
   1   b       NaN     NaN     hi
  </code></pre>
  
  <p>I want to merge the rows so it looks like this:</p>
  
  <pre><code>    name   time   thing   stuff
   0   a      10:00  X      blah
   1   b      11:00  Y      hi
  </code></pre>
  
  <p>I've tried groupby but it doesn't seem to work:</p>
  
  <pre><code>In:     result = result.groupby('name')
          print result
  
  Out:      result = pd.concat(frames)
          &lt;pandas.core.groupby.groupby.DataFrameGroupBy object at 0x10cc2bd10&gt;
  </code></pre>
  
  <p>Anyone know how I can make this work? </p>
  
  <p>Thanks!</p>