How to read CSV file and save the result to another CSV file

3 views (last 30 days)
Hello.
I have several CSV files.
After processing each CSV file, I want to save each CSV file to other name using for loop.
The names of input file are different (bend1.csv, walk2.csv, jogging2.csv, ....)
clear all
close all
X = csvread('bend1.csv');
X = X(:,1:28);
data = X';
% After processing......
% I want to each Y matrix to CSV files
Y = Phi_NuMax * X';
csvwrite('/result/bend1.csv', Y);
  2 Comments

Sign in to comment.

Accepted Answer

Peng Li
Peng Li on 26 Mar 2020
a simple structure:
outDir = yourDestination.
allCsvFiles = dir(fullfile(yourDirectory, '.*csv'));
for iA = 1:length(allCsvFiles)
curFile = allCsvFiles(iA).name;
yourTable = readtable(fullfile(yourDirectory, curFile));
% your process
writetable(fullfile(outDir, curFile), yourTable);
end
  6 Comments
Peng Li
Peng Li on 26 Mar 2020
Edited: Peng Li on 26 Mar 2020
In the dir call, replace .*csv with *.csv.
Sorry it was my mistake that I had this typo in my example lol

Sign in to comment.

More Answers (0)

Categories

Find more on Large Files and Big Data in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by