how to read multiple excel files, apply hampel filter and save them into folder with same names as input files
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Hi everyone
I have 20 excel files in a folder, I want to read those files, apply hampel filter and save them into a folder with same names.
files=dir('E:\EEG_RECORDING\Male_Data\*.csv');
files=files(~[files.isdir]);
n=length(files);
for i=1:n
data=xlsread(fullfile(files(i).folder, files(i).name));
a=hampel(data,y)
end
I am not getting how to apply filter and save the files. Here is attachement of error.
3 comentarios
Bob Thompson
el 17 de Jul. de 2019
Making a file name within a loop is usually accomplished by concatonating a string. I will provide an example, but you will have to change it to come up with your specific desired output.
y = [files(i).folder,'\output_',num2str(i),'.csv'];
Respuestas (1)
Mario Chiappelli
el 18 de Jul. de 2019
This task would be a lot easier to accomplish in Visual Basic (VBA).
0 comentarios
Ver también
Categorías
Más información sobre Data Import from MATLAB 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!