Designing tables in R with "knitr" and "kableExtra" | R Tutorial (2021)

Sorry for the weird audio on this one. I noticed during the editing process that it sounds a little off in spots. I hope it's not too distracting.
Subscribe to RichardOnData here: / @richardondata
Patreon: / richardondata
GitHub: github.com/Ric...
I strongly recommend watching my tutorial on R Markdown before this one. It can be found here: • Intro to R Markdown | ...
In a previous tutorial, we saw R Markdown in action, where multiple things can be created in one location: code, commentary, and output. A point I made towards the end is that formatting tables can be an area requiring lots of focus in and of itself! For example, calling a tibble is going to look very different than when it is passed through the "kable" function from the "knitr" package. In this tutorial we will also explore another package which will facilitate the creation of presentation-worthy tables: "kableExtra".
A tutorial on "knitr": sachsmc.github...
"kableExtra" vignette: cran.r-project...
A "formattable" tutorial: www.displayr.c...
PayPal: [e-mail]
Patreon: / richardondata
BTC: 3LM5d1vibhp1F7pcxAFX8Ys1DM6XLUoNVL
ETH: 0x3CfC599C4c1040963B644780a0E62d45999bE9D8
LTC: MH8yPjvSmKvpmRRmufofjRB9hnRAFHfx32

[@rezzyraptor]

Thanks so much for making this, it helped me a lot. I had to refer back to it several times. You explain things very clearly.

[@RichardOnData]

Thank you!

[@uppulamramu2302]

The information you are sharing is very useful to me to do project. Thank you for giving this wonderful lecture.👍

[@lordbebech]

Thank you so much, this video helped me a lot to learn kable package

[@pabliux3008]

Thanks for sharing this awesome tutorial, Richard!

[@siosaiavaihola3252]

I was looking for this and found it, thanks Richard.

[@siosaiavaihola3252]

Sir when I do data %>%
kbl() the result just showed briefly (few seconds in white background) then disappeared. I was doing it in rmarkdown. Why was this Sir ? thanking you in advance.

[@brunaalbuquerque9316]

THIS LOOKS SUPER AWESOME! THANKSSS A LOT

[@mocabeentrill]

Thank you for this tutorial. Very helpful

[@mariaangelicacastelblanco196]

Thanks for your video. It's what I was looking for :)

[@RichardOnData]

Glad I could help!

[@matiasrichetta728]

Very useful information! Thanks for the video!

[@RichardOnData]

My pleasure!

[@kar2194]

Really appreciate your content. Thank you

[@RichardOnData]

You are most welcome; glad to have you!

[@arash4232]

Hi,
That was grate, thank you.
Do you have any suggestion for the case that colour code is shown instead of the colourfull text in a markdown table, please?
I need the maximum in a specific column be coloured, not more.
Thank you.

[@tuhocr]

thanks for helpful video!

[@OpenSourceAgriculture]

This guy is super ~~**E.X.T.R.A**~~

[@hypercortical7772]

You should do a textbook video. especially if you still have physical textbooks from when you did your Masters.

[@RichardOnData]

This is an excellent idea. There's a couple good ones and a couple highly overrated ones that I think are worth talking about it!

[@ahmed007Jaber]

Thank u for this Richard
Got any idea how to spread/split a long table across slides?
Been searching for this for couple of weeks now

[@yaoliao3517]

Really good. Thank you

[@RichardOnData]

My pleasure!

[@harshithabondhuchandrashek8895]

How to decrease the size of the column?

Great video! I have a question, ¿how could I use these formats with the output of a function, e.g. summary of an Lm object?. Thanks in advance

[@RichardOnData]

The summary of an lm() object can be converted into a tidy format very easily with the "broom" package. I've got a video on "tidying and interpreting linear model output" that could help!

@@RichardOnData Thanks so much for your answer!! I´ll watch the video!!

[@kamarelba7717]

Hi Richard ! Very nice tutorial ! Congrats. However I have a question: how to add automatic caption like Table 1, Table 2, so on to our kbl() function ? It seems it only handle the caption and not the numbering !

[@vincenzo4259]

Thanks

[@matiasramirez8443]

when I knit when using kable_material_dark it isn't displayed dark in the PDF, is it normal?

[@WhiteGaming5883]

very helpful video.. but i do have further questions regarding something like the data bar under conditional formatting like the one in excel.. do you know how can i do it in groups or sub groups per column??

[@patricior7300]

Hi Richard! Is there an option to format the numbers? For example numbers without decimals and add the comma of thousands and millions? Thank you! We miss you man. Where have you been?

[@ChrisRHughes]

Honestly still haven't seen anyone demonstrate how to change the color of the caption directly in R.....