Python in Excel! Part 10: Get top N rows from a DataFrame! 🐍😃
In this video I solve last night's Excel challenge from Excel BI using Python.
Python equivalent of SUM(TEXTSPLIT(...
Python equivalent of FILTER(..., LARGE(...
What df.nlargest is and why it's not that good
More boolean masks 🎭
Locating rows in a DataFrame using df.loc (kinda like FILTER)
I hope it's at the very least interesting, please drop a like, comment, share, banana peel, your favorite Dad joke.
#excel #python #pythoninexcel #data #analytics