How can I show categorical data when categories are coded?

You can convert categorical codings into their appropriate labels in a few seconds with Keshif.

In some datasets, the data source may identify codings in place of full categorical values. For example, type of location of an event database can be coded as "R" in place of "Road", "H" in place of "Home", and "OC" in place of "Office". When you import such a dataset, and insert "Type of Location" into the dashboard, Keshif would create the following chart.

To convert these codes to correct labels, enable "Adjust" mode, click the code, and update the text.

These new labels will be used in all selections of this category, and also in record detail panel!

What if your categorical data is actually coded by integer value? Let's assume the dataset above is actually coded by integers, and "R" is coded as "2", and "H" is coded by 4, and so on. Given such a raw data, Keshif will parse these data as numbers, and show a histograms (and might even merge numbers into ranges if the numeric range is wide).

This chart is a good first step, but not a good representation of the underlying data.

To make it better, we need to tell Keshif what each number means, i.e. describe the coding. 

You can do this in two steps: 

1) First, click "derive" icon in the upper right corner, and select "convert to categorical.

2) Then, enable the adjust mode, and then re-name the categories as appropriate.

Once done, your charts will look and interact perfectly, and your data exploration will be a joy!

Still need help? Contact Us Contact Us