It is quite common to use size() in Python. size() function gives you a total number of elements. Now, if it is that easy and straight forward, then why am I writing about it? Isn't it? Well, calculating the size or getting the output of the size() function is very straight forward, but when it comes to labeling this value, things become more complicated. Let's understand this with the help of an example. Input Data Here is how our sample data looks like. It is in the form of CSV: Scenario Explained The idea is to group data based on 2 columns named 'type_school' and 'interest' and then show their item count in a separate column. Here is the sample code to achieve this: import pandas as pd df = pd . read_csv ( 'data.csv' ) data = df . groupby ( [ 'type_school' , 'interest' ] ) data [ 'size' ] = data . size ( ) print ( data ) Python Copy The above code looks all good but you will end up seeing an error in it's execu
This blog is all about my technical learnings pertaining to C#, Azure, Python, AI, ML, Visual Studio Code and many more.