New guy - learning how to clean up and parse a CSV file

WesCo2019

I am new to data analysis and preparing a data set. I have a CSV file with the time stamp in the following format: "2018/05/14:12:00:00 PM."

What is a recommended way to "parse" the time stamp into Year, date, and time components to make it easier to sort and filter?

Thanks!

sgenzer

嗨@WesCo2019- you're going to want to first put it into a date-time data type:





至于解析,我将使用“生成Attributes" to create separate attributes for each piece you want:

Hope that helps.

Scott

hughesfleming68

You can also define the date-time format in the csv import wizard and save one step. WhichI see Scott has already pointed out. I didn't see the first image.

Telcontar120

Or you can use "Date to Numerical" and then specify the date component you want to extract.

WesCo2019

Thanks to all for the helpful insght