Suppose i have an Excel file with two sheets one containing the values
LENDER_NAME STATE_CODE
1st Business Bank CA
Allied Bank of Texas Dallas TX
and another file containing the values
SLNO NAME STATE
1 1st Business BK CA
2 Allied BK of Texas TX
3 Allied Texas Bank TX
i need to compare with name and code , and merge the values of two sheets and write into one file. (Full code with description is needed as i'm a fresher in Python coding) Thanks in advance