Histogram values of a Pandas Series

Solution 1:

You just need to use the histogram function of NumPy:

import numpy as np
count, division = np.histogram(series)

where division is the automatically calculated border for your bins and count is the population inside each bin.

If you need to fix a certain number of bins, you can use the argument bins and specify a number of bins, or give it directly the boundaries between each bin.

count, division = np.histogram(series, bins = [-201,-149,949,1001])

to plot the results you can use the matplotlib function hist, but if you are working in pandas each Series has its own handle to the hist function, and you can give it the chosen binning:

series.hist(bins=division)

Edit: As mentioned by another poster, Pandas is built on top of NumPy. Since OP is explicitly using Pandas, we can do away with the additional import by accessing NumPy through Pandas:

count, division = pd.np.histogram(series)

Solution 2:

Inorder to get the frequency counts of the values in a given interval binned range, we could make use of pd.cut which returns indices of half open bins for each element along with value_counts for computing their respective counts.

To plot their counts, a bar plot can be then made.

step = 50
bin_range = np.arange(-200, 1000+step, step)
out, bins  = pd.cut(s, bins=bin_range, include_lowest=True, right=False, retbins=True)
out.value_counts().plot.bar()

Frequency for each interval sorted in descending order of their counts:

out.value_counts().head()
[-100, -50)    18
[0, 50)        16
[800, 850)      2
[-50, 0)        2
[950, 1000)     1
dtype: int64

To modify the plot to include just the lower closed interval of the range for aesthetic purpose, you could do:

out.cat.categories = bins[:-1]
out.value_counts().plot.bar()

Solution 3:

If you say you want to get values of histogram, you are simply looking for frequency of each unique value in your series, if I'm not mistaken. In that case, you can simply do serie.value_counts(), which will give you:

 0.0      16
-90.0      8
-100.0     5
-80.0      3
 63.0      1
-50.0      1
 130.0     1
 190.0     1
 840.0     1
-48.0      1
 208.0     1
-64.0      1
 812.0     1
-70.0      1
 950.0     1