Borrar filtros
Borrar filtros

how can i write loop for 32 files which are in .csv formated?

1 visualización (últimos 30 días)
Reddy gireesh
Reddy gireesh el 7 de Jun. de 2016
Comentada: KSSV el 1 de Jun. de 2018
I have .csv file for one month named like tc010316.csv,tc020316.csv,........,tc310316.csv,data_log.csv (tcddmmyy.csv formatted). each file represents one day data arranged in number of columns (53) and rows (288 roughly). Data formatted like columns respectively., Date(2-Mar-16),time(0:00),Data(573 ng).......... Date column same for hole data time is five minute average. i want to find out one day average for all columns separately and for month as well., provide me code to get out of this issue. i have tried lot of codes but loop is not continuing.

Respuestas (1)

KSSV
KSSV el 7 de Jun. de 2016
Editada: KSSV el 1 de Jun. de 2018
csvfiles = dir('*.csv'); % You are in the folder of csv files
Nfiles = length(csvfiles) ; % total number of csv files
% loop for each file
for i = 1:Nfiles
fname = csvfiles(i).name ; % file name
[num,txt,raw] = xlsread(fname) ; % read the data from csv file
%%do what you want %%%
end
  7 comentarios
Khushi Bhatti
Khushi Bhatti el 1 de Jun. de 2018
KSSV... this code didn't work for me :( .its not reading all the files
KSSV
KSSV el 1 de Jun. de 2018
Use xlsread instead of csvread. Code edited. Check now.

Iniciar sesión para comentar.

Categorías

Más información sobre Text Data Preparation en Help Center y File Exchange.

Etiquetas

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by