How to convert time column into a regular array?
조회 수: 51 (최근 30일)
이전 댓글 표시
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
Stephen23
2022년 1월 21일
"Can someone suggest a better way?"
Convert the "time series" to datetime objects and plot using them.
채택된 답변
Star Strider
2022년 1월 21일
댓글 수: 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일
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']}}
Aa = datetime([A{:}], 'InputFormat','yyyy-MM-dd HH:mm:ss.SSS', 'Format','yyyy-MM-dd HH:mm:ss.SSS').'
Using the same format descriptor string for both 'InputFormat' and 'Format' causes the output to match the input.
.
추가 답변 (1개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Type Conversion에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!