6. Groupby

Group the Data in the DataFrame

  1. Select Groupby in the Data Analysis category.

  1. Choose the DataFrame to be grouped.

Group by column A, Apply grouping to column B, and Use method C.

  1. For time-related data, check Grouper to group data based on periods such as monthly, weekly, or yearly.

  2. Check Advanced to apply different methods for each column.

  3. Specify the variable name to assign to the result.

  4. Reset the index to assign a new default integer index.

  5. Save and display the result in DataFrame format.

  6. Preview the code to be output.

  7. Preview the data to be output.

  8. Output the result.

Previous5. SubsetNext7. Bind

Last updated