VLOOKUP in Python - Quick and Easy Pandas Script

Learn how you can replace using VLOOKUP with Python script using Pandas. You will learn the basic of table joins that are more effective way of performing lookups than VLOOKUP. Please remember to subscribe if you have any question or concerns.
You will learn the following steps:

1. Loading Multiple Excel Sheets
2. Saving variable
3. Merging Sheets

The dataset and notebook will be on my Github

#Python, #Pandas, #VLookup #excel

[Seftehandle]

can't wait to try this out. you made it so easy for excel user <3

[VitorBarbi-]

Very good, thanks. I have one question, in my exercise when I merge the two dfs it brings me more rows that I had before. Do you know how can I avoid that?

[apz]

Thanks for sharing. I am new to python and pandas. The table I am merging contains many columns. My expectation is to bring just one or two columns from this data into my new dataframe. At the moment everything from the merging table is being added to my new dataframe, is this possible?

[AetherAlign]

Hi my name is Sumit srivastava we merge 3 data sets 1st is my overall where branch I'd, product I'd and so on data n 2nd one is branch name data set where 2 column data 1st is branch I'd n branch name and 3rd is product data where product I'd n product name we required overall dta branch name by branch I'd n product name by product I'd but when I used merge function n lookpu left data branch name n product name my overall data sets row automatic increased I am very confused pls help(overall data set size is 56000 but when use merge function dataset row r 90000 it's not correct)

[omarabubakerbamahdi]

Great tutorial! But How do I do the same thing but if the excel files are in *.csv format instead?

[stratelyze]

Will this return the exact same values as an Excel lookup?