Mastering Python for Data Science

Data operations

Once the missing data is handled, various operations can be performed on the data.

Aggregation operations

There are a number of aggregation operations, such as average, sum, and so on, which you would like to perform on a numerical field. These are the methods used to perform it:

• Average: To find out the average number of students in the ELEMENTARY school who are obese, we'll first filter the ELEMENTARY data with the following command:

  >>> data = d[d['GRADE LEVEL'] == 'ELEMENTARY']
  213.41593780369291
  

  Now, we'll find the mean using the following command:

  >>> data['NO. OBESE'].mean()
  

  The elementary grade level data is filtered and stored in the data object. The NO. OBESE column is selected, which contains the number of obese students ...