Converting Data Types

In this exercise, we'll use Dataflows to load a file, cleanse the data a bit and change the data type of one of the columns. The file has a list of video games and their ratings from critic reviews. Most ratings are numeric (1.0 - 10.0), but some records have text entries ('Excellent') so we need to standardize the entries by assigning a numeric value to the Excellent ratings before we can convert the column to numeric type.

Note: If you get an error about an API rate limit, this usually happens because a previous Fabric task has not completed. You can view active Fabric tasks from the Monitor page (located on the left horizontal menu). Canceling old Fabric tasks in the Monitor page will usually resolve the rate limit error.