R | RStudio | Time Series

Project Overview

Objective: Analyze (using R) residential power usage to determine the duration of occupancy.

Code & Resources

R RStudio
Packages: RMariaDB, dplyr, lubridate


Resource: Data housed in AWS and extracted using the RMariaDB package (SQL).
Datasets contained minute-by-minute power usage from December 2006 - November 2010 with the following attributes:

• Date
• Time
• Active Power
• Reactive Power
• Intensity
• Voltage
• Sub-meter 1 (dishwasher, oven and microwave)
• Sub-meter 2 (washing-machine, tumble-drier, refrigerator and light)
• Sub-meter 3 (electric water-heater and air-conditioner)