I love Python. Pandas New Era Excel!
Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool but it is not suitable for processing large amounts of data so I am sharing some common things a lot of people do in excel but using python’s pandas package, for example vlookup, filtering data or pivot table.
Pandas is a Python package providing fast, flexible, and expressive data structures designed to make working with “relational” or “labeled” data both easy and intuitive. It aims to be the fundamental high-level building block for doing practical, real-world data analysis in Python.
For codes please refer to my jovian profile (https://jovian.ai/umersaeed81/notebooks)
You can download the pdf document from the following link:
I will try my level best to provide the updated version of the document with better formatting share with you soon.