Display / print all rows of a tibble (tbl_df)
You could also use
print(tbl_df(df), n=40)
or with the help of the pipe operator
df %>% tbl_df %>% print(n=40)
To print all rows specify tbl_df %>% print(n = Inf)
edit 31.07.2021: in > dplyr 1.0.0
Warning message:
`tbl_df()` was deprecated in dplyr 1.0.0.
Please use `tibble::as_tibble()` instead.
df %>% as_tibble() %>% print(n=40)
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)
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:
The tibble vignette has an updated way to change its default printing behavior:
You can control the default appearance with options:
options(pillar.print_max = n, pillar.print_min = m)
: if there are more than n rows, print only the first m rows. Use options(pillar.print_max = Inf) to always show all rows.
options(pillar.width = n)
: use n character slots horizontally to show the data. If n > getOption("width"), this will result in multiple tiers. Useoptions(pillar.width = Inf)
to always print all columns, regardless of the width of the screen.
examples
This will always print all rows:
options(pillar.print_max = Inf)
This will not actually limit the printing to 50 lines:
options(pillar.print_max = 50)
But this will restrict printing to 50 lines:
options(pillar.print_max = 50, pillar.print_min = 50)