Undergraduate Websites, web programming

Project 15-3 File Cleaner

Project 15-3: File Cleaner
Create an application that reads a file that contains an email list, reformats the data, and writes the cleaned list to another file.

Console
File Cleaner

Source file:  prospects.csv

Cleaned file: prospects_clean.csv

Congratulations! Your file has been cleaned!

The prospect.csv file
FIRST,LAST,EMAIL

james,butler,[email protected]

Josephine,Darakjy,[email protected]

ART,VENERE,[email protected]

The prospect_clean.csv file
First,Last,email

James,Butler,[email protected]

Josephine,Darakjy,[email protected]

Art,Venere,[email protected]

Specifications
Your instructor should provide a CSV file named prospects.csv that contains a list of prospects.

Your application should fix the formatting problems and write a file named prospects_clean.csv.

All names should use title case (an initial capital letter with the rest lowercase).

All email addresses should be lowercase.

All extra spaces at the start or end of a string should be removed.