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

Question

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?

Are you using the plain RGui, or RStudio? I think the 1000 row limitation is built into RStudio, but they may increase it depending on demand from the community. See this SO post for more information: http://stackoverflow.com/questions/19341853/r-view-does-not-display-all-columns-of-data-frame — Tim Biegeleisen, Mar 05 '15 at 08:28
RStudio - Version 0.99.235 - has "infinite scroll", so you can view all the data. — zx8754, Mar 05 '15 at 08:40
@DavidArenburg see the answer, sorry, yes it is a preview version. — zx8754, Mar 05 '15 at 08:48

score 6 · Answer 1 · answered Mar 05 '15 at 09:34

6

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

options(max.print=25000)

Printing is set to 25000 lines now.

answered Mar 05 '15 at 09:34

chakalakka

464
2
9

score 4 · Accepted Answer · answered Mar 05 '15 at 08:45

4

RStudio preview version - Version 0.99.235 has "infinite scroll", so you can view all the data.

enter image description here

answered Mar 05 '15 at 08:45

zx8754

52,746
12
114
209

1

That is nice. You can now both filter and sort by each column too. – David Arenburg Mar 05 '15 at 09:02
@DavidArenburg Revamped code completion feature is great, too. – zx8754 Mar 05 '15 at 09:22

score 3 · Answer 3 · answered Mar 05 '15 at 09:03

3

utils::View(df) will print everything also in Rstudio (Though this is not using the native Rstudio viewer, we will have to wait for the next version of Rstudio for that)

answered Mar 05 '15 at 09:03

Rasmus Larsen

5,721
8
47
79

score 1 · Answer 4 · answered Mar 05 '15 at 08:37

I don't think it's possible to view more than 1000 rows at a time. However, if your goal is to view data beyond the 1000th row, you can subset your dataset, as follows:

View(df[2000:3000,]) # will show rows 2000-3000
View(df[5000:6000,]) # will show rows 5000-6000

score 1 · Answer 5 · edited Oct 05 '17 at 00:02

1

options(max.print=25000)
print.data.frame(<name_of_df>)

edited Oct 05 '17 at 00:02

lebelinoz

4,890
10
33
56

answered Oct 04 '17 at 20:34

G. Wrona

11
2

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

5 Answers5