This shows examples of DataTable and PivotTable.
We'll create a business analytics dataset for use throughout this documentation to show off all of the plottypes. The dataset contains sales data for a company employing door to door salesmen accross a wide area and with a large set of possible products.
The code that generates this dataset is shown below as the example of the CodeBlock type.
PivotTables can do quite alot. Indeed many of the charttypes of this package would alternatively be doable just using a PivotTable so you might prefer doing that in some cases. Dataset Selection: This PivotTable demonstrates the ability to switch between multiple datasets - use the dropdown above the table to switch between 'sales_data' (detailed sales records) and 'product_summary' (aggregated product statistics). This is useful when you want to explore the same data at different levels of aggregation. See here for PivotTable examples
This just displays your DataFrame in a nice way on the html page. There is a download as csv button at the bottom of it. You could also just use a PivotTable but this is lighterweight for cases where a PivotTable is overkill. See here for Table examples
| product | total_sales | total_quantity | total_profit |
|---|---|---|---|
| Phone | 1.2498934909082277e8 | 2334635 | 4.983743212838119e7 |
| Laptop | 9.331932174333596e7 | 1690764 | 3.718559283865343e7 |
| Tablet | 6.289886064762073e7 | 1987224 | 2.4985962429159395e7 |
Data: Table