TidyX 65: Cleaning ugly excel data, Part 2

In the last episode, I took my crack at cleaning some messy excel data. This week, it is Ellis’ turn!

While we took two different approaches to clean the data, we end up with the same result — a data frame of data that can be analyzed.

The key take-a-ways from this two part series are:

  1. There are more than one ways to scale the mountain in R.
  2. We both take a chunking approach,  where we work with a single excel sheet first and try to wrap our head around the problem and develop an approach to solve it.
  3. Once we’ve setup an approach that we think will be useful, we both built functions that could parse all of the sheets in the excel file, returning our cleaned data frame.

To watch our screen cast, CLICK HERE.

To access our code, CLICK HERE.

Happy cleaning!