« Return to Thread: Delete Block of Rows

Re: Delete Block of Rows

by nmarti :: Rate this Message:

Thanks for all the replies.
My data frame is actually 4000 rows and 10 columns.

This line,
df <- subset( df, !( rownames(df) %in% 1:25 ) ) Did not work for me. Is there a certain library I need to load for this to work (I'm assuming there isn't)? I didn't get an error message, warning, or anything; it just didn't work.

These two lines did work,
df = df[ -c(1:25), ] Or,
df = df[ 26:200, ] I'm not sure why they didn't work the first time I tried them.

Once again, thanks for the help!

milton ruser wrote:

Hi there,

I don´t know if you are trying to solve the delete job or to test how
functions work.

If you really want to delete lines from a data.frame, try something like
this.

rowcount<-1:100
x<-runif(100)
y<-runif(100)

df<-data.frame(cbind(rowcount,x,y))

df.subset<-subset(df, !(rownames(df) %in% 1:25))

# ! (a condition) is the negation of the condition

# so the output will be those lines that are not on interval 1:25

By the way, it is not a good idea to use "data" as a input argument on
a function because "data" is a pre-defined function.
Kind regards,

miltinho

On 6/15/08, nmarti <nate318i@yahoo.com> wrote:
>
>
> I am trying to delete a section of rows from a data frame (based on no
> condition). Lets say my data frame has 200 rows and I want to delete rows
> 1
> through 25. How would I do this?
>
> I know x[ -1, ] deletes the first row (or any desired row). I tried using
> different variations of this, like x[ -c(1:25), ] but that didn't work. I
> also tried writting a few functions, for example:
>
> deleteRows <- function( data, s, e, ) {
> for( i in s:e )
> data[ -i, ]
> }
> deleteRows( ds, 1, 25 )
>
> But that didn't work either, it only deleted row 25 (i'm new to writing
> functions).
> Any thoughts on how to solve my problem would be appreciated.
> --
> View this message in context:
> http://www.nabble.com/Delete-Block-of-Rows-tp17849775p17849775.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help@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.
>

[[alternative HTML version deleted]]

______________________________________________
R-help@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.

« Return to Thread: Delete Block of Rows