Original title: How to retrieve one data value from the result of a pandas DataFrame.groupby().mean()
Using Pandas 2.3.2 on Python 3.9.2 via JupyterLab. I’ve collected a bunch of thermal data from a thing. I’ve already collated that data into DataFrame chunks that look like this: zone data Setpoint 9 zone1 40.34347 40 13 zone1 40.07553 40 17 zone1 39.98359 40 21 zone1 40.06895 40 25 zone1 40.04465 40 .. … … … 952 zone4 109.91890 110 956 zone4 109.90520 110 960 zone4 110.00600 110 964 zone4 110.02160 110 968 zone4 109.94940 110
Then I’ve used groupby and mean() to, well, group and create means:
means = temps[[‘zone’,‘Setpoint’,‘data’]].groupby([‘zone’,‘Setpoint’]).mean()
data
zone Setpoint
zone1 40 40.050959
50 50.030125
60 60.066517
70 70.050257
80 80.045247
90 90.071484
100 100.032826
110 110.137990
zone3 40 39.990645