[R] a problem with table() and duplicates

jim holtman jholtman at gmail.com
Wed Jan 22 17:15:31 CET 2014


try:

table(dataframe$religion[!duplicated(dataframe$name)])


Jim Holtman
Data Munger Guru

What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.


On Wed, Jan 22, 2014 at 11:04 AM, Simone Gabbriellini
<simone.gabbriellini at gmail.com> wrote:
> Dear List,
>
> I have a data.frame like this:
>
> name religion neighbor religion.neighbor
> pippo a minnie a
> pluto a mickey a
> paperino b donald a
> paperino b minnie b
>
> when I table(dataframe$religion) my data.frame, I get
> a b
> 2 2
>
> of course, "paperino" is cited twice but should be counted once. Is
> there anything I can do in order to keep the data.frame the way it is
> but tell R to count values once if they are repeated?
>
> the point is that each row represent a relation, thus I cannot simply
> remove duplicates...
>
> any help more than welcome!
>
> Best regards,
> Simone
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.




More information about the R-help mailing list