importdata not reading date and time columns

Question

Ben Keshet 2018-12-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/437152-importdata-not-reading-date-and-time-columns

评论： Walter Roberson 2018-12-27

I need to read a text file arranged in columns, using Matlab R2012a, and eventually have it as a matrix so I can plot the numeric data. I have tried multiple ways, eventually importdata commands brings me pretty to close to what I need.

Problem is that the first two columns which are date and time are simply ignored and not read.

THis is about how my text file looks like.

2018-12-24 08:16:10.338 900 0 7550.000 4.846 -113.000 0.001 7.18e-09 4.65e-10 8.24e-12

2018-12-24 08:16:10.588 901.296 0 7550.000 4.856 -113.000 0.001 7.18e-09 4.65e-10 8.25e-12

2018-12-24 08:16:10.838 808.345 0 7550.000 4.846 -113.000 0.001 7.18e-09 4.65e-10 8.78e-13

2018-12-24 08:16:11.089 930.345 0 7550.000 4.846 -113.000 0.001 7.18e-09 4.65e-10 5.67e-13

2018-12-24 08:16:11.339 1000.794 0 7550.000 4.846 -113.000 0.001 7.18e-09 4.65e-10 8.24e-12

My code:

delimiterIn = ' ';
T=importdata('file.txt',delimiterIn);

The T.data table starts with the 3rd columns only.

Appreciate your help.

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

请先登录，再进行评论。

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

Answer 1

ahmed nebli 2018-12-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/437152-importdata-not-reading-date-and-time-columns#answer_353844

编辑：madhan ravi 2018-12-25

i suggest you use the command "readtable" , see this link https://www.mathworks.com/help/matlab/ref/readtable.html

4 个评论
显示 2更早的评论隐藏 2更早的评论

Ben Keshet 2018-12-25

thanks. sorry for the basic question - how do I handle this variable?

I got a cell type variable (<1X11 cell>).

eventually I want to plot each of the columns from column 3-11 vs time to view the time trending.

Thanks.

Walter Roberson 2018-12-27

在 MATLAB Online 中打开

time = datenum( strcat(DataCell{:,1}, {' '}, DataCell{:,2}) );
numerics = cell2mat(DataCell(:,3:11));
plot(time, numerics);
datetick('x', 'MM:ss.fff');    %show only minute, second, fraction