Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

CAN YOU CODE IT IN PYTHON!! And the last guy answers this sayingbhis nerwork is down. That all I got if you cant answer it

CAN YOU CODE IT IN PYTHON!! And the last guy answers this sayingbhis nerwork is down. That all I got if you cant answer it let someone else . image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Using Entity Relationship Diagrams

Authors: Sikha Saha Bagui, Richard Walsh Earp

3rd Edition

103201718X, 978-1032017181

More Books

Students also viewed these Databases questions

Question

Why is the System Build Process an iterative process?

Answered: 1 week ago