1. Học hỏi
    2. /
  2. Dự An
    3. /
  3. Case Study: Analyzing City Time Series Data in R
Connected

Bài tập

Generating a monthly average

While the to.period() command is useful in many contexts, for your purposes it may not be useful to select a single row as representative of the entire month.

Instead, it makes more sense to generate average temperature values per month. To do so, you'll need to manually calculate the monthly average using split() and lapply(), then generate a new xts object using as.xts() This may seem like a complicated process, but you already have the skills to do it!

The subsetted xts object from the previous exercise, temps_xts_2, is preloaded in your workspace. Also preloaded is an index object containing a vector of dates for the first day of each month covered in the data.

Hướng dẫn

100 XP
  • Use split() to generate monthly lists from the mean column of your temps_xts_2 object. Be sure to specify "months" as the period (the f argument).
  • Use lapply() to calculate the "mean of means", or the average mean temperature per month.
  • Use as.xts() to generate a new xts object containing average monthly temperature in Boston from 2010 through 2015. To do this, you will need to combine your monthly mean_of_means data with your monthly index object.
  • Finally, confirm that your new temps_monthly object shares a duration and periodicity with flights_xts.