R how to remove duplicates elements in the column and get average value

Question

Sorry I am new to R, and the problem is quite hard for me,
Here is the matrix:

        V1              predictions
1   Jeffery Howes   0.0909596345057677
2   Sherilee Waring 0.00434589236424605
3   Rachel Maitland 0.0909596345057677
4   Jan Maitland    0.0909596345057677
5   Jan Maitland    0.0909596345057677
6   Jan Maitland    0.0909596345057677
7   Jan Maitland    0.0909596345057677
8   Sandra McEwen   0.0909596345057677
....

How can I remove the duplicates in the columns (that's okay for me, could use unique, but the following problem is quite hard for me).

For example, there are many duplicated name Jan Maitland, duplicates should be removed, but the predications values should be calculated (the final result left should be the average value of those duplicate names)

Could someone help me on that? thanks a lot!!

See this post: data.frame Group By column

zx8754
– zx8754

2014-05-19 13:44:56 +00:00
Commented May 19, 2014 at 13:44 — zx8754
– zx8754, Commented May 19, 2014 at 13:44

droopy · Accepted Answer · 2014-05-19 14:00:10Z

1

you can use the dplyr library :

result%.%group_by(V1)%.%summarise(predictions = mean(predictions))
# the 2nd syntax
summarise(group_by(result, V1), predictions=mean(predictions))

hth

edited May 19, 2014 at 14:00

answered May 19, 2014 at 13:42

droopy

2,8281 gold badge16 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Jusleong Over a year ago

thanks! what's the meaning of tab? forget to mention that the matrix name is result, so it should be result%.%group_by(V1)%.%summarise(predictions = mean(predictions))??

Jusleong Over a year ago

Hi droppy, not quite understand the %.%

droopy Over a year ago

yes it should be result instead of tab and result must be a data.frame and a not a matrix; I'll edited the post

Jusleong Over a year ago

thanks! btw, how should I convert matrix to data.frame

Jusleong Over a year ago

as.data.frame(result)?

|

Collectives™ on Stack Overflow

R how to remove duplicates elements in the column and get average value

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related