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

3 次查看(过去 30 天)
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.

采纳的回答

KSSV
KSSV 2018-5-16
编辑:KSSV 2018-5-16
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
  5 个评论

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Large Files and Big Data 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by