Exercise: Data Typing and Structuring

Data typing

Suppose we extracted a dataset that includes a field called Price that represents the price of a product in dollars. However, upon further inspection, we noticed that the column’s data type is a string instead of a float. Furthermore, the prices are formatted with a dollar sign and comma, such as '$1,000.00'.

We know the data should eventually be loaded into a database table with a column data type of float. Our task is to remove the dollar sign and commas from the Price column and then convert the data type to float.

Let’s look at the Price column using the head() method, which prints the first five values in the column. It also prints the column’s data type, which is Object. The Object data type is used for strings in pandas.