<p>我正在寻找一种方法来生成一个移动窗口,它基于过去n天内每个组的非空值的平均值。在</p>
<p>例如,如果移动窗口大小为3,我希望根据每个<I>组的<I>ct</I>列中的非空值生成列<I>MovAvg</I>(即具有滞后效应)。在</p>
<pre class="lang-none prettyprint-override"><code>Date Group ct MovAvg
1/1/71 A NaN NaN
2/1/71 A 1 NaN
3/1/71 A NaN NaN
4/1/71 A NaN 1
5/1/71 A 1 1
6/1/71 A NaN 1
7/1/71 A 0 1
8/1/71 A NaN 0.5
9/1/71 A NaN 0
10/1/71 A 1 0
11/1/71 A 0 1
1/1/71 B NaN NaN
2/1/71 B 1 NaN
3/1/71 B NaN NaN
4/1/71 B NaN 1
5/1/71 B 0 1
6/1/71 B 1 0
7/1/71 B 1 0.5
8/1/71 B NaN 0.67
9/1/71 B NaN 1
10/1/71 B 1 1
11/1/71 B 0 1
</code></pre>