olivroy

olivroy, 26 days ago to random

A new release of RStudio dropped this week!! A lot of bug fixes and hard work over the last few months. For me, the highlights are the improvements to the Git pane, the completion for ggplot2 aesthetics, help for S3 methods, help available when package loaded via devtools. I had the chance to contribute some (very) minor features. Special thanks to @kevinushey and @ronblum for their kindness and responsiveness! #rstats https://posit.co/blog/rstudio-2024-04-0-whats-new/

josi, 8 months ago to random

How would #rstats users feel if a function returned a data.frame if tibble wasn't installed. Otherwise always returned a tibble?

olivroy, 8 months ago to random

Watching #PositConf2023 online. Which talk are you most excited for? #rstats

grrrck, 8 months ago to random

I just discovered that quarto slides have a "shuffle" mode and now I'm contemplating presenting at posit conf in chaos mode

olivroy, 9 months ago to Excel

Do almost anything from R in Excel with openxlsx2 https://janmarvin.github.io/openxlsx2/index.html #rstats #openxlsx2 #excel #blog https://olivroy.quarto.pub/creating-cool-xlsx-files-with-openxlsx2-10/ @rweekly

Code: library(openxlsx2) # create a workbook from scratch wb <- wb_workbook(title = "A demo workbook") wb <- wb_add_worksheet(wb, sheet = "my data") # start writing a banded data table from the B2 cell. wb$add_data_table(x = mtcars, dims = "B2", banded_rows = TRUE, table_style = "TableStyleLight16") # use Excel's dimensions for mtcars # As we want to write mtcars starting in cell B2 # It helps keeping the cells relative to x. (the data) f_dims <- function(..., select = NULL) { wb_dims(x = mtcars, from_row = 2, from_col = "B", ..., select = select) } # Add data bars to the mpg column wb <- wb |> wb_add_conditional_formatting(dims = f_dims(cols = "mpg"), type = "dataBar") wb$add_conditional_formatting(dims = f_dims(cols = "vs"), rule = "=0") # Modify column names appearance wb$add_fill(dims = f_dims(select = "col_names"), color = wb_color("black")) wb$add_font(dims = f_dims(select = "col_names"), color = wb_color("white"), size = 13, bold = TRUE) # modify data appearance (not column names) wb$add_font(dims = f_dims(select = "data"), italic = TRUE) wb$open()