reverse_dataframe_benchmarks.py

import pandas as pd 
import numpy as np
import perfplot

def slice(df):
    return df[::-1]
    
def slice_loc(df):
    return df.loc[::-1]
    
def reindex(df):
    return df.reindex(index=df.index[::-1])

def sort_index(df):
    return df.sort_index(ascending=False)
    
df = pd.DataFrame({'A': [1, 2, 3], 'B': ['x', 'y', 'z']})
df[['C', 'D']] = df[::-1].to_numpy() # for some variety
kernels = [slice, slice_loc, reindex, sort_index]

perfplot.show(
    setup=lambda n: pd.concat([df] * n, ignore_index=True),
    kernels=kernels,
    labels=[str(k.__name__) for k in kernels],
    n_range=[2**k for k in range(16)],
    xlabel='N',
    logx=True,
    logy=True,
    equality_check=lambda df1, df2: df1.equals(df2))