Python Plotting Grouped Data

Question

The grouped data looks like

My approach yields to

I'd want a result like

Is there an easy way to achieve that?

Group again by MAPPING, then plot or use seaborn or pivot MAPPING into distinct columns. — Mr. T
– Mr. T, Commented Mar 10, 2022 at 13:17

Valdi_Bo · Accepted Answer · 2022-03-10 16:25:33Z

1

As the test DataFrame I used:

         MAPPING CREATED_DTM  counts
0  Beschaedigung  2020-04-30   22738
1  Beschaedigung  2020-05-31   21523
2  Beschaedigung  2020-06-30   18516
3  Beschaedigung  2020-07-31   21436
4  Beschaedigung  2020-08-31   22325
5        Verlust  2020-04-30   20000
6        Verlust  2020-05-31   19500
7        Verlust  2020-06-30   22400
8        Verlust  2020-07-31   19100
9        Verlust  2020-08-31   21100

(CREATED_DTM column of datetime64[ns] type).

An elegant solution to create the plot you want, is to use seaborn.

Start from necessary imports:

import seaborn as sns
import matplotlib.pyplot as plt
import matplotlib.dates as md

Then, run:

sns.lineplot(data=reaktiv_mapping, x='CREATED_DTM', y='counts', hue='MAPPING')
ax = plt.gca()
x = ax.xaxis
x.set_major_locator(md.MonthLocator())
x.set_major_formatter(md.DateFormatter('%Y-%m'))
plt.xticks(rotation = 45)
ax.legend(loc='upper left', bbox_to_anchor=(1.05, 1.0));

For the above source data, I got the following plot:

To get the grid, like in your expected picture, you can start with:

sns.set_style('darkgrid')

edited Mar 10, 2022 at 16:25

answered Mar 10, 2022 at 16:13

Valdi_Bo

31.1k4 gold badges29 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Romero Azzalini Over a year ago

you are an angel, thank you very much!

Collectives™ on Stack Overflow

Python Plotting Grouped Data

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related