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.
  3 件のコメント
Mikayla
Mikayla 2022 年 6 月 30 日
Mikayla
Mikayla 2022 年 6 月 30 日

サインインしてコメントする。

回答 (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 ExchangeSpreadsheets についてさらに検索

製品

Community Treasure Hunt

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

Start Hunting!

Translated by