Question: In python I cant stress this enough! You will be provided with a comma delimited file called DirtyNames.csv this file consists of thousands of names

In python I cant stress this enough!
 In python I cant stress this enough! You will be provided

You will be provided with a comma delimited file called DirtyNames.csv this file consists of thousands of names that are horribly formatted and must be cleaned up. A clean name is all lower case letters except the first letter which must be capitalized. In addition, some of the names have symbols or other invalid characters, if a name contains an invalid character it should be put in a separate file called InvalidNames.csv. Clean names should be put in CleanNames.csv. A dirty name will consist of a name with randomly placed upper and lowercase letters and is valid but needs to be reformatted. For example: Should be reformatted to - Jordan A clean name should be formatted with an uppercase first letter followed by lowercase letters. However, if a name is hyphenated the name after the hyphen should also start with an upper case letter. For example: - Jordan - Pitt-Rivers Invalid names are entries in the lst that are not names at all or names that contain invalid symbols. For the purpose of this task a name should be considered valid if it only contains letters a-z, A-Z, or a hyphen. Any other symbols (including spaces and numbers) should put the name in the invalid name list. Examples of invalid names: 123-123-1234 - Jake -John Doe

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!