Creating a Timetable from a large excel data set

1 view (last 30 days)
I have only have basic matlab training- and that has been a while- and I am currently struggling on manipulating this large data set.
I am trying to turn this data set into a timestable. However, I get an error code saying that I need a datetime or duration vector. I attempted to create a datetime but I haven't found a way to do that where I don't have to type everything in individually.
My other problem- my time data (day, month, year, hour, minute, second) is all in a single column. So I am not sure how to break apart the data, again without doing every individual term.

Answers (1)

MJFcoNaN
MJFcoNaN on 1 Jul 2022
Hello,
What type is the AbsTime? Does this one work?
t=table2timetable(m137);
  2 Comments
Mikayla
Mikayla on 1 Jul 2022
No that doesn't work. One of the pictures I posted in the comments showed that I had tried that and that is where I got the error code of needing a datetime or duration variable.
I don't know about the type of Abstime. It's formatted into a single column of month/day/year hour:minute.
I separated this data out into multiple columns in excel but still can't figure out how to make a datetime.
MJFcoNaN
MJFcoNaN on 2 Jul 2022
Edited: MJFcoNaN on 2 Jul 2022
Sorry, I don't find in which picture you tried the code ("m137" as the input of table2timetable) and the consequent error.

Sign in to comment.

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!