0 votes

I want to calculate `mean` (or any other summary statistics of length one, e.g. `min``max``length``sum`) of a numeric variable ("value") within each level of a grouping variable ("group").

The summary statistic should be assigned to a new variable which has the same length as the original data. That is, each row of the original data should have a value corresponding to the current group value - the data set should not be collapsed to one row per group. For example, consider group `mean`

Before

``````id  group  value
1   a      10
2   a      20
3   b      100
4   b      200``````

After

``````id  group  value  grp.mean.values
1   a      10     15
2   a      20     15
3   b      100    150
4   b      200    150`````` Jun 27, 2018 326 views

## 1 answer to this question.

0 votes

You can use something like this:

`df\$grp.mean.values <- ave(df\$value, df\$group)`

If you want to use ave to calculate something else per group, you need to specify FUN = your-desired-function, e.g. FUN = min:

`df\$grp.min <- ave(df\$value, df\$group, FUN = min)` answered Jun 27, 2018 by
• 6,380 points

0 votes
1 answer

## How to find out the sum/mean for multiple variables per group in R?

You can use the reshape2 package for ...READ MORE

0 votes
1 answer

## How to filter a data frame with dplyr and tidy evaluation in R?

Requires the use of map_df to run each model, ...READ MORE

0 votes
1 answer

## How to forecast season and trend of data using STL and ARIMA in R?

You can use the forecast.stl function for the ...READ MORE

0 votes
1 answer

## How can I calculate mean per group in a data.frame?

You can use aggregate function for calculating ...READ MORE

0 votes
1 answer

## How to write a custom function which will replace all the missing values in a vector with the mean of values in R?

Consider this vector: a<-c(1,2,3,NA,4,5,NA,NA) Write the function to impute ...READ MORE

0 votes
1 answer

## Mean of one column with respect to another

Consider the inbuilt iris dataset in R. Use ...READ MORE

0 votes
1 answer

## Big Data transformations with R

Dear Koushik, Hope you are doing great. You can ...READ MORE

0 votes
2 answers

## Transforming a key/value string into distinct rows in R

We would start off by loading the ...READ MORE

+1 vote
2 answers

## How to sort a data frame by columns in R?

You can use dplyr function arrange() like ...READ MORE

0 votes
1 answer

## How to find out cluster center mean of DBSCAN in R?

Just index back into the original data ...READ MORE