Preserving zero-length groups

Learning the group_by attribute .drop

This week I learned about another neat trick with tidyverse functions: the argument .drop from the group_by function.

To showcase this functionality I made up a simple example with this dataset consisting of nuclear accidents data.

Take a sneak peek of the dataset:

DateLocationCost (millions 2013US$)INESSmyth MagnitudeRegionFatalities
4/26/1986Kiev, Ukraine25933678.0EE4056
3/11/2011Fukushima Prefecture, Japan16608977.5A573
12/8/1995Tsuruga, Japan15500NANAA0
3/28/1979Middletown, Pennsylvania, United States1091057.9NA0

Let’s say we are interested in knowing about how does the percentage of accidents happened in Europe vary compared to the rest of the world, and for that reason we simplify the Region variable onto the In_Europe boolean feature:

We then simply compute the percentage of accidents happened every year and plot it

If that chunk puzzles you, I explain what is going on under the hood in this post.

In the plot below I highlighted the strange result I found: being that there are only two possibilities (the accident happened in Europe or not) the sum of the ratios should add up to 100, right?

Not a beautiful plot but aesthetic considerations apart, what is going on here? Did we fail with the maths? Not exactly. This result is due to a tricky behaviour of the summarise function related with the missing values.

If we take a look to the first rows, we can see how in 1990 and 1991 there weren’t any nuclear accident in Europe, but that information is implicit instead of explicit.

YearIn_EuropeNPercentage
1989FALSE466.7
1989TRUE233.3
1990FALSE1100.0
1991FALSE3100.0
1992FALSE375.0
1992TRUE125.0

When plotting with the line graph, ggplot is connecting the data points between 1989 and 1992 and therefore displaying misleading information. Obviously this is not ggplot’s fault, it’s simply how it works.

We could easily solve this problem chossing an more suitable graph as we will see below, but this example is still useful to learn about the .drop argument: The default behaviour of the group_by function is to drop zero-length groups, and therefore it’s making implicit that piece of information. We can override the default behaviour simply adding .drop = FALSE to the call:

Now we can see the years when there were no accidents in Europe:

YearIn_EuropeNPercentage
1989FALSE466.7
1989TRUE233.3
1990FALSE1100.0
1990TRUE00.0
1991FALSE3100.0
1991TRUE00.0

And now the graph doesn’t deceive us anymore:

Let’s face, however, that we could have tackled this problem choosing a more suitable geom. Whenever you need to display any normalized variable, using geom_col() is usually a better approach:

Pablo Cánovas
Pablo Cánovas
Senior Data Scientist at Spotahome

Data Scientist, formerly physicist | Tidyverse believer, piping life | Hanging out at TypeThePipe

Related