selecting specific columns from R datatable

Question

I have a R dataframe and I need to select first n columns and some other columns using name.

Can I do it in a single statement ?

Say I need to choose columns from 1 to 10 and columns named as A,B,C etc

Ronak Shah · Accepted Answer · 2020-05-14 06:15:15Z

3

select from dplyr allows to do that.

library(dplyr)
mtcars %>% select(1:3, 'am', 'carb') %>% head

#                   mpg cyl disp am carb
#Mazda RX4         21.0   6  160  1    4
#Mazda RX4 Wag     21.0   6  160  1    4
#Datsun 710        22.8   4  108  1    1
#Hornet 4 Drive    21.4   6  258  0    1
#Hornet Sportabout 18.7   8  360  0    2
#Valiant           18.1   6  225  0    1

In base R, you can use either index or names at a given time, so you can either do :

mtcars[, c(names(mtcars)[1:3], 'am', 'carb')]

Or :

mtcars[, c(1:3, match(c('am', 'carb'), names(mtcars)))]

answered May 14, 2020 at 6:15

Ronak Shah

391k20 gold badges173 silver badges237 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

selecting specific columns from R datatable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related