Replicate Excel VLOOKUP, HLOOKUP, XLOOKUP in Python (DAY 30!!)
Last Updated on July 14, 2022 by Jay Excel LOOKUP formulas are probably one of the most used formulas (at[…]
Read moreUse Python to automate office tasks
Last Updated on July 14, 2022 by Jay Excel LOOKUP formulas are probably one of the most used formulas (at[…]
Read moreLast Updated on July 14, 2022 by Jay We previously talked about how to create calculated columns in pandas, and[…]
Read moreLast Updated on July 14, 2022 by Jay Python lambda function, aka anonymous function. Unlike how we create a function[…]
Read moreLast Updated on July 24, 2022 by Jay It’s hard to talk about Python without mentioning list comprehension, which is[…]
Read moreLast Updated on July 14, 2022 by Jay Folks work in the finance industry deal with cashflow projection everyday, but[…]
Read moreLast Updated on July 14, 2022 by Jay We briefly talked about how to create a graph in Python using[…]
Read moreLast Updated on July 14, 2022 by Jay Excel makes plotting a graph very easy. So does Python! Today we’ll[…]
Read moreLast Updated on July 14, 2022 by Jay Today we’ll learn how to replicate a common Excel task – find[…]
Read moreLast Updated on July 14, 2022 by Jay We have seen many different ways to load data into Python using[…]
Read moreLast Updated on July 14, 2022 by Jay Sorting table is a common task in Excel. We sort a table[…]
Read more