In today’s blog post, I’m showing you how to work with databases from within R. As always, you can find the video version of this blog post on YouTube: Establish a connection Let us start by setting up a database connection. library(odbc) lib... [Read more...]

[Read more...]

The R programming language has a rich ecosystem of packages that are fantastic for creating beautiful production-grade tables from within R. Today, I’m showing you that one package that makes it really easy (mostly) to create interactive tables. Namely, I’m going to show you {reactable}. 🥳 If you want ... [Read more...]

Real-world problem often happen at the intersection of many areas. For example, maybe you want to build a web app for easier data ingestion. As an R user that’s no problem. You can easily dabble into the world of web development using the fantast... [Read more...]

[Read more...]

library(tidyverse) ## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ── ## ✔ dplyr 1.1.4 ✔ readr 2.1.5 ## ✔ forcats 1.0.0 ✔ stringr 1.5.1 ## ✔ ggplot2 3.5.1 ✔ tibble 3.2.1 ## ✔ lubridate 1.9.3 ✔ tidyr 1.3.1 ## ✔ purrr 1.0.2 ## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ── ## ✖ dplyr::filter() masks stats::filter() ## ✖ dplyr::lag() masks stats::lag() ## ℹ Use the conflicted package () to force all conflicts to become errors library(reactable) counts filter(!is.na(sex)) |__ dplyr::count(species, ... [Read more...]

[Read more...]

[Read more...]

[Read more...]

Guten Tag! 👋 As data scientists we are judged by how quickly we can generate meaningful insights. But we’re often stuck with cleaning our data first. That’s bad. So that’s why I’m super excited to tell you that my new “Data Cleaning with R Master... [Read more...]

In this blog post I’m going to show you the six most fundamental functions for your data cleaning journey. And as always, you can watch the video version of this blog post on YouTube: Getting started All of these functions come from the tidyve... [Read more...]

[Read more...]

RStudio is the premier way to write R code. It is very user-friendly as it’s super easy to set up. But it also has a lot of pretty advanced features. In today’s blog post I’ll give you a list of my favorite RStudio tricks and shortcuts. If ... [Read more...]

[Read more...]

library(tidyverse) library(giscoR) library(ggiraph) germany_districts as_tibble() |__ janitor::clean_names() germany_states as_tibble() |__ janitor::clean_names() ggplt ggplot(aes(geometry = geometry)) + geom_sf( data = germany_states, aes(fill = nuts_name), color = 'black', linewidth = 0.5 ) + geom_sf_interactive( fill = NA, aes( data_id = nuts_id, tooltip = glue::glue(... [Read more...]

[Read more...]

Quarto is a great tool to create all kinds of documents from the same source code. But it’s notation can sometimes feel random and confusing. For example, if you’ve ever wondered why you had to use ::: {.panel-tabset} ## Panel 1 ## Panel 2 ::... [Read more...]

[Read more...]

There are two major systems to align things in CSS. These are flexbox and grid layout. Both of them are really useful to know to have any chance to make nice websites or app. And today we’re going to focus on flexbox. And as always, if you want to ... [Read more...]

[Read more...]