how to save the data in csv file from the plot
141 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
muhammad choudhry
el 31 de Mayo de 2021
Comentada: Walter Roberson
el 31 de Mayo de 2021
Hi,
I am using the code below for extracting the wanted data from few excel files then plotting the extracting data but I am unable to save the plotted data into excel file. Can you guys help, please?
Code So Far:
% To access the folder
folder = fullfile('C:','Users','muhammad','Documents','1st_Yr','Experiments_2021','performance_110');
files = dir( fullfile(folder, '*.ods') );
% Reading and extracting data from 12 excel files hence plotting
for ii = 1:length(files)
data = readmatrix(fullfile(files(ii).folder,files(ii).name), 'NumHeaderLines', 1)
x= data(:,10)
y=data(:,4)
figure(1)
% Plotting data
plot(x,y,'x','LineWidth',0.5);
hold on
end
4 comentarios
Walter Roberson
el 31 de Mayo de 2021
It sounds like you want to save them numerically.
As you are processing a number of files, how do you want the values from one file to be arranged relative to the values for another file? For example are you wanting to write each one to a separate sheet? Are you wanting to write 2 * length(files) separate columns, alternating X and Y? (If so is it possible that different files are not the same size as each other?) Are you wanting to write all of the data together as a pair of columns, all of the first file then all of the second file, and so on? If so then how do you want to mark the boundary between files? Do you want to store the file name for every row? Do you want to store a "group number" (which in this case would be ii) for each row ?
Respuesta aceptada
KALYAN ACHARJYA
el 31 de Mayo de 2021
Editada: KALYAN ACHARJYA
el 31 de Mayo de 2021
Options:
- The plot is a figure, you can save as Matlab .fig files (Use save as option)
- Save the figure plot result as an image (imwrite)
- If you wish to save x & y numeric data, create a vector as follows & save using writematrix function (Excel/CSV)
result=[x_column_data,y_column_data]
writematrix(result,......) %see the write matrix Matlab Doc
2 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!