如何在pandasq中使用窗口函数

Question

我正在积极尝试在pandasql中使用一个窗口函数，这在我上次检查的SQLite3中是可用的。但是，我遇到了一个错误：

import numpy as np
import pandas as pd
from pandasql import sqldf, load_meat, load_births

pysqldf = lambda q: sqldf(q, globals())

meat = load_meat()
births = load_births()
print(pysqldf("""
SELECT 
    *, 
    count(*) over (partition by date) as t 
FROM meat""").head())

错误：

PandaSQLException: (sqlite3.OperationalError) near "(": syntax error
[SQL: SELECT *, count(*) over (partition by date) as t FROM meat]
(Background on this error at: http://sqlalche.me/e/e3q8)

错误中提供的链接似乎没有任何帮助