Do calculations in csv data one csv file at the time
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Martin Kneyber
el 27 de Abr. de 2024
I have several csv files. Want to perform calculations on the data in the csv file, for example calculating variable x. Then, I want one table with in the first column the filename of each csv file and then in the next column the calculated variable x. How can I do this? Newbie,so sorry for asking.
3 comentarios
Dyuman Joshi
el 27 de Abr. de 2024
Use readtable or readmatrix to import the data, and their counter-parts writetable or writematrix to export the data.
Respuesta aceptada
Voss
el 27 de Abr. de 2024
Something like this; adjust as necessary.
% use dir() to get info about the relevant csv files:
csv_dir = '.';
F = dir(fullfile(csv_dir,'*.csv'));
filename = fullfile({F.folder},{F.name}).';
% preallocate x. I assume it's a scalar numeric for each file
N = numel(F);
x = zeros(N,1);
% loop over the files
for ii = 1:N
% read each file (use the appropriate function with the appropriate options)
data = readtable(filename{ii});
% ...
% calculate this_x based on data
% ...
% store this_x
x(ii) = this_x;
end
% write file with file names and x values
T = table(filename,x);
writetable(T,'out.csv')
2 comentarios
Más respuestas (1)
Ver también
Categorías
Más información sobre Data Import and Analysis 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!