A Pivot Table is a powerful tool that helps in calculating, summarising and analysing your data. Most often we relate Pivot tables to Excel sheets due to extensive usage of this feature on Excel for quick analysis.
Pivot Table is the first and foremost go to tool for anyone whose day to day life revolves around using MS-Excel.
In this article we will not just look at how to build a Pivot table on Excel but we will extend the same idea to SQL and Python(Pandas). …
Knows a thing or two about data science and machine learning