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

WesCo2019WesCo2019 Member Posts: 2 Newbie
edited December 2018 in Help
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!

Best Answer

Answers

  • hughesfleming68hughesfleming68 Member Posts: 323 Unicorn
    edited December 2018
    You can also define the date-time format in the csv import wizard and save one step. Which I see Scott has already pointed out. I didn't see the first image.
  • Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 Unicorn
    Or you can use "Date to Numerical" and then specify the date component you want to extract.
    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
  • WesCo2019WesCo2019 Member Posts: 2 Newbie
    Thanks to all for the helpful insght
Sign In or Register to comment.