you have finished cleaning the data to ensure it is complete, correct, and relevant to the problem you’re trying to solve. then, you complete the verification and reporting processes to share the details of your data-cleaning effort with your team. your team notes one aspect of data cleaning that would help improve the dataset. they point out that the new survey also has a new question in column g: "what are your favorite indoor paint colors?" this was a free-response question, so respondents typed in their answers. some people included multiple different colors of paint. in order to determine which colors are most popular, it will be necessary to put each color in its own cell. you use a spreadsheet function to divide the text strings in column g around the commas and put each fragment into a new, separate cell. in this example, what are the commas called?



Answer :

Other Questions