Converting data types
When you upload data to Devo from a file, all data except for dates is assigned the string data type. For numerical expressions, this can cause errors during analysis. Therefore, it is important to review the data types of key fields and change them as needed.
In our my.upload.test.markets example, we have uploaded the data and parsed the information into columns. Our table contains longitude and latitude coordinates that we can later use to visualize the table data on a map. But first, for this information to be understood as geographical coordinates, we need to change the data types of the Latitude and Longitude columns from strings to numbers.
- First, click the Latitude column header to select the column.
- Select Create Column in the toolbar.
- In the Create Column dialog box, open the Operation dropdown list and select To Float. This operation changes strings to numbers. Now, enter LatitudeFloat as the Column Name, then click Create Column.
- Repeat the same for the Longitude column, naming the new column LongitudeFloat.