Articles by

Lists to Data.Frames with imap

February 16, 2022 |

When working with data which is a result of json-data converted to a list of lists of lists of lists … (you know what mean ;-)) I often want to convert it a data.frame. Unfortunately there’s often a list in the source data which is unnamed... [Read more...]

Accessing Snowflake with R

February 6, 2022 |

Snowflake is a well known cloud-based database. It’s used for Data Warehouses and other big data applications. In this article and the following ones I want to show how to setup and access a snowflake database from various clients such as R, Tableau and PowerBI. So let’s start ...
[Read more...]

Custom Formats in gt Tables

November 26, 2021 |

The “grammar of tables” is used to build tables with the R-package gt. Thomas Mock published an extension package called gtExtras which is used all over in tweets about NFL and Fantasy Football such as win and loss history information in a table. gt follows a similar philosophy such as ... [Read more...]

Working with tree-based hierarchies using data.tree

July 30, 2021 |

Lately I tried to visualize an hierarchy with Tableau Desktop. The problem was that the hierarchy had a variable depth because it was tree-based. Each row had an id and a parent_id. Normally hierarchies in Tableau are defined by pulling some fields together, such as product category, product group ... [Read more...]

Accessing PIWIK PRO from R

May 14, 2021 |

The main tool for tracking the action on a website is Google Analytics. But more and more websites switch to other tools such as Matomo or PIWIK PRO due to GDPR. My employer decided to switch to PIWIK PRO, too. So I was looking for a way to access the ... [Read more...]

Sorting German Numbers in DT datatable

April 22, 2021 |

DT::datatable() is a great way to show interactive tables in RMarkdown documents. (Unfortunately it’s a little bit tricky to use them with blogdown in combination with some hugo themes. But that’s another story.) The user can sort any column as he wants to. But it’s an ... [Read more...]

Splitting Linear Models

April 2, 2021 |

Last Thursday I watched Wolfgang Viechtbauer’s stream on Twitch. Wolfgang spoke about linear regression. (If you’re interested in the results: Wolfgang lists the R-code he wrote during the stream at
[Read more...]

Simple Prediction in SARS-CoV-2 Shiny App

February 27, 2021 |

I made another small update to my SARS-CoV-2 Shiny App. As the discussion in Germany about whether to open schools and shops starts again I was wondering how I could visualize a simple prediction of future infections. So I did the following simple appr...
[Read more...]

Updated SARS-CoV-2 Shiny App

January 22, 2021 |

I’ve updated my Shiny App slightly. Because of the appearence of the mutation B 1.1.7 I want to see the current R-value, the current reproduction rate of the virus per Landkreis or Bundesland. The scientists suspect that B 1.1.7 has a 50% higher...
[Read more...]

Anomaly Detection with Prophet

December 31, 2020 |

How to detect the unexpected? Is the behaviour of some measured value normal or did something unexpected happen? To answer these questions we need to detect anomalous behaviour in a time series. In this article I want to show you how we can do this wit...
[Read more...]

How to change datasources in Tableau

November 27, 2020 |

At work I’m using Tableau as a tool for visualizing data with the possibility for the user to filter the data he’s looking at. So the user doesn’t need to program. He can use just is mouse which is great for people who don’t know exactly ...
[Read more...]

Hosting a Shiny App using Docker

October 17, 2020 |

I used for my own shiny app. It’s a great service. You can deploy your app for free, test it and show it to other people. But there’s also a downside: The memory an app can use is limited. So I was looking for another way ... [Read more...]
1 2

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)