Excel merge cells, from 2 sheets using Python Pandas
<p>I have two Excel sheets, <code>sheet1</code>, and <code>sheet2</code>. Sheet1 has the <code>row id</code>, <code>First name</code>, <code>Last name</code>, <code>Description</code> columns, etc. Sheet2 has also a column that stores the <code>First name</code>, <code>Last name</code>, and also two other columns, <code>column D</code>, and <code>column E</code>, that need to be merged in the Description column.</p>

<p>The combination of <code>First name</code>, <code>Last name</code>, exists only once in both sheets. </p>

<p>How could I merge the contents of column D, E from sheet 2, in column named Description, in sheet 1, based on the matching criteria First name and Last name are equal in row from sheet 1, and from sheet 2, using Python Pandas? </p>

<p>Sheet 1:</p>

<pre><code>ID | columnB  | column C | Column D 
1  | John     | Hingins  | Somedescription
</code></pre>

<p>Sheet 2: </p>

<pre><code>ID | column Z | column X | Column Y     | Column W
1  | John     | Hingins  | description2 | Somemoredescription
</code></pre>

<p>Output:
Sheet 1:</p>

<pre><code>ID | columnB  | column C | Column D
1  | John     | Hingins  | description2-separator-Someotherdescription-separator-Somedescription
</code></pre>