This can be achieved using python-magic ... a specified DataFrame and index – or indexes if a multi-index is required – and returns the corresponding values. pd.pivot_table(logs_filtered ...