pandas dataframe transformation partial sums -

pandas dataframe transformation partial sums -

i have pandas dataframe

index a

1 3.4 2 4.5 3 5.3 4 2.1 5 4.0 6 5.3 ... 95 3.4 96 1.2 97 8.9 98 3.4 99 2.7 100 7.6

from create dataframe b

1-5 sum(1-5) 6-10 sum(6-10) ... 96-100 sum(96-100)

any ideas how elegantly rather brute-force?

cheers, mike

this give series partial sums:

df['bin'] = df.index / 5 bin_sums = df.groupby('bin')['a'].sum()

then, if want rename index:

bin_sums.index = ['%s - %s' % (5*i, 5*(i+1)) in bin_sums.index]

pandas dataframes