Writing Multiple CSV files

8 次查看（过去 30 天）
Curious Mind
Curious Mind 2017-11-10
编辑： 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更早的评论
Curious Mind
Curious Mind 2017-11-10
Please what does M stands for in your code? Is it the data file name?
per isakson
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
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
  2 个评论
Curious Mind
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
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.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by