Showing all data points instead of Aggregate

📊 Plotly Python
1

Hi Team,

The below line plot seems to display all experiments instead of the aggregate.

1
1984×562 63 KB

I was expecting something like this

2
2863×477 148 KB

2

Hi,

I can’t see what your employment dataset looks like but I would check and make sure that the dataframe your passing in (employment) is in itself a groupby dataframe. The correct dataframe to pass in would only have 1 row per age group per period.

In short:

df = employment.groupby(["Period","Age"],as_index=False).sum()
fig = px.line(employment, x="Period", y="Unemployment", color= "Age")
fig.show()

or straight up do the groupby while you create the plot.

fig = px.line(employment.groupby(['Period','Age'],as_index=False).sum() , x="Period", y="Unemployment", color= "Age")
fig.show()