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...]

[Read more...]

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...]

Last weekend I fixed some issues with my R-package piwikproR The new version 0.3.1 is now available at CRAN So let’s have a look at the changes: The main change is that you now can fetch DateTime values from PIWIK PRO when you are using the API-e... [Read more...]

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...]

[Read more...]

[Read more...]

Lately R version 4.1.0 was released on CRAN (see https://cran.r-project.org). The MacOS version was one day late. But yesterday it was released, too. So I wanted to test the new version without being able to go back. “No problem”, I thought... [Read more...]

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...]

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...]

[Read more...]

[Read more...]

I’m working on an R-package to access the data of a web service. So I have to handle large data I get back from an API call. The result is encoded in JSON-format which itself results in a large list of lists (of lists). But I want to convert ... [Read more...]

[Read more...]

Lately I’ve had the problem that ggplot2-plots were missing in my blogdown-posts. I discovered that this problem only occurs when I used .Rmarkdown instead of .Rmd. Going back to .Rmd was no option because I want to use syntax highlighting for th... [Read more...]

[Read more...]

[Read more...]

I sometimes have a function which takes some parameters and returns a data.frame as a result. Then I have a data.frame where each row of it is a set of parameters. So I like to apply the function to each row of the parameter-data.frame and rbind the ... [Read more...]

Update 2020-11-28: I’ve updated the resulting image with data until Nov 27, 2020. In August I published first an animation of the spreading of SARS-CoV-2 in Germany. Some days ago I found a similar visualization for Austria by Matthias Schnetzer... [Read more...]

I used shinyapps.io 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...]