DataPalooza 2021

DATA UPLOAD WORKSHOP

Figure 9 - Convert to Attribute

Now that FDIC Cert is an Attribute, we will click on the Wrangle option seen in figure 9.

WRANGLE Wrangle allow us to clean up the data we are working with before we move it into our dossier. Take notice that all the text data in column Name are in all CAPS. This doesn’t really follow the format form our existing dataset and looks messy. Pick the Name column and select the Title Case function. Title Case will make it so that each word starts with a capital letter but everything else is lower case. Next, we notice that the Name column still has a small error in it - “Of” is capitalized. To fix this select the Name column again and use the Find and Replace Function to replace “Of” with “of”. These are small fixes but it is still important to clean and prepare all of your data, so it is ready to be analyzed. Our final step for Wrangling the text data is fixing the column City. Like the Name column all the Cities are in all CAPS. Again, we’ll use the same Title Case function.

7 | P a g e