How to plot after doing a groupby on pandas data frame

Question

I have a time series data which contains date, year, month and ratings columns. I have grouped by year and month and and then i am counting the number of rating in each month for that year. I have done this the following way:

nightlife_ratings_mean = review_data_nightlife.groupby(['year','month'])['stars'].count()

I get the following data frame

year  month
2005  8           3
      9           4
      10         16
      11         13
      12          7
2006  1          62
      2          24
      3          13
      4          20
      5          11
      6          13
      7          11
      8          29
      9          33
      10         46

I want to plot this such that my x label is year and and y label is count and i want a line plot with marker-ø. How can I do this. I am trying this for the first time. So please help.

what do you mean by a line plot with marker-ø?

Dalek
– Dalek

2016-03-10 21:26:53 +00:00
Commented Mar 10, 2016 at 21:26 — Dalek
– Dalek, Commented Mar 10, 2016 at 21:26

bbkglb · Accepted Answer · 2016-03-10 22:07:53Z

1

You can call plot on your DataFrame and include the option style = 'o-':

plt = nightlife_ratings_mean.plot(x = 'year', y = 'stars', style = 'o-', title = "Stars for each month and year")
plt.set_xlabel("[Year, Month]")
plt.set_ylabel("Stars")

This will plot the following:

answered Mar 10, 2016 at 22:07

bbkglb

7691 gold badge7 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

How to plot after doing a groupby on pandas data frame

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related