Python tutorial 94 -- merge two excel tables in Python and delete unnecessary data operation processes

development environment ：

Mac、python3.8

Case description ：
In everyday Excel Frequently encountered during operation , Two Excel Merge （ According to a certain condition ）. Delete unwanted data , Analysis and statistics with effective data .

materiel (2 individual excel surface )：

The code is as follows ：