How do I find how many times a value has been repeated in a column - R

Question

Possible Duplicate:
Count unique values in R

I have just one column full of names, and I need to know how many times each name is on this column.

I can do a

summary(dfUL)

where dfUL is my user list data frame

This will give me a summary with the number of times a particular value is repeated, but it will only do it for the top 6. How can i do that for the entire data frame?

score 8 · Accepted Answer · answered Apr 23 '12 at 11:42

8

Did you try already table(dfUL)?

answered Apr 23 '12 at 11:42

johannes

14,043
5
40
51

No I hadn't, yes this solves it...i feel really bad for asking such a stupid questions. Thanks. – vonHippie Apr 23 '12 at 11:48
3

@vonHippie "there are no stupid questions, just stupid answers." PS remember to accept the answer. – Carl Witthoft Apr 23 '12 at 14:03

score 2 · Answer 2 · answered Apr 23 '12 at 23:45

2

Another possibly useful method would be the match() function.

match(x,dfUL$somecol) #Where x is the value in somecol you are looking for
match(max(dfUL$somecol),dfUL) #Returns the row with the maximum value of somecol

answered Apr 23 '12 at 23:45

forestman

189
5

How do I find how many times a value has been repeated in a column - R

2 Answers2