Vlookup function in Pyhton

[antozas]

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

[vikraman]

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