Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

View() an entire dataset in RStudio (past 1000 row limit)

Tags:

r

Simple question but I can't figure it out in RStudio: View(mydata) only gives me 1000 rows.

How can I increase this limit to a number of my choosing? Say, like 25,000?

like image 292
user798719 Avatar asked Mar 05 '15 08:03

user798719


People also ask

How do I view a full dataset in R?

If you want to read the original article, click here View data frame in r: use of View() function in R. View data frame in r, within RStudio, the View() function in R can be used to call a spreadsheet-style data viewer. When using this function, make sure to use a capital “V”.

How many rows of data can RStudio handle?

As a rule of thumb: Data sets that contain up to one million records can easily processed with standard R. Data sets with about one million to one billion records can also be processed in R, but need some additional effort.

Does R have a row limit?

Similar to Excel, with Mac Numbers you'll see warning if you'r file exceeds 1,000,000 rows. This one can be misleading and catch you off-guard if you're dealing with large files. While they do not have a specific row limit, they do enforce a cell limit of 5 million cells.

How do I view rows in R?

R provides us nrow() function to get the rows for an object. That is, with nrow() function, we can easily detect and extract the number of rows present in an object that can be matrix, data frame or even a dataset.


1 Answers

It is not View() but also works in command-line R:

options(max.print=25000)

Printing is set to 25000 lines now.

like image 135
chakalakka Avatar answered Nov 14 '22 22:11

chakalakka