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

9 vues (au cours des 30 derniers jours)
Kong
Kong le 26 Mar 2020
Modifié(e) : Peng Li le 26 Mar 2020
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 commentaires
Akira Agata
Akira Agata le 26 Mar 2020
Modifié(e) : Akira Agata le 26 Mar 2020
You mean, you have many CSV files in one folder and want to save in another folder with the same file name after applying some processing?
Kong
Kong le 26 Mar 2020
YES! I want to do it.

Connectez-vous pour commenter.

Réponse acceptée

Peng Li
Peng Li le 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 commentaires
Kong
Kong le 26 Mar 2020
Modifié(e) : Kong le 26 Mar 2020
I am sorry to bother you.
I changed outDir. When I tried to read each CSV file, what is Table?
yourTable is empty.
Peng Li
Peng Li le 26 Mar 2020
Modifié(e) : Peng Li le 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

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Cell Arrays dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by