1
00:00:00,610 --> 00:00:08,110
High in this video, I'm going to show you how to create a plot showing the average rating by month,

2
00:00:08,440 --> 00:00:13,540
and this is going to be a very short lecture because we already know how to do that.

3
00:00:18,230 --> 00:00:26,450
All we have to do is just copy that cell like that, or you can also copy by pressing escape and then

4
00:00:26,810 --> 00:00:31,640
CC so hit the C key two times and then here.

5
00:00:32,240 --> 00:00:40,190
So you just go there and say V and that will pace the cell so that you don't have to copy all the code

6
00:00:40,280 --> 00:00:40,850
like that.

7
00:00:41,180 --> 00:00:46,940
But instead of copying the code , you can copy the entire cell and then we need to do some changes

8
00:00:46,940 --> 00:00:47,130
here.

9
00:00:47,130 --> 00:00:56,660
Month here timestamp, then inside of U we have M, instead of week we have a month. Instead of week

10
00:00:56,660 --> 00:00:57,800
here we have four month.

11
00:00:58,720 --> 00:00:59,510
This is fine.

12
00:01:00,290 --> 00:01:03,740
Then we here we update the variable month_average.

13
00:01:06,200 --> 00:01:12,410
Month_average execute and this is the monthly average.

14
00:01:13,060 --> 00:01:15,490
So I think it's getting better.

15
00:01:15,910 --> 00:01:19,190
You see that we see that difference more clearly now.

16
00:01:19,810 --> 00:01:29,260
And that is also because you see the range has changed of the graph since we have more aggregated data.

17
00:01:29,290 --> 00:01:31,120
So we have monthly averages.

18
00:01:31,120 --> 00:01:37,270
Now, that means there is not a big amplitude, a big difference between the highest value.

19
00:01:37,630 --> 00:01:43,600
So you see that the highest value now is somewhere at 4.6 and the lowest value, which is

20
00:01:43,600 --> 00:01:47,890
somewhere at 4.3 or 4.35.

21
00:01:48,460 --> 00:01:53,800
That will make the highs and peaks more appearance to the user.

22
00:01:54,110 --> 00:01:54,630
Right.

23
00:01:54,640 --> 00:01:55,900
And that's about this video.

24
00:01:56,020 --> 00:01:59,790
In the next video, we are going to do something a more different.

25
00:02:00,100 --> 00:02:07,690
We are going to look to create multiple lines in one single plot and each line is going to represent

26
00:02:08,020 --> 00:02:11,350
the monthly average of ratings for each course.

27
00:02:11,500 --> 00:02:14,870
So far, we only had aggregated courses.

28
00:02:14,890 --> 00:02:16,360
So let's talk to you in the next video.