Hey guys, welcome back. Here are the solutions to the exercises of section two. The first thing we need to do is import the standard libraries like numpy, matplotlib, and pandas and also set the matplotlib inline directive. So we do that in the very first cell. Then let's look at the exercise one. The first thing was to load the dataset. Well we've seen how to do this by using the pd dot read csv File it's a csv so I think this should have been pretty easy for you to do. Let's run it, loads pretty fast. Then we were asked to inspect it using the info and heads command. So let's run these. So the info command tells us there are two columns there are 144 values and no new values in either column. The first column is called month and its the second column is called thousand passengers. We can get a sneak peak-- oh we also know that the passengers are an integer whereas the month is a string. We can get a sneak peak of the values by using the head command which shows us the first five rows of the data frame. 

So we see that the month is a date as a string with year and month and these are the number of passengers in thousands, so its an integer. Then we were asked to use a function, pd to datetime to change the column type of month to a datetime type. So we do this by using pd to datetime on the month column and we are just reassigning that to the same month so we are overwriting the column month column and then we are using df set index on month because check the recommendation set index takes the key which is the column column label or list of column labels that are gonna be used as index. So we set the month to be the index and with this new data frame with month as index we override the original dataframe. So let's see what it looks like now. 

We've set the month column to be the index and notice how it also added the day because now it's interpreted as datetime not as a string. Now if we do df plot it does everything for us in the right way. Shows the right way the year it displays the title of the axis and it shows the legend that tells us what is displayed in the plot. Okay, so if you have any questions about this make sure to post them in the forum. I hope you enjoyed this video, see you in the next.