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.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 overgreater than a certain threshold. There are a variety of functions for filtering underwithin each column.

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

Now that we haveUsing the basic functions down,described weabove, you can update the snapshotsnapshot, and createyou can use the mapsnapshot byto selectingpopulate one or more swarms within the correctFlow.

If aggregations are performed within a snapshot, hierarchy levels are automatically inserted into the snapshot underdataset, source.and First,often wea createFlow Filter is used to select the mapdesired usinghierarchy latitude and longitude by selecting the appropriate chart type and snapshot under Chart. 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.