Saving the selected .mat file and write it into csv

7 次查看（过去 30 天）

显示更早的评论

steamrice 2020-2-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/504114-saving-the-selected-mat-file-and-write-it-into-csv

评论： Guillaume 2020-2-10

采纳的回答： Guillaume

在 MATLAB Online 中打开

Hello there,

I was implmenting something similar from this post: https://www.mathworks.com/matlabcentral/answers/317297-uigetfile-load-m-file-variables-into-workspace and I want to get the selected .mat file and write it into csv. I have the following but I have the problem of saving it into .csv file

[baseFileName, folder] = uigetfile('*.mat');
fullFileName = fullfile(folder, baseFileName);
if exist(fullFileName, 'file')
    storedStructure = load(fullFileName);
else
    warningMessage = sprintf('Warning: mat file does not exist:\n%s', fullFileName);
    uiwait(errordlg(warningMessage));
    return;
end
cHeader = {'x' 'y' 'z'}; %dummy header
commaHeader = [cHeader;repmat({','},1,numel(cHeader))]; %insert commaas
commaHeader = commaHeader(:)';
textHeader = cell2mat(commaHeader); %cHeader in text with commas
%write header to file
%write data and save it to .csv
fid = fopen(fullFileName,'w');        
fprintf(fid,'%s \n',textHeader);
fclose(fid);
dlmwrite(fullFileName,storedStructure.data,'-append');

I think I have problem in the secotion of %write data and save it to .csv using fullFileName. I do not know how to do it properly since we do not have one fixed file to write into. Thanks!

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

请先登录，再进行评论。

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

采纳的回答

Guillaume 2020-2-6

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/504114-saving-the-selected-mat-file-and-write-it-into-csv#answer_414205

在 MATLAB Online 中打开

Assuming that storedStructure.data is a matrix with 3 columns, the simplest way to save to csv is with:

writetable(array2table(storedStructure.data, 'VariableNames', {'x', 'y', 'z'}), fullfilename, 'FileType', 'text');

Note that I would recommend changing the extension of the filename from .mat to .csv so that it's not misleading.

18 个评论
显示 16更早的评论隐藏 16更早的评论

steamrice 2020-2-9

@Walter Roberson I am still only work with the number of columns I have (according to my data). Other than that, its it possbile to save out the user input (from prompt) and write it into the same .csv?

Walter Roberson 2020-2-9

As this is for csv files, see my discussion at https://www.mathworks.com/matlabcentral/answers/503384-xlswrite-overwrites-data-despite-setting-a-specific-range#answer_413819

请先登录，再进行评论。

更多回答（1 个）

steamrice 2020-2-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/504114-saving-the-selected-mat-file-and-write-it-into-csv#answer_414699

Thanks for the response!

I think you mentioned, "I need to emphasize that this cannot be used to add new columns to a csv file."

Does that mean its not possbile to combine the user input from prompt with the after-data-anaylsis into the same .csv?

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

Walter Roberson 2020-2-10

编辑：Walter Roberson 2020-2-10

Does that mean its not possbile to combine the user input from prompt with the after-data-anaylsis into the same .csv?

No, it does not mean that.

If you have an existing .csv file and you want to add new rows to it, then you can do that by appending to the file without changing what is already there.

If you have an existing .csv file and you want to add new columns to it, then there is no way to do that without changing what is already there. None of the Mathworks-supplied functions can add new columns to a .csv file: they can only add new rows or they can rewrite the entire file, destroying whatever is currently in it.

In other words, if you want to add new columns to a .csv, then what you need to do is read in all of the existing data from the .csv, and add more columns to what you read in, and then write the old data together with the new data overtop of the file.

It is simply not technically possible to add new columns to a text file without rewriting from the end of the old first line completely through to the end of the file -- but by the same measure, if you do bother to read in the existing data, you can certainly write it out with new data as well.

steamrice 2020-2-10

Question: If adding new row, wouldn't it affect my data (three column) as well?

In addition, would you mind direct me if I want to try this method?

"if you want to add new columns to a .csv, then what you need to do is read in all of the existing data from the .csv, and add more columns to what you read in, and then write the old data together with the new data overtop of the file."

Guillaume 2020-2-10

在 MATLAB Online 中打开

As said, you'd be better off starting a new question. You'd likely get more contributors.

"If adding new row, wouldn't it affect my data"

Not sure what you mean by that. new rows are added to the end of the file by using the OS file append mode. This does not touch data earlier in the file.

"would you mind direct me if I want to try [adding new columns]"

Here you need to a number of difficulties. Do you need to preserve the exact text formatting of the earlier columns, including number format, separator(s) (type and number if using spaces/tabs for example), etc.? Do you have to detect the formatting or can your code just assume the formatting?

The simplest way, which may not preserve the formatting is to read your file with your favorite csv reading function (readmatrix, readtable, csvread, dlmread, importdata (avoid that one)), append your new columns to the data and rewrite with the matching function to the one you used to read (writematrix, writetable, csvwrite, dlmwrite).

olddata = readmatrix(somefile);
appended = [olddata, newdata];  %newdata must be a matrix with as many rows as olddata
writematrix(appended, somenewfile);

If you need to preserve formatting and autodetect the formatting, it could be significantly more complicated.

请先登录，再进行评论。

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