How to create a matrix from csv files?

Hi,

I have a text matrix with my file names called log_files

log_files = ['file1.csv';'file2.csv';'file3.csv';'file1.csv';'file1.csv';'file4.csv']

I also have a matrix with the data of each csv files, called datafiles

datafiles = [1 1 1;2 2 2;3 3 3;4 4 4]

Where [1 1 1] is the data in file1.csv, [2 2 2] is the data in file2.csv, [3 3 3] is the data in file3.csv and [4 4 4] is the data in file4.csv

What I want, is a matrix called log_data that would look like this (according to log_files)

log_data= [1 1 1;2 2 2;3 3 3;1 1 1;1 1 1;4 4 4]

Thank you for the help you will provide.

[Rik]

Do you really have a char array? Or is it actually a cell array with the file names?

You can use a loop to read each file and store them in a matrix. What have you tried so far?

Answer 1

[Walter Roberson]

filenames = {'file1.csv', 'file2.csv', 'file3.csv', 'file4.csv'};
log_files = {'file1.csv';'file2.csv';'file3.csv';'file1.csv';'file1.csv';'file4.csv'};

[~, idx] = ismember(log_files, filenames);
log_data = datafiles(idx,:);

Answer 2

[Andrei Bobrov]

[~,~,i] = unique(log_files);
log_data = datafiles(i,:);