David Gohel

@ckhead @antoine_fabri Because it lets you work with any DBMS and there's nothing else like it in #rstats. Does this SQL interface even exists in JS or python? I doubt it (even if I am not sure).

@antoine_fabri Why use dplyr?

#rstats with dplyr: You can: mtcars |> summarize(across(everything(), mean), .by = c(vs, am)) You can: mtcars |> group_by(vs, am) |> summarize_all(mean, .groups = "drop") You can't mtcars |> summarize_all(mean, .by = c(vs, am)) I don't like this at all

@romain_francois + annotate_cap(type = 'so_french')

@tanya_shapiro Quite cool!

#rstats package #flextable now supports RTF ardata.fr/en/post/2023/0…

@VarugheseDeepak @rstatstweet @lostgps and about ggplot2 syntax, it does not look very different from flextable IMO but I am certainly biaised :)

@VarugheseDeepak @rstatstweet @lostgps I don't think gt has a grid graphic output. you probably talking about webshot export but it does not resize accordingly to available space.

First post about #rstats flextable and 'grid Graphics': ardata.fr/en/post/2023/0…… proudly made by @lostgps and myself

@IsabellaGhement I am not part of the team, I don't know sorry.

@DavidGohel At least there is hope! Right now I am using a combination of officedown + captioner to get by, but hoping this would become easier. Any idea when this Quarto release is supposed to happen?

In Quarto, is it now possible to work with figure/table captions for Word documents and to automatically update and reference the figure/table numbers? If yes, links to references or examples would be appreciated. Thank you! #rstats

@IsabellaGhement No, waiting for the Quarto 1.4 for that :)

@DavidGohel David, I recall you were working on something like this. Any developments on this front?

@dtoher OK. Thanks, I am using the dev version of quarto

@DavidGohel Captions work to word for me (using Quarto 1.2 and knitr).

Suppose, in a #QuartoPub document, using #rStats I have a list of length G, each item in this list is a flextable - I need to use flextable as opposed to kable, to allow for output to docx. G is unknown apriori, but will be at least 1. Is there any way to create a (1/2)

@dtoher This won't work for now. Captions/crossref are not available yet in Quarto for Word, it applies to flextable, gt, etc. It does not work as there is no way to send this caption to quarto yet (in R Markdown or with usual R, not an issue).

sequence of tables with associated labels and captions that could be worked out dynamically/parsed? Manually, this can be done really easily (creating new labels etc) and knowing when to stop, but is there a way of automating this? (2/2)

Does anyone know what is happening with the #rstats CRAN updates? It seems that since Saturday, all packages that are submitted for an update are stuck in the 'pretest' folder.

@timelyportfolio Thank you, Kent. I should also thank you for all the work you did that I am often using :)

I can't thank @DavidGohel enough for the absolutely brilliant #rstats officer package. In my real job in a very constrained environment, I am working with R 3.8 (lots of pkgs not avail) & 5 year old RStudio ver. officer provides the publishing engine I need. Thanks David!!

@Dale_Masch @CEBuddenhagen Maybe you want parameter 'ft.arraystretch'

@CEBuddenhagen Flextable is what im using

#Rmarkdown wizards, is there a way to adjust the row heights on a table in pdf output?

#rstats funny side effect of having a 'grid graphics' output with #flextable - it can be used to add complex labels on #ggplot with 'patchwork' (code: gist.github.com/davidgohel/681…, you may have to change the fonts if not avail. on your machine)

@IsabellaGhement @thomas_mock @lostgps Thank you Isabella. It's working with quarto now (captions were the issue). not yet on CRAN... Quarto team is going to work on captions/docx, we'll adapt if necessary :) I don't think officedown has any reason to exist in quarto universe.

@DavidGohel @thomas_mock @lostgps Wow! This looks so nice, David! Just wondering - do you have any plans for integrating some of your other fabulous R packages (e.g., officer, officedown) with Quarto? Last I checked, they didn’t seem to work with Quarto.

It's Friday. Let's show off a new feature of #rstats flextable @lostgps and I developed. We have now a "grid graphic" output🥳, it works very well with ggplot2, cowplot and patchwork (only on GitHub for now). Code available here: gist.github.com/davidgohel/eae…

It can be resized, it adjusts to its container, text wrap, columns auto-adjustment, and many other options...

🚨big project launch🚨 today I’m launching my 2022 midterms forecast! As of today, Democrats are favored to keep the senate and Republicans are favored to flip the house - more deets below but you can find the full forecasts here: thedatadiary.net/senate/ thedatadiary.net/house/

@MickaelCanouil @datavisFriendly I don't think officedown would help here.

#rstats I'm looking for examples of using #quartopub to generate powerpoint slides. Something that goes a bit beyond just the basics, e.g., showing code and output on the same slide, tabsets, etc.