1. Learn
    2. /
  2. Courses
    3. /
  3. ETL in Python

Exercise

Writing to CSV

You just read a CSV file and printed the first row. You're now ready to edit the file header and save the rows in a new .csv file. Changing the file header for shorter column names without spaces will make managing columns more manageable in the long run.

Then, you will write the header and the first row into a new CSV file named PPR-2021-Dublin-new-headers.csv.

Instructions 1/2

undefined XP
    1
    2
  • Complete the dictionary mapping to update the column names. date_of_sale is already defined; you need to add address, postal_code, county, price, description.