How to Groupby and plot it

Question

I have the following dataframe (with different campaigns)

When I use groupby and try to plot, I get several graphs

df.groupby("Campaign").plot(y=["Visits"], x = "Week")

I would like to have only one graph with all the visits in the same graph by every campaign during the week time. Also because the graphs show up separated, I do not know which one belongs to each campaign.

I would appreciate any tips regarding this.

Answer 1

Another possible solution would be to use seaborn

import seaborn as sns
ax = sns.lineplot(x="Week",
                  y="Visits",
                  hue="Campaign",
                  estimator=None,
                  lw=1,
                  data=df)

The documentation is here

Answer 2

You could do this:

df.set_index(['Week','Campaign'])['Visits'].unstack().plot(title='Visits by Campaign')

For multiple values of Week/Campaign let's aggregate them with sum or you could use mean to average the values:

df.groupby(['Week','Campaign'])['Visits'].sum().unstack().plot(title='Visits by Campain')

Output: