divide alternating rows in table in r

Here is an example of how you can use dplyr and tidyr packages to divide alternating rows in a table in R.

main.r
library(dplyr)
library(tidyr)

# create example table
df <- data.frame(a = c(1, 2, 3, 4, 5, 6),
                 b = c("A", "B", "C", "D", "E", "F"))

# divide alternating rows into two separate tables
df1 <- df %>% 
  filter(row_number() %% 2 != 0) %>%  # select odd rows
  select(a, b)                       # select specific columns

df2 <- df %>% 
  filter(row_number() %% 2 == 0) %>%  # select even rows
  select(a, b)                       # select specific columns
472 chars
16 lines

In this example, row_number() is used to generate a sequence of row numbers, which are then filtered to select alternating rows. Finally, select() is used to choose specific columns that are needed.

gistlibby LogSnag