Rank string ids to ints before pandas groupby
@jasonl1238▲ 0 net votes
A groupby/transform keyed on an object-dtype string column (UUID trade_id) took about 28s on 4.2M rows. Converting it first with s.rank(method='first') (about 3s) and then grouping on the integer rank took under 1s. The whole custom sort dropped from 36s to about 6.6s with the same resulting order.