This assignment uses data from the UC Irvine Machine Learning Repository, a popular repository for machine learning datasets. In particular, we will be using the "Individual household electric power consumption Data Set" which Roger Peng has made available on the course web site:
-
Dataset: Electric power consumption [20Mb] (also available as household_power_consumption.zip in this repository)
-
Description: Measurements of electric power consumption in one household with a one-minute sampling rate over a period of almost 4 years. Different electrical quantities and some sub-metering values are available.
The following descriptions of the 9 variables in the dataset are taken from the UCI web site:
- Date: Date in format dd/mm/yyyy
- Time: time in format hh:mm:ss
- Global_active_power: household global minute-averaged active power (in kilowatt)
- Global_reactive_power: household global minute-averaged reactive power (in kilowatt)
- Voltage: minute-averaged voltage (in volt)
- Global_intensity: household global minute-averaged current intensity (in ampere)
- Sub_metering_1: energy sub-metering No. 1 (in watt-hour of active energy). It corresponds to the kitchen, containing mainly a dishwasher, an oven and a microwave (hot plates are not electric but gas powered).
- Sub_metering_2: energy sub-metering No. 2 (in watt-hour of active energy). It corresponds to the laundry room, containing a washing-machine, a tumble-drier, a refrigerator and a light.
- Sub_metering_3: energy sub-metering No. 3 (in watt-hour of active energy). It corresponds to an electric water-heater and an air-conditioner.
When loading the dataset into R, please consider the following:
-
The dataset has 2,075,259 rows and 9 columns. First calculate a rough estimate of how much memory the dataset will require in memory before reading into R. Make sure your computer has enough memory (most modern computers should be fine).
-
We will only be using data from the dates 2007-02-01 and 2007-02-02. One alternative is to read the data from just those dates rather than reading in the entire dataset and subsetting to those dates.
-
You may find it useful to convert the Date and Time variables to Date/Time classes in R using the
strptime()
andas.Date()
functions. -
Note that in this dataset missing values are coded as
?
.
Our overall goal here is simply to examine how household energy usage varies over a 2-day period in February, 2007. The task is to reconstruct the following plots below, all of which were constructed using the base plotting system.
For each of the four plots, I have:
-
Constructed and saved it to a PNG file with a width of 480 pixels and a height of 480 pixels.
-
Named as
plot1.png
,plot2.png
, etc. -
Created a separate R code file (
plot1.R
,plot2.R
, etc.) that constructs the corresponding plot, i.e. code inplot1.R
constructs theplot1.png
plot.Each code file includes code for reading the data so that the plot can be fully reproduced. I have also included the code that creates the PNG file. -
Added the PNG file and R code file to this git repository
The four plots that needed to be constructed are shown below.
This plot is created by plot1.R. This code file:
- Reads in the data by sourcing readData.R, which contains a function that:
- Downloads and/or unzips the data if it not present in the working directory
- Reads in the data
- Subsets the data used for these plots
- Creates a
datetime
variable that contains the date and time in POSIXlt format - Sets the Date variable to date format
- Returns the data frame
- Opens a PNG device
- Builds the plot
- Closes the device, saving the plot as plot1.png
This plot is created by plot2.R. This code file:
- Reads in the data by sourcing readData.R, which contains a function that:
- Downloads and/or unzips the data if it not present in the working directory
- Reads in the data
- Subsets the data used for these plots
- Creates a
datetime
variable that contains the date and time in POSIXlt format - Sets the Date variable to date format
- Returns the data frame
- Opens a PNG device
- Sets up an empty plot
- Draws a line connecting each pair of (
datetime
,Global_active_power
) values - Closes the device, saving the plot as plot2.png
This plot is created by plot3.R. This code file:
- Reads in the data by sourcing readData.R, which contains a function that:
- Downloads and/or unzips the data if it not present in the working directory
- Reads in the data
- Subsets the data used for these plots
- Creates a
datetime
variable that contains the date and time in POSIXlt format - Sets the Date variable to date format
- Returns the data frame
- Restructures the data into long form so that all of the sub metering values are in a single column, with a variable indicating whether the value comes from
Sub_metering_1
,Sub_metering_2
, orSub_metering_3
- Opens a PNG device
- Sets up an empty plot
- Draws a black line connecting each pair of (datetime, submetering) values for
Sub_metering_1
- Draws a red line connecting each pair of (datetime, submetering) values for
Sub_metering_2
- Draws a blue line connecting each pair of (datetime, submetering) values for
Sub_metering_3
- Adds a legend showing what each line represents
- Closes the device, saving the plot as plot3.png
This plot is created by plot4.R. This code file:
- Reads in the data by sourcing readData.R, which contains a function that:
- Downloads and/or unzips the data if it not present in the working directory
- Reads in the data
- Subsets the data used for these plots
- Creates a
datetime
variable that contains the date and time in POSIXlt format - Sets the Date variable to date format
- Returns the data frame
- Creates a second data set in long form so that all of the sub metering values are in a single column, with a variable indicating whether the value comes from
Sub_metering_1
,Sub_metering_2
, orSub_metering_3
- Opens a PNG device
- Sets the
mfrow
parameter so that the device will have 4 plots in 2 columns and 2 rows, filling in by row - Creates the first plot using the wide format data:
- Sets up empty plot
- Draws a line connecting each pair of (
datetime
,Global_active_power
) values
- Creates the second plot using the wide format data:
- Sets up empty plot
- Draws a line connecting each pair of (
datetime
,Voltage
) values
- Creates the third plot using the long format data:
- Sets up empty plot
- Draws a black line connecting each pair of (datetime, submetering) values for Sub_metering_1
- Draws a red line connecting each pair of (datetime, submetering) values for Sub_metering_2
- Draws a blue line connecting each pair of (datetime, submetering) values for Sub_metering_3
- Adds a legend showing what each line represents
- Creates the fourth plot using the wide format data:
- Sets up empty plot
- Draws a line connecting each pair of (
datetime
,Global_reactive_power
) values
- Closes the device, saving the plot as plot4.png