Please complete this exercise by 09:15 Wednesday, 9 October 2019.
Start your assignment
You can start working on your copy of Exercise 5 by accepting the GitHub Classroom assignment.
Exercise 5 is due by the start of lecture in week 6.
You can also take a look at the open course copy of Exercise 5 in the course GitHub repository (does not require logging in). Note that you should not try to make changes to this copy of the exercise, but rather only to the copy available via GitHub Classroom.
Please note that we provide assignment feedback only for students enrolled in the course at the University of Helsinki.
Exercise 5 hints for Pandas¶
Below are some tips for working on Exercise 5.
Selecting date ranges
In the Problem 4 part 2, the aim is to select rows that belong to certain month. The key here is to understand that
the data values in
YR--MODAHRMN column are integer numbers using a format
YYYY is the
year of the observation,
MM is the month,
DD is the day,
HH is the hour, and
mm is the minute.
Using these values it is possible to make simple mathematical queries such as finding the values starting from August:
august_values = data.loc[data['YR--MODAHRMN'] >= 201708010000]
Here, the value
201708010000 corresponds to the first day of August at 00:00 hour.