I have a Dataframe with 15992 indexes.
I would like to loop over the dataset and take the sum of cells that falls within 999 to 1000.
And if the sum falls into this range, group them accordingly.
Take its Range, sum, count of range, mean, max, min to a new dataframe.
I'm really new at using Pandas, I don't know if it's possible. Please kindly have a look at the images below.
Thank you
Frame Offset | FrameTime |
---|---|
1 | 13.423 |
2 | 11.764 |
3 | 12.243 |
5 | 12.508 |
... | ... |
1995 | 49.559 |
1996 | 58.300 |
1997 | 56.943 |
1998 | 37.577 |
1999 | 57.111 |
Name: FrameTime, Length: 15992, dtype: float64