Use {janitor} to clean Excel files with R

[@ehoumanevans4783]

Dear Albert, thank you for your presentation on Janitor, was quite useful. Please, I would like to know how rendering and avoid result in the document but display it only in the console as you did.
It is very convenient indeed.
thank you

[@rappa753]

You can activate that in any quarto doc using the little cogwheel symbol at the top of the quarto page window

[@ac6852]

So glad I came across your video because this is so helpful and useful! The `excel_numeric_to_date()` function literally blew my mind. I always had a hard time with those!! Thanks for this! Also, what keyboard shortcut do you use to pull up the documentation so quickly instead of doing `?[function]`. Such a neat trick!

[@rappa753]

Glad that you like it ☺ And clicking on a function name and pressing F1 will do that for you :)

[@ac6852]

@@rappa753 yay, thanks for that! Do you have any plans to do a course on data processing? I feel like the way you clean your data is so efficient and would love to learn more about your best practices!

[@rappa753]

@@ac6852 Yup that's actually something I'm currently cooking up. Typically, I announce these kind of things first on my e-mail newsletter: 3mw.albert-rapp.de/

[@ac6852]

@@rappa753 Yay! Can't wait to take. Subscribed!

[@Tyler-ei2ec]

Nice blog. I found the recent article on using colors more efficiently in ggplot2 useful

[@rappa753]

Thank you, Tyler. Glad that I could help :)

[@timmytesla9655]

Thank you for this great content.

[@rappa753]

You're welcome, Timmy. Glad that you like it :)

[@abdullahimakama4819]

Great content 👍