How to convert time series table into an array and save as an excell file?

17 次查看（过去 30 天）
Piyumal Samarathunga
回答： Corey Silva 2023-3-14
I have data collected from accelerometers, and that data is saved in a timetable.
I have saved that timetable data as a .mat file.
The data in this .mat file is of the duration data type.
I used the table2array function to convert this table to array.
Following is my code and data set that I used.
load('2023_02_16_F300_NSH_Free_NIacc_data_1.mat', 'NI_Data')
New = table2array(NI_Data)
When I use that function, it indicates that all of my variables as sec values, and data type shows as duration.
How I can convert a time series table into an array as data format as double and how to remove the suffix sec at the end of each data?
Thank you.

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

回答（2 个）

Askic V
Askic V 2023-2-18
编辑：Askic V 2023-2-18
Ran in:
I think this code could help you:
%load('2023_02_16_F300_NSH_Free_NIacc_data_1.mat', 'NI_Data')
load(websave('2023_02_16_F300_NSH_Free_NIacc_data_1.mat','https://www.mathworks.com/matlabcentral/answers/uploaded_files/1299495/2023_02_16_F300_NSH_Free_NIacc_data_1.mat'))
New = table2array(NI_Data);
time_sec = seconds(New(:,1));
acc_1 = seconds(New(:,2));
plot(time_sec, acc_1)
Regarding saving into an Excel file, I suggest to look this part of the documentation:
https://www.mathworks.com/help/matlab/import_export/exporting-to-excel-spreadsheets.html
Matlab has an excellent documentation with a lot of examples.
Corey Silva
Corey Silva 2023-3-14
You can use writetimetable to write a timetable to an excel spreadsheet without any conversions needed.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2022b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by