Replicate Excel VLOOKUP, HLOOKUP, XLOOKUP in Python (DAY 30!!)
Excel LOOKUP formulas are probably one of the most used formulas (at least for me). So today we’ll replicate the[…]
Read moreCategory: Intermediate
Create complex calculated columns using applymap()
We previously talked about how to create calculated columns in pandas, and walked through some simple examples. We can create[…]
Read moreCashflow projection in Python
Folks work in the finance industry deal with cashflow projection everyday, but mostly in Excel. Indeed, Excel is easy to[…]
Read moreSave Python plots into Excel file
We briefly talked about how to create a graph in Python using web data, but it’s not so useful if[…]
Read moreReplicate Excel Goal Seek in Python
Excel provides an excellent feature – Goal Seek, which allows back-solving an input value when given the end result. It[…]
Read moreCreate calculated columns in a dataframe
In Excel, we can create a calculated column by first write a formula (in a cell), then drag down the[…]
Read moreFilter a pandas dataframe – OR, AND, NOT
This is the second part of the Filter a pandas dataframe tutorial. Today we’ll be talking about advanced filter in[…]
Read moreFilter a pandas dataframe (think Excel filters but more powerful)
Being able to slice and dice the data is essential for working with data. Similar to the filter in Excel,[…]
Read moreRename pandas dataframe columns
There are many reasons to rename pandas dataframe columns. For example, maybe you want the column names to be more[…]
Read moreInsert rows into a dataframe (vs Excel table)
One common task in Excel is to insert rows into a sheet. When working with data in Python, we can[…]
Read more