pandasでWindow関数的な集計 ref: https://qiita.com/kyoro1/items/ffe2a11986131857e6ef

file0.txt

import pandas as pd
import numpy as np
from numpy.random import *
from pandas import rolling_mean, rolling_apply

file1.txt

### Randomに0-1のデータを10個生成(numpy array形式)
tmp = rand(10) #

file2.txt

tmp
#array([0.05049257, 0.19130526, 0.38653303, 0.01820196, 0.28877423,
#       0.57416531, 0.85929624, 0.92731291, 0.27886026, 0.51936736])

file3.txt

df = pd.DataFrame(tmp)
df.columns = ['values']

file4.txt

df

file5.txt

## `ma`列に、直近3の幅の移動平均を計算した値を入れます
df['ma'] = pd.rolling_mean(df['values'], 3)

file6.txt

df

file7.txt

def count_threshold(x):
    return np.sum(x>0.3)

file8.txt

df['count_threshold'] = pd.rolling_apply(df['values'], 3, count_threshold)