title: How to concatenate values of repeating column value using pandas?
body: <p>I read a csv file:</p>
  <pre><code>df = pd.read_csv(path, sep='\t', 
      names=[&quot;id&quot;, &quot;beer&quot;, &quot;soda&quot;, &quot;water&quot;, &quot;name&quot;])
  </code></pre>
  <p>The file looks as follows:</p>
  <pre><code>01  0   1   0   John
  04  1   1   0   John
  51  0   1   1   John
  52  0   1   0   John
  87  0   0   0   Adam
  141 0   1   0   Lisa
  176 1   1   0   Lisa
  177 0   1   0   Lisa
  263 1   0   0   Jack
  269 0   1   1   Jack
  275 0   0   0   Jack
  281 0   1   0   Jack
  305 0   1   0   Thomas
  325 0   1   1   Jacob
  331 1   0   0   Jacob
  355 0   0   0   Jacob
  </code></pre>
  <p>I need to combine or concatenate the values by name, so they would look like this and write the result to the new file:</p>
  <pre><code>01  1   1   0   John
  87  0   0   0   Adam
  141 1   1   0   Lisa
  269 1   1   1   Jack
  305 0   1   0   Thomas
  305 1   1   1   Jacob
  </code></pre>
  <p>The id column is not important it can be whatever. I know how to write to the file, however, I can't find a way on how to concatenate values.
  Thanks.</p>