Group Data

It is time to move to more complicated functions. The first one is .groupby()! It can be guessed from the title that this function groups our columns, but how? Firstly, look at the example, and everything will become more evident:

Here is the initial dataset:

Look at the job titles.

Imagine you want to know the mean salary for each specialization. However, it's impossible to calculate this value manually; you have plenty of data, so using a function that can group column values is the right way.

Here is the code:

Look at the output:

Here, we can see the mean value of work_year, salary, and salary_in_usd for each job_title.

How does the function work?

1. DataFrame.groupby() is general syntax of groupby function.
2. DataFrame.groupby(['job_title']) in brackets we specify by which column we will group data.
3. DataFrame.groupby(['job_title']).mean() obligatory we need to give the program instructions: what it has to do with numerical values that relate to one group. In our case, we ask the groupby function to calculate the mean() of all numerical values with one job_title.