Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
11. Function size()


Good! Once we have our rows grouped, we can run various statistical functions on them. Let's start with size():

players_by_height = players.groupby('height')

We'll see something like:

180 1
185 3
191 2
198 3
203 1
dtype: int64

The size() function shows the number of rows in each group. You can use it as a starting point to check whether groups were created correctly.


Use the size() function on the rows grouped by country.

As you can see, the country with the most movies is the USA, and the country with the fewest movies is Russia.

Stuck? Here's a hint!

Simply add size() after a dot to the movies_by_country variable.