How to select every second column from an excel file

General
1

Hi,
I am having a bit of a problem with a big dataset. For my work I need to select every second column from an excel file. I need column B (to be able to differantiate measurements), and starting from the H or 8th column with a step of two (8th, 10th, 12th, 14th, etc.) until the CV column or in other words the 100th column.

Thanks for any help you can provide.

2 
dat <- data.frame(matrix(nrow = 2,ncol = 100))

picker <- which(1:100 %% 2 == 0)[c(1,4:50)]

dat[,picker]
#>   X2 X8 X10 X12 X14 X16 X18 X20 X22 X24 X26 X28 X30 X32 X34 X36 X38 X40 X42 X44
#> 1 NA NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA
#> 2 NA NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA
#>   X46 X48 X50 X52 X54 X56 X58 X60 X62 X64 X66 X68 X70 X72 X74 X76 X78 X80 X82
#> 1  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA
#> 2  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA  NA
#>   X84 X86 X88 X90 X92 X94 X96 X98 X100
#> 1  NA  NA  NA  NA  NA  NA  NA  NA   NA
#> 2  NA  NA  NA  NA  NA  NA  NA  NA   NA
1 Like
3

Thank you for your reply, it works like a charm.

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.