Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Possible to print more than 100 rows of a data.table?

The data.table has a nice feature that suppresses output to the head and tail of the table.

Is it possible to view / print more than 100 rows at once?

library(data.table) ## Convert the ubiquitous "iris" data to a data.table dtIris = as.data.table(iris) ## Printing 100 rows is possible dtIris[1:100, ] ## Printing 101 rows is truncated dtIris[1:101, ] 

I often have data.table results that are somewhat large (e.g. 200 rows) that I just want to view.

like image 889
geneorama Avatar asked Aug 28 '12 15:08

geneorama


People also ask

How do I print all Tibble rows?

Extending @BLT's answer, you can set n = Inf to print all rows. print (with a tibble) also has the width = and n_extra = options to control how many columns are printed, either directly or indirectly.

How do I print a dataset in R?

Every language provides some functions that can help you print the data on the console, and R is no different. To print the data on the console in R, use the print() function.


2 Answers

The print method of data.table has an argument nrows:

args(data.table:::print.data.table) function (x, nrows = 100L, digits = NULL, ...)  

You can use this to control how many rows get printed:

print(dtIris, nrow=105) ..... 99:          5.1         2.5          3.0         1.1 versicolor 100:          5.7         2.8          4.1         1.3 versicolor 101:          6.3         3.3          6.0         2.5  virginica 102:          5.8         2.7          5.1         1.9  virginica 103:          7.1         3.0          5.9         2.1  virginica 104:          6.3         2.9          5.6         1.8  virginica 105:          6.5         3.0          5.8         2.2  virginica      Sepal.Length Sepal.Width Petal.Length Petal.Width    Species 
like image 114
Andrie Avatar answered Sep 24 '22 13:09

Andrie


View() (as in View(iris) or View(dtIris[1:120,])) doesn't truncate data.tables, and can often be nicer than printing/spewing out a data.* to the console.

like image 37
Josh O'Brien Avatar answered Sep 21 '22 13:09

Josh O'Brien