Fast way to query a Table

Anvil Q&A
3

This forum post might be helpful.

Using pandas with Anvil

You might also consider going to a list of dicts rather than a dict of lists

my_table = list(dict(list(row)) for row in app_tables.table.search())

You could also then switch to a dict of lists from there - stack overflow will have some suggestions for ‘from list of dicts to dict of lists’