Skip to content

Instantly share code, notes, and snippets.

@UranusSeven
UranusSeven / DataFrameGroupbyRolling.md
Created April 13, 2023 08:40
Scale out groupby rolling using Xorbits

Given a dataframe,

            stock_id   returns
date
2015-01-03  bac_i.us  0.000000
2015-01-03    glt.us  0.000000
2015-01-03    lpx.us  0.000000
2015-01-03    rbc.us  0.000000
2015-01-03   clnt.us  0.000000
... ... ...
@UranusSeven
UranusSeven / README.md
Last active August 31, 2023 00:16
Benchmark pandas 2.0.0 with TPC-H

The TPC-H is a decision support benchmark. It consists of a suite of business oriented ad-hoc queries and concurrent data modifications.

Pandas 2.0.0 RC0 and RC1 has been released. According to the release notes, the main new features in 2.0.0 focus on performance improvement.

The benchmark runs on my laptop:

MacBook Pro (16-inch, 2021)
Chip Apple M1 Max
Memory 32 GB