When it comes to using tidyverse in non-American contexts it gets often a little bit tricky. The last time I encountered a problem was when I tried to show the Euro-sign (€) in a PDF created with quarto and the gt-package. Using html as output format e... [Read more...]

Sometimes I want to summarize some categories which don’t have much impact on my analysis. So the best way to do this is using some of the forcats::fct_lump*() functions. But I often struggle to find the way using the weights to order the categor... [Read more...]

When working with data provided by common APIs you will almost always get in contact with JSON formatted data. Using R’s rjson::fromJSON will transform JSON to R’s lists. So far so good. Converting those lists to tibble using tibble::as_tib... [Read more...]

Lately I tried to query BigQuery using bigrquery. Unfortunately I got an error: Error in strsplit(name, ".", fixed = TRUE) : non-character argument Updating to the latest packages on CRAN doesn’t solve the problem. So I had to dig deepe... [Read more...]

Lately I wanted to play around with nflfastR. That’s a great package giving you access to NFL’s play-by-play data since 1999. It let’s you download all the data and store it in several different databases. Unfortunately I ran into tro... [Read more...]

This blogpost is mainly a reminder for myself where I can delete this information. But what’s all about? Recently I installed bigrquery and ran queries against Google’s BigQuery cloud-database before I had installed gcloud (and did the auth... [Read more...]

After upgrading my local R version to version 4.2.1 I always got an annoying warning after loading my own package. This only occurred using RStudio.

<span class="lnt">1
</span><span class="lnt">2
</span><span class="lnt">3
</span>

Warning message: In length(steps) == 0 || nchar(steps) == 0 : 'length(x) = 2 __ 1' in coercion to 'logical(1)' “Okay, that’s something new in R 4.2.0”, I thought and ... [Read more...]

pkgdown is a great tool for generating a website with documentation for an R package. Unfortunately, pkgdown uses CDNs (content delivery networks) like Cloudflare to embed often used JavaScript libraries into the generated website. Also, fonts are incl... [Read more...]

A year ago I already wrote an article how to iterate over the rows of a data.frame. Now I’ve run into another special case. Last year we used pmap_dfr() to pass each element of a row as single parameter to our custom function. But what should you... [Read more...]

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