Transform Data

The Data Transformer is helpful for editing and manipulating your csv files and Google Sheets. Upon importing the default raw data, we can create a snapshot of data. Feel free to rename this snapshot to whatever is most applicable to your dataset. It's helpful to autosize columns to see the entirety of the values within the rows. Here are some basic functions:

• Group by column name or attributes. We do this function by dragging and clicking into the top area of the window in which the data is displayed.

• Perform calculations such as averages, summations, etc. on numerical columns. In this application, we can average the latitude and longitudes in each group to generally figure out where continents would be. Additionally, we can sum populations or any other metric within each continent. 

• Filter either numerically or categorically. For example, we can show just China, or maybe find countries with populations greater than a certain threshold. There are a variety of functions for filtering within each column.

• Sort either alphabetically or numerically. We do this by using the valuation first mechanism.

Using the basic functions described above, you can update the snapshot, and you can use the snapshot to populate one or more swarms within the Flow.

If aggregations are performed within a snapshot, hierarchy levels are automatically inserted into the snapshot dataset, and often a Flow Filter is used to select the desired hierarchy levels.

To get back to your edited data snapshot, click the Edit button in your Data Source menu. Remember to select the appropriate snapshot in the Data Transformer to make further edits.