MATLAB: How to combine multiple .dat files.

.datcombine filesdata processingexport filesimport files

I have 5 files (.dat) that are 2×20 (row,col) I want to import them and combine them in one file, the new file should (10×20)

Best Answer

Just call csvread or dlmread 5 times, then concatenate, then call csvwrite

m1 = csvread(filename1);
m2 = csvread(filename2);
m3 = csvread(filename3);
m4 = csvread(filename4);
m5 = csvread(filename5);
mOut = [m1;m2;m3;m4;m5];
csvwrite(fileNameOut, mOut);

Related Solutions

MATLAB: Import txt file containing some comment character = “#”

Mention:

    ....'CommentStyle','#')
fileID = fopen(filename);   %an example 
C = textscan(fileID,formatspec','Delimiter',',','CommentStyle','#');
fclose(fileID);

MATLAB: How to extract a subset of person identified data from several excel files into one excel file

Well, there's a lot of code that will read a spreadsheet, but there's probably nothing that you can just blindly throw at the particular problem.

But, it's not hard problem to solve if the spreadsheets are reasonably regular in their format.

Just read each file into a an array and select the rows desired--if it is truly random selection, then something like

d=dir('AppropriateWildCardString.xls*');   % get the dir() list of files
for i=1:length(d)
  [~,~,raw]=xlsread(d(i).name);            % read raw data from the sheet
  if i==1                                  % generate a random subset indexing vector
    ix=randperm(size(raw,1),1000);
    data=raw(ix,:);                        % and save the selected subset
  else
    data=[data raw(ix,2:end)];             % and append to previous
  end
end

At that point you'll have cell array of the desired data; I'd recommend converting to table and storing the data in appropriate variable types (double, string, categorical, ...) based on its characteristics.

Best Answer

Related Solutions

MATLAB: Import txt file containing some comment character = “#”

MATLAB: How to extract a subset of person identified data from several excel files into one excel file

Related Question