Replace Excel Vlookup with Python - Five Minute Python Scripts

Subscriber special! We'll look at how we can replace the vlookup function in excel using python and pandas.

Kite helps fund the channel, thanks for checking them out and supporting me --

We'll cover:
- Reading in multiple excel sheets
- Merging dataframes
- Renaming column names
- Exporting to Excel

#Python #Excel #Automation

If you have your own request on what you want to see. Please let me know! I'm happy to help.

THANK YOU ALL for so much support! You all are incredible. 3150+ Subscribers, I'm so glad you all enjoy the content enough to follow me. You all are awesome.

*****************************************************************
Full code from the video:
import pandas as pd
import numpy as np

initial_workbook = 'A.xlsx'
info_workbook = 'B.xlsx'

print(df_3)

print(df_3)

Or find it on my Github here:

*****************************************************************
Code from this tutorial and all my others can be found on my GitHub:

Check out my website:

If you liked the video - please hit the like button. It means more than you know. Thanks for watching and thank you for all your support!!

--- Channel FAQ --

What text editor do you use?

What Equipment do you use to film videos?

What computer do you use/desk setup?

What editing software do you use?
Premiere Pro for video editing
Photoshop for images
After Effects for animations

Do I have any courses available?
Yes & always working on more!

Where do I get my music?
I get all my music from the copyright free Youtube audio library

Let me know if there's anything else you want answered!

-------------------------

Always looking for suggestions on what video to make next -- leave me a comment with your project! Happy Coding!

[GirayhanYlmaz]

I’ve been using excel for over 20 years now, more than half in professional life. I’ve been trying to automate stuff and decided on pursuing python for that reason. Thank you for sharing your experience and wisdom with us.

[Humito]

Just started to learn python on my free time. As an accountant your channel is very helpful since you give examples of how I can use python to analyze data. Keep up the good work

[JenJHayden]

Multiple people accessing the same spreadsheet. Reduce human error. story of my life.

[Guilopes]

Thanks!

As a python newbie and advanced Excel user, I struggle to learn Python as I'm very stuck to excel logic. Would be great to have a tutorial that shows how to do most of Excel data wrangling but better and quicker with python! Thanks!

[urielronaldo]

This channel should have +1M subscribers. I am an economist from Mexico City and Derrick is my inspiration for keeping learning Python!

[logannon]

Been searching the world wide web for 4 hours on how to do this, and this is the only video that correct depicts what I needed. Thank you so fucking much!

[tortilladmaiz]

you deserve more views i believe that this is the future im from tijuana and all the time is consumed by making reports documents on excel thank you sir

[Itshimaru]

Dude, you're just as awesome! The things you have shared are invaluable to people like me who are just beginning to learn Python. By far, your tutorial is best out there with all the actual real life applications. Thank you

[delta-game]

Thankyou, finally found some decent content with someone who can speak english clearly. You are a saviour!

[vio-noob_]

This channel is criminally under subscribed. Very very helpful!!

[charitykahuria]

I found this at a time when I was almost giving up...Thank you

[codingwannabe]

Dude I don't usually comment on google videos however I feel inclined to tell you how useful your content is. I've watched some of your stuff and as someone new to Python that's transitioning from excel your help has been immeasurable. Thanks and keep it coming!

[abrammakgalemele]

Tx Derrick. To SQL users, that's a LEFT JOIN.

[blaskowitzj]

This is a huge help! Excel is so processing heavy that python makes things so much easier. Really appreciate your videos and please keep up the good work.

[patrickwheeler]

I love how you can go across data sources.

[virendraupadhye]

Just started to learn Python. Thanks very good explanation

[gabrielreilly]

I really like your videos. They answer practical questions the basic tutorials don't cover.

[nkimomoleleki]

After watching this video I felt compelled to subscribe. A very good video, easy to follow and most importantly very helpful. Thanks man!

[PM-csjq]

My friend, What a nice person you are and a great teacher 👏👏👏

[johnmcmanus]

This video was so quick I didn't have time to thank you 👍