Writing Multiple CSV files
显示 更早的评论
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 个评论
per isakson
2017-11-10
编辑：per isakson
2017-11-10
Something like this?
for jj = 2:21
csvwrite( sprintf( 'y%d.csv', jj ), M(:,[1,jj]) );
end
KSSV
2017-11-10
IT is better to have all the data in single csv files.
Curious Mind
2017-11-10
Curious Mind
2017-11-10
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
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
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Text Files 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
