Exercise

Interactive key stats table

Using graphs to display your data visually is a great way to see aggregated figures at a glance. Yet sometimes, you also need to see more numbers than is feasible to display in common visualization formats.

A key stakeholder in the e-commerce company, the finance department head, has heard of your great work but is someone who needs to see some figures in tabular rather than visual format. He has requested a dashboard displaying some aggregated stats in a tabular format. However, he wonders if you could also include some 'Dash magic' to make it a bit more interactive than his existing Excel spreadsheets?

Instructions

100 XP
  • Use the dash_table module FormatTemplate to create a money format to two decimal places for use in constructing the Data Table columns below line 13.
  • Use the columns created on line 18 and the data from the DataFrame created on line 11 to create a DataTable below line 22.
  • Ensure the DataTable has the built-in sorting below line 27.
  • Ensure the DataTable has the built-in filtering below line 29.