How to read row1 as datetime

Question

Yasuyuki Hamanaka 2021-5-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/838595-how-to-read-row1-as-datetime

评论： 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?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Uday Pradhan 2021-5-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/838595-how-to-read-row1-as-datetime#answer_710720

编辑：Uday Pradhan 2021-5-27

在 MATLAB Online 中打开

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'             }