Run a calculation on multiple different .csv files and export the result

Question

Lucas 2024-9-30，17:11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2156515-run-a-calculation-on-multiple-different-csv-files-and-export-the-result

评论： Voss 2024-9-30，19:45

Hello all!

I am new to MATLAB but I am working on performing matrix calculations. I have the calculation code nailed down. The problem is I have 500+ .csv files that I have to read in, perform the calculation, and export each separately.

Is there a way to read in a folder of .csv files, perform my calculation on each, and then export the result of each 500+ calculations to one place?

%so this grabs one single .csv file and performs my calculation%
>> filename='THESISv1-DATA.csv';
M=csvread(filename);
>> S = sum(abs(M(2:end,:)-M(1:end-1,:)),1)

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Voss 2024-9-30，17:45

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2156515-run-a-calculation-on-multiple-different-csv-files-and-export-the-result#answer_1524935

See my recent comment on a closely related question:

https://www.mathworks.com/matlabcentral/answers/2156490-subtracting-matrices-by-column-and-performing-a-summation#comment_3272485

2 个评论
显示无隐藏无

Lucas 2024-9-30，19:17

Thanks Voss!

Voss 2024-9-30，19:45

You're welcome!

请先登录，再进行评论。

Answer 2

Yukthi S 2024-9-30，18:20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2156515-run-a-calculation-on-multiple-different-csv-files-and-export-the-result#answer_1524945

在 MATLAB Online 中打开

Hi @Lucas

To automate the process of reading multiple .CSV files, performing operations and storing the results in one place, a simple “for” loop can be used.

The below code snippet will help you to get started.

% Define the input and output directories
inputDir = 'path/to/your/csv/files';  % Replace with input directory path
outputDir = 'path/to/save/results';   % Replace with output directory path
% Get a list of all CSV files in the input directory
csvFiles = dir(fullfile(inputDir, '*.csv'));
% Loop through each file
for k = 1:length(csvFiles)
    % Construct the full file path
    inputFile = fullfile(inputDir, csvFiles(k).name);
    
    % Read the CSV file
    M = csvread(inputFile);
    
    % Perform the calculation
    S = sum(abs(M(2:end,:) - M(1:end-1,:)), 1);
    
    % Construct the output file path
    [~, fileName, ~] = fileparts(csvFiles(k).name);
    outputFile = fullfile(outputDir, [fileName, '_result.csv']);
    
    % Save the result to a new CSV file
    writematrix(S, outputFile);
end
disp('Processing complete. Results saved.');