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.
