Pivot tables#

For analysing data in groups, it may make sense to turn it into a Pivot table.

import pandas as pd
df = pd.DataFrame(
    {
        "cell": ["Purkinje","Purkinje","Purkinje","Purkinje","Purkinje"],
        "location": ["brain1", "brain1", "brain2", "brain2", "brain1"],
        "spikes": ["simple", "complex", "simple", "complex", "simple"],
        "value": [3.3, 5.1, 2.5, 6.2, 2.8],
    }
)

df
cell location spikes value
0 Purkinje brain1 simple 3.3
1 Purkinje brain1 complex 5.1
2 Purkinje brain2 simple 2.5
3 Purkinje brain2 complex 6.2
4 Purkinje brain1 simple 2.8

You can turn your table into a pivot table, for example by computing the mean of columns for elements in groups using pandas.pivot_table()

pivot = pd.pivot_table(
    df, values="value", index=["cell", "location"], columns=["spikes"], aggfunc="mean"
)
pivot
spikes complex simple
cell location
Purkinje brain1 5.1 3.05
brain2 6.2 2.50