DataPalooza 2021

DATA UPLOAD WORKSHOP

Figure 7 and 8. Upload the CSBS District CSV and get to the prepare data section. As we see in Figure 16 there is an add a new table section on the top left of the preview window. We will want to click that an navigate to clipboard so we can paste our wiki data, see figure 15.

Figure 15 – Clipboard

Once done we will have our two datasets displayed in Figure 16.

Figure 16 - Preview

WRANGLING In our wiki data we will want to clean the text. Select Remove Row(s) Where Cell Is Empty and select Alpha Code. This will remove empty cells from our state data. See Figure 17.

11 | P a g e