1. Learn
    2. /
  2. Courses
    3. /
  3. Working with Dates and Times in R

Exercise

Import hourly weather data

The hourly data is a little different. The date information is spread over three columns year, month and mday, so you'll need to use make_date() to combine them.

Then the time information is in a separate column again, time. It's quite common to find date and time split across different variables. One way to construct the datetimes is to paste the date and time together and then parse them. You'll do that in this exercise.

Instructions

100 XP
  • Import the hourly data, "akl_weather_hourly_2016.csv" with read_csv(), then print akl_hourly_raw to confirm the date is spread over year, month and mday.
  • Using mutate() create the column date with using make_date().
  • We've pasted together the date and time columns. Create datetime by parsing the datetime_string column.
  • Take a look at the date, time and datetime columns to verify they match up.
  • Take a look at the data by plotting datetime on the x-axis and temperature of the y-axis.