Writing Multiple CSV files

9 次查看（过去 30 天）

Curious Mind 2017-11-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/366193-writing-multiple-csv-files

编辑： per isakson 2017-11-10

I have a dataset which has about 20 spectra. All 20 spectra share the same x-axis. So I have 21 columns, column 1 representing the x-axis and columns 2 to 21 representing the y values. I want to save the data 20 separate .csv files. Csvwrite just combines all the data into one large csv files which is not what I want. I want a code that can save cloumn 1 and 2 separately, 1 and 3 separately, 1 and 4 separately and so on till column 1 and 21 so that in the end I will have 20 separate csv files each having column 1 as the x-axis and the corresponding y column as y-axis.

Look forward to hearing from someone and I would really appreciate it.

Thanks.

5 个评论
显示 3更早的评论隐藏 3更早的评论

Curious Mind 2017-11-10

Please what does M stands for in your code? Is it the data file name?

per isakson 2017-11-10

编辑：per isakson 2017-11-10

M is your dataset with 21 columns
sprintf( 'y%d.csv', jj ) creates a filename

请先登录，再进行评论。

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

采纳的回答

KSSV 2017-11-10

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/366193-writing-multiple-csv-files#answer_290315

在 MATLAB Online 中打开

A = rand(10,11) ;
%%Write each colum to different files 
for i = 2:size(A,2)
    filename = ['column',num2str(i),'.csv'] ;
    csvwrite(filename,A(:,[1 i]))
end

2 个评论
显示无隐藏无

Curious Mind 2017-11-10

@KSSV will this save my data into 20 separate csv files? I don’t want 1 large file. Can you please explain your approach for me? Thank you

KSSV 2017-11-10

编辑：KSSV 2017-11-10

It is straight forward.....run a loop for each column and use csvwrite for each column with different file names. You run the above code and see. YOu can replace A with your data.

请先登录，再进行评论。