Last Updated on March 27, 2023 by mishou

I. What do you learn?

Let’s learn how to use VLOOKUP in Excel and Python according to the article:

VLOOKUP implementation in Python in three simple steps

II. Data

Get the data from here:

https://data.worldbank.org/indicator/NY.GDP.PCAP.PP.CD

You can find the indicators for pandas_datareader here:

I’ve got the data for some countries: GDP Purchasing Power Parity, GDP Purchasing Power Parity per capita, access to electricity, population, CO2 emission in 2018.

III. VLOOKUP implementation in Excel

You can see the EXCEL sheet here:

https://1drv.ms/x/s!AmlzIpnp3h4-jkhVh02kpimbsBHD?e=6BlXjZ

IV. Use Python to do the LOOKUP function in Excel

I have done the LOOKUP function job according to my Cheat Sheets way.

You can see all the scripts here:

https://colab.research.google.com/drive/19y6ZhQd8lHrZVL40Nfjj667Erwh26K2y?usp=sharing