Display / print all rows of a tibble (tbl_df)

r dplyr options display
Zhe Zhang picture Zhe Zhang · Apr 21, 2014 · Viewed 95.4k times · Source

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?

Answer

Tim picture Tim · Dec 4, 2014

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)

Related questions

Overriding "Variables not shown" in dplyr, to display all columns from df

When I have a column in a local data frame, sometimes I get the message Variables not shown such as this (ridiculous) example just needed enough columns. library(dplyr) library(ggplot2) # for movies movies %.% group_by(year) %.% summarise(Length = mean(…

Read More
Filter rows which contain a certain string

I have to filter a data frame using as criterion those row in which is contained the string RTB. I'm using dplyr. d.del <- df %>% group_by(TrackingPixel) %>% summarise(MonthDelivery = as.integer(sum(Revenue))) %>% arrange(…

Read More
What does %>% function mean in R?

I have seen the use of %>% (percent greater than percent) function in some packages like dplyr and rvest. What does it mean? Is it a way to write closure blocks in R?

Read More