vlookup in python

VLOOKUP in Python and Pandas using .map() or .merge()

  • by

You may be familiar with VLOOKUP in Excel and be wondering how to accomplish this in Python. Using this tutorial, we’ll demonstrate Pandas’ .map() and .merge() methods to accomplish the same thing!

Personal Macro Workbook cover image

Setting up a Personal Macro Workbook in Excel (and some sample macros!)

  • by

When you develop a macro in Excel, it’s only available in the workbook you create it in – unless you add it to your Personal Macro Workbook. The workbook is a hidden workbook that runs in the background whenever you open Excel, allowing you to access any of the macros you’ve stored within it.

Using vlookup in excel

How to Use VLOOKUP in Excel

  • by

Learn everything you need to know about the magical and mystical VLOOKUP function in Excel!