multiple .csv file importing (different row numbers of each file) from a folder

Hi,

I have 100+ .csv files in a folder. Each .csv file has 18 columns and various row numbers. I want to import data from all .csv files from that folder to create a 3-d matrix where the third dimension will be the number of .csv files. Can someone please help me in this regard?

Also, some .csv file has few blank cells. I want to delete those rows and shift bottom rows up while processing those .csv files to create 3-d matrix.

Answer 1

[KSSV]

files = dir('*.csv') ;     % You are in the folder of csv files 
N = length(files) ;        % total number of files 
iwant = cell(N,1) ;        % cell because csv files have different rows 
% loop for each file 
for i = 1:N 
    iwant{i} = csvread(files(i).name) ;
end

[Mudasser Seraj]

Thank you so much.

[Mudasser Seraj]

I also want to delete rows with blank cells and shift bottom rows up. How to do that?

[KSSV]

Attach one CSV file..

[Mudasser Seraj]

I have attached one .csv file

[Mudasser Seraj]

@KSSV have you figured out a way to do that?