CODEWITHSUNDEEP
rr-markdownknitrkableextraflextable
markhogue
markhogue

Reputation: 1179

Format R Markdown output so that it can be copied and pasted to twitter

Trying to do daily reports with Rmarkdown on covid-19 data. Want to tweet top 10 values from tables, but the options tried so far leave no spaces - tabs are erased when the tweet button is pushed. Have tried {kableExtra} with html output and {flextable} with word output, but when copied and pasted, the column separations are 'disappearing' tabs.

Does anyone have any recommendations on how to obtain a table with spaces or commas between columns?

Example Rmarkdown script is here, if interested, but the question is meant to be general and not require looking at the script.

Upvotes: 0

Views: 862

Answers (1)

Steffen Moritz
Steffen Moritz

Reputation: 7730

How about creating a picture of the table (which looks quite good then).

You could do this like this:

library("knitr")
library(kableExtra")
knitr::kable(mtcars, "latex") %>%
  kableExtra::kable_styling(latex_options = "striped") %>%
  kableExtra::save_kable("test.png")

Or does this have any downsides you don't want?

Addition: Alright, I didn't look at your file - seems you want to add 4 tables but not copy 4 images.

Short question here - isn't this then quite hard with the 280 char limit of twitter...?

But what you could do is the following:

```{r, echo = F}

aa <- knitr::kable(head(mtcars[, 1:4]), "pipe")
for (i in 1:length(aa)) {
   aa[i] <- gsub(" ", ",", aa[i])
   aa[i] <- paste(aa[i], "\n")
}
aa
```

In your code chunk save the table to a variable. This will then just be a table in markdown format. Now you can parse through and replace and alter chars how you need it.

Upvotes: 1

Related Questions