Select column 2 to last column in R

r dataframe multiple-columns
user2015601 picture user2015601 · Mar 10, 2013 · Viewed 44.3k times · Source

I have a data frame with multiple columns. Now, I want to get rid of the row.names column (column 1), and thus I try to select all the other columns.

E.g., 

newdata <- olddata[,2:10]

is there a default symbol for the last column so I don't have to count all the columns? I tried

newdata <- olddata[,2:]

but it didn't work.

Answer

Se&#241;or O picture Señor O · Mar 10, 2013

I think it's better to focus on wanting to get rid of one column of data and not wanting to select every other column. You can do this as @Arun suggested:

olddata[,-1]

Or:

olddata$ColNameToDelete <- NULL

Related questions

Combine two or more columns in a dataframe into a new column with a new name

For example if I have this: n = c(2, 3, 5) s = c("aa", "bb", "cc") b = c(TRUE, FALSE, TRUE) df = data.frame(n, s, b) n s b 1 2 aa TRUE 2 3 bb FALSE 3 5 cc TRUE Then how do I combine the two …

Read More
Matching multiple columns on different data frames and getting other column as result

I got two big data frames, one (df1) has this structure chr init 1 12 25289552 2 3 180418785 3 3 180434779 The other (df2) has this V1 V2 V3 10 1 69094 medium 11 1 69094 medium 12 12 25289552 high 13 1 69095 medium 14 3 180418785 medium 15 3 180434779 low What I'm trying to do is to add the column V3 of df2 …

Read More
R subsetting a data frame into multiple data frames based on multiple column values

I am trying to subset a data frame, where I get multiple data frames based on multiple column values. Here is my example >df v1 v2 v3 v4 v5 A Z 1 10 12 D Y 10 12 8 E X 2 12 15 A Z 1 10 12 E X 2 14 16 …

Read More