similar to: Package recommendations for outputting table with cell formatting

Will this need to be done many times? If not, it might be just as easy to apply conditional formatting to cells after they're already in Excel. On Fri, Oct 23, 2020 at 8:28 PM Dennis Fisher <fisher at plessthan.com> wrote: > > R 4.0.2 > OS X > > Colleagues > > I have the unfortunate need to create a large number of tables (destined for a Word document). I need to

To John and everyone else, Please add Hmisc::latex to your how-to-make-beautiful-tables-in-r document. We first included latex() in S in 1995, and it is still actively maintained and improved. Rich Here are the first few lines of ?latex Convert an S object to LaTeX, and Related Utilities Description: ?latex? converts its argument to a ?.tex? file appropriate for inclusion in a

This comes with no guarantee since i have only tried one or two packages mentioned but have a look at <a href=" https://rfortherestofus.com/2019/11/how-to-make-beautiful-tables-in-r/"> R Tables</a>. On Fri, 23 Oct 2020 at 20:28, Dennis Fisher <fisher at plessthan.com> wrote: > R 4.0.2 > OS X > > Colleagues > > I have the unfortunate need to create a

OS X R 4.3.1 Colleagues I often create multipage PDFs [pdf()] in which the text "Page X" appears in the margin. These PDFs are created automatically using a massive R script. One of my clients requested that I change this to: Page X of XX where XX is the total number of pages. I don't know the number of expected pages so I can't think of any clever way to do this. I

R 4.2.3 OS X Colleagues, I am printing a large number of tables using the print command. A simple example is: print(data.frame(COL1=1:5, COL2=10:6)) The result in this case is: COL1 COL2 1 1 10 2 2 9 3 3 8 4 4 7 5 5 6 I would like to print the table WITHOUT the row numbers: COL1 COL2 1 10 2 9 3 8 4 7 5 6 Is there any simple

Colleagues, I am using R (2.9.2, all platforms) to search for a complicated text string using regular expressions. I would appreciate any help you can provide. The string consists of the following elements: SOMEWORDWITHNOSPACES any number of spaces and/or tabs ( any number of spaces and/or tabs integer any number of spaces and/or tabs ) Examples include: WORD ( 123 ) WORD(1 )

Colleagues R 2.10.1 on a Mac I read in textfiles using readLines, then I process those files, then I use R to execute another program. Occasionally those files contain characters other than letter / numbers / routine punctuation marks. For example, a bullet (option-8 on a Mac) triggers the problem. Although R can read and process those characters, the other program cannot so I would like to

R 4.2.2 OS X Colleagues A file that I have read includes strings like this: "EVENT ? 30 sec" When I include the string in a graphic using: mtext(STRING, ?) it appears as: "EVENT ... 30 sec" Is there a simple work-around (short of reformatting all the strings, then using plotmath)? Dennis Dennis Fisher MD P < (The "P Less Than" Company) Phone / Fax:

R 2.12.2 Windows 7 Colleagues, I just took advantage of the function: readWindowsShortcut in R.utils. It accomplished my goals and I was interested in learning its inner workings. So, I typed the function at the command line (without arguments or parentheses). R returned: function (...) UseMethod("readWindowsShortcut") <environment: namespace:R.utils> providing no

Colleagues I am learning lattice graphics (R 2.12.2; OS X). Several days ago, I inquired about adding margin text to lattice graphics. Jim Price offered a useful reply, suggesting that I add: page = function(page) grid.text('words', x = 0.5, y = 0.01) to my call to the function. The entire function that he suggested was; xyplot(1 ~ 1, par.settings = list(layout.heights =

Colleagues, I have created a list in the following manner: TEST <- list(c("A1", "A2"), c("B1", "B2"), c("C1", "C2")) I now want to delete one element from the list, e.g., the third. The command TEST[[3]] yields (as expected): [1] "C1" "C2" The command TEST[[-3]] yields: Error:

Colleagues Assume that I have a vector containing some text strings, some of which contain a particular character. I could like to apply "toupper" to the text before the character. For example (in this case, "|" is the particular character): ORIGINAL: TEXT <- c("aaaa", "bbb|cc", "|ddd") AFTER APPLICATION OF toupper: TEXT <-

Colleagues, I have some text: TEXT <- c("a", "bb;ccc", "dddd;eeeee;ffffff") I want to retrieve the portion of each element before the first semicolon. I can split each element using strsplit: SPLIT <- strsplit(TEXT, ";") This yields: > SPLIT [[1]] [1] "a" [[2]] [1] "bb" "ccc" [[3]] [1] "dddd"

R 3.4.2 OS X Colleagues I would appreciate some help with regular expressions. I have string that looks like: " ITERATION ,THETA1 ,THETA2 ,THETA3 ,THETA4 ,THETA5 ,THETA6 ,THETA7 ,SIGMA(1,1) ,SIGMA(2,1) ,SIGMA(2,2)? In the entries that

Luke Thanks ? I revised the code to: ERRORMESSAGE <- try(source(USERSCRIPTFILE, local=T), silent=T) print(ERRORMESSAGE) now returns: $value [1] 0 $visible [1] FALSE Not clear what to make of that. Dennis Dennis Fisher MD P < (The "P Less Than" Company) Phone / Fax: 1-866-PLessThan (1-866-753-7784) www.PLessThan.com > On Feb 22, 2018, at 12:45 PM, luke-tierney at

Colleagues During the transition to R3.0.0 (OS X), one of the packages that I used -- SASxport -- did not work until I used the "type=source" option in install.packages. This led to an adventure: 1. I downloaded the package source: SASxport_1.2.4.tar.gz 2. in the SASxport/R folder, I found all the functions that are part of the package. I became interested in whether I could

Colleagues, Hopefully a simple problem: I want to delete a column with a known name from a dataframe. I could write: FRAME <- FRAME[, names(FRAME) != NAMETODELETE] or FRAME <- FRAME[, !names(FRAME) %in% c(NAME1, NAME2, ETC)] Is there some simpler means to accomplish this? Dennis Dennis Fisher MD P < (The "P Less Than" Company) Phone: 1-866-PLessThan (1-866-753-7784)

Colleagues, I want to create the following array: "A1", "A2", "A3", "B1", "B2", "B3", "C1", "C2", "C3" I recall that there is a trick using "c" or "paste" permitting me to form all combinations of c("A", "B", "C") and 1:3. But, I can't recall the

Colleagues: I have encountered the following situation: SERIES OF COMMANDS source("File1") MORE COMMANDS source("File2") Optimally, I would like File1 and File2 to be merged into a single file (FileMerged). However, if I wrote the following: SERIES OF COMMANDS source("FileMerged") MORE COMMANDS I encounter an error: the File2 portion of FileMerged

Colleagues, R 2.9.0 on all platforms I have a dataset that contains three columns of interest: ID's, serial elapsed times, and a marker. Representative data: Subject Time Marker 1 100.5 0 1 101 0 1 102 1 1 103 0 1 105 0 For each subject, I would like to find the time associated with MARKER == 1, then replace Time with Time - (Time[Marker == 1]) The result for this