How to compare Two Excel Sheets , not in a cell wise manner (Python Automation)
1)First thing is Store out the data from sheet1 and check for the data in sheet2
note :The data may be present at different columns or rows (not at particular orderer manner)
so the missing data need be imported with relevant row info and stored into a new excel sheet.
see I have the example like below
assume it as City: delhi bangalore mumbai–in excel sheet1
and in excel sheet2
City :Bangalore mumbai delhi pune chennai
see after comparing sheet1 and sheet2 (irrespective or row column places) and match the terms
so now the pune chennai are additional data and i need to store the particular data in new sheet as a Report
City: Pune chennai
I am trying by looping concepts and the code works fine but the only thing is its time complexity is more and by pandas and workbooks can anyone prefer me a efficient solution or approach if you have any idea.
I trying to implement it by pandas and dictionarys and i was net getting exact idea or the approach to to do ?
So if anyone has proper approach .lets have a discussion in the chat as it will benefit for both.
