Creating a Timetable from a large excel data set

1 次查看（过去 30 天）
Mikayla
Mikayla 2022-6-30
编辑： MJFcoNaN 2022-7-2
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.

请先登录，再回答此问题。

回答（1 个）

MJFcoNaN
MJFcoNaN 2022-7-1
Hello,
What type is the AbsTime? Does this one work?
t=table2timetable(m137);
  2 个评论
Mikayla
Mikayla 2022-7-1
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 2022-7-2
编辑：MJFcoNaN 2022-7-2
Sorry, I don't find in which picture you tried the code ("m137" as the input of table2timetable) and the consequent error.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by