View a large dataset in the R console

Question

Is there a way to view a large data set [1380160 obs. of 44 variables] completely on the R console?

I changed the print limit using options(max.print=...) , however I do not see the complete data set, that is, to the right of the first line to the last, since there is no way to scroll through the data.

Answer 1

Use the View function (pay attention to capitol 'V'), it will open a data frame, matrix or other object like a table in a new window in a spreadsheet style format that can be scrolled to view data (but not editing). This window does not depend on the console, so you can continue to issue commands without closing the view window (however, changes to the data object will not appear in the view window, you will need to close the window and run View again to see the changes).

If you want to edit data in a spreadsheet, such as a window, use edit or fix (but you cannot run other commands with them until you close the editing window).

Some of the GUIs for R also have tools for viewing or editing scrolling data objects.

Answer 2

Two options:

 df <- data.frame(X = rpois(n = 100, lambda = 3), Y = rnorm(n = 100, mean = 25, sd = 7)) page(x = df, method = "print") View(x = df , title = "My test data") 

Answer 3

This is an old question, however I had the same problem. I believe that the View data set in Rcmdr is well suited for viewing large data sets. It shows all the data (in any window).

 library(relimp, pos=35) showData(Dat, placement='-20+200', font=getRcmdr('logFont'), maxwidth=80, maxheight=10)