Hey! I started using Plotly just recently and Iām trying to plot data of a supply chain most sale categories with the next code:
cat = data.groupby([āCategory Nameā])[āSales per customerā].sum().reset_index().sort_values(āSales per customerā)
fig = px.pie(cat, values=āSales per customerā, names=āCategory Nameā, title=āCategorias con mas ventasā)
fig.show()
And I get all the categories but Ijust want the top 10
Welcome to Dash @eric7
Maybe you can filter your dataframe before creating the figure, so it has the top 10 of the category you want. For example, for top 10 āSales per customerā:
cat = data.groupby([āCategory Nameā])[āSales per customerā].sum().reset_index().sort_values(āSales per customerā)
cat_top_10 = cat.nlargest(10, "Sales per customer")
fig = px.pie(...
Hey Adam thank you it worked just fine!! this is how I did:
cat = data.groupby(['Category Name'])['Sales per customer'].sum().reset_index().sort_values('Sales per customer')
cat_top_10 = cat.nlargest(10, "Sales per customer")
fig = px.pie(cat_top_10, values='Sales per customer', names='Category Name', title='Categorias con mas ventas')
fig.show()