How can I group rows in groups of 5 using pandas?

Asked Dec 08 '15 at 15:57

Active Dec 08 '15 at 15:57

Viewed 158 times

I have data that looks like this:

And the numbers are either zero or one. I want to make a plot of this, but of course it looks crazy because values are either 0 or 1, so the lines jump around a lot. How can I group the rows by 5s or 10s, summing all the data in each group, so that I can make a more meaningful plot?

asked Dec 08 '15 at 15:57

Jonathan

10,571
13
67
103

what do you want to plot? – Colonel Beauvel Dec 08 '15 at 16:17
Where in the series each of the tags occur. So it's not super meaningful that "interruptions" happens once at 0, and once at 6, but more meaninful that it happens twice in the range 0-10. – Jonathan Dec 08 '15 at 16:26
Sounds like you're looking for "binning"? http://stackoverflow.com/questions/16947336/binning-a-dataframe-in-pandas-in-python – Adam Benzan Dec 08 '15 at 16:55

How can I group rows in groups of 5 using pandas?

0 Answers0