Creation of ISS Spacewalks - Makeover Monday
Earlier this year, I created one of my first Makeover Mondays on Spacewalks . This post walks through my data preparation steps and considerations I made while creating the visualization. Preparing the data set 1. Examine the data set for completeness I sorted each column to find missing data. The Spacewalkers column had some "n/a" fields so I filled in these values manually. 2. Add extra information to data set I wanted to add the nationalities of the Spacewalkers and countries of the spacesuits to the data set. For the nationalities, I used a vlookup to append the data based on the name. However, I did have to be careful about different name spellings used in the data set compared to Wikipedia . As for the spacesuits used in a spacewalk - I entered this manually based on the footnote symbols in Wikipedia . American spacesuits and Russian spacesuits were used depending on where the mission took place. 3. Final check I recreated the ori...