Compare two excel files with different headers but same row data using Pandas DataFrames
<p>Here I am trying to compare two excel files. Server_report has 42 columns, Email_report has 19 (of which 5 columns have no match at all to the server_report). 14 of the columns match in each report but have different headers. When I have both files open I do a sort on three columns to line the data up 'Delivery', 'Picked quantity', 'Batch' (sort on server_report) and 'Delivery', 'Picked Quantity', 'Batch Picked' (sort on email_report).</p>

<p>What I need is to compare the email_report to the server_report after sorted to line up (each file has the same amount of rows and can be indexed on the 'Delivery' column). If there is "missing" information on the server_report it needs to be filled in by the information obtained from the email_report. </p>

<p>After that two new files need to be generated.</p>

<ol>
<li><p>a new server_report with all original 42 columns with the changes from the email_report.</p></li>
<li><p>a new file that contains any changes made during the comparison.</p></li>
</ol>

<p>My question here is the title of this post. How can one compare two files with different columns/headers (not of all that can map to one another)</p>