In this post, we’ll explore how binning data in Python works with the cut() method in Pandas. In the past, we’ve explored how to use the describe() method to generate some descriptive statistics. In particular, the describe method allows us to see the quarter percentiles of a numerical column. However, as we’re generating insight into […]
Binning Data in Python with Pandas’ cut() Read More »
In this tutorial, you’ll learn how to use Python and Pandas to VLOOKUP data in a Pandas DataFrame. VLOOKUPs are common functions in Excel that allow you to map data from one table to another. In many cases, this can be used to lookup data from a reference table, such as mapping in, say, a
VLOOKUP in Python and Pandas using .map() or .merge() Read More »
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.
Setting up a Personal Macro Workbook in Excel (and some sample macros!) Read More »
Learn everything you need to know about the magical and mystical VLOOKUP function in Excel!
How to Use VLOOKUP in Excel Read More »
