Post History

Comparing two excel files with Python based on changes

I have two tables:

<b>Table1:</b>


| Name| Description | Amount| 
| --- | --- | --- | 
| 123 | Description123 | 123 |
| 456 | Description456 | 456|
| 789 | Description789  | 666|
| 101 | Description777  | 101 |
| 133 | Description133  | 133 |

<b>Table2:</b>

| Name| Description | Amount| 
| --- | --- | --- | 
| 456| Description456 | 456|
| 789 | Description789  | 789|
| 101 | Description101  | 101|
| 123 | Description123  | 123 |
| 102| Description102  | 102|

<br>

I need to find the difference in **Table1** compared it from **Table2**. The connection between these 2 excel files will be the column **Name**.
Expected output is if something is changed in **Table 2** the data must be used from **Table 2** and if there is new rows from **Table 2** they must be added to the final result. If nothing is also changed or **Table 2** doesn't have any data for specific **Name** from **Table 1** like **133** the rows also need to be added to the final result.
<br>
<br>
<b>Expected output:</b>

| Name| Description | Amount| 
| --- | --- | --- | 
| 123| Description123 | 123|
| 456| Description456  | 456|
| 789| Description789  | 789|
| 101| Description101  | 101|
| 102| Description102  | 102|
| 133| Description133  | 133|


Thanks in advance! <br>

Edit1: I struggle to find the solution. I understand how to compare each rows in the excel files, but they need to have exactly the same order in **Name** column. I don't know how to do it if there is no order like this specific case above.