Re move row.names column in dataframe

-----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] 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.

1.            If your data frame is numeric, change it to matrix. 

2.            Or make your own function 

identical(df[1,],df[2,]) is FALSE because of the row names. all( == ) is just a work-around that I attempted.

Jorgen.

On Mar 11, 2013, at 02:53 , PIKAL Petr wrote:

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

I 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

	[[alternative HTML version deleted]]

-----Original Message-----
From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-
project.org] On Behalf Of jeharmse
Sent: Monday, March 11, 2013 5:28 PM
To: r-help at r-project.org
Subject: Re: [R] Re move row.names column in dataframe

1.            If your data frame is numeric, change it to matrix.

It isn't necessarily numeric.

2.            Or make your own function

I think that's the solution, but the function has to handle both NA and
non-numeric.

equal.NA <- function(x,y)
all(is.na(x)==is.na(y)) && all(is.na(x) | x==y)

I'm still worried that row names could bite me in some other way, and
would prefer to be able to discard them.

--
View this message in context: http://r.789695.n4.nabble.com/Remove-row-
names-column-in-dataframe-tp856647p4660956.html
Sent from the R help mailing list archive at Nabble.com.