rolling functions and merge asof?

[randomgambit]

Hello there and thanks for this great package!

I wonder if you plan to implement all the pandas-related rolling functions as well as the merge_asof merge. These are very powerful data manipulation tools. They are available in the spark pandas API, so I wonder if these will be available in bigquery pandas as well.

What do you think? Thanks!

[TrevorBergeron]

Hi, Thanks for the feature request. We do have support for rolling windows on dataframes and series, see DataFrame.rolling docs. The available aggregations are here: Window docs. Is this sufficient to cover your use case?

As for pandas.merge_asof, this is not yet implemented. I will update this issue when we add this feature.

[randomgambit]

Thanks @tswast , just to clarify: under the hood what is the package doing exactly? are you translating the pandas methods into corresponding bigquery SQL queries? Or are you doing something else?

Thanks!

[tswast]

@randomgambit Yes, we translate to SQL via Ibis.