Data Ingest

[JBraunsmaJr]

Category

Data Analytics

Description

Your company is ingesting a data source. You must sanitize incoming values.

Acceptance Criteria

For sake of the challenge,
Valid and invalid records shall be returned as two arrays (tuple)

Any row with a null value is invalid
Any DOB in the future, or invalid format is invalid
Any row with an invalid experience option is invalid

Valid records shall:

• have sanitized names
• Contain valid date of births
• Experience level that is valid

Valid options

• White Belt
• Green Belt
• Yellow Belt
• Red Belt
• Blue Belt
• Black Belt

Example content

Name: first position
DOB: second position
Experience: third position

[
    ["First last", "01-01-1990", "Black Belt"],
    [None, "12-15-1999", "White Belt"]
]