xlwings - VLOOKUP an Entire Column in an Excel Workbook with Python | Data Automation

This video reviews how to add the VLOOKUP formula to an entire column using the Python library xlwings. I use Anaconda's Jupyter Lab interface.
😄 Please consider supporting this channel and making this content possible:
☕ www.buymeacoffee.com/DataAuto...
🅿 / dataautomation
00:00 :: Intro and Workbook review
00:36 :: Collecting Last Row of Data
01:29 :: Adding VLOOKUP to the Column
02:07 :: Overview
#PythonExcelTutorial #xlwings #data #DataAutomation #python #pythontutorial #excel #pythonautomation #pythonprogramming #VLOOKUP #jupyterlab

[@heliheli6808]

Wouldn’t this be as slow as vba if we are writing formula or value into excel if the database is large?

[@data_automation]

Thank you for the question! I don't actually know the answer to that, as I have never used VBA before. I have run this on larger datasets and haven't experienced any issues in speed.