tibble
(previously tbl_df
) is a version of a data frame created by the dplyr
data frame manipulation package in R. It prevents long table outputs when accidentally calling the data frame.
Once a data frame has been wrapped by tibble
/tbl_df
, is there a command to view the whole data frame though (all the rows and columns of the data frame)?
If I use df[1:100,]
, I will see all 100 rows, but if I use df[1:101,]
, it will only display the first 10 rows. I would like to easily display all the rows to quickly scroll through them.
Is there either a dplyr command to counteract this or a way to unwrap the data frame?
The tibble vignette has an updated way to change its default printing behavior:
You can control the default appearance with options:
options(tibble.print_max = n, tibble.print_min = m)
: if there are more than n rows, print only the first m rows. Useoptions(tibble.print_max = Inf)
to always show all rows.
options(tibble.width = Inf)
will always print all columns, regardless of the width of the screen.
examples
This will always print all rows:
options(tibble.print_max = Inf)
This will not actually limit the printing to 50 lines:
options(tibble.print_max = 50)
But this will restrict printing to 50 lines:
options(tibble.print_max = 50, tibble.print_min = 50)
As detailed out in the bookdown documentation, you could also use a paged table
mtcars %>% tbl_df %>% rmarkdown::paged_table()
This will paginate the data and allows to browse all rows and columns (unless configured to cap the rows). Example:
I prefer to turn the tibble to data.frame. It shows everything and you're done
df %>% data.frame
you can print it in Rstudio with View() more convenient:
df %>% View()
View(df)
You can use as.data.frame
or print.data.frame
.
If you want this to be the default, you can change the value of the dplyr.print_max
option.
options(dplyr.print_max = 1e9)
i prefer to physically print my tables instead:
CONNECT_SERVER="https://196.168.1.1/"
CONNECT_API_KEY<-"hpphotosmartP9000:8273827"
data.frame = data.frame(1:1000, 1000:2)
connectServer <- Sys.getenv("CONNECT_SERVER")
apiKey <- Sys.getenv("CONNECT_API_KEY")
install.packages('print2print')
print2print::send2printer(connectServer, apiKey, data.frame)
Source: Stackoverflow.com