+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Vlookup function in Pyhton (/thread-40791.html)
Vlookup function in Pyhton - antozas - Sep-24-2023
Hello Everyone,
I am user of excel and vey new to Python. My work involve with data comparison - bank statement and supplier statements sometimes data involves 5000 rows and to get this sorted and transform it takes a lot of my time.
I have to use lookup formula in excel. I saw some videos wherein Python Code can do that work for me and within few seconds transform data gets generated.
Could you please suggest some tutorials on this subject/books I can read.
Best wishes,
Antozas
RE: Vlookup function in Pyhton - vikraman - Oct-02-2023
you could use python for the same.... its pritty good one
but volume of 5000 we can handle in excel it self - try to use pivot table
problem with vlookup is - it will retrieve the first found information - it will not check if the line has a duplicate name with different value
with pivot - it will be more accurate