How to convert time column into a regular array?

Question

Anjali Mishra 2022-1-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1633580-how-to-convert-time-column-into-a-regular-array

评论： Anjali Mishra 2022-1-21

I have a table with first column as time series, and other columns as other parameters that changes with time. I want to convert the time series into an array for plaotting. I tried following code:

A_time = A(:,1);

A_time_array = table2array(A_time);

This method works for all the numeric columns. However, it errors out in the time column. Can someone suggest a better way?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Stephen23 2022-1-21

"Can someone suggest a better way?"

Convert the "time series" to datetime objects and plot using them.

请先登录，再进行评论。

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

Answer 1

Star Strider 2022-1-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1633580-how-to-convert-time-column-into-a-regular-array#answer_879150

If the time series are a datetime array, they can easily be plotted as funcitons of that variable. It would be best to convert them to a datetime array if they are not already.

The other (less-desirable) option is to convert them to a datenum array and then use the datetick function.

.

2 个评论
显示无隐藏无

Star Strider 2022-1-21

Anjali Mishra’s Answer became this Comment —

Thank you Star Stider. Here is the scenario. A is a table with first column as time and other columns as other parameters. A am

>> A(:,1)

A(:,1)=

4×1 cell array

{[2021-11-14 19:16:02.328]}

{[2021-11-14 19:16:02.430]}

{[2021-11-14 19:16:02.533]}

{[2021-11-14 19:16:02.640]}

>> temperature = table2array(A(:,2));

This is expected to be x-axis on the plot with temperature

>> plot(A(:,1), temperature, 'r*')

results into A_time being invalid arguments.

Is there a way to keep this format of time as in 2021-11-14 19:16:02.328?

Star Strider 2022-1-21

在 MATLAB Online 中打开

Those dates and times must be present in the file as character or string arrays. It is not possible to work with them as they are presented, so having the original file would help.

Assuming that they are (or can be made to be) read as character arrays or string arrays, the conversion is straightforward —

A = {{['2021-11-14 19:16:02.328']}
    {['2021-11-14 19:16:02.430']}
    {['2021-11-14 19:16:02.533']}
    {['2021-11-14 19:16:02.640']}}
A = 4×1 cell array
    {1×1 cell}
    {1×1 cell}
    {1×1 cell}
    {1×1 cell}
Aa = datetime([A{:}], 'InputFormat','yyyy-MM-dd HH:mm:ss.SSS',  'Format','yyyy-MM-dd HH:mm:ss.SSS').'
Aa = 4×1 datetime array
   2021-11-14 19:16:02.328
   2021-11-14 19:16:02.430
   2021-11-14 19:16:02.533
   2021-11-14 19:16:02.640