Histogramming, grouping, and binning#

Overview#

Histogramming (see sc.hist), grouping (using sc.groupby), and binning (see Binned data) all serve similar but slightly different purposes. Picking the optimal one of the three for a particular application may yield more natural code and better performance. Let us start by an example. Consider a table of scattered measurements:

[1]:

import numpy as np
import scipp as sc

N = 5000
values = 10 * np.random.rand(N)
table = sc.DataArray(
    data=sc.array(
        dims=['position'], unit=sc.units.counts, values=values, variances=values
    ),
    coords={
        'x': sc.array(dims=['position'], unit='m', values=np.random.rand(N)),
        'y': sc.array(dims=['position'], unit='m', values=np.random.rand(N)),
    },
)
table.values *= 1.0 / np.exp(5.0 * table.coords['x'].values)
sc.table(table['position', :5])

[1]:

Coordinates		Data
x [m]	y [m]	[counts]
0.649	0.307	0.120±1.755
0.975	0.955	0.028±1.924
0.704	0.872	0.265±2.992
0.660	0.729	0.344±3.056
0.710	0.274	0.193±2.592

We may now be interested in the total intensity (counts) as a function of 'x'. There are three ways to do this:

[2]:

xbins = sc.linspace('x', 0, 1, num=40, unit='m')
ds = sc.Dataset(
    {
        'histogram': table.hist(x=xbins),
        'groupby': table.groupby('x', bins=xbins).sum('position'),
        'bin': table.bin(x=xbins).bins.sum(),
    }
)
ds.plot()

[2]:

../../_images/user-guide_binned-data_histogramming-grouping-and-binning_3_0.svg

In the above plot we can only see a single line, since the three solutions yield exactly the same result (neglecting floating-point rounding errors):

hist sorts data points into ‘x’ bins, summing immediately.
groupby groups by ‘x’ and then sums (on-the-fly) all data points falling in the same ‘x’ bin.
bin sorts data points into ‘x’ bins. Summing all rows in a bin yields the same result as grouping and summing directly.

So in this case we get equivalent results, but the application areas differ, as described in more detail in the following sections.

Histogramming#

scipp.hist directly sums the data and is efficient. Limitations are:

When histogramming in more than one dimension, the implementation uses sc.bin internally, which may be less efficient and uses more memory.
Can only apply “sum” or “nansum” to accumulate into a bin. scipp.nanhist is currently implemented differently and uses sc.bin internally. It therefore uses more memory and may be less efficient.

We can also histogram binned data (since binning preserves the 'y' coord), to create 2-D (or N-D) histograms:

[3]:

binned = table.bin(x=xbins)
hist = binned.hist(y=30)
hist.plot()

[3]:

../../_images/user-guide_binned-data_histogramming-grouping-and-binning_5_0.svg

[4]:

hist

[4]:

scipp.DataArray (19.93 KB)

Dimensions:
- x: 39
- y: 30

Coordinates: (2)

(x [bin-edge])

float64

0.0, 0.026, ..., 0.974, 1.0

Values:
array([0.        , 0.02564103, 0.05128205, 0.07692308, 0.1025641 ,
       0.12820513, 0.15384615, 0.17948718, 0.20512821, 0.23076923,
       0.25641026, 0.28205128, 0.30769231, 0.33333333, 0.35897436,
       0.38461538, 0.41025641, 0.43589744, 0.46153846, 0.48717949,
       0.51282051, 0.53846154, 0.56410256, 0.58974359, 0.61538462,
       0.64102564, 0.66666667, 0.69230769, 0.71794872, 0.74358974,
       0.76923077, 0.79487179, 0.82051282, 0.84615385, 0.87179487,
       0.8974359 , 0.92307692, 0.94871795, 0.97435897, 1.        ])

(y [bin-edge])

float64

0.000, 0.034, ..., 0.967, 1.000

Values:
array([4.71560559e-04, 3.37842181e-02, 6.70968756e-02, 1.00409533e-01,
       1.33722191e-01, 1.67034848e-01, 2.00347506e-01, 2.33660163e-01,
       2.66972821e-01, 3.00285478e-01, 3.33598136e-01, 3.66910793e-01,
       4.00223451e-01, 4.33536108e-01, 4.66848766e-01, 5.00161423e-01,
       5.33474081e-01, 5.66786738e-01, 6.00099396e-01, 6.33412053e-01,
       6.66724711e-01, 7.00037369e-01, 7.33350026e-01, 7.66662684e-01,
       7.99975341e-01, 8.33287999e-01, 8.66600656e-01, 8.99913314e-01,
       9.33225971e-01, 9.66538629e-01, 9.99851286e-01])

Data: (1)

(x, y)

float64

counts

29.233, 39.329, ..., 0.219, 0.0

σ = 5.580, 6.486, ..., 5.550, 0.0

Values:
array([[2.92330287e+01, 3.93290383e+01, 2.93261060e+01, ...,
        9.92075507e+00, 3.50256620e+01, 2.61086431e+01],
       [1.60771607e+01, 1.19209489e+01, 1.49572898e+01, ...,
        1.70956910e+01, 0.00000000e+00, 9.87322452e+00],
       [9.88434838e+00, 1.32354118e+01, 1.44310746e+01, ...,
        1.83086408e+01, 2.62621376e+01, 1.29777485e+01],
       ...,
       [3.44878526e-02, 2.49241056e-01, 2.21085338e-01, ...,
        3.76334352e-01, 1.08971536e-01, 1.09549255e-01],
       [1.83270732e-01, 1.06906190e-01, 7.96188652e-02, ...,
        7.69816139e-02, 2.44557438e-01, 1.80649497e-01],
       [8.82452875e-02, 6.90611484e-02, 5.96690228e-02, ...,
        1.87851176e-01, 2.18559525e-01, 0.00000000e+00]])

Variances (σ²):
array([[31.13144148, 42.06563802, 31.34728786, ..., 10.94075069,
        36.75658647, 27.36243511],
       [19.16165134, 14.16353965, 18.73284072, ..., 21.28072945,
         0.        , 11.64736065],
       [13.16169182, 18.31668195, 19.22150089, ..., 25.78625655,
        35.16949719, 17.17365703],
       ...,
       [ 3.750819  , 27.01586099, 23.74536245, ..., 40.4381467 ,
        12.12303826, 12.10415187],
       [22.78614449, 13.11444716, 10.07025908, ...,  9.82143072,
        30.20390859, 21.64633892],
       [12.18875674, 10.09901241,  8.42917148, ..., 26.40566552,
        30.79906656,  0.        ]])

Another capability of hist is to histogram a dimension that has previously been binned with a different or higher resolution, i.e. different bin edges. Compare to the plot of the initial example:

[5]:

binned = table.bin(x=xbins)
binned.hist(x=100).plot()

[5]:

../../_images/user-guide_binned-data_histogramming-grouping-and-binning_8_0.svg

This Page

Histogramming, grouping, and binning#

Overview#

Histogramming#

Grouping#

Binning#