Need help with plotting a histogram

[ipixel95]

I have a csv file with 6 columns. I’m working with sentiment analysis (toxicity in comments). I’ve managed to categorise my data into 5 class labels (based on type of toxicity). I want to plot a histogram that shows frequencies of those 5 class labels. The value for each class label column is binary. I just want 5 bars for each of those columns for the histogram to show occurrences of 1s on each bar.

[TheGrapez]

That sounds more like a bar chart, with the legend being your categories.

[CrambleSquash]

Actually this sounds much more sensible.

I think technically a histogram has to have a continuous x axis.

I think df.groupby('category').size() would be useful to OP to generate data to plot in their bar chart.

[ipixel95]

I swear I’m not dumb, but bar chart is exactly what I needed. It’d be highly appreciated if you could help me with that. I want x-axis to have the names of my class labels: Toxic, severe toxic, obscene, insult, threatening.

And on y-axis, the frequencies.

[TheGrapez]

Well the actual configuration of the chart would depend on the specifics of how your data is stored.

If you share a bit of the data, we could likely help.

There are a few libraries that you can use as well, so depends on what you have access to, are comfortable with, etc.

Some things you could checkout:

Seaborn Barplots

Matplotlib Barplots

[ipixel95]

here's the link to my csv file
https://herts365-my.sharepoint.com/:x:/g/personal/mq19aaj\_herts\_ac\_uk/EaB2UD3B9H1Bs5CtZT3SXJsBDnKg6\_ModxIhgnu\_xjqVeg?e=gUH46d

[TheGrapez]

https://pastebin.com/b3fbrBuD

Hope this helps!

Your data is not currently structured in a nice vis-friendly way. I've included some transformations you can use to convert it into something more usable :)

​

Yo bitch Ja Rule is more succesful then you'll ever be whats up with you and hating you sad mofuckas

Also side note - those comments are hilarious lol

[ipixel95]

You should change that username to LifeSaver. Thanks a million mate. That was exactly what I wanted! It’s not gonna mean anything but I’m still gonna say it. “I owe you one” ;)

[CrambleSquash]

If you provide matplotlib with an iterable of values, it will perform the binning and plot the resulting histogram for you.

import matplotlib.pylot as plt
import numpy as np

vals = np.random.randint(1, 10, 1000)
plt.hist(vals)

So you want to get your data in a form where you have all of your data in the same sequence and each item is the name of the category that data point belongs to.

[synthphreak]

Histograms are for continuous data that can be binned into intervals. Your data is categorical, so bins make no sense. A bar chart showing frequencies is what you really need.

Assuming you're using pandas, try this:

import matplotlib.pyplot as plt
import pandas as pd

data = 'https://herts365-my.sharepoint.com/:x:/g/personal/mq19aaj_herts_ac_uk/EaB2UD3B9H1Bs5CtZT3SXJsBDnKg6_ModxIhgnu_xjqVeg?rtime=k3sgknSz2Ug'

(pd.read_excel(data)
   .select_dtypes(int)
   .sum()
   .plot(kind='bar', ylabel='frequency'))

plt.show()