Date & time error
Hey everyone,
I’m encountering an issue with a CSV file. It seems that some rows are shifted to the right. Out of over 300,000 rows, there are approximately 600 rows like this. I’m not sure if this is due to a comma or some other reason. Even if I want to delete these rows, I’m unsure about how to do it. I’ve attempted to use the row filter node, but it’s complicated. Additionally, the data type is supposed to be date and time, but it’s showing as a string, and I’m unable to convert it because of these rows.
Any help would be appreciated, but I would prefer a step-by-step explanation.
link of dataset