How to Visualize Data Categories in Python With Pandas
Tags: python, datascience, machinelearning, programming
Published: 2021-09-04 12:49:20

**If you have a dataset which is divided into categories of data like: kickstarter projects, flower species or most popular car brands, then it's a good idea to visualize those data categories to see the amount of values within each category.**

Here's a dataset of over 300,000 kickstarter projects as well as their categories, goal, No. of backers and much more: https://www.kaggle.com/kemical/kickstarter-projects.

When looking at the dataset, you would notice that every one of those 300,000+ projects are put into different categories such as: Games, Music, Art and Technology.

***************

**To make a Python script that will display each category as a fraction of a donut plot based on the number of projects belonging to it, first add the necessary libraries and load in the dataset:**

```python
import pandas as pd 
import matplotlib.pyplot as plt
import seaborn as sns

data = pd.read_csv('ks-projects.csv')

df = pd.DataFrame(data)
```

Next, to get the number of projects within each category, add this line of code to your script: 

```
category_values = df.pivot_table(columns=['main_category'], aggfunc='size')
```

Now to display "category_values" in a doughnut graph, add this to the end of your script:

```python
plt.pie(category_values)
my_circle=plt.Circle( (0,0), 0.7, color='white')
p=plt.gcf()
p.gca().add_artist(my_circle)

plt.show()
```

Now if you run your script, your doughnut plot should look something like this:
![Donut!](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/khj02w0p1fyje0e0gtqy.png)


As you can see, it displays the amount of projects within each category as a fraction of the doughnut plot, but it doesn't label the categories.

**************

**To label the categories, add these lines of code before your doughnut plot:**

```python
category_names = data['main_category']
categories = category_names.unique()
categories.sort()
```

This will count the number of unique category names within the dataset and sort them in alphabetical order.

The reason for sorting them in alphabetical order is because the category values we defined earlier are ordered alphabetically( first value is Art: 28153 and last value is Theater: 10913).

*********

**Now to display the doughnut plot with its corresponding labels, replace**

```python
plt.pie(category_values)
```
with
```python
plt.pie(category_values, labels=categories)
```

Full code:

```python
import pandas as pd 
import matplotlib.pyplot as plt
import seaborn as sns

data = pd.read_csv('ks-projects.csv')

df = pd.DataFrame(data)
category_values = df.pivot_table(columns=['main_category'], aggfunc='size')

category_names = data['main_category']
categories = category_names.unique()
categories.sort()
plt.pie(category_values, labels=categories)

my_circle=plt.Circle( (0,0), 0.7, color='white')
p=plt.gcf()
p.gca().add_artist(my_circle)
plt.show()
```

####Now if your run your script, you should see a doughnut plot that displays the fraction of projects each category contains, as well as the categories' labels:
![Donut with labels](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/3294ypluwvi6y3b3vsjp.png)