I am a newbie in pandas, I reviewed some of the listed solution to bucket dataframe but none of them seems to be my answer. i have a time series data which I am not going to use resampling for them, the way I want to bucket is divide whole data into 7 groups and each group into 10 equal buckets. I am sure there must be very straight way rather than using index here.
More details
Dataframe
tick: 2014-11-03 00:00:07,...
date_part: 4972807141, 4972807143
spot: 0.8752, 0.8753,...
length:1405
the ticks i want to be grouped into 7 and each point to exact 10 spot bucket and then other column can use aggregation function up to spot bucket level, which will be total 7X10 records.