Creating a Timetable from a large excel data set

2022 6 30
1 个回答
更新时间：2022 7 2
4 次查看（30 天）

0 个投票

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

0 个投票

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.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息

产品

标签

提问:

Mikayla
Mikayla
2022-6-30

编辑：

MJFcoNaN
MJFcoNaN
2022-7-2

Community Treasure Hunt

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

Start Hunting!

Translated by