convert time series struct to csv file

118 次查看（过去 30 天）
Davindra Usov
Davindra Usov 2023-1-17
评论： Davindra Usov 2023-1-19
Hello,
I have a 1x1 struct called 'fluid_data' with 13 fields where each field is a 400000 x 1 timetable. In each field, there is a 'time' column and a quantity column e.g. 'viscosity'. These headings are in the field.
I am trying to make this into a csv file called "my_csv_file" with this code but it will not accept timeseries
fluid_data = load('property_values.mat');
writestruct(fluid_data,"my_csv_file.csv");
'property_values.mat' is an output file I created earlier in the code. This contains simulink timeseries data. So I am converting this file into a struct called 'fluid_data' and then converting this into a csv file called "my_csv_file"
Thank you

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

采纳的回答

Gowthami
Gowthami 2023-1-18
Hi Davindra,
It is my understanding that you trying to convert a MAT file to a CSV file when the MAT file has structures in it.
If the MAT file contains a structure, we would not know which fields to save into the CSV file.
One possible solution is to load the MAT file to the MATLAB Workspace, then convert the structure to a table. For example, if the MAT file has the following structure:
>> S.Name = {'CLARK';'BROWN';'MARTIN'};
>> S.Gender = {'M';'F';'M'};
>> S.SystolicBP = [124;122;130];
>> S.DiastolicBP = [93;80;92];
You can convert the structure array to table and then use the "writetable" function to write the table to a CSV file, as follows:
>> T = struct2table(S)
>> writetable(T,'test.csv')
Please refer to the following link for more information on using the "writetable" function: https://www.mathworks.com/help/matlab/ref/writetable.html

更多回答（0 个）

类别

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

标签

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by