So I have been trying to import 167 .csv files from a directory. These files should be plotted together (j vs w) and I would like to concatenate all the j (dims 2204×1) values as a matrix. The first column should be w (dims 2204×1), which is constant for all the files and the rest should be the 167 'j' values. So far I've been successful at reading all these files, but I cannot build a matrix (I also can't plot these). I chose the row values "15:end" because there is no data prior to this.
I've been combing through the forums and I can't seem to find the right code to do this. I've tried using brackets and curly brackets.
Any help would be appreciated!
a=dir('*.csv'); for i=1:length(cell(size(a))) bob = sprintf('_ (%i).csv',i) [~,~,idx{i}]=xlsread(bob); w=table(idx(:,1)); j=table(idx(:,2)); w=w{15:end,'Var1'}; j=j{15:end,'Var1'}; end
Best Answer