Hello, aa<-c(1,1,2,2,3,3,4,4,5,5,6,6) bb<-c(56,56,33,33,53,53,20,20,63,63,9,9) cc<-data.frame(aa,bb) uniquedf <- unique(cc) View(uniquedf) Why does the column "row.names" appear in the new dataframe and how do I get rid of it. "uniquedf$row.names <- NULL" does not seem to work. For what I'm doing this is a useless column and can cause confusion and/or problems for subsequent merging/filtering etc. Thanks. -- View this message in context: http://www.nabble.com/Remove-row.names-column-in-dataframe-tp18050179p18050179.html Sent from the R help mailing list archive at Nabble.com.
tonyxv wrote:> > > Hello, > > aa<-c(1,1,2,2,3,3,4,4,5,5,6,6) > bb<-c(56,56,33,33,53,53,20,20,63,63,9,9) > cc<-data.frame(aa,bb) > uniquedf <- unique(cc) > View(uniquedf) > > > Why does the column "row.names" appear in the new dataframe and how do I > get rid of it. > > "uniquedf$row.names <- NULL" does not seem to work. > > For what I'm doing this is a useless column and can cause confusion and/or > problems for subsequent merging/filtering etc. > > > Thanks. >There is no column row.names; there are only row names. In R enter ?unique ?View ?row.names ?data.frame and your questions will be answered. To get sequential row numbers you can do row.names(uniquedf) <- NULL Berend -- View this message in context: http://www.nabble.com/Remove-row.names-column-in-dataframe-tp18050179p18051448.html Sent from the R help mailing list archive at Nabble.com.
- There is no column in the data frame called "row.names". It only looks that way when you use the viewer. - All data frames must have row and column names. This is not negotiable. Also, the row.names will not interfere with any merging operation because they are not a column of the data frame: they are the row names. Bill Venables CSIRO Laboratories mailto:Bill.Venables at csiro.au http://www.cmis.csiro.au/bill.venables/ -----Original Message----- From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] On Behalf Of tonyxv Sent: Sunday, 22 June 2008 11:15 AM To: r-help at r-project.org Subject: [R] Re move row.names column in dataframe Hello, aa<-c(1,1,2,2,3,3,4,4,5,5,6,6) bb<-c(56,56,33,33,53,53,20,20,63,63,9,9) cc<-data.frame(aa,bb) uniquedf <- unique(cc) View(uniquedf) Why does the column "row.names" appear in the new dataframe and how do I get rid of it. "uniquedf$row.names <- NULL" does not seem to work. For what I'm doing this is a useless column and can cause confusion and/or problems for subsequent merging/filtering etc. Thanks. -- View this message in context: http://www.nabble.com/Remove-row.names-column-in-dataframe-tp18050179p18 050179.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ 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.
... the row.names will not interfere with any merging operation ... Row names do not interfere with merge, but they cause other problems. In the example, I want to test whether rows have the same entries (in some or all columns). identical fails because of the row names, and all( == ) can fail if there are NAs. There are ways around this, but it would be cleaner to be able to remove row names.> df <- data.frame(x=c(1,1,NA,NA), y=c(2,2,7,7)) > identical(df[1,],df[2,])[1] FALSE> all(df[1,]==df[2,])[1] TRUE> all(df[3,]==df[4,])[1] NA -- View this message in context: http://r.789695.n4.nabble.com/Remove-row-names-column-in-dataframe-tp856647p4660743.html Sent from the R help mailing list archive at Nabble.com.
Hi> -----Original Message----- > From: r-help-bounces at r-project.org [mailto:r-help-bounces at r- > project.org] On Behalf Of jeharmse > Sent: Friday, March 08, 2013 7:41 PM > To: r-help at r-project.org > Subject: Re: [R] Re move row.names column in dataframe > > > ... the row.names will not interfere with any merging operation ... > > Row names do not interfere with merge, but they cause other problems. > In the example, I want to test whether rows have the same entries (in > some or all columns). identical fails because of the row names, and > all( == ) can fail if there are NAs. There are ways around this, but it > would be cleaner to be able to remove row names. > > > df <- data.frame(x=c(1,1,NA,NA), y=c(2,2,7,7)) > > identical(df[1,],df[2,]) > [1] FALSE > > all(df[1,]==df[2,]) > [1] TRUE > > all(df[3,]==df[4,]) > [1] NAI beg your pardon, whot does row names do with the above result? What do you expect as a result of all(df[3,]==df[4,]) Regards Petr> > > > > -- > View this message in context: http://r.789695.n4.nabble.com/Remove-row- > names-column-in-dataframe-tp856647p4660743.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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.
Thank you. This does what I want (apparently by coercing data.frame to list with no other structure). -- View this message in context: http://r.789695.n4.nabble.com/Remove-row-names-column-in-dataframe-tp856647p4661049.html Sent from the R help mailing list archive at Nabble.com.