displaying all the rows and columns of tibble in R-markdown

Question

I'm working on an R markdown file. The results of analysis are shown in the form of tibble but in order to see all the columns and rows, I need to click to expand. However, since I'm going to knit the file into html, I need to display all the columns and rows in the R markdown file. I did a search and came up with the following codes:

options(tibble.width = Inf) # displays all columns.
options(tibble.print_max = Inf) # to show all the rows.

However, I don't know where to put them. I placed them before and after my code, but it didn't work. MY codes are:

head(df)
summarise(mean_cov= ..., median_cov=...., sd_cov=...., ...)

Thanks.

Is widening also possible for only a single column? I'm fine with some columns being collapsed, but a specific one contains an identifier which needs to be fully available for copy-pasting in the .md output. — Katrin Leinweber, Oct 24 '19 at 13:11
I think the answer in [this question](https://stackoverflow.com/questions/40893742/r-markdown-df-print-options) is relevant. Essentially set `{r rows.print = n}` in your code chunk header. — Mxblsdl, Jun 20 '20 at 17:33

moodymudskipper · Answer 1 · 2017-10-28T21:54:18.383

12

a tibble is a specific type of data.frame (try class(df)), and it has its own method to print, which is frustrating when you want the full thing.

As it's still a data.frame though you can use the method for data.frames and it will print everything, try:

print.data.frame(df)

or

print.data.frame(head(df))

or

print.data.frame(summarize...)

Note that as.data.frame will have the same output

edited Oct 28 '17 at 21:54

answered Oct 28 '17 at 21:40

moodymudskipper

46,417
11
121
167

But the problem is that I want to see all the columns but only first few rows when using the head() function, and I want to see all the columns and rows when using the summarise() function. – Oct 28 '17 at 21:50
just wrap them into a `print.data.frame` statement, see updated answer – moodymudskipper Oct 28 '17 at 21:54
if still not clear please update your post with a reproducible example (input and expected output), this always makes things much easier – moodymudskipper Oct 28 '17 at 21:55
When I wrap it, I get the following error: Error: This function should not be called directly – Oct 28 '17 at 22:38
This is why we need the reproducible examples ;) – moodymudskipper Oct 28 '17 at 22:45
Yeah, but you don't have access to the data. Right? – Oct 28 '17 at 22:56
https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example – moodymudskipper Oct 28 '17 at 23:04
This doesn't work. The problem he's experiencing isn't caused by tibble, its caused by rmarkdown deciding to show only the first x rows. – Bob Feb 20 '18 at 02:58
3

This is why we need reproducible examples – moodymudskipper Feb 20 '18 at 07:11

score 7 · Answer 2 · answered Oct 28 '17 at 23:27

7

print(your_tbl, n = 1e3)

or

your_tbl %>% print(n = 1e3)

Replace n with a number larger than the max number of rows you'll encounter. (And hopefully 1e3 = 1000 will do, since a table with even 100 rows is pretty hard to understand by eye.)

answered Oct 28 '17 at 23:27

mmuurr

1,310
1
11
21

Same problem as the other answer. – Bob Feb 20 '18 at 02:58

score 0 · Answer 3 · edited Jul 23 '20 at 16:42

0

Or you can also use View(df) to see the data in spreadsheet format.

edited Jul 23 '20 at 16:42

Peter

11,500
5
21
31

answered Jul 23 '20 at 14:08

mschiffm

26
2

score -1 · Answer 4 · answered Sep 13 '20 at 04:29

-1

try head(data.frame(df)), head(data.frame(df), 40), head(data.frame(df), 40) etc

answered Sep 13 '20 at 04:29

Dawit

1

displaying all the rows and columns of tibble in R-markdown

4 Answers4

Linked