<
<

Groupby Mean

>

Computes the mean (average) of values in a dataset grouped by a specified column.

>

Input

Output

29 Related tools

Video Tutorial?

Table Statistic?

Any Questions?

Computes the mean (average) of values in a dataset grouped by a specified column. Mean is the average value of a set of numbers. Read more about mean on Wikipedia https://en.wikipedia.org/wiki/Arithmetic_mean

4 is the mean of the set [2, 4, 6] because (2 + 4 + 6) / 3 = 4.

Useful for summarizing average performance by group, like average score per class or average income per region.

  • Microsoft Excel: AVERAGE
  • Google Sheets: AVERAGE
  • Apple Numbers: AVERAGE
  • Python Pandas: df.groupby('grouping_column')['column_name'].mean()
  • Related Words: calculate groupby mean, average values based on a grouping column

This is normal for a web based application. We recommend uploading data up to 6000 columns and rows. If you encounter lag, you can reduce the sheet size.

There is a fullscreen button on the top right side of the input table. You can also download the table offline to edit with excel which has bigger screen sizes.

You can leave a message here.

Why SickSheet?

🌎
Access Anywhere

Compatible with any browser on any systems. No installation needed.

💸
Free to Use

Use over 300+ tools for free. No registration or credit card asked.

🧸
No Code

Complete all process without writing a single line of code.

💡
Intuitive Edit

Editing tables feels like in Excel. No learning curve needed.

💾
Instant Download

Click to download 10+ Spreadsheet formats and continue edit in Excel.

🕵️‍♂️
Super Private

Nothing is sent to the server. All data are operated on the client-side.

Related Tools?

Discover Above Average

Finds values above the arithmetic average.

mean
Discover Under Average

Finds values below the arithmetic average.

mean
Calculate Mean

Computes the arithmetic mean in each row and column.

mean
Rolling Mean

Computes the rolling mean (average) of a specified window size for a dataset.

mean
Cumulative Mean

Computes the cumulative arithmetic mean in a dataset up to each row or column.

mean
Groupby Sum

Computes the sum of values in a dataset grouped by a specified column.

Groupby Quotient

Computes the quotient of values in a dataset grouped by a specified column.

Groupby Product

Computes the product of values in a dataset grouped by a specified column.

Groupby Difference

Computes the difference in a dataset grouped by a specified column.

Groupby Duplicate Cell Count

Count duplicate cells in a dataset grouped by a specified column.

Groupby Mode

Computes the mode of values in a dataset grouped by a specified column.

Groupby Unique Cell Count

Count distinct values in a dataset grouped by a specified column.

Groupby First

Performs a SQL grouby and returns the first element of each item.

Groupby Last

Performs a SQL grouby and returns the last element of each item.

Groupby Maximum

Computes the maximum value in a dataset grouped by a specified column.

Groupby Minimum

Computes the minimum value in a dataset grouped by a specified column.

Groupby Range

Computes the range of values in a dataset grouped by a specified column.

Groupby Blank Count

Count empty cells in a dataset grouped by a specified column.

Groupby Non Blank Count

Count non-empty cells in a dataset grouped by a specified column.

Groupby Geometric Mean

Computes the geometric mean of values in a dataset grouped by a specified column.

Groupby Harmonic Mean

Computes the harmonic mean of values in a dataset grouped by a specified column.

Groupby Median

Computes the median of values in a dataset grouped by a specified column.

Groupby Concatenation

Concatenate the values in a dataset grouped by a specified column.

Groupby Percent Difference

Computes the percentage difference in a dataset grouped by a specified column.

Groupby Quantile

Computes the quantile of values in a dataset grouped by a specified column.

Groupby Kurtosis

Computes the kurtosis of values in a dataset grouped by a specified column.

Groupby Skewness

Computes the skewness of values in a dataset grouped by a specified column.

Groupby Standard Deviation

Computes the standard deviation of values in a dataset grouped by a specified column.

Groupby Variance

Computes the variance of values in a dataset grouped by a specified column.

<
👉... other 321 tools to save you time
>