The Uncount function for Tidy data

Prev Next

Sometimes you may have some data that have been aggregated by counting the number of observations

For example in the dataset below (on DataClassroom here), the number seen of species A, B and C have been recorded for two different days:

For many types of analysis it is desirable to convert this data into Tidy form, where there is one observation per row, as in the corresponding example below:

This is where the uncount function is useful. This function is found under Advanced in the left-hand menu:

NOTE
First you need to ensure that the column with the number of observations has been set to the correct type: Sample count as in our example dataset.