1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Data Pipelines

Exercise

Customizing a CSV file

Sometimes, data needs to be stored in a CSV file in a customized manner. This may include using different header values, including or excluding the index column of a DataFrame, or altering the character used to separate columns. In this example, you'll get to practice this, as well as ensuring that the file is stored in the desired file path.

The pandas library has been imported as pd, and the data has already been transformed to include only rows with a "Quantity Ordered" greater than one. The cleaned DataFrame is stored in a variable named clean_sales_data.

Instructions

100 XP
  • Import the os library.
  • Write the cleaned DataFrame to a CSV stored at path_to_write, without a header.
  • Ensure the file was written to the desired path.