How to read row1 as datetime

3 次查看（过去 30 天）
Yasuyuki Hamanaka
Yasuyuki Hamanaka 2021-5-24
评论： Yasuyuki Hamanaka 2021-5-29
I read below table using readtable(). I wnat to read first and second column of the first row as string. But after the third clumn, I want to read data as datetime. And other data should be read as double. How can I do that?

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

采纳的回答

Uday Pradhan
Uday Pradhan 2021-5-27
编辑：Uday Pradhan 2021-5-27
Hi,
To read the first row in the specified format, you could try:
t = readtable('yourDataOnlyRow1','Format','%s %s %{mm/dd/yyyy HH:MM}D %{mm/dd/yyyy HH:MM}D %{mm/dd/yyyy HH:MM}D','TextType','string','ReadVariableNames',false)
where the file yourDataOnlyRow1 contains only the first row of your data. For the rest of the data, you could do:
t1 = readtable('yourData','Format','%f%f%f%f%f','ReadVariableNames',false,'HeaderLines',1) %exclude the first row from the original data file
These two table cannot be joined due to conflicting data types. Perhaps try reformatting your data and have a look at the following documentation pages:table2timetable,readtable.
Note:To get the data as a table with text entries, try:
>> t1 = readtable('yourData.txt','Format','auto')
t1 =
2×5 table
Var1 Var2 Var3 Var4 Var5
____________ ______________ __________________ __________________ __________________
{'Depth ()'} {'Channel ()'} {'4/5/2018 11:10'} {'4/5/2018 12:10'} {'4/5/2018 12:12'}
{'1' } {'2' } {'3' } {'4' } {'5' }
  1 个评论
Yasuyuki Hamanaka
Yasuyuki Hamanaka 2021-5-29
Thank you for replying. I used readtable() and read the date as numeric. After that, I reform the data to date using datetime().
During coding, I noticed that using readtable() to read data as datetime is much slower than as numeric data. Is this correct?

请先登录，再进行评论。

更多回答（0 个）

类别

在 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