R get rid of rows with duplicate attribute

Posted by CatholicEvangelist on Stack Overflow See other posts from Stack Overflow or by CatholicEvangelist
Published on 2010-05-03T16:05:57Z Indexed on 2010/05/03 16:08 UTC
Read the original article Hit count: 218

Filed under:

hi there
I have a big dataframe with columns such as:
ID, time, OS, IP
Each row of that dataframe corresponds to one entry. Within that dataframe for some IDs serveral entries (rows) exist.
I would like to get rid of those multiple rows (obviously the other attributes will differ for the same ID). Or put different: I only want one single entry (row) for each ID.

Could anyone be so kind and help me out on this one?
When I use unique, on the ID column, I only recieve the levels (or each unique ID), but I want to keep the other attributes as well...
I have tried to use apply(x,2,unique(data$ID)), but this does not work either...
Any help is highly appreciated!

Related posts about dataframe

Pandas Dataframe add rows on top of dataframe

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to add blank rows on top of the pandas Dataframe data. Basically, some blank rows and some calculation for each row which contains calculations for Average etc. for that column. Can someone please help me how I can do this? From: A B D E F G H I J 0 -8 10… >>> More
Converting a dataframe to a vector (by rows)

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a dataframe with numeric entries like this one test <- data.frame(x=c(26,21,20),y=c(34,29,28)) How can I get the following vector? > 26,34,21,29,20,28 >>> More
writing to a dataframe from a for-loop in R

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to write from a loop to a data frame in R, for example a loop like this for (i in 1:20) { print(c(i+i,i*i,i/1))} and to write each line of 3 values to a data frame with three columns, so that each iteration takes on a new row. I've tried using matrix, with ncol=3 and filled by rows,… >>> More
R get rid of rows with duplicate attribute

as seen on Stack Overflow - Search for 'Stack Overflow'
hi there I have a big dataframe with columns such as: ID, time, OS, IP Each row of that dataframe corresponds to one entry. Within that dataframe for some IDs serveral entries (rows) exist. I would like to get rid of those multiple rows (obviously the other attributes will differ for the same ID)… >>> More
Replace values in a dataframe based on another factor which contains NA's in R

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a dataframe which contains (among other things) a numeric column with a concentration, and a factor column with a status flag. This status flag contains NA's. Here's an example df<-structure(list(conc = c(101.769, 1.734, 62.944, 92.697, 25.091, 27.377, 24.343, 55.084, 0.335, 23.280),… >>> More

Developer IT