1. Learn
    2. /
  2. Courses
    3. /
  3. ETL and ELT in Python
Connected

Exercise

Transforming sales data with pandas

Before insights can be extracted from a dataset, column types may need to be altered to properly leverage the data. This is especially common with temporal data types, which can be stored in several different ways.

For this example, pandas has been import as pd and is ready for you to use.

Instructions

100 XP
  • Update the transform() function to convert data in the "Order Date" column to type datetime.
  • Filter the DataFrame to only contain rows with "Price Each" less than ten dollars.
  • Print the data types of each column in the DataFrame.