Assignment

Students must create one R script called $$clean$\_$data.R$$ that does the following:$-$

$$ Use $($prefix$)$ the portable code snipper.R provided to ensure probability of your script.

$$ Download the zipped data set and manually placed as described in the snippet. All other steps are done in the script.

$$ Unzip the data set.

$$ Merge the three $(3)$ data files provided to create one data file.

$$ Clean the data to provide the features $($columns$)$ and observations $($rows$)$ required.

$$ Create meaningful column $($also called features or variables or attributes$)$ labels. Use the fourth file provided and import the feature labels, as these labels reflect exactly what you expected to find in the data.

$$ Appropriately label the data set with these descriptive variable names.

$$ Save this dataset.

$$ From the data set in the step above, create a second, independent tidy data set where the twelve $(12)$ historical sales are replaced by quarterly $(4)$ sums.

$$ Add an average sales column also.

$$ Save this dataset.