process data from dirty to clean weekly challenge 4 answers
2. What is the first step in the verification process?
- Compare cleaned data with the original, uncleaned dataset and compare it to what is there now
- Create a chronological list of modifications made to the data
- Determine the quality of the data
- Inform others of your data-cleaning effort
3. Which of the following functions automatically remove extra spaces when cleaning data?
- SNIP
- REMOVE
- TRIM
- CLEAR
4. What tool can a data analyst use to figure out how many identical errors occur in a dataset?
- CASE
- COUNTA
- CONFIRM
- COUNT
5. Fill in the blank: A data analyst uses the CASE statement to consider one or more _____, then returns a value.
- additions
- conditions
- identifications
- changes
6. What is the process of tracking changes, additions, deletions, and errors during data cleaning?
- Recording
- Observation
- Cataloging
- Documentation
7. Fill in the blank: While cleaning data, a data analyst can use a changelog to keep a chronological list of changes they make. They can refer to it during the _____ period if there are errors or questions.
- presenting
- verification
- documentation
- visualization
Shuffle Q/A 1
9. In what step of the data-cleaning process do you find mistakes before you begin analyzing the data?
- Confirming
- Publishing
- Verifying
- Processing
10. During the data cleaning process you find a significant amount of data that contains irrelevant spaces. Which function do you use to remove leading, trailing, or repeated spaces?
- CUT
- DELETE
- TRIM
- TIDY