Print range of ROWS in R-CodePudding

I'm trying to print a range of rows in a large dataset but everything comes back with an error mentioning columns. I've tried a variation of punctuation but struggling to find anything that dictates the actual syntax for print rows and not columns. Can someone assist?

INDIANA.LONG <- INDIANA %>% 
  pivot_longer(X2010:X2019, names_to = "YEARS", values_to = "COUNT") %>%
  print[75:83,]

This is the error:

Error in `vectbl_as_col_location()`:
! Can't subset columns past the end.
ℹ Locations 75, 76, 77, 78, 79, … don't
  exist.
ℹ There are only 6 columns.

CodePudding user response：

Try using slice from dplyr before the print statement:

INDIANA.LONG <- INDIANA %>% 
  pivot_longer(X2010:X2019, names_to = "YEARS", values_to = "COUNT") %>%
  slice(75:83) %>%
  print

CodePudding user response：

within a dplyr/tidyr pipeline, you can use between(), row_number(), and filter()

filter(between(row_number(), 75,83))

instead of your print() call.

CodePudding user response：

Another option is to use the base R notation inside the pipe prior to using print:

library(dplyr)

INDIANA.LONG <- INDIANA %>%
  pivot_longer(X2010:X2019, names_to = "YEARS", values_to = "COUNT") %>%
  .[75:83, ] %>%
  print