R-helpers: I need some references for formatting the display of my data frame columns. Any guidance will be appreciated. Bruce ~~ I have a date frame with one column as an integer for which I want a comma display, one column consisting of dollar amounts, one column for which I want a display to two digits after the decimal point, and one column as integers ranging between 100 - 999.
Hi Bruce,
display as in the console or as a table for presentation?
For the latter, look at sprintf:
sprintf("%,1f", 1)
sprintf("%.2f", 2.5678)
sprintf("$%.3f", 2.5678)
HTH
Ulrik
On Fri, 5 May 2017 at 14:08 Bruce Ratner PhD <br at dmstat1.com> wrote:
> R-helpers:
> I need some references for formatting the display of my data frame columns.
> Any guidance will be appreciated. Bruce
> ~~
> I have a date frame with one column as an integer for which I want a comma
> display,
> one column consisting of dollar amounts, one column for which I want a
> display to two digits after the decimal point, and one column as integers
> ranging between
> 100 - 999.
>
> ______________________________________________
> 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]]
Data frames are primarily data storage objects, not data display objects. You can create a separate version of your data frame with formatted text strings, but what you usually really want is to handle column alignment as well and that really has to be addressed as part of your data output process, which you have said nothing about. Do you know about HTML or markdown or LaTeX? These are useful formats for creating reproducible research, and they are well supported through the knitr package and in RStudio via Rnw and Rmd files. Tables in particular are well supported via LaTeX with the tables package. The ReporteR package can output to Microsoft Word files directly with various formatting options, but it doesn't play well with the other tools. -- Sent from my phone. Please excuse my brevity. On May 5, 2017 5:08:19 AM PDT, Bruce Ratner PhD <br at dmstat1.com> wrote:>R-helpers: >I need some references for formatting the display of my data frame >columns. >Any guidance will be appreciated. Bruce >~~ >I have a date frame with one column as an integer for which I want a >comma display, >one column consisting of dollar amounts, one column for which I want a >display to two digits after the decimal point, and one column as >integers ranging between >100 - 999. > >______________________________________________ >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.
Ulrik: Thanks for reply. I obviously new to R, so I feel if the output on the console looks right I'm half way through my problem. I know it's not WYSIWYG, but it's a quasi start. Thanks. Bruce ______________> On May 5, 2017, at 8:56 AM, Ulrik Stervbo <ulrik.stervbo at gmail.com> wrote: > > Hi Bruce, > > display as in the console or as a table for presentation? > > For the latter, look at sprintf: > > sprintf("%,1f", 1) > sprintf("%.2f", 2.5678) > sprintf("$%.3f", 2.5678) > > HTH > Ulrik > >> On Fri, 5 May 2017 at 14:08 Bruce Ratner PhD <br at dmstat1.com> wrote: >> R-helpers: >> I need some references for formatting the display of my data frame columns. >> Any guidance will be appreciated. Bruce >> ~~ >> I have a date frame with one column as an integer for which I want a comma display, >> one column consisting of dollar amounts, one column for which I want a display to two digits after the decimal point, and one column as integers ranging between >> 100 - 999. >> >> ______________________________________________ >> 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]]
Jeff: Thanks for reply. I will follow your lead. Thanks. Bruce ______________> On May 5, 2017, at 9:15 AM, Jeff Newmiller <jdnewmil at dcn.davis.ca.us> wrote: > > Data frames are primarily data storage objects, not data display objects. You can create a separate version of your data frame with formatted text strings, but what you usually really want is to handle column alignment as well and that really has to be addressed as part of your data output process, which you have said nothing about. > > Do you know about HTML or markdown or LaTeX? These are useful formats for creating reproducible research, and they are well supported through the knitr package and in RStudio via Rnw and Rmd files. Tables in particular are well supported via LaTeX with the tables package. The ReporteR package can output to Microsoft Word files directly with various formatting options, but it doesn't play well with the other tools. > -- > Sent from my phone. Please excuse my brevity. > >> On May 5, 2017 5:08:19 AM PDT, Bruce Ratner PhD <br at dmstat1.com> wrote: >> R-helpers: >> I need some references for formatting the display of my data frame >> columns. >> Any guidance will be appreciated. Bruce >> ~~ >> I have a date frame with one column as an integer for which I want a >> comma display, >> one column consisting of dollar amounts, one column for which I want a >> display to two digits after the decimal point, and one column as >> integers ranging between >> 100 - 999. >> >> ______________________________________________ >> 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. >
Jeff:
I cannot install the ReporteR package. Is there a work-around, or is the
error message correct?
Thanks. Bruce
R> install.packages("ReporteR") Installing package into
?C:/Users/BruceRatner/Documents/R/win-library/3.3? (as ?lib? is
unspecified) Warning in install.packages :
package ?ReporteR? is not available (for R version 3.3.3)
Jeff Newmiller wrote:> Data frames are primarily data storage objects, not data display objects.
You can create a separate version of your data frame with formatted text
strings, but what you usually really want is to handle column alignment as well
and that really has to be addressed as part of your data output process, which
you have said nothing about.
>
> Do you know about HTML or markdown or LaTeX? These are useful formats for
creating reproducible research, and they are well supported through the knitr
package and in RStudio via Rnw and Rmd files. Tables in particular are well
supported via LaTeX with the tables package. The ReporteR package can output to
Microsoft Word files directly with various formatting options, but it
doesn't play well with the other tools.