You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?
To analyze the complaints by the logged date and use a built-in date hierarchy, split the Logged column by using 'at' as the delimiter. This will separate the date and time parts, allowing you to format the date portion correctly and leverage date-based analysis tools effectively.
this question is repeat many times
Option A says , Extract the last 11 characters here, as opposed to First 11 in the Question 10 . therefore C is Correct.
This is the 3rd time this question has appeared. Now the answer is delimiter, with the presence of 11-char. 2/3 delimiter, 1 against 11-char. I think it is safe to say the answer to this question will always be delimiter.
Deja vu
Option C, This question was in Exam
correct answer
I have completed all the steps with dummy data, and yes, answer C is correct.
split by at delimiter
As many have said, this question is repeated many times.
Why Not A
It's not A because it is about extracting the last 11 characters rather than the first ones.
Not again..... C.
This question is the same as Question 10, can anyone please explain the difference between the answers given? (In Question 10 the answer given was to extract the first 11 characters)
wrong answer before probably. correct is to split using at as delimiter. check the discussions for the correct answer always
Answer C is correct. Duplicate question.
Answer C