How to configure the way categorical values are sorted?

This is a very common requirement especially when you want to visualize the data and present to the others.

You can convert your ‘character’ data type column to ‘factor’ type and define the order in R / Exploratory. There are various requirement for defining the order, such as,

  • Order by the way the incoming data is
  • Order by another column
  • Order by the frequency
  • Order manually

And you can use some amazingly easy to use functions from ‘forcats’ package, which is embedded inside Exploratory. You can find them from the column header menu.

I have written a blog post about how to use these functions, take a look for the details.