Read and manipulate multiple .csv files

206 visualizaciones (últimos 30 días)
Jake
Jake el 9 de Mzo. de 2020
Comentada: Ameer Hamza el 13 de Mzo. de 2020
Hi,
I have multiple *.csv files which contains almost similar data. All the csv files have random and dissimilar file-names. Is there a way to load them, read them one by one and work with the data?
To elaborate, my end goal is to read one csv file, change certain data in that file and save it as a .txt file and continue this for all the files. And I have 1000+ csv files with almost nothing in common. I'm okay with the manipulation part but I need some help with loading and reading all csv files from a certain directory, one by one.
Thanks in advance!

Respuesta aceptada

Ameer Hamza
Ameer Hamza el 9 de Mzo. de 2020
You can use dir to read the name of all files with csv extensions.
files = dir('*.csv');
Then iterate over the files struct to read each file.
for i=1:length(files)
data = readmatrix(files(i).name); % or csvread(files(i).name)
% process data
writematrix(processed_data,txt_filename); % save to txt file
end
  3 comentarios
metumetu
metumetu el 12 de Mzo. de 2020
Editada: metumetu el 12 de Mzo. de 2020
@Ameer Hamza Do we need convert txt files to csv? and writematrix doesnt work on 2018a. what can we do alternatively?
Ameer Hamza
Ameer Hamza el 13 de Mzo. de 2020
metumetu, you do not need to conver txt to csv. You can directly read data from txt file.
writematrix will is not available in R2018a. You can use readtable, textscan, dlmread or fscanf to read data from txt file. The exact solution will depend on the formatting of your txt file.

Iniciar sesión para comentar.

Más respuestas (0)

Community Treasure Hunt

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

Start Hunting!

Translated by