如何获得非连续组的平均值

I need to filter the data, to have only one value on (y) group by (x) The aggregation could be the Mean(y) The problem : a group on (x) must be consecutive over (Date)I need to filter the data, to have only one val