Hello All,
As i am a newbie in R so most of you would have seen this question zillion
times. I searched for the answer on this forum as well on other various
forums however could not find the answer i am looking for.
I am dplyr package and used a very basic code:
select(june,city,state,mod)
The data sheet i am using has more than 3 million observations but the
console does not print all of them and show only few options and give a
message:
[ reached getOption("max.print") -- omitted 376341 rows ]
What is the option that i need to add to see all values in the output.
Similarly once i scroll down and then if i scroll up i am not able to see
the values starting from row #1. Please suggest
--
View this message in context:
http://r.789695.n4.nabble.com/Output-In-R-tp4711227.html
Sent from the R help mailing list archive at Nabble.com.
?write.csv and look at with the editor of choice. On Tue, Aug 18, 2015 at 6:41 AM, Shivi82 <shivibhatia at ymail.com> wrote:> Hello All, > > As i am a newbie in R so most of you would have seen this question zillion > times. I searched for the answer on this forum as well on other various > forums however could not find the answer i am looking for. > > I am dplyr package and used a very basic code: > select(june,city,state,mod) > > The data sheet i am using has more than 3 million observations but the > console does not print all of them and show only few options and give a > message: > [ reached getOption("max.print") -- omitted 376341 rows ] > > > What is the option that i need to add to see all values in the output. > Similarly once i scroll down and then if i scroll up i am not able to see > the values starting from row #1. Please suggest > > > > -- > View this message in context: > http://r.789695.n4.nabble.com/Output-In-R-tp4711227.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >[[alternative HTML version deleted]]
That's a very odd request: surely you would not want to visually inspect 3
million rows in the console?
Typically one would assign the (large) results of a function to a variable for
further processing. If you need to inspect the beginning and end of your
dataset, use head() and tail().
Try getOption("max.print") to see what it is set to: it's a large
and reasonable value, remember your console uses memory and at some point it
needs to truncate the values you store in the console, to stay within its
allotted memory. You can change the "max.print" option, but I
can't see how that would be reasonable.
Cheers,
Boris
On Aug 18, 2015, at 8:41 AM, Shivi82 <shivibhatia at ymail.com> wrote:
> Hello All,
>
> As i am a newbie in R so most of you would have seen this question zillion
> times. I searched for the answer on this forum as well on other various
> forums however could not find the answer i am looking for.
>
> I am dplyr package and used a very basic code:
> select(june,city,state,mod)
>
> The data sheet i am using has more than 3 million observations but the
> console does not print all of them and show only few options and give a
> message:
> [ reached getOption("max.print") -- omitted 376341 rows ]
>
>
> What is the option that i need to add to see all values in the output.
> Similarly once i scroll down and then if i scroll up i am not able to see
> the values starting from row #1. Please suggest
>
>
>
> --
> View this message in context:
http://r.789695.n4.nabble.com/Output-In-R-tp4711227.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
Shivi82 <shivibhatia at ymail.com> writes:> Hello All, > > As i am a newbie in R so most of you would have seen this question zillion > times. I searched for the answer on this forum as well on other various > forums however could not find the answer i am looking for. > > I am dplyr package and used a very basic code: > select(june,city,state,mod) > > The data sheet i am using has more than 3 million observations but the > console does not print all of them and show only few options and give a > message: > [ reached getOption("max.print") -- omitted 376341 rows ] > > > What is the option that i need to add to see all values in the output. > Similarly once i scroll down and then if i scroll up i am not able to see > the values starting from row #1. Please suggestYou need to sharpen your searching skills. The first result of looking for r max.print via a well-known search engine is a question on StackOverflow. One of the answers given there is to set the value of max.print in the following manner: options(max.print=999999) I'll leave finding the appropriate value as an exercise for the reader. Cheers, Loris -- This signature is currently under construction.
I would suggest that instead of trying to view all the results in the console that you save the result into a object then use the View (note the capitol V) function to be able to scroll through the results. The head and tail functions have already been mentioned and I second their use for a quick view. Since you are already using dplyr you should look at the slice (and possibly filter) function for another way to display pieces of the resulting object. On Tue, Aug 18, 2015 at 6:41 AM, Shivi82 <shivibhatia at ymail.com> wrote:> Hello All, > > As i am a newbie in R so most of you would have seen this question zillion > times. I searched for the answer on this forum as well on other various > forums however could not find the answer i am looking for. > > I am dplyr package and used a very basic code: > select(june,city,state,mod) > > The data sheet i am using has more than 3 million observations but the > console does not print all of them and show only few options and give a > message: > [ reached getOption("max.print") -- omitted 376341 rows ] > > > What is the option that i need to add to see all values in the output. > Similarly once i scroll down and then if i scroll up i am not able to see > the values starting from row #1. Please suggest > > > > -- > View this message in context: http://r.789695.n4.nabble.com/Output-In-R-tp4711227.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.-- Gregory (Greg) L. Snow Ph.D. 538280 at gmail.com
HI Boris,
The reason i want to see or show 3 million rows in console is that i need to
present it to a business user.
So here my end objective is to present the final output to the business
user. So lets say when i write a code:
select(june,waybill:type,contains("sfxcode")) so here there could be
multiple instances where sfx code could appear which will not accommodate in
console. I tried using max print option and increased to (max.print=999999)
but still only shows few rows of data.
What other option to i have. Thanks.
--
View this message in context:
http://r.789695.n4.nabble.com/Output-In-R-tp4711227p4711263.html
Sent from the R help mailing list archive at Nabble.com.
Hi Loris, I have already tried options(max.print=999999) but does not show the desired result. As posted above it want to share the outcome with the business owner where there could be multiple entries. -- View this message in context: http://r.789695.n4.nabble.com/Output-In-R-tp4711227p4711264.html Sent from the R help mailing list archive at Nabble.com.