Display/Print All Rows of a Tibble (Tbl_Df)

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)

dplyr show all rows and columns for small data.frame inside a tbl_df

if you want to still use dplyr and print your dataframe just run

print.data.frame(ddf)
ddf

Having trouble viewing more than 10 rows in a tibble

What I often do when I want to see the output of a pipe like that is pipe it straight to View()

library(dplyr)
library(tidytext)

tidy_books %>%
    anti_join(stop_words) %>%
    count(word, sort=TRUE) %>%
    View()

If you want to save this to a new object that you can work with later, you can assign it to a new variable name at the beginning of the pipe.

word_counts <- tidy_books %>%
    anti_join(stop_words) %>%
    count(word, sort=TRUE)

dplyr::tbl_df fill whole screen

Several ways to accomplish this:

# show up to 1000 rows and all columns *CAPITAL V in View*
df %>% View()

# set option to see all columns and fewer rows
options(dplyr.width = Inf, dplyr.print_min = 6)

# reset options to defaults (or just close R)
options(dplyr.width = NULL, dplyr.print_min = 10)

# for good measure, don't forget about glimpse()...
df %>% glimpse()

R Function to print columns and rows in tibble - what am I doing wrong?

Here's how I would rewrite your function:

print_cols = function(df, ncols, rowstart, rowend) {
  if(!is_tibble(df)) {df = as_tibble(df)}
  col_starts = seq(from = 1, to = ncol(df), by = ncols)
  for(i in col_starts) {
    cat("\n")
    if(i < tail(col_starts, 1)) {
      cols = i + 0:(ncols - 1) 
    } else { ## last iteration
      cols = i:ncol(df)
    }
    message(sprintf(
        "Columns %s to %s: Rows %s to %s",
        cols[1], tail(cols, 1),
        rowstart, rowend
    ))
    print(df[rowstart:rowend, cols], n = Inf)
  }
}

print_cols(mtcars, 8, 2, 3)
# Columns 1 to 8: Rows 2 to 3
# # A tibble: 2 × 8
#     mpg   cyl  disp    hp  drat    wt  qsec    vs
#   <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
# 1  21       6   160   110  3.9   2.88  17.0     0
# 2  22.8     4   108    93  3.85  2.32  18.6     1
# 
# Columns 9 to 11: Rows 2 to 3
# # A tibble: 2 × 3
#      am  gear  carb
#   <dbl> <dbl> <dbl>
# 1     1     4     4
# 2     1     4     1

---

Related Topics